WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

NTP2000 3423858130 NTP2000 1 18-Feb-14 18:02 11.2.0.3.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
NTP2000	3423858130	NTP2000	1	18-Feb-14 18:02	11.2.0.3.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

PSDOMAIN AIX-Based Systems (64-bit) 16 8 64.00

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
PSDOMAIN	AIX-Based Systems (64-bit)	16	8		64.00

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 6214 18-Feb-14 19:00:16 32 1.1

End Snap: 6228 19-Feb-14 09:00:44 41 1.1

Elapsed: 840.46 (mins)

DB Time: 887.29 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	6214	18-Feb-14 19:00:16	32	1.1
End Snap:	6228	19-Feb-14 09:00:44	41	1.1
Elapsed:		840.46 (mins)
DB Time:		887.29 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 22,080M 22,080M Std Block Size: 32K

Shared Pool Size: 1,664M 1,664M Log Buffer: 16,532K

	Begin	End
Buffer Cache:	22,080M	22,080M	Std Block Size:	32K
Shared Pool Size:	1,664M	1,664M	Log Buffer:	16,532K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 1.1 1.0 0.01 0.01

DB CPU(s): 0.6 0.5 0.00 0.00

Redo size: 121,034.8 110,394.6

Logical reads: 4,878.8 4,449.9

Block changes: 514.5 469.3

Physical reads: 374.2 341.3

Physical writes: 201.6 183.8

User calls: 193.9 176.9

Parses: 45.3 41.3

Hard parses: 0.4 0.4

W/A MB processed: 10.8 9.9

Logons: 1.1 1.0

Executes: 130.8 119.3

Rollbacks: 0.0 0.0

Transactions: 1.1

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.1	1.0	0.01	0.01
DB CPU(s):	0.6	0.5	0.00	0.00
Redo size:	121,034.8	110,394.6
Logical reads:	4,878.8	4,449.9
Block changes:	514.5	469.3
Physical reads:	374.2	341.3
Physical writes:	201.6	183.8
User calls:	193.9	176.9
Parses:	45.3	41.3
Hard parses:	0.4	0.4
W/A MB processed:	10.8	9.9
Logons:	1.1	1.0
Executes:	130.8	119.3
Rollbacks:	0.0	0.0
Transactions:	1.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.49 Soft Parse %: 99.12

Execute to Parse %: 65.39 Latch Hit %: 99.93

Parse CPU to Parse Elapsd %: 24.38 % Non-Parse CPU: 99.63

Shared Pool Statistics

Begin End

Memory Usage %: 20.93 42.97

% SQL with executions>1: 62.84 94.39

% Memory for SQL w/exec>1: 64.04 92.47

	Begin	End
Memory Usage %:	20.93	42.97
% SQL with executions>1:	62.84	94.39
% Memory for SQL w/exec>1:	64.04	92.47

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		28,485		53.51
db file scattered read	642,052	5,587	9	10.50	User I/O
kdblil wait before retrying ORA-54	3,518	3,518	1000	6.61	Other
db file sequential read	781,252	1,713	2	3.22	User I/O
SQL*Net more data from client	1,802,294	574	0	1.08	Network

Host CPU (CPUs: 16 Cores: 8 Sockets: )

Load Average Begin Load Average End %User %System %WIO %Idle

2.26 1.81 7.8 2.8 0.8 89.4

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
2.26	1.81	7.8	2.8	0.8	89.4

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

3.6 33.6 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 65,536.0 65,536.0

SGA use (MB): 24,576.0 24,576.0

PGA use (MB): 112.4 147.0

% Host Mem used for SGA+PGA: 37.67 37.72

	Begin	End
Host Mem (MB):	65,536.0	65,536.0
SGA use (MB):	24,576.0	24,576.0
PGA use (MB):	112.4	147.0
% Host Mem used for SGA+PGA:	37.67	37.72

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): 53237.5s
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
DB CPU	28,484.84	53.51
sql execute elapsed time	25,794.77	48.45
PL/SQL execution elapsed time	1,083.72	2.04
connection management call elapsed time	416.41	0.78
parse time elapsed	392.04	0.74
hard parse elapsed time	265.98	0.50
failed parse elapsed time	51.87	0.10
hard parse (sharing criteria) elapsed time	7.37	0.01
repeated bind elapsed time	2.81	0.01
PL/SQL compilation elapsed time	1.64	0.00
sequence load elapsed time	0.04	0.00
hard parse (bind mismatch) elapsed time	0.01	0.00
DB time	53,237.54
background elapsed time	1,525.54
background cpu time	329.89

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
AVG_BUSY_TIME	533,939
AVG_IDLE_TIME	4,503,361
AVG_IOWAIT_TIME	41,259
AVG_SYS_TIME	138,353
AVG_USER_TIME	393,154
BUSY_TIME	8,580,702
IDLE_TIME	72,091,970
IOWAIT_TIME	675,789
SYS_TIME	2,251,512
USER_TIME	6,329,190
LOAD	2	2
OS_CPU_WAIT_TIME	8,171,300
RSRC_MGR_CPU_WAIT_TIME	8
VM_IN_BYTES	6,782,976
VM_OUT_BYTES	421,515,137,024
PHYSICAL_MEMORY_BYTES	68,719,476,736
NUM_CPUS	16
NUM_CPU_CORES	8
NUM_LCPUS	16
NUM_VCPUS	8
GLOBAL_RECEIVE_SIZE_MAX	1,310,720
GLOBAL_SEND_SIZE_MAX	1,310,720
TCP_RECEIVE_SIZE_DEFAULT	16,384
TCP_RECEIVE_SIZE_MAX	9,223,372,036,854,775,807
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	9,223,372,036,854,775,807
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
18-Feb 19:00:16	2.26
18-Feb 20:00:18	2.07	13.58	10.23	3.35	86.42	0.04
18-Feb 21:00:23	2.07	13.21	10.01	3.20	86.79	0.29
18-Feb 22:00:25	3.07	12.10	8.88	3.22	87.90	0.90
18-Feb 23:00:27	1.55	11.11	8.11	3.00	88.89	1.52
19-Feb 00:00:29	1.94	9.55	6.66	2.89	90.45	0.03
19-Feb 01:00:30	1.34	9.31	6.32	3.00	90.69	0.89
19-Feb 02:00:32	1.00	6.93	4.48	2.45	93.07	0.04
19-Feb 03:00:34	1.18	6.32	3.95	2.37	93.68	0.02
19-Feb 04:00:35	1.93	10.99	8.56	2.43	89.01	1.43
19-Feb 05:00:37	1.66	10.64	8.30	2.34	89.36	1.44
19-Feb 06:00:39	1.41	10.26	7.95	2.31	89.74	2.01
19-Feb 07:00:41	1.30	14.32	11.72	2.60	85.68	2.92
19-Feb 08:00:42	1.54	9.20	6.34	2.86	90.80	0.04
19-Feb 09:00:44	1.81	11.39	8.33	3.07	88.61	0.15

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 75.9% of Total DB time 53,237.54 (s)
Total FG Wait Time: 11,943.24 (s) DB CPU time: 28,484.84 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			28,485		53.51
User I/O	1,914,877	0	7,475	4	14.04
Other	307,909	1	3,770	12	7.08
Network	8,041,276	0	586	0	1.10
Commit	196,994	0	86	0	0.16
Application	16,816	0	12	1	0.02
System I/O	6,077	0	9	1	0.02
Concurrency	8,998	0	3	0	0.01
Configuration	732	0	2	3	0.00
Scheduler	1	0	0	0	0.00
Administrative	0		0		0.00

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
db file scattered read	642,052	0	5,587	9	11.61	10.50
kdblil wait before retrying ORA-54	3,518	100	3,518	1000	0.06	6.61
db file sequential read	781,252	0	1,713	2	14.13	3.22
SQL*Net more data from client	1,802,294	0	574	0	32.60	1.08
enq: CR - block range reuse ckpt	96,896	0	147	2	1.75	0.28
Wait for shrink lock2	882	100	88	100	0.02	0.17
log file sync	196,994	0	86	0	3.56	0.16
Disk file operations I/O	337,986	0	78	0	6.11	0.15
local write wait	65,652	0	53	1	1.19	0.10
direct path write	86,571	0	43	0	1.57	0.08
reliable message	205,294	0	17	0	3.71	0.03
SQL*Net message to client	6,238,982	0	12	0	112.85	0.02
enq: RO - fast object reuse	15,827	0	11	1	0.29	0.02
log file sequential read	279	0	5	20	0.01	0.01
control file sequential read	5,798	0	3	1	0.10	0.01
enq: ST - contention	260	0	2	8	0.00	0.00
os thread startup	8	0	1	103	0.00	0.00
buffer busy waits	5,023	0	1	0	0.09	0.00
read by other session	100	0	1	6	0.00	0.00
db file parallel read	64	0	1	9	0.00	0.00
cursor: pin S wait on X	21	0	0	23	0.00	0.00
library cache: mutex X	2,934	0	0	0	0.05	0.00
enq: TM - contention	476	0	0	0	0.01	0.00
enq: TX - row lock contention	513	0	0	0	0.01	0.00
log file switch (private strand flush incomplete)	5	0	0	26	0.00	0.00
write complete waits	167	0	0	1	0.00	0.00
kksfbc child completion	2	100	0	50	0.00	0.00
resmgr:internal state change	1	100	0	100	0.00	0.00
PX Deq: Slave Session Stats	424	0	0	0	0.01	0.00
library cache lock	21	0	0	3	0.00	0.00
cursor: pin S	11	0	0	5	0.00	0.00
enq: TX - allocate ITL entry	290	0	0	0	0.01	0.00
latch free	563	0	0	0	0.01	0.00
undo segment extension	3	100	0	10	0.00	0.00
latch: cache buffers chains	824	0	0	0	0.01	0.00
ADR block file read	15	0	0	2	0.00	0.00
log file switch completion	1	0	0	23	0.00	0.00
direct path read	4	0	0	6	0.00	0.00
library cache load lock	11	0	0	2	0.00	0.00
cursor: mutex S	2	0	0	10	0.00	0.00
PX Deq: Signal ACK EXT	212	0	0	0	0.00	0.00
direct path write temp	13	0	0	1	0.00	0.00
latch: row cache objects	30	0	0	0	0.00	0.00
utl_file I/O	1,183	0	0	0	0.02	0.00
log buffer space	3	0	0	2	0.00	0.00
CSS initialization	1	0	0	4	0.00	0.00
enq: PS - contention	25	0	0	0	0.00	0.00
latch: In memory undo latch	64	0	0	0	0.00	0.00
latch: shared pool	46	0	0	0	0.00	0.00
ADR block file write	7	0	0	0	0.00	0.00
latch: undo global data	3	0	0	0	0.00	0.00
SQL*Net message from client	6,238,973	0	35,399	6	112.84
jobq slave wait	7,689	100	3,843	500	0.14
PX Deq: Execution Msg	1,735	0	85	49	0.03
PL/SQL lock timer	3	100	3	1000	0.00
PX Deq: Execute Reply	1,485	0	0	0	0.03
PX Deq: Parse Reply	212	0	0	0	0.00
PX Deq Credit: send blkd	140	0	0	0	0.00
PX Deq: Join ACK	212	0	0	0	0.00
PX Deq: Msg Fragment	344	0	0	0	0.01
PX Deq: Table Q Normal	374	0	0	0	0.01

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
log file parallel write	1,544,588	0	562	0	27.94	36.84
db file parallel write	573,967	0	237	0	10.38	15.53
db file sequential read	11,579	0	75	7	0.21	4.94
os thread startup	299	0	44	147	0.01	2.88
db file async I/O submit	573,967	0	30	0	10.38	1.97
control file sequential read	53,182	0	19	0	0.96	1.25
LGWR wait for redo copy	105,149	0	13	0	1.90	0.88
control file parallel write	24,922	0	12	0	0.45	0.80
db file scattered read	322	0	3	9	0.01	0.18
Disk file operations I/O	12,225	0	3	0	0.22	0.17
latch free	37,576	0	2	0	0.68	0.16
process diagnostic dump	647	0	1	1	0.01	0.04
JS coord start wait	1	100	1	500	0.00	0.03
ADR block file read	519	0	0	1	0.01	0.03
rdbms ipc reply	2	0	0	161	0.00	0.02
db file parallel read	7	0	0	44	0.00	0.02
direct path read	16	0	0	11	0.00	0.01
SQL*Net message to client	158,854	0	0	0	2.87	0.01
log file sequential read	28	0	0	4	0.00	0.01
asynch descriptor resize	53,227	100	0	0	0.96	0.01
resmgr:internal state change	1	100	0	100	0.00	0.01
ADR block file write	213	0	0	0	0.00	0.00
enq: CR - block range reuse ckpt	41	0	0	1	0.00	0.00
direct path write	97	0	0	0	0.00	0.00
reliable message	124	0	0	0	0.00	0.00
ADR file lock	226	12	0	0	0.00	0.00
log file sync	28	0	0	0	0.00	0.00
latch: active service list	140	0	0	0	0.00	0.00
log file single write	28	0	0	0	0.00	0.00
library cache: mutex X	985	0	0	0	0.02	0.00
latch: messages	33	0	0	0	0.00	0.00
enq: RO - fast object reuse	41	0	0	0	0.00	0.00
wait list latch free	3	0	0	1	0.00	0.00
latch: object queue header operation	63	0	0	0	0.00	0.00
db file single write	7	0	0	0	0.00	0.00
latch: redo allocation	22	0	0	0	0.00	0.00
buffer busy waits	21	0	0	0	0.00	0.00
direct path write temp	5	0	0	0	0.00	0.00
latch: redo writing	15	0	0	0	0.00	0.00
rdbms ipc message	2,679,831	9	624,139	233	48.47
Space Manager: slave idle wait	209,821	25	504,249	2403	3.80
DIAG idle wait	100,709	100	100,711	1000	1.82
Streams AQ: qmn coordinator idle wait	3,602	50	50,428	14000	0.07
Streams AQ: qmn slave idle wait	1,801	0	50,428	28000	0.03
smon timer	8,342	0	50,420	6044	0.15
pmon timer	16,812	100	50,418	2999	0.30
VKRM Idle	1	0	14,400	14399614	0.00
PX Idle Wait	220	0	2,826	12846	0.00
SQL*Net message from client	211,808	0	169	1	3.83
class slave wait	169	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	534	92.3	1.3	.9	2.4	3.0
ADR block file write	220	98.6	.5	.9
ADR file lock	240	99.6	.4
ASM file metadata operation	1	100.0
CSS initialization	1			100.0
Disk file operations I/O	350.2K	99.8	.0	.1	.1	.0	.0	.0
JS coord start wait	1							100.0
LGWR wait for redo copy	105.1K	100.0	.0	.0
PX Deq: Signal ACK EXT	212	99.5				.5
PX Deq: Slave Session Stats	424	98.3				1.7
PX qref latch	17	100.0
SQL*Net message to client	6397.6K	100.0	.0	.0
SQL*Net more data from client	1802.2K	99.6	.4	.1	.0
Wait for shrink lock2	882							100.0
asynch descriptor resize	53.2K	100.0
buffer busy waits	5041	99.8	.1	.1
buffer deadlock	20	100.0
control file parallel write	24.9K	96.6	2.3	.7	.2	.1	.0	.0
control file sequential read	59K	96.7	1.5	.7	.5	.5	.0	.0
cursor: mutex S	2					100.0
cursor: mutex X	2	100.0
cursor: pin S	13	61.5				38.5
cursor: pin S wait on X	21		4.8	14.3		42.9	14.3	23.8
db file async I/O submit	573.9K	100.0	.0	.0
db file parallel read	71		1.4	7.0	26.8	53.5	2.8	8.5
db file parallel write	573.9K	98.5	1.1	.3	.1	.0	.0	.0
db file scattered read	642.4K	3.0	14.7	3.7	20.3	53.7	4.2	.3
db file sequential read	792.6K	72.2	.6	3.6	13.9	9.3	.3	.1
db file single write	7	100.0
direct path read	20	5.0	5.0	5.0	30.0	30.0	25.0
direct path write	86.7K	97.7	1.6	.5	.2	.1	.0	.0
direct path write temp	18	77.8	11.1	11.1
enq: CR - block range reuse ckpt	96.9K	10.4	74.0	14.3	1.1	.2	.0	.0
enq: HW - contention	2	100.0
enq: PS - contention	25	100.0
enq: RO - fast object reuse	15.9K	77.7	15.1	6.6	.5	.1	.0
enq: SQ - contention	1	100.0
enq: ST - contention	260	19.2	16.9	25.0	24.2	3.1	2.3	9.2
enq: TM - contention	476	100.0
enq: TX - allocate ITL entry	290	100.0
enq: TX - row lock contention	513	100.0
kdblil wait before retrying ORA-54	3518							100.0
kksfbc child completion	2							100.0
latch free	38.1K	99.9	.1	.0
latch: In memory undo latch	64	100.0
latch: active service list	144	100.0
latch: cache buffers chains	891	100.0
latch: cache buffers lru chain	3	100.0
latch: call allocation	26	100.0
latch: checkpoint queue latch	1	100.0
latch: messages	33	97.0	3.0
latch: object queue header operation	68	100.0
latch: redo allocation	22	100.0
latch: redo writing	15	100.0
latch: row cache objects	38	94.7	2.6	2.6
latch: shared pool	54	100.0
latch: undo global data	3	100.0
library cache load lock	11	81.8	9.1				9.1
library cache lock	21	23.8	52.4	14.3		4.8	4.8
library cache: mutex X	3910	99.3				.7
local write wait	65.7K	92.3	6.9	.7	.1	.0	.0
log buffer space	3	66.7		33.3
log file parallel write	1544.6K	98.4	1.1	.3	.1	.0	.0	.0
log file sequential read	307	18.9	3.9	1.6	4.6	17.3	43.3	10.4
log file single write	28	100.0
log file switch (private strand flush incomplete)	5				20.0		40.0	40.0
log file switch completion	1						100.0
log file sync	197K	96.6	2.3	.8	.3	.1	.0	.0
os thread startup	307							99.3	.7
process diagnostic dump	647	60.7	7.9	30.6	.8
rdbms ipc reply	2	50.0						50.0
read by other session	100	1.0	2.0	11.0	68.0	18.0
reliable message	205.4K	99.9	.0	.0	.0	.0	.0	.0
resmgr:cpu quantum	2	100.0
resmgr:internal state change	2							100.0
undo segment extension	3	33.3				33.3	33.3
utl_file I/O	1183	99.8	.1	.1
wait list latch free	3	33.3	66.7
write complete waits	167	94.6	3.0	.6	1.8
DIAG idle wait	100.7K							100.0
PL/SQL lock timer	3							100.0
PX Deq Credit: need buffer	14	100.0
PX Deq Credit: send blkd	140	97.1	2.9
PX Deq: Execute Reply	1485	98.9	.9	.2
PX Deq: Execution Msg	1729	63.0	20.8	2.6	.3	.8		12.5
PX Deq: Join ACK	212	99.1	.9
PX Deq: Msg Fragment	343	99.4	.6
PX Deq: Parse Reply	212	92.5	5.7	.9	.5	.5
PX Deq: Table Q Normal	373	100.0
PX Idle Wait	212	.9						23.6	75.5
SQL*Net message from client	6450.6K	85.8	2.3	.9	3.7	1.1	5.0	1.2	.0
Space Manager: slave idle wait	207.2K	.2	.0	.1	.2	.4	.8	32.2	66.1
Streams AQ: qmn coordinator idle wait	3602	50.0	.0						50.0
Streams AQ: qmn slave idle wait	1801								100.0
VKRM Idle	1								100.0
class slave wait	169	100.0
jobq slave wait	7688					.0		100.0
pmon timer	16.8K							.0	100.0
rdbms ipc message	2679.6K	52.6	9.2	4.2	2.6	1.8	2.7	21.8	5.2
smon timer	8342	.1	.0	.1	.2	.2	.5	10.7	88.1

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
Disk file operations I/O	3	100.0	.0	.0
JS coord start wait	1					100.0
Wait for shrink lock2	882			100.0
control file parallel write	1	100.0	.0
control file sequential read	16	100.0	.0	.0
cursor: pin S wait on X	5	76.2	19.0	4.8
db file parallel read	6	91.5	8.5
db file parallel write	21	100.0	.0	.0	.0
db file scattered read	2104	99.7	.3	.0	.0	.0
db file sequential read	491	99.9	.1	.0	.0	.0
direct path write	4	100.0	.0
enq: CR - block range reuse ckpt	8	100.0	.0
enq: ST - contention	24	90.8	7.7	1.5
kdblil wait before retrying ORA-54	3518						100.0
kksfbc child completion	2		100.0
log file parallel write	4	100.0	.0
log file sequential read	32	89.6	8.5	2.0
log file switch (private strand flush incomplete)	2	60.0	40.0
log file sync	3	100.0	.0
os thread startup	306			88.6	10.7			.3	.3
rdbms ipc reply	1	50.0				50.0
reliable message	8	100.0	.0	.0			.0
resmgr:internal state change	2			100.0

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
os thread startup	1	99.7			.3

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

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)
SYS$USERS	53,236	28,483	18,855	245,180
NTP2000	3	2	0	0
SYS$BACKGROUND	0	0	15	850

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	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	1914875	7475	8878	3	0	0	8027846	586
SYS$BACKGROUND	24284	81	1383	44	0	0	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 7.5% of Total DB Time (s): 53,238
Captured PL/SQL account for 43.4% of Total DB Time (s): 53,238

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
16,527.57	2	8,263.78	31.04	51.46	27.52	4yvwyb5z5t8v9	SQL*Plus	BEGIN SP_ORA_INDEX_REBUILD_ALL...
4,247.36	10	424.74	7.98	50.33	26.50	2p7c1wy5dwfbm	SQL*Plus	BEGIN SP_ORA_INDEX_REBUILD_ALL...
1,144.78	1	1,144.78	2.15	8.13	81.08	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
1,012.02	1	1,012.02	1.90	29.13	54.37	adkvb8hry75c8	SQL*Plus	BEGIN sp_data_lifecycle; END; ...
890.08	104	8.56	1.67	1.82	98.25	8szmwam7fysa3	DBMS_SCHEDULER	insert into wri$_adv_objspace_...
503.20	1,373,977	0.00	0.95	65.85	0.00	gp2kv5n5ypa7w	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
502.41	1,373,965	0.00	0.94	65.85	0.00	dzs3rm0w0bgnv	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
229.99	922,105	0.00	0.43	64.26	0.01	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
205.09	159,236	0.00	0.39	62.54	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
195.67	577	0.34	0.37	3.11	96.33	130dvvr5s8bgn		select obj#, dataobj#, part#, ...

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 6.2% of Total CPU Time (s): 28,485
Captured PL/SQL account for 39.0% of Total CPU Time (s): 28,485

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
8,504.47	2	4,252.24	29.86	16,527.57	51.46	27.52	4yvwyb5z5t8v9	SQL*Plus	BEGIN SP_ORA_INDEX_REBUILD_ALL...
2,137.53	10	213.75	7.50	4,247.36	50.33	26.50	2p7c1wy5dwfbm	SQL*Plus	BEGIN SP_ORA_INDEX_REBUILD_ALL...
331.35	1,373,977	0.00	1.16	503.20	65.85	0.00	gp2kv5n5ypa7w	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
330.82	1,373,965	0.00	1.16	502.41	65.85	0.00	dzs3rm0w0bgnv	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
294.82	1	294.82	1.04	1,012.02	29.13	54.37	adkvb8hry75c8	SQL*Plus	BEGIN sp_data_lifecycle; END; ...
147.79	922,105	0.00	0.52	229.99	64.26	0.01	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
128.25	159,236	0.00	0.45	205.09	62.54	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
102.77	52,922	0.00	0.36	162.03	63.42	0.00	bjstq78pprd24	SQL Loader Direct Path Load	SELECT DECODE(ELEMENT_SUBSTITU...
93.03	1	93.03	0.33	1,144.78	8.13	81.08	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
88.06	314,458	0.00	0.31	149.45	58.92	0.00	bsa0wjtftg3uw		select file# from file$ where ...

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 16.5% of Total User I/O Wait Time (s): 7,557
Captured PL/SQL account for 95.2% of Total User I/O Wait Time (s): 7,557

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
4,547.72	2	2,273.86	60.18	16,527.57	51.46	27.52	4yvwyb5z5t8v9	SQL*Plus	BEGIN SP_ORA_INDEX_REBUILD_ALL...
1,125.75	10	112.58	14.90	4,247.36	50.33	26.50	2p7c1wy5dwfbm	SQL*Plus	BEGIN SP_ORA_INDEX_REBUILD_ALL...
928.17	1	928.17	12.28	1,144.78	8.13	81.08	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
874.51	104	8.41	11.57	890.08	1.82	98.25	8szmwam7fysa3	DBMS_SCHEDULER	insert into wri$_adv_objspace_...
550.21	1	550.21	7.28	1,012.02	29.13	54.37	adkvb8hry75c8	SQL*Plus	BEGIN sp_data_lifecycle; END; ...
188.48	577	0.33	2.49	195.67	3.11	96.33	130dvvr5s8bgn		select obj#, dataobj#, part#, ...
44.77	104	0.43	0.59	52.44	18.80	85.37	7wgks43wrjtrz	DBMS_SCHEDULER	SELECT U.SPACE_USED, U.SPACE_A...
28.31	1	28.31	0.37	28.51	0.91	99.33	9v9n97qj8z1dg		delete /*+ dynamic_sampling(4)...
20.50	1	20.50	0.27	67.68	40.40	30.29	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
15.39	0		0.20	33.04	38.34	46.60	gdpn6rzn2rdtd	SQL*Plus	alter index IDX_4394791_FLOW_T...

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: 246,025,478
Captured SQL account for 77.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
44,714,210	314,458	142.19	18.17	149.45	58.9	0	bsa0wjtftg3uw		select file# from file$ where ...
35,374,195	52,922	668.42	14.38	95.93	63.2	0	8nb6mg3u6buhq	SQL Loader Direct Path Load	select pname, length(pname) f...
35,302,809	52,813	668.45	14.35	102.59	62.4	0	7ac05552jb0v9	SQL Loader Direct Path Load	SELECT 'X' FROM SYS.LOADER_PAR...
22,984,764	2	11,492,382.00	9.34	16,527.57	51.5	27.5	4yvwyb5z5t8v9	SQL*Plus	BEGIN SP_ORA_INDEX_REBUILD_ALL...
22,501,616	1,373,977	16.38	9.15	503.20	65.8	0	gp2kv5n5ypa7w	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
22,490,410	1,373,965	16.37	9.14	502.41	65.8	0	dzs3rm0w0bgnv	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
10,375,582	1	10,375,582.00	4.22	1,012.02	29.1	54.4	adkvb8hry75c8	SQL*Plus	BEGIN sp_data_lifecycle; END; ...
5,283,951	10	528,395.10	2.15	4,247.36	50.3	26.5	2p7c1wy5dwfbm	SQL*Plus	BEGIN SP_ORA_INDEX_REBUILD_ALL...
5,130,484	1	5,130,484.00	2.09	1,144.78	8.1	81.1	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
3,701,578	922,105	4.01	1.50	229.99	64.3	0	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
3,438,806	52,922	64.98	1.40	162.03	63.4	0	bjstq78pprd24	SQL Loader Direct Path Load	SELECT DECODE(ELEMENT_SUBSTITU...

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: 18,870,269
Captured SQL account for 3.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
14,974,398	2	7,487,199.00	79.35	16,527.57	51.46	27.52	4yvwyb5z5t8v9	SQL*Plus	BEGIN SP_ORA_INDEX_REBUILD_ALL...
3,252,253	10	325,225.30	17.23	4,247.36	50.33	26.50	2p7c1wy5dwfbm	SQL*Plus	BEGIN SP_ORA_INDEX_REBUILD_ALL...
398,585	1	398,585.00	2.11	1,144.78	8.13	81.08	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
199,519	104	1,918.45	1.06	890.08	1.82	98.25	8szmwam7fysa3	DBMS_SCHEDULER	insert into wri$_adv_objspace_...
197,440	104	1,898.46	1.05	52.44	18.80	85.37	7wgks43wrjtrz	DBMS_SCHEDULER	SELECT U.SPACE_USED, U.SPACE_A...
159,119	1	159,119.00	0.84	1,012.02	29.13	54.37	adkvb8hry75c8	SQL*Plus	BEGIN sp_data_lifecycle; END; ...
64,967	577	112.59	0.34	195.67	3.11	96.33	130dvvr5s8bgn		select obj#, dataobj#, part#, ...
57,435	0		0.30	41.12	51.12	28.44	cqkgg81x3jvvf	SQL*Plus	alter index IDX_4394791_FLOW_T...
51,383	0		0.27	33.04	38.34	46.60	gdpn6rzn2rdtd	SQL*Plus	alter index IDX_4394791_FLOW_T...
16,753	0		0.09	7.89	27.13	62.98	6vnnpvn0rzfku	SQL*Plus	alter index IDX_4396828_GN_TDR...

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: 1,436,866
Captured SQL account for 29.5% of Total
Total UnOptimized Read Requests: 1,436,866
Captured SQL account for 29.5% 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
647,829	647,829	2	323,914.50	45.09	4yvwyb5z5t8v9	SQL*Plus	BEGIN SP_ORA_INDEX_REBUILD_ALL...
398,338	398,338	1	398,338.00	27.72	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
199,479	199,479	104	1,918.07	13.88	8szmwam7fysa3	DBMS_SCHEDULER	insert into wri$_adv_objspace_...
197,440	197,440	104	1,898.46	13.74	7wgks43wrjtrz	DBMS_SCHEDULER	SELECT U.SPACE_USED, U.SPACE_A...
159,119	159,119	1	159,119.00	11.07	adkvb8hry75c8	SQL*Plus	BEGIN sp_data_lifecycle; END; ...
152,103	152,103	10	15,210.30	10.59	2p7c1wy5dwfbm	SQL*Plus	BEGIN SP_ORA_INDEX_REBUILD_ALL...
7,498	7,498	1	7,498.00	0.52	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
4,881	4,881	1	4,881.00	0.34	05s9358mm6vrr		begin dbms_feature_usage_inter...
4,806	4,806	1	4,806.00	0.33	9v9n97qj8z1dg		delete /*+ dynamic_sampling(4)...
4,636	4,636	328	14.13	0.32	424h0nf7bhqzd	DBMS_SCHEDULER	SELECT sqlset_row(sql_id, for...

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: 6,597,020
Captured SQL account for 90.0% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,373,977	0	0.00	503.20	65.8	0	gp2kv5n5ypa7w	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
1,373,965	0	0.00	502.41	65.8	0	dzs3rm0w0bgnv	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
922,105	922,104	1.00	229.99	64.3	0	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
314,458	22,231,389	70.70	149.45	58.9	0	bsa0wjtftg3uw		select file# from file$ where ...
174,294	174,294	1.00	4.55	58.4	0	fhzj09a7fnrnb	SQL Loader Direct Path Load	SELECT DBTIMEZONE, LENGTH(DBTI...
159,236	1,857,540	11.67	205.09	62.5	0	cm5vu20fhtnq1		select /*+ connect_by_filterin...
116,868	11,912	0.10	8.64	51.5	11	9tgj4g8y4rwy8		select type#, blocks, extents,...
96,935	96,935	1.00	23.37	62.2	0	7zx0nu1u7qccz		delete from seg$ where ts#=:1 ...
85,709	0	0.00	38.53	64.5	0	bj0up6yn660zx	SQL Loader Direct Path Load	SELECT SUBPARTITION_NAME FROM ...
53,074	159,224	3.00	17.89	58	0	0k8522rmdzg4k		select privilege# from sysauth...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 2,283,313
Captured SQL account for 73.3% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
53,743	314,458	2.35	bsa0wjtftg3uw		select file# from file$ where ...
53,733	922,105	2.35	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
53,676	116,868	2.35	9tgj4g8y4rwy8		select type#, blocks, extents,...
53,646	96,935	2.35	7zx0nu1u7qccz		delete from seg$ where ts#=:1 ...
53,075	159,236	2.32	cm5vu20fhtnq1		select /*+ connect_by_filterin...
53,073	53,074	2.32	0k8522rmdzg4k		select privilege# from sysauth...
52,951	52,951	2.32	459f3z9u4fb3u		select value$ from props$ wher...
52,947	52,945	2.32	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
52,944	52,946	2.32	5ur69atw3vfhj		select decode(failover_method,...
52,923	52,922	2.32	8nb6mg3u6buhq	SQL Loader Direct Path Load	select pname, length(pname) f...
52,923	52,923	2.32	b46fndavjb1pj	SQL Loader Direct Path Load	SELECT CONSTRAINT_NAME, TYPE, ...
52,923	52,914	2.32	bd13sdj0ty0q4	SQL Loader Direct Path Load	SELECT 'X' FROM SYS.ALL_OBJECT...
52,923	52,922	2.32	bjstq78pprd24	SQL Loader Direct Path Load	SELECT DECODE(ELEMENT_SUBSTITU...
52,923	52,923	2.32	bzcf02fmx1fxu		SELECT O.NAME, U.NAME FROM SYS...
52,923	52,923	2.32	cv86y224b08ab	SQL Loader Direct Path Load	SELECT TRIGGER_OWNER, TRIGGER_...
52,923	1,373,965	2.32	dzs3rm0w0bgnv	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
52,923	1,373,977	2.32	gp2kv5n5ypa7w	SQL Loader Direct Path Load	SELECT 'X' FROM LOADER_COL_FLA...
52,922	52,921	2.32	07rw9znc8g7aj	SQL Loader Direct Path Load	SELECT DECODE(COUNT(*), 0, 0, ...
52,922	52,923	2.32	a0wx5u9sbc6nk		SELECT ROBJ# FROM SYS.CDEF$ WH...
52,922	52,922	2.32	dutdz1c6ub304	SQL Loader Direct Path Load	SELECT DECODE(COUNT(*), 0, 0, ...
52,921	52,922	2.32	d247u0jp3z8ws	SQL Loader Direct Path Load	SELECT DECODE(COUNT(*), 0, 0, ...
52,920	52,921	2.32	4z554v42crjkn	SQL Loader Direct Path Load	SELECT DECODE(NESTED, 'YES', 1...
52,813	52,813	2.31	7ac05552jb0v9	SQL Loader Direct Path Load	SELECT 'X' FROM SYS.LOADER_PAR...
52,813	52,813	2.31	8agwdqgvnpqzh		UPDATE SYS.KU_UTLUSE SET USECN...
52,812	52,812	2.31	b36m29qfaz4rq	SQL Loader Direct Path Load	SELECT COUNT (distinct partnam...
52,812	174,294	2.31	fhzj09a7fnrnb	SQL Loader Direct Path Load	SELECT DBTIMEZONE, LENGTH(DBTI...
52,805	85,709	2.31	bj0up6yn660zx	SQL Loader Direct Path Load	SELECT SUBPARTITION_NAME FROM ...
49,142	49,142	2.15	21czn90vsncd6		select 1 from rls$ r, obj$ o, ...
48,462	48,462	2.12	05k5qtcfz4uf7	SQL Loader Direct Path Load	SELECT DISTINCT INDEXNAME, SUB...
44,942	44,942	1.97	3nv2uwsnw0j27	SQL Loader Direct Path Load	SELECT distinct PARTNAME, LOAD...
44,505	44,505	1.95	15jnrrb6016nd	SQL Loader Direct Path Load	SELECT SESSIONTIMEZONE, LENGTH...
39,701	39,702	1.74	3w54wsybgw0sc	sqlldr@PSDOMAIN (TNS V1-V3)	SELECT SYS_CONTEXT('USERENV', ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

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

05k5qtcfz4uf7 SELECT DISTINCT INDEXNAME, SUBNAME, MESSAGE, MESSAGE_NUM FROM V$LOADISTAT WHERE OWNER = :1 AND TABNAME = :2 ORDER BY INDEXNAME, SUBNAME

05s9358mm6vrr begin dbms_feature_usage_internal.exec_db_usage_sampling(:bind1); end;

07rw9znc8g7aj SELECT DECODE(COUNT(*), 0, 0, 1) FROM SYS.ALL_VIEWS WHERE VIEW_NAME = :tname AND OWNER = :owner

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

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')

130dvvr5s8bgn select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part#

15jnrrb6016nd SELECT SESSIONTIMEZONE, LENGTH(SESSIONTIMEZONE) FROM SYS.DUAL

21czn90vsncd6 select 1 from rls$ r, obj$ o, user$ u where r.enable_flag=1 and bitand(r.stmt_type, 2)=2 and r.obj#=o.obj# and o.owner#=u.user# and u.name= :1 and o.name= :2

2p7c1wy5dwfbm BEGIN SP_ORA_INDEX_REBUILD_ALL; END;

3nv2uwsnw0j27 SELECT distinct PARTNAME, LOADED FROM V$LOADPSTAT WHERE OWNER = :1 AND TABNAME = :2 AND PARTNAME IS NOT NULL ORDER BY PARTNAME

3w54wsybgw0sc SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL

424h0nf7bhqzd SELECT sqlset_row(sql_id, force_matching_signature, sql_text, object_list, bind_data, parsing_schema_name, module, action, elapsed_time, cpu_time, buffer_gets, disk_reads, direct_writes, rows_processed, fetches, executions, end_of_fetch_count, optimizer_cost, optimizer_env, priority, command_type, first_load_time, stat_period, active_stat_period, other, plan_hash_value, sql_plan, bind_list) FROM ( SELECT /*+ first_rows(1) */ sql_id, force_matching_signature, sql_text, cast(NULL as SQL_OBJECTS) object_list, bind_data, parsing_schema_name, module, action, elapsed_time, cpu_time, buffer_gets, disk_reads, direct_writes, rows_processed, fetches, executions, end_of_fetch_count, optimizer_cost, optimizer_env, NULL priority, command_type, NULL first_load_time, null stat_period, null active_stat_period, xmlelement( "other_attrs", xmlelement("parsing_user_id", parsing_user_id)).getClobVal() other, plan_hash_value, cast(NUL L as SQL_PLAN_TABLE_TYPE) sql_plan, cast (NULL as SQL_BINDS) bind_list FROM ((SELECT t1.sql_id, t1.force_matching_signature, sql_text, module, action, selap as ELAPSED_TIME, scpu as CPU_TIME, sbgets as BUFFER_GETS, swrites as DIRECT_WRITES, sdreads as DISK_READS, srow as ROWS_PROCESSED, sfetches as fetches, sexec as EXECUTIONS, seofc as end_of_fetch_count, optimizer_cost, optimizer_env, command_type, parsing_schema_name, parsing_user_id, T1.snap_id, T1.plan_hash_value, T1.dbid, loaded_versions, bind_data FROM (SELECT sql_id, force_matching_signature, action, module, snap_id, dbid, loaded_versions, instance_number, sql_text, command_type, optimizer_env, bind_data, parsing_schema_name, parsing_user_id, plan_hash_value, optimizer_cost FROM (SELECT s.snap_id, s.dbid, s.instance_number, s.sql_id, s.force_matching_signature, sql_text, t.command_type, module, action, fetches_delta as FETCHES, executions_delta as EXECUTIONS, end_of_fetch_count_ delta as END_OF_FETCH_COUNT, disk_reads_delta AS DISK_READS, direct_writes_delta DIRECT_WRITES, buffer_gets_delta as BUFFER_GETS, optimizer_env, rows_processed_delta as ROWS_PROCESSED, cpu_time_delta as CPU_TIME, elapsed_time_delta as ELAPSED_TIME, optimizer_cost, s.parsing_schema_name, s.parsing_user_id, plan_hash_value, loaded_versions, bind_data FROM DBA_HIST_SQLSTAT s, DBA_HIST_SQLTEXT t, DBA_HIST_OPTIMIZER_ENV e, V$DATABASE d WHERE s.sql_id = t.sql_id and s.dbid = t.dbid and s.dbid = e.dbid(+) and s.optimizer_env_hash_value = e.optimizer_env_hash_value(+) and s.dbid = d.dbid and /* only capture sqls with the full set of execution stats */ bitand(nvl(s.flag, 0), 1) = 0)) T1, (SELECT sql_id, plan_hash_value, sum(CPU_TIME) AS scpu, sum(BUFFER_GETS) AS sbgets, sum(DISK_READS) AS sdreads, sum(DIRECT_WRITES) AS swrites, sum(ROWS_PROCESSED) AS srow, sum(FETCHES) AS sfetches, sum(EXECUTIONS) AS sexec, sum(END_OF_FETCH_COUNT) AS seofc, sum(ELAPSED_TIME) AS sela p, MAX(SNAP_ID) KEEP (DENSE_RANK LAST ORDER BY ELAPSED_TIME) AS snap_id, MAX(INSTANCE_NUMBER) KEEP (DENSE_RANK LAST ORDER BY ELAPSED_TIME) AS instance_number FROM (SELECT s.snap_id, s.dbid, s.instance_number, s.sql_id, s.force_matching_signature, sql_text, t.command_type, module, action, fetches_delta as FETCHES, executions_delta as EXECUTIONS, end_of_fetch_count_delta as END_OF_FETCH_COUNT, disk_reads_delta AS DISK_READS, direct_writes_delta DIRECT_WRITES, buffer_gets_delta as BUFFER_GETS, optimizer_env, rows_processed_delta as ROWS_PROCESSED, cpu_time_delta as CPU_TIME, elapsed_time_delta as ELAPSED_TIME, optimizer_cost, s.parsing_schema_name, s.parsing_user_id, plan_hash_value, loaded_versions, bind_data FROM DBA_HIST_SQLSTAT s, DBA_HIST_SQLTEXT t, DBA_HIST_OPTIMIZER_ENV e, V$DATABASE d WHERE s.sql_id = t.sql_id and s.dbid = t.dbid and s.dbid = e.dbid(+) and s.optimizer_env_hash_value = e.optimizer_env_hash_value(+) and s.dbid = d.dbid and /* only captur e sqls with the full set of execution stats */ bitand(nvl(s.flag, 0), 1) = 0) WHERE snap_id >= :begin_snap and snap_id <= :end_snap AND command_type in (1, 2, 3, 6, 7, 189) AND sql_id = :sqlid AND plan_hash_value = :phv GROUP BY sql_id, plan_hash_value) T2 WHERE T1.sql_id = T2.sql_id AND T1.plan_hash_value = T2.plan_hash_value AND T1.snap_id = T2.snap_id AND T1.instance_number = T2.instance_number)) S )

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

4yvwyb5z5t8v9 BEGIN SP_ORA_INDEX_REBUILD_ALL_LAST; END;

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

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

5zruc4v6y32f9 DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN DECLARE ename VARCHAR2(30); BEGIN ename := dbms_sqltune.execute_tuning_task( 'SYS_AUTO_SQL_TUNING_TASK'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

6mcpb06rctk0x call dbms_space.auto_space_advisor_job_proc ( )

6vnnpvn0rzfku alter index IDX_4396828_GN_TDR_IMSI rebuild PARTITION P_20140218_187 online

7ac05552jb0v9 SELECT 'X' FROM SYS.LOADER_PART_INFO WHERE TNAME = :1 AND OWNER = :2 AND PARTTYPE = 3

7wgks43wrjtrz SELECT U.SPACE_USED, U.SPACE_ALLOCATED FROM TABLE(DBMS_SPACE.OBJECT_SPACE_USAGE_TBF( :B1 , :B2 , :B3 , 0, :B4 , 'TRUE', :B5 )) U

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

8nb6mg3u6buhq select pname, length(pname) from loader_part_info where parttype = 3 and tname = :1 and owner = :2

8szmwam7fysa3 insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))

9tgj4g8y4rwy8 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

9v9n97qj8z1dg delete /*+ dynamic_sampling(4) */ from sys.wri$_optstat_histhead_history where savtime < :1 and rownum <= NVL(:2, rownum)

a0wx5u9sbc6nk SELECT ROBJ# FROM SYS.CDEF$ WHERE OBJ# = :TABOBJNUM AND BITAND(DEFER, 512) = 512

adkvb8hry75c8 BEGIN sp_data_lifecycle; END;

b36m29qfaz4rq SELECT COUNT (distinct partname) FROM V$LOADPSTAT WHERE OWNER = :1 AND TABNAME = :2 AND PARTNAME IS NOT NULL

b46fndavjb1pj SELECT CONSTRAINT_NAME, TYPE, NVL(ENABLED, 0), DEFER FROM SYS.LOADER_CONSTRAINT_INFO WHERE TABLE_NAME = :1 AND OWNER = :2 AND (ENABLED = 1 OR BITAND(DEFER, 4) = 4) AND (TYPE IN (4, 1))

bd13sdj0ty0q4 SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJECT_TYPE = 'TABLE'

bj0up6yn660zx SELECT SUBPARTITION_NAME FROM SYS.ALL_TAB_SUBPARTITIONS WHERE TABLE_OWNER = :1 AND TABLE_NAME = :2 AND ALL_TAB_SUBPARTITIONS.SUBPARTITION_NAME = :3 ORDER BY SUBPARTITION_NAME

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

bsa0wjtftg3uw select file# from file$ where ts#=:1

bzcf02fmx1fxu SELECT O.NAME, U.NAME FROM SYS.OBJ$ O, SYS.USER$ U WHERE U.USER# = O.OWNER# AND O.OBJ# = :TABOBJNUM

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

cqkgg81x3jvvf alter index IDX_4394791_FLOW_TDR_MSISDN rebuild PARTITION P_20140218_188 online

cv86y224b08ab SELECT TRIGGER_OWNER, TRIGGER_NAME FROM SYS.LOADER_TRIGGER_INFO WHERE TABLE_NAME = :1 AND TABLE_OWNER = :2 AND ENABLED = 1 ORDER BY TRIGGER_OWNER, TRIGGER_NAME

d247u0jp3z8ws SELECT DECODE(COUNT(*), 0, 0, 1) FROM SYS.LOADER_NESTED_VARRAYS WHERE TABLE_NAME = :tname AND TABLE_OWNER = :owner

dutdz1c6ub304 SELECT DECODE(COUNT(*), 0, 0, 1) FROM SYS.ALL_TAB_COLS WHERE TABLE_NAME = :tname AND OWNER = :owner AND COLUMN_NAME = 'SYS_NC_TYPEID$'

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'

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

gdpn6rzn2rdtd alter index IDX_4394791_FLOW_TDR_MSISDN rebuild PARTITION P_20140218_264 online

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
05k5qtcfz4uf7	SELECT DISTINCT INDEXNAME, SUBNAME, MESSAGE, MESSAGE_NUM FROM V$LOADISTAT WHERE OWNER = :1 AND TABNAME = :2 ORDER BY INDEXNAME, SUBNAME
05s9358mm6vrr	begin dbms_feature_usage_internal.exec_db_usage_sampling(:bind1); end;
07rw9znc8g7aj	SELECT DECODE(COUNT(*), 0, 0, 1) FROM SYS.ALL_VIEWS WHERE VIEW_NAME = :tname AND OWNER = :owner
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
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')
130dvvr5s8bgn	select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part#
15jnrrb6016nd	SELECT SESSIONTIMEZONE, LENGTH(SESSIONTIMEZONE) FROM SYS.DUAL
21czn90vsncd6	select 1 from rls$ r, obj$ o, user$ u where r.enable_flag=1 and bitand(r.stmt_type, 2)=2 and r.obj#=o.obj# and o.owner#=u.user# and u.name= :1 and o.name= :2
2p7c1wy5dwfbm	BEGIN SP_ORA_INDEX_REBUILD_ALL; END;
3nv2uwsnw0j27	SELECT distinct PARTNAME, LOADED FROM V$LOADPSTAT WHERE OWNER = :1 AND TABNAME = :2 AND PARTNAME IS NOT NULL ORDER BY PARTNAME
3w54wsybgw0sc	SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL
424h0nf7bhqzd	SELECT sqlset_row(sql_id, force_matching_signature, sql_text, object_list, bind_data, parsing_schema_name, module, action, elapsed_time, cpu_time, buffer_gets, disk_reads, direct_writes, rows_processed, fetches, executions, end_of_fetch_count, optimizer_cost, optimizer_env, priority, command_type, first_load_time, stat_period, active_stat_period, other, plan_hash_value, sql_plan, bind_list) FROM ( SELECT /+ first_rows(1) / sql_id, force_matching_signature, sql_text, cast(NULL as SQL_OBJECTS) object_list, bind_data, parsing_schema_name, module, action, elapsed_time, cpu_time, buffer_gets, disk_reads, direct_writes, rows_processed, fetches, executions, end_of_fetch_count, optimizer_cost, optimizer_env, NULL priority, command_type, NULL first_load_time, null stat_period, null active_stat_period, xmlelement( "other_attrs", xmlelement("parsing_user_id", parsing_user_id)).getClobVal() other, plan_hash_value, cast(NUL L as SQL_PLAN_TABLE_TYPE) sql_plan, cast (NULL as SQL_BINDS) bind_list FROM ((SELECT t1.sql_id, t1.force_matching_signature, sql_text, module, action, selap as ELAPSED_TIME, scpu as CPU_TIME, sbgets as BUFFER_GETS, swrites as DIRECT_WRITES, sdreads as DISK_READS, srow as ROWS_PROCESSED, sfetches as fetches, sexec as EXECUTIONS, seofc as end_of_fetch_count, optimizer_cost, optimizer_env, command_type, parsing_schema_name, parsing_user_id, T1.snap_id, T1.plan_hash_value, T1.dbid, loaded_versions, bind_data FROM (SELECT sql_id, force_matching_signature, action, module, snap_id, dbid, loaded_versions, instance_number, sql_text, command_type, optimizer_env, bind_data, parsing_schema_name, parsing_user_id, plan_hash_value, optimizer_cost FROM (SELECT s.snap_id, s.dbid, s.instance_number, s.sql_id, s.force_matching_signature, sql_text, t.command_type, module, action, fetches_delta as FETCHES, executions_delta as EXECUTIONS, end_of_fetch_count_ delta as END_OF_FETCH_COUNT, disk_reads_delta AS DISK_READS, direct_writes_delta DIRECT_WRITES, buffer_gets_delta as BUFFER_GETS, optimizer_env, rows_processed_delta as ROWS_PROCESSED, cpu_time_delta as CPU_TIME, elapsed_time_delta as ELAPSED_TIME, optimizer_cost, s.parsing_schema_name, s.parsing_user_id, plan_hash_value, loaded_versions, bind_data FROM DBA_HIST_SQLSTAT s, DBA_HIST_SQLTEXT t, DBA_HIST_OPTIMIZER_ENV e, V$DATABASE d WHERE s.sql_id = t.sql_id and s.dbid = t.dbid and s.dbid = e.dbid(+) and s.optimizer_env_hash_value = e.optimizer_env_hash_value(+) and s.dbid = d.dbid and /* only capture sqls with the full set of execution stats / bitand(nvl(s.flag, 0), 1) = 0)) T1, (SELECT sql_id, plan_hash_value, sum(CPU_TIME) AS scpu, sum(BUFFER_GETS) AS sbgets, sum(DISK_READS) AS sdreads, sum(DIRECT_WRITES) AS swrites, sum(ROWS_PROCESSED) AS srow, sum(FETCHES) AS sfetches, sum(EXECUTIONS) AS sexec, sum(END_OF_FETCH_COUNT) AS seofc, sum(ELAPSED_TIME) AS sela p, MAX(SNAP_ID) KEEP (DENSE_RANK LAST ORDER BY ELAPSED_TIME) AS snap_id, MAX(INSTANCE_NUMBER) KEEP (DENSE_RANK LAST ORDER BY ELAPSED_TIME) AS instance_number FROM (SELECT s.snap_id, s.dbid, s.instance_number, s.sql_id, s.force_matching_signature, sql_text, t.command_type, module, action, fetches_delta as FETCHES, executions_delta as EXECUTIONS, end_of_fetch_count_delta as END_OF_FETCH_COUNT, disk_reads_delta AS DISK_READS, direct_writes_delta DIRECT_WRITES, buffer_gets_delta as BUFFER_GETS, optimizer_env, rows_processed_delta as ROWS_PROCESSED, cpu_time_delta as CPU_TIME, elapsed_time_delta as ELAPSED_TIME, optimizer_cost, s.parsing_schema_name, s.parsing_user_id, plan_hash_value, loaded_versions, bind_data FROM DBA_HIST_SQLSTAT s, DBA_HIST_SQLTEXT t, DBA_HIST_OPTIMIZER_ENV e, V$DATABASE d WHERE s.sql_id = t.sql_id and s.dbid = t.dbid and s.dbid = e.dbid(+) and s.optimizer_env_hash_value = e.optimizer_env_hash_value(+) and s.dbid = d.dbid and / only captur e sqls with the full set of execution stats */ bitand(nvl(s.flag, 0), 1) = 0) WHERE snap_id >= :begin_snap and snap_id <= :end_snap AND command_type in (1, 2, 3, 6, 7, 189) AND sql_id = :sqlid AND plan_hash_value = :phv GROUP BY sql_id, plan_hash_value) T2 WHERE T1.sql_id = T2.sql_id AND T1.plan_hash_value = T2.plan_hash_value AND T1.snap_id = T2.snap_id AND T1.instance_number = T2.instance_number)) S )
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4yvwyb5z5t8v9	BEGIN SP_ORA_INDEX_REBUILD_ALL_LAST; END;
4z554v42crjkn	SELECT DECODE(NESTED, 'YES', 1, 0) FROM SYS.ALL_OBJECT_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner
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
5zruc4v6y32f9	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN DECLARE ename VARCHAR2(30); BEGIN ename := dbms_sqltune.execute_tuning_task( 'SYS_AUTO_SQL_TUNING_TASK'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6mcpb06rctk0x	call dbms_space.auto_space_advisor_job_proc ( )
6vnnpvn0rzfku	alter index IDX_4396828_GN_TDR_IMSI rebuild PARTITION P_20140218_187 online
7ac05552jb0v9	SELECT 'X' FROM SYS.LOADER_PART_INFO WHERE TNAME = :1 AND OWNER = :2 AND PARTTYPE = 3
7wgks43wrjtrz	SELECT U.SPACE_USED, U.SPACE_ALLOCATED FROM TABLE(DBMS_SPACE.OBJECT_SPACE_USAGE_TBF( :B1 , :B2 , :B3 , 0, :B4 , 'TRUE', :B5 )) U
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
8nb6mg3u6buhq	select pname, length(pname) from loader_part_info where parttype = 3 and tname = :1 and owner = :2
8szmwam7fysa3	insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
9v9n97qj8z1dg	delete /+ dynamic_sampling(4) / from sys.wri$_optstat_histhead_history where savtime < :1 and rownum <= NVL(:2, rownum)
a0wx5u9sbc6nk	SELECT ROBJ# FROM SYS.CDEF$ WHERE OBJ# = :TABOBJNUM AND BITAND(DEFER, 512) = 512
adkvb8hry75c8	BEGIN sp_data_lifecycle; END;
b36m29qfaz4rq	SELECT COUNT (distinct partname) FROM V$LOADPSTAT WHERE OWNER = :1 AND TABNAME = :2 AND PARTNAME IS NOT NULL
b46fndavjb1pj	SELECT CONSTRAINT_NAME, TYPE, NVL(ENABLED, 0), DEFER FROM SYS.LOADER_CONSTRAINT_INFO WHERE TABLE_NAME = :1 AND OWNER = :2 AND (ENABLED = 1 OR BITAND(DEFER, 4) = 4) AND (TYPE IN (4, 1))
bd13sdj0ty0q4	SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJECT_TYPE = 'TABLE'
bj0up6yn660zx	SELECT SUBPARTITION_NAME FROM SYS.ALL_TAB_SUBPARTITIONS WHERE TABLE_OWNER = :1 AND TABLE_NAME = :2 AND ALL_TAB_SUBPARTITIONS.SUBPARTITION_NAME = :3 ORDER BY SUBPARTITION_NAME
bjstq78pprd24	SELECT DECODE(ELEMENT_SUBSTITUTABLE, ' Y', 1, 0) FROM SYS.ALL_NESTED_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner
bsa0wjtftg3uw	select file# from file$ where ts#=:1
bzcf02fmx1fxu	SELECT O.NAME, U.NAME FROM SYS.OBJ$ O, SYS.USER$ U WHERE U.USER# = O.OWNER# AND O.OBJ# = :TABOBJNUM
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cqkgg81x3jvvf	alter index IDX_4394791_FLOW_TDR_MSISDN rebuild PARTITION P_20140218_188 online
cv86y224b08ab	SELECT TRIGGER_OWNER, TRIGGER_NAME FROM SYS.LOADER_TRIGGER_INFO WHERE TABLE_NAME = :1 AND TABLE_OWNER = :2 AND ENABLED = 1 ORDER BY TRIGGER_OWNER, TRIGGER_NAME
d247u0jp3z8ws	SELECT DECODE(COUNT(*), 0, 0, 1) FROM SYS.LOADER_NESTED_VARRAYS WHERE TABLE_NAME = :tname AND TABLE_OWNER = :owner
dutdz1c6ub304	SELECT DECODE(COUNT(*), 0, 0, 1) FROM SYS.ALL_TAB_COLS WHERE TABLE_NAME = :tname AND OWNER = :owner AND COLUMN_NAME = 'SYS_NC_TYPEID$'
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'
fhzj09a7fnrnb	SELECT DBTIMEZONE, LENGTH(DBTIMEZONE) FROM SYS.DUAL
gdpn6rzn2rdtd	alter index IDX_4394791_FLOW_TDR_MSISDN rebuild PARTITION P_20140218_264 online
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

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	895	0.02	0.02
Batched IO (full) vector count	4	0.00	0.00
Batched IO block miss count	4,228	0.08	0.08
Batched IO buffer defrag count	10	0.00	0.00
Batched IO double miss count	28	0.00	0.00
Batched IO same unit count	1,914	0.04	0.03
Batched IO single block count	827	0.02	0.01
Batched IO slow jump count	54	0.00	0.00
Batched IO vector block count	1,491	0.03	0.03
Batched IO vector read count	73	0.00	0.00
Block Cleanout Optim referenced	21	0.00	0.00
CCursor + sql area evicted	332	0.01	0.01
CPU used by this session	2,728,941	54.12	49.36
CPU used when call started	2,711,158	53.76	49.04
CR blocks created	315,222	6.25	5.70
Cached Commit SCN referenced	18,157,635	360.07	328.42
Commit SCN cached	133,233	2.64	2.41
DB time	5,471,899	108.51	98.97
DBWR checkpoint buffers written	727,492	14.43	13.16
DBWR checkpoints	15,876	0.31	0.29
DBWR object drop buffers written	59,278	1.18	1.07
DBWR transaction table writes	1,822	0.04	0.03
DBWR undo block writes	199,204	3.95	3.60
DDL statements parallelized	32	0.00	0.00
DFO trees parallelized	32	0.00	0.00
Effective IO time	22,844	0.45	0.41
HSC Heap Segment Block Changes	1,478,590	29.32	26.74
HSC IDL Compressed Blocks	9,937,627	197.07	179.74
Heap Segment Array Inserts	1,092	0.02	0.02
Heap Segment Array Updates	911,789	18.08	16.49
IMU CR rollbacks	4	0.00	0.00
IMU Flushes	53,345	1.06	0.96
IMU Redo allocation size	1,937,684	38.43	35.05
IMU commits	53,635	1.06	0.97
IMU contention	125	0.00	0.00
IMU ktichg flush	21	0.00	0.00
IMU pool not allocated	26	0.00	0.00
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	82,055,160	1,627.19	1,484.14
IMU- failed to get a private strand	26	0.00	0.00
LOB table id lookup cache misses	3	0.00	0.00
Number of read IOs issued	4	0.00	0.00
PX local messages recv'd	3,938	0.08	0.07
PX local messages sent	3,938	0.08	0.07
Parallel operations not downgraded	32	0.00	0.00
Requests to/from client	6,238,975	123.72	112.85
RowCR attempts	22,081	0.44	0.40
RowCR hits	22,384	0.44	0.40
SQL*Net roundtrips to/from client	6,238,988	123.72	112.85
active txn count during cleanout	5,457	0.11	0.10
application wait time	1,168	0.02	0.02
background checkpoints completed	7	0.00	0.00
background checkpoints started	7	0.00	0.00
background timeouts	255,982	5.08	4.63
buffer is not pinned count	224,924,833	4,460.35	4,068.24
buffer is pinned count	192,870,833	3,824.71	3,488.48
bytes received via SQL*Net from client	331,876,566,885	6,581,247.72	6,002,687.15
bytes sent via SQL*Net to client	2,429,767,424	48,183.28	43,947.46
calls to get snapshot scn: kcmgss	9,233,044	183.10	167.00
calls to kcmgas	9,734,633	193.04	176.07
calls to kcmgcs	2,704,625	53.63	48.92
cell physical IO interconnect bytes	973,559,605,760	19,306,084.17	17,608,877.26
change write time	66,953	1.33	1.21
cleanout - number of ktugct calls	139,278	2.76	2.52
cleanouts and rollbacks - consistent read gets	1,731	0.03	0.03
cleanouts only - consistent read gets	133,773	2.65	2.42
cluster key scan block gets	5,321,028	105.52	96.24
cluster key scans	4,286,340	85.00	77.53
commit batch performed	117	0.00	0.00
commit batch requested	117	0.00	0.00
commit batch/immediate performed	225,598	4.47	4.08
commit batch/immediate requested	225,598	4.47	4.08
commit cleanout failures: block lost	311	0.01	0.01
commit cleanout failures: buffer being written	5	0.00	0.00
commit cleanout failures: callback failure	164	0.00	0.00
commit cleanout failures: cannot pin	1,287	0.03	0.02
commit cleanouts	1,661,881	32.96	30.06
commit cleanouts successfully completed	1,660,114	32.92	30.03
commit immediate performed	225,481	4.47	4.08
commit immediate requested	225,481	4.47	4.08
commit txn count during cleanout	135,648	2.69	2.45
concurrency wait time	4,673	0.09	0.08
consistent changes	595,772	11.81	10.78
consistent gets	204,457,756	4,054.48	3,698.05
consistent gets - examination	108,422,989	2,150.07	1,961.06
consistent gets direct	83	0.00	0.00
consistent gets from cache	204,457,673	4,054.48	3,698.05
consistent gets from cache (fastpath)	91,878,454	1,821.99	1,661.82
cursor authentications	2,500	0.05	0.05
data blocks consistent reads - undo records applied	134,249	2.66	2.43
db block changes	25,943,779	514.48	469.25
db block gets	41,567,722	824.30	751.84
db block gets direct	8,950,948	177.50	161.90
db block gets from cache	32,616,774	646.80	589.94
db block gets from cache (fastpath)	9,530,605	189.00	172.38
deferred (CURRENT) block cleanout applications	1,211,445	24.02	21.91
dirty buffers inspected	2,927	0.06	0.05
enqueue conversions	1,051,860	20.86	19.03
enqueue releases	6,579,263	130.47	119.00
enqueue requests	6,597,928	130.84	119.34
enqueue timeouts	18,653	0.37	0.34
enqueue waits	114,372	2.27	2.07
exchange deadlocks	20	0.00	0.00
execute count	6,597,020	130.82	119.32
file io wait time	7,673,546,371	152,169.56	138,792.26
free buffer inspected	3,279,355	65.03	59.31
free buffer requested	21,254,998	421.50	384.44
heap block compress	1,890	0.04	0.03
hot buffers moved to head of LRU	264,110	5.24	4.78
immediate (CR) block cleanout applications	135,504	2.69	2.45
immediate (CURRENT) block cleanout applications	195,941	3.89	3.54
in call idle wait time	144,902,260	2,873.47	2,620.86
index crx upgrade (positioned)	3,389	0.07	0.06
index crx upgrade (prefetch)	1	0.00	0.00
index fast full scans (full)	116,540	2.31	2.11
index fetch by key	942,319,334	18,686.58	17,043.83
index scans kdiixs1	112,668,322	2,234.26	2,037.84
leaf node 90-10 splits	75	0.00	0.00
leaf node splits	211	0.00	0.00
lob reads	1,901	0.04	0.03
lob writes	11,827	0.23	0.21
lob writes unaligned	11,827	0.23	0.21
logical read bytes from cache	7,768,454,823,936	154,051,628.47	140,508,877.59
logons cumulative	53,595	1.06	0.97
max cf enq hold time	144	0.00	0.00
messages received	2,970,151	58.90	53.72
messages sent	2,970,151	58.90	53.72
min active SCN optimization applied on CR	491	0.01	0.01
no buffer to keep pinned count	2	0.00	0.00
no work - consistent read gets	92,709,492	1,838.47	1,676.85
non-idle wait count	14,205,464	281.70	256.94
non-idle wait time	1,294,591	25.67	23.42
opened cursors cumulative	6,497,642	128.85	117.52
parse count (describe)	80	0.00	0.00
parse count (failures)	3,615	0.07	0.07
parse count (hard)	20,002	0.40	0.36
parse count (total)	2,283,313	45.28	41.30
parse time cpu	10,612	0.21	0.19
parse time elapsed	43,531	0.86	0.79
physical read IO requests	1,436,866	28.49	25.99
physical read bytes	618,340,974,592	12,261,953.79	11,183,999.69
physical read total IO requests	1,503,910	29.82	27.20
physical read total bytes	625,729,492,480	12,408,471.12	11,317,636.60
physical read total multi block requests	626,635	12.43	11.33
physical reads	18,870,269	374.21	341.31
physical reads cache	18,867,939	374.16	341.27
physical reads cache prefetch	17,434,819	345.74	315.35
physical reads direct	2,330	0.05	0.04
physical reads direct (lob)	4	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical write IO requests	3,805,992	75.47	68.84
physical write bytes	333,038,190,592	6,604,283.19	6,023,697.56
physical write total IO requests	7,005,373	138.92	126.71
physical write total bytes	347,830,113,280	6,897,613.05	6,291,240.65
physical write total multi block requests	1,020,382	20.23	18.46
physical writes	10,163,519	201.55	183.83
physical writes direct	8,951,788	177.52	161.91
physical writes direct (lob)	100	0.00	0.00
physical writes direct temporary tablespace	98	0.00	0.00
physical writes from cache	1,211,731	24.03	21.92
physical writes non checkpoint	10,002,926	198.36	180.92
pinned buffers inspected	35	0.00	0.00
process last non-idle time	50,470	1.00	0.91
recursive calls	38,382,917	761.15	694.24
recursive cpu usage	1,217,032	24.13	22.01
redo KB read	6,199,225	122.93	112.13
redo blocks checksummed by FG (exclusive)	5,863,445	116.27	106.05
redo blocks written	13,248,743	262.73	239.63
redo buffer allocation retries	6	0.00	0.00
redo entries	20,946,819	415.38	378.87
redo log space requests	8	0.00	0.00
redo log space wait time	17	0.00	0.00
redo ordering marks	327	0.01	0.01
redo size	6,103,496,216	121,034.82	110,394.59
redo size for direct writes	173,524,908	3,441.07	3,138.56
redo subscn max counts	227,765	4.52	4.12
redo synch long waits	2	0.00	0.00
redo synch time	1,497	0.03	0.03
redo synch time (usec)	87,765,370	1,740.42	1,587.42
redo synch writes	409,136	8.11	7.40
redo wastage	458,106,896	9,084.45	8,285.83
redo write time	57,234	1.13	1.04
redo writes	1,544,588	30.63	27.94
rollback changes - undo records applied	6	0.00	0.00
rollbacks only - consistent read gets	1,529	0.03	0.03
rows fetched via callback	65,104,047	1,291.04	1,177.54
session connect time	18,018	0.36	0.33
session cursor cache hits	3,553,056	70.46	64.26
session logical reads	246,025,478	4,878.79	4,449.89
shared hash latch upgrades - no wait	1,407,838	27.92	25.46
shared hash latch upgrades - wait	1,234	0.02	0.02
sorts (memory)	668,643	13.26	12.09
sorts (rows)	5,429,104,117	107,661.35	98,196.79
sql area evicted	332	0.01	0.01
sql area purged	4,682	0.09	0.08
summed dirty queue length	8,498	0.17	0.15
switch current to new buffer	1,091,137	21.64	19.74
table fetch by rowid	176,961,919	3,509.23	3,200.73
table fetch continued row	5,524	0.11	0.10
table scan blocks gotten	20,777,268	412.02	375.80
table scan rows gotten	5,773,936,857	114,499.52	104,433.82
table scans (long tables)	556	0.01	0.01
table scans (short tables)	179,682	3.56	3.25
temp space allocated (bytes)	4,194,304	83.17	75.86
total cf enq hold time	6,822	0.14	0.12
total number of cf enq holders	2,039	0.04	0.04
total number of times SMON posted	8,343	0.17	0.15
transaction rollbacks	8,310	0.16	0.15
undo change vector size	3,659,990,672	72,579.11	66,198.64
user I/O wait time	755,583	14.98	13.67
user calls	9,778,789	193.92	176.87
user commits	55,171	1.09	1.00
user rollbacks	117	0.00	0.00
workarea executions - optimal	445,485	8.83	8.06
write clones created in background	65,657	1.30	1.19
write clones created in foreground	70	0.00	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
session pga memory max	110,260,464	670,378,704
session cursor cache count	84,482	2,112,183
session uga memory	123,164,288	556,920,821,560
opened cursors current	35	46
workarea memory allocated	1,060	1,330
logons current	32	41
session uga memory max	3,342,280,192	87,668,842,360
session pga memory	67,268,848	378,546,896

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)	7	0.50

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)
Buffer Cache Reads	575.8G	28.45	11.6923	0M	0.00	0M	1433K	4.76
Direct Writes	0M	0.00	0M	261.8G	61.38	5.31558	0
DBWR	0M	0.00	0M	37G	12.17	.750759	0
Others	6.9G	1.33	.139744	12.5G	3.40	.254662	85.8K	0.26
LGWR	2M	0.00	.000039	12.6G	61.97	.256625	1544.8K	0.03
Direct Reads	70M	0.04	.001388	10M	0.01	.000198	0
TOTAL:	582.8G	29.82	11.8335	323.9G	138.92	6.57782	3063.6K	2.25

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	576G	28.53	11.6954	310.2G	75.47	6.29819	2.10	8.29
Log File	5.9G	0.12	.120251	12.6G	61.96	.256565	3.78	14.85
Control File	921M	1.17	.018263	1.1G	1.48	.023161	0.13
Temp File	3M	0.00	.000059	3M	0.00	.000059	0.00	0.75
TOTAL:	582.8G	29.82	11.8340	323.9G	138.92	6.57798	1.96	8.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)
Buffer Cache Reads	575.8G	28.44	11.6923	0M	0.00	0M	1432.9K	4.76
Buffer Cache Reads (Data File)	575.8G	28.44	11.6923	0M	0.00	0M	1432.9K	4.76
Direct Writes	0M	0.00	0M	261.8G	61.38	5.31554	0
Direct Writes (Data File)	0M	0.00	0M	261.8G	61.38	5.31554	0
DBWR	0M	0.00	0M	37G	12.17	.750719	0
DBWR (Data File)	0M	0.00	0M	37G	12.17	.750719	0
Others	983M	1.21	.019493	12.5G	3.40	.254642	60.9K	0.33
Others (Data File)	63M	0.04	.001249	11.4G	1.92	.231539	2029	6.05
Others (Control File)	920M	1.17	.018243	1.1G	1.48	.023102	58.8K	0.13
LGWR	2M	0.00	.000039	12.6G	61.97	.256625	178	1.25
LGWR (Log File)	0M	0.00	0M	12.6G	61.96	.256565	56	1.96
LGWR (Control File)	2M	0.00	.000039	3M	0.00	.000059	122	0.92
TOTAL:	576.8G	29.65	11.7118	323.9G	138.91	6.57752	1494K	4.58

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
DATA_0000	1,386,161	27	5.20	13.58	1,409,274	28	81	0.12
IDX_0000	34,737	1	1.46	1.00	2,328,317	46	1	0.00
UNDOTBS1	10	0	4.00	1.00	57,709	1	2,020	0.11
SYSAUX	9,347	0	6.36	1.10	4,526	0	0	0.00
SYSTEM	6,678	0	6.09	1.21	6,055	0	3,200	0.37
ZXT_DATA	77	0	5.45	1.08	21	0	0	0.00
ZXT_IDX	21	0	0.00	1.00	21	0	0	0.00
TEMP	13	0	0.77	7.46	26	0	0	0.00
USERS	7	0	0.00	1.00	7	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
DATA_0000	/oradb1/NTP2000/ora_data0.dbf	17,326	0	4.70	13.47	3,947	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data1.dbf	16,083	0	4.27	13.45	3,833	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data10.dbf	5,289	0	7.60	17.46	33	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data11.dbf	6,234	0	7.34	17.14	42	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data12.dbf	17,645	0	4.93	14.63	2,439	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data13.dbf	16,953	0	4.53	14.62	2,129	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data14.dbf	16,195	0	4.52	14.34	1,891	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data15.dbf	16,350	0	4.26	13.84	1,833	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data16.dbf	14,864	0	4.41	14.27	1,811	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data17.dbf	15,247	0	4.89	13.37	1,766	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data18.dbf	33,391	1	6.95	15.35	79,639	2	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data19.dbf	41,967	1	4.36	12.83	30,120	1	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data2.dbf	15,234	0	4.15	13.46	3,618	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data3.dbf	14,557	0	4.07	13.25	3,399	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data4.dbf	14,555	0	3.87	12.83	3,038	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data5.dbf	13,094	0	3.98	13.39	2,766	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data6.dbf	1,189	0	10.02	18.23	32	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data7.dbf	3,427	0	8.20	16.58	29	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data8.dbf	3,925	0	7.45	18.15	27	0	0	0.00
DATA_0000	/oradb1/NTP2000/ora_data9.dbf	4,474	0	7.66	18.13	23	0	0	0.00
DATA_0000	/oradb2/NTP2000/ora_data0.dbf	28,594	1	5.73	17.75	32,639	1	0	0.00
DATA_0000	/oradb2/NTP2000/ora_data1.dbf	42,848	1	5.23	14.78	24,042	0	0	0.00
DATA_0000	/oradb2/NTP2000/ora_data10.dbf	26,123	1	5.16	15.64	64,147	1	2	0.00
DATA_0000	/oradb2/NTP2000/ora_data11.dbf	18,809	0	5.63	15.55	54,866	1	0	0.00
DATA_0000	/oradb2/NTP2000/ora_data12.dbf	17,006	0	4.88	14.00	90,588	2	0	0.00
DATA_0000	/oradb2/NTP2000/ora_data13.dbf	24,475	0	4.11	8.98	43,735	1	4	0.00
DATA_0000	/oradb2/NTP2000/ora_data14.dbf	24,339	0	5.14	11.05	151,192	3	4	0.00
DATA_0000	/oradb2/NTP2000/ora_data15.dbf	17,068	0	4.45	14.21	66,797	1	1	0.00
DATA_0000	/oradb2/NTP2000/ora_data16.dbf	15,712	0	4.73	14.11	54,135	1	0	0.00
DATA_0000	/oradb2/NTP2000/ora_data17.dbf	22,600	0	5.51	14.13	32,640	1	0	0.00
DATA_0000	/oradb2/NTP2000/ora_data18.dbf	5,915	0	3.86	1.18	21,756	0	0	0.00
DATA_0000	/oradb2/NTP2000/ora_data19.dbf	29,305	1	5.39	14.23	20,548	0	0	0.00
DATA_0000	/oradb2/NTP2000/ora_data2.dbf	36,049	1	5.03	15.54	24,832	0	0	0.00
DATA_0000	/oradb2/NTP2000/ora_data3.dbf	25,792	1	5.34	16.99	11,151	0	0	0.00
DATA_0000	/oradb2/NTP2000/ora_data4.dbf	25,796	1	4.49	15.66	11,558	0	0	0.00
DATA_0000	/oradb2/NTP2000/ora_data5.dbf	21,491	0	5.10	17.58	8,572	0	0	0.00
DATA_0000	/oradb2/NTP2000/ora_data6.dbf	19,266	0	5.43	14.72	9,273	0	0	0.00
DATA_0000	/oradb2/NTP2000/ora_data7.dbf	28,232	1	7.67	17.11	101,918	2	17	0.00
DATA_0000	/oradb2/NTP2000/ora_data8.dbf	34,589	1	5.51	16.09	77,781	2	17	0.00
DATA_0000	/oradb2/NTP2000/ora_data9.dbf	25,950	1	6.19	18.87	70,636	1	8	1.25
DATA_0000	/oradb3/NTP2000/ora_data0.dbf	13,409	0	4.55	7.39	14,307	0	0	0.00
DATA_0000	/oradb3/NTP2000/ora_data1.dbf	14,958	0	5.00	4.02	15,525	0	0	0.00
DATA_0000	/oradb3/NTP2000/ora_data10.dbf	19,070	0	5.38	14.01	19,285	0	2	0.00
DATA_0000	/oradb3/NTP2000/ora_data11.dbf	16,732	0	4.96	14.28	14,456	0	0	0.00
DATA_0000	/oradb3/NTP2000/ora_data12.dbf	14,985	0	5.29	14.46	10,625	0	0	0.00
DATA_0000	/oradb3/NTP2000/ora_data13.dbf	14,661	0	4.59	13.64	8,692	0	0	0.00
DATA_0000	/oradb3/NTP2000/ora_data14.dbf	17,356	0	5.65	14.50	7,378	0	0	0.00
DATA_0000	/oradb3/NTP2000/ora_data15.dbf	19,750	0	4.42	13.78	6,620	0	0	0.00
DATA_0000	/oradb3/NTP2000/ora_data16.dbf	19,342	0	4.61	14.11	6,846	0	0	0.00
DATA_0000	/oradb3/NTP2000/ora_data17.dbf	11,529	0	9.86	18.22	243	0	0	0.00
DATA_0000	/oradb3/NTP2000/ora_data18.dbf	357	0	10.14	18.11	197	0	0	0.00
DATA_0000	/oradb3/NTP2000/ora_data19.dbf	686	0	5.99	16.00	137	0	0	0.00
DATA_0000	/oradb3/NTP2000/ora_data2.dbf	45,050	1	7.01	15.89	17,377	0	0	0.00
DATA_0000	/oradb3/NTP2000/ora_data3.dbf	81,389	2	4.14	7.23	67,348	1	17	0.00
DATA_0000	/oradb3/NTP2000/ora_data4.dbf	29,752	1	7.04	19.19	16,631	0	0	0.00
DATA_0000	/oradb3/NTP2000/ora_data5.dbf	1,458	0	8.80	15.82	876	0	0	0.00
DATA_0000	/oradb3/NTP2000/ora_data6.dbf	1,899	0	7.66	12.12	10,155	0	1	0.00
DATA_0000	/oradb3/NTP2000/ora_data7.dbf	27,622	1	5.52	14.66	7,821	0	3	0.00
DATA_0000	/oradb3/NTP2000/ora_data8.dbf	20,450	0	6.41	17.29	14,534	0	3	0.00
DATA_0000	/oradb3/NTP2000/ora_data9.dbf	25,612	1	5.92	13.06	25,998	1	2	0.00
DATA_0000	/oradb4/NTP2000/ora_data0.dbf	27,023	1	2.78	1.37	784	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data1.dbf	1,767	0	5.96	4.33	543	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data10.dbf	237	0	3.97	1.13	170	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data11.dbf	50	0	1.80	1.62	47	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data12.dbf	80	0	3.50	1.38	66	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data13.dbf	8,219	0	4.42	7.33	1,179	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data14.dbf	30,911	1	6.34	15.69	4,249	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data15.dbf	55	0	2.36	1.00	60	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data16.dbf	22,950	0	5.23	14.52	89	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data17.dbf	23,347	0	5.37	15.84	5,055	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data18.dbf	21,295	0	4.96	14.58	4,738	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data19.dbf	18,102	0	4.89	14.69	4,279	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data2.dbf	850	0	5.29	6.21	402	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data3.dbf	437	0	6.00	8.60	244	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data4.dbf	403	0	7.97	4.11	96	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data5.dbf	10,877	0	3.07	1.00	501	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data6.dbf	10,616	0	2.70	1.00	45	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data7.dbf	5,462	0	2.44	1.00	56	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data8.dbf	12,589	0	4.73	8.45	2,313	0	0	0.00
DATA_0000	/oradb4/NTP2000/ora_data9.dbf	70	0	3.00	1.44	53	0	0	0.00
DATA_0000	/oradb6/NTP2000/ora_data0.dbf	16,796	0	4.65	14.45	4,033	0	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx0.dbf	52	0	6.35	1.00	58,044	1	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx1.dbf	33	0	6.06	1.00	63,449	1	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx10.dbf	68	0	8.24	1.00	77,949	2	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx11.dbf	28	0	6.79	1.00	74,961	1	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx12.dbf	32	0	5.00	1.00	74,301	1	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx13.dbf	23,836	0	0.52	1.00	102,016	2	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx14.dbf	622	0	2.85	1.00	96,272	2	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx15.dbf	50	0	6.00	1.00	91,888	2	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx16.dbf	3,643	0	3.08	1.00	94,323	2	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx17.dbf	27	0	5.19	1.00	106,953	2	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx18.dbf	481	0	3.10	1.00	100,151	2	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx19.dbf	34	0	6.47	1.00	92,669	2	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx2.dbf	46	0	6.74	1.00	61,839	1	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx20.dbf	32	0	6.25	1.00	93,898	2	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx21.dbf	38	0	6.84	1.00	92,010	2	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx22.dbf	33	0	5.76	1.00	84,581	2	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx23.dbf	29	0	5.52	1.00	80,506	2	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx24.dbf	31	0	6.13	1.00	78,126	2	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx25.dbf	43	0	5.81	1.00	72,813	1	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx26.dbf	41	0	6.83	1.00	62,538	1	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx27.dbf	1,590	0	4.34	1.00	62,786	1	1	0.00
IDX_0000	/oradb5/NTP2000/ora_idx28.dbf	181	0	5.36	1.00	59,773	1	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx29.dbf	36	0	6.67	1.00	59,636	1	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx3.dbf	1,717	0	3.42	1.00	57,188	1	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx4.dbf	364	0	1.98	1.00	59,704	1	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx5.dbf	1,417	0	2.58	1.00	62,613	1	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx6.dbf	65	0	7.85	1.00	62,639	1	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx7.dbf	54	0	5.93	1.00	74,306	1	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx8.dbf	57	0	6.84	1.00	87,421	2	0	0.00
IDX_0000	/oradb5/NTP2000/ora_idx9.dbf	57	0	5.26	1.00	82,964	2	0	0.00
SYSAUX	/oradata/NTP2000/sysaux01.dbf	9,347	0	6.36	1.10	4,526	0	0	0.00
SYSTEM	/oradata/NTP2000/system01.dbf	6,678	0	6.09	1.21	6,055	0	3,200	0.37
TEMP	/oradata/NTP2000/temp01.dbf	13	0	0.77	7.46	26	0	0
UNDOTBS1	/oradata/NTP2000/undotbs01.dbf	10	0	4.00	1.00	57,709	1	2,020	0.11
USERS	/oradata/NTP2000/users01.dbf	7	0	0.00	1.00	7	0	0	0.00
ZXT_DATA	/oradata/NTP2000/zxt_data01.dbf	7	0	0.00	1.00	7	0	0	0.00
ZXT_DATA	/oradata/NTP2000/zxt_data02.dbf	63	0	6.67	1.10	7	0	0	0.00
ZXT_DATA	/oradata/NTP2000/zxt_data03.dbf	7	0	0.00	1.00	7	0	0	0.00
ZXT_IDX	/oradata/NTP2000/zxt_idx01.dbf	7	0	0.00	1.00	7	0	0	0.00
ZXT_IDX	/oradata/NTP2000/zxt_idx02.dbf	7	0	0.00	1.00	7	0	0	0.00
ZXT_IDX	/oradata/NTP2000/zxt_idx03.dbf	7	0	0.00	1.00	7	0	0	0.00

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	698,970	92	237,070,942	18,868,039	1,211,731	0	0	5,315

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 10,163,519

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	727,443	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	15	2346	33533	190155	3317760	190155
E	0	17	4123	60779	357896	3317760	357896

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	2,176	0.10	69	1.03	19,420	1	8604.00
D	4,352	0.20	138	1.03	19,376	1	8506.00
D	6,528	0.30	207	1.03	19,362	1	8473.00
D	8,704	0.39	276	1.02	19,352	1	8450.00
D	10,880	0.49	344	1.02	19,344	1	8434.00
D	13,056	0.59	413	1.02	19,298	1	8330.00
D	15,232	0.69	482	1.00	18,945	1	7533.00
D	17,408	0.79	551	1.00	18,926	1	7491.00
D	19,584	0.89	620	1.00	18,909	1	7453.00
D	21,760	0.99	689	1.00	18,892	1	7415.00
D	22,080	1.00	699	1.00	18,890	1	7410.00
D	23,936	1.08	758	1.00	18,878	1	7383.00
D	26,112	1.18	827	1.00	18,873	1	7372.00
D	28,288	1.28	895	1.00	18,870	1	7366.00
D	30,464	1.38	964	1.00	18,869	1	7362.00
D	32,640	1.48	1,033	1.00	18,866	1	7356.00
D	34,816	1.58	1,102	1.00	18,864	1	7352.00
D	36,992	1.68	1,171	1.00	18,863	1	7350.00
D	39,168	1.77	1,240	1.00	18,862	1	7347.00
D	41,344	1.87	1,309	1.00	18,858	1	7338.00
D	43,520	1.97	1,378	1.00	18,853	1	7327.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	546,578	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	12,288	10,999	112.43	1.04	0.92	0.00	100.00	1,048,576
E	12,288	10,996	147.04	1.30	0.88	0.00	100.00	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	441,302	441,302
64K	128K	125	125
128K	256K	74	74
256K	512K	752	752
512K	1024K	1,218	1,218
1M	2M	14	14
2M	4M	6	6
4M	8M	404	404
8M	16M	1	1
16M	32M	2	2
32M	64M	40	40
64M	128M	184	184
128M	256M	562	562
256M	512M	476	476
512M	1024M	342	342

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 PGA Overalloc Count	Estd Time
1,536	0.13	546,627.35	269,973.34	67.00	1	96,676,223
3,072	0.25	546,627.35	269,973.34	67.00	1	96,676,223
6,144	0.50	546,627.35	269,971.39	67.00	0	96,675,992
9,216	0.75	546,627.35	269,971.39	67.00	0	96,675,992
12,288	1.00	546,627.35	0.00	100.00	0	64,714,453
14,746	1.20	546,627.35	0.00	100.00	0	64,714,453
17,203	1.40	546,627.35	0.00	100.00	0	64,714,453
19,661	1.60	546,627.35	0.00	100.00	0	64,714,453
22,118	1.80	546,627.35	0.00	100.00	0	64,714,453
24,576	2.00	546,627.35	0.00	100.00	0	64,714,453
36,864	3.00	546,627.35	0.00	100.00	0	64,714,453
49,152	4.00	546,627.35	0.00	100.00	0	64,714,453
73,728	6.00	546,627.35	0.00	100.00	0	64,714,453
98,304	8.00	546,627.35	0.00	100.00	0	64,714,453

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)
704	0.42	169	12,539	134,445	1.00	416	1.00	6,967
896	0.54	181	13,150	134,445	1.00	416	1.00	6,967
1,024	0.62	181	13,150	134,445	1.00	416	1.00	6,967
1,088	0.65	181	13,150	134,445	1.00	416	1.00	6,967
1,152	0.69	181	13,150	134,445	1.00	416	1.00	6,967
1,216	0.73	181	13,150	134,445	1.00	416	1.00	6,967
1,280	0.77	181	13,150	134,445	1.00	416	1.00	6,967
1,344	0.81	181	13,150	134,445	1.00	416	1.00	6,967
1,408	0.85	181	13,150	134,445	1.00	416	1.00	6,967
1,472	0.88	181	13,150	134,445	1.00	416	1.00	6,967
1,536	0.92	181	13,150	134,445	1.00	416	1.00	6,967
1,600	0.96	181	13,150	134,445	1.00	416	1.00	6,967
1,664	1.00	181	13,150	134,445	1.00	416	1.00	6,967
1,728	1.04	181	13,150	134,446	1.00	415	1.00	6,968
1,792	1.08	181	13,150	134,446	1.00	415	1.00	6,968
1,856	1.12	181	13,150	134,446	1.00	415	1.00	6,968
1,920	1.15	181	13,150	134,446	1.00	415	1.00	6,968
1,984	1.19	181	13,150	134,446	1.00	415	1.00	6,968
2,048	1.23	181	13,150	134,446	1.00	415	1.00	6,968
2,112	1.27	181	13,150	134,446	1.00	415	1.00	6,968
2,176	1.31	181	13,150	134,446	1.00	415	1.00	6,968
2,240	1.35	181	13,150	134,446	1.00	415	1.00	6,968
2,432	1.46	181	13,150	134,446	1.00	415	1.00	6,968
2,624	1.58	181	13,150	134,446	1.00	415	1.00	6,968
2,816	1.69	181	13,150	134,446	1.00	415	1.00	6,968
3,008	1.81	181	13,150	134,446	1.00	415	1.00	6,968
3,200	1.92	181	13,150	134,446	1.00	415	1.00	6,968
3,392	2.04	181	13,150	134,446	1.00	415	1.00	6,968

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
6,144	0.25	57,257	19,388,772
9,216	0.38	57,223	19,373,660
12,288	0.50	57,184	19,356,659
15,360	0.63	57,083	19,311,323
18,432	0.75	56,242	18,937,299
21,504	0.88	56,202	18,920,298
24,576	1.00	56,134	18,890,074
27,648	1.13	56,124	18,884,407
30,720	1.25	56,113	18,880,629
33,792	1.38	56,107	18,878,740
36,864	1.50	56,101	18,874,962
39,936	1.63	56,101	18,874,962
43,008	1.75	56,079	18,865,517
46,080	1.88	56,079	18,865,517
49,152	2.00	56,079	18,865,517

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

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)
data block	3,202	1
undo block	1,667	0
undo header	345	0
file header block	82	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)
CR-Reuse Block Range (block range reuse ckpt)	1,523,759	1,523,758	0	96,937	148	1.52
RO-Multiple Object Reuse (fast object reuse)	158,690	158,690	0	15,868	11	0.72
ST-Space Transaction	105,625	105,625	0	260	2	8.33
TX-Transaction (row lock contention)	513	513	0	513	0	0.35
TM-DML	1,269,492	1,268,599	904	476	0	0.33
TX-Transaction (allocate ITL entry)	294	294	0	290	0	0.15
PS-PX Process Reservation	844	854	0	25	0	0.08
HW-Segment High Water Mark	224,728	224,728	0	2	0	0.00
SQ-Sequence Cache	119	119	0	1	0	0.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	199.25	1,723,680	13,368	10	2872.7/5603.8	0/0	0/0/0/13/47174/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
19-Feb 08:57	2,068	12,647	208	5	2,894	0/0	0/0/0/0/0/0
19-Feb 08:47	2,080	12,633	811	5	2,890	0/0	0/0/0/0/0/0
19-Feb 08:37	2,137	12,790	210	5	2,887	0/0	0/0/0/0/0/0
19-Feb 08:27	2,150	12,657	813	5	2,884	0/0	0/0/0/0/0/0
19-Feb 08:17	2,141	12,610	213	5	2,881	0/0	0/0/0/0/0/0
19-Feb 08:07	2,035	13,174	817	7	2,878	0/0	0/0/0/0/0/0
19-Feb 07:57	2,258	12,359	216	5	2,874	0/0	0/0/0/0/0/0
19-Feb 07:47	2,437	12,750	820	5	2,873	0/0	0/0/0/0/0/0
19-Feb 07:37	2,435	12,592	219	5	2,874	0/0	0/0/0/0/0/0
19-Feb 07:27	2,515	12,684	823	5	2,876	0/0	0/0/0/0/0/0
19-Feb 07:17	2,558	12,715	223	5	2,878	0/0	0/0/0/0/0/0
19-Feb 07:07	2,578	12,709	827	7	2,882	0/0	0/0/0/0/0/0
19-Feb 06:57	2,595	12,965	227	8	2,886	0/0	0/0/0/0/0/0
19-Feb 06:47	2,702	20,058	13,368	8	2,890	0/0	0/0/0/0/0/0
19-Feb 06:37	2,692	18,750	12,768	8	2,896	0/0	0/0/0/0/0/0
19-Feb 06:27	2,604	17,380	12,168	8	2,903	0/0	0/0/0/0/0/0
19-Feb 06:17	2,417	18,121	11,567	10	2,908	0/0	0/0/0/0/0/0
19-Feb 06:07	1,426	13,174	10,967	9	2,909	0/0	0/0/0/0/0/0
19-Feb 05:57	2,575	14,238	10,366	7	2,894	0/0	0/0/0/0/0/0
19-Feb 05:47	2,409	12,826	9,766	7	2,898	0/0	0/0/0/0/0/0
19-Feb 05:37	2,473	13,317	9,166	6	2,900	0/0	0/0/0/0/0/0
19-Feb 05:27	2,475	13,892	8,566	6	2,903	0/0	0/0/0/0/0/0
19-Feb 05:17	2,479	12,667	7,965	7	2,906	0/0	0/0/0/0/0/0
19-Feb 05:07	2,171	11,734	7,364	8	2,909	0/0	0/0/0/0/0/0
19-Feb 04:57	2,440	12,344	6,764	7	2,906	0/0	0/0/0/0/0/0
19-Feb 04:47	2,386	11,759	6,163	7	2,909	0/0	0/0/0/0/0/0
19-Feb 04:37	2,512	12,358	5,563	7	2,910	0/0	0/0/0/0/0/0
19-Feb 04:27	2,420	12,026	4,963	6	2,914	0/0	0/0/0/0/0/0
19-Feb 04:17	2,508	12,368	4,363	7	2,916	0/0	0/0/0/0/0/0
19-Feb 04:07	2,644	12,989	3,762	7	2,921	0/0	0/0/0/0/0/0
19-Feb 03:57	2,589	12,673	3,162	6	2,928	0/0	0/0/0/0/0/0
19-Feb 03:47	2,585	12,695	2,561	6	2,934	0/0	0/0/0/0/0/0
19-Feb 03:37	2,559	12,489	1,961	6	2,941	0/0	0/0/0/0/0/0
19-Feb 03:27	2,598	12,765	1,360	6	2,947	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	14	0.00		0	0
ASM db client latch	351,393	0.00		0	0
ASM map operation hash table	14	0.00		0	0
ASM network background latch	1	0.00		0	0
ASM network state latch	807	0.00		0	0
AWR Alerted Metric Element list	425,656	0.00		0	0
Change Notification Hash table latch	102,539	0.00		0	0
Consistent RBA	1,545,041	0.01	0.00	0	0
DML lock allocation	2,537,736	0.00	0.00	0	0
Event Group Locks	106,872	0.01	0.00	0	0
FIB s.o chain latch	52	0.00		0	0
FOB s.o list latch	700,256	0.01	0.00	0	0
File State Object Pool Parent Latch	14	0.00		0	0
I/O Staticstics latch	14	0.00		0	0
IPC stats buffer allocation latch	14	0.00		0	0
In memory undo latch	390,819	0.02	0.93	0	111,713	0.05
JS Sh mem access	56	0.00		0	0
JS broadcast autostart latch	3	0.00		0	0
JS mem alloc latch	84	0.00		0	0
JS queue access latch	98	0.00		0	0
JS queue state obj latch	123,188	0.00		0	0
JS slv state obj latch	1,294	0.00		0	0
KFC FX Hash Latch	14	0.00		0	0
KFC Hash Latch	14	0.00		0	0
KFCL LE Freelist	14	0.00		0	0
KGNFS-NFS:SHM structure	14	0.00		0	0
KGNFS-NFS:SVR LIST	15	0.00		0	0
KJC message pool free list	14	0.00		0	0
KJCT flow control latch	14	0.00		0	0
KMG MMAN ready and startup request latch	16,808	0.00		0	0
KTF sga latch	334	0.00		0	16,932	0.00
Locator state objects pool parent latch	14	0.00		0	0
Lsod array latch	14	0.00		0	0
MQL Tracking Latch	0			0	1,007	0.00
Memory Management Latch	14	0.00		0	16,808	0.00
Memory Queue	14	0.00		0	0
Memory Queue Message Subscriber #1	14	0.00		0	0
Memory Queue Message Subscriber #2	14	0.00		0	0
Memory Queue Message Subscriber #3	14	0.00		0	0
Memory Queue Message Subscriber #4	14	0.00		0	0
Memory Queue Subscriber	14	0.00		0	0
MinActiveScn Latch	560	0.00		0	0
Mutex	14	0.00		0	0
Mutex Stats	14	0.00		0	0
NLS data objects	5	0.00		0	0
OS process	214,570	0.00		0	0
OS process allocation	208,179	0.11	0.00	0	0
OS process: request allocation	106,515	0.21	0.00	0	0
PL/SQL warning settings	55,268	0.00		0	0
PX hash array latch	14	0.00		0	0
QMT	14	0.00		0	0
Real-time plan statistics latch	151,578	0.06	0.04	0	0
Result Cache: RC Latch	2	0.00		0	0
SGA IO buffer pool latch	27	0.00		0	27	0.00
SGA blob parent	14	0.00		0	0
SGA bucket locks	14	0.00		0	0
SGA heap locks	14	0.00		0	0
SGA pool locks	14	0.00		0	0
SQL memory manager latch	14	0.00		0	16,796	0.00
SQL memory manager workarea list latch	1,684,361	0.00	0.00	0	0
Shared B-Tree	1,815	0.00		0	0
Streams Generic	14	0.00		0	0
Testing	14	0.00		0	0
Token Manager	14	0.00		0	0
Undo Hint Latch	0			0	13	0.00
WCR: sync	14	0.00		0	0
Write State Object Pool Parent Latch	14	0.00		0	0
X$KSFQP	14	0.00		0	0
XDB NFS Security Latch	14	0.00		0	0
XDB unused session pool	14	0.00		0	0
XDB used session pool	14	0.00		0	0
active checkpoint queue latch	1,894,899	2.69	0.00	0	0
active service list	372,392	0.11	0.43	0	22,587	0.00
archive control	62	0.00		0	0
begin backup scn array	3,191,365	0.00	0.00	0	0
buffer pool	14	0.00		0	0
business card	14	0.00		0	0
cache buffer handles	17,663	0.05	0.00	0	0
cache buffers chains	439,099,261	0.05	0.00	0	37,775,418	0.00
cache buffers lru chain	10,287,749	0.01	0.01	0	38,690,029	0.01
cache table scan latch	642,345	0.01	0.00	0	642,345	0.00
call allocation	782,609	0.05	0.07	0	0
cas latch	14	0.00		0	0
change notification client cache latch	14	0.00		0	0
channel handle pool latch	212,288	0.02	0.00	0	0
channel operations parent latch	2,824,877	0.01	0.03	0	0
checkpoint queue latch	47,387,350	0.00	0.00	0	1,215,249	0.01
client/application info	426,357	0.01	0.00	0	0
compile environment latch	53,603	0.00		0	0
corrupted undo seg latch	8,328	2.25	0.00	0	0
cp cmon/server latch	14	0.00		0	0
cp pool latch	14	0.00		0	0
cp server hash latch	14	0.00		0	0
cp sga latch	807	0.00		0	0
cvmap freelist lock	14	0.00		0	0
database property service latch	14	0.00		0	0
deferred cleanup latch	807	0.00		0	0
dml lock allocation	194,686	0.00	0.00	0	0
done queue latch	14	0.00		0	0
dummy allocation	107,211	0.23	0.01	0	0
enqueue freelist latch	15	0.00		0	7,012,456	0.00
enqueue hash chains	14,458,868	0.00	0.00	0	51	0.00
enqueues	2,959	0.24	0.00	0	0
error message lists	456	8.55	0.00	0	0
fifth spare latch	14	0.00		0	0
file cache latch	1,105,077	0.00	0.00	0	0
flashback copy	14	0.00		0	0
fourth Audit Vault latch	14	0.00		0	0
gc element	14	0.00		0	0
gcs commit scn state	14	0.00		0	0
gcs partitioned table hash	14	0.00		0	0
gcs pcm hashed value bucket hash	14	0.00		0	0
gcs resource freelist	14	0.00		0	0
gcs resource hash	14	0.00		0	0
gcs resource scan list	14	0.00		0	0
gcs shadows freelist	14	0.00		0	0
ges domain table	14	0.00		0	0
ges enqueue table freelist	14	0.00		0	0
ges group table	14	0.00		0	0
ges process hash list	14	0.00		0	0
ges process parent latch	14	0.00		0	0
ges resource hash list	14	0.00		0	0
ges resource scan list	14	0.00		0	0
ges resource table freelist	14	0.00		0	0
ges value block free list	14	0.00		0	0
global KZLD latch for mem in SGA	52,955	0.00		0	0
global ctx hash table latch	1	0.00		0	0
global tx hash mapping	14	0.00		0	0
granule operation	14	0.00		0	0
hash table column usage latch	2,217	0.05	0.00	0	793,538	0.02
hash table modification latch	8,429	0.01	0.00	0	0
heartbeat check	14	0.00		0	0
internal temp table object number allocation latch	101	0.00		0	0
interrupt manipulation	1,113	4.13	0.00	0	0
intra txn parallel recovery	14	0.00		0	0
io pool granule metadata list	14	0.00		0	0
job workq parent latch	143	0.00		0	129	0.00
job_queue_processes free list latch	282	0.71	0.00	0	0
job_queue_processes parameter latch	4,565	0.00		0	0
k2q lock allocation	14	0.00		0	0
kcbtsemkid latch	7	0.00		0	0
kcfis latch	51	0.00		0	0
kdlx hb parent latch	14	0.00		0	0
kgb parent	14	0.00		0	0
kgnfs mount latch	14	0.00		0	0
kokc descriptor allocation latch	346	0.00		0	0
ksfv messages	14	0.00		0	0
ksim group membership cache	14	0.00		0	0
kss move lock	352	0.00		0	0
ksuosstats global area	5,084	0.00		0	0
ksv allocation latch	1,483	0.00		0	0
ksv class latch	690	0.43	0.33	0	0
ksv msg queue latch	14	0.00		0	0
ksz_so allocation latch	106,515	0.21	0.00	0	0
ktm global data	33,618	0.00		0	0
kwqbsn:qsga	1,801	0.00		0	0
lgwr LWN SCN	1,546,276	0.04	0.00	0	0
list of block allocation	108,305	0.00		0	0
loader state object freelist	182,045	0.00		0	0
lob segment dispenser latch	14	0.00		0	0
lob segment hash table latch	182	0.00		0	0
lob segment query latch	14	0.00		0	0
lock DBA buffer during media recovery	14	0.00		0	0
logical standby cache	14	0.00		0	0
logminer context allocation	14	0.00		0	0
logminer work area	14	0.00		0	0
longop free list parent	560	0.00		0	546	0.00
mapped buffers lru chain	14	0.00		0	0
message pool operations parent latch	615,696	0.00	0.00	0	0
messages	9,401,491	0.52	0.00	0	0
mostly latch-free SCN	1,555,920	0.46	0.00	0	0
msg queue latch	14	0.00		0	0
multiblock read objects	1,288,436	0.00	0.00	0	0
name-service namespace bucket	14	0.00		0	0
ncodef allocation latch	807	0.00		0	0
object queue header heap	17,591,295	0.02	0.00	0	5,900,488	0.10
object queue header operation	63,293,707	0.03	0.00	0	0
object stats modification	106,718	0.24	0.00	0	7	0.00
parallel query alloc buffer	10,050	1.18	0.00	0	0
parallel query stats	322	44.41	0.08	0	0
parameter list	1,600	0.00		0	0
parameter table management	905,758	0.13	0.38	0	0
peshm	14	0.00		0	0
pesom_free_list	14	0.00		0	0
pesom_hash_node	14	0.00		0	0
post/wait queue	464,742	1.64	0.00	0	476,040	0.96
process allocation	106,822	0.21	0.00	0	53,046	0.41
process group creation	106,515	0.00		0	0
process queue	2,295	0.74	0.00	0	0
process queue reference	75,610	0.06	0.00	0	5,760	0.30
qmn task queue latch	7,330	0.00		0	0
query server freelists	2,318	0.26	0.00	0	0
query server process	220	0.00		0	8	0.00
queued dump request	168	0.00		0	0
queuing load statistics	14	0.00		0	0
recovery domain hash list	14	0.00		0	0
redo allocation	4,888,466	0.23	0.00	0	20,939,987	0.10
redo copy	14	0.00		0	20,947,035	0.86
redo writing	6,143,951	0.53	0.00	0	0
resmgr group change latch	1,865,869	0.00	0.00	0	0
resmgr:active threads	110,382	0.00	1.00	0	7,204	0.00
resmgr:actses change group	53,629	0.00		0	0
resmgr:actses change state	52,998	0.00		0	0
resmgr:free threads list	107,292	0.22	0.00	0	0
resmgr:method mem alloc latch	20	0.00		0	0
resmgr:plan CPU method	14	0.00		0	0
resmgr:resource group CPU method	54	0.00		0	0
resmgr:schema config	1,815,562	0.02	0.24	0	240	0.00
resmgr:session queuing	14	0.00		0	0
rm cas latch	14	0.00		0	0
row cache objects	39,553,187	0.06	0.00	0	0
second Audit Vault latch	14	0.00		0	0
second spare latch	14	0.00		0	0
sequence cache	164,026	0.02	0.00	0	0
session allocation	697,395	0.00	0.00	0	590,484	0.00
session idle bit	20,094,325	0.00	0.00	0	0
session queue latch	14	0.00		0	0
session state list latch	1,444	12.81	0.00	0	0
session switching	54,074	0.00		0	0
session timer	16,812	0.00		0	0
shared pool	6,745,251	0.08	0.01	0	0
shared pool sim alloc	551	0.00		0	0
shared pool simulator	32,436	0.00		0	0
sim partition latch	14	0.00		0	0
simulator hash latch	48,170,425	0.00	0.00	0	0
simulator lru latch	1,201,812	0.05	0.00	0	44,643,675	0.03
sort extent pool	9,594	0.00		0	0
space background task latch	478,466	22.16	0.35	2	73,213	0.03
state object free list	30	0.00		0	0
statistics aggregation	4,704	0.00		0	0
tablespace key chain	15,268	0.11	0.00	0	0
temp lob duration state obj allocation	32	0.00		0	0
temporary table state object allocation	14	0.00		0	0
test excl. parent l0	14	0.00		0	0
test excl. parent2 l0	14	0.00		0	0
third spare latch	14	0.00		0	0
threshold alerts latch	2,331	0.00		0	0
trace latch	128	0.00		0	0
transaction allocation	448,829	0.00	0.00	0	0
undo global data	7,761,062	0.01	0.01	0	0
virtual circuit buffers	14	0.00		0	0
virtual circuit holder	14	0.00		0	0
virtual circuit queues	14	0.00		0	0

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	439,099,261	202,800	916	201,920
space background task latch	478,466	106,007	37,530	68,489
active checkpoint queue latch	1,894,899	50,983	44	50,939
messages	9,401,491	49,041	33	49,008
redo writing	6,143,951	32,698	15	32,683
row cache objects	39,553,187	23,565	39	23,528
object queue header operation	63,293,707	19,300	68	19,232
redo allocation	4,888,466	11,203	22	11,181
post/wait queue	464,742	7,604	5	7,599
mostly latch-free SCN	1,555,920	7,191	17	7,174
shared pool	6,745,251	5,586	54	5,532
parameter table management	905,758	1,205	453	752
checkpoint queue latch	47,387,350	1,185	1	1,184
simulator lru latch	1,201,812	628	1	627
cache buffers lru chain	10,287,749	533	3	530
active service list	372,392	396	170	253
undo global data	7,761,062	395	3	392
call allocation	782,609	384	28	362
resmgr:schema config	1,815,562	334	80	263
dummy allocation	107,211	249	2	247
resmgr:free threads list	107,292	231	1	230
channel operations parent latch	2,824,877	226	7	219
parallel query stats	322	143	11	132
Real-time plan statistics latch	151,578	92	4	88
In memory undo latch	390,819	71	66	7
resmgr:active threads	110,382	4	4	0
ksv class latch	690	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
In memory undo latch	ktiFlush: child	36	22
In memory undo latch	ktichg: child	16	15
In memory undo latch	kticmt: child	15	20
PC and Classifier lists for WLM	No latch	25	0
Real-time plan statistics latch	keswxAddNewPlanEntry	4	4
active checkpoint queue latch	kcbbacq: scan active checkpoints	42	41
active checkpoint queue latch	kcbk_add_rbr_ckpt: Add rbr ckpt 1	1	0
active checkpoint queue latch	kcbkcpa: Checkpoint post-processing 2	1	0
active service list	kswslogon: session logout	173	169
active service list	kswsite: service iterator	3	0
cache buffers chains	kcbchg1: mod cr pin	346	256
cache buffers chains	kcbgtcr: fast path	156	47
cache buffers chains	kcbgtcr: fast path (cr pin)	101	45
cache buffers chains	kcbgcur_2	99	68
cache buffers chains	kcbbic2	81	14
cache buffers chains	kcbgtcr_2	69	102
cache buffers chains	kcbbxsv	60	42
cache buffers chains	kcbzwb	58	75
cache buffers chains	kcbget: fast exchange	38	10
cache buffers chains	kcbbic1	15	4
cache buffers chains	kcbrls_2	15	93
cache buffers chains	kcbgtcr: kslbegin shared	9	9
cache buffers chains	kcbrlb1	7	64
cache buffers chains	kcbAdoptBuffers_vhl	6	16
cache buffers chains	kcbzgb: scan from tail. nowait	5	0
cache buffers chains	kcbrls: fast release	4	18
cache buffers chains	kcbnlc	3	32
cache buffers chains	kcbgtcr: kslbegin excl	2	11
cache buffers chains	kcb_pre_apply: kcbhq61	1	6
cache buffers chains	kcbchg1: aux pin	1	42
cache buffers chains	kcbchg1: clear MS bit	1	31
cache buffers chains	kcbchg1: mod cur pin	1	39
cache buffers chains	kcbget: pin buffer	1	0
cache buffers chains	kcbzar_fpin_1	1	4
cache buffers chains	kcbzibmlt: multi-block read: nowait	1	0
cache buffers lru chain	kcbzgws	3	0
call allocation	ksuxds	26	20
call allocation	ksusroll	2	1
channel operations parent latch	ksrpubwait():1	5	0
channel operations parent latch	ksrapublish()	2	0
checkpoint queue latch	kcbklbc_cql	1	0
client/application info	ksuinfos_modact	1	1
dummy allocation	ktcdod	1	2
dummy allocation	ktcscnfy	1	0
ksv class latch	ksvclsl: create	1	0
lgwr LWN SCN	kcs023	15	0
messages	ksarcv: after wait	23	8
messages	ksaamb: after wakeup	5	8
messages	ksarcv	5	17
mostly latch-free SCN	kcslcu3	2	17
object queue header operation	kcbo_switch_q_bg	23	21
object queue header operation	kcbo_check_flist	13	39
object queue header operation	kcbo_unlink_q	13	6
object queue header operation	kcbo_write_q	9	3
object queue header operation	kcbo_switch_mq_bg	8	9
object queue header operation	kcbo_link_q	5	3
object queue header operation	kcbo_sw_buf	3	0
object queue header operation	kcbo_switch_cq	3	0
object queue header operation	kcbo_unlink_q_bg	2	0
parallel query stats	kxfprst: KSLBEGIN:1	11	11
parameter table management	kspcpy	452	0
parameter table management	ksp_param_table_free	6	0
parameter table management	kspptval	1	459
post/wait queue	ksliwat:remove	3	4
post/wait queue	ksliwat:add:nowait	1	0
post/wait queue	kslpstevent:get	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	22	0
redo writing	kcrfwcr	12	12
redo writing	kcrfw_cal_target_rba	2	3
redo writing	kcrfw_post: rba scn pair	1	0
resmgr:active threads	kgsksimsetup1	2	0
resmgr:active threads	kskdynthreshact	2	0
resmgr:free threads list	kskthrsod	1	1
resmgr:schema config	kgskgasi1	61	0
resmgr:schema config	kgskclassinfo1	9	0
resmgr:schema config	kgskmetricupd	8	0
resmgr:schema config	kgskgcs1	1	0
resmgr:schema config	kgskscscb	1	0
row cache objects	kqreqd: reget	19	0
row cache objects	kqrpre: find obj	16	28
row cache objects	kqrcmt: while loop	1	1
row cache objects	kqreqd	1	6
row cache objects	kqrpup	1	0
row cache objects	kqrso	1	0
shared pool	kghalo	38	37
shared pool	kghalp	8	4
shared pool	kghupr1	7	8
shared pool	kghfre	1	2
simulator lru latch	kcbs_simulate: simulate set	1	0
space background task latch	ktsj_grab_task	37,502	37,529
space background task latch	ktsjCreateTask	2	0
space background task latch	ktsj_detach_task	1	1
undo global data	ktudba: KSLBEGIN	3	3

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kgllkdl1 85	970
Library Cache	kglhdgn2 106	951
Library Cache	kglhdgn1 62	570
Library Cache	kgllkc1 57	478
Library Cache	kglhdgh1 64	386
Cursor Pin	kkslce [KKSCHLPIN2]	291
Library Cache	kglpin1 4	218
Library Cache	kglget2 2	182
Library Cache	kglpndl1 95	165
Library Cache	kglpnal1 90	150
Library Cache	kglget1 1	30
Cursor Pin	kksfbc [KKSCHLFSP2]	17
Library Cache	kglobpn1 71	14
Library Cache	kglllal3 111	7
Library Cache	kgldtin1 42	4
Cursor Pin	kksfbc [KKSCHLPIN1]	4
Cursor Parent	kkscsPruneChild [KKSPRTLOC35]	3
hash table	kkshGetNextChild [KKSHBKLOC1]	3
Cursor Pin	kksLockDelete [KKSCHLPIN6]	2
Cursor Parent	kkscsAddChildNode [KKSPRTLOC34]	2
Library Cache	kglhdgc1 102	1
Library Cache	kglini1 32	1
Library Cache	kgllldl2 112	1
Library Cache	kglobld1 75	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: 246,025,478
Captured Segments account for 82.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	TABPART$	TABLE	33,049,632	13.43
SYS	SYSTEM	PARTOBJ$	TABLE	28,748,400	11.69
SYS	SYSTEM	I_OBJ#	INDEX	25,169,696	10.23
SYS	SYSTEM	I_FILE2	INDEX	22,567,536	9.17
SYS	SYSTEM	FILE$	TABLE	22,212,192	9.03

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 18,870,269
Captured Segments account for 7.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_145	TABLE PARTITION	66,003	0.35
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_144	TABLE PARTITION	65,657	0.35
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_146	TABLE PARTITION	64,980	0.34
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_147	TABLE PARTITION	64,649	0.34
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_148	TABLE PARTITION	63,859	0.34

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 1,436,866
Captured Segments account for 6.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Read Requests	%Total
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_228	TABLE PARTITION	5,332	0.37
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_222	TABLE PARTITION	5,311	0.37
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_221	TABLE PARTITION	5,295	0.37
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_219	TABLE PARTITION	3,235	0.23
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_220	TABLE PARTITION	3,231	0.22

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 1,436,866
Captured Segments account for 6.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	UnOptimized Reads	%Total
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_228	TABLE PARTITION	5,332	0.37
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_222	TABLE PARTITION	5,311	0.37
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_221	TABLE PARTITION	5,295	0.37
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_219	TABLE PARTITION	3,235	0.23
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_220	TABLE PARTITION	3,231	0.22

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: 10,163,519
Captured Segments account for 69.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_228	TABLE PARTITION	60,545	0.60
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_229	TABLE PARTITION	58,671	0.58
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_230	TABLE PARTITION	58,123	0.57
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_231	TABLE PARTITION	58,041	0.57
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_233	TABLE PARTITION	57,456	0.57

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 3,805,992
Captured Segments account for 34.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
ZXT2000	DATA_0000	TB_FLOW_TDR_20140219	P_20140219_105	TABLE PARTITION	8,383	0.22
ZXT2000	DATA_0000	TB_FLOW_TDR_20140219	P_20140219_104	TABLE PARTITION	8,345	0.22
ZXT2000	DATA_0000	TB_FLOW_TDR_20140219	P_20140219_103	TABLE PARTITION	8,296	0.22
ZXT2000	DATA_0000	TB_FLOW_TDR_20140219	P_20140219_102	TABLE PARTITION	8,257	0.22
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_243	TABLE PARTITION	8,116	0.21

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 8,951,788
Captured Segments account for 72.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_228	TABLE PARTITION	60,058	0.67
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_229	TABLE PARTITION	58,186	0.65
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_230	TABLE PARTITION	57,672	0.64
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_231	TABLE PARTITION	57,578	0.64
ZXT2000	DATA_0000	TB_FLOW_TDR_20140218	P_20140218_233	TABLE PARTITION	56,957	0.64

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 117,096
Captured Segments account for 99.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	I_USER2	INDEX	116,038	99.10
SYS	SYSAUX	WRH$_SEG_STAT_OBJ_PK	INDEX	358	0.31
SYS	SYSTEM	I_OBJ5	INDEX	44	0.04
SYS	SYSTEM	I_OBJ1	INDEX	32	0.03
SYS	SYSTEM	I_USER1	INDEX	3	0.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	Subobject Name	Obj. Type	DB Block Changes	% of Capture
SYS	SYSTEM	SEG$		TABLE	1,211,104	15.21
SYS	SYSTEM	AUD$		TABLE	907,776	11.40
SYS	SYSTEM	I_FILE#_BLOCK#		INDEX	687,776	8.64
SYS	SYSTEM	I_OBJ2		INDEX	47,536	0.60
ZXT2000	DATA_0000	TB_FLOW_TDR_20140219	P_20140219_0	TABLE PARTITION	44,400	0.56

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	513	98.46
SYS	SYSAUX	I_WRI$_OPTSTAT_IND_OBJ#_ST		INDEX	2	0.38
SYS	SYSAUX	WRH$_LATCH_PK	WRH$_LATCH_3423858130_6198	INDEX PARTITION	2	0.38
SYS	SYSAUX	WRH$_PARAMETER_PK	WRH$_PARAME_3423858130_6198	INDEX PARTITION	2	0.38
SYS	SYSAUX	WRM$_SNAPSHOT_DETAILS_INDEX		INDEX	2	0.38

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	294	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	I_FILE#_BLOCK#	INDEX	1,071	34.59
SYS	SYSTEM	SEG$	TABLE	1,006	32.49
SYS	SYSTEM	AUD$	TABLE	380	12.27
SYS	SYSTEM	I_DEFERRED_STG1	INDEX	184	5.94
SYS	SYSTEM	DEFERRED_STG$	TABLE	83	2.68

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	1,135	0.00	30	1
dc_constraints	2,871	38.59	2,871	151
dc_files	847	0.00	0	121
dc_global_oids	546	4.95	0	50
dc_histogram_data	42,938	3.01	151	2,493
dc_histogram_defs	190,172	5.44	403	7,068
dc_object_grants	46	78.26	0	38
dc_objects	1,419,056	3.17	46,073	28,530
dc_profiles	53,093	0.00	0	1
dc_rollback_segments	44,709	0.00	0	28
dc_segments	2,684,167	4.37	1,115,991	23,025
dc_sequences	120	7.50	120	12
dc_table_scns	828	100.00	0	0
dc_tablespaces	3,172,558	0.00	0	10
dc_users	5,387,661	0.03	0	1,703
global database name	86,897	0.00	0	1
outstanding_alerts	588	0.00	0	8
sch_lj_objs	11	27.27	0	3
sch_lj_oids	20	45.00	0	9

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	105,910	0.00	0		0	0
BODY	159,533	0.03	164,727	0.03	0	0
CLUSTER	536	0.19	624	0.16	0	0
DBLINK	105,938	0.00	0		0	0
EDITION	53,253	0.00	106,330	0.00	0	0
INDEX	26,543	3.53	32,074	2.99	21	0
OBJECT ID	11,766	100.00	0		0	0
SCHEMA	57,471	0.01	0		0	0
SQL AREA	2,228,869	0.34	9,867,913	0.41	7,426	11,859
SQL AREA BUILD	14,570	44.97	0		0	0
SQL AREA STATS	14,632	49.25	14,633	49.25	0	0
TABLE/PROCEDURE	428,134	0.87	1,027,460	0.88	443	0
TRIGGER	8,948	0.03	8,948	0.03	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	22,080.00	22,080.00	22,080.00	22,080.00	INI/
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	12,288.00	12,288.00	12,288.00	12,288.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	24,576.00	24,576.00	24,576.00	24,576.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	192.00	192.00	192.00	192.00	STA/
large pool	512.00	512.00	512.00	512.00	STA/
shared pool	1,664.00	1,664.00	1,664.00	1,664.00	STA/
streams pool	0.00	0.00	0.00	0.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	71.26		2.16	2.82	12	12	33	33
B	Freeable	41.25	0.00	4.13	7.06	18		10	10
B	PL/SQL	0.47	0.37	0.01	0.04	0	0	33	33
B	SQL	0.45	0.22	0.02	0.05	0	2	21	17
E	Other	84.47		2.06	2.62	12	14	41	41
E	Freeable	61.63	0.00	3.24	5.50	17		19	19
E	PL/SQL	0.50	0.37	0.01	0.04	0	0	41	41
E	SQL	0.47	0.22	0.02	0.02	0	2	29	25

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	23,152,558,080
Fixed Size	2,233,480
Redo Buffers	16,928,768
Variable Size	2,483,030,904

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	192.00	192.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	504.19	504.19	0.00
shared	ASH buffers	32.00	32.00	0.00
shared	KGLH0		99.68
shared	KGLHD		19.94
shared	KGLS		18.90
shared	KQR L PO		29.51
shared	SQLA		169.74
shared	db_block_hash_buckets	44.50	44.50	0.00
shared	event statistics per sess	19.17	19.17	0.00
shared	free memory	1,315.77	948.91	-27.88
shared	ksunfy : SSO free list	17.87	17.87	0.00
shared	private strands	21.82	21.82	0.00
	buffer_cache	22,080.00	22,080.00	0.00
	fixed_sga	2.13	2.13	0.00
	log_buffer	16.14	16.14	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

No data exists for this section of the report.

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	0	0	0	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

No data exists for this section of the report.

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

No data exists for this section of the report.

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	/oracle/admin/NTP2000/adump
audit_trail	DB
compatible	11.2.0.0.0
control_files	/oradata/NTP2000/control01.ctl, /oradb1/NTP2000/control02.ctl, /oradb5/NTP2000/control03.ctl
db_block_size	32768
db_cache_size	14562623488
db_domain
db_name	NTP2000
diagnostic_dest	/oracle
filesystemio_options	SETALL
java_pool_size	201326592
large_pool_size	536870912
open_cursors	1000
pga_aggregate_target	12884901888
processes	1000
recyclebin	OFF
remote_login_passwordfile	EXCLUSIVE
sessions	1536
sga_max_size	25769803776
sga_target	25769803776
shared_pool_size	1744830464
spfile	/oradata/NTP2000/spfileNTP2000.ora
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	/oradata/NTP2000/control01.ctl
control_files	/oradb1/NTP2000/control02.ctl
control_files	/oradb5/NTP2000/control03.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 %:	92.04	In-memory Sort %:	100.00
Library Hit %:	99.49	Soft Parse %:	99.12
Execute to Parse %:	65.39	Latch Hit %:	99.93
Parse CPU to Parse Elapsd %:	24.38	% Non-Parse CPU:	99.63