WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ORCL	1431258748	orcl1	1	21-Jun-16 21:06	11.2.0.4.0	YES

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
rac1.oracl.com	Linux IA (32-bit)	1			1.97

	Snap Id	Snap Time	Sessions	Cursors/Session	Instances
Begin Snap:	4	21-Jun-16 21:55:55	49	1.1	1
End Snap:	5	21-Jun-16 22:30:10	54	2.4	1
Elapsed:		34.25 (mins)
DB Time:		35.00 (mins)

Report Summary

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.0	1.0	0.00	1.23
DB CPU(s):	0.1	0.1	0.00	0.10
Redo size (bytes):	87,362.4	81,539.7
Logical read (blocks):	10,274.3	9,589.5
Block changes:	1,098.1	1,024.9
Physical read (blocks):	137.6	128.5
Physical write (blocks):	20.5	19.1
Read IO requests:	41.4	38.7
Write IO requests:	11.4	10.6
Read IO (MB):	1.1	1.0
Write IO (MB):	0.2	0.2
Global Cache blocks received:	0.0	0.0
Global Cache blocks served:	0.0	0.0
User calls:	0.8	0.8
Parses (SQL):	94.8	88.5
Hard parses (SQL):	8.1	7.6
SQL Work Area (MB):	0.5	0.5
Logons:	0.0	0.0
Executes (SQL):	388.3	362.4
Rollbacks:	0.0	0.0
Transactions:	1.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.13	In-memory Sort %:	100.00
Library Hit %:	96.58	Soft Parse %:	91.45
Execute to Parse %:	75.59	Latch Hit %:	99.98
Parse CPU to Parse Elapsd %:	25.38	% Non-Parse CPU:	31.04

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
db file sequential read	24,792	507.2	20	24.1	User I/O
resmgr:cpu quantum	1,511	194.2	129	9.2	Scheduler
DB CPU		166.5		7.9
db file scattered read	6,982	120.5	17	5.7	User I/O
control file sequential read	2,309	26.9	12	1.3	System I/O
cursor: pin S wait on X	116	15.4	133	.7	Concurrency
row cache lock	6,001	9.7	2	.5	Concurrency
reliable message	19	7.4	387	.4	Other
enq: TQ - DDL contention	2	5.7	2857	.3	Other
buffer exterminate	225	2.8	12	.1	Other

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
User I/O	86,150	1,111	13	52.9	0.5
System I/O	23,474	905	39	43.1	0.4
Scheduler	2,698	303	112	14.4	0.1
DB CPU		166		7.9	0.1
Other	915,596	137	0	6.5	0.1
Concurrency	200,084	90	0	4.3	0.0
Commit	10	2	227	.1	0.0
Application	465	1	1	.0	0.0
Administrative	1	0	157	.0	0.0
Configuration	3	0	36	.0	0.0
Network	1,312	0	0	.0	0.0
Cluster	1	0	8	.0	0.0

Host CPU

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
1			5.54	2.84	33.1	34.6	24.7	32.0

Instance CPU

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

IO Profile

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	65.6	48.2	17.4
Database Requests:	52.8	41.4	11.4
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	3.4	0.1	3.3
Total (MB):	3.2	2.1	1.2
Database (MB):	1.2	1.1	0.2
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	0.2	0.1	0.1
Database (blocks):	158.1	137.6	20.5
Via Buffer Cache (blocks):	104.2	88.9	15.3
Direct (blocks):	53.9	48.7	5.1

Memory Statistics

	Begin	End
Host Mem (MB):	2,022.1	2,022.1
SGA use (MB):	244.0	244.0
PGA use (MB):	261.9	333.6
% Host Mem used for SGA+PGA:	25.02	28.57

Cache Sizes

	Begin	End
Buffer Cache:	100M	64M	Std Block Size:	8K
Shared Pool Size:	83M	108M	Log Buffer:	5,904K

Shared Pool Statistics

	Begin	End
Memory Usage %:	82.69	73.89
% SQL with executions>1:	71.38	83.65
% Memory for SQL w/exec>1:	66.79	80.58

Main Report

RAC Statistics

Wait Events Statistics

Time Model Statistics

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

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	1,242.81	59.18
parse time elapsed	340.40	16.21
hard parse elapsed time	318.69	15.17
PL/SQL execution elapsed time	202.17	9.63
DB CPU	166.47	7.93
PL/SQL compilation elapsed time	47.47	2.26
hard parse (sharing criteria) elapsed time	20.68	0.98
connection management call elapsed time	10.96	0.52
RMAN cpu time (backup/restore)	5.62	0.27
inbound PL/SQL rpc elapsed time	5.31	0.25
failed parse elapsed time	2.19	0.10
repeated bind elapsed time	0.61	0.03
sequence load elapsed time	0.56	0.03
hard parse (bind mismatch) elapsed time	0.48	0.02
DB time	2,100.14
background elapsed time	2,566.76
background cpu time	496.58

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Statistic	Value	End Value
BUSY_TIME	125,168
IDLE_TIME	58,972
IOWAIT_TIME	45,512
SYS_TIME	63,675
USER_TIME	60,859
LOAD	6	3
RSRC_MGR_CPU_WAIT_TIME	30,830
VM_IN_BYTES	638,976
VM_OUT_BYTES	33,443,840
PHYSICAL_MEMORY_BYTES	2,120,294,400
NUM_CPUS	1
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	903,776
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	903,776
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
21-Jun 21:55:55	5.54
21-Jun 22:30:10	2.84	67.97	33.05	34.58	32.03	24.72

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 51.5% of Total DB time 2,100.14 (s)
Total FG Wait Time: 915.97 (s) DB CPU time: 166.47 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
User I/O	33,350	0	637	19	30.32
Scheduler	1,511	0	194	129	9.25
DB CPU			166		7.93
Concurrency	6,527	0	31	5	1.49
System I/O	2,417	0	29	12	1.36
Other	1,293	19	23	18	1.11
Commit	9	0	1	141	0.06
Application	456	0	0	1	0.02
Administrative	1	0	0	157	0.01
Network	1,141	0	0	0	0.00
Cluster	0		0		0.00
Configuration	0		0		0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
db file sequential read	24,792	0	507	20	11.26	24.15
resmgr:cpu quantum	1,511	0	194	129	0.69	9.25
db file scattered read	6,982	0	121	17	3.17	5.74
control file sequential read	2,309	0	27	12	1.05	1.28
cursor: pin S wait on X	116	0	15	133	0.05	0.73
row cache lock	6,001	0	10	2	2.73	0.46
reliable message	19	0	7	387	0.01	0.35
enq: TQ - DDL contention	2	0	6	2857	0.00	0.27
buffer exterminate	225	98	3	12	0.10	0.13
read by other session	30	0	3	84	0.01	0.12
library cache load lock	13	0	2	192	0.01	0.12
Disk file operations I/O	170	0	2	14	0.08	0.12
kupp process wait	21	100	2	101	0.01	0.10
direct path read	891	0	2	2	0.40	0.10
ADR block file read	7	0	2	269	0.00	0.09
os thread startup	5	0	2	366	0.00	0.09
direct path write temp	42	0	2	41	0.02	0.08
log file sync	9	0	1	141	0.00	0.06
control file single write	29	0	1	37	0.01	0.05
recovery area: computing obsolete files	3	0	1	324	0.00	0.05
library cache lock	2	0	1	328	0.00	0.03
CRS call completion	12	0	1	50	0.01	0.03
latch: shared pool	284	0	1	2	0.13	0.02
recovery area: computing dropped files	1	0	0	488	0.00	0.02
enq: IV - contention	795	0	0	1	0.36	0.02
log file sequential read	10	0	0	45	0.00	0.02
buffer busy waits	14	0	0	29	0.01	0.02
SQL*Net break/reset to client	453	0	0	1	0.21	0.02
db file parallel read	7	0	0	29	0.00	0.01
enq: CF - contention	2	0	0	93	0.00	0.01
control file parallel write	65	0	0	3	0.03	0.01
SGA: allocation forcing component growth	7	0	0	25	0.00	0.01
switch logfile command	1	0	0	157	0.00	0.01
recovery area: computing backed up files	1	0	0	139	0.00	0.01
CSS initialization	12	0	0	11	0.01	0.01
latch: row cache objects	79	0	0	2	0.04	0.01
direct path read temp	11	0	0	9	0.00	0.00
rdbms ipc reply	1	0	0	82	0.00	0.00
latch free	42	0	0	2	0.02	0.00
utl_file I/O	404	0	0	0	0.18	0.00
latch: cache buffers lru chain	10	0	0	4	0.00	0.00
CSS operation: action	13	0	0	2	0.01	0.00
library cache: mutex X	10	0	0	3	0.00	0.00
SQL*Net message to client	1,141	0	0	0	0.52	0.00
enq: CR - block range reuse ckpt	8	0	0	2	0.00	0.00
cursor: pin S	1	0	0	11	0.00	0.00
CSS operation: query	36	0	0	0	0.02	0.00
latch: gc element	6	0	0	1	0.00	0.00
enq: TM - contention	1	0	0	8	0.00	0.00
latch: ges resource hash list	55	0	0	0	0.02	0.00
latch: enqueue hash chains	3	0	0	1	0.00	0.00
enq: RO - fast object reuse	2	0	0	1	0.00	0.00
latch: cache buffers chains	2	0	0	1	0.00	0.00
ASM file metadata operation	6	0	0	0	0.00	0.00
kfk: async disk IO	3	0	0	1	0.00	0.00
Data Pump slave startup	2	0	0	1	0.00	0.00
Datapump dump file I/O	16	0	0	0	0.01	0.00
direct path write	5	0	0	0	0.00	0.00
Log archive I/O	1	0	0	1	0.00	0.00
SQL*Net message from client	1,143	0	6,254	5472	0.52
wait for unread message on broadcast channel	3,171	74	2,525	796	1.44
jobq slave wait	592	99	294	497	0.27
PL/SQL lock timer	305	100	32	106	0.14
KSV master wait	36	6	0	1	0.02
class slave wait	142	99	0	0	0.06

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
control file sequential read	7,583	0	479	63	3.44	18.65
db file sequential read	41,159	0	362	9	18.69	14.09
RMAN backup & recovery I/O	2,833	0	253	89	1.29	9.85
resmgr:cpu quantum	1,192	0	109	91	0.54	4.24
ASM file metadata operation	2,346	0	66	28	1.07	2.56
direct path read	4,878	0	46	9	2.22	1.78
log file parallel write	6,715	0	42	6	3.05	1.65
control file parallel write	1,319	0	36	27	0.60	1.40
db file parallel write	1,376	0	35	25	0.62	1.34
log file sequential read	165	0	29	179	0.07	1.15
direct path write	1,905	0	29	15	0.87	1.12
row cache lock	3,252	0	14	4	1.48	0.53
library cache lock	10	0	13	1294	0.00	0.50
enq: TQ - TM contention	4	0	11	2796	0.00	0.44
cursor: pin S wait on X	32	0	11	346	0.01	0.43
os thread startup	33	0	11	322	0.01	0.41
Datapump dump file I/O	2,481	0	11	4	1.13	0.41
rdbms ipc reply	23	17	10	455	0.01	0.41
db file scattered read	1,193	0	9	8	0.54	0.36
Data file init write	59	0	6	105	0.03	0.24
Streams AQ: qmn coordinator waiting for slave to start	2	50	5	2565	0.00	0.20
reliable message	10	40	5	465	0.00	0.18
library cache load lock	12	0	4	361	0.01	0.17
row cache process	418,664	0	4	0	190.13	0.14
db file parallel read	140	0	3	24	0.06	0.13
enq: TC - contention	1	0	3	3017	0.00	0.12
latch: ges resource hash list	10,951	0	2	0	4.97	0.10
ksxr poll remote instances	189,273	100	2	0	85.96	0.09
latch: shared pool	701	0	2	3	0.32	0.09
read by other session	31	0	2	68	0.01	0.08
libcache interrupt action by LCK	189,273	0	2	0	85.96	0.08
Disk file operations I/O	580	0	2	3	0.26	0.08
latch free	10,993	0	2	0	4.99	0.06
kfk: async disk IO	62	0	2	26	0.03	0.06
Parameter File I/O	146	0	2	11	0.07	0.06
resmgr:internal state change	15	100	2	101	0.01	0.06
direct path sync	2	0	1	662	0.00	0.05
control file single write	30	0	1	38	0.01	0.04
direct path read temp	101	0	1	11	0.05	0.04
log file sync	1	0	1	1005	0.00	0.04
row cache cleanup	265,273	0	1	0	120.47	0.04
DFS lock handle	93	0	1	7	0.04	0.03
direct path write temp	62	0	1	10	0.03	0.02
latch: gc element	29	0	0	16	0.01	0.02
buffer exterminate	36	100	0	12	0.02	0.02
enq: CF - contention	2	0	0	178	0.00	0.01
CGS wait for IPC msg	16,294	100	0	0	7.40	0.01
latch: row cache objects	155	0	0	2	0.07	0.01
local write wait	58	0	0	4	0.03	0.01
latch: cache buffers chains	19	0	0	12	0.01	0.01
Log archive I/O	4	0	0	53	0.00	0.01
enq: KO - fast object checkpoint	3	0	0	59	0.00	0.01
CSS initialization	12	0	0	12	0.01	0.01
latch: cache buffers lru chain	40	0	0	4	0.02	0.01
library cache: mutex X	48	0	0	3	0.02	0.00
log file switch completion	1	0	0	108	0.00	0.00
CSS group registration	6	0	0	16	0.00	0.00
CRS call completion	8	0	0	12	0.00	0.00
ADR block file read	3	0	0	27	0.00	0.00
CSS operation: action	35	0	0	2	0.02	0.00
SGA: allocation forcing component growth	3	0	0	17	0.00	0.00
db file single write	35	0	0	1	0.02	0.00
latch: redo allocation	29	0	0	1	0.01	0.00
enq: IV - contention	28	0	0	1	0.01	0.00
LGWR wait for redo copy	17	0	0	1	0.01	0.00
asynch descriptor resize	47	100	0	0	0.02	0.00
buffer busy waits	15	0	0	1	0.01	0.00
gc buffer busy release	1	0	0	8	0.00	0.00
log file single write	10	0	0	1	0.00	0.00
CSS operation: query	36	0	0	0	0.02	0.00
latch: messages	3	0	0	2	0.00	0.00
ADR block file write	3	0	0	2	0.00	0.00
latch: gcs resource hash	4	0	0	1	0.00	0.00
latch: enqueue hash chains	4	0	0	1	0.00	0.00
SQL*Net break/reset to client	6	0	0	1	0.00	0.00
latch: object queue header operation	10	0	0	0	0.00	0.00
CSS group membership query	4	0	0	1	0.00	0.00
db file async I/O submit	960	0	0	0	0.44	0.00
latch: call allocation	1	0	0	3	0.00	0.00
enq: JS - queue lock	1	0	0	3	0.00	0.00
latch: cache buffer handles	2	0	0	1	0.00	0.00
ARCH wait for archivelog lock	7	0	0	0	0.00	0.00
rdbms ipc message	223,502	13	44,510	199	101.50
Space Manager: slave idle wait	1,511	87	6,949	4599	0.69
class slave wait	1,416	0	4,904	3463	0.64
wait for unread message on broadcast channel	3,952	100	3,971	1005	1.79
DIAG idle wait	20,066	100	3,959	197	9.11
Streams AQ: qmn slave idle wait	435	0	3,473	7984	0.20
Streams AQ: waiting for time management or cleanup tasks	5	40	2,322	464335	0.00
smon timer	30	3	2,066	68883	0.01
Streams AQ: qmn coordinator idle wait	449	42	2,000	4454	0.20
PING	459	33	1,989	4333	0.21
pmon timer	667	98	1,983	2973	0.30
ges remote message	29,408	60	1,983	67	13.36
GCR sleep	397	100	1,983	4995	0.18
gcs remote message	61,433	100	1,981	32	27.90
shared server idle wait	66	100	1,981	30012	0.03
dispatcher timer	33	100	1,980	60011	0.01
ASM background timer	1,223	0	1,980	1619	0.56
VKRM Idle	1	0	1,081	1081471	0.00
SQL*Net message from client	182	0	699	3843	0.08
KSV master wait	2,020	59	58	29	0.92
SGA: MMAN sleep for component shrink	591	99	8	13	0.27
Streams AQ: RAC qmn coordinator idle wait	453	100	0	0	0.21

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	10	10.0				10.0	40.0	40.0
ADR block file write	3	66.7		33.3
ADR file lock	6	100.0
ARCH wait for archivelog lock	8	100.0
ASM file metadata operation	2341	79.2	6.6	6.7	2.7	1.0	.4	2.6	.7
CGS wait for IPC msg	16.3K	100.0	.0			.0
CRS call completion	20	45.0				25.0	15.0	15.0
CSS group membership query	4	75.0	25.0
CSS group registration	6			66.7		16.7		16.7
CSS initialization	24	50.0				8.3	33.3	8.3
CSS operation: action	48	18.8	43.8	33.3	2.1	2.1
CSS operation: query	72	88.9	9.7	1.4
DFS lock handle	97	72.2	1.0	4.1	9.3	8.2	4.1	1.0
Data Pump slave startup	2	100.0
Data file init write	59		1.7	1.7	3.4	5.1	13.6	74.6
Datapump dump file I/O	2522	84.3	6.3	3.9	2.7	1.1	.5	.9	.1
Disk file operations I/O	738	88.9	2.0	2.2	2.0	1.8	1.4	1.8
LGWR wait for redo copy	17	64.7	23.5	11.8
Log archive I/O	5	20.0	20.0	20.0				40.0
Parameter File I/O	146	53.4	16.4	5.5	6.8	6.8	4.8	6.2
RMAN backup & recovery I/O	2826	1.5	.1	.5	1.0	3.5	9.4	84.0
SGA: allocation forcing component growth	10	20.0		10.0			40.0	30.0
SQL*Net break/reset to client	459	93.7	3.3	.9	1.3	.4	.2	.2
SQL*Net message to client	1279	99.5	.2	.3	.1
Streams AQ: qmn coordinator waiting for slave to start	2					50.0			50.0
asynch descriptor resize	45	91.1	4.4	4.4
buffer busy waits	29	55.2	34.5	6.9				3.4
buffer exterminate	261	1.1			.4	88.1	10.0	.4
control file parallel write	1346	78.3	4.5	1.6	1.2	2.3	2.2	10.0
control file sequential read	9779	36.4	5.7	3.7	5.6	16.8	13.4	18.3	.1
control file single write	59	22.0	10.2	5.1	18.6	5.1		39.0
cursor: pin S	2	50.0				50.0
cursor: pin S wait on X	148		.7	4.7	1.4	27.7	16.9	44.6	4.1
db file async I/O submit	992	100.0
db file parallel read	147	28.6	3.4	4.1	8.2	13.6	17.0	25.2
db file parallel write	1437	60.9	6.4	3.5	2.5	4.3	5.6	16.8
db file scattered read	8164	25.1	33.4	7.1	4.9	11.9	10.0	7.6
db file sequential read	66.7K	55.8	7.6	3.7	4.9	12.6	10.1	5.3	.0
db file single write	39	76.9	20.5			2.6
direct path read	5769	45.3	10.9	7.4	7.4	16.0	8.6	4.4
direct path read temp	112	39.3	5.4	6.3	12.5	18.8	8.0	9.8
direct path sync	2			50.0					50.0
direct path write	1910	49.0	15.8	9.3	9.4	4.7	2.9	9.0
direct path write temp	104	75.0	13.5	1.9		2.9	1.0	5.8
enq: CF - contention	4				25.0			75.0
enq: CR - block range reuse ckpt	8	25.0	62.5			12.5
enq: IV - contention	821	87.9	9.6	1.5	.7	.2
enq: JS - queue lock	1			100.0
enq: KO - fast object checkpoint	3		33.3		33.3			33.3
enq: RO - fast object reuse	2	50.0	50.0
enq: TC - contention	1								100.0
enq: TM - contention	1					100.0
enq: TQ - DDL contention	2							50.0	50.0
enq: TQ - TM contention	4							50.0	50.0
gc buffer busy release	1				100.0
kfk: async disk IO	69	65.2	10.1	2.9	1.4	2.9	2.9	14.5
ksxr poll remote instances	189.6K	100.0	.0	.0	.0	.0
kupp process wait	21							100.0
latch free	11K	97.7	1.5	.6	.2	.1	.0	.0
latch: cache buffer handles	2	100.0
latch: cache buffers chains	26	46.2	26.9	11.5	7.7		3.8	3.8
latch: cache buffers lru chain	53	67.9	15.1	11.3	1.9		1.9	1.9
latch: call allocation	2	50.0		50.0
latch: checkpoint queue latch	1	100.0
latch: enqueue hash chains	7	57.1	42.9
latch: gc element	35	74.3	8.6	8.6	2.9	2.9		2.9
latch: gcs resource hash	4	75.0			25.0
latch: ges resource hash list	11K	94.3	4.1	1.2	.4	.1	.0
latch: messages	3	33.3		66.7
latch: object queue header operation	10	90.0	10.0
latch: redo allocation	31	74.2	22.6	3.2
latch: row cache objects	233	44.2	30.9	18.9	5.2	.4	.4
latch: shared pool	979	39.3	33.1	17.1	7.4	1.9	.4	.8
libcache interrupt action by LCK	189.6K	99.9	.0	.0	.0	.0	.0
library cache load lock	25	16.0	12.0	12.0			8.0	44.0	8.0
library cache lock	12	8.3				16.7	8.3	25.0	41.7
library cache: mutex X	58	29.3	25.9	25.9	12.1	6.9
local write wait	74	50.0	33.8	1.4	4.1	5.4	1.4	4.1
log file parallel write	6716	90.4	3.8	1.9	.5	.5	.4	2.6
log file sequential read	175	14.3	2.3		2.3	3.4	5.1	72.6
log file single write	10	80.0	20.0
log file switch completion	1							100.0
log file sync	10	20.0	10.0	20.0		10.0		40.0
os thread startup	36							97.2	2.8
rdbms ipc reply	24	41.7	20.8	8.3				8.3	20.8
read by other session	61	3.3	9.8	6.6	8.2	19.7	23.0	29.5
recovery area: computing backed up files	1							100.0
recovery area: computing dropped files	1							100.0
recovery area: computing obsolete files	3			66.7				33.3
reliable message	29	13.8	20.7	13.8		6.9	6.9	27.6	10.3
resmgr:cpu quantum	2754	7.5	5.3	5.9	7.7	10.5	14.2	47.3	1.6
resmgr:internal state change	15							100.0
row cache cleanup	265.8K	100.0	.0	.0	.0	.0	.0	.0
row cache lock	9467	91.6	5.8	1.7	.6	.2	.0	.0	.1
row cache process	419.6K	100.0	.0	.0	.0	.0		.0
switch logfile command	1							100.0
utl_file I/O	404	97.5	1.7	.2		.5
write complete waits	2	100.0
ASM background timer	1234	28.0	11.4	5.3	2.4	2.5	2.6	12.6	35.2
DIAG idle wait	20.1K					4.6	.3	95.1	.0
GCR sleep	398	.3							99.7
KSV master wait	2002	79.5	7.5	6.3	2.8	.5		2.3	.8
PING	459	65.8		.4		.2		.2	33.3
PL/SQL lock timer	305							100.0
SGA: MMAN sleep for component shrink	591			.2	.7	86.6	12.0	.5
SQL*Net message from client	1291	45.5	10.5	8.5	6.7	1.9	.8	3.4	22.6
Space Manager: slave idle wait	1524	1.2	.1	.2	.1	.3	.1	3.5	94.6
Streams AQ: RAC qmn coordinator idle wait	458	100.0
Streams AQ: qmn coordinator idle wait	454	29.1	14.5	7.5	2.2	1.3	.2	2.0	43.2
Streams AQ: qmn slave idle wait	440	2.5	.2	.2					97.0
Streams AQ: waiting for time management or cleanup tasks	5	20.0						40.0	40.0
class slave wait	1462	33.9	3.1	4.7	3.6	3.8	6.8	27.8	16.2
dispatcher timer	33								100.0
gcs remote message	61.6K	.1					92.8	7.1	.0
ges remote message	29.5K	11.6	8.5	5.8	4.0	3.3	2.9	63.9	.0
jobq slave wait	588	.7						99.3
pmon timer	669					.1		.9	99.0
rdbms ipc message	224K	69.4	4.2	3.8	2.5	2.0	1.7	12.0	4.3
shared server idle wait	67								100.0
smon timer	29	20.7						3.4	75.9
wait for unread message on broadcast channel	7163	1.6	.4	1.2	.7	1.0	.9	92.6	1.7

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
ADR block file read	4	60.0		10.0		10.0	20.0
ASM file metadata operation	70	96.7	.2	.4	.4	.7	1.0	.3	.3
CRS call completion	3	85.0	5.0		5.0	5.0
CSS group registration	1	83.3		16.7
CSS initialization	2	91.7	8.3
DFS lock handle	1	99.0				1.0
Data file init write	44	25.4	15.3	30.5	16.9	11.9
Datapump dump file I/O	25	99.0	.4	.3	.2	.0		.1	.0
Disk file operations I/O	13	98.2	.4	.3	.1	.5	.4
Log archive I/O	2	60.0		40.0
Parameter File I/O	9	93.8	2.7	.7	2.7
RMAN backup & recovery I/O	2374	16.0	34.9	29.0	16.8	2.9	.4
SGA: allocation forcing component growth	3	70.0	30.0
SQL*Net break/reset to client	1	99.8			.2
buffer busy waits	1	96.6				3.4
buffer exterminate	1	99.6	.4
control file parallel write	134	90.0	2.1	2.2	1.5	2.9	1.3
control file sequential read	1795	81.6	6.1	2.7	2.7	4.2	2.6	.0	.0
control file single write	23	61.0	16.9	16.9	5.1
cursor: pin S wait on X	71	51.4	14.9	14.2	6.8	5.4	3.4	3.4	.7
db file parallel read	37	74.8	15.6	7.5	1.4	.7
db file parallel write	242	83.2	4.2	6.1	4.7	1.7	.1
db file scattered read	618	92.4	3.4	1.4	1.3	1.2	.2
db file sequential read	3543	94.7	2.6	.7	.8	.9	.3	.0
direct path read	253	95.6	3.2	.7	.3	.2	.1
direct path read temp	11	90.2	6.3	3.6
direct path sync	1	50.0						50.0
direct path write	171	91.0	2.3	3.0	2.5	1.0	.1
direct path write temp	6	94.2		1.0		3.8	1.0
enq: CF - contention	3	25.0			75.0
enq: KO - fast object checkpoint	1	66.7			33.3
enq: TQ - DDL contention	1					50.0			50.0
enq: TQ - TM contention	2						50.0		50.0
kfk: async disk IO	10	85.5	5.8		5.8	2.9
kupp process wait	21			100.0
latch free	1	100.0				.0
latch: cache buffers chains	1	96.2			3.8
latch: cache buffers lru chain	1	98.1		1.9
latch: gc element	1	97.1				2.9
latch: shared pool	8	99.2	.4	.3		.1
library cache load lock	13	48.0	4.0	4.0	24.0		12.0	8.0
library cache lock	6	33.3					25.0	25.0	16.7
local write wait	3	95.9		4.1
log file parallel write	172	97.4	.4	.6	.6	.7	.2
log file sequential read	127	27.4	10.3	9.1	26.3	24.0	2.9
log file switch completion	1			100.0
log file sync	4	60.0			10.0	10.0	20.0
os thread startup	35			19.4	41.7	30.6	5.6		2.8
rdbms ipc reply	7	70.8		4.2			4.2	20.8
read by other session	18	70.5	4.9	4.9	8.2	11.5
recovery area: computing backed up files	1				100.0
recovery area: computing dropped files	1					100.0
recovery area: computing obsolete files	1	66.7					33.3
reliable message	10	62.1		3.4	3.4		20.7	6.9	3.4
resmgr:cpu quantum	1333	51.2	14.1	15.9	9.9	5.3	2.1	1.1	.4
resmgr:internal state change	15			100.0
row cache cleanup	1	100.0	.0
row cache lock	5	99.9	.0			.0		.0	.1
row cache process	1	100.0	.0
switch logfile command	1				100.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

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

Event	Waits 4s to 2m	<2s	<4s	<8s
		% of Total Waits
ASM file metadata operation	8	99.7	.3
Datapump dump file I/O	1	100.0	.0
Streams AQ: qmn coordinator waiting for slave to start	1	50.0		50.0
control file sequential read	3	100.0	.0
cursor: pin S wait on X	1	99.3		.7
enq: TC - contention	1		100.0
enq: TQ - DDL contention	1	50.0		50.0
enq: TQ - TM contention	2	50.0	25.0	25.0
library cache lock	2	83.3	16.7
os thread startup	1	97.2	2.8
reliable message	1	96.6	3.4
resmgr:cpu quantum	12	99.6	.4	.0
row cache lock	6	99.9	.1

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report. Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
SYS$USERS	2,102	167	280	21,042
SYS$BACKGROUND	0	0	2	63
orcl.gdb.com	0	0	0	0
orclXDB	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	33725	640	6532	32	1	0	1284	0
SYS$BACKGROUND	52362	470	193532	58	0	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time

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

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
995.29	0		47.39	35.47	27.82	2ykzqty3zh2cq		BEGIN SYS.KUPW$WORKER.MAIN('J...
89.89	857	0.10	4.28	0.97	91.03	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
82.15	1	82.15	3.91	41.99	37.55	9jbmdcrxrfvjm	Data Pump Worker	SELECT /+rule/ SYS_XMLGEN(VA...
73.91	162	0.46	3.52	4.89	2.81	8c0syt8yv0qvn	ude@rac1.oracl.com (TNS V1-V3)	BEGIN SYS.DBMS_DATAPUMP.GET_ST...
63.16	6,549	0.01	3.01	13.76	62.44	c2jwvyg92zppc	Data Pump Worker	INSERT INTO "SYSTEM"."J1" (obj...
60.80	374	0.16	2.90	3.40	1.27	7wn3wubg7gjds	ude@rac1.oracl.com (TNS V1-V3)	BEGIN :1 := sys.kupc$que_int.g...
57.62	4	14.41	2.74	19.86	30.55	d5cbbqhhcp9bg	ude@rac1.oracl.com (TNS V1-V3)	DECLARE JOBHNDL NUMBER; BEGIN ...
47.78	2,748	0.02	2.28	20.47	75.51	1a4rxr3djk4dv	Data Pump Worker	select cast(multiset(select ob...
46.53	2,570	0.02	2.22	2.36	89.44	3ktacv9r56b51		select owner#, name, namespace...
42.55	857	0.05	2.03	1.00	92.75	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
35.85	0		1.71	20.21	30.04	dsnb15xzg6wra		BEGIN SYS.KUPM$MCP.MAIN('J1',...
32.03	10,059	0.00	1.52	5.15	77.69	db78fxqxwxt7r		select /+ rule / bucket, end...
32.00	2,570	0.01	1.52	1.90	81.97	8swypbbr0m372		select order#, columns, types ...
24.43	857	0.03	1.16	1.55	87.78	ga9j9xk5cy9s0		select /*+ index(idl_sb4$ i_id...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
353.04	0		212.08	995.29	35.47	27.82	2ykzqty3zh2cq		BEGIN SYS.KUPW$WORKER.MAIN('J...
34.49	1	34.49	20.72	82.15	41.99	37.55	9jbmdcrxrfvjm	Data Pump Worker	SELECT /+rule/ SYS_XMLGEN(VA...
11.44	4	2.86	6.87	57.62	19.86	30.55	d5cbbqhhcp9bg	ude@rac1.oracl.com (TNS V1-V3)	DECLARE JOBHNDL NUMBER; BEGIN ...
9.78	2,748	0.00	5.88	47.78	20.47	75.51	1a4rxr3djk4dv	Data Pump Worker	select cast(multiset(select ob...
8.69	6,549	0.00	5.22	63.16	13.76	62.44	c2jwvyg92zppc	Data Pump Worker	INSERT INTO "SYSTEM"."J1" (obj...
7.25	0		4.35	35.85	20.21	30.04	dsnb15xzg6wra		BEGIN SYS.KUPM$MCP.MAIN('J1',...
3.62	162	0.02	2.17	73.91	4.89	2.81	8c0syt8yv0qvn	ude@rac1.oracl.com (TNS V1-V3)	BEGIN SYS.DBMS_DATAPUMP.GET_ST...
2.66	6,549	0.00	1.60	13.71	19.41	3.21	6fqhkrfng1vmx	Data Pump Worker	UPDATE "SYSTEM"."J1" SET last_...
2.09	63,995	0.00	1.26	4.75	44.10	0.78	f9jyt3tpyw0ha	Data Pump Worker	SELECT BITAND(:B2 , :B1 ) FROM...
2.07	374	0.01	1.24	60.80	3.40	1.27	7wn3wubg7gjds	ude@rac1.oracl.com (TNS V1-V3)	BEGIN :1 := sys.kupc$que_int.g...
1.91	470	0.00	1.15	15.35	12.44	6.94	bjf05cwcj5s6p	Data Pump Master	BEGIN :1 := sys.kupc$que_int.r...
1.87	34,162	0.00	1.12	13.79	13.55	79.92	96g93hntrzjtr		select /+ rule / bucket_cnt,...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
276.93	0		24.93	995.29	35.47	27.82	2ykzqty3zh2cq		BEGIN SYS.KUPW$WORKER.MAIN('J...
81.83	857	0.10	7.37	89.89	0.97	91.03	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
41.61	2,570	0.02	3.75	46.53	2.36	89.44	3ktacv9r56b51		select owner#, name, namespace...
39.46	857	0.05	3.55	42.55	1.00	92.75	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
39.44	6,549	0.01	3.55	63.16	13.76	62.44	c2jwvyg92zppc	Data Pump Worker	INSERT INTO "SYSTEM"."J1" (obj...
36.08	2,748	0.01	3.25	47.78	20.47	75.51	1a4rxr3djk4dv	Data Pump Worker	select cast(multiset(select ob...
30.84	1	30.84	2.78	82.15	41.99	37.55	9jbmdcrxrfvjm	Data Pump Worker	SELECT /+rule/ SYS_XMLGEN(VA...
26.23	2,570	0.01	2.36	32.00	1.90	81.97	8swypbbr0m372		select order#, columns, types ...
24.88	10,059	0.00	2.24	32.03	5.15	77.69	db78fxqxwxt7r		select /+ rule / bucket, end...
21.45	857	0.03	1.93	24.43	1.55	87.78	ga9j9xk5cy9s0		select /*+ index(idl_sb4$ i_id...
17.60	4	4.40	1.58	57.62	19.86	30.55	d5cbbqhhcp9bg	ude@rac1.oracl.com (TNS V1-V3)	DECLARE JOBHNDL NUMBER; BEGIN ...
13.12	857	0.02	1.18	14.10	1.83	93.02	c6awqs517jpj0		select /*+ index(idl_char$ i_i...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

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

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
14,091,705	0		66.73	995.29	35.5	27.8	2ykzqty3zh2cq		BEGIN SYS.KUPW$WORKER.MAIN('J...
1,844,348	1	1,844,348.00	8.73	82.15	42	37.5	9jbmdcrxrfvjm	Data Pump Worker	SELECT /+rule/ SYS_XMLGEN(VA...
223,035	6,549	34.06	1.06	63.16	13.8	62.4	c2jwvyg92zppc	Data Pump Worker	INSERT INTO "SYSTEM"."J1" (obj...
185,864	0		0.88	35.85	20.2	30	dsnb15xzg6wra		BEGIN SYS.KUPM$MCP.MAIN('J1',...
125,914	4	31,478.50	0.60	57.62	19.9	30.5	d5cbbqhhcp9bg	ude@rac1.oracl.com (TNS V1-V3)	DECLARE JOBHNDL NUMBER; BEGIN ...
91,590	34,162	2.68	0.43	13.79	13.5	79.9	96g93hntrzjtr		select /+ rule / bucket_cnt,...
49,735	12,214	4.07	0.24	12.76	8.7	76.6	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
48,922	24,444	2.00	0.23	1.27	53.4	1.8	938wuu4npuj57	Data Pump Worker	SELECT A.NAME FROM ATTRCOL$ A ...
47,798	6,549	7.30	0.23	13.71	19.4	3.2	6fqhkrfng1vmx	Data Pump Worker	UPDATE "SYSTEM"."J1" SET last_...
44,957	14,942	3.01	0.21	6.23	10.6	83.2	a9jybh9j09gpk	Data Pump Worker	SELECT process_order, processi...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

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

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
120,711	0		42.68	995.29	35.47	27.82	2ykzqty3zh2cq		BEGIN SYS.KUPW$WORKER.MAIN('J...
11,513	2,748	4.19	4.07	47.78	20.47	75.51	1a4rxr3djk4dv	Data Pump Worker	select cast(multiset(select ob...
8,764	1	8,764.00	3.10	82.15	41.99	37.55	9jbmdcrxrfvjm	Data Pump Worker	SELECT /+rule/ SYS_XMLGEN(VA...
5,820	4	1,455.00	2.06	4.07	19.79	75.28	259vhdn0ak8np	Data Pump Worker	SELECT /+all_rows/ VALUE(KU$...
5,460	4	1,365.00	1.93	4.82	17.37	70.17	bdya6jgp4qh5c	Data Pump Worker	SELECT /+all_rows/ VALUE(KU$...
5,309	4	1,327.25	1.88	3.52	28.70	56.16	7a3ppgt0sdbqg	Data Pump Worker	SELECT /+all_rows/ VALUE(KU$...
1,443	0		0.51	35.85	20.21	30.04	dsnb15xzg6wra		BEGIN SYS.KUPM$MCP.MAIN('J1',...
1,350	4	337.50	0.48	57.62	19.86	30.55	d5cbbqhhcp9bg	ude@rac1.oracl.com (TNS V1-V3)	DECLARE JOBHNDL NUMBER; BEGIN ...
1,349	857	1.57	0.48	89.89	0.97	91.03	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
959	10,059	0.10	0.34	32.03	5.15	77.69	db78fxqxwxt7r		select /+ rule / bucket, end...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

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

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
42,908	42,908	0		50.38	2ykzqty3zh2cq		BEGIN SYS.KUPW$WORKER.MAIN('J...
11,513	11,513	2,748	4.19	13.52	1a4rxr3djk4dv	Data Pump Worker	select cast(multiset(select ob...
8,764	8,764	1	8,764.00	10.29	9jbmdcrxrfvjm	Data Pump Worker	SELECT /+rule/ SYS_XMLGEN(VA...
1,360	1,360	4	340.00	1.60	d5cbbqhhcp9bg	ude@rac1.oracl.com (TNS V1-V3)	DECLARE JOBHNDL NUMBER; BEGIN ...
1,332	1,332	857	1.55	1.56	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
1,092	1,092	0		1.28	dsnb15xzg6wra		BEGIN SYS.KUPM$MCP.MAIN('J1',...
959	959	10,059	0.10	1.13	db78fxqxwxt7r		select /+ rule / bucket, end...
560	560	4	140.00	0.66	bdya6jgp4qh5c	Data Pump Worker	SELECT /+all_rows/ VALUE(KU$...
476	476	4	119.00	0.56	259vhdn0ak8np	Data Pump Worker	SELECT /+all_rows/ VALUE(KU$...
434	434	857	0.51	0.51	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 798,060
Captured SQL account for 30.0% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
63,995	63,995	1.00	4.75	44.1	.8	f9jyt3tpyw0ha	Data Pump Worker	SELECT BITAND(:B2 , :B1 ) FROM...
34,162	23,110	0.68	13.79	13.5	79.9	96g93hntrzjtr		select /+ rule / bucket_cnt,...
24,444	3	0.00	1.27	53.4	1.8	938wuu4npuj57	Data Pump Worker	SELECT A.NAME FROM ATTRCOL$ A ...
14,942	14,942	1.00	6.23	10.6	83.2	a9jybh9j09gpk	Data Pump Worker	SELECT process_order, processi...
12,214	11,710	0.96	12.76	8.7	76.6	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
10,059	156,317	15.54	32.03	5.2	77.7	db78fxqxwxt7r		select /+ rule / bucket, end...
8,532	9,424	1.10	3.60	13.7	66.2	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
7,546	12,931	1.71	9.23	6.8	9.4	5n1fs4m2n2y0r		select pos#, intcol#, col#, sp...
6,549	6,549	1.00	13.71	19.4	3.2	6fqhkrfng1vmx	Data Pump Worker	UPDATE "SYSTEM"."J1" SET last_...
6,549	20,332	3.10	63.16	13.8	62.4	c2jwvyg92zppc	Data Pump Worker	INSERT INTO "SYSTEM"."J1" (obj...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 194,815
Captured SQL account for 49.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
63,987	63,995	32.85	f9jyt3tpyw0ha	Data Pump Worker	SELECT BITAND(:B2 , :B1 ) FROM...
6,549	6,549	3.36	6fqhkrfng1vmx	Data Pump Worker	UPDATE "SYSTEM"."J1" SET last_...
6,549	6,549	3.36	c2jwvyg92zppc	Data Pump Worker	INSERT INTO "SYSTEM"."J1" (obj...
2,570	2,570	1.32	3ktacv9r56b51		select owner#, name, namespace...
2,570	2,570	1.32	8swypbbr0m372		select order#, columns, types ...
891	891	0.46	asvzxj61dc5vs		select timestamp, flags from f...
857	857	0.44	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
857	857	0.44	c6awqs517jpj0		select /*+ index(idl_char$ i_i...
857	857	0.44	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
857	857	0.44	ga9j9xk5cy9s0		select /*+ index(idl_sb4$ i_id...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report. Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report. Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

No data exists for this section of the report. Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
1a4rxr3djk4dv	select cast(multiset(select obj#, line, 0, 0, 0, 0, NULL, 0, REPLACE(source, CHR(0)) from sys.source$ where obj# = :1 order by obj#, line) as sys.ku$_source_list_t) from dual
259vhdn0ak8np	SELECT /+all_rows/ VALUE(KU$), 0 , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.GRANTEE , KU$.GRANTOR , KU$.PRIVNAME , 'OBJECT_GRANT' FROM SYS.KU$_OBJGRANT_VIEW KU$ WHERE KU$.GRANTOR!=KU$.BASE_OBJ.OWNER_NAME AND KU$.WGO=0 AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) ORDER BY KU$.GRANTOR
2ykzqty3zh2cq	BEGIN SYS.KUPW$WORKER.MAIN('J1', 'SYSTEM', 0); END;
39m4sx9k63ba2	select /+ index(idl_ub2$ i_idl_ub21) +/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3nkd3g3ju5ph1	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5n1fs4m2n2y0r	select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
6fqhkrfng1vmx	UPDATE "SYSTEM"."J1" SET last_update = sysdate, object_number = :1, object_schema = :2, object_name = :3, object_long_name = :4, object_type_path = :5, partition_name = DECODE(partition_name, NULL, NULL, :6), subpartition_name = DECODE(subpartition_name, NULL, NULL, :7), total_bytes = :8, completed_rows = :9, metadata_io = :10, cumulative_time = :11, parallelization = :12 WHERE process_order = :13 AND duplicate = :14
7a3ppgt0sdbqg	SELECT /+all_rows/ VALUE(KU$), 0 , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.GRANTEE , KU$.GRANTOR , KU$.PRIVNAME , 'OBJECT_GRANT' FROM SYS.KU$_OBJGRANT_VIEW KU$ WHERE KU$.GRANTOR!=KU$.BASE_OBJ.OWNER_NAME AND KU$.WGO!=0 AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001)))
7wn3wubg7gjds	BEGIN :1 := sys.kupc$que_int.get_status(:2, :3); END;
8c0syt8yv0qvn	BEGIN SYS.DBMS_DATAPUMP.GET_STATUS( handle => :JOBHNDL, mask => :MASK, timeout => :TIMEOUT, job_state => :JOB_STATE, status => :STATUS); END;
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
938wuu4npuj57	SELECT A.NAME FROM ATTRCOL$ A WHERE A.OBJ#=:B2 AND A.INTCOL#=:B1
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9jbmdcrxrfvjm	SELECT /+rule/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('PACKAGE_BODY_T', '7')), KU$.OBJ_NUM , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'PACKAGE_BODY' , KU$.SCHEMA_OBJ.OWNER_NAME FROM SYS.KU$_EXP_PKG_BODY_VIEW KU$ WHERE KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND KU$.SCHEMA_OBJ.OWNER_NAME LIKE '%'
a9jybh9j09gpk	SELECT process_order, processing_state, processing_status FROM "SYSTEM"."J1" WHERE process_order > 0 AND duplicate = 0 AND object_type = :1 AND object_schema = :2 AND object_name = :3 AND partition_name IS NULL AND subpartition_name IS NULL AND :4 IS NULL AND :5 IS NULL
asvzxj61dc5vs	select timestamp, flags from fixed_obj$ where obj#=:1
bdya6jgp4qh5c	SELECT /+all_rows/ VALUE(KU$), 0 , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.GRANTEE , KU$.GRANTOR , KU$.PRIVNAME , 'OBJECT_GRANT' FROM SYS.KU$_OBJGRANT_VIEW KU$ WHERE KU$.GRANTOR=KU$.BASE_OBJ.OWNER_NAME AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) ORDER BY KU$.GRANTOR
bjf05cwcj5s6p	BEGIN :1 := sys.kupc$que_int.receive(:2); END;
c2jwvyg92zppc	INSERT INTO "SYSTEM"."J1" (object_type_path, object_path_seqno, dump_fileid, dump_position, dump_length, dump_orig_length, dump_allocation, process_order, duplicate, object_row, object_type, object_schema, original_object_schema, object_name, object_long_name, original_object_name, partition_name, subpartition_name, object_tablespace, grantor, flags, processing_state, processing_status, base_process_order, base_object_type, base_object_schema, base_object_name, domain_process_order, xml_clob, ancestor_process_order, property, trigflag, size_estimate, creation_level, parent_process_order, value_n, object_int_oid, metadata_io) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :13, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38)
c6awqs517jpj0	select /+ index(idl_char$ i_idl_char1) +/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d5cbbqhhcp9bg	DECLARE JOBHNDL NUMBER; BEGIN :JOBHNDL := SYS.DBMS_DATAPUMP.OPEN( operation =>:OPERATION, job_mode => :JOB_MODE, remote_link => :REMOTE_LINK, job_name => :JOB_NAME, version => :VERSION); END;
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dsnb15xzg6wra	BEGIN SYS.KUPM$MCP.MAIN('J1', 'SYSTEM', 0, 0); END;
f9jyt3tpyw0ha	SELECT BITAND(:B2 , :B1 ) FROM SYS.DUAL
ga9j9xk5cy9s0	select /+ index(idl_sb4$ i_idl_sb41) +/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Key Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
db block changes	2,256,897	1,098.12	1,024.93
execute count	798,060	388.31	362.43
logons cumulative	56	0.03	0.03
opened cursors cumulative	777,356	378.23	353.02
parse count (total)	194,815	94.79	88.47
parse time elapsed	45,231	22.01	20.54
physical reads	282,860	137.63	128.46
physical writes	42,060	20.46	19.10
redo size	179,550,328	87,362.39	81,539.66
session cursor cache hits	179,837	87.50	81.67
session logical reads	21,116,065	10,274.28	9,589.49
user calls	1,701	0.83	0.77
user commits	2,201	1.07	1.00
user rollbacks	1	0.00	0.00
workarea executions - onepass	4	0.00	0.00
workarea executions - optimal	135,178	65.77	61.39

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	278	0.14	0.13
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	2,164	1.05	0.98
Batched IO buffer defrag count	18	0.01	0.01
Batched IO double miss count	260	0.13	0.12
Batched IO same unit count	1,000	0.49	0.45
Batched IO single block count	322	0.16	0.15
Batched IO slow jump count	92	0.04	0.04
Batched IO vector block count	1,016	0.49	0.46
Batched IO vector read count	153	0.07	0.07
Block Cleanout Optim referenced	46	0.02	0.02
CCursor + sql area evicted	677	0.33	0.31
CPU used by this session	59,546	28.97	27.04
CPU used when call started	3,011	1.47	1.37
CR blocks created	181	0.09	0.08
Cached Commit SCN referenced	1,353,851	658.73	614.83
Commit SCN cached	8,218	4.00	3.73
DBWR checkpoint buffers written	1,673	0.81	0.76
DBWR checkpoints	23	0.01	0.01
DBWR object drop buffers written	12	0.01	0.01
DBWR tablespace checkpoint buffers written	512	0.25	0.23
DBWR thread checkpoint buffers written	163	0.08	0.07
DBWR transaction table writes	63	0.03	0.03
DBWR undo block writes	5,491	2.67	2.49
Effective IO time	46,803,000	22,772.57	21,254.77
HSC Heap Segment Block Changes	109,533	53.29	49.74
Heap Segment Array Inserts	412	0.20	0.19
Heap Segment Array Updates	170	0.08	0.08
Number of read IOs issued	9,806	4.77	4.45
Requests to/from client	1,135	0.55	0.52
RowCR attempts	590	0.29	0.27
RowCR hits	592	0.29	0.27
SQL*Net roundtrips to/from client	1,272	0.62	0.58
active txn count during cleanout	2,818	1.37	1.28
background checkpoints completed	5	0.00	0.00
background checkpoints started	5	0.00	0.00
background timeouts	16,874	8.21	7.66
buffer is not pinned count	10,582,073	5,148.84	4,805.66
buffer is pinned count	56,290,661	27,388.90	25,563.42
bytes received via SQL*Net from client	1,549,583	753.97	703.72
bytes sent via SQL*Net to client	334,592	162.80	151.95
calls to get snapshot scn: kcmgss	2,277,982	1,108.38	1,034.51
calls to kcmgas	21,913	10.66	9.95
calls to kcmgcs	243,529	118.49	110.59
cell physical IO interconnect bytes	8,702,170,624	4,234,146.65	3,951,939.43
change write time	3,084	1.50	1.40
cleanout - number of ktugct calls	16,541	8.05	7.51
cleanouts and rollbacks - consistent read gets	134	0.07	0.06
cleanouts only - consistent read gets	13,476	6.56	6.12
cluster key scan block gets	1,985,287	965.97	901.58
cluster key scans	1,547,725	753.06	702.87
commit batch/immediate performed	37	0.02	0.02
commit batch/immediate requested	37	0.02	0.02
commit cleanout failures: block lost	151	0.07	0.07
commit cleanout failures: callback failure	175	0.09	0.08
commit cleanout failures: cannot pin	5	0.00	0.00
commit cleanouts	29,730	14.47	13.50
commit cleanouts successfully completed	29,399	14.30	13.35
commit immediate performed	37	0.02	0.02
commit immediate requested	37	0.02	0.02
commit txn count during cleanout	14,738	7.17	6.69
consistent changes	1,617,900	787.21	734.74
consistent gets	14,231,578	6,924.55	6,463.02
consistent gets - examination	2,467,954	1,200.81	1,120.78
consistent gets direct	98,861	48.10	44.90
consistent gets from cache	14,132,717	6,876.44	6,418.13
consistent gets from cache (fastpath)	10,743,280	5,227.27	4,878.87
cursor authentications	3,783	1.84	1.72
data blocks consistent reads - undo records applied	2,275	1.11	1.03
db block gets	6,884,487	3,349.73	3,126.47
db block gets direct	9,140	4.45	4.15
db block gets from cache	6,875,347	3,345.28	3,122.32
db block gets from cache (fastpath)	183,132	89.11	83.17
deferred (CURRENT) block cleanout applications	18,485	8.99	8.39
dirty buffers inspected	26,568	12.93	12.07
enqueue conversions	3,976	1.93	1.81
enqueue releases	199,286	96.97	90.50
enqueue requests	199,305	96.97	90.51
enqueue timeouts	19	0.01	0.01
enqueue waits	26	0.01	0.01
file io service time	3	0.00	0.00
frame signature mismatch	38	0.02	0.02
free buffer inspected	207,689	101.05	94.32
free buffer requested	322,456	156.89	146.44
gc force cr disk read	7,777	3.78	3.53
gc local grants	202,472	98.52	91.95
global enqueue get time	8,843	4.30	4.02
global enqueue gets async	80,456	39.15	36.54
global enqueue gets sync	1,457,809	709.31	662.04
global enqueue releases	1,479,247	719.75	671.77
heap block compress	4,136	2.01	1.88
hot buffers moved to head of LRU	47,059	22.90	21.37
immediate (CR) block cleanout applications	13,610	6.62	6.18
immediate (CURRENT) block cleanout applications	6,668	3.24	3.03
index crx upgrade (positioned)	3,594	1.75	1.63
index fast full scans (full)	445	0.22	0.20
index fetch by key	2,079,522	1,011.82	944.38
index scans kdiixs1	1,273,512	619.64	578.34
leaf node 90-10 splits	188	0.09	0.09
leaf node splits	712	0.35	0.32
lob reads	401,244	195.23	182.22
lob writes	517,181	251.64	234.87
lob writes unaligned	514,959	250.56	233.86
logical read bytes from cache	172,098,060,288	83,736,398.30	78,155,340.73
max cf enq hold time	3,210	1.56	1.46
messages received	86,652	42.16	39.35
messages sent	86,652	42.16	39.35
min active SCN optimization applied on CR	1,715	0.83	0.78
no buffer to keep pinned count	221,519	107.78	100.60
no work - consistent read gets	10,455,940	5,087.46	4,748.38
non-idle wait count	1,617,157	786.85	734.40
parse count (describe)	12	0.01	0.01
parse count (failures)	281	0.14	0.13
parse count (hard)	16,649	8.10	7.56
parse time cpu	11,479	5.59	5.21
physical read IO requests	85,163	41.44	38.68
physical read bytes	2,317,189,120	1,127,456.47	1,052,311.14
physical read total IO requests	99,099	48.22	45.00
physical read total bytes	4,510,749,184	2,194,759.72	2,048,478.29
physical read total multi block requests	12,541	6.10	5.70
physical reads cache	182,695	88.89	82.97
physical reads cache prefetch	108,498	52.79	49.27
physical reads direct	100,165	48.74	45.49
physical reads direct (lob)	7,228	3.52	3.28
physical reads direct temporary tablespace	1,335	0.65	0.61
physical reads prefetch warmup	157	0.08	0.07
physical write IO requests	23,341	11.36	10.60
physical write bytes	344,555,520	167,647.67	156,473.90
physical write total IO requests	35,812	17.42	16.26
physical write total bytes	2,477,922,304	1,205,663.15	1,125,305.32
physical write total multi block requests	2,756	1.34	1.25
physical writes direct	10,545	5.13	4.79
physical writes direct (lob)	8,709	4.24	3.96
physical writes direct temporary tablespace	1,723	0.84	0.78
physical writes from cache	31,515	15.33	14.31
physical writes non checkpoint	41,222	20.06	18.72
pinned buffers inspected	96	0.05	0.04
pinned cursors current	56	0.03	0.03
prefetch warmup blocks aged out before use	51	0.02	0.02
prefetched blocks aged out before use	896	0.44	0.41
process last non-idle time	1,466,527,446	713,556.71	665,997.93
recovery blocks read	0	0.00	0.00
recursive calls	1,908,959	928.83	866.92
recursive cpu usage	21,295	10.36	9.67
redo KB read	169,787	82.61	77.11
redo blocks checksummed by FG (exclusive)	169,919	82.68	77.17
redo blocks read for recovery	0	0.00	0.00
redo blocks written	366,270	178.21	166.34
redo buffer allocation retries	1	0.00	0.00
redo entries	342,103	166.45	155.36
redo k-bytes read for recovery	0	0.00	0.00
redo log space requests	3	0.00	0.00
redo ordering marks	5,936	2.89	2.70
redo size for direct writes	72,012,556	35,038.58	32,703.25
redo synch long waits	32	0.02	0.01
redo synch time	227	0.11	0.10
redo synch time (usec)	2,273,558	1,106.23	1,032.50
redo synch time overhead (usec)	650,801,233	316,655.23	295,550.06
redo synch time overhead count (<128 msec)	6	0.00	0.00
redo synch time overhead count (<2 msec)	16	0.01	0.01
redo synch time overhead count (<32 msec)	1	0.00	0.00
redo synch time overhead count (<8 msec)	5	0.00	0.00
redo synch time overhead count (>=128 msec)	14	0.01	0.01
redo synch writes	42	0.02	0.02
redo wastage	1,767,232	859.87	802.56
redo write info find	42	0.02	0.02
redo write time	4,504	2.19	2.05
redo writes	6,715	3.27	3.05
rollback changes - undo records applied	76	0.04	0.03
rollbacks only - consistent read gets	54	0.03	0.02
rows fetched via callback	720,021	350.33	326.99
session connect time	1,466,527,407	713,556.69	665,997.91
shared hash latch upgrades - no wait	95,830	46.63	43.52
shared hash latch upgrades - wait	3	0.00	0.00
sorts (memory)	168,929	82.19	76.72
sorts (rows)	7,512,142	3,655.12	3,411.51
sql area evicted	12,441	6.05	5.65
sql area purged	358	0.17	0.16
summed dirty queue length	58,229	28.33	26.44
switch current to new buffer	4,809	2.34	2.18
table fetch by rowid	31,667,935	15,408.42	14,381.44
table fetch continued row	5,200	2.53	2.36
table scan blocks gotten	866,577	421.64	393.54
table scan rows gotten	37,111,751	18,057.17	16,853.66
table scans (direct read)	107	0.05	0.05
table scans (long tables)	331	0.16	0.15
table scans (rowid ranges)	8	0.00	0.00
table scans (short tables)	131,311	63.89	59.63
temp space allocated (bytes)	51,380,224	24,999.67	23,333.44
total cf enq hold time	20,450	9.95	9.29
total number of cf enq holders	394	0.19	0.18
total number of times SMON posted	27	0.01	0.01
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	33	0.02	0.01
undo change vector size	36,021,556	17,526.72	16,358.56
user logons cumulative	9	0.00	0.00
user logouts cumulative	11	0.01	0.00
write clones created in background	58	0.03	0.03
write clones created in foreground	16	0.01	0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
logons current	49	54
opened cursors current	54	131
session cursor cache count	887	2,613
session pga memory	244,824,256	340,367,824
session pga memory max	268,106,564	464,592,600
session uga memory	14,698,536	74,959,636
session uga memory max	41,908,392	217,214,648

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	5	8.76

Back to Instance Activity Statistics
Back to Top

IO Stats

IOStat by Function summary

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

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
RMAN	1.7G	2.27	.854M	1.5G	0.90	.726M	1650	22.19
Buffer Cache Reads	1.1G	21.48	.566M	0M	0.00	0M	44.1K	18.24
Data Pump	730M	18.60	.355M	243M	2.42	.118M	33.8K	8.11
Others	318M	4.20	.155M	200M	0.59	.097M	9437	56.89
Direct Reads	327M	1.90	.159M	0M	0.02	0M	0
DBWR	2M	0.05	.001M	287M	12.32	.14M	112	4.80
LGWR	1M	0.04	0M	180M	3.32	.088M	6852	6.14
Direct Writes	0M	0.00	0M	2M	0.03	.001M	0
Streams AQ	0M	0.02	0M	0M	0.00	0M	38	18.00
TOTAL:	4.2G	48.56	2.091M	2.3G	19.61	1.17M	95.9K	17.66

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	3.8G	42.76	1.879M	259M	8.61	.126M	14.23	154.40
Data File Backup	0M	0.00	0M	1.4G	0.71	.705M
Log File	166M	0.10	.081M	180M	3.30	.088M	32.94	444.08
Control File	232M	4.77	.113M	57M	0.68	.028M	53.64	87.79
Archive Log	2M	0.01	.001M	166M	0.08	.081M	54.58	136.00
Temp File	32M	0.91	.016M	111M	5.05	.054M	5.99	41.93
Data Pump Dump File	0M	0.00	0M	84M	1.17	.041M
Other	0M	0.03	0M	18M	0.05	.009M	17.27
Archive Log Backup	0M	0.00	0M	2M	0.00	.001M
TOTAL:	4.2G	48.58	2.089M	2.3G	19.65	1.131M	18.47	157.73

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Buffer Cache Reads	1.1G	21.49	.566M	0M	0.00	0M	44.1K	18.24
Buffer Cache Reads (Data File)	1.1G	21.49	.566M	0M	0.00	0M	44.1K	18.24
Others	319M	4.17	.155M	200M	0.55	.097M	8428	59.54
Others (Control File)	150M	3.95	.073M	32M	0.44	.016M	8139	60.73
Others (Archive Log)	0M	0.00	0M	166M	0.08	.081M	0
Others (Log File)	166M	0.09	.081M	0M	0.00	0M	23	14.30
Others (Data File)	3M	0.13	.001M	2M	0.03	.001M	266	26.95
DBWR	0M	0.00	0M	289M	12.41	.141M	0
DBWR (Data File)	0M	0.00	0M	289M	12.41	.141M	0
LGWR	1M	0.04	0M	181M	3.32	.088M	86	8.15
LGWR (Log File)	0M	0.00	0M	180M	3.30	.088M	20	6.15
LGWR (Control File)	1M	0.03	0M	1M	0.02	0M	66	8.76
RMAN	76M	0.58	.037M	26M	0.18	.013M	1205	25.54
RMAN (Control File)	74M	0.57	.036M	24M	0.18	.012M	1181	24.94
RMAN (Archive Log Backup)	0M	0.00	0M	2M	0.00	.001M	0
RMAN (Archive Log)	2M	0.01	.001M	0M	0.00	0M	24	54.58
Streams AQ	0M	0.02	0M	0M	0.00	0M	38	18.00
Streams AQ (Data File)	0M	0.02	0M	0M	0.00	0M	38	18.00
TOTAL:	1.5G	26.30	.759M	696M	16.47	.339M	53.8K	24.85

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
SYSTEM	73,921	36	24.16	5.11	11,963	27.79	13	6	107	45.89
SYSAUX	9,773	5	65.22	8.14	2,946	3.67	9	1	17	7.06
TEMP	1,310	1	5.24	2.72	5,951	0.47	5	3	0	0.00
UNDOTBS1	470	0	355.26	36.52	2,360	0.10	38	1	6	0.00
DEV_ORABAM	770	0	26.25	4.20	66	0.31	6	0	0	0.00
DEV_PORTAL	808	0	126.05	13.82	5	0.30	8	0	0	0.00
DEV_SOAINFRA	448	0	18.79	3.73	5	0.18	5	0	0	0.00
DEV_PORTAL_IDX	178	0	49.10	6.66	5	0.08	14	0	0	0.00
DEV_IAS_ORASDPM	137	0	36.20	6.05	5	0.06	6	0	0	0.00
USERS	51	0	31.18	5.16	5	0.02	17	0	0	0.00
UNDOTBS2	38	0	61.58	12.58	5	0.02	25	0	0	0.00
DEV_IAS_PORTLET	34	0	34.71	6.76	5	0.01	22	0	0	0.00
DEV_MDS	23	0	22.17	6.43	5	0.01	16	0	0	0.00
DEV_PORTAL_DOC	23	0	18.26	6.43	5	0.01	17	0	0	0.00
DEV_PORTAL_LOG	23	0	14.35	6.43	5	0.01	13	0	0	0.00
DEV_IAS_TEMP	1	0	30.00	1.00	0	0.00	30	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
DEV_IAS_ORASDPM	+DATA/orcl/datafile/dev_ias_orasdpm.269.915134781	137	0	36.20	6.05	0	5.79	5	0	0	0.00
DEV_IAS_PORTLET	+DATA/orcl/datafile/dev_ias_portlet.274.915134845	34	0	34.71	6.76	0	21.72	5	0	0	0.00
DEV_IAS_TEMP	+DATA/orcl/tempfile/dev_ias_temp.270.915134809	1	0	30.00	1.00	0	30.00	0	0	0
DEV_MDS	+DATA/orcl/datafile/dev_mds.275.915134847	23	0	22.17	6.43	0	16.19	5	0	0	0.00
DEV_ORABAM	+DATA/orcl/datafile/dev_orabam.277.915134865	770	0	26.25	4.20	0	6.33	66	0	0	0.00
DEV_PORTAL	+DATA/orcl/datafile/dev_portal.276.915134855	808	0	126.05	13.82	0	8.26	5	0	0	0.00
DEV_PORTAL_DOC	+DATA/orcl/datafile/dev_portal_doc.272.915134837	23	0	18.26	6.43	0	16.67	5	0	0	0.00
DEV_PORTAL_IDX	+DATA/orcl/datafile/dev_portal_idx.273.915134839	178	0	49.10	6.66	0	14.32	5	0	0	0.00
DEV_PORTAL_LOG	+DATA/orcl/datafile/dev_portal_log.268.915134781	23	0	14.35	6.43	0	13.33	5	0	0	0.00
DEV_SOAINFRA	+DATA/orcl/datafile/dev_soainfra.271.915134809	448	0	18.79	3.73	0	5.37	5	0	0	0.00
SYSAUX	+DATA/orcl/datafile/sysaux.257.903477839	9,773	5	65.22	8.14	4	8.51	2,946	1	17	7.06
SYSTEM	+DATA/orcl/datafile/system.256.903477837	73,921	36	24.16	5.11	28	13.49	11,963	6	107	45.89
TEMP	+DATA/orcl/tempfile/temp.263.903478051	1,310	1	5.24	2.72	0	5.49	5,951	3	0
UNDOTBS1	+DATA/orcl/datafile/undotbs1.258.903477841	470	0	355.26	36.52	0	37.66	2,360	1	6	0.00
UNDOTBS2	+DATA/orcl/datafile/undotbs2.264.903478367	38	0	61.58	12.58	0	25.16	5	0	0	0.00
USERS	+DATA/orcl/datafile/users.259.903477841	51	0	31.18	5.16	0	16.90	5	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	7,664	99	21,006,912	182,484	31,454	0	2	130

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 42,060

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	160	0	0	998	3

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	0	214	704	82944	82944				0
E	0	5	413	58690	82944	82944	359458			1

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report. Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	4	0.06	0	2.02	392	1	3684.00
D	8	0.12	1	1.79	347	1	3104.00
D	12	0.18	1	1.66	322	1	2780.00
D	16	0.24	2	1.55	300	1	2496.00
D	20	0.29	2	1.38	268	1	2075.00
D	24	0.35	3	1.21	235	1	1641.00
D	28	0.41	3	1.17	226	1	1528.00
D	32	0.47	4	1.12	217	1	1408.00
D	36	0.53	4	1.10	213	1	1354.00
D	40	0.59	5	1.09	210	1	1320.00
D	44	0.65	5	1.06	206	1	1257.00
D	48	0.71	6	1.04	201	1	1197.00
D	52	0.76	6	1.03	199	1	1167.00
D	56	0.82	7	1.02	197	1	1149.00
D	60	0.88	7	1.01	196	1	1129.00
D	64	0.94	8	1.00	194	1	1110.00
D	68	1.00	8	1.00	194	1	1103.00
D	72	1.06	9	0.99	192	1	1084.00
D	76	1.12	9	0.98	190	1	1059.00
D	80	1.18	10	0.97	188	1	1033.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
99.02	1,042	10

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report. Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs
2K	4K	134,097	134,097	0
64K	128K	240	240	0
128K	256K	90	90	0
256K	512K	133	133	0
512K	1024K	313	313	0
1M	2M	267	267	0
2M	4M	28	24	4
4M	8M	10	10	0
8M	16M	2	2	0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
21	0.13	1,084.47	512.43	68.00	70	5,507,315
42	0.25	1,084.47	512.43	68.00	70	5,507,315
84	0.50	1,084.47	512.43	68.00	70	5,507,315
126	0.75	1,084.47	512.43	68.00	70	5,507,315
168	1.00	1,084.47	2.57	100.00	70	3,748,941
202	1.20	1,084.47	0.00	100.00	66	3,740,067
235	1.40	1,084.47	0.00	100.00	56	3,740,067
269	1.60	1,084.47	0.00	100.00	27	3,740,067
302	1.80	1,084.47	0.00	100.00	3	3,740,067
336	2.00	1,084.47	0.00	100.00	1	3,740,067
504	3.00	1,084.47	0.00	100.00	0	3,740,067
672	4.00	1,084.47	0.00	100.00	0	3,740,067
1,008	6.00	1,084.47	0.00	100.00	0	3,740,067
1,344	8.00	1,084.47	0.00	100.00	0	3,740,067

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
152	1.00	17	1,237	127,545	1.00	362	1.00	2,492
156	1.03	21	1,315	127,574	1.00	333	0.92	2,493
160	1.05	25	1,528	127,584	1.00	323	0.89	2,494
164	1.08	28	1,879	127,592	1.00	315	0.87	2,494
168	1.11	31	2,127	127,596	1.00	311	0.86	2,495
172	1.13	34	2,410	127,602	1.00	305	0.84	2,495
176	1.16	37	2,595	127,605	1.00	302	0.83	2,495
180	1.18	41	2,872	127,608	1.00	299	0.83	2,495
184	1.21	45	3,142	127,612	1.00	295	0.81	2,496
188	1.24	49	3,202	127,619	1.00	288	0.80	2,496
200	1.32	61	3,216	127,658	1.00	249	0.69	2,497
216	1.42	77	3,343	127,686	1.00	221	0.61	2,497
232	1.53	92	4,255	127,699	1.00	208	0.57	2,498
248	1.63	108	4,692	127,721	1.00	186	0.51	2,499
264	1.74	124	4,960	127,734	1.00	173	0.48	2,499
280	1.84	140	4,963	127,741	1.00	166	0.46	2,500
296	1.95	156	5,336	127,746	1.00	161	0.44	2,500
312	2.05	171	5,911	127,747	1.00	160	0.44	2,500

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
183	0.75	9,581	267,585
244	1.00	2,230	191,392
305	1.25	2,092	187,468
366	1.50	2,015	187,468
427	1.75	2,003	187,468
488	2.00	2,003	187,468

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
4	0.50	0	0	0	0
8	1.00	0	0	0	0
12	1.50	0	0	0	0
16	2.00	0	0	0	0
20	2.50	0	0	0	0
24	3.00	0	0	0	0
28	3.50	0	0	0	0
32	4.00	0	0	0	0
36	4.50	0	0	0	0
40	5.00	0	0	0	0
44	5.50	0	0	0	0
48	6.00	0	0	0	0
52	6.50	0	0	0	0
56	7.00	0	0	0	0
60	7.50	0	0	0	0
64	8.00	0	0	0	0
68	8.50	0	0	0	0
72	9.00	0	0	0	0
76	9.50	0	0	0	0
80	10.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report. Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	106	5	44
segment header	18	0	21
undo header	4	0	0
undo block	2	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TQ-Queue table enqueue (TM contention)	4	4	0	4	11	2,795.00
TQ-Queue table enqueue (DDL contention)	43	42	1	2	6	2,855.00
TC-Tablespace Checkpoint	3	3	0	1	3	3,020.00
CF-Controlfile Transaction	4,487	4,486	1	4	1	135.00
KO-Multiple Object Checkpoint (fast object checkpoint)	80	80	0	3	0	60.00
CR-Reuse Block Range (block range reuse ckpt)	90	90	0	8	0	3.75
JS-Job Scheduler (queue lock)	70,071	70,071	0	1	0	10.00
TM-DML	20,563	20,563	0	1	0	10.00
RO-Multiple Object Reuse (fast object reuse)	90	90	0	2	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	3.86	8,241	911	4	19.1/29.2	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
21-Jun 22:24	1,144	1,121	911	4	29	0/0	0/0/0/0/0/0
21-Jun 22:14	1,679	3,465	307	4	19	0/0	0/0/0/0/0/0
21-Jun 22:04	1,038	3,655	910	4	29	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0	0
AQ dequeue txn counter latch	545	0.00		0	0
ASM Keyed state latch	89	0.00		0	0
ASM allocation	1,051	0.00		0	0
ASM db client latch	1,384	0.00		0	0
ASM map headers	1,244	0.00		0	0
ASM map load waiting list	282	0.00		0	0
ASM map operation freelist	693	0.00		0	0
ASM map operation hash table	840,044	0.00		0	0
ASM network background latch	2,871	0.00		0	0
ASM network state latch	1,114	0.00		0	0
AWR Alerted Metric Element list	15,223	0.00		0	0
Change Notification Hash table latch	707	0.00		0	0
Consistent RBA	6,720	0.00		0	0
DML lock allocation	41,145	0.00		0	0
Event Group Locks	104	0.00		0	0
FAL Queue	90	0.00		0	0
FIB s.o chain latch	323	0.00		0	0
FOB s.o list latch	901	0.00		0	0
File IO Stats segmented array latch	1	0.00		0	0
File State Object Pool Parent Latch	1	0.00		0	0
I/O Staticstics latch	1	0.00		0	0
IPC other latch	17	0.00		0	0
IPC stats buffer allocation latch	85	0.00		0	94	0.00
In memory undo latch	1	0.00		0	0
JS Sh mem access	9	33.33	1.00	0	0
JS broadcast add buf latch	3,859	0.00		0	0
JS broadcast drop buf latch	3,859	0.00		0	0
JS broadcast kill buf latch	1	0.00		0	0
JS broadcast load blnc latch	3,801	0.00		0	0
JS mem alloc latch	37	0.00		0	0
JS queue access latch	30	0.00		0	0
JS queue state obj latch	140,210	0.00		0	0
JS slv state obj latch	29	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KFK SGA Libload latch	228	0.00		0	0
KFMD SGA	14	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	1	0.00		0	0
KJCT flow control latch	1	0.00		0	0
KMG MMAN ready and startup request latch	2,769	0.00		0	0
KMG resize request state object freelist	24	0.00		0	0
KSXR large replies	12	0.00		0	0
KTF sga latch	19	0.00		0	553	0.00
KWQMN job cache list latch	517	0.19	1.00	0	0
KWQP Prop Status	124	0.00		0	0
KWQS pqsubs latch	9	0.00		0	0
KWQS pqueue ctx latch	9	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	118	0.00		0	0
MQL Tracking Latch	0			0	39	0.00
Memory Management Latch	2,479	0.00		0	2,759	0.00
Memory Queue	636	0.00		0	0
Memory Queue Message Subscriber #1	729	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	774	0.00		0	0
MinActiveScn Latch	699	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
NLS data objects	5	0.00		0	0
OS process	364	0.00		0	0
OS process allocation	4,153	0.00		0	0
OS process: request allocation	89	0.00		0	0
PL/SQL warning settings	75,066	0.00		0	0
PX hash array latch	1	0.00		0	0
Policy Hash Table Latch	419	0.00		0	0
QMT	2	0.00		0	0
Real-time plan statistics latch	349	0.00		0	2	0.00
Reserved Space Latch	86	0.00		0	0
SGA IO buffer pool latch	1,092	0.00		0	1,100	0.00
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	67	0.00		0	623	0.00
SQL memory manager workarea list latch	49,435	0.00		0	0
STREAMS Pool Advisor	2	0.00		0	57	0.00
Shared B-Tree	3,706	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	1,699	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB NFS Stateful SGA Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	2,402	0.00		0	0
active service list	124,048	0.00		0	2,491	0.00
alert log latch	10	0.00		0	0
archive control	296	0.00		0	0
archive process latch	278	2.52	1.00	0	0
begin backup scn array	2,230	0.04	1.00	0	0
bq:time manger info latch	97	0.00		0	0
buffer pool	19	0.00		0	0
bufq statistics	1,487	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	258,479	0.00	1.00	0	0
cache buffers chains	44,575,769	0.00	0.91	0	550,418	0.01
cache buffers lru chain	543,559	0.01	1.02	0	518,405	0.02
cache table scan latch	8,086	0.00		0	8,086	0.00
call allocation	22,956	0.01	1.00	0	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	154	0.00		0	0
channel operations parent latch	11,611,941	0.00		0	0
checkpoint queue latch	49,761	0.00	1.00	0	31,983	0.00
client/application info	446	0.00		0	0
compile environment latch	56	0.00		0	0
corrupted undo seg latch	261	0.00		0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	40	0.00		0	0
cvmap freelist lock	1	0.00		0	0
database property service latch	8	0.00		0	0
datapump attach fixed tables latch	40	0.00		0	0
datapump job fixed tables latch	48	0.00		0	0
deferred cleanup latch	40	0.00		0	0
device information	28	0.00		0	0
dml lock allocation	210	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	108	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	3	66.67	1.00	0	341,389	0.00
enqueue hash chains	452,697	0.00	1.14	0	35	0.00
enqueue sob latch	17	0.00		0	0
enqueues	206	0.00		0	0
fifteenth spare latch - children	1	0.00		0	0
file cache latch	430	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	724,062	0.00	0.97	0	10,224	0.00
gcr global ctx	49	0.00		0	0
gcs commit scn state	1	0.00		0	0
gcs partitioned table hash	2,873,965	0.00		0	5,400	0.00
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs remaster request queue	93	0.00		0	0
gcs resource freelist	350,556	0.00	1.00	0	18	0.00
gcs resource hash	415,249	0.00	1.00	0	0
gcs resource scan list	1	0.00		0	0
gcs resource validate list	1	0.00		0	0
gcs shadows freelist	1	0.00		0	0
ges caches resource lists	1,317,065	0.00	1.00	0	136,321	0.00
ges deadlock list	24	0.00		0	2	0.00
ges domain table	2,765,032	0.00		0	0
ges enqueue table freelist	2,832,742	0.00	0.97	0	0
ges group table	2,764,282	0.00		0	0
ges process hash list	825	0.00		0	0
ges process parent latch	5,949,181	0.18	1.00	1	0
ges process table freelist	89	0.00		0	0
ges resource hash list	5,936,975	0.19	1.00	2	107,029	0.00
ges resource scan list	1	0.00		0	0
ges resource table freelist	208,028	0.00	1.00	0	0
ges timeout list	30	0.00		0	118	0.00
ges value block free list	11,190	0.00		0	0
global KZLD latch for mem in SGA	11	0.00		0	0
global tx hash mapping	1	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	1,338	0.00		0	775,588	0.00
hash table modification latch	185	0.00		0	0
heartbeat check	1	0.00		0	466	0.00
heartbeat structure management	0			0	396	0.00
image handles of buffered messages latch	728	0.00		0	0
internal temp table object number allocation latch	33	0.00		0	0
interrupt manipulation	4	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	10	0.00		0	9	0.00
job_queue_processes free list latch	28	0.00		0	0
job_queue_processes parameter latch	3,838	0.00		0	0
k2q global data latch	1,320	0.00		0	0
k2q lock allocation	1	0.00		0	0
kcbtsemkid latch	5	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
kmcptab latch	3	0.00		0	0
kmcpvec latch	0			0	1	0.00
kokc descriptor allocation latch	1,744,219	0.01	1.12	0	0
krbmrosl	124	0.00		0	0
ksbxic instance latch	34	0.00		0	0
ksfv messages	1	0.00		0	0
ksim group membership cache	5,092	0.00		0	0
ksim membership request latch	52	0.00		0	1,383	0.00
kss move lock	41	0.00		0	0
ksuosstats global area	201	0.50	1.00	0	0
ksv allocation latch	115	0.00		0	0
ksv class latch	9,424	0.07	1.00	0	2	0.00
ksv instance latch	21	0.00		0	0
ksv msg queue latch	354	0.00		0	353	0.00
ksxp shared latch	89	0.00		0	0
ksxp so latch	89	0.00		0	0
ksz_so allocation latch	89	0.00		0	0
ktm global data	111	0.00		0	0
kupp process latch	76	0.00		0	0
kwqbsgn:msghdr	1,092	0.00		0	0
kwqbsn:qsga	1,174	0.00		0	56	1.79
kwqbsn:qxl	50	0.00		0	0
kwqi:kchunk latch	7	0.00		0	0
lgwr LWN SCN	6,851	0.00		0	0
list of block allocation	503	0.00		0	0
loader state object freelist	14,560	0.01	1.00	0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	7	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
logical standby cache	1	0.00		0	0
logminer context allocation	1	0.00		0	0
logminer local	1	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	1,027	0.00		0	820	0.00
managed standby latch	87	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	925	0.00		0	0
messages	539,460	0.00	1.00	0	0
mostly latch-free SCN	6,851	0.00		0	0
msg queue latch	1	0.00		0	0
multiblock read objects	20,462	0.00		0	0
name-service memory objects	4,032	0.00		0	0
name-service namespace bucket	10,768	0.00		0	0
name-service pending queue	4,032	0.00		0	0
name-service request queue	18,314	0.00		0	0
ncodef allocation latch	40	0.00		0	0
nineth spare latch - X parent	1	0.00		0	0
object queue header heap	12,245	0.00		0	10,185	0.00
object queue header operation	733,393	0.00	0.91	0	7,995	0.00
object stats modification	12,719	0.00		0	0
parallel query alloc buffer	257	0.00		0	0
parallel query stats	1	0.00		0	0
parallel txn reco latch	140	0.00		0	0
parameter list	241	0.00		0	0
parameter table management	300	0.33	1.00	0	0
pass worker exception to master	39	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
post/wait queue	33,116	0.00		0	32,742	0.00
process allocation	633	0.00		0	47	0.00
process group creation	89	0.00		0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qm_init_sga	2	0.00		0	0
qmn state object latch	3	0.00		0	0
qmn task queue latch	1,320	0.15	1.00	0	0
qmtmrcsg_init	1	0.00		0	0
query server freelists	1	0.00		0	0
queue sender's info. latch	2,328	0.00		0	0
queued dump request	6	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	13,645	0.23	1.10	0	342,036	0.02
redo copy	6	0.00		0	342,058	0.01
redo writing	23,749	0.00		0	0
reservation so alloc latch	16	0.00		0	0
resmgr group change latch	115	0.00		0	0
resmgr:active threads	10,465	0.00		0	633	0.00
resmgr:actses change group	110	0.00		0	0
resmgr:actses change state	34	0.00		0	0
resmgr:free threads list	121	0.00		0	0
resmgr:method mem alloc latch	16	0.00		0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	15,964	0.01	1.00	0	0
resmgr:schema config	88,755	0.00		0	30	0.00
resmgr:session queuing	1	0.00		0	0
resumable state object	470	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	9,530,544	0.00	1.00	0	24,441	0.16
rules engine aggregate statistics	743	0.00		0	0
rules engine evaluation context statistics	10	0.00		0	0
rules engine rule set statistics	1,885	0.00		0	0
rules engine rule statistics	374	0.00		0	0
second Audit Vault latch	1	0.00		0	0
segmented array pool	276	0.00		0	0
sequence cache	487	0.00		0	0
session allocation	1,651	0.00		0	0
session idle bit	4,142	0.00		0	0
session queue latch	1	0.00		0	0
session state list latch	185	0.00		0	0
session switching	83	0.00		0	0
session timer	667	0.00		0	0
seventh spare latch - X parent	1	0.00		0	0
shared pool	2,372,785	0.04	1.10	3	0
shared pool sim alloc	323	0.00		0	0
shared pool simulator	83,416	0.00	1.00	0	0
shared server configuration	30	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	1,455,182	0.00		0	0
simulator lru latch	172	0.00		0	1,412,915	0.01
sixth spare latch - X parent	1	0.00		0	0
sort extent pool	682	0.00		0	0
space background state object latch	8	0.00		0	0
space background task latch	4,408	0.02	1.00	0	1,340	0.00
spilled messages latch	14	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	1,875	0.00		0	0
tablespace key chain	1	0.00		0	0
temp lob duration state obj allocation	9	0.00		0	0
temporary table state object allocation	15	0.00		0	0
tenth spare latch - X parent	1	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
thirteenth spare latch - children	1	0.00		0	0
threshold alerts latch	117	0.00		0	0
trace latch	8	0.00		0	0
transaction allocation	2,916	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	48,774	0.00		0	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0
write info latch	0			0	6,720	0.00

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
ges resource hash list	5,936,975	11,007	11,008	1
ges process parent latch	5,949,181	10,783	10,783	0
shared pool	2,372,785	1,009	1,109	23
row cache objects	9,530,544	246	245	12
kokc descriptor allocation latch	1,744,219	126	141	0
ges enqueue table freelist	2,832,742	88	85	3
cache buffers lru chain	543,559	50	51	0
gc element	724,062	36	35	1
redo allocation	13,645	31	34	0
cache buffers chains	44,575,769	23	21	2
object queue header operation	733,393	11	10	1
archive process latch	278	7	7	0
enqueue hash chains	452,697	7	8	0
ksv class latch	9,424	7	7	0
gcs resource freelist	350,556	6	6	0
gcs resource hash	415,249	4	4	0
JS Sh mem access	9	3	3	0
ges caches resource lists	1,317,065	3	3	0
ges resource table freelist	208,028	3	3	0
messages	539,460	3	3	0
cache buffer handles	258,479	2	2	0
call allocation	22,956	2	2	0
enqueue freelist latch	3	2	2	0
qmn task queue latch	1,320	2	2	0
KWQMN job cache list latch	517	1	1	0
begin backup scn array	2,230	1	1	0
checkpoint queue latch	49,761	1	1	0
ksuosstats global area	201	1	1	0
loader state object freelist	14,560	1	1	0
parameter table management	300	1	1	0
resmgr:resource group CPU method	15,964	1	1	0
shared pool simulator	83,416	1	1	0
space background task latch	4,408	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
JS Sh mem access	jsksGetShMemLatch	3	3
KWQMN job cache list latch	kwqmnuji: update job item	1	0
archive process latch	kcrrsarc	7	0
begin backup scn array	get begin backup scn for file	1	1
cache buffer handles	kcbzfs	1	0
cache buffer handles	kcbzgs	1	2
cache buffers chains	kcbgtcr: fast path	12	4
cache buffers chains	kcbgtcr: fast path (cr pin)	3	2
cache buffers chains	kcbchg1: mod cr pin	1	1
cache buffers chains	kcbgcur_2	1	1
cache buffers chains	kcbget: fast exchange	1	0
cache buffers chains	kcbgtcr_1	1	0
cache buffers chains	kcbivbr	1	2
cache buffers chains	kcbrls_2	1	3
cache buffers chains	kcbzgb: scan from tail. nowait	1	0
cache buffers lru chain	kcbzgws_1	25	50
cache buffers lru chain	kcbzgb_2	19	0
cache buffers lru chain	kcbo_link_q	3	0
cache buffers lru chain	kcb_mv_to_req	1	0
cache buffers lru chain	kcbbwlru	1	0
cache buffers lru chain	kcbzgm	1	0
cache buffers lru chain	kcbzswcu	1	0
call allocation	ksucrp: top call	1	0
call allocation	ksuprc	1	1
checkpoint queue latch	kcbk_get_cqlt_nowait2	1	0
enqueue freelist latch	ksqdeli	2	0
enqueue hash chains	ksqgtl3	4	1
enqueue hash chains	ksqcmi: if lk mode requested	2	1
enqueue hash chains	ksqrcl	2	6
gc element	kclnfndnewm	23	5
gc element	kclrwrite	5	3
gc element	kclfwrite1	3	1
gc element	kclevict	2	0
gc element	kclulb	2	7
gcs resource freelist	kjbralc add resource	6	1
gcs resource hash	kjbcropen	4	0
ges caches resource lists	kjrm2c: move resource to cache	3	3
ges enqueue table freelist	kjlfr: remove lock from parent object	47	28
ges enqueue table freelist	kjlalc: lock allocation	38	57
ges process parent latch	kjata_fg	10,783	0
ges resource hash list	kjrmas1: lookup master node	10,873	0
ges resource hash list	kjlrlr: remove lock from resource queue	92	16
ges resource hash list	kjucvl: lock convert request	36	11,064
ges resource hash list	kjakoca: search for resp by resname	6	103
ges resource hash list	kjrref: find matched resource	1	30
ges resource table freelist	kjralc: resource allocation	3	2
kokc descriptor allocation latch	kokcdlt: regular free	101	19
kokc descriptor allocation latch	kokcdlt: allocation	40	116
ksuosstats global area	ksugetosstat	1	1
ksv class latch	ksvclsl: rdp - recycle	7	0
loader state object freelist	kcblfs	1	1
messages	ksarcv	2	2
messages	ksaamb: after wakeup	1	0
object queue header operation	kcbo_unlink_q	6	7
object queue header operation	kcbo_switch_q_bg	2	1
object queue header operation	kclevict	2	0
object queue header operation	kcbo_link_q	1	2
parameter table management	kspallmod	1	0
qmn task queue latch	kwqmngettsk: get task	1	3
qmn task queue latch	kwqmnmvtsks: delay to ready list	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	33	0
redo allocation	kcrfw_redo_write: before write	1	2
resmgr:resource group CPU method	kgkprrpicknext	1	1
row cache objects	kqreqd: reget	139	0
row cache objects	kqrbtm: pop parent	36	0
row cache objects	kqrpre: find obj	30	183
row cache objects	kqreqd	13	2
row cache objects	kqrso	7	1
row cache objects	kqrigt	6	24
row cache objects	kqrpre: init complete	3	5
row cache objects	kqrigt3	2	1
row cache objects	ksucallcbksafely: kqrhngc	2	0
row cache objects	kqrbip	1	0
shared pool	kghalo	696	185
shared pool	kghupr1	225	761
shared pool	kghalp	158	117
shared pool	kghfre	19	17
shared pool	kgh_heap_sizes	8	16
shared pool	kghfrunp: clatch: nowait	6	0
shared pool simulator	kglsim_upd_newhp	1	0
space background task latch	ktsj_grab_task	1	1

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Cursor Pin	kkslce [KKSCHLPIN2]	1,945
Cursor Pin	kksfbc [KKSCHLFSP2]	475
Library Cache	kglhdgn2 106	28
Library Cache	kglhdgn1 62	8
Library Cache	kglpndl1 95	8
Cursor Pin	kksfbc [KKSCHLPIN1]	7
Library Cache	kglget1 1	6
Library Cache	kglllal3 111	5
Library Cache	kglget2 2	4
Library Cache	kglpin1 4	4
Library Cache	kglhbh1 63	3
Library Cache	kgllkdl1 85	3
Library Cache	kgllkal1 80	1
Library Cache	kglpnal2 91	1

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report. Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report. Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads

Total Logical Reads: 21,116,065
Captured Segments account for 73.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	METANAMETRANS$		TABLE	3,451,824	16.35
MISSING	TEMP	** MISSING: -40016381/4197760	MISSING	UNDEFINED	3,406,016	16.13
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1431258748_0	TABLE PARTITION	1,949,808	9.23
SYS	SYSTEM	ICOL$		TABLE	1,403,872	6.65
SYS	SYSTEM	OBJ$		TABLE	597,328	2.83

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 282,860
Captured Segments account for 50.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	OBJ$	TABLE	53,821	19.03
SYS	SYSTEM	ICOL$	TABLE	36,708	12.98
SYS	SYSTEM	TYPE$	TABLE	26,443	9.35
SYSTEM	SYSTEM	SYS_LOB0000097569C00045$$	LOB	5,967	2.11
SYS	SYSTEM	I_OBJ2	INDEX	4,638	1.64

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 85,163
Captured Segments account for 40.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
SYS	SYSTEM	ICOL$	TABLE	6,399	7.51
SYS	SYSTEM	OBJ$	TABLE	6,356	7.46
SYS	SYSTEM	TYPE$	TABLE	5,941	6.98
SYS	SYSTEM	I_OBJ2	INDEX	2,766	3.25
SYSTEM	SYSTEM	SYS_LOB0000097569C00045$$	LOB	2,221	2.61

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 85,163
Captured Segments account for 40.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
SYS	SYSTEM	ICOL$	TABLE	6,399	7.51
SYS	SYSTEM	OBJ$	TABLE	6,356	7.46
SYS	SYSTEM	TYPE$	TABLE	5,941	6.98
SYS	SYSTEM	I_OBJ2	INDEX	2,766	3.25
SYSTEM	SYSTEM	SYS_LOB0000097569C00045$$	LOB	2,221	2.61

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report. Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 100,165
Captured Segments account for 92.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Direct Reads	%Total
SYS	SYSTEM	OBJ$	TABLE	49,896	49.81
SYS	SYSTEM	ICOL$	TABLE	21,593	21.56
SYS	SYSTEM	TYPE$	TABLE	13,348	13.33
SYSTEM	SYSTEM	SYS_LOB0000097569C00045$$	LOB	5,964	5.95
SYS	SYSTEM	VIEW$	TABLE	1,746	1.74

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 42,060
Captured Segments account for 46.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SYSTEM	SYSTEM	SYS_LOB0000097569C00045$$		LOB	8,469	20.14
MISSING	TEMP	** MISSING: -40016381/4197760	MISSING	UNDEFINED	7,306	17.37
SYSTEM	SYSTEM	J1		TABLE	936	2.23
SYSTEM	SYSTEM	SYS_MTABLE_000017D21_IND_1		INDEX	524	1.25
SYS	SYSTEM	ICOL$		TABLE	331	0.79

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 23,341
Captured Segments account for 41.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
MISSING	TEMP	** MISSING: -40016381/4197760	MISSING	UNDEFINED	5,616	24.06
SYSTEM	SYSTEM	SYS_LOB0000097569C00045$$		LOB	2,130	9.13
SYSTEM	SYSTEM	J1		TABLE	312	1.34
SYS	SYSTEM	ICOL$		TABLE	228	0.98
SYSTEM	SYSTEM	SYS_MTABLE_000017D21_IND_1		INDEX	144	0.62

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 10,545
Captured Segments account for 80.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYSTEM	SYSTEM	SYS_LOB0000097569C00045$$		LOB	8,461	80.24
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1431258748_0	TABLE PARTITION	17	0.16
MISSING	TEMP	** MISSING: -40016381/4197760	MISSING	UNDEFINED	12	0.11
SYSTEM	SYSTEM	SYS_MTABLE_000017D21_IND_1		INDEX	11	0.10
SYS	SYSAUX	SYS_LOB0000006409C00004$$		LOB	8	0.08

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 776
Captured Segments account for 40.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	ICOL$		TABLE	216	27.84
SYS	SYSTEM	OBJ$		TABLE	59	7.60
SYS	SYSTEM	TYPE$		TABLE	10	1.29
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1431258748_0	INDEX PARTITION	6	0.77
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY_INDEX		INDEX	5	0.64

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
MISSING	TEMP	** MISSING: -40016381/4197760	MISSING	UNDEFINED	996,448	79.91
SYSTEM	SYSTEM	J1		TABLE	45,744	3.67
SYSTEM	SYSTEM	SYS_MTABLE_000017D21_IND_1		INDEX	42,704	3.42
SYSTEM	SYSTEM	SYS_C0015840		INDEX	29,984	2.40
SYS	SYSTEM	I_H_OBJ#_COL#		INDEX	25,296	2.03

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report. Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report. Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	COL_USAGE$	TABLE	27	67.50
SYS	SYSTEM	MON_MODS$	TABLE	8	20.00
SYS	SYSTEM	I_MON_MODS$_OBJ	INDEX	3	7.50
SYS	SYSTEM	I_COL_USAGE$	INDEX	2	5.00

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

No data exists for this section of the report. Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

No data exists for this section of the report. Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

No data exists for this section of the report. Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	61	27.87	2	1
dc_constraints	81	51.85	81	0
dc_files	210	13.33	0	0
dc_global_oids	887,026	0.15	17	93
dc_histogram_data	97,736	10.21	1,665	442
dc_histogram_defs	273,606	12.34	11,152	1,311
dc_object_grants	1,845	25.80	0	10
dc_objects	1,187,878	1.77	578	789
dc_profiles	27	29.63	0	0
dc_rollback_segments	463	0.00	0	22
dc_segments	42,201	15.39	239	150
dc_sequences	41	97.56	41	0
dc_table_scns	12	100.00	0	0
dc_tablespaces	108,663	0.07	0	15
dc_users	473,256	0.14	0	85
global database name	1,450	0.55	0	2
outstanding_alerts	38	97.37	1	0
qmc_app_cache_entries	1	100.00	0	0
qmrc_cache_entries	7	100.00	0	0
qmtmrcin_cache_entries	2	100.00	0	0
qmtmrciq_cache_entries	3	100.00	0	0
qmtmrctn_cache_entries	9	100.00	0	0
qmtmrctq_cache_entries	463	100.00	0	0
rule_info	22	100.00	0	0
sch_lj_objs	17	23.53	0	0
sch_lj_oids	9	55.56	0	0

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Releases
dc_awr_control	21	17
dc_constraints	149	29
dc_files	28	28
dc_global_oids	1,383	1,288
dc_histogram_defs	46,855	28,190
dc_objects	21,477	20,917
dc_profiles	8	9
dc_segments	6,873	6,577
dc_sequences	82	41
dc_table_scns	12	0
dc_tablespaces	79	79
dc_users	483	487
global database name	8	7
outstanding_alerts	74	48
qmc_app_cache_entries	1	1
qmrc_cache_entries	7	7
qmtmrcin_cache_entries	2	2
qmtmrciq_cache_entries	3	3
qmtmrctn_cache_entries	9	9
qmtmrctq_cache_entries	463	463
rule_info	22	0
sch_lj_objs	4	4
sch_lj_oids	5	6

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
APP CONTEXT	22	4.55	239	4.60	10	0
BODY	2,445	11.25	83,195	0.68	265	0
CLUSTER	3,506	1.31	3,689	1.27	1	0
DBLINK	25	28.00	0		0	0
EDITION	30	53.33	46	67.39	1	0
INDEX	8,410	19.82	7,138	41.02	14	0
OBJECT ID	168	100.00	0		0	0
QUEUE	1,243	0.97	4,618	1.71	36	0
RULESET	78	53.85	830	10.96	41	0
SCHEMA	13,389	0.55	0		0	0
SQL AREA	37,461	36.67	956,488	3.63	4,340	545
SQL AREA BUILD	12,943	88.68	0		0	0
SQL AREA STATS	10,240	93.08	10,240	93.11	3	0
TABLE/PROCEDURE	832,210	1.09	1,134,922	2.30	6,888	0
TRANSFORMATION	197	15.74	197	15.74	0	0
TRIGGER	1,029	20.99	1,029	20.99	0	0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases
BODY	10	83,143	83,143
CLUSTER	3,689	3,689	3,689
DBLINK	25	0	0
EDITION	30	31	31
INDEX	7,127	7,127	7,127
QUEUE	3,624	4,620	4,620
RULESET	76	819	819
SCHEMA	79	0	0
TABLE/PROCEDURE	133,559	1,092,836	1,092,836
TRANSFORMATION	197	197	197
TRIGGER	0	1,029	1,029

Back to Library Cache Statistics
Back to Top

Memory Statistics

Memory Dynamic Components

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

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	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	100.00	64.00	48.00	108.00	9	SHR/IMM
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	168.00	168.00	168.00	168.00	0	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	244.00	244.00	244.00	244.00	0	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	0	STA/
java pool	4.00	4.00	4.00	4.00	0	STA/
large pool	8.00	8.00	8.00	68.00	0	SHR/DEF
shared pool	124.00	152.00	116.00	152.00	7	GRO/IMM
streams pool	0.00	8.00	0.00	8.00	2	GRO/IMM

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

Resizes, Grows, Shrinks - Operations captured by AWR if there are operations on the same component for the same operation_type, target_size, and with the same start_time only one operation is captured
ordered by Component

Component	Min Size (Mb)	Max Size (Mb)	Avg Size (Mb)	Re- Sizes	Grows	Shrinks
DEFAULT buffer cache	64.00	100.00	82.00	10	0	10
shared pool	124.00	152.00	138.00	8	8	0
streams pool	4.00	8.00	6.00	2	2	0

Back to Memory Statistics
Back to Top

Memory Resize Ops

Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred Delta : change in size of the component Target Delta: displayed only if final size <> target_size
Status: COMplete/CANcelled/INActive/PENding/ERRor
ordered by start_time desc,component

Start	Ela (s)	Component	Oper Typ/Mod	Init Size (M)	Delta	Final (M)	Sta
06/21 22:20:37	0	bufcache	SHR/IMM	68	-4	64	COM
06/21 22:20:37	0	shared	GRO/IMM	148	4	152	COM
06/21 22:19:37	60	bufcache	SHR/IMM	72	-4	68	COM
06/21 22:19:37	60	shared	GRO/IMM	144	4	148	COM
06/21 22:19:27	10	bufcache	SHR/IMM	76	-4	72	COM
06/21 22:19:27	10	shared	GRO/IMM	140	4	144	COM
06/21 22:18:01	2	bufcache	SHR/DEF	80	-4	76	COM
06/21 22:18:01	2	shared	GRO/DEF	136	4	140	COM
06/21 22:13:47	0	bufcache	SHR/IMM	84	-4	80	COM
06/21 22:13:47	0	streams	GRO/IMM	4	4	8	COM
06/21 22:13:42	5	bufcache	SHR/IMM	88	-4	84	COM
06/21 22:13:42	5	streams	GRO/IMM	0	4	4	COM
06/21 22:12:22	3	bufcache	SHR/DEF	92	-4	88	COM
06/21 22:12:22	3	shared	GRO/DEF	132	4	136	COM
06/21 22:07:52	2	bufcache	SHR/DEF	96	-4	92	COM
06/21 22:07:52	2	shared	GRO/DEF	128	4	132	COM
06/21 22:03:39	0	bufcache	SHR/IMM	100	-4	96	COM
06/21 22:03:39	0	shared	GRO/IMM	124	4	128	COM
06/21 21:56:18	3	bufcache	SHR/DEF	104	-4	100	COM
06/21 21:56:18	3	shared	GRO/DEF	120	4	124	COM

Back to Memory Statistics
Back to Top

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	241.36		4.73	6.99	27	27	51	51
B	Freeable	20.25	0.00	1.13	1.12	4		18	18
B	PL/SQL	0.79	0.60	0.02	0.04	0	0	49	49
B	SQL	0.55	0.08	0.03	0.03	0	2	20	17
E	Other	273.48		4.88	7.54	30	40	56	56
E	Freeable	37.69	0.00	1.88	4.85	22		20	20
E	PL/SQL	15.17	3.31	0.28	1.61	12	20	54	54
E	SQL	7.31	5.75	0.30	1.31	6	17	24	21

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	104,857,600	67,108,864
Fixed Size	1,365,124
Redo Buffers	6,045,696
Variable Size	318,770,044	356,518,780

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	4.00	4.00	0.00
large	ASM map operations hashta	0.23	0.23	0.00
large	PX msg pool	0.47	0.47	0.00
large	free memory	7.30	7.30	0.00
shared	ASH buffers	2.00	2.00	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGLH0	9.98	11.12	11.38
shared	KGLHD	1.62	1.70	4.86
shared	KGLS	2.74	2.22	-18.99
shared	KGLSG	3.52	3.52	0.00
shared	KKSSP		1.56
shared	KQR M PO	1.36		-100.00
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	KSXR receive buffers	2.02	2.02	0.00
shared	PLMCD	1.93	3.60	86.59
shared	SQLA	5.39	5.45	1.10
shared	XDBSC		7.74
shared	dbktb: trace buffer	2.34	2.34	0.00
shared	event statistics per sess	2.71	2.71	0.00
shared	free memory	14.35	28.09	95.76
shared	gc partition table	2.19	2.19	0.00
shared	ges big msg buffers	3.79	3.79	0.00
shared	ges enqueues	2.12	2.12	0.00
shared	ges reserved msg buffers	2.41	2.41	0.00
shared	ges resource	1.73	2.33	34.30
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	ksunfy : SSO free list	2.70	2.70	0.00
shared	ksws msg buffers	1.97	1.97	0.00
shared	obj stats allocation chun	2.32	2.32	0.00
shared	row cache	4.12	4.12	0.00
streams	free memory		7.93
	buffer_cache	100.00	64.00	-36.00
	fixed_sga	1.30	1.30	0.00
	log_buffer	5.77	5.77	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage

Streams processes ordered by CPU Time, descending

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	0621 21:45:47	1.10	0.49	0.00
QMON Coordinator	0621 21:45:36	0.25	0.00	0.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report. Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report. Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report. Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report. Back to Streams Statistics
Back to Top

Buffered Queues

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps

Queue Name	Enq Msgs	Enq Msgs/sec	Deq Msgs	Deq Msgs/sec	Spill Msgs	Spill Msgs/sec	%Spill Msgs
*SYS.KUPC$C_1_20160621221341(97620)	76	0.08	76	0.08	0	0.00	0.00
*SYS.KUPC$S_1_20160621221341(97624)	54	0.06	54	0.06	0	0.00	0.00

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

Ordered by Queue Name, Subscriber Name
* indicates Subscriber activity (re)started between Begin/End snaps

Subscriber/Queue	Enq Msgs	Enq Msgs/sec	Deq Msgs	Deq Msgs/sec
*KUPC$A_1_221349786798000(1)/SYS.KUPC$C_1_20160621221341	8	0.01	8	0.01
*KUPC$A_1_221407580069000(6)/SYS.KUPC$C_1_20160621221341	2	0.00	2	0.00
*MCP(5)/SYS.KUPC$C_1_20160621221341	66	0.07	66	0.07
*KUPC$A_1_221349786798000(3)/SYS.KUPC$S_1_20160621221341	54	0.06	54	0.06

Back to Streams Statistics
Back to Top

Rule Set

Rule Sets ordered by Evaluations
* indicates Rule Set activity (re)started between Begin/End snaps
SQL per Eval - average # of SQL statements executed for non-SQL free evals
CPU(s),Ela(s) per Eval - avg CPU and Elapsed time per evaluation includes both SQL free and non-SQL free evals

Rule	Evals	CPU(s)	Ela(s)	Eval /Sec	Ela(s) per Eval	CPU(s) per Eval	Reloads
*SYS.KUPC$C_1_20160621221341$1	76	0.02	0.01	0.08	0.00	0.00	6
*SYS.KUPC$C_1_20160621221341$5	76	0.04	0.13	0.08	0.00	0.00	6
*SYS.KUPC$C_1_20160621221341$6	60	0.20	0.46	0.06	0.01	0.00	5
*SYS.KUPC$S_1_20160621221341$3	54	0.23	0.80	0.06	0.01	0.00	4
*SYS.ALERT_QUE_R	5	0.17	0.88	0.00	0.18	0.03	2

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report. Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report. Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report. Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.
Back to Top

Shared Server Statistics

Shared Servers Activity

Values represent averages for all samples

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

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

Total Server Time (s)	%Busy	%Idle	Incoming Net %	Outgoing Net %
1,993	0.00	100.00	0.00	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report. Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

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

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

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u01/app/oracle/admin/orcl/adump
audit_trail	DB
cluster_database	TRUE
compatible	11.2.0.4.0
control_files	+DATA/orcl/controlfile/current.260.903478013
db_block_size	8192
db_create_file_dest	+DATA
db_domain	gdb.com
db_name	orcl
db_recovery_file_dest	+backup
db_recovery_file_dest_size	4294967296
diagnostic_dest	/u01/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=orclXDB)
instance_number	1
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=192.192.2.201)(PORT=1521))
log_archive_dest	+BACKUP
memory_target	432013312
open_cursors	300
plsql_warnings	DISABLE:ALL
processes	150
remote_listener	rac-scan:1521
remote_login_passwordfile	EXCLUSIVE
resource_manager_plan		SCHEDULER[0x32DA]:DEFAULT_MAINTENANCE_PLAN
service_names	orcl.gdb.com	SYS$SYS.KUPC$S_1_20160621221341.ORCL.GDB.COM, SYS$SYS.KUPC$C_1_20160621221341.ORCL.GDB.COM
spfile	+DATA/orcl/spfileorcl.ora
thread	1
undo_tablespace	UNDOTBS1

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

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

Parameter Name	Begin value	End value (if different)
service_names	(NULL)	SYS$SYS.KUPC$C_1_20160621221341.ORCL.GDB.COM
service_names	(NULL)	SYS$SYS.KUPC$S_1_20160621221341.ORCL.GDB.COM

Back to init.ora Parameters
Back to Top

RAC Statistics

	Begin	End
Number of Instances:	1	1

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	0.00	0.00
Global Cache blocks served:	0.00	0.00
GCS/GES messages received:	0.00	0.00
GCS/GES messages sent:	0.00	0.00
DBWR Fusion writes:	0.00	0.00
Estd Interconnect traffic (KB)	0.02

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %:	99.13
Buffer access - remote cache %:	0.00
Buffer access - disk %:	0.87

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.0
Avg global cache current block receive time (ms):	0.0
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	0.0
Avg global cache cr block flush time (ms):
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.0
Avg global cache current block flush time (ms):

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):
Avg message sent queue time on ksxp (ms):
Avg message received queue time (ms):
Avg GCS message process time (ms):
Avg GES message process time (ms):
% of direct sent messages:
% of indirect sent messages:
% of flow controlled messages:

Cluster Interconnect

if Public/Source at End snap is different a '*' is displayed

Interface	IP Address	Pub	Source	Pub	Src
	Begin			End
eth5:1	169.254.35.214	N

RAC Statistics

Global Messaging Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	0	0.00	0.00
acks for commit broadcast(logical)	0	0.00	0.00
broadcast msgs on commit(actual)	0	0.00	0.00
broadcast msgs on commit(logical)	0	0.00	0.00
broadcast msgs on commit(wasted)	0	0.00	0.00
dynamically allocated gcs resources	3,072	1.49	1.40
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	0	0.00	0.00
gcs ast xid	0	0.00	0.00
gcs blocked converts	0	0.00	0.00
gcs blocked cr converts	0	0.00	0.00
gcs compatible basts	0	0.00	0.00
gcs compatible cr basts (global)	0	0.00	0.00
gcs compatible cr basts (local)	0	0.00	0.00
gcs cr basts to PIs	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	0	0.00	0.00
gcs dbwr write request msgs	0	0.00	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 force cr block only	0	0.00	0.00
gcs force cr grant	0	0.00	0.00
gcs force cr no current	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	14,563	7.09	6.61
gcs immediate (null) converts	3,858	1.88	1.75
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	170,991	83.20	77.65
gcs indirect ast	0	0.00	0.00
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	0	0.00	0.00
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	0	0.00	0.00
gcs msgs process time(ms)	0	0.00	0.00
gcs msgs received	0	0.00	0.00
gcs new served by master	2,008	0.98	0.91
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	0	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	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	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	0	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	0	0.00	0.00
gcs side channel msgs logical	0	0.00	0.00
gcs stale cr	7,790	3.79	3.54
gcs undo cr	0	0.00	0.00
gcs write notification msgs	0	0.00	0.00
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	0	0.00	0.00
ges msgs received	0	0.00	0.00
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	0	0.00	0.00
implicit batch messages sent	0	0.00	0.00
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	0	0.00	0.00
messages queue sent actual	0	0.00	0.00
messages queue sent logical	0	0.00	0.00
messages received actual	0	0.00	0.00
messages received logical	0	0.00	0.00
messages sent directly	0	0.00	0.00
messages sent indirectly	0	0.00	0.00
messages sent not implicit batched	0	0.00	0.00
messages sent pbatched	0	0.00	0.00
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)	0	0.00	0.00
msgs received queued	0	0.00	0.00
msgs sent queue time (ms)	0	0.00	0.00
msgs sent queue time on ksxp (ms)	0	0.00	0.00
msgs sent queued	0	0.00	0.00
msgs sent queued on ksxp	0	0.00	0.00
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	0	0.00	0.00
process batch messages sent	0	0.00	0.00

Global CR Served Stats

Statistic	Total
CR Block Requests	0
CURRENT Block Requests	0
Data Block Requests	0
Undo Block Requests	0
TX Block Requests	0
Current Results	0
Private results	0
Zero Results	0
Disk Read Results	0
Fail Results	0
Fairness Down Converts	0
Fairness Clears	0
Free GC Elements	0
Flushes	0
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	0
Errors	0

Global CURRENT Served Stats

Pins = CURRENT Block Pin Operations
Flushes = Redo Flush before CURRENT Block Served Operations
Writes = CURRENT Block Fusion Write Operations

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	0	0.00	0.00	0.00	0.00	0.00
Flushes	0	0.00	0.00	0.00	0.00	0.00
Writes	0	0.00	0.00	0.00	0.00	0.00

Global Cache Transfer Stats

No data exists for this section of the report. Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer Times (ms)

No data exists for this section of the report. Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer (Immediate)

No data exists for this section of the report. Back to Global Cache Transfer Stats
Back to Top

Global Cache Times (Immediate)

No data exists for this section of the report. Back to Global Cache Transfer Stats
Back to Top

Interconnect Stats

Interconnect Ping Latency Stats

Ping latency of the roundtrip of a message from this instance to
target instances.
The target instance is identified by an instance number.
Average and standard deviation of ping latency is given in miliseconds
for message sizes of 500 bytes and 8K.
Note that latency of a message from the instance to itself is used as
control, since message latency can include wait for CPU

Target Instance	500B Ping Count	Avg Latency 500B msg	Stddev 500B msg	8K Ping Count	Avg Latency 8K msg	Stddev 8K msg
1	153	0.75	4.06	153	0.74	4.06
2	0	0.00	0.00	0	0.00	0.00

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Throughput of interconnect usage by major consumers
All throughput numbers are megabytes per second

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

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics

Throughput and errors of interconnect devices (at OS level)
All throughput numbers are megabytes per second

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
eth5:1	169.254.35.214	NO		0.00	0	0	0	0	0.00	0	0	0	0

Back to Interconnect Stats
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.
Back to TopEnd of Report

Friday, 24 June 2016

AWR report

WORKLOAD REPOSITORY report for

Report Summary

Main Report

RAC Statistics

Wait Events Statistics

Time Model Statistics

Operating System Statistics

Operating System Statistics - Detail

Foreground Wait Class

Foreground Wait Events

Background Wait Events

Wait Event Histogram

Wait Event Histogram Detail (64 msec to 2 sec)

Wait Event Histogram Detail (4 sec to 2 min)

Wait Event Histogram Detail (4 min to 1 hr)

Service Statistics

Service Wait Class Stats

SQL Statistics

SQL ordered by Elapsed Time

SQL ordered by CPU Time

SQL ordered by User I/O Wait Time

SQL ordered by Gets

SQL ordered by Reads

SQL ordered by Physical Reads (UnOptimized)

SQL ordered by Executions

SQL ordered by Parse Calls

SQL ordered by Sharable Memory

SQL ordered by Version Count

SQL ordered by Cluster Wait Time

Complete List of SQL Text

Instance Activity Statistics

Key Instance Activity Stats

Other Instance Activity Stats

Instance Activity Stats - Absolute Values

Instance Activity Stats - Thread Activity

IO Stats

IOStat by Function summary

IOStat by Filetype summary

IOStat by Function/Filetype summary

Tablespace IO Stats

File IO Stats

Buffer Pool Statistics

Buffer Pool Statistics

Checkpoint Activity

Advisory Statistics

Instance Recovery Stats

MTTR Advisory

Buffer Pool Advisory

PGA Aggr Summary

PGA Aggr Target Stats

PGA Aggr Target Histogram

PGA Memory Advisory

Shared Pool Advisory

SGA Target Advisory

Streams Pool Advisory

Java Pool Advisory

Wait Statistics

Buffer Wait Statistics

Enqueue Activity

Undo Statistics

Undo Segment Summary

Undo Segment Stats

Latch Statistics

Latch Activity

Latch Sleep Breakdown

Latch Miss Sources

Mutex Sleep Summary

Parent Latch Statistics

Child Latch Statistics

Segment Statistics

Segments by Logical Reads

Segments by Physical Reads

Segments by Physical Read Requests

Segments by UnOptimized Reads

Segments by Optimized Reads

Segments by Direct Physical Reads

Segments by Physical Writes

Segments by Physical Write Requests