WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

DEMO 3430975138 DEMO4 4 30-Jun-09 12:06 11.1.0.7.0 YES

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

Host Name Platform CPUs Cores Sockets Memory (GB)

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

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

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1045 02-Jul-09 13:04:52 45 3.0

End Snap: 1046 02-Jul-09 13:06:13 45 3.0

Elapsed: 1.35 (mins)

DB Time: 4.25 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1045	02-Jul-09 13:04:52	45	3.0
End Snap:	1046	02-Jul-09 13:06:13	45	3.0
Elapsed:		1.35 (mins)
DB Time:		4.25 (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.2 3.6 0.20 0.39

DB CPU(s): 2.6 3.0 0.16 0.32

Redo size: 15,670.9 18,155.7

Logical reads: 23,878.4 27,664.5

Block changes: 33.4 38.7

Physical reads: 25,264.5 29,270.3

Physical writes: 1,766.7 2,046.8

User calls: 8.1 9.4

Parses: 5.8 6.7

Hard parses: 0.9 1.0

W/A MB processed: 24,113,401.4 27,936,753.4

Logons: 1.0 1.2

Executes: 15.5 18.0

Rollbacks: 0.5 0.6

Transactions: 0.9

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	3.2	3.6	0.20	0.39
DB CPU(s):	2.6	3.0	0.16	0.32
Redo size:	15,670.9	18,155.7
Logical reads:	23,878.4	27,664.5
Block changes:	33.4	38.7
Physical reads:	25,264.5	29,270.3
Physical writes:	1,766.7	2,046.8
User calls:	8.1	9.4
Parses:	5.8	6.7
Hard parses:	0.9	1.0
W/A MB processed:	24,113,401.4	27,936,753.4
Logons:	1.0	1.2
Executes:	15.5	18.0
Rollbacks:	0.5	0.6
Transactions:	0.9

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 95.32 Soft Parse %: 85.04

Execute to Parse %: 62.83 Latch Hit %: 99.99

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

Shared Pool Statistics

Begin End

Memory Usage %: 75.34 75.31

% SQL with executions>1: 92.33 93.94

% Memory for SQL w/exec>1: 89.72 91.47

	Begin	End
Memory Usage %:	75.34	75.31
% SQL with executions>1:	92.33	93.94
% Memory for SQL w/exec>1:	89.72	91.47

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		207		81.32
cell smart table scan	11,182	22	2	8.53	User I/O
direct path read temp	4,612	9	2	3.51	User I/O
direct path write temp	4,612	8	2	2.95	User I/O
reliable message	144	6	44	2.47	Other

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

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

0.05 2.16 31.6 1.4 0.0 66.8

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.05	2.16	31.6	1.4	0.0	66.8

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

32.2 96.9 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
32.2	96.9	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): 388.0 419.7

% Host Mem used for SGA+PGA: 20.29 20.29

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

RAC Statistics

Begin End

Number of Instances: 8 8

	Begin	End
Number of Instances:	8	8

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 28.96 33.56

Global Cache blocks served: 10.28 11.91

GCS/GES messages received: 100.88 116.87

GCS/GES messages sent: 129.25 149.74

DBWR Fusion writes: 3.64 4.21

Estd Interconnect traffic (KB) 358.93

	Per Second	Per Transaction
Global Cache blocks received:	28.96	33.56
Global Cache blocks served:	10.28	11.91
GCS/GES messages received:	100.88	116.87
GCS/GES messages sent:	129.25	149.74
DBWR Fusion writes:	3.64	4.21
Estd Interconnect traffic (KB)	358.93

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

Buffer access - local cache %: 92.06

Buffer access - remote cache %: 7.66

Buffer access - disk %: 0.28

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1

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

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

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

Avg global cache cr block send time (ms): 0.1

Global cache log flushes for cr blocks served %: 2.3

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

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

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

Global cache log flushes for current blocks served %: 0.3

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 598.7

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: 38.00

% of indirect sent messages: 59.49

% of flow controlled messages: 2.51

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): 255.1s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	252.54	99.00
DB CPU	207.42	81.32
PL/SQL execution elapsed time	6.36	2.49
parse time elapsed	0.21	0.08
hard parse elapsed time	0.15	0.06
hard parse (sharing criteria) elapsed time	0.11	0.04
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	255.08
background elapsed time	1.17
background cpu time	0.71

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	21,482
IDLE_TIME	43,159
IOWAIT_TIME	14
NICE_TIME	0
SYS_TIME	908
USER_TIME	20,458
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
02-Jul 13:04:52	0.05
02-Jul 13:06:13	2.16	33.23	31.65	1.40	0.02	66.77

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			207		81.32
User I/O	20,465	26	39	2	15.10
Other	3,765	88	8	2	3.11
System I/O	1,114	0	0	0	0.15
Cluster	1,040	0	0	0	0.08
Concurrency	746	3	0	0	0.05
Application	32	3	0	0	0.00
Commit	7	0	0	0	0.00
Network	233	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
cell smart table scan	11,182	48	22	2	159.74	8.53
direct path read temp	4,612	0	9	2	65.89	3.51
direct path write temp	4,612	0	8	2	65.89	2.95
reliable message	144	4	6	44	2.06	2.47
PX Deq: Slave Session Stats	84	0	1	8	1.20	0.28
PX Deq: Signal ACK RSG	39	54	0	12	0.56	0.19
control file sequential read	1,114	0	0	0	15.91	0.15
cell single block physical read	43	0	0	6	0.61	0.10
PX Nsq: PQ load info query	1	100	0	200	0.01	0.08
enq: PS - contention	196	36	0	1	2.80	0.07
gc cr multi block request	340	0	0	0	4.86	0.04
library cache pin	351	0	0	0	5.01	0.02
library cache lock	312	0	0	0	4.46	0.02
enq: WF - contention	16	0	0	2	0.23	0.01
gc current multi block request	280	0	0	0	4.00	0.01
cell multiblock physical read	16	0	0	2	0.23	0.01
IPC send completion sync	340	98	0	0	4.86	0.01
gc cr block 3-way	98	0	0	0	1.40	0.01
gc current block 3-way	103	0	0	0	1.47	0.01
row cache lock	61	0	0	0	0.87	0.00
PX Deq: reap credit	1,642	100	0	0	23.46	0.00
gc current block 2-way	85	0	0	0	1.21	0.00
gc current grant busy	44	0	0	0	0.63	0.00
PX Deq: Signal ACK EXT	11	0	0	1	0.16	0.00
gc cr block 2-way	66	0	0	0	0.94	0.00
enq: KO - fast object checkpoint	3	0	0	2	0.04	0.00
PX qref latch	1,248	100	0	0	17.83	0.00
log file sync	7	0	0	0	0.10	0.00
rdbms ipc reply	26	0	0	0	0.37	0.00
gc current block busy	5	0	0	0	0.07	0.00
SQL*Net break/reset to client	28	0	0	0	0.40	0.00
gc cr block busy	3	0	0	1	0.04	0.00
latch: session allocation	6	0	0	0	0.09	0.00
gc current grant 2-way	16	0	0	0	0.23	0.00
SQL*Net message from client	233	0	329	1411	3.33
wait for unread message on broadcast channel	81	100	81	1001	1.16
jobq slave wait	33	48	80	2425	0.47
PX Deq: Execute Reply	115	19	72	623	1.64
PX Deq: Execution Msg	354	5	49	140	5.06
Streams AQ: waiting for messages in the queue	8	100	8	1001	0.11
PX Deq: Join ACK	75	13	0	2	1.07
PX Deq: Parse Reply	48	0	0	2	0.69
PX Deq Credit: send blkd	111	0	0	0	1.59
PX Deq: Table Q Normal	6	0	0	0	0.09

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
control file sequential read	183	0	0	2	2.61	24.77
PX Deq: reap credit	2,172	100	0	0	31.03	3.41
control file parallel write	27	0	0	1	0.39	2.47
db file parallel write	12	0	0	1	0.17	1.32
log file parallel write	60	0	0	0	0.86	1.24
ges inquiry response	30	0	0	0	0.43	0.92
enq: CO - master slave det	25	100	0	0	0.36	0.58
gcs log flush sync	31	0	0	0	0.44	0.50
CGS wait for IPC msg	659	100	0	0	9.41	0.47
ksxr poll remote instances	534	100	0	0	7.63	0.36
enq: CF - contention	3	100	0	0	0.04	0.12
PX Idle Wait	2,083	96	5,193	2493	29.76
rdbms ipc message	2,810	42	1,455	518	40.14
wait for unread message on broadcast channel	162	100	162	1001	2.31
gcs remote message	7,547	49	162	21	107.81
DIAG idle wait	2,345	92	161	69	33.50
shared server idle wait	3	100	90	30000	0.04
Streams AQ: qmn slave idle wait	3	0	86	28556	0.04
Streams AQ: qmn coordinator idle wait	6	50	86	14278	0.09
pmon timer	30	90	81	2700	0.43
ges remote message	3,858	18	81	21	55.11
ASM background timer	16	0	80	5005	0.23
Space Manager: slave idle wait	16	100	80	5001	0.23
PING	25	8	75	2999	0.36
dispatcher timer	1	100	60	60001	0.01

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	16	100.0
CGS wait for IPC msg	656	100.0
IPC send completion sync	340	99.7		.3
KJC: Wait for msg sends to complete	1	100.0
PX Deq: Signal ACK EXT	11	81.8	9.1	9.1
PX Deq: Signal ACK RSG	41	63.4	9.8	2.4	2.4	7.3	7.3	7.3
PX Deq: Slave Session Stats	84	86.9	7.1	3.6	1.2			1.2
PX Deq: reap credit	3806	99.8	.1	.1	.0
PX Nsq: PQ load info query	1							100.0
PX qref latch	1248	100.0
SQL*Net break/reset to client	28	100.0
SQL*Net message to client	233	100.0
cell multiblock physical read	16	68.8		12.5	18.8
cell single block physical read	43	7.0	7.0	37.2	25.6	18.6	4.7
cell smart table scan	11K	83.8	5.9	1.0	.4	4.7	3.8	.4
control file parallel write	27	77.8	14.8	7.4
control file sequential read	1297	96.1	1.7	1.2	.2	.5	.3
db file parallel read	1					100.0
db file parallel write	14	57.1	21.4	21.4
direct path read temp	4611	70.1	2.9	5.9	14.6	5.9	.7	.0
direct path write temp	4612	16.3	63.3	18.1	2.2	.0
enq: AF - task serialization	2	100.0
enq: CF - contention	3	100.0
enq: CO - master slave det	25	96.0		4.0
enq: JQ - contention	1	100.0
enq: KO - fast object checkpoint	4	75.0			25.0
enq: PS - contention	196	98.0	1.0					1.0
enq: TT - contention	2	100.0
enq: TX - index contention	2	100.0
enq: UL - contention	1	100.0
enq: WF - contention	16	93.8					6.3
gc cr block 2-way	58	100.0
gc cr block 3-way	90	100.0
gc cr block busy	3	100.0
gc cr multi block request	342	98.0	1.8					.3
gc current block 2-way	77	100.0
gc current block 3-way	89	100.0
gc current block busy	3	100.0
gc current grant 2-way	14	100.0
gc current grant busy	31	100.0
gc current multi block request	267	100.0
gcs log flush sync	14	100.0
ges inquiry response	32	96.9	3.1
ksxr poll remote instances	521	100.0
latch: enqueue hash chains	1	100.0
latch: ges resource hash list	1	100.0
latch: session allocation	6	100.0
latch: shared pool	3	100.0
library cache lock	143	99.3	.7
library cache pin	196	98.5	1.5
library cache: mutex X	20	100.0
log file parallel write	58	100.0
log file sync	7	100.0
rdbms ipc reply	28	100.0
reliable message	141	91.5	.7	1.4	1.4			5.0
row cache lock	54	100.0
ASM background timer	16								100.0
DIAG idle wait	2354	3.4	.4	.5	.5	.6	40.4	54.3
KSV master wait	48	100.0
PING	25	88.0							12.0
PX Deq Credit: send blkd	111	96.4	1.8	1.8
PX Deq: Execute Reply	115	25.2	.9		1.7	5.2	6.1	38.3	22.6
PX Deq: Execution Msg	354	43.2	21.8	16.7	4.0	.8	1.1	5.9	6.5
PX Deq: Join ACK	77	85.7	7.8	3.9		1.3		1.3
PX Deq: Msg Fragment	3	100.0
PX Deq: Parse Reply	49	83.7		4.1	2.0	6.1	2.0	2.0
PX Deq: Table Q Normal	6	83.3	16.7
PX Idle Wait	2078				.0	.1		2.5	97.3
SQL*Net message from client	233	75.5	8.6	.9					15.0
Space Manager: slave idle wait	16								100.0
Streams AQ: RAC qmn coordinator idle wait	6	100.0
Streams AQ: qmn coordinator idle wait	6	50.0							50.0
Streams AQ: qmn slave idle wait	3								100.0
Streams AQ: waiting for messages in the queue	8							100.0
dispatcher timer	1								100.0
gcs remote message	7272	33.5	4.9	3.6	3.0	3.0	3.4	48.6
ges remote message	3496	52.7	5.4	3.5	4.0	3.9	4.3	26.2
jobq slave wait	34				2.9				97.1
pmon timer	31	12.9							87.1
rdbms ipc message	2795	38.2	1.6	2.8	1.9	1.1	1.6	38.1	14.7
shared server idle wait	3								100.0
wait for unread message on broadcast channel	243							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	254	207	8,195	7,658
SYS$BACKGROUND	1	0	0	0
SYS$USERS	0	0	0	0
DEMO	0	0	0	1
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	Network Total Wts
D_FOUR	0	705	3
SYS$BACKGROUND	0	7	0
SYS$USERS	0	22	56
DEMO	16	42	174
D4	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
242	202	1	241.96	94.86	dw7vptwvsn6bw	SQL*Plus	select /* four / /+ p...
7	0	1	6.90	2.70	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0	0	1	0.47	0.19	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	8	0.03	0.08	7frqszzdu8sgg	racgimon@rsthpdbs101.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
0	0	2	0.09	0.07	2b064ybzkwf1y	OEM.SystemPool	BEGIN EMD_NOTIFICATION.QUEUE_R...
0	0	1	0.18	0.07	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
0	0	1	0.16	0.06	350myuyx0t1d6		insert into wrh$_tablespace_st...
0	0	1	0.14	0.05	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	68	0.00	0.04	6v7n0y2bq89n8	OEM.SystemPool	BEGIN EMDW_LOG.set_context(MGM...
0	0	1	0.10	0.04	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...

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): 207
Captured SQL account for 98.0% of Total
Total CPU Time (s): 207
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
202	242	1	202.30	97.53	94.86	dw7vptwvsn6bw	SQL*Plus	select /* four / /+ p...
0	0	1	0.47	0.23	0.19	bunssq950snhf		insert into wrh$_sga_target_ad...
0	7	1	0.44	0.21	2.70	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0	0	1	0.10	0.05	0.05	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	1	0.08	0.04	0.04	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...
0	0	8	0.01	0.04	0.08	7frqszzdu8sgg	racgimon@rsthpdbs101.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
0	0	68	0.00	0.03	0.04	6v7n0y2bq89n8	OEM.SystemPool	BEGIN EMDW_LOG.set_context(MGM...
0	0	1	0.04	0.02	0.07	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
0	0	1	0.02	0.01	0.03	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
0	0	1	0.02	0.01	0.01	84k66tf2s7y1c		insert into wrh$_bg_event_summ...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
Total Buffer Gets: 1,936,518
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,887,905	1	1,887,905.00	97.49	202.30	241.96	dw7vptwvsn6bw	SQL*Plus	select /* four / /+ p...
7,357	1	7,357.00	0.38	0.08	0.10	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...
5,300	1	5,300.00	0.27	0.44	6.90	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
3,410	1	3,410.00	0.18	0.10	0.14	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
1,095	1	1,095.00	0.06	0.01	0.01	6c06mfv01xt2h		update wrh$_seg_stat_obj sso ...
800	68	11.76	0.04	0.06	0.10	6v7n0y2bq89n8	OEM.SystemPool	BEGIN EMDW_LOG.set_context(MGM...
582	132	4.41	0.03	0.01	0.01	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
419	1	419.00	0.02	0.01	0.01	61tn3mam0vq0b		SELECT source, (case ...
384	1	384.00	0.02	0.00	0.01	6wm3n4d7bnddg		SELECT source, (case ...
303	1	303.00	0.02	0.01	0.02	5ax5xu96u2ztd		insert into WRH$_EVENT_HISTOGR...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 2,048,922
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
2,017,656	1	2,017,656.00	98.47	202.30	241.96	dw7vptwvsn6bw	SQL*Plus	select /* four / /+ p...
64	68	0.94	0.00	0.06	0.10	6v7n0y2bq89n8	OEM.SystemPool	BEGIN EMDW_LOG.set_context(MGM...
20	1	20.00	0.00	0.00	0.01	brwtjmaw6pu3h	OEM.SystemPool	UPDATE MGMT_JOB_EXECUTION SET ...
12	51	0.24	0.00	0.00	0.01	5hfunyv38vwfp	OEM.SystemPool	SELECT JOB_ID, EXECUTION_ID, ...
8	17	0.47	0.00	0.00	0.03	2n27cdhj8s6fb	OEM.SystemPool	SELECT JOB_ID, EXECUTION_ID, ...
5	1	5.00	0.00	0.44	6.90	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
3	1	3.00	0.00	0.00	0.01	dtj94u9jj2qj4		insert into wrh$_tablespace_sp...
1	1	1.00	0.00	0.10	0.14	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
1	1	1.00	0.00	0.00	0.01	6xpsr8v27pmy2		insert into WRH$_IOSTAT_FUNCTI...
1	1	1.00	0.00	0.47	0.47	bunssq950snhf		insert into wrh$_sga_target_ad...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 1,259
Captured SQL account for 34.9% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
132	132	1.00	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
68	68	1.00	6v7n0y2bq89n8	OEM.SystemPool	BEGIN EMDW_LOG.set_context(MGM...
51	1	0.02	5hfunyv38vwfp	OEM.SystemPool	SELECT JOB_ID, EXECUTION_ID, ...
47	35	0.74	87gaftwrm2h68		select o.owner#, o.name, o.nam...
31	1,984	64.00	an4593dzvqr4v		select obj#, dataobj#, subpa...
17	0	0.00	2n27cdhj8s6fb	OEM.SystemPool	SELECT JOB_ID, EXECUTION_ID, ...
11	11	1.00	g4vrdfn14tp29		SELECT PROPERTY FROM SYS.WRI$_...
9	9	1.00	8x0funf899dka		INSERT INTO wri$_adv_addm_inst...
9	9	1.00	bsa0wjtftg3uw		select file# from file$ where ...
9	9	1.00	dwypdxsjg4juq		select /*+ index_ss(obj$ i_obj...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 468
Captured SQL account for 44.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
64	8	13.68	7frqszzdu8sgg	racgimon@rsthpdbs101.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
9	9	1.92	8x0funf899dka		INSERT INTO wri$_adv_addm_inst...
9	9	1.92	bsa0wjtftg3uw		select file# from file$ where ...
8	0	1.71	8z3tqxkjw4sg4	sqlplus@rsthpdbs101.us.oracle.com (TNS V1-V3)	select px.SID "SID", ...
6	6	1.28	062savj8zgzut		UPDATE sys.wri$_adv_parameters...
5	1	1.07	dw7vptwvsn6bw	SQL*Plus	select /* four / /+ p...
4	4	0.85	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
4	4	0.85	6uv0yw917usfy		INSERT INTO wri$_adv_addm_fdg ...
4	4	0.85	7gtztzv329wg0		select c.name, u.name from co...
4	4	0.85	9ur12dtztw3rx	OEM.SystemPool	SELECT TARGET_GUID, DELETE_RE...

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

Cluster Wait Time (s)	%Ela	%Total	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Module	SQL Text
0.08	0.03	41.28	241.96	202.30	1	dw7vptwvsn6bw	SQL*Plus	select /* four / /+ p...
0.07	0.97	33.92	6.90	0.44	1	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0.03	24.12	16.64	0.14	0.10	1	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.01	7.60	3.96	0.10	0.06	68	6v7n0y2bq89n8	OEM.SystemPool	BEGIN EMDW_LOG.set_context(MGM...

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

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)

1uk5m5qbzj1vt BEGIN dbms_workload_repository.create_snapshot; END;

2b064ybzkwf1y BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;

2n27cdhj8s6fb SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B5 , :B4 ) AND COMMAND_TYPE = :B3 AND START_TIME <= :B2 AND ROWNUM <= :B1

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

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

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

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

5hfunyv38vwfp SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B9 , :B8 , :B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND START_TIME <= :B2 AND ROWNUM <= :B1

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

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

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

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

6v7n0y2bq89n8 BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); MGMT_JOB_ENGINE.get_scheduled_steps(:2, :3, :4, :5); EMDW_LOG.set_context; END;

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

6xpsr8v27pmy2 insert into WRH$_IOSTAT_FUNCTION (snap_id, dbid, instance_number, function_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, large_read_reqs, large_write_reqs, number_of_waits, wait_time) (select :snap_id, :dbid, :instance_number, function_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(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(number_of_waits) number_of_waits, sum(wait_time) wait_time from v$iostat_function group by function_id)

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

7gtztzv329wg0 select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#

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

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

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

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

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)

8z3tqxkjw4sg4 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", s.sql_id 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

9ur12dtztw3rx SELECT TARGET_GUID, DELETE_REQUEST_TIME, DELETE_COMPLETE_TIME FROM MGMT_TARGETS_DELETE DEL WHERE EMD_URL = :B1 OR EXISTS (SELECT 1 FROM MGMT_TARGET_AGENT_ASSOC WHERE TARGET_GUID = DEL.TARGET_GUID AND AGENT_GUID = :B2 )

an4593dzvqr4v select obj#, dataobj#, subpart#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabsubpart$ where pobj# = :1 order by subpart#

brwtjmaw6pu3h UPDATE MGMT_JOB_EXECUTION SET STEP_STATUS = :B4 , DISPATCHER_ID=:B3 , OMS_NAME=:B2 WHERE STEP_ID = :B1

bsa0wjtftg3uw select file# from file$ where ts#=:1

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

dtj94u9jj2qj4 insert into wrh$_tablespace_space_usage (snap_id, dbid, tablespace_id, tablespace_usedsize, tablespace_size, tablespace_maxsize, rtime) select :snap_id, :dbid, KTTEFINFOTSN, sum(KTTEFINFOUSP), sum(KTTEFINFOSIZE), sum(KTTEFINFOMSIZE), to_char(sysdate, 'MM/DD/YYYY HH24:MI:SS') from X$KTTEFINFO group by KTTEFINFOTSN

dw7vptwvsn6bw 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 d31.dwb_rtl_trx t1, d31.dwb_rtl_trx t2 where t1.trx_nbr = t2.trx_nbr

dwypdxsjg4juq select /*+ index_ss(obj$ i_obj2) */ obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

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
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)
1uk5m5qbzj1vt	BEGIN dbms_workload_repository.create_snapshot; END;
2b064ybzkwf1y	BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
2n27cdhj8s6fb	SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B5 , :B4 ) AND COMMAND_TYPE = :B3 AND START_TIME <= :B2 AND ROWNUM <= :B1
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
3m8smr0v7v1m6	INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
5ax5xu96u2ztd	insert into WRH$_EVENT_HISTOGRAM (snap_id, dbid, instance_number, event_id, wait_time_milli, wait_count) select :snap_id, :dbid, :instance_number, d.ksledhash, s.kslsesmaxdur, s.kslsesval from x$kslseshist s, x$ksled d where s.kslsesenum = d.indx and s.kslsesval > 0 order by d.ksledhash, s.kslsesmaxdur
5h7w8ykwtb2xt	INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
5hfunyv38vwfp	SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B9 , :B8 , :B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND START_TIME <= :B2 AND ROWNUM <= :B1
61tn3mam0vq0b	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMB ERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6c06mfv01xt2h	update wrh$_seg_stat_obj sso set (index_type, base_obj#, base_object_name, base_object_owner) = (select decode(ind.type#, 1, 'NORMAL'\|\| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner from sys.ind$ ind, sys.user$ base_owner, sys.obj$ base_obj where ind.obj# = sso.obj# and ind.dataobj# = sso.dataobj# and ind.bo# = base_obj.obj# and base_obj.owner# = base_owner.user#) where sso.dbid = :dbid and (obj#, dataobj#) in (select objn_kewrseg, objd_kewrseg from x$kewrtsegstat ss1 where objtype_kewrseg = 1) and sso.snap_id = :lah_snap_id and sso.object_type = 'INDEX'
6uv0yw917usfy	INSERT INTO wri$_adv_addm_fdg ( TASK_ID, FINDING_ID, RULE_ID, ADDM_FDG_ID, ADDM_SEQ, DATABASE_TIME, ACTIVE_SESSIONS, PERC_ACTIVE_SESS, IS_AGGREGATE, METER_LEVEL) VALUES ( :tid, :kea_id, NULL, NULL, 0, NULL, NULL, NULL, 'N', NULL)
6v7n0y2bq89n8	BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); MGMT_JOB_ENGINE.get_scheduled_steps(:2, :3, :4, :5); EMDW_LOG.set_context; END;
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
6xpsr8v27pmy2	insert into WRH$_IOSTAT_FUNCTION (snap_id, dbid, instance_number, function_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, large_read_reqs, large_write_reqs, number_of_waits, wait_time) (select :snap_id, :dbid, :instance_number, function_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(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(number_of_waits) number_of_waits, sum(wait_time) wait_time from v$iostat_function group by function_id)
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
7gtztzv329wg0	select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
7qjhf5dzmazsr	SELECT snap_id , OBJ#, DATAOBJ# FROM (SELECT /+ ordered use_nl(t2) index(t2) / t2.snap_id , t1.OBJN_KEWRSEG OBJ#, t1.OBJD_KEWRSEG DATAOBJ# FROM X$KEWRTSEGSTAT t1, WRH$_SEG_STAT_OBJ t2 WHERE t2.dbid(+) = :dbid AND t2.OBJ#(+) = t1.OBJN_KEWRSEG AND t2.DATAOBJ#(+) = t1.OBJD_KEWRSEG) WHERE nvl(snap_id, 0) < :snap_id
7vgmvmy8vvb9s	insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)
84k66tf2s7y1c	insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id
87gaftwrm2h68	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
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)
8z3tqxkjw4sg4	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", s.sql_id 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
9ur12dtztw3rx	SELECT TARGET_GUID, DELETE_REQUEST_TIME, DELETE_COMPLETE_TIME FROM MGMT_TARGETS_DELETE DEL WHERE EMD_URL = :B1 OR EXISTS (SELECT 1 FROM MGMT_TARGET_AGENT_ASSOC WHERE TARGET_GUID = DEL.TARGET_GUID AND AGENT_GUID = :B2 )
an4593dzvqr4v	select obj#, dataobj#, subpart#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabsubpart$ where pobj# = :1 order by subpart#
brwtjmaw6pu3h	UPDATE MGMT_JOB_EXECUTION SET STEP_STATUS = :B4 , DISPATCHER_ID=:B3 , OMS_NAME=:B2 WHERE STEP_ID = :B1
bsa0wjtftg3uw	select file# from file$ where ts#=:1
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
dtj94u9jj2qj4	insert into wrh$_tablespace_space_usage (snap_id, dbid, tablespace_id, tablespace_usedsize, tablespace_size, tablespace_maxsize, rtime) select :snap_id, :dbid, KTTEFINFOTSN, sum(KTTEFINFOUSP), sum(KTTEFINFOSIZE), sum(KTTEFINFOMSIZE), to_char(sysdate, 'MM/DD/YYYY HH24:MI:SS') from X$KTTEFINFO group by KTTEFINFOTSN
dw7vptwvsn6bw	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 d31.dwb_rtl_trx t1, d31.dwb_rtl_trx t2 where t1.trx_nbr = t2.trx_nbr
dwypdxsjg4juq	select /+ index_ss(obj$ i_obj2) / obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
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.02	0.03
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	12	0.15	0.17
Batched IO buffer defrag count	1	0.01	0.01
Batched IO double miss count	2	0.02	0.03
Batched IO same unit count	7	0.09	0.10
Batched IO single block count	1	0.01	0.01
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	4	0.05	0.06
Batched IO vector read count	1	0.01	0.01
Block Cleanout Optim referenced	17	0.21	0.24
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	20,705	255.31	295.79
CPU used when call started	108,245	1,334.73	1,546.36
CR blocks created	10	0.12	0.14
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	5	0.06	0.07
DB time	43,859	540.81	626.56
DBWR checkpoint buffers written	7	0.09	0.10
DBWR checkpoints	1	0.01	0.01
DBWR fusion writes	295	3.64	4.21
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	1	0.01	0.01
DBWR undo block writes	6	0.07	0.09
DFO trees parallelized	10	0.12	0.14
DML statements parallelized	0	0.00	0.00
HSC Heap Segment Block Changes	407	5.02	5.81
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	108	1.33	1.54
Heap Segment Array Updates	5	0.06	0.07
PX local messages recv'd	124	1.53	1.77
PX local messages sent	124	1.53	1.77
PX remote messages recv'd	346	4.27	4.94
PX remote messages sent	442	5.45	6.31
Parallel operations downgraded 1 to 25 pct	0	0.00	0.00
Parallel operations not downgraded	10	0.12	0.14
RowCR - row contention	1	0.01	0.01
RowCR attempts	4	0.05	0.06
RowCR hits	3	0.04	0.04
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	239	2.95	3.41
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	71	0.88	1.01
application wait time	1	0.01	0.01
background timeouts	497	6.13	7.10
branch node splits	0	0.00	0.00
buffer is not pinned count	4,165	51.36	59.50
buffer is pinned count	15,069	185.81	215.27
bytes received via SQL*Net from client	72,983	899.92	1,042.61
bytes sent via SQL*Net to client	30,728	378.89	438.97
calls to get snapshot scn: kcmgss	18,784	231.62	268.34
calls to kcmgas	888	10.95	12.69
calls to kcmgcs	75	0.92	1.07
cell blocks helped by minscn optimization	1,910,153	23,553.35	27,287.90
cell blocks processed by cache layer	1,910,153	23,553.35	27,287.90
cell blocks processed by data layer	1,910,153	23,553.35	27,287.90
cell blocks processed by txn layer	1,910,153	23,553.35	27,287.90
cell physical IO bytes eligible for predicate offload	15,612,837,888	192,515,787.96	223,040,541.26
cell physical IO bytes saved during optimized file creation	0	0.00	0.00
cell physical IO interconnect bytes	11,822,537,416	145,779,077.62	168,893,391.66
cell scans	992	12.23	14.17
change write time	2	0.02	0.03
cleanout - number of ktugct calls	84	1.04	1.20
cleanouts and rollbacks - consistent read gets	8	0.10	0.11
cleanouts only - consistent read gets	5	0.06	0.07
cluster key scan block gets	77	0.95	1.10
cluster key scans	64	0.79	0.91
cluster wait time	19	0.23	0.27
commit batch/immediate performed	7	0.09	0.10
commit batch/immediate requested	7	0.09	0.10
commit cleanout failures: block lost	22	0.27	0.31
commit cleanout failures: callback failure	4	0.05	0.06
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	350	4.32	5.00
commit cleanouts successfully completed	324	4.00	4.63
commit immediate performed	7	0.09	0.10
commit immediate requested	7	0.09	0.10
commit txn count during cleanout	71	0.88	1.01
concurrency wait time	10	0.12	0.14
consistent changes	26	0.32	0.37
consistent gets	1,933,696	23,843.65	27,624.23
consistent gets - examination	2,206	27.20	31.51
consistent gets direct	1,905,864	23,500.46	27,226.63
consistent gets from cache	27,832	343.19	397.60
consistent gets from cache (fastpath)	25,065	309.07	358.07
cursor authentications	68	0.84	0.97
data blocks consistent reads - undo records applied	10	0.12	0.14
db block changes	2,707	33.38	38.67
db block gets	2,822	34.80	40.31
db block gets direct	0	0.00	0.00
db block gets from cache	2,822	34.80	40.31
db block gets from cache (fastpath)	815	10.05	11.64
deferred (CURRENT) block cleanout applications	192	2.37	2.74
enqueue conversions	202	2.49	2.89
enqueue releases	3,278	40.42	46.83
enqueue requests	3,311	40.83	47.30
enqueue timeouts	33	0.41	0.47
enqueue waits	267	3.29	3.81
exchange deadlocks	1	0.01	0.01
execute count	1,259	15.52	17.99
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	0	0.00	0.00
free buffer requested	3,884	47.89	55.49
gc CPU used by this session	37	0.46	0.53
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.05	0.06
gc cr block send time	1	0.01	0.01
gc cr blocks received	223	2.75	3.19
gc cr blocks served	174	2.15	2.49
gc current block flush time	0	0.00	0.00
gc current block pin time	0	0.00	0.00
gc current block receive time	337	4.16	4.81
gc current block send time	3	0.04	0.04
gc current blocks received	2,126	26.21	30.37
gc current blocks served	660	8.14	9.43
gc local grants	25	0.31	0.36
gc reader bypass grants	19	0.23	0.27
gc remote grants	149	1.84	2.13
gcs messages sent	6,986	86.14	99.80
ges messages sent	3,496	43.11	49.94
global enqueue get time	58	0.72	0.83
global enqueue gets async	61	0.75	0.87
global enqueue gets sync	4,631	57.10	66.16
global enqueue releases	4,506	55.56	64.37
heap block compress	9	0.11	0.13
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	13	0.16	0.19
immediate (CURRENT) block cleanout applications	86	1.06	1.23
index crx upgrade (positioned)	73	0.90	1.04
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fetch by key	917	11.31	13.10
index scans kdiixs1	5,087	62.73	72.67
leaf node 90-10 splits	18	0.22	0.26
leaf node splits	21	0.26	0.30
lob reads	0	0.00	0.00
lob writes	2	0.02	0.03
lob writes unaligned	2	0.02	0.03
logons cumulative	81	1.00	1.16
messages received	191	2.36	2.73
messages sent	191	2.36	2.73
min active SCN optimization applied to CR	0	0.00	0.00
no work - consistent read gets	11,997	147.93	171.39
opened cursors cumulative	1,139	14.04	16.27
parse count (describe)	1	0.01	0.01
parse count (failures)	0	0.00	0.00
parse count (hard)	70	0.86	1.00
parse count (total)	468	5.77	6.69
parse time cpu	8	0.10	0.11
parse time elapsed	5	0.06	0.07
physical IO disk bytes	19,160,519,680	236,260,862.40	273,721,709.71
physical read IO requests	24,819	306.03	354.56
physical read bytes	16,784,769,024	206,966,411.72	239,782,414.63
physical read total IO requests	26,145	322.38	373.50
physical read total bytes	16,806,322,176	207,232,175.19	240,090,316.80
physical read total multi block requests	24,616	303.53	351.66
physical reads	2,048,922	25,264.45	29,270.31
physical reads cache	86	1.06	1.23
physical reads cache prefetch	48	0.59	0.69
physical reads direct	2,048,836	25,263.39	29,269.09
physical reads direct temporary tablespace	142,972	1,762.93	2,042.46
physical reads prefetch warmup	48	0.59	0.69
physical write IO requests	4,909	60.53	70.13
physical write bytes	1,173,716,992	14,472,644.45	16,767,385.60
physical write total IO requests	5,051	62.28	72.16
physical write total bytes	1,176,435,200	14,506,161.60	16,806,217.14
physical write total multi block requests	4,614	56.89	65.91
physical writes	143,276	1,766.68	2,046.80
physical writes direct	142,972	1,762.93	2,042.46
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	142,972	1,762.93	2,042.46
physical writes from cache	304	3.75	4.34
physical writes non checkpoint	143,272	1,766.63	2,046.74
pinned buffers inspected	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	0	0.00	0.00
queries parallelized	10	0.12	0.14
recovery blocks read	0	0.00	0.00
recursive calls	6,835	84.28	97.64
recursive cpu usage	20,519	253.01	293.13
redo blocks checksummed by FG (exclusive)	1,875	23.12	26.79
redo blocks written	2,717	33.50	38.81
redo entries	1,512	18.64	21.60
redo ordering marks	60	0.74	0.86
redo size	1,270,896	15,670.92	18,155.66
redo size for direct writes	0	0.00	0.00
redo subscn max counts	103	1.27	1.47
redo synch time	1	0.01	0.01
redo synch writes	13	0.16	0.19
redo wastage	14,324	176.62	204.63
redo write broadcast ack time	0	0.00	0.00
redo write time	5	0.06	0.07
redo writer latching time	0	0.00	0.00
redo writes	61	0.75	0.87
rollback changes - undo records applied	53	0.65	0.76
rollbacks only - consistent read gets	2	0.02	0.03
rows fetched via callback	650	8.01	9.29
session connect time	0	0.00	0.00
session cursor cache hits	684	8.43	9.77
session logical reads	1,936,518	23,878.44	27,664.54
shared hash latch upgrades - no wait	427	5.27	6.10
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	4,244	52.33	60.63
sorts (rows)	11,382	140.35	162.60
sql area evicted	123	1.52	1.76
sql area purged	0	0.00	0.00
switch current to new buffer	16	0.20	0.23
table fetch by rowid	8,726	107.60	124.66
table fetch continued row	3	0.04	0.04
table scan blocks gotten	1,907,180	23,516.69	27,245.43
table scan rows gotten	234,131,458	2,886,983.29	3,344,735.11
table scans (direct read)	992	12.23	14.17
table scans (long tables)	992	12.23	14.17
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	65	0.80	0.93
total number of times SMON posted	0	0.00	0.00
transaction lock background get time	0	0.00	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction lock foreground wait time	0	0.00	0.00
transaction rollbacks	7	0.09	0.10
undo change vector size	436,260	5,379.35	6,232.29
user I/O wait time	3,853	47.51	55.04
user calls	655	8.08	9.36
user commits	30	0.37	0.43
user rollbacks	40	0.49	0.57
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	4,243	52.32	60.61
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session uga memory max	1,598,087,119,200	1,600,784,124,416
session pga memory	1,092,403,608,464	1,092,598,705,944
session pga memory max	5,898,360,250,256	5,902,111,151,544
session cursor cache count	406,272	406,318
session uga memory	2,050,936,290,992	2,050,940,204,376
opened cursors current	134	134
workarea memory allocated	405	405
logons current	45	45

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s
TEMP	4,606	57	0.53	31.01	4,612	57
SYSAUX	22	0	2.27	3.18	295	4
D31	16	0	5.63	1.00	0	0
UNDOTBS4	0	0	0.00	0.00	2	0

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Av Buf Wt(ms)
D31	+DGA/demo/datafile/d31.445.688376261	16	0	5.63	1.00	0	0	0.00
SYSAUX	+DGA/demo/datafile/sysaux.417.686904815	22	0	2.27	3.18	295	4	0.00
TEMP	+DGA/demo/tempfile/temp.419.686904819	4,606	57	0.53	31.01	4,612	57
UNDOTBS4	+DGA/demo/datafile/undotbs4.422.686904827	0	0			2	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	30,734	86	304	0	0	0

Advisory Statistics

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

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	0	651	1458	13669	1887390	13669
E	0	1	843	4163	16274	1887390	16274

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.14	158,344
D	896	0.18	106,526	1.13	157,770
D	1,344	0.27	159,789	1.12	156,283
D	1,792	0.36	213,052	1.08	150,404
D	2,240	0.45	266,315	1.01	140,857
D	2,688	0.55	319,578	1.00	139,380
D	3,136	0.64	372,841	1.00	139,251
D	3,584	0.73	426,104	1.00	139,157
D	4,032	0.82	479,367	1.00	139,109
D	4,480	0.91	532,630	1.00	139,108
D	4,928	1.00	585,893	1.00	139,108
D	5,376	1.09	639,156	1.00	139,108
D	5,824	1.18	692,419	1.00	139,108
D	6,272	1.27	745,682	1.00	139,108
D	6,720	1.36	798,945	1.00	139,108
D	7,168	1.45	852,208	1.00	139,108
D	7,616	1.55	905,471	1.00	139,108
D	8,064	1.64	958,734	1.00	139,108
D	8,512	1.73	1,011,997	1.00	139,108
D	8,960	1.82	1,065,260	0.98	136,390

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	9,203	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	12,288	10,872	387.96	0.40	0.10	100.00	0.00	1,048,576
E	12,288	10,803	419.69	0.40	0.09	100.00	0.00	1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	4,192	4,192
64K	128K	5	5
512K	1024K	22	22
1M	2M	4	4
256M	512M	20	20

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
1,536	0.13	710,150.25	827,542.47	46.00	89	173,279,358
3,072	0.25	710,150.25	28,100.29	96.00	0	83,191,900
6,144	0.50	710,150.25	42.14	100.00	0	80,030,087
9,216	0.75	710,150.25	42.14	100.00	0	80,030,087
12,288	1.00	710,150.25	42.14	100.00	0	80,030,087
14,746	1.20	710,150.25	0.00	100.00	0	80,025,338
17,203	1.40	710,150.25	0.00	100.00	0	80,025,338
19,661	1.60	710,150.25	0.00	100.00	0	80,025,338
22,118	1.80	710,150.25	0.00	100.00	0	80,025,338
24,576	2.00	710,150.25	0.00	100.00	0	80,025,338
36,864	3.00	710,150.25	0.00	100.00	0	80,025,338
49,152	4.00	710,150.25	0.00	100.00	0	80,025,338
73,728	6.00	710,150.25	0.00	100.00	0	80,025,338
98,304	8.00	710,150.25	0.00	100.00	0	80,025,338

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	23	1,358	24,691	1.00	676	1.00	724
1,024	1.00	151	8,235	24,694	1.00	673	1.00	3,915
1,152	1.13	254	12,393	24,707	1.00	660	0.98	3,917
1,280	1.25	259	13,353	24,707	1.00	660	0.98	3,917
1,408	1.38	259	13,353	24,707	1.00	660	0.98	3,917
1,536	1.50	259	13,353	24,707	1.00	660	0.98	3,917
1,664	1.63	259	13,353	24,707	1.00	660	0.98	3,917
1,792	1.75	259	13,353	24,707	1.00	660	0.98	3,917
1,920	1.88	259	13,353	24,707	1.00	660	0.98	3,917
2,048	2.00	259	13,353	24,707	1.00	660	0.98	3,917

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	241,118	158,347
2,304	0.38	241,118	157,776
3,072	0.50	241,094	150,404
3,840	0.63	241,070	140,861
4,608	0.75	241,070	139,247
5,376	0.88	241,070	139,108
6,144	1.00	241,070	139,108
6,912	1.13	241,070	139,108
7,680	1.25	241,070	139,108
8,448	1.38	241,070	139,108
9,216	1.50	241,070	139,108
9,984	1.63	241,070	136,395
10,752	1.75	241,070	136,395
11,520	1.88	241,070	136,395
12,288	2.00	241,070	136,395

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Av Wt Time(ms)
PS-PX Process Reservation	343	336	6	202	0.89
WF-AWR Flush	20	20	0	16	1.88
FB-Format Block	4	4	0	4	2.50
CO-KTUCLO Master Slave enq (master slave det)	27	0	27	25	0.00
KO-Multiple Object Checkpoint (fast object checkpoint)	9	9	0	4	0.00
CF-Controlfile Transaction	171	171	0	3	0.00
AF-Advisor Framework (task serialization)	13	13	0	2	0.00
TT-Tablespace	1,389	1,389	0	2	0.00
TX-Transaction (index contention)	3	3	0	2	0.00
JQ-Job Queue	1	0	1	1	0.00
UL-User-defined	1	1	0	1	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
ASM db client latch	135	0.00		0
ASM map operation freelist	36	0.00		0
ASM map operation hash table	72,689	0.00	0.00	0
ASM network background latch	32	0.00		0
AWR Alerted Metric Element list	814	0.00		0
Change Notification Hash table latch	27	0.00		0
Consistent RBA	61	0.00		0
DML lock allocation	498	0.00		0
Event Group Locks	1	0.00		0
FOB s.o list latch	27	0.00		0
File State Object Pool Parent Latch	1	0.00		0
IPC stats buffer allocation latch	201	0.00		221	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	1	0.00		0
JS broadcast add buf latch	18	0.00		0
JS broadcast drop buf latch	18	0.00		0
JS broadcast load blnc latch	16	0.00		0
JS queue access latch	1	0.00		0
JS queue state obj latch	864	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	616	0.00		0
KFMD SGA	1,785	0.11	0.00	0
KFR redo allocation latch	1	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	1,959	0.15	0.00	685	0.15
KJCT flow control latch	13,366	0.07	0.00	0
KMG MMAN ready and startup request latch	27	0.00		0
KSXR large replies	8	0.00		0
KTF sga latch	3	0.00		23	0.00
KWQMN job cache list latch	6	0.00		0
Locator state objects pool parent latch	1	0.00		0
MQL Tracking Latch	0			2	0.00
Memory Management Latch	1	0.00		27	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	6,137	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	1	0.00		0
OS process allocation	27	0.00		0
PL/SQL warning settings	87	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	129	1.55	0.00	0
SGA IO buffer pool latch	2	0.00		2	0.00
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		27	0.00
SQL memory manager workarea list latch	2,025	0.00		0
Shared B-Tree	4	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	4,019	0.00		0
active service list	4,022	0.07	0.00	30	0.00
archive control	9	0.00		0
buffer pool	1	0.00		0
business card	20	0.00		0
cache buffer handles	128	0.00		0
cache buffers chains	73,976	0.00		9,269	0.00
cache buffers lru chain	6,214	0.03	0.00	6,766	0.00
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	3	0.00		0
channel operations parent latch	58,854	0.00	0.00	0
checkpoint queue latch	3,711	0.00		565	0.00
client/application info	414	0.00		0
commit callback allocation	1	0.00		0
compile environment latch	81	0.00		0
corrupted undo seg lock	166	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	1	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	1	0.00		0
dml lock allocation	1	0.00		0
done queue latch	1	0.00		0
dummy allocation	162	0.00		0
enqueue hash chains	10,744	0.07	0.14	0
enqueues	5,846	0.05	0.00	0
error message lists	169	0.00		0
fifth spare latch	1	0.00		0
file cache latch	181	0.00		0
flashback copy	1	0.00		0
gc element	11,035	0.00		1	0.00
gcs commit scn state	1	0.00		0
gcs opaque info freelist	1,702	0.00		0
gcs partitioned table hash	241,468	0.00	0.00	12	0.00
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	10	0.00		0
gcs remastering latch	319	0.00		0
gcs resource freelist	2	0.00		49	0.00
gcs resource hash	11,198	0.00		0
gcs resource scan list	1	0.00		0
gcs shadows freelist	1,010	0.00		1,251	0.00
ges caches resource lists	4,497	0.00		2,150	0.00
ges deadlock list	1,270	0.00		0
ges domain table	9,054	0.00		0
ges enqueue table freelist	10,094	0.00		0
ges group table	13,679	0.00		0
ges process hash list	8,565	0.00		0
ges process parent latch	20,737	0.00		0
ges resource hash list	20,001	0.05	0.10	1,129	0.09
ges resource scan list	1	0.00		0
ges resource table freelist	2,046	0.00		0
ges timeout list	224	0.00		30	0.00
ges value block free list	1	0.00		0
global tx hash mapping	1	0.00		0
granule operation	1	0.00		0
hash table column usage latch	0			1,304	0.00
hash table modification latch	2	0.00		0
heartbeat check	1	0.00		16	0.00
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	1	0.00		2	0.00
job_queue_processes parameter latch	19	0.00		0
k2q global data latch	54	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	692	0.00		0
kokc descriptor allocation latch	76	0.00		0
ksfv messages	1	0.00		0
ksim membership request latch	80	0.00		81	0.00
kss move lock	1	0.00		0
ksuosstats global area	9	0.00		0
ksv allocation latch	1	0.00		0
ksv class latch	97	0.00		0
ksv msg queue latch	1	0.00		0
ksz_so allocation latch	9	0.00		0
kwqbsn:qsga	3	0.00		0
lgwr LWN SCN	78	0.00		0
list of block allocation	21	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	1	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	1	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	1,141	0.00		0
messages	5,938	0.00		0
mostly latch-free SCN	78	0.00		0
msg queue latch	1	0.00		0
multiblock read objects	966	0.00		0
name-service memory objects	404	0.00		0
name-service namespace bucket	808	0.00		0
name-service pending queue	56	0.00		0
name-service request queue	1,078	0.00		0
ncodef allocation latch	1	0.00		0
object queue header heap	2,091	0.00		136	0.00
object queue header operation	96,717	0.00		0
object stats modification	3,256	0.00		0
parallel query alloc buffer	1,163	0.00		0
parallel query stats	111	0.00		0
parameter list	12	0.00		0
parameter table management	161	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	83	0.00		38	0.00
process allocation	362	0.00		0
process queue	518	0.00		0
process queue reference	21,536	0.01	0.00	1,164	107.22
qmn task queue latch	12	0.00		0
query server freelists	359	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	218	0.00		1,550	0.00
redo copy	1	0.00		1,550	0.00
redo writing	287	0.00		0
reid allocation latch	9	0.00		0
resmgr group change latch	154	0.00		0
resmgr:active threads	162	0.00		0
resmgr:actses change group	82	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	161	0.62	0.00	0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	41	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	33,776	0.00		65	0.00
second spare latch	1	0.00		0
sequence cache	31	0.00		0
session allocation	5,197	0.23	0.58	0
session idle bit	1,431	0.00		0
session queue latch	1	0.00		0
session state list latch	162	0.62	0.00	0
session switching	2	0.00		0
session timer	30	0.00		0
shared pool	19,780	0.05	0.30	0
shared pool sim alloc	4	0.00		0
shared pool simulator	1,877	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	1,217	0.00		0
simulator lru latch	1	0.00		1,198	0.00
sort extent pool	1,451	0.00		0
space background task latch	59	0.00		54	0.00
state object free list	2	0.00		0
statistics aggregation	1,568	0.00		0
storage server table manipulation latch	67	0.00		0
tablespace key chain	1,191	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	1	0.00		0
transaction allocation	8	0.00		0
undo global data	534	0.00		0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
session allocation	5,197	12	7	6
ges resource hash list	20,001	10	1	9
shared pool	19,780	10	3	7
enqueue hash chains	10,744	7	1	6

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
active service list	ksws_event: ksws event	1	0
enqueue hash chains	ksqcmi: if lk mode not requested	1	0
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	1	0
session allocation	ksuxds: KSUSFCLC not set	6	0
session allocation	kxfpqidqr:1	1	5
shared pool	kghalo	3	3

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kglget2 2	6
Library Cache	kglpnal2 91	5
Library Cache	kglpndl1 95	4
Library Cache	kglhdgn1 62	2
Library Cache	kgllkal1 80	2
Library Cache	kgllkc1 57	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,936,518
Captured Segments account for 11.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
D31	D31	DWB_RTL_TRX	90509_H051	TABLE SUBPARTITION	10,272	0.53
SYS	SYSAUX	WRH$_SEG_STAT_OBJ_PK		INDEX	8,608	0.44
D31	D31	DWB_RTL_TRX	90508_H051	TABLE SUBPARTITION	8,224	0.42
D31	D31	DWB_RTL_TRX	90502_H052	TABLE SUBPARTITION	8,208	0.42
D31	D31	DWB_RTL_TRX	90525_H042	TABLE SUBPARTITION	7,936	0.41

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 2,048,922
Captured Segments account for 5.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
D31	D31	DWB_RTL_TRX	90508_H051	TABLE SUBPARTITION	3,886	0.19
D31	D31	DWB_RTL_TRX	90508_H029	TABLE SUBPARTITION	3,884	0.19
D31	D31	DWB_RTL_TRX	90508_H039	TABLE SUBPARTITION	3,884	0.19
D31	D31	DWB_RTL_TRX	90531_H012	TABLE SUBPARTITION	3,884	0.19
D31	D31	DWB_RTL_TRX	90508_H026	TABLE SUBPARTITION	3,880	0.19

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 2,048,836
Captured Segments account for 5.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
D31	D31	DWB_RTL_TRX	90508_H051	TABLE SUBPARTITION	3,886	0.19
D31	D31	DWB_RTL_TRX	90508_H029	TABLE SUBPARTITION	3,884	0.19
D31	D31	DWB_RTL_TRX	90508_H039	TABLE SUBPARTITION	3,884	0.19
D31	D31	DWB_RTL_TRX	90531_H012	TABLE SUBPARTITION	3,884	0.19
D31	D31	DWB_RTL_TRX	90508_H026	TABLE SUBPARTITION	3,880	0.19

Back to Segment Statistics
Back to Top

Segments by Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 992
Captured Segments account for 5.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	AILABLE **	UNDEFINED	2	0.20
D31	D31	DWB_RTL_TRX	90501_H019	TABLE SUBPARTITION	2	0.20
D31	D31	DWB_RTL_TRX	90502_H039	TABLE SUBPARTITION	2	0.20
D31	D31	DWB_RTL_TRX	90502_H052	TABLE SUBPARTITION	2	0.20
D31	D31	DWB_RTL_TRX	90504_H012	TABLE SUBPARTITION	2	0.20

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	16.98
SYS	SYSAUX	WRI$_ADV_PARAMETERS_PK		INDEX	144	16.98
SYS	SYSAUX	WRH$_DLM_MISC	75138_1021	TABLE PARTITION	80	9.43
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	75138_1021	INDEX PARTITION	80	9.43
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	75138_1021	INDEX PARTITION	80	9.43

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 223
Captured Segments account for 68.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSAUX	WRM$_DATABASE_INSTANCE		TABLE	24	10.76
SYS	SYSAUX	WRH$_SQL_PLAN_PK		INDEX	9	4.04
SYS	SYSAUX	WRH$_SYS_TIME_MODEL	75138_1021	TABLE PARTITION	9	4.04
SYS	SYSAUX	WRM$_SNAPSHOT		TABLE	9	4.04
SYS	SYSAUX	WRI$_ADV_ADDM_FDG		TABLE	8	3.59

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 2,126
Captured Segments account for 12.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	75138_1021	INDEX PARTITION	53	2.49
SYS	SYSAUX	WRH$_SQLTEXT_PK		INDEX	14	0.66
SYS	SYSAUX	WRH$_SQL_BIND_METADATA_PK		INDEX	14	0.66
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	75138_1021	INDEX PARTITION	13	0.61
SYS	SYSAUX	WRM$_SNAPSHOT		TABLE	9	0.42

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	5	0.00	2	1
dc_global_oids	195	0.00	0	198
dc_histogram_data	1,043	0.00	0	8,553
dc_histogram_defs	1,647	0.67	0	5,702
dc_object_grants	16	0.00	0	33
dc_objects	1,052	5.42	0	1,648
dc_rollback_segments	60	0.00	0	1,055
dc_segments	2,240	0.04	0	3,769
dc_sequences	2	50.00	2	5
dc_tablespaces	4,574	0.00	0	50
dc_users	527	0.00	0	148
global database name	75	0.00	0	1

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Releases
dc_awr_control	4	0
dc_histogram_defs	11	132
dc_objects	45	0
dc_segments	1	16
dc_sequences	4	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	243	0.00	0
CLUSTER	7	0.00	5	0.00	0
INDEX	14	0.00	14	0.00	0
SQL AREA	263	6.08	2,409	6.60	16
TABLE/PROCEDURE	591	0.34	1,337	2.17	8
TRIGGER	9	0.00	11	0.00	0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace	GES Lock Requests	GES Pin Requests
CLUSTER	5	5
INDEX	14	14
TABLE/PROCEDURE	668	974

Back to Library Cache Statistics
Back to Top

Memory Statistics

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

Memory Dynamic Components

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

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

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	350.38		3.07	5.78	31	32	114	113
	Freeable	22.25	0.00	1.11	1.04	4		20	20
	PL/SQL	18.96	2.26	0.39	2.18	15	15	49	49
	SQL	10.27	7.61	0.41	1.67	8	9	25	18
E	Other	376.44		3.30	5.98	32	159	114	113
	Freeable	27.75	0.00	1.16	0.98	4		24	24
	PL/SQL	18.96	2.26	0.36	2.10	15	15	53	49
	SQL	10.31	7.64	0.36	1.56	8	638	29	18

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	22.64	22.58	-0.29
shared	FileOpenBlock	11.21	11.21	0.00
shared	KCL name table	48.00	48.00	0.00
shared	KGL handle	10.84	10.68	-1.42
shared	KQR L PO	10.84	10.76	-0.72
shared	PCursor	13.66	13.63	-0.22
shared	PL/SQL DIANA	18.19	18.19	0.00
shared	PL/SQL MPCODE	13.85	13.81	-0.31
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	252.54	252.84	0.12
shared	gcs resources	97.36	97.36	0.00
shared	gcs shadows	64.90	64.90	0.00
shared	ges big msg buffers	22.03	22.03	0.00
shared	ges enqueues	22.06	22.06	0.00
shared	sessions	11.96	11.96	0.00
shared	sql area	135.36	135.00	-0.27
shared	write state object	14.95	14.95	0.00
	buffer_cache	4,928.00	4,928.00	0.00
	fixed_sga	2.06	2.06	0.00
	log_buffer	34.50	34.50	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

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

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u01/app/oracle/admin/DEMO/adump
audit_trail	DB
cluster_database	TRUE
cluster_database_instances	8
compatible	11.1.0.7
control_files	+DGA/demo/control01.ctl, +DGA/demo/control02.ctl, +DGA/demo/control03.ctl
db_block_size	8192
db_domain
db_name	DEMO
diagnostic_dest	/u01/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=DEMOXDB)
event	27401 trace name context forever, level 16384
instance_number	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
service_names	D_EIGHT, D_FOUR, 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)	378	4.66	5.40
acks for commit broadcast(logical)	378	4.66	5.40
broadcast msgs on commit(actual)	426	5.25	6.09
broadcast msgs on commit(logical)	427	5.27	6.10
broadcast msgs on commit(wasted)	10	0.12	0.14
broadcast on commit wait time(ms)	408,479	5,036.79	5,835.41
broadcast on commit waits	9	0.11	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	8	0.10	0.11
flow control messages sent	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	511	6.30	7.30
gcs ast xid	1	0.01	0.01
gcs blocked converts	413	5.09	5.90
gcs blocked cr converts	242	2.98	3.46
gcs compatible basts	40	0.49	0.57
gcs compatible cr basts (global)	20	0.25	0.29
gcs compatible cr basts (local)	382	4.71	5.46
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	295	3.64	4.21
gcs dbwr write request msgs	0	0.00	0.00
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	6	0.07	0.09
gcs immediate (null) converts	32	0.39	0.46
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	1	0.01	0.01
gcs indirect ast	54	0.67	0.77
gcs indirect bidless ast	20	0.25	0.29
gcs indirect fg ast	48	0.59	0.69
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	1	0.01	0.01
gcs msgs process time(ms)	48	0.59	0.69
gcs msgs received	4,878	60.15	69.69
gcs new served by master	32	0.39	0.46
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	0	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs queued converts	0	0.00	0.00
gcs reader bypass N->Xw ping local	8	0.10	0.11
gcs reader bypass N->Xw ping remote	2	0.02	0.03
gcs reader bypass grant X on assume	3	0.04	0.04
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	13	0.16	0.19
gcs reader bypass grant immediate	16	0.20	0.23
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	193	2.38	2.76
gcs retry convert request	688	8.48	9.83
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	87	1.07	1.24
gcs side channel msgs logical	2,354	29.03	33.63
gcs stale cr	0	0.00	0.00
gcs undo cr	0	0.00	0.00
gcs write notification msgs	0	0.00	0.00
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	15	0.18	0.21
ges msgs received	3,303	40.73	47.19
global posts dropped	0	0.00	0.00
global posts queue time	0	0.00	0.00
global posts queued	0	0.00	0.00
global posts requested	0	0.00	0.00
global posts sent	0	0.00	0.00
implicit batch messages received	96	1.18	1.37
implicit batch messages sent	137	1.69	1.96
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	107	1.32	1.53
messages queue sent actual	4,517	55.70	64.53
messages queue sent logical	4,806	59.26	68.66
messages received actual	6,212	76.60	88.74
messages received logical	8,181	100.88	116.87
messages sent directly	1,620	19.98	23.14
messages sent indirectly	2,536	31.27	36.23
messages sent not implicit batched	4,380	54.01	62.57
messages sent pbatched	7,209	88.89	102.99
msgs causing lmd to send msgs	1,546	19.06	22.09
msgs causing lms(s) to send msgs	754	9.30	10.77
msgs received queue time (ms)	2	0.02	0.03
msgs received queued	8,181	100.88	116.87
msgs sent queue time (ms)	2,828,679	34,879.33	40,409.70
msgs sent queue time on ksxp (ms)	821	10.12	11.73
msgs sent queued	4,725	58.26	67.50
msgs sent queued on ksxp	6,632	81.78	94.74
process batch messages received	3,463	42.70	49.47
process batch messages sent	3,626	44.71	51.80

Global CR Served Stats

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

Global CURRENT Served Stats

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

Statistic	Total	% <1ms	% <10ms	% <100ms
Pins	598	100.00	0.00	0.00
Flushes	2	100.00	0.00	0.00
Writes	295	1.02	52.88	46.10

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
5	Others	11	100.00	0.00	0.00	1,025	98.63	0.00	1.37
2	Others	1	100.00	0.00	0.00	683	100.00	0.00	0.00
5	data block	30	96.67	3.33	0.00	91	97.80	2.20	0.00
3	data block	21	100.00	0.00	0.00	87	98.85	1.15	0.00
7	data block	42	100.00	0.00	0.00	45	100.00	0.00	0.00
1	data block	46	100.00	0.00	0.00	34	100.00	0.00	0.00
2	data block	19	100.00	0.00	0.00	36	100.00	0.00	0.00
7	Others	3	100.00	0.00	0.00	31	100.00	0.00	0.00
6	data block	9	100.00	0.00	0.00	19	100.00	0.00	0.00
8	data block	6	100.00	0.00	0.00	17	100.00	0.00	0.00
6	Others	1	100.00	0.00	0.00	19	100.00	0.00	0.00
3	Others	9	100.00	0.00	0.00	8	100.00	0.00	0.00
8	Others	1	100.00	0.00	0.00	12	100.00	0.00	0.00
5	undo header	7	71.43	28.57	0.00	6	100.00	0.00	0.00
3	undo header	3	100.00	0.00	0.00	0
7	undo header	2	100.00	0.00	0.00	0
8	undo header	1	100.00	0.00	0.00	1	100.00	0.00	0.00
5	undo block	1	100.00	0.00	0.00	0
2	undo header	1	100.00	0.00	0.00	0
1	undo header	1	100.00	0.00	0.00	0
6	undo header	1	100.00	0.00	0.00	0

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer Times (ms)

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

Inst No	Block Class	All	Immed	Busy	All	Immed	Busy	Congst
		CR Avg Time (ms)			Current Avg Time (ms)
5	others	0.14	0.14		2.24	1.57		50.53
2	others	0.21	0.21		1.36	1.36
5	data block	0.25	0.24	0.71	0.23	0.22	0.73
3	data block	0.18	0.18		0.22	0.21	0.96
7	data block	0.19	0.19		0.24	0.24
1	data block	0.22	0.22		0.19	0.19
2	data block	0.19	0.19		0.21	0.21
7	others	0.19	0.19		1.04	1.04
6	data block	0.17	0.17		0.22	0.22
8	data block	0.21	0.21		0.23	0.23
6	others	0.13	0.13		1.11	1.11
3	others	0.16	0.16		0.59	0.59
5	undo header	0.24	0.11	0.57	0.15	0.15
8	others	0.17	0.17		1.09	1.09
3	undo header	0.18	0.18
7	undo header	0.13	0.13
8	undo header	0.15	0.15		0.15	0.15
6	undo header	0.16	0.16
1	undo header	0.12	0.12
2	undo header	0.12	0.12
5	undo block	0.14	0.14
8	undo block
1	others
2	undo block
7	undo block
1	undo block
6	undo block
3	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
5	others	0	11	63.64	36.36	1,011	51.93	48.07
2	others	0	1	0.00	100.00	683	83.31	16.69
5	data block	0	29	37.93	62.07	89	57.30	42.70
3	data block	0	21	57.14	42.86	86	36.05	63.95
7	data block	0	42	14.29	85.71	45	24.44	75.56
1	data block	0	46	26.09	73.91	34	44.12	55.88
2	data block	0	19	21.05	78.95	36	47.22	52.78
7	others	0	3	33.33	66.67	31	90.32	9.68
6	data block	0	9	22.22	77.78	19	47.37	52.63
8	data block	0	6	0.00	100.00	17	41.18	58.82
6	others	0	1	100.00	0.00	19	100.00	0.00
3	others	0	9	0.00	100.00	8	75.00	25.00
8	others	0	1	0.00	100.00	12	91.67	8.33
5	undo header	0	5	100.00	0.00	6	100.00	0.00
3	undo header	0	3	100.00	0.00	0
7	undo header	0	2	100.00	0.00	0
8	undo header	0	1	100.00	0.00	1	100.00	0.00
6	undo header	0	1	100.00	0.00	0
1	undo header	0	1	100.00	0.00	0
2	undo header	0	1	100.00	0.00	0
5	undo block	0	1	100.00	0.00	0
8	undo block	0	0			0
1	others	0	0			0
2	undo block	0	0			0
7	undo block	0	0			0
1	undo block	0	0			0
6	undo block	0	0			0
3	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)
5	others	0.14	0.12	0.17	1.57	1.25	1.92
2	others	0.21		0.21	1.36	1.30	1.67
5	data block	0.24	0.14	0.30	0.22	0.20	0.24
3	data block	0.18	0.15	0.23	0.21	0.18	0.23
7	data block	0.19	0.12	0.20	0.24	0.13	0.27
1	data block	0.22	0.19	0.23	0.19	0.15	0.23
2	data block	0.19	0.17	0.19	0.21	0.17	0.25
7	others	0.19	0.15	0.21	1.04	1.13	0.21
6	data block	0.17	0.12	0.18	0.22	0.17	0.28
8	data block	0.21		0.21	0.23	0.23	0.23
6	others	0.13	0.13		1.11	1.11
3	others	0.16		0.16	0.59	0.73	0.17
8	others	0.17		0.17	1.09	1.17	0.17
5	undo header	0.11	0.11		0.15	0.15
3	undo header	0.18	0.18
7	undo header	0.13	0.13
8	undo header	0.15	0.15		0.15	0.15
6	undo header	0.16	0.16
1	undo header	0.12	0.12
2	undo header	0.12	0.12
5	undo block	0.14	0.14
8	undo block
1	others
2	undo block
7	undo block
1	undo block
6	undo block
3	undo block

Back to Global Cache Transfer Stats
Back to Top

Interconnect Stats

Interconnect Latency Stats
Interconnect Throughput by Client
Interconnect Device Stats

Interconnect Ping Latency Stats

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

Target Instance	500B Ping Count	Avg Latency 500B msg	Stddev 500B msg	8K Ping Count	Avg Latency 8K msg	Stddev 8K msg
1	3	0.80	0.28	3	0.90	0.19
2	3	0.68	0.13	3	0.67	0.13
3	3	0.51	0.13	3	0.61	0.17
4	3	0.50	0.14	3	0.52	0.18
5	3	0.64	0.07	3	0.69	0.06
6	3	0.45	0.11	3	0.44	0.10
7	3	0.58	0.09	3	0.60	0.06
8	3	0.45	0.07	3	0.46	0.09

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.07	0.22
Parallel Query	0.03	0.01
DB Locks	0.03	0.02
DB Streams	0.00	0.00
Other	0.00	0.00

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics

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

Device Name	IP Address	Public	Source	Send Mbytes/sec	Send Errors	Send Dropped	Send Buffer Overrun	Send Carrier Lost	Receive Mbytes/sec	Receive Errors	Receive Dropped	Receive Buffer Overrun	Receive Frame Errors
bond0	172.31.88.170	NO	Oracle Cluster Repository	0.00	0	0	0	0	0.00	0	0	0	0

Back to Interconnect Stats
Back to Top

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.72	In-memory Sort %:	100.00
Library Hit %:	95.32	Soft Parse %:	85.04
Execute to Parse %:	62.83	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	0.00	% Non-Parse CPU:	99.96

Buffer access - local cache %:	92.06
Buffer access - remote cache %:	7.66
Buffer access - disk %:	0.28

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

Avg message sent queue time (ms):	598.7
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:	38.00
% of indirect sent messages:	59.49
% of flow controlled messages:	2.51