AWR Report for DB: CONNDEMO, Inst: conndemo2, Snaps: 27006-27007

DB Name	DB Id	Unique Name	Role	Edition	Release	RAC	CDB
CONNDEMO	5801112	conndemo	PRIMARY	EE	12.2.0.1.0	YES	NO

Instance	Inst Num	Startup Time
conndemo2	2	03-Aug-17 03:08

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
scao08adm04.us.oracle.com	Linux x86 64-bit	48	24	2	503.42

	Snap Id	Snap Time	Sessions	Cursors/Session	Instances
Begin Snap:	27006	25-Aug-17 12:29:59	201	8.2	2
End Snap:	27007	25-Aug-17 12:40:10	205	8.1	2
Elapsed:		10.18 (mins)
DB Time:		921.97 (mins)

Report Summary

Finding Name	Avg active sessions of the task	Percent active sessions of finding	Task Name	Begin Snap Time	End Snap Time
Hard Parse Due to Literal Usage	90.54	87.04	ADDM:5801112_2_27007	25-Aug-17 12:29	25-Aug-17 12:40
Shared Pool Latches	90.54	52.51	ADDM:5801112_2_27007	25-Aug-17 12:29	25-Aug-17 12:40
Unusual "Concurrency" Wait Event	90.54	23.88	ADDM:5801112_2_27007	25-Aug-17 12:29	25-Aug-17 12:40
Soft Parse	90.54	9.11	ADDM:5801112_2_27007	25-Aug-17 12:29	25-Aug-17 12:40

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	90.5	0.0	0.01	0.00
DB CPU(s):	16.8	0.0	0.00	0.00
Background CPU(s):	0.7	0.0	0.00	0.00
Redo size (bytes):	3,464,858.1	1,616.5
Logical read (blocks):	43,914.7	20.5
Block changes:	22,226.8	10.4
Physical read (blocks):	17.8	0.0
Physical write (blocks):	683.3	0.3
Read IO requests:	17.8	0.0
Write IO requests:	111.9	0.1
Read IO (MB):	0.1	0.0
Write IO (MB):	5.3	0.0
IM scan rows:	0.0	0.0
Session Logical Read IM:	0.0	0.0
Global Cache blocks received:	19.2	0.0
Global Cache blocks served:	0.6	0.0
User calls:	18,415.9	8.6
Parses (SQL):	6,998.8	3.3
Hard parses (SQL):	6,978.5	3.3
SQL Work Area (MB):	3.7	0.0
Logons:	3.1	0.0
Executes (SQL):	8,198.3	3.8
Rollbacks:	0.0	0.0
Transactions:	2,143.5

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	99.96	In-memory Sort %:	100.00
Library Hit %:	56.68	Soft Parse %:	0.29
Execute to Parse %:	14.63	Latch Hit %:	92.31
Parse CPU to Parse Elapsd %:	15.67	% Non-Parse CPU:	19.07
Flash Cache Hit %:	5.71

Event	Waits	Total Wait Time (sec)	Avg Wait	% DB time	Wait Class
library cache: mutex X	3,412,405	24.7K	7.25ms	44.7	Concurrency
row cache mutex	1,684,141	13.2K	7.84ms	23.9	Concurrency
DB CPU		10.3K		18.6
latch: shared pool	12,448,227	4271	343.10us	7.7	Concurrency
log file sync	1,307,279	594.8	454.99us	1.1	Commit
row cache read	204,903	490.3	2.39ms	.9	Concurrency
latch: ges resource hash list	345,373	133.9	387.68us	.2	Other
buffer exterminate	5,390	53.3	9.88ms	.1	Other
library cache: bucket mutex X	4,297	28.3	6.58ms	.1	Concurrency
row cache lock	223	12.2	54.92ms	.0	Concurrency

Wait Class	Waits	Total Wait Time (sec)	Avg Wait Time	% DB time	Avg Active Sessions
Concurrency	17,762,982	42,763	2.41ms	77.3	70.0
DB CPU		10,282		18.6	16.8
Commit	1,307,286	595	454.99us	1.1	1.0
Other	913,126	274	300.48us	.5	0.4
System I/O	1,287,784	274	212.96us	.5	0.4
Network	6,972,472	8	1.10us	.0	0.0
Cluster	8,989	7	726.71us	.0	0.0
User I/O	12,046	6	461.45us	.0	0.0
Scheduler	14	0	8.95ms	.0	0.0
Configuration	37	0	310.38us	.0	0.0
Application	123	0	48.05us	.0	0.0

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
48	24	2	19.85	16.71	33.5	3.1	0.0	62.8

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

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	2,012.6	22.5	1,990.1
Database Requests:	129.6	17.8	111.9
Optimized Requests:	176.7	22.4	154.3
Redo Requests:	1,876.0	0.0	1,876.0
Total (MB):	9.6	0.2	9.4
Database (MB):	5.5	0.1	5.3
Optimized Total (MB):	5.7	0.2	5.5
Redo (MB):	4.0	0.0	4.0
Database (blocks):	701.0	17.8	683.3
Via Buffer Cache (blocks):	700.5	17.8	682.8
Direct (blocks):	0.5	0.0	0.5

	Begin	End
Host Mem (MB):	515,503.9	515,503.9
SGA use (MB):	10,016.0	10,016.0
PGA use (MB):	1,333.8	1,347.4
% Host Mem used for SGA+PGA:	2.20	2.20

	Begin	End
Buffer Cache:	M	M	Std Block Size:	8K
Shared Pool Size:	0M	0M	Log Buffer:	K
In-Memory Area:	0M	0M

	Begin	End
Memory Usage %:
% SQL with executions>1:	52.95	53.84
% Memory for SQL w/exec>1:	7.32	7.59

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 (up to 64 us)

Wait Event Histogram (up to 32 ms)

Wait Event Histogram (up to 2 sec)

Wait Event Histogram (up to 2 min)

Wait Event Histogram (up to 1 hr)

Service Statistics

Service Wait Class Stats

Top 10 Channel Waits

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 Offload Eligible Bytes

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

Statistic Name	Time (s)	% of DB Time	% of Total CPU Time
parse time elapsed	53,192.31	96.16
hard parse elapsed time	48,153.05	87.05
DB CPU	10,282.32	18.59	95.94
sql execute elapsed time	717.71	1.30
hard parse (sharing criteria) elapsed time	4.62	0.01
hard parse (bind mismatch) elapsed time	3.84	0.01
repeated bind elapsed time	1.27	0.00
PL/SQL execution elapsed time	0.40	0.00
PL/SQL compilation elapsed time	0.26	0.00
sequence load elapsed time	0.04	0.00
DB time	55,318.03
background elapsed time	632.97
background cpu time	435.66		4.06
total CPU time	10,717.98

Statistic	Value	End Value
FREE_MEMORY_BYTES	195,875,868,672	195,795,701,760
INACTIVE_MEMORY_BYTES	26,775,683,072	26,781,622,272
SWAP_FREE_BYTES	25,769,799,680
BUSY_TIME	1,041,606
IDLE_TIME	1,761,919
IOWAIT_TIME	228
NICE_TIME	3,522
SYS_TIME	85,746
USER_TIME	938,248
LOAD	20	17
PHYSICAL_MEMORY_BYTES	540,545,028,096
NUM_CPUS	48
NUM_CPU_CORES	24
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	2,097,152
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	6,291,456
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

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
25-Aug 12:29:59	19.85
25-Aug 12:40:10	16.71	37.15	33.47	3.06	62.85	0.01

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait	%DB time
Concurrency	17,756,838	0	42,761	2.41ms	77.30
DB CPU			10,282		18.59
Commit	1,307,282	0	595	454.99us	1.08
Other	485,848	12	206	423.60us	0.37
Network	6,972,472	0	8	1.10us	0.01
Cluster	3,691	0	6	1.65ms	0.01
User I/O	3,229	0	2	531.99us	0.00
Scheduler	14	93	0	8.95ms	0.00
System I/O	226	0	0	194.42us	0.00
Application	121	0	0	45.21us	0.00
Configuration	4	50	0	133.50us	0.00

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait	Waits /txn	% DB time
library cache: mutex X	3,412,405		24,744	7.25ms	2.61	44.73
row cache mutex	1,684,141		13,210	7.84ms	1.29	23.88
latch: shared pool	12,448,227		4,271	343.10us	9.50	7.72
log file sync	1,307,279		595	454.99us	1.00	1.08
row cache read	204,903		490	2.39ms	0.16	0.89
latch: ges resource hash list	345,373		134	387.68us	0.26	0.24
buffer exterminate	5,390	99	53	9.88ms	0.00	0.10
library cache: bucket mutex X	4,297		28	6.58ms	0.00	0.05
row cache lock	223		12	54.92ms	0.00	0.02
SQL*Net message to client	6,971,799		8	1.10us	5.32	0.01
wait list latch free	5,576		6	1.10ms	0.00	0.01
latch free	25,172		6	242.91us	0.02	0.01
gc buffer busy release	9		6	623.04ms	0.00	0.01
library cache: dependency mutex X	642		3	4.87ms	0.00	0.01
PX Deq: Join ACK	9,150		3	277.05us	0.01	0.00
cell single block physical read	2,934		2	524.09us	0.00	0.00
library cache load lock	85		1	13.21ms	0.00	0.00
Sync ASM rebalance	31		1	26.31ms	0.00	0.00
enq: PS - contention	3,687	1	1	177.49us	0.00	0.00
reliable message	1,831		1	356.05us	0.00	0.00
PX Deq: Slave Session Stats	5,526		0	86.11us	0.00	0.00
PGA memory operation	23,048		0	18.85us	0.02	0.00
PX Deq: reap credit	50,806	100	0	6.11us	0.04	0.00
cursor: pin S wait on X	35		0	7.26ms	0.00	0.00
gc current block 2-way	2,063		0	113.03us	0.00	0.00
acknowledge over PGA limit	14	93	0	8.95ms	0.00	0.00
cell statistics gather	224		0	555.19us	0.00	0.00
enq: FB - contention	362		0	264.24us	0.00	0.00
buffer busy waits	1,745		0	53.77us	0.00	0.00
PX Deq: Signal ACK EXT	3,662		0	25.12us	0.00	0.00
latch: redo allocation	248		0	323.13us	0.00	0.00
latch: enqueue hash chains	163		0	391.78us	0.00	0.00
gc current grant 2-way	471		0	135.07us	0.00	0.00
name-service call wait	2		0	27.37ms	0.00	0.00
Disk file Mirror Read	57		0	814.18us	0.00	0.00
gc cr grant 2-way	275		0	161.86us	0.00	0.00
control file sequential read	226		0	194.42us	0.00	0.00
gc cr multi block mixed	213		0	187.21us	0.00	0.00
gc current multi block request	151		0	257.09us	0.00	0.00
ADR block file read	36		0	1.08ms	0.00	0.00
IPC send completion sync	5,590		0	6.58us	0.00	0.00
cursor: pin S	31		0	1.10ms	0.00	0.00
gc current block busy	215		0	124.90us	0.00	0.00
latch: cache buffers chains	104		0	250.79us	0.00	0.00
latch: messages	47		0	448.28us	0.00	0.00
ASM file metadata operation	5		0	4.17ms	0.00	0.00
enq: IV - contention	56	7	0	285.93us	0.00	0.00
gc cr block 2-way	130		0	117.03us	0.00	0.00
SQL*Net more data to client	551		0	23.26us	0.00	0.00
latch: undo global data	19		0	589.32us	0.00	0.00
gc current grant busy	88		0	105.95us	0.00	0.00
remote log force - commit	3		0	2.90ms	0.00	0.00
read by other session	6		0	1.38ms	0.00	0.00
gc cr disk read	70		0	115.00us	0.00	0.00
SQL*Net break/reset to client	120		0	43.58us	0.00	0.00
enq: TX - contention	3		0	1.64ms	0.00	0.00
TCP Socket (KGAS)	122		0	27.04us	0.00	0.00
enq: WF - contention	17		0	190.82us	0.00	0.00
gc cr block busy	6		0	410.83us	0.00	0.00
latch: session allocation	5		0	317.00us	0.00	0.00
SQL*Net message from client	6,974,867		5,869	841.39us	5.33
watchdog main loop	406		1,218	2999.99ms	0.00
PL/SQL lock timer	123	100	949	7717.51ms	0.00
PX Deq: Execute Reply	3,806		222	58.30ms	0.00
PX Deq: Execution Msg	5,592		173	30.94ms	0.00
PX Deq: Parse Reply	3,662		2	550.60us	0.00

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait	Waits /txn	% bg time
log file parallel write	1,146,419	0	248	215.90us	0.88	39.10
LGWR any worker group	226,510	0	27	120.83us	0.17	4.32
db file parallel write	69,826	0	26	368.41us	0.05	4.06
LGWR all worker groups	61,121	0	19	317.72us	0.05	3.07
RMA: IPC0 completion sync	637	0	12	19.50ms	0.00	1.96
LGWR worker group ordering	96,278	0	4	44.05us	0.07	0.67
cell single block physical read	7,915	0	4	445.35us	0.01	0.56
oracle thread bootstrap	49	0	2	36.43ms	0.00	0.28
latch: shared pool	4,838	0	2	327.14us	0.00	0.25
LGWR wait for redo copy	3,402	0	1	244.43us	0.00	0.13
control file sequential read	2,622	0	1	234.65us	0.00	0.10
Sync ASM rebalance	143	0	1	4.21ms	0.00	0.10
IMR slave acknowledgement msg	1,836	0	0	174.61us	0.00	0.05
Disk file Mirror Read	816	0	0	358.75us	0.00	0.05
latch: redo allocation	722	0	0	374.47us	0.00	0.04
gc cr block 2-way	2,548	0	0	89.67us	0.00	0.04
ASM file metadata operation	612	0	0	344.53us	0.00	0.03
control file parallel write	327	0	0	583.07us	0.00	0.03
gc current block 2-way	2,523	0	0	72.28us	0.00	0.03
latch free	644	0	0	245.44us	0.00	0.02
PGA memory operation	6,179	0	0	20.80us	0.00	0.02
AQ: RAC AQ Network	6,101	100	0	15.77us	0.00	0.02
os thread creation	49	0	0	1.87ms	0.00	0.01
DFS lock handle	771	100	0	114.02us	0.00	0.01
SGA: allocation forcing component growth	1	0	0	82.69ms	0.00	0.01
PX Deq: Slave Join Frag	3,728	0	0	20.14us	0.00	0.01
enq: IV - contention	339	4	0	218.62us	0.00	0.01
name-service call wait	1	0	0	63.12ms	0.00	0.01
PX Deq: reap credit	8,031	100	0	7.34us	0.01	0.01
db file async I/O submit	67,449	0	0	861.33ns	0.05	0.01
CGS wait for IPC msg	6,094	100	0	8.68us	0.00	0.01
cursor: pin S wait on X	5	0	0	6.40ms	0.00	0.01
CSS operation: data query	40	0	0	540.98us	0.00	0.00
latch: messages	63	0	0	307.06us	0.00	0.00
Parameter File I/O	32	0	0	540.66us	0.00	0.00
libcache interrupt action by LCK	1,247	0	0	12.62us	0.00	0.00
KSV master wait	531	77	0	28.47us	0.00	0.00
ksxr poll remote instances	2,511	100	0	5.95us	0.00	0.00
reliable message	36	0	0	400.53us	0.00	0.00
gc cr multi block mixed	71	0	0	202.96us	0.00	0.00
latch: redo writing	33	0	0	331.82us	0.00	0.00
CSS initialization	4	0	0	2.31ms	0.00	0.00
gc current block busy	60	0	0	139.63us	0.00	0.00
enq: CF - contention	37	73	0	217.84us	0.00	0.00
row cache lock	23	57	0	338.04us	0.00	0.00
IPC send completion sync	617	99	0	10.68us	0.00	0.00
CSS operation: data update	10	0	0	646.20us	0.00	0.00
gc cr disk read	58	0	0	86.86us	0.00	0.00
Disk file operations I/O	52	0	0	86.15us	0.00	0.00
ges inquiry response	20	0	0	212.30us	0.00	0.00
CSS operation: action	8	0	0	476.75us	0.00	0.00
PX Deq: Join ACK	8	0	0	366.75us	0.00	0.00
gc current grant busy	21	0	0	115.14us	0.00	0.00
wait list latch free	2	0	0	1.06ms	0.00	0.00
log file sync	4	0	0	495.50us	0.00	0.00
CSS operation: query	12	0	0	131.25us	0.00	0.00
library cache lock	9	0	0	170.33us	0.00	0.00
direct path write	2	0	0	697.50us	0.00	0.00
library cache pin	8	0	0	140.50us	0.00	0.00
rdbms ipc message	2,812,197	0	15,865	5.64ms	2.15
Space Manager: slave idle wait	1,392	0	6,113	4391.61ms	0.00
class slave wait	13,320	91	4,274	320.84ms	0.01
EMON slave idle wait	610	100	3,050	4999.97ms	0.00
wait for unread message on broadcast channel	5,487	100	2,288	416.95ms	0.00
LMS CR slave timer	181,750	0	1,829	10.06ms	0.14
gcs remote message	3,760,021	0	1,772	471.33us	2.87
GCR sleep	4,067	0	1,221	300.11ms	0.00
ges remote message	126,645	0	1,220	9.63ms	0.10
pmon timer	406	100	1,218	2999.82ms	0.00
DIAG idle wait	8,120	77	1,206	148.55ms	0.01
PX Idle Wait	1,865	0	979	525.04ms	0.00
LGWR worker group idle	886,611	0	836	943.22us	0.68
smon timer	5	40	785	156.92 s	0.00
Streams AQ: load balancer idle	14	100	630	45.01 s	0.00
PING	50	98	613	12.25 s	0.00
ASM cluster membership changes	350	90	613	1750.25ms	0.00
lreg timer	204	100	613	3002.52ms	0.00
heartbeat redo informer	611	0	611	1000.07ms	0.00
REPL Capture/Apply: RAC AQ qmn coordinator	10	100	611	61.09 s	0.00
SCM slave idle	6,110	0	611	99.99ms	0.00
Streams AQ: emn coordinator idle wait	61	100	610	10.00 s	0.00
OFS idle	203	100	609	3000.00ms	0.00
pman timer	203	100	609	2999.75ms	0.00
ASM background timer	393	0	609	1549.14ms	0.00
dispatcher timer	10	100	600	60.01 s	0.00
AQPC idle	20	100	600	30.00 s	0.00
Data Guard: Gap Manager	10	0	600	60.00 s	0.00
Data Guard: Timer	1	0	600	600.00 s	0.00
Streams AQ: qmn slave idle wait	21	0	588	28.00 s	0.00
Streams AQ: qmn coordinator idle wait	42	0	588	14.00 s	0.00
PX Deq: Execute Reply	3	0	0	567.00us	0.00
PX Deq: Parse Reply	3	0	0	486.33us	0.00

		% of Total Waits
Event	Total Waits	<8us	<16us	<32us	<64us	<128us	<256us	<512us	>=512us
ADR block file read	36					38.9	41.7		19.4
ADR block file write	10				10.0	80.0	10.0
ADR file lock	12	50.0		16.7	33.3
AQ: RAC AQ Network	6099	4.5	54.6	39.9	.9	.0
ASM file metadata operation	618	17.3	3.6	4.0	.3	9.7	20.4	41.4	3.2
AWR Flush	8	100.0
CGS wait for IPC msg	6093	17.4	79.5	2.9	.2	.0
CSS initialization	4				50.0				50.0
CSS operation: action	8				25.0			25.0	50.0
CSS operation: data query	40							72.5	27.5
CSS operation: data update	10							20.0	80.0
CSS operation: query	12	83.3							16.7
DFS lock handle	771					77.3	22.2	.5
Disk file Mirror Read	873						8.7	89.6	1.7
Disk file operations I/O	58	46.6	1.7		3.4	12.1	31.0	5.2
GCR CSS group query	40	100.0
GCR CSS group update	10	100.0
IMR slave acknowledgement msg	1833	3.0	.4	24.9	30.9	7.1	.3	27.6	5.7
IPC send completion sync	6206	71.0	25.9	3.0	.1
KSV master wait	531	68.4	7.7	11.5	8.7	1.5	.4	.4	1.5
LGWR all worker groups	61.1K			.0	.6	2.3	16.6	79.2	1.3
LGWR any worker group	226.5K	.7	4.8	9.8	16.6	27.0	33.7	7.1	.2
LGWR wait for redo copy	3400	12.2	17.7	14.1	9.4	7.4	8.7	11.0	19.4
LGWR worker group ordering	96.3K	4.6	14.7	34.8	32.8	9.8	1.8	1.0	.6
PGA memory operation	29.2K	57.7	22.1	7.1	4.4	5.3	3.0	.4	.0
PX Deq: Join ACK	9158	3.0	.3	.9	29.2	25.5	12.6	11.8	16.7
PX Deq: Signal ACK EXT	3665	14.1	44.7	22.1	8.0	9.8	1.1	.1	.1
PX Deq: Slave Join Frag	3728	49.0	.1	14.7	34.2	1.7	.3	.1
PX Deq: Slave Session Stats	5529	21.1	3.6	4.3	29.3	16.6	19.4	5.5	.3
PX Deq: reap credit	58.8K	67.1	30.0	2.8	.1	.0		.0
PX qref latch	10	90.0	10.0
Parameter File I/O	32						56.3	40.6	3.1
RMA: IPC0 completion sync	634		.5	2.1	.5				97.0
SGA: allocation forcing component growth	1								100.0
SQL*Net break/reset to client	120	48.3	1.7		.8	47.5	1.7
SQL*Net message to client	7M	99.8	.2	.0	.0	.0	.0	.0	.0
SQL*Net more data to client	551		.4	93.5	6.2
Sync ASM rebalance	174	31.6	10.9	3.4	1.1	8.0	2.3	5.2	37.4
TCP Socket (KGAS)	122			86.9	13.1
acknowledge over PGA limit	14		7.1						92.9
buffer busy waits	1746	6.1	16.7	58.6	11.2	2.1	1.1	1.1	3.1
buffer exterminate	5394	.1							99.9
cell multiblock physical read	1						100.0
cell single block physical read	10.8K						5.5	86.0	8.5
cell statistics gather	224					31.3	50.0	3.1	15.6
control file parallel write	327							56.9	43.1
control file sequential read	2848	5.0	22.7	2.8	.0	.0	20.2	48.3	.9
cursor: pin S	31								100.0
cursor: pin S wait on X	40								100.0
db file async I/O submit	62.3K	99.7	.2	.0	.0	.0
db file parallel write	64.7K	1.1	1.2	.8	.5	.3	37.3	37.1	21.8
direct path write	3							33.3	66.7
enq: AF - task serialization	1						100.0
enq: CF - contention	37					21.6	51.4	27.0
enq: DW - contention	2						50.0	50.0
enq: FB - contention	363				.3	.8	65.0	29.8	4.1
enq: HW - contention	3			33.3		33.3	33.3
enq: IV - contention	392					26.8	38.0	30.6	4.6
enq: PS - contention	3691			.3	9.9	29.9	50.0	7.1	2.8
enq: TA - contention	3						100.0
enq: TD - KTF dump entries	2						100.0
enq: TM - contention	3						100.0
enq: TX - contention	3								100.0
enq: US - contention	3						33.3	66.7
enq: WF - contention	17					23.5	52.9	23.5
gc buffer busy release	9								100.0
gc cr block 2-way	2672		.0		24.4	60.2	14.6	.7	.0
gc cr block busy	6							83.3	16.7
gc cr disk read	128				31.3	43.8	22.7	2.3
gc cr grant 2-way	280				1.1	28.9	65.4	3.9	.7
gc cr multi block mixed	284					32.4	44.0	22.9	.7
gc current block 2-way	4285		.0	.0	30.4	53.7	15.0	.8
gc current block busy	280				3.2	61.4	31.1	3.9	.4
gc current grant 2-way	472				9.7	43.2	43.2	3.2	.6
gc current grant busy	102			1.0	10.8	58.8	28.4	1.0
gc current multi block request	152					.7	50.0	48.7	.7
gcs log flush sync	2				100.0
gcs resource directory to be unfrozen	1	100.0
ges inquiry response	20						80.0	20.0
ges resource directory to be unfrozen	46	100.0
ksxr poll remote instances	2514	83.2	15.2	1.6	.1
latch free	25.7K	4.4	3.4	7.7	17.8	19.4	17.3	15.1	15.0
latch: cache buffers chains	105	13.3	19.0	19.0	6.7	3.8	7.6	14.3	16.2
latch: enqueue hash chains	164		2.4	9.1	9.8	11.6	18.3	23.8	25.0
latch: gc element	1	100.0
latch: gcs resource hash	2							50.0	50.0
latch: ges resource hash list	345.3K	8.2	5.2	7.5	9.8	13.5	14.9	13.5	27.5
latch: messages	109		1.8	7.3	20.2	10.1	16.5	12.8	31.2
latch: redo allocation	966	1.1	3.9	8.3	13.4	13.7	13.3	17.8	28.6
latch: redo writing	30	3.3	3.3	20.0	23.3	6.7	10.0		33.3
latch: session allocation	5						40.0	60.0
latch: shared pool	12.5M	1.5	1.8	10.0	20.8	17.6	12.3	11.5	24.6
latch: undo global data	19			5.3		5.3	21.1	26.3	42.1
libcache interrupt action by LCK	1247	67.6	3.4	12.5	12.3	3.4	.6	.1
library cache load lock	86				1.2			1.2	97.7
library cache lock	9					44.4	33.3	22.2
library cache pin	8					62.5	37.5
library cache: bucket mutex X	4278	23.4	5.6	.2	.3	.9	.6	.9	68.1
library cache: dependency mutex X	641	36.5	7.6	.6	1.6	1.6	1.2	.3	50.5
library cache: mutex X	3.4M	32.4	3.0	.4	.3	.6	.5	.6	62.2
log file parallel write	1.1M	.0	.0	.0	.0	.4	79.5	19.9	.1
log file sync	1.3M	.0	.0	.0	.0	.0	.5	79.6	19.9
name-service call wait	3							33.3	66.7
oracle thread bootstrap	49								100.0
os thread creation	49								100.0
read by other session	6				16.7			33.3	50.0
reliable message	1867						27.6	61.8	10.6
remote log force - commit	3								100.0
row cache lock	249		.4	3.2	8.4	19.7	22.9	18.1	27.3
row cache mutex	1.7M	37.2	3.2	.4	.3	.6	.5	.6	57.2
row cache read	204.8K	66.1	2.9	1.2	.5	1.3	.8	.8	26.4
undo_retention publish retry	2	100.0
wait list latch free	5592								100.0
AQPC idle	20								100.0
ASM background timer	393					.5	.5	.8	98.2
ASM cluster membership changes	348								100.0
DIAG idle wait	8116	13.8	3.8	2.8	.5		.8	.5	77.8
Data Guard: Gap Manager	10								100.0
Data Guard: Timer	1								100.0
EMON slave idle wait	610								100.0
GCR sleep	4067								100.0
LGWR worker group idle	886.5K	.3	2.1	2.4	7.6	9.1	14.7	20.0	43.8
LMS CR slave timer	181.6K								100.0
OFS idle	204								100.0
PING	50			2.0					98.0
PL/SQL lock timer	123								100.0
PX Deq Credit: need buffer	1								100.0
PX Deq Credit: send blkd	12	50.0	33.3	16.7
PX Deq: Execute Reply	3809	14.3	2.5	1.7	4.3	2.9	3.8	27.8	42.7
PX Deq: Execution Msg	5592	5.7	.0	.1	3.5	10.5	45.0	18.3	16.8
PX Deq: Msg Fragment	1		100.0
PX Deq: Parse Reply	3665	12.1	1.5	1.6	7.4	10.9	9.6	43.1	13.8
PX Idle Wait	1864	1.4	.3			.3	.5	1.1	96.4
REPL Capture/Apply: RAC AQ qmn coordinator	10								100.0
SCM slave idle	6108								100.0
SQL*Net message from client	7M					2.5	60.6	18.0	18.9
Space Manager: slave idle wait	1387	.3		.4	2.2	.7	.1		96.4
Streams AQ: emn coordinator idle wait	61								100.0
Streams AQ: load balancer idle	14								100.0
Streams AQ: qmn coordinator idle wait	42					45.2	4.8		50.0
Streams AQ: qmn slave idle wait	21								100.0
class slave wait	13.3K	1.0	.2	.7	.8	.4	.1		96.9
dispatcher timer	10								100.0
gcs remote message	3.8M	36.1	.9	.5	2.0	5.1	10.3	17.5	27.4
ges remote message	126.6K	.2	.1	.0	.1	.8	.4	.5	97.9
heartbeat redo informer	611								100.0
lreg timer	203								100.0
pman timer	204								100.0
pmon timer	408								100.0
rdbms ipc message	2.8M	6.3	3.5	23.4	18.2	11.7	16.3	14.5	6.0
smon timer	5								100.0
wait for unread message on broadcast channel	5486								100.0
watchdog main loop	408								100.0

		% of Total Waits
Event	Waits 1us - 64us	<1us	<2us	<4us	<8us	<16us	<32us	<64us	>=64us
ADR block file write	1							10.0	90.0
ADR file lock	12		33.3	16.7			16.7	33.3
AQ: RAC AQ Network	6096				4.5	54.6	39.9	.9	.0
ASM file metadata operation	156	.2	6.1	9.7	1.3	3.6	4.0	.3	74.8
AWR Flush	8	87.5	12.5
CGS wait for IPC msg	6092		.3	7.2	9.8	79.5	2.9	.2	.0
CSS initialization	2							50.0	50.0
CSS operation: action	2							25.0	75.0
CSS operation: query	10	50.0		33.3					16.7
Disk file operations I/O	30		3.4	13.8	29.3	1.7		3.4	48.3
GCR CSS group query	40			5.0	95.0
GCR CSS group update	10			90.0	10.0
IMR slave acknowledgement msg	1085		.2	2.5	.4	.4	24.9	30.9	40.8
IPC send completion sync	6206			7.4	63.6	25.9	3.0	.1
KSV master wait	511			28.6	39.7	7.7	11.5	8.7	3.8
LGWR all worker groups	378						.0	.6	99.4
LGWR any worker group	72.3K	.0	.1	.1	.5	4.8	9.8	16.6	68.1
LGWR wait for redo copy	1818	3.5	6.5	2.1	.1	17.7	14.1	9.4	46.5
LGWR worker group ordering	83.7K	.9	1.6	.9	1.2	14.7	34.8	32.8	13.1
PGA memory operation	26.7K			22.0	35.6	22.1	7.1	4.4	8.7
PX Deq: Join ACK	3057	.1	.8	1.3	.8	.3	.9	29.2	66.6
PX Deq: Signal ACK EXT	3257			.0	14.1	44.7	22.1	8.0	11.1
PX Deq: Slave Join Frag	3652	29.7	19.2	.1		.1	14.7	34.2	2.0
PX Deq: Slave Session Stats	3221	.6	4.7	4.3	11.4	3.6	4.3	29.3	41.7
PX Deq: reap credit	58.8K		5.4	27.4	34.3	30.0	2.8	.1	.0
PX qref latch	10			30.0	60.0	10.0
RMA: IPC0 completion sync	19					.5	2.1	.5	97.0
SQL*Net break/reset to client	61			6.7	41.7	1.7		.8	49.2
SQL*Net message to client	7M	15.7	66.7	17.3	.1	.2	.0	.0	.0
SQL*Net more data to client	551					.4	93.5	6.2
Sync ASM rebalance	82			1.1	30.5	10.9	3.4	1.1	52.9
TCP Socket (KGAS)	122						86.9	13.1
acknowledge over PGA limit	1					7.1			92.9
buffer busy waits	1616			3.5	2.6	16.7	58.6	11.2	7.4
buffer exterminate	7			.1	.1				99.9
control file sequential read	872				5.0	22.7	2.8	.0	69.4
db file async I/O submit	62.3K	21.4	76.5	.9	1.0	.2	.0	.0	.0
db file parallel write	2321				1.1	1.2	.8	.5	96.4
enq: FB - contention	1							.3	99.7
enq: HW - contention	1						33.3		66.7
enq: PS - contention	376						.3	9.9	89.8
gc cr block 2-way	653					.0		24.4	75.6
gc cr disk read	40							31.3	68.8
gc cr grant 2-way	3							1.1	98.9
gc current block 2-way	1305					.0	.0	30.4	69.5
gc current block busy	9							3.2	96.8
gc current grant 2-way	46							9.7	90.3
gc current grant busy	12						1.0	10.8	88.2
gcs log flush sync	2							100.0
gcs resource directory to be unfrozen	1	100.0
ges resource directory to be unfrozen	46	26.1	73.9
ksxr poll remote instances	2514			12.5	70.7	15.2	1.6	.1
latch free	8554	.0	.8	2.6	.9	3.4	7.7	17.8	66.8
latch: cache buffers chains	61		1.0	8.6	3.8	19.0	19.0	6.7	41.9
latch: enqueue hash chains	35					2.4	9.1	9.8	78.7
latch: gc element	1				100.0
latch: ges resource hash list	106K	.0	.8	4.3	3.1	5.2	7.5	9.8	69.3
latch: messages	32					1.8	7.3	20.2	70.6
latch: redo allocation	258		.5	.6		3.9	8.3	13.4	73.3
latch: redo writing	15				3.3	3.3	20.0	23.3	50.0
latch: shared pool	4.2M	.0	.1	.6	.8	1.8	10.0	20.8	65.9
latch: undo global data	1						5.3		94.7
libcache interrupt action by LCK	1196	38.6	24.5	4.6		3.4	12.5	12.3	4.1
library cache load lock	1							1.2	98.8
library cache: bucket mutex X	1263		.3	4.0	19.1	5.6	.2	.3	70.5
library cache: dependency mutex X	297			4.2	32.3	7.6	.6	1.6	53.7
library cache: mutex X	1.2M	.1	1.4	9.0	21.9	3.0	.4	.3	63.9
log file parallel write	1046				.0	.0	.0	.0	99.9
log file sync	85			.0	.0	.0	.0	.0	100.0
read by other session	1							16.7	83.3
row cache lock	30					.4	3.2	8.4	88.0
row cache mutex	691.9K	.0	.5	6.4	30.3	3.2	.4	.3	58.9
row cache read	144.8K	.0	.5	1.6	64.1	2.9	1.2	.5	29.3
undo_retention publish retry	2			100.0

		% of Total Waits
Event	Waits 1ms to 32ms	<512us	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	>=32ms
ADR block file read	7	80.6			5.6	13.9
ASM file metadata operation	20	96.8	2.4	.2				.6
CSS initialization	2	50.0				50.0
CSS operation: action	4	50.0	50.0
CSS operation: data query	11	72.5	17.5	10.0
CSS operation: data update	8	20.0	80.0
CSS operation: query	2	83.3	16.7
Disk file Mirror Read	15	98.3	1.6					.1
IMR slave acknowledgement msg	105	94.3	5.7	.1
KSV master wait	8	98.5	1.1	.4
LGWR all worker groups	776	98.7	1.2	.1	.0
LGWR any worker group	493	99.8	.2	.0	.0		.0	.0
LGWR wait for redo copy	659	80.6	15.0	4.1	.2
LGWR worker group ordering	559	99.4	.5	.1	.0	.0	.0
PGA memory operation	5	100.0	.0
PX Deq: Join ACK	1528	83.3	12.9	2.6	1.0	.1			.0
PX Deq: Signal ACK EXT	4	99.9	.1	.0
PX Deq: Slave Session Stats	14	99.7	.3
Parameter File I/O	1	96.9					3.1
RMA: IPC0 completion sync	615	3.0						97.0
SQL*Net message to client	260	100.0	.0	.0	.0
Sync ASM rebalance	57	62.6	2.3	.6		6.9	23.0		4.6
acknowledge over PGA limit	13	7.1					92.9
buffer busy waits	54	96.9	2.3	.7	.1
buffer exterminate	5387	.1					99.9
cell single block physical read	915	91.5	6.9	.7	.3	.2	.3	.0	.0
cell statistics gather	35	84.4		12.1	.4	3.1
control file parallel write	141	56.9	41.6		.3	.9	.3
control file sequential read	25	99.1	.7	.1	.0		.1
cursor: pin S	31		3.2	93.5	3.2
cursor: pin S wait on X	40			15.0	15.0	42.5	17.5	10.0
db file parallel write	14.1K	78.2	20.8	.6	.1	.1	.1	.0
direct path write	2	33.3	66.7
enq: FB - contention	15	95.9	2.8	1.4
enq: IV - contention	18	95.4	4.6
enq: PS - contention	104	97.2	1.7	.9	.1		.0
enq: TX - contention	3		66.7			33.3
gc cr block 2-way	1	100.0	.0
gc cr block busy	1	83.3	16.7
gc cr grant 2-way	2	99.3	.7
gc cr multi block mixed	2	99.3	.7
gc current block busy	1	99.6	.4
gc current grant 2-way	3	99.4	.4	.2
gc current multi block request	1	99.3	.7
latch free	3859	85.0	11.9	2.9	.1	.0		.0
latch: cache buffers chains	17	83.8	11.4	3.8	1.0
latch: enqueue hash chains	41	75.0	16.5	7.3	1.2
latch: gcs resource hash	1	50.0	50.0
latch: ges resource hash list	95K	72.5	16.7	9.4	1.4	.1
latch: messages	34	68.8	22.0	9.2
latch: redo allocation	276	71.4	21.1	7.0	.4
latch: redo writing	10	66.7	26.7	6.7
latch: shared pool	3.1M	75.4	15.8	8.1	.6	.0	.1		.0
latch: undo global data	8	57.9	26.3	15.8
library cache load lock	84	2.3	1.2	1.2	2.3	12.8	46.5	33.7
library cache: bucket mutex X	2913	31.9	1.4	.5			64.2	2.0
library cache: dependency mutex X	324	49.5	.5	.2			49.9
library cache: mutex X	2.1M	37.8	1.1	.4	.0	.0	48.9	11.2	.6
log file parallel write	1114	99.9	.1	.0	.0	.0	.0	.0
log file sync	260.6K	80.1	16.7	3.1	.1	.0	.0	.0
oracle thread bootstrap	4							8.2	91.8
os thread creation	49			79.6	20.4
read by other session	3	50.0	16.7		16.7	16.7
reliable message	198	89.4	10.4	.2
remote log force - commit	3		66.7			33.3
row cache lock	64	72.7	4.4	3.2	10.4	2.8	4.8		1.6
row cache mutex	924.8K	42.8	.7	.2	.0		38.3	15.8	2.2
row cache read	54K	73.6	1.2	.4	.0		24.8	.0
wait list latch free	5592		.3	98.8	.9

		% of Total Waits
Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
PX Deq: Join ACK	1	100.0	.0
SGA: allocation forcing component growth	1			100.0
Sync ASM rebalance	8	95.4	2.3	1.1		1.1
cell single block physical read	4	100.0	.0
gc buffer busy release	9		11.1	11.1	11.1	11.1	55.6
latch: shared pool	37	100.0	.0
library cache: mutex X	21K	99.4	.6	.0
name-service call wait	2	33.3	66.7
oracle thread bootstrap	45	8.2	89.8	2.0
row cache mutex	37.2K	97.8	2.1	.2	.0

		% of Total Waits
Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s	< 1m	< 2m	>=2m
row cache lock	4	98.4	1.6

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
conndemo	55,186	10,175	2	26,406
SYS$USERS	118	105	0	333
SYS$BACKGROUND	0	0	8	83
conndemo2	0	0	0	0
conndemoXDB	0	0	0	0
conndemo_scan	0	0	0	0

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
conndemo	2478	1	17761417	44303	6984109	8
SYS$USERS	707	0	26835	8	1497	0
SYS$BACKGROUND	8823	4	5050	1	0	0
conndemo2	0	0	0	0	0	0
conndemo_scan	0	0	0	0	0	0

Channel	Waits	Total Wait Time (s)	Avg Wait
GEN0 ksbxic channel	10	0	545.10us
RBR channel	31	0	329.13us
kxfp control signal channel	1,833	1	355.99us

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
53.02	610	0.09	0.10	96.91	0.00	0rc74p3yhj9bj	JDBC Thin Client	SELECT SUM(VALUE) FROM GV$SYSS...
36.82	0		0.07	81.49	0.01	apqrms2c1kc9p	JDBC Thin Client	BEGIN :1 := mon_db.startup(int...
21.70	655,141	0.00	0.04	57.13	0.00	47r1y8yn34jmj		select default$ from col$ wher...
20.02	122	0.16	0.04	92.25	0.00	c6qynd1shsz12	JDBC Thin Client	SELECT MAX(A.VALUE), MIN(A.VAL...
10.31	0		0.02	71.62	2.64	56vd37c105kc2	sqlplus@scao08adm04.us.oracle.com (TNS V1-V3)	begin dbms_workload_repository...
4.41	1	4.41	0.01	80.74	1.40	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
2.80	122	0.02	0.01	76.48	0.00	d5vhrurw6qufa	JDBC Thin Client	SELECT DECODE(ASH.WAIT_CLASS, ...
2.12	755	0.00	0.00	79.79	0.00	4rm4183czbs7j		select value, flags, modified_...
2.04	40	0.05	0.00	80.72	0.00	8d62ttmswmy01	EM Realtime Connection	SELECT event#, sql_id, sql_pla...
1.76	122	0.01	0.00	73.44	0.00	cp168yc65na4a	JDBC Thin Client	SELECT EVENT \|\| '\|' \|\| SUM(CAS...

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
51.38	610	0.08	0.50	53.02	96.91	0.00	0rc74p3yhj9bj	JDBC Thin Client	SELECT SUM(VALUE) FROM GV$SYSS...
30.00	0		0.29	36.82	81.49	0.01	apqrms2c1kc9p	JDBC Thin Client	BEGIN :1 := mon_db.startup(int...
18.47	122	0.15	0.18	20.02	92.25	0.00	c6qynd1shsz12	JDBC Thin Client	SELECT MAX(A.VALUE), MIN(A.VAL...
12.39	655,141	0.00	0.12	21.70	57.13	0.00	47r1y8yn34jmj		select default$ from col$ wher...
7.39	0		0.07	10.31	71.62	2.64	56vd37c105kc2	sqlplus@scao08adm04.us.oracle.com (TNS V1-V3)	begin dbms_workload_repository...
3.56	1	3.56	0.03	4.41	80.74	1.40	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
2.14	122	0.02	0.02	2.80	76.48	0.00	d5vhrurw6qufa	JDBC Thin Client	SELECT DECODE(ASH.WAIT_CLASS, ...
1.69	755	0.00	0.02	2.12	79.79	0.00	4rm4183czbs7j		select value, flags, modified_...
1.65	40	0.04	0.02	2.04	80.72	0.00	8d62ttmswmy01	EM Realtime Connection	SELECT event#, sql_id, sql_pla...
1.37	1,913	0.00	0.01	1.39	98.23	2.64	121ffmrc95v7g		select i.obj#, i.ts#, i.file#,...

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.27	0		4.89	10.31	71.62	2.64	56vd37c105kc2	sqlplus@scao08adm04.us.oracle.com (TNS V1-V3)	begin dbms_workload_repository...
0.06	1	0.06	1.11	4.41	80.74	1.40	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.04	1,913	0.00	0.66	1.39	98.23	2.64	121ffmrc95v7g		select i.obj#, i.ts#, i.file#,...
0.03	1,432	0.00	0.60	0.17	96.37	19.45	aaz3bayav0jwj		update /* KSXM:FLUSH COL */ sy...
0.01	10,189	0.00	0.10	0.71	78.91	0.82	2sxqgx5hx76qr		select /+ rule / bucket, end...
0.01	122	0.00	0.10	0.84	68.32	0.65	4k5bnqqmc8pph	JDBC Thin Client	SELECT 'log file sync' \|\| '\|' ...
0.01	0		0.10	36.82	81.49	0.01	apqrms2c1kc9p	JDBC Thin Client	BEGIN :1 := mon_db.startup(int...
0.00	826	0.00	0.08	0.61	83.02	0.73	1mjd9xp80vuqa		select node, owner, name from ...
0.00	3,272	0.00	0.04	0.65	71.03	0.35	9t4vxdppkv534		select name, intcol#, segcol#,...
0.00	150	0.00	0.04	0.05	83.31	4.82	3dbzmtf9ahvzt		merge /* KSXM:OPTIM_DML_INF */...

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,310,210	655,141	2.00	4.88	21.70	57.1	0	47r1y8yn34jmj		select default$ from col$ wher...
107,123	0		0.40	36.82	81.5	0	apqrms2c1kc9p	JDBC Thin Client	BEGIN :1 := mon_db.startup(int...
95,747	0		0.36	10.31	71.6	2.6	56vd37c105kc2	sqlplus@scao08adm04.us.oracle.com (TNS V1-V3)	begin dbms_workload_repository...
63,777	122	522.76	0.24	20.02	92.3	0	c6qynd1shsz12	JDBC Thin Client	SELECT MAX(A.VALUE), MIN(A.VAL...
52,899	1	52,899.00	0.20	4.41	80.7	1.4	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
48,153	16,235	2.97	0.18	0.49	53.7	.1	0sbbcuruzd66f		select /+ rule / bucket_cnt,...
36,812	10,189	3.61	0.14	0.71	78.9	.8	2sxqgx5hx76qr		select /+ rule / bucket, end...
29,495	6,959	4.24	0.11	0.20	74.6	0	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
23,363	755	30.94	0.09	2.12	79.8	0	4rm4183czbs7j		select value, flags, modified_...
22,429	61	367.69	0.08	0.87	82.6	0	5qu5f26fprk6c		select ct.toid, ct.version# fr...

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
377	0		3.48	10.31	71.62	2.64	56vd37c105kc2	sqlplus@scao08adm04.us.oracle.com (TNS V1-V3)	begin dbms_workload_repository...
170	1	170.00	1.57	4.41	80.74	1.40	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
9	10,189	0.00	0.08	0.71	78.91	0.82	2sxqgx5hx76qr		select /+ rule / bucket, end...
5	150	0.03	0.05	0.05	83.31	4.82	3dbzmtf9ahvzt		merge /* KSXM:OPTIM_DML_INF */...
3	122	0.02	0.03	0.84	68.32	0.65	4k5bnqqmc8pph	JDBC Thin Client	SELECT 'log file sync' \|\| '\|' ...
3	0		0.03	36.82	81.49	0.01	apqrms2c1kc9p	JDBC Thin Client	BEGIN :1 := mon_db.startup(int...
2	1,913	0.00	0.02	1.39	98.23	2.64	121ffmrc95v7g		select i.obj#, i.ts#, i.file#,...
2	826	0.00	0.02	0.61	83.02	0.73	1mjd9xp80vuqa		select node, owner, name from ...
2	0		0.02	0.01	81.36	6.88	dryn65cmpsyf3		SELECT t.ts#, t.con_dbid, max...
2	1	2.00	0.02	0.03	72.83	2.92	gwqytpnrq8g0k		insert into wrh$_seg_stat (dbi...

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Opt	%Total	SQL Id	SQL Module	SQL Text
10	456	0		97.81	1000.00	56vd37c105kc2	sqlplus@scao08adm04.us.oracle.com (TNS V1-V3)	begin dbms_workload_repository...
10	169	1	10.00	94.08	1000.00	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	195	0.00		0.00	03guhbfpak0w7		select /*+ index(idl_ub1$ i_id...
0	0	122	0.00		0.00	0492m78c0mfha	JDBC Thin Client	SELECT 'enq: TX - index conten...
0	0	610	0.00		0.00	0rc74p3yhj9bj	JDBC Thin Client	SELECT SUM(VALUE) FROM GV$SYSS...
0	0	16,235	0.00		0.00	0sbbcuruzd66f		select /+ rule / bucket_cnt,...
0	0	122	0.00		0.00	0urqy7qgsbnrr	JDBC Thin Client	SELECT 'log file parallel writ...
0	2	1,913	0.00	100.00	0.00	121ffmrc95v7g		select i.obj#, i.ts#, i.file#,...
0	0	0			0.00	18c2yb5aj919t		SELECT nvl(e1, 0) as e1, nvl(...
0	0	122	0.00		0.00	1jg9p7bcxdpun	JDBC Thin Client	SELECT 'gc buffer busy release...

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
655,141	655,146	1.00	21.70	57.1	0	47r1y8yn34jmj	select default$ from col$ wher...
16,235	14,953	0.92	0.49	53.7	.1	0sbbcuruzd66f	select /+ rule / bucket_cnt,...
10,189	162,230	15.92	0.71	78.9	.8	2sxqgx5hx76qr	select /+ rule / bucket, end...
6,959	7,721	1.11	0.20	74.6	0	53saa2zkr6wc3	select intcol#, nvl(pos#, 0), ...
3,449	2,550	0.74	0.25	35.1	.1	acmvv4fhdc9zh	select obj#, type#, ctime, mti...
3,272	73,602	22.49	0.65	71	.4	9t4vxdppkv534	select name, intcol#, segcol#,...
2,961	4,790	1.62	0.13	71.4	0	5n1fs4m2n2y0r	select pos#, intcol#, col#, sp...
2,439	2,439	1.00	0.11	67.6	0	grwydz59pu6mc	select text from view$ where r...
1,913	2,961	1.55	1.39	98.2	2.6	121ffmrc95v7g	select i.obj#, i.ts#, i.file#,...
1,434	192	0.13	0.07	96.3	0	6qz82dptj0qr7	select l.col#, l.intcol#, l.lo...

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
2,439	2,439	0.06	grwydz59pu6mc		select text from view$ where r...
1,434	1,434	0.03	6qz82dptj0qr7		select l.col#, l.intcol#, l.lo...
1,226	1,226	0.03	3un99a0zwp4vd		select owner#, name, namespace...
1,226	1,226	0.03	8swypbbr0m372		select order#, columns, types ...
1,203	1,203	0.03	asvzxj61dc5vs		select timestamp, flags from f...
755	755	0.02	4rm4183czbs7j		select value, flags, modified_...
610	610	0.01	0rc74p3yhj9bj	JDBC Thin Client	SELECT SUM(VALUE) FROM GV$SYSS...
534	534	0.01	2p9fv35c7zxtg		select /* KSXM:LOAD_DML_INF */...
429	1,432	0.01	aaz3bayav0jwj		update /* KSXM:FLUSH COL */ sy...
237	237	0.01	afx304d90ps3z		select rowcnt, blkcnt, empcnt,...

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.23	0	3.52	10.31	2.23	71.62	2.64	56vd37c105kc2	sqlplus@scao08adm04.us.oracle.com (TNS V1-V3)	begin dbms_workload_repository...
0.10	1	1.60	4.41	2.36	80.74	1.40	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.03	10,189	0.47	0.71	4.33	78.91	0.82	2sxqgx5hx76qr		select /+ rule / bucket, end...
0.01	1,226	0.15	0.18	5.60	81.30	0.29	3un99a0zwp4vd		select owner#, name, namespace...
0.01	3,272	0.12	0.65	1.23	71.03	0.35	9t4vxdppkv534		select name, intcol#, segcol#,...
0.01	195	0.12	0.02	32.66	69.08	2.15	03guhbfpak0w7		select /*+ index(idl_ub1$ i_id...
0.01	1,226	0.10	0.08	8.27	88.09	0.65	8swypbbr0m372		select order#, columns, types ...
0.01	1,432	0.08	0.17	3.03	96.37	19.45	aaz3bayav0jwj		update /* KSXM:FLUSH COL */ sy...

SQL Id	SQL Text
03guhbfpak0w7	select /+ index(idl_ub1$ i_idl_ub11) / piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
0492m78c0mfha	SELECT 'enq: TX - index contention' \|\| '\|' \|\| SUM(TIME_WAITED_MICRO)/1000 \|\| '\|' \|\| SUM(TOTAL_WAITS) DATA FROM GV$SYSTEM_EVENT WHERE EVENT = 'enq: TX - index contention'
0rc74p3yhj9bj	SELECT SUM(VALUE) FROM GV$SYSSTAT WHERE NAME = :B1
0sbbcuruzd66f	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln, minimum_enc, maximum_enc from hist_head$ where obj#=:1 and intcol#=:2
0urqy7qgsbnrr	SELECT 'log file parallel write' \|\| '\|' \|\| SUM(TIME_WAITED_MICRO)/1000 \|\| '\|' \|\| SUM(TOTAL_WAITS) DATA FROM GV$SYSTEM_EVENT WHERE EVENT = 'log file parallel write'
121ffmrc95v7g	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)), nvl(i.evaledition#, 1), nvl(i.unusablebefore#, 0), nvl(i.unusablebeginning#, 0), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(intcols) 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#
18c2yb5aj919t	SELECT nvl(e1, 0) as e1, nvl(e2, 0) as e2, nvl(e3, 0) as e3, nvl(e4, 0) as e4, nvl(e5, 0) as e5, nvl(e6, 0) as e6 FROM (SELECT e.event_id as event_id, e.event_name as event_name FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid AND e.event_name in ('log file sync', 'gc buffer busy', 'gc buffer busy acquire', 'gc buffer busy release', 'Streams: resolve low memory condition', 'Streams capture: resolve low memory condition') ) PIVOT (max(event_id) FOR event_name IN ('log file sync' as e1, 'gc buffer busy' as e2, 'gc buffer busy acquire' as e3, 'gc buffer busy release' as e4, 'Streams: resolve low memory condition' as e5, 'Streams capture: resolve low memory condition' as e6) )
1jg9p7bcxdpun	SELECT 'gc buffer busy release' \|\| '\|' \|\| SUM(TIME_WAITED_MICRO)/1000 \|\| '\|' \|\| SUM(TOTAL_WAITS) DATA FROM GV$SYSTEM_EVENT WHERE EVENT = 'gc buffer busy release'
1mjd9xp80vuqa	select node, owner, name from syn$ where obj#=:1
2p9fv35c7zxtg	select /* KSXM:LOAD_DML_INF //+ leading(o) index(m) use_nl(m) */ nvl(m.inserts, 0) ins, nvl(m.updates, 0) upd, nvl(m.deletes, 0) del, nvl(m.drop_segments, 0) dropseg, nvl(m.flags, 0) flags, nvl(rowcnt, 0) rowcnt, o.pobjn pobjn from (select :objn objn, 0 pobjn, rowcnt from tab$ t where t.obj# = :objn union all select :objn objn, tp.bo# pobjn, rowcnt from tabpart$ tp where tp.obj# = :objn union all select :objn objn, tcp.bo# pobjn, rowcnt from tabcompart$ tcp where tcp.obj# = :objn union all select :objn objn, tsp.pobj# pobjn, rowcnt from tabsubpart$ tsp where tsp.obj# = :objn) o, sys.mon_mods_all$ m where o.objn = m.obj#(+) and rownum < 2
2sxqgx5hx76qr	select /+ rule / bucket, endpoint, col#, epvalue, epvalue_raw, ep_repeat_count, endpoint_enc from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
3dbzmtf9ahvzt	merge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using dual on (m.obj# = :objn and (:pobjn = 0 or m.obj# = :pobjn or m.obj# in (select obj# from tabpart$ where bo# = :pobjn and obj# = :objn union all select obj# from tabcompart$ where bo# = :pobjn and obj# = :objn union all select ts p.obj# from tabsubpart$ tsp, tabcompart$ tcp where tsp.pobj# = tcp.obj# and (tcp.bo# = :pobjn or tcp.obj# = :pobjn) and tsp.obj# = :objn))) when matched then update set inserts = decode(:reset, 1, 0, inserts) + :ins, updates = decode(:reset, 1, 0, updates) + :upd, deletes = decode(:reset, 1, 0, deletes) + :del, flags = decode(:reset, 1, 0, flags - bitand(flags, :flag)) + :flag, drop_segments = decode(:reset, 1, 0, drop_segments) + :dropseg, timestamp = :time when NOT matched then insert (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:objn, :ins, :upd, :del, :time, :flag, :dropseg) where :ins != 0 or :upd != 0 or :del != 0 or :flag != 0 or :dropseg !=0
3un99a0zwp4vd	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, flags, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
47r1y8yn34jmj	select default$ from col$ where rowid=:1
4k5bnqqmc8pph	SELECT 'log file sync' \|\| '\|' \|\| SUM(TIME_WAITED_MICRO)/1000 \|\| '\|' \|\| SUM(TOTAL_WAITS) DATA FROM GV$SYSTEM_EVENT WHERE EVENT = 'log file sync'
4rm4183czbs7j	select value, flags, modified_inst, additional_info, attr_tstamp, attr_intv from sys.scheduler$_global_attribute where obj# = :1
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
56vd37c105kc2	begin dbms_workload_repository.create_snapshot; dbms_lock.sleep(600); dbms_workload_repository.create_snapshot; end;
5n1fs4m2n2y0r	select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
5qu5f26fprk6c	select ct.toid, ct.version# from sys.col$ c, sys.coltype$ ct, sys.obj$ o where c.intcol# = ct.intcol# and ct.toid = o.oid$ and o.type# <> 10 and c.obj# = ct.obj# and c.name = 'USER_DATA' and c.obj# = :1
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
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
8d62ttmswmy01	SELECT event#, sql_id, sql_plan_hash_value, sql_opcode, session_id, session_serial#, module, action, client_id, DECODE(wait_time, 0, 'W', 'C'), 1, time_waited, service_hash, user_id, program, sample_time, p1, p2, p3, current_file#, current_obj#, current_block#, qc_session_id, qc_instance_id, sql_child_number, plsql_object_id, plsql_subprogram_id, qc_session_serial#, con_id FROM v$active_session_history WHERE sample_time > :1 AND sample_time <= :2
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
9t4vxdppkv534	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), nvl(evaledition#, 1), nvl(unusablebefore#, 0), nvl(unusablebeginning#, 0), case when (type# in (1, 8, 9, 96, 112)) then nvl(collid, 16382) else 0 end case, nvl(collintcol#, 0), nvl(acdrrescol#, 0), nvl(spare7, 0) from col$ where obj#=:1 order by intcol#
aaz3bayav0jwj	update /* KSXM:FLUSH COL */ sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), flags = :flag, timestamp = :time where obj# = :objn and intcol# = :coln
acmvv4fhdc9zh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2, spare3, signature, spare7, spare8, spare9, nvl(dflcollid, 16382), creappid, creverid, modappid, modverid, crepatchid, modpatchid from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
afx304d90ps3z	select rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, analyzetime, samplesize, avgspc_flb, flbcnt, flags from tab_stats$ where obj#=:1
apqrms2c1kc9p	BEGIN :1 := mon_db.startup(interval=>5, server=>'10.128.18.121', port=>2700, userfilter=>'CLO_NORMAL%') ; END;
asvzxj61dc5vs	select timestamp, flags from fixed_obj$ where obj#=:1
c6qynd1shsz12	SELECT MAX(A.VALUE), MIN(A.VALUE) FROM V$SESSTAT A, V$STATNAME B, V$SESSION S WHERE A.STATISTIC# = B.STATISTIC# AND B.NAME = 'opened cursors current' AND S.SID = A.SID AND USERNAME LIKE :B1
cp168yc65na4a	SELECT EVENT \|\| '\|' \|\| SUM(CASE WHEN WAIT_TIME_MILLI<=1 THEN WAIT_COUNT ELSE 0 END) \|\| '\|' \|\| SUM(CASE WHEN WAIT_TIME_MILLI>1 AND WAIT_TIME_MILLI<=2 THEN WAIT_COUNT ELSE 0 END) \|\| '\|' \|\| SUM(CASE WHEN WAIT_TIME_MILLI>2 AND WAIT_TIME_MILLI<=4 THEN WAIT_COUNT ELSE 0 END) \|\| '\|' \|\| SUM(CASE WHEN WAIT_TIME_MILLI>4 AND WAIT_TIME_MILLI<=8 THEN WAIT_COUNT ELSE 0 END) \|\| '\|' \|\| SUM(CASE WHEN WAIT_TIME_MILLI>8 AND WAIT_TIME_MILLI<=16 THEN WAIT_COUNT ELSE 0 END) \|\| '\|' \|\| SUM(CASE WHEN WAIT_TIME_MILLI>16 AND WAIT_TIME_MILLI<=32 THEN WAIT_COUNT ELSE 0 END) \|\| '\|' \|\| SUM(CASE WHEN WAIT_TIME_MILLI> 32 AND WAIT_TIME_MILLI<=64 THEN WAIT_COUNT ELSE 0 END) \|\| '\|' \|\| SUM(CASE WHEN WAIT_TIME_MILLI> 64 AND WAIT_TIME_MILLI<=128 THEN WAIT_COUNT ELSE 0 END) \|\| '\|' \|\| SUM(CASE WHEN WAIT_TIME_MILLI> 128 AND WAIT_TIME_MILLI<=256 THEN WAIT_COUNT ELSE 0 END) \|\| '\|' \|\| SUM(CASE WHEN WAIT_TIME_MILLI> 256 AND WAIT_TIME_MILLI<=512 THEN WAIT_COUNT ELSE 0 END) \|\| '\|' \|\| SUM(CASE WHEN WAIT_TIME_MILLI> 512 AND WAIT_TIME_MILLI<=1024 THEN WAIT_COUNT ELSE 0 END) \|\| '\|' \|\| SUM(CASE WHEN WAIT_TIME_MILLI>1024 THEN WAIT_COUNT ELSE 0 END) DATA FROM GV$EVENT_HISTOGRAM WHERE EVENT IN ('log file sync', 'log file parallel write') GROUP BY EVENT ORDER BY EVENT
d5vhrurw6qufa	SELECT DECODE(ASH.WAIT_CLASS, '', 'ON CPU', ASH.WAIT_CLASS) \|\| '\|' \|\| DECODE(ASH.SESSION_STATE, 'ON CPU', 'ON CPU', ASH.EVENT) \|\| '\|' \|\| ROUND(COUNT(1)/:B3 , 2) \|\| '\|' \|\| ROUND(MAX(TIME_WAITED/1000)) DATA FROM GV$ACTIVE_SESSION_HISTORY ASH WHERE SAMPLE_TIME >= :B2 - NUMTODSINTERVAL(1, 'SECOND') AND SAMPLE_TIME < :B1 - NUMTODSINTERVAL(1, 'SECOND') GROUP BY DECODE(ASH.SESSION_STATE, 'ON CPU', 'ON CPU', ASH.EVENT), DECODE(ASH.WAIT_CLASS, '', 'ON CPU', ASH.WAIT_CLASS)
dryn65cmpsyf3	SELECT t.ts#, t.con_dbid, max(t.tsname) as tname, count(*) as backup FROM WRH$_TABLESPACE_STAT t WHERE t.dbid = :dbid and t.snap_id <= :eid and t.snap_id >= :bid and t.is_backup = 'TRUE' GROUP BY t.ts#, t.con_dbid ORDER BY 3 DESC, 1 ASC, 2 ASC
grwydz59pu6mc	select text from view$ where rowid=:1
gwqytpnrq8g0k	insert into wrh$_seg_stat (dbid, per_pdb, con_dbid, snap_id, instance_number, ts#, obj#, dataobj#, logical_reads_total, logical_reads_delta, buffer_busy_waits_total, buffer_busy_waits_delta, db_block_changes_total, db_block_changes_delta, physical_reads_total, physical_reads_delta, physical_writes_total, physical_writes_delta, physical_reads_direct_total, physical_reads_direct_delta, physical_writes_direct_total, physical_writes_direct_delta, itl_waits_total, itl_waits_delta, row_lock_waits_total, row_lock_waits_delta, gc_buffer_busy_total, gc_buffer_busy_delta, gc_cr_blocks_received_total, gc_cr_blocks_received_delta, gc_cu_blocks_received_total, gc_cu_blocks_received_delta, space_used_total, space_used_delta, space_allocated_total, space_allocated_delta, table_scans_total, table_scans_delta, chain_row_excess_total, chain_row_excess_delta, physical_read_requests_total, physical_read_requests_delt a, physical_write_requests_total, physical_write_requests_delta, optimized_physical_reads_total, optimized_physical_reads_delta ) select :dbid, 0 per_pdb, :srcdbid con_dbid, :snap_id, :instance_number, tsn_kewrseg, objn_kewrseg, objd_kewrseg, log_rds_kewrseg, log_rds_dl_kewrseg, buf_busy_wts_kewrseg, buf_busy_wts_dl_kewrseg, db_blk_chgs_kewrseg, db_blk_chgs_dl_kewrseg, phy_rds_kewrseg, phy_rds_dl_kewrseg, phy_wrts_kewrseg, phy_wrts_dl_kewrseg, phy_rds_drt_kewrseg, phy_rds_drt_dl_kewrseg, phy_wrts_drt_kewrseg, phy_wrts_drt_dl_kewrseg, itl_wts_kewrseg, itl_wts_dl_kewrseg, row_lck_wts_kewrseg, row_lck_wts_dl_kewrseg, gc_buf_busy_kewrseg, gc_buf_busy_dl_kewrseg, gc_cr_blks_rcv_kewrseg, gc_cr_blks_rcv_dl_kewrseg, gc_cu_blks_rcv_kewrseg, gc_cu_blks_rcv_dl_kewrseg, space_used_kewrseg, space_used_dl_kewrseg, space_alloc_kewrseg, space_alloc_dl_kewrseg, tbl_scns_kewrseg, tbl_scns_dl_kewrseg, ch n_exc_kewrseg / 100, chn_exc_dl_kewrseg / 100, phy_rd_reqs_kewrseg, phy_rd_reqs_dl_kewrseg, phy_wrt_reqs_kewrseg, phy_wrt_reqs_dl_kewrseg, opt_phy_rds_kewrseg, opt_phy_rds_dl_kewrseg FROM X$KEWRTSEGSTAT tsseg WHERE (1 = 1)

Instance Activity Statistics

Key Instance Activity Stats

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

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

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

Dictionary Cache Statistics

Dictionary Cache Stats

Dictionary Cache Stats (RAC)

Library Cache Statistics

Library Cache Activity

Library Cache Activity (RAC)

Memory Statistics

Memory Dynamic Components

Memory Resize Operations Summary

Memory Resize Ops

Process Memory Summary

SGA Memory Summary

SGA breakdown difference

Replication Statistics (GoldenGate, XStream)

Replication System Resource Usage

Replication SGA Usage

GoldenGate Capture

GoldenGate Capture Rate

GoldenGate Apply Reader

GoldenGate Apply Coordinator

GoldenGate Apply Server

GoldenGate Apply Coordinator Rate

GoldenGate Apply Reader and Server Rate

XStream Capture

XStream Capture Rate

XStream Apply Reader

XStream Apply Coordinator

XStream Apply Server

XStream Apply Coordinator Rate

XStream Apply Reader and Server Rate

Table Statistics by DML Operations

Table Statistics by Conflict Resolutions

Replication Large Transaction Statistics

Replication Long Running Transaction Statistics

Streams Statistics

Streams CPU/IO Usage

Streams Capture

Streams Capture Rate

Streams Apply

Streams Apply Rate

Buffered Queues

Buffered Queue Subscribers

Rule Set

Persistent Queues

Persistent Queues Rate

Persistent Queue Subscribers

Resource Limit Stats

Shared Server Statistics

Shared Servers Activity

Shared Servers Rates

Shared Servers Utilization

Shared Servers Common Queue

Shared Servers Dispatchers

init.ora Parameters

init.ora Multi-Valued Parameters

Active Session History (ASH) Report

Top SQL with Top Events

Top SQL with Top Row Sources

Top Sessions

Top Blocking Sessions

Top PL/SQL Procedures

Top Events

Top Event P1/P2/P3 Values

Top DB Objects

Activity Over Time

ADDM Task ADDM:5801112_2_27007

RAC Statistics

Statistic	Total	per Second	per Trans
db block changes	13,581,403	22,226.77	10.37
execute count	5,009,443	8,198.25	3.82
gc cr block receive time	25	0.04	0.00
gc cr blocks received	2,746	4.49	0.00
gc current block receive time	122	0.20	0.00
gc current blocks received	9,013	14.75	0.01
logons cumulative	1,913	3.13	0.00
opened cursors cumulative	5,009,715	8,198.70	3.82
parse count (total)	4,276,560	6,998.84	3.27
parse time elapsed	5,311,208	8,692.11	4.06
physical reads	10,847	17.75	0.01
physical writes	417,495	683.26	0.32
redo size	2,117,159,944	3,464,858.07	1,616.46
session cursor cache hits	746,729	1,222.07	0.57
session logical reads	26,833,535	43,914.67	20.49
user calls	11,252,820	18,415.91	8.59
user commits	1,309,752	2,143.49	1.00
user rollbacks	0	0.00	0.00
workarea executions - multipass	0	0.00	0.00
workarea executions - optimal	18,725	30.64	0.01

Statistic	Total	per Second	per Trans
ASSM bg: segment fix monitor	1	0.00	0.00
ASSM cbk:blocks examined	1,329,817	2,176.32	1.02
ASSM cbk:blocks marked full	16,505	27.01	0.01
ASSM gsp:L1 bitmaps examined	1,316,845	2,155.10	1.01
ASSM gsp:L2 bitmap full	20	0.03	0.00
ASSM gsp:L2 bitmaps examined	1,057	1.73	0.00
ASSM gsp:L3 bitmaps examined	0	0.00	0.00
ASSM gsp:Optimized reject DB	0	0.00	0.00
ASSM gsp:Optimized reject l1	0	0.00	0.00
ASSM gsp:Optimized reject l2	0	0.00	0.00
ASSM gsp:Search all	16	0.03	0.00
ASSM gsp:Search hint	967	1.58	0.00
ASSM gsp:Search steal	13	0.02	0.00
ASSM gsp:bump HWM	13	0.02	0.00
ASSM gsp:get free block	1,313,312	2,149.31	1.00
ASSM gsp:get free data block	1,310,300	2,144.38	1.00
ASSM gsp:get free index block	3,012	4.93	0.00
ASSM gsp:good hint	1,313,298	2,149.29	1.00
ASSM gsp:reject L1	0	0.00	0.00
ASSM gsp:reject L2	0	0.00	0.00
ASSM gsp:reject db	0	0.00	0.00
ASSM rsv:alloc from reserve	0	0.00	0.00
ASSM rsv:alloc from reserve succ	0	0.00	0.00
ASSM rsv:clear reserve	0	0.00	0.00
ASSM rsv:fill reserve	1	0.00	0.00
ASSM wasted db state change	225	0.37	0.00
BPS commit wait	3	0.00	0.00
Batched IO (bound) vector count	77	0.13	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	236	0.39	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	2	0.00	0.00
Batched IO same unit count	150	0.25	0.00
Batched IO single block count	76	0.12	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	11	0.02	0.00
Batched IO vector read count	3	0.00	0.00
Block Cleanout Optim referenced	10,871	17.79	0.01
CCursor + sql area evicted	4,258,063	6,968.57	3.25
CPU used by this session	917,446	1,501.45	0.70
CPU used when call started	899,395	1,471.91	0.69
CR blocks created	49,276	80.64	0.04
Cached Commit SCN referenced	3,368	5.51	0.00
Commit SCN cached	2	0.00	0.00
DBWR checkpoint buffers written	370,894	606.99	0.28
DBWR checkpoints	0	0.00	0.00
DBWR fusion writes	38	0.06	0.00
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 transaction table writes	596	0.98	0.00
DBWR undo block writes	104,677	171.31	0.08
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	1,833	3.00	0.00
DML statements parallelized	0	0.00	0.00
Effective IO time	0	0.00	0.00
HSC Heap Segment Block Changes	4,045,608	6,620.88	3.09
Heap Segment Array Inserts	228	0.37	0.00
Heap Segment Array Updates	9	0.01	0.00
Heatmap BlkLevel Flushed	0	0.00	0.00
Heatmap BlkLevel Flushed to SYSAUX	0	0.00	0.00
Heatmap BlkLevel Ranges Flushed	0	0.00	0.00
Heatmap Blklevel Flush Task Count	0	0.00	0.00
IPC CPU used by this session	0	0.00	0.00
KTFB alloc myinst	12	0.02	0.00
KTFB alloc req	27	0.04	0.00
KTFB alloc search FFB	44	0.07	0.00
KTFB alloc space (block)	67,121,688	109,848.63	51.25
KTFB alloc steal	0	0.00	0.00
KTFB alloc time (ms)	5,623	9.20	0.00
KTFB apply req	39	0.06	0.00
KTFB apply time (ms)	2,727	4.46	0.00
KTFB commit req	0	0.00	0.00
KTFB commit time (ms)	0	0.00	0.00
KTFB free req	24	0.04	0.00
KTFB free space (block)	3,968	6.49	0.00
KTFB free time (ms)	25	0.04	0.00
LOB table id lookup cache misses	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
Number of read IOs issued	0	0.00	0.00
OS Block input operations	0	0.00	0.00
OS Block output operations	0	0.00	0.00
OS Involuntary context switches	0	0.00	0.00
OS Maximum resident set size	0	0.00	0.00
OS Page faults	0	0.00	0.00
OS Page reclaims	0	0.00	0.00
OS System time used	0	0.00	0.00
OS User time used	0	0.00	0.00
OS Voluntary context switches	0	0.00	0.00
PX local messages recv'd	7,457	12.20	0.01
PX local messages sent	7,457	12.20	0.01
PX remote messages recv'd	3,746	6.13	0.00
PX remote messages sent	3,742	6.12	0.00
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	1,833	3.00	0.00
Requests to/from client	6,986,427	11,433.70	5.33
RowCR - row contention	0	0.00	0.00
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment shrink	3	0.00	0.00
SQL*Net roundtrips to/from client	6,986,511	11,433.84	5.33
TBS Extension: tasks created	0	0.00	0.00
active txn count during cleanout	1,023,294	1,674.68	0.78
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	1	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	7,266	11.89	0.01
blocks cleaned out using minact	99,268	162.46	0.08
branch node splits	5	0.01	0.00
buffer is not pinned count	11,459,416	18,754.02	8.75
buffer is pinned count	1,677,602	2,745.50	1.28
bytes received via SQL*Net from client	2,183,823,434	3,573,956.83	1,667.36
bytes sent via SQL*Net to client	2,356,135,641	3,855,956.00	1,798.92
calls to get snapshot scn: kcmgss	23,036,711	37,700.95	17.59
calls to kcmgas	2,563,890	4,195.96	1.96
calls to kcmgcs	5,594,189	9,155.22	4.27
cell IO uncompressed bytes	0	0.00	0.00
cell blocks helped by minscn optimization	0	0.00	0.00
cell blocks processed by cache layer	0	0.00	0.00
cell blocks processed by data layer	0	0.00	0.00
cell blocks processed by txn layer	0	0.00	0.00
cell flash cache read hits	13,692	22.41	0.01
cell flash cache read hits for controlfile reads	2,849	4.66	0.00
cell flash cache read hits for smart IO	0	0.00	0.00
cell logical write IO requests	1,209,429	1,979.30	0.92
cell logical write IO requests eligible for offload	0	0.00	0.00
cell num smartio automem buffer allocation attempts	0	0.00	0.00
cell overwrites in flash cache	140,657	230.19	0.11
cell partial writes in flash cache	0	0.00	0.00
cell physical IO bytes eligible for predicate offload	0	0.00	0.00
cell physical IO bytes eligible for smart IOs	0	0.00	0.00
cell physical IO bytes saved during optimized file creation	0	0.00	0.00
cell physical IO interconnect bytes	12,149,282,816	19,883,023.34	9,276.02
cell physical IO interconnect bytes returned by smart scan	0	0.00	0.00
cell physical write IO bytes eligible for offload	0	0.00	0.00
cell physical write IO host network bytes written during offloa	0	0.00	0.00
cell physical write bytes saved by smart file initialization	0	0.00	0.00
cell scans	0	0.00	0.00
cell smart IO session cache hits	0	0.00	0.00
cell smart IO session cache hwm	0	0.00	0.00
cell smart IO session cache lookups	0	0.00	0.00
cell writes to flash cache	140,855	230.52	0.11
change write time	7,167	11.73	0.01
cleanout - number of ktugct calls	500,137	818.50	0.38
cleanouts and rollbacks - consistent read gets	48,638	79.60	0.04
cleanouts only - consistent read gets	1,176	1.92	0.00
cluster key scan block gets	57,849	94.67	0.04
cluster key scans	32,438	53.09	0.02
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	1,309,728	2,143.45	1.00
commit batch/immediate requested	1,309,728	2,143.45	1.00
commit cleanout failures: block lost	15	0.02	0.00
commit cleanout failures: buffer being written	11	0.02	0.00
commit cleanout failures: callback failure	17,536	28.70	0.01
commit cleanout failures: cannot pin	2,769	4.53	0.00
commit cleanouts	4,158,102	6,804.98	3.17
commit cleanouts successfully completed	4,137,771	6,771.71	3.16
commit immediate performed	1,309,727	2,143.45	1.00
commit immediate requested	1,309,728	2,143.45	1.00
commit txn count during cleanout	43,031	70.42	0.03
commit wait performed	1,309,724	2,143.44	1.00
commit wait requested	1,309,724	2,143.44	1.00
commit wait/nowait performed	1,309,724	2,143.44	1.00
commit wait/nowait requested	1,309,724	2,143.44	1.00
consistent changes	99,847	163.41	0.08
consistent gets	14,573,236	23,849.97	11.13
consistent gets direct	0	0.00	0.00
consistent gets examination	11,143,393	18,236.82	8.51
consistent gets examination (fastpath)	11,141,368	18,233.51	8.51
consistent gets from cache	14,573,236	23,849.97	11.13
consistent gets pin	3,429,843	5,613.14	2.62
consistent gets pin (fastpath)	2,992,691	4,897.72	2.28
cursor authentications	2,895	4.74	0.00
cursor reload failures	19	0.03	0.00
data blocks consistent reads - undo records applied	99,616	163.03	0.08
db block changes	13,581,403	22,226.77	10.37
db block gets	12,260,299	20,064.71	9.36
db block gets direct	294	0.48	0.00
db block gets from cache	12,260,005	20,064.23	9.36
db block gets from cache (fastpath)	10,831,393	17,726.22	8.27
deferred (CURRENT) block cleanout applications	1,848,659	3,025.44	1.41
dirty buffers inspected	3,533	5.78	0.00
enqueue conversions	8,593	14.06	0.01
enqueue releases	5,638,624	9,227.94	4.31
enqueue requests	5,638,628	9,227.95	4.31
enqueue timeouts	4	0.01	0.00
enqueue waits	4,127	6.75	0.00
exchange deadlocks	0	0.00	0.00
execute count	5,009,443	8,198.25	3.82
failed probes on index block reclamation	0	0.00	0.00
fastpath consistent get quota limit	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	131,023	214.43	0.10
free buffer requested	173,286	283.59	0.13
gc blocks compressed	0	0.00	0.00
gc cleanout applied	0	0.00	0.00
gc cleanout saved	15	0.02	0.00
gc cr anti locks created	0	0.00	0.00
gc cr block build time	0	0.00	0.00
gc cr block flush time	0	0.00	0.00
gc cr block receive time	25	0.04	0.00
gc cr blocks built	116	0.19	0.00
gc cr blocks flushed	0	0.00	0.00
gc cr blocks received	2,746	4.49	0.00
gc cr blocks received with BPS	11	0.02	0.00
gc cr blocks served	187	0.31	0.00
gc cr blocks served with BPS	0	0.00	0.00
gc cr multiblock grant time	0	0.00	0.00
gc cr multiblock grants received	5	0.01	0.00
gc current block flush time	0	0.00	0.00
gc current block pin time	0	0.00	0.00
gc current block receive time	122	0.20	0.00
gc current blocks flushed	0	0.00	0.00
gc current blocks pinned	0	0.00	0.00
gc current blocks received	9,013	14.75	0.01
gc current blocks received with BPS	13	0.02	0.00
gc current blocks served	191	0.31	0.00
gc current blocks served with BPS	8	0.01	0.00
gc force cr read cr	427	0.70	0.00
gc force cr read current	592	0.97	0.00
gc index split wait timeouts	0	0.00	0.00
gc kbytes saved	0	0.00	0.00
gc kbytes sent	3,024	4.95	0.00
gc local grants	109,336	178.93	0.08
gc merge pi bg	2	0.00	0.00
gc merge pi fg	19	0.03	0.00
gc read time waited	0	0.00	0.00
gc read waits	0	0.00	0.00
gc reader bypass grants	19	0.03	0.00
gc reader bypass waits	5	0.01	0.00
gc remote grants	3,094	5.06	0.00
gc status messages received	991	1.62	0.00
gc status messages sent	267	0.44	0.00
gcs affinity lock failures	50	0.08	0.00
gcs affinity lock grants	106,403	174.13	0.08
gcs anti-locks created	0	0.00	0.00
gcs messages sent	2,388,395	3,908.75	1.82
gcs read-mostly lock failures	0	0.00	0.00
gcs read-mostly lock grants	0	0.00	0.00
ges messages sent	8,973	14.68	0.01
global enqueue CPU used by this session	0	0.00	0.00
global enqueue get time	117,931	193.00	0.09
global enqueue gets async	206	0.34	0.00
global enqueue gets sync	92,707,104	151,720.69	70.78
global enqueue releases	92,697,889	151,705.60	70.78
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	21,410	35.04	0.02
hot buffers moved to head of LRU	47,192	77.23	0.04
immediate (CR) block cleanout applications	49,814	81.52	0.04
immediate (CURRENT) block cleanout applications	8,597	14.07	0.01
index crx upgrade (positioned)	60	0.10	0.00
index fast full scans (full)	95	0.16	0.00
index fetch by key	2,684,486	4,393.32	2.05
index reclamation/extension switch	0	0.00	0.00
index scans kdiixs1	389,305	637.12	0.30
index split cancel op set	0	0.00	0.00
index split cancel wait clean	0	0.00	0.00
index split cancel wait noclean	0	0.00	0.00
leaf node 90-10 splits	35	0.06	0.00
leaf node splits	3,005	4.92	0.00
lob reads	0	0.00	0.00
lob writes	0	0.00	0.00
lob writes unaligned	0	0.00	0.00
logical read bytes from cache	219,817,910,272	359,745,073.58	167,831.70
logons cumulative	1,913	3.13	0.00
max cf enq hold time	0	0.00	0.00
messages received	1,273,654	2,084.41	0.97
messages sent	1,273,654	2,084.41	0.97
min active SCN optimization applied on CR	0	0.00	0.00
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	3,362,136	5,502.34	2.57
non-idle wait count	38,481,208	62,976.78	29.38
opened cursors cumulative	5,009,715	8,198.70	3.82
parse count (describe)	76	0.12	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	4,264,108	6,978.47	3.26
parse count (total)	4,276,560	6,998.84	3.27
parse time cpu	832,170	1,361.90	0.64
parse time elapsed	5,311,208	8,692.11	4.06
physical read IO requests	10,846	17.75	0.01
physical read bytes	88,858,624	145,422.42	67.84
physical read partial requests	0	0.00	0.00
physical read requests optimized	13,695	22.41	0.01
physical read snap IO requests no data	0	0.00	0.00
physical read total IO requests	13,718	22.45	0.01
physical read total bytes	135,649,280	221,998.11	103.57
physical read total bytes optimized	135,528,448	221,800.36	103.48
physical read total multi block requests	0	0.00	0.00
physical reads	10,847	17.75	0.01
physical reads cache	10,847	17.75	0.01
physical reads cache prefetch	1	0.00	0.00
physical reads direct	0	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	68,367	111.89	0.05
physical write bytes	3,420,110,848	5,597,214.65	2,611.27
physical write requests optimized	94,302	154.33	0.07
physical write total IO requests	1,216,029	1,990.10	0.93
physical write total bytes	5,998,780,416	9,817,360.65	4,580.09
physical write total bytes optimized	3,496,183,296	5,721,711.74	2,669.35
physical write total multi block requests	17,806	29.14	0.01
physical writes	417,495	683.26	0.32
physical writes direct	294	0.48	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	417,200	682.77	0.32
physical writes non checkpoint	167,594	274.28	0.13
pinned buffers inspected	0	0.00	0.00
pinned cursors current	5	0.01	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	611	1.00	0.00
queries parallelized	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	6,671,676	10,918.59	5.09
recursive cpu usage	767,856	1,256.64	0.59
redo KB read	0	0.00	0.00
redo blocks checksummed by FG (exclusive)	97,391	159.39	0.07
redo blocks written	5,004,612	8,190.34	3.82
redo blocks written (group 0)	4,137,186	6,770.75	3.16
redo blocks written (group 1)	867,426	1,419.59	0.66
redo buffer allocation retries	0	0.00	0.00
redo entries	6,941,200	11,359.69	5.30
redo log space requests	0	0.00	0.00
redo ordering marks	0	0.00	0.00
redo size	2,117,159,944	3,464,858.07	1,616.46
redo size for direct writes	912	1.49	0.00
redo subscn max counts	201	0.33	0.00
redo synch long waits	25,913	42.41	0.02
redo synch poll writes	0	0.00	0.00
redo synch polls	0	0.00	0.00
redo synch time	60,355	98.77	0.05
redo synch time (usec)	603,536,557	987,723.44	460.80
redo synch time overhead (usec)	101,133,626	165,511.19	77.22
redo synch time overhead count ( 2ms)	1,308,912	2,142.11	1.00
redo synch time overhead count ( 8ms)	458	0.75	0.00
redo synch time overhead count ( 32ms)	1	0.00	0.00
redo synch time overhead count (128ms)	0	0.00	0.00
redo synch time overhead count (inf)	1	0.00	0.00
redo synch writes	1,309,743	2,143.47	1.00
redo wastage	361,752,360	592,029.24	276.20
redo write active strands	1,449,211	2,371.72	1.11
redo write broadcast ack count	7,594	12.43	0.01
redo write broadcast ack time	644,405	1,054.61	0.49
redo write broadcast lgwr post count	2	0.00	0.00
redo write finish time	357,681,155	585,366.47	273.09
redo write gather time	51,127,424	83,673.07	39.04
redo write info find	1,309,386	2,142.89	1.00
redo write info find fail	14	0.02	0.00
redo write issue time	97,896,957	160,214.19	74.74
redo write schedule time	53,133,632	86,956.35	40.57
redo write size count ( 4KB)	976,887	1,598.73	0.75
redo write size count ( 8KB)	146,837	240.31	0.11
redo write size count ( 16KB)	19,896	32.56	0.02
redo write size count ( 32KB)	2,715	4.44	0.00
redo write size count ( 128KB)	133	0.22	0.00
redo write size count ( 256KB)	2	0.00	0.00
redo write size count ( 512KB)	1	0.00	0.00
redo write size count (1024KB)	0	0.00	0.00
redo write size count (inf)	0	0.00	0.00
redo write time	36,441	59.64	0.03
redo write time (usec)	364,410,567	596,379.55	278.23
redo write total time	405,350,280	663,379.82	309.49
redo write worker delay (usec)	24,515,727	40,121.44	18.72
redo write worker delay count	1,146,471	1,876.27	0.88
redo writes	1,146,472	1,876.27	0.88
redo writes (group 0)	752,250	1,231.10	0.57
redo writes (group 1)	394,222	645.17	0.30
redo writes adaptive all	1,146,472	1,876.27	0.88
redo writes adaptive worker	1,146,472	1,876.27	0.88
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	3	0.00	0.00
rollbacks only - consistent read gets	661	1.08	0.00
root node splits	0	0.00	0.00
rows fetched via callback	2,630,177	4,304.44	2.01
saved cleanout failures: callback failure	0	0.00	0.00
saved cleanouts	0	0.00	0.00
saved cleanouts successfully completed	0	0.00	0.00
securefile allocation bytes	0	0.00	0.00
securefile allocation chunks	0	0.00	0.00
securefile bytes non-transformed	3,238	5.30	0.00
securefile direct read bytes	0	0.00	0.00
securefile direct read ops	0	0.00	0.00
securefile direct write bytes	0	0.00	0.00
securefile direct write ops	0	0.00	0.00
securefile number of non-transformed flushes	4	0.01	0.00
segment cfs allocations	0	0.00	0.00
segment chunks allocation from dispenser	0	0.00	0.00
segment dispenser allocations	0	0.00	0.00
segment dispenser load empty	0	0.00	0.00
segment dispenser load tasks	0	0.00	0.00
segment prealloc bytes	0	0.00	0.00
segment prealloc ops	3	0.00	0.00
segment prealloc tasks	0	0.00	0.00
segment prealloc time (ms)	174	0.28	0.00
segment prealloc ufs2cfs bytes	0	0.00	0.00
segment total chunk allocation	0	0.00	0.00
session connect time	0	0.00	0.00
session cursor cache hits	746,729	1,222.07	0.57
session logical reads	26,833,535	43,914.67	20.49
shared hash latch upgrades - no wait	478,938	783.81	0.37
shared hash latch upgrades - wait	2	0.00	0.00
shared io pool buffer get success	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	33,480	54.79	0.03
sorts (rows)	575,069	941.13	0.44
sql area evicted	4,261,205	6,973.72	3.25
sql area purged	2	0.00	0.00
summed dirty queue length	70,868	115.98	0.05
switch current caused by our pin	62	0.10	0.00
switch current to new buffer	163	0.27	0.00
table fetch by rowid	4,180,039	6,840.88	3.19
table fetch continued row	755	1.24	0.00
table scan blocks gotten	12,995	21.27	0.01
table scan disk non-IMC rows gotten	521,259	853.07	0.40
table scan rows gotten	521,259	853.07	0.40
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)	1,060	1.73	0.00
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	154	0.25	0.00
total number of cf enq holders	99	0.16	0.00
total number of times SMON posted	3	0.00	0.00
transaction lock background get time	0	0.00	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	1	0.00	0.00
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	593,876,640	971,914.41	453.43
user calls	11,252,820	18,415.91	8.59
user commits	1,309,752	2,143.49	1.00
user logons cumulative	0	0.00	0.00
user logouts cumulative	0	0.00	0.00
user rollbacks	0	0.00	0.00
workarea executions - multipass	0	0.00	0.00
workarea executions - optimal	18,725	30.64	0.01
write clones created in background	2	0.00	0.00
write clones created in foreground	45	0.07	0.00

Statistic	Begin Value	End Value
logons current	201	205
opened cursors current	1,649	1,654
session cursor cache count	7,223,795	7,226,387
session pga memory	1,288,401,504	1,304,110,624
session pga memory max	2,107,159,808	2,120,575,168
session uga memory	639,233,092,664	639,431,280,848
session uga memory max	2,747,605,245,128	2,748,273,317,920

Statistic	Total	per Hour
log switches (derived)	0	0.00

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Time
DBWR	0M	0.00	0M	3.2G	107.79	5.281M	0
LGWR	0M	0.00	0M	2.4G	1875.86	3.998M	0
Buffer Cache Reads	85M	17.66	.139M	0M	0.00	0M	10.8K	472.68us
Others	45M	4.70	.074M	16M	1.65	.026M	2342	366.44us
Direct Writes	0M	0.00	0M	1M	0.01	.002M	0
TOTAL:	130M	22.35	.213M	5.6G	1985.32	9.307M	13.1K	453.73us

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read
Data File	84M	17.68	.137M	3.2G	107.81	5.286M	79.88us
Log File	0M	0.00	0M	2.4G	1875.97	3.996M
Control File	45M	4.66	.074M	15M	1.61	.025M	11.95us
Other	0M	0.02	0M	0M	0.03	0M	750.00us
Temp File	0M	0.00	0M	0M	0.00	0M
TOTAL:	129M	22.36	.211M	5.6G	1985.42	9.307M	66.32us

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Time
DBWR (Data File)	0M	0.00	0M	3.2G	107.79	5.281M	0
DBWR	0M	0.00	0M	3.2G	107.79	5.281M	0
DBWR (Temp File)	0M	0.00	0M	0M	0.00	0M	0
LGWR (Log File)	0M	0.00	0M	2.4G	1875.87	3.996M	0
LGWR	0M	0.00	0M	2.4G	1875.87	3.996M	0
Buffer Cache Reads (Data File)	85M	17.67	.139M	0M	0.00	0M	10.8K	472.67us
Buffer Cache Reads	85M	17.67	.139M	0M	0.00	0M	10.8K	472.67us
Others	44M	4.68	.072M	16M	1.62	.026M	1982	328.82us
Others (Control File)	44M	4.66	.072M	15M	1.61	.025M	1971	328.48us
Others (Data File)	0M	0.02	0M	1M	0.01	.002M	11	390.55us
Direct Writes (Data File)	0M	0.00	0M	1M	0.01	.002M	0
Direct Writes	0M	0.00	0M	1M	0.01	.002M	0
TOTAL:	129M	22.35	.211M	5.6G	1985.30	9.305M	12.8K	450.36us

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	489,809	100	26,830,095	10,842	420,306	0	0	1,769

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	371,787	0

	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	174	221628	26720364	84934656	84934656	144668161			86
E	0	22	166011	2521422	84934656	84934656	129233024			10

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	416	0.10	49	12.34	278,124	1	545174.00
D	832	0.20	97	7.42	167,184	1	327570.00
D	1,248	0.30	146	3.35	75,520	1	147776.00
D	1,664	0.39	194	1.68	37,744	1	73680.00
D	2,080	0.49	243	1.34	30,299	1	59077.00
D	2,496	0.59	292	1.20	27,038	1	52680.00
D	2,912	0.69	340	1.13	25,380	1	49429.00
D	3,328	0.79	389	1.08	24,284	1	47278.00
D	3,744	0.89	437	1.04	23,412	1	45568.00
D	4,160	0.98	486	1.00	22,641	1	44056.00
D	4,224	1.00	494	1.00	22,531	1	43841.00
D	4,576	1.08	535	0.97	21,928	1	42657.00
D	4,992	1.18	583	0.94	21,238	1	41305.00
D	5,408	1.28	632	0.91	20,536	1	39928.00
D	5,824	1.38	680	0.88	19,777	1	38439.00
D	6,240	1.48	729	0.84	18,892	1	36702.00
D	6,656	1.58	778	0.80	17,996	1	34946.00
D	7,072	1.67	826	0.77	17,349	1	33676.00
D	7,488	1.77	875	0.76	17,161	1	33306.00
D	7,904	1.87	924	0.76	17,149	1	33283.00
D	8,320	1.97	972	0.76	17,141	1	33269.00

	Begin	End
Number of Instances:	2	2
Number of LMS's:	3	3
Number of realtime LMS's:	3	3	(0 priority changes)

	Per Second	Per Transaction
Global Cache blocks received:	19.24	0.01
Global Cache blocks served:	0.62	0.00
GCS/GES messages received:	1,716.71	0.80
GCS/GES messages sent:	3,923.87	1.83
DBWR Fusion writes:	0.06	0.00
Estd Interconnect traffic (KB)	1,260.58

Buffer access - local cache %:	99.92
Buffer access - remote cache %:	0.04
Buffer access - disk %:	0.04
Global Cache Locality %:	97.25

Avg global cache cr block receive time (us):	91.0
Avg global cache current block receive time (us):	135.4
Avg LMS process busy %:	3.3
Avg global cache cr block build time (us):	0.0
Global cache log flushes for cr blocks served %:	0.0
Avg global cache cr block flush time (us):
Avg global cache current block pin time (us):
Global cache log flushes for current blocks served %:	0.0
Avg global cache current block flush time (us):
Avg global enqueue get time (us):	12.7

Avg message sent queue time (us):	80.6
Avg message sent queue time on ksxp (us):	11.0
Avg message received queue time (us):	7.3
Avg GCS message process time (us):	1.8
Avg GES message process time (us):	4.1
% of direct sent messages:	38.38
% of indirect sent messages:	61.62
% of flow controlled messages:	0.00

RAC Statistics

Global Messaging Statistics

Global CR Server Statistics

Global Current Server Statistics

Global Cache Transfer Statistics

Global Cache Transfer Times (us)

Global Cache Transfer (Immediate)

Global Cache Times (Immediate)

Interconnect Statistics

Interconnect Ping Latency Statistics

Interconnect Throughput by Client

Interconnect Device Statistics

Dynamic Remastering Statistics

Exadata Configuration and Statistics

Exadata Storage Server Model

Model Information of Servers
CPU Count refers to logical CPUs, including cores and hyperthreads

Model	CPU Count	Memory (GB)	# Cells	Cells
Oracle Corporation SUN SERVER X4-2L High Performance	24/24	94	7	scao08celadm01, scao08celadm02, scao08celadm03, scao08celadm04, scao08celadm05, scao08celadm06, scao08celadm07

Back to Exadata Server Configuration

Exadata Storage Server Version

Version information of packages on the storage server

Package Type	Package Version	Cells
Kernel	4.1.12-61.47.1.el6uek.x86_64	All (7)
Cell	cell-12.2.1.1.2_LINUX.X64_170714-1.x86_64	All (7)
Offload	cellofl-12.1.2.4.0_LINUX.X64_170701	All (7)
Offload	cellofl-12.2.1.1.2_LINUX.X64_170714	All (7)
Offload	cellofl-11.2.3.3.1_LINUX.X64_170621.1	All (7)

Back to Exadata Server Configuration

Exadata Storage Information

Storage information per cell
'Total' is the sum for all cells

# Cells	Flash Cache Size (GB)	Flash Log Size (GB)	Hard Disk	Flash	# Griddisks	Cell Name
			# Celldisks
7	2,945.25	2.00	12	16	98	All (7)
Total (7)	20,616.75	14.00	84	112	686	All (7)

Back to Exadata Server Configuration

Exadata Griddisks

Griddisks on the storage servervs
Disk Type <F|H>/<size>: F-Flash, H-Harddisk
Size (GB) - Griddisk: indicates size of individual Griddisks in the cells
Size (GB) - Cell Total: indicates total size per cell
Size (GB) - System Total: indicates total size over all cells

Griddisk Name Prefix	# Griddisks	Griddisk	Cell Total	System Total	Disk Type	Cells
		Size (GB)
CLUSTER	12	2.00	24.00	168.00	H/1.1T	All (7)
DATA_ALL	12	50.00	600.00	4,200.00	H/1.1T	All (7)
DATA_LOW7	12	433.00	5,196.00	36,372.00	H/1.1T	All (7)
DATA_TOP7	12	433.00	5,196.00	36,372.00	H/1.1T	All (7)
DBFS_DG	10	33.80	338.00	2,366.00	H/1.1T	All (7)
NOFLASH	12	25.00	300.00	2,100.00	H/1.1T	All (7)
RECO_ALL	12	20.00	240.00	1,680.00	H/1.1T	All (7)
flash	16	2.00	32.00	224.00	F/186G	All (7)

Back to Exadata Server Configuration

Exadata Celldisks

Celldisks on the storage servervs
Disk Type <F|H>/<size>: F-Flash, H-Harddisk
Celldisk Size indicates size of individual Celldisks in the cells, not the total size
System disks have the same disk type, but are smaller in size

Disk Type	Celldisk Size (GB)	# Celldisks	Cells
F/186G	186.25	16	All (7)
H/1.1T	1,116.64	10	All (7)
H/1.1T	1,082.84	2	All (7)

Back to Exadata Server Configuration

ASM Diskgroups

ASM Diskgroups at the end of the report period for the database

Disk Group	Size (GB)	Used (GB)	# Griddisks	Redundancy
DATA_ALL	4,200.00	2,706.35	84	NORMAL
DATA_TOP7	36,372.00	24,940.82	84	NORMAL
NOFLASH	2,100.00	417.82	84	NORMAL

Back to Exadata Server Configuration

Exadata Server Health Report

Exadata Alerts Summary
Exadata Alerts Detail
Exadata Non-Online Disks

Exadata Alerts Summary

No open alerts.

Back to Exadata Server Health Report

Exadata Alert Details

No open alerts.

Back to Exadata Server Health Report

Exadata Non-Online Disks

All disks were online at the end of the report period.

Back to Exadata Server Health Report

Exadata Statistics

Exadata Resource Statistics

Exadata Outlier Summary
Exadata OS Statistics Outliers

Exadata OS IO Statistics
Exadata OS IO Latency
Exadata OS CPU Statistics

Exadata Cell Server Statistics Outliers

Cell Server IOPS Statistics
Cell Server IO MB/s Statistics
Cell Server IO Latency Statistics

Exadata Outlier Details

Exadata OS Statistics Outlier Details
Exadata Cell Server Outlier Details

Exadata OS Statistics Top

Exadata OS IO Statistcs
Exadata OS IO Latency Statistics
Exadata OS CPU Statistics

Exadata Cell Server Statistics Top

Cell Server IOPS Statistics
Cell Server IO MB/s Statistics
Cell Server IO Latency

Exadata Smart Statistics

Smart IO
Flash Log
Flash Cache

Exadata IO Reasons

Top IO Reasons by Requests
Top IO Reasons by MB

Exadata Top Database Consumers

Top Databases by Requests
Top Databases by Throughput
Top Databases by Requests per Cell
Top Databases by Throughput per Cell

Exadata Resource Statistics

Exadata Outlier Summary
Exadata OS Statistics Outliers

Exadata OS IO Statistics
Exadata OS IO Latency
Exadata OS CPU Statistics

Exadata Cell Server Statistics Outliers

Cell Server IOPS Statistics
Cell Server IO MB/s Statistics
Cell Server IO Latency Statistics

Exadata Outlier Details

Exadata OS Statistics Outlier Details
Exadata Cell Server Outlier Details

Exadata OS Statistics Top

Exadata OS IO Statistcs
Exadata OS IO Latency Statistics
Exadata OS CPU Statistics

Exadata Cell Server Statistics Top

Cell Server IOPS Statistics
Cell Server IO MB/s Statistics
Cell Server IO Latency

Exadata Outlier Summary

Cell Level
Disk Level

Outlier Summary - Cell Level

Outliers are cells whose average performance is outside the normal range, where normal range is -/+ 1 standard deviation
Outlier cells must have a mininum of 10 IOPs. Idle cells are not considered for outlier analysis.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
A '*' and a dark red background indicates over maximum capacity
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
Maximum cell capacity for hard disks: IOPS: H/1.1T: 3,168 | IO MB/s: H/1.1T: 1,440
Maximum cell capacity for flash disks: IOPS: F/186G: 459,984 | IO MB/s: F/186G: 8,272
There is insufficient activity on Flash Disks, and Flash Disk outliers will not be displayed
There are no cell outliers on hard disks

Back to Exadata Outlier Summary
Back to Exadata Resource Statistics

Outlier Summary - Disk Level

Outliers are disks whose average performance is outside the normal range, where normal range is -/+ 3 standard deviation
Outlier disks must have a mininum of 10 IOPs. Idle disks are not considered for outlier analysis.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
A '*' and a dark red background indicates over maximum capacity
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
Maximum hard disk capacity: IOPS: H/1.1T: 264 | IO MB/s: H/1.1T: 120
Maximum flash disk capacity: IOPS: F/186G: 28,749 | IO MB/s: F/186G: 517
There is insufficient activity on Flash Disks, and Flash Disk outliers will not be displayed

Disk Name	Cell Name	Disk Type	Statistic Name	Value		Mean	Std Dev	Normal Range
CD_03_scao08celadm01	scao08celadm01	H/1.1T	% Disk Utilization	^	1.00	0.02	0.29	0.00 - 0.89
			Small Reads/s	^	84.20	2.44	20.34	0.00 - 63.47
			Small Read MB/s	^	0.33	0.01	0.08	0.00 - 0.24
CD_11_scao08celadm07	scao08celadm07	H/1.1T	Cell Server IO MB/s	^	0.80	0.20	0.17	0.00 - 0.70

Back to Exadata Outlier Summary
Back to Exadata Resource Statistics

Exadata OS Statistics Outliers

Exadata OS IO Statistics

Outlier Cells
Outlier Disks

Exadata OS IO Latency

Outlier Cells
Outlier Disks

Exadata OS CPU Statistics - Outlier Cells

Exadata OS IO Statistics - Outlier Cells

These statistics are collected by the OS on the cells and are not restricted to this database or instance
Outliers are cells whose average performance is outside the normal range, where normal range is -/+ 1 standard deviation
Outlier cells must have a mininum of 10 IOPs. Idle cells are not considered for outlier analysis.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
A '*' and a dark red background indicates over maximum capacity
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
%Total - Avg [IOPs |IO MB/s] of the cell as a percentage of total [IOPs | IO MB/s] for the disk type
There are no cell outliers on hard disks

Disk Type	Cell Name	# Cells	# Disks	Total	% Total	Average	Mean	Std Dev	Normal Range	Total	% Total	Average	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range
				IOPs						IO MB/s						% Disk Utilization
				Total	% Total	Per Cell	Per Disk			Total	% Total	Per Cell	Per Disk			% Disk Utilization
F/186G	All	7	112	5,134.65		733.52	45.85	30.54	15.30 - 76.39	1.28		0.18	0.01	0.14	0.00 - 0.15	0.02	0.16	0.00 - 0.18
H/1.1T	All	7	84	3,980.73		568.68	47.39	35.56	11.83 - 82.95	0.49		0.07	0.01	0.10	0.00 - 0.11	0.02	0.29	0.00 - 0.31

Exadata OS IO Statistics - Outlier Disks

These statistics are collected by the OS on the cells and are not restricted to this database or instance
Outliers are disks whose average performance is outside the normal range, where normal range is -/+ 3 standard deviation
Outlier disks must have a mininum of 10 IOPs. Idle disks are not considered for outlier analysis.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
A '*' and a dark red background indicates over maximum capacity
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
% Total - Avg [IOPs |IO MB/s] of the disk as a percentage of total [IOPs | IO MB/s] for the disk type

Disk Type	Cell Name	Disk Name	# Disks	% Total	Mean	Std Dev	Normal Range	% Total	Mean	Std Dev	Normal Range	Mean		Std Dev	Normal Range
				IOPs				IO MB/s				% Disk Utilization
F/186G	All	All	112		45.85	30.54	0.00 - 137.47		0.01	0.14	0.00 - 0.44	0.02		0.16	0.00 - 0.50
H/1.1T	All	All	84		47.39	35.56	0.00 - 154.08		0.01	0.10	0.00 - 0.31	0.02		0.29	0.00 - 0.89
Outlier	scao08celadm01	CD_03_scao08celadm01		2.97	118.10			42.31	0.20			^	1.00

Back to Exadata OS Statistics Outliers
Back to Exadata Resource Statistics

Exadata OS IO Latency - Outlier Cells

These statistics are collected by the OS on the cells and are not restricted to this database or instance
Outliers are cells whose average performance is outside the normal range, where normal range is -/+ 1 standard deviation
Outlier cells must have a mininum of 10 IOPs. Idle cells are not considered for outlier analysis.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
There are no cell outliers on hard disks

Disk Type	Cell Name	# Cells	# Disks	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range
				Avg Service Time			Avg Wait Time
F/186G	All	7	112	72.43us	17.04us	55.40us - 89.47us	79.41us	25.82us	53.59us - 105.22us
H/1.1T	All	7	84	73.89us	291.51us	0.00us - 365.40us	185.93us	868.05us	0.00us - 1,053.98us

Exadata OS IO Latency - Outlier Disks

These statistics are collected by the OS on the cells and are not restricted to this database or instance
Outliers are disks whose average performance is outside the normal range, where normal range is -/+ 3 standard deviation
Outlier disks must have a mininum of 10 IOPs. Idle disks are not considered for outlier analysis.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk

Disk Type	Cell Name	Disk Name	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range
			Avg Service Time			Avg Wait Time
F/186G	All	All	72.43us	17.04us	21.32us - 123.54us	79.41us	25.82us	1.95us - 156.86us
H/1.1T	All	All	73.89us	291.51us	0.00us - 948.41us	185.93us	868.05us	0.00us - 2,790.09us

Back to Exadata OS Statistics Outliers
Back to Exadata Resource Statistics

Exadata OS CPU Statistics - Outlier Cells

These statistics are collected by the OS on the cells and are not restricted to this database or instance
Outliers are cells whose average performance is outside the normal range, where normal range is -/+ 1 standard deviation
Outlier cells must have a mininum of 10 IOPs. Idle cells are not considered for outlier analysis.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Outliers for CPU are displayed when CPU exceeds 20%
Outliers for CPU will not be displayed. The mean CPU usage is only 2.03%

Cell Name	# Cells	Mean		Std Dev	Normal Range	Mean		Std Dev	Normal Range	Mean		Std Dev	Normal Range
		% CPU Usage				% User CPU				% System CPU
All	7	2.03		0.29	1.74 - 2.32	1.04		0.20	0.84 - 1.24	0.99		0.21	0.78 - 1.19

Back to Exadata OS Statistics Outliers
Back to Exadata Resource Statistics

Exadata Cell Server Statistics Outliers

Cell Server IOPS Statistics

Outlier Cells
Outlier Disks

Cell Server IO MB/s Statistics

Outlier Cells
Outlier Disks

Cell Server IO Latency Statistics

Outlier Cells
Outlier Disks

Exadata Cell Server IOPS Statistics - Outlier Cells

These statistics are collected by the cells and are not restricted to this database or instance
Outliers are cells whose average performance is outside the normal range, where normal range is -/+ 1 standard deviation
Outlier cells must have a mininum of 10 IOPs. Idle cells are not considered for outlier analysis.
Outliers for small reads, small writes, large read, large writes, must have a minimum of 10 requests for the corresponding small read, small write, large read, large write statistic.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
% Total - Avg IOPs of the cell as a percentage of total IOPs for the disk type
There are no cell outliers on hard disks

Disk Type	Cell Name	# Cells	# Disks	Total	% Total	Average	Mean	Std Dev	Normal Range	Average	Mean	Std Dev	Normal Range	Average	Mean	Std Dev	Normal Range	Average	Mean	Std Dev	Normal Range	Average	Mean	Std Dev	Normal Range
				IOPs						Small Reads/s				Small Writes/s				Large Reads/s				Large Writes/s
				Total	% Total	Per Cell	Per Disk			Per Cell	Per Disk			Per Cell	Per Disk			Per Cell	Per Disk			Per Cell	Per Disk
F/186G	All	7	112	5,000.66		714.38	44.65	30.49	14.16 - 75.14	117.54	7.35	29.72	0.00 - 37.06	577.49	36.09	8.09	28.00 - 44.19	7.00	0.44	1.81	0.00 - 2.25	12.35	0.77	0.68	0.09 - 1.45
H/1.1T	All	7	84	3,976.10		568.01	47.33	35.35	11.99 - 82.68	29.30	2.44	20.34	0.00 - 22.78	538.68	44.89	29.27	15.62 - 74.16	0.04	0.00	0.08	0.00 - 0.08	0.00	0.00	0.00	0.00 - 0.00

Exadata Cell Server IOPS Statistics - Outlier Disks

These statistics are collected by the cells and are not restricted to this database or instance
Outliers are disks whose average performance is outside the normal range, where normal range is -/+ 3 standard deviation
Outlier disks must have a mininum of 10 IOPs. Idle disks are not considered for outlier analysis.
Outliers for small reads, small writes, large read, large writes, must have a minimum of 10 requests for the corresponding small read, small write, large read, large write statistic.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
% Total - Avg IOPs of the disk as a percentage of total IOPs for the disk type

Disk Type	Cell Name	Disk Name	% Total	Mean	Std Dev	Normal Range	Mean		Std Dev	Normal Range	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range
			IOPs				Small Reads/s				Small Writes/s			Large Reads/s			Large Writes/s
F/186G	All	All		44.65	30.49	0.00 - 136.12	7.35		29.72	0.00 - 96.49	36.09	8.09	11.81 - 60.37	0.44	1.81	0.00 - 5.88	0.77	0.68	0.00 - 2.81
H/1.1T	All	All		47.33	35.35	0.00 - 153.38	2.44		20.34	0.00 - 63.47	44.89	29.27	0.00 - 132.71	0.00	0.08	0.00 - 0.23	0.00	0.00	0.00 - 0.00
Outlier	scao08celadm01	CD_03_scao08celadm01	2.97	118.10			^	84.20			33.90			0.00			0.00

Back to Exadata Cell Server Statistics Outliers
Back to Exadata Resource Statistics

Exadata Cell Server IO MB/s Statistics - Outlier Cells

These statistics are collected by the cells and are not restricted to this database or instance
Outliers are cells whose average performance is outside the normal range, where normal range is -/+ 1 standard deviation
Outlier cells must have a mininum of 10 IOPs. Idle cells are not considered for outlier analysis.
Outliers for small reads, small writes, large read, large writes, must have a minimum of 10 requests for the corresponding small read, small write, large read, large write statistic.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
% Total - Avg IO MB/s of the cell as a percentage of total IO MB/s for the disk type
There are no cell outliers on hard disks

Disk Type	Cell Name	# Cells	# Disks	Total	% Total	Average	Mean	Std Dev	Normal Range	Average	Mean	Std Dev	Normal Range	Average	Mean	Std Dev	Normal Range	Average	Mean	Std Dev	Normal Range	Average	Mean	Std Dev	Normal Range
				IO MB/s						Small Reads/s				Small Writes/s				Large Reads/s				Large Writes/s
				Total	% Total	Per Cell	Per Disk			Per Cell	Per Disk			Per Cell	Per Disk			Per Cell	Per Disk			Per Cell	Per Disk
F/186G	All	7	112	39.31		5.62	0.35	0.23	0.12 - 0.58	0.80	0.05	0.18	0.00 - 0.23	3.08	0.19	0.04	0.15 - 0.23	0.61	0.04	0.15	0.00 - 0.19	1.13	0.07	0.03	0.04 - 0.10
H/1.1T	All	7	84	16.80		2.40	0.20	0.17	0.03 - 0.37	0.06	0.01	0.08	0.00 - 0.08	1.16	0.10	0.06	0.03 - 0.16	1.18	0.10	0.12	0.00 - 0.22	0.00	0.00	0.00	0.00 - 0.00

Exadata Cell Server IO MB/s Statistics - Outlier Disks

These statistics are collected by the cells and are not restricted to this database or instance
Outliers are disks whose average performance is outside the normal range, where normal range is -/+ 3 standard deviation
Outlier disks must have a mininum of 10 IOPs. Idle disks are not considered for outlier analysis.
Outliers for small reads, small writes, large read, large writes, must have a minimum of 10 requests for the corresponding small read, small write, large read, large write statistic.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
% Total - Avg IO MB/s of the disk as a percentage of total IO MB/s for the disk type

Disk Type	Cell Name	Disk Name	% Total	Mean		Std Dev	Normal Range	Mean		Std Dev	Normal Range	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range
			IO MB/s					Small Reads/s				Small Writes/s			Large Reads/s			Large Writes/s
F/186G	All	All		0.35		0.23	0.00 - 1.05	0.05		0.18	0.00 - 0.58	0.19	0.04	0.07 - 0.32	0.04	0.15	0.00 - 0.48	0.07	0.03	0.00 - 0.16
H/1.1T	All	All		0.20		0.17	0.00 - 0.70	0.01		0.08	0.00 - 0.24	0.10	0.06	0.00 - 0.28	0.10	0.12	0.00 - 0.47	0.00	0.00	0.00 - 0.01
Outlier	scao08celadm07	CD_11_scao08celadm07	4.78	^	0.80			0.00				0.11			0.69			0.00
Outlier	scao08celadm01	CD_03_scao08celadm01	2.82	0.47				^	0.33			0.07			0.07			0.00

Back to Exadata Cell Server Statistics Outliers
Back to Exadata Resource Statistics

Exadata Cell Server IO Latency - Outlier Cells

These statistics are collected by the cells and are not restricted to this database or instance
Outliers are cells whose average performance is outside the normal range, where normal range is -/+ 1 standard deviation
Outlier cells must have a mininum of 10 IOPs. Idle cells are not considered for outlier analysis.
Outliers for small reads, small writes, large read, large writes, must have a minimum of 10 requests for the corresponding small read, small write, large read, large write statistic.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
There are no cell outliers on hard disks

Disk Type	Cell Name	# Cells	# Disks	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range
				Cell Latency			Small Read			Small Write			Large Read			Large Write
F/186G	All	7	112	97.79us	25.81us	71.98us - 123.60us	117.77us	120.86us	0.00us - 238.63us	91.18us	20.97us	70.21us - 112.15us	89.01us	253.35us	0.00us - 342.36us	197.94us	41.58us	156.36us - 239.52us
H/1.1T	All	7	84	146.26us	290.90us	0.00us - 437.17us	715.83us	1,803.81us	0.00us - 2,519.64us	152.43us	291.81us	0.00us - 444.24us	1,262.66us	1,797.14us	0.00us - 3,059.80us	3.42us	25.22us	0.00us - 28.64us

Exadata Cell Server IO Latency - Outlier Disks

These statistics are collected by the cells and are not restricted to this database or instance
Outliers are disks whose average performance is outside the normal range, where normal range is -/+ 3 standard deviation
Outlier disks must have a mininum of 10 IOPs. Idle disks are not considered for outlier analysis.
Outliers for small reads, small writes, large read, large writes, must have a minimum of 10 requests for the corresponding small read, small write, large read, large write statistic.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk

Disk Type	Cell Name	Disk Name	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range	Mean	Std Dev	Normal Range
			Cell Latency			Small Read			Small Write			Large Read			Large Write
F/186G	All	All	97.79us	25.81us	20.36us - 175.22us	117.77us	120.86us	0.00us - 480.35us	91.18us	20.97us	28.28us - 154.08us	89.01us	253.35us	0.00us - 849.07us	197.94us	41.58us	73.20us - 322.68us
H/1.1T	All	All	146.26us	290.90us	0.00us - 1,018.97us	715.83us	1,803.81us	0.00us - 6,127.25us	152.43us	291.81us	0.00us - 1,027.87us	1,262.66us	1,797.14us	0.00us - 6,654.09us	3.42us	25.22us	0.00us - 79.09us

Back to Exadata Cell Server Statistics Outliers
Back to Exadata Resource Statistics

Exadata Outlier Details

Exadata OS Statistics Outlier Details

Cell Outliers
Disk Outliers

Exadata Cell Server Outlier Details

Cell Outliers
Disk Outliers

Exadata OS IO Statistics Details for Outlier Cells

No data exists for this section of the report.

Exadata OS IO Statistics Details for Outlier Disks

These statistics are collected by the OS on the cells and are not restricted to this database or instance
Outliers are disks whose average performance is outside the normal range, where normal range is -/+ 3 standard deviation
Outlier disks must have a mininum of 10 IOPs. Idle disks are not considered for outlier analysis.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
Only disks with outliers in an OS IO statistic are displayed

Disk Type	Disk Name	Cell Name	Mean	Std Dev	Range	Mean	Std Dev	Range	Mean		Std Dev	Range	Mean	Std Dev	Range	Mean	Std Dev	Range
			IOPs			IO MB/s			% Disk Utilization				Avg Service Time			Avg Wait Time
F/186G	All	All	45.85	30.54	0.00 - 137.47	0.01	0.14	0.00 - 0.44	0.02		0.16	0.00 - 0.50	72.43us	17.04us	21.32us - 123.54us	79.41us	25.82us	1.95us - 156.86us
H/1.1T	All	All	47.39	35.56	0.00 - 154.08	0.01	0.10	0.00 - 0.31	0.02		0.29	0.00 - 0.89	73.89us	291.51us	0.00ns - 948.41us	185.93us	868.05us	0.00ns - 2.79ms
H/1.1T	CD_03_scao08celadm01	scao08celadm01	118.10			0.20			^	1.00			104.70us			132.30us

Back to Exadata Outlier Details
Back to Exadata Resource Statistics

Exadata Cell Server Details for Outlier Cells

No data exists for this section of the report.

Exadata Cell Server Details for Outlier Disks

These statistics are collected by the cells and are not restricted to this database or instance
Outliers are disks whose average performance is outside the normal range, where normal range is -/+ 3 standard deviation
Outlier disks must have a mininum of 10 IOPs. Idle disks are not considered for outlier analysis.
Outliers for small reads, small writes, large read, large writes, must have a minimum of 10 requests for the corresponding small read, small write, large read, large write statistic.
Outliers for hard disks are displayed when Hard Disk IOPs exceeds 221.76 (1% of maximum capacity of 22,176)
Outliers for flash disks are displayed when Flash Disk IOPs exceeds 32198.88 (1% of maximum capacity of 3,219,888)
Outliers for flash disks will not be displayed. There are only 5,130 flash IOPs
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
Only disks with outliers in a cell server statistic are displayed

Disk Type	Disk Name	Cell Name	Statistic	per Disk		Std Dev	Range	per Disk		Std Dev	Range	per Disk	Std Dev	Range	per Disk	Std Dev	Range	per Disk	Std Dev	Range
				I/O				Small Read				Small Write			Large Read			Large Write
F/186G	All	All	Cell Server IOPs	44.65		30.49	0.00 - 136.12	7.35		29.72	0.00 - 96.49	36.09	8.09	11.81 - 60.37	0.44	1.81	0.00 - 5.88	0.77	0.68	0.00 - 2.81
			Cell Server IO MB/s	0.35		0.23	0.00 - 1.05	0.05		0.18	0.00 - 0.58	0.19	0.04	0.07 - 0.32	0.04	0.15	0.00 - 0.48	0.07	0.03	0.00 - 0.16
			Cell Server IO Latency	97.79us		25.81us	20.36us - 175.22us	117.77us		120.86us	0.00ns - 480.35us	91.18us	20.97us	28.28us - 154.08us	89.01us	253.35us	0.00ns - 849.07us	197.94us	41.58us	73.20us - 322.68us
H/1.1T	All	All	Cell Server IOPs	47.33		35.35	0.00 - 153.38	2.44		20.34	0.00 - 63.47	44.89	29.27	0.00 - 132.71	0.00	0.08	0.00 - 0.23	0.00	0.00	0.00 - 0.00
			Cell Server IO MB/s	0.20		0.17	0.00 - 0.70	0.01		0.08	0.00 - 0.24	0.10	0.06	0.00 - 0.28	0.10	0.12	0.00 - 0.47	0.00	0.00	0.00 - 0.01
			Cell Server IO Latency	146.26us		290.90us	0.00ns - 1.02ms	715.83us		1.80ms	0.00ns - 6.13ms	152.43us	291.81us	0.00ns - 1.03ms	1.26ms	1.80ms	0.00ns - 6.65ms	3.42us	25.22us	0.00ns - 79.09us
H/1.1T	CD_03_scao08celadm01	scao08celadm01	Cell Server IOPs	118.10				^	84.20			33.90			0.00			0.00
			Cell Server IO MB/s	0.47				^	0.33			0.07			0.07			0.00
			Cell Server IO Latency	155.08us				178.50us				87.60us			833.10us			0.00ns
H/1.1T	CD_11_scao08celadm07	scao08celadm07	Cell Server IOPs	51.55				0.00				51.27			0.27			0.00
			Cell Server IO MB/s	^	0.80			0.00				0.11			0.69			0.00
			Cell Server IO Latency	179.69us				1.68ms				139.09us			6.24ms			0.00ns

Back to Exadata Outlier Details
Back to Exadata Resource Statistics

Exadata OS Statistics Top

Exadata OS IO Statistcs

Top Cells
Top Disks

Exadata OS IO Latency Statistics

Top Cells
Top Disks

Exadata OS CPU Statistics - Top Cells

Exadata OS IO Statistics - Top Cells

These statistics are collected by the OS on the cells and are not restricted to this database or instance
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
A '*' and a dark red background indicates over maximum capacity
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
Maximum cell capacity for hard disks: IOPS: H/1.1T: 3,168 | IO MB/s: H/1.1T: 1,440
Maximum cell capacity for flash disks: IOPS: F/186G: 459,984 | IO MB/s: F/186G: 8,272
Within each disk type, the top cells by Avg IOPs are displayed
%Total - Avg [IOPs | IO MB/s] as a percentage of total [IOPs | IO MB/s] for the disk type
Ordered by Disk Type, IOPs desc
F/186G Average: 733.52 IOPs, 0.18 IO MB/s, 0.02 % Disk Utilization
H/1.1T Average: 568.68 IOPs, 0.07 IO MB/s, 0.02 % Disk Utilization

Disk Type	Cell Name	%Total	Avg	%Total	Avg	Avg
		IOPs		IO MB/s		%Disk Utilization
F/186G	scao08celadm03	16.59	851.30	0.00	0.00	0.03
	scao08celadm05	15.47	793.50	0.00	0.00	0.05
	scao08celadm07	15.19	779.36	0.00	0.00	0.03
	scao08celadm01	13.92	714.20	61.54	0.80	0.03
	scao08celadm04	13.21	677.50	38.46	0.50	0.03
	scao08celadm06	13.06	670.00	0.00	0.00	0.00
	scao08celadm02	12.56	644.20	0.00	0.00	0.00
H/1.1T	scao08celadm01	15.23	606.70	42.31	0.20	0.09
	scao08celadm06	15.23	606.40	0.00	0.00	0.00
	scao08celadm05	14.35	571.50	0.00	0.00	0.00
	scao08celadm02	14.19	564.90	0.00	0.00	0.00
	scao08celadm07	13.88	552.82	57.69	0.27	0.02
	scao08celadm03	13.75	547.40	0.00	0.00	0.01
	scao08celadm04	13.37	532.60	0.00	0.00	0.00

Exadata OS IO Statistics - Top Disks

These statistics are collected by the OS on the cells and are not restricted to this database or instance
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
A '*' and a dark red background indicates over maximum capacity
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
Maximum hard disk capacity: IOPS: H/1.1T: 264 | IO MB/s: H/1.1T: 120
Maximum flash disk capacity: IOPS: F/186G: 28,749 | IO MB/s: F/186G: 517
Within each disk type, the top disks by Avg IOPs are displayed
%Total - Avg [IOPs | IO MB/s] as a percentage of the total [IOPs | IO MB/s] for the disk type
Ordered by Disk Type, IOPs desc
F/186G Average: 45.85 IOPs, 0.01 IO MB/s, 0.02 % Disk Utilization
H/1.1T Average: 47.39 IOPs, 0.01 IO MB/s, 0.02 % Disk Utilization

Disk Type	Cell Name	Disk Name	%Total	Avg	%Total	Avg	Avg
			IOPs		IO MB/s		%Disk Utilization
F/186G	scao08celadm07	FD_00_scao08celadm07	3.06	157.09	0.00	0.00	0.45
	scao08celadm04	FD_15_scao08celadm04	2.35	120.30	38.46	0.50	0.40
	scao08celadm05	FD_12_scao08celadm05	1.66	85.40	0.00	0.00	0.20
	scao08celadm05	FD_13_scao08celadm05	1.65	84.50	0.00	0.00	0.20
	scao08celadm05	FD_14_scao08celadm05	1.56	79.80	0.00	0.00	0.20
	scao08celadm05	FD_15_scao08celadm05	1.50	77.10	0.00	0.00	0.20
	scao08celadm03	FD_14_scao08celadm03	1.37	70.20	0.00	0.00	0.10
	scao08celadm01	FD_09_scao08celadm01	1.26	64.60	0.00	0.00	0.10
	scao08celadm01	FD_08_scao08celadm01	1.24	63.40	0.00	0.00	0.10
	scao08celadm03	FD_15_scao08celadm03	1.21	62.00	0.00	0.00	0.00
	scao08celadm03	FD_13_scao08celadm03	1.18	60.40	0.00	0.00	0.00
	scao08celadm01	FD_10_scao08celadm01	1.17	59.90	0.00	0.00	0.10
	scao08celadm03	FD_03_scao08celadm03	1.16	59.70	0.00	0.00	0.00
	scao08celadm03	FD_02_scao08celadm03	1.16	59.40	0.00	0.00	0.10
	scao08celadm03	FD_08_scao08celadm03	1.15	59.20	0.00	0.00	0.10
H/1.1T	scao08celadm01	CD_03_scao08celadm01	2.97	118.10	42.31	0.20	^	1.00
	scao08celadm03	CD_09_scao08celadm03	1.96	78.00	0.00	0.00	0.00
	scao08celadm05	CD_10_scao08celadm05	1.86	74.20	0.00	0.00	0.00
	scao08celadm04	CD_09_scao08celadm04	1.82	72.30	0.00	0.00	0.00
	scao08celadm06	CD_04_scao08celadm06	1.73	68.70	0.00	0.00	0.00
	scao08celadm02	CD_09_scao08celadm02	1.69	67.50	0.00	0.00	0.00
	scao08celadm02	CD_00_scao08celadm02	1.41	56.10	0.00	0.00	0.00
	scao08celadm06	CD_00_scao08celadm06	1.41	56.10	0.00	0.00	0.00
	scao08celadm01	CD_10_scao08celadm01	1.41	56.10	0.00	0.00	0.10
	scao08celadm04	CD_07_scao08celadm04	1.40	55.80	0.00	0.00	0.00
	scao08celadm02	CD_11_scao08celadm02	1.40	55.80	0.00	0.00	0.00
	scao08celadm06	CD_11_scao08celadm06	1.40	55.70	0.00	0.00	0.00
	scao08celadm06	CD_07_scao08celadm06	1.33	52.80	0.00	0.00	0.00
	scao08celadm01	CD_00_scao08celadm01	1.32	52.70	0.00	0.00	0.00
	scao08celadm05	CD_06_scao08celadm05	1.32	52.70	0.00	0.00	0.00

Back to Exadata OS Statistics Top
Back to Exadata Resource Statistics

Exadata OS IO Latency - Top Cells

These statistics are collected by the OS on the cells and are not restricted to this database or instance
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
Within each disk type, the top cells by Wait Time are displayed
Ordered by Disk Type, Avg Wait Time desc
F/186G Average: 72.43us Service Time, 79.41us Wait Time
H/1.1T Average: 73.89us Service Time, 185.93us Wait Time

Disk Type	Cell Name	Service Time	Wait Time
		Average Times
F/186G	scao08celadm01	79.61us	93.17us
	scao08celadm02	78.79us	90.62us
	scao08celadm04	81.01us	88.58us
	scao08celadm06	68.72us	76.19us
	scao08celadm07	70.43us	73.33us
	scao08celadm03	66.66us	69.80us
	scao08celadm05	61.99us	64.74us
H/1.1T	scao08celadm04	108.16us	305.06us
	scao08celadm07	99.73us	230.86us
	scao08celadm02	55.20us	170.89us
	scao08celadm06	60.95us	165.55us
	scao08celadm01	90.03us	144.18us
	scao08celadm05	53.56us	141.38us
	scao08celadm03	47.00us	139.09us

Exadata OS IO Latency - Top Disks

These statistics are collected by the OS on the cells and are not restricted to this database or instance
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
Within each disk type, the top disks by Wait Time are displayed
Ordered by Disk Type, Avg Wait Time desc
F/186G Average: 72.43us Service Time, 79.41us Wait Time
H/1.1T Average: 73.89us Service Time, 185.93us Wait Time

Disk Type	Cell Name	Disk Name	Service Time	Wait Time
			Average Times
F/186G	scao08celadm01	FD_06_scao08celadm01	106.20us	133.70us
	scao08celadm01	FD_01_scao08celadm01	83.00us	109.90us
	scao08celadm01	FD_00_scao08celadm01	82.60us	106.60us
	scao08celadm02	FD_03_scao08celadm02	86.00us	106.00us
	scao08celadm02	FD_01_scao08celadm02	85.00us	103.20us
	scao08celadm02	FD_04_scao08celadm02	84.90us	103.10us
	scao08celadm02	FD_06_scao08celadm02	82.70us	101.40us
	scao08celadm02	FD_05_scao08celadm02	81.70us	101.30us
	scao08celadm01	FD_02_scao08celadm01	79.40us	101.20us
	scao08celadm02	FD_00_scao08celadm02	82.90us	100.70us
	scao08celadm01	FD_03_scao08celadm01	76.90us	100.50us
	scao08celadm02	FD_07_scao08celadm02	80.80us	98.40us
	scao08celadm02	FD_02_scao08celadm02	78.10us	95.40us
	scao08celadm04	FD_05_scao08celadm04	87.60us	95.30us
	scao08celadm04	FD_13_scao08celadm04	81.60us	93.90us
H/1.1T	scao08celadm04	CD_10_scao08celadm04	628.50us	2,348.80us
	scao08celadm07	CD_07_scao08celadm07	173.55us	534.36us
	scao08celadm01	CD_01_scao08celadm01	498.40us	510.30us
	scao08celadm07	CD_11_scao08celadm07	383.00us	498.91us
	scao08celadm02	CD_01_scao08celadm02	64.50us	428.50us
	scao08celadm06	CD_03_scao08celadm06	49.50us	366.30us
	scao08celadm06	CD_08_scao08celadm06	90.50us	347.60us
	scao08celadm02	CD_07_scao08celadm02	62.00us	346.70us
	scao08celadm07	CD_02_scao08celadm07	108.45us	321.91us
	scao08celadm07	CD_00_scao08celadm07	109.73us	307.36us
	scao08celadm05	CD_00_scao08celadm05	74.80us	303.10us
	scao08celadm03	CD_06_scao08celadm03	93.00us	288.10us
	scao08celadm06	CD_05_scao08celadm06	177.00us	287.20us
	scao08celadm04	CD_06_scao08celadm04	43.00us	277.00us
	scao08celadm01	CD_06_scao08celadm01	55.20us	273.00us

Back to Exadata OS Statistics Top
Back to Exadata Resource Statistics

Exadata OS CPU Statistics - Top Cells

These statistics are collected by the OS on the cells and are not restricted to this database or instance
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
The top cells by %CPU are displayed
Ordered by % CPU desc
Average: 2.03 % CPU, 1.04 % User, 0.99 % Sys

Cell Name	% CPU	% User	% Sys
scao08celadm02	2.10	1.10	1.00
scao08celadm03	2.10	1.10	1.00
scao08celadm05	2.10	1.10	1.00
scao08celadm04	2.00	1.00	1.00
scao08celadm01	2.00	1.00	1.00
scao08celadm07	2.00	1.00	1.00
scao08celadm06	1.90	1.00	0.90

Back to Exadata OS Statistics Top
Back to Exadata Resource Statistics

Exadata Cell Server Statistics Top

Cell Server IOPS Statistics

Top Cells
Top Disks

Cell Server IO MB/s Statistics

Top Cells
Top Disks

Cell Server IO Latency

Top Cells
Top Disks

Exadata Cell Server IOPS Statistics - Top Cells

These statistics are collected by the cells and are not restricted to this database or instance
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
Within each disk type, the top cells by Avg IOPs are displayed
%Total - Avg IOPs as a percentage of the IOPs for the disk type
Ordered by Disk Type, IOPs desc
F/186G Average Requests: 714.38 IOPs, 117.54 Small Reads, 577.49 Small Writes, 7.00 Large Reads, 12.35 Large Writes
H/1.1T Average Requests: 568.01 IOPs, 29.30 Small Reads, 538.68 Small Writes, 0.04 Large Reads, 0.00 Large Writes

Disk Type	Cell Name	% Total	Average	Small Reads	Small Writes	Large Reads	Large Writes
		IOPs		Average Per Second
F/186G	scao08celadm03	16.66	832.40	266.60	553.60	0.00	12.20
	scao08celadm05	15.51	775.00	184.60	580.40	0.00	10.00
	scao08celadm07	15.30	764.45	155.64	595.45	0.00	13.36
	scao08celadm01	13.83	691.10	88.60	564.80	26.80	10.90
	scao08celadm04	13.20	659.50	98.10	546.30	0.00	15.10
	scao08celadm06	12.99	648.80	13.00	618.00	7.70	10.10
	scao08celadm02	12.50	624.40	12.40	582.10	15.20	14.70
H/1.1T	scao08celadm06	15.24	606.00	24.80	581.20	0.00	0.00
	scao08celadm01	15.21	604.80	84.20	520.60	0.00	0.00
	scao08celadm05	14.37	571.60	24.60	547.00	0.00	0.00
	scao08celadm02	14.18	564.10	25.20	538.90	0.00	0.00
	scao08celadm07	13.92	553.73	0.45	553.00	0.27	0.00
	scao08celadm03	13.71	545.40	24.40	521.00	0.00	0.00
	scao08celadm04	13.37	531.90	24.30	507.60	0.00	0.00

Exadata Cell Server IOPS - Top Disks

These statistics are collected by the cells and are not restricted to this database or instance
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
Within each disk type, the top disks by Avg IOPs are displayed
%Total - Avg IOPs as a percentage of the total IOPs for the disk type
Ordered by Disk Type, IOPs desc
F/186G Average Requests: 44.65 IOPs, 7.35 Small Reads, 36.09 Small Writes, 0.44 Large Reads, 0.77 Large Writes
H/1.1T Average Requests: 47.33 IOPs, 2.44 Small Reads, 44.89 Small Writes, 0.00 Large Reads, 0.00 Large Writes

Disk Type	Cell Name	Disk Name	%Total	Average	Small Reads		Small Writes	Large Reads	Large Writes
			IOPs		Average Per Second
F/186G	scao08celadm07	FD_00_scao08celadm07	3.13	156.27	118.91		36.36	0.00	1.00
	scao08celadm04	FD_15_scao08celadm04	2.39	119.30	84.30		34.30	0.00	0.70
	scao08celadm05	FD_12_scao08celadm05	1.69	84.40	47.70		36.10	0.00	0.60
	scao08celadm05	FD_13_scao08celadm05	1.67	83.30	46.70		36.10	0.00	0.50
	scao08celadm05	FD_14_scao08celadm05	1.58	78.80	41.90		36.30	0.00	0.60
	scao08celadm05	FD_15_scao08celadm05	1.52	76.00	37.40		38.00	0.00	0.60
	scao08celadm03	FD_14_scao08celadm03	1.37	68.50	33.10		34.70	0.00	0.70
	scao08celadm01	FD_09_scao08celadm01	1.27	63.30	24.50		35.90	2.00	0.90
	scao08celadm01	FD_08_scao08celadm01	1.23	61.40	23.20		35.40	2.00	0.80
	scao08celadm03	FD_15_scao08celadm03	1.22	60.90	25.20		34.90	0.00	0.80
	scao08celadm03	FD_13_scao08celadm03	1.18	58.90	22.50		35.60	0.00	0.80
	scao08celadm03	FD_03_scao08celadm03	1.18	58.70	22.90		34.80	0.00	1.00
	scao08celadm03	FD_02_scao08celadm03	1.17	58.40	22.90		34.50	0.00	1.00
	scao08celadm03	FD_08_scao08celadm03	1.16	58.10	23.20		34.20	0.00	0.70
	scao08celadm01	FD_10_scao08celadm01	1.16	58.00	18.70		36.70	2.00	0.60
H/1.1T	scao08celadm01	CD_03_scao08celadm01	2.97	118.10	^	84.20	33.90	0.00	0.00
	scao08celadm03	CD_09_scao08celadm03	1.97	78.20	24.40		53.80	0.00	0.00
	scao08celadm05	CD_10_scao08celadm05	1.87	74.50	24.20		50.30	0.00	0.00
	scao08celadm04	CD_09_scao08celadm04	1.83	72.70	24.30		48.40	0.00	0.00
	scao08celadm06	CD_04_scao08celadm06	1.73	69.00	24.40		44.60	0.00	0.00
	scao08celadm02	CD_09_scao08celadm02	1.70	67.50	24.20		43.30	0.00	0.00
	scao08celadm02	CD_00_scao08celadm02	1.41	56.20	0.00		56.20	0.00	0.00
	scao08celadm06	CD_00_scao08celadm06	1.41	56.20	0.00		56.20	0.00	0.00
	scao08celadm04	CD_07_scao08celadm04	1.41	56.10	0.00		56.10	0.00	0.00
	scao08celadm06	CD_11_scao08celadm06	1.41	56.10	0.00		56.10	0.00	0.00
	scao08celadm02	CD_11_scao08celadm02	1.40	55.80	1.00		54.80	0.00	0.00
	scao08celadm01	CD_10_scao08celadm01	1.34	53.20	0.00		53.20	0.00	0.00
	scao08celadm06	CD_07_scao08celadm06	1.34	53.10	0.00		53.10	0.00	0.00
	scao08celadm05	CD_06_scao08celadm05	1.33	52.90	0.00		52.90	0.00	0.00
	scao08celadm01	CD_00_scao08celadm01	1.33	52.80	0.00		52.80	0.00	0.00

Back to Exadata Cell Server Statistics Top
Back to Exadata Resource Statistics

Exadata Cell Server IO MB/s Statistics - Top Cells

These statistics are collected by the cells and are not restricted to this database or instance
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
Within each disk type, the top cells by Avg IO MB/s are displayed
%Total - Avg IO MB/s as a percentage of the IO MB/s for the disk type
Ordered by Disk Type, IO MB/s desc
F/186G Average MB/s: 5.62 IO MB/s, 0.80 Small Reads, 3.08 Small Writes, 0.61 Large Reads, 1.13 Large Writes
H/1.1T Average MB/s: 2.40 IO MB/s, 0.06 Small Reads, 1.16 Small Writes, 1.18 Large Reads, 0.00 Large Writes

Disk Type	Cell Name	% Total	Average	Small Reads	Small Writes	Large Reads	Large Writes
		IO MB/s		Average MB/s
F/186G	scao08celadm01	17.89	7.03	0.43	3.06	2.47	1.07
	scao08celadm07	14.96	5.88	1.51	3.19	0.00	1.18
	scao08celadm02	14.87	5.84	0.22	3.15	1.24	1.23
	scao08celadm03	13.41	5.27	1.29	2.91	0.00	1.07
	scao08celadm06	13.24	5.20	0.25	3.27	0.62	1.06
	scao08celadm04	12.88	5.06	0.85	2.94	0.00	1.28
	scao08celadm05	12.75	5.01	0.96	3.05	0.00	1.00
H/1.1T	scao08celadm07	17.83	2.98	0.01	1.19	1.78	0.00
	scao08celadm01	14.76	2.47	0.34	1.12	1.01	0.00
	scao08celadm06	14.25	2.39	0.02	1.24	1.12	0.00
	scao08celadm02	14.02	2.35	0.02	1.16	1.16	0.01
	scao08celadm05	13.90	2.33	0.02	1.17	1.13	0.00
	scao08celadm03	12.88	2.16	0.02	1.12	1.02	0.00
	scao08celadm04	12.37	2.07	0.02	1.09	0.96	0.00

Exadata Cell Server IO MB/s - Top Disks

These statistics are collected by the cells and are not restricted to this database or instance
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
Within each disk type, the top disks by Avg IO MB/s are displayed
%Total - Avg IO MB/s as a percentage of the total IO MB/s for the disk type
Ordered by Disk Type, IO MB/s desc
F/186G Average MB/s: 0.35 IO MB/s, 0.05 Small Reads, 0.19 Small Writes, 0.04 Large Reads, 0.07 Large Writes
H/1.1T Average MB/s: 0.20 IO MB/s, 0.01 Small Reads, 0.10 Small Writes, 0.10 Large Reads, 0.00 Large Writes

Disk Type	Cell Name	Disk Name	%Total	Average		Small Reads		Small Writes	Large Reads	Large Writes
			IO MB/s			Average MB/s
F/186G	scao08celadm07	FD_00_scao08celadm07	3.06	1.20		0.93		0.19	0.00	0.08
	scao08celadm04	FD_15_scao08celadm04	2.32	0.91		0.66		0.18	0.00	0.06
	scao08celadm01	FD_06_scao08celadm01	2.29	0.90		0.05		0.17	0.62	0.06
	scao08celadm01	FD_00_scao08celadm01	1.48	0.58		0.00		0.20	0.31	0.07
	scao08celadm01	FD_03_scao08celadm01	1.46	0.57		0.00		0.19	0.31	0.07
	scao08celadm01	FD_02_scao08celadm01	1.45	0.57		0.00		0.18	0.31	0.07
	scao08celadm01	FD_01_scao08celadm01	1.43	0.56		0.00		0.18	0.31	0.07
	scao08celadm01	FD_09_scao08celadm01	1.34	0.53		0.10		0.20	0.15	0.07
	scao08celadm01	FD_10_scao08celadm01	1.29	0.51		0.08		0.21	0.15	0.07
	scao08celadm01	FD_08_scao08celadm01	1.29	0.51		0.09		0.19	0.15	0.07
	scao08celadm03	FD_14_scao08celadm03	1.28	0.50		0.25		0.18	0.00	0.07
	scao08celadm05	FD_12_scao08celadm05	1.27	0.50		0.25		0.19	0.00	0.05
	scao08celadm01	FD_11_scao08celadm01	1.23	0.48		0.08		0.19	0.15	0.06
	scao08celadm02	FD_04_scao08celadm02	1.17	0.46		0.03		0.21	0.15	0.07
	scao08celadm02	FD_02_scao08celadm02	1.09	0.43		0.00		0.20	0.15	0.07
H/1.1T	scao08celadm07	CD_11_scao08celadm07	4.78	^	0.80	0.00		0.11	0.69	0.00
	scao08celadm01	CD_03_scao08celadm01	2.82	0.47		^	0.33	0.07	0.07	0.00
	scao08celadm04	CD_07_scao08celadm04	1.49	0.25		0.00		0.12	0.12	0.00
	scao08celadm02	CD_00_scao08celadm02	1.45	0.24		0.00		0.12	0.12	0.00
	scao08celadm01	CD_10_scao08celadm01	1.37	0.23		0.00		0.11	0.12	0.00
	scao08celadm01	CD_00_scao08celadm01	1.36	0.23		0.00		0.11	0.11	0.00
	scao08celadm02	CD_11_scao08celadm02	1.35	0.23		0.00		0.12	0.11	0.00
	scao08celadm03	CD_09_scao08celadm03	1.34	0.23		0.01		0.11	0.10	0.00
	scao08celadm05	CD_00_scao08celadm05	1.33	0.22		0.00		0.11	0.12	0.00
	scao08celadm07	CD_05_scao08celadm07	1.33	0.22		0.01		0.10	0.11	0.00
	scao08celadm05	CD_10_scao08celadm05	1.32	0.22		0.01		0.10	0.11	0.00
	scao08celadm05	CD_06_scao08celadm05	1.31	0.22		0.00		0.11	0.11	0.00
	scao08celadm02	CD_10_scao08celadm02	1.30	0.22		0.00		0.09	0.12	0.00
	scao08celadm06	CD_08_scao08celadm06	1.29	0.22		0.00		0.11	0.10	0.00
	scao08celadm03	CD_04_scao08celadm03	1.29	0.22		0.00		0.10	0.11	0.00

Back to Exadata Cell Server Statistics Top
Back to Exadata Resource Statistics

Exadata Cell Server IO Latency - Top Cells

These statistics are collected by the cells and are not restricted to this database or instance
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
Within each disk type, the top cells by Cell Latency are displayed
Ordered by Disk Type, Avg Cell Latency desc
F/186G Average: 97.79us Cell Latency, 117.77us Small Read, 91.18us Small Write, 89.01us Large Read, 197.94us Large Write
H/1.1T Average: 146.26us Cell Latency, 715.83us Small Read, 152.43us Small Write, 1,262.66us Large Read, 3.42us Large Write

Disk Type	Cell Name	Cell Latency	Small Read	Small Write	Large Read	Large Write
		Average Times
F/186G	scao08celadm01	109.93us	107.64us	94.21us	291.07us	198.85us
	scao08celadm02	108.22us	110.33us	96.86us	221.31us	197.35us
	scao08celadm04	103.20us	159.19us	100.33us	0.00us	202.49us
	scao08celadm06	97.89us	110.83us	89.66us	119.60us	196.01us
	scao08celadm07	90.90us	140.74us	86.23us	0.00us	196.52us
	scao08celadm03	88.78us	94.06us	88.06us	0.00us	201.71us
	scao08celadm05	86.27us	99.28us	83.40us	0.00us	192.76us
H/1.1T	scao08celadm02	191.25us	604.27us	206.85us	1,093.47us	11.41us
	scao08celadm06	158.13us	560.79us	158.49us	1,137.96us	0.00us
	scao08celadm07	153.08us	1,153.94us	153.79us	2,228.90us	5.96us
	scao08celadm03	151.44us	545.63us	156.58us	889.88us	2.31us
	scao08celadm05	133.56us	575.58us	145.80us	1,071.88us	0.00us
	scao08celadm01	121.28us	702.88us	120.35us	1,119.17us	1.19us
	scao08celadm04	114.41us	823.92us	125.01us	1,200.73us	2.84us

Exadata Cell Server IO Latency - Top Disks

These statistics are collected by the cells and are not restricted to this database or instance
A 'v' and a dark yellow background indicates an outlier value below the low range
A '^' and a light red background indicates an outlier value above the high range
Disk Type <F|H>/<size>: F-Flash, H-Hard Disk
Within each disk type, the top disks by Cell Latency are displayed
Ordered by Disk Type, Avg Wait Time desc
F/186G Average: 97.79us Cell Latency, 117.77us Small Read, 91.18us Small Write, 89.01us Large Read, 197.94us Large Write
H/1.1T Average: 146.26us Cell Latency, 715.83us Small Read, 152.43us Small Write, 1,262.66us Large Read, 3.42us Large Write

Disk Type	Cell Name	Disk Name	Cell Latency	Small Read	Small Write	Large Read	Large Write
			Average Times
F/186G	scao08celadm01	FD_00_scao08celadm01	139.31us	73.90us	96.90us	408.70us	210.50us
	scao08celadm01	FD_02_scao08celadm01	134.66us	117.50us	88.40us	433.40us	215.10us
	scao08celadm01	FD_01_scao08celadm01	131.55us	125.60us	97.80us	336.80us	186.90us
	scao08celadm01	FD_03_scao08celadm01	125.11us	61.40us	91.20us	341.90us	185.60us
	scao08celadm02	FD_00_scao08celadm02	123.25us	75.60us	101.80us	507.30us	205.60us
	scao08celadm02	FD_04_scao08celadm02	122.61us	160.70us	103.30us	448.20us	196.80us
	scao08celadm02	FD_03_scao08celadm02	121.18us	89.20us	105.70us	392.30us	197.40us
	scao08celadm02	FD_01_scao08celadm02	120.76us	80.80us	104.60us	419.00us	184.70us
	scao08celadm01	FD_06_scao08celadm01	120.23us	156.00us	92.70us	1,739.80us	200.70us
	scao08celadm02	FD_06_scao08celadm02	119.97us	117.20us	103.60us	391.90us	212.60us
	scao08celadm02	FD_07_scao08celadm02	119.37us	146.60us	100.70us	471.90us	196.90us
	scao08celadm02	FD_05_scao08celadm02	119.26us	208.40us	101.30us	423.00us	210.70us
	scao08celadm02	FD_02_scao08celadm02	116.78us	71.50us	98.40us	487.40us	196.40us
	scao08celadm06	FD_01_scao08celadm06	114.69us	57.60us	91.30us	415.30us	187.50us
	scao08celadm06	FD_02_scao08celadm06	114.30us	88.40us	90.00us	466.80us	195.20us
H/1.1T	scao08celadm02	CD_01_scao08celadm02	595.30us	2,708.90us	595.30us	1,130.40us	15.90us
	scao08celadm06	CD_03_scao08celadm06	401.90us	747.60us	401.90us	628.10us	0.00us
	scao08celadm02	CD_07_scao08celadm02	341.50us	470.20us	363.00us	798.50us	0.00us
	scao08celadm04	CD_06_scao08celadm04	307.30us	1,009.80us	307.30us	774.00us	0.00us
	scao08celadm01	CD_06_scao08celadm01	298.60us	728.50us	298.60us	1,101.80us	0.00us
	scao08celadm07	CD_09_scao08celadm07	264.36us	1,284.64us	264.36us	1,275.27us	0.00us
	scao08celadm03	CD_06_scao08celadm03	256.60us	728.70us	256.60us	859.90us	0.00us
	scao08celadm06	CD_05_scao08celadm06	250.78us	460.60us	192.70us	788.70us	0.00us
	scao08celadm03	CD_08_scao08celadm03	235.40us	505.10us	235.40us	1,054.90us	0.00us
	scao08celadm06	CD_11_scao08celadm06	234.00us	435.90us	241.10us	595.80us	0.00us
	scao08celadm05	CD_03_scao08celadm05	222.20us	990.60us	231.20us	1,213.10us	0.00us
	scao08celadm03	CD_04_scao08celadm03	219.60us	371.60us	219.60us	1,239.00us	0.00us
	scao08celadm06	CD_08_scao08celadm06	212.40us	780.60us	225.00us	1,192.00us	0.00us
	scao08celadm04	CD_07_scao08celadm04	211.10us	851.00us	225.60us	1,089.40us	20.80us
	scao08celadm07	CD_01_scao08celadm07	209.73us	942.82us	209.73us	2,691.18us	0.00us

Back to Exadata Cell Server Statistics Top
Back to Exadata Resource Statistics

Exadata Smart Statistics

Smart IO
Flash Log
Flash Cache

Smart IO

No data exists for this section of the report.

Back to Exadata Smart Statistics
Back to Exadata Statistics

Flash Log Statistics

Flash Log
Redo Write Histogram

Flash Log

These statistics are collected by the cells and are not restricted to this database or instance
Writes - writes serviced by flash log
First Writes Flash Log - writes written first to smart flash log
First Writes DB Log - writes written first to database redo log file
% Efficiency - percentage when flash log prevented writes from exceeding the threshold
Prevented - flash log writes prevented from exceeding outlier threshold
Actual - flash log writes that exceeded outlier threshold
Disk I/O Errors - disk I/O errors encountered by flash log (should be 0)
Flash I/O Errors - flash I/O errors encountered by flash log (should be 0)
Keep - redo saved on flash due to disk I/O errors (should be 0)
Skip Count - redo writes not serviced by flash log (should be 0)
Ordered by Total Write Requests desc

Cell Name	% Total	Total	per Sec	Total	per Sec	%Flash Log	Flash Log	DB Log	% Efficiency	Disk I/O
	Write Requests			Write MB		First Writes			Outliers	Errors
Total (7)		2,296,035	3,757.83	10,577.34	17.31	32.01	735,001	1,561,034
scao08celadm07	14.99	344,231	563.39	1,585.91	2.60	32.62	112,301	231,930
scao08celadm06	14.57	334,559	547.56	1,540.10	2.52	32.10	107,400	227,159
scao08celadm05	14.56	334,404	547.31	1,540.26	2.52	33.65	112,540	221,864
scao08celadm03	14.12	324,129	530.49	1,492.31	2.44	31.77	102,980	221,149
scao08celadm04	14.04	322,302	527.50	1,486.11	2.43	31.68	102,091	220,211
scao08celadm02	13.99	321,147	525.61	1,479.69	2.42	31.71	101,825	219,322
scao08celadm01	13.73	315,263	515.98	1,452.97	2.38	30.41	95,864	219,399

Back to Exadata Smart Statistics
Back to Exadata Statistics

Redo Write Histogram

log file parallel write is for the entire database, not restricted to an instance
Redo log write completions are collected by the cells
Cells for redo log write completions are ordered by # of writes >= 512ms
Redo log write completion Avg Wait is the average time for the redo log write request, including network overhead
Redo log write completion Average IO Time is the average time for the IO request

					% of Total
	Cell Name	Total Waits	Avg Wait		<1us	<2us	<4us	<8us	<16us	<32us	<64us	<128us	<256us	<512us	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<64ms	<128ms	<256ms	<512ms	<1s	>=1s
log file parallel write		1,146,873	215.91us Total Time: 247.63s					0.04	0.04	0.00	0.01	0.44	79.48	19.90	0.09	0.01	0.00	0.00	0.00	0.00
	Cell Name	Total Writes	Avg Wait	Average IO Time	<1us	<2us	<4us	<8us	<16us	<32us	<64us	<128us	<256us	<512us	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<64ms	<128ms	<256ms	<512ms	<1s	>=1s
Redo log write completions	Total (7)	2,296,035 # of Waits: 2296035	226.90us Total Time: 520.96s	62.77us Total IO Time: 144.13s	96.62													2.83	0.43	0.09	0.03	0.00
	scao08celadm07	344,231 # of Waits: 344231	208.73us Total Time: 71.85s	63.58us Total IO Time: 21.88s	96.79													2.76	0.35	0.08	0.02	0.00
	scao08celadm06	334,559 # of Waits: 334559	247.61us Total Time: 82.84s	63.07us Total IO Time: 21.10s	96.37													2.95	0.55	0.10	0.02
	scao08celadm05	334,404 # of Waits: 334404	232.14us Total Time: 77.63s	63.02us Total IO Time: 21.07s	96.56													2.86	0.45	0.11	0.02
	scao08celadm03	324,129 # of Waits: 324129	224.36us Total Time: 72.72s	62.26us Total IO Time: 20.18s	96.67													2.79	0.41	0.10	0.03
	scao08celadm04	322,302 # of Waits: 322302	207.98us Total Time: 67.03s	62.81us Total IO Time: 20.24s	96.84													2.76	0.30	0.07	0.04
	scao08celadm02	321,147 # of Waits: 321147	265.27us Total Time: 85.19s	62.79us Total IO Time: 20.16s	96.35													2.91	0.57	0.12	0.04	0.01
	scao08celadm01	315,263 # of Waits: 315263	202.05us Total Time: 63.70s	61.79us Total IO Time: 19.48s	96.79													2.78	0.36	0.07	0.00

Back to Exadata Smart Statistics
Back to Exadata Statistics

Flash Cache

Flash Cache Configuration
Flash Cache Space Usage
Flash Cache Performance Summary
Flash Cache User Reads
Flash Cache Efficiency
Flash Cache User Writes
Flash Cache Internal Reads
Flash Cache Internal Writes
Flash Cache Scan Population

Flash Cache Configuration

These statistics are collected by the cells and are not restricted to this database or instance

Mode	Compression	Status	Cells
WriteBack	FALSE	normal	All

Back to Exadata Flash Cache
Back to Exadata Smart Statistics

Flash Cache Space Usage

These statistics are collected by the cells and are not restricted to this database or instance
Space is at the time of the end snapshot
Ordered by Space (GB) desc

Cell Name	Space (GB)	%Clean	%Unflushed	%Temp Spill	%Scan	%Columnar	%Clean	%Unflushed	%Scan	%Columnar
		Default					Keep
		OLTP		Large Writes	%Scan	%Columnar	OLTP		%Scan	%Columnar
Total (7)	3,604.31	4.30	18.02	0.00	76.75	0.60	0.00	0.33	0.00
scao08celadm02	518.02	4.35	17.90	0.00	76.82	0.59	0.00	0.34	0.00
scao08celadm01	517.87	4.28	17.93	0.00	76.90	0.57	0.00	0.32	0.00
scao08celadm06	517.83	4.27	17.89	0.00	76.94	0.58	0.00	0.32	0.00
scao08celadm05	517.40	4.24	17.98	0.00	76.85	0.59	0.00	0.33	0.00
scao08celadm04	517.07	4.35	17.90	0.00	76.81	0.59	0.00	0.34	0.00
scao08celadm03	516.50	4.25	17.92	0.00	76.87	0.61	0.00	0.35	0.00
scao08celadm07	499.61	4.34	18.63	0.00	76.05	0.66	0.00	0.32	0.00

Back to Exadata Flash Cache
Back to Exadata Smart Statistics

Flash Cache Performance Summary

I/O Summary

average requests/second and MB/s per disk

Disk Type	Reads/s	Writes/s	Read MB/s	Write MB/s
	Requests		Throughput
F/186G	7.79	36.86	0.09	0.26
H/1.1T	2.44	44.89	0.11	0.10

Flash Cache Savings

Disk write savings (overwrites) - writes absorbed by flash cache that would have otherwise gone to disk
Database Flash Cache Hit% - for the database, not restricted to an instance
Cell OLTP and Cell Scan Flash Cache Hit% - for the cells, not restricted to this database or instance

Database Flash Cache Hit %	99.97
Cell OLTP Hit %	100
Cell Scan Hit %	100
Disk Write savings/s	274.52

Disk Activity

Flash cache activity resulting in disk I/O
Read Misses - reads from disk, writes to flash
Disk Writer - reads from flash, writes to disk

I/O per second
Read Misses	0.02
Disk writer
% Utilization
H/1.1T	0.02

Single Block Reads

cell single block physical read wait time for the database, not restricted to an instance
% of small reads from flash/disk from the cells, not restricted to this database or instance
small reads for flash/disk from the cells, not restricted to this database or instance
Total Small Reads/s - small reads/s for the entire system for the disk type
Cell Small Reads/s - average small reads/s for a cell for the disk type
Disk Small Reads/s - average small reads/s for a disk for the disk type

				% of Total Waits
	Total Waits	FG Waits	Avg Wait	<1us	<2us	<4us	<8us	<16us	<32us	<64us	<128us	<256us	<512us	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<64ms	<128ms	<256ms	<512ms	<1s	>=1s
cell single block physical read	11,165	2,934	524.09us Total Time:1,537.69ms									6.48	84.81	7.01	0.77	0.38	0.21	0.25	0.04	0.05

Small Reads Distribution	%Small Reads	Small Reads/s
Flash	80.05	822.75
Disk	19.95	205.07
Small Reads - Flash	# Cells	Total Small Reads/s	Cell Small Reads/s	Disk Small Reads/s	Latency
F/186G	7	822.75	117.54	7.35	117.77us
Small Reads - Disk	# Cells	Total Small Reads/s	Cell Small Reads/s	Disk Small Reads/s	Latency
H/1.1T	7	205.07	29.30	2.44	715.83us

Flash Cache Scan Summary

	%MB	MB/s
Flash	100.00	3.64
Disk

Temp IO and Large Writes Summary

direct path [read|write] temp wait time for the database, not restricted to an instance
Large writes from the cells, not restricted to this database or instance

				% of Total Waits
	Total Waits	FG Waits	Avg Wait	<1us	<2us	<4us	<8us	<16us	<32us	<64us	<128us	<256us	<512us	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<64ms	<128ms	<256ms	<512ms	<1s	>=1s
direct path write temp	0	0	Total Time:0.00ns
direct path read temp	0	0	Total Time:0.00ns

Flash Cache User Reads

These statistics are collected by the cells and are not restricted to this database or instance
Total - total number of reads from Flash Cache
OLTP/Scan/Columnar reads include reads on keep objects
Misses/Partial Hits - number of read request misses and partial hits
Ordered by Total Read Requests desc

Cell Name	Total	per Sec	OLTP	Scan	Misses Partial Hits	Total	per Sec	OLTP	Scan
	Read Requests					Read Megabytes
Total (7)	466,286	763.15	464,058	2,228	10	5,153.00	8.43	2,927.18	2,225.82
scao08celadm03	164,923	269.92	164,923			779.99	1.28	779.99
scao08celadm05	113,377	185.56	113,377			574.72	0.94	574.72
scao08celadm07	98,498	161.21	98,498			916.61	1.50	916.61
scao08celadm01	56,655	92.73	55,543	1,112		1,366.00	2.24	255.08	1,110.91
scao08celadm06	11,485	18.80	11,113	372		526.48	0.86	154.84	371.64
scao08celadm04	10,965	17.95	10,965			113.42	0.19	113.42
scao08celadm02	10,383	16.99	9,639	744	10	875.80	1.43	132.52	743.27

Flash Cache User Reads Per Second

These statistics are collected by the cells and are not restricted to this database or instance
Total - total number of reads per second from Flash Cache
OLTP/Scan/Columnar reads include reads on keep objects
Ordered by Total Read Requests per Second desc

Cell Name	Total	OLTP	Scan	Misses	Total	OLTP	Scan
	Read Requests per Second				Read MB per Second
Total (7)	763.15	759.51	3.65	0.02	8.43	4.79	3.64
scao08celadm03	269.92	269.92			1.28	1.28
scao08celadm05	185.56	185.56			0.94	0.94
scao08celadm07	161.21	161.21			1.50	1.50
scao08celadm01	92.73	90.91	1.82		2.24	0.42	1.82
scao08celadm06	18.80	18.19	0.61		0.86	0.25	0.61
scao08celadm04	17.95	17.95			0.19	0.19
scao08celadm02	16.99	15.78	1.22	0.02	1.43	0.22	1.22

Back to Exadata Flash Cache
Back to Exadata Smart Statistics

Flash Cache User Reads Efficiency

These statistics are collected by the cells and are not restricted to this database or instance
Ordered by Total Requests desc

Cell Name	Requests	MB	Read Requests	Misses	%Hit	Read MB	Attempted MB	%Hit	Read MB	Read Requests
	Total		OLTP			Scan			Columnar	Keep
Total (7)	466,286	5,153.00	464,058	10	100.00	2,225.82	2,225.82	100.00
scao08celadm03	164,923	779.99	164,923	0	100.00
scao08celadm05	113,377	574.72	113,377	0	100.00
scao08celadm07	98,498	916.61	98,498	0	100.00
scao08celadm01	56,655	1,366.00	55,543	0	100.00	1,110.91	1,111.91	99.91
scao08celadm06	11,485	526.48	11,113	0	100.00	371.64	371.64	100.00
scao08celadm04	10,965	113.42	10,965	0	100.00
scao08celadm02	10,383	875.80	9,639	10	99.90	743.27	742.27	100.13

Back to Exadata Flash Cache
Back to Exadata Smart Statistics

Flash Cache User Writes

These statistics are collected by the cells and are not restricted to this database or instance
Total - total number of write requests or write megabytes to Flash Cache
First Writes/Overwrites also include Keep Writes and Large Writes
Ordered by Total Write Requests desc

Cell Name	Total	First Writes	Overwrites	Total	First Writes	Overwrites	Total	First Writes	Overwrites	Total	First Writes	Overwrites
	Write Requests						Write Megabytes
	Total			per Sec			Total			per Sec
Total (7)	167,974	241	167,733	274.92	0.39	274.52	7,010.65	18.16	6,992.20	11.47	0.03	11.44
scao08celadm02	27,230	89	27,141	44.57	0.15	44.42	1,104.98	7.12	1,097.84	1.81	0.01	1.80
scao08celadm01	25,629	10	25,619	41.95	0.02	41.93	1,002.63	0.35	1,002.20	1.64	0.00	1.64
scao08celadm07	24,313	87	24,226	39.79	0.14	39.65	1,024.91	7.13	1,017.73	1.68	0.01	1.67
scao08celadm06	24,213	11	24,202	39.63	0.02	39.61	981.12	0.37	980.73	1.61	0.00	1.61
scao08celadm04	23,953	19	23,934	39.20	0.03	39.17	1,089.66	1.58	1,088.05	1.78	0.00	1.78
scao08celadm05	21,572	7	21,565	35.31	0.01	35.29	893.22	0.23	892.94	1.46	0.00	1.46
scao08celadm03	21,064	18	21,046	34.47	0.03	34.45	914.13	1.38	912.72	1.50	0.00	1.49

Back to Exadata Flash Cache
Back to Exadata Smart Statistics

Flash Cache Internal Reads

No data exists for this section of the report.

Back to Exadata Flash Cache
Back to Exadata Smart Statistics

Flash Cache Internal Writes

These statistics are collected by the cells and are not restricted to this database or instance
The top cells by Total Write Requests are displayed
Population Write - population writes due to read misses

Cell Name	Total	per Sec	Total	per Sec
	Population Write Requests		Population Write Megabytes
Total (7)	8	0.01	0.45	0.00
scao08celadm02	8	0.01	0.45	0.00

Back to Exadata Smart Statistics
Back to Exadata Statistics

Flash Cache Scan Population

No data exists for this section of the report.

Back to Exadata Smart Statistics
Back to Exadata Statistics

Exadata IO Reasons

Top IO Reasons by Requests
Top IO Reasons by MB

Top IO Reasons by Requests

The top IO reasons by requests per cell are displayed
Only reasons with over 1% of IO requests for each cell are displayed
At most 5 reasons are displayed per cell
%Cell - the percentage of IO requests on the cell due to the IO reason
Ordered by Cell Name, Requests Value desc

Cell Name	IO Reason	%Cell	Total Requests	per Sec	Total MB	per Sec
		Requests			MB
scao08celadm01	redo log write	79.08	630,526	1,031.96	2,126.28	3.48
	ASM CACHE IO	14.92	118,980	194.73	1,879.83	3.08
	self tune checkpoint writes	3.27	26,093	42.71	780.72	1.28
	database control file write	1.03	8,194	13.41	128.03	0.21
scao08celadm02	redo log write	88.14	642,802	1,052.05	2,166.84	3.55
	self tune checkpoint writes	4.31	31,455	51.48	918.59	1.50
	Voting file I/O	2.39	17,440	28.54	10.63	0.02
	ASM CACHE IO	1.63	11,904	19.48	743.27	1.22
	database control file read	1.05	7,656	12.53	119.63	0.20
scao08celadm03	redo log write	74.50	647,646	1,059.98	2,180.35	3.57
	ASM CACHE IO	17.39	151,200	247.46	594.42	0.97
	self tune checkpoint writes	3.06	26,633	43.59	768.78	1.26
	Voting file I/O	2.02	17,559	28.74	10.69	0.02
	database control file read	1.19	10,350	16.94	161.72	0.26
scao08celadm04	redo log write	83.93	643,668	1,053.47	2,171.39	3.55
	ASM CACHE IO	6.57	50,400	82.49	394.59	0.65
	self tune checkpoint writes	4.01	30,778	50.37	930.78	1.52
	Voting file I/O	2.29	17,545	28.72	10.68	0.02
scao08celadm05	redo log write	79.71	668,804	1,094.61	2,252.85	3.69
	ASM CACHE IO	12.01	100,800	164.98	396.28	0.65
	self tune checkpoint writes	2.87	24,083	39.42	703.35	1.15
	Voting file I/O	2.08	17,419	28.51	10.62	0.02
	database control file read	1.26	10,592	17.34	165.50	0.27
scao08celadm06	redo log write	89.58	668,467	1,094.05	2,250.04	3.68
	self tune checkpoint writes	3.41	25,444	41.64	769.17	1.26
	Voting file I/O	2.36	17,591	28.79	10.71	0.02
	database control file read	1.21	9,031	14.78	141.11	0.23
scao08celadm07	redo log write	82.92	690,332	1,129.84	2,326.81	3.81
	buffer cache reads	9.49	78,987	129.27	617.09	1.01
	self tune checkpoint writes	3.27	27,241	44.58	823.66	1.35
	database control file read	2.30	19,171	31.38	299.55	0.49

Top IO Reasons by MB

The top reasons by MB per cell are displayed
Only reasons with over 1% of IO MB for each cell are displayed
At most 5 reasons are displayed per cell
%Cell - the percentage of MB on the cell due to the IO reason
Ordered by Cell Name, MB Value desc

Cell Name	IO Reason	%Cell	Total MB	per Sec	Total Requests	per Sec
		MB			Requests
scao08celadm01	redo log write	37.42	2,126.28	3.48	630,526	1,031.96
	ASM CACHE IO	33.08	1,879.83	3.08	118,980	194.73
	self tune checkpoint writes	13.74	780.72	1.28	26,093	42.71
	redo log read	10.54	598.74	0.98	756	1.24
	database control file write	2.25	128.03	0.21	8,194	13.41
scao08celadm02	redo log write	44.60	2,166.84	3.55	642,802	1,052.05
	self tune checkpoint writes	18.91	918.59	1.50	31,455	51.48
	ASM CACHE IO	15.30	743.27	1.22	11,904	19.48
	redo log read	13.87	674.08	1.10	980	1.60
	database control file read	2.46	119.63	0.20	7,656	12.53
scao08celadm03	redo log write	48.11	2,180.35	3.57	647,646	1,059.98
	self tune checkpoint writes	16.96	768.78	1.26	26,633	43.59
	redo log read	13.69	620.23	1.02	781	1.28
	ASM CACHE IO	13.12	594.42	0.97	151,200	247.46
	database control file read	3.57	161.72	0.26	10,350	16.94
scao08celadm04	redo log write	49.07	2,171.39	3.55	643,668	1,053.47
	self tune checkpoint writes	21.03	930.78	1.52	30,778	50.37
	redo log read	14.05	621.90	1.02	778	1.27
	ASM CACHE IO	8.92	394.59	0.65	50,400	82.49
	aged writes by dbwr	1.69	74.96	0.12	1,846	3.02
scao08celadm05	redo log write	50.79	2,252.85	3.69	668,804	1,094.61
	self tune checkpoint writes	15.86	703.35	1.15	24,083	39.42
	redo log read	15.20	674.04	1.10	853	1.40
	ASM CACHE IO	8.93	396.28	0.65	100,800	164.98
	database control file read	3.73	165.50	0.27	10,592	17.34
scao08celadm06	redo log write	50.52	2,250.04	3.68	668,467	1,094.05
	self tune checkpoint writes	17.27	769.17	1.26	25,444	41.64
	redo log read	14.72	655.47	1.07	824	1.35
	ASM CACHE IO	8.34	371.64	0.61	5,952	9.74
	database control file read	3.17	141.11	0.23	9,031	14.78
scao08celadm07	redo log write	43.20	2,326.81	3.81	690,332	1,129.84
	self tune checkpoint writes	15.29	823.66	1.35	27,241	44.58
	redo log read	13.28	715.18	1.17	897	1.47
	buffer cache reads	11.46	617.09	1.01	78,987	129.27
	ASM CACHE IO	6.90	371.64	0.61	372	0.61

Back to Exadata IO Reasons
Back to Exadata Statistics

Exadata Top Database Consumers

Top Databases by Requests
Top Databases by Throughput
Top Databases by Requests per Cell
Top Databases by Throughput per Cell

Top Databases by IO Requests

The top databases by IO Requests are displayed
At most 10 databases are displayed
%Captured - % of Captured DB IO requests
Total - total IO requests or IO throughput (Flash + Disk)
Ordered by IO requests desc

DB Name	DBID	%Captured	Total Requests	per Sec	Flash	Disk	Total MB	per Sec	Flash	Disk
		IO Requests					IO Throughput (MB)
CONNDEMO	3094411576	87.06	4,834,673	7,912.72	2,533,668	2,301,005	26,768.55	43.81	17,284.61	9,483.95
ASM	1	9.69	538,380	881.15	392,445	145,935	4,846.39	7.93	4,185.70	660.68
OTHER	0	3.25	180,425	295.29	178,885	1,540	2,108.01	3.45	2,105.83	2.18

Back to Exadata Top Database Consumers
Back to Exadata Statistics

Top Databases by IO Throughput

The top database by IO Throughput are displayed
At most 10 database are displayed
%Captured - % of Captured DB IO throughput
Total - total IO throughput or IO requests (Flash + Disk)
Ordered by IO Throughput desc

DB Name	DBID	%Captured	Total MB	per Sec	Flash	Disk	Total Requests	per Sec	Flash	Disk
		IO Throughput (MB)					IO Requests
CONNDEMO	3094411576	79.38	26,768.55	43.81	17,284.61	9,483.95	4,834,673	7,912.72	2,533,668	2,301,005
ASM	1	14.37	4,846.39	7.93	4,185.70	660.68	538,380	881.15	392,445	145,935
OTHER	0	6.25	2,108.01	3.45	2,105.83	2.18	180,425	295.29	178,885	1,540

Back to Exadata Top Database Consumers
Back to Exadata Statistics

Top Databases by IO Requests per Cell

Within each cell the top databases by IO requests are displayed
At most 5 databases are displayed per cell
%Cell - % of Captured DB IOs on the Cell
Ordered by cell name, IO requests desc

Cell Name	DB Name	DBID	%Cell	Total Requests	per Sec	Flash	Disk	Total MB	per Sec	Flash	Disk
			IO Requests					IO Throughput (MB)
scao08celadm01	CONNDEMO	3094411576	83.42	662,394	1,084.11	346,246	316,148	3,627.61	5.94	2,346.92	1,280.68
	ASM	1	15.09	119,840	196.14	69,010	50,830	1,881.51	3.08	1,681.90	199.62
	OTHER	0	1.49	11,860	19.41	11,722	138	173.72	0.28	173.56	0.16
scao08celadm02	CONNDEMO	3094411576	93.88	682,424	1,116.90	359,304	323,120	3,895.74	6.38	2,527.62	1,368.11
	ASM	1	4.26	31,001	50.74	12,334	18,667	757.40	1.24	743.48	13.92
	OTHER	0	1.85	13,470	22.05	13,331	139	203.97	0.33	203.81	0.16
scao08celadm03	CONNDEMO	3094411576	78.69	680,823	1,114.28	356,523	324,300	3,717.96	6.09	2,400.60	1,317.36
	ASM	1	19.71	170,492	279.04	151,830	18,662	611.65	1.00	595.41	16.24
	OTHER	0	1.60	13,857	22.68	13,654	203	198.61	0.33	198.36	0.25
scao08celadm04	CONNDEMO	3094411576	89.22	679,719	1,112.47	358,022	321,697	3,859.33	6.32	2,547.77	1,311.56
	ASM	1	9.11	69,417	113.61	51,029	18,388	409.36	0.67	395.58	13.78
	OTHER	0	1.66	12,681	20.75	12,289	392	146.97	0.24	146.46	0.52
scao08celadm05	CONNDEMO	3094411576	83.72	698,980	1,143.99	364,008	334,972	3,768.99	6.17	2,382.90	1,386.08
	ASM	1	14.39	120,105	196.57	101,230	18,875	417.01	0.68	396.49	20.52
	OTHER	0	1.90	15,845	25.93	15,501	344	237.37	0.39	236.75	0.62
scao08celadm06	CONNDEMO	3094411576	94.31	699,088	1,144.17	364,553	334,535	3,795.68	6.21	2,429.84	1,365.84
	ASM	1	3.46	25,656	41.99	6,582	19,074	391.25	0.64	372.63	18.63
	OTHER	0	2.23	16,545	27.08	16,391	154	251.93	0.41	251.76	0.16
scao08celadm07	CONNDEMO	3094411576	88.18	731,245	1,196.80	385,012	346,233	4,103.26	6.72	2,648.95	1,454.30
	OTHER	0	11.60	96,167	157.39	95,997	170	895.44	1.47	895.13	0.31
	ASM	1	0.23	1,869	3.06	430	1,439	378.20	0.62	0.21	377.99

Back to Exadata Top Database Consumers
Back to Exadata Statistics

Top Databases by IO Throughput per Cell

Within each cell the top databases by IO throughput are displayed
At most 5 databases are displayed per cell
%Cell - % of Captured DB IOs on the Cell
Ordered by cell name, IO throughput desc

Cell Name	DB Name	DBID	%Cell	Total MB	per Sec	Flash	Disk	Total Requests	per Sec	Flash	Disk
			IO Throughput (MB)					IO Requests
scao08celadm01	CONNDEMO	3094411576	63.83	3,627.61	5.94	2,346.92	1,280.68	662,394	1,084.11	346,246	316,148
	ASM	1	33.11	1,881.51	3.08	1,681.90	199.62	119,840	196.14	69,010	50,830
	OTHER	0	3.06	173.72	0.28	173.56	0.16	11,860	19.41	11,722	138
scao08celadm02	CONNDEMO	3094411576	80.21	3,895.74	6.38	2,527.62	1,368.11	682,424	1,116.90	359,304	323,120
	ASM	1	15.59	757.40	1.24	743.48	13.92	31,001	50.74	12,334	18,667
	OTHER	0	4.20	203.97	0.33	203.81	0.16	13,470	22.05	13,331	139
scao08celadm03	CONNDEMO	3094411576	82.11	3,717.96	6.09	2,400.60	1,317.36	680,823	1,114.28	356,523	324,300
	ASM	1	13.51	611.65	1.00	595.41	16.24	170,492	279.04	151,830	18,662
	OTHER	0	4.39	198.61	0.33	198.36	0.25	13,857	22.68	13,654	203
scao08celadm04	CONNDEMO	3094411576	87.40	3,859.33	6.32	2,547.77	1,311.56	679,719	1,112.47	358,022	321,697
	ASM	1	9.27	409.36	0.67	395.58	13.78	69,417	113.61	51,029	18,388
	OTHER	0	3.33	146.97	0.24	146.46	0.52	12,681	20.75	12,289	392
scao08celadm05	CONNDEMO	3094411576	85.21	3,768.99	6.17	2,382.90	1,386.08	698,980	1,143.99	364,008	334,972
	ASM	1	9.43	417.01	0.68	396.49	20.52	120,105	196.57	101,230	18,875
	OTHER	0	5.37	237.37	0.39	236.75	0.62	15,845	25.93	15,501	344
scao08celadm06	CONNDEMO	3094411576	85.51	3,795.68	6.21	2,429.84	1,365.84	699,088	1,144.17	364,553	334,535
	ASM	1	8.81	391.25	0.64	372.63	18.63	25,656	41.99	6,582	19,074
	OTHER	0	5.68	251.93	0.41	251.76	0.16	16,545	27.08	16,391	154
scao08celadm07	CONNDEMO	3094411576	76.31	4,103.26	6.72	2,648.95	1,454.30	731,245	1,196.80	385,012	346,233
	OTHER	0	16.65	895.44	1.47	895.13	0.31	96,167	157.39	95,997	170
	ASM	1	7.03	378.20	0.62	0.21	377.99	1,869	3.06	430	1,439

Back to Exadata Top Database Consumers
Back to Exadata Statistics

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	2,048	998	1,333.77	0.00	0.00	0.00	0.00	209,710
E	2,048	988	1,347.40	0.00	0.00	0.00	0.00	209,710

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
256	0.13	716,606.88	740,624.62	49.00	2,412	26,609,050
512	0.25	716,606.88	737,687.39	49.00	2,067	26,555,416
1,024	0.50	716,606.88	686,635.54	51.00	220	25,623,209
1,536	0.75	716,606.88	671,190.93	52.00	45	25,341,190
2,048	1.00	716,606.88	660,634.88	52.00	31	25,148,437
2,458	1.20	716,606.88	660,634.88	52.00	18	25,148,437
2,867	1.40	716,606.88	660,634.88	52.00	0	25,148,437
3,277	1.60	716,606.88	165,158.72	81.00	0	16,101,041
3,686	1.80	716,606.88	165,158.72	81.00	0	16,101,041
4,096	2.00	716,606.88	165,158.72	81.00	0	16,101,041
6,144	3.00	716,606.88	165,158.72	81.00	0	16,101,041
8,192	4.00	716,606.88	165,158.72	81.00	0	16,101,041
12,288	6.00	716,606.88	165,158.72	81.00	0	16,101,041
16,384	8.00	716,606.88	165,158.72	81.00	0	16,101,041

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
3,296	1.00	225	9,499	21,649,960	1.00	128,172	1.00	646,304
3,328	1.01	289	11,733	21,649,976	1.00	128,156	1.00	646,308
3,360	1.02	334	13,320	21,649,988	1.00	128,144	1.00	646,310
3,392	1.03	366	14,424	21,650,001	1.00	128,131	1.00	646,313
3,424	1.04	410	15,949	21,650,008	1.00	128,124	1.00	646,315
3,456	1.05	474	18,161	21,650,014	1.00	128,118	1.00	646,317
3,488	1.06	529	20,074	21,650,019	1.00	128,113	1.00	646,318
3,520	1.07	561	21,182	21,650,024	1.00	128,108	1.00	646,320
3,552	1.08	593	22,290	21,650,028	1.00	128,104	1.00	646,321
3,584	1.09	625	23,398	21,650,032	1.00	128,100	1.00	646,322
3,648	1.11	689	25,615	21,650,042	1.00	128,090	1.00	646,325
4,000	1.21	1,040	37,789	21,650,125	1.00	128,007	1.00	646,342
4,352	1.32	1,392	49,969	21,650,263	1.00	127,869	1.00	646,368
4,704	1.43	1,744	62,117	21,650,460	1.00	127,672	1.00	646,400
5,056	1.53	2,095	74,288	21,650,789	1.00	127,343	0.99	646,444
5,408	1.64	2,447	86,443	21,651,148	1.00	126,984	0.99	646,489
5,760	1.75	2,799	98,495	21,651,511	1.00	126,621	0.99	646,545
6,112	1.85	3,151	110,705	21,651,859	1.00	126,273	0.99	646,589
6,464	1.96	3,503	122,833	21,652,184	1.00	125,948	0.98	646,626
6,816	2.07	3,855	135,022	21,652,490	1.00	125,642	0.98	646,656

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
PS-PX Process Reservation	12,864	12,860	4	3,692	1	0.21
FB-Format Block	1,411	1,411	0	367	0	0.40
CF-Controlfile Transaction	1,322	1,322	0	37	0	0.35
TX-Transaction	1,312,162	1,312,637	0	3	0	2.00
WF-AWR Flush	28	28	0	17	0	0.24
TM-DML	1,142	1,142	0	3	0	0.67
HW-Segment High Water Mark	7,952	7,952	0	4	0	0.25
US-Undo Segment	5	5	0	4	0	0.25
TA-Instance Undo	3	3	0	3	0	0.33
TD-KTF map table enqueue (KTF dump entries)	2	2	0	2	0	0.50
DW-In memory Dispenser	3	3	0	2	0	0.00
AF-Advisor Framework (task serialization)	13	13	0	1	0	0.00
CU-Cursor	4,259,636	4,260,216	0	0	0
JG-Job Scheduler1	20,304	20,304	0	0	0
JG-Job Scheduler1 (queue lock)	20,304	20,304	0	0	0
SE-Session Migration	1,912	1,912	0	0	0
JG-Job Scheduler1 (q mem clnup lck)	1,504	1,504	0	0	0
KA-Kernel Service ACL (ACL control status)	406	406	0	0	0
DD-ASM Local Disk Group	212	212	0	0	0
CR-Reuse Block Range (block range reuse ckpt)	186	186	0	0	0
BU-Buddy Instance Context (recovery set construct)	67	67	0	0	0
TT-Tablespace	58	58	0	0	0
MR-Media Recovery	48	48	0	0	0
PR-Process Startup	48	48	0	0	0
PV-KSV slave startup (syncstart)	47	47	0	0	0
AE-Edition Lock (lock)	42	42	0	0	0
SJ-KTSJ Slave Task Cancel (Slave Task Cancel)	30	30	0	0	0
WT-AWR CDB-Wide Table Lock	26	26	0	0	0
JD-Job Queue Date	20	20	0	0	0
SQ-Sequence Cache	19	19	0	0	0
TH-Threshold Chain (metric threshold evaluation)	10	10	0	0	0
PE-Parameter	8	8	0	0	0
PG-Global Parameter	4	4	0	0	0
TO-Temp Object	4	4	0	0	0
PW-Buffer Cache PreWarm (flush prewarm buffers)	3	3	0	0	0
SH-Active Session History Flushing	3	3	0	0	0
IS-Instance State	1	1	0	0	0
JZ-Join group dictionary (Join group dictionary)	1	1	0	0	0
RS-Reclaimable Space (read alert level)	1	1	0	0	0

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
shared pool	303,512,705	104,630,201	13,074,197	92,404,222
ges resource hash list	278,113,183	27,423,125	350,983	27,079,498
ges cached resource lists	60,429,435	3,380,516	21,440	3,359,439
ges enqueue table freelist	185,405,031	644,183	3,654	640,578
redo allocation	5,138,476	71,645	989	70,675
ges domain table	185,402,544	31,071	80	30,993
messages	7,138,558	15,832	113	15,722
cache buffers chains	68,823,662	10,310	105	10,207
post/wait queue	4,132,192	9,991	86	9,906
shared pool simulator	17,070,777	6,639	453	6,189
enqueue hash chains	11,331,329	4,962	167	4,798
ASM map operation hash table	2,477,666	4,588	18	4,570
lgwr LWN SCN	1,212,342	4,490	8	4,482
KJCT flow control latch	6,266,088	3,882	1	3,881
redo writing	3,812,944	3,155	33	3,122
ges group table	185,418,216	2,518	6	2,512
undo global data	5,188,047	1,288	21	1,269
Consistent RBA	1,147,728	955	1	954
KJC message pool free list	406,724	952	372	581
space background task latch	362	129	109	23
active checkpoint queue latch	70,161	125	1	124
session allocation	1,643,970	113	5	108
gc element	487,687	73	1	72
gcs resource hash	420,924	33	2	31
Shared context latch	27,133	3	4	0
hash table column usage latch	445	3	1	2
Shared context root latch	94	1	1	0
parameter table management	7,520	1	1	0

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	17,954	17,954
64K	128K	209	209
128K	256K	15	15
256K	512K	8	8
512K	1024K	3	3
1M	2M	309	309
2M	4M	102	102
4M	8M	4	4
8M	16M	122	122

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	502	2	3
undo header	898	0	0
1st level bmb	220	0	0
undo block	136	0	0
2nd level bmb	2	0	0
segment header	1	0	0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ Background: interrupt command latch	1	0.00		0	21	0.00
AQ Coord jobx_kwsbgsgn latch	20	0.00		0	0
AQ Sharded master pool latch	20	0.00		0	0
AQ deq hash table latch	1	0.00		0	0
AQ dequeue txn counter latch	120	0.00		0	0
ASM Keyed state latch	94	0.00		0	0
ASM allocation	36,493	0.00		0	0
ASM connection state latch	1,359	0.22	0.00	0	0
ASM db client latch	492	0.00		0	0
ASM map headers	404	0.00		0	0
ASM map load waiting list	4	0.00		0	0
ASM map operation freelist	26	0.00		0	0
ASM map operation hash table	2,477,666	0.19	0.00	0	0
ASM network background latch	1,020	0.00		0	0
ASM network state latch	218	0.00		0	0
ASM remote client latch	10	0.00		0	0
AWR Alerted Metric Element list	6,407	0.00		0	0
Change Notification Hash table latch	205	0.00		0	0
Column stats entry latch	1	0.00		0	0
Consistent RBA	1,147,728	0.08	0.00	0	0
DML lock allocation	7,384,928	0.00		0	0
Event Group Locks	5,789	0.00		0	0
FIB s.o chain latch	8	0.00		0	0
FOB consolidated s.o list latch	8	0.00		0	0
File State Object Pool Parent Latch	1	0.00		0	0
GCS logfile block	1	0.00		0	0
GCS logfile write queue	1	0.00		0	0
Hang Manager wait event statistics	40	0.00		0	6,882	0.00
I/O Staticstics latch	1	0.00		0	0
ILM Stats Stripe Latch	1	0.00		0	0
ILM Stats main anchor latch	3,244	0.00		0	0
ILM access tracking extent	1	0.00		0	0
ILM activity tracking latch	1	0.00		0	0
IM Global dictionary latch	1	0.00		0	0
IM Global dictionary queue latch	1	0.00		0	0
IM Global dictionary rw latch	1	0.00		0	0
IM area sb latch	1	0.00		0	0
IM area scb latch	1	0.00		0	0
IM emb latch	1	0.00		0	0
IM seg hdr latch	1	0.00		0	0
IMFS defer write list	1	0.00		0	0
IPC other latch	7	0.00		0	0
IPC stats buffer allocation latch	1	0.00		0	0
In memory undo latch	1	0.00		0	0
JS Sh mem access	754	0.00		0	0
JS broadcast add buf latch	770	0.00		0	0
JS broadcast drop buf latch	770	0.00		0	0
JS broadcast load blnc latch	18	0.00		0	0
JS mem alloc latch	5	0.00		0	0
JS queue access latch	6	0.00		0	0
JS queue state obj latch	40,644	0.00		0	0
JS slv state obj latch	1	0.00		0	0
KCNIBR - invalid block range tree	1	0.00		0	0
KDCStatHash latch	1	0.00		0	0
KDMADO action list latch	1	0.00		0	0
KDMADO bll latch	1	0.00		0	0
KDMADO latch	1	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KFIAS client latch	1	0.00		0	0
KFIAS cluster latch	1	0.00		0	0
KFIAS endpoint latch	1	0.00		0	0
KFIAS node latch	1	0.00		0	0
KFIAS process latch	1	0.00		0	0
KFIAS queue latch	1	0.00		0	0
KFK SGA Libload latch	66,276	0.00		0	0
KFMD SGA	604	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	205	0.00		0	0
KJC message pool free list	406,724	0.23	0.39	0	1,842	43.54
KJC message pool pending avail list	1	0.00		0	0
KJCT flow control latch	6,266,088	0.06	0.00	0	0
KMG MMAN ready and startup request latch	425	0.00		0	0
KMG resize request state object freelist	2	0.00		0	0
KSFS OFS ctx level parent latch	1	0.00		0	0
KSFS OFS req layer parent latch	1	0.00		0	0
KSFS OFS sess layer parent latch	1	0.00		0	0
KSFS Receive and Send Queue latch	1	0.00		0	0
KSFS id table parent latch	1	0.00		0	0
KSFS ksfs_node latch	1	0.00		0	0
KSFSD name cache parent latch	1	0.00		0	0
KSGL LS Segment latch	1	0.00		0	0
KSGL SGA anchor latch	1	0.00		0	0
KSIPC SGA allocation parent latch	648	0.00		0	0
KSK PDB IO STAT	1	0.00		0	0
KSRMA SGA anchor latch	1	0.00		0	0
KSRMF SGA anchor latch	1	0.00		0	0
KSXR hang analysis phase 1 latch	3,737	0.00		0	0
KSXR hang analysis phase 2 latch	213	0.00		0	0
KSXR large replies	22	0.00		0	0
KTF sga latch	4	0.00		0	228	0.00
KTILM latch	1	0.00		0	0
KTU in-memory txn table latch	1	0.00		0	0
KWQMN job cache list latch	102	0.00		0	0
KXDBIO latch	11	0.00		0	0
Latch for NonceHistory	1	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	347	0.00		0	0
MQL Tracking Latch	0			0	12	0.00
Memory Management Latch	65	0.00		0	424	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
Message cache latch	1	0.00		0	0
MinActiveScn Latch	30	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
Nologging Standby SCN Time Map cache	204	0.00		0	0
OS process	634	0.00		0	0
OS process allocation	1,506	0.00		0	0
OS process: request allocation	94	0.00		0	0
PDB Hash Table Latch	1	0.00		0	0
PDB LRU structure	1	0.00		0	0
PL/SQL warning settings	1,913	0.00		0	0
PX hash array latch	1	0.00		0	0
Parent latch for dependency tracking	1	0.00		0	0
Parent latch for query hash table access	1	0.00		0	0
Parent latch for segments scanning	1	0.00		0	0
QMT	1	0.00		0	0
Real-time descriptor latch	11,317	0.00		0	0
Report Request stats latch	40	0.00		0	0
Request holder compeltion list latch	99	0.00		0	0
Retry Ht elm latch	1	0.00		0	0
Retry bkt latch	1	0.00		0	0
SGA Blackbox latch	2	0.00		0	0
SGA IO buffer pool latch	18	0.00		0	18	0.00
SGA Logging Bkt Latch	1	0.00		0	0
SGA Logging Log Latch	15,245	0.00		0	0
SGA blob parent	1	0.00		0	0
SGA bucket locks	1	0.00		0	0
SGA heap locks	1	0.00		0	0
SGA pool locks	1	0.00		0	0
SQL memory manager latch	1	0.00		0	203	0.00
SQL memory manager workarea list latch	19,282	0.00		0	0
SR Stats Stripe Latch	1	0.00		0	0
SR Stats main anchor latch	6,920	0.00		0	0
Sched IM Job latch	11	0.00		0	0
Sched InMem Job Cache	10	0.00		0	0
Shared B-Tree	22	0.00		0	0
Shared context latch	27,133	0.01	1.33	0	0
Shared context root latch	94	1.06	1.00	0	0
Streams Generic	1	0.00		0	0
Subscriber Ht elm latch	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
Txn Ht elm latch	1	0.00		0	0
Txn bkt latch	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	1	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	70,161	0.18	0.01	0	0
active service list	39,498	0.01	0.00	0	622	0.00
archive destination	20	0.00		0	0
begin backup scn array	13	0.00		0	0
buffer pool	2	0.00		0	0
business card	3,667	0.00		0	0
cache buffer handles	16,794	0.01	0.00	0	0
cache buffers chains	68,823,662	0.01	0.01	0	749,948	0.00
cache buffers lru chain	435,855	0.01	0.00	0	645,236	0.01
cache table scan latch	1	0.00		0	1	0.00
call allocation	18,479	0.08	0.00	0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	191	0.00		0	0
channel operations parent latch	20,487	0.10	0.00	0	0
checkpoint queue latch	2,880,246	0.00	0.00	0	366,149	0.00
client/application info	11,319	0.00		0	0
compile environment latch	1,913	0.00		0	0
connection pool sga data lock	122	0.00		0	0
corrupted undo seg latch	10	0.00		0	0
cp handoff latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	10	0.00		0	0
cp srv type state latch	610	0.00		0	0
cp srv type wait latch	1	0.00		0	0
cr slave free list	1	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	10	0.00		0	0
dispatcher info	10	0.00		0	0
dml lock allocation	10	0.00		0	0
done queue latch	1	0.00		0	0
dtp latch	45	0.00		0	0
dummy allocation	3,823	0.00		0	0
eighth spare latch - X parent	1	0.00		0	0
eleventh spare latch - children	1	0.00		0	0
enqueue freelist latch	1	0.00		0	8,644,586	0.02
enqueue hash chains	11,331,329	0.04	0.03	0	1	0.00
enqueues	59	0.00		0	0
error message lists	9,163	0.01	0.00	0	0
fifteenth spare latch - children	1	0.00		0	0
file cache latch	1,537	0.00		0	0
flash file access latch	1	0.00		0	0
flashback copy	1	0.00		0	0
fourteenth spare latch - children	1	0.00		0	0
fourth Audit Vault latch	1	0.00		0	0
gc element	487,687	0.01	0.01	0	18,194	0.04
gc xid list	3,014	0.00		0	0
gcs commit scn state	1	0.00		0	0
gcs nodemap pool	58	0.00		0	0
gcs opaque info freelist	9,437	0.01	0.00	0	0
gcs partitioned table hash	3,232,986	0.03	0.00	0	106,470	0.02
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs remaster request queue	3	0.00		0	0
gcs resource freelist	17,653	0.00		0	0
gcs resource hash	420,924	0.01	0.06	0	0
gcs resource scan list	1	0.00		0	0
gcs shadows freelist	171	0.00		0	0
ges cached resource lists	60,429,435	5.59	0.01	5	142,676	5.62
ges deadlock list	24	0.00		0	0
ges domain table	185,402,544	0.02	0.00	0	0
ges enqueue table freelist	185,405,031	0.35	0.01	1	0
ges group table	185,418,216	0.00	0.00	0	0
ges process hash list	45,457	0.00		0	0
ges process parent latch	370,827,995	0.00	0.00	0	0
ges process table freelist	94	0.00		0	0
ges resource hash list	278,113,183	9.86	0.01	134	24,141	0.03
ges resource scan list	105	0.00		0	0
ges resource table freelist	43,533	0.07	0.00	0	0
ges s-lock bitvec freelist	1,264	0.00		0	0
ges timeout list	7,325	0.00		0	96	0.00
ges value block free list	174	0.00		0	0
global tx hash mapping	1	0.00		0	0
granule from data transfer cache	1	0.00		0	0
gws:Sharding global descriptor latch	40	0.00		0	0
hash table Sql Plan Finding latch	64	0.00		0	11,333,834	0.11
hash table column usage latch	445	0.67	0.33	0	18,497,969	0.15
hash table expression usage tracking latch	1	0.00		0	0
heartbeat check	1	0.00		0	3,605	0.00
heartbeat structure management	0			0	306	0.00
imc buf hdl lat	1	0.00		0	0
imc cr clone buf	1	0.00		0	0
imc hash lat	1	0.00		0	0
imc sj lat	1	0.00		0	0
imc srchsp lat	1	0.00		0	0
imc-txn-wrk-lat	1	0.00		0	0
in-memory area latch	1	0.00		0	0
in-memory columnar segment hash table latch	1	0.00		0	0
in-memory columnar ts extent map chunk latch	1	0.00		0	0
in-memory global pool latch	1	0.00		0	0
internal temp table object number allocation latch	59	0.00		0	0
interrupt manipulation	9,291	0.00		0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	1	0.00		0	0
job_queue_processes parameter latch	1	0.00		0	0
k2q global data latch	408	0.00		0	0
k2q lock allocation	1	0.00		0	0
kcb DW scan objtemp hash table latch	1	0.00		0	0
kcfis latch	10	0.00		0	0
kcn buffer chains	1	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kgnfs mount latch	1	0.00		0	0
kjci objects freelist latch	1	0.00		0	0
kjci process context latch	1	0.00		0	21,401	0.00
kjoedcso state object freelist latch	10	0.00		0	0
kjoeq omni enqueue hash bucket latch	1	0.00		0	0
kjoer owner hash bucket	1	0.00		0	0
kjpm my inst data	20	0.00		0	0
kjsc protect control request queue	0			0	6,110	0.00
kjsca protect pkey hash table bucket	1	0.00		0	0
kjsca protect service hash table bucket	1	0.00		0	0
kokc descriptor allocation latch	126	0.00		0	0
krso process	22	0.00		0	0
ksbxic instance latch	50	0.00		0	0
ksevn object root latch	204	0.00		0	0
ksfv messages	1	0.00		0	0
ksi resource reuse count	1	0.00		0	0
ksim group membership cache	17,048,614	0.07	0.00	0	0
ksim membership request latch	0			0	459	0.00
kss move lock	97	0.00		0	0
ksuosstats global area	60	0.00		0	233	0.00
ksv allocation latch	198	0.00		0	0
ksv class latch	14,216	0.01	0.00	0	0
ksv msg queue latch	13	0.00		0	12	0.00
ksxp shared latch	94	0.00		0	0
ksxp so latch	94	0.00		0	0
ksz_so allocation latch	116	0.00		0	0
ktfbn latch	157	0.00		0	0
ktm adg jrnls	1	0.00		0	0
ktm adg lookuptable	1	0.00		0	0
ktm adg space	1	0.00		0	0
ktm adg stages	1	0.00		0	0
ktm global data	27	0.00		0	0
ktm prv jrnls	1	0.00		0	0
ktmpj HT ls	1	0.00		0	0
kwqbsn:qsga	21	0.00		0	0
kwslbmdl: metadata latch	56	0.00		0	0
kwslbql: queue latch	1	0.00		0	0
kwsptQcachLt: queue cache latch	1	0.00		0	0
kwsptTrncTsksLt: trunc task latch	1	0.00		0	0
kwsptjobAdPtLt: AdPt list latch	14	0.00		0	0
kwsslLat: skiplist latch	1	0.00		0	0
kxfxscanrate_latch	1	0.00		0	0
lgwr LWN SCN	1,212,342	0.37	0.00	0	0
list of block allocation	47	0.00		0	0
loader state object freelist	6	0.00		0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	25	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
log write info	0			0	1,204,957	0.21
log write worker phase	192,984	0.04	0.00	0	0
logical standby cache	1	0.00		0	0
logminer context allocation	1	0.00		0	0
logminer local	1	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	1	0.00		0	0
managed standby	21	0.00		0	0
message bitmap latch	1	0.00		0	0
message pool operations parent latch	6,169	0.02	0.00	0	0
messages	7,138,558	0.22	0.01	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	716	0.00		0	0
name-service memory objects	2,363	0.00		0	0
name-service namespace bucket	4,269,429	0.02	0.00	0	0
name-service pending queue	1,454	0.00		0	0
name-service request	6	0.00		0	0
name-service request queue	7,992	0.00		0	0
ncodef allocation latch	10	0.00		0	0
ninth spare latch - X parent	1	0.00		0	0
object queue header freelist	7,755	0.00		0	3,475	0.00
object queue header operation	1,458,559	0.00	0.00	0	15,667	0.02
object queue memory	1	0.00		0	0
object stats modification	61	0.00		0	0
parallel query alloc buffer	29,513	0.00		0	114	0.00
parallel query stats	7,364	0.00		0	0
parallel txn reco latch	24,888	0.00		0	0
parameter table management	7,520	0.01	1.00	0	0
pdb enqueue hash chains	1	0.00		0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
pkey global statistics	1	0.00		0	0
pmon dead latch	10	0.00		0	0
post/wait queue	4,132,192	0.24	0.01	0	1,476,154	0.36
process allocation	3,183	0.03	0.00	0	0
process group creation	94	0.00		0	0
process pkey statistics list	1	0.00		0	0
process queue	12,926	0.00		0	0
process queue reference	324,785	0.00	0.00	0	35,168	0.03
qmn task queue latch	84	0.00		0	0
query server freelists	16,560	0.00		0	0
query server process	2,239	0.00		0	1	0.00
queued dump request	2	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash bucket	244	0.00		0	0
redo allocation	5,138,476	1.39	0.01	0	6,879,352	2.71
redo copy	1	0.00		0	6,945,715	0.06
redo transport task	1	0.00		0	0
redo writing	3,812,944	0.08	0.01	0	0
reid allocation latch	22	0.00		0	0
remote tool request latch	1,909	0.00		0	0
resmgr group change latch	1,869	0.00		0	0
resmgr:active threads	3,838	0.00		0	10	0.00
resmgr:actses change group	1,913	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	3,822	0.00		0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:plan change alloc latch	1	0.00		0	0
resmgr:plan change latch	1	0.00		0	0
resmgr:resource group CPU method	53	0.00		0	0
resmgr:schema config	75	0.00		0	10	0.00
resmgr:session queuing	1	0.00		0	0
row cache objects	1	0.00		0	16	0.00
second Audit Vault latch	1	0.00		0	0
segmented array pool	8	0.00		0	0
sequence cache	482	0.00		0	0
service drain list	611	0.00		0	0
session allocation	1,643,970	0.01	0.04	0	1,640,048	0.01
session idle bit	25,784,499	0.00	0.00	0	0
session queue latch	1	0.00		0	0
session state list latch	3,826	0.00		0	0
session statistics	3,824	0.00		0	0
session switching	56	0.00		0	0
session timer	203	0.00		0	0
seventh spare latch - X parent	1	0.00		0	0
sga hash table parent latch	1	0.00		0	0
shard latch	1	0.00		0	0
shared pool	303,512,705	34.47	0.12	4272	1,148	39.81
shared pool sim alloc	1	0.00		0	0
shared pool simulator	17,070,777	0.04	0.07	0	0
shared server configuration	205	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	1,446,460	0.00		0	0
simulator lru latch	434	0.00		0	1,433,427	0.01
sixth spare latch - X parent	1	0.00		0	0
sort extent pool	31	0.00		0	0
space background state object latch	6	0.00		0	0
space background task latch	362	35.64	0.84	0	408	0.98
state object free list	2	0.00		0	0
statistics aggregation	174	0.00		0	0
storage server table manipulation latch	20	0.00		0	0
subscriber Ht bkt	1	0.00		0	0
tablespace key chain	1	0.00		0	0
tenth spare latch - X parent	1	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
test excl. parent2 lmid cln	1	0.00		0	0
test mode exclusive	1	0.00		0	0
test open exclusive	1	0.00		0	0
test pdb exclusive	1	0.00		0	0
test shared parent2 lmid	1	0.00		0	0
thirteenth spare latch - children	1	0.00		0	0
threshold alerts latch	32	0.00		0	0
transaction allocation	30,786	0.00		0	0
twelfth spare latch - children	1	0.00		0	0
twenty-fifth spare latch - S par	1	0.00		0	0
twenty-first spare latch - S par	1	0.00		0	0
twenty-fourth spare latch - S par	1	0.00		0	0
twenty-second spare latch - S par	1	0.00		0	0
twenty-third spare latch - S par	1	0.00		0	0
undo global data	5,188,047	0.02	0.02	0	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0

Latch Name	Where	Sleeps	Waiter Sleeps
ASM map operation hash table	kffmDoDone_1	11	8
ASM map operation hash table	kffmTranslate	7	10
KJC message pool free list	kjcspfmbq: free vector of msg buffers	319	0
KJC message pool free list	kjcsmpav: allocate a msg buffer	53	372
KJCT flow control latch	kjcts_sqenq: queue a message	1	0
Shared context latch	ksm_mga_detach_whr2	3	0
Shared context latch	ksm_mga_attach_whr2	1	2
Shared context root latch	ksm_mga_attach_whr1	1	0
active checkpoint queue latch	kcbbacq: scan active checkpoints	1	1
active service list	kswslogon: session logout	2	0
cache buffers chains	kcbgcur: fast path excl	53	21
cache buffers chains	kcbnlc	21	15
cache buffers chains	kcbgtcr: fast path pin	16	4
cache buffers chains	kcbchg: cur pin change	8	8
cache buffers chains	kcbgtcr: fast path exam	8	11
cache buffers chains	kcbchg: change complete	6	11
cache buffers chains	kcbchg: aux pin	1	1
cache buffers chains	kcbget: new pin	1	0
cache buffers chains	kcbrls: fast pin release	1	15
cache buffers chains	kcbzcbf: clone buffer	1	23
cache buffers chains	kcbzgb: scan from tail nowait	1	0
cache buffers chains	kcbzwb	1	0
cache buffers chains	kclcls_3	1	0
enqueue hash chains	ksqgtl3	107	82
enqueue hash chains	ksqrcl	59	84
enqueue hash chains	ksqcmi: if lk mode not requested	1	0
gc element	kclnfndnewm	1	0
gcs resource hash	kclfwrite1	2	1
ges cached resource lists	kjrm2c: move resource to cache	21,343	21,436
ges cached resource lists	kjruch: cached obj cleanup	70	0
ges cached resource lists	kjchc: clean resource cache	28	0
ges domain table	kjdmlad: add a lock to an xid-hashed lock list	45	53
ges domain table	kjdmlrm: remove a lock from its xid-hashed lock list	35	27
ges enqueue table freelist	kjlalc: lock allocation	2,044	2,673
ges enqueue table freelist	kjlfr: remove lock from parent object	1,611	982
ges group table	kjgagll: move a lock from process lock list to group lock list	3	3
ges group table	kjgdgll: move a lock from group lock list to process lock list	3	3
ges resource hash list	kjrmas1: lookup master node	202,485	15,969
ges resource hash list	kjlrlr: remove lock from resource queue	124,742	57,830
ges resource hash list	kjrref: find matched resource	23,807	277,235
ges resource hash list	kjucvl: lock convert request	5	0
hash table column usage latch	KSXMMON_GETCELEM	1	0
messages	ksaamb: after wakeup	77	57
messages	ksarcv	23	12
messages	ksarcv: after wait	13	44
mostly latch-free SCN	kcs024	6	0
mostly latch-free SCN	kcslcu3	2	8
mostly latch-free SCN	kcsnew_scn_rba	1	0
parameter table management	kspallmod	1	0
post/wait queue	kslpstevent:get	32	48
post/wait queue	ksliwat:add:nowait	31	0
post/wait queue	kslpstevent:reget	19	37
post/wait queue	ksliwat:remove	3	0
post/wait queue	ksliwat:add:wait	1	1
redo allocation	kcrfw_redo_gen: redo allocation 1	620	0
redo allocation	kcrfw_post: more space	147	350
redo allocation	kcrfw_redo_gen: redo allocation 3	109	256
redo allocation	kcrfw_redo_write: before write	103	383
redo allocation	kcrfw_redo_gen: redo allocation 2	10	0
redo writing	kcrfw_post: rba scn pair	27	0
redo writing	kcrfwcr	3	12
redo writing	kcrfw_cal_target_rba	2	21
redo writing	kcrfw_post: after write	1	0
session allocation	kspallmod	4	0
session allocation	ksucri_int : SSO	1	3
shared pool simulator	kglsim_upd_newhp	447	287
shared pool simulator	kglsim_chg_simhp_free	6	73
space background task latch	ktsj_grab_task	96	107
space background task latch	ktsj_detach_task	5	2
undo global data	ktudnx:child	17	8
undo global data	ktudba: KSLBEGIN	3	3
undo global data	ktucof: at start	1	0
unknown latch	kghalo	6,844,730	5,981,343
unknown latch	kghalp	3,344,771	3,542,231
unknown latch	kghupr1	2,157,129	3,024,637
unknown latch	kgh_heap_sizes	339,264	451,162
unknown latch	kghasp	291,693	51,180
unknown latch	kghfre	93,362	21,412
unknown latch	kghfrunp: alloc: wait	163	0
unknown latch	spmemrm_use_free_mem	84	71
unknown latch	kgh: add new extent	27	5
unknown latch	kghfrh	16	22
unknown latch	No latch	8	0

Mutex Type	Location	Sleeps	Wait Time (ms)
Library Cache	kglhdgn2 106	7,100,973	21,071,491
Row Cache	[19] kqrpre	3,552,444	11,194,295
Library Cache	kglpin1 4	341,336	200,442
Row Cache	[06] kqrGetClusterLock	276,008	166,498
Row Cache	[13] kqreqd	269,328	81,712
Library Cache	kglpndl1 95	248,807	179,826
Library Cache	kgllkdl1 85	216,273	142,264
Library Cache	kglpnal1 90	121,764	67,890
Library Cache	kglget1 1	75,311	101,382
Library Cache	kglobpn1 71	60,030	44,162
Library Cache	kglget2 2	19,747	19,796
Library Cache	kgldtin2 142	19,265	14,033
Library Cache	kglhdgn1 62	10,399	27,570
Library Cache	kglrfcl2 165	1,277	3,020
Library Cache	kglllal3 111	550	13
Library Cache	kgllldl2 112	341	7
Row Cache	[32] kqrsfd	323	273
Cursor Pin	kkslce [KKSCHLPIN2]	238	254
Library Cache	kgldtin3 143	68	78
Cursor Pin	kksfbc [KKSCHLFSP2]	48	51
Library Cache	kglGetHandleReference 123	39	97
Row Cache	[05] kqrWaitForObjectLoad	28	37
Cursor Pin	kksLockDelete [KKSCHLPIN6]	14	15
Library Cache	kglic1 49	3	10
Row Cache	[17] kqrCreateUsingSecondaryKey	1	0
Library Cache	kglic4 145	1	0

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Obj#	Dataobj#	Logical Reads	%Total
CLO_NORMAL	IDXTBS	PK_T_SESSION		INDEX	285510	285510	7,873,808	29.34
CLO_NORMAL	IDXTBS	T_SESSION	T_SESSION_N1	TABLE PARTITION	98521	285499	5,238,144	19.52
CLO_NORMAL	IDXTBS	I_XYDC_DETAIL_SERIAL_DETAIL	T_GAME_XYDC_DETAIL_N1	INDEX PARTITION	98545	285505	3,641,344	13.57
CLO_NORMAL	IDXTBS	T_GAME_XYDC_DETAIL	T_GAME_XYDC_DETAIL_N1	TABLE PARTITION	98526	285498	2,358,592	8.79
SYS	SYSTEM	COL$		TABLE	280553	280546	1,342,576	5.00

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Obj#	Dataobj#	CR Blocks Received	%Total
SYS	SYSAUX	WRH$_SEG_STAT_OBJ		TABLE	8481	8481	44	1.60
SYS	SYSAUX	WRH$_SYSSTAT_PK	WRH$_SYSSTAT_5801112_26985	INDEX PARTITION	285340	285340	14	0.51
SYS	SYSTEM	SEG$		TABLE	14	8	9	0.33
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_SESSION_HISTORY_5801112_26985	TABLE PARTITION	285358	285358	9	0.33
SYS	SYSAUX	WRH$_SYSSTAT	WRH$_SYSSTAT_5801112_26985	TABLE PARTITION	285338	285338	9	0.33

Owner	Tablespace Name	Object Name	Obj. Type	Obj#	Dataobj#	Current Blocks Received	%Total
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	8311	8311	1,629	18.07
SYS	SYSAUX	SCHEDULER$_EVENT_LOG	TABLE	7902	7902	1,001	11.11
SYS	SYSTEM	SEG$	TABLE	14	8	766	8.50
SYS	SYSAUX	SMON_SCN_TIME	TABLE	346	344	375	4.16
SYS	SYSAUX	WRH$_SQLTEXT	TABLE	8303	8303	317	3.52

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	16	12.50	2	1
dc_global_oids	157	12.74	0	13
dc_histogram_data	5,298,859	0.20	0	1,179
dc_histogram_defs	35,349,334	0.05	0	2,019
dc_object_grants	27	11.11	0	2
dc_objects	27,219,789	0.01	0	697
dc_props	492	0.00	0	1
dc_rollback_segments	116,173	0.00	0	8,298
dc_segments	5,128	66.30	19	259
dc_sequences	19	26.32	19	1
dc_tablespaces	330	48.79	0	5
dc_users	29,810,479	0.00	0	11
outstanding_alerts	9	100.00	0	0
sch_lj_oids	3	100.00	0	0

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	121	4.96	209	12.92	21	0
CLUSTER	742	8.63	742	8.63	0	0
EDITION	43	34.88	43	34.88	0	0
INDEX	1,637,513	-0.00	1,637,525	0.00	21	0
QUEUE	60	100.00	60	100.00	0	0
SCHEMA	6,211	0.05	0		0	0
SQL AREA	8,517,625	99.95	13,529,685	94.37	3,450	2
SQL AREA BUILD	4,259,382	99.99	0		0	0
SQL AREA STATS	4,257,192	100.00	4,258,848	100.00	0	0
TABLE/PROCEDURE	4,282,846	0.03	19,903,091	0.05	11,956	0
TRANSFORMATION	60	100.00	60	100.00	0	0
TRIGGER	8	100.00	8	100.00	0	0

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Oper Count	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT buffer cache	4,224.00	4,192.00	4,192.00	4,800.00	1	SHR/IMM
Data Transfer Cache	0.00	0.00	0.00	0.00	0	STA/
In Memory RO Extension Area	0.00	0.00	0.00	0.00	0	STA/
In Memory RW Extension Area	0.00	0.00	0.00	0.00	0	STA/
In-Memory Area	0.00	0.00	0.00	0.00	0	STA/
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	2,048.00	2,048.00	2,048.00	2,048.00	0	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	0.00	0.00	0.00	0.00	0	STA/
Shared IO Pool	320.00	320.00	0.00	320.00	0	GRO/IMM
java pool	64.00	64.00	64.00	64.00	0	STA/
large pool	2,048.00	2,048.00	2,048.00	2,048.00	0	STA/
shared pool	3,264.00	3,296.00	3,008.00	3,296.00	1	GRO/IMM
streams pool	0.00	0.00	0.00	0.00	0	STA/

Start	Ela (s)	Component	Oper Typ/Mod	Init Size (M)	Delta	Target Delta	Final (M)	Sta
08/25 12:37:34	0	bufcache	SHR/IMM	4,224	-32		4,192	COM
08/25 12:37:34	0	shared	GRO/IMM	3,264	32		3,296	COM

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Freeable	44.81	0.00	0.33	0.31	3		135	135
B	Other	1,256.94		6.13	15.73	161	167	205	205
B	PL/SQL	18.74	7.96	0.09	0.41	4	9	203	202
B	SQL	15.80	3.96	0.11	0.22	2	56	142	129
B	Total	1,336.29	11.92	6.67	16.67	170	231	685	671
E	Freeable	44.63	0.00	0.33	0.31	3		136	136
E	Other	1,268.86		6.07	15.60	161	167	209	209
E	PL/SQL	19.23	8.42	0.09	0.41	4	9	207	206
E	SQL	16.52	4.13	0.11	0.22	2	56	144	133
E	Total	1,349.24	12.55	6.61	16.53	170	231	696	684

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	4,764,729,344	4,731,174,912
Fixed Size	12,170,616
Redo Buffers	21,381,120
Variable Size	5,704,256,136	5,737,810,568

Resource Name	Current Utilization	Maximum Utilization	Limit
ges_cache_ress	106,740	108,970	UNLIMITED
smartio_buffer_memory	0	237,708,576	UNLIMITED
smartio_metadata_memory	0	58,752	UNLIMITED
smartio_overhead_memory	0	15,927,552	UNLIMITED
smartio_sessions	0	32	UNLIMITED

Parameter Name	Begin value	End value (if different)
_kgl_cluster_lock_read_mostly	TRUE
_lm_lmd_waittime	1
_optimizer_dsdir_usage_control	0
_use_single_log_writer	ADAPTIVE
audit_file_dest	/u01/app/oracle/admin/conndemo/adump
audit_trail	NONE
cluster_database	TRUE
commit_logging	IMMEDIATE
commit_wait	WAIT
compatible	12.2.0.1.0
connection_brokers	((TYPE=DEDICATED)(BROKERS=1)), ((TYPE=EMON)(BROKERS=1))
control_files	+DATA_TOP7/conndemo/control01.ctl, +DATA_TOP7/conndemo/control02.ctl, +DATA_TOP7/conndemo/control03.ctl
cpu_count	48
db_block_size	8192
db_cache_size	4697620480
db_create_file_dest	+DATA_TOP7
db_domain
db_name	conndemo
db_writer_processes	4
deferred_segment_creation	FALSE
diagnostic_dest	/u01/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=conndemoXDB)
event	27401 trace name context forever, level 16384
instance_number	2
large_pool_size	2147483648
listener_networks
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=10.128.5.128)(PORT=1521)), (ADDRESS=(PROTOCOL=TCP)(HOST=10.128.5.128)(PORT=1522)), (ADDRESS=(PROTOCOL=TCP)(HOST=10.128.5.128)(PORT=1523))
open_cursors	300
optimizer_features_enable	12.1.0.2
parallel_adaptive_multi_user	FALSE
parallel_execution_message_size	16384
parallel_max_servers	96
parallel_min_servers	0
parallel_servers_target	96
parallel_threads_per_cpu	1
pga_aggregate_target	2147483648
plsql_warnings	DISABLE:ALL
processes	9000
recyclebin	OFF
remote_listener	scao08-scan1:1521
remote_login_passwordfile	EXCLUSIVE
resource_manager_plan
sessions	13536
sga_max_size	10502537216
shared_pool_size	3154116608
thread	2
threaded_execution	FALSE
undo_retention	600
undo_tablespace	UNDOTBS22
use_large_pages	ONLY

Parameter Name	Begin value	End value (if different)
connection_brokers	((TYPE=DEDICATED)(BROKERS=1))
connection_brokers	((TYPE=EMON)(BROKERS=1))
control_files	+DATA_TOP7/conndemo/control01.ctl
control_files	+DATA_TOP7/conndemo/control02.ctl
control_files	+DATA_TOP7/conndemo/control03.ctl
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=10.128.5.128)(PORT=1521))
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=10.128.5.128)(PORT=1522))
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=10.128.5.128)(PORT=1523))

Sid, Serial#	% Activity	Event	% Event	User	Program	# Samples Active	XIDs
859,52617	1.08	library cache: mutex X	0.53	CLO_NORMAL	java@scao08adm...m (TNS V1-V3)	30/61 [ 49%]	12
4252,59063	1.08	library cache: mutex X	0.55	CLO_NORMAL	java@scao08adm...m (TNS V1-V3)	31/61 [ 51%]	16
6504,30101	1.08	library cache: mutex X	0.53	CLO_NORMAL	java@scao08adm...m (TNS V1-V3)	30/61 [ 49%]	13
9596,31273	1.08	library cache: mutex X	0.62	CLO_NORMAL	java@scao08adm...m (TNS V1-V3)	35/61 [ 57%]	16
9878,57157	1.08	library cache: mutex X	0.59	CLO_NORMAL	java@scao08adm...m (TNS V1-V3)	33/61 [ 54%]	14

Blocking Sid (Inst)	% Activity	Event Caused	% Event	User	Program	# Samples Active	XIDs
6209,35284( 2)	2.05	row cache mutex	1.96	CLO_NORMAL	java@scao08adm...m (TNS V1-V3)	56/61 [ 92%]	29
3969, 7948( 2)	1.73	row cache mutex	1.62	CLO_NORMAL	java@scao08adm...m (TNS V1-V3)	56/61 [ 92%]	29
3109,60002( 2)	1.53	row cache mutex	1.48	CLO_NORMAL	java@scao08adm...m (TNS V1-V3)	58/61 [ 95%]	33
6508,50034( 2)	1.30	row cache mutex	1.23	CLO_NORMAL	java@scao08adm...m (TNS V1-V3)	57/61 [ 93%]	35
10448,59695( 2)	1.26	row cache mutex	1.21	CLO_NORMAL	java@scao08adm...m (TNS V1-V3)	58/61 [ 95%]	32

Event	Event Class	Session Type	% Activity	Avg Active Sessions
library cache: mutex X	Concurrency	FOREGROUND	45.90	42.24
row cache mutex	Concurrency	FOREGROUND	26.98	24.83
CPU + Wait for CPU	CPU	FOREGROUND	17.27	15.89
latch: shared pool	Concurrency	FOREGROUND	6.69	6.15
log file sync	Commit	FOREGROUND	1.24	1.15

WORKLOAD REPOSITORY report for

Report Summary

Main Report

RAC Statistics

Exadata Configuration and 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 (up to 64 us)

Wait Event Histogram (up to 32 ms)

Wait Event Histogram (up to 2 sec)

Wait Event Histogram (up to 2 min)

Wait Event Histogram (up to 1 hr)

Service Statistics

Service Wait Class Stats

Top 10 Channel Waits

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 Offload Eligible Bytes

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

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

Event	% Event	P1, P2, P3 Values	% Activity	Parameter 1	Parameter 2	Parameter 3
library cache: mutex X	45.90	"2110518249","55770150338560","8978538"	0.37	idn	value	where
row cache mutex	26.98	"10","19","0"	20.83	cache id	where requested	NOT DEFINED
row cache mutex	26.97848123777343055308554152587586697492	"8","19","0"	3.93	cache id	where requested	NOT DEFINED
row cache mutex	26.97848123777343055308554152587586697492	"16","19","0"	1.74	cache id	where requested	NOT DEFINED
latch: shared pool	6.69	"1614798048","551","0"	3.02	address	number	why
latch: shared pool	6.68682198114885292548461675262315489952	"1614797888","551","0"	2.21	address	number	why
log file sync	1.24	"323","106449451130","0"	0.02	buffer#	sync scn	NOT DEFINED

Slot Time (Duration)	Slot Count	Event	Event Count	% Event
12:29:59 (1 secs)	90	row cache mutex	43	0.76
12:29:59 (1 secs)	90	CPU + Wait for CPU	18	0.32
12:29:59 (1 secs)	90	library cache: mutex X	15	0.27
12:30:00 (5.0 min)	2,758	library cache: mutex X	1,293	22.99
12:30:00 (5.0 min)	2758	row cache mutex	709	12.61
12:30:00 (5.0 min)	2758	CPU + Wait for CPU	498	8.86
12:35:00 (5.0 min)	2,775	library cache: mutex X	1,273	22.64
12:35:00 (5.0 min)	2775	row cache mutex	765	13.60
12:35:00 (5.0 min)	2775	CPU + Wait for CPU	480	8.54

Statistic	Total	per Second	per Trans
KA local message waits	0	0.00	0.00
KA local messages received	0	0.00	0.00
KA messages received actual	0	0.00	0.00
KA messages received logical	0	0.00	0.00
KA requests failed	0	0.00	0.00
KA requests succeeded	0	0.00	0.00
acks for commit broadcast(actual)	229	0.37	0.00
acks for commit broadcast(logical)	292	0.48	0.00
broadcast msgs on commit(actual)	1,115,723	1,825.95	0.85
broadcast msgs on commit(logical)	1,146,291	1,875.97	0.88
broadcast msgs on commit(wasted)	211,775	346.58	0.16
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	117	0.19	0.00
gcs ast to fg	98	0.16	0.00
gcs ast xid	0	0.00	0.00
gcs bidless ast to lms	0	0.00	0.00
gcs blocked converts	286	0.47	0.00
gcs blocked cr converts	201	0.33	0.00
gcs compatible basts	70	0.11	0.00
gcs compatible cr basts (global)	29	0.05	0.00
gcs compatible cr basts (local)	4,247	6.95	0.00
gcs cr basts to PIs	0	0.00	0.00
gcs cr requests to slave	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	48,027	78.60	0.04
gcs dbwr write request msgs	40	0.07	0.00
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 flash read serve requests to slave	0	0.00	0.00
gcs force cr block only	7	0.01	0.00
gcs force cr grant	328	0.54	0.00
gcs force cr no current	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs grant ast	98	0.16	0.00
gcs immediate (compatible) converts	163	0.27	0.00
gcs immediate (null) converts	2,341	3.83	0.00
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	312	0.51	0.00
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	133	0.22	0.00
gcs msgs process time(ms)	1,894	3.10	0.00
gcs msgs received	1,040,943	1,703.57	0.79
gcs new served by master	2,015	3.30	0.00
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	96	0.16	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	0	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	19	0.03	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs refuse xid to fg	0	0.00	0.00
gcs refuse xid to lms	0	0.00	0.00
gcs refuse xid to master	0	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	0	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	42	0.07	0.00
gcs side channel msgs logical	990	1.62	0.00
gcs stale cr	397	0.65	0.00
gcs undo cr	2	0.00	0.00
gcs write notification msgs	2	0.00	0.00
gcs writes refused	5	0.01	0.00
ges msgs process time(ms)	29	0.05	0.00
ges msgs received	7,044	11.53	0.01
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	375	0.61	0.00
implicit batch messages sent	44,108	72.19	0.03
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	28	0.05	0.00
messages queue sent actual	1,397,016	2,286.30	1.07
messages queue sent logical	119,063	194.85	0.09
messages received actual	1,039,954	1,701.95	0.79
messages received logical	1,047,987	1,715.09	0.80
messages sent directly	916,137	1,499.31	0.70
messages sent indirectly	1,470,993	2,407.37	1.12
messages sent not implicit batched	3	0.00	0.00
messages sent pbatched	13,175	21.56	0.01
msgs causing lmd to send msgs	0	0.00	0.00
msgs causing lms(s) to send msgs	0	0.00	0.00
msgs received queue time (ms)	7,693	12.59	0.01
msgs received queued	1,047,987	1,715.09	0.80
msgs sent queue time (ms)	118,631	194.15	0.09
msgs sent queue time on ksxp (ms)	25,500	41.73	0.02
msgs sent queued	1,471,822	2,408.72	1.12
msgs sent queued on ksxp	2,313,891	3,786.82	1.77
number of broadcasted resources	0	0.00	0.00
number of directly freed master res	719	1.18	0.00
number of ges deadlock detected	0	0.00	0.00
number of lock borrowed by LMD	0	0.00	0.00
number of received ODPS messages	560	0.92	0.00
number of resource borrowed by LMD	0	0.00	0.00
number of sent ODPS messages	1,207,604	1,976.32	0.92
process batch messages received	1,034,123	1,692.40	0.79
process batch messages sent	4,842	7.92	0.00

Statistic	Total
CR Block Requests	114
CURRENT Block Requests	180
Data Block Requests	114
Undo Block Requests	1
TX Block Requests	15
Current Results	180
Private results	0
Zero Results	0
Disk Read Results	114
Fail Results	0
Fairness Down Converts	104
Light Works	0
Flushes	0
Builds	115
Errors	0

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
1	data block	189	95.24	4.76	0.00	6,149	95.87	4.13	0.00
1	Others	18	100.00	0.00	0.00	2,698	99.18	0.82	0.00
1	undo header	2,536	99.92	0.08	0.00	56	89.29	10.71	0.00

Inst No	Block Class	All	Immed	Busy	All	Immed	Busy
		CR Avg Time (us)			Current Avg Time (us)
1	data block	136	121	424	166	168	129
1	others	117	117		75	75	137
1	undo header	89	89	317	154	154	155
1	undo block

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	0.00	0.15
Parallel Query	0.03	0.05
DB Locks	0.65	0.33
DB Streams
Other	0.01	0.01

Device Name	IP Address	Public	Source	Send Mbytes/sec	Send Errors	Send Dropped	Send Buffer Overrun	Send Carrier Lost	Receive Mbytes/sec	Receive Errors	Receive Dropped	Receive Buffer Overrun	Receive Frame Errors
ib0:1	169.254.4.119	NO		0.00	0	0	0	0	0.00	0	0	0	0
ib1:1	169.254.171.194	NO		0.00	0	0	0	0	0.00	0	0	0	0

Name	Begin Snap	End Snap
affinity objects	19	19
affinity objects (other inst)	1	1
read-mostly objects	2	2