WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

DAILY 3206806247 daily 1 30-Aug-16 12:08 11.2.0.4.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
DAILY	3206806247	daily	1	30-Aug-16 12:08	11.2.0.4.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

volteyy3 Linux x86 64-bit 40 20 2 127.91

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
volteyy3	Linux x86 64-bit	40	20	2	127.91

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 149 05-Sep-16 14:00:18 95 1.3

End Snap: 150 05-Sep-16 15:00:30 105 2.1

Elapsed: 60.21 (mins)

DB Time: 1,561.60 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	149	05-Sep-16 14:00:18	95	1.3
End Snap:	150	05-Sep-16 15:00:30	105	2.1
Elapsed:		60.21 (mins)
DB Time:		1,561.60 (mins)

Report Summary

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 25.9 2.5 0.02 0.01

DB CPU(s): 1.7 0.2 0.00 0.00

Redo size (bytes): 131,974.1 12,745.8

Logical read (blocks): 477,977.5 46,162.2

Block changes: 1,143.3 110.4

Physical read (blocks): 184.4 17.8

Physical write (blocks): 2,608.3 251.9

Read IO requests: 21.7 2.1

Write IO requests: 104.2 10.1

Read IO (MB): 1.4 0.1

Write IO (MB): 20.4 2.0

User calls: 1,865.5 180.2

Parses (SQL): 1,130.6 109.2

Hard parses (SQL): 0.1 0.0

SQL Work Area (MB): 0.8 0.1

Logons: 11.6 1.1

Executes (SQL): 1,112.3 107.4

Rollbacks: 0.0 0.0

Transactions: 10.4

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	25.9	2.5	0.02	0.01
DB CPU(s):	1.7	0.2	0.00	0.00
Redo size (bytes):	131,974.1	12,745.8
Logical read (blocks):	477,977.5	46,162.2
Block changes:	1,143.3	110.4
Physical read (blocks):	184.4	17.8
Physical write (blocks):	2,608.3	251.9
Read IO requests:	21.7	2.1
Write IO requests:	104.2	10.1
Read IO (MB):	1.4	0.1
Write IO (MB):	20.4	2.0
User calls:	1,865.5	180.2
Parses (SQL):	1,130.6	109.2
Hard parses (SQL):	0.1	0.0
SQL Work Area (MB):	0.8	0.1
Logons:	11.6	1.1
Executes (SQL):	1,112.3	107.4
Rollbacks:	0.0	0.0
Transactions:	10.4

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

Buffer Hit %: 99.99 In-memory Sort %: 100.00

Library Hit %: 99.97 Soft Parse %: 99.99

Execute to Parse %: -1.65 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 1.83 % Non-Parse CPU: 99.37

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
enq: HW - contention	37,926	58K	1530	61.9	Configuration
buffer busy waits	20,672	21.9K	1059	23.4	Concurrency
DB CPU		5997		6.4
log file sync	76,431	1535.2	20	1.6	Commit
direct path sync	37,377	1528.8	41	1.6	User I/O
db file sequential read	38,734	1115.8	29	1.2	User I/O
db file scattered read	18,843	442.6	23	.5	User I/O
latch: shared pool	2,268	296.6	131	.3	Concurrency
direct path write	317,186	291.4	1	.3	User I/O
read by other session	4,444	280.6	63	.3	User I/O

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
Configuration	41,083	58,156	1416	62.1	16.1
Concurrency	48,520	22,774	469	24.3	6.3
DB CPU		5,997		6.4	1.7
User I/O	749,684	4,237	6	4.5	1.2
System I/O	169,510	1,966	12	2.1	0.5
Commit	76,434	1,535	20	1.6	0.4
Application	5,031	236	47	.3	0.1
Other	96,870	167	2	.2	0.0
Network	4,261,562	65	0	.1	0.0

Host CPU

CPUs Cores Sockets Load Average Begin Load Average End %User %System %WIO %Idle

40 20 2 6.08 7.94 7.0 4.9 4.8 87.9

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
40	20	2	6.08	7.94	7.0	4.9	4.8	87.9

Instance CPU

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)

4.4 36.4 0.0

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
4.4	36.4	0.0

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 232.9 25.5 207.5

Database Requests: 125.9 21.7 104.2

Optimized Requests: 0.0 0.0 0.0

Redo Requests: 36.3 1.1 35.2

Total (MB): 89.8 2.6 87.2

Database (MB): 21.8 1.4 20.4

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB): 1.3 1.1 0.1

Database (blocks): 2,792.7 184.4 2,608.3

Via Buffer Cache (blocks): 196.3 58.6 137.7

Direct (blocks): 2,596.4 125.8 2,470.6

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	232.9	25.5	207.5
Database Requests:	125.9	21.7	104.2
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	36.3	1.1	35.2
Total (MB):	89.8	2.6	87.2
Database (MB):	21.8	1.4	20.4
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	1.3	1.1	0.1
Database (blocks):	2,792.7	184.4	2,608.3
Via Buffer Cache (blocks):	196.3	58.6	137.7
Direct (blocks):	2,596.4	125.8	2,470.6

Memory Statistics

Begin End

Host Mem (MB): 130,975.3 130,975.3

SGA use (MB): 58,624.0 58,624.0

PGA use (MB): 249.7 295.0

% Host Mem used for SGA+PGA: 44.95 44.98

	Begin	End
Host Mem (MB):	130,975.3	130,975.3
SGA use (MB):	58,624.0	58,624.0
PGA use (MB):	249.7	295.0
% Host Mem used for SGA+PGA:	44.95	44.98

Cache Sizes

Begin End

Buffer Cache: 52,096M 52,096M Std Block Size: 8K

Shared Pool Size: 3,683M 3,674M Log Buffer: 122,996K

	Begin	End
Buffer Cache:	52,096M	52,096M	Std Block Size:	8K
Shared Pool Size:	3,683M	3,674M	Log Buffer:	122,996K

Shared Pool Statistics

Begin End

Memory Usage %: 67.02 64.57

% SQL with executions>1: 99.55 99.09

% Memory for SQL w/exec>1: 98.05 96.83

	Begin	End
Memory Usage %:	67.02	64.57
% SQL with executions>1:	99.55	99.09
% Memory for SQL w/exec>1:	98.05	96.83

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
Shared Server Statistics
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Wait Event Histogram Detail (64 msec to 2 sec)
Wait Event Histogram Detail (4 sec to 2 min)
Wait Event Histogram Detail (4 min to 1 hr)
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 93695.7s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	6,914.02	7.38
DB CPU	5,997.03	6.40
parse time elapsed	2,275.22	2.43
hard parse elapsed time	2,154.39	2.30
connection management call elapsed time	153.37	0.16
failed parse elapsed time	148.23	0.16
PL/SQL execution elapsed time	15.92	0.02
hard parse (sharing criteria) elapsed time	3.67	0.00
PL/SQL compilation elapsed time	3.19	0.00
repeated bind elapsed time	0.03	0.00
sequence load elapsed time	0.01	0.00
DB time	93,695.71
background elapsed time	2,741.04
background cpu time	352.94

Back to Wait Events Statistics
Back to Top

Operating System Statistics

*TIME statistic values are diffed. All others display actual values. End Value is displayed if different
ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Statistic	Value	End Value
BUSY_TIME	1,744,814
IDLE_TIME	12,631,575
IOWAIT_TIME	690,907
NICE_TIME	0
SYS_TIME	706,784
USER_TIME	1,010,704
LOAD	6	8
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	1,186,000,896
VM_OUT_BYTES	145,661,952
PHYSICAL_MEMORY_BYTES	137,337,577,472
NUM_CPUS	40
NUM_CPU_CORES	20
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
05-Sep 14:00:18	6.08
05-Sep 15:00:30	7.94	12.14	7.03	4.92	87.86	4.81

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 99.1% of Total DB time 93,695.71 (s)
Total FG Wait Time: 86,813.57 (s) DB CPU time: 5,997.03 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Configuration	41,080	0	58,156	1416	62.07
Concurrency	47,907	0	22,630	472	24.15
DB CPU			5,997		6.40
User I/O	539,694	0	4,027	7	4.30
Commit	76,431	0	1,535	20	1.64
Application	5,031	0	236	47	0.25
Other	39,638	2	149	4	0.16
Network	4,135,780	0	65	0	0.07
System I/O	4,906	0	15	3	0.02

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

s - second, ms - millisecond - 1000th of a second
Only events with Total Wait Time (s) >= .001 are shown
ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
enq: HW - contention	37,926	0	58,041	1530	1.01	61.95
buffer busy waits	20,672	0	21,884	1059	0.55	23.36
log file sync	76,431	0	1,535	20	2.04	1.64
direct path sync	37,377	0	1,529	41	1.00	1.63
db file sequential read	38,734	0	1,116	29	1.04	1.19
db file scattered read	18,843	0	443	23	0.50	0.47
latch: shared pool	2,268	0	297	131	0.06	0.32
direct path write	317,186	0	291	1	8.48	0.31
read by other session	4,444	0	281	63	0.12	0.30
direct path read	12,079	0	224	19	0.32	0.24
enq: TX - row lock contention	2,687	0	220	82	0.07	0.23
latch: cache buffers chains	6,176	0	201	33	0.17	0.21
row cache lock	2,235	0	145	65	0.06	0.15
XDB SGA initialization	24	100	120	5001	0.00	0.13
enq: TX - allocate ITL entry	3,116	2	113	36	0.08	0.12
db file parallel read	629	0	104	165	0.02	0.11
library cache: mutex X	14,291	0	77	5	0.38	0.08
SQL*Net more data from client	291,705	0	63	0	7.80	0.07
Data file init write	32,832	0	36	1	0.88	0.04
reliable message	37,332	0	23	1	1.00	0.02
enq: TM - contention	2,281	0	15	7	0.06	0.02
latch: row cache objects	1,920	0	13	7	0.05	0.01
cursor: pin S wait on X	1	0	13	12516	0.00	0.01
log file sequential read	4,061	0	9	2	0.11	0.01
control file parallel write	96	0	6	67	0.00	0.01
Disk file operations I/O	77,538	0	4	0	2.07	0.00
enq: CR - block range reuse ckpt	79	0	4	50	0.00	0.00
log buffer space	2	100	2	1001	0.00	0.00
latch free	425	0	2	4	0.01	0.00
SQL*Net message to client	3,818,216	0	1	0	102.08	0.00
SQL*Net break/reset to client	63	0	1	13	0.00	0.00
SQL*Net more data to client	25,859	0	1	0	0.69	0.00
cursor: pin S	340	0	0	1	0.01	0.00
undo segment extension	36	78	0	6	0.00	0.00
rdbms ipc reply	32	0	0	3	0.00	0.00
db file single write	32	0	0	3	0.00	0.00
control file sequential read	749	0	0	0	0.02	0.00
latch: enqueue hash chains	467	0	0	0	0.01	0.00
latch: call allocation	201	0	0	0	0.01	0.00
latch: object queue header operation	92	0	0	0	0.00	0.00
buffer deadlock	908	100	0	0	0.02	0.00
latch: redo allocation	65	0	0	0	0.00	0.00
SQL*Net message from client	3,818,192	0	109,963	29	102.08
jobq slave wait	982	100	491	500	0.03

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)
Only events with Total Wait Time (s) >= .001 are shown
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
db file async I/O submit	48,684	0	1,446	30	1.30	52.75
log file parallel write	105,109	0	363	3	2.81	13.26
Data file init write	208,290	0	200	1	5.57	7.31
control file parallel write	2,331	0	132	57	0.06	4.82
latch: shared pool	453	0	127	281	0.01	4.64
os thread startup	31	0	13	429	0.00	0.49
latch free	2,676	0	12	4	0.07	0.44
control file sequential read	8,481	0	9	1	0.23	0.35
Disk file operations I/O	722	0	7	10	0.02	0.25
enq: CF - contention	3	0	4	1281	0.00	0.14
latch: cache buffers chains	26	0	3	122	0.00	0.12
db file sequential read	754	0	1	2	0.02	0.05
rdbms ipc reply	204	0	1	4	0.01	0.03
db file single write	204	0	1	3	0.01	0.03
process diagnostic dump	195	0	0	2	0.01	0.02
latch: row cache objects	47	0	0	7	0.00	0.01
latch: call allocation	1,450	0	0	0	0.04	0.01
asynch descriptor resize	41,975	100	0	0	1.12	0.01
ADR block file read	67	0	0	4	0.00	0.01
LGWR wait for redo copy	10,421	0	0	0	0.28	0.01
buffer busy waits	52	0	0	3	0.00	0.01
ADR block file write	37	0	0	3	0.00	0.00
SQL*Net message to client	125,784	0	0	0	3.36	0.00
undo segment extension	3	67	0	7	0.00	0.00
reliable message	35	0	0	1	0.00	0.00
ADR file lock	30	13	0	0	0.00	0.00
log file sync	3	0	0	3	0.00	0.00
latch: cache buffers lru chain	112	0	0	0	0.00	0.00
direct path sync	3	0	0	1	0.00	0.00
direct path write	16	0	0	0	0.00	0.00
rdbms ipc message	160,779	14	57,600	358	4.30
Space Manager: slave idle wait	13,294	40	35,400	2663	0.36
DIAG idle wait	7,208	100	7,215	1001	0.19
dispatcher timer	61	100	3,661	60010	0.00
Streams AQ: qmn slave idle wait	129	0	3,613	28009	0.00
Streams AQ: qmn coordinator idle wait	258	50	3,613	14004	0.01
pmon timer	1,213	99	3,613	2978	0.03
shared server idle wait	120	100	3,601	30009	0.00
smon timer	606	0	3,586	5917	0.02
SQL*Net message from client	167,727	0	57	0	4.48
class slave wait	19	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
% of Waits: value of .0 indicates value was <.05%; value of null is truly 0
% of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
Ordered by Event (idle events last)

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	67	70.1		4.5	6.0	11.9	4.5	3.0
ADR block file write	37	91.9			2.7			5.4
ADR file lock	30	93.3		3.3		3.3
Data file init write	240.8K	94.6	5.1	.1	.1	.0	.0	.1	.0
Disk file operations I/O	78.2K	99.7	.0	.1	.1	.0	.0	.1	.0
LGWR wait for redo copy	10.4K	100.0	.0
SQL*Net break/reset to client	63	49.2	1.6	19.0	12.7	7.9	6.3	3.2
SQL*Net message to client	3942.9K	100.0
SQL*Net more data from client	291.7K	99.9	.1	.0	.0
SQL*Net more data to client	25.9K	100.0	.0	.0	.0
XDB SGA initialization	24								100.0
asynch descriptor resize	42K	100.0
buffer busy waits	20.7K	72.4	3.2	1.4	.8	.6	1.4	10.4	9.7
buffer deadlock	908	100.0
control file parallel write	2427	84.6	1.7	1.4	1.9	.5	.7	7.4	1.7
control file sequential read	9215	99.7	.0	.0	.0	.1	.0	.1	.0
cursor: mutex S	3	100.0
cursor: mutex X	1	100.0
cursor: pin S	339	91.7				6.5	.9	.9
cursor: pin S wait on X	1								100.0
db file async I/O submit	48.7K	15.5	4.2	8.7	14.9	33.4	18.5	4.3	.6
db file parallel read	629			.6	.6	1.0	5.2	90.9	1.6
db file scattered read	18.9K	22.4	.8	5.7	12.4	17.0	32.6	9.0	.2
db file sequential read	39.5K	29.9	7.7	5.4	7.9	12.7	21.5	14.5	.4
db file single write	236	23.3	10.2	55.5	8.9	.8	.4	.8
direct path read	12.1K	48.1	2.5	3.7	5.0	10.2	9.8	20.8
direct path sync	37.4K	.0	.1	.6	10.4	46.6	28.7	12.9	.7
direct path write	317.2K	94.1	1.1	2.0	1.8	.7	.2	.2	.0
enq: CF - contention	3							33.3	66.7
enq: CR - block range reuse ckpt	79	3.8	1.3	15.2	24.1	12.7	15.2	27.8
enq: HW - contention	37.9K	.2	.5	1.6	1.9	3.3	4.4	26.9	61.2
enq: TM - contention	2280	83.6	1.9	1.1	2.5	4.2	3.4	3.2	.0
enq: TX - allocate ITL entry	3113	86.4	2.2	.0	.4	.5	1.1	9.3
enq: TX - row lock contention	2685	83.1	7.8	.9		.2	1.0	5.2	1.8
latch free	3101	60.7	.7	.2	33.6	3.0	1.0	.7
latch: active service list	9	100.0
latch: cache buffers chains	6200	80.3	1.9	1.6	3.0	4.4	3.7	4.3	.8
latch: cache buffers lru chain	124	100.0
latch: call allocation	1651	97.3	1.6	.4	.4	.3
latch: checkpoint queue latch	6	100.0
latch: enqueue hash chains	467	100.0
latch: messages	1	100.0
latch: object queue header operation	100	100.0
latch: redo allocation	72	100.0
latch: row cache objects	1962	86.7	.8	1.7	2.9	3.7	3.1	1.0	.2
latch: shared pool	2720	21.4	3.6	5.1	13.7	17.9	15.4	19.8	3.2
library cache: mutex X	14.3K	95.0	.0	.0		3.4	.5	.9	.2
log buffer space	2							100.0
log file parallel write	105.1K	88.9	1.2	1.7	3.8	2.0	1.4	1.0	.1
log file sequential read	4061	83.6	10.1	1.1	1.2	1.6	1.5	.9
log file sync	76.4K	76.7	2.1	3.4	6.5	4.1	2.9	3.7	.5
os thread startup	31					38.7	16.1	32.3	12.9
process diagnostic dump	195	46.7		49.2	2.6	1.5
rdbms ipc reply	236	72.0	5.5	4.7	5.9	8.9	1.7	1.3
read by other session	4444	1.1	.0	.8	1.6	9.6	27.7	59.0	.2
reliable message	37.4K	99.8	.0	.0	.0	.0	.0	.1	.0
row cache lock	2236	5.3	4.7	9.7	13.6	25.0	31.3	9.6	.8
undo segment extension	39	61.5				15.4	23.1
DIAG idle wait	7212							100.0
SQL*Net message from client	3985.3K	91.1	1.8	2.7	.7	1.4	.6	1.1	.5
Space Manager: slave idle wait	13.2K	3.1	.4	.9	1.1	2.0	3.0	27.2	62.2
Streams AQ: qmn coordinator idle wait	258	50.0							50.0
Streams AQ: qmn slave idle wait	129								100.0
class slave wait	19	100.0
dispatcher timer	61								100.0
jobq slave wait	977							100.0
pmon timer	1212	.2				.1	.1	.4	99.2
rdbms ipc message	160.8K	18.6	5.6	3.8	6.3	10.2	12.8	34.4	8.2
shared server idle wait	120								100.0
smon timer	606	5.4	1.0	2.1	2.1	3.5	5.1	38.8	41.9

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
ADR block file read	2	97.0	1.5	1.5
ADR block file write	2	94.6	5.4
Data file init write	161	99.9	.0	.0	.0	.0	.0	.0	.0
Disk file operations I/O	47	99.9	.0	.0	.0	.0		.0
SQL*Net break/reset to client	2	96.8	1.6				1.6
buffer busy waits	2758	79.8	1.7	1.9	2.3	2.5	2.2	2.9	6.8
control file parallel write	213	90.9	.6	1.3	1.8	1.9	1.7	1.4	.4
control file sequential read	8	99.9	.0	.0			.0	.0	.0
cursor: pin S	3	99.1	.9
db file async I/O submit	2268	95.1	2.3	.7	.3	.5	.4	.4	.2
db file parallel read	579	7.5	14.6	37.0	30.4	6.8	2.1	1.1	.5
db file scattered read	1734	90.8	5.3	2.0	.8	.5	.3	.2	.0
db file sequential read	5873	85.1	9.2	3.0	1.2	.7	.5	.4	.1
db file single write	2	99.2		.8
direct path read	2507	79.2	13.9	5.3	1.3	.3	.0
direct path sync	4969	86.3	7.9	2.9	1.4	.5	.4	.4	.4
direct path write	630	99.8	.1	.0	.0	.0	.0	.0
enq: CF - contention	3				33.3			66.7
enq: CR - block range reuse ckpt	22	72.2	17.7	3.8	2.5		3.8
enq: HW - contention	19.5K	11.9	4.7	4.1	4.2	5.3	8.6	24.7	36.5
enq: TM - contention	74	96.7	1.2	.8	.7	.5			.0
enq: TX - allocate ITL entry	289	90.7	2.0	1.8	1.6	1.1	2.9
enq: TX - row lock contention	156	93.0	.8	.3	1.8	1.5	.9	.6	1.2
latch free	22	99.3	.3	.3	.1		.0
latch: cache buffers chains	299	94.8	1.8	.6	.5	.4	1.0	.5	.3
latch: row cache objects	19	98.9	.7	.2		.1			.2
latch: shared pool	558	77.1	11.5	4.4	1.3	1.0	1.5	.7	2.4
library cache: mutex X	149	98.9	.5	.2	.0	.0	.1	.1	.1
log buffer space	2						100.0
log file parallel write	1055	99.0	.5	.2	.1	.1	.1	.0	.0
log file sequential read	36	99.1	.5	.3	.0	.0
log file sync	3056	95.8	1.4	.8	.6	.5	.4	.3	.2
os thread startup	12	54.8		19.4	6.5	3.2	3.2	6.5	6.5
rdbms ipc reply	3	98.7	.8			.4
read by other session	2628	40.8	22.5	30.3	5.4	.6	.2	.2	.0
reliable message	56	99.8	.0	.1	.0	.0	.0	.0	.0
row cache lock	221	89.5	7.1	.8	.5	.5	.8	.3	.6

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s	< 1m	< 2m	>=2m
		% of Total Waits
Data file init write	3	100.0	.0
XDB SGA initialization	24			100.0
buffer busy waits	1413	93.2	2.9	1.2	1.4	.4	.6	.3	.0
control file parallel write	9	99.6	.3	.0
control file sequential read	1	100.0	.0
cursor: pin S wait on X	1				100.0
db file async I/O submit	119	99.8	.2	.0
db file parallel read	3	99.5	.5
db file scattered read	3	100.0	.0
db file sequential read	26	99.9	.1
direct path sync	133	99.6	.3	.0
enq: HW - contention	13.9K	63.5	36.2	.3	.0
enq: TM - contention	1	100.0	.0
enq: TX - row lock contention	31	98.8	.7	.2	.3
latch: cache buffers chains	21	99.7	.3
latch: row cache objects	3	99.8	.2
latch: shared pool	66	97.6	1.3	1.2
library cache: mutex X	11	99.9	.1
log file parallel write	17	100.0	.0	.0
log file sync	164	99.8	.2	.0
os thread startup	2	93.5	3.2	3.2
read by other session	2	100.0	.0
reliable message	1	100.0	.0
row cache lock	13	99.4	.0	.5

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes) h is 4096*1024 milliseconds (approximately 70 minutes or 1.17 hours)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 4m to 1h	<2m	<4m	<8m	<1/4h	<1/2h	< 1h	>=1h
		% of Total Waits
buffer busy waits	2	100.0	.0

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
daily	93,631	5,995	665	1,726,240
SYS$USERS	1	0	0	2
SYS$BACKGROUND	0	0	0	28
dailyXDB	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in seconds

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
daily	539770	4026	47832	22621	4136932	65
SYS$USERS	2	0	2	0	0	0
SYS$BACKGROUND	209993	210	171	25	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
%Total - Elapsed Time as a percentage of Total DB time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 5.5% of Total DB Time (s): 93,696
Captured PL/SQL account for 0.3% of Total DB Time (s): 93,696

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
2,330.46	37,349	0.06	2.49	1.02	0.00	g7mt7ptq286u7		insert into seg$ (file#, block...
209.60	2	104.80	0.22	0.10	64.39	6ymsy1ky1smgd		SELECT /* OPT_DYN_SAMP / /+ ...
192.03	37,351	0.01	0.20	3.05	0.00	7zx0nu1u7qccz		delete from seg$ where ts#=:1 ...
189.77	43,560	0.00	0.20	5.82	0.00	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
186.10	2	93.05	0.20	10.05	1.73	gb91juyr13n3g	PL/SQL Developer	declare ddl clob; part clob; p...
181.42	2	90.71	0.19	0.29	18.56	3tz4bpp8r26gb	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", TO_DATE(' 20...
181.32	2	90.66	0.19	0.13	66.34	262mnhuk9mhxm		SELECT /* OPT_DYN_SAMP / /+ ...
143.17	2	71.58	0.15	0.09	66.48	gkxf550wt2ph2		SELECT /* OPT_DYN_SAMP / /+ ...
117.30	37,348	0.00	0.13	84.52	0.00	cqwfdp2kgp1y6	SQL Loader Direct Path Load	SELECT VALUE FROM SYS.LOADER_S...
112.35	2	56.18	0.12	1.19	63.25	faafr758897qa	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - CPU Time as a percentage of Total DB CPU
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 5.5% of Total CPU Time (s): 5,997
Captured PL/SQL account for 0.9% of Total CPU Time (s): 5,997

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
99.13	37,348	0.00	1.65	117.30	84.52	0.00	cqwfdp2kgp1y6	SQL Loader Direct Path Load	SELECT VALUE FROM SYS.LOADER_S...
67.63	37,346	0.00	1.13	68.30	99.02	0.00	cnumpcz520unc		SELECT COUNT(*) FROM ALL_OBJEC...
35.92	37,348	0.00	0.60	67.98	52.84	0.00	8vwac6wpcqm0z		call SYS.KUPU$UTILITIES.UPDATE...
23.86	37,349	0.00	0.40	2,330.46	1.02	0.00	g7mt7ptq286u7		insert into seg$ (file#, block...
18.70	2	9.35	0.31	186.10	10.05	1.73	gb91juyr13n3g	PL/SQL Developer	declare ddl clob; part clob; p...
14.49	209,772	0.00	0.24	26.11	55.48	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
11.05	43,560	0.00	0.18	189.77	5.82	0.00	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
10.41	208	0.05	0.17	10.49	99.25	0.00	at1ygf4rd7cvj		select file#, block#, blocks f...
9.50	37,351	0.00	0.16	25.31	37.53	0.02	8agwdqgvnpqzh		UPDATE SYS.KU_UTLUSE SET USECN...
8.78	41,892	0.00	0.15	9.08	96.75	0.00	459f3z9u4fb3u		select value$ from props$ wher...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - User I/O Time as a percentage of Total User I/O Wait time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 25.5% of Total User I/O Wait Time (s): 4,237
Captured PL/SQL account for 0.1% of Total User I/O Wait Time (s): 4,237

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
134.96	2	67.48	3.19	209.60	0.10	64.39	6ymsy1ky1smgd		SELECT /* OPT_DYN_SAMP / /+ ...
120.28	2	60.14	2.84	181.32	0.13	66.34	262mnhuk9mhxm		SELECT /* OPT_DYN_SAMP / /+ ...
95.18	2	47.59	2.25	143.17	0.09	66.48	gkxf550wt2ph2		SELECT /* OPT_DYN_SAMP / /+ ...
77.30	2	38.65	1.82	107.11	0.11	72.16	b6w5daa32symf		SELECT /* OPT_DYN_SAMP / /+ ...
71.06	2	35.53	1.68	112.35	1.19	63.25	faafr758897qa	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
62.60	2	31.30	1.48	99.59	0.99	62.86	685ystbpb1d64	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
60.87	2	30.44	1.44	96.44	1.06	63.12	1b38qwsyqd2jk	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
55.21	2	27.61	1.30	86.72	1.25	63.67	11y74f2gr8t1q	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
53.74	2	26.87	1.27	92.60	0.23	58.04	01jc5vdpwxzb7		SELECT /* OPT_DYN_SAMP / /+ ...
52.50	2	26.25	1.24	82.03	1.01	64.00	1r93qrd7n7nb5	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
42.41	2	21.21	1.00	66.59	1.12	63.70	9q2rcmz7m6rfx	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - Buffer Gets as a percentage of Total Buffer Gets
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Buffer Gets: 1,726,695,093
Captured SQL account for 2.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	SQL Id	SQL Module	SQL Text
10,925,606	1,144,332	9.55	0.63	50.85	6.9	dzs3rm0w0bgnv	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
10,924,872	1,144,313	9.55	0.63	56.02	8.3	gp2kv5n5ypa7w	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
2,224,815	208	10,696.23	0.13	10.49	99.3	at1ygf4rd7cvj		select file#, block#, blocks f...
1,341,208	209,772	6.39	0.08	26.11	55.5	cm5vu20fhtnq1		select /*+ connect_by_filterin...
1,266,744	74,597	16.98	0.07	13.29	41.5	26njhkbrccvs4		select count(*) from ts$ where...
856,572	37,349	22.93	0.05	2,330.46	1	g7mt7ptq286u7		insert into seg$ (file#, block...
668,004	37,347	17.89	0.04	7.73	15.4	bjstq78pprd24	SQL Loader Direct Path Load	SELECT DECODE(ELEMENT_SUBSTITU...
382,142	37,346	10.23	0.02	68.30	99	cnumpcz520unc		SELECT COUNT(*) FROM ALL_OBJEC...
382,131	37,347	10.23	0.02	10.22	19.4	4z554v42crjkn	SQL Loader Direct Path Load	SELECT DECODE(NESTED, 'YES', 1...
377,347	41,899	9.01	0.02	11.94	35.7	0k8522rmdzg4k		select privilege# from sysauth...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 666,150
Captured SQL account for 30.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
67,112	2	33,556.00	10.07	34.49	2.80	98.10	fu30kzkgtq99n	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
49,520	2	24,760.00	7.43	36.14	2.28	98.60	0prj2psh47tb4	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
8,220	2	4,110.00	1.23	62.83	1.92	29.17	6ahgxs9xnpcxk	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
8,076	2	4,038.00	1.21	112.35	1.19	63.25	faafr758897qa	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
7,956	2	3,978.00	1.19	77.95	1.53	27.01	d29qnhj79x644	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
7,917	2	3,958.50	1.19	60.73	1.93	30.34	4zn94ms97q1qu	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
6,728	2	3,364.00	1.01	86.72	1.25	63.67	11y74f2gr8t1q	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
6,568	2	3,284.00	0.99	181.42	0.29	18.56	3tz4bpp8r26gb	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", TO_DATE(' 20...
6,224	2	3,112.00	0.93	96.44	1.06	63.12	1b38qwsyqd2jk	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
5,828	2	2,914.00	0.87	99.59	0.99	62.86	685ystbpb1d64	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 78,301
Captured SQL account for 15.0% of Total
Total UnOptimized Read Requests: 78,301
Captured SQL account for 15.0% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
4,268	4,268	2	2,134.00	5.45	gb91juyr13n3g	PL/SQL Developer	declare ddl clob; part clob; p...
923	923	2	461.50	1.18	6ahgxs9xnpcxk	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
912	912	2	456.00	1.16	dxwgtpgw2zvxd		SELECT /* OPT_DYN_SAMP / /+ ...
867	867	2	433.50	1.11	4zn94ms97q1qu	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
850	850	2	425.00	1.09	96wv95ng6n8p8		SELECT /* OPT_DYN_SAMP / /+ ...
837	837	2	418.50	1.07	d29qnhj79x644	oracle@volteyy2 (TNS V1-V3)	SELECT "A1"."CI", SUM(CASE WHE...
758	758	2	379.00	0.97	01jc5vdpwxzb7		SELECT /* OPT_DYN_SAMP / /+ ...
751	751	2	375.50	0.96	dz1ngjhr5aagw		SELECT /* OPT_DYN_SAMP / /+ ...
738	738	2	369.00	0.94	5fv7j6h3r0r5c		SELECT /* OPT_DYN_SAMP / /+ ...
738	738	2	369.00	0.94	6ymsy1ky1smgd		SELECT /* OPT_DYN_SAMP / /+ ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 4,018,069
Captured SQL account for 93.1% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	SQL Id	SQL Module	SQL Text
1,144,332	0	0.00	50.85	6.9	dzs3rm0w0bgnv	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
1,144,313	0	0.00	56.02	8.3	gp2kv5n5ypa7w	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
209,772	1,717,517	8.19	26.11	55.5	cm5vu20fhtnq1		select /*+ connect_by_filterin...
169,289	169,278	1.00	4.11	5	fhzj09a7fnrnb	SQL Loader Direct Path Load	SELECT DBTIMEZONE, LENGTH(DBTI...
74,597	74,589	1.00	13.29	41.5	26njhkbrccvs4		select count(*) from ts$ where...
43,560	43,560	1.00	189.77	5.8	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
41,899	209,778	5.01	11.94	35.7	0k8522rmdzg4k		select privilege# from sysauth...
41,894	41,882	1.00	4.40	98.6	5ur69atw3vfhj		select decode(failover_method,...
41,892	41,895	1.00	9.08	96.8	459f3z9u4fb3u		select value$ from props$ wher...
41,888	41,884	1.00	8.03	93.5	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 4,084,242
Captured SQL account for 91.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
1,144,239	1,144,332	28.02	dzs3rm0w0bgnv	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
1,144,182	1,144,313	28.01	gp2kv5n5ypa7w	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
209,730	209,772	5.14	cm5vu20fhtnq1		select /*+ connect_by_filterin...
169,275	169,289	4.14	fhzj09a7fnrnb	SQL Loader Direct Path Load	SELECT DBTIMEZONE, LENGTH(DBTI...
74,673	74,597	1.83	26njhkbrccvs4		select count(*) from ts$ where...
41,898	41,899	1.03	0k8522rmdzg4k		select privilege# from sysauth...
41,895	41,888	1.03	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
41,893	41,894	1.03	5ur69atw3vfhj		select decode(failover_method,...
41,892	41,892	1.03	459f3z9u4fb3u		select value$ from props$ wher...
37,353	43,560	0.91	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
2,699,654	5	0.07	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
1,202,929	9	0.03	7aw21806wpgzp	plsqldev.exe	select null from all_synonyms ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

01jc5vdpwxzb7 SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."S1SIPFLVOLTE_2016090417" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

0kkhhb2w93cx0 update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3

0prj2psh47tb4 SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090321" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"

0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

11y74f2gr8t1q SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090316" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"

1b38qwsyqd2jk SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090315" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"

1r93qrd7n7nb5 SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090314" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"

262mnhuk9mhxm SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."S1SIPFLVOLTE_2016090415" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB

26njhkbrccvs4 select count(*) from ts$ where (contents$=0 and bitand(flags, 16)=0) and bitmapped=0 and online$=1

3tz4bpp8r26gb SELECT "A1"."CI", TO_DATE(' 2016-09-04 00:00:00', 'syyyy-mm-dd hh24:mi:ss'), SUM(CASE WHEN ("A1"."INVITE_DIR"=1 AND "A1"."MEDIA_TYPE"=1) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=1 AND "A1"."MEDIA_TYPE"=2) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=2 AND "A1"."MEDIA_TYPE"=1) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=2 AND "A1"."MEDIA_TYPE"=2) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=1 AND "A1"."MEDIA_TYPE"=1 AND "A1"."TS_180" IS NOT NULL) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=1 AND "A1"."MEDIA_TYPE"=2 AND "A1"."TS_180" IS NOT NULL) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=2 AND "A1". "MEDIA_TYPE"=1 AND "A1"."TS_180" IS NOT NULL) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=2 AND "A1"."MEDIA_TYPE"=2 AND "A1"."TS_180" IS NOT NULL) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=1 AND "A1"."MEDIA_TYPE"=1 AND "A1"."TS_180" IS NULL AND ("A1"."STATUSCODE_INVITE"=180 OR "A1"."STATUSCODE_INVITE"=403 OR "A1"."STATUSCODE_INVITE"=404 OR "A1"."STATUSCODE_INVITE"=405 OR "A1"."STATUSCODE_INVITE"=413 OR "A1"."STATUSCODE_INVITE"=414 OR "A1"."STATUSCODE_INVITE"=415 OR "A1"."STATUSCODE_INVITE"=416 OR "A1"."STATUSCODE_INVITE"=422 OR "A1"."STATUSCODE_INVITE"=423 OR "A1"."STATUSCODE_INVITE"=480 OR "A1 "."STATUSCODE_INVITE"=486 OR "A1"."STATUSCODE_INVITE"=487 OR "A1"."STATUSCODE_INVITE"=488 OR "A1"."STATUSCODE_INVITE"=600 OR "A1"."STATUSCODE_INVITE"=603 OR "A1"."STATUSCODE_INVITE"=604 OR "A1"."STATUSCODE_INVITE"=606)) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=1 AND "A1"."MEDIA_TYPE"=2 AND "A1"."TS_180" IS NULL AND ("A1"."STATUSCODE_INVITE"=180 OR "A1"."STATUSCODE_INVITE"=403 OR "A1"."STATUSCODE_INVITE"=404 OR "A1"."STATUSCODE_INVITE"=405 OR "A1"."STATUSCODE_INVITE"=413 OR "A1"."STATUSCODE_INVITE"=414 OR "A1"."STATUSCODE_INVITE"=415 OR "A1"."STATUSCODE_INVITE"=416 OR "A1"."STATUSCODE_INVITE"=422 OR " A1"."STATUSCODE_INVITE"=423 OR "A1"."STATUSCODE_INVITE"=480 OR "A1"."STATUSCODE_INVITE"=486 OR "A1"."STATUSCODE_INVITE"=487 OR "A1"."STATUSCODE_INVITE"=488 OR "A1"."STATUSCODE_INVITE"=600 OR "A1"."STATUSCODE_INVITE"=603 OR "A1"."STATUSCODE_INVITE"=604 OR "A1"."STATUSCODE_INVITE"=606)) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=2 AND "A1"."MEDIA_TYPE"=1 AND "A1"."TS_180" IS NULL AND ("A1"."STATUSCODE_INVITE"=180 OR "A1"."STATUSCODE_INVITE"=403 OR "A1"."STATUSCODE_INVITE"=404 OR "A1"."STATUSCODE_INVITE"=405 OR "A1"."STATUSCODE_INVITE"=413 OR "A1"."STATUSCODE_INVITE"=414 OR "A1"."STATUSCODE_INVITE"=415 OR "A1"."STATUSCODE_INVITE"=416 OR "A1"."STATUSCODE_INVITE"=422 OR "A1"."STATUSCODE_INVITE"=423 OR "A1"."STATUSCODE_INVITE"=480 OR "A1"."STATUSCODE_INVITE"=486 OR "A1"."STATUSCODE_INVITE"=487 OR "A1"."STATUSCODE_INVITE"=488 OR "A1"."STATUSCODE_INVITE"=600 OR "A1"."STATUSCODE_INVITE"=603 OR "A1"."STATUSCODE_INVITE"=604 OR "A1"."STATUSCODE_INVITE"=606)) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=2 AND "A1"."MEDIA_TYPE"=2 AND "A1"."TS_180" IS NULL AND ("A1"."STATUSCODE_INVITE"=180 OR "A1"."STATUSCODE_INVITE"=403 OR "A1"."STATUSCODE_INVITE"=404 OR "A1"."STATUSCODE_INVITE"=405 OR "A1"."STATUSCODE_INVITE"=413 O R "A1"."STATUSCODE_INVITE"=414 OR "A1"."STATUSCODE_INVITE"=415 OR "A1"."STATUSCODE_INVITE"=416 OR "A1"."STATUSCODE_INVITE"=422 OR "A1"."STATUSCODE_INVITE"=423 OR "A1"."STATUSCODE_INVITE"=480 OR "A1"."STATUSCODE_INVITE"=486 OR "A1"."STATUSCODE_INVITE"=487 OR "A1"."STATUSCODE_INVITE"=488 OR "A1"."STATUSCODE_INVITE"=600 OR "A1"."STATUSCODE_INVITE"=603 OR "A1"."STATUSCODE_INVITE"=604 OR "A1"."STATUSCODE_INVITE"=606)) THEN 1 ELSE 0 END ) FROM "MWSIPFLVOLTE_2016090400" "A1" WHERE "A1"."INTERFACE"=0 OR "A1"."INTERFACE"=1 GROUP BY "A1"."CI"

459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'

4z554v42crjkn SELECT DECODE(NESTED, 'YES', 1, 0) FROM SYS.ALL_OBJECT_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner

4zn94ms97q1qu SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090309" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"

5fv7j6h3r0r5c SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."S1SIPFLVOLTE_2016090414" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB

5ur69atw3vfhj select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1

685ystbpb1d64 SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090312" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"

6ahgxs9xnpcxk SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090310" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"

6ymsy1ky1smgd SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."S1SIPFLVOLTE_2016090416" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB

7aw21806wpgzp select null from all_synonyms where 1=0

7zx0nu1u7qccz delete from seg$ where ts#=:1 and file#=:2 and block#=:3

8agwdqgvnpqzh UPDATE SYS.KU_UTLUSE SET USECNT = USECNT + 1, ENCRYPTCNT = ENCRYPTCNT + :1, COMPRESSCNT = COMPRESSCNT + :2, LAST_USED = CURRENT_TIMESTAMP WHERE UTLNAME = :3

8vwac6wpcqm0z call SYS.KUPU$UTILITIES.UPDATEFEATURETABLE ('Oracle Utility SQL Loader (Direct Path Load)', 0, 0)

96wv95ng6n8p8 SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."MWSIPFLVOLTE_2016090421" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB

9q2rcmz7m6rfx SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090313" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"

at1ygf4rd7cvj select file#, block#, blocks from seg$ where type# = 3 and ts# = :1

b6w5daa32symf SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."MWSIPFLVOLTE_2016090423" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB

bd502nbh9abbs select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

bjstq78pprd24 SELECT DECODE(ELEMENT_SUBSTITUTABLE, ' Y', 1, 0) FROM SYS.ALL_NESTED_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner

cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

cnumpcz520unc SELECT COUNT(*) FROM ALL_OBJECT_TABLES OT, ALL_XML_TABLES XT WHERE OT.OWNER = XT.OWNER AND OT.TABLE_NAME = XT.TABLE_NAME AND XT.STORAGE_TYPE = 'CLOB' AND OT.OWNER = :OWN AND OT.TABLE_NAME = :TAB

cqwfdp2kgp1y6 SELECT VALUE FROM SYS.LOADER_SKIP_UNUSABLE_INDEXES

d29qnhj79x644 SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090311" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"

dxwgtpgw2zvxd SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."S1SIPFLVOLTE_2016090400" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB

dz1ngjhr5aagw SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."S1SIPFLVOLTE_2016090411" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB

dzs3rm0w0bgnv SELECT 'X' FROM LOADER_COL_FLAGS L WHERE L.TABLE_OWNER = UPPER(:owner) AND L.TABLE_NAME = UPPER(:tname) AND L.COLNAME = UPPER(:cname) AND L.ISVIRTUAL = 'YES'

faafr758897qa SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090318" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"

fhzj09a7fnrnb SELECT DBTIMEZONE, LENGTH(DBTIMEZONE) FROM SYS.DUAL

fu30kzkgtq99n SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090317" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"

g7mt7ptq286u7 insert into seg$ (file#, block#, type#, ts#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, lists, groups, cachehint, hwmincr, spare1, scanhint, bitmapranges) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, DECODE(:17, 0, NULL, :17), :18, :19)

gb91juyr13n3g declare ddl clob; part clob; procedure get_dependent_ddl(deptype in varchar2) is begin part := sys.dbms_metadata.get_dependent_ddl(object_type => deptype, base_object_name => :object_name, base_object_schema => :object_owner); sys.dbms_lob.append(dest_lob => ddl, src_lob => part); exception when others then null; end; begin sys.dbms_lob.createtemporary(ddl, true); sys.dbms_lob.createtemporary(part, true); sys.dbms_metadata.set_transform_param(sys.dbms_metadata.session_transform, 'PRETTY'); sys.dbms_metadata.set_transform_param(sys.dbms_metadata.session_transform, 'SQLTERMINATOR'); ddl := sys.dbms_metadata.get_ddl(object_type => :object_type, schema => :object_owner, name => :object_name); get_dependent_ddl('INDEX'); get_dependent_ddl('CONSTRAINT'); get_dependent_ddl('COMMENT'); get_dependent_ddl('OBJECT_GRANT'); :ddl := ddl; end;

gkxf550wt2ph2 SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."MWSIPFLVOLTE_2016090422" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB

gp2kv5n5ypa7w SELECT 'X' FROM LOADER_COL_FLAGS L WHERE L.TABLE_OWNER = :owner AND L.TABLE_NAME = :tname AND L.COLNAME = :cname AND L.ISVIRTUAL = 'YES'

SQL Id	SQL Text
01jc5vdpwxzb7	SELECT /* OPT_DYN_SAMP / /+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE / NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."S1SIPFLVOLTE_2016090417" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0kkhhb2w93cx0	update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3
0prj2psh47tb4	SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090321" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
11y74f2gr8t1q	SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090316" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"
1b38qwsyqd2jk	SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090315" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"
1r93qrd7n7nb5	SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090314" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"
262mnhuk9mhxm	SELECT /* OPT_DYN_SAMP / /+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE / NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."S1SIPFLVOLTE_2016090415" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB
26njhkbrccvs4	select count(*) from ts$ where (contents$=0 and bitand(flags, 16)=0) and bitmapped=0 and online$=1
3tz4bpp8r26gb	SELECT "A1"."CI", TO_DATE(' 2016-09-04 00:00:00', 'syyyy-mm-dd hh24:mi:ss'), SUM(CASE WHEN ("A1"."INVITE_DIR"=1 AND "A1"."MEDIA_TYPE"=1) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=1 AND "A1"."MEDIA_TYPE"=2) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=2 AND "A1"."MEDIA_TYPE"=1) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=2 AND "A1"."MEDIA_TYPE"=2) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=1 AND "A1"."MEDIA_TYPE"=1 AND "A1"."TS_180" IS NOT NULL) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=1 AND "A1"."MEDIA_TYPE"=2 AND "A1"."TS_180" IS NOT NULL) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=2 AND "A1". "MEDIA_TYPE"=1 AND "A1"."TS_180" IS NOT NULL) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=2 AND "A1"."MEDIA_TYPE"=2 AND "A1"."TS_180" IS NOT NULL) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=1 AND "A1"."MEDIA_TYPE"=1 AND "A1"."TS_180" IS NULL AND ("A1"."STATUSCODE_INVITE"=180 OR "A1"."STATUSCODE_INVITE"=403 OR "A1"."STATUSCODE_INVITE"=404 OR "A1"."STATUSCODE_INVITE"=405 OR "A1"."STATUSCODE_INVITE"=413 OR "A1"."STATUSCODE_INVITE"=414 OR "A1"."STATUSCODE_INVITE"=415 OR "A1"."STATUSCODE_INVITE"=416 OR "A1"."STATUSCODE_INVITE"=422 OR "A1"."STATUSCODE_INVITE"=423 OR "A1"."STATUSCODE_INVITE"=480 OR "A1 "."STATUSCODE_INVITE"=486 OR "A1"."STATUSCODE_INVITE"=487 OR "A1"."STATUSCODE_INVITE"=488 OR "A1"."STATUSCODE_INVITE"=600 OR "A1"."STATUSCODE_INVITE"=603 OR "A1"."STATUSCODE_INVITE"=604 OR "A1"."STATUSCODE_INVITE"=606)) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=1 AND "A1"."MEDIA_TYPE"=2 AND "A1"."TS_180" IS NULL AND ("A1"."STATUSCODE_INVITE"=180 OR "A1"."STATUSCODE_INVITE"=403 OR "A1"."STATUSCODE_INVITE"=404 OR "A1"."STATUSCODE_INVITE"=405 OR "A1"."STATUSCODE_INVITE"=413 OR "A1"."STATUSCODE_INVITE"=414 OR "A1"."STATUSCODE_INVITE"=415 OR "A1"."STATUSCODE_INVITE"=416 OR "A1"."STATUSCODE_INVITE"=422 OR " A1"."STATUSCODE_INVITE"=423 OR "A1"."STATUSCODE_INVITE"=480 OR "A1"."STATUSCODE_INVITE"=486 OR "A1"."STATUSCODE_INVITE"=487 OR "A1"."STATUSCODE_INVITE"=488 OR "A1"."STATUSCODE_INVITE"=600 OR "A1"."STATUSCODE_INVITE"=603 OR "A1"."STATUSCODE_INVITE"=604 OR "A1"."STATUSCODE_INVITE"=606)) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=2 AND "A1"."MEDIA_TYPE"=1 AND "A1"."TS_180" IS NULL AND ("A1"."STATUSCODE_INVITE"=180 OR "A1"."STATUSCODE_INVITE"=403 OR "A1"."STATUSCODE_INVITE"=404 OR "A1"."STATUSCODE_INVITE"=405 OR "A1"."STATUSCODE_INVITE"=413 OR "A1"."STATUSCODE_INVITE"=414 OR "A1"."STATUSCODE_INVITE"=415 OR "A1"."STATUSCODE_INVITE"=416 OR "A1"."STATUSCODE_INVITE"=422 OR "A1"."STATUSCODE_INVITE"=423 OR "A1"."STATUSCODE_INVITE"=480 OR "A1"."STATUSCODE_INVITE"=486 OR "A1"."STATUSCODE_INVITE"=487 OR "A1"."STATUSCODE_INVITE"=488 OR "A1"."STATUSCODE_INVITE"=600 OR "A1"."STATUSCODE_INVITE"=603 OR "A1"."STATUSCODE_INVITE"=604 OR "A1"."STATUSCODE_INVITE"=606)) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."INVITE_DIR"=2 AND "A1"."MEDIA_TYPE"=2 AND "A1"."TS_180" IS NULL AND ("A1"."STATUSCODE_INVITE"=180 OR "A1"."STATUSCODE_INVITE"=403 OR "A1"."STATUSCODE_INVITE"=404 OR "A1"."STATUSCODE_INVITE"=405 OR "A1"."STATUSCODE_INVITE"=413 O R "A1"."STATUSCODE_INVITE"=414 OR "A1"."STATUSCODE_INVITE"=415 OR "A1"."STATUSCODE_INVITE"=416 OR "A1"."STATUSCODE_INVITE"=422 OR "A1"."STATUSCODE_INVITE"=423 OR "A1"."STATUSCODE_INVITE"=480 OR "A1"."STATUSCODE_INVITE"=486 OR "A1"."STATUSCODE_INVITE"=487 OR "A1"."STATUSCODE_INVITE"=488 OR "A1"."STATUSCODE_INVITE"=600 OR "A1"."STATUSCODE_INVITE"=603 OR "A1"."STATUSCODE_INVITE"=604 OR "A1"."STATUSCODE_INVITE"=606)) THEN 1 ELSE 0 END ) FROM "MWSIPFLVOLTE_2016090400" "A1" WHERE "A1"."INTERFACE"=0 OR "A1"."INTERFACE"=1 GROUP BY "A1"."CI"
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4z554v42crjkn	SELECT DECODE(NESTED, 'YES', 1, 0) FROM SYS.ALL_OBJECT_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner
4zn94ms97q1qu	SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090309" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"
5fv7j6h3r0r5c	SELECT /* OPT_DYN_SAMP / /+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE / NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."S1SIPFLVOLTE_2016090414" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
685ystbpb1d64	SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090312" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"
6ahgxs9xnpcxk	SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090310" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"
6ymsy1ky1smgd	SELECT /* OPT_DYN_SAMP / /+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE / NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."S1SIPFLVOLTE_2016090416" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB
7aw21806wpgzp	select null from all_synonyms where 1=0
7zx0nu1u7qccz	delete from seg$ where ts#=:1 and file#=:2 and block#=:3
8agwdqgvnpqzh	UPDATE SYS.KU_UTLUSE SET USECNT = USECNT + 1, ENCRYPTCNT = ENCRYPTCNT + :1, COMPRESSCNT = COMPRESSCNT + :2, LAST_USED = CURRENT_TIMESTAMP WHERE UTLNAME = :3
8vwac6wpcqm0z	call SYS.KUPU$UTILITIES.UPDATEFEATURETABLE ('Oracle Utility SQL Loader (Direct Path Load)', 0, 0)
96wv95ng6n8p8	SELECT /* OPT_DYN_SAMP / /+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE / NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."MWSIPFLVOLTE_2016090421" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB
9q2rcmz7m6rfx	SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090313" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"
at1ygf4rd7cvj	select file#, block#, blocks from seg$ where type# = 3 and ts# = :1
b6w5daa32symf	SELECT /* OPT_DYN_SAMP / /+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE / NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."MWSIPFLVOLTE_2016090423" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB
bd502nbh9abbs	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
bjstq78pprd24	SELECT DECODE(ELEMENT_SUBSTITUTABLE, ' Y', 1, 0) FROM SYS.ALL_NESTED_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cnumpcz520unc	SELECT COUNT(*) FROM ALL_OBJECT_TABLES OT, ALL_XML_TABLES XT WHERE OT.OWNER = XT.OWNER AND OT.TABLE_NAME = XT.TABLE_NAME AND XT.STORAGE_TYPE = 'CLOB' AND OT.OWNER = :OWN AND OT.TABLE_NAME = :TAB
cqwfdp2kgp1y6	SELECT VALUE FROM SYS.LOADER_SKIP_UNUSABLE_INDEXES
d29qnhj79x644	SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090311" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"
dxwgtpgw2zvxd	SELECT /* OPT_DYN_SAMP / /+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE / NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."S1SIPFLVOLTE_2016090400" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB
dz1ngjhr5aagw	SELECT /* OPT_DYN_SAMP / /+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE / NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."S1SIPFLVOLTE_2016090411" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB
dzs3rm0w0bgnv	SELECT 'X' FROM LOADER_COL_FLAGS L WHERE L.TABLE_OWNER = UPPER(:owner) AND L.TABLE_NAME = UPPER(:tname) AND L.COLNAME = UPPER(:cname) AND L.ISVIRTUAL = 'YES'
faafr758897qa	SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090318" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"
fhzj09a7fnrnb	SELECT DBTIMEZONE, LENGTH(DBTIMEZONE) FROM SYS.DUAL
fu30kzkgtq99n	SELECT "A1"."CI", SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=1 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS">=3000) THEN 1 ELSE 0 END ), SUM(CASE WHEN ("A1"."DIR"=2 AND "A1"."CALLER_MOS"<3000) THEN 1 ELSE 0 END ) FROM "S1SIPFLVOLTE_2016090317" "A1" WHERE "A1"."CALLER_MOS">=0 AND "A1"."CALLER_MOS"<=5000 AND 5000>=0 GROUP BY "A1"."CI"
g7mt7ptq286u7	insert into seg$ (file#, block#, type#, ts#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, lists, groups, cachehint, hwmincr, spare1, scanhint, bitmapranges) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, DECODE(:17, 0, NULL, :17), :18, :19)
gb91juyr13n3g	declare ddl clob; part clob; procedure get_dependent_ddl(deptype in varchar2) is begin part := sys.dbms_metadata.get_dependent_ddl(object_type => deptype, base_object_name => :object_name, base_object_schema => :object_owner); sys.dbms_lob.append(dest_lob => ddl, src_lob => part); exception when others then null; end; begin sys.dbms_lob.createtemporary(ddl, true); sys.dbms_lob.createtemporary(part, true); sys.dbms_metadata.set_transform_param(sys.dbms_metadata.session_transform, 'PRETTY'); sys.dbms_metadata.set_transform_param(sys.dbms_metadata.session_transform, 'SQLTERMINATOR'); ddl := sys.dbms_metadata.get_ddl(object_type => :object_type, schema => :object_owner, name => :object_name); get_dependent_ddl('INDEX'); get_dependent_ddl('CONSTRAINT'); get_dependent_ddl('COMMENT'); get_dependent_ddl('OBJECT_GRANT'); :ddl := ddl; end;
gkxf550wt2ph2	SELECT /* OPT_DYN_SAMP / /+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE / NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "DAILY"."MWSIPFLVOLTE_2016090422" SAMPLE BLOCK (:"SYS_B_4" , :"SYS_B_5") SEED (:"SYS_B_6") "P") SAMPLESUB
gp2kv5n5ypa7w	SELECT 'X' FROM LOADER_COL_FLAGS L WHERE L.TABLE_OWNER = :owner AND L.TABLE_NAME = :tname AND L.COLNAME = :cname AND L.ISVIRTUAL = 'YES'

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Key Instance Activity Stats
Other Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Key Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
db block changes	4,130,194	1,143.31	110.42
execute count	4,018,069	1,112.27	107.42
logons cumulative	41,961	11.62	1.12
opened cursors cumulative	3,951,287	1,093.78	105.64
parse count (total)	4,084,242	1,130.59	109.19
parse time elapsed	205,525	56.89	5.49
physical reads	666,150	184.40	17.81
physical writes	9,422,308	2,608.25	251.90
redo size	476,756,888	131,974.12	12,745.81
session cursor cache hits	2,572,619	712.14	68.78
session logical reads	1,726,695,093	477,977.48	46,162.15
user calls	6,739,046	1,865.48	180.16
user commits	37,404	10.35	1.00
user rollbacks	1	0.00	0.00
workarea executions - optimal	173,360	47.99	4.63

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	8	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	24	0.01	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	16	0.00	0.00
Batched IO single block count	8	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	2	0.00	0.00
CCursor + sql area evicted	6	0.00	0.00
CPU used by this session	506,176	140.12	13.53
CPU used when call started	476,272	131.84	12.73
CR blocks created	5,674	1.57	0.15
Cached Commit SCN referenced	1,187,353	328.68	31.74
Commit SCN cached	23,203	6.42	0.62
DBWR checkpoint buffers written	496,482	137.43	13.27
DBWR checkpoints	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	461	0.13	0.01
DBWR undo block writes	14,571	4.03	0.39
HSC Heap Segment Block Changes	156,937	43.44	4.20
Heap Segment Array Inserts	117	0.03	0.00
Heap Segment Array Updates	77,183	21.37	2.06
IMU Flushes	37,849	10.48	1.01
IMU Redo allocation size	84,320	23.34	2.25
IMU commits	37,391	10.35	1.00
IMU contention	482	0.13	0.01
IMU ktichg flush	4	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	57,300,928	15,861.84	1,531.91
IMU- failed to get a private strand	0	0.00	0.00
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	12,079	3.34	0.32
Requests to/from client	3,817,691	1,056.80	102.06
RowCR - row contention	0	0.00	0.00
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	21	0.01	0.00
SQL*Net roundtrips to/from client	3,817,664	1,056.79	102.06
SQL*Net roundtrips to/from dblink	0	0.00	0.00
TBS Extension: bytes extended	217,980,076,032	60,340,455.37	5,827,565.19
TBS Extension: files extended	204	0.06	0.01
TBS Extension: tasks created	35	0.01	0.00
TBS Extension: tasks executed	3	0.00	0.00
active txn count during cleanout	34,177	9.46	0.91
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	22,033	6.10	0.59
branch node splits	0	0.00	0.00
buffer is not pinned count	19,475,798	5,391.22	520.67
buffer is pinned count	2,346,436	649.53	62.73
bytes received via SQL*Net from client	64,583,678,700	17,877,820.09	1,726,605.50
bytes received via SQL*Net from dblink	0	0.00	0.00
bytes sent via SQL*Net to client	1,845,377,751	510,830.79	49,335.06
bytes sent via SQL*Net to dblink	0	0.00	0.00
calls to get snapshot scn: kcmgss	4,188,975	1,159.58	111.99
calls to kcmgas	461,923	127.87	12.35
calls to kcmgcs	1,401,975	388.09	37.48
cell physical IO interconnect bytes	339,993,252,352	94,115,701.04	9,089,513.50
change write time	2,365	0.65	0.06
cleanout - number of ktugct calls	58,474	16.19	1.56
cleanouts and rollbacks - consistent read gets	4,517	1.25	0.12
cleanouts only - consistent read gets	23,572	6.53	0.63
cluster key scan block gets	3,871,997	1,071.83	103.52
cluster key scans	2,485,482	688.02	66.45
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	6,966	1.93	0.19
commit batch/immediate requested	6,966	1.93	0.19
commit cleanout failures: block lost	4	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	39	0.01	0.00
commit cleanout failures: cannot pin	4,082	1.13	0.11
commit cleanouts	305,217	84.49	8.16
commit cleanouts successfully completed	301,092	83.35	8.05
commit immediate performed	6,966	1.93	0.19
commit immediate requested	6,966	1.93	0.19
commit txn count during cleanout	27,544	7.62	0.74
consistent changes	10,382	2.87	0.28
consistent gets	35,234,579	9,753.51	941.98
consistent gets - examination	17,235,830	4,771.16	460.79
consistent gets direct	454,446	125.80	12.15
consistent gets from cache	34,780,133	9,627.71	929.83
consistent gets from cache (fastpath)	17,016,449	4,710.43	454.92
cursor authentications	192	0.05	0.01
data blocks consistent reads - undo records applied	8,147	2.26	0.22
db block gets	1,691,460,589	468,224.00	45,220.17
db block gets direct	8,924,947	2,470.57	238.60
db block gets from cache	1,682,535,646	465,753.43	44,981.57
db block gets from cache (fastpath)	1,677,636,967	464,397.39	44,850.61
deferred (CURRENT) block cleanout applications	158,377	43.84	4.23
dirty buffers inspected	2	0.00	0.00
enqueue conversions	151,650	41.98	4.05
enqueue releases	1,169,515	323.74	31.27
enqueue requests	1,210,560	335.10	32.36
enqueue timeouts	41,015	11.35	1.10
enqueue waits	46,089	12.76	1.23
exchange deadlocks	908	0.25	0.02
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
free buffer inspected	589,932	163.30	15.77
free buffer requested	800,283	221.53	21.40
heap block compress	650,570	180.09	17.39
hot buffers moved to head of LRU	324,195	89.74	8.67
immediate (CR) block cleanout applications	28,089	7.78	0.75
immediate (CURRENT) block cleanout applications	48,151	13.33	1.29
index crx upgrade (positioned)	0	0.00	0.00
index fast full scans (full)	6	0.00	0.00
index fetch by key	6,323,696	1,750.50	169.06
index scans kdiixs1	4,742,598	1,312.83	126.79
leaf node 90-10 splits	70	0.02	0.00
leaf node splits	75	0.02	0.00
lob reads	2,817	0.78	0.08
lob writes	45	0.01	0.00
lob writes unaligned	45	0.01	0.00
logical read bytes from cache	14,068,243,521,536	3,894,320,232.13	376,105,962.35
max cf enq hold time	6,460	1.79	0.17
messages received	156,354	43.28	4.18
messages sent	156,354	43.28	4.18
min active SCN optimization applied on CR	16,015	4.43	0.43
no work - consistent read gets	16,331,146	4,520.73	436.60
non-idle wait count	5,534,445	1,532.03	147.96
parse count (describe)	0	0.00	0.00
parse count (failures)	32	0.01	0.00
parse count (hard)	485	0.13	0.01
parse time cpu	3,751	1.04	0.10
physical read IO requests	78,301	21.67	2.09
physical read bytes	5,457,100,800	1,510,614.88	145,892.28
physical read total IO requests	92,078	25.49	2.46
physical read total bytes	9,858,732,544	2,729,058.65	263,567.24
physical read total multi block requests	9,673	2.68	0.26
physical reads cache	211,753	58.62	5.66
physical reads cache prefetch	153,247	42.42	4.10
physical reads direct	454,397	125.78	12.15
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	376,342	104.18	10.06
physical write bytes	77,187,547,136	21,366,777.31	2,063,562.28
physical write total IO requests	749,424	207.45	20.04
physical write total bytes	330,134,519,808	91,386,642.39	8,825,946.26
physical write total multi block requests	528,875	146.40	14.14
physical writes direct	8,924,951	2,470.57	238.60
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	497,357	137.68	13.30
physical writes non checkpoint	9,407,132	2,604.05	251.49
pinned buffers inspected	0	0.00	0.00
pinned cursors current	5	0.00	0.00
prefetch clients - default	6	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	5	0.00	0.00
process last non-idle time	3,613	1.00	0.10
recursive calls	7,316,749	2,025.40	195.61
recursive cpu usage	299,254	82.84	8.00
redo KB read	4,145,718	1,147.60	110.83
redo blocks checksummed by FG (exclusive)	12,717	3.52	0.34
redo blocks written	1,026,563	284.17	27.44
redo buffer allocation retries	0	0.00	0.00
redo entries	3,134,444	867.67	83.80
redo log space requests	0	0.00	0.00
redo ordering marks	1	0.00	0.00
redo size for direct writes	18,007,300	4,984.72	481.41
redo subscn max counts	14,380	3.98	0.38
redo synch long waits	2,071	0.57	0.06
redo synch poll writes	0	0.00	0.00
redo synch polls	0	0.00	0.00
redo synch time	152,444	42.20	4.08
redo synch time (usec)	1,535,750,468	425,120.88	41,057.36
redo synch time overhead (usec)	22,378,190	6,194.65	598.27
redo synch time overhead count (<128 msec)	2	0.00	0.00
redo synch time overhead count (<2 msec)	78,489	21.73	2.10
redo synch time overhead count (<32 msec)	22	0.01	0.00
redo synch time overhead count (<8 msec)	98	0.03	0.00
redo synch time overhead count (>=128 msec)	10	0.00	0.00
redo synch writes	80,982	22.42	2.17
redo wastage	30,812,272	8,529.34	823.75
redo write info find	78,622	21.76	2.10
redo write info find fail	1	0.00	0.00
redo write time	36,395	10.07	0.97
redo writes	105,104	29.09	2.81
rollback changes - undo records applied	301	0.08	0.01
rollbacks only - consistent read gets	1,077	0.30	0.03
root node splits	0	0.00	0.00
rows fetched via callback	2,794,257	773.50	74.70
session connect time	1,031	0.29	0.03
shared hash latch upgrades - no wait	307,371	85.09	8.22
shared hash latch upgrades - wait	1,249	0.35	0.03
sorts (disk)	0	0.00	0.00
sorts (memory)	627,022	173.57	16.76
sorts (rows)	2,760,596	764.18	73.80
sql area evicted	79	0.02	0.00
sql area purged	31	0.01	0.00
summed dirty queue length	2	0.00	0.00
switch current to new buffer	117,748	32.59	3.15
table fetch by rowid	3,959,397	1,096.03	105.85
table fetch continued row	136	0.04	0.00
table scan blocks gotten	4,862,925	1,346.14	130.01
table scan rows gotten	58,869,047	16,295.92	1,573.83
table scans (direct read)	36	0.01	0.00
table scans (long tables)	4	0.00	0.00
table scans (short tables)	198,149	54.85	5.30
total cf enq hold time	55,680	15.41	1.49
total number of cf enq holders	1,097	0.30	0.03
total number of times SMON posted	609	0.17	0.02
transaction rollbacks	765	0.21	0.02
transaction tables consistent read rollbacks	1	0.00	0.00
transaction tables consistent reads - undo records applied	23	0.01	0.00
undo change vector size	104,016,484	28,793.47	2,780.82
user logons cumulative	41,922	11.60	1.12
user logouts cumulative	41,910	11.60	1.12
write clones created in background	4	0.00	0.00
write clones created in foreground	30	0.01	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
logons current	95	105
opened cursors current	124	219
session cursor cache count	297,571,117	298,986,345
session pga memory	1,741,502,288	1,781,824,928
session pga memory max	1,929,610,352	2,005,322,432
session uga memory	480,155,458,528	482,358,298,400
session uga memory max	11,661,558,603,656	11,717,218,942,512
workarea memory allocated	14,330	28,369

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
ordered by (Data Read + Write) desc

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	4.1G	3.48	1.157M	234.1G	67.81	66.354M	257.5K	1.39
Direct Writes	0M	0.00	0M	68.1G	87.81	19.305M	317.2K	0.73
DBWR	18M	0.33	.005M	3.8G	16.38	1.076M	49.9K	28.41
Direct Reads	3.4G	3.33	.973M	0M	0.00	0M	12.1K	18.19
Buffer Cache Reads	1.6G	18.34	.46M	0M	0.00	0M	59.2K	29.45
LGWR	0M	0.00	0M	501M	35.18	.139M	210.2K	3.24
TOTAL:	9.2G	25.48	2.595M	306.5G	207.18	86.874M	906.1K	5.13

Back to IO Stats
Back to Top

IOStat by Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Small Read and Large Read are average service times, in milliseconds
Ordered by (Data Read + Write) desc

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	5.1G	21.81	1.434M	71.9G	104.26	20.382M	23.84	37.47
Log File	4G	1.12	1.121M	501M	35.18	.139M	0.00	1.47
Control File	144M	2.55	.04M	76M	1.34	.021M	1.03
TOTAL:	9.2G	25.48	2.594M	72.5G	140.79	20.541M	21.29	22.35

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Ordered by (Data Read + Write) desc for each function

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	4.1G	3.48	1.157M	234.1G	67.80	66.354M	12.8K	1.26
Others (Data File)	3M	0.13	.001M	234G	66.46	66.333M	716	0.96
Others (Log File)	4G	1.12	1.121M	0M	0.00	0M	4061	1.46
Others (Control File)	126M	2.22	.035M	75M	1.34	.021M	8034	1.18
Direct Writes	0M	0.00	0M	68.1G	87.81	19.306M	0
Direct Writes (Data File)	0M	0.00	0M	68.1G	87.81	19.306M	0
DBWR	18M	0.33	.005M	3.8G	16.38	1.076M	1175	0.00
DBWR (Data File)	0M	0.00	0M	3.8G	16.38	1.076M	0
DBWR (Control File)	18M	0.33	.005M	0M	0.00	0M	1175	0.00
Direct Reads	3.4G	3.33	.973M	0M	0.00	0M	0
Direct Reads (Data File)	3.4G	3.33	.973M	0M	0.00	0M	0
Buffer Cache Reads	1.6G	18.34	.46M	0M	0.00	0M	57.9K	26.53
Buffer Cache Reads (Data File)	1.6G	18.34	.46M	0M	0.00	0M	57.9K	26.53
LGWR	0M	0.00	0M	501M	35.17	.139M	0
LGWR (Log File)	0M	0.00	0M	501M	35.17	.139M	0
TOTAL:	9.2G	25.48	2.595M	306.5G	207.18	86.874M	71.9K	21.59

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
DAILY_20160905	14,457	4	3.21	1.09	366,262	3.98	3	101	22,977	867.34
DAILY_20160904	43,768	12	30.83	3.15	999	8.64	34	0	0	0.00
DAILY_20160903	19,146	5	8.30	26.63	7,140	1.06	4	2	7,171	39.14
UNDOTBS1	0	0	0.00	0.00	1,476	0.00	0	0	818	0.15
SYSAUX	450	0	4.53	3.20	427	0.12	4	0	0	0.00
SYSTEM	446	0	6.57	1.10	163	0.12	7	0	19,442	98.78

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
DAILY_20160903	/data/oradata/daily/002/DAILY_20160903.dbf	19,146	5	8.30	26.63	1	3.80	7,140	2	7,171	39.14
DAILY_20160904	/data/oradata/daily/003/DAILY_20160904.dbf	43,768	12	30.83	3.15	9	33.70	999	0	0	0.00
DAILY_20160905	/data/oradata/daily/004/DAILY_20160905.dbf	14,457	4	3.21	1.09	4	3.21	366,262	101	22,977	867.34
SYSAUX	/opt/oracle/oradata/daily/sysaux01.dbf	450	0	4.53	3.20	0	4.26	427	0	0	0.00
SYSTEM	/opt/oracle/oradata/daily/system01.dbf	446	0	6.57	1.10	0	6.57	163	0	19,442	98.78
UNDOTBS1	/opt/oracle/oradata/daily/undotbs01.dbf	0	0			0		1,476	0	818	0.15

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	6,417,169	100	1,716,196,979	211,727	497,357	0	0	50,435

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 9,422,308

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	496,408	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats
MTTR Advisory
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	42	53031	116884	644661	6794766	644661
E	0	39	47665	101738	499880	6794766	499880

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	5,120	0.10	631	1.17	7,718	1	25777.00
D	10,240	0.20	1,261	1.08	7,117	1	21598.00
D	15,360	0.29	1,892	1.04	6,882	1	19967.00
D	20,480	0.39	2,523	1.02	6,738	1	18968.00
D	25,600	0.49	3,153	1.01	6,663	1	18448.00
D	30,720	0.59	3,784	1.01	6,633	1	18235.00
D	35,840	0.69	4,415	1.00	6,623	1	18166.00
D	40,960	0.79	5,045	1.00	6,614	1	18106.00
D	46,080	0.88	5,676	1.00	6,599	1	17999.00
D	51,200	0.98	6,307	1.00	6,596	1	17978.00
D	52,096	1.00	6,417	1.00	6,595	1	17974.00
D	56,320	1.08	6,937	1.00	6,593	1	17961.00
D	61,440	1.18	7,568	1.00	6,591	1	17947.00
D	66,560	1.28	8,199	1.00	6,589	1	17930.00
D	71,680	1.38	8,830	1.00	6,587	1	17917.00
D	76,800	1.47	9,460	1.00	6,585	1	17902.00
D	81,920	1.57	10,091	1.00	6,582	1	17883.00
D	87,040	1.67	10,722	1.00	6,580	1	17870.00
D	92,160	1.77	11,352	1.00	6,578	1	17855.00
D	97,280	1.87	11,983	1.00	6,576	1	17843.00
D	102,400	1.97	12,614	1.00	6,574	1	17828.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	3,051	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin Snap E: End Snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	19,522	17,473	249.73	12.94	5.18	0.00	100.00	1,048,576
E	19,522	17,397	295.00	27.19	9.22	44.79	55.21	1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	173,027	173,027
64K	128K	40	40
128K	256K	6	6
256K	512K	12	12
512K	1024K	37	37
1M	2M	76	76
2M	4M	40	40
4M	8M	19	19
8M	16M	20	20
16M	32M	66	66
32M	64M	10	10
64M	128M	2	2

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd Time
2,440	0.13	196,568.44	4,388.60	98.00	136,495,960
4,881	0.25	196,568.44	0.00	100.00	133,515,095
9,761	0.50	196,568.44	0.00	100.00	133,515,095
14,642	0.75	196,568.44	0.00	100.00	133,515,095
19,522	1.00	196,568.44	0.00	100.00	133,515,095
23,426	1.20	196,568.44	0.00	100.00	133,515,095
27,331	1.40	196,568.44	0.00	100.00	133,515,095
31,235	1.60	196,568.44	0.00	100.00	133,515,095
35,140	1.80	196,568.44	0.00	100.00	133,515,095
39,044	2.00	196,568.44	0.00	100.00	133,515,095
58,566	3.00	196,568.44	0.00	100.00	133,515,095
78,088	4.00	196,568.44	0.00	100.00	133,515,095
117,132	6.00	196,568.44	0.00	100.00	133,515,095
156,176	8.00	196,568.44	0.00	100.00	133,515,095

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
3,200	0.76	201	47,594	5,522,249	0.67	2,722,010	55.35	446,408
3,328	0.79	329	64,233	7,330,788	0.89	913,471	18.58	593,802
3,456	0.82	457	80,886	8,194,908	1.00	49,351	1.00	662,471
3,584	0.85	585	99,438	8,194,949	1.00	49,310	1.00	662,475
3,712	0.88	713	116,208	8,195,009	1.00	49,250	1.00	662,480
3,840	0.91	841	134,693	8,195,042	1.00	49,217	1.00	662,484
3,968	0.94	969	154,040	8,195,047	1.00	49,212	1.00	662,488
4,096	0.97	1,097	171,473	8,195,068	1.00	49,191	1.00	662,492
4,224	1.00	1,224	188,368	8,195,083	1.00	49,176	1.00	662,507
4,352	1.03	1,352	206,045	8,195,084	1.00	49,175	1.00	662,510
4,480	1.06	1,480	222,546	8,195,084	1.00	49,175	1.00	662,514
4,608	1.09	1,608	238,659	8,195,084	1.00	49,175	1.00	662,525
4,736	1.12	1,736	253,911	8,195,084	1.00	49,175	1.00	662,531
4,864	1.15	1,864	268,719	8,195,084	1.00	49,175	1.00	662,531
4,992	1.18	1,991	282,568	8,195,084	1.00	49,175	1.00	662,531
5,120	1.21	2,063	290,466	8,195,084	1.00	49,175	1.00	662,531
5,248	1.24	2,063	290,466	8,195,084	1.00	49,175	1.00	662,531
5,376	1.27	2,063	290,466	8,195,084	1.00	49,175	1.00	662,531
5,760	1.36	2,063	290,466	8,195,084	1.00	49,175	1.00	662,531
6,272	1.48	2,063	290,466	8,195,084	1.00	49,175	1.00	662,531
6,784	1.61	2,063	290,466	8,195,084	1.00	49,175	1.00	662,531
7,296	1.73	2,063	290,466	8,195,084	1.00	49,175	1.00	662,531
7,808	1.85	2,063	290,466	8,195,084	1.00	49,175	1.00	662,531
8,320	1.97	2,063	290,466	8,195,084	1.00	49,175	1.00	662,531
8,832	2.09	2,063	290,466	8,195,084	1.00	49,175	1.00	662,531

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
14,656	0.25	9,598,781	7,108,885
21,984	0.38	9,596,862	6,874,360
29,312	0.50	9,595,902	6,655,645
36,640	0.63	9,594,943	6,625,341
43,968	0.75	9,594,943	6,606,896
51,296	0.88	9,594,943	6,591,085
58,624	1.00	9,594,943	6,587,791
65,952	1.13	9,594,943	6,583,838
73,280	1.25	9,594,946	6,579,886
80,608	1.38	9,594,946	6,577,251
87,936	1.50	9,594,946	6,572,639
95,264	1.63	9,594,948	6,570,663
102,592	1.75	9,594,955	6,566,710
109,920	1.88	9,594,955	6,566,710
117,248	2.00	9,594,958	6,566,710

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
128	0.50	0	0	0	0
256	1.00	0	0	0	0
384	1.50	0	0	0	0
512	2.00	0	0	0	0
640	2.50	0	0	0	0
768	3.00	0	0	0	0
896	3.50	0	0	0	0
1,024	4.00	0	0	0	0
1,152	4.50	0	0	0	0
1,280	5.00	0	0	0	0
1,408	5.50	0	0	0	0
1,536	6.00	0	0	0	0
1,664	6.50	0	0	0	0
1,792	7.00	0	0	0	0
1,920	7.50	0	0	0	0
2,048	8.00	0	0	0	0
2,176	8.50	0	0	0	0
2,304	9.00	0	0	0	0
2,432	9.50	0	0	0	0
2,560	10.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
file header block	22,979	19,931	867
data block	26,610	2,205	83
undo block	421	0	0
undo header	397	0	0
segment header	3	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with 10g data
ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
HW-Segment High Water Mark	81,227	81,256	0	37,929	58,043	1,530.30
TX-Transaction (row lock contention)	2,696	2,696	0	2,687	220	81.75
TX-Transaction (allocate ITL entry)	3,159	3,104	55	3,116	113	36.29
TM-DML	193,886	193,885	0	2,281	15	6.77
CR-Reuse Block Range (block range reuse ckpt)	225,123	225,120	0	79	4	49.49
CF-Controlfile Transaction	3,366	3,365	1	3	4	1,280.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	14.06	306,880	1,461	70	18.2/37.4	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
05-Sep 14:58	2,566	57,734	314	46	18	0/0	0/0/0/0/0/0
05-Sep 14:48	1,134	23,807	1,461	70	37	0/0	0/0/0/0/0/0
05-Sep 14:38	3,030	65,707	859	67	27	0/0	0/0/0/0/0/0
05-Sep 14:28	2,934	65,844	919	42	28	0/0	0/0/0/0/0/0
05-Sep 14:18	2,913	65,570	318	64	18	0/0	0/0/0/0/0/0
05-Sep 14:08	1,478	28,218	920	67	28	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Mutex Sleep Summary
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0	0
ASM db client latch	39,801	0.00		0	0
ASM map operation hash table	1	0.00		0	0
ASM network state latch	68	0.00		0	0
AWR Alerted Metric Element list	27,210	0.00		0	0
Change Notification Hash table latch	38,563	0.00	0.00	0	0
Consistent RBA	105,149	0.00	0.00	0	0
DML lock allocation	387,748	0.00	0.00	0	0
Event Group Locks	83,919	0.00	0.00	0	0
FIB s.o chain latch	494	0.00		0	0
FOB s.o list latch	155,489	0.45	0.00	0	0
File State Object Pool Parent Latch	1	0.00		0	0
I/O Staticstics latch	1	0.00		0	0
IPC stats buffer allocation latch	1	0.00		0	0
In memory undo latch	347,132	0.07	0.00	0	112,910	0.16
JS Sh mem access	7	0.00		0	0
JS mem alloc latch	6	0.00		0	0
JS queue access latch	7	0.00		0	0
JS queue state obj latch	26,170	0.00		0	0
JS slv state obj latch	21	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	1	0.00		0	0
KJCT flow control latch	1	0.00		0	0
KMG MMAN ready and startup request latch	1,204	0.00		0	0
KTF sga latch	24	0.00		0	1,164	0.00
KWQMN job cache list latch	1	0.00		0	0
KWQP Prop Status	2	0.00		0	0
KWQS pqueue ctx latch	2	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	1	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	1	0.00		0	1,204	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
MinActiveScn Latch	40	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	167,931	0.00		0	0
OS process allocation	91,193	0.58	0.01	0	0
OS process: request allocation	83,895	0.11	0.01	0	0
PL/SQL warning settings	42,166	0.00	0.00	0	0
PX hash array latch	1	0.00		0	0
QMT	2	0.00		0	0
Real-time plan statistics latch	30,256	0.00		0	0
SGA blob parent	1	0.00		0	0
SGA bucket locks	1	0.00		0	0
SGA heap locks	1	0.00		0	0
SGA pool locks	1	0.00		0	0
SQL memory manager latch	1	0.00		0	1,171	0.00
SQL memory manager workarea list latch	527,596	0.00	0.00	0	0
Shared B-Tree	135	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	1	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB NFS Stateful SGA Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	55,913	1.04	0.00	0	0
active service list	260,014	0.24	0.01	0	1,830	0.00
begin backup scn array	317,155	0.00	0.00	0	0
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	1,228	0.08	0.00	0	0
cache buffers chains	3,426,114,713	0.00	0.12	205	1,582,691	0.02
cache buffers lru chain	775,248	0.09	0.18	0	1,975,336	0.92
cache table scan latch	18,852	0.00		0	18,855	0.00
call allocation	255,479	1.06	0.70	0	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	158,616	0.16	0.00	0	0
channel operations parent latch	555,763	0.09	0.01	0	0
checkpoint queue latch	2,887,269	0.09	0.00	0	492,560	0.04
client/application info	330,900	0.00	0.00	0	0
compile environment latch	41,963	0.00		0	0
corrupted undo seg latch	1,668	0.96	0.00	0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	68	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	68	0.00		0	0
dml lock allocation	74,789	0.01	0.00	0	0
done queue latch	1	0.00		0	0
dummy allocation	83,912	0.15	0.01	0	0
eighth spare latch - X parent	1	0.00		0	0
eleventh spare latch - children	1	0.00		0	0
enqueue freelist latch	1	0.00		0	1,261,964	0.02
enqueue hash chains	2,589,037	0.38	0.05	0	20,640	0.17
enqueues	2	0.00		0	0
fifteenth spare latch - children	1	0.00		0	0
file cache latch	44,223	0.01	0.00	0	0
first Audit Vault latch	41,924	0.25	0.01	0	0
flashback copy	1	0.00		0	0
fourteenth spare latch - children	1	0.00		0	0
fourth Audit Vault latch	1	0.00		0	0
gc element	1	0.00		0	0
gcs commit scn state	1	0.00		0	0
gcs partitioned table hash	1	0.00		0	0
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs resource freelist	1	0.00		0	0
gcs resource hash	1	0.00		0	0
gcs resource scan list	1	0.00		0	0
gcs resource validate list	1	0.00		0	0
gcs shadows freelist	1	0.00		0	0
ges domain table	1	0.00		0	0
ges enqueue table freelist	1	0.00		0	0
ges group table	1	0.00		0	0
ges process hash list	1	0.00		0	0
ges process parent latch	1	0.00		0	0
ges resource hash list	1	0.00		0	0
ges resource scan list	1	0.00		0	0
ges resource table freelist	1	0.00		0	0
ges value block free list	1	0.00		0	0
global KZLD latch for mem in SGA	41,924	0.01	0.00	0	0
global tx hash mapping	1,809	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	121	0.00		0	107,703	0.00
hash table modification latch	91	0.00		0	0
heartbeat check	1	0.00		0	0
interrupt manipulation	1	0.00		0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	9	0.00		0	8	12.50
job_queue_processes free list latch	20	0.00		0	0
job_queue_processes parameter latch	792	0.00		0	0
k2q lock allocation	1	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kgnfs mount latch	1	0.00		0	0
kokc descriptor allocation latch	160,032	0.00		0	0
ksfv messages	1	0.00		0	0
ksim group membership cache	1	0.00		0	0
kss move lock	39	0.00		0	0
ksuosstats global area	363	0.00		0	0
ksv allocation latch	144	0.00		0	0
ksv class latch	77	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	83,895	0.65	0.00	0	0
ktm global data	2,451	0.00		0	0
kwqbsn:qsga	131	0.00		0	0
lgwr LWN SCN	106,376	0.05	0.00	0	0
list of block allocation	74,815	0.01	0.00	0	0
loader state object freelist	74,797	0.01	0.00	0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	13	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
logical standby cache	1	0.00		0	0
logminer context allocation	2	0.00		0	0
logminer local	1	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	132	0.00		0	133	0.00
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	112,414	0.04	0.00	0	0
messages	588,320	0.35	0.00	0	0
mostly latch-free SCN	108,793	0.96	0.00	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	39,465	0.01	0.00	0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	68	0.00		0	0
nineth spare latch - X parent	1	0.00		0	0
object queue header heap	2,824	0.00		0	3,485	0.00
object queue header operation	2,865,898	0.21	0.02	0	0
object stats modification	664	0.15	0.00	0	1	0.00
parallel query alloc buffer	1,161	0.00		0	0
parallel query stats	1	0.00		0	0
parameter list	380,283	0.05	0.00	0	0
parameter table management	653,850	0.15	0.20	2	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
post/wait queue	133,558	0.49	0.00	0	102,444	0.58
process allocation	83,925	1.72	0.87	10	41,859	0.23
process group creation	83,894	0.79	0.00	0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qm_init_sga	27	0.00		0	0
qmn task queue latch	525	0.00		0	0
qmtmrcsg_init	1	0.00		0	0
query server freelists	1	0.00		0	0
queued dump request	12	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	583,319	2.31	0.01	0	3,117,110	1.71
redo copy	1	0.00		0	3,134,549	0.45
redo writing	395,530	0.08	0.00	0	0
resmgr group change latch	41,937	0.00		0	0
resmgr:active threads	83,912	0.00		0	0
resmgr:actses change group	41,952	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	83,911	0.33	0.00	0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	61	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	12,450,136	0.46	0.04	13	2,267	0.71
rules engine rule set statistics	100	0.00		0	0
second Audit Vault latch	1	0.00		0	0
sequence cache	126,051	0.18	0.00	0	0
session allocation	402,954	0.00	0.00	0	319,104	0.00
session idle bit	13,754,921	0.00	0.00	0	0
session queue latch	1	0.00		0	0
session state list latch	158,695	0.24	0.46	0	0
session switching	42,008	0.32	0.00	0	2	0.00
session timer	1,213	0.00		0	0
seventh spare latch - X parent	1	0.00		0	0
shared pool	4,018,804	0.45	0.18	420	8	0.00
shared pool sim alloc	24	0.00		0	0
shared pool simulator	17,494	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	114,962,019	0.00	0.03	0	0
simulator lru latch	496,594	0.91	0.03	2	114,392,001	0.26
sixth spare latch - X parent	1	0.00		0	0
sort extent pool	755	1.19	0.11	0	0
space background task latch	30,844	10.67	0.43	0	8,593	0.20
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
tablespace key chain	1	0.00		0	0
temp lob duration state obj allocation	8	0.00		0	0
temporary table state object allocation	8	37.50	0.33	0	0
tenth spare latch - X parent	1	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
thirteenth spare latch - children	1	0.00		0	0
threshold alerts latch	209	0.00		0	0
transaction allocation	267,908	0.01	0.06	0	2	0.00
transaction branch allocation	3,013	0.10	0.00	0	0
twelfth spare latch - children	1	0.00		0	0
twenty-fifth spare latch - S par	1	0.00		0	0
twenty-first spare latch - S par	1	0.00		0	0
twenty-fourth spare latch - S par	1	0.00		0	0
twenty-second spare latch - S par	1	0.00		0	0
twenty-third spare latch - S par	1	0.00		0	0
undo global data	1,370,574	0.04	0.00	0	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0
write info latch	0			0	105,095	0.00

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	3,426,114,713	59,233	6,946	53,232
row cache objects	12,450,136	56,733	2,011	54,868
shared pool	4,018,804	18,090	3,236	15,497
redo allocation	583,319	13,476	73	13,405
enqueue hash chains	2,589,037	9,901	468	9,454
object queue header operation	2,865,898	5,916	125	5,816
simulator lru latch	496,594	4,503	139	4,383
space background task latch	30,844	3,292	1,404	1,910
call allocation	255,479	2,715	1,912	1,085
checkpoint queue latch	2,887,269	2,601	6	2,595
simulator hash latch	114,962,019	2,326	64	2,262
messages	588,320	2,048	1	2,047
process allocation	83,925	1,446	1,256	361
parameter table management	653,850	962	197	781
cache buffers lru chain	775,248	688	127	564
post/wait queue	133,558	652	3	649
active service list	260,014	623	9	614
ksz_so allocation latch	83,895	544	2	542
OS process allocation	91,193	528	4	524
channel operations parent latch	555,763	491	4	487
session state list latch	158,695	381	174	209
resmgr:free threads list	83,911	273	1	272
dummy allocation	83,912	129	1	128
first Audit Vault latch	41,924	103	1	102
OS process: request allocation	83,895	92	1	91
transaction allocation	267,908	17	1	16
sort extent pool	755	9	1	8
temporary table state object allocation	8	3	1	2

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
OS process allocation	kso_new_process:2	3	1
OS process allocation	kso_delete_process:1	1	3
OS process: request allocation	kso_new_process	1	0
PC and Classifier lists for WLM	No latch	25	0
active service list	kswslogon: session logout	23	17
cache buffers chains	kcbgtcr: fast path	2,555	920
cache buffers chains	kcbchg1: mod cr pin	1,903	1,525
cache buffers chains	kcbgcur_2	747	451
cache buffers chains	kcbget: fast exchange	626	379
cache buffers chains	kcbgtcr: fast path (cr pin)	586	389
cache buffers chains	kcbzwb	479	723
cache buffers chains	kcbrls_2	307	251
cache buffers chains	kcbgtcr_2	172	333
cache buffers chains	kcbnew: new latch again	67	0
cache buffers chains	kcbgtcr: kslbegin excl	23	61
cache buffers chains	kcbbxsv	7	7
cache buffers chains	kcbnlc	7	303
cache buffers chains	kcbgcur: fast path (shr)	5	231
cache buffers chains	kcbzibmlt: multi-block read: nowait	5	0
cache buffers chains	kcb_trim_hash_chain	4	1
cache buffers chains	kcbchg1: clear MS bit	4	916
cache buffers chains	kcbzgb: scan from tail. nowait	4	0
cache buffers chains	kcbcge	3	583
cache buffers chains	kcbgcur_4	2	28
cache buffers chains	kcbbic1	1	0
cache buffers chains	kcbchg1: mod cur pin	1	245
cache buffers chains	kcbrls: fast release	1	165
cache buffers lru chain	kcbzgws	108	0
cache buffers lru chain	kcbbic2	12	111
cache buffers lru chain	kcbbxsv: move to being written	4	0
cache buffers lru chain	kcbzgb	3	6
call allocation	ksuxds	1,776	1,524
call allocation	ksudlp: top call	106	147
call allocation	ksuinfos_modact	18	65
call allocation	ksucrp: top call	5	31
call allocation	ksudlc : rec call	4	73
call allocation	ksuprc	3	72
channel handle pool latch	ksrchdelete()	1	1
channel operations parent latch	ksrchdelete_sub()	6	6
channel operations parent latch	ksrmfree()	1	0
checkpoint queue latch	kcbkubc_4	6	4
dummy allocation	ktcscnfy	1	1
enqueue hash chains	ksqrcl	254	119
enqueue hash chains	ksqgtl3	133	135
enqueue hash chains	ksqcmi: get hash chain latch after wait	80	214
enqueue hash chains	ksqcmi: kslgpl	1	0
first Audit Vault latch	Audit Vault latch 1 where 1	1	1
ksz_so allocation latch	ksznfy1	2	2
messages	ksarcv	1	0
object queue header operation	kcbo_unlink_q	90	9
object queue header operation	kcbo_link_q	32	8
object queue header operation	kcbo_switch_cq	21	124
object queue header operation	kcbo_switch_mq_bg	5	4
object queue header operation	kcbo_sw_buf	1	0
object queue header operation	kcbo_switch_q_bg	1	5
parameter table management	ksp_param_table_free	166	16
parameter table management	kspcpy	63	14
post/wait queue	ksliwat:remove	3	2
process allocation	ksucrp:1	1,052	0
process allocation	ksuapc	107	1,213
process allocation	ksudlp	96	43
process allocation	ksu_reserve	1	0
redo allocation	kcrfw_redo_gen: redo allocation 3	33	66
redo allocation	kcrfw_redo_gen: redo allocation 1	27	0
redo allocation	kcrfw_redo_gen: redo allocation 2	13	0
resmgr:free threads list	kskthrcreate	1	1
row cache objects	kqrpre: find obj	1,031	1,217
row cache objects	kqreqd: reget	590	132
row cache objects	kqreqd	245	527
row cache objects	kqrso	61	38
row cache objects	kqrcmt: while loop	25	33
row cache objects	kqrpup	7	1
row cache objects	kqrpdl	4	0
row cache objects	kqrget	3	3
session state list latch	kpseqd	151	2
session state list latch	kpscad	21	36
session state list latch	kpscdl	1	57
session state list latch	kpseqa	1	79
shared pool	kghalo	2,583	1,639
shared pool	kghfre	395	951
shared pool	kghupr1	188	633
shared pool	kghalp	48	7
shared pool	kghfrunp: clatch: nowait	42	0
shared pool	kghfrunp: alloc: wait	10	0
shared pool	kgh_heap_sizes	9	1
shared pool	kghasp	3	2
shared pool	kghfrunp: clatch: wait	3	9
simulator hash latch	kcbs_lookup_setid: lookup dba	62	23
simulator hash latch	kcbsacc: lookup dba	2	40
simulator lru latch	kcbs_lookup_setid	80	0
simulator lru latch	kcbs_simulate: simulate set	26	0
simulator lru latch	kcbs_simbufseq	25	139
simulator lru latch	kcbs_dump_adv_state	8	0
sort extent pool	ktstaddextent1	1	0
space background task latch	ktsj_grab_task	1,374	1,404
space background task latch	ktsj_detach_task	5	0
temporary table state object allocation	kxttCreate	1	1
transaction allocation	ktcxbr	1	1

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kgllkdl1 85	7,834
Library Cache	kglhdgn1 62	6,078
Library Cache	kglhdgn2 106	4,502
Library Cache	kgllkc1 57	2,253
Cursor Pin	kkslce [KKSCHLPIN2]	1,256
Library Cache	kglpin1 4	1,066
Library Cache	kglpndl1 95	484
Library Cache	kglpnal1 90	382
Cursor Pin	kksLockDelete [KKSCHLPIN6]	191
Library Cache	kglget2 2	83
Cursor Pin	kksfbc [KKSCHLPIN1]	64
Library Cache	kglobpn1 71	45
Cursor Pin	kksfbc [KKSCHLFSP2]	38
Library Cache	kglget1 1	7
Library Cache	kglhdgh1 64	5
hash table	kkscsSearchChildList [KKSHBKLOC2]	3
Library Cache	kglati1 45	2
Cursor Parent	kkscsAddChildNode [KKSPRTLOC34]	1

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 1,726,695,093
Captured Segments account for 99.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
DAILY	DAILY_20160905	ISCSIPCTRL_2016090509	TABLE	1,072,303,712	62.10
DAILY	DAILY_20160905	GXFLOW_2016090509	TABLE	399,864,432	23.16
DAILY	DAILY_20160905	MGSIPCTRL_2016090509	TABLE	64,620,960	3.74
DAILY	DAILY_20160905	GXCMCCXDR_2016090509	TABLE	51,218,400	2.97
DAILY	DAILY_20160905	MWSIPCTRL_2016090509	TABLE	35,238,864	2.04

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 666,150
Captured Segments account for 8.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
DAILY	DAILY_20160903	S1SIPFLVOLTE_2016090318	TABLE	8,076	1.21
DAILY	DAILY_20160903	S1SIPFLVOLTE_2016090311	TABLE	7,956	1.19
DAILY	DAILY_20160903	S1SIPFLVOLTE_2016090316	TABLE	6,728	1.01
DAILY	DAILY_20160903	S1SIPFLVOLTE_2016090315	TABLE	6,224	0.93
DAILY	DAILY_20160903	S1SIPFLVOLTE_2016090312	TABLE	5,828	0.87

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 78,301
Captured Segments account for 22.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
DAILY	DAILY_20160905	ISCSIPCTRL_2016090509	TABLE	5,638	7.20
DAILY	DAILY_20160905	MGSIPCTRL_2016090509	TABLE	1,343	1.72
DAILY	DAILY_20160905	MWSIPCTRL_2016090509	TABLE	912	1.16
DAILY	DAILY_20160903	S1SIPFLVOLTE_2016090318	TABLE	898	1.15
DAILY	DAILY_20160903	S1SIPFLVOLTE_2016090311	TABLE	888	1.13

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 78,301
Captured Segments account for 22.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
DAILY	DAILY_20160905	ISCSIPCTRL_2016090509	TABLE	5,638	7.20
DAILY	DAILY_20160905	MGSIPCTRL_2016090509	TABLE	1,343	1.72
DAILY	DAILY_20160905	MWSIPCTRL_2016090509	TABLE	912	1.16
DAILY	DAILY_20160903	S1SIPFLVOLTE_2016090318	TABLE	898	1.15
DAILY	DAILY_20160903	S1SIPFLVOLTE_2016090311	TABLE	888	1.13

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 9,422,308
Captured Segments account for 94.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
DAILY	DAILY_20160905	GXFLOW_2016090509	TABLE	2,505,797	26.59
DAILY	DAILY_20160905	ISCSIPCTRL_2016090509	TABLE	2,078,531	22.06
DAILY	DAILY_20160905	GXCMCCXDR_2016090509	TABLE	827,213	8.78
DAILY	DAILY_20160905	MGSIPCTRL_2016090509	TABLE	496,603	5.27
DAILY	DAILY_20160905	MWSIPCTRL_2016090509	TABLE	355,590	3.77

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 376,342
Captured Segments account for 90.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
DAILY	DAILY_20160905	GXFLOW_2016090509	TABLE	87,850	23.34
DAILY	DAILY_20160905	ISCSIPCTRL_2016090509	TABLE	87,763	23.32
DAILY	DAILY_20160905	GXCMCCXDR_2016090509	TABLE	28,744	7.64
DAILY	DAILY_20160905	MGSIPCTRL_2016090509	TABLE	21,551	5.73
DAILY	DAILY_20160905	MWSIPCTRL_2016090509	TABLE	13,889	3.69

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 8,924,951
Captured Segments account for 95.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Direct Writes	%Total
DAILY	DAILY_20160905	GXFLOW_2016090509	TABLE	2,443,826	27.38
DAILY	DAILY_20160905	ISCSIPCTRL_2016090509	TABLE	1,940,238	21.74
DAILY	DAILY_20160905	GXCMCCXDR_2016090509	TABLE	807,975	9.05
DAILY	DAILY_20160905	MGSIPCTRL_2016090509	TABLE	461,788	5.17
DAILY	DAILY_20160905	MWSIPCTRL_2016090509	TABLE	329,484	3.69

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 10
Captured Segments account for 60.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	I_OBJ2		INDEX	5	50.00
SYS	SYSTEM	I_SYSAUTH1		INDEX	1	10.00

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

% of Capture shows % of DB Block Changes for each top segment compared
with total DB Block Changes for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
DAILY	DAILY_20160905	ISCSIPCTRL_2016090509	TABLE	563,488	21.42
SYS	SYSTEM	SEG$	TABLE	561,712	21.36
SYS	SYSTEM	I_FILE#_BLOCK#	INDEX	389,168	14.80
DAILY	DAILY_20160905	GXFLOW_2016090509	TABLE	279,680	10.63
DAILY	DAILY_20160905	MGSIPCTRL_2016090509	TABLE	138,768	5.28

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared
with total row lock waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
SYS	SYSTEM	I_FILE#_BLOCK#		INDEX	2,698	100.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

% of Capture shows % of ITL waits for each top segment compared
with total ITL waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	ITL Waits	% of Capture
SYS	SYSTEM	SEG$		TABLE	3,104	100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

% of Capture shows % of Buffer Busy Waits for each top segment compared
with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	SEG$	TABLE	11,555	58.30
SYS	SYSTEM	I_FILE#_BLOCK#	INDEX	7,895	39.83
DAILY	DAILY_20160903	S1SIPFLVOLTE_2016090316	TABLE	73	0.37
DAILY	DAILY_20160903	S1SIPFLVOLTE_2016090312	TABLE	55	0.28
DAILY	DAILY_20160903	S1SIPFLVOLTE_2016090314	TABLE	55	0.28

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)
"Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	72	0.00	2	1
dc_global_oids	80,495	0.09	0	127
dc_histogram_data	3,714	1.29	0	620
dc_histogram_defs	73,132	8.67	0	32,372
dc_object_grants	75	72.00	0	86
dc_objects	181,642	0.36	5	319,615
dc_profiles	83,864	0.00	0	1
dc_rollback_segments	2,056	0.00	0	42
dc_segments	430,344	8.94	118,288	44,766
dc_sequences	12	8.33	12	8
dc_tablespaces	1,053,899	0.00	0	16
dc_users	2,579,842	0.00	0	16,438
global database name	44,356	0.00	0	1
outstanding_alerts	60	0.00	0	12
qmc_app_cache_entries	1	100.00	0	1
qmrc_cache_entries	7	100.00	0	7
qmtmrcin_cache_entries	1	100.00	0	1
qmtmrciq_cache_entries	1	100.00	0	1
qmtmrctn_cache_entries	12	50.00	0	6
qmtmrctq_cache_entries	682	50.00	0	341
sch_lj_oids	5	0.00	0	17

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	125,781	0.00	0		0	0
BODY	112,291	0.00	113,370	0.00	0	0
CLUSTER	75	1.33	84	1.19	0	0
DBLINK	125,776	0.00	0		0	0
EDITION	41,954	0.00	83,889	0.00	0	0
SCHEMA	42,337	0.00	0		0	0
SQL AREA	1,491,171	0.04	4,877,052	0.02	94	119
SQL AREA BUILD	441	78.91	0		0	0
SQL AREA STATS	457	79.65	457	79.65	0	0
TABLE/PROCEDURE	348,529	0.07	692,526	0.07	102	0
TRIGGER	56	0.00	56	0.00	0	0

Memory Statistics

Memory Dynamic Components
Memory Resize Operations Summary
Memory Resize Ops
Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Memory Dynamic Components

Min/Max sizes since instance startup
Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
ordered by Component

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	52,096.00	52,096.00	52,096.00	52,096.00	INI/
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	19,584.00	19,584.00	19,584.00	19,584.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	58,624.00	58,624.00	58,624.00	58,624.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	896.00	896.00	896.00	896.00	STA/
large pool	768.00	768.00	768.00	768.00	STA/
shared pool	4,224.00	4,224.00	4,224.00	4,224.00	STA/
streams pool	256.00	256.00	256.00	256.00	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

B: Begin Snap E: End Snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	210.87		2.15	1.89	12	12	98	98
B	Freeable	53.63	0.00	1.09	1.77	5		49	49
B	PL/SQL	1.10	0.88	0.01	0.03	0	0	96	96
B	SQL	0.56	0.16	0.01	0.01	0	3	81	75
E	Other	222.97		2.10	1.83	12	12	106	106
E	Freeable	55.94	0.00	1.06	1.71	5		53	53
E	SQL	14.94	12.22	0.17	0.77	5	26	90	85
E	PL/SQL	1.19	0.93	0.01	0.03	0	0	104	104

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	54,626,615,296
Fixed Size	2,268,192
Redo Buffers	125,947,904
Variable Size	6,442,451,936

Back to Memory Statistics
Back to Top

SGA breakdown difference

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Pool	Name	Begin MB	End MB	% Diff
java	free memory	896.00	896.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	760.19	760.19	0.00
shared	ASH buffers	80.00	80.00	0.00
shared	KGLH0	742.21	673.02	-9.32
shared	KGLHD	163.30	145.50	-10.90
shared	KGLS	131.02	97.55	-25.55
shared	KQR L PO	335.69	328.59	-2.12
shared	SQLA	659.87	692.07	4.88
shared	db_block_hash_buckets	356.00	356.00	0.00
shared	free memory	1,214.51	1,301.70	7.18
streams	free memory	256.00	256.00	0.00
	buffer_cache	52,096.00	52,096.00	0.00
	fixed_sga	2.16	2.16	0.00
	log_buffer	120.11	120.11	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Capture Rate
Streams Apply
Streams Apply Rate
Buffered Queues
Buffered Queue Subscribers
Rule Set
Persistent Queues
Persistent Queues Rate
Persistent Queue Subscribers

Streams CPU/IO Usage

Streams processes ordered by CPU Time, descending

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	0830 12:58:38	0.04	0.00	0.00
QMON Coordinator	0830 12:58:28	0.04	0.00	0.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Shared Server Statistics

Shared Servers Activity
Shared Servers Rates
Shared Servers Utilization
Shared Servers Common Queue
Shared Servers Dispatchers

Shared Servers Activity

Values represent averages for all samples

Avg Total Connections	Avg Active Connections	Avg Total Shared Srvrs	Avg Active Shared Srvrs	Avg Total Dispatchers	Avg Active Dispatchers
0	0	1	0	1	0

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per Sec	Disp Queue Per Sec	Server Msgs/Sec	Server KB/Sec	Common Queue Total	Disp Queue Total	Server Total Msgs	Server Total(KB)
0	0	0	0.00	0	0	0	0

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Statistics are combined for all servers
Incoming and Outgoing Net % are included in %Busy

Total Server Time (s)	%Busy	%Idle	Incoming Net %	Outgoing Net %
3,608	0.00	100.00	0.00	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

Ordered by %Busy, descending
Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue
Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots

Name	Avg Conns	Total Disp Time (s)	%Busy	%Idle	Total Queued	Total Queue Wait (s)	Avg Queue Wait (ms)
D000	0.00	3,608	0.00	100.00	0	0

Back to Shared Server Statistics
Back to Top

init.ora Parameters

init.ora Parameters
init.ora Multi-Valued Parameters

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/opt/oracle/admin/daily/adump
audit_trail	NONE
compatible	11.2.0.4.0
control_files	/opt/oracle/oradata/daily/control01.ctl, /opt/oracle/fast_recovery_area/daily/control02.ctl
db_block_size	8192
db_domain
db_name	daily
db_recovery_file_dest	/opt/oracle/fast_recovery_area
db_recovery_file_dest_size	5218762752
diagnostic_dest	/opt/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=dailyXDB)
log_archive_format	%t_%s_%r.dbf
open_cursors	1500
pga_aggregate_target	20470300672
plsql_warnings	DISABLE:ALL
processes	1500
recyclebin	OFF
remote_login_passwordfile	EXCLUSIVE
sessions	2280
sga_target	61471719424
shadow_core_dump	partial	PARTIAL
undo_tablespace	UNDOTBS1

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

This section only displays parameters that have more one value
'(NULL)' indicates a missing parameter value
A blank in the End Snapshot indicates the same value as the BeginSnapshot

Parameter Name	Begin value	End value (if different)
control_files	/opt/oracle/fast_recovery_area/daily/control02.ctl
control_files	/opt/oracle/oradata/daily/control01.ctl

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	99.97	Soft Parse %:	99.99
Execute to Parse %:	-1.65	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	1.83	% Non-Parse CPU:	99.37