WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

DEMO 3430975138 DEMO3 3 30-Jun-09 12:06 11.1.0.7.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
DEMO	3430975138	DEMO3	3	30-Jun-09 12:06	11.1.0.7.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

rsthpdbs103.us.oracle.com Linux x86 64-bit 8 8 2 31.44

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
rsthpdbs103.us.oracle.com	Linux x86 64-bit	8	8	2	31.44

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1047 02-Jul-09 13:12:32 43 1.3

End Snap: 1048 02-Jul-09 13:13:45 43 1.4

Elapsed: 1.21 (mins)

DB Time: 2.24 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1047	02-Jul-09 13:12:32	43	1.3
End Snap:	1048	02-Jul-09 13:13:45	43	1.4
Elapsed:		1.21 (mins)
DB Time:		2.24 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 4,928M 4,928M Std Block Size: 8K

Shared Pool Size: 1,024M 1,024M Log Buffer: 35,328K

	Begin	End
Buffer Cache:	4,928M	4,928M	Std Block Size:	8K
Shared Pool Size:	1,024M	1,024M	Log Buffer:	35,328K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 1.9 3.1 0.17 0.16

DB CPU(s): 1.5 2.5 0.13 0.12

Redo size: 20,790.6 35,039.0

Logical reads: 13,542.0 22,822.7

Block changes: 37.4 63.1

Physical reads: 14,134.8 23,821.7

Physical writes: 986.9 1,663.2

User calls: 11.9 20.1

Parses: 6.6 11.1

Hard parses: 0.8 1.3

W/A MB processed: 13,728,755.5 23,137,422.9

Logons: 2.3 3.8

Executes: 11.2 18.9

Rollbacks: 0.3 0.5

Transactions: 0.6

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.9	3.1	0.17	0.16
DB CPU(s):	1.5	2.5	0.13	0.12
Redo size:	20,790.6	35,039.0
Logical reads:	13,542.0	22,822.7
Block changes:	37.4	63.1
Physical reads:	14,134.8	23,821.7
Physical writes:	986.9	1,663.2
User calls:	11.9	20.1
Parses:	6.6	11.1
Hard parses:	0.8	1.3
W/A MB processed:	13,728,755.5	23,137,422.9
Logons:	2.3	3.8
Executes:	11.2	18.9
Rollbacks:	0.3	0.5
Transactions:	0.6

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 94.25 Soft Parse %: 88.47

Execute to Parse %: 41.18 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 0.00 % Non-Parse CPU: 99.97

Shared Pool Statistics

Begin End

Memory Usage %: 70.79 70.86

% SQL with executions>1: 86.68 92.07

% Memory for SQL w/exec>1: 87.80 91.21

	Begin	End
Memory Usage %:	70.79	70.86
% SQL with executions>1:	86.68	92.07
% Memory for SQL w/exec>1:	87.80	91.21

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		107		79.84
cell smart table scan	5,546	10	2	7.57	User I/O
direct path read temp	2,306	6	2	4.21	User I/O
reliable message	146	5	37	3.99	Other
direct path write temp	2,306	3	1	2.46	User I/O

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

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

0.01 1.28 18.7 0.9 0.0 80.2

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.01	1.28	18.7	0.9	0.0	80.2

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

18.6 94.1 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 32,189.6 32,189.6

SGA use (MB): 6,144.0 6,144.0

PGA use (MB): 387.0 388.3

% Host Mem used for SGA+PGA: 20.29 20.29

	Begin	End
Host Mem (MB):	32,189.6	32,189.6
SGA use (MB):	6,144.0	6,144.0
PGA use (MB):	387.0	388.3
% Host Mem used for SGA+PGA:	20.29	20.29

RAC Statistics

Begin End

Number of Instances: 8 8

	Begin	End
Number of Instances:	8	8

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 28.27 47.65

Global Cache blocks served: 9.52 16.05

GCS/GES messages received: 95.60 161.12

GCS/GES messages sent: 120.70 203.42

DBWR Fusion writes: 0.04 0.07

Estd Interconnect traffic (KB) 344.61

	Per Second	Per Transaction
Global Cache blocks received:	28.27	47.65
Global Cache blocks served:	9.52	16.05
GCS/GES messages received:	95.60	161.12
GCS/GES messages sent:	120.70	203.42
DBWR Fusion writes:	0.04	0.07
Estd Interconnect traffic (KB)	344.61

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

Buffer access - local cache %: 92.74

Buffer access - remote cache %: 7.18

Buffer access - disk %: 0.08

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1

Avg global cache cr block receive time (ms): 0.2

Avg global cache current block receive time (ms): 1.1

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 %: 3.2

Avg global cache cr block flush time (ms): 0.0

Avg global cache current block pin time (ms): 0.0

Avg global cache current block send time (ms): 0.0

Global cache log flushes for current blocks served %: 0.9

Avg global cache current block flush time (ms): 0.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 853.2

Avg message sent queue time on ksxp (ms): 0.1

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 43.46

% of indirect sent messages: 48.97

% of flow controlled messages: 7.57

Cluster Interconnect

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
bond0	172.31.88.111	N	Oracle Cluster Repository

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 134.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	133.14	99.26
DB CPU	107.10	79.84
PL/SQL execution elapsed time	5.37	4.01
parse time elapsed	0.16	0.12
hard parse elapsed time	0.12	0.09
hard parse (sharing criteria) elapsed time	0.10	0.08
PL/SQL compilation elapsed time	0.00	0.00
sequence load elapsed time	0.00	0.00
repeated bind elapsed time	0.00	0.00
DB time	134.14
background elapsed time	1.10
background cpu time	0.64

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	11,448
IDLE_TIME	46,483
IOWAIT_TIME	17
NICE_TIME	0
SYS_TIME	519
USER_TIME	10,852
LOAD	0	1
PHYSICAL_MEMORY_BYTES	33,753,260,032
NUM_CPUS	8
NUM_CPU_CORES	8
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	2,097,152
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
02-Jul 13:12:32	0.01
02-Jul 13:13:45	1.28	19.76	18.73	0.90	0.03	80.24

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 99.6% of Total DB time 134.14 (s)
Total FG Wait Time: 26.47 (s) DB CPU time: 107.10 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			107		79.84
User I/O	10,202	26	19	2	14.42
Other	3,918	78	6	2	4.70
System I/O	1,107	0	1	0	0.41
Cluster	932	0	0	0	0.11
Concurrency	554	0	0	0	0.09
Application	16	0	0	0	0.00
Network	45	0	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
cell smart table scan	5,546	48	10	2	128.98	7.57
direct path read temp	2,306	0	6	2	53.63	4.21
reliable message	146	3	5	37	3.40	3.99
direct path write temp	2,306	0	3	1	53.63	2.46
control file sequential read	1,107	0	1	0	25.74	0.41
PX Deq: Slave Session Stats	169	0	0	3	3.93	0.35
cell single block physical read	43	0	0	5	1.00	0.17
PX Nsq: PQ load info query	1	100	0	200	0.02	0.15
enq: PS - contention	283	25	0	0	6.58	0.07
PX Deq: Signal ACK RSG	32	50	0	3	0.74	0.07
library cache pin	269	0	0	0	6.26	0.06
gc cr multi block request	307	0	0	0	7.14	0.04
gc current multi block request	276	0	0	0	6.42	0.03
rdbms ipc reply	304	0	0	0	7.07	0.03
IPC send completion sync	679	100	0	0	15.79	0.02
library cache lock	232	0	0	0	5.40	0.02
gc current block 3-way	98	0	0	0	2.28	0.01
PX Deq: reap credit	2,266	100	0	0	52.70	0.01
row cache lock	50	0	0	0	1.16	0.01
gc cr block 3-way	70	0	0	0	1.63	0.01
gc current grant busy	40	0	0	0	0.93	0.01
gc current block 2-way	72	0	0	0	1.67	0.01
cell multiblock physical read	1	0	0	6	0.02	0.00
PX Deq: Signal ACK EXT	11	0	0	0	0.26	0.00
enq: KO - fast object checkpoint	2	0	0	3	0.05	0.00
gc cr block 2-way	44	0	0	0	1.02	0.00
enq: WF - contention	16	0	0	0	0.37	0.00
gc current grant 2-way	22	0	0	0	0.51	0.00
SQL*Net message from client	45	0	133	2963	1.05
PX Deq: Execute Reply	105	15	64	613	2.44
jobq slave wait	14	100	42	3001	0.33
PX Deq: Execution Msg	668	0	14	21	15.53
Streams AQ: waiting for messages in the queue	7	100	7	1000	0.16
PX Deq: Parse Reply	52	0	0	2	1.21
PX Deq: Join ACK	64	16	0	0	1.49
PX Deq Credit: send blkd	120	0	0	0	2.79

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	166	0	0	2	3.86	27.19
PX Deq: reap credit	2,210	100	0	0	51.40	5.86
DFS lock handle	27	0	0	2	0.63	3.99
control file parallel write	24	0	0	1	0.56	2.66
os thread startup	1	0	0	22	0.02	1.97
ges inquiry response	38	0	0	0	0.88	1.21
enq: CO - master slave det	24	100	0	1	0.56	1.15
log file parallel write	52	0	0	0	1.21	1.09
gcs log flush sync	51	0	0	0	1.19	0.61
ksxr poll remote instances	931	100	0	0	21.65	0.60
CGS wait for IPC msg	595	100	0	0	13.84	0.40
db file parallel write	2	0	0	1	0.05	0.15
enq: CF - contention	3	100	0	0	0.07	0.13
PX Idle Wait	2,046	92	4,790	2341	47.58
rdbms ipc message	3,024	36	3,103	1026	70.33
wait for unread message on broadcast channel	146	100	146	1001	3.40
DIAG idle wait	2,889	94	145	50	67.19
gcs remote message	6,146	53	145	24	142.93
dispatcher timer	2	100	120	60002	0.05
shared server idle wait	3	100	90	30000	0.07
Streams AQ: qmn slave idle wait	3	0	85	28449	0.07
Streams AQ: qmn coordinator idle wait	6	50	85	14224	0.14
ASM background timer	15	0	75	5005	0.35
Space Manager: slave idle wait	15	100	75	5001	0.35
PING	14	14	75	5355	0.33
ges remote message	3,770	18	72	19	87.67
pmon timer	29	83	72	2482	0.67
smon timer	1	0	14	13976	0.02

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ASM file metadata operation	15	100.0
CGS wait for IPC msg	592	100.0
IPC send completion sync	683	99.9	.1
PX Deq: Signal ACK EXT	11	90.9		9.1
PX Deq: Signal ACK RSG	32	75.0	9.4	6.3	6.3			3.1
PX Deq: Slave Session Stats	170	91.8	3.5	3.5	.6			.6
PX Deq: reap credit	4479	99.6	.2	.2	.0
PX Nsq: PQ load info query	1							100.0
SQL*Net break/reset to client	14	100.0
SQL*Net message to client	45	100.0
cell multiblock physical read	1			100.0
cell single block physical read	43	4.7	2.3	25.6	30.2	32.6	2.3	2.3
cell smart table scan	5546	84.4	5.7	.7	.2	5.6	3.2	.2
control file parallel write	24	45.8	41.7	12.5
control file sequential read	1273	96.4	.9	1.0	1.0	.4	.1	.2
db file parallel write	2	50.0	50.0
direct path read temp	2305	66.2	2.1	6.8	15.8	7.5	1.3	.2
direct path write temp	2306	25.1	62.8	10.1	2.0	.0
enq: AF - task serialization	1	100.0
enq: CF - contention	3	100.0
enq: CO - master slave det	24	95.8	4.2
enq: DR - contention	1	100.0
enq: FB - contention	5	100.0
enq: JQ - contention	1	100.0
enq: KO - fast object checkpoint	2	50.0			50.0
enq: MW - contention	1	100.0
enq: PS - contention	284	98.6	.7	.4			.4
enq: TT - contention	2	100.0
enq: WF - contention	16	100.0
gc cr block 2-way	34	100.0
gc cr block 3-way	81	100.0
gc cr block busy	1	100.0
gc cr multi block request	311	94.5	5.5
gc current block 2-way	72	100.0
gc current block 3-way	103	100.0
gc current block busy	2	100.0
gc current grant 2-way	17	100.0
gc current grant busy	45	100.0
gc current multi block request	312	100.0
gcs log flush sync	49	98.0	2.0
ges inquiry response	30	93.3		6.7
ksxr poll remote instances	911	100.0
latch: cache buffers chains	1	100.0
latch: gc element	1	100.0
latch: session allocation	4	100.0
latch: shared pool	1	100.0
library cache lock	77	100.0
library cache pin	100	100.0
library cache: mutex X	2	100.0
log file parallel write	48	97.9	2.1
os thread startup	1						100.0
rdbms ipc reply	306	99.7	.3
reliable message	146	92.5	1.4	1.4	.7			4.1
row cache lock	39	100.0
ASM background timer	15								100.0
DIAG idle wait	2885	2.6	.3	.3	.4	.9	65.2	30.3
KSV master wait	44	100.0
PING	14	78.6							21.4
PX Deq Credit: send blkd	120	99.2	.8
PX Deq: Execute Reply	105	23.8	1.9		1.9	1.9	5.7	44.8	20.0
PX Deq: Execution Msg	672	67.0	7.7	12.8	2.1	1.9	.9	7.3	.3
PX Deq: Join ACK	64	87.5	10.9	1.6
PX Deq: Msg Fragment	2	100.0
PX Deq: Parse Reply	52	80.8	3.8	3.8	5.8	1.9	3.8
PX Deq: Table Q Normal	3	100.0
PX Idle Wait	2040			2.2	1.3	.1	.3	3.6	92.5
SQL*Net message from client	45	44.4	22.2	2.2					31.1
Space Manager: slave idle wait	14								100.0
Streams AQ: RAC qmn coordinator idle wait	6	100.0
Streams AQ: qmn coordinator idle wait	6	50.0							50.0
Streams AQ: qmn slave idle wait	3								100.0
Streams AQ: waiting for messages in the queue	7							100.0
dispatcher timer	2								100.0
gcs remote message	6255	29.4	5.7	4.1	4.1	2.5	3.3	50.8
ges remote message	3383	49.0	9.6	6.4	4.6	2.5	3.9	24.0
jobq slave wait	14								100.0
pmon timer	29	17.2							82.8
rdbms ipc message	2980	43.0	1.0	2.8	3.3	2.1	1.9	33.8	12.0
shared server idle wait	3								100.0
wait for unread message on broadcast channel	146							100.0

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)
D_EIGHT	132	106	8,195	7,657
SYS$USERS	1	0	0	0
SYS$BACKGROUND	0	0	0	1
D3	0	0	0	0
DEMO	0	0	0	0
DEMOXDB	0	0	0	0
D_FOUR	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	Network Total Wts
D_EIGHT	10202	19	549	3
SYS$USERS	0	0	27	42
SYS$BACKGROUND	0	0	6	0
D3	0	0	0	0
DEMO	0	0	0	0
D_FOUR	0	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
SQL ordered by Cluster Wait Time
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
Total DB Time (s): 134
Captured SQL account for 94.3% of Total
Total DB Time (s): 134
Captured PL/SQL account for 5.0% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
124	105	1	124.43	92.76	8dkv0z9wm9881	SQL*Plus	select /* eight / /+ ...
7	1	1	6.54	4.87	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0	0	1	0.49	0.37	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	1	0.31	0.23	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
0	0	1	0.22	0.16	350myuyx0t1d6		insert into wrh$_tablespace_st...
0	0	7	0.03	0.16	7frqszzdu8sgg	racgimon@rsthpdbs102.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
0	0	1	0.16	0.12	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	1	0.12	0.09	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...
0	0	1	0.12	0.09	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
0	0	1	0.08	0.06	f318xdxdn0pdc		insert into wrh$_log (s...

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 is the CPU Time divided into the Total CPU Time times 100
Total CPU Time (s): 107
Captured SQL account for 98.7% of Total
Total CPU Time (s): 107
Captured PL/SQL account for 0.6% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
105	124	1	104.71	97.77	92.76	8dkv0z9wm9881	SQL*Plus	select /* eight / /+ ...
1	7	1	0.52	0.49	4.87	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0	0	1	0.49	0.46	0.37	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	1	0.12	0.12	0.12	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	1	0.12	0.11	0.09	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...
0	0	7	0.01	0.07	0.16	7frqszzdu8sgg	racgimon@rsthpdbs102.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
0	0	1	0.05	0.05	0.23	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
0	0	0		0.02	0.02	0v6s91manuhz8	emagent@rsthpdbs101.us.oracle.com (TNS V1-V3)	/* OracleOEM */ S...
0	0	1	0.02	0.02	0.02	7g732rx16j8jc		insert into WRH$_SERVICE_STAT ...
0	0	1	0.02	0.02	0.02	84k66tf2s7y1c		insert into wrh$_bg_event_summ...

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: 981,376
Captured SQL account for 99.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
965,226	1	965,226.00	98.35	104.71	124.43	8dkv0z9wm9881	SQL*Plus	select /* eight / /+ ...
13,733	1	13,733.00	1.40	0.52	6.54	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
7,358	1	7,358.00	0.75	0.12	0.12	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...
3,484	1	3,484.00	0.36	0.12	0.16	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
839	1	839.00	0.09	0.01	0.01	6c06mfv01xt2h		update wrh$_seg_stat_obj sso ...
581	132	4.40	0.06	0.01	0.01	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
419	1	419.00	0.04	0.01	0.01	61tn3mam0vq0b		SELECT source, (case ...
384	1	384.00	0.04	0.01	0.00	6wm3n4d7bnddg		SELECT source, (case ...
328	1	328.00	0.03	0.01	0.01	9rfkm1bf915a0		UPDATE WRH$_SEG_STAT_OBJ SET s...
253	1	253.00	0.03	0.01	0.02	5ax5xu96u2ztd		insert into WRH$_EVENT_HISTOGR...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 1,024,332
Captured SQL account for 100.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,024,324	1	1,024,324.00	100.00	104.71	124.43	8dkv0z9wm9881	SQL*Plus	select /* eight / /+ ...
3	1	3.00	0.00	0.52	6.54	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
2	1	2.00	0.00	0.12	0.16	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
1	4	0.25	0.00	0.00	0.01	fnz13xnvkybtj		INSERT INTO sys.wri$_adv_findi...
0	6	0.00	0.00	0.00	0.00	062savj8zgzut		UPDATE sys.wri$_adv_parameters...
0	0		0.00	0.02	0.02	0v6s91manuhz8	emagent@rsthpdbs101.us.oracle.com (TNS V1-V3)	/* OracleOEM */ S...
0	2	0.00	0.00	0.00	0.00	14wnf35dahb7v		SELECT A.ID, A.TYPE FROM SYS.W...
0	1	0.00	0.00	0.01	0.12	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
0	7	0.00	0.00	0.00	0.00	1jqqpfkr0m3yk		SELECT COUNT(*) FROM SYS.WRI$_...
0	0		0.00	0.01	0.01	1mjhyad05m8pf	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT value ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 811
Captured SQL account for 37.6% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
132	132	1.00	0.00	0.00	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
44	29	0.66	0.00	0.00	87gaftwrm2h68		select o.owner#, o.name, o.nam...
11	11	1.00	0.00	0.00	g4vrdfn14tp29		SELECT PROPERTY FROM SYS.WRI$_...
9	9	1.00	0.00	0.00	8x0funf899dka		INSERT INTO wri$_adv_addm_inst...
9	9	1.00	0.00	0.00	fstp7x8vrq235		UPDATE SYS.WRI$_ADV_TASKS SET ...
9	9	1.00	0.00	0.00	gpb7chr15zyrs		SELECT PROPERTY FROM SYS.WRI$_...
7	7	1.00	0.00	0.00	1jqqpfkr0m3yk		SELECT COUNT(*) FROM SYS.WRI$_...
7	7	1.00	0.01	0.03	7frqszzdu8sgg	racgimon@rsthpdbs102.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
7	7	1.00	0.00	0.00	grzx1ww6wf4q2		SELECT A.FLAGS FROM SYS.WRI$_A...
6	6	1.00	0.00	0.00	062savj8zgzut		UPDATE sys.wri$_adv_parameters...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 477
Captured SQL account for 54.5% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
58	7	12.16	7frqszzdu8sgg	racgimon@rsthpdbs102.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
37	0	7.76	fgqt3gak6vv8x	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT instance_name ...
32	0	6.71	arx2rgss6k33m	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT s.inst_id, s.name, i...
16	0	3.35	aqb79nn78dgyy	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT inst_id, service_name...
9	9	1.89	8x0funf899dka		INSERT INTO wri$_adv_addm_inst...
7	0	1.47	1mjhyad05m8pf	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT value ...
7	0	1.47	8j37z6cqf3s9h	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT value ...
6	6	1.26	062savj8zgzut		UPDATE sys.wri$_adv_parameters...
4	4	0.84	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
4	4	0.84	6uv0yw917usfy		INSERT INTO wri$_adv_addm_fdg ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
2,899,349	0	0.27	0v6s91manuhz8	emagent@rsthpdbs101.us.oracle.com (TNS V1-V3)	/* OracleOEM */ S...

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

%Ela is Cluster Wait Time as percentage of SQL Elapsed Time
%Total is Cluster Wait Time as percentage of Total Cluster Wait Time
Only SQL with Cluster Wait Time > .005 seconds is reported
Total Cluster Wait Time (s): 0
Captured Segments account for 47.6% of Total

Cluster Wait Time (s)	%Ela	%Total	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Module	SQL Text
0.08	1.19	53.47	6.54	0.52	1	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0.03	21.19	23.41	0.16	0.12	1	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.03	0.02	19.17	124.43	104.71	1	8dkv0z9wm9881	SQL*Plus	select /* eight / /+ ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

062savj8zgzut UPDATE sys.wri$_adv_parameters SET datatype = :1, value = :2, flags = :3, description = :4 WHERE task_id = :5 AND name = :6

0v6s91manuhz8 /* OracleOEM */ SELECT blocking_sid, num_blocked FROM ( SELECT blocking_sid, SUM(num_blocked) num_blocked FROM ( SELECT l.id1, l.id2, MAX(DECODE(l.block, 1, i.instance_name||'-'||l.sid, 2, i.instance_name||'-'||l.sid, 0 )) blocking_sid, SUM(DECODE(l.request, 0, 0, 1 )) num_blocked FROM gv$lock l, gv$instance i WHERE ( l.block!= 0 OR l.request > 0 ) AND l.inst_id = i.inst_id GROUP BY l.id1, l.id2) GROUP BY blocking_sid ORDER BY num_blocked DESC) WHERE num_blocked != 0 AND blocking_sid != '0'

14wnf35dahb7v SELECT A.ID, A.TYPE FROM SYS.WRI$_ADV_DEFINITIONS A WHERE A.NAME = :B1

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

1jqqpfkr0m3yk SELECT COUNT(*) FROM SYS.WRI$_ADV_PARAMETERS A WHERE A.TASK_ID = :B2 AND A.NAME = :B1

1mjhyad05m8pf SELECT value FROM gv$osstat WHERE inst_id = :p1 and stat_name='NUM_CPU_CORES'

1uk5m5qbzj1vt BEGIN dbms_workload_repository.create_snapshot; END;

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

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

5ax5xu96u2ztd insert into WRH$_EVENT_HISTOGRAM (snap_id, dbid, instance_number, event_id, wait_time_milli, wait_count) select :snap_id, :dbid, :instance_number, d.ksledhash, s.kslsesmaxdur, s.kslsesval from x$kslseshist s, x$ksled d where s.kslsesenum = d.indx and s.kslsesval > 0 order by d.ksledhash, s.kslsesmaxdur

5h7w8ykwtb2xt INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )

61tn3mam0vq0b SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMB ERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC

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

6c06mfv01xt2h update wrh$_seg_stat_obj sso set (index_type, base_obj#, base_object_name, base_object_owner) = (select decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner from sys.ind$ ind, sys.user$ base_owner, sys.obj$ base_obj where ind.obj# = sso.obj# and ind.dataobj# = sso.dataobj# and ind.bo# = base_obj.obj# and base_obj.owner# = base_owner.user#) where sso.dbid = :dbid and (obj#, dataobj#) in (select objn_kewrseg, objd_kewrseg from x$kewrtsegstat ss1 where objtype_kewrseg = 1) and sso.snap_id = :lah_snap_id and sso.object_type = 'INDEX'

6uv0yw917usfy INSERT INTO wri$_adv_addm_fdg ( TASK_ID, FINDING_ID, RULE_ID, ADDM_FDG_ID, ADDM_SEQ, DATABASE_TIME, ACTIVE_SESSIONS, PERC_ACTIVE_SESS, IS_AGGREGATE, METER_LEVEL) VALUES ( :tid, :kea_id, NULL, NULL, 0, NULL, NULL, NULL, 'N', NULL)

6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC

7frqszzdu8sgg select DECODE(UPPER(d.OPEN_MODE), 'READ WRITE', 'R', 'N') , DECODE(UPPER(i.STATUS), 'OPEN', 'O', 'N') into :b0, :b1 from v$database d , gv$instance i where i.INSTANCE_NAME=:b2

7g732rx16j8jc insert into WRH$_SERVICE_STAT (snap_id, dbid, instance_number, service_name_hash, stat_id, value) select :snap_id, :dbid, :instance_number, stat.service_name_hash, stat.stat_id, stat.value from v$active_services asvc, v$service_stats stat where asvc.name_hash = stat.service_name_hash

7qjhf5dzmazsr SELECT snap_id , OBJ#, DATAOBJ# FROM (SELECT /*+ ordered use_nl(t2) index(t2) */ t2.snap_id , t1.OBJN_KEWRSEG OBJ#, t1.OBJD_KEWRSEG DATAOBJ# FROM X$KEWRTSEGSTAT t1, WRH$_SEG_STAT_OBJ t2 WHERE t2.dbid(+) = :dbid AND t2.OBJ#(+) = t1.OBJN_KEWRSEG AND t2.DATAOBJ#(+) = t1.OBJD_KEWRSEG) WHERE nvl(snap_id, 0) < :snap_id

7vgmvmy8vvb9s insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)

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

87gaftwrm2h68 select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1

8dkv0z9wm9881 select /* eight */ /*+ parallel (t1, 16) parallel (t2, 16) */ min (t1.bsns_unit_key + t2.bsns_unit_key), max (t1.day_key + t2.day_key), avg (t1.day_key + t2.day_key), max (t1.bsns_unit_typ_cd), max (t2.curr_ind), max (t1.load_dt) from d31.dwb_rtl_trx t1, d31.dwb_rtl_trx t2 where t1.trx_nbr = t2.trx_nbr

8j37z6cqf3s9h SELECT value FROM gv$osstat WHERE inst_id = :p1 and stat_name='NUM_CPUS'

8x0funf899dka INSERT INTO wri$_adv_addm_inst ( TASK_ID, INSTANCE_NUMBER, INSTANCE_NAME, HOST_NAME, STATUS, DATABASE_TIME, ACTIVE_SESSIONS, PERC_ACTIVE_SESS, METER_LEVEL, LOCAL_TASK_ID) VALUES ( :tid, :inst_num, :inst_name, :host_name, :st, NULL, NULL, NULL, NULL, NULL)

9rfkm1bf915a0 UPDATE WRH$_SEG_STAT_OBJ SET snap_id = :lah_snap_id WHERE dbid = :dbid AND (OBJ#, DATAOBJ#) IN (SELECT NUM1_KEWRATTR, NUM2_KEWRATTR FROM X$KEWRATTRSTALE)

aqb79nn78dgyy SELECT inst_id, service_name, TO_CHAR(CAST(begin_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') time, TO_CHAR(CAST(end_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') time, intsize_csec, group_id, cpupercall, dbtimepercall, callspersec, dbtimepersec FROM gv$servicemetric_history WHERE service_name = :p1 AND end_time >= SYSDATE - 5/(60*24) AND group_id = 6 ORDER BY inst_id asc, end_time DESC

arx2rgss6k33m SELECT s.inst_id, s.name, i.instance_name FROM gv$active_services s, gv$instance i WHERE s.name = :p1 AND s.inst_id = i.inst_id

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

f318xdxdn0pdc insert into wrh$_log (snap_id, dbid, instance_number, group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time) select :snap_id, :dbid, :instance_number, group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time from v$log

fgqt3gak6vv8x SELECT instance_name FROM gv$instance WHERE inst_id = :p1

fnz13xnvkybtj INSERT INTO sys.wri$_adv_findings (id, task_id, type, parent, obj_id, impact_msg_id, impact_val, msg_id, more_info_id, name_msg_code, flags, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)

fstp7x8vrq235 UPDATE SYS.WRI$_ADV_TASKS SET MTIME = SYSDATE, STATUS = NVL(:B4 , STATUS), CLEANUP = NVL(:B3 , CLEANUP), VERSION = NVL(:B2 , VERSION) WHERE ID = :B1

g4vrdfn14tp29 SELECT PROPERTY FROM SYS.WRI$_ADV_TASKS WHERE ID = :B1

gpb7chr15zyrs SELECT PROPERTY FROM SYS.WRI$_ADV_DEFINITIONS WHERE ID = :B1

grzx1ww6wf4q2 SELECT A.FLAGS FROM SYS.WRI$_ADV_PARAMETERS A WHERE A.TASK_ID = :B2 AND A.NAME = :B1

SQL Id	SQL Text
062savj8zgzut	UPDATE sys.wri$_adv_parameters SET datatype = :1, value = :2, flags = :3, description = :4 WHERE task_id = :5 AND name = :6
0v6s91manuhz8	/* OracleOEM */ SELECT blocking_sid, num_blocked FROM ( SELECT blocking_sid, SUM(num_blocked) num_blocked FROM ( SELECT l.id1, l.id2, MAX(DECODE(l.block, 1, i.instance_name\|\|'-'\|\|l.sid, 2, i.instance_name\|\|'-'\|\|l.sid, 0 )) blocking_sid, SUM(DECODE(l.request, 0, 0, 1 )) num_blocked FROM gv$lock l, gv$instance i WHERE ( l.block!= 0 OR l.request > 0 ) AND l.inst_id = i.inst_id GROUP BY l.id1, l.id2) GROUP BY blocking_sid ORDER BY num_blocked DESC) WHERE num_blocked != 0 AND blocking_sid != '0'
14wnf35dahb7v	SELECT A.ID, A.TYPE FROM SYS.WRI$_ADV_DEFINITIONS A WHERE A.NAME = :B1
1cq3qr774cu45	insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
1jqqpfkr0m3yk	SELECT COUNT(*) FROM SYS.WRI$_ADV_PARAMETERS A WHERE A.TASK_ID = :B2 AND A.NAME = :B1
1mjhyad05m8pf	SELECT value FROM gv$osstat WHERE inst_id = :p1 and stat_name='NUM_CPU_CORES'
1uk5m5qbzj1vt	BEGIN dbms_workload_repository.create_snapshot; END;
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
3m8smr0v7v1m6	INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
5ax5xu96u2ztd	insert into WRH$_EVENT_HISTOGRAM (snap_id, dbid, instance_number, event_id, wait_time_milli, wait_count) select :snap_id, :dbid, :instance_number, d.ksledhash, s.kslsesmaxdur, s.kslsesval from x$kslseshist s, x$ksled d where s.kslsesenum = d.indx and s.kslsesval > 0 order by d.ksledhash, s.kslsesmaxdur
5h7w8ykwtb2xt	INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
61tn3mam0vq0b	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMB ERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6c06mfv01xt2h	update wrh$_seg_stat_obj sso set (index_type, base_obj#, base_object_name, base_object_owner) = (select decode(ind.type#, 1, 'NORMAL'\|\| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner from sys.ind$ ind, sys.user$ base_owner, sys.obj$ base_obj where ind.obj# = sso.obj# and ind.dataobj# = sso.dataobj# and ind.bo# = base_obj.obj# and base_obj.owner# = base_owner.user#) where sso.dbid = :dbid and (obj#, dataobj#) in (select objn_kewrseg, objd_kewrseg from x$kewrtsegstat ss1 where objtype_kewrseg = 1) and sso.snap_id = :lah_snap_id and sso.object_type = 'INDEX'
6uv0yw917usfy	INSERT INTO wri$_adv_addm_fdg ( TASK_ID, FINDING_ID, RULE_ID, ADDM_FDG_ID, ADDM_SEQ, DATABASE_TIME, ACTIVE_SESSIONS, PERC_ACTIVE_SESS, IS_AGGREGATE, METER_LEVEL) VALUES ( :tid, :kea_id, NULL, NULL, 0, NULL, NULL, NULL, 'N', NULL)
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC
7frqszzdu8sgg	select DECODE(UPPER(d.OPEN_MODE), 'READ WRITE', 'R', 'N') , DECODE(UPPER(i.STATUS), 'OPEN', 'O', 'N') into :b0, :b1 from v$database d , gv$instance i where i.INSTANCE_NAME=:b2
7g732rx16j8jc	insert into WRH$_SERVICE_STAT (snap_id, dbid, instance_number, service_name_hash, stat_id, value) select :snap_id, :dbid, :instance_number, stat.service_name_hash, stat.stat_id, stat.value from v$active_services asvc, v$service_stats stat where asvc.name_hash = stat.service_name_hash
7qjhf5dzmazsr	SELECT snap_id , OBJ#, DATAOBJ# FROM (SELECT /+ ordered use_nl(t2) index(t2) / t2.snap_id , t1.OBJN_KEWRSEG OBJ#, t1.OBJD_KEWRSEG DATAOBJ# FROM X$KEWRTSEGSTAT t1, WRH$_SEG_STAT_OBJ t2 WHERE t2.dbid(+) = :dbid AND t2.OBJ#(+) = t1.OBJN_KEWRSEG AND t2.DATAOBJ#(+) = t1.OBJD_KEWRSEG) WHERE nvl(snap_id, 0) < :snap_id
7vgmvmy8vvb9s	insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)
84k66tf2s7y1c	insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id
87gaftwrm2h68	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
8dkv0z9wm9881	select /* eight / /+ parallel (t1, 16) parallel (t2, 16) */ min (t1.bsns_unit_key + t2.bsns_unit_key), max (t1.day_key + t2.day_key), avg (t1.day_key + t2.day_key), max (t1.bsns_unit_typ_cd), max (t2.curr_ind), max (t1.load_dt) from d31.dwb_rtl_trx t1, d31.dwb_rtl_trx t2 where t1.trx_nbr = t2.trx_nbr
8j37z6cqf3s9h	SELECT value FROM gv$osstat WHERE inst_id = :p1 and stat_name='NUM_CPUS'
8x0funf899dka	INSERT INTO wri$_adv_addm_inst ( TASK_ID, INSTANCE_NUMBER, INSTANCE_NAME, HOST_NAME, STATUS, DATABASE_TIME, ACTIVE_SESSIONS, PERC_ACTIVE_SESS, METER_LEVEL, LOCAL_TASK_ID) VALUES ( :tid, :inst_num, :inst_name, :host_name, :st, NULL, NULL, NULL, NULL, NULL)
9rfkm1bf915a0	UPDATE WRH$_SEG_STAT_OBJ SET snap_id = :lah_snap_id WHERE dbid = :dbid AND (OBJ#, DATAOBJ#) IN (SELECT NUM1_KEWRATTR, NUM2_KEWRATTR FROM X$KEWRATTRSTALE)
aqb79nn78dgyy	SELECT inst_id, service_name, TO_CHAR(CAST(begin_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') time, TO_CHAR(CAST(end_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') time, intsize_csec, group_id, cpupercall, dbtimepercall, callspersec, dbtimepersec FROM gv$servicemetric_history WHERE service_name = :p1 AND end_time >= SYSDATE - 5/(60*24) AND group_id = 6 ORDER BY inst_id asc, end_time DESC
arx2rgss6k33m	SELECT s.inst_id, s.name, i.instance_name FROM gv$active_services s, gv$instance i WHERE s.name = :p1 AND s.inst_id = i.inst_id
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
f318xdxdn0pdc	insert into wrh$_log (snap_id, dbid, instance_number, group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time) select :snap_id, :dbid, :instance_number, group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time from v$log
fgqt3gak6vv8x	SELECT instance_name FROM gv$instance WHERE inst_id = :p1
fnz13xnvkybtj	INSERT INTO sys.wri$_adv_findings (id, task_id, type, parent, obj_id, impact_msg_id, impact_val, msg_id, more_info_id, name_msg_code, flags, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
fstp7x8vrq235	UPDATE SYS.WRI$_ADV_TASKS SET MTIME = SYSDATE, STATUS = NVL(:B4 , STATUS), CLEANUP = NVL(:B3 , CLEANUP), VERSION = NVL(:B2 , VERSION) WHERE ID = :B1
g4vrdfn14tp29	SELECT PROPERTY FROM SYS.WRI$_ADV_TASKS WHERE ID = :B1
gpb7chr15zyrs	SELECT PROPERTY FROM SYS.WRI$_ADV_DEFINITIONS WHERE ID = :B1
grzx1ww6wf4q2	SELECT A.FLAGS FROM SYS.WRI$_ADV_PARAMETERS A WHERE A.TASK_ID = :B2 AND A.NAME = :B1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	2	0.03	0.05
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	13	0.18	0.30
Batched IO buffer defrag count	1	0.01	0.02
Batched IO double miss count	3	0.04	0.07
Batched IO same unit count	7	0.10	0.16
Batched IO single block count	2	0.03	0.05
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	4	0.06	0.09
Batched IO vector read count	1	0.01	0.02
Block Cleanout Optim referenced	28	0.39	0.65
CCursor + sql area evicted	2	0.03	0.05
CPU used by this session	10,643	146.86	247.51
CPU used when call started	93,571	1,291.19	2,176.07
CR blocks created	3	0.04	0.07
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	21	0.29	0.49
DB time	23,902	329.82	555.86
DBWR checkpoint buffers written	32	0.44	0.74
DBWR checkpoints	1	0.01	0.02
DBWR fusion writes	3	0.04	0.07
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	11	0.15	0.26
DBWR undo block writes	12	0.17	0.28
DFO trees parallelized	8	0.11	0.19
DML statements parallelized	0	0.00	0.00
HSC Heap Segment Block Changes	331	4.57	7.70
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	99	1.37	2.30
Heap Segment Array Updates	7	0.10	0.16
PX local messages recv'd	72	0.99	1.67
PX local messages sent	72	0.99	1.67
PX remote messages recv'd	504	6.95	11.72
PX remote messages sent	616	8.50	14.33
Parallel operations not downgraded	8	0.11	0.19
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	45	0.62	1.05
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	87	1.20	2.02
application wait time	1	0.01	0.02
background timeouts	448	6.18	10.42
branch node splits	0	0.00	0.00
buffer is not pinned count	3,102	42.80	72.14
buffer is pinned count	10,788	148.86	250.88
bytes received via SQL*Net from client	46,210	637.65	1,074.65
bytes sent via SQL*Net to client	14,481	199.82	336.77
calls to get snapshot scn: kcmgss	13,300	183.53	309.30
calls to kcmgas	520	7.18	12.09
calls to kcmgcs	66	0.91	1.53
cell blocks helped by minscn optimization	954,977	13,177.73	22,208.77
cell blocks processed by cache layer	954,977	13,177.73	22,208.77
cell blocks processed by data layer	954,977	13,177.73	22,208.77
cell blocks processed by txn layer	954,977	13,177.73	22,208.77
cell physical IO bytes eligible for predicate offload	7,805,517,824	107,708,369.43	181,523,670.33
cell physical IO bytes saved during optimized file creation	0	0.00	0.00
cell physical IO interconnect bytes	5,921,507,272	81,710,900.83	137,709,471.44
cell scans	496	6.84	11.53
change write time	1	0.01	0.02
cleanout - number of ktugct calls	82	1.13	1.91
cleanouts and rollbacks - consistent read gets	3	0.04	0.07
cleanouts only - consistent read gets	3	0.04	0.07
cluster key scan block gets	76	1.05	1.77
cluster key scans	69	0.95	1.60
cluster wait time	14	0.19	0.33
commit batch/immediate performed	2	0.03	0.05
commit batch/immediate requested	2	0.03	0.05
commit cleanout failures: block lost	16	0.22	0.37
commit cleanout failures: callback failure	4	0.06	0.09
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	409	5.64	9.51
commit cleanouts successfully completed	389	5.37	9.05
commit immediate performed	2	0.03	0.05
commit immediate requested	2	0.03	0.05
commit txn count during cleanout	103	1.42	2.40
concurrency wait time	8	0.11	0.19
consistent changes	18	0.25	0.42
consistent gets	978,518	13,502.57	22,756.23
consistent gets - examination	1,692	23.35	39.35
consistent gets direct	952,822	13,147.99	22,158.65
consistent gets from cache	25,696	354.58	597.58
consistent gets from cache (fastpath)	23,727	327.41	551.79
current blocks converted for CR	0	0.00	0.00
cursor authentications	52	0.72	1.21
data blocks consistent reads - undo records applied	3	0.04	0.07
db block changes	2,713	37.44	63.09
db block gets	2,858	39.44	66.47
db block gets direct	0	0.00	0.00
db block gets from cache	2,858	39.44	66.47
db block gets from cache (fastpath)	749	10.34	17.42
deferred (CURRENT) block cleanout applications	179	2.47	4.16
enqueue conversions	169	2.33	3.93
enqueue releases	2,621	36.17	60.95
enqueue requests	2,653	36.61	61.70
enqueue timeouts	32	0.44	0.74
enqueue waits	339	4.68	7.88
exchange deadlocks	0	0.00	0.00
execute count	811	11.19	18.86
free buffer inspected	0	0.00	0.00
free buffer requested	3,680	50.78	85.58
gc CPU used by this session	30	0.41	0.70
gc blocks lost	0	0.00	0.00
gc cr block build time	0	0.00	0.00
gc cr block flush time	0	0.00	0.00
gc cr block receive time	3	0.04	0.07
gc cr block send time	0	0.00	0.00
gc cr blocks received	175	2.41	4.07
gc cr blocks served	157	2.17	3.65
gc current block flush time	0	0.00	0.00
gc current block pin time	0	0.00	0.00
gc current block receive time	214	2.95	4.98
gc current block send time	1	0.01	0.02
gc current blocks received	1,874	25.86	43.58
gc current blocks served	533	7.35	12.40
gc local grants	116	1.60	2.70
gc reader bypass grants	23	0.32	0.53
gc remote grants	137	1.89	3.19
gcs messages sent	5,781	79.77	134.44
ges messages sent	2,966	40.93	68.98
global enqueue get time	42	0.58	0.98
global enqueue gets async	50	0.69	1.16
global enqueue gets sync	3,051	42.10	70.95
global enqueue releases	2,865	39.53	66.63
heap block compress	8	0.11	0.19
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	6	0.08	0.14
immediate (CURRENT) block cleanout applications	131	1.81	3.05
index crx upgrade (positioned)	14	0.19	0.33
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fetch by key	711	9.81	16.53
index scans kdiixs1	4,553	62.83	105.88
leaf node 90-10 splits	14	0.19	0.33
leaf node splits	38	0.52	0.88
lob reads	0	0.00	0.00
lob writes	2	0.03	0.05
lob writes unaligned	2	0.03	0.05
logons cumulative	164	2.26	3.81
messages received	440	6.07	10.23
messages sent	440	6.07	10.23
min active SCN optimization applied to CR	0	0.00	0.00
no work - consistent read gets	11,168	154.11	259.72
opened cursors cumulative	804	11.09	18.70
parse count (describe)	1	0.01	0.02
parse count (failures)	0	0.00	0.00
parse count (hard)	55	0.76	1.28
parse count (total)	477	6.58	11.09
parse time cpu	3	0.04	0.07
parse time elapsed	4	0.06	0.09
physical IO disk bytes	9,590,014,976	132,332,652.25	223,023,604.09
physical read IO requests	12,426	171.47	288.98
physical read bytes	8,391,327,744	115,791,962.69	195,147,156.84
physical read total IO requests	13,720	189.32	319.07
physical read total bytes	8,412,356,608	116,082,140.06	195,636,200.19
physical read total multi block requests	12,313	169.91	286.35
physical reads	1,024,332	14,134.76	23,821.67
physical reads cache	24	0.33	0.56
physical reads cache prefetch	1	0.01	0.02
physical reads direct	1,024,308	14,134.43	23,821.12
physical reads direct temporary tablespace	71,486	986.44	1,662.47
physical reads prefetch warmup	1	0.01	0.02
physical write IO requests	2,335	32.22	54.30
physical write bytes	585,883,648	8,084,610.63	13,625,201.12
physical write total IO requests	2,455	33.88	57.09
physical write total bytes	588,239,360	8,117,117.11	13,679,985.12
physical write total multi block requests	2,307	31.83	53.65
physical writes	71,519	986.89	1,663.23
physical writes direct	71,486	986.44	1,662.47
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	71,486	986.44	1,662.47
physical writes from cache	33	0.46	0.77
physical writes non checkpoint	71,497	986.59	1,662.72
pinned buffers inspected	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	0	0.00	0.00
queries parallelized	8	0.11	0.19
recovery blocks read	0	0.00	0.00
recursive calls	5,303	73.18	123.33
recursive cpu usage	10,593	146.17	246.35
redo blocks checksummed by FG (exclusive)	1,618	22.33	37.63
redo blocks written	2,297	31.70	53.42
redo entries	1,513	20.88	35.19
redo ordering marks	92	1.27	2.14
redo size	1,506,676	20,790.63	35,038.98
redo size for direct writes	0	0.00	0.00
redo subscn max counts	65	0.90	1.51
redo synch time	0	0.00	0.00
redo synch writes	2	0.03	0.05
redo wastage	10,668	147.21	248.09
redo write broadcast ack time	0	0.00	0.00
redo write time	1	0.01	0.02
redo writer latching time	0	0.00	0.00
redo writes	48	0.66	1.12
rollback changes - undo records applied	4	0.06	0.09
rollbacks only - consistent read gets	0	0.00	0.00
rows fetched via callback	461	6.36	10.72
session connect time	0	0.00	0.00
session cursor cache hits	331	4.57	7.70
session logical reads	981,376	13,542.01	22,822.70
shared hash latch upgrades - no wait	132	1.82	3.07
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	4,325	59.68	100.58
sorts (rows)	11,591	159.94	269.56
sql area evicted	23	0.32	0.53
sql area purged	0	0.00	0.00
switch current to new buffer	4	0.06	0.09
table fetch by rowid	6,357	87.72	147.84
table fetch continued row	3	0.04	0.07
table scan blocks gotten	953,729	13,160.51	22,179.74
table scan rows gotten	117,075,626	1,615,527.00	2,722,688.98
table scans (direct read)	496	6.84	11.53
table scans (long tables)	496	6.84	11.53
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	41	0.57	0.95
total number of times SMON posted	0	0.00	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	2	0.03	0.05
undo change vector size	553,536	7,638.25	12,872.93
user I/O wait time	1,934	26.69	44.98
user calls	865	11.94	20.12
user commits	22	0.30	0.51
user rollbacks	21	0.29	0.49
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	4,317	59.57	100.40
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session uga memory max	1,597,916,939,104	1,599,296,173,328
session pga memory	1,066,260,389,592	1,066,630,146,032
session pga memory max	5,885,848,971,416	5,889,243,886,672
session cursor cache count	391,718	391,831
session uga memory	1,380,919,399,264	1,380,927,023,736
opened cursors current	58	59
workarea memory allocated	354	354
logons current	43	43

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s
TEMP	2,306	32	0.85	31.00	2,306	32
UNDOTBS3	0	0	0.00	0.00	19	0
SYSAUX	7	0	8.57	1.14	10	0
D31	16	0	3.13	1.00	0	0

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Av Buf Wt(ms)
D31	+DGA/demo/datafile/d31.445.688376261	16	0	3.13	1.00	0	0	0.00
SYSAUX	+DGA/demo/datafile/sysaux.417.686904815	7	0	8.57	1.14	10	0	0.00
TEMP	+DGA/demo/tempfile/temp.419.686904819	2,306	32	0.85	31.00	2,306	32
UNDOTBS3	+DGA/demo/datafile/undotbs3.421.686904825	0	0			19	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	585,893	100	28,470	24	33	0	0	0

Advisory Statistics

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

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	0	239	1223	20652	1887390	20652
E	0	0	827	3387	20253	1887390	20253

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 for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	448	0.09	53,263	1.18	47,925
D	896	0.18	106,526	1.17	47,819
D	1,344	0.27	159,789	1.16	47,409
D	1,792	0.36	213,052	1.08	44,113
D	2,240	0.45	266,315	1.00	40,775
D	2,688	0.55	319,578	1.00	40,754
D	3,136	0.64	372,841	1.00	40,746
D	3,584	0.73	426,104	1.00	40,746
D	4,032	0.82	479,367	1.00	40,746
D	4,480	0.91	532,630	1.00	40,746
D	4,928	1.00	585,893	1.00	40,746
D	5,376	1.09	639,156	1.00	40,746
D	5,824	1.18	692,419	1.00	40,746
D	6,272	1.27	745,682	1.00	40,746
D	6,720	1.36	798,945	1.00	40,746
D	7,168	1.45	852,208	1.00	40,746
D	7,616	1.55	905,471	1.00	40,746
D	8,064	1.64	958,734	1.00	40,746
D	8,512	1.73	1,011,997	1.00	40,746
D	8,960	1.82	1,065,260	0.98	39,908

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	4,617	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	12,288	10,878	386.99	0.35	0.09	100.00	0.00	1,048,576
E	12,288	10,843	388.35	0.35	0.09	100.00	0.00	1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	4,276	4,276
64K	128K	4	4
512K	1024K	23	23
1M	2M	4	4
256M	512M	10	10

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
1,536	0.13	709,156.74	785,996.51	47.00	36	300,698,909
3,072	0.25	709,156.74	8,959.31	99.00	0	144,424,469
6,144	0.50	709,156.74	0.00	100.00	0	142,622,609
9,216	0.75	709,156.74	0.00	100.00	0	142,622,609
12,288	1.00	709,156.74	0.00	100.00	0	142,622,609
14,746	1.20	709,156.74	0.00	100.00	0	142,622,609
17,203	1.40	709,156.74	0.00	100.00	0	142,622,609
19,661	1.60	709,156.74	0.00	100.00	0	142,622,609
22,118	1.80	709,156.74	0.00	100.00	0	142,622,609
24,576	2.00	709,156.74	0.00	100.00	0	142,622,609
36,864	3.00	709,156.74	0.00	100.00	0	142,622,609
49,152	4.00	709,156.74	0.00	100.00	0	142,622,609
73,728	6.00	709,156.74	0.00	100.00	0	142,622,609
98,304	8.00	709,156.74	0.00	100.00	0	142,622,609

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)
896	0.88	0	33	10,633	1.00	698	1.00	17
1,024	1.00	130	5,229	10,633	1.00	698	1.00	2,645
1,152	1.13	195	9,434	10,643	1.00	688	0.99	2,646
1,280	1.25	195	9,434	10,643	1.00	688	0.99	2,646
1,408	1.38	195	9,434	10,643	1.00	688	0.99	2,646
1,536	1.50	195	9,434	10,643	1.00	688	0.99	2,646
1,664	1.63	195	9,434	10,643	1.00	688	0.99	2,646
1,792	1.75	195	9,434	10,643	1.00	688	0.99	2,646
1,920	1.88	195	9,434	10,643	1.00	688	0.99	2,646
2,048	2.00	195	9,434	10,643	1.00	688	0.99	2,646

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,536	0.25	242,247	47,925
2,304	0.38	242,247	47,820
3,072	0.50	242,198	44,112
3,840	0.63	242,174	40,775
4,608	0.75	242,174	40,746
5,376	0.88	242,174	40,746
6,144	1.00	242,174	40,746
6,912	1.13	242,174	40,746
7,680	1.25	242,174	40,746
8,448	1.38	242,174	40,746
9,216	1.50	242,174	40,746
9,984	1.63	242,174	39,907
10,752	1.75	242,174	39,907
11,520	1.88	242,174	39,907
12,288	2.00	242,174	39,907

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

No data exists for this section of the report.

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	Av Wt Time(ms)
PS-PX Process Reservation	386	379	7	283	0.32
KO-Multiple Object Checkpoint (fast object checkpoint)	9	9	0	2	5.00
CO-KTUCLO Master Slave enq (master slave det)	24	0	24	24	0.00
WF-AWR Flush	20	20	0	16	0.00
FB-Format Block	5	5	0	4	0.00
CF-Controlfile Transaction	154	154	0	3	0.00
TT-Tablespace	703	703	0	2	0.00
AF-Advisor Framework (task serialization)	13	13	0	1	0.00
DR-Distributed Recovery	1	1	0	1	0.00
JQ-Job Queue	1	0	1	1	0.00
MW-MWIN Schedule	1	1	0	1	0.00
US-Undo Segment	1	1	0	1	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
ASM db client latch	129	0.00		0
ASM map operation freelist	1	0.00		0
ASM map operation hash table	37,457	0.00		0
ASM network background latch	30	0.00		0
AWR Alerted Metric Element list	408	0.00		0
Change Notification Hash table latch	24	0.00		0
Consistent RBA	51	0.00		0
DML lock allocation	60,630	0.00		0
Event Group Locks	2	0.00		0
FOB s.o list latch	17	0.00		0
File State Object Pool Parent Latch	1	0.00		0
IPC stats buffer allocation latch	366	0.00		382	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	1	0.00		0
JS broadcast add buf latch	17	0.00		0
JS broadcast drop buf latch	17	0.00		0
JS broadcast load blnc latch	15	0.00		0
JS queue access latch	1	0.00		0
JS queue state obj latch	810	0.00		0
JS slv state obj latch	4	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KFK SGA Libload latch	924	0.00		0
KFMD SGA	90	0.00		0
KFR redo allocation latch	1	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	1,402	0.00		558	0.00
KJCT flow control latch	11,207	0.00		0
KMG MMAN ready and startup request latch	24	0.00		0
KSXR large replies	8	0.00		0
KTF sga latch	0			23	0.00
KWQMN job cache list latch	6	0.00		0
Locator state objects pool parent latch	1	0.00		0
MQL Tracking Latch	0			2	0.00
Memory Management Latch	1	0.00		24	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	1,178	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	10	0.00		0
OS process allocation	30	0.00		0
OS process: request allocation	2	0.00		0
PL/SQL warning settings	168	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	123	0.00		0
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	1	0.00		24	0.00
SQL memory manager workarea list latch	1,782	0.00		0
Shared B-Tree	4	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	4,003	0.00		0
active service list	9,043	0.00		29	0.00
archive control	7	0.00		0
buffer pool	1	0.00		0
business card	17	0.00		0
cache buffer handles	144	0.00		0
cache buffers chains	67,354	0.00	1.00	8,782	0.01
cache buffers lru chain	4,775	0.00		6,281	0.00
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	5	0.00		0
channel operations parent latch	82,290	0.00	0.00	0
checkpoint queue latch	2,770	0.00		611	0.00
client/application info	922	0.00		0
commit callback allocation	1	0.00		0
compile environment latch	164	0.00		0
corrupted undo seg lock	21	0.00		0
cp cmon/server latch	1	0.00		0
cp pool latch	1	0.00		0
cp server hash latch	1	0.00		0
cp sga latch	2	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	2	0.00		0
dml lock allocation	2	0.00		0
done queue latch	1	0.00		0
dummy allocation	329	0.00		0
enqueue hash chains	8,095	0.00		1	0.00
enqueues	4,430	0.00		0
error message lists	152	0.66	0.00	0
fifth spare latch	1	0.00		0
file cache latch	127	0.00		0
flashback copy	1	0.00		0
gc element	9,146	0.01	1.00	2	0.00
gcs commit scn state	1	0.00		0
gcs opaque info freelist	1,214	0.00		0
gcs partitioned table hash	211,076	0.00		81	0.00
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	6	0.00		0
gcs remastering latch	35	0.00		0
gcs resource freelist	22	0.00		6	0.00
gcs resource hash	9,164	0.00		0
gcs resource scan list	1	0.00		0
gcs shadows freelist	745	0.00		919	0.00
ges caches resource lists	3,062	0.00		1,642	0.00
ges deadlock list	940	0.00		0
ges domain table	5,998	0.00		0
ges enqueue table freelist	7,005	0.00		0
ges group table	8,981	0.00		0
ges process hash list	10,057	0.00		0
ges process parent latch	14,372	0.00		0
ges process table freelist	2	0.00		0
ges resource hash list	14,898	0.09	0.00	739	0.00
ges resource scan list	5	0.00		0
ges resource table freelist	1,433	0.00		0
ges timeout list	198	0.00		48	0.00
ges value block free list	1	0.00		0
global tx hash mapping	1	0.00		0
granule operation	1	0.00		0
hash table column usage latch	0			1,835	0.00
hash table modification latch	1	0.00		0
heartbeat check	1	0.00		15	0.00
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	1	0.00		2	0.00
job_queue_processes parameter latch	17	0.00		0
k2q global data latch	48	0.00		0
k2q lock allocation	1	0.00		0
kcfis stats shared latch	2	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kks stats	136	0.00		0
kokc descriptor allocation latch	58	0.00		0
ksfv messages	1	0.00		0
ksim membership request latch	656	0.00		73	0.00
kss move lock	1	0.00		0
ksuosstats global area	50	0.00		0
ksv allocation latch	2	0.00		0
ksv class latch	85	0.00		0
ksv msg queue latch	1	0.00		0
ksxp shared latch	2	0.00		0
ksz_so allocation latch	3	0.00		0
ktm global data	2	0.00		0
kwqbsn:qsga	3	0.00		0
lgwr LWN SCN	71	0.00		0
list of block allocation	20	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	1	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	1	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	1,604	0.00		0
messages	7,562	0.00		0
mostly latch-free SCN	71	0.00		0
msg queue latch	1	0.00		0
multiblock read objects	714	0.00		0
name-service memory objects	378	0.00		0
name-service namespace bucket	734	0.00		0
name-service pending queue	44	0.00		0
name-service request queue	975	0.00		0
ncodef allocation latch	2	0.00		0
object queue header heap	1,689	0.00		85	0.00
object queue header operation	182,858	0.00	0.00	0
object stats modification	2,086	0.00		0
parallel query alloc buffer	1,745	0.06	0.00	0
parallel query stats	188	0.00		0
parameter list	26	0.00		0
parameter table management	328	0.00		0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
post/wait queue	80	0.00		51	0.00
process allocation	325	0.00		1	0.00
process group creation	2	0.00		0
process queue	722	0.00		0
process queue reference	24,056	0.00		1,473	0.00
qmn task queue latch	12	0.00		0
query server freelists	495	0.00		0
queued dump request	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	194	0.00		1,467	0.00
redo copy	1	0.00		1,467	0.00
redo writing	234	0.00		0
reid allocation latch	1	0.00		0
resmgr group change latch	220	0.00		0
resmgr:active threads	343	0.00		0
resmgr:actses change group	164	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	328	0.00		0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	55	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	25,622	0.00		1	0.00
second spare latch	1	0.00		0
sequence cache	31	0.00		0
session allocation	5,763	0.12	0.57	0
session idle bit	1,757	0.00		0
session queue latch	1	0.00		0
session state list latch	328	0.00		0
session switching	3	0.00		0
session timer	29	0.00		0
shared pool	18,722	0.03	0.20	0
shared pool sim alloc	2	0.00		0
shared pool simulator	407	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	1,161	0.00		0
simulator lru latch	1	0.00		1,128	0.00
sort extent pool	731	0.00		0
space background task latch	54	0.00		48	0.00
state object free list	2	0.00		0
statistics aggregation	1,568	0.00		0
storage server table manipulation latch	9	0.00		0
tablespace key chain	638	0.00		0
temp lob duration state obj allocation	1	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
third spare latch	1	0.00		0
threshold alerts latch	2	0.00		0
transaction allocation	14,935	0.00		0
undo global data	580	0.00		0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
session allocation	5,763	7	4	3
shared pool	18,722	5	1	4
cache buffers chains	67,354	1	1	0
gc element	9,146	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
cache buffers chains	kcbchg1: kslbegin: call CR func	1	0
gc element	kclchkping	1	0
object queue header operation	kcbo_link_q	1	0
session allocation	ksuxds: KSUSFCLC not set	4	0
shared pool	kghalo	1	1

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Library Cache	kglhdgn2 106	1	0
Library Cache	kgllkck1 89	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits
Segments by Global Cache Buffer Busy
Segments by CR Blocks Received
Segments by Current Blocks Received

Segments by Logical Reads

Total Logical Reads: 981,376
Captured Segments account for 19.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
D31	D31	DWB_RTL_TRX	90527_H007	TABLE SUBPARTITION	7,920	0.81
D31	D31	DWB_RTL_TRX	90529_H049	TABLE SUBPARTITION	7,904	0.81
SYS	SYSAUX	WRH$_SEG_STAT_OBJ_PK		INDEX	7,376	0.75
D31	D31	DWB_RTL_TRX	90525_H034	TABLE SUBPARTITION	7,008	0.71
D31	D31	DWB_RTL_TRX	90501_H049	TABLE SUBPARTITION	6,432	0.66

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 1,024,332
Captured Segments account for 10.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
D31	D31	DWB_RTL_TRX	90510_H049	TABLE SUBPARTITION	3,890	0.38
D31	D31	DWB_RTL_TRX	90531_H034	TABLE SUBPARTITION	3,876	0.38
D31	D31	DWB_RTL_TRX	90516_H044	TABLE SUBPARTITION	3,858	0.38
D31	D31	DWB_RTL_TRX	90504_H049	TABLE SUBPARTITION	3,856	0.38
D31	D31	DWB_RTL_TRX	90502_H061	TABLE SUBPARTITION	3,852	0.38

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 1,024,308
Captured Segments account for 10.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
D31	D31	DWB_RTL_TRX	90510_H049	TABLE SUBPARTITION	3,890	0.38
D31	D31	DWB_RTL_TRX	90531_H034	TABLE SUBPARTITION	3,876	0.38
D31	D31	DWB_RTL_TRX	90516_H044	TABLE SUBPARTITION	3,858	0.38
D31	D31	DWB_RTL_TRX	90504_H049	TABLE SUBPARTITION	3,856	0.38
D31	D31	DWB_RTL_TRX	90502_H061	TABLE SUBPARTITION	3,852	0.38

Back to Segment Statistics
Back to Top

Segments by Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 496
Captured Segments account for 11.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
D31	D31	DWB_RTL_TRX	90501_H049	TABLE SUBPARTITION	2	0.40
D31	D31	DWB_RTL_TRX	90502_H061	TABLE SUBPARTITION	2	0.40
D31	D31	DWB_RTL_TRX	90503_H007	TABLE SUBPARTITION	2	0.40
D31	D31	DWB_RTL_TRX	90503_H061	TABLE SUBPARTITION	2	0.40
D31	D31	DWB_RTL_TRX	90504_H007	TABLE SUBPARTITION	2	0.40

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	75138_1021	INDEX PARTITION	176	18.64
SYS	SYSAUX	WRI$_ADV_PARAMETERS		TABLE	144	15.25
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	75138_1021	INDEX PARTITION	96	10.17
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM	75138_1021	TABLE PARTITION	48	5.08
SYS	SYSAUX	SYS_C001765		INDEX	32	3.39

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

No data exists for this section of the report.

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

Total CR Blocks Received: 175
Captured Segments account for 84.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSAUX	WRM$_DATABASE_INSTANCE		TABLE	24	13.71
SYS	SYSAUX	WRH$_SYS_TIME_MODEL	75138_1021	TABLE PARTITION	13	7.43
SYS	SYSAUX	WRM$_SNAPSHOT		TABLE	10	5.71
SYS	SYSAUX	WRI$_ADV_ADDM_FDG		TABLE	8	4.57
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	7	4.00

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 1,874
Captured Segments account for 12.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	75138_1021	INDEX PARTITION	61	3.26
SYS	SYSAUX	WRH$_MUTEX_SLEEP_PK		INDEX	12	0.64
SYS	SYSAUX	WRM$_SNAPSHOT		TABLE	12	0.64
SYS	SYSAUX	SYS_C001765		INDEX	10	0.53
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	75138_1021	INDEX PARTITION	9	0.48

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Dictionary Cache Stats
Dictionary Cache Stats (RAC)

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	6	0.00	2	1
dc_database_links	1	0.00	0	1
dc_global_oids	41	0.00	0	170
dc_histogram_data	859	1.51	0	5,301
dc_histogram_defs	1,631	0.49	0	4,421
dc_object_grants	16	0.00	0	95
dc_objects	815	6.38	0	1,438
dc_rollback_segments	63	0.00	0	1,055
dc_segments	193	0.52	0	3,396
dc_sequences	2	50.00	2	1
dc_tablespaces	4,549	0.00	0	50
dc_users	430	0.00	0	155
global database name	69	0.00	0	1
outstanding_alerts	6	0.00	0	7

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts	GES Releases
dc_awr_control	4	0	0
dc_histogram_defs	8	0	0
dc_objects	37	0	1
dc_segments	1	1	0
dc_sequences	4	0	0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Library Cache Activity
Library Cache Activity (RAC)

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	7	0.00	9	0.00	0
CLUSTER	2	0.00	1	0.00	0
INDEX	20	0.00	17	0.00	0
SQL AREA	313	2.56	1,768	7.64	9
TABLE/PROCEDURE	407	0.00	1,022	2.64	12

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace	GES Lock Requests	GES Pin Requests
CLUSTER	1	1
INDEX	17	17
TABLE/PROCEDURE	611	668

Back to Library Cache Statistics
Back to Top

Memory Statistics

Memory Dynamic Components
Memory Resize Operations Summary
Memory Resize Ops
Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Memory Dynamic Components

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

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	4,928.00	4,928.00	4,544.00	4,928.00	GRO/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	12,288.00	12,288.00	12,288.00	12,288.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	6,144.00	6,144.00	6,144.00	6,144.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	64.00	64.00	64.00	64.00	STA/
large pool	64.00	64.00	64.00	448.00	SHR/DEF
shared pool	1,024.00	1,024.00	1,024.00	1,024.00	STA/
streams pool	0.00	0.00	0.00	0.00	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	347.35		3.10	5.80	31	160	112	111
	Freeable	24.75	0.00	1.08	1.26	6		23	23
	PL/SQL	18.69	2.14	0.37	2.12	15	15	51	47
	SQL	9.85	7.37	0.38	1.65	8	638	26	16
E	Other	347.88		3.11	5.82	32	160	112	111
	Freeable	25.63	0.00	1.11	1.29	6		23	23
	PL/SQL	18.69	2.14	0.37	2.12	15	15	51	47
	SQL	9.75	7.34	0.37	1.65	8	638	26	16

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	5,167,382,528
Fixed Size	2,160,112
Redo Buffers	36,175,872
Variable Size	1,207,962,128

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	64.00	64.00	0.00
large	PX msg pool	54.00	54.00	0.00
large	free memory	9.63	9.63	0.00
shared	ASH buffers	15.50	15.50	0.00
shared	CCursor	17.22	17.42	1.13
shared	FileOpenBlock	11.21	11.21	0.00
shared	KCL name table	48.00	48.00	0.00
shared	PL/SQL DIANA	18.18	18.20	0.13
shared	PL/SQL MPCODE	12.22	12.22	0.00
shared	db_block_hash_buckets	44.50	44.50	0.00
shared	event statistics per sess	12.32	12.32	0.00
shared	free memory	299.10	298.37	-0.24
shared	gcs resources	97.36	97.36	0.00
shared	gcs shadows	64.90	64.90	0.00
shared	ges big msg buffers	22.03	22.03	0.00
shared	ges enqueues	22.19	22.19	0.00
shared	sessions	11.96	11.96	0.00
shared	sql area	113.85	113.88	0.03
shared	write state object	14.95	14.95	0.00
	buffer_cache	4,928.00	4,928.00	0.00
	fixed_sga	2.06	2.06	0.00
	log_buffer	34.50	34.50	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Apply
Buffered Queues
Buffered Subscribers
Rule Set
Persistent Queues
Persistent Subscribers

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent 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.

init.ora Parameters

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

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u01/app/oracle/admin/DEMO/adump
audit_trail	DB
cluster_database	TRUE
cluster_database_instances	8
compatible	11.1.0.7
control_files	+DGA/demo/control01.ctl, +DGA/demo/control02.ctl, +DGA/demo/control03.ctl
db_block_size	8192
db_domain
db_name	DEMO
diagnostic_dest	/u01/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=DEMOXDB)
event	27401 trace name context forever, level 16384
instance_number	3
local_listener	LISTENER_DEMO3
open_cursors	300
parallel_adaptive_multi_user	FALSE
parallel_execution_message_size	16384
parallel_max_servers	128
parallel_min_servers	64
pga_aggregate_target	12884901888
processes	1024
recyclebin	OFF
remote_listener	LISTENERS_DEMO
remote_login_passwordfile	EXCLUSIVE
resource_manager_plan
service_names	D_EIGHT, D_FOUR, D3, DEMO
sessions	1131
sga_target	6442450944
spfile	+DGA/demo/spfiledemo.ora
thread	3
undo_tablespace	UNDOTBS3

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	520	7.18	12.09
acks for commit broadcast(logical)	521	7.19	12.12
broadcast msgs on commit(actual)	326	4.50	7.58
broadcast msgs on commit(logical)	329	4.54	7.65
broadcast msgs on commit(wasted)	11	0.15	0.26
broadcast on commit wait time(ms)	1	0.01	0.02
broadcast on commit waits	5	0.07	0.12
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
false posts waiting for scn acks	0	0.00	0.00
flow control messages received	4	0.06	0.09
flow control messages sent	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	348	4.80	8.09
gcs ast xid	0	0.00	0.00
gcs blocked converts	290	4.00	6.74
gcs blocked cr converts	129	1.78	3.00
gcs compatible basts	1	0.01	0.02
gcs compatible cr basts (global)	28	0.39	0.65
gcs compatible cr basts (local)	274	3.78	6.37
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	1	0.01	0.02
gcs dbwr write request msgs	3	0.04	0.07
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	11	0.15	0.26
gcs immediate (null) converts	19	0.26	0.44
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	4	0.06	0.09
gcs indirect ast	30	0.41	0.70
gcs indirect bidless ast	29	0.40	0.67
gcs indirect fg ast	27	0.37	0.63
gcs lms flush pi msgs	8	0.11	0.19
gcs lms write request msgs	8	0.11	0.19
gcs msgs process time(ms)	36	0.50	0.84
gcs msgs received	3,972	54.81	92.37
gcs new served by master	16	0.22	0.37
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 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	3	0.04	0.07
gcs reader bypass grant X on assume	3	0.04	0.07
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	19	0.26	0.44
gcs reader bypass grant immediate	28	0.39	0.65
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	1	0.01	0.02
gcs regular cr	75	1.03	1.74
gcs retry convert request	533	7.35	12.40
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	77	1.06	1.79
gcs side channel msgs logical	2,095	28.91	48.72
gcs stale cr	0	0.00	0.00
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)	13	0.18	0.30
ges msgs received	2,956	40.79	68.74
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	34	0.47	0.79
implicit batch messages sent	74	1.02	1.72
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	231	3.19	5.37
messages queue sent actual	3,732	51.50	86.79
messages queue sent logical	3,841	53.00	89.33
messages received actual	5,263	72.62	122.40
messages received logical	6,928	95.60	161.12
messages sent directly	1,326	18.30	30.84
messages sent indirectly	1,494	20.62	34.74
messages sent not implicit batched	3,658	50.48	85.07
messages sent pbatched	6,245	86.17	145.23
msgs causing lmd to send msgs	1,416	19.54	32.93
msgs causing lms(s) to send msgs	495	6.83	11.51
msgs received queue time (ms)	0	0.00	0.00
msgs received queued	6,928	95.60	161.12
msgs sent queue time (ms)	3,277,125	45,221.06	76,212.21
msgs sent queue time on ksxp (ms)	637	8.79	14.81
msgs sent queued	3,841	53.00	89.33
msgs sent queued on ksxp	5,567	76.82	129.47
process batch messages received	2,772	38.25	64.47
process batch messages sent	3,198	44.13	74.37

Global CR Served Stats

Statistic	Total
CR Block Requests	65
CURRENT Block Requests	98
Data Block Requests	65
Undo Block Requests	0
TX Block Requests	69
Current Results	161
Private results	1
Zero Results	1
Disk Read Results	0
Fail Results	0
Fairness Down Converts	10
Fairness Clears	13
Free GC Elements	0
Flushes	5
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	1
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
Pins	547	100.00	0.00
Flushes	5	60.00	40.00
Writes	3	0.00	100.00

Global Cache Transfer Stats

Global Cache Transfer Stats
Global Cache Transfer Times (ms)
Global Cache Transfer (Immediate)
Global Cache Times (Immediate)

Global Cache Transfer Stats

Immediate (Immed) - Block Transfer NOT impacted by Remote Processing Delays
Busy (Busy) - Block Transfer impacted by Remote Contention
Congested (Congst) - Block Transfer impacted by Remote System Load
ordered by CR + Current Blocks Received desc

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
4	Others	11	100.00	0.00	0.00	588	100.00	0.00	0.00
2	Others	15	100.00	0.00	0.00	499	100.00	0.00	0.00
5	Others	5	100.00	0.00	0.00	364	100.00	0.00	0.00
4	data block	22	100.00	0.00	0.00	128	100.00	0.00	0.00
2	data block	22	100.00	0.00	0.00	73	100.00	0.00	0.00
5	data block	21	100.00	0.00	0.00	73	100.00	0.00	0.00
8	data block	18	100.00	0.00	0.00	45	91.11	8.89	0.00
1	data block	18	100.00	0.00	0.00	25	92.00	8.00	0.00
7	Others	1	100.00	0.00	0.00	23	100.00	0.00	0.00
6	data block	11	100.00	0.00	0.00	13	100.00	0.00	0.00
6	Others	4	100.00	0.00	0.00	19	100.00	0.00	0.00
7	data block	11	100.00	0.00	0.00	10	100.00	0.00	0.00
1	Others	9	100.00	0.00	0.00	7	100.00	0.00	0.00
8	Others	1	100.00	0.00	0.00	8	100.00	0.00	0.00
8	undo header	4	75.00	25.00	0.00	2	100.00	0.00	0.00
5	undo header	3	100.00	0.00	0.00	2	100.00	0.00	0.00
4	undo header	3	100.00	0.00	0.00	1	100.00	0.00	0.00
7	undo header	1	100.00	0.00	0.00	3	100.00	0.00	0.00
1	undo header	0				2	100.00	0.00	0.00
8	undo block	1	100.00	0.00	0.00	0
2	undo header	0				1	100.00	0.00	0.00
6	undo header	1	100.00	0.00	0.00	0

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer Times (ms)

Avg Time - average time of all blocks (Immed,Busy,Congst) in ms
Immed, Busy, Congst - Average times in ms
ordered by CR + Current Blocks Received desc

Inst No	Block Class	All	Immed	Busy	All	Immed	Busy
		CR Avg Time (ms)			Current Avg Time (ms)
4	others	0.18	0.18		1.45	1.45
2	others	0.17	0.17		1.37	1.37
5	others	0.13	0.13		1.30	1.30
4	data block	0.23	0.23		0.21	0.21
2	data block	0.19	0.19		0.23	0.23
5	data block	0.20	0.20		0.22	0.22
8	data block	0.24	0.24		0.27	0.23	0.65
1	data block	0.20	0.20		0.24	0.24	0.22
6	data block	0.21	0.21		0.18	0.18
7	others	0.12	0.12		1.09	1.09
6	others	0.16	0.16		1.06	1.06
7	data block	0.20	0.20		0.22	0.22
1	others	0.29	0.29		0.17	0.17
8	others	0.19	0.19		0.63	0.63
8	undo header	0.26	0.13	0.65	0.16	0.16
5	undo header	0.12	0.12		0.13	0.13
7	undo header	0.13	0.13		0.13	0.13
4	undo header	0.12	0.12		0.12	0.12
1	undo header				0.14	0.14
8	undo block	0.26	0.26
6	undo header	0.14	0.14
2	undo header				0.13	0.13
7	undo block
4	undo block
5	undo block
1	undo block
6	undo block
2	undo block

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer (Immediate)

Immediate (Immed) - Block Transfer NOT impacted by Remote Processing Delays
% of Blocks Received requiring 2 or 3 hops
ordered by CR + Current Blocks Received desc

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
4	others	0	11	0.00	100.00	588	55.78	44.22
2	others	0	15	0.00	100.00	499	98.40	1.60
5	others	0	5	100.00	0.00	364	88.74	11.26
4	data block	0	22	18.18	81.82	128	47.66	52.34
2	data block	0	22	36.36	63.64	73	41.10	58.90
5	data block	0	21	23.81	76.19	73	46.58	53.42
8	data block	0	18	5.56	94.44	41	21.95	78.05
1	data block	0	18	22.22	77.78	23	17.39	82.61
6	data block	0	11	18.18	81.82	13	69.23	30.77
7	others	0	1	100.00	0.00	23	100.00	0.00
6	others	0	4	0.00	100.00	19	89.47	10.53
7	data block	0	11	18.18	81.82	10	30.00	70.00
1	others	0	9	0.00	100.00	7	14.29	85.71
8	others	0	1	0.00	100.00	8	50.00	50.00
5	undo header	0	3	100.00	0.00	2	100.00	0.00
8	undo header	0	3	100.00	0.00	2	100.00	0.00
7	undo header	0	1	100.00	0.00	3	100.00	0.00
4	undo header	0	3	100.00	0.00	1	100.00	0.00
1	undo header	0	0			2	100.00	0.00
8	undo block	0	1	100.00	0.00	0
6	undo header	0	1	100.00	0.00	0
2	undo header	0	0			1	100.00	0.00
7	undo block	0	0			0
4	undo block	0	0			0
5	undo block	0	0			0
1	undo block	0	0			0
6	undo block	0	0			0
2	undo block	0	0			0

Back to Global Cache Transfer Stats
Back to Top

Global Cache Times (Immediate)

Blocks Lost, 2-hop and 3-hop Average times in (ms)
ordered by CR + Current Blocks Received desc

Src Inst#	Block Class	Immed	2hop	3hop	Immed	2hop	3hop
		CR Avg Time (ms)			Current Avg Time (ms)
4	others	0.18		0.18	1.45	1.29	1.66
2	others	0.17		0.17	1.37	1.39	0.17
5	others	0.13	0.13		1.30	1.29	1.33
4	data block	0.23	0.26	0.23	0.21	0.18	0.24
2	data block	0.19	0.14	0.23	0.23	0.19	0.25
5	data block	0.20	0.16	0.21	0.22	0.19	0.24
8	data block	0.24	0.12	0.24	0.23	0.16	0.25
1	data block	0.20	0.19	0.20	0.24	0.15	0.26
6	data block	0.21	0.11	0.23	0.18	0.16	0.22
7	others	0.12	0.12		1.09	1.09
6	others	0.16		0.16	1.06	1.17	0.17
7	data block	0.20	0.17	0.20	0.22	0.14	0.26
1	others	0.29		0.29	0.17	0.12	0.18
8	others	0.19		0.19	0.63	1.04	0.22
5	undo header	0.12	0.12		0.13	0.13
8	undo header	0.13	0.13		0.16	0.16
7	undo header	0.13	0.13		0.13	0.13
4	undo header	0.12	0.12		0.12	0.12
1	undo header				0.14	0.14
8	undo block	0.26	0.26
6	undo header	0.14	0.14
2	undo header				0.13	0.13
7	undo block
4	undo block
5	undo block
1	undo block
6	undo block
2	undo block

Back to Global Cache Transfer Stats
Back to Top

Interconnect Stats

Interconnect Latency Stats
Interconnect Throughput by Client
Interconnect Device 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	3	0.64	0.00	3	0.64	0.00
2	3	0.75	0.05	3	0.74	0.06
3	3	0.62	0.05	3	0.63	0.02
4	3	0.55	0.06	3	0.55	0.06
5	3	0.58	0.05	3	0.57	0.05
6	3	0.52	0.05	3	0.54	0.04
7	3	0.53	0.00	3	0.53	0.00
8	3	0.46	0.04	3	0.46	0.04

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.08	0.22
Parallel Query	0.05	0.02
DB Locks	0.03	0.02
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
bond0	172.31.88.111	NO	Oracle Cluster Repository	0.00	0	0	0	0	0.00	0	0	0	0

Back to Interconnect Stats
Back to Top

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.92	In-memory Sort %:	100.00
Library Hit %:	94.25	Soft Parse %:	88.47
Execute to Parse %:	41.18	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	0.00	% Non-Parse CPU:	99.97

Buffer access - local cache %:	92.74
Buffer access - remote cache %:	7.18
Buffer access - disk %:	0.08

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.2
Avg global cache current block receive time (ms):	1.1
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 %:	3.2
Avg global cache cr block flush time (ms):	0.0
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.9
Avg global cache current block flush time (ms):	0.0

Avg message sent queue time (ms):	853.2
Avg message sent queue time on ksxp (ms):	0.1
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	43.46
% of indirect sent messages:	48.97
% of flow controlled messages:	7.57