WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

DEMO 3430975138 DEMO4 4 26-Jun-09 06:06 11.1.0.7.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
DEMO	3430975138	DEMO4	4	26-Jun-09 06:06	11.1.0.7.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

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

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

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 914 27-Jun-09 17:34:13 44 1.6

End Snap: 915 27-Jun-09 17:37:21 47 1.5

Elapsed: 3.14 (mins)

DB Time: 12.05 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	914	27-Jun-09 17:34:13	44	1.6
End Snap:	915	27-Jun-09 17:37:21	47	1.5
Elapsed:		3.14 (mins)
DB Time:		12.05 (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): 3.8 7.5 0.52 0.67

DB CPU(s): 2.0 3.9 0.27 0.35

Redo size: 6,206.8 12,196.9

Logical reads: 10,440.5 20,516.4

Block changes: 88.8 174.5

Physical reads: 16,551.0 32,524.1

Physical writes: 6,338.5 12,455.6

User calls: 5.7 11.2

Parses: 3.9 7.7

Hard parses: 0.4 0.7

W/A MB processed: 40,496,820.3 79,579,626.7

Logons: 1.0 1.9

Executes: 7.3 14.4

Rollbacks: 0.4 0.8

Transactions: 0.5

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	3.8	7.5	0.52	0.67
DB CPU(s):	2.0	3.9	0.27	0.35
Redo size:	6,206.8	12,196.9
Logical reads:	10,440.5	20,516.4
Block changes:	88.8	174.5
Physical reads:	16,551.0	32,524.1
Physical writes:	6,338.5	12,455.6
User calls:	5.7	11.2
Parses:	3.9	7.7
Hard parses:	0.4	0.7
W/A MB processed:	40,496,820.3	79,579,626.7
Logons:	1.0	1.9
Executes:	7.3	14.4
Rollbacks:	0.4	0.8
Transactions:	0.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 10.72 Redo NoWait %: 100.00

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

Library Hit %: 94.03 Soft Parse %: 90.79

Execute to Parse %: 46.44 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 0.01 % Non-Parse CPU: 99.96

Shared Pool Statistics

Begin End

Memory Usage %: 68.49 68.77

% SQL with executions>1: 94.22 95.05

% Memory for SQL w/exec>1: 87.33 86.96

	Begin	End
Memory Usage %:	68.49	68.77
% SQL with executions>1:	94.22	95.05
% Memory for SQL w/exec>1:	87.33	86.96

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		378		52.37
direct path read temp	38,103	195	5	26.97	User I/O
direct path write temp	38,099	30	1	4.10	User I/O
gc buffer busy acquire	13,998	29	2	3.97	Cluster
gc buffer busy release	5,624	17	3	2.31	Cluster

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

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

0.23 2.10 22.4 3.1 0.0 73.2

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.23	2.10	22.4	3.1	0.0	73.2

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

25.5 95.0 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
25.5	95.0	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): 394.1 429.0

% Host Mem used for SGA+PGA: 20.31 20.31

	Begin	End
Host Mem (MB):	32,189.6	32,189.6
SGA use (MB):	6,144.0	6,144.0
PGA use (MB):	394.1	429.0
% Host Mem used for SGA+PGA:	20.31	20.31

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: 21.51 42.27

Global Cache blocks served: 21.12 41.51

GCS/GES messages received: 65.90 129.50

GCS/GES messages sent: 82.30 161.73

DBWR Fusion writes: 0.10 0.20

Estd Interconnect traffic (KB) 370.03

	Per Second	Per Transaction
Global Cache blocks received:	21.51	42.27
Global Cache blocks served:	21.12	41.51
GCS/GES messages received:	65.90	129.50
GCS/GES messages sent:	82.30	161.73
DBWR Fusion writes:	0.10	0.20
Estd Interconnect traffic (KB)	370.03

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

Buffer access - local cache %: 85.61

Buffer access - remote cache %: 14.24

Buffer access - disk %: 0.15

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): 5.2

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

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

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

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

Global cache log flushes for current blocks served %: 0.2

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 16,560.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: 47.38

% of indirect sent messages: 45.99

% of flow controlled messages: 6.62

Cluster Interconnect

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
bond0	172.31.88.170	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): 722.7s
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	699.96	96.85
DB CPU	378.50	52.37
PL/SQL execution elapsed time	0.84	0.12
parse time elapsed	0.27	0.04
hard parse elapsed time	0.23	0.03
hard parse (sharing criteria) elapsed time	0.17	0.02
sequence load elapsed time	0.00	0.00
PL/SQL compilation elapsed time	0.00	0.00
repeated bind elapsed time	0.00	0.00
DB time	722.71
background elapsed time	18.68
background cpu time	5.24

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	40,393
IDLE_TIME	110,298
IOWAIT_TIME	30
NICE_TIME	0
SYS_TIME	4,687
USER_TIME	33,747
LOAD	0	2
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
27-Jun 17:34:13	0.23
27-Jun 17:37:21	2.10	26.81	22.39	3.11	0.02	73.19

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			378		52.37
User I/O	102,852	0	243	2	33.65
Cluster	33,515	19	66	2	9.08
Other	1,396,397	100	20	0	2.71
Concurrency	10,693	0	15	1	2.06
System I/O	1,354	0	1	1	0.10
Application	41	0	0	0	0.00
Network	177	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
direct path read temp	38,103	0	195	5	396.91	26.97
direct path write temp	38,099	0	30	1	396.86	4.10
gc buffer busy acquire	13,998	0	29	2	145.81	3.97
gc buffer busy release	5,624	0	17	3	58.58	2.31
PX Deq: reap credit	1,385,327	100	16	0	14,430.49	2.21
buffer busy waits	9,724	0	15	2	101.29	2.03
local write wait	23,019	0	13	1	239.78	1.81
gc current block busy	4,028	62	11	3	41.96	1.49
gc current block 3-way	9,348	43	9	1	97.38	1.23
cell smart table scan	3,515	2	5	1	36.61	0.69
PX Deq: Slave Session Stats	189	0	1	5	1.97	0.13
reliable message	154	0	1	5	1.60	0.11
control file sequential read	1,345	0	1	1	14.01	0.10
PX Deq: Signal ACK RSG	70	53	1	10	0.73	0.10
cell single block physical read	95	0	0	5	0.99	0.07
gc current grant busy	88	35	0	5	0.92	0.06
enq: PS - contention	369	33	0	1	3.84	0.05
DFS lock handle	11	0	0	30	0.11	0.05
PX Nsq: PQ load info query	1	100	0	200	0.01	0.03
enq: WF - contention	13	0	0	7	0.14	0.01
IPC send completion sync	749	98	0	0	7.80	0.01
library cache lock	239	0	0	0	2.49	0.01
row cache lock	218	0	0	0	2.27	0.01
gc current retry	9	44	0	6	0.09	0.01
os thread startup	3	0	0	14	0.03	0.01
library cache pin	231	0	0	0	2.41	0.01
enq: XL - fault extent map	2	0	0	18	0.02	0.01
PX qref latch	9,357	100	0	0	97.47	0.00
PX Deq: Signal ACK EXT	31	0	0	1	0.32	0.00
gc cr block 3-way	143	0	0	0	1.49	0.00
gc current block 2-way	130	0	0	0	1.35	0.00
latch: cache buffers chains	256	0	0	0	2.67	0.00
enq: PV - syncstart	1	0	0	11	0.01	0.00
read by other session	18	0	0	1	0.19	0.00
gc cr block 2-way	84	0	0	0	0.88	0.00
latch: session allocation	12	0	0	1	0.13	0.00
control file parallel write	9	0	0	1	0.09	0.00
gc current grant 2-way	35	6	0	0	0.36	0.00
SQL*Net break/reset to client	38	0	0	0	0.40	0.00
latch free	12	0	0	0	0.13	0.00
gc cr block busy	2	0	0	1	0.02	0.00
enq: CF - contention	5	0	0	0	0.05	0.00
ASM file metadata operation	45	0	0	0	0.47	0.00
db file single write	3	0	0	0	0.03	0.00
SQL*Net message from client	177	0	1,456	8226	1.84
PX Deq Credit: send blkd	183,843	0	360	2	1,915.03
PX Deq: Execution Msg	1,039	8	236	227	10.82
PX Deq: Execute Reply	797	10	178	223	8.30
PX Deq: Table Q Normal	214,489	0	115	1	2,234.26
PX Deq Credit: need buffer	25,232	0	24	1	262.83
Streams AQ: waiting for messages in the queue	34	56	19	558	0.35
KSV master wait	78	0	3	39	0.81
PX Deq: Parse Reply	94	1	0	1	0.98
PX Deq: Join ACK	158	18	0	0	1.65

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
db file parallel write	14,455	0	8	1	150.57	43.94
ASM file metadata operation	272	0	4	13	2.83	19.04
buffer busy waits	1	0	1	837	0.01	4.48
control file sequential read	484	0	1	1	5.04	3.01
gc buffer busy acquire	2	0	0	201	0.02	2.15
DFS lock handle	151	99	0	1	1.57	0.92
enq: CO - master slave det	63	100	0	2	0.66	0.81
control file parallel write	63	0	0	2	0.66	0.52
ges inquiry response	71	0	0	1	0.74	0.23
PX Deq: reap credit	4,985	100	0	0	51.93	0.17
row cache lock	43	0	0	0	0.45	0.09
log file parallel write	59	0	0	0	0.61	0.08
os thread startup	1	0	0	14	0.01	0.07
CGS wait for IPC msg	1,541	100	0	0	16.05	0.06
gcs log flush sync	59	0	0	0	0.61	0.05
enq: CF - contention	13	54	0	1	0.14	0.05
ksxr poll remote instances	1,228	100	0	0	12.79	0.04
enq: TA - contention	1	0	0	4	0.01	0.02
library cache pin	7	0	0	1	0.07	0.02
enq: PS - contention	19	47	0	0	0.20	0.02
gc cr block 3-way	4	0	0	1	0.04	0.02
gc current block 2-way	4	0	0	1	0.04	0.02
reliable message	6	0	0	1	0.06	0.02
gc current block 3-way	13	0	0	0	0.14	0.02
cell single block physical read	1	0	0	2	0.01	0.01
latch: shared pool	1	0	0	2	0.01	0.01
PX Deq: Slave Session Stats	1	0	0	1	0.01	0.01
latch: cache buffers chains	43	0	0	0	0.45	0.01
latch: session allocation	1	0	0	1	0.01	0.01
PX Idle Wait	4,694	96	11,567	2464	48.90
rdbms ipc message	21,578	13	3,373	156	224.77
class slave wait	200	75	530	2648	2.08
wait for unread message on broadcast channel	376	100	376	1001	3.92
DIAG idle wait	6,441	92	376	58	67.09
gcs remote message	19,663	41	376	19	204.82
smon timer	1	100	300	300011	0.01
Streams AQ: qmn coordinator idle wait	14	50	200	14313	0.15
Streams AQ: qmn slave idle wait	7	0	200	28625	0.07
PING	69	6	200	2897	0.72
Space Manager: slave idle wait	38	100	190	5001	0.40
ASM background timer	164	0	189	1154	1.71
pmon timer	71	89	189	2662	0.74
ges remote message	7,172	25	188	26	74.71
dispatcher timer	3	100	180	60002	0.03
shared server idle wait	6	100	180	30000	0.06
KSV master wait	121	93	1	5	1.26
PX Deq: Join ACK	8	13	0	0	0.08

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	317	82.6	2.2	1.9	.3	.9	6.0	6.0
CGS wait for IPC msg	1540	100.0
DFS lock handle	169	90.5	4.7	1.2	1.2			2.4
IPC send completion sync	761	98.4	1.2	.4
KJC: Wait for msg sends to complete	1	100.0
PX Deq: Signal ACK EXT	31	74.2	16.1	6.5	3.2
PX Deq: Signal ACK RSG	69	71.0	2.9	2.9	5.8	2.9	5.8	8.7
PX Deq: Slave Session Stats	190	58.4	15.3	15.8	5.3	2.6	2.1	.5
PX Deq: reap credit	1389K	100.0	.0	.0	.0
PX Nsq: PQ load info query	1							100.0
PX qref latch	9357	100.0
SQL*Net break/reset to client	36	97.2	2.8
SQL*Net message to client	170	100.0
buffer busy waits	9725	59.6	19.0	14.9	5.8	.5	.0	.1
cell single block physical read	98	8.2	5.1	19.4	50.0	16.3	1.0
cell smart table scan	3515	61.5	20.6	11.7	2.8	2.9	.4	.1
control file parallel write	71	71.8	9.9	11.3	5.6	1.4
control file sequential read	1815	92.6	2.7	1.7	2.0	.8	.2	.1
db file parallel write	14K	89.8	7.1	2.3	.7	.1
db file single write	3	100.0
direct path read temp	38K	14.6	4.9	22.7	41.9	15.1	.7	.1
direct path write temp	38K	66.2	22.8	9.1	1.6	.2		.0
enq: AF - task serialization	2	100.0
enq: CF - contention	17	88.2		11.8
enq: CO - master slave det	62	79.0	11.3	8.1				1.6
enq: KO - fast object checkpoint	4	100.0
enq: PS - contention	380	88.2	5.8	5.0	.5			.5
enq: PV - syncstart	1					100.0
enq: SW - contention	1	100.0
enq: TA - contention	1				100.0
enq: TD - KTF dump entries	1	100.0
enq: TK - Auto Task Serialization	1	100.0
enq: TT - contention	1	100.0
enq: TX - index contention	1	100.0
enq: US - contention	1	100.0
enq: WF - contention	13	92.3						7.7
enq: XL - fault extent map	2					50.0	50.0
gc buffer busy acquire	14K	57.3	16.6	13.6	9.1	3.1	.1	.2
gc buffer busy release	5624	62.5	15.9	12.1	6.8	2.2	.2	.3
gc cr block 2-way	77	100.0
gc cr block 3-way	142	98.6	1.4
gc cr block busy	2	50.0	50.0
gc cr grant 2-way	2	100.0
gc cr multi block request	24	100.0
gc current block 2-way	136	99.3		.7
gc current block 3-way	3058	63.8	6.5	5.6	8.4	14.7	.7	.2
gc current block busy	577	.3	.3	4.0	17.3	71.1	5.5	1.0	.3
gc current grant 2-way	35	97.1	2.9
gc current grant busy	41	78.0					2.4	19.5
gc current retry	3	66.7						33.3
gcs log flush sync	43	100.0
ges inquiry response	77	81.8	10.4	7.8
ksxr poll remote instances	1080	100.0
latch free	15	100.0
latch: cache buffers chains	299	99.3	.3	.3
latch: enqueue hash chains	1	100.0
latch: gc element	7	100.0
latch: gcs resource hash	1	100.0
latch: ges resource hash list	8	100.0
latch: session allocation	13	69.2	15.4	15.4
latch: shared pool	5	80.0	20.0
library cache lock	75	96.0	4.0
library cache pin	84	98.8	1.2
library cache: mutex X	17	100.0
local write wait	23K	87.5	9.2	2.9	.3	.0
lock escalate retry	3	100.0
log file parallel write	58	100.0
os thread startup	4					100.0
rdbms ipc reply	28	100.0
read by other session	18	88.9	5.6	5.6
reliable message	149	88.6	6.7	3.4	.7			.7
row cache lock	190	97.9	1.1	1.1
undo segment extension	1							100.0
ASM background timer	163	22.1	2.5	4.3	1.8	9.2	12.3	17.8	30.1
DIAG idle wait	6437	2.9	.5	.3	.4	1.0	45.0	49.9
KSV master wait	199	65.8	6.5	3.5	3.5	2.5	8.0	10.1
PING	69	87.0	1.4						11.6
PX Deq Credit: need buffer	25K	76.4	10.7	8.5	3.3	1.0	.2	.0
PX Deq Credit: send blkd	183K	63.0	14.1	14.0	7.1	1.5	.2	.1	.0
PX Deq: Execute Reply	797	20.6	5.3	5.4	6.3	11.3	9.2	35.0	7.0
PX Deq: Execution Msg	1038	45.5	12.0	15.8	9.1	3.9	1.5	3.7	8.6
PX Deq: Join ACK	160	86.3	9.4	3.8	.6
PX Deq: Parse Reply	94	85.1	6.4	2.1	4.3	1.1	1.1
PX Deq: Table Q Normal	214K	88.0	7.8	3.3	.8	.1	.0	.0
PX Idle Wait	4679			.0	.0	.0	.1	2.6	97.3
SQL*Net message from client	170	42.4	18.2	8.8	4.7				25.9
Space Manager: slave idle wait	38								100.0
Streams AQ: RAC qmn coordinator idle wait	15	100.0
Streams AQ: qmn coordinator idle wait	14	35.7	7.1	7.1					50.0
Streams AQ: qmn slave idle wait	7								100.0
Streams AQ: waiting for messages in the queue	33							100.0
class slave wait	201	.5		.5			.5	6.5	92.0
dispatcher timer	3								100.0
gcs remote message	19K	33.3	4.0	3.8	6.1	10.7	2.7	39.4
ges remote message	6742	47.8	6.4	3.5	3.0	3.5	4.4	31.4
pmon timer	71	11.3							88.7
rdbms ipc message	21K	66.9	3.7	3.0	2.2	5.6	1.7	12.7	4.2
shared server idle wait	6								100.0
smon timer	2								100.0
wait for unread message on broadcast channel	376							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_FOUR	721	378	12,351	7,667
SYS$USERS	1	1	0	0
SYS$BACKGROUND	1	0	0	1
DEMO	0	0	0	0
D4	0	0	0	0
DEMOXDB	0	0	0	0
D_EIGHT	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	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts
D_FOUR	0	10689	15	3
SYS$USERS	0	31	0	138
SYS$BACKGROUND	1	95	1	0
DEMO	0	0	0	36

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): 723
Captured SQL account for 96.7% of Total
Total DB Time (s): 723
Captured PL/SQL account for 0.4% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
696	374	1	696.20	96.33	dgyay259941s4	SQL*Plus	select /* four / /+ parallel...
3	1	1	3.04	0.42	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
1	0	18	0.03	0.08	7frqszzdu8sgg	racgimon@host105.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
0	0	1	0.45	0.06	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	1	0.38	0.05	350myuyx0t1d6		insert into wrh$_tablespace_st...
0	0	1	0.18	0.03	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
0	0	1	0.16	0.02	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	1	0.16	0.02	f318xdxdn0pdc		insert into wrh$_log (s...
0	0	1	0.13	0.02	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
0	0	1	0.11	0.02	6hwjmjgrpsuaa		insert into wrh$_enqueue_stat ...

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): 378
Captured SQL account for 99.0% of Total
Total CPU Time (s): 378
Captured PL/SQL account for 0.3% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
374	696	1	373.94	98.80	96.33	dgyay259941s4	SQL*Plus	select /* four / /+ parallel...
1	3	1	1.00	0.26	0.42	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0	0	1	0.44	0.12	0.06	bunssq950snhf		insert into wrh$_sga_target_ad...
0	1	18	0.01	0.04	0.08	7frqszzdu8sgg	racgimon@host105.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
0	0	1	0.10	0.03	0.02	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	1	0.05	0.01	0.01	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...
0	0	1	0.04	0.01	0.03	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
0	0	0		0.01	0.01	1rsnjtn0upcut	sqlplus@host101.us.oracle.com (TNS V1-V3)	select px.SID "SID", ...
0	0	1	0.03	0.01	0.02	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
0	0	1	0.01	0.00	0.00	4dy1xm4nxc0gf		insert into wrh$_system_event ...

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: 1,969,572
Captured SQL account for 98.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,920,079	1	1,920,079.00	97.49	373.94	696.20	dgyay259941s4	SQL*Plus	select /* four / /+ parallel...
15,337	1	15,337.00	0.78	1.00	3.04	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
7,159	1	7,159.00	0.36	0.05	0.05	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...
3,697	1	3,697.00	0.19	0.10	0.16	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
1,040	1	1,040.00	0.05	0.01	0.00	6c06mfv01xt2h		update wrh$_seg_stat_obj sso ...
585	132	4.43	0.03	0.00	0.01	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
382	1	382.00	0.02	0.00	0.00	6wm3n4d7bnddg		SELECT source, (case ...
210	1	210.00	0.01	0.01	0.02	5ax5xu96u2ztd		insert into WRH$_EVENT_HISTOGR...
192	1	192.00	0.01	0.01	0.01	2mbgtjssndtz5		SELECT ID FROM WRI$_ADV_MESSAG...
168	44	3.82	0.01	0.00	0.00	96g93hntrzjtr		select /+ rule / bucket_cnt,...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 3,122,317
Captured SQL account for 98.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
3,074,972	1	3,074,972.00	98.48	373.94	696.20	dgyay259941s4	SQL*Plus	select /* four / /+ parallel...
11	1	11.00	0.00	1.00	3.04	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
3	4	0.75	0.00	0.01	0.03	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
3	1	3.00	0.00	0.10	0.16	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
2	1	2.00	0.00	0.05	0.05	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...
2	1	2.00	0.00	0.00	0.02	fnk7155mk2jq6		insert into wrh$_sysmetric_his...
1	1	1.00	0.00	0.00	0.01	0z1031991bd7w		insert into wrh$_sysmetric_sum...
1	1	1.00	0.00	0.01	0.02	5ax5xu96u2ztd		insert into WRH$_EVENT_HISTOGR...
1	1	1.00	0.00	0.01	0.11	6hwjmjgrpsuaa		insert into wrh$_enqueue_stat ...
0	6	0.00	0.00	0.00	0.00	062savj8zgzut		UPDATE sys.wri$_adv_parameters...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 1,378
Captured SQL account for 40.0% 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...
48	48	1.00	0.00	0.00	6xvp6nxs4a9n4		select nvl(sum(space), 0) from...
48	0	0.00	0.00	0.00	csnp95dz2r8ss		select file#, block# from rec...
44	28	0.64	0.00	0.00	96g93hntrzjtr		select /+ rule / bucket_cnt,...
43	676	15.72	0.00	0.00	db78fxqxwxt7r		select /+ rule / bucket, en...
40	0	0.00	0.00	0.00	c4nhd1ntptxq7		select message_level, sequenc...
31	31	1.00	0.00	0.00	9tgj4g8y4rwy8		select type#, blocks, extents,...
18	18	1.00	0.01	0.03	7frqszzdu8sgg	racgimon@host105.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
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...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 738
Captured SQL account for 62.3% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
150	18	20.33	7frqszzdu8sgg	racgimon@host105.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
48	48	6.50	6xvp6nxs4a9n4		select nvl(sum(space), 0) from...
48	48	6.50	csnp95dz2r8ss		select file#, block# from rec...
40	40	5.42	c4nhd1ntptxq7		select message_level, sequenc...
31	31	4.20	9tgj4g8y4rwy8		select type#, blocks, extents,...
9	9	1.22	8x0funf899dka		INSERT INTO wri$_adv_addm_inst...
9	1	1.22	dgyay259941s4	SQL*Plus	select /* four / /+ parallel...
7	1	0.95	a1xgxtssv5rrp	MMON_SLAVE	select sum(used_blocks), ts.t...
6	6	0.81	062savj8zgzut		UPDATE sys.wri$_adv_parameters...
6	6	0.81	1ytruncyx2kdb	OEM.DefaultPool	BEGIN MGMT_HTTP_SESSION.sessio...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

%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): 66
Captured Segments account for 99.3% of Total

Cluster Wait Time (s)	%Ela	%Total	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Module	SQL Text
65.50	9.41	99.22	696.20	373.94	1	dgyay259941s4	SQL*Plus	select /* four / /+ parallel...
0.10	3.17	0.15	3.04	1.00	1	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0.03	18.72	0.05	0.16	0.10	1	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...

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

0z1031991bd7w insert into wrh$_sysmetric_summary (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, num_interval, maxval, minval, average, standard_deviation, sum_squares) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, numintv, max, min, avg, std, sumsq FROM x$kewmsmdv WHERE groupid = 2

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)

1rsnjtn0upcut select px.SID "SID", p.PID, p.SPID "SPID", px.INST_ID "Inst", px.SERVER_GROUP "Group", px.SERVER_SET "Set", px.DEGREE "Degree", px.REQ_DEGREE "Req Degree", w.event "Wait Event" from GV$SESSION s, GV$PX_SESSION px, GV$PROCESS p, GV$SESSION_WAIT w where s.sid (+) = px.sid and s.inst_id (+) = px.inst_id and s.sid = w.sid (+) and s.inst_id = w.inst_id (+) and s.paddr = p.addr (+) and s.inst_id = p.inst_id (+) ORDER BY decode(px.QCINST_ID, NULL, px.INST_ID, px.QCINST_ID), px.QCSID, decode(px.SERVER_GROUP, NULL, 0, px.SERVER_GROUP), px.SERVER_SET, px.INST_ID

1uk5m5qbzj1vt BEGIN dbms_workload_repository.create_snapshot; END;

1ytruncyx2kdb BEGIN MGMT_HTTP_SESSION.session_expired(:1); END;

2mbgtjssndtz5 SELECT ID FROM WRI$_ADV_MESSAGE_GROUPS WHERE TASK_ID = :B9 AND SEQ = 0 AND MESSAGE# = :B8 AND FAC = :B7 AND HDR = 0 AND LM = 0 AND NL = 0 AND EXEC_NAME = :B6 AND NVL(:B5 , '~') = NVL(P1, '~') AND NVL(:B4 , '~') = NVL(P2, '~') AND NVL(:B3 , '~') = NVL(P3, '~') AND NVL(:B2 , '~') = NVL(P4, '~') AND NVL(:B1 , '~') = NVL(P5, '~')

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)

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

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 )

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'

6hwjmjgrpsuaa insert into wrh$_enqueue_stat (snap_id, dbid, instance_number, eq_type, req_reason, total_req#, total_wait#, succ_req#, failed_req#, cum_wait_time, event#) select :snap_id, :dbid, :instance_number, eq_type, req_reason, total_req#, total_wait#, succ_req#, failed_req#, cum_wait_time, event# from v$enqueue_statistics where total_req# != 0 order by eq_type, req_reason

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

6xvp6nxs4a9n4 select nvl(sum(space), 0) from recyclebin$ where ts# = :1

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

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)

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)

96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2

9tgj4g8y4rwy8 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

a1xgxtssv5rrp select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#

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

c4nhd1ntptxq7 select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4

csnp95dz2r8ss select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0

db78fxqxwxt7r select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

dgyay259941s4 select /* four */ /*+ 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 retail.DWB_RTL_TRX t1 , retail.DWB_RTL_TRX t2 where t1.TRX_NBR = t2.TRX_NBR

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

fnk7155mk2jq6 insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv order by groupid, metricid, begtime

g4vrdfn14tp29 SELECT PROPERTY FROM SYS.WRI$_ADV_TASKS WHERE ID = :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
0z1031991bd7w	insert into wrh$_sysmetric_summary (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, num_interval, maxval, minval, average, standard_deviation, sum_squares) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, numintv, max, min, avg, std, sumsq FROM x$kewmsmdv WHERE groupid = 2
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)
1rsnjtn0upcut	select px.SID "SID", p.PID, p.SPID "SPID", px.INST_ID "Inst", px.SERVER_GROUP "Group", px.SERVER_SET "Set", px.DEGREE "Degree", px.REQ_DEGREE "Req Degree", w.event "Wait Event" from GV$SESSION s, GV$PX_SESSION px, GV$PROCESS p, GV$SESSION_WAIT w where s.sid (+) = px.sid and s.inst_id (+) = px.inst_id and s.sid = w.sid (+) and s.inst_id = w.inst_id (+) and s.paddr = p.addr (+) and s.inst_id = p.inst_id (+) ORDER BY decode(px.QCINST_ID, NULL, px.INST_ID, px.QCINST_ID), px.QCSID, decode(px.SERVER_GROUP, NULL, 0, px.SERVER_GROUP), px.SERVER_SET, px.INST_ID
1uk5m5qbzj1vt	BEGIN dbms_workload_repository.create_snapshot; END;
1ytruncyx2kdb	BEGIN MGMT_HTTP_SESSION.session_expired(:1); END;
2mbgtjssndtz5	SELECT ID FROM WRI$_ADV_MESSAGE_GROUPS WHERE TASK_ID = :B9 AND SEQ = 0 AND MESSAGE# = :B8 AND FAC = :B7 AND HDR = 0 AND LM = 0 AND NL = 0 AND EXEC_NAME = :B6 AND NVL(:B5 , '~') = NVL(P1, '~') AND NVL(:B4 , '~') = NVL(P2, '~') AND NVL(:B3 , '~') = NVL(P3, '~') AND NVL(:B2 , '~') = NVL(P4, '~') AND NVL(:B1 , '~') = NVL(P5, '~')
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)
4dy1xm4nxc0gf	insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id
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 )
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'
6hwjmjgrpsuaa	insert into wrh$_enqueue_stat (snap_id, dbid, instance_number, eq_type, req_reason, total_req#, total_wait#, succ_req#, failed_req#, cum_wait_time, event#) select :snap_id, :dbid, :instance_number, eq_type, req_reason, total_req#, total_wait#, succ_req#, failed_req#, cum_wait_time, event# from v$enqueue_statistics where total_req# != 0 order by eq_type, req_reason
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
6xvp6nxs4a9n4	select nvl(sum(space), 0) from recyclebin$ where ts# = :1
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
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)
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)
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
a1xgxtssv5rrp	select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#
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
c4nhd1ntptxq7	select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4
csnp95dz2r8ss	select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dgyay259941s4	select /* four / /+ 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 retail.DWB_RTL_TRX t1 , retail.DWB_RTL_TRX t2 where t1.TRX_NBR = t2.TRX_NBR
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
fnk7155mk2jq6	insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv order by groupid, metricid, begtime
g4vrdfn14tp29	SELECT PROPERTY FROM SYS.WRI$_ADV_TASKS WHERE ID = :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.01	0.02
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	12	0.06	0.13
Batched IO buffer defrag count	1	0.01	0.01
Batched IO double miss count	2	0.01	0.02
Batched IO same unit count	7	0.04	0.07
Batched IO single block count	1	0.01	0.01
Batched IO vector block count	4	0.02	0.04
Batched IO vector read count	1	0.01	0.01
Block Cleanout Optim referenced	49	0.26	0.51
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	37,800	200.37	393.75
CPU used when call started	202,707	1,074.53	2,111.53
CR blocks created	21	0.11	0.22
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	14	0.07	0.15
DB time	141,240	748.70	1,471.25
DBWR checkpoint buffers written	268	1.42	2.79
DBWR checkpoints	1	0.01	0.01
DBWR fusion writes	19	0.10	0.20
DBWR transaction table writes	17	0.09	0.18
DBWR undo block writes	117	0.62	1.22
DFO trees parallelized	21	0.11	0.22
HSC Heap Segment Block Changes	349	1.85	3.64
Heap Segment Array Inserts	100	0.53	1.04
Heap Segment Array Updates	3	0.02	0.03
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	180,014	954.23	1,875.15
PX local messages sent	180,014	954.23	1,875.15
PX remote messages recv'd	525,758	2,786.98	5,476.65
PX remote messages sent	539,711	2,860.94	5,621.99
Parallel operations not downgraded	21	0.11	0.22
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment shrink	1	0.01	0.01
SQL*Net roundtrips to/from client	171	0.91	1.78
active txn count during cleanout	85	0.45	0.89
application wait time	1	0.01	0.01
background timeouts	1,160	6.15	12.08
branch node splits	0	0.00	0.00
buffer is not pinned count	4,772	25.30	49.71
buffer is pinned count	10,688	56.66	111.33
bytes received via SQL*Net from client	121,778	645.53	1,268.52
bytes sent via SQL*Net to client	39,274	208.19	409.10
calls to get snapshot scn: kcmgss	2,706	14.34	28.19
calls to kcmgas	18,294	96.97	190.56
calls to kcmgcs	120	0.64	1.25
cell blocks helped by minscn optimization	1,947,463	10,323.26	20,286.07
cell blocks processed by cache layer	1,947,463	10,323.26	20,286.07
cell blocks processed by data layer	1,947,463	10,323.26	20,286.07
cell blocks processed by txn layer	1,947,463	10,323.26	20,286.07
cell physical IO bytes eligible for predicate offload	15,901,335,552	84,291,037.02	165,638,912.00
cell physical IO interconnect bytes	37,735,132,272	200,029,325.90	393,074,294.50
cell scans	142	0.75	1.48
change write time	0	0.00	0.00
cleanout - number of ktugct calls	95	0.50	0.99
cleanouts and rollbacks - consistent read gets	26	0.14	0.27
cleanouts only - consistent read gets	5	0.03	0.05
cluster key scan block gets	237	1.26	2.47
cluster key scans	235	1.25	2.45
cluster wait time	6,601	34.99	68.76
commit batch/immediate performed	1	0.01	0.01
commit batch/immediate requested	1	0.01	0.01
commit cleanout failures: block lost	25	0.13	0.26
commit cleanout failures: callback failure	3	0.02	0.03
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	345	1.83	3.59
commit cleanouts successfully completed	317	1.68	3.30
commit immediate performed	1	0.01	0.01
commit immediate requested	1	0.01	0.01
commit txn count during cleanout	60	0.32	0.63
concurrency wait time	1,568	8.31	16.33
consistent changes	14,429	76.49	150.30
consistent gets	1,957,000	10,373.82	20,385.42
consistent gets - examination	2,556	13.55	26.63
consistent gets direct	1,941,081	10,289.43	20,219.59
consistent gets from cache	15,919	84.38	165.82
consistent gets from cache (fastpath)	12,943	68.61	134.82
cursor authentications	55	0.29	0.57
data blocks consistent reads - undo records applied	26	0.14	0.27
db block changes	16,748	88.78	174.46
db block gets	12,572	66.64	130.96
db block gets direct	0	0.00	0.00
db block gets from cache	12,572	66.64	130.96
db block gets from cache (fastpath)	673	3.57	7.01
deferred (CURRENT) block cleanout applications	187	0.99	1.95
dirty buffers inspected	2	0.01	0.02
enqueue conversions	433	2.30	4.51
enqueue releases	13,680	72.52	142.50
enqueue requests	13,755	72.91	143.28
enqueue timeouts	75	0.40	0.78
enqueue waits	489	2.59	5.09
exchange deadlocks	0	0.00	0.00
execute count	1,378	7.30	14.35
free buffer inspected	978	5.18	10.19
free buffer requested	18,581	98.50	193.55
gc CPU used by this session	193	1.02	2.01
gc blocks lost	0	0.00	0.00
gc cr block build time	0	0.00	0.00
gc cr block flush time	1	0.01	0.01
gc cr block receive time	4	0.02	0.04
gc cr block send time	1	0.01	0.01
gc cr blocks received	242	1.28	2.52
gc cr blocks served	214	1.13	2.23
gc current block flush time	2	0.01	0.02
gc current block pin time	1,531	8.12	15.95
gc current block receive time	1,991	10.55	20.74
gc current block send time	17	0.09	0.18
gc current blocks received	3,816	20.23	39.75
gc current blocks served	3,771	19.99	39.28
gc local grants	44	0.23	0.46
gc reader bypass grants	21	0.11	0.22
gc remote grants	81	0.43	0.84
gcs messages sent	10,172	53.92	105.96
ges messages sent	5,354	28.38	55.77
global enqueue get time	181	0.96	1.89
global enqueue gets async	340	1.80	3.54
global enqueue gets sync	14,013	74.28	145.97
global enqueue releases	13,470	71.40	140.31
heap block compress	4	0.02	0.04
hot buffers moved to head of LRU	25	0.13	0.26
immediate (CR) block cleanout applications	31	0.16	0.32
immediate (CURRENT) block cleanout applications	83	0.44	0.86
index crx upgrade (positioned)	52	0.28	0.54
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fetch by key	1,125	5.96	11.72
index scans kdiixs1	4,775	25.31	49.74
leaf node 90-10 splits	16	0.08	0.17
leaf node splits	22	0.12	0.23
lob reads	0	0.00	0.00
lob writes	2	0.01	0.02
lob writes unaligned	2	0.01	0.02
logons cumulative	179	0.95	1.86
messages received	28,806	152.70	300.06
messages sent	28,806	152.70	300.06
min active SCN optimization applied to CR	0	0.00	0.00
no work - consistent read gets	11,898	63.07	123.94
opened cursors cumulative	1,327	7.03	13.82
parse count (describe)	1	0.01	0.01
parse count (failures)	0	0.00	0.00
parse count (hard)	68	0.36	0.71
parse count (total)	738	3.91	7.69
parse time cpu	14	0.07	0.15
parse time elapsed	14	0.07	0.15
physical IO disk bytes	45,212,547,072	239,666,188.20	470,964,032.00
physical read IO requests	60,180	319.01	626.88
physical read bytes	25,578,020,864	135,585,963.61	266,437,717.33
physical read total IO requests	62,057	328.96	646.43
physical read total bytes	25,608,323,072	135,746,591.92	266,753,365.33
physical read total multi block requests	59,671	316.31	621.57
physical reads	3,122,317	16,551.02	32,524.14
physical reads cache	43	0.23	0.45
physical reads cache prefetch	0	0.00	0.00
physical reads direct	3,122,274	16,550.79	32,523.69
physical reads direct temporary tablespace	1,181,193	6,261.36	12,304.09
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	52,658	279.13	548.52
physical write bytes	9,795,502,080	51,924,759.76	102,036,480.00
physical write total IO requests	52,940	280.63	551.46
physical write total bytes	9,800,342,528	51,950,418.39	102,086,901.33
physical write total multi block requests	38,106	202.00	396.94
physical writes	1,195,740	6,338.47	12,455.63
physical writes direct	1,181,069	6,260.70	12,302.80
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	1,181,069	6,260.70	12,302.80
physical writes from cache	14,671	77.77	152.82
physical writes non checkpoint	1,184,505	6,278.92	12,338.59
pinned buffers inspected	105	0.56	1.09
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	0	0.00	0.00
queries parallelized	21	0.11	0.22
recursive calls	20,865	110.60	217.34
recursive cpu usage	37,511	198.84	390.74
redo blocks checksummed by FG (exclusive)	1,717	9.10	17.89
redo blocks written	2,494	13.22	25.98
redo entries	1,460	7.74	15.21
redo ordering marks	62	0.33	0.65
redo size	1,170,904	6,206.82	12,196.92
redo size for direct writes	0	0.00	0.00
redo subscn max counts	106	0.56	1.10
redo synch time	0	0.00	0.00
redo synch writes	2	0.01	0.02
redo wastage	14,100	74.74	146.88
redo write broadcast ack time	1	0.01	0.01
redo write time	3	0.02	0.03
redo writes	62	0.33	0.65
rollback changes - undo records applied	2	0.01	0.02
rollbacks only - consistent read gets	0	0.00	0.00
rows fetched via callback	599	3.18	6.24
session connect time	0	0.00	0.00
session cursor cache hits	822	4.36	8.56
session logical reads	1,969,572	10,440.46	20,516.38
shared hash latch upgrades - no wait	335	1.78	3.49
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	644	3.41	6.71
sorts (rows)	16,107	85.38	167.78
sql area evicted	21	0.11	0.22
sql area purged	0	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	5	0.03	0.05
table fetch by rowid	6,748	35.77	70.29
table fetch continued row	23	0.12	0.24
table scan blocks gotten	1,940,977	10,288.88	20,218.51
table scan rows gotten	238,337,916	1,263,400.17	2,482,686.63
table scans (direct read)	142	0.75	1.48
table scans (long tables)	142	0.75	1.48
table scans (rowid ranges)	142	0.75	1.48
table scans (short tables)	55	0.29	0.57
total number of times SMON posted	1	0.01	0.01
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	1	0.01	0.01
undo change vector size	390,232	2,068.57	4,064.92
user I/O wait time	24,320	128.92	253.33
user calls	1,074	5.69	11.19
user commits	23	0.12	0.24
user rollbacks	73	0.39	0.76
workarea executions - onepass	4	0.02	0.04
workarea executions - optimal	555	2.94	5.78
write clones created in background	14,382	76.24	149.81

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	39,986,151,856	45,071,198,472
session pga memory	351,443,495,728	351,858,020,832
session pga memory max	767,856,190,032	775,098,779,904
session cursor cache count	210,743	210,849
session uga memory	1,209,528,791,272	1,209,537,512,408
opened cursors current	71	71
logons current	44	47

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	Buffer Waits	Av Buf Wt(ms)
TEMP	38,129	202	1.71	30.98	52,480	278	25,436	2.20
SYSAUX	9	0	5.56	1.00	141	1	0	0.00
UNDOTBS4	0	0	0.00	0.00	36	0	0	0.00
RETAIL_20090531	1	0	10.00	1.00	0	0	0	0.00

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	Buffer Waits	Av Buf Wt(ms)
RETAIL_20090531	+DGA/retail_20090531.dbf	1	0	10.00	1.00	0	0	0	0.00
SYSAUX	+DGA/demo/datafile/sysaux.417.686904815	9	0	5.56	1.00	141	1	0	0.00
TEMP	+DGA/demo/tempfile/temp.419.686904819	38,129	202	1.71	30.98	52,480	278	25,436	2.20
UNDOTBS4	+DGA/demo/datafile/undotbs4.422.686904827	0	0			36	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	585,893	100	28,561	42	14,671	0	0	25,437

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	441	2474	9721	1887390	9721
E	0	0	535	2884	11443	1887390	11443

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.49	17,909,755
D	896	0.18	106,526	1.08	12,957,254
D	1,344	0.27	159,789	1.02	12,314,823
D	1,792	0.36	213,052	1.00	12,036,080
D	2,240	0.45	266,315	1.00	12,035,751
D	2,688	0.55	319,578	1.00	12,034,117
D	3,136	0.64	372,841	1.00	12,033,866
D	3,584	0.73	426,104	1.00	12,032,955
D	4,032	0.82	479,367	1.00	12,030,584
D	4,480	0.91	532,630	1.00	12,029,971
D	4,928	1.00	585,893	1.00	12,029,877
D	5,376	1.09	639,156	1.00	12,029,798
D	5,824	1.18	692,419	1.00	12,029,626
D	6,272	1.27	745,682	1.00	12,029,186
D	6,720	1.36	798,945	1.00	12,028,966
D	7,168	1.45	852,208	1.00	12,028,369
D	7,616	1.55	905,471	1.00	12,027,647
D	8,064	1.64	958,734	1.00	12,026,720
D	8,512	1.73	1,011,997	0.92	11,054,444
D	8,960	1.82	1,065,260	0.92	11,053,392

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
50.08	7,286	7,263

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,882	394.12	0.00	0.00	0.00	0.00	1,048,576
E	12,288	10,807	429.04	0.00	0.00	0.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	1-Pass Execs
2K	4K	529	529	0
64K	128K	5	5	0
512K	1024K	21	21	0
1M	2M	4	4	0
1G	2G	4	0	4

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd Time
1,536	0.13	13,836.91	7,494.80	65.00	5,969,057
3,072	0.25	13,836.91	7,494.80	65.00	5,969,057
6,144	0.50	13,836.91	7,494.80	65.00	5,969,057
9,216	0.75	13,836.91	7,494.80	65.00	5,969,057
12,288	1.00	13,836.91	7,494.80	65.00	5,969,057
14,746	1.20	13,836.91	7,262.95	66.00	5,904,182
17,203	1.40	13,836.91	7,262.95	66.00	5,904,182
19,661	1.60	13,836.91	7,262.95	66.00	5,904,182
22,118	1.80	13,836.91	7,262.95	66.00	5,904,182
24,576	2.00	13,836.91	7,262.95	66.00	5,904,182
36,864	3.00	13,836.91	7,262.95	66.00	5,904,182
49,152	4.00	13,836.91	7,262.95	66.00	5,904,182
73,728	6.00	13,836.91	7,262.95	66.00	5,904,182
98,304	8.00	13,836.91	7,262.95	66.00	5,904,182

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	56	5,182	1.00	77	1.00	6
1,024	1.00	130	9,202	5,182	1.00	77	1.00	1,009
1,152	1.13	133	9,955	5,182	1.00	77	1.00	1,009
1,280	1.25	133	9,955	5,182	1.00	77	1.00	1,009
1,408	1.38	133	9,955	5,182	1.00	77	1.00	1,009
1,536	1.50	133	9,955	5,182	1.00	77	1.00	1,009
1,664	1.63	133	9,955	5,182	1.00	77	1.00	1,009
1,792	1.75	133	9,955	5,182	1.00	77	1.00	1,009
1,920	1.88	133	9,955	5,182	1.00	77	1.00	1,009
2,048	2.00	133	9,955	5,182	1.00	77	1.00	1,009

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	32,646	17,910,072
2,304	0.38	22,730	12,957,374
3,072	0.50	20,885	12,035,886
3,840	0.63	20,880	12,034,683
4,608	0.75	20,878	12,033,480
5,376	0.88	20,872	12,029,871
6,144	1.00	20,872	12,029,871
6,912	1.13	20,872	12,029,871
7,680	1.25	20,872	12,028,668
8,448	1.38	20,868	12,027,465
9,216	1.50	20,807	11,054,248
9,984	1.63	20,807	11,054,248
10,752	1.75	20,807	11,053,045
11,520	1.88	20,807	11,053,045
12,288	2.00	20,807	11,053,045

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
file header block	25,427	56	2
bitmap index block	9	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
PS-PX Process Reservation	785	773	12	388	1	1.29
CO-KTUCLO Master Slave enq (master slave det)	63	0	63	63	0	1.90
WF-AWR Flush	20	20	0	13	0	6.15
XL-ASM Extent Fault Lock (fault extent map)	38	38	0	2	0	15.00
PV-KSV slave startup (syncstart)	5	5	0	1	0	10.00
TA-Instance Undo	1	1	0	1	0	10.00
CF-Controlfile Transaction	432	432	0	18	0	0.00
KO-Multiple Object Checkpoint (fast object checkpoint)	9	9	0	4	0	0.00
AF-Advisor Framework (task serialization)	13	13	0	2	0	0.00
SW-Suspend Writes	3	3	0	1	0	0.00
TD-KTF map table enqueue (KTF dump entries)	1	1	0	1	0	0.00
TK-Auto Task Serialization (Auto Task Serialization)	1	1	0	1	0	0.00
TX-Transaction (index contention)	2	2	0	1	0	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 allocation	31	0.00		0
ASM db client latch	173	0.00		0
ASM map headers	117	0.00		0
ASM map load waiting list	51	0.00		0
ASM map operation freelist	4,906	0.26	0.31	0
ASM map operation hash table	466,367	0.00	0.00	0
ASM network background latch	331	0.00		0
AWR Alerted Metric Element list	1,538	0.00		0
Change Notification Hash table latch	63	0.00		0
Consistent RBA	62	0.00		0
DML lock allocation	756	0.00		0
Event Group Locks	5	0.00		0
FIB s.o chain latch	6	0.00		0
FOB s.o list latch	145	0.00		0
File State Object Pool Parent Latch	1	0.00		0
IPC stats buffer allocation latch	518	0.00		610	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	1	0.00		0
JS broadcast add buf latch	43	0.00		0
JS broadcast drop buf latch	43	0.00		0
JS broadcast load blnc latch	37	0.00		0
JS queue access latch	1	0.00		0
JS queue state obj latch	1,998	0.00		0
JS slv state obj latch	1	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	1,540	0.00		0
KFMD SGA	4,185	0.17	0.14	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	4,733	0.02	0.00	610	0.00
KJCT flow control latch	27,944	0.05	0.00	0
KMG MMAN ready and startup request latch	63	0.00		0
KSXR large replies	8	0.00		0
KTF sga latch	6	0.00		60	0.00
KWQMN job cache list latch	20	0.00		0
KWQS pqsubs latch	8	0.00		0
KWQS pqueue ctx latch	1	0.00		0
Locator state objects pool parent latch	1	0.00		0
MQL Tracking Latch	0			4	0.00
Memory Management Latch	1	0.00		63	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	2,325	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	28	0.00		0
OS process allocation	84	0.00		0
OS process: request allocation	5	0.00		0
PL/SQL warning settings	202	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	60	3.33	1.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		63	0.00
SQL memory manager workarea list latch	4,398	0.00		0
Shared B-Tree	17	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	28,518	0.00		0
active service list	4,995	0.06	1.00	71	0.00
archive control	19	0.00		0
buffer pool	1	0.00		0
business card	45	0.00		0
cache buffer handles	98	0.00		0
cache buffers chains	241,731	0.30	0.44	5,883	0.14
cache buffers lru chain	90,717	0.01	0.00	9,274	0.02
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	10	0.00		0
channel operations parent latch	107,063	0.00	0.00	0
checkpoint queue latch	475,672	0.00		457	0.00
client/application info	927	0.00		0
commit callback allocation	3	0.00		0
compile environment latch	180	0.00		0
corrupted undo seg lock	7	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	4	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	4	0.00		0
dml lock allocation	4	0.00		0
done queue latch	1	0.00		0
dummy allocation	358	0.28	0.00	0
enqueue hash chains	49,608	0.06	0.03	1	0.00
enqueues	26,350	0.07	0.00	0
error message lists	420	0.00		0
fifth spare latch	1	0.00		0
file cache latch	1,122	0.00		0
flashback copy	1	0.00		0
gc element	52,988	0.05	0.28	103	0.00
gcs commit scn state	1	0.00		0
gcs opaque info freelist	944	0.00		0
gcs partitioned table hash	533,657	0.00	0.00	39	0.00
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	10	0.00		0
gcs remastering latch	117	0.00		0
gcs resource freelist	21	0.00		8	0.00
gcs resource hash	46,825	0.01	0.33	0
gcs resource scan list	1	0.00		0
gcs shadows freelist	296	0.00		324	0.00
ges caches resource lists	9,785	0.00		3,469	0.00
ges deadlock list	886	0.00		0
ges domain table	27,087	0.00		0
ges enqueue table freelist	29,056	0.00	0.00	0
ges group table	40,877	0.00	0.00	0
ges process hash list	20,801	0.00		0
ges process parent latch	59,325	0.00	0.00	0
ges process table freelist	5	0.00		0
ges resource hash list	52,029	0.19	0.08	1,238	0.65
ges resource scan list	7	0.00		0
ges resource table freelist	2,191	0.00		0
ges timeout list	640	0.00		101	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			2,070	0.00
hash table modification latch	4	0.00		0
heartbeat check	1	0.00		37	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		0
job_queue_processes parameter latch	40	0.00		0
k2q global data latch	126	0.00		0
k2q lock allocation	1	0.00		0
kcfis stats shared latch	4	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kks stats	241	0.00		0
kokc descriptor allocation latch	154	0.00		0
ksfv messages	1	0.00		0
ksim membership request latch	76	0.00		188	0.00
kss move lock	9	0.00		0
ksuosstats global area	16	0.00		0
ksv allocation latch	17	0.00		0
ksv class latch	630	0.16	2.00	0
ksv instance latch	8	0.00		0
ksv msg queue latch	55	0.00		54	0.00
ksxp shared latch	5	0.00		0
ksz_so allocation latch	18	0.00		0
ktm global data	4	0.00		0
kwqbsn:qsga	7	0.00		0
lgwr LWN SCN	116	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	9	0.00		8	0.00
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	2,036	0.00		0
messages	88,530	0.29	0.00	0
mostly latch-free SCN	116	0.00		0
msg queue latch	1	0.00		0
multiblock read objects	16	0.00		0
name-service memory objects	880	0.00		0
name-service namespace bucket	1,867	0.00		0
name-service pending queue	110	0.00		0
name-service request queue	2,382	0.00		0
ncodef allocation latch	4	0.00		0
object queue header heap	114,779	0.00		915	0.00
object queue header operation	222,699	0.00	0.00	0
object stats modification	160	0.63	0.00	0
parallel query alloc buffer	3,299	0.06	0.00	0
parallel query stats	243	0.00		0
parallel txn reco latch	1,053	0.00		0
parameter list	22	0.00		0
parameter table management	357	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	7,955	0.01	0.00	59	0.00
process allocation	853	0.00		4	0.00
process group creation	5	0.00		0
process queue	1,445	0.00		0
process queue reference	27,506,194	0.00	0.01	1,266,079	0.74
qmn task queue latch	31	3.23	0.00	0
query server freelists	1,073	0.00		0
queued dump request	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	295	0.00		1,455	0.00
redo copy	1	0.00		1,455	0.00
redo writing	28,771	0.00		0
reid allocation latch	13	0.00		0
resmgr group change latch	337	0.00		0
resmgr:active threads	358	0.00		0
resmgr:actses change group	181	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	357	0.28	1.00	0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	6	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	24,800	0.00		42	0.00
rules engine aggregate statistics	1	0.00		0
rules engine rule set statistics	2	0.00		0
second spare latch	1	0.00		0
segmented array pool	6	0.00		0
sequence cache	35	0.00		0
session allocation	16,684	0.12	0.85	0
session idle bit	2,275	0.00		0
session queue latch	1	0.00		0
session state list latch	360	0.56	0.50	0
session switching	5	0.00		0
session timer	71	0.00		0
shared pool	15,873	0.27	0.12	0
shared pool sim alloc	5	0.00		0
shared pool simulator	487	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	1,184	0.00		0
simulator lru latch	1	0.00		1,165	0.00
sort extent pool	30,622	0.07	0.00	0
space background task latch	139	0.00		126	0.00
state object free list	2	0.00		0
statistics aggregation	1,568	0.00		0
storage server table manipulation latch	122	0.00		0
tablespace key chain	300	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	89	0.00		0
transaction allocation	11	0.00		0
undo global data	708	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
cache buffers chains	241,731	724	318	425
process queue reference	27,506,194	435	4	432
ges resource hash list	52,029	98	8	90
shared pool	15,873	43	5	38
enqueue hash chains	49,608	31	1	30
gc element	52,988	29	8	22
session allocation	16,684	20	17	7
ASM map operation freelist	4,906	13	4	10
KFMD SGA	4,185	7	1	6
active service list	4,995	3	3	1
gcs resource hash	46,825	3	1	2
Real-time plan statistics latch	60	2	2	0
session state list latch	360	2	1	1
ksv class latch	630	1	2	0
resmgr:free threads list	357	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
ASM map operation freelist	kffmTranslate2	4	4
KFMD SGA	kfmdGetPriReidInfo	1	1
Real-time plan statistics latch	keswxAddNewPlanEntry	2	2
active service list	ksws_event: ksws event	3	1
cache buffers chains	kcbbxsv	254	7
cache buffers chains	kcbgcur_2	80	29
cache buffers chains	kcbzwb	14	92
cache buffers chains	kcbrls_2	8	0
cache buffers chains	kclbla	8	17
cache buffers chains	kcbbic2	6	19
cache buffers chains	kclpdc_1	4	2
cache buffers chains	kcbbic1	2	11
cache buffers chains	kcbzgb: scan from tail. nowait	2	0
cache buffers chains	kclwlr	2	2
cache buffers chains	kcbgcur_1	1	0
cache buffers chains	kcbrlb1	1	194
cache buffers chains	kcbzib: finish free bufs	1	1
enqueue hash chains	ksqrcl	1	1
gc element	kclpdc_3	8	0
gc element	kclebs	1	1
gc element	kclnfndnewm	1	9
gc element	kclpdcl	1	0
gcs resource hash	kjbassume	1	0
ges resource hash list	kjuscl: lock close request	6	4
ges resource hash list	kjakcai: search for resp by resname	1	0
ges resource hash list	kjrmas1: lookup master node	1	0
ksv class latch	ksvclsl: rdp - recycle	2	0
process queue reference	kxfpqrsnd	4	0
resmgr:free threads list	kskthrcreate	1	1
session allocation	ksuxds: KSUSFCLC not set	15	1
session allocation	kxfpqidqr:1	1	11
session allocation	kxfprdp	1	5
session state list latch	kpseqa	1	1
shared pool	kghalo	5	5

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kglget2 2	7
Library Cache	kglpin1 4	3
Library Cache	kglpnal2 91	3
Library Cache	kglhdgn1 62	2
Library Cache	kglhdgn2 106	1
Library Cache	kglpndl1 95	1

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by 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: 1,969,572
Captured Segments account for 98.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
RETAIL	RETAIL_20090524	DWB_RTL_TRX	R20090524	TABLE PARTITION	107,488	5.46
RETAIL	RETAIL_20090503	DWB_RTL_TRX	R20090503	TABLE PARTITION	103,648	5.26
RETAIL	RETAIL_20090506	DWB_RTL_TRX	R20090506	TABLE PARTITION	101,136	5.13
RETAIL	RETAIL_20090515	DWB_RTL_TRX	R20090515	TABLE PARTITION	97,600	4.96
RETAIL	RETAIL_20090521	DWB_RTL_TRX	R20090521	TABLE PARTITION	92,768	4.71

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 3,122,317
Captured Segments account for 61.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
RETAIL	RETAIL_20090506	DWB_RTL_TRX	R20090506	TABLE PARTITION	96,376	3.09
RETAIL	RETAIL_20090521	DWB_RTL_TRX	R20090521	TABLE PARTITION	95,942	3.07
RETAIL	RETAIL_20090524	DWB_RTL_TRX	R20090524	TABLE PARTITION	95,766	3.07
RETAIL	RETAIL_20090515	DWB_RTL_TRX	R20090515	TABLE PARTITION	95,490	3.06
RETAIL	RETAIL_20090510	DWB_RTL_TRX	R20090510	TABLE PARTITION	83,116	2.66

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 3,122,274
Captured Segments account for 61.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
RETAIL	RETAIL_20090506	DWB_RTL_TRX	R20090506	TABLE PARTITION	96,376	3.09
RETAIL	RETAIL_20090521	DWB_RTL_TRX	R20090521	TABLE PARTITION	95,942	3.07
RETAIL	RETAIL_20090524	DWB_RTL_TRX	R20090524	TABLE PARTITION	95,766	3.07
RETAIL	RETAIL_20090515	DWB_RTL_TRX	R20090515	TABLE PARTITION	95,490	3.06
RETAIL	RETAIL_20090510	DWB_RTL_TRX	R20090510	TABLE PARTITION	83,244	2.67

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 1,195,740
Captured Segments account for 0.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM	975138_895	TABLE PARTITION	7
SYS	SYSAUX	WRH$_BG_EVENT_SUMMARY		TABLE	4
SYS	SYSAUX	WRH$_SYSTEM_EVENT	975138_895	TABLE PARTITION	4
SYS	SYSAUX	WRI$_ADV_PARAMETERS_PK		INDEX	4
SYS	SYSAUX	WRH$_BG_EVENT_SUMMARY_PK		INDEX	3

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: 142
Captured Segments account for 99.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
RETAIL	RETAIL_20090506	DWB_RTL_TRX	R20090506	TABLE PARTITION	7	4.93
RETAIL	RETAIL_20090515	DWB_RTL_TRX	R20090515	TABLE PARTITION	7	4.93
RETAIL	RETAIL_20090521	DWB_RTL_TRX	R20090521	TABLE PARTITION	7	4.93
RETAIL	RETAIL_20090524	DWB_RTL_TRX	R20090524	TABLE PARTITION	7	4.93
RETAIL	RETAIL_20090501	DWB_RTL_TRX	R20090501	TABLE PARTITION	6	4.23

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	WRI$_ADV_PARAMETERS		TABLE	144	15.79
SYS	SYSAUX	WRI$_ADV_PARAMETERS_PK		INDEX	144	15.79
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	975138_895	INDEX PARTITION	64	7.02
SYS	SYSAUX	WRH$_ENQUEUE_STAT_PK		INDEX	32	3.51
SYS	SYSAUX	WRH$_LATCH	975138_895	TABLE PARTITION	32	3.51

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared
with total row lock waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	975138_895	INDEX PARTITION	2	100.00

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: 242
Captured Segments account for 78.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSAUX	WRM$_DATABASE_INSTANCE		TABLE	24	9.92
SYS	SYSTEM	HISTGRM$		TABLE	18	7.44
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	12	4.96
SYS	SYSAUX	WRH$_SYS_TIME_MODEL	975138_895	TABLE PARTITION	11	4.55
SYS	SYSAUX	WRM$_SNAPSHOT		TABLE	10	4.13

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 3,816
Captured Segments account for 6.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	975138_895	INDEX PARTITION	52	1.36
SYS	SYSTEM	I_FILE#_BLOCK#		INDEX	14	0.37
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	975138_895	INDEX PARTITION	13	0.34
SYS	SYSAUX	WRM$_SNAPSHOT		TABLE	11	0.29
SYS	SYSAUX	WRH$_TS_SPACE_USAGE_IND		INDEX	10	0.26

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	7	0.00	2	1
dc_global_oids	101	0.00	0	147
dc_histogram_data	833	8.52	0	2,797
dc_histogram_defs	1,770	7.63	0	4,902
dc_object_grants	16	0.00	0	95
dc_objects	992	4.33	0	4,778
dc_rollback_segments	2,304	0.00	0	1,055
dc_segments	319	13.17	0	1,229
dc_sequences	4	50.00	4	2
dc_tablespaces	760	0.00	0	49
dc_users	525	0.00	0	101
global database name	175	0.00	0	1
outstanding_alerts	43	93.02	1	6

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	135	0	36
dc_objects	31	0	0
dc_segments	42	4	2
dc_sequences	8	2	0
outstanding_alerts	85	40	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	27	0.00	0
CLUSTER	2	0.00	1	0.00	0
INDEX	20	25.00	17	29.41	0
SQL AREA	371	3.77	2,701	6.03	4
TABLE/PROCEDURE	586	0.85	1,305	5.67	51

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	767	892

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,928.00	4,928.00	INI/
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	64.00	STA/
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	358.27		3.12	6.35	32	32	115	115
	Freeable	28.38	0.00	1.35	1.62	7		21	21
	SQL	7.18	5.23	0.30	1.23	6	13	24	17
	PL/SQL	0.33	0.21	0.01	0.01	0	0	49	48
E	Other	385.32		3.27	6.26	32	37	118	118
	Freeable	36.25	0.00	1.25	1.37	7		29	29
	SQL	7.18	5.24	0.22	1.07	6	1,185	32	17
	PL/SQL	0.34	0.21	0.01	0.01	0	0	60	51

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	16.88	17.21	1.95
shared	FileOpenBlock	11.21	11.21	0.00
shared	KCL name table	48.00	48.00	0.00
shared	PCursor	10.47	10.42	-0.55
shared	PL/SQL DIANA	19.06	19.00	-0.33
shared	PL/SQL MPCODE	13.82	13.82	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	322.62	319.79	-0.88
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	20.96	20.96	0.00
shared	sessions	11.96	11.96	0.00
shared	sql area	88.90	90.39	1.68
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

only rows with Current or Maximum Utilization > 80% of Limit are shown
ordered by resource name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
gcs_resources	82,665	710,750	708930	708930
gcs_shadows	83,596	582,023	708930	708930

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)
filesystemio_options	setall
instance_number	4
local_listener	LISTENER_DEMO4
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	FORCE:
service_names	D_FOUR, D_EIGHT, D4, DEMO
sessions	1131
sga_target	6442450944
spfile	+DGA/demo/spfiledemo.ora
thread	4
undo_tablespace	UNDOTBS4

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	694	3.68	7.23
acks for commit broadcast(logical)	695	3.68	7.24
broadcast msgs on commit(actual)	413	2.19	4.30
broadcast msgs on commit(logical)	413	2.19	4.30
broadcast msgs on commit(wasted)	24	0.13	0.25
broadcast on commit wait time(ms)	0	0.00	0.00
broadcast on commit waits	12	0.06	0.13
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	3	0.02	0.03
flow control messages sent	0	0.00	0.00
gcs assume cvt	1	0.01	0.01
gcs assume no cvt	337	1.79	3.51
gcs ast xid	0	0.00	0.00
gcs blocked converts	300	1.59	3.13
gcs blocked cr converts	250	1.33	2.60
gcs compatible basts	76	0.40	0.79
gcs compatible cr basts (global)	55	0.29	0.57
gcs compatible cr basts (local)	49	0.26	0.51
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	14	0.07	0.15
gcs dbwr write request msgs	12	0.06	0.13
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	5	0.03	0.05
gcs immediate (null) converts	10	0.05	0.10
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	0	0.00	0.00
gcs indirect ast	94	0.50	0.98
gcs indirect bidless ast	24	0.13	0.25
gcs indirect fg ast	77	0.41	0.80
gcs lms flush pi msgs	72	0.38	0.75
gcs lms write request msgs	43	0.23	0.45
gcs msgs process time(ms)	131	0.69	1.36
gcs msgs received	6,674	35.38	69.52
gcs new served by master	0	0.00	0.00
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	0	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs queued converts	1	0.01	0.01
gcs reader bypass N->Xw ping local	0	0.00	0.00
gcs reader bypass N->Xw ping remote	20	0.11	0.21
gcs reader bypass grant X on assume	20	0.11	0.21
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	18	0.10	0.19
gcs reader bypass grant immediate	10	0.05	0.10
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	166	0.88	1.73
gcs retry convert request	0	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	288	1.53	3.00
gcs side channel msgs logical	4,098	21.72	42.69
gcs stale cr	0	0.00	0.00
gcs undo cr	1	0.01	0.01
gcs write notification msgs	0	0.00	0.00
gcs writes refused	3	0.02	0.03
ges msgs process time(ms)	38	0.20	0.40
ges msgs received	5,758	30.52	59.98
global posts dropped	0	0.00	0.00
global posts queue time	1,247	6.61	12.99
global posts queued	7	0.04	0.07
global posts requested	7	0.04	0.07
global posts sent	7	0.04	0.07
implicit batch messages received	149	0.79	1.55
implicit batch messages sent	269	1.43	2.80
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	745	3.95	7.76
messages queue sent actual	8,906	47.21	92.77
messages queue sent logical	9,236	48.96	96.21
messages received actual	11,881	62.98	123.76
messages received logical	12,432	65.90	129.50
messages sent directly	5,329	28.25	55.51
messages sent indirectly	5,173	27.42	53.89
messages sent not implicit batched	8,637	45.78	89.97
messages sent pbatched	4,866	25.79	50.69
msgs causing lmd to send msgs	2,478	13.14	25.81
msgs causing lms(s) to send msgs	643	3.41	6.70
msgs received queue time (ms)	3	0.02	0.03
msgs received queued	12,432	65.90	129.50
msgs sent queue time (ms)	152,933,711	810,682.92	1,593,059.49
msgs sent queue time on ksxp (ms)	1,236	6.55	12.88
msgs sent queued	9,235	48.95	96.20
msgs sent queued on ksxp	14,244	75.51	148.38
process batch messages received	6,755	35.81	70.36
process batch messages sent	4,137	21.93	43.09

Global CR Served Stats

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

Global CURRENT Served Stats

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

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s
Pins	3,760	61.73	22.98	15.21	0.08
Flushes	8	87.50	12.50	0.00	0.00
Writes	19	31.58	68.42	0.00	0.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
3	Others	3	100.00	0.00	0.00	3,417	83.17	16.83	0.00
2	data block	43	100.00	0.00	0.00	89	100.00	0.00	0.00
8	data block	33	93.94	6.06	0.00	83	100.00	0.00	0.00
6	data block	16	100.00	0.00	0.00	65	100.00	0.00	0.00
1	data block	29	100.00	0.00	0.00	34	100.00	0.00	0.00
7	data block	22	100.00	0.00	0.00	23	95.65	4.35	0.00
2	Others	7	100.00	0.00	0.00	36	97.22	2.78	0.00
8	undo header	27	100.00	0.00	0.00	1	100.00	0.00	0.00
3	data block	12	100.00	0.00	0.00	14	100.00	0.00	0.00
5	data block	5	100.00	0.00	0.00	17	100.00	0.00	0.00
1	Others	10	100.00	0.00	0.00	5	100.00	0.00	0.00
8	Others	4	100.00	0.00	0.00	7	100.00	0.00	0.00
7	Others	5	100.00	0.00	0.00	1	100.00	0.00	0.00
6	Others	3	100.00	0.00	0.00	2	100.00	0.00	0.00
2	undo header	3	100.00	0.00	0.00	2	100.00	0.00	0.00
6	undo header	0				5	100.00	0.00	0.00
1	undo header	2	100.00	0.00	0.00	1	100.00	0.00	0.00
3	undo header	2	100.00	0.00	0.00	0
5	undo header	1	100.00	0.00	0.00	1	100.00	0.00	0.00
8	undo block	1	100.00	0.00	0.00	0
7	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)
3	others	0.13	0.13		5.81	3.17	18.82
2	data block	0.16	0.16		0.19	0.19
8	data block	0.28	0.22	1.34	0.18	0.18
6	data block	0.29	0.29		0.26	0.26
1	data block	0.19	0.19		0.19	0.19
7	data block	0.21	0.21		0.22	0.19	0.99
2	others	0.15	0.15		0.73	0.72	0.92
8	undo header	0.11	0.11		0.15	0.15
3	data block	0.17	0.17		0.20	0.20
5	data block	0.16	0.16		0.18	0.18
1	others	0.17	0.17		0.18	0.18
8	others	0.14	0.14		0.16	0.16
7	others	0.16	0.16		0.16	0.16
2	undo header	0.12	0.12		0.16	0.16
6	undo header				0.15	0.15
6	others	0.20	0.20		0.43	0.43
1	undo header	0.12	0.12		0.16	0.16
5	undo header	0.12	0.12		0.23	0.23
3	undo header	0.12	0.12
7	undo header	0.11	0.11
8	undo block	0.12	0.12
7	undo block
1	undo block
6	undo block
5	others
2	undo block
3	undo block
5	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
3	others	0	3	100.00	0.00	2,842	0.00	100.00
2	data block	0	43	23.26	76.74	89	34.83	65.17
8	data block	0	31	25.81	74.19	83	48.19	51.81
6	data block	0	16	18.75	81.25	65	24.62	75.38
1	data block	0	29	20.69	79.31	34	35.29	64.71
7	data block	0	22	9.09	90.91	22	36.36	63.64
2	others	0	7	42.86	57.14	35	5.71	94.29
8	undo header	0	27	100.00	0.00	1	100.00	0.00
3	data block	0	12	0.00	100.00	14	50.00	50.00
5	data block	0	5	40.00	60.00	17	35.29	64.71
1	others	0	10	20.00	80.00	5	0.00	100.00
8	others	0	4	75.00	25.00	7	85.71	14.29
7	others	0	5	0.00	100.00	1	0.00	100.00
2	undo header	0	3	100.00	0.00	2	100.00	0.00
6	undo header	0	0			5	80.00	20.00
6	others	0	3	0.00	100.00	2	0.00	100.00
1	undo header	0	2	100.00	0.00	1	100.00	0.00
5	undo header	0	1	100.00	0.00	1	100.00	0.00
3	undo header	0	2	100.00	0.00	0
7	undo header	0	1	100.00	0.00	0
8	undo block	0	1	100.00	0.00	0
7	undo block	0	0			0
1	undo block	0	0			0
6	undo block	0	0			0
5	others	0	0			0
2	undo block	0	0			0
3	undo block	0	0			0
5	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)
3	others	0.13	0.13		3.17		3.17
2	data block	0.16	0.15	0.17	0.19	0.14	0.21
8	data block	0.22	0.13	0.24	0.18	0.14	0.22
6	data block	0.29	0.13	0.33	0.26	0.32	0.24
1	data block	0.19	0.13	0.20	0.19	0.18	0.19
7	data block	0.21	0.11	0.22	0.19	0.15	0.21
2	others	0.15	0.13	0.17	0.72	0.28	0.75
8	undo header	0.11	0.11		0.15	0.15
3	data block	0.17		0.17	0.20	0.17	0.23
5	data block	0.16	0.16	0.17	0.18	0.14	0.21
1	others	0.17	0.16	0.18	0.18		0.18
8	others	0.14	0.13	0.19	0.16	0.15	0.19
7	others	0.16		0.16	0.16		0.16
2	undo header	0.12	0.12		0.16	0.16
6	undo header				0.15	0.14	0.19
6	others	0.20		0.20	0.43		0.43
1	undo header	0.12	0.12		0.16	0.16
5	undo header	0.12	0.12		0.23	0.23
3	undo header	0.12	0.12
7	undo header	0.11	0.11
8	undo block	0.12	0.12
7	undo block
1	undo block
6	undo block
5	others
2	undo block
3	undo block
5	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	8	0.48	0.09	8	0.55	0.08
2	8	0.96	0.76	8	1.05	0.82
3	8	0.42	0.13	8	0.50	0.10
4	8	0.36	0.09	8	0.37	0.08
5	8	0.44	0.14	8	0.53	0.02
6	8	0.43	0.10	8	0.51	0.06
7	8	0.52	0.10	8	0.55	0.06
8	8	0.46	0.13	8	0.53	0.05

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.16	0.17
Parallel Query	45.05	43.91
DB Locks	0.02	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.170	NO	Oracle Cluster Repository	0.01	0	0	0	0	0.01	0	0	0	0

Back to Interconnect Stats
Back to Top

End of Report

Buffer Nowait %:	10.72	Redo NoWait %:	100.00
Buffer Hit %:	99.85	In-memory Sort %:	100.00
Library Hit %:	94.03	Soft Parse %:	90.79
Execute to Parse %:	46.44	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	0.01	% Non-Parse CPU:	99.96

Buffer access - local cache %:	85.61
Buffer access - remote cache %:	14.24
Buffer access - disk %:	0.15

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):	5.2
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 %:	2.3
Avg global cache cr block flush time (ms):	2.0
Avg global cache current block pin time (ms):	4.1
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.2
Avg global cache current block flush time (ms):	2.5

Avg message sent queue time (ms):	16,560.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:	47.38
% of indirect sent messages:	45.99
% of flow controlled messages:	6.62