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: 227 21-Apr-14 06:00:07 72 3.0 2

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

Elapsed: 240.38 (mins)

DB Time: 491.85 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session	Instances
Begin Snap:	227	21-Apr-14 06:00:07	72	3.0	2
End Snap:	231	21-Apr-14 10:00:30	73	3.0	2
Elapsed:		240.38 (mins)
DB Time:		491.85 (mins)

Report Summary

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 2.1 4.0 0.23 0.19

DB CPU(s): 0.0 0.0 0.00 0.00

Redo size (bytes): 831.7 1,627.0

Logical read (blocks): 85.4 167.1

Block changes: 3.1 6.1

Physical read (blocks): 0.1 0.1

Physical write (blocks): 0.5 0.9

Read IO requests: 0.0 0.1

Write IO requests: 0.3 0.6

Read IO (MB): 0.0 0.0

Write IO (MB): 0.0 0.0

Global Cache blocks received: 0.2 0.4

Global Cache blocks served: 0.5 0.9

User calls: 10.9 21.3

Parses (SQL): 6.4 12.5

Hard parses (SQL): 0.0 0.0

SQL Work Area (MB): 0.0 0.1

Logons: 0.0 0.0

Executes (SQL): 8.8 17.3

Rollbacks: 0.5 1.0

Transactions: 0.5

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	2.1	4.0	0.23	0.19
DB CPU(s):	0.0	0.0	0.00	0.00
Redo size (bytes):	831.7	1,627.0
Logical read (blocks):	85.4	167.1
Block changes:	3.1	6.1
Physical read (blocks):	0.1	0.1
Physical write (blocks):	0.5	0.9
Read IO requests:	0.0	0.1
Write IO requests:	0.3	0.6
Read IO (MB):	0.0	0.0
Write IO (MB):	0.0	0.0
Global Cache blocks received:	0.2	0.4
Global Cache blocks served:	0.5	0.9
User calls:	10.9	21.3
Parses (SQL):	6.4	12.5
Hard parses (SQL):	0.0	0.0
SQL Work Area (MB):	0.0	0.1
Logons:	0.0	0.0
Executes (SQL):	8.8	17.3
Rollbacks:	0.5	1.0
Transactions:	0.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 95.61 Soft Parse %: 99.96

Execute to Parse %: 27.70 Latch Hit %: 99.98

Parse CPU to Parse Elapsd %: 78.61 % Non-Parse CPU: 92.44

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
gc current multi block request	0	14.4K		48.9	Cluster
enq: TX - contention	1	598.8	598839	2.0	Other
DB CPU		56.9		.2
enq: IV - contention	4,930	7.2	1	.0	Other
db file sequential read	480	3.7	8	.0	User I/O
log file sync	2,384	3	1	.0	Commit
name-service call wait	48	1.6	34	.0	Other
enq: TM - contention	1,439	1.4	1	.0	Application
gc cr multi block request	80	.2	2	.0	Cluster
SQL*Net message to client	90,244	.2	0	.0	Network

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
Cluster	2,499	14,426	5773	48.9	1.0
Other	273,296	623	2	2.1	0.0
DB CPU		57		.2	0.0
System I/O	52,065	18	0	.1	0.0
User I/O	8,495	7	1	.0	0.0
Concurrency	35,681	6	0	.0	0.0
Commit	2,386	3	1	.0	0.0
Application	1,454	1	1	.0	0.0
Network	90,251	0	0	.0	0.0
Configuration	4	0	3	.0	0.0
Administrative	1	0	1	.0	0.0

Host CPU

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

24 24 6 0.12 0.13 0.6 0.4 0.0 99.0

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
24	24	6	0.12	0.13	0.6	0.4	0.0	99.0

Instance CPU

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

0.1 12.8 0.0

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

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 4.4 2.8 1.5

Database Requests: 0.4 0.0 0.3

Optimized Requests: 0.0 0.0 0.0

Redo Requests: 0.5 0.0 0.5

Total (MB): 0.1 0.0 0.0

Database (MB): 0.0 0.0 0.0

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB): 0.0 0.0 0.0

Database (blocks): 0.5 0.1 0.5

Via Buffer Cache (blocks): 0.5 0.1 0.5

Direct (blocks): 0.0 0.0 0.0

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	4.4	2.8	1.5
Database Requests:	0.4	0.0	0.3
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	0.5	0.0	0.5
Total (MB):	0.1	0.0	0.0
Database (MB):	0.0	0.0	0.0
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	0.0	0.0	0.0
Database (blocks):	0.5	0.1	0.5
Via Buffer Cache (blocks):	0.5	0.1	0.5
Direct (blocks):	0.0	0.0	0.0

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): 455.2 458.6

% Host Mem used for SGA+PGA: 24.24 24.25

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

Cache Sizes

Begin End

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

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

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

Shared Pool Statistics

Begin End

Memory Usage %: 63.75 63.79

% SQL with executions>1: 98.98 98.94

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

	Begin	End
Memory Usage %:	63.75	63.79
% SQL with executions>1:	98.98	98.94
% Memory for SQL w/exec>1:	98.84	98.77

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): 29511.2s
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	632.95	2.14
PL/SQL execution elapsed time	603.24	2.04
DB CPU	56.88	0.19
parse time elapsed	4.98	0.02
hard parse elapsed time	0.31	0.00
repeated bind elapsed time	0.10	0.00
connection management call elapsed time	0.05	0.00
hard parse (sharing criteria) elapsed time	0.03	0.00
PL/SQL compilation elapsed time	0.01	0.00
sequence load elapsed time	0.00	0.00
DB time	29,511.23
background cpu time	388.45
background elapsed time	364.62

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	346,792
IDLE_TIME	34,003,279
IOWAIT_TIME	7,148
NICE_TIME	3
SYS_TIME	126,545
USER_TIME	216,596
LOAD	0	0
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	32,768
VM_OUT_BYTES	0
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 06:00:07	0.12
21-Apr 07:00:13	0.28	1.01	0.63	0.37	98.99	0.02
21-Apr 08:00:19	0.24	1.00	0.63	0.37	99.00	0.02
21-Apr 09:00:25	0.20	1.01	0.63	0.36	98.99	0.02
21-Apr 10:00:30	0.13	1.01	0.63	0.37	98.99	0.02

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 100.0% of Total DB time 29,511.23 (s)
Total FG Wait Time: 29,463.47 (s) DB CPU time: 56.88 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Cluster	452	0	14,424	31912	48.88
Other	6,329	8	608	96	2.06
DB CPU			57		0.19
User I/O	572	0	4	7	0.01
Commit	2,384	0	3	1	0.01
Application	1,443	100	1	1	0.00
Network	90,244	0	0	0	0.00
Concurrency	140	11	0	1	0.00
Administrative	0		0		0.00
Configuration	0		0		0.00
System I/O	0		0		0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
gc current multi block request	0		14,424		0.00	48.87
enq: TX - contention	1	0	599	598839	0.00	2.03
enq: IV - contention	4,930	0	7	1	0.67	0.02
db file sequential read	480	0	4	8	0.07	0.01
log file sync	2,384	0	3	1	0.32	0.01
name-service call wait	48	0	2	34	0.01	0.01
enq: TM - contention	1,439	100	1	1	0.20	0.00
gc cr multi block request	80	0	0	2	0.01	0.00
SQL*Net message to client	90,244	0	0	0	12.24	0.00
IPC send completion sync	200	0	0	1	0.03	0.00
gc current block 2-way	163	0	0	1	0.02	0.00
gc cr disk read	131	0	0	1	0.02	0.00
enq: PS - contention	73	33	0	1	0.01	0.00
gc current grant busy	33	0	0	2	0.00	0.00
PX Deq: Slave Session Stats	73	0	0	1	0.01	0.00
library cache lock	44	34	0	1	0.01	0.00
library cache pin	55	0	0	1	0.01	0.00
gc cr block 2-way	34	0	0	1	0.00	0.00
row cache lock	40	0	0	1	0.01	0.00
enq: JQ - contention	12	100	0	2	0.00	0.00
Disk file operations I/O	91	0	0	0	0.01	0.00
gc current grant 2-way	8	0	0	2	0.00	0.00
KJC: Wait for msg sends to complete	506	0	0	0	0.07	0.00
SQL*Net break/reset to client	1	0	0	10	0.00	0.00
PX Deq: reap credit	461	100	0	0	0.06	0.00
db file scattered read	1	0	0	6	0.00	0.00
enq: JS - job run lock - synchronize	7	100	0	1	0.00	0.00
latch: ges resource hash list	13	0	0	0	0.00	0.00
enq: UL - contention	3	67	0	1	0.00	0.00
gc current block congested	2	0	0	1	0.00	0.00
gc cr block congested	1	0	0	1	0.00	0.00
enq: TT - contention	2	0	0	1	0.00	0.00
SQL*Net message from client	90,243	0	72,170	800	12.24
jobq slave wait	3,827	100	1,917	501	0.52
PX Deq: Execution Msg	292	0	0	1	0.04

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
control file sequential read	39,335	0	16	0	5.34	4.47
enq: CO - master slave det	4,800	100	5	1	0.65	1.46
os thread startup	139	0	5	35	0.02	1.35
db file sequential read	995	0	3	3	0.13	0.72
DFS lock handle	1,297	94	3	2	0.18	0.69
CGS wait for IPC msg	139,761	100	2	0	18.96	0.54
reliable message	580	0	1	2	0.08	0.38
log file parallel write	3,874	0	1	0	0.53	0.36
gcs log flush sync	142	16	1	6	0.02	0.22
gc current block 2-way	992	0	1	1	0.13	0.20
name-service call wait	24	0	1	29	0.00	0.19
control file parallel write	4,805	0	1	0	0.65	0.18
row cache lock	514	0	1	1	0.07	0.14
libcache interrupt action by LCK	34,816	0	1	0	4.72	0.14
ksxr poll remote instances	31,817	100	1	0	4.32	0.14
gc cr block 2-way	538	0	0	1	0.07	0.13
ksdxexeotherwait	2	0	0	191	0.00	0.10
latch: ges resource hash list	3,060	0	0	0	0.42	0.08
gc current grant busy	287	0	0	1	0.04	0.08
db file parallel write	2,074	0	0	0	0.28	0.07
row cache cleanup	35,953	0	0	0	4.88	0.06
enq: WF - contention	76	0	0	3	0.01	0.05
ASM file metadata operation	2,934	0	0	0	0.40	0.05
row cache process	38,194	0	0	0	5.18	0.05
gc buffer busy release	5	0	0	21	0.00	0.03
gc current block busy	59	0	0	2	0.01	0.03
library cache pin	45	0	0	2	0.01	0.03
enq: PS - contention	73	34	0	1	0.01	0.03
latch free	2,444	0	0	0	0.33	0.02
Disk file operations I/O	6,891	0	0	0	0.93	0.02
db file scattered read	27	0	0	3	0.00	0.02
PX Deq: reap credit	4,753	100	0	0	0.64	0.02
enq: IV - contention	83	0	0	1	0.01	0.02
library cache lock	24	13	0	2	0.00	0.01
gc current multi block request	47	0	0	1	0.01	0.01
gc cr multi block request	26	0	0	2	0.00	0.01
gc cr block busy	24	0	0	2	0.00	0.01
PX Deq: Signal ACK RSG	72	0	0	1	0.01	0.01
CSS initialization	10	0	0	3	0.00	0.01
PX Deq: Slave Session Stats	72	0	0	0	0.01	0.01
enq: TA - contention	47	0	0	1	0.01	0.01
enq: TD - KTF dump entries	33	0	0	1	0.00	0.01
CSS operation: action	21	0	0	1	0.00	0.01
IPC send completion sync	48	0	0	0	0.01	0.01
enq: PI - contention	24	100	0	1	0.00	0.01
ADR block file read	64	0	0	0	0.01	0.01
KJC: Wait for msg sends to complete	179	0	0	0	0.02	0.00
gc current grant 2-way	21	0	0	1	0.00	0.00
gc cr grant 2-way	20	0	0	1	0.00	0.00
enq: TT - contention	22	82	0	1	0.00	0.00
PX Deq: Signal ACK EXT	72	0	0	0	0.01	0.00
gc current block congested	19	0	0	1	0.00	0.00
gc cr block congested	8	0	0	1	0.00	0.00
enq: HW - contention	4	0	0	3	0.00	0.00
enq: AF - task serialization	7	0	0	1	0.00	0.00
db file async I/O submit	1,975	0	0	0	0.27	0.00
enq: DR - contention	8	0	0	1	0.00	0.00
log file sync	2	0	0	4	0.00	0.00
enq: MW - contention	8	0	0	1	0.00	0.00
enq: TM - contention	7	0	0	1	0.00	0.00
ADR block file write	20	0	0	0	0.00	0.00
Data file init write	5	0	0	1	0.00	0.00
LGWR wait for redo copy	48	0	0	0	0.01	0.00
CSS operation: query	30	0	0	0	0.00	0.00
enq: CR - block range reuse ckpt	4	0	0	1	0.00	0.00
asynch descriptor resize	141	100	0	0	0.02	0.00
enq: TX - index contention	2	0	0	1	0.00	0.00
enq: CF - contention	3	0	0	1	0.00	0.00
enq: RO - fast object reuse	4	0	0	0	0.00	0.00
ges inquiry response	3	0	0	1	0.00	0.00
enq: FB - contention	2	0	0	1	0.00	0.00
ges DFS hang analysis phase 2 acks	1	0	0	1	0.00	0.00
enq: CT - state	1	0	0	1	0.00	0.00
rdbms ipc message	283,792	87	302,656	1066	38.49
wait for unread message on broadcast channel	29,031	89	28,845	994	3.94
gcs remote message	946,100	99	28,823	30	128.32
DIAG idle wait	218,144	86	28,755	132	29.59
Space Manager: slave idle wait	3,184	98	15,750	4947	0.43
Streams AQ: qmn slave idle wait	503	0	14,428	28683	0.07
Streams AQ: qmn coordinator idle wait	1,006	50	14,428	14341	0.14
ASM background timer	2,896	0	14,422	4980	0.39
GCR sleep	2,884	100	14,422	5001	0.39
PING	5,526	20	14,422	2610	0.75
pmon timer	4,801	100	14,415	3003	0.65
ges remote message	169,924	79	14,412	85	23.05
shared server idle wait	480	100	14,405	30009	0.07
dispatcher timer	240	100	14,402	60010	0.03
smon timer	85	54	14,236	167487	0.01
PX Idle Wait	97	0	9,497	97910	0.01
class slave wait	54	0	299	5543	0.01
PX Deq: Join ACK	72	0	0	4	0.01
PX Deq: Parse Reply	72	0	0	3	0.01
KSV master wait	8,762	100	0	0	1.19
PX Deq: Execute Reply	72	0	0	1	0.01
Streams AQ: RAC qmn coordinator idle wait	1,018	100	0	0	0.14
SQL*Net message from client	9	0	0	1	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	64	100.0
ADR block file write	20	100.0
ADR file lock	24	100.0
ASM file metadata operation	2934	99.7	.1		.0	.0	.0	.1
CGS wait for IPC msg	139.8K	100.0
CSS initialization	10	50.0			40.0	10.0
CSS operation: action	21	42.9	52.4	4.8
CSS operation: query	30	100.0
DFS lock handle	1297	94.1	3.7	.2	.1	.1		1.9
Data file init write	5	60.0	40.0
Disk file operations I/O	6983	99.9		.0	.1
IPC send completion sync	248	86.7	13.3
KJC: Wait for msg sends to complete	686	99.9		.1
LGWR wait for redo copy	48	100.0
PX Deq: Signal ACK EXT	72	97.2	1.4		1.4
PX Deq: Signal ACK RSG	72	94.4	2.8	1.4		1.4
PX Deq: Slave Session Stats	145	80.7	17.9	.7	.7
PX Deq: reap credit	5214	100.0
SQL*Net break/reset to client	1					100.0
SQL*Net message to client	90.3K	100.0	.0
asynch descriptor resize	141	100.0
buffer busy waits	1	100.0
buffer deadlock	1	100.0
control file parallel write	4805	100.0	.0
control file sequential read	39.3K	99.7	.1	.0	.0	.0	.0	.0
db file async I/O submit	1975	100.0
db file parallel write	2074	100.0	.0
db file scattered read	28	60.7		3.6	25.0	10.7
db file sequential read	1475	38.8	.8	13.8	40.9	4.9	.3	.4
db file single write	1	100.0
direct path write	4	100.0
enq: AE - lock	1	100.0
enq: AF - task serialization	7	42.9	42.9		14.3
enq: CF - contention	3	100.0
enq: CO - master slave det	4800	33.5	66.2	.3	.0	.1
enq: CR - block range reuse ckpt	4	100.0
enq: CT - state	1		100.0
enq: DR - contention	8	37.5	62.5
enq: FB - contention	4	100.0
enq: FD - Flashback logical operations	1	100.0
enq: HW - contention	3	66.7				33.3
enq: IV - contention	5013	41.3	38.9	19.8	.1		.0
enq: JQ - contention	12		66.7	33.3
enq: JS - job run lock - synchronize	7	85.7	14.3
enq: MV - datafile move	1	100.0
enq: MW - contention	8	75.0	25.0
enq: PI - contention	24	95.8	4.2
enq: PS - contention	146	38.4	58.9	2.1	.7
enq: RO - fast object reuse	4	100.0
enq: SW - contention	1	100.0
enq: TA - contention	47	95.7	4.3
enq: TD - KTF dump entries	33	87.9	9.1		3.0
enq: TM - contention	1446	58.5	41.4	.1
enq: TT - contention	24	83.3	12.5	4.2
enq: TX - contention	1								100.0
enq: TX - index contention	2	50.0	50.0
enq: UL - contention	3	66.7	33.3
enq: WF - contention	76	89.5	7.9	1.3				1.3
gc buffer busy release	5	80.0						20.0
gc cr block 2-way	573	86.6	11.2	.9	.9	.5
gc cr block busy	21		81.0	19.0
gc cr block congested	9	77.8	11.1		11.1
gc cr disk read	131	94.7	5.3
gc cr grant 2-way	20	85.0	10.0		5.0
gc cr multi block request	106	23.6	45.3	14.2	17.0
gc current block 2-way	1178	90.7	7.5	.9	.8	.1
gc current block busy	53	3.8	64.2	30.2	1.9
gc current block congested	22	90.9	4.5		4.5
gc current grant 2-way	29	72.4	17.2	6.9	3.4
gc current grant busy	325	79.4	14.2	3.7	1.8	.6	.3
gc current grant congested	2	100.0
gc current multi block request	50	70.0	28.0	2.0
gc current split	1	100.0
gcs log flush sync	136	58.8	22.8	1.5			16.9
ges DFS hang analysis phase 2 acks	1		100.0
ges inquiry response	3	100.0
kfk: async disk IO	1	100.0
ksdxexeotherwait	2				50.0			50.0
ksxr poll remote instances	31.8K	100.0
latch free	2446	100.0	.0
latch: active service list	1	100.0
latch: cache buffers lru chain	1	100.0
latch: call allocation	1	100.0
latch: gc element	4	100.0
latch: ges resource hash list	3073	99.9	.1
latch: object queue header operation	1	100.0
latch: shared pool	1	100.0
libcache interrupt action by LCK	34.8K	100.0	.0
library cache lock	68	63.2	23.5	8.8	2.9	1.5
library cache pin	100	79.0	5.0	6.0	9.0	1.0
log file parallel write	3868	99.9	.1		.0			.0
log file sync	2386	14.5	84.4	1.0	.1		.0
name-service call wait	72	19.4	5.6	4.2	6.9	25.0	6.9	31.9
os thread startup	139						69.1	30.9
reliable message	580	15.2	41.7	42.4	.3		.2	.2
row cache cleanup	35.9K	100.0
row cache lock	552	70.1	27.0	1.6	1.3
row cache process	38.2K	100.0	.0
ASM background timer	2896	.2		.1		.1	.0	.0	99.6
DIAG idle wait	218.1K	12.1	.6	.2	.4	3.0	22.8	61.0
GCR sleep	2884								100.0
KSV master wait	8764	100.0						.0
PING	5526	78.4	1.1	.0				.0	20.4
PX Deq: Execute Reply	72	93.1	6.9
PX Deq: Execution Msg	292	76.4	19.9	2.4	.3	.7	.3
PX Deq: Join ACK	72	20.8	2.8	19.4	54.2	1.4	1.4
PX Deq: Parse Reply	72	6.9	31.9	37.5	23.6
PX Idle Wait	73	31.5						34.2	34.2
SQL*Net message from client	90.3K	97.2	.1	.0		.0			2.7
Space Manager: slave idle wait	3182	.2	.0		.1		.0	.4	99.3
Streams AQ: RAC qmn coordinator idle wait	1018	100.0
Streams AQ: qmn coordinator idle wait	1006	49.8	.2						50.0
Streams AQ: qmn slave idle wait	503								100.0
class slave wait	54	94.4	1.9	1.9					1.9
dispatcher timer	240								100.0
gcs remote message	946.1K	.6	.2	.2	.2	.2	98.3	.4
ges remote message	169.9K	10.7	1.3	1.5	.8	.7	1.2	83.7
jobq slave wait	3826	.0						100.0
pmon timer	4802								100.0
rdbms ipc message	283.8K	5.5	1.0	1.0	.1	.5	.5	62.6	28.9
shared server idle wait	480								100.0
smon timer	84	20.2						20.2	59.5
wait for unread message on broadcast channel	29K					.7		99.3

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
		% of Total Waits
ASM file metadata operation	2	99.9	.1
DFS lock handle	24	98.1	.8	1.1
control file sequential read	6	100.0	.0
db file sequential read	6	99.6	.1	.1	.1	.1
enq: WF - contention	1	98.7			1.3
gc buffer busy release	1	80.0		20.0
ksdxexeotherwait	1	50.0				50.0
log file parallel write	1	100.0					.0
name-service call wait	23	68.1	9.7	22.2
os thread startup	43	69.1	27.3	1.4	2.2
reliable message	1	99.8				.2

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

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

Event	Waits 4m to 1h	<2m	<4m	<8m	<1/4h	<1/2h	< 1h	>=1h
		% of Total Waits
enq: TX - contention	1				100.0

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Logical Reads (K)
SYS$USERS	29,512	56	1,137
SYS$BACKGROUND	1	1	95
odi	0	0	0
odiXDB	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	572	4	140	0	0	0	90244	0
SYS$BACKGROUND	7923	3	35541	6	1	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 2.2% of Total DB Time (s): 29,511
Captured PL/SQL account for 0.0% of Total DB Time (s): 29,511

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
603.86	1	603.86	2.05	0.21	0.62	6pbnp0hyq18uy	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
9.75	2,399	0.00	0.03	92.31	0.00	cqwfdp2kgp1y6	loader@odidb1 (TNS V1-V3)	SELECT VALUE FROM SYS.LOADER_S...
4.67	61,398	0.00	0.02	47.30	0.00	dzs3rm0w0bgnv	loader@odidb1 (TNS V1-V3)	SELECT 'X' FROM LOADER_COL_FLA...
3.35	480	0.01	0.01	102.72	0.00	772s25v1y0x8k		select shared_pool_size_for_es...
2.67	4	0.67	0.01	7.26	92.28	350myuyx0t1d6		insert into wrh$_tablespace_st...
2.47	4	0.62	0.01	98.42	0.00	bunssq950snhf		insert into wrh$_sga_target_ad...
2.43	4	0.61	0.01	98.39	0.00	dayq182sk41ks		insert into wrh$_memory_target...
2.42	4	0.60	0.01	98.60	0.00	bm2pwrpcr8ru6		select sga_size s, sga_size_fa...
2.41	4	0.60	0.01	70.09	2.88	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
2.12	24	0.09	0.01	14.07	0.00	axfcq597829h6	MMON_SLAVE	select tablespace_id, rfno, al...

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 71.6% of Total CPU Time (s): 57
Captured PL/SQL account for 3.0% of Total CPU Time (s): 57

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
9.00	2,399	0.00	15.82	9.75	92.31	0.00	cqwfdp2kgp1y6	loader@odidb1 (TNS V1-V3)	SELECT VALUE FROM SYS.LOADER_S...
3.44	480	0.01	6.05	3.35	102.72	0.00	772s25v1y0x8k		select shared_pool_size_for_es...
2.43	4	0.61	4.27	2.47	98.42	0.00	bunssq950snhf		insert into wrh$_sga_target_ad...
2.40	4	0.60	4.21	2.43	98.39	0.00	dayq182sk41ks		insert into wrh$_memory_target...
2.38	4	0.60	4.19	2.42	98.60	0.00	bm2pwrpcr8ru6		select sga_size s, sga_size_fa...
2.21	61,398	0.00	3.88	4.67	47.30	0.00	dzs3rm0w0bgnv	loader@odidb1 (TNS V1-V3)	SELECT 'X' FROM LOADER_COL_FLA...
1.71	480	0.00	3.01	1.74	98.63	0.00	aykvshm7zsabd		select size_for_estimate, size...
1.69	4	0.42	2.97	2.41	70.09	2.88	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
1.40	2,399	0.00	2.46	1.75	79.59	0.00	9rzjf5cqv4qv1		delete from deferred_stg$ wher...
1.24	1	1.24	2.19	603.86	0.21	0.62	6pbnp0hyq18uy	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
1.24	2,399	0.00	2.18	1.66	74.62	0.00	bjstq78pprd24	loader@odidb1 (TNS V1-V3)	SELECT DECODE(ELEMENT_SUBSTITU...
1.21	2,399	0.00	2.12	1.62	74.40	0.00	4z554v42crjkn	loader@odidb1 (TNS V1-V3)	SELECT DECODE(NESTED, 'YES', 1...
0.92	480	0.00	1.62	1.25	73.43	0.00	7k9uvtq74b7ts		LOCK TABLE "HMV6BF"."RY_RXXX" ...
0.91	2,404	0.00	1.60	0.98	92.87	0.00	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
0.89	479	0.00	1.57	1.30	68.64	0.00	24h34ym0q5fq1		LOCK TABLE "HMV6BF"."AJ_FLWS" ...
0.85	2,882	0.00	1.49	1.77	47.98	0.00	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
0.69	2,407	0.00	1.21	0.75	92.01	0.00	83taa7kaw59c1		select name, intcol#, segcol#,...
0.61	481	0.00	1.07	0.64	94.45	0.00	ftnc9xn199cds		LOCK TABLE "HMV6BF"."JG_TXXX" ...
0.57	480	0.00	1.01	0.60	95.85	0.00	9vnyvh4mq6jzb		LOCK TABLE "HMV6BF"."AJ_FLWS_T...

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
3.73	1	3.73	57.09	603.86	0.21	0.62	6pbnp0hyq18uy	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
2.47	4	0.62	37.78	2.67	7.26	92.28	350myuyx0t1d6		insert into wrh$_tablespace_st...
0.07	4	0.02	1.06	2.41	70.09	2.88	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.02	4	0.00	0.31	0.38	83.47	5.31	85px9dq62dc0q		INSERT /*+ APPEND LEADING(@"SE...
0.01	1	0.01	0.13	0.48	85.68	1.79	86dghj7qv3tb9	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
0.01	320	0.00	0.13	0.34	35.78	2.48	3s58mgk0uy2ws		insert into wrm$_snapshot_deta...
0.00	299	0.00	0.01	0.06	69.08	1.41	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
0.00	73	0.00	0.01	0.02	32.39	2.96	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
0.00	2	0.00	0.01	0.02	67.17	2.45	459f3z9u4fb3u		select value$ from props$ wher...
0.00	4	0.00	0.00	0.02	74.34	0.19	0pt4jfmq9f1q0		SELECT x.statistic# as stat_id...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

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

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
511,815	61,398	8.34	41.54	4.67	47.3	0	dzs3rm0w0bgnv	loader@odidb1 (TNS V1-V3)	SELECT 'X' FROM LOADER_COL_FLA...
342,578	2,399	142.80	27.80	1.66	74.6	0	bjstq78pprd24	loader@odidb1 (TNS V1-V3)	SELECT DECODE(ELEMENT_SUBSTITU...
28,578	1	28,578.00	2.32	603.86	.2	.6	6pbnp0hyq18uy	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
27,069	1	27,069.00	2.20	0.48	85.7	1.8	86dghj7qv3tb9	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
26,902	4	6,725.50	2.18	2.41	70.1	2.9	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
22,551	2,399	9.40	1.83	1.62	74.4	0	4z554v42crjkn	loader@odidb1 (TNS V1-V3)	SELECT DECODE(NESTED, 'YES', 1...
22,551	2,399	9.40	1.83	0.41	67.5	0	dutdz1c6ub304	loader@odidb1 (TNS V1-V3)	SELECT DECODE(COUNT(*), 0, 0, ...
17,753	2,399	7.40	1.44	0.27	50.7	0	07rw9znc8g7aj	loader@odidb1 (TNS V1-V3)	SELECT DECODE(COUNT(*), 0, 0, ...
16,372	2,399	6.82	1.33	1.75	79.6	0	9rzjf5cqv4qv1		delete from deferred_stg$ wher...
15,354	2,399	6.40	1.25	0.23	56.5	0	8nb6mg3u6buhq	loader@odidb1 (TNS V1-V3)	select pname, length(pname) f...
15,354	2,399	6.40	1.25	0.26	53	0	d247u0jp3z8ws	loader@odidb1 (TNS V1-V3)	SELECT DECODE(COUNT(*), 0, 0, ...
14,910	2,404	6.20	1.21	0.98	92.9	0	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
12,408	33	376.00	1.01	0.33	57	0	679x4qggryd2v		select smontabv.cnt, smontabv....

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: 650
Captured SQL account for 76.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
480	1	480.00	73.85	603.86	0.21	0.62	6pbnp0hyq18uy	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
135	4	33.75	20.77	2.41	70.09	2.88	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
7	299	0.02	1.08	0.06	69.08	1.41	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
6	320	0.02	0.92	0.34	35.78	2.48	3s58mgk0uy2ws		insert into wrm$_snapshot_deta...
2	1	2.00	0.31	0.48	85.68	1.79	86dghj7qv3tb9	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
0	2,399	0.00	0.00	0.27	50.75	0.00	07rw9znc8g7aj	loader@odidb1 (TNS V1-V3)	SELECT DECODE(COUNT(*), 0, 0, ...
0	1,922	0.00	0.00	0.07	97.13	0.00	0fr8zhn4ymu3v		select intcol#, type, flags, l...
0	4	0.00	0.00	0.02	74.34	0.19	0pt4jfmq9f1q0		SELECT x.statistic# as stat_id...
0	4	0.00	0.00	1.27	27.93	0.00	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
0	1,202	0.00	0.00	0.14	74.55	0.00	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...

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: 536
Captured SQL account for 1.0E+03% of Total
Total UnOptimized Read Requests: 536
Captured SQL account for 1.0E+03% 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	%Opt	%Total	SQL Id	SQL Module	SQL Text
3,932	3,932	4	983.00	0.00	733.58	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
1,008	1,008	4	252.00	0.00	188.06	350myuyx0t1d6		insert into wrh$_tablespace_st...
480	480	1	480.00	0.00	89.55	6pbnp0hyq18uy	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
45	45	4	11.25	0.00	8.40	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
2	2	320	0.01	0.00	0.37	3s58mgk0uy2ws		insert into wrm$_snapshot_deta...
1	1	1	1.00	0.00	0.19	86dghj7qv3tb9	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
0	0	2,399	0.00		0.00	07rw9znc8g7aj	loader@odidb1 (TNS V1-V3)	SELECT DECODE(COUNT(*), 0, 0, ...
0	0	1,922	0.00		0.00	0fr8zhn4ymu3v		select intcol#, type, flags, l...
0	0	4	0.00		0.00	0pt4jfmq9f1q0		SELECT x.statistic# as stat_id...
0	0	1,202	0.00		0.00	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...

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: 127,267
Captured SQL account for 91.4% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	SQL Id	SQL Module	SQL Text
61,398	0	0.00	4.67	47.3	dzs3rm0w0bgnv	loader@odidb1 (TNS V1-V3)	SELECT 'X' FROM LOADER_COL_FLA...
2,882	25	0.01	1.77	48	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
2,407	61,548	25.57	0.75	92	83taa7kaw59c1		select name, intcol#, segcol#,...
2,404	1	0.00	0.10	111.2	2q93zsrvbdw48		select grantee#, privilege#, n...
2,404	0	0.00	0.15	87.5	6aq34nj2zb2n7		select col#, grantee#, privile...
2,404	2,887	1.20	0.98	92.9	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
2,399	2,399	1.00	0.27	50.7	07rw9znc8g7aj	loader@odidb1 (TNS V1-V3)	SELECT DECODE(COUNT(*), 0, 0, ...
2,399	0	0.00	1.62	74.4	4z554v42crjkn	loader@odidb1 (TNS V1-V3)	SELECT DECODE(NESTED, 'YES', 1...
2,399	0	0.00	0.23	56.5	8nb6mg3u6buhq	loader@odidb1 (TNS V1-V3)	select pname, length(pname) f...
2,399	2,399	1.00	1.75	79.6	9rzjf5cqv4qv1		delete from deferred_stg$ wher...
2,399	0	0.00	1.66	74.6	bjstq78pprd24	loader@odidb1 (TNS V1-V3)	SELECT DECODE(ELEMENT_SUBSTITU...
2,399	2,399	1.00	9.75	92.3	cqwfdp2kgp1y6	loader@odidb1 (TNS V1-V3)	SELECT VALUE FROM SYS.LOADER_S...
2,399	2,399	1.00	0.26	53	d247u0jp3z8ws	loader@odidb1 (TNS V1-V3)	SELECT DECODE(COUNT(*), 0, 0, ...
2,399	2,399	1.00	0.41	67.5	dutdz1c6ub304	loader@odidb1 (TNS V1-V3)	SELECT DECODE(COUNT(*), 0, 0, ...
1,922	0	0.00	0.07	97.1	0fr8zhn4ymu3v		select intcol#, type, flags, l...
1,922	48,998	25.49	0.22	93.2	32bhha21dkv0v		select col#, intcol#, charseti...
1,922	2,880	1.50	0.19	96.6	6qz82dptj0qr7		select l.col#, l.intcol#, l.lo...
1,922	0	0.00	0.09	97.6	7nuw4xwrnuwxq		select col#, intcol#, toid, ve...
1,922	0	0.00	0.07	118.6	9g485acn2n30m		select col#, intcol#, reftyp, ...
1,922	0	0.00	0.08	101.1	9rfqm06xmuwu0		select intcol#, toid, version#...
1,922	0	0.00	0.06	87.9	f3g84j69n0tjh		select col#, intcol#, ntab# fr...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 92,010
Captured SQL account for 97.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
61,398	61,398	66.73	dzs3rm0w0bgnv	loader@odidb1 (TNS V1-V3)	SELECT 'X' FROM LOADER_COL_FLA...
2,399	2,399	2.61	07rw9znc8g7aj	loader@odidb1 (TNS V1-V3)	SELECT DECODE(COUNT(*), 0, 0, ...
2,399	2,399	2.61	4z554v42crjkn	loader@odidb1 (TNS V1-V3)	SELECT DECODE(NESTED, 'YES', 1...
2,399	2,399	2.61	8nb6mg3u6buhq	loader@odidb1 (TNS V1-V3)	select pname, length(pname) f...
2,399	2,399	2.61	bjstq78pprd24	loader@odidb1 (TNS V1-V3)	SELECT DECODE(ELEMENT_SUBSTITU...
2,399	2,399	2.61	cqwfdp2kgp1y6	loader@odidb1 (TNS V1-V3)	SELECT VALUE FROM SYS.LOADER_S...
2,399	2,399	2.61	d247u0jp3z8ws	loader@odidb1 (TNS V1-V3)	SELECT DECODE(COUNT(*), 0, 0, ...
2,399	2,399	2.61	dutdz1c6ub304	loader@odidb1 (TNS V1-V3)	SELECT DECODE(COUNT(*), 0, 0, ...
1,922	1,922	2.09	6qz82dptj0qr7		select l.col#, l.intcol#, l.lo...
1,122	1,122	1.22	cm5vu20fhtnq1		select /*+ connect_by_filterin...

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): 28,849
Captured SQL account for 0.0% of Total

Cluster Wait Time (s)	Executions	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.52	4	2.41	21.78	70.09	2.88	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.33	1	603.86	0.06	0.21	0.62	6pbnp0hyq18uy	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
0.23	320	0.34	67.87	35.78	2.48	3s58mgk0uy2ws		insert into wrm$_snapshot_deta...
0.15	33	0.33	45.39	56.98	0.00	679x4qggryd2v		select smontabv.cnt, smontabv....
0.08	1	0.48	17.25	85.68	1.79	86dghj7qv3tb9	sqlplus@odidb1 (TNS V1-V3)	select sum(bytes)/1024/1024/10...
0.05	8	0.07	71.67	32.13	0.00	9wncfacx0nj9h		insert into smon_scn_time (thr...
0.02	4	0.26	8.47	89.62	0.00	84k66tf2s7y1c		insert into wrh$_bg_event_summ...
0.02	4	0.38	5.68	83.47	5.31	85px9dq62dc0q		INSERT /*+ APPEND LEADING(@"SE...
0.02	1	0.08	23.40	49.77	0.00	6rrt4010dxyzv		insert into wrh$_filestatxs (s...
0.02	439	0.13	12.90	90.81	0.00	g00cj285jmgsw		update sys.mon_mods$ set inser...
0.02	4	0.08	21.07	79.62	0.01	5h91zx386wbht		WITH awr_params as ( SELECT /*...
0.01	4	0.02	64.22	51.70	0.00	7g4rxwbvhdh3q		SELECT startsn.stat_id, smap....
0.01	299	0.06	19.12	69.08	1.41	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
0.01	4	2.47	0.37	98.42	0.00	bunssq950snhf		insert into wrh$_sga_target_ad...
0.01	4	0.28	2.67	96.51	0.00	4dy1xm4nxc0gf		insert into wrh$_system_event ...
0.01	1	0.26	2.82	6.57	0.00	317v5hnvvd49h		UPDATE wrh$_seg_stat_obj ob S...
0.01	2,882	1.77	0.39	47.98	0.00	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
0.01	4	2.43	0.28	98.39	0.00	dayq182sk41ks		insert into wrh$_memory_target...
0.01	2,399	0.23	2.60	56.49	0.00	8nb6mg3u6buhq	loader@odidb1 (TNS V1-V3)	select pname, length(pname) f...
0.01	4	1.27	0.46	27.93	0.00	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

0fr8zhn4ymu3v select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc

0pt4jfmq9f1q0 SELECT x.statistic# as stat_id, x.keh_id as keh_id, nvl(awr_time.value_diff, 0) as value_diff FROM X$KEHTIMMAP x , (SELECT startsn.stat_id as stat_id, sum(GREATEST( 0, (endsn.value - startsn.value) )) as value_diff FROM WRH$_SYS_TIME_MODEL startsn , WRH$_SYS_TIME_MODEL endsn WHERE endsn.dbid = :dbid AND endsn.instance_number = :inst AND endsn.snap_id = :eid AND startsn.dbid = :dbid AND startsn.instance_number = endsn.instance_number AND startsn.snap_id = :bid AND startsn.stat_id = endsn.stat_id GROUP BY startsn.stat_id ) awr_time WHERE x.statistic# <> 0 AND x.statistic# = awr_time.stat_id(+) ORDER BY x.keh_id ASC

1cq3qr774cu45 insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum (small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)

1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)

24h34ym0q5fq1 LOCK TABLE "HMV6BF"."AJ_FLWS" IN EXCLUSIVE MODE NOWAIT

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#

317v5hnvvd49h UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LO B', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat)

32bhha21dkv0v select col#, intcol#, charsetid, charsetform from col$ where obj#=:1 order by intcol# asc

350myuyx0t1d6 insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#

3m8smr0v7v1m6 INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)

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

3s58mgk0uy2ws insert into wrm$_snapshot_details (snap_id, dbid, instance_number, table_id, begin_time, end_time) values (:snap_id, :dbid, :instance_number, :bind1, :bind2, :bind3)

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

4dy1xm4nxc0gf insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id

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

5h91zx386wbht WITH awr_params as ( SELECT /*+ NO_MERGE(map) USE_HASH(map) */ p.parameter_hash as parameter_hash, max(map.parameter_name) as parameter_name, max (map.keh_id) as keh_id, max (case when p.snap_id = :bid then upper(p.value) else null end) as first_value, max (case when p.snap_id = :eid then upper(p.value) else null end) as last_value, max (case when p.isdefault = 'TRUE' then upper(p.value) else null end) as default_value, max (upper(p.value)) as max_value, min (upper(p.value)) as min_value, max (case when p.snap_id = :bid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as first_is_mod, max (case when p.snap_id = :eid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as last_is_mod FROM ( SELECT /*+ USE_HASH(xmap) */ xmap.keh_id as keh_id, xmap.parameter_hash as parameter_hash, pn.parameter_name as parameter_name FROM X$KEHPRMMAP xmap , WRH$_PARAMETER_NAME pn WHERE pn.dbid = :dbid AND pn.parameter_hash = xmap.parameter_hash ) map, WRH$_PARAMETER p WHERE p.parameter_hash = map.parameter_hash AND p.dbid = :dbid AND p.instance_number = :inst AND p.snap_id >= :bid AND p.snap_id <= :eid GROUP BY p.parameter_hash ), def_params as (SELECT p.hash as parameter_hash, p.name as parameter_name, x.keh_id as keh_id, decode(p.name, 'db_block_size', '8192', 'gcs_server_processes', '1', 'disk_asynch_io', 'TRUE', '0') as value FROM X$KEHPRMMAP x , V$PARAMETER p WHERE x.parameter_hash = p.hash AND (p.name like '%size' OR p.name like '%target' OR p.name in ('gcs_server_processes', 'disk_asynch_io')) ) SELECT parameter_hash, nvl(a.parameter_name, p.parameter_name) as pname, nvl(a.keh_id, p.keh_id) as keh_id, case when a.keh_id is null then p.value else a.first_value end as first_value, case when a.keh_id is null then p.value else a.last_value end as last_value, case when a.keh_id is null then p.value else a.default_value end as default_value, case when a.keh_id is null then p.value else a.max_valu e end as min_value, case when a.keh_id is null then p.value else a.min_value end as min_value, case when a.keh_id is null then 0 else a.first_is_mod end as first_is_mod, case when a.keh_id is null then 0 else a.last_is_mod end as last_is_mod FROM awr_params a full outer join def_params p using(parameter_hash)

5ms6rbzdnq16t select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job

679x4qggryd2v select smontabv.cnt, smontabv.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt, max(time_mp) time_mp from smon_scn_time) smontabv where smontab.scn = smontabv.scnmax

6ajkhukk78nsr begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;

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

6qz82dptj0qr7 select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc

6rrt4010dxyzv insert into wrh$_filestatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select /*+ opt_param('_optimizer_mjc_enabled', 'false') leading(df fs fw) */ :snap_id, :dbid, :instance_number, df.file#, (df.crscnbas + (df.crscnwrp * power(2, 32))) creation_change#, fs.kcfiopyr, fs.kcfiopyw, fs.kcfiosbr, floor(fs.kcfioprt / 10000), floor(fs.kcfiopwt / 10000), floor(fs.kcfiosbt / 10000), fs.kcfiopbr, fs.kcfiopbw, fw.count, fw.time from x$kcfio fs, file$ df, x$kcbfwait fw where fw.indx+1 = fs.kcfiofno and df.file# = fs.kcfiofno and df.status$ = 2

772s25v1y0x8k select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice

7g4rxwbvhdh3q SELECT startsn.stat_id, smap.keh_id, sum(GREATEST( 0, (endsn.value - startsn.value) )) as value_diff FROM WRH$_SYSSTAT startsn , WRH$_SYSSTAT endsn , X$KEHSYSMAP smap WHERE startsn.stat_id = endsn.stat_id and startsn.stat_id = smap.statistic_hash and endsn.dbid = :dbid AND endsn.instance_number = :inst AND endsn.snap_id = :eid AND startsn.dbid = :dbid AND startsn.instance_number = endsn.instance_number AND startsn.snap_id = :bid and endsn.instance_number = :inst GROUP BY startsn.stat_id, smap.keh_id ORDER BY startsn.stat_id ASC

7k9uvtq74b7ts LOCK TABLE "HMV6BF"."RY_RXXX" IN EXCLUSIVE MODE NOWAIT

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#

7nuw4xwrnuwxq select col#, intcol#, toid, version#, packed, intcols, intcol#s, flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc

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#

84k66tf2s7y1c insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id

85px9dq62dc0q INSERT /*+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial#, px_flags , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_mo del , service_hash, program, module, action, client_id, machine, port, ecid , dbreplay_file_id, dbreplay_call_counter , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT /*+ PARAM('_module_action_old_length', 0) */:snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_s ession_serial#, a.px_flags , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance# , a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , a.dbreplay_file_id, a.dbreplay_call_counter , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.d elta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (nlssort(h.is_awr_sample, 'nls_sort=BINARY') = nlssort('Y', 'nls_sort=BINARY')) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and nlssort(a.need_awr_sample, 'nls_sort=BINARY') = nlssort('Y', 'nls_sort =BINARY'))

86dghj7qv3tb9 select sum(bytes)/1024/1024/1024 from sys.sys_dba_segs

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

9g485acn2n30m select col#, intcol#, reftyp, stabid, expctoid from refcon$ where obj#=:1 order by intcol# asc

9rfqm06xmuwu0 select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc

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

9vnyvh4mq6jzb LOCK TABLE "HMV6BF"."AJ_FLWS_TP" IN EXCLUSIVE MODE NOWAIT

9wncfacx0nj9h insert into smon_scn_time (thread, time_mp, time_dp, scn, scn_wrp, scn_bas, num_mappings, tim_scn_map) values (0, :1, :2, :3, :4, :5, :6, :7)

axfcq597829h6 select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag, inst_id from sys.ts$, GV$FILESPACE_USAGE where ts# = tablespace_id and online$ != 3 and (changescn_wrap > PITRSCNWRP or (changescn_wrap = PITRSCNWRP and changescn_base >= PITRSCNBAS)) and inst_id != :inst and (changescn_wrap > :w or (changescn_wrap = :w and changescn_base >= :b))

aykvshm7zsabd select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'

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

bm2pwrpcr8ru6 select sga_size s, sga_size_factor * 100 f, estd_db_time t, estd_physical_reads p from v$sga_target_advice order by sga_size

bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice

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

cqwfdp2kgp1y6 SELECT VALUE FROM SYS.LOADER_SKIP_UNUSABLE_INDEXES

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

dayq182sk41ks insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice

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

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

f3g84j69n0tjh select col#, intcol#, ntab# from ntab$ where obj#=:1 order by intcol# asc

ftnc9xn199cds LOCK TABLE "HMV6BF"."JG_TXXX" IN EXCLUSIVE MODE NOWAIT

g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

SQL Id	SQL Text
07rw9znc8g7aj	SELECT DECODE(COUNT(*), 0, 0, 1) FROM SYS.ALL_VIEWS WHERE VIEW_NAME = :tname AND OWNER = :owner
0fr8zhn4ymu3v	select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc
0pt4jfmq9f1q0	SELECT x.statistic# as stat_id, x.keh_id as keh_id, nvl(awr_time.value_diff, 0) as value_diff FROM X$KEHTIMMAP x , (SELECT startsn.stat_id as stat_id, sum(GREATEST( 0, (endsn.value - startsn.value) )) as value_diff FROM WRH$_SYS_TIME_MODEL startsn , WRH$_SYS_TIME_MODEL endsn WHERE endsn.dbid = :dbid AND endsn.instance_number = :inst AND endsn.snap_id = :eid AND startsn.dbid = :dbid AND startsn.instance_number = endsn.instance_number AND startsn.snap_id = :bid AND startsn.stat_id = endsn.stat_id GROUP BY startsn.stat_id ) awr_time WHERE x.statistic# <> 0 AND x.statistic# = awr_time.stat_id(+) ORDER BY x.keh_id ASC
1cq3qr774cu45	insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum (small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
24h34ym0q5fq1	LOCK TABLE "HMV6BF"."AJ_FLWS" IN EXCLUSIVE MODE NOWAIT
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#
317v5hnvvd49h	UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'\|\| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LO B', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat)
32bhha21dkv0v	select col#, intcol#, charsetid, charsetform from col$ where obj#=:1 order by intcol# asc
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
3m8smr0v7v1m6	INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
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
3s58mgk0uy2ws	insert into wrm$_snapshot_details (snap_id, dbid, instance_number, table_id, begin_time, end_time) values (:snap_id, :dbid, :instance_number, :bind1, :bind2, :bind3)
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4dy1xm4nxc0gf	insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id
4z554v42crjkn	SELECT DECODE(NESTED, 'YES', 1, 0) FROM SYS.ALL_OBJECT_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner
5h91zx386wbht	WITH awr_params as ( SELECT /+ NO_MERGE(map) USE_HASH(map) / p.parameter_hash as parameter_hash, max(map.parameter_name) as parameter_name, max (map.keh_id) as keh_id, max (case when p.snap_id = :bid then upper(p.value) else null end) as first_value, max (case when p.snap_id = :eid then upper(p.value) else null end) as last_value, max (case when p.isdefault = 'TRUE' then upper(p.value) else null end) as default_value, max (upper(p.value)) as max_value, min (upper(p.value)) as min_value, max (case when p.snap_id = :bid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as first_is_mod, max (case when p.snap_id = :eid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as last_is_mod FROM ( SELECT /+ USE_HASH(xmap) / xmap.keh_id as keh_id, xmap.parameter_hash as parameter_hash, pn.parameter_name as parameter_name FROM X$KEHPRMMAP xmap , WRH$_PARAMETER_NAME pn WHERE pn.dbid = :dbid AND pn.parameter_hash = xmap.parameter_hash ) map, WRH$_PARAMETER p WHERE p.parameter_hash = map.parameter_hash AND p.dbid = :dbid AND p.instance_number = :inst AND p.snap_id >= :bid AND p.snap_id <= :eid GROUP BY p.parameter_hash ), def_params as (SELECT p.hash as parameter_hash, p.name as parameter_name, x.keh_id as keh_id, decode(p.name, 'db_block_size', '8192', 'gcs_server_processes', '1', 'disk_asynch_io', 'TRUE', '0') as value FROM X$KEHPRMMAP x , V$PARAMETER p WHERE x.parameter_hash = p.hash AND (p.name like '%size' OR p.name like '%target' OR p.name in ('gcs_server_processes', 'disk_asynch_io')) ) SELECT parameter_hash, nvl(a.parameter_name, p.parameter_name) as pname, nvl(a.keh_id, p.keh_id) as keh_id, case when a.keh_id is null then p.value else a.first_value end as first_value, case when a.keh_id is null then p.value else a.last_value end as last_value, case when a.keh_id is null then p.value else a.default_value end as default_value, case when a.keh_id is null then p.value else a.max_valu e end as min_value, case when a.keh_id is null then p.value else a.min_value end as min_value, case when a.keh_id is null then 0 else a.first_is_mod end as first_is_mod, case when a.keh_id is null then 0 else a.last_is_mod end as last_is_mod FROM awr_params a full outer join def_params p using(parameter_hash)
5ms6rbzdnq16t	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job
679x4qggryd2v	select smontabv.cnt, smontabv.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt, max(time_mp) time_mp from smon_scn_time) smontabv where smontab.scn = smontabv.scnmax
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
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
6qz82dptj0qr7	select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc
6rrt4010dxyzv	insert into wrh$_filestatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select /+ opt_param('_optimizer_mjc_enabled', 'false') leading(df fs fw) / :snap_id, :dbid, :instance_number, df.file#, (df.crscnbas + (df.crscnwrp * power(2, 32))) creation_change#, fs.kcfiopyr, fs.kcfiopyw, fs.kcfiosbr, floor(fs.kcfioprt / 10000), floor(fs.kcfiopwt / 10000), floor(fs.kcfiosbt / 10000), fs.kcfiopbr, fs.kcfiopbw, fw.count, fw.time from x$kcfio fs, file$ df, x$kcbfwait fw where fw.indx+1 = fs.kcfiofno and df.file# = fs.kcfiofno and df.status$ = 2
772s25v1y0x8k	select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
7g4rxwbvhdh3q	SELECT startsn.stat_id, smap.keh_id, sum(GREATEST( 0, (endsn.value - startsn.value) )) as value_diff FROM WRH$_SYSSTAT startsn , WRH$_SYSSTAT endsn , X$KEHSYSMAP smap WHERE startsn.stat_id = endsn.stat_id and startsn.stat_id = smap.statistic_hash and endsn.dbid = :dbid AND endsn.instance_number = :inst AND endsn.snap_id = :eid AND startsn.dbid = :dbid AND startsn.instance_number = endsn.instance_number AND startsn.snap_id = :bid and endsn.instance_number = :inst GROUP BY startsn.stat_id, smap.keh_id ORDER BY startsn.stat_id ASC
7k9uvtq74b7ts	LOCK TABLE "HMV6BF"."RY_RXXX" IN EXCLUSIVE MODE NOWAIT
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#
7nuw4xwrnuwxq	select col#, intcol#, toid, version#, packed, intcols, intcol#s, flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc
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#
84k66tf2s7y1c	insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id
85px9dq62dc0q	INSERT /+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") / INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial#, px_flags , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_mo del , service_hash, program, module, action, client_id, machine, port, ecid , dbreplay_file_id, dbreplay_call_counter , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT /+ PARAM('_module_action_old_length', 0) /:snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_s ession_serial#, a.px_flags , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance# , a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , a.dbreplay_file_id, a.dbreplay_call_counter , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.d elta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (nlssort(h.is_awr_sample, 'nls_sort=BINARY') = nlssort('Y', 'nls_sort=BINARY')) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and nlssort(a.need_awr_sample, 'nls_sort=BINARY') = nlssort('Y', 'nls_sort =BINARY'))
86dghj7qv3tb9	select sum(bytes)/1024/1024/1024 from sys.sys_dba_segs
8nb6mg3u6buhq	select pname, length(pname) from loader_part_info where parttype = 3 and tname = :1 and owner = :2
9g485acn2n30m	select col#, intcol#, reftyp, stabid, expctoid from refcon$ where obj#=:1 order by intcol# asc
9rfqm06xmuwu0	select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc
9rzjf5cqv4qv1	delete from deferred_stg$ where obj# = :1
9vnyvh4mq6jzb	LOCK TABLE "HMV6BF"."AJ_FLWS_TP" IN EXCLUSIVE MODE NOWAIT
9wncfacx0nj9h	insert into smon_scn_time (thread, time_mp, time_dp, scn, scn_wrp, scn_bas, num_mappings, tim_scn_map) values (0, :1, :2, :3, :4, :5, :6, :7)
axfcq597829h6	select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag, inst_id from sys.ts$, GV$FILESPACE_USAGE where ts# = tablespace_id and online$ != 3 and (changescn_wrap > PITRSCNWRP or (changescn_wrap = PITRSCNWRP and changescn_base >= PITRSCNBAS)) and inst_id != :inst and (changescn_wrap > :w or (changescn_wrap = :w and changescn_base >= :b))
aykvshm7zsabd	select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
bjstq78pprd24	SELECT DECODE(ELEMENT_SUBSTITUTABLE, ' Y', 1, 0) FROM SYS.ALL_NESTED_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner
bm2pwrpcr8ru6	select sga_size s, sga_size_factor * 100 f, estd_db_time t, estd_physical_reads p from v$sga_target_advice order by sga_size
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cqwfdp2kgp1y6	SELECT VALUE FROM SYS.LOADER_SKIP_UNUSABLE_INDEXES
d247u0jp3z8ws	SELECT DECODE(COUNT(*), 0, 0, 1) FROM SYS.LOADER_NESTED_VARRAYS WHERE TABLE_NAME = :tname AND TABLE_OWNER = :owner
dayq182sk41ks	insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice
dutdz1c6ub304	SELECT DECODE(COUNT(*), 0, 0, 1) FROM SYS.ALL_TAB_COLS WHERE TABLE_NAME = :tname AND OWNER = :owner AND COLUMN_NAME = 'SYS_NC_TYPEID$'
dzs3rm0w0bgnv	SELECT 'X' FROM LOADER_COL_FLAGS L WHERE L.TABLE_OWNER = UPPER(:owner) AND L.TABLE_NAME = UPPER(:tname) AND L.COLNAME = UPPER(:cname) AND L.ISVIRTUAL = 'YES'
f3g84j69n0tjh	select col#, intcol#, ntab# from ntab$ where obj#=:1 order by intcol# asc
ftnc9xn199cds	LOCK TABLE "HMV6BF"."JG_TXXX" IN EXCLUSIVE MODE NOWAIT
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

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	44,885	3.11	6.09
execute count	127,267	8.82	17.26
gc cr block receive time	51	0.00	0.01
gc cr blocks received	618	0.04	0.08
gc current block receive time	380	0.03	0.05
gc current blocks received	2,513	0.17	0.34
logons cumulative	222	0.02	0.03
opened cursors cumulative	114,675	7.95	15.55
parse count (total)	92,010	6.38	12.48
parse time elapsed	547	0.04	0.07
physical reads	650	0.05	0.09
physical writes	6,878	0.48	0.93
redo size	11,995,520	831.70	1,626.95
session logical reads	1,232,131	85.43	167.11
user calls	157,308	10.91	21.34
user commits	173	0.01	0.02
user rollbacks	7,200	0.50	0.98
workarea executions - optimal	13,887	0.96	1.88

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	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	0	0.00	0.00
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	22,019	1.53	2.99
CPU used when call started	4,969	0.34	0.67
CR blocks created	13	0.00	0.00
Cached Commit SCN referenced	3,634	0.25	0.49
Commit SCN cached	66	0.00	0.01
DBWR checkpoint buffers written	6,403	0.44	0.87
DBWR checkpoints	2	0.00	0.00
DBWR fusion writes	579	0.04	0.08
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	1,083	0.08	0.15
DBWR undo block writes	3,139	0.22	0.43
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	48	0.00	0.01
Effective IO time	0	0.00	0.00
HSC Heap Segment Block Changes	5,466	0.38	0.74
Heap Segment Array Inserts	552	0.04	0.07
Heap Segment Array Updates	22	0.00	0.00
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	0	0.00	0.00
PX local messages recv'd	96	0.01	0.01
PX local messages sent	96	0.01	0.01
PX remote messages recv'd	194	0.01	0.03
PX remote messages sent	194	0.01	0.03
Parallel operations not downgraded	48	0.00	0.01
Requests to/from client	90,242	6.26	12.24
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	90,243	6.26	12.24
TBS Extension: bytes extended	10,485,760	727.02	1,422.18
TBS Extension: files extended	1	0.00	0.00
TBS Extension: tasks created	19	0.00	0.00
TBS Extension: tasks executed	19	0.00	0.00
active txn count during cleanout	574	0.04	0.08
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	119,090	8.26	16.15
branch node splits	0	0.00	0.00
buffer is not pinned count	624,218	43.28	84.66
buffer is pinned count	312,462	21.66	42.38
bytes received via SQL*Net from client	35,333,152	2,449.81	4,792.24
bytes sent via SQL*Net to client	21,005,026	1,456.37	2,848.91
calls to get snapshot scn: kcmgss	127,521	8.84	17.30
calls to kcmgas	9,216	0.64	1.25
calls to kcmgcs	7,276	0.50	0.99
cell physical IO interconnect bytes	909,091,840	63,031.42	123,300.13
change write time	134	0.01	0.02
cleanout - number of ktugct calls	679	0.05	0.09
cleanouts and rollbacks - consistent read gets	4	0.00	0.00
cleanouts only - consistent read gets	122	0.01	0.02
cluster key scan block gets	107,308	7.44	14.55
cluster key scans	107,306	7.44	14.55
commit batch/immediate performed	2,400	0.17	0.33
commit batch/immediate requested	2,400	0.17	0.33
commit cleanout failures: block lost	62	0.00	0.01
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	20	0.00	0.00
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	2,999	0.21	0.41
commit cleanouts successfully completed	2,917	0.20	0.40
commit immediate performed	2,400	0.17	0.33
commit immediate requested	2,400	0.17	0.33
commit txn count during cleanout	523	0.04	0.07
consistent changes	146	0.01	0.02
consistent gets	1,174,095	81.41	159.24
consistent gets - examination	686,320	47.59	93.09
consistent gets direct	0	0.00	0.00
consistent gets from cache	1,174,095	81.41	159.24
consistent gets from cache (fastpath)	468,130	32.46	63.49
cursor authentications	24	0.00	0.00
data blocks consistent reads - undo records applied	44	0.00	0.01
db block gets	58,036	4.02	7.87
db block gets direct	117	0.01	0.02
db block gets from cache	57,919	4.02	7.86
db block gets from cache (fastpath)	19,445	1.35	2.64
deferred (CURRENT) block cleanout applications	1,635	0.11	0.22
dirty buffers inspected	0	0.00	0.00
enqueue conversions	15,535	1.08	2.11
enqueue releases	579,517	40.18	78.60
enqueue requests	584,324	40.51	79.25
enqueue timeouts	4,805	0.33	0.65
enqueue waits	6,667	0.46	0.90
exchange deadlocks	2	0.00	0.00
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	0.00	0.00
free buffer requested	6,116	0.42	0.83
gc blocks compressed	4,819	0.33	0.65
gc blocks lost	0	0.00	0.00
gc cr block flush time	4	0.00	0.00
gc cr blocks served	4,820	0.33	0.65
gc current block flush time	78	0.01	0.01
gc current block pin time	0	0.00	0.00
gc current blocks served	1,840	0.13	0.25
gc force cr disk read	499	0.03	0.07
gc kbytes saved	24,315	1.69	3.30
gc kbytes sent	28,965	2.01	3.93
gc local grants	821	0.06	0.11
gc read waits	0	0.00	0.00
gc remote grants	813	0.06	0.11
gcs messages sent	11,985	0.83	1.63
ges messages sent	35,815	2.48	4.86
global enqueue get time	3,089	0.21	0.42
global enqueue gets async	3,287	0.23	0.45
global enqueue gets sync	105,428	7.31	14.30
global enqueue releases	90,161	6.25	12.23
heap block compress	91	0.01	0.01
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	126	0.01	0.02
immediate (CURRENT) block cleanout applications	636	0.04	0.09
index crx upgrade (positioned)	240	0.02	0.03
index fast full scans (direct read)	0	0.00	0.00
index fast full scans (full)	5	0.00	0.00
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	685,833	47.55	93.02
index scans kdiixs1	116,565	8.08	15.81
leaf node 90-10 splits	99	0.01	0.01
leaf node splits	190	0.01	0.03
lob reads	0	0.00	0.00
lob writes	133	0.01	0.02
lob writes unaligned	133	0.01	0.02
logical read bytes from cache	10,092,642,304	699,768.22	1,368,865.09
max cf enq hold time	10	0.00	0.00
messages received	9,020	0.63	1.22
messages sent	9,020	0.63	1.22
min active SCN optimization applied on CR	0	0.00	0.00
no work - consistent read gets	462,803	32.09	62.77
non-idle wait count	698,207	48.41	94.70
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	37	0.00	0.01
parse time cpu	430	0.03	0.06
physical read IO requests	536	0.04	0.07
physical read bytes	5,324,800	369.19	722.20
physical read total IO requests	40,838	2.83	5.54
physical read total bytes	657,719,296	45,602.63	89,206.47
physical read total multi block requests	0	0.00	0.00
physical reads cache	650	0.05	0.09
physical reads cache prefetch	114	0.01	0.02
physical reads direct	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	113	0.01	0.02
physical write IO requests	4,503	0.31	0.61
physical write bytes	56,344,576	3,906.62	7,642.01
physical write total IO requests	21,867	1.52	2.97
physical write total bytes	251,372,544	17,428.79	34,093.66
physical write total multi block requests	73	0.01	0.01
physical writes direct	117	0.01	0.02
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	6,761	0.47	0.92
physical writes non checkpoint	1,428	0.10	0.19
pinned buffers inspected	0	0.00	0.00
pinned cursors current	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	0	0.00	0.00
queries parallelized	48	0.00	0.01
recursive calls	406,141	28.16	55.08
recursive cpu usage	2,314	0.16	0.31
redo blocks checksummed by FG (exclusive)	11,983	0.83	1.63
redo blocks written	26,449	1.83	3.59
redo buffer allocation retries	0	0.00	0.00
redo entries	25,525	1.77	3.46
redo log space requests	0	0.00	0.00
redo ordering marks	413	0.03	0.06
redo size for direct writes	416	0.03	0.06
redo subscn max counts	501	0.03	0.07
redo synch long waits	59	0.00	0.01
redo synch poll writes	0	0.00	0.00
redo synch polls	0	0.00	0.00
redo synch time	301	0.02	0.04
redo synch time (usec)	3,016,143	209.12	409.08
redo synch time overhead (usec)	720,589,603	49,961.71	97,733.57
redo synch time overhead count (<128 msec)	0	0.00	0.00
redo synch time overhead count (<2 msec)	2,427	0.17	0.33
redo synch time overhead count (<32 msec)	1	0.00	0.00
redo synch time overhead count (<8 msec)	10	0.00	0.00
redo synch time overhead count (>=128 msec)	1	0.00	0.00
redo synch writes	2,439	0.17	0.33
redo wastage	1,088,284	75.46	147.60
redo write broadcast ack count	621	0.04	0.08
redo write broadcast ack time	209,822	14.55	28.46
redo write broadcast lgwr post count	0	0.00	0.00
redo write info find	2,439	0.17	0.33
redo write info find fail	0	0.00	0.00
redo write time	441	0.03	0.06
redo writes	3,867	0.27	0.52
remote Oradebug requests	2	0.00	0.00
rollback changes - undo records applied	4,800	0.33	0.65
rollbacks only - consistent read gets	9	0.00	0.00
root node splits	0	0.00	0.00
rows fetched via callback	87,572	6.07	11.88
session connect time	0	0.00	0.00
shared hash latch upgrades - no wait	15,083	1.05	2.05
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	30,147	2.09	4.09
sorts (rows)	222,999	15.46	30.25
sql area evicted	18	0.00	0.00
sql area purged	0	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	26	0.00	0.00
table fetch by rowid	206,286	14.30	27.98
table fetch continued row	3	0.00	0.00
table scan blocks gotten	77,666	5.38	10.53
table scan rows gotten	1,310,442	90.86	177.74
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	4,118	0.29	0.56
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	40	0.00	0.01
total number of cf enq holders	4	0.00	0.00
total number of times SMON posted	39	0.00	0.01
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	2,400	0.17	0.33
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	3,913,264	271.32	530.76
user logons cumulative	2	0.00	0.00
user logouts cumulative	1	0.00	0.00
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
logons current	72	73
opened cursors current	218	218
session cursor cache count	19,872	21,128
session pga memory	829,522,200	882,985,744
session pga memory max	1,348,715,448	1,413,320,112
session uga memory	2,315,940,152	2,350,954,016
session uga memory max	57,423,761,272	57,601,374,720
workarea memory allocated	1,060	1,060

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

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)
Others	622M	2.79	.043M	160M	0.67	.011M	45.1K	0.08
DBWR	0M	0.00	0M	52M	0.31	.004M	5	0.00
LGWR	0M	0.00	0M	25M	0.54	.002M	3867	0.62
Buffer Cache Reads	5M	0.04	0M	0M	0.00	0M	537	6.83
Direct Writes	0M	0.00	0M	1M	0.00	0M	0
TOTAL:	627M	2.83	.043M	238M	1.52	.017M	49.5K	0.20

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
Control File	615M	2.73	.043M	150M	0.67	.01M	0.01
Data File	12M	0.10	.001M	53M	0.31	.004M	3.81
Log File	0M	0.00	0M	25M	0.54	.002M
TOTAL:	627M	2.83	.043M	228M	1.52	.016M	0.15

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	622M	2.79	.043M	160M	0.67	.011M	40.3K	0.07
Others (Control File)	614M	2.73	.043M	150M	0.67	.01M	39.3K	0.01
Others (Data File)	8M	0.07	.001M	10M	0.00	.001M	967	2.12
DBWR	0M	0.00	0M	52M	0.31	.004M	5	0.00
DBWR (Data File)	0M	0.00	0M	52M	0.31	.004M	0
DBWR (Control File)	0M	0.00	0M	0M	0.00	0M	5	0.00
LGWR	0M	0.00	0M	25M	0.54	.002M	0
LGWR (Log File)	0M	0.00	0M	25M	0.54	.002M	0
Buffer Cache Reads	5M	0.04	0M	0M	0.00	0M	536	6.83
Buffer Cache Reads (Data File)	5M	0.04	0M	0M	0.00	0M	536	6.83
Direct Writes	0M	0.00	0M	1M	0.00	0M	0
Direct Writes (Data File)	0M	0.00	0M	1M	0.00	0M	0
TOTAL:	627M	2.83	.043M	238M	1.52	.017M	40.8K	0.15

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Buffer Waits
UNDOTBS1	0	0.00	0.00	2,217	0.00	0	1
SYSAUX	217	4.42	1.54	1,880	0.01	5	0
SYSTEM	67	5.52	1.01	404	0.00	5	0
XABF	87	12.30	1.00	0	0.01	13	0
ESBF	85	6.12	1.00	0	0.01	6	0
BMBF	79	10.76	1.00	0	0.01	11	0
DSG	1	0.00	1.00	0	0.00	0	0

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Av 1-bk Rd(ms)	Writes	Buffer Waits
BMBF	+DATA/odi/datafile/bmbf.374.845135077	3	6.67	1.00	6.67	0	0
BMBF	+DATA/odi/datafile/bmbf.379.845135609	3	10.00	1.00	10.00	0	0
BMBF	+DATA/odi/datafile/bmbf.383.845136433	3	13.33	1.00	13.33	0	0
BMBF	+DATA/odi/datafile/bmbf.389.845137019	2	5.00	1.00	0.00	0	0
BMBF	+DATA/odi/datafile/bmbf.395.845137839	8	5.00	1.00	6.25	0	0
BMBF	+DATA/odi/datafile/bmbf.398.845138575	4	7.50	1.00	7.50	0	0
BMBF	+DATA/odi/datafile/bmbf.403.845139347	10	6.00	1.00	6.00	0	0
BMBF	+DATA/odi/datafile/bmbf.410.845140041	6	15.00	1.00	15.00	0	0
BMBF	+DATA/odi/datafile/bmbf.417.845140983	5	8.00	1.00	8.00	0	0
BMBF	+DATA/odi/datafile/bmbf.425.845142107	2	5.00	1.00	10.00	0	0
BMBF	+DATA/odi/datafile/bmbf.431.845143137	2	5.00	1.00	5.00	0	0
BMBF	+DATA/odi/datafile/bmbf.438.845144039	1	10.00	1.00	10.00	0	0
BMBF	+DATA/odi/datafile/bmbf.445.845144211	3	3.33	1.00	6.67	0	0
BMBF	+DATA/odi/datafile/bmbf.449.845145225	7	8.57	1.00	8.57	0	0
BMBF	+DATA/odi/datafile/bmbf.459.845146263	20	19.50	1.00	20.00	0	0
DSG	+DATA/odi/datafile/dsg.268.845121707	1	0.00	1.00	0.00	0	0
ESBF	+DATA/odi/datafile/esbf.386.845136783	7	5.71	1.00	5.71	0	0
ESBF	+DATA/odi/datafile/esbf.391.845137043	1	0.00	1.00	0.00	0	0
ESBF	+DATA/odi/datafile/esbf.399.845138575	2	10.00	1.00	10.00	0	0
ESBF	+DATA/odi/datafile/esbf.405.845139347	9	7.78	1.00	6.67	0	0
ESBF	+DATA/odi/datafile/esbf.408.845140035	12	6.67	1.00	7.50	0	0
ESBF	+DATA/odi/datafile/esbf.415.845140747	5	6.00	1.00	6.00	0	0
ESBF	+DATA/odi/datafile/esbf.422.845141045	4	5.00	1.00	5.00	0	0
ESBF	+DATA/odi/datafile/esbf.429.845142109	14	5.71	1.00	5.71	0	0
ESBF	+DATA/odi/datafile/esbf.434.845143137	3	6.67	1.00	6.67	0	0
ESBF	+DATA/odi/datafile/esbf.440.845144161	6	5.00	1.00	5.00	0	0
ESBF	+DATA/odi/datafile/esbf.448.845145223	5	6.00	1.00	6.00	0	0
ESBF	+DATA/odi/datafile/esbf.456.845146263	3	3.33	1.00	6.67	0	0
ESBF	+DATA/odi/datafile/esbf.461.845147035	14	6.43	1.00	6.43	0	0
SYSAUX	+DATA/odi/datafile/sysaux.257.844614421	217	4.42	1.54	4.71	1,880	0
SYSTEM	+DATA/odi/datafile/system.256.844614421	67	5.52	1.01	5.45	404	0
UNDOTBS1	+DATA/odi/datafile/undotbs1.258.844614421	0				2,217	1
XABF	+DATA/odi/datafile/xabf.348.845132287	3	6.67	1.00	6.67	0	0
XABF	+DATA/odi/datafile/xabf.352.845132843	6	5.00	1.00	5.00	0	0
XABF	+DATA/odi/datafile/xabf.356.845133125	2	45.00	1.00	50.00	0	0
XABF	+DATA/odi/datafile/xabf.360.845133441	7	7.14	1.00	8.57	0	0
XABF	+DATA/odi/datafile/xabf.364.845133801	10	5.00	1.00	5.00	0	0
XABF	+DATA/odi/datafile/xabf.367.845134387	5	6.00	1.00	6.00	0	0
XABF	+DATA/odi/datafile/xabf.373.845134969	18	6.67	1.00	6.67	0	0
XABF	+DATA/odi/datafile/xabf.381.845136393	6	5.00	1.00	5.00	0	0
XABF	+DATA/odi/datafile/xabf.385.845136473	5	6.00	1.00	4.00	0	0
XABF	+DATA/odi/datafile/xabf.390.845137019	9	31.11	1.00	32.22	0	0
XABF	+DATA/odi/datafile/xabf.394.845137839	4	7.50	1.00	7.50	0	0
XABF	+DATA/odi/datafile/xabf.401.845138577	1	10.00	1.00	10.00	0	0
XABF	+DATA/odi/datafile/xabf.411.845140045	3	3.33	1.00	3.33	0	0
XABF	+DATA/odi/datafile/xabf.418.845140983	2	5.00	1.00	5.00	0	0
XABF	+DATA/odi/datafile/xabf.437.845143137	2	135.00	1.00	140.00	0	0
XABF	+DATA/odi/datafile/xabf.442.845144161	2	5.00	1.00	5.00	0	0
XABF	+DATA/odi/datafile/xabf.447.845145223	1	0.00	1.00	0.00	0	0
XABF	+DATA/odi/datafile/xabf.458.845146263	1	0.00	1.00	0.00	0	0

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,464,076	100	1,231,983	653	6,761	0	0	1

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 6,878

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	6,403	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

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

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	0	372	2229	1110	1698651	1110			0
E	0	0	396	2325	2427	1698651	2427			0

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,944	0.10	345	1.01	2,379	1	382.00
D	5,888	0.20	690	1.00	2,366	1	373.00
D	8,832	0.30	1,035	1.00	2,364	1	372.00
D	11,776	0.40	1,380	1.00	2,362	1	370.00
D	14,720	0.50	1,725	1.00	2,361	1	370.00
D	17,664	0.60	2,069	1.00	2,360	1	369.00
D	20,608	0.70	2,414	1.00	2,360	1	369.00
D	23,552	0.80	2,759	1.00	2,360	1	369.00
D	26,496	0.90	3,104	1.00	2,360	1	369.00
D	29,440	1.00	3,449	1.00	2,360	1	369.00
D	29,568	1.00	3,464	1.00	2,360	1	369.00
D	32,384	1.10	3,794	1.00	2,360	1	369.00
D	35,328	1.19	4,139	1.00	2,360	1	369.00
D	38,272	1.29	4,484	1.00	2,360	1	369.00
D	41,216	1.39	4,829	1.00	2,360	1	369.00
D	44,160	1.49	5,174	1.00	2,360	1	369.00
D	47,104	1.59	5,519	1.00	2,360	1	369.00
D	50,048	1.69	5,863	1.00	2,360	1	369.00
D	52,992	1.79	6,208	1.00	2,360	1	369.00
D	55,936	1.89	6,553	1.00	2,360	1	369.00
D	58,880	1.99	6,898	0.99	2,329	1	350.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	344	0

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
2K	4K	13,606	13,606
64K	128K	48	48
256K	512K	4	4
512K	1024K	72	72
1M	2M	138	138
2M	4M	11	11
4M	8M	8	8

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	69,186.25	100.00	56,034,506
6,080	0.25	69,186.25	100.00	56,034,506
12,160	0.50	69,186.25	100.00	56,034,506
18,240	0.75	69,186.25	100.00	56,034,506
24,320	1.00	69,186.25	100.00	56,034,506
29,184	1.20	69,186.25	100.00	56,034,506
34,048	1.40	69,186.25	100.00	56,034,506
38,912	1.60	69,186.25	100.00	56,034,506
43,776	1.80	69,186.25	100.00	56,034,506
48,640	2.00	69,186.25	100.00	56,034,506
72,960	3.00	69,186.25	100.00	56,034,506
97,280	4.00	69,186.25	100.00	56,034,506
145,920	6.00	69,186.25	100.00	56,034,506
194,560	8.00	69,186.25	100.00	56,034,506

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,480	0.90	275	12,161	253,270	1.00	4,622	1.00	13,704
4,608	0.92	403	14,652	253,274	1.00	4,618	1.00	13,704
4,736	0.95	530	17,150	253,275	1.00	4,617	1.00	13,704
4,864	0.97	657	19,648	253,281	1.00	4,611	1.00	13,839
4,992	1.00	784	22,146	253,292	1.00	4,600	1.00	13,932
5,120	1.03	911	24,644	253,297	1.00	4,595	1.00	13,932
5,248	1.05	1,038	27,142	253,297	1.00	4,595	1.00	13,932
5,376	1.08	1,165	29,640	253,297	1.00	4,595	1.00	13,932
5,504	1.10	1,292	32,138	253,297	1.00	4,595	1.00	13,932
5,632	1.13	1,419	34,636	253,297	1.00	4,595	1.00	13,932
5,760	1.15	1,546	37,134	253,297	1.00	4,595	1.00	13,932
5,888	1.18	1,673	39,632	253,297	1.00	4,595	1.00	13,932
6,016	1.21	1,800	42,130	253,297	1.00	4,595	1.00	13,932
6,144	1.23	1,927	44,628	253,297	1.00	4,595	1.00	13,932
6,528	1.31	2,311	52,133	253,297	1.00	4,595	1.00	13,932
7,040	1.41	2,823	65,071	253,297	1.00	4,595	1.00	13,932
7,552	1.51	3,335	75,919	253,297	1.00	4,595	1.00	13,932
8,064	1.62	3,846	86,064	253,297	1.00	4,595	1.00	13,932
8,576	1.72	4,357	96,209	253,297	1.00	4,595	1.00	13,932
9,088	1.82	4,868	106,354	253,297	1.00	4,595	1.00	13,932
9,600	1.92	5,379	116,499	253,298	1.00	4,594	1.00	13,932
10,112	2.03	5,890	126,644	253,300	1.00	4,592	1.00	13,933

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	474,060	2,379,409
13,584	0.38	474,060	2,366,195
18,112	0.50	474,060	2,361,476
22,640	0.63	474,060	2,361,476
27,168	0.75	474,060	2,360,768
31,696	0.88	474,060	2,359,588
36,224	1.00	474,060	2,359,588
40,752	1.13	474,060	2,359,588
45,280	1.25	474,060	2,359,588
49,808	1.38	474,060	2,359,588
54,336	1.50	474,060	2,359,588
58,864	1.63	474,062	2,359,588
63,392	1.75	474,062	2,329,149
67,920	1.88	474,062	2,329,149
72,448	2.00	474,062	2,329,149

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)
undo block	1	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)
TX-Transaction	3,398	3,397	0	1	599	598,750.00
CO-KTUCLO Master Slave enq (master slave det)	4,800	0	4,800	4,800	7	1.48
TM-DML	10,101	10,101	0	1,446	2	1.30
PS-PX Process Reservation	313	313	0	146	0	1.51
WF-AWR Flush	92	92	0	76	0	2.63
TT-Tablespace	5,423	5,423	0	24	0	1.67
JQ-Job Queue	25	24	1	12	0	2.50
TA-Instance Undo	47	47	0	47	0	0.43
MW-MWIN Schedule	8	8	0	8	0	2.50
RO-Multiple Object Reuse (fast object reuse)	8	8	0	4	0	5.00
CF-Controlfile Transaction	31,008	31,008	0	3	0	6.67
PI-Remote PX Process Spawn Status	47	47	0	24	0	0.42
DR-Distributed Recovery	8	8	0	8	0	1.25
AF-Advisor Framework (task serialization)	52	52	0	7	0	1.43
JS-Job Scheduler (job run lock - synchronize)	8	8	0	7	0	1.43
HW-Segment High Water Mark	964	964	0	4	0	2.50
UL-User-defined	29	29	0	3	0	3.33
TD-KTF map table enqueue (KTF dump entries)	33	33	0	33	0	0.00
CR-Reuse Block Range (block range reuse ckpt)	24	24	0	4	0	0.00
FB-Format Block	14	14	0	2	0	0.00
TX-Transaction (index contention)	2	2	0	2	0	0.00
AE-Edition Lock (lock)	104	104	0	1	0	0.00
CT-Block Change Tracking (state)	1	1	0	1	0	0.00
FD-Flashback Database (Flashback logical operations)	1	1	0	1	0	0.00
MV-Online Datafile Move (datafile move)	1	1	0	1	0	0.00
SW-Suspend Writes	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	2.93	3,387	756	7	24.3/32	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 09:53	103	112	736	5	24	0/0	0/0/0/0/0/0
21-Apr 09:43	91	104	135	5	31	0/0	0/0/0/0/0/0
21-Apr 09:33	106	114	739	5	24	0/0	0/0/0/0/0/0
21-Apr 09:23	78	101	138	5	31	0/0	0/0/0/0/0/0
21-Apr 09:13	112	208	740	5	24	0/0	0/0/0/0/0/0
21-Apr 09:03	248	211	138	7	31	0/0	0/0/0/0/0/0
21-Apr 08:53	96	107	741	5	24	0/0	0/0/0/0/0/0
21-Apr 08:43	104	119	140	5	31	0/0	0/0/0/0/0/0
21-Apr 08:33	99	110	742	5	24	0/0	0/0/0/0/0/0
21-Apr 08:23	76	105	141	5	31	0/0	0/0/0/0/0/0
21-Apr 08:13	104	200	741	5	24	0/0	0/0/0/0/0/0
21-Apr 08:03	254	210	139	7	31	0/0	0/0/0/0/0/0
21-Apr 07:53	88	98	743	5	24	0/0	0/0/0/0/0/0
21-Apr 07:43	103	118	142	5	32	0/0	0/0/0/0/0/0
21-Apr 07:33	100	112	745	5	25	0/0	0/0/0/0/0/0
21-Apr 07:23	83	105	144	5	32	0/0	0/0/0/0/0/0
21-Apr 07:13	99	201	749	5	26	0/0	0/0/0/0/0/0
21-Apr 07:03	240	199	147	6	32	0/0	0/0/0/0/0/0
21-Apr 06:53	95	106	747	5	25	0/0	0/0/0/0/0/0
21-Apr 06:43	104	118	146	5	32	0/0	0/0/0/0/0/0
21-Apr 06:33	102	111	752	5	26	0/0	0/0/0/0/0/0
21-Apr 06:23	82	104	150	5	32	0/0	0/0/0/0/0/0
21-Apr 06:13	101	199	756	5	26	0/0	0/0/0/0/0/0
21-Apr 06:03	261	215	155	7	32	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	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	4	0.00		0
AQ dequeue txn counter latch	480	0.00		0
ASM Keyed state latch	281	0.00		0
ASM allocation	10	0.00		0
ASM db client latch	9,697	0.00		0
ASM map headers	22	0.00		0
ASM map load waiting list	5	0.00		0
ASM map operation freelist	67	0.00		0
ASM map operation hash table	141,224	0.00	0.00	0
ASM network background latch	5,798	0.00		0
ASM network state latch	239	0.00		0
AWR Alerted Metric Element list	147,105	0.00		0
Change Notification Hash table latch	4,804	0.00		0
Consistent RBA	3,874	0.00		0
DML lock allocation	17,452	0.00		0
Event Group Locks	391	0.00		0
FIB s.o chain latch	2	0.00		0
FOB s.o list latch	13,955	0.00		0
File State Object Pool Parent Latch	4	0.00		0
I/O Staticstics latch	4	0.00		0
IPC other latch	121	0.00		0
IPC stats buffer allocation latch	636	0.00		637	0.00
In memory undo latch	4	0.00		0
JS Sh mem access	32	15.63	1.00	0
JS broadcast add buf latch	14,302	0.00		0
JS broadcast drop buf latch	14,306	0.00		0
JS broadcast load blnc latch	13,889	0.00		0
JS mem alloc latch	22	0.00		0
JS queue access latch	26	0.00		0
JS queue state obj latch	500,140	0.00		0
JS slv state obj latch	132	0.76	0.00	0
KFC FX Hash Latch	4	0.00		0
KFC Hash Latch	4	0.00		0
KFCL LE Freelist	4	0.00		0
KFK SGA Libload latch	8,640	0.00		0
KFMD SGA	6	0.00		0
KGNFS-NFS:SHM structure	4	0.00		0
KGNFS-NFS:SVR LIST	4	0.00		0
KJC message pool free list	6,949	0.03	0.50	1,544	0.00
KJCT flow control latch	84,311	0.02	0.00	0
KMG MMAN ready and startup request latch	4,806	0.00		0
KSXR large replies	970	0.00		0
KTF sga latch	114	0.00		3,744	0.00
KWQMN job cache list latch	1,018	0.00		0
Locator state objects pool parent latch	4	0.00		0
Lsod array latch	266	0.00		0
MQL Tracking Latch	0			288	0.00
Memory Management Latch	4	0.00		4,806	0.00
Memory Queue	4	0.00		0
Memory Queue Message Subscriber #1	4	0.00		0
Memory Queue Message Subscriber #2	4	0.00		0
Memory Queue Message Subscriber #3	4	0.00		0
Memory Queue Message Subscriber #4	4	0.00		0
Memory Queue Subscriber	4	0.00		0
MinActiveScn Latch	5,040	0.00		0
Mutex	4	0.00		0
Mutex Stats	4	0.00		0
OS process	1,260	0.00		0
OS process allocation	29,535	0.00		0
OS process: request allocation	281	0.00		0
PL/SQL warning settings	284	0.00		0
PX hash array latch	4	0.00		0
QMT	4	0.00		0
Real-time plan statistics latch	57,840	0.00		0
SGA IO buffer pool latch	21	0.00		21	0.00
SGA blob parent	4	0.00		0
SGA bucket locks	4	0.00		0
SGA heap locks	4	0.00		0
SGA pool locks	4	0.00		0
SQL memory manager latch	484	0.00		4,802	0.00
SQL memory manager workarea list latch	337,592	0.00		0
Shared B-Tree	507	0.00		0
Streams Generic	4	0.00		0
Testing	4	0.00		0
Token Manager	4	0.00		0
WCR: sync	4	0.00		0
Write State Object Pool Parent Latch	4	0.00		0
X$KSFQP	4	0.00		0
XDB NFS Security Latch	4	0.00		0
XDB unused session pool	4	0.00		0
XDB used session pool	4	0.00		0
active checkpoint queue latch	16,627	0.20	0.03	0
active service list	174,508	0.00	0.33	7,245	0.00
begin backup scn array	8	0.00		0
buffer pool	4	0.00		0
business card	100	0.00		0
cache buffer handles	212	0.00		0
cache buffers chains	1,896,381	0.00	0.00	46,528	0.00
cache buffers lru chain	15,678	0.01	1.00	49,080	0.00
cache table scan latch	1	0.00		1	0.00
call allocation	978	0.31	0.33	0
cas latch	4	0.00		0
change notification client cache latch	4	0.00		0
channel handle pool latch	349	0.00		0
channel operations parent latch	2,359,718	0.00		0
checkpoint queue latch	3,166,966	0.00	0.00	7,094	0.00
client/application info	742	0.00		0
compile environment latch	246	0.00		0
corrupted undo seg latch	16,800	0.00		0
cp cmon/server latch	4	0.00		0
cp pool latch	4	0.00		0
cp server hash latch	4	0.00		0
cp sga latch	229	0.00		0
cvmap freelist lock	4	0.00		0
deferred cleanup latch	229	0.00		0
dml lock allocation	229	0.00		0
done queue latch	4	0.00		0
dummy allocation	495	0.00		0
eighth spare latch - X parent	4	0.00		0
eleventh spare latch - children	4	0.00		0
enqueue freelist latch	4	0.00		1,143,947	0.00
enqueue hash chains	1,217,491	0.00	0.00	1,125	0.00
enqueues	12	0.00		0
error message lists	192	0.00		0
fifteenth spare latch - children	4	0.00		0
file cache latch	8,459	0.00		0
flashback copy	4	0.00		0
fourteenth spare latch - children	4	0.00		0
fourth Audit Vault latch	4	0.00		0
gc element	34,001	0.04	0.27	43,580	0.00
gcs commit scn state	4	0.00		0
gcs opaque info freelist	5,164	0.02	0.00	0
gcs partitioned table hash	19,711,604	0.00	0.00	403	0.00
gcs pcm hashed value bucket hash	4	0.00		0
gcs remaster request queue	51	0.00		0
gcs resource freelist	1,223	0.00		831	0.00
gcs resource hash	33,453	0.05	0.00	1	0.00
gcs resource scan list	6	0.00		0
gcs resource validate list	4	0.00		0
gcs shadows freelist	617	0.00		1,847	0.00
ges DFS wait callback info	6	0.00		1	0.00
ges caches resource lists	83,870	0.01	0.08	170,264	0.00
ges deadlock list	320	0.00		296	0.00
ges domain table	176,817	0.00		0
ges enqueue table freelist	194,607	0.00		0
ges group table	173,721	0.00		0
ges process hash list	6,273	0.03	1.00	0
ges process parent latch	431,492	0.56	1.00	0
ges process table freelist	281	0.00		0
ges resource hash list	436,103	0.73	0.97	1,594	0.00
ges resource scan list	1,982	0.00		0
ges resource table freelist	974	0.00		0
ges timeout list	1,686	0.00		147	0.00
ges value block free list	2,464	0.00		0
global tx hash mapping	4	0.00		0
granule operation	4	0.00		0
hash table column usage latch	98	0.00		13,474	0.00
hash table modification latch	362	0.00		0
heartbeat check	4	0.00		4,085	0.00
heartbeat structure management	0			2,884	0.00
interrupt manipulation	681	0.00		0
intra txn parallel recovery	4	0.00		0
io pool granule metadata list	4	0.00		0
job workq parent latch	37	0.00		33	0.00
job_queue_processes free list latch	82	0.00		0
job_queue_processes parameter latch	14,151	0.00		0
k2q global data latch	9,612	0.00		0
k2q lock allocation	4	0.00		0
kdlx hb parent latch	4	0.00		0
kgb parent	4	0.00		0
kgnfs mount latch	4	0.00		0
kokc descriptor allocation latch	16	0.00		0
ksfv messages	4	0.00		0
ksim group membership cache	606	0.00		0
ksim membership request latch	0			7,571	0.00
kss move lock	106	0.00		0
ksuosstats global area	1,455	0.00		0
ksv allocation latch	433	0.00		0
ksv class latch	26,505	0.00		0
ksv instance latch	4	0.00		0
ksv msg queue latch	4	0.00		0
ksxp shared latch	281	0.00		0
ksxp so latch	281	0.00		0
ksz_so allocation latch	281	0.00		0
ktm global data	284	0.00		0
kwqbsn:qsga	503	0.00		0
lgwr LWN SCN	6,043	0.00		0
list of block allocation	186	0.00		0
loader state object freelist	8	0.00		0
lob segment dispenser latch	4	0.00		0
lob segment hash table latch	52	0.00		0
lob segment query latch	4	0.00		0
lock DBA buffer during media recovery	4	0.00		0
logical standby cache	4	0.00		0
logminer context allocation	4	0.00		0
logminer local	4	0.00		0
logminer work area	4	0.00		0
longop free list parent	4	0.00		0
mapped buffers lru chain	4	0.00		0
message pool operations parent latch	19,372	0.00		0
messages	580,095	0.00	0.00	0
mostly latch-free SCN	6,054	0.03	0.00	0
msg queue latch	4	0.00		0
multiblock read objects	2,394	0.00		0
name-service memory objects	2,514	0.00		0
name-service namespace bucket	76,170	0.00		0
name-service namespace objects	48	0.00		0
name-service pending queue	1,832	0.00		0
name-service request	144	0.00		0
name-service request queue	141,998	0.00		0
ncodef allocation latch	229	0.00		0
nineth spare latch - X parent	4	0.00		0
object queue header heap	134,667	0.00		1,748	0.00
object queue header operation	2,933,975	0.00	0.08	0
object stats modification	543	0.00		0
parallel query alloc buffer	3,948	0.00		0
parallel query stats	221	0.00		0
parallel txn reco latch	3,055	0.00		0
parameter list	70	0.00		0
parameter table management	803	0.00		0
peshm	4	0.00		0
pesom_free_list	4	0.00		0
pesom_hash_node	4	0.00		0
post/wait queue	179,344	0.00	0.00	177,193	0.00
process allocation	70,342	0.00		141	0.00
process group creation	281	0.00		0
process queue	583	0.00		0
process queue reference	8,390	0.00		797	0.00
qmn task queue latch	2,048	0.00		0
query server freelists	486	0.00		0
query server process	49	0.00		24	0.00
queued dump request	48	0.00		0
queuing load statistics	4	0.00		0
recovery domain hash list	4	0.00		0
redo allocation	15,974	0.02	0.00	25,498	0.03
redo copy	4	0.00		25,503	0.24
redo writing	38,331	0.04	0.00	0
resmgr group change latch	129	0.00		0
resmgr:active threads	495	0.00		0
resmgr:actses change group	160	0.00		0
resmgr:actses change state	4	0.00		0
resmgr:free threads list	491	0.20	0.00	0
resmgr:plan CPU method	4	0.00		0
resmgr:resource group CPU method	4	0.00		0
resmgr:schema config	124	0.00		0
resmgr:session queuing	4	0.00		0
rm cas latch	4	0.00		0
row cache objects	481,761	0.00	0.00	14	0.00
second Audit Vault latch	4	0.00		0
segmented array pool	2	0.00		0
sequence cache	948	0.00		0
session allocation	10,446	0.00		10,054	0.00
session idle bit	324,476	0.00		0
session queue latch	4	0.00		0
session state list latch	648	0.46	0.67	0
session switching	373	0.00		0
session timer	4,801	0.00		0
seventh spare latch - X parent	4	0.00		0
shared pool	92,003	0.01	0.08	2	0.00
shared pool sim alloc	4	0.00		0
shared pool simulator	149	0.00		0
sim partition latch	4	0.00		0
simulator hash latch	48,418	0.00		0
simulator lru latch	4	0.00		48,254	0.00
sixth spare latch - X parent	4	0.00		0
sort extent pool	482	0.00		0
space background state object latch	12	0.00		0
space background task latch	16,143	0.12	0.45	9,615	0.00
state object free list	8	0.00		0
statistics aggregation	2,240	0.00		0
tablespace key chain	4	0.00		0
temp lob duration state obj allocation	8	0.00		0
tenth spare latch - X parent	4	0.00		0
test excl. parent l0	4	0.00		0
test excl. parent2 l0	4	0.00		0
thirteenth spare latch - children	4	0.00		0
threshold alerts latch	1,229	0.00		0
transaction allocation	5,710	0.00		0
twelfth spare latch - children	4	0.00		0
twenty-fifth spare latch - S par	4	0.00		0
twenty-first spare latch - S par	4	0.00		0
twenty-fourth spare latch - S par	4	0.00		0
twenty-second spare latch - S par	4	0.00		0
twenty-third spare latch - S par	4	0.00		0
undo global data	24,081	0.00		0
virtual circuit buffers	4	0.00		0
virtual circuit holder	4	0.00		0
virtual circuit queues	4	0.00		0
write info latch	0			4,495	0.38

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
ges resource hash list	436,103	3,176	3,075	103
ges process parent latch	431,492	2,427	2,426	2
active checkpoint queue latch	16,627	34	1	33
space background task latch	16,143	20	9	11
gc element	34,001	15	4	11
shared pool	92,003	13	1	12
ges caches resource lists	83,870	12	1	11
object queue header operation	2,933,975	12	1	11
JS Sh mem access	32	5	5	0
active service list	174,508	3	1	2
call allocation	978	3	1	2
session state list latch	648	3	2	1
KJC message pool free list	6,949	2	1	1
ges process hash list	6,273	2	2	0
cache buffers lru chain	15,678	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
JS Sh mem access	jsksGetShMemLatch	5	5
KJC message pool free list	kjcsmpav: allocate a msg buffer	1	1
active checkpoint queue latch	kcbbacq: scan active checkpoints	1	1
active service list	kswsite: service iterator	1	0
active service list	kswslogon: session logout	1	0
cache buffers lru chain	kcbbxsv: move to being written	1	0
call allocation	ksuxds	1	0
gc element	kclfwrite1	2	2
gc element	kclrwrite	2	2
ges caches resource lists	kjchc: clean resource cache	1	0
ges process hash list	kjakiqa: set inquiry response	2	0
ges process parent latch	kjata_fg	2,426	0
ges resource hash list	kjrmas1: lookup master node	2,431	0
ges resource hash list	kjlrlr: remove lock from resource queue	342	237
ges resource hash list	kjakcai: search for resp by resname	223	301
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	77	41
ges resource hash list	kjucvl: lock convert request	2	2,430
object queue header operation	kcbo_switch_cq	1	0
session state list latch	kpscad	1	0
session state list latch	kpseqd	1	1
shared pool	kghalo	1	0
space background task latch	ktsj_grab_task	5	9
space background task latch	ktsjCreateTask	4	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

No data exists for this section of the report.

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: 1,232,131
Captured Segments account for 94.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	I_OBJ#	INDEX	330,352	26.81
SYS	SYSTEM	I_OBJ2	INDEX	225,904	18.33
SYS	SYSTEM	I_OBJ5	INDEX	148,000	12.01
SYS	SYSTEM	LOB$	TABLE	77,392	6.28
SYS	SYSTEM	USER$	TABLE	77,328	6.28

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.95	In-memory Sort %:	100.00
Library Hit %:	95.61	Soft Parse %:	99.96
Execute to Parse %:	27.70	Latch Hit %:	99.98
Parse CPU to Parse Elapsd %:	78.61	% Non-Parse CPU:	92.44

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_2459726119_0	TABLE PARTITION	120	18.46
SYS	SYSAUX	WRM$_SNAPSHOT_DETAILS_INDEX		INDEX	14	2.15
SYS	SYSTEM	I_OBJ1		INDEX	2	0.31
SYS	SYSTEM	IDL_UB1$		TABLE	1	0.15
SYS	SYSTEM	I_OBJAUTH1		INDEX	1	0.15

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	WRH$_SQLSTA_2459726119_0	INDEX PARTITION	206	3.00
SYS	SYSTEM	DEFERRED_STG$		TABLE	134	1.95
SYS	SYSTEM	I_DEFERRED_STG1		INDEX	134	1.95
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_2459726119_0	TABLE PARTITION	124	1.80
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	WRH$_EVENT__2459726119_0	INDEX PARTITION	60	0.87

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSAUX	SMON_SCN_TIME		TABLE	88	14.24
SYS	SYSAUX	SMON_SCN_TIME_SCN_IDX		INDEX	63	10.19
SYS	SYSAUX	WRH$_SYSTEM_EVENT_PK	WRH$_SYSTEM_2459726119_0	INDEX PARTITION	32	5.18
SYS	SYSAUX	WRH$_PARAMETER	WRH$_PARAME_2459726119_0	TABLE PARTITION	22	3.56
SYS	SYSAUX	WRH$_PARAMETER_PK	WRH$_PARAME_2459726119_0	INDEX PARTITION	17	2.75

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSTEM	OBJ$		TABLE	922	36.69
SYS	SYSTEM	I_OBJ1		INDEX	362	14.41
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	WRH$_SQLSTA_2459726119_0	INDEX PARTITION	110	4.38
SYS	SYSAUX	WRM$_SNAPSHOT_DETAILS_INDEX		INDEX	89	3.54
SYS	SYSAUX	SMON_SCN_TIME		TABLE	80	3.18

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	260	0.38	8	1
dc_global_oids	28	0.00	0	26
dc_histogram_data	2,478	0.48	0	1,183
dc_histogram_defs	2,994	1.57	0	1,327
dc_objects	7,622	1.22	20	8,999
dc_profiles	38	0.00	0	1
dc_rollback_segments	5,197	0.00	0	67
dc_segments	915	0.77	6	2,188
dc_sequences	27	7.41	27	4
dc_tablespace_quotas	4,800	0.00	0	9
dc_tablespaces	32,774	0.00	0	21
dc_users	124,157	0.00	0	1,044
global database name	13,405	0.00	0	1
outstanding_alerts	440	98.18	0	0
sch_lj_oids	19	0.00	0	10

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	266	0.38	3,480	0.03	0	0
CLUSTER	8	0.00	8	0.00	0	0
DBLINK	12	0.00	0		0	0
EDITION	76	0.00	106	0.00	0	0
INDEX	22	0.00	22	4.55	1	0
QUEUE	0		240	0.00	0	0
SCHEMA	4,850	0.00	0		0	0
SQL AREA	4,045	0.89	137,371	0.08	3	4
SQL AREA BUILD	38	84.21	0		0	0
SQL AREA STATS	36	97.22	36	97.22	0	0
TABLE/PROCEDURE	7,828	0.15	26,971	26.86	2,421	0

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases
BODY	0	3,472	3,472
CLUSTER	8	8	8
DBLINK	12	0	0
EDITION	76	84	84
INDEX	22	22	22
QUEUE	0	240	240
SCHEMA	30	0	0
TABLE/PROCEDURE	12,634	21,548	21,548

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

	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	354.01		4.99	5.44	26	26	71	70
B	SQL	294.35	89.63	6.26	20.81	108	109	47	41
B	Freeable	67.06	0.00	2.16	2.87	12		31	31
B	PL/SQL	11.25	1.91	0.15	0.25	1	1	73	72
E	Other	356.43		5.02	5.42	26	26	71	71
E	SQL	328.10	99.51	6.84	22.82	119	120	48	42
E	Freeable	68.06	0.00	2.13	2.83	12		32	32
E	PL/SQL	11.26	1.91	0.15	0.25	1	1	74	73

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

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.00
shared	FileOpenBlock	121.57	121.57	0.00
shared	KGLH0	203.16	203.98	0.41
shared	SQLA	702.70	703.31	0.09
shared	db_block_hash_buckets	178.00	178.00	0.00
shared	free memory	1,613.96	1,612.08	-0.12
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,568.00	0.00
	fixed_sga	2.16	2.16	0.00
	log_buffer	111.54	111.54	0.00

Name	Total Disp Time (s)	%Busy	%Idle
D000	14,421	0.00	100.00
D000	14,421	0.00	100.00
D000	14,421	0.00	100.00
D000	14,421	0.00	100.00
Sum
Avg		0.00	100.00
Std		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

Buffer access - local cache %:	99.69
Buffer access - remote cache %:	0.25
Buffer access - disk %:	0.05

Avg global enqueue get time (ms):	0.3
Avg global cache cr block receive time (ms):	0.8
Avg global cache current block receive time (ms):	1.5
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 %:	0.5
Avg global cache cr block flush time (ms):	1.7
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 %:	3.5
Avg global cache current block flush time (ms):	12.2

Avg message sent queue time (ms):	5.6
Avg message sent queue time on ksxp (ms):	0.7
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.1
Avg GES message process time (ms):	0.0
% of direct sent messages:	70.26
% of indirect sent messages:	15.94
% of flow controlled messages:	13.80

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	650	0.05	0.09
acks for commit broadcast(logical)	675	0.05	0.09
broadcast msgs on commit(actual)	3,103	0.22	0.42
broadcast msgs on commit(logical)	3,644	0.25	0.49
broadcast msgs on commit(wasted)	15	0.00	0.00
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	1,053	0.07	0.14
gcs ast xid	1	0.00	0.00
gcs blocked converts	1,459	0.10	0.20
gcs blocked cr converts	4,297	0.30	0.58
gcs compatible basts	28	0.00	0.00
gcs compatible cr basts (global)	70	0.00	0.01
gcs compatible cr basts (local)	1,251	0.09	0.17
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	502	0.03	0.07
gcs dbwr write request msgs	392	0.03	0.05
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	12	0.00	0.00
gcs force cr grant	44	0.00	0.01
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	425	0.03	0.06
gcs immediate (null) converts	534	0.04	0.07
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	333	0.02	0.05
gcs indirect ast	718	0.05	0.10
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	718	0.05	0.10
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	105	0.01	0.01
gcs msgs process time(ms)	902	0.06	0.12
gcs msgs received	14,081	0.98	1.91
gcs new served by master	32	0.00	0.00
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	0	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	1	0.00	0.00
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	0	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	24	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	227	0.02	0.03
gcs side channel msgs logical	3,363	0.23	0.46
gcs stale cr	345	0.02	0.05
gcs undo cr	82	0.01	0.01
gcs write notification msgs	30	0.00	0.00
gcs writes refused	7	0.00	0.00
ges msgs process time(ms)	1,355	0.09	0.18
ges msgs received	34,101	2.36	4.63
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	453	0.03	0.06
implicit batch messages sent	1,836	0.13	0.25
lmd msg send time(ms)	14	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	3,847	0.27	0.52
messages queue sent actual	22,815	1.58	3.09
messages queue sent logical	4,332	0.30	0.59
messages received actual	46,404	3.22	6.29
messages received logical	48,182	3.34	6.53
messages sent directly	19,579	1.36	2.66
messages sent indirectly	4,442	0.31	0.60
messages sent not implicit batched	0	0.00	0.00
messages sent pbatched	21,421	1.49	2.91
msgs causing lmd to send msgs	17,574	1.22	2.38
msgs causing lms(s) to send msgs	550	0.04	0.07
msgs received queue time (ms)	1,313	0.09	0.18
msgs received queued	48,182	3.34	6.53
msgs sent queue time (ms)	140,667	9.75	19.08
msgs sent queue time on ksxp (ms)	29,667	2.06	4.02
msgs sent queued	25,300	1.75	3.43
msgs sent queued on ksxp	43,379	3.01	5.88
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	13,058	0.91	1.77
process batch messages sent	19,446	1.35	2.64

Statistic	Total
CR Block Requests	1,579
CURRENT Block Requests	3,251
Data Block Requests	1,579
Undo Block Requests	2
TX Block Requests	3,165
Current Results	4,824
Private results	0
Zero Results	6
Disk Read Results	0
Fail Results	0
Fairness Down Converts	1,483
Fairness Clears	28
Free GC Elements	0
Flushes	24
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	3
Errors	0

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

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	2	100.00	0.00	0.00	0.00	0.00
Flushes	64	40.63	57.81	0.00	1.56	0.00
Writes	579	11.57	26.60	61.49	0.17	0.17

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	458	94.54	3.49	1.97	2,319	66.62	2.29	31.09
2	Others	101	98.02	0.99	0.99	194	98.97	0.00	1.03
2	undo header	54	92.59	7.41	0.00	2	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	0.96	0.91	1.85	1.47	1.60	1.16	1.91	2.53
2	others	0.83	0.83	1.21	0.76	0.80	0.80		0.72
2	undo header	0.77	0.74	1.15		0.57	0.57
2	undo block

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	0.00	0.00
Parallel Query	0.00	0.00
DB Locks	0.00	0.00
DB Streams	0.00	0.00
Other	0.00	0.00