WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

ODI 2459726119 odi1 1 19-Apr-14 12:04 11.2.0.4.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ODI	2459726119	odi1	1	19-Apr-14 12:04	11.2.0.4.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

odidb1 Linux x86 64-bit 24 24 6 147.74

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
odidb1	Linux x86 64-bit	24	24	6	147.74

Snap Id Snap Time Sessions Cursors/Session Instances

Begin Snap: 231 21-Apr-14 10:00:30 73 3.0 2

End Snap: 232 21-Apr-14 11:00:01 89 2.3 2

Elapsed: 59.52 (mins)

DB Time: 388.46 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session	Instances
Begin Snap:	231	21-Apr-14 10:00:30	73	3.0	2
End Snap:	232	21-Apr-14 11:00:01	89	2.3	2
Elapsed:		59.52 (mins)
DB Time:		388.46 (mins)

Report Summary

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 6.5 1.5 0.03 0.01

DB CPU(s): 1.2 0.3 0.01 0.00

Redo size (bytes): 517,396.9 114,737.7

Logical read (blocks): 15,094.4 3,347.3

Block changes: 4,302.5 954.1

Physical read (blocks): 3,936.2 872.9

Physical write (blocks): 2,983.8 661.7

Read IO requests: 88.6 19.7

Write IO requests: 1,931.7 428.4

Read IO (MB): 30.8 6.8

Write IO (MB): 23.3 5.2

Global Cache blocks received: 44.6 9.9

Global Cache blocks served: 24.0 5.3

User calls: 554.6 123.0

Parses (SQL): 205.1 45.5

Hard parses (SQL): 19.4 4.3

SQL Work Area (MB): 5.4 1.2

Logons: 4.0 0.9

Executes (SQL): 228.6 50.7

Rollbacks: 0.4 0.1

Transactions: 4.5

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	6.5	1.5	0.03	0.01
DB CPU(s):	1.2	0.3	0.01	0.00
Redo size (bytes):	517,396.9	114,737.7
Logical read (blocks):	15,094.4	3,347.3
Block changes:	4,302.5	954.1
Physical read (blocks):	3,936.2	872.9
Physical write (blocks):	2,983.8	661.7
Read IO requests:	88.6	19.7
Write IO requests:	1,931.7	428.4
Read IO (MB):	30.8	6.8
Write IO (MB):	23.3	5.2
Global Cache blocks received:	44.6	9.9
Global Cache blocks served:	24.0	5.3
User calls:	554.6	123.0
Parses (SQL):	205.1	45.5
Hard parses (SQL):	19.4	4.3
SQL Work Area (MB):	5.4	1.2
Logons:	4.0	0.9
Executes (SQL):	228.6	50.7
Rollbacks:	0.4	0.1
Transactions:	4.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97 Redo NoWait %: 100.00

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

Library Hit %: 91.21 Soft Parse %: 90.54

Execute to Parse %: 10.27 Latch Hit %: 99.30

Parse CPU to Parse Elapsd %: 92.05 % Non-Parse CPU: 66.82

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
DB CPU		4365.4		18.7
gc current multi block request	8,160	3586.5	440	15.4	Cluster
enq: TM - contention	1,098	2528	2302	10.8	Application
enq: TX - contention	3	2325.2	775071	10.0	Other
direct path read	52,995	1879.4	35	8.1	User I/O
log file sync	36,337	349.2	10	1.5	Commit
kpodplck wait before retrying ORA-54	240	239.1	996	1.0	Other
db file scattered read	17,431	232.4	13	1.0	User I/O
enq: IV - contention	113,874	217.1	2	.9	Other
PX Deq: Slave Session Stats	49,007	159	3	.7	Other

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
DB CPU		4,365		18.7	1.2
Cluster	147,764	3,845	26	16.5	1.1
Other	3,387,812	3,422	1	14.7	1.0
Application	2,263	2,541	1123	10.9	0.7
User I/O	114,511	2,459	21	10.6	0.7
Commit	36,338	349	10	1.5	0.1
Network	2,595,805	107	0	.5	0.0
Concurrency	516,432	100	0	.4	0.0
System I/O	126,942	81	1	.3	0.0
Configuration	864	2	3	.0	0.0

Host CPU

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

24 24 6 0.13 10.90 6.5 2.4 3.3 90.6

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
24	24	6	0.13	10.90	6.5	2.4	3.3	90.6

Instance CPU

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

5.6 59.5 0.0

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

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 2,103.1 102.8 2,000.3

Database Requests: 2,020.3 88.6 1,931.7

Optimized Requests: 0.0 0.0 0.0

Redo Requests: 66.9 0.0 66.9

Total (MB): 55.4 31.0 24.4

Database (MB): 54.1 30.8 23.3

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB): 1.0 0.0 1.0

Database (blocks): 6,919.9 3,936.2 2,983.8

Via Buffer Cache (blocks): 308.6 250.9 57.6

Direct (blocks): 6,611.3 3,685.2 2,926.1

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	2,103.1	102.8	2,000.3
Database Requests:	2,020.3	88.6	1,931.7
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	66.9	0.0	66.9
Total (MB):	55.4	31.0	24.4
Database (MB):	54.1	30.8	23.3
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	1.0	0.0	1.0
Database (blocks):	6,919.9	3,936.2	2,983.8
Via Buffer Cache (blocks):	308.6	250.9	57.6
Direct (blocks):	6,611.3	3,685.2	2,926.1

Memory Statistics

Begin End

Host Mem (MB): 151,288.8 151,288.8

SGA use (MB): 36,224.0 36,224.0

PGA use (MB): 458.6 764.1

% Host Mem used for SGA+PGA: 24.25 24.45

	Begin	End
Host Mem (MB):	151,288.8	151,288.8
SGA use (MB):	36,224.0	36,224.0
PGA use (MB):	458.6	764.1
% Host Mem used for SGA+PGA:	24.25	24.45

Cache Sizes

Begin End

Buffer Cache: 29,568M 29,184M Std Block Size: 8K

Shared Pool Size: 4,452M 4,851M Log Buffer: 114,216K

	Begin	End
Buffer Cache:	29,568M	29,184M	Std Block Size:	8K
Shared Pool Size:	4,452M	4,851M	Log Buffer:	114,216K

Shared Pool Statistics

Begin End

Memory Usage %: 63.79 68.84

% SQL with executions>1: 98.94 79.14

% Memory for SQL w/exec>1: 98.77 59.74

	Begin	End
Memory Usage %:	63.79	68.84
% SQL with executions>1:	98.94	79.14
% Memory for SQL w/exec>1:	98.77	59.74

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): 23307.3s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	9,839.03	42.21
DB CPU	4,365.39	18.73
PL/SQL execution elapsed time	2,428.70	10.42
parse time elapsed	1,544.18	6.63
hard parse elapsed time	1,482.28	6.36
PL/SQL compilation elapsed time	9.08	0.04
connection management call elapsed time	0.76	0.00
repeated bind elapsed time	0.67	0.00
hard parse (sharing criteria) elapsed time	0.53	0.00
sequence load elapsed time	0.12	0.00
hard parse (bind mismatch) elapsed time	0.02	0.00
failed parse elapsed time	0.01	0.00
DB time	23,307.30
background elapsed time	597.19
background cpu time	385.13

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Statistic	Value	End Value
BUSY_TIME	798,861
IDLE_TIME	7,694,714
IOWAIT_TIME	280,408
NICE_TIME	1
SYS_TIME	205,182
USER_TIME	549,577
LOAD	0	11
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	12,255,232
VM_OUT_BYTES	626,688
PHYSICAL_MEMORY_BYTES	158,637,850,624
NUM_CPUS	24
NUM_CPU_CORES	24
NUM_CPU_SOCKETS	6
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
21-Apr 10:00:30	0.13
21-Apr 11:00:01	10.90	9.41	6.47	2.42	90.59	3.30

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 88.9% of Total DB time 23,307.30 (s)
Total FG Wait Time: 16,347.97 (s) DB CPU time: 4,365.39 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			4,365		18.73
Cluster	146,985	0	3,844	26	16.49
Other	1,585,202	77	3,373	2	14.47
Application	2,249	47	2,541	1130	10.90
User I/O	112,249	0	2,457	22	10.54
Commit	36,337	0	349	10	1.50
Network	2,595,707	0	107	0	0.46
Concurrency	97,057	0	90	1	0.39
System I/O	37,207	0	11	0	0.05
Configuration	847	0	2	3	0.01

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
gc current multi block request	8,160	0	3,586	440	0.51	15.39
enq: TM - contention	1,098	96	2,528	2302	0.07	10.85
enq: TX - contention	3	0	2,325	775071	0.00	9.98
direct path read	52,995	0	1,879	35	3.29	8.06
log file sync	36,337	0	349	10	2.26	1.50
kpodplck wait before retrying ORA-54	240	100	239	996	0.01	1.03
db file scattered read	17,431	0	232	13	1.08	1.00
enq: IV - contention	113,874	1	217	2	7.07	0.93
PX Deq: Slave Session Stats	49,007	0	159	3	3.04	0.68
name-service call wait	2,602	0	131	50	0.16	0.56
direct path write	11,108	0	127	11	0.69	0.55
db file sequential read	15,241	0	116	8	0.95	0.50
SQL*Net more data from client	904,679	0	102	0	56.18	0.44
gc current grant busy	50,663	0	90	2	3.15	0.39
DFS lock handle	1,135	0	82	72	0.07	0.35
direct path read temp	6,179	0	63	10	0.38	0.27
PX Deq: Table Q Get Keys	7,005	0	57	8	0.43	0.24
gc current block 2-way	40,537	0	53	1	2.52	0.23
gc cr multi block request	14,806	0	45	3	0.92	0.19
enq: PS - contention	27,392	23	37	1	1.70	0.16
reliable message	9,664	0	36	4	0.60	0.15
db file parallel read	1,441	0	36	25	0.09	0.15
library cache pin	24,094	0	29	1	1.50	0.12
row cache lock	30,395	0	24	1	1.89	0.10
library cache lock	18,149	0	23	1	1.13	0.10
IPC send completion sync	21,510	0	20	1	1.34	0.09
PX Deq: reap credit	1,025,229	100	18	0	63.66	0.08
gc current grant 2-way	10,796	0	17	2	0.67	0.07
gc buffer busy acquire	6,974	0	16	2	0.43	0.07
PX Deq: Signal ACK EXT	34,990	0	14	0	2.17	0.06
enq: CR - block range reuse ckpt	1,943	0	12	6	0.12	0.05
gc buffer busy release	1,134	0	12	11	0.07	0.05
enq: RO - fast object reuse	661	0	12	18	0.04	0.05
control file sequential read	36,295	0	11	0	2.25	0.05
gc current block busy	1,523	0	8	5	0.09	0.03
os thread startup	72	0	8	105	0.00	0.03
gc cr block 2-way	5,899	0	7	1	0.37	0.03
latch free	1,648	0	6	4	0.10	0.03
gc cr grant 2-way	4,202	0	5	1	0.26	0.02
SQL*Net message to client	1,690,826	0	5	0	104.99	0.02
enq: TS - contention	1,835	12	3	2	0.11	0.01
PX Deq: Table Q qref	17,495	0	3	0	1.09	0.01
latch: row cache objects	17,785	0	2	0	1.10	0.01
enq: DL - contention	1,593	100	2	1	0.10	0.01
buffer exterminate	183	99	2	11	0.01	0.01
enq: TT - contention	1,415	0	2	1	0.09	0.01
gc current block congested	941	0	1	2	0.06	0.01
KJC: Wait for msg sends to complete	66,669	0	1	0	4.14	0.01
library cache: mutex X	2,473	0	1	1	0.15	0.01
Disk file operations I/O	6,654	0	1	0	0.41	0.01
enq: FB - contention	852	0	1	2	0.05	0.01
latch: gc element	2,895	0	1	0	0.18	0.01
local write wait	948	0	1	1	0.06	0.00
gc current grant congested	432	0	1	2	0.03	0.00
PX qref latch	190,771	100	1	0	11.85	0.00
buffer busy waits	1,161	0	1	1	0.07	0.00
enq: HW - contention	533	0	1	1	0.03	0.00
cursor: pin S wait on X	13	0	1	54	0.00	0.00
enq: KO - fast object checkpoint	321	0	1	2	0.02	0.00
latch: shared pool	1,925	0	1	0	0.12	0.00
gc cr block busy	206	0	1	3	0.01	0.00
enq: TX - allocate ITL entry	284	0	1	2	0.02	0.00
gc cr block lost	1	0	1	515	0.00	0.00
gc cr disk read	395	0	0	1	0.02	0.00
log file switch completion	9	0	0	52	0.00	0.00
enq: TX - index contention	11	0	0	41	0.00	0.00
write complete waits	21	0	0	20	0.00	0.00
CSS initialization	90	0	0	4	0.01	0.00
gcs drm freeze in enter server mode	4	0	0	99	0.00	0.00
ges inquiry response	227	0	0	2	0.01	0.00
enq: CF - contention	251	0	0	1	0.02	0.00
enq: TX - row lock contention	165	0	0	2	0.01	0.00
gc cr block congested	178	0	0	2	0.01	0.00
latch: enqueue hash chains	1,173	0	0	0	0.07	0.00
read by other session	22	0	0	12	0.00	0.00
CSS operation: action	91	0	0	2	0.01	0.00
latch: object queue header operation	393	0	0	1	0.02	0.00
gc cr grant congested	131	0	0	1	0.01	0.00
latch: cache buffers chains	793	0	0	0	0.05	0.00
latch: redo allocation	753	0	0	0	0.05	0.00
db file single write	228	0	0	1	0.01	0.00
cursor: pin S	155	0	0	1	0.01	0.00
kfk: async disk IO	228	0	0	1	0.01	0.00
enq: PI - contention	80	100	0	2	0.00	0.00
latch: ges resource hash list	553	0	0	0	0.03	0.00
latch: cache buffers lru chain	370	0	0	0	0.02	0.00
library cache load lock	13	0	0	8	0.00	0.00
CSS operation: query	270	0	0	0	0.02	0.00
control file parallel write	684	0	0	0	0.04	0.00
latch: gcs resource hash	94	0	0	1	0.01	0.00
latch: parallel query alloc buffer	120	0	0	0	0.01	0.00
SQL*Net more data to client	202	0	0	0	0.01	0.00
ASM file metadata operation	592	0	0	0	0.04	0.00
cursor: mutex S	1	0	0	10	0.00	0.00
gc current retry	6	0	0	1	0.00	0.00
enq: SW - contention	3	0	0	1	0.00	0.00
latch: messages	10	0	0	0	0.00	0.00
latch: call allocation	9	0	0	0	0.00	0.00
global enqueue expand wait	28	0	0	0	0.00	0.00
enq: JQ - contention	1	100	0	3	0.00	0.00
enq: JS - job run lock - synchronize	2	100	0	1	0.00	0.00
enq: AE - lock	3	0	0	1	0.00	0.00
wait list latch free	2	0	0	1	0.00	0.00
direct path write temp	2	0	0	1	0.00	0.00
SQL*Net message from client	1,690,840	0	2,620,955	1550	105.00
PX Deq: Execution Msg	78,745	0	3,551	45	4.89
PX Deq: Table Q Normal	302,884	0	1,596	5	18.81
PX Deq: Execute Reply	161,250	0	861	5	10.01
jobq slave wait	720	100	361	501	0.04
PX Deq: Parse Reply	35,022	0	78	2	2.17
PX Deq Credit: send blkd	67,860	0	64	1	4.21
PX Deq: Join ACK	35,022	0	25	1	2.17
PX Deq Credit: need buffer	10,200	0	9	1	0.63
KSV master wait	1,866	0	6	3	0.12

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	65,916	0	41	1	4.09	6.90
control file sequential read	13,515	0	13	1	0.84	2.24
gcs log flush sync	5,647	3	11	2	0.35	1.84
db file parallel write	3,961	0	9	2	0.25	1.45
ASM file metadata operation	14,616	0	7	0	0.91	1.13
libcache interrupt action by LCK	416,526	0	6	0	25.86	1.06
control file parallel write	2,497	0	6	2	0.16	1.03
name-service call wait	78	0	6	75	0.00	0.98
latch: ges resource hash list	51,141	0	5	0	3.18	0.85
row cache process	677,618	0	5	0	42.08	0.84
ksxr poll remote instances	405,117	100	4	0	25.16	0.63
ges lms sync during dynamic remastering and reconfig	27	78	2	78	0.00	0.35
row cache cleanup	514,975	0	2	0	31.98	0.35
db file sequential read	372	0	2	6	0.02	0.35
latch free	47,319	0	2	0	2.94	0.33
os thread startup	43	0	2	38	0.00	0.27
enq: CO - master slave det	1,189	100	1	1	0.07	0.23
library cache pin	744	0	1	1	0.05	0.15
DFS lock handle	425	95	1	2	0.03	0.12
row cache lock	833	0	1	1	0.05	0.11
enq: WF - contention	19	0	1	32	0.00	0.10
PX Deq: reap credit	43,654	100	1	0	2.71	0.09
direct path read	23	0	1	23	0.00	0.09
CGS wait for IPC msg	34,323	100	1	0	2.13	0.08
latch: gc element	1,328	0	0	0	0.08	0.07
library cache lock	302	74	0	1	0.02	0.06
gc current block 2-way	376	0	0	1	0.02	0.06
LGWR wait for redo copy	2,613	0	0	0	0.16	0.05
enq: JS - queue lock	1	0	0	277	0.00	0.05
ksdxexeotherwait	4	0	0	60	0.00	0.04
reliable message	143	0	0	2	0.01	0.04
gc cr block 2-way	182	0	0	1	0.01	0.03
latch: redo allocation	682	0	0	0	0.04	0.02
latch: call allocation	470	0	0	0	0.03	0.02
latch: shared pool	470	0	0	0	0.03	0.02
ges DFS hang analysis phase 2 acks	25	0	0	5	0.00	0.02
enq: CF - contention	98	96	0	1	0.01	0.02
direct path write	14	0	0	6	0.00	0.01
gc current grant busy	88	0	0	1	0.01	0.01
gc cr multi block request	29	0	0	2	0.00	0.01
latch: gcs resource hash	274	0	0	0	0.02	0.01
Parameter File I/O	48	0	0	1	0.00	0.01
CSS operation: action	52	0	0	1	0.00	0.01
enq: TT - contention	64	81	0	1	0.00	0.01
latch: cache buffers chains	350	0	0	0	0.02	0.01
gc cr grant 2-way	35	0	0	1	0.00	0.01
db file scattered read	8	0	0	4	0.00	0.01
latch: cache buffers lru chain	45	0	0	1	0.00	0.01
gc current block busy	16	0	0	2	0.00	0.01
latch: object queue header operation	114	0	0	0	0.01	0.00
enq: PS - contention	22	41	0	1	0.00	0.00
log file sequential read	8	0	0	3	0.00	0.00
gc current multi block request	24	0	0	1	0.00	0.00
Disk file operations I/O	1,798	0	0	0	0.11	0.00
gc current grant 2-way	12	0	0	2	0.00	0.00
latch: row cache objects	106	0	0	0	0.01	0.00
PX Deq: Signal ACK RSG	18	0	0	1	0.00	0.00
enq: IV - contention	8	0	0	2	0.00	0.00
db file async I/O submit	3,865	0	0	0	0.24	0.00
library cache: mutex X	5	0	0	2	0.00	0.00
gc current block congested	5	0	0	2	0.00	0.00
latch: active service list	21	0	0	1	0.00	0.00
enq: TA - contention	15	0	0	1	0.00	0.00
gc buffer busy acquire	6	0	0	2	0.00	0.00
KJC: Wait for msg sends to complete	265	0	0	0	0.02	0.00
gc cr block busy	4	0	0	2	0.00	0.00
PX Deq: Slave Session Stats	18	0	0	0	0.00	0.00
latch: redo writing	13	0	0	0	0.00	0.00
CSS initialization	2	0	0	3	0.00	0.00
enq: FB - contention	7	0	0	1	0.00	0.00
IPC send completion sync	12	0	0	0	0.00	0.00
ADR block file read	16	0	0	0	0.00	0.00
buffer busy waits	24	0	0	0	0.00	0.00
log file single write	8	0	0	1	0.00	0.00
enq: MW - contention	2	0	0	2	0.00	0.00
enq: PI - contention	6	100	0	1	0.00	0.00
latch: checkpoint queue latch	21	0	0	0	0.00	0.00
enq: TM - contention	7	0	0	1	0.00	0.00
enq: TD - KTF dump entries	8	0	0	1	0.00	0.00
latch: messages	28	0	0	0	0.00	0.00
enq: PE - contention	3	100	0	1	0.00	0.00
enq: HW - contention	4	0	0	1	0.00	0.00
enq: KO - fast object checkpoint	3	0	0	1	0.00	0.00
enq: RO - fast object reuse	4	0	0	1	0.00	0.00
PX Deq: Signal ACK EXT	18	0	0	0	0.00	0.00
asynch descriptor resize	158	100	0	0	0.01	0.00
enq: DR - contention	2	0	0	1	0.00	0.00
enq: AF - task serialization	2	0	0	1	0.00	0.00
gc cr block congested	2	0	0	1	0.00	0.00
enq: PG - contention	3	100	0	1	0.00	0.00
latch: parallel query alloc buffer	5	0	0	0	0.00	0.00
latch: enqueue hash chains	6	0	0	0	0.00	0.00
ADR block file write	5	0	0	0	0.00	0.00
rdbms ipc message	600,888	10	74,602	124	37.31
PX Idle Wait	14,102	0	47,964	3401	0.88
Space Manager: slave idle wait	3,621	48	10,969	3029	0.22
wait for unread message on broadcast channel	7,198	89	7,147	993	0.45
DIAG idle wait	52,755	86	7,124	135	3.28
gcs remote message	551,947	37	7,088	13	34.27
smon timer	245	4	3,757	15333	0.02
dispatcher timer	60	100	3,601	60010	0.00
Streams AQ: qmn slave idle wait	125	0	3,585	28683	0.01
Streams AQ: qmn coordinator idle wait	250	50	3,585	14342	0.02
ASM background timer	13,416	0	3,576	267	0.83
PING	1,309	21	3,575	2731	0.08
pmon timer	1,190	100	3,573	3003	0.07
shared server idle wait	119	100	3,571	30010	0.01
GCR sleep	714	100	3,570	5001	0.04
ges remote message	368,653	7	3,543	10	22.89
class slave wait	4,054	0	1,288	318	0.25
SGA: MMAN sleep for component shrink	695	98	7	11	0.04
KSV master wait	2,950	73	1	0	0.18
SQL*Net message from client	141	0	0	1	0.01
PX Deq: Join ACK	18	0	0	4	0.00
PX Deq: Parse Reply	18	0	0	3	0.00
PX Deq: Execute Reply	18	0	0	1	0.00
Streams AQ: RAC qmn coordinator idle wait	253	100	0	0	0.02

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	16	100.0
ADR block file write	5	100.0
ADR file lock	6	100.0
ASM file metadata operation	15.3K	94.0	2.8	1.4	.3	1.1	.2	.2
CGS wait for IPC msg	34.3K	100.0
CSS initialization	92	50.0			27.2	21.7	1.1
CSS operation: action	143	24.5	42.0	26.6	7.0
CSS operation: query	276	91.3	5.1	2.9	.7
DFS lock handle	1560	54.3	12.3	4.7	2.5	.4	.1	24.4	1.2
Disk file operations I/O	8210	99.5	.2	.1	.1	.1	.0	.0
IPC send completion sync	21.6K	74.6	20.8	3.0	1.4	.2	.0	.0
KJC: Wait for msg sends to complete	67.2K	99.9	.1	.0	.0	.0	.0
LGWR wait for redo copy	2614	98.9	.9	.2
PX Deq Credit: free buffer	65	100.0
PX Deq: Signal ACK EXT	35.1K	98.2	.4	.3	.5	.3	.1	.2
PX Deq: Signal ACK RSG	18	88.9	5.6			5.6
PX Deq: Slave Session Stats	49.1K	72.5	2.0	3.5	8.9	11.0	1.5	.6	.0
PX Deq: Table Q Get Keys	7005	30.8	32.4	27.0	3.6	1.6	1.3	3.1	.1
PX Deq: Table Q qref	17.5K	96.8	1.7	.7	.7	.1
PX Deq: reap credit	1069.5K	100.0	.0	.0	.0
PX qref latch	190.8K	100.0	.0	.0
Parameter File I/O	48	81.3	4.2	6.3	4.2	4.2
SQL*Net break/reset to client	3	100.0
SQL*Net message to client	1731.2K	100.0	.0	.0	.0
SQL*Net more data from client	908.4K	97.9	1.6	.5	.0	.0
SQL*Net more data to client	202	100.0
asynch descriptor resize	158	100.0
buffer busy waits	1186	78.2	16.1	4.6	1.1			.1
buffer deadlock	59	100.0
buffer exterminate	183				.5	99.5
control file parallel write	3181	96.0	.8	.4	.6	.4	.4	1.2	.0
control file sequential read	49.8K	98.3	.8	.3	.2	.1	.1	.2
cursor: mutex S	1					100.0
cursor: mutex X	17	100.0
cursor: pin S	156	87.8	3.2	.6		8.3
cursor: pin S wait on X	13			15.4		53.8		30.8
db file async I/O submit	3872	100.0
db file parallel read	1441	9.0	11.0	9.2	6.6	15.1	25.3	23.7
db file parallel write	3976	92.1	1.8	1.1	1.0	.7	1.0	2.3
db file scattered read	17.7K	29.7	9.5	8.5	12.6	16.7	12.3	10.9
db file sequential read	15.6K	48.3	3.3	6.4	18.1	12.7	6.3	5.0
db file single write	228	89.0	8.8	1.8	.4
direct path read	53K	3.8	4.0	6.7	12.8	17.6	20.8	34.3
direct path read temp	6179	23.5	5.7	11.2	23.9	22.0	9.2	4.5
direct path write	11.1K	72.7	5.6	5.9	5.3	3.9	2.3	4.2	.1
direct path write temp	2	50.0	50.0
enq: AE - lock	3	66.7	33.3
enq: AF - task serialization	2	50.0	50.0
enq: CF - contention	349	68.8	16.9	7.7	6.0	.6
enq: CO - master slave det	1190	56.4	38.5	3.3	1.7	.1	.1
enq: CR - block range reuse ckpt	1952	58.6	19.3	11.7	7.0	1.3	.6	1.4	.1
enq: DL - contention	1594	68.1	17.5	8.1	5.4	.8		.1
enq: DR - contention	2	50.0	50.0
enq: DT - contention	1	100.0
enq: FB - contention	857	56.8	27.1	8.2	6.2	1.8
enq: HW - contention	540	57.8	27.6	7.6	6.1	.6	.4
enq: IV - contention	114K	41.7	35.5	11.9	8.0	2.7	.1	.0
enq: JQ - contention	1			100.0
enq: JS - job run lock - synchronize	2	50.0	50.0
enq: JS - queue lock	1							100.0
enq: KO - fast object checkpoint	324	68.2	16.4	6.5	6.5	.6	1.5	.3
enq: MW - contention	2	50.0			50.0
enq: PE - contention	3	66.7		33.3
enq: PG - contention	3	100.0
enq: PI - contention	86	40.7	45.3	8.1	4.7	1.2
enq: PS - contention	27.5K	69.4	16.2	7.0	6.4	1.0	.0	.0
enq: RO - fast object reuse	667	63.0	19.5	8.7	3.4	1.3	1.2	2.4	.4
enq: SW - contention	3	33.3	66.7
enq: TA - contention	15	100.0
enq: TD - KTF dump entries	8	100.0
enq: TM - contention	1104	67.2	24.4	5.3	2.5	.5
enq: TS - contention	1855	60.1	21.7	9.2	7.9	1.1		.1
enq: TT - contention	1489	61.0	24.6	9.0	4.7	.7
enq: TX - allocate ITL entry	284	40.8	33.8	12.7	8.5	4.2
enq: TX - contention	1	100.0
enq: TX - index contention	11	45.5		9.1	9.1	18.2	9.1	9.1
enq: TX - row lock contention	165	50.9	27.9	13.3	5.5	1.8		.6
enq: UL - contention	1	100.0
enq: WF - contention	19	73.7	21.1					5.3
gc buffer busy acquire	6982	44.6	25.9	16.6	9.2	3.0	.5	.2
gc buffer busy release	1134	19.8	34.7	19.0	14.2	6.9	2.5	3.1
gc cr block 2-way	6129	60.7	31.5	5.5	2.1	.2	.0	.0
gc cr block busy	210	2.4	34.3	52.4	9.5	.5	1.0
gc cr block congested	182	35.2	37.9	20.3	4.9	1.6
gc cr block lost	1							100.0
gc cr disk read	395	85.6	8.4	2.5	3.0	.3		.3
gc cr failure	1	100.0
gc cr grant 2-way	4278	67.9	19.8	7.9	4.1	.3		.0
gc cr grant congested	132	50.0	29.5	14.4	6.1
gc cr multi block request	15K	26.3	43.6	20.3	8.6	.9	.1	.2
gc current block 2-way	41.3K	68.0	18.3	7.6	5.5	.6	.0	.0
gc current block busy	1536	5.5	29.2	41.0	17.1	4.8	1.5	1.0
gc current block congested	960	56.0	21.7	14.0	7.5	.8
gc current grant 2-way	10.9K	58.8	22.7	10.2	7.4	.8	.0	.0
gc current grant busy	50.9K	49.1	28.6	12.6	8.3	1.4	.0	.0
gc current grant congested	437	41.4	25.4	17.6	13.3	2.1		.2
gc current multi block request	8189	56.1	29.1	8.1	5.9	.6	.1	.1
gc current retry	6	66.7	33.3
gcs drm freeze in enter server mode	4						25.0	75.0
gcs log flush sync	5645	71.6	17.7	4.0	2.0	1.1	3.4	.1
ges DFS hang analysis phase 2 acks	25	20.0	24.0	24.0	28.0			4.0
ges inquiry response	227	61.2	22.5	7.5	6.6	2.2
ges lms sync during dynamic remastering and reconfig	27				7.4	22.2		70.4
global enqueue expand wait	28	100.0
kfk: async disk IO	228	93.4	4.8	1.8
kpodplck wait before retrying ORA-54	240	.4						99.6
ksdxexeotherwait	4				50.0			50.0
ksxr poll remote instances	406.8K	100.0	.0
latch free	49K	99.6	.2	.0	.0	.0		.1
latch: active service list	23	78.3	21.7
latch: cache buffers chains	1143	97.0	2.4	.5
latch: cache buffers lru chain	415	92.5	5.5	1.2	.5	.2
latch: call allocation	480	96.7	2.7	.4	.2
latch: checkpoint queue latch	21	95.2	4.8
latch: enqueue hash chains	1180	97.4	2.4	.3
latch: gc element	4226	90.3	6.9	2.2	.3	.2	.0
latch: gcs resource hash	368	95.1	3.0	.8	1.1
latch: ges resource hash list	51.7K	99.4	.4	.1	.0	.0
latch: messages	38	97.4	2.6
latch: object queue header operation	508	86.2	11.2	1.8	.8
latch: parallel query alloc buffer	125	91.2	8.8
latch: redo allocation	1438	98.3	1.5	.2
latch: redo writing	13	100.0
latch: row cache objects	17.9K	98.7	1.1	.2	.0	.0		.0
latch: shared pool	2400	95.4	3.8	.8	.1
latch: undo global data	3	100.0
libcache interrupt action by LCK	418.3K	100.0	.0	.0	.0
library cache load lock	13	30.8	23.1	7.7	30.8			7.7
library cache lock	18.6K	67.3	18.8	7.9	5.4	.7	.0	.0
library cache pin	25K	71.2	16.8	6.5	4.8	.6	.0
library cache: mutex X	2481	93.2	2.1	.3	.0	4.2	.2
local write wait	948	90.4	6.8	.8	.6	.6	.3	.4
lock escalate retry	2	100.0
log file parallel write	66K	95.0	1.7	1.3	.9	.6	.3	.2	.0
log file sequential read	8	50.0			37.5	12.5
log file single write	8	87.5	12.5
log file switch completion	9							100.0
log file sync	36.4K	3.3	32.2	36.2	15.1	6.9	2.9	3.4	.0
name-service call wait	2681	11.7	.9	2.1	2.9	5.7	12.9	63.7
os thread startup	115						27.8	72.2
rdbms ipc reply	2	100.0
read by other session	22	40.9	18.2	4.5	9.1	9.1	4.5	13.6
reliable message	9849	37.1	32.7	15.9	10.2	2.6	.4	1.2
row cache cleanup	517.4K	100.0	.0	.0	.0
row cache lock	31.6K	80.0	12.7	4.0	2.8	.5	.0
row cache process	681.3K	100.0	.0
wait for scn ack	1	100.0
wait list latch free	2		100.0
write complete waits	21	4.8	23.8	47.6	4.8		4.8	14.3
ASM background timer	13.5K	38.8	12.6	6.6	4.1	6.0	5.6	21.1	5.2
DIAG idle wait	52.8K	11.7	.9	.4	.5	3.1	20.5	62.9
GCR sleep	715								100.0
KSV master wait	4816	80.9	8.7	4.5	1.1	3.4	.7	.6
PING	1309	76.2	2.1	.2	.1				21.4
PX Deq Credit: need buffer	10.2K	72.0	22.9	4.3	.8	.0
PX Deq Credit: send blkd	67.9K	72.8	17.4	6.2	3.3	.3	.0	.0
PX Deq: Execute Reply	161.5K	83.5	4.3	3.2	2.4	2.0	1.7	3.0	.0
PX Deq: Execution Msg	78.7K	14.9	4.6	6.1	13.9	16.6	16.9	26.4	.6
PX Deq: Join ACK	35.1K	85.4	2.2	5.5	5.6	1.1	.1
PX Deq: Parse Reply	35.1K	81.3	5.3	3.4	4.0	1.8	2.6	1.6
PX Deq: Table Q Normal	302.8K	65.0	12.0	7.6	5.4	3.9	3.0	3.1	.0
PX Idle Wait	14K	.1	.0	.0	.1	.8	2.1	78.7	18.1
SGA: MMAN sleep for component shrink	695	1.0	.1		.4	98.4
SQL*Net message from client	1731.3K	93.6	1.7	2.0	.9	.7	.3	.7	.1
Space Manager: slave idle wait	3634	2.4	1.0	1.5	2.1	3.0	2.5	17.5	70.0
Streams AQ: RAC qmn coordinator idle wait	253	100.0
Streams AQ: qmn coordinator idle wait	250	50.0							50.0
Streams AQ: qmn slave idle wait	125								100.0
class slave wait	4053	50.0	9.6	9.0	6.9	4.4	6.0	11.7	2.4
dispatcher timer	60								100.0
gcs remote message	553.3K	37.2	8.2	6.5	5.5	4.3	37.8	.5
ges remote message	369.6K	62.5	10.9	7.4	6.4	2.7	1.7	8.4
jobq slave wait	720							100.0
pmon timer	1190								100.0
rdbms ipc message	602.9K	57.0	11.1	6.0	4.6	3.2	2.9	12.0	3.2
shared server idle wait	119								100.0
smon timer	246	8.9	3.7	7.3	4.5	6.9	5.3	27.2	36.2
wait for unread message on broadcast channel	7200					.8		99.2

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
ASM file metadata operation	30	99.8	.1	.1	.0
DFS lock handle	392	74.4	14.6	5.7	2.4	1.0	.6	.8	.4
Disk file operations I/O	4	100.0	.0	.0			.0
IPC send completion sync	1	100.0	.0
PX Deq: Signal ACK EXT	71	99.8	.1	.1	.0	.0	.0
PX Deq: Slave Session Stats	312	99.4	.3	.2	.0	.0	.1	.0
PX Deq: Table Q Get Keys	222	96.8	1.1	1.1	.4	.3	.2	.1
buffer busy waits	1	99.9	.1
control file parallel write	40	98.7	.5	.4	.3	.1		.0
control file sequential read	89	99.8	.1	.1	.0
cursor: pin S wait on X	4	69.2	15.4		7.7	7.7
db file parallel read	342	76.3	16.0	6.0	1.7	.1
db file parallel write	90	97.7	1.4	.7	.2	.1
db file scattered read	1927	89.1	7.5	2.6	.6	.1	.0
db file sequential read	778	95.0	3.4	1.3	.2	.0	.0
direct path read	18.2K	65.7	19.0	11.0	3.7	.6	.1
direct path read temp	280	95.5	3.0	.9	.4	.2	.0
direct path write	477	95.7	1.5	1.2	.6	.6	.3	.1	.0
enq: CR - block range reuse ckpt	30	98.5	.2	.5	.5	.1	.2	.1
enq: DL - contention	1	99.9	.1
enq: IV - contention	3	100.0	.0
enq: JS - queue lock	1					100.0
enq: KO - fast object checkpoint	1	99.7		.3
enq: PS - contention	2	100.0	.0			.0
enq: RO - fast object reuse	19	97.2	.4	.6	.3	.1	.9	.4
enq: TS - contention	1	99.9	.1
enq: TX - index contention	1	90.9				9.1
enq: TX - row lock contention	1	99.4	.6
enq: WF - contention	1	94.7					5.3
gc buffer busy acquire	15	99.8	.1	.0	.0	.0
gc buffer busy release	35	96.9	.8		1.1	1.1
gc cr block 2-way	1	100.0		.0
gc cr block lost	1					100.0
gc cr disk read	1	99.7			.3
gc cr grant 2-way	1	100.0	.0
gc cr multi block request	36	99.8	.0	.0		.1	.1
gc current block 2-way	1	100.0	.0
gc current block busy	15	99.0	.5	.1	.3	.1	.1
gc current grant 2-way	3	100.0		.0
gc current grant busy	20	100.0	.0	.0	.0	.0
gc current grant congested	1	99.8	.2
gc current multi block request	12	99.9	.1	.0
gcs drm freeze in enter server mode	3	25.0	25.0		50.0
gcs log flush sync	6	99.9	.1
ges DFS hang analysis phase 2 acks	1	96.0	4.0
ges lms sync during dynamic remastering and reconfig	19	29.6	40.7	22.2		3.7	3.7
kpodplck wait before retrying ORA-54	239	.4					99.6
ksdxexeotherwait	2	50.0	25.0		25.0
latch free	51	99.9	.0	.1	.0
latch: row cache objects	4	100.0	.0
library cache load lock	1	92.3		7.7
library cache lock	1	100.0	.0
local write wait	4	99.6	.1	.2	.1
log file parallel write	151	99.8	.1	.0	.0	.0	.0	.0
log file switch completion	9		55.6	44.4
log file sync	1272	96.5	1.6	1.0	.4	.2	.3	.0	.0
name-service call wait	1709	36.3	26.1	37.0	.2	.4
os thread startup	83	27.8	7.8	62.6	.9	.9
read by other session	3	86.4	4.5	9.1
reliable message	114	98.8	.3	.4	.4	.1	.0
write complete waits	3	85.7		9.5	4.8

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
		% of Total Waits
DFS lock handle	7	99.6	.4	.1
direct path write	4	100.0	.0
log file sync	1	100.0	.0

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	22,296	4,348	14,025	53,617
odi	970	8	2	115
SYS$BACKGROUND	1	0	20	105
odiXDB	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	110398	2427	96611	90	0	0	2591854	107
SYS$BACKGROUND	2255	3	418851	10	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
SQL ordered by Cluster Wait Time
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 11.1% of Total DB Time (s): 23,307
Captured PL/SQL account for 0.1% of Total DB Time (s): 23,307

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,399.67	1	1,399.67	6.01	0.07	0.19	6pbnp0hyq18uy	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
965.87	2	482.94	4.14	0.16	1.73	54zw7j1jztqc2	PL/SQL Developer	select sum(bytes)/1024/1024/10...
24.47	1	24.47	0.10	58.53	27.15	572fbaj0fdw2b	sqlplus@odidb1 (TNS V1-V3)	select output from table(dbms_...
22.09	5,352	0.00	0.09	91.06	0.00	cqwfdp2kgp1y6	loader@odidb1 (TNS V1-V3)	SELECT VALUE FROM SYS.LOADER_S...
15.70	5,352	0.00	0.07	85.76	5.03	bjstq78pprd24	loader@odidb1 (TNS V1-V3)	SELECT DECODE(ELEMENT_SUBSTITU...
14.92	4,920	0.00	0.06	86.61	5.97	cnumpcz520unc		SELECT COUNT(*) FROM ALL_OBJEC...
13.79	167,123	0.00	0.06	41.62	0.00	dzs3rm0w0bgnv	loader@odidb1 (TNS V1-V3)	SELECT 'X' FROM LOADER_COL_FLA...
13.73	0		0.06	40.01	48.88	3wyqyrnysd3h5	loader@odidb1 (TNS V1-V3)	CREATE UNIQUE INDEX "CFBF"."S...
12.19	33	0.37	0.05	27.88	0.03	732srx540qk3v	loader@odidb1 (TNS V1-V3)	select to_char(file_id)\|\|CHR(1...
9.89	4,920	0.00	0.04	79.22	0.07	8vwac6wpcqm0z		call SYS.KUPU$UTILITIES.UPDATE...

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 3.3% of Total CPU Time (s): 4,365
Captured PL/SQL account for 0.5% of Total CPU Time (s): 4,365

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
20.12	5,352	0.00	0.46	22.09	91.06	0.00	cqwfdp2kgp1y6	loader@odidb1 (TNS V1-V3)	SELECT VALUE FROM SYS.LOADER_S...
14.32	1	14.32	0.33	24.47	58.53	27.15	572fbaj0fdw2b	sqlplus@odidb1 (TNS V1-V3)	select output from table(dbms_...
13.46	5,352	0.00	0.31	15.70	85.76	5.03	bjstq78pprd24	loader@odidb1 (TNS V1-V3)	SELECT DECODE(ELEMENT_SUBSTITU...
12.93	4,920	0.00	0.30	14.92	86.61	5.97	cnumpcz520unc		SELECT COUNT(*) FROM ALL_OBJEC...
7.84	4,920	0.00	0.18	9.89	79.22	0.07	8vwac6wpcqm0z		call SYS.KUPU$UTILITIES.UPDATE...
5.74	167,123	0.00	0.13	13.79	41.62	0.00	dzs3rm0w0bgnv	loader@odidb1 (TNS V1-V3)	SELECT 'X' FROM LOADER_COL_FLA...
5.49	0		0.13	13.73	40.01	48.88	3wyqyrnysd3h5	loader@odidb1 (TNS V1-V3)	CREATE UNIQUE INDEX "CFBF"."S...
5.41	10,042	0.00	0.12	6.19	87.34	0.00	13t5kwh3tyfhu	oraagent.bin@odidb1 (TNS V1-V3)	declare TYPE attrs_cur IS REF ...
5.29	20,083	0.00	0.12	6.65	79.58	0.00	bcv9qynmu1nv9	oraagent.bin@odidb1 (TNS V1-V3)	select sys.dbms_standard.dicti...
5.23	10,041	0.00	0.12	7.36	71.05	0.19	38spc81t7bjwy	loader@odidb1 (TNS V1-V3)	declare TYPE attrs_cur IS REF ...

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 1.7% of Total User I/O Wait Time (s): 2,459
Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 2,459

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
16.70	2	8.35	0.68	965.87	0.16	1.73	54zw7j1jztqc2	PL/SQL Developer	select sum(bytes)/1024/1024/10...
6.71	0		0.27	13.73	40.01	48.88	3wyqyrnysd3h5	loader@odidb1 (TNS V1-V3)	CREATE UNIQUE INDEX "CFBF"."S...
6.64	1	6.64	0.27	24.47	58.53	27.15	572fbaj0fdw2b	sqlplus@odidb1 (TNS V1-V3)	select output from table(dbms_...
3.84	62	0.06	0.16	4.41	5.24	87.17	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
2.67	1	2.67	0.11	1,399.67	0.07	0.19	6pbnp0hyq18uy	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
1.22	3,076	0.00	0.05	3.26	36.11	37.23	2zuvt3ptkmw7j		insert into deferred_stg$ (obj...
0.89	4,920	0.00	0.04	14.92	86.61	5.97	cnumpcz520unc		SELECT COUNT(*) FROM ALL_OBJEC...
0.79	5,352	0.00	0.03	15.70	85.76	5.03	bjstq78pprd24	loader@odidb1 (TNS V1-V3)	SELECT DECODE(ELEMENT_SUBSTITU...
0.53	3,327	0.00	0.02	3.50	65.93	15.01	ct6c4h224pxgz	oraagent.bin@odidb1 (TNS V1-V3)	BEGIN BEGIN IF (sys.is_vpd_ena...
0.47	3,524	0.00	0.02	0.86	32.67	54.14	8swypbbr0m372		select order#, columns, types ...

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: 53,905,278
Captured SQL account for 19.6% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
5,842,582	5,352	1,091.66	10.84	15.70	85.8	5	bjstq78pprd24	loader@odidb1 (TNS V1-V3)	SELECT DECODE(ELEMENT_SUBSTITU...
1,451,080	167,123	8.68	2.69	13.79	41.6	0	dzs3rm0w0bgnv	loader@odidb1 (TNS V1-V3)	SELECT 'X' FROM LOADER_COL_FLA...
1,250,202	1	1,250,202.00	2.32	24.47	58.5	27.2	572fbaj0fdw2b	sqlplus@odidb1 (TNS V1-V3)	select output from table(dbms_...
235,773	4,536	51.98	0.44	4.07	63.2	0	bfds0c26sax80	loader@odidb1 (TNS V1-V3)	select constraint_name\|\|chr(1)...
159,662	19,845	8.05	0.30	2.71	88.2	0	38243c4tqrkxm		select u.name, o.name, o.names...
149,476	67,925	2.20	0.28	4.43	86.8	1.5	grwydz59pu6mc		select text from view$ where r...
82,572	13,493	6.12	0.15	4.51	25.1	0	1tw5ppr82gvjq	loader@odidb1 (TNS V1-V3)	select to_char(charsetform) \|...
66,767	13,983	4.77	0.12	3.19	78.6	0	4yyb4104skrwj	DBMS_SCHEDULER	update obj$ set obj#=:4, type#...
61,084	10,036	6.09	0.11	1.77	75.3	0	4cv3nc10n5rw0	loader@odidb1 (TNS V1-V3)	select p.valchar from sys.opts...
55,326	2	27,663.00	0.10	965.87	.2	1.7	54zw7j1jztqc2	PL/SQL Developer	select sum(bytes)/1024/1024/10...

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: 14,056,877
Captured SQL account for 0.3% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
35,180	0		0.25	13.73	40.01	48.88	3wyqyrnysd3h5	loader@odidb1 (TNS V1-V3)	CREATE UNIQUE INDEX "CFBF"."S...
967	2	483.50	0.01	965.87	0.16	1.73	54zw7j1jztqc2	PL/SQL Developer	select sum(bytes)/1024/1024/10...
668	1	668.00	0.00	24.47	58.53	27.15	572fbaj0fdw2b	sqlplus@odidb1 (TNS V1-V3)	select output from table(dbms_...
480	1	480.00	0.00	1,399.67	0.07	0.19	6pbnp0hyq18uy	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
399	62	6.44	0.00	4.41	5.24	87.17	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
65	5,352	0.01	0.00	15.70	85.76	5.03	bjstq78pprd24	loader@odidb1 (TNS V1-V3)	SELECT DECODE(ELEMENT_SUBSTITU...
38	3,327	0.01	0.00	3.50	65.93	15.01	ct6c4h224pxgz	oraagent.bin@odidb1 (TNS V1-V3)	BEGIN BEGIN IF (sys.is_vpd_ena...
28	3,076	0.01	0.00	3.26	36.11	37.23	2zuvt3ptkmw7j		insert into deferred_stg$ (obj...
26	4,532	0.01	0.00	2.42	63.54	4.08	8q6ttxknf3y97		insert into sys.wri$_optstat_o...
22	4,920	0.00	0.00	14.92	86.61	5.97	cnumpcz520unc		SELECT COUNT(*) FROM ALL_OBJEC...

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: 316,520
Captured SQL account for 8.2% of Total
Total UnOptimized Read Requests: 316,520
Captured SQL account for 8.2% 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
22,885	22,885	33	693.48	7.23	732srx540qk3v	loader@odidb1 (TNS V1-V3)	select to_char(file_id)\|\|CHR(1...
967	967	2	483.50	0.31	54zw7j1jztqc2	PL/SQL Developer	select sum(bytes)/1024/1024/10...
529	529	1	529.00	0.17	572fbaj0fdw2b	sqlplus@odidb1 (TNS V1-V3)	select output from table(dbms_...
480	480	1	480.00	0.15	6pbnp0hyq18uy	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
399	399	62	6.44	0.13	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
384	384	0		0.12	3wyqyrnysd3h5	loader@odidb1 (TNS V1-V3)	CREATE UNIQUE INDEX "CFBF"."S...
65	65	5,352	0.01	0.02	bjstq78pprd24	loader@odidb1 (TNS V1-V3)	SELECT DECODE(ELEMENT_SUBSTITU...
38	38	3,327	0.01	0.01	ct6c4h224pxgz	oraagent.bin@odidb1 (TNS V1-V3)	BEGIN BEGIN IF (sys.is_vpd_ena...
28	28	3,076	0.01	0.01	2zuvt3ptkmw7j		insert into deferred_stg$ (obj...
22	22	4,920	0.00	0.01	cnumpcz520unc		SELECT COUNT(*) FROM ALL_OBJEC...

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: 816,391
Captured SQL account for 72.4% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
167,123	0	0.00	13.79	41.6	0	dzs3rm0w0bgnv	loader@odidb1 (TNS V1-V3)	SELECT 'X' FROM LOADER_COL_FLA...
67,925	67,926	1.00	4.43	86.8	1.5	grwydz59pu6mc		select text from view$ where r...
20,083	20,082	1.00	6.65	79.6	0	bcv9qynmu1nv9	oraagent.bin@odidb1 (TNS V1-V3)	select sys.dbms_standard.dicti...
19,845	19,844	1.00	2.71	88.2	0	38243c4tqrkxm		select u.name, o.name, o.names...
13,983	13,983	1.00	3.19	78.6	0	4yyb4104skrwj	DBMS_SCHEDULER	update obj$ set obj#=:4, type#...
13,493	321,659	23.84	4.51	25.1	0	1tw5ppr82gvjq	loader@odidb1 (TNS V1-V3)	select to_char(charsetform) \|...
13,420	13,420	1.00	0.94	74	0	7jpt4cpfvcy1k		select ts#, online$ from ts$ w...
12,660	4,859	0.38	1.43	28.9	0	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
11,401	79	0.01	1.34	71.1	0	9gkq7rruycsjp		select parttype, partcnt, part...
10,042	10,042	1.00	6.19	87.3	0	13t5kwh3tyfhu	oraagent.bin@odidb1 (TNS V1-V3)	declare TYPE attrs_cur IS REF ...
10,041	10,041	1.00	7.36	71.1	.2	38spc81t7bjwy	loader@odidb1 (TNS V1-V3)	declare TYPE attrs_cur IS REF ...
10,036	0	0.00	1.77	75.3	0	4cv3nc10n5rw0	loader@odidb1 (TNS V1-V3)	select p.valchar from sys.opts...
10,036	10,036	1.00	1.05	85.6	0	9dzjush42kmfs	loader@odidb1 (TNS V1-V3)	select spare4 from sys.optstat...
9,852	0	0.00	0.62	82.9	0	9y7s2afnkqs9d		delete from idl_ub2$ where obj...
9,852	0	0.00	0.64	92	0	d5jd9b2xct7xz		delete from idl_char$ where ob...
9,852	0	0.00	0.62	93.6	0	dvpfc386d6dmm		delete from idl_sb4$ where obj...
9,852	0	0.00	0.65	90	0	gdhz78y24tvnz		delete from ncomp_dll$ where o...
9,852	0	0.00	0.74	86.4	0	gsqxm6zz3w2by		delete from idl_ub1$ where obj...
8,729	209,972	24.05	2.59	89.2	0	83taa7kaw59c1		select name, intcol#, segcol#,...
8,623	5,539	0.64	3.94	74.6	2.4	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
8,615	99	0.01	0.58	71.6	26.7	2q93zsrvbdw48		select grantee#, privilege#, n...
8,611	0	0.00	0.81	69.7	25	6aq34nj2zb2n7		select col#, grantee#, privile...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 732,536
Captured SQL account for 68.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
167,130	167,123	22.82	dzs3rm0w0bgnv	loader@odidb1 (TNS V1-V3)	SELECT 'X' FROM LOADER_COL_FLA...
67,921	67,925	9.27	grwydz59pu6mc		select text from view$ where r...
20,081	20,083	2.74	bcv9qynmu1nv9	oraagent.bin@odidb1 (TNS V1-V3)	select sys.dbms_standard.dicti...
19,845	19,845	2.71	38243c4tqrkxm		select u.name, o.name, o.names...
13,417	13,420	1.83	7jpt4cpfvcy1k		select ts#, online$ from ts$ w...
11,403	11,401	1.56	9gkq7rruycsjp		select parttype, partcnt, part...
10,042	10,042	1.37	13t5kwh3tyfhu	oraagent.bin@odidb1 (TNS V1-V3)	declare TYPE attrs_cur IS REF ...
10,041	10,041	1.37	38spc81t7bjwy	loader@odidb1 (TNS V1-V3)	declare TYPE attrs_cur IS REF ...
10,036	10,036	1.37	4cv3nc10n5rw0	loader@odidb1 (TNS V1-V3)	select p.valchar from sys.opts...
10,036	10,036	1.37	9dzjush42kmfs	loader@odidb1 (TNS V1-V3)	select spare4 from sys.optstat...
9,852	9,852	1.34	9y7s2afnkqs9d		delete from idl_ub2$ where obj...
9,852	9,852	1.34	d5jd9b2xct7xz		delete from idl_char$ where ob...
9,852	9,852	1.34	dvpfc386d6dmm		delete from idl_sb4$ where obj...
9,852	9,852	1.34	gdhz78y24tvnz		delete from ncomp_dll$ where o...
9,850	9,852	1.34	gsqxm6zz3w2by		delete from idl_ub1$ where obj...

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

SQL ordered by Cluster Wait Time

%Total - Cluster Time as a percentage of Total Cluster Wait Time
%Clu - Cluster Time as a percentage of Elapsed Time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Only SQL with Cluster Wait Time > .005 seconds is reported
Total Cluster Wait Time (s): 7,419
Captured SQL account for 0.3% of Total

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
5.34	3,352	0.07	8.09	65.97	32.80	1.57	bxa794dmp6z7w		insert into icol$(obj#, bo#, i...
4.22	905	0.06	8.01	52.67	24.70	1.20	g7mt7ptq286u7		insert into seg$ (file#, block...
2.63	4,113	0.04	5.08	51.76	37.44	0.09	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
1.65	3,284	0.02	3.39	48.60	53.68	0.00	8wka9s48pjvfh		delete from icol$ where obj#=:...
1.30	2,748	0.02	2.37	54.79	30.36	5.48	9tgj4g8y4rwy8		select type#, blocks, extents,...
1.04	1	0.01	24.47	4.26	58.53	27.15	572fbaj0fdw2b	sqlplus@odidb1 (TNS V1-V3)	select output from table(dbms_...
0.77	3,355	0.01	2.89	26.58	62.11	0.00	2yv5xahhmr2aa		insert into ind$(bo#, obj#, ts...
0.54	3,284	0.01	2.81	19.22	72.30	0.01	59vjj34vugaav		delete from obj$ where obj# = ...
0.42	62	0.01	4.41	9.47	5.24	87.17	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
0.40	0	0.01	13.73	2.90	40.01	48.88	3wyqyrnysd3h5	loader@odidb1 (TNS V1-V3)	CREATE UNIQUE INDEX "CFBF"."S...
0.38	33	0.01	12.19	3.12	27.88	0.03	732srx540qk3v	loader@odidb1 (TNS V1-V3)	select to_char(file_id)\|\|CHR(1...
0.34	2	0.00	965.87	0.03	0.16	1.73	54zw7j1jztqc2	PL/SQL Developer	select sum(bytes)/1024/1024/10...
0.25	1	0.00	1,399.67	0.02	0.07	0.19	6pbnp0hyq18uy	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
0.13	3,403	0.00	3.05	4.28	59.36	0.16	4bjwv5sp99589		insert into obj$(owner#, name,...
0.13	13,983	0.00	3.19	4.05	78.62	0.00	4yyb4104skrwj	DBMS_SCHEDULER	update obj$ set obj#=:4, type#...
0.05	5,352	0.00	15.70	0.35	85.76	5.03	bjstq78pprd24	loader@odidb1 (TNS V1-V3)	SELECT DECODE(ELEMENT_SUBSTITU...
0.05	3,525	0.00	1.32	3.71	34.89	33.32	3ktacv9r56b51		select owner#, name, namespace...
0.05	3,076	0.00	3.26	1.40	36.11	37.23	2zuvt3ptkmw7j		insert into deferred_stg$ (obj...
0.04	3,524	0.00	0.86	5.11	32.67	54.14	8swypbbr0m372		select order#, columns, types ...
0.04	4,532	0.00	2.42	1.71	63.54	4.08	8q6ttxknf3y97		insert into sys.wri$_optstat_o...
0.03	3,327	0.00	3.50	0.87	65.93	15.01	ct6c4h224pxgz	oraagent.bin@odidb1 (TNS V1-V3)	BEGIN BEGIN IF (sys.is_vpd_ena...
0.03	3,526	0.00	2.19	1.34	79.86	0.73	9rzjf5cqv4qv1		delete from deferred_stg$ wher...
0.02	4,920	0.00	9.89	0.25	79.22	0.07	8vwac6wpcqm0z		call SYS.KUPU$UTILITIES.UPDATE...
0.02	4,920	0.00	1.95	1.22	91.95	0.02	8agwdqgvnpqzh		UPDATE SYS.KU_UTLUSE SET USECN...
0.02	10,041	0.00	7.36	0.30	71.05	0.19	38spc81t7bjwy	loader@odidb1 (TNS V1-V3)	declare TYPE attrs_cur IS REF ...
0.02	4,920	0.00	14.92	0.10	86.61	5.97	cnumpcz520unc		SELECT COUNT(*) FROM ALL_OBJEC...
0.01	8,623	0.00	3.94	0.27	74.58	2.44	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
0.01	8,615	0.00	0.58	1.45	71.58	26.74	2q93zsrvbdw48		select grantee#, privilege#, n...
0.01	4,503	0.00	1.03	0.71	59.78	0.96	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
0.01	43	0.00	0.02	29.70	51.16	0.00	b1wc53ddd6h3p		select audit$, options from pr...
0.01	8,611	0.00	0.81	0.66	69.73	24.98	6aq34nj2zb2n7		select col#, grantee#, privile...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

13t5kwh3tyfhu declare TYPE attrs_cur IS REF CURSOR; m_cur attrs_cur; m_event varchar2(512); m_user varchar2(512); m_owner varchar2(512); m_user1 varchar2(512); m_type varchar2(512); m_stmt varchar2(512); m_name varchar2(5120); m_column varchar2(5120); m_cnt NUMBER; m_stmt1 varchar2(512); m_var varchar2(512); m_o_stmt VARCHAR2(5120); PRAGMA AUTONOMOUS_TRANSACTION; begin m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual'; execute immediate m_stmt into m_type; if(not (m_type='TABLE' or m_type='TRIGGER' or m_type='USER' or m_type='TABLESPACE')) then return; end if; m_stmt:='select sys.dbms_standard.sysevent from dual'; execute immediate m_stmt into m_event; m_stmt:='select SYS_CONTEXT(''USERENV'', ''SESSION_USER'') from dual'; execute immediate m_stmt into m_user; m_stmt:='select SYS_CONTEXT(''USERENV'', ''CURRENT_USER'') from dual'; execute immediate m_stmt into m_user1; m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual'; execute immediate m_stmt into m_owner; m_stmt:='sele ct sys.dbms_standard.dictionary_obj_name from dual'; execute immediate m_stmt into m_name; m_stmt:='select sdo_geor_def.getSqlText from dual'; execute immediate m_stmt into m_o_stmt; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='ALTER') then m_stmt:='select column_name from dba_tab_columns where owner=:1 and table_name=:2'; open m_cur for m_stmt using m_owner, m_name; loop fetch m_cur into m_column; exit when m_cur%NOTFOUND; m_stmt:='select sdo_geor_def.isDropColumn(:1) from dual'; execute immediate m_stmt into m_stmt1 using SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_column); if (trim(m_stmt1)='TRUE') then m_stmt:='begin sdo_geor_def.doAlterDropColumn(:1, :2, :3); end;'; execute immediate m_stmt using SYS.DBMS_ASSERT.SCHEMA_NAME(m_owner), SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_name), SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_column); end if; end loop; end if; if ((m_event='DROP' and m_type='USER') or (m_event='DROP' and m_type='TABLESPACE')) then m_stmt:='insert into sdo_geor_ddl__ table$$ values (1)'; EXECUTE IMMEDIATE m_stmt; commit; end if; if (m_event='DROP' and m_type='TABLE') then m_stmt:='select count(*) from sdo_geor_sysdata_table where sdo_owner=:1 and RDT_TABLE_NAME=:2'; EXECUTE IMMEDIATE m_stmt into m_cnt using m_owner, m_name; if(m_cnt!=0) then m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if((m_cnt=0)and (m_user!='SYS' and m_user!='SYSTEM' and m_user!='MDSYS'and m_owner!='MDSYS' and m_owner!='SYS')) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''The referenced raster data table(RDT) cannot be dropped.'')'; execute immediate m_stmt; end if; end if; m_stmt:='insert into sdo_geor_ddl__table$$ values (2)'; EXECUTE IMMEDIATE m_stmt; commit; end if; if(m_user='SYS' or m_user='SYSTEM' or m_user='MDSYS' or m_owner='MDSYS' or m_owner='SYS') then return; end if; if (m_event='RENAME' and m_type='TABLE') then m_stmt:='select count(*) from sdo_geor_sysdata_table where sdo_owner=:1 and RDT_TABLE_N AME=:2'; EXECUTE IMMEDIATE m_stmt into m_cnt using m_owner, m_name; if(m_cnt!=0) then m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''The referenced raster data table(RDT) cannot be renamed directly.'')'; execute immediate m_stmt; end if; end if; end if; if (m_type='TRIGGER' and m_event='DROP') then m_stmt:='select REGEXP_SUBSTR(:1, ''GRDMLTR_.+'', 1, 1, ''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster DML triggers cannot be dropped.'')'; execute immediate m_stmt; end if; end if; if (m_type='TRIGGER' and m_event='ALTER') then m_o_stmt:=upper(trim(m_o_stmt)); if(instr(m_o_stmt, ' COMPILE ')>0 or instr(m_o_stmt, ' ENABLE ') >0 or substr(m_o_stmt, length(m_o_stmt)-8, 8)=' COMPILE' or substr(m_o_stmt, length(m_o_stmt)-7, 7)=' ENABLE' ) then return; end if; m_stmt:='select REGEXP_SUBSTR(:1, ''GRDMLTR_.+'', 1, 1, ''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster DML triggers cannot be altered.'')'; execute immediate m_stmt; end if; end if; if (m_type='TRIGGER' and m_event='CREATE') then m_stmt:='select REGEXP_SUBSTR(:1, ''GRDMLTR_.+'', 1, 1, ''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster reserved names cannot be used to create reg ular triggers.'')'; execute immediate m_stmt; end if; end if; Exception when others then if(sqlcode=-13391) then m_stmt:=sqlerrm; m_stmt:=substr(m_stmt, 11); m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, '''||m_stmt||''')'; execute immediate m_stmt; end if; end;

1tw5ppr82gvjq select to_char(charsetform) ||chr(1) || to_char(charsetid)||chr(1)|| to_char(null$) ||chr(1) || to_char(property) ||chr(1)|| to_char(col#) ||chr(1) || to_char(segcol#) ||chr(1)|| to_char(type#) ||chr(1) || to_char(spare3) ||chr(1) || to_char(length) ||chr(1)|| to_char(nvl(precision#, '65535')) || chr(1) || to_char(nvl(precision#, '0')) || chr(1) || to_char(nvl(scale, '0')) || chr(1) || to_char(nvl(scale, '255'))||chr(1) ||name , default$ from sys.col$ where obj#=:1 and segcol#>0 order by obj#, decode(segcol#, 0, 65535, segcol#), intcol#

2q93zsrvbdw48 select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#

2yv5xahhmr2aa insert into ind$(bo#, obj#, ts#, file#, block#, intcols, type#, flags, property, pctfree$, initrans, maxtrans, blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, cols, analyzetime, samplesize, dataobj#, degree, instances, rowcnt, pctthres$, indmethod#, trunccnt, spare1, spare4, spare2, spare6)values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, decode(:23, 1, null, :23), decode(:24, 1, null, :24), :25, :32*256+:26, :27, :28, :29, :30, :31, :33)

2zuvt3ptkmw7j insert into deferred_stg$ (obj#, pctfree_stg, pctused_stg, size_stg, initial_stg, next_stg, minext_stg, maxext_stg, maxsiz_stg, lobret_stg, mintim_stg, pctinc_stg, initra_stg, maxtra_stg, optimal_stg, maxins_stg, frlins_stg, flags_stg, bfp_stg, enc_stg, cmpflag_stg, cmplvl_stg) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)

38243c4tqrkxm select u.name, o.name, o.namespace, o.type#, decode(bitand(i.property, 1024), 0, 0, 1), o.obj# from ind$ i, obj$ o, user$ u where i.obj#=:1 and o.obj#=i.bo# and o.owner#=u.user#

38spc81t7bjwy declare TYPE attrs_cur IS REF CURSOR; m_cur attrs_cur; m_event varchar2(512); m_user varchar2(512); m_owner varchar2(512); m_user1 varchar2(512); m_type varchar2(512); m_name varchar2(5120); m_column varchar2(5120); m_cnt NUMBER; m_stmt varchar2(512); m_ret varchar2(3000); m_ret1 varchar2(512); m_o_stmt VARCHAR2(5120); begin m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual'; execute immediate m_stmt into m_type; if(not (m_type='TABLE' or m_type='TRIGGER' or m_type='USER' or m_type='TABLESPACE')) then return; end if; m_stmt:='select sys.dbms_standard.sysevent from dual'; execute immediate m_stmt into m_event; m_stmt:='select SYS_CONTEXT(''USERENV'', ''SESSION_USER'') from dual'; execute immediate m_stmt into m_user; m_stmt:='select sys.dbms_standard.login_user from dual'; execute immediate m_stmt into m_user1; m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual'; execute immediate m_stmt into m_owner; m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual'; execute immediate m_stmt into m_name; if((instr(upper(m_name), 'MDRT_')>0) and m_event='DROP') then return; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='CREATE') then m_stmt:='select sdo_geor_def.listAllGeoRasterFieldsStr(:1, :2) from dual'; execute immediate m_stmt into m_ret using SYS.DBMS_ASSERT.SCHEMA_NAME(m_owner), SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_name); m_ret:=trim(m_ret); while (length(m_ret)!=0) loop if (instr(m_ret, ' $$__## ')!=0) then m_ret1:=trim(substr(m_ret, 1, instr(m_ret, ' $$__## ')-1)); m_ret:=trim(substr(m_ret, instr(m_ret, ' $$__## ')+8)); else m_ret1:=trim(m_ret); m_ret:=''; end if; m_stmt:='begin SDO_GEOR_UTL.createDMLTrigger(:1, :2); end;'; execute immediate m_stmt using m_owner||'.'||m_name, SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME(m_ret1); end loop; return; end if; if (m_name!='MDSYS' and m_type='USER' and m_event='DROP') then m_stmt:='call sdo_geor_def.doDropUserAndTable()'; execute immediate m_stmt; end if; if (m_owner !='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='DROP') then m_stmt:='call sdo_geor_def.doDropUserAndTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='TRUNCATE') then m_stmt:='call sdo_geor_def.doTruncateTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='ALTER') then m_stmt:='call sdo_geor_def.doAlterRenameTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='RENAME') then m_stmt:='call sdo_geor_def.doRenameTable()'; execute immediate m_stmt; end if; if (m_event='DROP' and m_type='TABLE') then m_stmt:='delete from sdo_geor_ddl__table$$ where id=2'; EXECUTE IMMEDIATE m_stmt; end if; if ((m_type='USER' and m_event='DROP') or (m_type='TABLESPACE' and m_event='DROP')) then m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; end if; Exception when others then if(sqlcode= -13391) then m_stmt:=sqlerrm; m_stmt:=substr(m_stmt, 11); m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, '''||m_stmt||''')'; execute immediate m_stmt; end if; end;

3ktacv9r56b51 select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

3nkd3g3ju5ph1 select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

3wyqyrnysd3h5 CREATE UNIQUE INDEX "CFBF"."SYS_C0046910" ON "CFBF"."RY_HXX_BF" ("HH") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CFBF"

4bjwv5sp99589 insert into obj$(owner#, name, namespace, obj#, type#, ctime, mtime, stime, status, remoteowner, linkname, subname, dataobj#, flags, oid$, spare1, spare2, spare3) values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18)

4cv3nc10n5rw0 select p.valchar from sys.optstat_user_prefs$ p, sys.obj$ o, sys.user$ u where p.obj#=o.obj# and u.user#=o.owner# and u.name=:1 and o.name=:2 and p.pname=:3

4yyb4104skrwj update obj$ set obj#=:4, type#=:5, ctime=:6, mtime=:7, stime=:8, status=:9, dataobj#=:10, flags=:11, oid$=:12, spare1=:13, spare2=:14 where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

53saa2zkr6wc3 select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1

54zw7j1jztqc2 select sum(bytes)/1024/1024/1024 from dba_segments

572fbaj0fdw2b select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))

59vjj34vugaav delete from obj$ where obj# = :1

6aq34nj2zb2n7 select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#

6pbnp0hyq18uy select sum(bytes)/1024/1024/1024 from dba_segments

732srx540qk3v select to_char(file_id)||CHR(1)||to_char(relative_fno)||CHR(1)||tablespace_name||CHR(1)||file_name||chr(1)||to_char(nvl(ts#, 0)) from sys.dba_data_files, sys.ts$ where tablespace_name=name order by file_id

7jpt4cpfvcy1k select ts#, online$ from ts$ where name=:1

7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

83taa7kaw59c1 select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#

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

8q6ttxknf3y97 insert into sys.wri$_optstat_opr (operation, target, start_time, end_time) values (:1, :2, :3, :4)

8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1

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

8wka9s48pjvfh delete from icol$ where obj#=:1

9dzjush42kmfs select spare4 from sys.optstat_hist_control$ where sname=:1

9gkq7rruycsjp select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags, mod(spare3, 256) interval_dty, rowid, defmaxsize from partobj$ where obj# = :1

9rzjf5cqv4qv1 delete from deferred_stg$ where obj# = :1

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

9y7s2afnkqs9d delete from idl_ub2$ where obj#=:1 and part=:2

b1wc53ddd6h3p select audit$, options from procedure$ where obj#=:1

bcv9qynmu1nv9 select sys.dbms_standard.dictionary_obj_type from dual

bfds0c26sax80 select constraint_name||chr(1)||constraint_type from dba_constraints where owner='(null)' and table_name='(null)' and constraint_type in ('R', 'P', 'U')

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

bxa794dmp6z7w insert into icol$(obj#, bo#, intcol#, pos#, segcol#, segcollength, offset, col#, spare1, spare2, spare3) values(:1, :2, :3, :4, 0, 0, 0, :5, :6, :7, :8)

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

cqwfdp2kgp1y6 SELECT VALUE FROM SYS.LOADER_SKIP_UNUSABLE_INDEXES

ct6c4h224pxgz BEGIN BEGIN IF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_CONTENTS)) THEN xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name); ELSIF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; END;

cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#

d5jd9b2xct7xz delete from idl_char$ where obj#=:1 and part=:2

dvpfc386d6dmm delete from idl_sb4$ where obj#=:1 and part=:2

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'

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

gdhz78y24tvnz delete from ncomp_dll$ where obj#=:1 returning dllname into :2

grwydz59pu6mc select text from view$ where rowid=:1

gsqxm6zz3w2by delete from idl_ub1$ where obj#=:1 and part=:2

SQL Id	SQL Text
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
13t5kwh3tyfhu	declare TYPE attrs_cur IS REF CURSOR; m_cur attrs_cur; m_event varchar2(512); m_user varchar2(512); m_owner varchar2(512); m_user1 varchar2(512); m_type varchar2(512); m_stmt varchar2(512); m_name varchar2(5120); m_column varchar2(5120); m_cnt NUMBER; m_stmt1 varchar2(512); m_var varchar2(512); m_o_stmt VARCHAR2(5120); PRAGMA AUTONOMOUS_TRANSACTION; begin m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual'; execute immediate m_stmt into m_type; if(not (m_type='TABLE' or m_type='TRIGGER' or m_type='USER' or m_type='TABLESPACE')) then return; end if; m_stmt:='select sys.dbms_standard.sysevent from dual'; execute immediate m_stmt into m_event; m_stmt:='select SYS_CONTEXT(''USERENV'', ''SESSION_USER'') from dual'; execute immediate m_stmt into m_user; m_stmt:='select SYS_CONTEXT(''USERENV'', ''CURRENT_USER'') from dual'; execute immediate m_stmt into m_user1; m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual'; execute immediate m_stmt into m_owner; m_stmt:='sele ct sys.dbms_standard.dictionary_obj_name from dual'; execute immediate m_stmt into m_name; m_stmt:='select sdo_geor_def.getSqlText from dual'; execute immediate m_stmt into m_o_stmt; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='ALTER') then m_stmt:='select column_name from dba_tab_columns where owner=:1 and table_name=:2'; open m_cur for m_stmt using m_owner, m_name; loop fetch m_cur into m_column; exit when m_cur%NOTFOUND; m_stmt:='select sdo_geor_def.isDropColumn(:1) from dual'; execute immediate m_stmt into m_stmt1 using SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_column); if (trim(m_stmt1)='TRUE') then m_stmt:='begin sdo_geor_def.doAlterDropColumn(:1, :2, :3); end;'; execute immediate m_stmt using SYS.DBMS_ASSERT.SCHEMA_NAME(m_owner), SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_name), SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_column); end if; end loop; end if; if ((m_event='DROP' and m_type='USER') or (m_event='DROP' and m_type='TABLESPACE')) then m_stmt:='insert into sdo_geor_ddl__ table$$ values (1)'; EXECUTE IMMEDIATE m_stmt; commit; end if; if (m_event='DROP' and m_type='TABLE') then m_stmt:='select count() from sdo_geor_sysdata_table where sdo_owner=:1 and RDT_TABLE_NAME=:2'; EXECUTE IMMEDIATE m_stmt into m_cnt using m_owner, m_name; if(m_cnt!=0) then m_stmt:='select count() from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if((m_cnt=0)and (m_user!='SYS' and m_user!='SYSTEM' and m_user!='MDSYS'and m_owner!='MDSYS' and m_owner!='SYS')) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''The referenced raster data table(RDT) cannot be dropped.'')'; execute immediate m_stmt; end if; end if; m_stmt:='insert into sdo_geor_ddl__table$$ values (2)'; EXECUTE IMMEDIATE m_stmt; commit; end if; if(m_user='SYS' or m_user='SYSTEM' or m_user='MDSYS' or m_owner='MDSYS' or m_owner='SYS') then return; end if; if (m_event='RENAME' and m_type='TABLE') then m_stmt:='select count() from sdo_geor_sysdata_table where sdo_owner=:1 and RDT_TABLE_N AME=:2'; EXECUTE IMMEDIATE m_stmt into m_cnt using m_owner, m_name; if(m_cnt!=0) then m_stmt:='select count() from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''The referenced raster data table(RDT) cannot be renamed directly.'')'; execute immediate m_stmt; end if; end if; end if; if (m_type='TRIGGER' and m_event='DROP') then m_stmt:='select REGEXP_SUBSTR(:1, ''GRDMLTR_.+'', 1, 1, ''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count() from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster DML triggers cannot be dropped.'')'; execute immediate m_stmt; end if; end if; if (m_type='TRIGGER' and m_event='ALTER') then m_o_stmt:=upper(trim(m_o_stmt)); if(instr(m_o_stmt, ' COMPILE ')>0 or instr(m_o_stmt, ' ENABLE ') >0 or substr(m_o_stmt, length(m_o_stmt)-8, 8)=' COMPILE' or substr(m_o_stmt, length(m_o_stmt)-7, 7)=' ENABLE' ) then return; end if; m_stmt:='select REGEXP_SUBSTR(:1, ''GRDMLTR_.+'', 1, 1, ''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count() from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster DML triggers cannot be altered.'')'; execute immediate m_stmt; end if; end if; if (m_type='TRIGGER' and m_event='CREATE') then m_stmt:='select REGEXP_SUBSTR(:1, ''GRDMLTR_.+'', 1, 1, ''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster reserved names cannot be used to create reg ular triggers.'')'; execute immediate m_stmt; end if; end if; Exception when others then if(sqlcode=-13391) then m_stmt:=sqlerrm; m_stmt:=substr(m_stmt, 11); m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, '''\|\|m_stmt\|\|''')'; execute immediate m_stmt; end if; end;
1tw5ppr82gvjq	select to_char(charsetform) \|\|chr(1) \|\| to_char(charsetid)\|\|chr(1)\|\| to_char(null$) \|\|chr(1) \|\| to_char(property) \|\|chr(1)\|\| to_char(col#) \|\|chr(1) \|\| to_char(segcol#) \|\|chr(1)\|\| to_char(type#) \|\|chr(1) \|\| to_char(spare3) \|\|chr(1) \|\| to_char(length) \|\|chr(1)\|\| to_char(nvl(precision#, '65535')) \|\| chr(1) \|\| to_char(nvl(precision#, '0')) \|\| chr(1) \|\| to_char(nvl(scale, '0')) \|\| chr(1) \|\| to_char(nvl(scale, '255'))\|\|chr(1) \|\|name , default$ from sys.col$ where obj#=:1 and segcol#>0 order by obj#, decode(segcol#, 0, 65535, segcol#), intcol#
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2yv5xahhmr2aa	insert into ind$(bo#, obj#, ts#, file#, block#, intcols, type#, flags, property, pctfree$, initrans, maxtrans, blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, cols, analyzetime, samplesize, dataobj#, degree, instances, rowcnt, pctthres$, indmethod#, trunccnt, spare1, spare4, spare2, spare6)values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, decode(:23, 1, null, :23), decode(:24, 1, null, :24), :25, :32*256+:26, :27, :28, :29, :30, :31, :33)
2zuvt3ptkmw7j	insert into deferred_stg$ (obj#, pctfree_stg, pctused_stg, size_stg, initial_stg, next_stg, minext_stg, maxext_stg, maxsiz_stg, lobret_stg, mintim_stg, pctinc_stg, initra_stg, maxtra_stg, optimal_stg, maxins_stg, frlins_stg, flags_stg, bfp_stg, enc_stg, cmpflag_stg, cmplvl_stg) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
38243c4tqrkxm	select u.name, o.name, o.namespace, o.type#, decode(bitand(i.property, 1024), 0, 0, 1), o.obj# from ind$ i, obj$ o, user$ u where i.obj#=:1 and o.obj#=i.bo# and o.owner#=u.user#
38spc81t7bjwy	declare TYPE attrs_cur IS REF CURSOR; m_cur attrs_cur; m_event varchar2(512); m_user varchar2(512); m_owner varchar2(512); m_user1 varchar2(512); m_type varchar2(512); m_name varchar2(5120); m_column varchar2(5120); m_cnt NUMBER; m_stmt varchar2(512); m_ret varchar2(3000); m_ret1 varchar2(512); m_o_stmt VARCHAR2(5120); begin m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual'; execute immediate m_stmt into m_type; if(not (m_type='TABLE' or m_type='TRIGGER' or m_type='USER' or m_type='TABLESPACE')) then return; end if; m_stmt:='select sys.dbms_standard.sysevent from dual'; execute immediate m_stmt into m_event; m_stmt:='select SYS_CONTEXT(''USERENV'', ''SESSION_USER'') from dual'; execute immediate m_stmt into m_user; m_stmt:='select sys.dbms_standard.login_user from dual'; execute immediate m_stmt into m_user1; m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual'; execute immediate m_stmt into m_owner; m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual'; execute immediate m_stmt into m_name; if((instr(upper(m_name), 'MDRT_')>0) and m_event='DROP') then return; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='CREATE') then m_stmt:='select sdo_geor_def.listAllGeoRasterFieldsStr(:1, :2) from dual'; execute immediate m_stmt into m_ret using SYS.DBMS_ASSERT.SCHEMA_NAME(m_owner), SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_name); m_ret:=trim(m_ret); while (length(m_ret)!=0) loop if (instr(m_ret, ' $$__## ')!=0) then m_ret1:=trim(substr(m_ret, 1, instr(m_ret, ' $$__## ')-1)); m_ret:=trim(substr(m_ret, instr(m_ret, ' $$__## ')+8)); else m_ret1:=trim(m_ret); m_ret:=''; end if; m_stmt:='begin SDO_GEOR_UTL.createDMLTrigger(:1, :2); end;'; execute immediate m_stmt using m_owner\|\|'.'\|\|m_name, SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME(m_ret1); end loop; return; end if; if (m_name!='MDSYS' and m_type='USER' and m_event='DROP') then m_stmt:='call sdo_geor_def.doDropUserAndTable()'; execute immediate m_stmt; end if; if (m_owner !='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='DROP') then m_stmt:='call sdo_geor_def.doDropUserAndTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='TRUNCATE') then m_stmt:='call sdo_geor_def.doTruncateTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='ALTER') then m_stmt:='call sdo_geor_def.doAlterRenameTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='RENAME') then m_stmt:='call sdo_geor_def.doRenameTable()'; execute immediate m_stmt; end if; if (m_event='DROP' and m_type='TABLE') then m_stmt:='delete from sdo_geor_ddl__table$$ where id=2'; EXECUTE IMMEDIATE m_stmt; end if; if ((m_type='USER' and m_event='DROP') or (m_type='TABLESPACE' and m_event='DROP')) then m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; end if; Exception when others then if(sqlcode= -13391) then m_stmt:=sqlerrm; m_stmt:=substr(m_stmt, 11); m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, '''\|\|m_stmt\|\|''')'; execute immediate m_stmt; end if; end;
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3nkd3g3ju5ph1	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
3wyqyrnysd3h5	CREATE UNIQUE INDEX "CFBF"."SYS_C0046910" ON "CFBF"."RY_HXX_BF" ("HH") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CFBF"
4bjwv5sp99589	insert into obj$(owner#, name, namespace, obj#, type#, ctime, mtime, stime, status, remoteowner, linkname, subname, dataobj#, flags, oid$, spare1, spare2, spare3) values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18)
4cv3nc10n5rw0	select p.valchar from sys.optstat_user_prefs$ p, sys.obj$ o, sys.user$ u where p.obj#=o.obj# and u.user#=o.owner# and u.name=:1 and o.name=:2 and p.pname=:3
4yyb4104skrwj	update obj$ set obj#=:4, type#=:5, ctime=:6, mtime=:7, stime=:8, status=:9, dataobj#=:10, flags=:11, oid$=:12, spare1=:13, spare2=:14 where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
54zw7j1jztqc2	select sum(bytes)/1024/1024/1024 from dba_segments
572fbaj0fdw2b	select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
59vjj34vugaav	delete from obj$ where obj# = :1
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6pbnp0hyq18uy	select sum(bytes)/1024/1024/1024 from dba_segments
732srx540qk3v	select to_char(file_id)\|\|CHR(1)\|\|to_char(relative_fno)\|\|CHR(1)\|\|tablespace_name\|\|CHR(1)\|\|file_name\|\|chr(1)\|\|to_char(nvl(ts#, 0)) from sys.dba_data_files, sys.ts$ where tablespace_name=name order by file_id
7jpt4cpfvcy1k	select ts#, online$ from ts$ where name=:1
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8agwdqgvnpqzh	UPDATE SYS.KU_UTLUSE SET USECNT = USECNT + 1, ENCRYPTCNT = ENCRYPTCNT + :1, COMPRESSCNT = COMPRESSCNT + :2, LAST_USED = CURRENT_TIMESTAMP WHERE UTLNAME = :3
8q6ttxknf3y97	insert into sys.wri$_optstat_opr (operation, target, start_time, end_time) values (:1, :2, :3, :4)
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
8vwac6wpcqm0z	call SYS.KUPU$UTILITIES.UPDATEFEATURETABLE ('Oracle Utility SQL Loader (Direct Path Load)', 0, 0)
8wka9s48pjvfh	delete from icol$ where obj#=:1
9dzjush42kmfs	select spare4 from sys.optstat_hist_control$ where sname=:1
9gkq7rruycsjp	select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags, mod(spare3, 256) interval_dty, rowid, defmaxsize from partobj$ where obj# = :1
9rzjf5cqv4qv1	delete from deferred_stg$ where obj# = :1
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
9y7s2afnkqs9d	delete from idl_ub2$ where obj#=:1 and part=:2
b1wc53ddd6h3p	select audit$, options from procedure$ where obj#=:1
bcv9qynmu1nv9	select sys.dbms_standard.dictionary_obj_type from dual
bfds0c26sax80	select constraint_name\|\|chr(1)\|\|constraint_type from dba_constraints where owner='(null)' and table_name='(null)' and constraint_type in ('R', 'P', 'U')
bjstq78pprd24	SELECT DECODE(ELEMENT_SUBSTITUTABLE, ' Y', 1, 0) FROM SYS.ALL_NESTED_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner
bxa794dmp6z7w	insert into icol$(obj#, bo#, intcol#, pos#, segcol#, segcollength, offset, col#, spare1, spare2, spare3) values(:1, :2, :3, :4, 0, 0, 0, :5, :6, :7, :8)
cnumpcz520unc	SELECT COUNT(*) FROM ALL_OBJECT_TABLES OT, ALL_XML_TABLES XT WHERE OT.OWNER = XT.OWNER AND OT.TABLE_NAME = XT.TABLE_NAME AND XT.STORAGE_TYPE = 'CLOB' AND OT.OWNER = :OWN AND OT.TABLE_NAME = :TAB
cqwfdp2kgp1y6	SELECT VALUE FROM SYS.LOADER_SKIP_UNUSABLE_INDEXES
ct6c4h224pxgz	BEGIN BEGIN IF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_CONTENTS)) THEN xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name); ELSIF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; END;
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d5jd9b2xct7xz	delete from idl_char$ where obj#=:1 and part=:2
dvpfc386d6dmm	delete from idl_sb4$ where obj#=:1 and part=:2
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'
g7mt7ptq286u7	insert into seg$ (file#, block#, type#, ts#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, lists, groups, cachehint, hwmincr, spare1, scanhint, bitmapranges) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, DECODE(:17, 0, NULL, :17), :18, :19)
gdhz78y24tvnz	delete from ncomp_dll$ where obj#=:1 returning dllname into :2
grwydz59pu6mc	select text from view$ where rowid=:1
gsqxm6zz3w2by	delete from idl_ub1$ where obj#=:1 and part=:2

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Key Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
db block changes	15,365,179	4,302.51	954.12
execute count	816,391	228.60	50.69
gc cr block receive time	10,128	2.84	0.63
gc cr blocks received	56,181	15.73	3.49
gc current block receive time	23,581	6.60	1.46
gc current blocks received	103,073	28.86	6.40
logons cumulative	14,118	3.95	0.88
opened cursors cumulative	689,025	192.94	42.79
parse count (total)	732,536	205.12	45.49
parse time elapsed	157,371	44.07	9.77
physical reads	14,056,877	3,936.16	872.88
physical writes	10,655,624	2,983.75	661.68
redo size	1,847,735,992	517,396.87	114,737.70
session cursor cache hits	371,891	104.14	23.09
session logical reads	53,905,278	15,094.38	3,347.32
user calls	1,980,490	554.57	122.98
user commits	14,815	4.15	0.92
user rollbacks	1,289	0.36	0.08
workarea executions - onepass	4	0.00	0.00
workarea executions - optimal	59,113	16.55	3.67

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	34	0.01	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	159	0.04	0.01
Batched IO buffer defrag count	1	0.00	0.00
Batched IO double miss count	1	0.00	0.00
Batched IO same unit count	96	0.03	0.01
Batched IO single block count	29	0.01	0.00
Batched IO vector block count	34	0.01	0.00
Batched IO vector read count	6	0.00	0.00
Block Cleanout Optim referenced	0	0.00	0.00
CCursor + sql area evicted	168	0.05	0.01
CPU used by this session	429,240	120.19	26.65
CPU used when call started	411,542	115.24	25.56
CR blocks created	14,418	4.04	0.90
Cached Commit SCN referenced	13,995,440	3,918.96	869.07
Commit SCN cached	81,380	22.79	5.05
DBWR checkpoint buffers written	171,074	47.90	10.62
DBWR checkpoints	334	0.09	0.02
DBWR fusion writes	17,312	4.85	1.08
DBWR object drop buffers written	34	0.01	0.00
DBWR parallel query checkpoint buffers written	192	0.05	0.01
DBWR revisited being-written buffer	219	0.06	0.01
DBWR thread checkpoint buffers written	154,069	43.14	9.57
DBWR transaction table writes	1,754	0.49	0.11
DBWR undo block writes	72,994	20.44	4.53
DDL statements parallelized	2,191	0.61	0.14
DFO trees parallelized	2,203	0.62	0.14
Effective IO time	1,879,403,139	526,264.20	116,704.12
HSC Heap Segment Block Changes	63,721	17.84	3.96
Heap Segment Array Inserts	140	0.04	0.01
Heap Segment Array Updates	8,100	2.27	0.50
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	102,919	28.82	6.39
PX local messages recv'd	372,993	104.44	23.16
PX local messages sent	372,993	104.44	23.16
PX remote messages recv'd	215,572	60.36	13.39
PX remote messages sent	185,926	52.06	11.55
Parallel operations not downgraded	2,203	0.62	0.14
Requests to/from client	1,708,207	478.33	106.07
RowCR attempts	25	0.01	0.00
RowCR hits	19	0.01	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	1,708,672	478.46	106.10
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	30,828	8.63	1.91
background checkpoints completed	42	0.01	0.00
background checkpoints started	42	0.01	0.00
background timeouts	34,244	9.59	2.13
branch node splits	60	0.02	0.00
buffer is not pinned count	6,485,876	1,816.15	402.75
buffer is pinned count	10,902,896	3,052.99	677.03
bytes received via SQL*Net from client	64,273,754,419	17,997,722.46	3,991,167.07
bytes sent via SQL*Net to client	208,783,928	58,462.98	12,964.72
calls to get snapshot scn: kcmgss	4,801,440	1,344.48	298.15
calls to kcmgas	262,481	73.50	16.30
calls to kcmgcs	1,294,943	362.61	80.41
cell physical IO interconnect bytes	207,268,256,768	58,038,566.35	12,870,607.10
change write time	10,985	3.08	0.68
cleanout - number of ktugct calls	103,356	28.94	6.42
cleanouts and rollbacks - consistent read gets	13,983	3.92	0.87
cleanouts only - consistent read gets	82,135	23.00	5.10
cluster key scan block gets	3,275,730	917.26	203.41
cluster key scans	2,110,273	590.91	131.04
commit batch/immediate performed	30,230	8.46	1.88
commit batch/immediate requested	30,230	8.46	1.88
commit cleanout failures: block lost	29	0.01	0.00
commit cleanout failures: buffer being written	35	0.01	0.00
commit cleanout failures: callback failure	435	0.12	0.03
commit cleanout failures: cannot pin	228	0.06	0.01
commit cleanouts	140,683	39.39	8.74
commit cleanouts successfully completed	139,956	39.19	8.69
commit immediate performed	30,230	8.46	1.88
commit immediate requested	30,230	8.46	1.88
commit txn count during cleanout	85,428	23.92	5.30
consistent changes	381,832	106.92	23.71
consistent gets	28,600,055	8,008.49	1,775.96
consistent gets - examination	5,049,602	1,413.97	313.56
consistent gets direct	12,780,923	3,578.87	793.65
consistent gets from cache	15,819,132	4,429.62	982.31
consistent gets from cache (fastpath)	10,328,053	2,892.03	641.33
cursor authentications	2,931	0.82	0.18
data blocks consistent reads - undo records applied	23,188	6.49	1.44
db block gets	25,305,352	7,085.92	1,571.37
db block gets direct	10,080,551	2,822.72	625.97
db block gets from cache	15,224,804	4,263.20	945.41
db block gets from cache (fastpath)	5,925,146	1,659.14	367.93
deferred (CURRENT) block cleanout applications	44,150	12.36	2.74
dirty buffers inspected	14,583	4.08	0.91
enqueue conversions	113,403	31.75	7.04
enqueue releases	7,093,594	1,986.32	440.49
enqueue requests	7,130,433	1,996.64	442.77
enqueue timeouts	36,753	10.29	2.28
enqueue waits	39,955	11.19	2.48
exchange deadlocks	127	0.04	0.01
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	1,069,252	299.41	66.40
free buffer requested	1,326,786	371.52	82.39
gc blocks compressed	43,142	12.08	2.68
gc blocks lost	29	0.01	0.00
gc cr block flush time	537	0.15	0.03
gc cr blocks served	32,348	9.06	2.01
gc current block flush time	839	0.23	0.05
gc current block pin time	197	0.06	0.01
gc current blocks served	53,417	14.96	3.32
gc force cr disk read	1,638	0.46	0.10
gc kbytes saved	217,751	60.97	13.52
gc kbytes sent	468,369	131.15	29.08
gc local grants	687,398	192.48	42.68
gc read wait timeouts	1	0.00	0.00
gc read waits	5	0.00	0.00
gc remote grants	409,993	114.80	25.46
gcs messages sent	1,643,798	460.29	102.07
ges messages sent	434,949	121.79	27.01
global enqueue get time	69,487	19.46	4.31
global enqueue gets async	118,912	33.30	7.38
global enqueue gets sync	2,485,935	696.10	154.37
global enqueue releases	2,162,247	605.47	134.27
heap block compress	1,274	0.36	0.08
hot buffers moved to head of LRU	276	0.08	0.02
immediate (CR) block cleanout applications	96,119	26.91	5.97
immediate (CURRENT) block cleanout applications	36,880	10.33	2.29
index crx upgrade (positioned)	98,733	27.65	6.13
index fast full scans (direct read)	0	0.00	0.00
index fast full scans (full)	3	0.00	0.00
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	6,439,060	1,803.04	399.84
index scans kdiixs1	3,423,525	958.64	212.59
leaf node 90-10 splits	2,408	0.67	0.15
leaf node splits	2,525	0.71	0.16
lob reads	118,852	33.28	7.38
lob writes	1,189,548	333.09	73.87
lob writes unaligned	1,183,905	331.51	73.52
logical read bytes from cache	254,310,932,480	71,211,299.59	15,791,786.67
max cf enq hold time	40	0.01	0.00
messages received	197,298	55.25	12.25
messages sent	197,298	55.25	12.25
min active SCN optimization applied on CR	0	0.00	0.00
no work - consistent read gets	21,832,112	6,113.36	1,355.69
non-idle wait count	9,615,302	2,692.44	597.08
parse count (describe)	12	0.00	0.00
parse count (failures)	1	0.00	0.00
parse count (hard)	69,288	19.40	4.30
parse time cpu	144,862	40.56	9.00
physical read IO requests	316,520	88.63	19.65
physical read bytes	115,153,936,384	32,245,021.41	7,150,641.85
physical read total IO requests	367,054	102.78	22.79
physical read total bytes	115,975,775,232	32,475,149.99	7,201,675.06
physical read total multi block requests	115,334	32.30	7.16
physical reads cache	896,172	250.94	55.65
physical reads cache prefetch	862,042	241.39	53.53
physical reads direct	13,160,705	3,685.22	817.23
physical reads direct (lob)	8	0.00	0.00
physical reads direct temporary tablespace	359,896	100.78	22.35
physical reads prefetch warmup	2,729	0.76	0.17
physical write IO requests	6,898,564	1,931.71	428.38
physical write bytes	87,290,888,192	24,442,903.54	5,420,447.60
physical write total IO requests	7,143,458	2,000.29	443.58
physical write total bytes	91,292,473,344	25,563,414.07	5,668,931.53
physical write total multi block requests	91,259	25.55	5.67
physical writes direct	10,449,789	2,926.12	648.89
physical writes direct (lob)	6,289,812	1,761.25	390.57
physical writes direct temporary tablespace	359,896	100.78	22.35
physical writes from cache	205,835	57.64	12.78
physical writes non checkpoint	10,626,892	2,975.71	659.89
pinned buffers inspected	1,946	0.54	0.12
pinned cursors current	5	0.00	0.00
prefetch warmup blocks aged out before use	5	0.00	0.00
prefetch warmup blocks flushed out before use	3,708	1.04	0.23
prefetched blocks aged out before use	5,400	1.51	0.34
process last non-idle time	57,475	16.09	3.57
queries parallelized	12	0.00	0.00
recursive calls	2,554,588	715.33	158.63
recursive cpu usage	199,740	55.93	12.40
redo blocks checksummed by FG (exclusive)	111,298	31.17	6.91
redo blocks written	3,804,577	1,065.34	236.25
redo buffer allocation retries	9	0.00	0.00
redo entries	14,492,152	4,058.04	899.91
redo log space requests	19	0.01	0.00
redo ordering marks	80,400	22.51	4.99
redo size for direct writes	352,591,764	98,731.57	21,894.67
redo subscn max counts	10,774	3.02	0.67
redo synch long waits	281	0.08	0.02
redo synch poll writes	45,413	12.72	2.82
redo synch polls	56,566	15.84	3.51
redo synch time	34,619	9.69	2.15
redo synch time (usec)	349,827,746	97,957.60	21,723.03
redo synch time overhead (usec)	435,603,119	121,976.13	27,049.37
redo synch time overhead count (<128 msec)	1,186	0.33	0.07
redo synch time overhead count (<2 msec)	24,915	6.98	1.55
redo synch time overhead count (<32 msec)	5,399	1.51	0.34
redo synch time overhead count (<8 msec)	14,056	3.94	0.87
redo synch time overhead count (>=128 msec)	386	0.11	0.02
redo synch writes	46,623	13.06	2.90
redo wastage	29,474,100	8,253.24	1,830.23
redo write broadcast ack count	12,583	3.52	0.78
redo write broadcast ack time	19,787,650	5,540.87	1,228.74
redo write broadcast lgwr post count	3	0.00	0.00
redo write info find	45,945	12.87	2.85
redo write info find fail	3	0.00	0.00
redo write time	16,962	4.75	1.05
redo writes	65,952	18.47	4.10
remote Oradebug requests	4	0.00	0.00
rollback changes - undo records applied	924	0.26	0.06
rollbacks only - consistent read gets	430	0.12	0.03
root node splits	59	0.02	0.00
rows fetched via callback	331,776	92.90	20.60
session connect time	159	0.04	0.01
shared hash latch upgrades - no wait	278,040	77.86	17.27
shared hash latch upgrades - wait	90	0.03	0.01
sorts (disk)	2	0.00	0.00
sorts (memory)	114,758	32.13	7.13
sorts (rows)	417,903,979	117,020.08	25,950.32
sql area evicted	50,146	14.04	3.11
sql area purged	3,402	0.95	0.21
summed dirty queue length	24,346	6.82	1.51
switch current to new buffer	21,840	6.12	1.36
table fetch by rowid	3,479,161	974.22	216.04
table fetch continued row	13,867	3.88	0.86
table scan blocks gotten	15,219,974	4,261.85	945.11
table scan rows gotten	420,610,336	117,777.90	26,118.38
table scans (direct read)	2,760	0.77	0.17
table scans (long tables)	9,342	2.62	0.58
table scans (rowid ranges)	8,619	2.41	0.54
table scans (short tables)	29,093	8.15	1.81
temp space allocated (bytes)	1,048,576	293.62	65.11
total cf enq hold time	13,520	3.79	0.84
total number of cf enq holders	963	0.27	0.06
total number of times SMON posted	237	0.07	0.01
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	547	0.15	0.03
transaction tables consistent read rollbacks	9	0.00	0.00
transaction tables consistent reads - undo records applied	187	0.05	0.01
undo change vector size	532,534,016	149,118.40	33,068.43
user logons cumulative	43	0.01	0.00
user logouts cumulative	37	0.01	0.00
write clones created in background	951	0.27	0.06
write clones created in foreground	2,911	0.82	0.18

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
logons current	73	89
opened cursors current	218	208
session cursor cache count	21,128	23,723
session pga memory	882,985,744	1,130,564,288
session pga memory max	1,413,320,112	3,159,444,832
session uga memory	2,350,954,016	3,236,524,016
session uga memory max	57,601,374,720	71,140,562,440
workarea memory allocated	1,060	139,425

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)	2	2.02

Back to Instance Activity Statistics
Back to Top

IO Stats

IOStat by Function summary
IOStat by Filetype summary
IOStat by Function/Filetype summary
Tablespace IO Stats
File IO Stats

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)
Direct Reads	99.2G	40.93	28.452M	271M	3.95	.076M	0
Direct Writes	1.2G	2.47	.339M	77.8G	1884.31	22.317M	0
Buffer Cache Reads	6.9G	45.30	1.966M	0M	0.00	0M	34.4K	11.07
LGWR	1M	0.01	0M	3.6G	66.91	1.044M	66.2K	2.04
Others	764M	13.75	.214M	1.9G	7.25	.549M	52.5K	0.43
DBWR	18M	0.32	.005M	1.6G	43.21	.45M	1140	0.04
TOTAL:	108G	102.79	30.976M	85.2G	2005.64	24.437M	154.2K	3.49

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	104.5G	79.64	29.974M	78.8G	1933.75	22.585M	1.92	43.14
Temp File	2.8G	9.19	.789M	2.8G	3.94	.79M	9.18	11.73
Log File	0M	0.00	0M	3.6G	66.93	1.044M	3.13
Control File	778M	13.95	.218M	100M	1.78	.028M	0.21
Other	0M	0.01	0M	0M	0.01	0M	1.72
TOTAL:	108G	102.79	30.98M	85.3G	2006.41	24.447M	2.35	41.49

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)
Direct Reads	99.2G	40.93	28.452M	271M	3.95	.076M	0
Direct Reads (Data File)	99.2G	40.93	28.452M	271M	3.95	.076M	0
Direct Writes	1.2G	2.47	.339M	78G	1886.70	22.352M	0
Direct Writes (Data File)	1.2G	2.47	.339M	78G	1886.70	22.352M	0
Buffer Cache Reads	6.9G	45.31	1.966M	0M	0.00	0M	33K	10.42
Buffer Cache Reads (Data File)	6.9G	45.31	1.966M	0M	0.00	0M	33K	10.42
LGWR	1M	0.01	0M	3.6G	67.05	1.046M	42	1.40
LGWR (Log File)	0M	0.00	0M	3.6G	67.04	1.045M	16	1.63
LGWR (Control File)	1M	0.01	0M	1M	0.01	0M	26	1.27
Others	764M	13.75	.214M	1.9G	7.24	.549M	49.3K	0.21
Others (Data File)	4M	0.13	.001M	1.8G	5.47	.522M	684	0.09
Others (Control File)	760M	13.62	.213M	99M	1.77	.028M	48.6K	0.21
DBWR	18M	0.32	.005M	1.6G	43.21	.45M	1140	0.04
DBWR (Data File)	0M	0.00	0M	1.6G	43.21	.45M	0
DBWR (Control File)	18M	0.32	.005M	0M	0.00	0M	1140	0.04
TOTAL:	108G	102.79	30.976M	85.4G	2008.15	24.473M	83.5K	4.24

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
ESBF	45,884	13	1.03	34.12	5,162,108	8.81	0	1,445	813	7.47
BMBF	28,833	8	2.43	27.30	508,169	5.54	1	142	2,075	1.30
CFBF	38,273	11	0.66	96.56	281,594	2.40	1	79	114	4.74
WMBF	26,492	7	0.84	30.26	247,313	4.95	1	69	1,880	1.89
BTBF	30,226	8	0.50	25.39	223,131	6.47	0	62	464	4.01
XMBF	16,468	5	3.43	25.11	211,468	3.41	1	59	416	3.39
XABF	53,730	15	0.97	39.65	76,841	9.84	0	22	53	3.77
AMBF	34,264	10	0.78	102.59	80,998	1.71	1	23	164	4.09
TEMP	32,361	9	0.00	11.13	13,845	0.04	0	4	0	0.00
UNDOTBS1	39	0	0.00	1.00	41,870	0.01	0	12	258	0.19
HMBF	2,149	1	0.12	1.00	26,480	0.60	0	7	1,256	3.21
SYSTEM	1,689	0	14.74	1.10	8,149	0.47	15	2	1,351	1.61
TLBF	1,677	0	0.00	1.00	858	0.47	0	0	0	0.00
HSBF	1,131	0	0.00	1.00	702	0.32	0	0	0	0.00
SYSAUX	664	0	13.48	1.31	910	0.17	13	0	14	6.43
WHBF	975	0	0.00	1.00	546	0.27	0	0	0	0.00
DSG	42	0	0.95	1.00	39	0.01	1	0	0	0.00
TBS_ODIWORK	39	0	0.00	1.00	39	0.01	0	0	0	0.00
UNDOTBS2	39	0	0.00	1.00	39	0.01	0	0	5	0.00
USERS	39	0	0.00	1.00	39	0.01	0	0	0	0.00
XRAPUSER	39	0	0.00	1.00	39	0.01	0	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
AMBF	+DATA/odi/datafile/ambf.296.845207027	6,978	2	0.61	100.70	0	0.80	16,296	5	33	3.94
AMBF	+DATA/odi/datafile/ambf.300.845206911	6,761	2	1.01	101.84	0	1.20	16,135	5	25	4.80
AMBF	+DATA/odi/datafile/ambf.306.845206849	6,687	2	0.87	106.68	0	1.08	16,040	4	24	2.50
AMBF	+DATA/odi/datafile/ambf.309.845206731	6,746	2	0.73	105.88	0	0.79	16,333	5	46	5.22
AMBF	+DATA/odi/datafile/ambf.313.845206649	7,092	2	0.70	98.19	0	0.71	16,194	5	36	3.33
BMBF	+DATA/odi/datafile/bmbf.269.845214489	656	0	0.78	25.90	0	0.50	14,613	4	49	2.04
BMBF	+DATA/odi/datafile/bmbf.270.845122309	897	0	1.88	23.47	0	0.55	14,499	4	53	0.94
BMBF	+DATA/odi/datafile/bmbf.277.845213317	633	0	2.92	24.01	0	0.88	7,270	2	61	0.66
BMBF	+DATA/odi/datafile/bmbf.289.845213913	476	0	2.06	35.18	0	1.89	14,334	4	53	1.32
BMBF	+DATA/odi/datafile/bmbf.292.845214111	630	0	0.92	31.20	0	0.68	15,750	4	46	0.43
BMBF	+DATA/odi/datafile/bmbf.297.845213743	628	0	1.35	32.32	0	0.57	7,474	2	57	0.88
BMBF	+DATA/odi/datafile/bmbf.305.845213543	928	0	1.57	36.08	0	0.82	7,070	2	56	2.14
BMBF	+DATA/odi/datafile/bmbf.314.845213153	771	0	3.54	26.43	0	0.68	8,120	2	55	0.00
BMBF	+DATA/odi/datafile/bmbf.320.845213075	767	0	1.63	27.09	0	1.24	8,160	2	58	1.72
BMBF	+DATA/odi/datafile/bmbf.331.845212647	728	0	4.26	25.68	0	1.22	8,120	2	59	3.56
BMBF	+DATA/odi/datafile/bmbf.343.845212435	582	0	6.25	31.76	0	2.22	8,172	2	56	0.89
BMBF	+DATA/odi/datafile/bmbf.350.845212333	663	0	2.55	29.89	0	0.60	7,436	2	63	1.43
BMBF	+DATA/odi/datafile/bmbf.357.845212159	847	0	2.44	22.63	0	0.52	14,384	4	57	0.70
BMBF	+DATA/odi/datafile/bmbf.374.845135077	743	0	2.53	25.65	0	0.52	8,117	2	56	2.14
BMBF	+DATA/odi/datafile/bmbf.379.845135609	614	0	4.23	27.92	0	1.01	8,080	2	55	1.45
BMBF	+DATA/odi/datafile/bmbf.383.845136433	391	0	2.76	50.28	0	4.44	7,152	2	56	1.25
BMBF	+DATA/odi/datafile/bmbf.389.845137019	770	0	3.65	30.97	0	1.38	7,178	2	56	1.25
BMBF	+DATA/odi/datafile/bmbf.395.845137839	407	0	3.24	76.60	0	6.86	7,017	2	54	1.11
BMBF	+DATA/odi/datafile/bmbf.398.845138575	634	0	1.69	27.92	0	1.48	6,493	2	56	0.89
BMBF	+DATA/odi/datafile/bmbf.403.845139347	677	0	2.54	25.27	0	2.24	7,591	2	53	0.19
BMBF	+DATA/odi/datafile/bmbf.410.845140041	804	0	1.69	22.59	0	0.73	7,558	2	62	0.32
BMBF	+DATA/odi/datafile/bmbf.417.845140983	732	0	0.75	25.39	0	0.50	15,732	4	50	2.20
BMBF	+DATA/odi/datafile/bmbf.425.845142107	630	0	2.02	29.16	0	0.42	15,911	4	46	0.65
BMBF	+DATA/odi/datafile/bmbf.431.845143137	575	0	1.72	31.70	0	1.14	15,598	4	44	1.36
BMBF	+DATA/odi/datafile/bmbf.438.845144039	773	0	1.73	22.38	0	1.10	14,618	4	42	2.14
BMBF	+DATA/odi/datafile/bmbf.445.845144211	625	0	1.49	27.44	0	0.52	14,651	4	45	1.33
BMBF	+DATA/odi/datafile/bmbf.449.845145225	742	0	1.42	20.29	0	0.92	14,673	4	48	1.46
BMBF	+DATA/odi/datafile/bmbf.459.845146263	810	0	1.21	19.95	0	1.24	14,648	4	47	1.49
BMBF	+DATA/odi/datafile/bmbf.465.845203067	970	0	1.18	15.45	0	0.38	14,794	4	44	1.36
BMBF	+DATA/odi/datafile/bmbf.466.845202775	533	0	2.48	32.38	0	0.34	14,679	4	48	0.00
BMBF	+DATA/odi/datafile/bmbf.467.845202939	672	0	0.76	20.25	0	0.62	14,785	4	49	0.82
BMBF	+DATA/odi/datafile/bmbf.470.845203365	452	0	1.88	36.86	0	1.61	14,786	4	47	0.43
BMBF	+DATA/odi/datafile/bmbf.472.845203455	487	0	1.77	33.26	0	1.49	14,872	4	40	2.00
BMBF	+DATA/odi/datafile/bmbf.475.845203587	570	0	2.95	27.96	0	0.85	14,857	4	38	2.37
BMBF	+DATA/odi/datafile/bmbf.477.845203725	399	0	2.46	36.61	0	0.68	14,896	4	39	0.77
BMBF	+DATA/odi/datafile/bmbf.480.845203905	1,143	0	0.75	14.20	0	0.37	15,002	4	31	1.29
BMBF	+DATA/odi/datafile/bmbf.482.845203927	296	0	2.20	54.90	0	1.85	15,073	4	28	1.07
BMBF	+DATA/odi/datafile/bmbf.485.845204611	912	0	0.86	20.63	0	0.66	15,336	4	31	0.65
BMBF	+DATA/odi/datafile/bmbf.487.845204613	640	0	3.95	29.01	0	0.52	14,695	4	42	2.38
BMBF	+DATA/odi/datafile/bmbf.490.845205241	677	0	4.74	28.90	0	3.24	14,659	4	45	2.00
BMBF	+DATA/odi/datafile/bmbf.491.845205821	1,044	0	3.28	22.02	0	0.37	14,566	4	56	2.14
BMBF	+DATA/odi/datafile/bmbf.495.845205435	905	0	8.61	22.27	0	1.05	14,750	4	44	1.36
BTBF	+DATA/odi/datafile/btbf.271.845122359	2,804	1	0.66	32.56	1	0.41	31,996	9	60	4.00
BTBF	+DATA/odi/datafile/btbf.283.845126221	3,351	1	0.51	24.79	1	0.30	24,786	7	50	4.40
BTBF	+DATA/odi/datafile/btbf.284.845126281	3,421	1	0.49	24.76	1	0.26	24,006	7	56	5.71
BTBF	+DATA/odi/datafile/btbf.285.845126329	3,007	1	0.54	26.93	1	0.31	24,236	7	52	5.38
BTBF	+DATA/odi/datafile/btbf.287.845126381	2,895	1	0.60	26.13	1	0.39	23,247	7	47	3.62
BTBF	+DATA/odi/datafile/btbf.290.845126447	3,894	1	0.46	21.83	1	0.27	23,102	6	54	1.48
BTBF	+DATA/odi/datafile/btbf.294.845126865	3,458	1	0.43	23.77	1	0.16	23,175	6	49	3.67
BTBF	+DATA/odi/datafile/btbf.298.845127503	3,563	1	0.47	26.31	1	0.23	23,822	7	50	4.00
BTBF	+DATA/odi/datafile/btbf.303.845128151	3,833	1	0.39	23.71	1	0.29	24,761	7	46	3.70
CFBF	+DATA/odi/datafile/cfbf.272.845122409	1,937	1	0.73	115.70	0	3.09	13,729	4	25	2.00
CFBF	+DATA/odi/datafile/cfbf.302.845206879	2,359	1	0.81	87.05	0	1.01	13,371	4	12	7.50
CFBF	+DATA/odi/datafile/cfbf.354.845212259	1,968	1	0.74	108.19	0	1.05	13,780	4	7	7.14
CFBF	+DATA/odi/datafile/cfbf.413.845140127	2,620	1	0.55	84.68	0	0.25	13,122	4	7	2.86
CFBF	+DATA/odi/datafile/cfbf.420.845140985	2,076	1	0.50	104.54	0	0.98	13,719	4	4	12.50
CFBF	+DATA/odi/datafile/cfbf.424.845142107	2,254	1	0.47	102.20	0	0.17	22,136	6	5	6.00
CFBF	+DATA/odi/datafile/cfbf.432.845143137	2,354	1	0.58	89.31	0	0.42	22,206	6	3	3.33
CFBF	+DATA/odi/datafile/cfbf.443.845144161	2,237	1	0.34	86.90	0	0.12	22,313	6	5	2.00
CFBF	+DATA/odi/datafile/cfbf.450.845145225	2,375	1	0.39	85.13	0	0.24	22,303	6	2	5.00
CFBF	+DATA/odi/datafile/cfbf.454.845146253	1,772	0	0.53	112.02	0	1.78	21,955	6	1	0.00
CFBF	+DATA/odi/datafile/cfbf.460.845146861	2,087	1	0.74	96.20	0	0.26	15,365	4	4	5.00
CFBF	+DATA/odi/datafile/cfbf.468.845202873	2,081	1	0.61	96.19	0	0.43	14,512	4	9	6.67
CFBF	+DATA/odi/datafile/cfbf.469.845203161	2,201	1	1.33	97.52	0	1.05	15,155	4	6	10.00
CFBF	+DATA/odi/datafile/cfbf.474.845203493	1,961	1	0.67	106.65	0	1.47	15,104	4	9	3.33
CFBF	+DATA/odi/datafile/cfbf.479.845203879	2,543	1	0.64	98.41	0	1.33	14,745	4	2	5.00
CFBF	+DATA/odi/datafile/cfbf.484.845204555	2,751	1	0.74	94.44	0	0.73	14,328	4	9	2.22
CFBF	+DATA/odi/datafile/cfbf.489.845204655	2,697	1	0.80	90.40	0	0.35	13,751	4	4	5.00
DSG	+DATA/odi/datafile/dsg.268.845121707	42	0	0.95	1.00	0	0.95	39	0	0	0.00
ESBF	+DATA/odi/datafile/esbf.273.845122463	1,303	0	0.96	27.45	0	0.37	173,476	49	30	2.33
ESBF	+DATA/odi/datafile/esbf.301.845213551	1,561	0	0.42	51.40	0	0.22	178,460	50	18	2.22
ESBF	+DATA/odi/datafile/esbf.308.845213333	1,103	0	2.96	51.86	0	1.56	178,704	50	36	2.50
ESBF	+DATA/odi/datafile/esbf.310.845213175	2,010	1	1.49	32.36	0	0.83	179,744	50	34	1.76
ESBF	+DATA/odi/datafile/esbf.317.845213113	2,207	1	1.55	30.95	0	0.36	179,668	50	29	1.72
ESBF	+DATA/odi/datafile/esbf.323.845212803	2,891	1	0.73	18.36	1	0.13	179,646	50	24	1.67
ESBF	+DATA/odi/datafile/esbf.335.845212629	2,808	1	0.62	17.70	1	0.18	174,993	49	18	0.56
ESBF	+DATA/odi/datafile/esbf.346.845212423	2,904	1	0.53	21.36	1	0.14	171,629	48	30	3.67
ESBF	+DATA/odi/datafile/esbf.386.845136783	1,764	0	2.00	36.98	0	0.53	178,841	50	37	2.43
ESBF	+DATA/odi/datafile/esbf.391.845137043	2,054	1	1.29	40.45	0	0.77	174,447	49	28	1.07
ESBF	+DATA/odi/datafile/esbf.396.845137839	1,377	0	0.95	69.22	0	0.48	172,151	48	28	1.43
ESBF	+DATA/odi/datafile/esbf.399.845138575	1,399	0	0.96	62.79	0	1.06	178,852	50	30	3.33
ESBF	+DATA/odi/datafile/esbf.405.845139347	1,346	0	0.77	39.50	0	0.75	170,531	48	21	70.00
ESBF	+DATA/odi/datafile/esbf.408.845140035	1,164	0	1.71	46.21	0	2.36	182,599	51	20	4.50
ESBF	+DATA/odi/datafile/esbf.415.845140747	874	0	2.08	68.56	0	1.12	185,601	52	28	2.14
ESBF	+DATA/odi/datafile/esbf.422.845141045	1,112	0	0.60	43.16	0	0.40	187,708	53	24	2.50
ESBF	+DATA/odi/datafile/esbf.429.845142109	1,225	0	1.18	40.04	0	1.12	192,027	54	32	0.94
ESBF	+DATA/odi/datafile/esbf.434.845143137	1,228	0	1.21	41.70	0	0.62	194,562	54	30	59.67
ESBF	+DATA/odi/datafile/esbf.440.845144161	1,291	0	0.74	37.40	0	0.57	194,217	54	26	1.54
ESBF	+DATA/odi/datafile/esbf.448.845145223	1,448	0	0.69	30.54	0	0.38	194,522	54	25	3.20
ESBF	+DATA/odi/datafile/esbf.456.845146263	1,659	0	0.61	22.60	0	0.18	194,930	55	45	28.44
ESBF	+DATA/odi/datafile/esbf.461.845147035	1,836	1	0.83	24.98	0	0.63	189,463	53	34	2.65
ESBF	+DATA/odi/datafile/esbf.462.845202977	2,156	1	0.60	26.31	0	0.18	196,670	55	35	3.71
ESBF	+DATA/odi/datafile/esbf.471.845203411	1,091	0	0.94	35.26	0	0.20	196,751	55	34	1.18
ESBF	+DATA/odi/datafile/esbf.476.845203629	1,137	0	1.20	40.35	0	0.46	196,028	55	30	1.00
ESBF	+DATA/odi/datafile/esbf.481.845203913	2,135	1	0.80	22.47	0	0.24	196,255	55	31	3.55
ESBF	+DATA/odi/datafile/esbf.486.845204613	1,506	0	0.70	25.68	0	0.17	188,967	53	29	1.38
ESBF	+DATA/odi/datafile/esbf.492.845214649	1,295	0	1.47	34.11	0	0.22	180,666	51	27	0.00
HMBF	+DATA/odi/datafile/hmbf.274.845122513	59	0	0.17	1.00	0	0.17	1,139	0	67	3.28
HMBF	+DATA/odi/datafile/hmbf.280.845213971	131	0	0.00	1.00	0	0.00	1,194	0	69	4.49
HMBF	+DATA/odi/datafile/hmbf.288.845214127	130	0	0.00	1.00	0	0.00	1,140	0	60	3.00
HMBF	+DATA/odi/datafile/hmbf.293.845213803	104	0	0.10	1.00	0	0.10	1,248	0	69	2.75
HMBF	+DATA/odi/datafile/hmbf.414.845140623	130	0	0.00	1.00	0	0.00	1,198	0	67	2.69
HMBF	+DATA/odi/datafile/hmbf.421.845141039	133	0	0.08	1.00	0	0.08	1,231	0	74	2.97
HMBF	+DATA/odi/datafile/hmbf.428.845142107	132	0	0.00	1.00	0	0.00	1,156	0	65	4.31
HMBF	+DATA/odi/datafile/hmbf.433.845143137	124	0	0.00	1.00	0	0.00	1,117	0	50	2.40
HMBF	+DATA/odi/datafile/hmbf.441.845144161	97	0	0.00	1.00	0	0.00	1,263	0	63	4.76
HMBF	+DATA/odi/datafile/hmbf.446.845145203	86	0	0.00	1.00	0	0.00	1,326	0	58	2.41
HMBF	+DATA/odi/datafile/hmbf.453.845145315	85	0	0.00	1.00	0	0.00	1,268	0	50	4.00
HMBF	+DATA/odi/datafile/hmbf.457.845146263	89	0	0.00	1.00	0	0.00	1,300	0	47	2.13
HMBF	+DATA/odi/datafile/hmbf.464.845147037	88	0	0.00	1.00	0	0.00	1,317	0	45	3.11
HMBF	+DATA/odi/datafile/hmbf.496.845214933	89	0	0.00	1.00	0	0.00	1,327	0	45	4.89
HMBF	+DATA/odi/datafile/hmbf.497.845215215	92	0	0.00	1.00	0	0.00	1,360	0	59	2.20
HMBF	+DATA/odi/datafile/hmbf.498.845215381	98	0	0.20	1.00	0	0.20	1,357	0	62	4.19
HMBF	+DATA/odi/datafile/hmbf.499.845215525	95	0	0.11	1.00	0	0.11	1,289	0	63	2.86
HMBF	+DATA/odi/datafile/hmbf.500.845215663	95	0	0.00	1.00	0	0.00	1,370	0	64	1.72
HMBF	+DATA/odi/datafile/hmbf.501.845215745	100	0	1.00	1.00	0	1.00	1,401	0	63	2.38
HMBF	+DATA/odi/datafile/hmbf.502.845215893	95	0	0.32	1.00	0	0.32	1,277	0	59	3.39
HMBF	+DATA/odi/datafile/hmbf.503.845216495	97	0	0.72	1.00	0	0.72	1,202	0	57	3.51
HSBF	+DATA/odi/datafile/hsbf.275.845122565	39	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.291.845126485	39	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.295.845126871	39	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.299.845127505	39	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.304.845128155	39	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.307.845128629	39	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.311.845128743	39	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.315.845128897	78	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.318.845129055	78	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.321.845129405	78	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.325.845129777	78	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.329.845129913	78	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.333.845130507	78	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.337.845131099	78	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.340.845131615	78	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.344.845132105	78	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.347.845132285	78	0	0.00	1.00	0	0.00	39	0	0	0.00
HSBF	+DATA/odi/datafile/hsbf.351.845132817	78	0	0.00	1.00	0	0.00	39	0	0	0.00
SYSAUX	+DATA/odi/datafile/sysaux.257.844614421	664	0	13.48	1.31	0	12.73	910	0	14	6.43
SYSTEM	+DATA/odi/datafile/system.256.844614421	1,689	0	14.74	1.10	0	14.51	8,149	2	1,351	1.61
TBS_ODIWORK	+DATA/odi/datafile/tbs_odiwork.281.845122859	39	0	0.00	1.00	0	0.00	39	0	0	0.00
TEMP	+DATA/odi/tempfile/temp.263.844614521	32,361	9	0.00	11.13	0	0.39	13,845	4	0
TLBF	+DATA/odi/datafile/tlbf.276.845211143	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.286.845214333	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.324.845211055	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.328.845210933	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.332.845210877	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.336.845210821	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.341.845210685	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.345.845210573	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.353.845210339	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.361.845211481	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.362.845210131	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.365.845211423	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.369.845211291	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.370.845209871	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.371.845211197	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.380.845209645	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.388.845209503	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.400.845209369	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.409.845209223	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.423.845209075	78	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.435.845208959	39	0	0.00	1.00	0	0.00	39	0	0	0.00
TLBF	+DATA/odi/datafile/tlbf.493.845214623	78	0	0.00	1.00	0	0.00	39	0	0	0.00
UNDOTBS1	+DATA/odi/datafile/undotbs1.258.844614421	39	0	0.00	1.00	0	0.00	41,870	12	258	0.19
UNDOTBS2	+DATA/odi/datafile/undotbs2.264.844614607	39	0	0.00	1.00	0	0.00	39	0	5	0.00
USERS	+DATA/odi/datafile/users.259.844614421	39	0	0.00	1.00	0	0.00	39	0	0	0.00
WHBF	+DATA/odi/datafile/whbf.327.845212659	117	0	0.00	1.00	0	0.00	39	0	0	0.00
WHBF	+DATA/odi/datafile/whbf.339.845212507	78	0	0.00	1.00	0	0.00	39	0	0	0.00
WHBF	+DATA/odi/datafile/whbf.349.845210345	78	0	0.00	1.00	0	0.00	39	0	0	0.00
WHBF	+DATA/odi/datafile/whbf.358.845210141	78	0	0.00	1.00	0	0.00	39	0	0	0.00
WHBF	+DATA/odi/datafile/whbf.366.845209879	78	0	0.00	1.00	0	0.00	39	0	0	0.00
WHBF	+DATA/odi/datafile/whbf.375.845209657	78	0	0.00	1.00	0	0.00	39	0	0	0.00
WHBF	+DATA/odi/datafile/whbf.378.845208585	39	0	0.00	1.00	0	0.00	39	0	0	0.00
WHBF	+DATA/odi/datafile/whbf.384.845209517	78	0	0.00	1.00	0	0.00	39	0	0	0.00
WHBF	+DATA/odi/datafile/whbf.393.845209385	78	0	0.00	1.00	0	0.00	39	0	0	0.00
WHBF	+DATA/odi/datafile/whbf.407.845209237	78	0	0.00	1.00	0	0.00	39	0	0	0.00
WHBF	+DATA/odi/datafile/whbf.416.845209087	78	0	0.00	1.00	0	0.00	39	0	0	0.00
WHBF	+DATA/odi/datafile/whbf.430.845209031	39	0	0.00	1.00	0	0.00	39	0	0	0.00
WHBF	+DATA/odi/datafile/whbf.439.845208887	39	0	0.00	1.00	0	0.00	39	0	0	0.00
WHBF	+DATA/odi/datafile/whbf.452.845208797	39	0	0.00	1.00	0	0.00	39	0	0	0.00
WMBF	+DATA/odi/datafile/wmbf.278.845122709	1,192	0	0.45	28.64	0	0.25	10,909	3	79	1.39
WMBF	+DATA/odi/datafile/wmbf.355.845132939	899	0	0.48	37.39	0	0.51	10,965	3	72	2.64
WMBF	+DATA/odi/datafile/wmbf.359.845133333	839	0	0.70	42.29	0	0.61	9,970	3	91	3.08
WMBF	+DATA/odi/datafile/wmbf.363.845133793	888	0	0.88	44.10	0	0.65	10,003	3	86	1.05
WMBF	+DATA/odi/datafile/wmbf.368.845134387	922	0	0.62	39.47	0	0.52	10,456	3	79	1.65
WMBF	+DATA/odi/datafile/wmbf.372.845134969	666	0	1.55	49.88	0	2.07	10,306	3	80	1.38
WMBF	+DATA/odi/datafile/wmbf.377.845135595	1,273	0	0.75	28.93	0	0.43	10,121	3	94	2.45
WMBF	+DATA/odi/datafile/wmbf.382.845136433	770	0	0.90	56.40	0	1.30	10,079	3	86	2.21
WMBF	+DATA/odi/datafile/wmbf.387.845137013	1,116	0	0.58	47.88	0	0.71	9,155	3	90	2.44
WMBF	+DATA/odi/datafile/wmbf.392.845137825	996	0	0.84	34.96	0	0.75	9,372	3	91	1.43
WMBF	+DATA/odi/datafile/wmbf.397.845138075	1,548	0	0.34	19.92	0	0.21	9,649	3	80	2.00
WMBF	+DATA/odi/datafile/wmbf.402.845138589	1,399	0	0.81	21.70	0	0.50	9,610	3	80	1.63
WMBF	+DATA/odi/datafile/wmbf.406.845139347	1,264	0	1.50	23.11	0	1.50	9,759	3	81	1.23
WMBF	+DATA/odi/datafile/wmbf.412.845140045	1,281	0	0.98	22.62	0	0.92	9,440	3	75	1.60
WMBF	+DATA/odi/datafile/wmbf.419.845140985	998	0	1.25	26.87	0	1.29	9,629	3	76	1.58
WMBF	+DATA/odi/datafile/wmbf.426.845142107	968	0	2.25	25.48	0	2.95	9,721	3	82	1.22
WMBF	+DATA/odi/datafile/wmbf.436.845143137	1,360	0	0.21	23.30	0	0.20	10,068	3	74	1.35
WMBF	+DATA/odi/datafile/wmbf.444.845144161	1,193	0	0.60	24.25	0	0.28	10,700	3	70	1.57
WMBF	+DATA/odi/datafile/wmbf.451.845145225	959	0	0.36	27.82	0	0.39	10,790	3	69	1.01
WMBF	+DATA/odi/datafile/wmbf.455.845146261	1,453	0	1.82	19.75	0	1.65	11,743	3	63	1.11
WMBF	+DATA/odi/datafile/wmbf.463.845203139	1,218	0	0.81	25.59	0	0.45	11,369	3	76	1.45
WMBF	+DATA/odi/datafile/wmbf.473.845203487	1,355	0	0.66	25.48	0	0.30	11,300	3	62	4.68
WMBF	+DATA/odi/datafile/wmbf.478.845203871	948	0	0.47	29.73	0	0.47	11,136	3	74	3.24
WMBF	+DATA/odi/datafile/wmbf.483.845204279	987	0	0.73	40.87	0	0.68	11,063	3	70	2.14
XABF	+DATA/odi/datafile/xabf.279.845122761	2,699	1	1.29	28.61	1	0.88	3,456	1	0	0.00
XABF	+DATA/odi/datafile/xabf.348.845132287	2,728	1	0.76	29.77	1	0.27	3,708	1	0	0.00
XABF	+DATA/odi/datafile/xabf.352.845132843	2,080	1	0.85	36.75	0	0.32	4,102	1	3	3.33
XABF	+DATA/odi/datafile/xabf.356.845133125	2,336	1	0.84	43.55	0	0.24	4,012	1	0	0.00
XABF	+DATA/odi/datafile/xabf.360.845133441	1,969	1	1.70	48.48	0	0.38	3,083	1	0	0.00
XABF	+DATA/odi/datafile/xabf.364.845133801	2,240	1	1.44	48.75	0	1.05	2,735	1	0	0.00
XABF	+DATA/odi/datafile/xabf.367.845134387	1,608	0	1.87	64.29	0	1.12	2,643	1	0	0.00
XABF	+DATA/odi/datafile/xabf.373.845134969	2,142	1	1.10	39.70	0	0.49	2,784	1	2	0.00
XABF	+DATA/odi/datafile/xabf.376.845135595	1,754	0	1.41	57.56	0	0.95	2,931	1	5	2.00
XABF	+DATA/odi/datafile/xabf.381.845136393	1,592	0	1.24	66.50	0	0.92	3,105	1	4	5.00
XABF	+DATA/odi/datafile/xabf.385.845136473	1,547	0	1.58	65.53	0	1.09	2,973	1	1	10.00
XABF	+DATA/odi/datafile/xabf.390.845137019	2,005	1	1.07	60.68	0	1.11	3,062	1	2	5.00
XABF	+DATA/odi/datafile/xabf.394.845137839	2,095	1	0.98	44.87	0	0.60	3,413	1	2	5.00
XABF	+DATA/odi/datafile/xabf.401.845138577	1,715	0	0.96	58.48	0	0.44	3,417	1	5	6.00
XABF	+DATA/odi/datafile/xabf.404.845139347	2,572	1	0.59	37.18	0	0.13	3,511	1	3	0.00
XABF	+DATA/odi/datafile/xabf.411.845140045	2,454	1	1.07	34.78	0	0.54	3,451	1	6	3.33
XABF	+DATA/odi/datafile/xabf.418.845140983	3,013	1	0.67	29.44	1	0.11	3,364	1	3	3.33
XABF	+DATA/odi/datafile/xabf.427.845142107	3,101	1	0.51	25.90	1	0.08	3,513	1	2	0.00
XABF	+DATA/odi/datafile/xabf.437.845143137	3,058	1	0.60	29.28	1	0.12	3,659	1	3	6.67
XABF	+DATA/odi/datafile/xabf.442.845144161	2,790	1	0.70	30.46	1	0.16	3,474	1	4	5.00
XABF	+DATA/odi/datafile/xabf.447.845145223	2,995	1	0.92	31.44	1	0.56	3,667	1	5	4.00
XABF	+DATA/odi/datafile/xabf.458.845146263	2,415	1	0.76	30.78	0	0.10	3,151	1	2	0.00
XABF	+DATA/odi/datafile/xabf.488.845204639	2,822	1	0.67	29.63	1	0.05	3,627	1	1	10.00
XMBF	+DATA/odi/datafile/xmbf.312.845208109	1,588	0	4.63	26.99	0	1.05	20,168	6	35	1.71
XMBF	+DATA/odi/datafile/xmbf.316.845208053	866	0	5.46	48.18	0	1.07	14,895	4	39	2.31
XMBF	+DATA/odi/datafile/xmbf.319.845207967	725	0	5.83	53.72	0	1.08	15,652	4	61	8.69
XMBF	+DATA/odi/datafile/xmbf.322.845207825	1,240	0	4.40	32.13	0	0.55	22,534	6	34	4.12
XMBF	+DATA/odi/datafile/xmbf.326.845207697	876	0	6.30	44.37	0	1.56	16,079	5	35	1.71
XMBF	+DATA/odi/datafile/xmbf.330.845207569	2,634	1	2.24	15.84	1	0.39	23,552	7	52	2.12
XMBF	+DATA/odi/datafile/xmbf.334.845207419	1,964	1	2.36	20.39	0	0.22	32,244	9	44	5.91
XMBF	+DATA/odi/datafile/xmbf.338.845207255	3,164	1	2.03	13.83	1	0.24	25,533	7	47	1.28
XMBF	+DATA/odi/datafile/xmbf.342.845207195	1,018	0	5.57	42.18	0	1.12	16,995	5	35	0.86
XMBF	+DATA/odi/datafile/xmbf.494.845214901	2,393	1	2.72	17.88	1	0.45	23,816	7	34	2.06
XRAPUSER	+DATA/odi/datafile/xrapuser.282.845122909	39	0	0.00	1.00	0	0.00	39	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	3,419,088	97	31,015,407	905,503	205,820	0	0	8,902

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 10,655,624

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	16,813	154,069

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	0	396	2325	2427	1698651	2427			0
E	0	5	3120	47892	1698651	1698651	3798655			2

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,816	0.10	330	1.02	3,339	1	781.00
D	5,632	0.19	660	1.02	3,320	1	768.00
D	8,448	0.29	990	1.01	3,309	1	760.00
D	11,264	0.39	1,320	1.00	3,280	1	740.00
D	14,080	0.48	1,650	1.00	3,272	1	735.00
D	16,896	0.58	1,979	1.00	3,266	1	731.00
D	19,712	0.68	2,309	1.00	3,265	1	730.00
D	22,528	0.77	2,639	1.00	3,264	1	730.00
D	25,344	0.87	2,969	1.00	3,264	1	730.00
D	28,160	0.96	3,299	1.00	3,264	1	730.00
D	29,184	1.00	3,419	1.00	3,264	1	730.00
D	30,976	1.06	3,629	1.00	3,264	1	730.00
D	33,792	1.16	3,959	1.00	3,264	1	730.00
D	36,608	1.25	4,289	1.00	3,264	1	730.00
D	39,424	1.35	4,619	1.00	3,264	1	730.00
D	42,240	1.45	4,949	1.00	3,264	1	730.00
D	45,056	1.54	5,279	1.00	3,264	1	730.00
D	47,872	1.64	5,609	1.00	3,264	1	730.00
D	50,688	1.74	5,938	1.00	3,264	1	730.00
D	53,504	1.83	6,268	1.00	3,264	1	730.00
D	56,320	1.93	6,598	1.00	3,256	1	723.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
84.91	35,592	6,328

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

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	1-Pass Execs
2K	4K	56,627	56,627	0
64K	128K	632	632	0
128K	256K	58	58	0
256K	512K	62	62	0
512K	1024K	196	196	0
1M	2M	581	581	0
2M	4M	158	158	0
4M	8M	134	134	0
8M	16M	230	230	0
16M	32M	220	220	0
32M	64M	118	118	0
64M	128M	32	32	0
128M	256M	30	30	0
256M	512M	14	14	0
512M	1024M	2	2	0
1G	2G	4	0	4

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 PGA Cache Hit %	Estd Time
3,040	0.13	88,397.77	100.00	23,050,303
6,080	0.25	88,397.77	100.00	23,050,303
12,160	0.50	88,397.77	100.00	23,050,303
18,240	0.75	88,397.77	100.00	23,050,303
24,320	1.00	88,397.77	100.00	23,050,303
29,184	1.20	88,397.77	100.00	23,050,303
34,048	1.40	88,397.77	100.00	23,050,303
38,912	1.60	88,397.77	100.00	23,050,303
43,776	1.80	88,397.77	100.00	23,050,303
48,640	2.00	88,397.77	100.00	23,050,303
72,960	3.00	88,397.77	100.00	23,050,303
97,280	4.00	88,397.77	100.00	23,050,303
145,920	6.00	88,397.77	100.00	23,050,303
194,560	8.00	88,397.77	100.00	23,050,303

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)
4,736	0.88	586	19,523	270,173	1.00	6,234	1.01	14,966
4,864	0.90	713	22,141	270,180	1.00	6,227	1.01	15,101
4,992	0.93	840	24,704	270,195	1.00	6,212	1.01	15,195
5,120	0.95	967	27,244	270,223	1.00	6,184	1.01	15,198
5,248	0.98	1,094	29,786	270,251	1.00	6,156	1.00	15,202
5,376	1.00	1,221	32,263	270,263	1.00	6,144	1.00	15,203
5,504	1.02	1,349	34,623	270,273	1.00	6,134	1.00	15,203
5,632	1.05	1,477	36,991	270,284	1.00	6,123	1.00	15,204
5,760	1.07	1,605	39,352	270,294	1.00	6,113	1.00	15,204
5,888	1.10	1,733	41,712	270,308	1.00	6,099	0.99	15,205
6,016	1.12	1,861	43,940	270,318	1.00	6,089	0.99	15,206
6,144	1.14	1,989	46,271	270,330	1.00	6,077	0.99	15,206
6,272	1.17	2,117	48,741	270,349	1.00	6,058	0.99	15,207
6,400	1.19	2,244	51,116	270,370	1.00	6,037	0.98	15,208
6,528	1.21	2,371	53,542	270,396	1.00	6,011	0.98	15,209
6,656	1.24	2,499	55,887	270,423	1.00	5,984	0.97	15,211
7,296	1.36	3,139	67,244	270,509	1.00	5,898	0.96	15,214
7,936	1.48	3,778	78,718	270,526	1.00	5,881	0.96	15,215
8,576	1.60	4,418	90,280	270,526	1.00	5,881	0.96	15,215
9,216	1.71	5,057	103,833	270,528	1.00	5,879	0.96	15,216
9,856	1.83	5,697	117,430	270,551	1.00	5,856	0.95	15,217
10,496	1.95	6,336	132,938	270,594	1.00	5,813	0.95	15,219
11,136	2.07	6,975	146,237	270,645	1.00	5,762	0.94	15,221

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
9,056	0.25	497,818	3,176,815
13,584	0.38	497,519	3,176,815
18,112	0.50	497,420	3,158,456
22,640	0.63	497,420	3,148,498
27,168	0.75	497,371	3,119,247
31,696	0.88	497,371	3,111,779
36,224	1.00	497,369	3,111,779
40,752	1.13	497,371	3,111,779
45,280	1.25	497,371	3,111,779
49,808	1.38	497,371	3,111,779
54,336	1.50	497,374	3,111,779
58,864	1.63	497,374	3,111,779
63,392	1.75	497,378	3,111,779
67,920	1.88	497,378	3,103,688
72,448	2.00	497,379	3,103,688

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)	Avg Time (ms)
file header block	7,237	21	3
data block	1,342	2	2
segment header	59	0	2
undo header	92	0	0
undo block	172	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
PS-PX Process Reservation	147,500	119,129	28,338	27,414	40	1.45
CR-Reuse Block Range (block range reuse ckpt)	47,986	47,989	0	1,945	13	6.51
RO-Multiple Object Reuse (fast object reuse)	2,700	2,700	0	665	12	17.71
TS-Temporary Segment	4,106	4,106	0	1,838	3	1.65
DL-Direct Loader Index Creation	6,676	6,676	0	1,593	2	1.53
TT-Tablespace	32,684	32,682	0	1,480	2	1.45
CO-KTUCLO Master Slave enq (master slave det)	1,189	0	1,189	1,189	2	1.43
FB-Format Block	1,905	1,905	0	860	2	1.78
TM-DML	92,419	92,165	248	1,103	1	1.21
HW-Segment High Water Mark	34,388	34,388	0	537	1	1.69
KO-Multiple Object Checkpoint (fast object checkpoint)	1,100	1,100	0	324	1	2.16
TX-Transaction (allocate ITL entry)	289	289	0	284	1	2.18
WF-AWR Flush	22	22	0	19	1	32.11
TX-Transaction (index contention)	16	16	0	11	0	40.91
CF-Controlfile Transaction	9,615	9,588	27	349	0	1.12
JS-Job Scheduler (queue lock)	147,707	147,707	0	1	0	280.00
TX-Transaction (row lock contention)	175	175	0	165	0	1.52
PI-Remote PX Process Spawn Status	172	172	0	86	0	1.63
TA-Instance Undo	15	15	0	15	0	0.67
AE-Edition Lock (lock)	67	67	0	3	0	3.33
JS-Job Scheduler (job run lock - synchronize)	2	2	0	2	0	5.00
MW-MWIN Schedule	2	2	0	2	0	5.00
JQ-Job Queue	4	4	0	1	0	10.00
TD-KTF map table enqueue (KTF dump entries)	8	8	0	8	0	0.00
SW-Suspend Writes	228	228	0	3	0	0.00
PE-Parameter	12	12	0	3	0	0.00
PG-Global Parameter	6	6	0	3	0	0.00
AF-Advisor Framework (task serialization)	13	13	0	2	0	0.00
DR-Distributed Recovery	2	2	0	2	0	0.00
TX-Transaction	92,397	92,353	0	1	0	0.00
UL-User-defined	6	6	0	1	0	0.00
DT-Default Temporary Tablespace	1	1	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	46.24	55,344	888	45	24.2/30.6	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
21-Apr 10:53	40,024	33,337	888	36	27	0/0	0/0/0/0/0/0
21-Apr 10:43	5,662	21,324	287	45	30	0/0	0/0/0/0/0/0
21-Apr 10:33	108	140	730	6	24	0/0	0/0/0/0/0/0
21-Apr 10:23	92	104	129	5	30	0/0	0/0/0/0/0/0
21-Apr 10:13	90	225	735	5	24	0/0	0/0/0/0/0/0
21-Apr 10:03	264	214	133	7	31	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0	0
AQ dequeue txn counter latch	118	0.00		0	0
ASM Keyed state latch	276	0.00		0	0
ASM allocation	2,394	0.00		0	0
ASM db client latch	13,249	0.00		0	0
ASM map headers	3,820	0.00		0	0
ASM map load waiting list	826	0.00		0	0
ASM map operation freelist	5,619	0.02	1.00	0	0
ASM map operation hash table	17,606,306	0.00	0.14	0	0
ASM network background latch	27,849	0.00		0	0
ASM network state latch	2,505	0.00		0	0
AWR Alerted Metric Element list	36,572	0.00		0	0
Change Notification Hash table latch	6,072	0.00		0	0
Consistent RBA	65,937	0.00	0.00	0	0
DML lock allocation	184,353	0.00	0.00	0	0
Event Group Locks	14,331	0.06	0.00	0	0
FIB s.o chain latch	468	0.00		0	0
FOB s.o list latch	12,124	0.91	0.14	0	0
File State Object Pool Parent Latch	1	0.00		0	0
I/O Staticstics latch	1	0.00		0	0
IPC other latch	30	0.00		0	0
IPC stats buffer allocation latch	54,359	0.00		0	54,621	0.00
In memory undo latch	1	0.00		0	0
JS Sh mem access	7	14.29	1.00	0	0
JS broadcast add buf latch	8,307	0.00		0	0
JS broadcast drop buf latch	8,308	0.00		0	0
JS broadcast load blnc latch	8,205	0.00		0	0
JS mem alloc latch	8	0.00		0	0
JS queue access latch	9	0.00		0	0
JS queue state obj latch	295,414	0.00		0	0
JS slv state obj latch	25	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KFK SGA Libload latch	1,800	0.00		0	0
KFMD SGA	47	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	267,503	0.47	0.10	0	59,464	0.23
KJCT flow control latch	1,871,357	0.08	0.03	0	0
KMG MMAN ready and startup request latch	1,885	0.00		0	0
KMG resize request state object freelist	6	0.00		0	0
KSXR large replies	240	0.00		0	0
KTF sga latch	28	0.00		0	977	0.00
KWQMN job cache list latch	253	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	1,157	0.00		0	0
MQL Tracking Latch	0			0	71	0.00
Memory Management Latch	783	0.00		0	1,885	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
MinActiveScn Latch	1,249	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	1,088	0.00		0	0
OS process allocation	7,848	0.04	0.00	0	0
OS process: request allocation	276	0.00		0	0
PL/SQL warning settings	58,600	0.00	0.00	0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	30,650	0.89	0.17	0	0
SGA IO buffer pool latch	1,505	0.00		0	2,221	0.23
SGA blob parent	1	0.00		0	0
SGA bucket locks	1	0.00		0	0
SGA heap locks	1	0.00		0	0
SGA pool locks	1	0.00		0	0
SQL memory manager latch	120	0.00		0	1,184	0.00
SQL memory manager workarea list latch	223,893	0.00	0.00	0	0
Shared B-Tree	126	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	1	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	34,596	0.85	0.01	0	0
active service list	193,350	0.28	0.05	0	1,799	0.00
begin backup scn array	6,714,256	0.11	0.12	0	0
buffer pool	7	0.00		0	0
business card	3,611	0.00		0	0
cache buffer handles	5,795	0.00		0	0
cache buffers chains	84,318,924	0.01	0.27	0	4,870,990	0.12
cache buffers lru chain	1,385,176	0.52	0.06	0	5,012,063	0.70
cache table scan latch	16,312	0.04	0.57	0	16,441	0.09
call allocation	56,829	1.72	0.57	0	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	418	0.00		0	0
channel operations parent latch	25,031,726	0.00	0.02	0	0
checkpoint queue latch	1,850,387	0.01	0.14	0	309,810	0.01
client/application info	98,587	0.02	0.00	0	0
compile environment latch	14,172	0.03	0.00	0	0
corrupted undo seg latch	3,319	0.03	0.00	0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	57	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	57	0.00		0	0
dml lock allocation	5,259	0.34	0.00	0	0
done queue latch	1	0.00		0	0
dummy allocation	28,321	1.06	0.03	0	0
eighth spare latch - X parent	1	0.00		0	0
eleventh spare latch - children	1	0.00		0	0
enqueue freelist latch	1	0.00		0	13,842,045	0.04
enqueue hash chains	14,962,268	0.06	0.15	0	8,701	0.05
enqueues	239	0.00		0	0
error message lists	72,235	0.59	0.00	0	0
fifteenth spare latch - children	1	0.00		0	0
file cache latch	62,049	0.06	0.17	0	0
first Audit Vault latch	7	0.00		0	0
flashback copy	1	0.00		0	0
fourteenth spare latch - children	1	0.00		0	0
fourth Audit Vault latch	1	0.00		0	0
gc element	4,515,926	0.93	0.11	2	129,630	1.32
gc persistent rm	7	0.00		0	0
gcs affinity object freelist latch	3	0.00		0	0
gcs commit scn state	1	0.00		0	0
gcs opaque info freelist	175,290	0.09	0.10	0	0
gcs partitioned table hash	10,565,550	0.06	0.00	0	308,695	0.02
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs remaster request queue	85,025	0.00		0	0
gcs remastering latch	637	0.16	0.00	0	27	0.00
gcs resource freelist	380,191	0.30	0.02	0	358,458	0.16
gcs resource hash	16,927,512	0.02	0.11	0	354	1.13
gcs resource scan list	800	0.00		0	0
gcs resource validate list	1	0.00		0	0
gcs shadows freelist	52,759	0.00	0.00	0	448,198	0.00
ges DFS wait callback info	150	0.00		0	25	0.00
ges caches resource lists	1,456,031	0.06	0.06	0	489,923	0.11
ges deadlock list	86,764	0.00	0.50	0	1,949	0.00
ges domain table	4,083,257	0.00	0.18	0	0
ges enqueue table freelist	4,444,390	0.01	0.02	0	0
ges group table	4,219,141	0.00	0.02	0	0
ges process hash list	71,680	0.00	0.00	0	0
ges process parent latch	9,857,847	0.49	0.99	2	0
ges process table freelist	276	0.72	0.00	0	0
ges resource hash list	9,857,917	0.56	0.94	5	171,271	0.75
ges resource scan list	72,476	0.00	0.50	0	0
ges resource table freelist	224,169	0.01	0.10	0	2	0.00
ges timeout list	159,103	0.01	0.21	0	16,116	0.02
ges value block free list	56,159	0.00	1.00	0	0
global KZLD latch for mem in SGA	40	0.00		0	0
global tx hash mapping	1	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	323	0.31	0.00	0	79,779,401	0.18
hash table modification latch	151	0.00		0	0
heartbeat check	1	0.00		0	1,010	0.00
heartbeat structure management	0			0	714	0.00
internal temp table object number allocation latch	51	0.00		0	0
interrupt manipulation	73,368	0.70	0.00	0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	7	0.00		0	6	0.00
job_queue_processes free list latch	16	0.00		0	0
job_queue_processes parameter latch	8,269	0.00		0	0
k2q global data latch	2,380	0.00		0	0
k2q lock allocation	1	0.00		0	0
kcbtsemkid latch	2	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kgnfs mount latch	1	0.00		0	0
kokc descriptor allocation latch	6	0.00		0	0
ksfv messages	1	0.00		0	0
ksim group membership cache	24,215	0.03	0.00	0	0
ksim membership request latch	12	0.00		0	2,477	0.00
kss move lock	51	0.00		0	0
ksuosstats global area	360	0.00		0	0
ksv allocation latch	147	0.00		0	0
ksv class latch	22,108	0.00	0.00	0	0
ksv instance latch	32	0.00		0	0
ksv msg queue latch	605	0.00		0	604	0.00
ksxp shared latch	276	0.00		0	0
ksxp so latch	276	0.00		0	0
ksz_so allocation latch	276	1.81	0.00	0	0
ktm global data	939	0.00		0	0
kwqbsn:qsga	125	0.00		0	0
lgwr LWN SCN	66,498	0.23	0.02	0	0
list of block allocation	2,055	0.00		0	0
loader state object freelist	33,247	0.03	0.00	0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	13	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
logical standby cache	1	0.00		0	0
logminer context allocation	1	0.00		0	0
logminer local	1	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	47	0.00		0	47	0.00
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	39,173	0.01	0.00	0	0
messages	1,440,633	0.07	0.04	0	0
mostly latch-free SCN	69,061	2.24	0.05	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	63,836	0.13	0.20	0	0
name-service entry	4,378	0.00		0	0
name-service memory objects	22,210	0.02	0.00	0	1	0.00
name-service namespace bucket	112,463	0.01	0.22	0	0
name-service namespace objects	2,207	0.00		0	0
name-service pending queue	17,280	0.00		0	0
name-service request	4,752	0.19	0.00	0	0
name-service request queue	51,113	0.01	0.33	0	0
ncodef allocation latch	57	0.00		0	0
nineth spare latch - X parent	1	0.00		0	0
object queue header heap	256,163	0.00	0.00	0	10,014	0.04
object queue header operation	4,236,646	0.10	0.13	0	89,557	0.05
object stats modification	4,079	0.17	0.00	0	0
parallel query alloc buffer	695,383	0.48	0.04	0	0
parallel query stats	20,628	0.52	0.01	0	0
parallel txn reco latch	989	0.00		0	0
parameter list	431	0.00		0	0
parameter table management	281,238	0.64	0.02	0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
post/wait queue	384,529	0.01	0.04	0	382,518	0.01
process allocation	19,815	0.00		0	158	0.00
process group creation	276	1.09	0.00	0	0
process queue	275,064	0.14	0.02	0	0
process queue reference	22,345,078	0.00	0.04	0	902,546	21.14
qmn task queue latch	509	0.00		0	0
query server freelists	328,925	0.06	0.02	0	0
query server process	14,074	0.43	0.93	6	54	0.00
queued dump request	12	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	261,462	3.59	0.16	0	14,466,070	0.95
redo copy	1	0.00		0	14,475,944	0.02
redo writing	283,845	0.07	0.06	0	0
resmgr group change latch	14,085	0.12	0.00	0	0
resmgr:active threads	28,321	0.00		0	0
resmgr:actses change group	14,107	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	28,320	1.42	0.03	0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	31	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	160,605,074	1.71	0.01	2	13,700	2.47
second Audit Vault latch	1	0.00		0	0
segmented array pool	468	0.00		0	0
sequence cache	92,200	0.01	0.25	0	0
session allocation	145,190	0.01	0.00	0	116,796	0.00
session idle bit	4,034,789	0.00	0.11	0	0
session queue latch	1	0.00		0	0
session state list latch	28,369	1.09	0.00	0	0
session switching	176	0.57	0.00	0	0
session timer	1,190	0.00		0	0
seventh spare latch - X parent	1	0.00		0	0
shared pool	6,873,536	0.34	0.11	1	3,280	0.12
shared pool sim alloc	1,928	0.05	1.00	0	0
shared pool simulator	245,961	0.00	0.13	0	0
sim partition latch	1	0.00		0	0
simulator hash latch	2,322,315	0.00	0.20	0	0
simulator lru latch	1,233	0.16	1.00	0	2,149,786	0.08
sixth spare latch - X parent	1	0.00		0	0
sort extent pool	4,295	0.00		0	0
space background state object latch	17	0.00		0	0
space background task latch	10,162	4.38	0.61	0	3,170	0.28
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
tablespace key chain	1	0.00		0	0
temp lob duration state obj allocation	3	0.00		0	0
temporary table state object allocation	5	0.00		0	0
tenth spare latch - X parent	1	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
thirteenth spare latch - children	1	0.00		0	0
threshold alerts latch	306	0.00		0	0
trace latch	9	0.00		0	0
transaction allocation	35,556	0.00	1.00	0	0
twelfth spare latch - children	1	0.00		0	0
twenty-fifth spare latch - S par	1	0.00		0	0
twenty-first spare latch - S par	1	0.00		0	0
twenty-fourth spare latch - S par	1	0.00		0	0
twenty-second spare latch - S par	1	0.00		0	0
twenty-third spare latch - S par	1	0.00		0	0
undo global data	605,495	0.01	0.06	0	194	0.00
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0
write info latch	0			0	78,495	0.40

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
row cache objects	160,605,074	2,746,469	19,013	2,728,610
ges resource hash list	9,857,917	55,166	51,818	3,476
ges process parent latch	9,857,847	47,858	47,306	591
gc element	4,515,926	42,128	4,504	37,911
shared pool	6,873,536	23,427	2,657	21,046
redo allocation	261,462	9,396	1,524	7,961
enqueue hash chains	14,962,268	8,812	1,284	7,633
begin backup scn array	6,714,256	7,646	892	6,858
cache buffers lru chain	1,385,176	7,256	449	6,843
cache buffers chains	84,318,924	4,455	1,202	3,314
object queue header operation	4,236,646	4,077	542	3,571
gcs resource hash	16,927,512	3,720	391	3,357
parallel query alloc buffer	695,383	3,317	136	3,192
parameter table management	281,238	1,792	35	1,759
KJCT flow control latch	1,871,357	1,569	51	1,521
mostly latch-free SCN	69,061	1,546	77	1,474
KJC message pool free list	267,503	1,256	127	1,136
gcs resource freelist	380,191	1,128	24	1,108
call allocation	56,829	980	554	523
messages	1,440,633	940	40	902
ges caches resource lists	1,456,031	852	48	807
process queue reference	22,345,078	839	37	807
active service list	193,350	544	25	521
ges enqueue table freelist	4,444,390	520	9	512
interrupt manipulation	73,368	517	2	515
space background task latch	10,162	445	270	202
error message lists	72,235	428	1	427
resmgr:free threads list	28,320	402	11	391
process queue	275,064	377	8	371
ASM map operation hash table	17,606,306	352	51	303
session state list latch	28,369	309	1	308
dummy allocation	28,321	301	8	295
active checkpoint queue latch	34,596	293	3	290
channel operations parent latch	25,031,726	291	7	284
Real-time plan statistics latch	30,650	272	47	230
redo writing	283,845	212	13	199
query server freelists	328,925	183	4	179
gcs opaque info freelist	175,290	165	16	149
lgwr LWN SCN	66,498	152	3	149
checkpoint queue latch	1,850,387	148	21	127
session idle bit	4,034,789	128	14	116
FOB s.o list latch	12,124	110	15	96
parallel query stats	20,628	108	1	107
ges group table	4,219,141	83	2	81
multiblock read objects	63,836	80	16	65
query server process	14,074	60	56	6
undo global data	605,495	54	3	51
post/wait queue	384,529	45	2	43
simulator hash latch	2,322,315	44	9	35
file cache latch	62,049	36	6	30
ges resource table freelist	224,169	29	3	26
ges timeout list	159,103	19	4	15
ges domain table	4,083,257	17	3	15
sequence cache	92,200	12	3	10
name-service namespace bucket	112,463	9	2	8
shared pool simulator	245,961	8	1	7
cache table scan latch	16,312	7	4	4
name-service request queue	51,113	3	1	2
ges deadlock list	86,764	2	1	1
ges resource scan list	72,476	2	1	1
simulator lru latch	1,233	2	2	0
ASM map operation freelist	5,619	1	1	0
JS Sh mem access	7	1	1	0
ges value block free list	56,159	1	1	0
shared pool sim alloc	1,928	1	1	0
transaction allocation	35,556	1	1	0

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
ASM map operation freelist	kffmTranslate2	1	0
ASM map operation hash table	kffmTranslate	29	17
ASM map operation hash table	kffmDoDone_1	22	29
FOB s.o list latch	ksfd_allfob	15	15
JS Sh mem access	jsksGetShMemLatch	1	1
KJC message pool free list	kjcsmpav: allocate a msg buffer	89	127
KJC message pool free list	kjcspfmbq: free vector of msg buffers	38	0
KJCT flow control latch	kjcts_sqenq: queue a message	34	12
KJCT flow control latch	kjctcsnd: send normal message	9	8
KJCT flow control latch	kjcts_sedeqv2: dequeue a vector of msgs	5	17
KJCT flow control latch	kjctr_updatetkt: update ticket info	2	5
KJCT flow control latch	kjctssqmg: adjuest send tickets	1	7
PC and Classifier lists for WLM	No latch	30	0
Real-time plan statistics latch	keswxAddNewPlanEntry	47	47
active checkpoint queue latch	kcbbacq: scan active checkpoints	2	3
active checkpoint queue latch	kcbkcpa: Checkpoint post-processing	1	0
active service list	kswslogon: session logout	22	23
active service list	kswsigsn: get service name	2	4
active service list	kswsite: service iterator	1	0
active service list	kswssetsvc: PX session switch service	1	1
begin backup scn array	get begin backup scn for file	892	892
cache buffers chains	kcbgcur_2	566	522
cache buffers chains	kcbrls_2	204	19
cache buffers chains	kcbgtcr: fast path	82	13
cache buffers chains	kcbchg1: mod cr pin	70	38
cache buffers chains	kcbgcur: fast path (shr)	69	21
cache buffers chains	kcbgtcr: fast path (cr pin)	54	42
cache buffers chains	kcbbxsv	43	35
cache buffers chains	kcbzwb	36	30
cache buffers chains	kcbget: fast exchange	27	31
cache buffers chains	kcbzgb: scan from tail. nowait	17	0
cache buffers chains	kcllkopesc	15	1
cache buffers chains	kclwlr	11	7
cache buffers chains	kcbchg1: clear MS bit	10	82
cache buffers chains	kcbnlc	10	20
cache buffers chains	kclcqchk	9	0
cache buffers chains	kclbla	6	5
cache buffers chains	kcbgcur_4	5	11
cache buffers chains	kcbbic1	4	1
cache buffers chains	kcbchg1: aux pin	3	2
cache buffers chains	kcbbic2	2	2
cache buffers chains	kcbrls: fast release	2	10
cache buffers chains	kcbso1: set no access	2	2
cache buffers chains	kcbAdoptBuffers_vhl	1	0
cache buffers chains	kcbchg1: mod cur pin	1	27
cache buffers chains	kcbget: pin buffer	1	1
cache buffers chains	kcbgtcr_2	1	9
cache buffers chains	kcbsod1	1	0
cache buffers chains	kcbzib: finish processing buffer	1	2
cache buffers chains	kcbzibmlt: multi-block read: nowait	1	0
cache buffers chains	kclpdcl	1	0
cache buffers chains	kclrlstp	1	6
cache buffers chains	kclwrt	1	0
cache buffers lru chain	kcbzgb_2	226	325
cache buffers lru chain	kcbzgws	136	0
cache buffers lru chain	kcbzar: KSLNBEGIN	57	0
cache buffers lru chain	kcbz_prewarm_islocal	8	2
cache buffers lru chain	kcbbxsv: move to being written	5	0
cache buffers lru chain	kcbzgb	5	27
cache buffers lru chain	kcbo_link_q	4	3
cache buffers lru chain	kcbzgm	3	0
cache buffers lru chain	kclmvreqbg	2	21
cache buffers lru chain	kcb_mv_to_req	1	0
cache buffers lru chain	kcbzfw	1	0
cache buffers lru chain	kclwcrs	1	0
cache table scan latch	kcbz_free_table_scan_read_buffer	3	4
cache table scan latch	kcbz_find_table_scan_read_buffer	1	0
call allocation	ksuxds	544	546
call allocation	ksudlc : rec call	4	5
call allocation	ksuprc	4	2
call allocation	ksuinfos_modact	2	2
call allocation	ksudlp: top call	1	1
channel operations parent latch	ksrwait()	3	3
channel operations parent latch	ksrapublish()	2	1
channel operations parent latch	ksrsconsume()	2	1
channel operations parent latch	ksrmfree()	1	0
checkpoint queue latch	kcbkubc_4	9	19
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	7	1
checkpoint queue latch	kcbklbc_cql	5	0
client/application info	ksuinfos_modact	2	2
client/application info	kskirefrattrmap	1	2
dummy allocation	ktcdod	6	6
dummy allocation	ktcscnfy	2	2
enqueue hash chains	ksqrcl	969	94
enqueue hash chains	ksqgtl3	203	1,153
enqueue hash chains	ksqcmi: if lk mode not requested	61	15
enqueue hash chains	ksqcmi: if lk mode requested	43	14
enqueue hash chains	ksqcnl	4	6
enqueue hash chains	ksqexpandres	2	0
enqueue hash chains	ksqhngcbk1: Phase 1	1	0
enqueue hash chains	ksqhngcbk1: Phase 2	1	0
error message lists	kxfpqsnd	1	1
file cache latch	file cache:04	6	6
gc element	kclnfndnewm	3,634	994
gc element	kclulb	391	1,316
gc element	kclchkping	284	1
gc element	kclrwrite	111	114
gc element	kclbla	84	17
gc element	KCLUNLNK	79	1,046
gc element	kclfwrite1	68	79
gc element	kclnfndx	57	48
gc element	kclplz	53	748
gc element	kclebs	19	50
gc element	kclplz_1	19	64
gc element	kclrlstp	9	3
gc element	kclcqchk	8	230
gc element	kclrwrite_10	8	0
gc element	kclwrt	8	36
gc element	kclevict	7	0
gc element	kclexpand_2	5	1
gc element	kclhngcbk1	5	0
gc element	kcl_get_le_latch	4	0
gc element	kcl_fairness	2	0
gc element	kclclose_1	2	0
gc element	kclnfnds	2	55
gcs opaque info freelist	kjbrcvt save opaque info	11	8
gcs opaque info freelist	kjbrinfofree free opaque info	5	8
gcs resource freelist	kjbralc add resource	21	5
gcs resource freelist	kjbralc_bg: add resource	3	0
gcs resource hash	kjbcropen	135	41
gcs resource hash	kjbassume	45	26
gcs resource hash	kclrwrite	40	29
gcs resource hash	kjbopen	39	6
gcs resource hash	kjbconvert	35	13
gcs resource hash	kjblocalobj_nolock	23	5
gcs resource hash	kjbmpopen	14	10
gcs resource hash	kjbopen:affinity	13	5
gcs resource hash	kclfwrite1	10	21
gcs resource hash	kjbrwrdone reget	9	0
gcs resource hash	kjbmpconvert	6	25
gcs resource hash	kclpdc	5	10
gcs resource hash	kjbmpclose	5	21
gcs resource hash	kjbclose	3	75
gcs resource hash	kjblpast	2	19
gcs resource hash	kjbmdowncvt	2	25
gcs resource hash	kjbrdrmcvtq_98	2	7
gcs resource hash	kclgrantlk_1	1	0
gcs resource hash	kjbcrconvert	1	0
gcs resource hash	kjblpwreq	1	7
ges caches resource lists	kjruch: cached obj cleanup	17	0
ges caches resource lists	kjrm2c: move resource to cache	16	48
ges caches resource lists	kjchc: clean resource cache	12	0
ges caches resource lists	kjrchc: cached obj cleanup	2	0
ges caches resource lists	kjrchc2: cached obj cleanup	1	0
ges deadlock list	kjcvdte: insert into dd timer_q	1	0
ges domain table	kjdmlad: add a lock to an xid-hashed lock list	2	2
ges domain table	kjdmlrm: remove a lock from its xid-hashed lock list	1	1
ges enqueue table freelist	kjlalc: lock allocation	9	6
ges group table	kjgagll: move a lock from process lock list to group lock list	1	2
ges group table	kjgdgll: move a lock from group lock list to process lock list	1	0
ges process parent latch	kjata_fg	46,838	35
ges process parent latch	kjatb	289	266
ges process parent latch	kjatioc	86	3
ges process parent latch	kjlrem: detach lock from group	64	1
ges process parent latch	kjata	27	40
ges process parent latch	kjatsu1	3	46,961
ges process parent latch	kjlini_client: attach client lock to process	1	0
ges resource hash list	kjrmas1: lookup master node	48,326	51
ges resource hash list	kjlrlr: remove lock from resource queue	2,319	824
ges resource hash list	kjucvl: lock convert request	725	48,097
ges resource hash list	kjakcai: search for resp by resname	244	1,333
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	124	1,034
ges resource hash list	kjakoca: search for resp by resname	72	348
ges resource hash list	kjrref: find matched resource	10	134
ges resource hash list	kjuinq: inquire resource held mode	2	0
ges resource hash list	kjtscn: try lock res with nowait	1	0
ges resource scan list	kjcvscn: traverse scan_q	1	0
ges resource table freelist	kjralc: resource allocation	3	1
ges timeout list	kjteq: insert into timer queue	3	1
ges timeout list	kjtscn: try to lock timer queue	1	0
ges value block free list	kjvblkfr: free	1	1
interrupt manipulation	ksursi0	2	2
lgwr LWN SCN	kcs023	39	0
messages	ksaamb: after wakeup	18	11
messages	ksarcv	12	16
messages	ksarcv: after wait	10	13
mostly latch-free SCN	kcslcu3	38	80
mostly latch-free SCN	kcs024	3	0
multiblock read objects	kcbzibmlt	10	8
multiblock read objects	kcbzibmlt: normal mbr free	6	8
name-service namespace bucket	kjxgnqry: search for a name entry	2	0
name-service request queue	kjxgnapq: process a request	1	0
object queue header operation	kcbo_unlink_q	416	357
object queue header operation	kcbo_link_q	36	52
object queue header operation	kcbo_switch_q_bg	35	46
object queue header operation	kcbo_switch_cq	27	30
object queue header operation	kcbo_switch_mq_bg	26	32
object queue header operation	kclbufs	13	21
object queue header operation	kcbw_make_free_nowait	3	0
object queue header operation	kclobj_5	3	2
object queue header operation	kcbo_sw_buf	2	0
object queue header operation	kcbo_unlink_q_bg	2	7
object queue header operation	kclevict	2	0
object queue header operation	kcbo_write_bufs	1	0
object queue header operation	kcldbufs	1	7
parallel query alloc buffer	kxfpbalo	115	111
parallel query alloc buffer	kxfpbfre	21	25
parallel query stats	kxfprst: KSLBEGIN:1	1	1
parameter table management	kspptval	31	51
parameter table management	ksp_param_table_free	16	0
parameter table management	kspcpy	4	0
post/wait queue	kslpstevent:get	2	1
process queue	kxfpqsnd: KSLBEGIN	7	5
process queue	kxfpqidqr: KSLBEGIN	1	3
process queue reference	kxfpqrsnd	36	0
process queue reference	kxfpnuldq	1	32
query server freelists	kxfpobadf	4	4
query server process	kxfpg1srv	56	56
redo allocation	kcrfw_redo_gen: redo allocation 1	1,416	0
redo allocation	kcrfw_redo_gen: redo allocation 2	49	0
redo allocation	kcrfw_redo_gen: redo allocation 3	38	839
redo allocation	kcrfw_post: more space	11	420
redo allocation	kcrfw_redo_write: before write	10	265
redo writing	kcrfwcr	8	12
redo writing	kcrfw_post: rba scn pair	3	0
redo writing	kcrfw_cal_target_rba	2	1
resmgr:free threads list	kskthrcreate	9	9
resmgr:free threads list	kskthrsod	2	2
row cache objects	kqreqd: reget	9,496	1,554
row cache objects	kqrpre: find obj	6,489	12,384
row cache objects	kqreqd	2,123	4,101
row cache objects	kqrso	582	711
row cache objects	kqrbip	135	8
row cache objects	kqrbgl	54	40
row cache objects	kqrigt	46	41
row cache objects	kqrbfr	25	9
row cache objects	kqrbtm: pop parent	25	18
row cache objects	kqrcmt: while loop	9	13
row cache objects	kqrigt2	4	10
row cache objects	kqrbpr: KQRRSNRL	3	8
row cache objects	kqrpup	3	4
row cache objects	kqrcmt: clear flag	1	17
row cache objects	kqrigt3	1	0
row cache objects	kqrpre: init complete	1	13
sequence cache	kdnnxt: cached seq	1	0
sequence cache	kdnss	1	2
sequence cache	kdnssd	1	1
session idle bit	ksupuc: set busy	7	2
session idle bit	ksupuc: clear busy	4	12
session idle bit	ksuxds	3	0
session state list latch	kpseqd	1	0
shared pool	kghalo	2,150	1,150
shared pool	kghfre	281	586
shared pool	kghupr1	90	512
shared pool	kghalp	84	359
shared pool	kghfrunp: alloc: wait	32	0
shared pool	kgh_heap_sizes	17	27
shared pool	kghfrunp: clatch: nowait	13	0
shared pool	kghfrunp: clatch: wait	3	85
shared pool	kghfrh	2	13
shared pool	kghfree_extents: scan	1	0
shared pool sim alloc	kglsim_chk_objlist: alloc	1	1
shared pool simulator	kglsim_chg_simhp_noob	1	1
simulator hash latch	kcbsacc: lookup dba	7	9
simulator hash latch	kcbs_lookup_setid: lookup dba	2	0
simulator lru latch	kcbs_shrink_pool	2	0
space background task latch	ktsj_grab_task	240	270
transaction allocation	ktcxbr	1	1
undo global data	ktudba: KSLBEGIN	1	2
undo global data	ktudnx:child	1	0
undo global data	ktusmupst: KSLBEGIN	1	1

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kgllkdl1 85	1,022
Cursor Pin	kkslce [KKSCHLPIN2]	548
Library Cache	kglhdgn2 106	453
Library Cache	kgllkc1 57	321
Library Cache	kglpnal2 91	300
Library Cache	kglhdgn1 62	195
Library Cache	kglpin1 4	118
Library Cache	kglget1 1	80
Library Cache	kgllkal1 80	60
Library Cache	kglget2 2	55
Library Cache	kglpndl1 95	55
Library Cache	kgldtin1 42	49
Library Cache	kglpnal1 90	46
Library Cache	kglobpn1 71	27
Library Cache	kglhdgh1 64	25
Cursor Pin	kksLockDelete [KKSCHLPIN6]	25
Cursor Parent	kkshmih [KKSPRTLOC11]	17
Cursor Pin	kksfbc [KKSCHLPIN1]	13
Library Cache	kglrfcl1 79	12
hash table	kkscsSearchChildList [KKSHBKLOC2]	3
Cursor Pin	kksfbc [KKSCHLFSP2]	3
Library Cache	kglati1 45	1
Library Cache	kglllal3 111	1
Cursor Pin	kksxsccmp [KKSCHLPIN5]	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 Global Cache Buffer Busy
Segments by CR Blocks Received
Segments by Current Blocks Received

Segments by Logical Reads

Total Logical Reads: 53,905,278
Captured Segments account for 79.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
HMV6BF	ESBF	SYS_LOB0000194195C00017$$	LOB	4,323,488	8.02
HMV6BF	ESBF	SYS_LOB0000194285C00011$$	LOB	3,735,440	6.93
AMBF	AMBF	YD_KHXX	TABLE	3,479,712	6.46
SYS	SYSTEM	COL$	TABLE	3,440,944	6.38
SYS	SYSTEM	I_OBJ#	INDEX	3,244,016	6.02

Buffer Nowait %:	99.97	Redo NoWait %:	100.00
Buffer Hit %:	97.11	In-memory Sort %:	100.00
Library Hit %:	91.21	Soft Parse %:	90.54
Execute to Parse %:	10.27	Latch Hit %:	99.30
Parse CPU to Parse Elapsd %:	92.05	% Non-Parse CPU:	66.82

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
HMV6BF	ESBF	RY_ZZBDXX	TABLE	480	5.14
XMBF	XMBF	RY_SFZZZHT_BF	TABLE	254	2.72
ESBF	ESBF	AJ_FLWS_BF	TABLE	228	2.44
BTBF	BTBF	RY_JBXX_BF	TABLE	220	2.35
WMBF	WMBF	AJ_FLWS_BF	TABLE	207	2.22

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
SYS	SYSTEM	I_FILE#_BLOCK#	INDEX	167	90.27
SYS	SYSAUX	I_WRI$_OPTSTAT_OPR_STIME	INDEX	9	4.86
SYS	SYSTEM	I_DEFERRED_STG1	INDEX	2	1.08
SYS	SYSTEM	I_ICOL1	INDEX	2	1.08
SYS	SYSTEM	I_OBJ#	INDEX	2	1.08

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	SEG$	TABLE	495	56.00
SYS	SYSTEM	I_FILE#_BLOCK#	INDEX	258	29.19
SYS	SYSTEM	OBJ$	TABLE	31	3.51
SYS	SYSTEM	DEFERRED_STG$	TABLE	19	2.15
SYS	SYSTEM	COL$	TABLE	14	1.58

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
BMBF	BMBF	AJ_SMBL_BF	TABLE	13,828	24.61
BMBF	BMBF	AJ_QTZJTX_BF	TABLE	10,006	17.81
WMBF	WMBF	AJ_FLWS_BF	TABLE	8,965	15.96
XABF	XABF	AJ_SMBL_BF	TABLE	6,089	10.84
XABF	XABF	AJ_FLWS_BF	TABLE	2,913	5.19

Owner	Tablespace Name	Object Name	Obj. Type	Current Blocks Received	%Total
XABF	XABF	CKZL_RYJBXX_BF	TABLE	11,124	10.79
XABF	XABF	AJ_SMBL_BF	TABLE	10,875	10.55
XABF	XABF	AJ_FLWS_BF	TABLE	7,364	7.14
BMBF	BMBF	AJ_SMBL_BF	TABLE	5,252	5.10
XMBF	XMBF	RY_HCY_BF	TABLE	3,387	3.29

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	63	1.59	1	1
dc_constraints	114	50.00	114	38
dc_files	7,953	3.03	0	0
dc_global_oids	185	3.78	0	10
dc_histogram_data	5,192,854	0.01	0	818
dc_histogram_defs	24,160,475	0.02	0	1,781
dc_object_grants	4,685	1.52	0	92
dc_objects	4,545,161	0.35	24,007	11,621
dc_profiles	88	0.00	0	1
dc_rollback_segments	2,379	0.13	0	69
dc_segments	101,486	2.57	6,662	1,388
dc_sequences	47	12.77	47	3
dc_tablespace_quotas	78,347	0.03	1	21
dc_tablespaces	8,975,394	0.00	0	21
dc_users	16,095,959	0.02	1	491
global database name	3,422	0.00	0	1
outstanding_alerts	110	98.18	0	0
sch_lj_oids	6	0.00	0	10

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	121	4.13	0		0	0
BODY	65,107	0.02	84,094	0.02	0	0
CLUSTER	99,122	0.00	99,125	0.00	0	0
DBLINK	128	3.13	0		0	0
EDITION	60	3.33	106	4.72	1	0
INDEX	43,183	7.79	49,778	26.64	3,299	0
OBJECT ID	3,394	100.00	0		0	0
QUEUE	0		59	0.00	0	0
SCHEMA	15,944	0.03	0		0	0
SQL AREA	231,077	23.76	1,184,225	14.07	807	16,871
SQL AREA BUILD	55,550	99.42	0		0	0
SQL AREA STATS	55,492	99.42	55,492	99.42	0	0
TABLE/PROCEDURE	356,248	1.95	1,323,115	1.42	4,426	1
TRIGGER	93,054	0.01	93,054	0.02	0	0

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases
ACCOUNT_STATUS	121	0	0
BODY	0	84,091	84,091
CLUSTER	99,126	99,126	99,126
DBLINK	128	0	0
EDITION	60	62	62
INDEX	43,180	49,775	49,775
QUEUE	0	59	59
SCHEMA	3,420	0	0
TABLE/PROCEDURE	531,597	668,411	668,411
TRIGGER	0	93,053	93,053

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Oper Count	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT buffer cache	29,568.00	29,184.00	29,184.00	29,696.00	3	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	24,320.00	24,320.00	24,320.00	24,320.00	0	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	36,224.00	36,224.00	36,224.00	36,224.00	0	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	0	STA/
java pool	768.00	768.00	768.00	768.00	0	STA/
large pool	512.00	512.00	512.00	512.00	0	STA/
shared pool	4,992.00	5,376.00	4,864.00	5,376.00	3	GRO/DEF
streams pool	0.00	0.00	0.00	0.00	0	STA/

Component	Min Size (Mb)	Max Size (Mb)	Avg Size (Mb)	Re- Sizes	Grows	Shrinks
DEFAULT buffer cache	29,184.00	29,440.00	29,312.00	3	0	3
shared pool	5,120.00	5,376.00	5,248.00	3	3	0

Start	Ela (s)	Component	Oper Typ/Mod	Init Size (M)	Delta	Final (M)	Sta
04/21 10:50:46	3	bufcache	SHR/DEF	29,312	-128	29,184	COM
04/21 10:50:46	3	shared	GRO/DEF	5,248	128	5,376	COM
04/21 10:46:16	3	bufcache	SHR/DEF	29,440	-128	29,312	COM
04/21 10:46:16	3	shared	GRO/DEF	5,120	128	5,248	COM
04/21 10:41:43	3	bufcache	SHR/DEF	29,568	-128	29,440	COM
04/21 10:41:43	3	shared	GRO/DEF	4,992	128	5,120	COM

	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	356.43		5.02	5.42	26	26	71	71
B	SQL	328.10	99.51	6.84	22.82	119	120	48	42
B	Freeable	68.06	0.00	2.13	2.83	12		32	32
B	PL/SQL	11.26	1.91	0.15	0.25	1	1	74	73
E	Other	462.89		4.13	4.45	26	26	112	112
E	SQL	428.61	210.31	4.93	21.25	123	1,054	87	58
E	Freeable	91.94	0.00	1.37	1.94	12		67	67
E	PL/SQL	12.73	2.75	0.11	0.38	4	4	114	89

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	31,004,295,168	30,601,641,984
Fixed Size	2,268,792
Redo Buffers	116,957,184
Variable Size	32,078,037,384	32,480,690,568

Pool	Name	Begin MB	End MB	% Diff
java	free memory	768.00	768.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	503.81	503.81	0.00
shared	ASM extent pointer array	59.79	59.79	0.01
shared	FileOpenBlock	121.57	121.57	0.00
shared	KGLH0	203.98	295.05	44.64
shared	KGLHD		54.33
shared	SQLA	703.31	1,057.41	50.35
shared	db_block_hash_buckets	178.00	178.00	0.00
shared	free memory	1,612.08	1,511.85	-6.22
shared	gc name table	96.00	96.00	0.00
shared	gcs res hash bucket	64.00	64.00	0.00
shared	gcs resources	835.06	835.06	0.00
shared	gcs shadows	578.12	578.12	0.00
	buffer_cache	29,568.00	29,184.00	-1.30
	fixed_sga	2.16	2.16	0.00
	log_buffer	111.54	111.54	0.00

Name	Total Disp Time (s)	%Busy	%Idle
D000	3,575	0.00	100.00
D000	3,575	0.00	100.00
D000	3,575	0.00	100.00
D000	3,575	0.00	100.00
Sum
Avg		0.00	100.00
Std		0.00	0.00

Parameter Name	Begin value	End value (if different)
audit_file_dest	/db/base/admin/odi/adump
audit_trail	DB
cluster_database	TRUE
compatible	11.2.0.4.0
control_files	+DATA/odi/controlfile/current.260.844614503, +ARCHIVE/odi/controlfile/current.256.844614505
db_block_size	8192
db_create_file_dest	+DATA
db_domain
db_files	2048
db_name	odi
db_recovery_file_dest	+ARCHIVE
db_recovery_file_dest_size	10737418240
diagnostic_dest	/db/base
dispatchers	(PROTOCOL=TCP) (SERVICE=odiXDB)
instance_number	1
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=10.100.20.146)(PORT=1521))
memory_target	63484985344
open_cursors	300
plsql_warnings	DISABLE:ALL
processes	1000
remote_listener	odidb-cluster-scan:1521
remote_login_passwordfile	EXCLUSIVE
sessions	1536
spfile	+DATA/odi/spfileodi.ora
thread	1
undo_tablespace	UNDOTBS1

Parameter Name	Begin value	End value (if different)
control_files	+ARCHIVE/odi/controlfile/current.256.844614505
control_files	+DATA/odi/controlfile/current.260.844614503

	Per Second	Per Transaction
Global Cache blocks received:	44.59	9.89
Global Cache blocks served:	24.02	5.33
GCS/GES messages received:	413.07	91.60
GCS/GES messages sent:	582.08	129.08
DBWR Fusion writes:	4.85	1.08
Estd Interconnect traffic (KB)	743.24

Buffer access - local cache %:	96.60
Buffer access - remote cache %:	0.51
Buffer access - disk %:	2.89

WORKLOAD REPOSITORY report for

Report Summary

Main Report

RAC Statistics

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

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

SQL ordered by Cluster Wait Time

Complete List of SQL Text

Instance Activity Statistics

Key Instance Activity Stats

Other Instance Activity Stats

Instance Activity Stats - Absolute Values

Instance Activity Stats - Thread Activity

IO Stats

IOStat by Function summary

IOStat by Filetype summary

IOStat by Function/Filetype summary

Tablespace IO Stats

File IO Stats

Buffer Pool Statistics

Buffer Pool Statistics

Checkpoint Activity

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

Wait Statistics

Buffer Wait Statistics

Enqueue Activity

Undo Statistics

Undo Segment Summary

Undo Segment Stats

Latch Statistics

Latch Activity

Latch Sleep Breakdown

Latch Miss Sources

Mutex Sleep Summary

Parent Latch Statistics

Child Latch Statistics

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

Avg global enqueue get time (ms):	0.3
Avg global cache cr block receive time (ms):	1.8
Avg global cache current block receive time (ms):	2.3
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	4.2
Avg global cache cr block flush time (ms):	4.0
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	2.3
Avg global cache current block flush time (ms):	6.8

Avg message sent queue time (ms):	0.1
Avg message sent queue time on ksxp (ms):	1.5
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	32.49
% of indirect sent messages:	62.61
% of flow controlled messages:	4.90

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	12,634	3.54	0.78
acks for commit broadcast(logical)	17,810	4.99	1.11
broadcast msgs on commit(actual)	58,909	16.50	3.66
broadcast msgs on commit(logical)	65,881	18.45	4.09
broadcast msgs on commit(wasted)	7,284	2.04	0.45
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
flow control messages received	0	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	27,279	7.64	1.69
gcs ast xid	0	0.00	0.00
gcs blocked converts	64,076	17.94	3.98
gcs blocked cr converts	44,613	12.49	2.77
gcs compatible basts	335	0.09	0.02
gcs compatible cr basts (global)	2,475	0.69	0.15
gcs compatible cr basts (local)	50,365	14.10	3.13
gcs cr basts to PIs	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	15,657	4.38	0.97
gcs dbwr write request msgs	4,888	1.37	0.30
gcs delta msgs sent	0	0.00	0.00
gcs delta push aborted by cancel	0	0.00	0.00
gcs delta push aborted by remastering	0	0.00	0.00
gcs delta push cancelled	0	0.00	0.00
gcs delta push cancelled at master	0	0.00	0.00
gcs delta push cancelled by close	0	0.00	0.00
gcs delta push cancelled by consign	0	0.00	0.00
gcs delta push cancelled by cvt ping	0	0.00	0.00
gcs delta push cancelled by dwncvt	0	0.00	0.00
gcs delta push create pi	0	0.00	0.00
gcs delta update master msgs sent	0	0.00	0.00
gcs delta wait aborted by remastering	0	0.00	0.00
gcs delta wait cancelled	0	0.00	0.00
gcs error msgs	0	0.00	0.00
gcs force cr block only	172	0.05	0.01
gcs force cr grant	59	0.02	0.00
gcs force cr no current	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	12,775	3.58	0.79
gcs immediate (null) converts	46,302	12.97	2.88
gcs immediate cr (compatible) converts	373,275	104.52	23.18
gcs immediate cr (null) converts	468,003	131.05	29.06
gcs indirect ast	7,311	2.05	0.45
gcs indirect bidless ast	1,329	0.37	0.08
gcs indirect fg ast	5,982	1.68	0.37
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	7,199	2.02	0.45
gcs msgs process time(ms)	18,413	5.16	1.14
gcs msgs received	1,099,934	308.00	68.30
gcs new served by master	37,044	10.37	2.30
gcs out-of-order msgs	19	0.01	0.00
gcs pings refused	117	0.03	0.01
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	202	0.06	0.01
gcs reader bypass N->Xw ping local	0	0.00	0.00
gcs reader bypass N->Xw ping remote	0	0.00	0.00
gcs reader bypass grant X on assume	0	0.00	0.00
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	0	0.00	0.00
gcs reader bypass grant immediate	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	1	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	75	0.02	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	3,817	1.07	0.24
gcs side channel msgs logical	178,720	50.04	11.10
gcs stale cr	1,040	0.29	0.06
gcs undo cr	64	0.02	0.00
gcs write notification msgs	379	0.11	0.02
gcs writes refused	471	0.13	0.03
ges msgs process time(ms)	10,294	2.88	0.64
ges msgs received	375,221	105.07	23.30
global posts dropped	0	0.00	0.00
global posts queue time	0	0.00	0.00
global posts queued	0	0.00	0.00
global posts requested	0	0.00	0.00
global posts sent	0	0.00	0.00
implicit batch messages received	22,547	6.31	1.40
implicit batch messages sent	82,324	23.05	5.11
lmd msg send time(ms)	77	0.02	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	55,878	15.65	3.47
messages queue sent actual	280,212	78.46	17.40
messages queue sent logical	686,943	192.36	42.66
messages received actual	661,410	185.21	41.07
messages received logical	1,475,155	413.07	91.60
messages sent directly	370,184	103.66	22.99
messages sent indirectly	713,352	199.75	44.30
messages sent not implicit batched	684	0.19	0.04
messages sent pbatched	1,112,951	311.64	69.11
msgs causing lmd to send msgs	98,024	27.45	6.09
msgs causing lms(s) to send msgs	72,080	20.18	4.48
msgs received queue time (ms)	20,772	5.82	1.29
msgs received queued	1,475,155	413.07	91.60
msgs sent queue time (ms)	106,483	29.82	6.61
msgs sent queue time on ksxp (ms)	1,049,905	293.99	65.20
msgs sent queued	800,317	224.10	49.70
msgs sent queued on ksxp	716,738	200.70	44.51
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	280,327	78.50	17.41
process batch messages sent	269,854	75.56	16.76

Statistic	Total
CR Block Requests	30,751
CURRENT Block Requests	1,597
Data Block Requests	30,751
Undo Block Requests	50
TX Block Requests	1,142
Current Results	31,129
Private results	1,021
Zero Results	193
Disk Read Results	1
Fail Results	2
Fairness Down Converts	22,986
Fairness Clears	2,531
Free GC Elements	0
Flushes	1,347
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	15
Errors	0

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	977	44.01	54.35	1.64	0.00	0.00
Flushes	1,240	24.11	71.85	2.74	1.29	0.00
Writes	17,311	0.72	7.40	8.51	38.97	44.41

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	55,544	66.72	0.36	32.92	67,741	52.79	0.62	46.59
2	Others	482	94.40	2.28	3.32	36,994	94.74	3.04	2.22
2	undo header	127	88.19	5.51	6.30	267	97.75	0.37	1.87
2	undo block	41	58.54	39.02	2.44	1	100.00	0.00	0.00

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
2	data block	1.82	1.53	3.08	2.38	2.79	2.28	5.10	3.34
2	others	1.30	1.22	2.45	2.97	1.41	1.29	5.02	1.56
2	undo header	1.08	1.04	1.75	1.12	1.04	1.04	3.16	0.75
2	undo block	1.48	1.20	1.91	1.23	0.61	0.61

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
2	data block	0	37,060	100.00	0.00	35,763	100.00	0.00
2	others	0	455	100.00	0.00	35,049	100.00	0.00
2	undo header	0	112	100.00	0.00	261	100.00	0.00
2	undo block	0	24	100.00	0.00	1	100.00	0.00

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	0.13	0.23
Parallel Query	0.34	0.43
DB Locks	0.12	0.10
DB Streams	0.00	0.00
Other	0.00	0.00

Name	Total	per Remaster Op	Begin Snap	End Snap
remaster ops	2	1.00
remastered objects	3	1.50
replayed locks received	0	0.00
replayed locks sent	9,964	4,982.00
resources cleaned	0	0.00
remaster time (s)	4.8	2.38
quiesce time (s)	2.0	1.02
freeze time (s)	0.0	0.01
cleanup time (s)	0.9	0.47
replay time (s)	0.1	0.07
fixwrite time (s)	1.2	0.61
sync time (s)	0.4	0.21
affinity objects			46	48