WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

DEMO 3430975138 DEMO2 2 30-Jun-09 12:06 11.1.0.7.0 YES

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

Host Name Platform CPUs Cores Sockets Memory (GB)

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

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

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1043 02-Jul-09 12:57:16 42 1.4

End Snap: 1044 02-Jul-09 12:59:02 42 1.4

Elapsed: 1.76 (mins)

DB Time: 11.34 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1043	02-Jul-09 12:57:16	42	1.4
End Snap:	1044	02-Jul-09 12:59:02	42	1.4
Elapsed:		1.76 (mins)
DB Time:		11.34 (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): 6.5 15.8 0.86 0.63

DB CPU(s): 5.5 13.5 0.74 0.54

Redo size: 12,452.1 30,494.5

Logical reads: 27,432.2 67,180.3

Block changes: 23.2 56.8

Physical reads: 29,866.3 73,141.2

Physical writes: 2,716.7 6,653.1

User calls: 10.2 25.0

Parses: 4.7 11.5

Hard parses: 0.1 0.1

W/A MB processed: 109,928,600.1 269,210,028.7

Logons: 1.9 4.7

Executes: 7.5 18.4

Rollbacks: 0.2 0.5

Transactions: 0.4

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	6.5	15.8	0.86	0.63
DB CPU(s):	5.5	13.5	0.74	0.54
Redo size:	12,452.1	30,494.5
Logical reads:	27,432.2	67,180.3
Block changes:	23.2	56.8
Physical reads:	29,866.3	73,141.2
Physical writes:	2,716.7	6,653.1
User calls:	10.2	25.0
Parses:	4.7	11.5
Hard parses:	0.1	0.1
W/A MB processed:	109,928,600.1	269,210,028.7
Logons:	1.9	4.7
Executes:	7.5	18.4
Rollbacks:	0.2	0.5
Transactions:	0.4

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.50 Soft Parse %: 98.79

Execute to Parse %: 37.39 Latch Hit %: 99.97

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

Shared Pool Statistics

Begin End

Memory Usage %: 71.19 71.20

% SQL with executions>1: 89.72 92.35

% Memory for SQL w/exec>1: 88.55 90.79

	Begin	End
Memory Usage %:	71.19	71.20
% SQL with executions>1:	89.72	92.35
% Memory for SQL w/exec>1:	88.55	90.79

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		582		85.55
cell smart table scan	15,938	33	2	4.92	User I/O
direct path write temp	9,224	26	3	3.80	User I/O
direct path read temp	9,224	12	1	1.69	User I/O
reliable message	158	8	48	1.12	Other

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

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

0.20 4.90 65.8 5.4 0.0 28.5

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.20	4.90	65.8	5.4	0.0	28.5

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

69.5 97.2 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
69.5	97.2	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): 366.4 417.3

% Host Mem used for SGA+PGA: 20.23 20.23

	Begin	End
Host Mem (MB):	32,189.6	32,189.6
SGA use (MB):	6,144.0	6,144.0
PGA use (MB):	366.4	417.3
% Host Mem used for SGA+PGA:	20.23	20.23

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: 5.62 13.77

Global Cache blocks served: 5.52 13.51

GCS/GES messages received: 82.57 202.21

GCS/GES messages sent: 82.34 201.65

DBWR Fusion writes: 0.06 0.14

Estd Interconnect traffic (KB) 121.32

	Per Second	Per Transaction
Global Cache blocks received:	5.62	13.77
Global Cache blocks served:	5.52	13.51
GCS/GES messages received:	82.57	202.21
GCS/GES messages sent:	82.34	201.65
DBWR Fusion writes:	0.06	0.14
Estd Interconnect traffic (KB)	121.32

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

Buffer access - local cache %: 97.99

Buffer access - remote cache %: 2.00

Buffer access - disk %: 0.02

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.6

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

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

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

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

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

Global cache log flushes for current blocks served %: 1.9

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 4,460.5

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

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

% of indirect sent messages: 41.33

% of flow controlled messages: 7.84

Cluster Interconnect

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
bond0	172.31.88.110	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): 680.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	659.36	96.95
DB CPU	581.85	85.55
PL/SQL execution elapsed time	6.28	0.92
parse time elapsed	0.12	0.02
hard parse elapsed time	0.01	0.00
hard parse (sharing criteria) elapsed time	0.00	0.00
sequence load elapsed time	0.00	0.00
repeated bind elapsed time	0.00	0.00
DB time	680.11
background elapsed time	3.57
background cpu time	1.84

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	60,073
IDLE_TIME	23,905
IOWAIT_TIME	11
NICE_TIME	0
SYS_TIME	4,501
USER_TIME	55,274
LOAD	0	5
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 12:57:16	0.20
02-Jul 12:59:02	4.90	71.53	65.82	5.36	0.01	28.47

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 98.3% of Total DB time 680.11 (s)
Total FG Wait Time: 86.84 (s) DB CPU time: 581.85 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			582		85.55
User I/O	34,410	21	71	2	10.44
Other	13,235	92	15	1	2.25
System I/O	1,128	0	0	0	0.06
Cluster	808	0	0	0	0.02
Concurrency	313	11	0	0	0.01
Application	22	0	0	1	0.00
Commit	1	0	0	1	0.00
Network	60	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	15,938	45	33	2	370.65	4.92
direct path write temp	9,224	0	26	3	214.51	3.80
direct path read temp	9,224	0	12	1	214.51	1.69
reliable message	158	4	8	48	3.67	1.12
PX Deq: Slave Session Stats	206	0	4	21	4.79	0.63
PX Deq: Signal ACK RSG	35	69	2	54	0.81	0.28
PX Deq: reap credit	2,637	100	1	0	61.33	0.11
control file sequential read	1,128	0	0	0	26.23	0.06
enq: PS - contention	355	30	0	1	8.26	0.04
PX Nsq: PQ load info query	1	100	0	201	0.02	0.03
IPC send completion sync	809	99	0	0	18.81	0.02
cell single block physical read	23	0	0	6	0.53	0.02
rdbms ipc reply	315	0	0	0	7.33	0.01
gc current multi block request	221	0	0	0	5.14	0.00
PX qref latch	8,640	100	0	0	200.93	0.00
library cache pin	126	0	0	0	2.93	0.00
gc current block 3-way	113	0	0	0	2.63	0.00
gc cr multi block request	180	0	0	0	4.19	0.00
library cache lock	108	0	0	0	2.51	0.00
gc cr block 3-way	78	0	0	0	1.81	0.00
PX Deq: Signal ACK EXT	16	0	0	1	0.37	0.00
cell multiblock physical read	1	0	0	11	0.02	0.00
gc current grant busy	45	0	0	0	1.05	0.00
SQL*Net break/reset to client	20	0	0	0	0.47	0.00
gc cr block 2-way	83	0	0	0	1.93	0.00
latch: ges resource hash list	17	0	0	0	0.40	0.00
gc current block 2-way	61	0	0	0	1.42	0.00
row cache lock	30	0	0	0	0.70	0.00
enq: KO - fast object checkpoint	2	0	0	2	0.05	0.00
gc cr block busy	5	0	0	1	0.12	0.00
enq: WF - contention	16	0	0	0	0.37	0.00
latch: shared pool	16	0	0	0	0.37	0.00
gc current grant 2-way	21	0	0	0	0.49	0.00
SQL*Net message from client	60	0	374	6230	1.40
PX Deq: Execution Msg	878	6	134	153	20.42
PX Deq: Execute Reply	119	24	94	791	2.77
jobq slave wait	20	100	61	3041	0.47
Streams AQ: waiting for messages in the queue	12	83	10	834	0.28
PX Deq Credit: send blkd	105	0	1	8	2.44
PX Deq: Join ACK	56	9	0	5	1.30
PX Deq: Parse Reply	49	0	0	1	1.14
PX Deq: Table Q Normal	2	0	0	11	0.05
PX Deq: Msg Fragment	2	0	0	1	0.05

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
PX Deq: reap credit	2,915	100	5	2	67.79	137.72
os thread startup	7	0	1	114	0.16	22.33
control file sequential read	239	0	0	2	5.56	11.71
name-service call wait	4	0	0	80	0.09	9.01
DFS lock handle	470	100	0	1	10.93	8.18
control file parallel write	35	0	0	5	0.81	4.61
enq: CO - master slave det	35	100	0	1	0.81	0.70
ges inquiry response	44	0	0	0	1.02	0.59
gc current block 2-way	6	0	0	3	0.14	0.45
CGS wait for IPC msg	820	100	0	0	19.07	0.42
log file parallel write	51	0	0	0	1.19	0.35
ksxr poll remote instances	1,027	100	0	0	23.88	0.29
enq: CF - contention	4	100	0	2	0.09	0.25
gcs log flush sync	36	0	0	0	0.84	0.15
db file parallel write	4	0	0	1	0.09	0.11
latch: shared pool	6	0	0	0	0.14	0.08
latch: session allocation	5	0	0	0	0.12	0.07
ASM file metadata operation	22	0	0	0	0.51	0.06
enq: PI - contention	4	100	0	0	0.09	0.04
enq: TA - contention	1	0	0	1	0.02	0.03
PX Idle Wait	2,710	93	6,484	2393	63.02
rdbms ipc message	3,858	40	1,895	491	89.72
smon timer	1	100	300	300011	0.02
wait for unread message on broadcast channel	211	100	211	1001	4.91
gcs remote message	7,424	65	210	28	172.65
DIAG idle wait	3,686	94	209	57	85.72
ASM background timer	22	0	109	4967	0.51
Space Manager: slave idle wait	21	100	106	5046	0.49
pmon timer	44	80	105	2386	1.02
ges remote message	5,149	18	105	20	119.74
PING	18	22	100	5554	0.42
shared server idle wait	3	100	90	30006	0.07
Streams AQ: qmn coordinator idle wait	6	50	87	14501	0.14
Streams AQ: qmn slave idle wait	3	0	87	29002	0.07
dispatcher timer	1	100	60	60004	0.02

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ASM file metadata operation	21	100.0
CGS wait for IPC msg	823	100.0
DFS lock handle	470	98.5		.9	.2			.4
IPC send completion sync	805	99.3	.1	.1		.1	.2	.1
KJC: Wait for msg sends to complete	1	100.0
PX Deq: Signal ACK EXT	16	81.3	6.3	6.3	6.3
PX Deq: Signal ACK RSG	35	42.9	2.9		2.9	5.7	2.9	42.9
PX Deq: Slave Session Stats	205	71.7	2.4	4.9	2.0	3.4	6.8	8.8
PX Deq: reap credit	5528	97.6	.1	.2	.3	.5	.7	.6	.0
PX Nsq: PQ load info query	1							100.0
PX qref latch	8640	100.0
SQL*Net break/reset to client	20	95.0			5.0
SQL*Net message to client	60	100.0
cell multiblock physical read	2					100.0
cell single block physical read	23			8.7	56.5	30.4	4.3
cell smart table scan	15K	82.0	5.9	2.4	.3	5.2	3.9	.4
control file parallel write	35	22.9	45.7	20.0	5.7	2.9		2.9
control file sequential read	1367	93.2	4.1	.9	.8	.7	.2	.1
db file parallel write	4	75.0		25.0
direct path read temp	9208	81.8	2.5	4.8	6.7	3.4	.8	.1
direct path write temp	9223	7.2	20.7	58.6	13.1	.4
enq: AF - task serialization	2	100.0
enq: CF - contention	4	75.0			25.0
enq: CO - master slave det	35	94.3	2.9	2.9
enq: FB - contention	7	100.0
enq: JQ - contention	2	100.0
enq: KO - fast object checkpoint	2	50.0			50.0
enq: PI - contention	4	100.0
enq: PS - contention	354	92.9	4.0	.8	.8	.6	.8
enq: TA - contention	1		100.0
enq: TD - KTF dump entries	1	100.0
enq: TT - contention	1	100.0
enq: WF - contention	16	100.0
gc cr block 2-way	90	100.0
gc cr block 3-way	74	100.0
gc cr block busy	5	100.0
gc cr grant 2-way	1	100.0
gc cr multi block request	182	100.0
gc current block 2-way	70	98.6				1.4
gc current block 3-way	116	100.0
gc current block busy	4	100.0
gc current grant 2-way	21	100.0
gc current grant busy	44	100.0
gc current multi block request	235	100.0
gcs log flush sync	30	93.3	6.7
ges inquiry response	45	93.3	6.7
ksxr poll remote instances	1024	100.0
latch free	12	100.0
latch: enqueue hash chains	2	100.0
latch: gcs resource hash	1	100.0
latch: ges resource hash list	24	91.7		8.3
latch: session allocation	14	100.0
latch: shared pool	21	90.5	4.8	4.8
library cache lock	44	100.0
library cache pin	60	98.3	1.7
library cache: mutex X	33	100.0
log file parallel write	52	98.1	1.9
log file sync	1	100.0
name-service call wait	4						25.0	75.0
os thread startup	7						42.9	57.1
rdbms ipc reply	319	92.8	6.9	.3
reliable message	158	86.7	3.8	.6	1.3		.6	7.0
row cache lock	30	100.0
ASM background timer	21								100.0
DIAG idle wait	3688	2.8	.5	.4	.2	.9	52.9	42.3
KSV master wait	62	100.0
PING	18	77.8							22.2
PX Deq Credit: send blkd	105	80.0	1.0	1.9	1.9	2.9	3.8	8.6
PX Deq: Execute Reply	119	23.5	.8	.8	.8		2.5	43.7	27.7
PX Deq: Execution Msg	874	61.9	9.4	5.3	1.5	3.0	3.3	9.7	5.9
PX Deq: Join ACK	56	73.2	10.7	1.8	1.8	3.6	7.1	1.8
PX Deq: Msg Fragment	2	100.0
PX Deq: Parse Reply	49	77.6	8.2	10.2	2.0	2.0
PX Deq: Table Q Normal	2	50.0					50.0
PX Idle Wait	2692			.7	1.4	.3	.1	3.8	93.8
SQL*Net message from client	60	46.7	8.3	5.0	5.0				35.0
Space Manager: slave idle wait	21								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	12							100.0
class slave wait	1	100.0
dispatcher timer	1								100.0
gcs remote message	7408	20.7	4.4	3.4	3.0	1.8	1.9	64.7
ges remote message	5009	52.1	7.0	4.2	4.5	4.5	4.4	23.4
jobq slave wait	20								100.0
pmon timer	44	20.5							79.5
rdbms ipc message	3851	37.1	1.9	2.3	1.4	2.0	2.9	39.2	13.3
shared server idle wait	3								100.0
smon timer	1								100.0
wait for unread message on broadcast channel	210							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_TWO	672	580	8,195	7,654
SYS$USERS	8	1	0	0
DEMO	0	0	0	0
D2	0	0	0	0
DEMOXDB	0	0	0	0
D_EIGHT	0	0	0	0
D_FOUR	0	0	0	0
SYS$BACKGROUND	0	0	0	1

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	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts
D_TWO	316	0	3
SYS$USERS	5	0	50
DEMO	0	0	7
D2	0	0	0
D_EIGHT	0	0	0
SYS$BACKGROUND	7	1	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): 680
Captured SQL account for 93.9% of Total
Total DB Time (s): 680
Captured PL/SQL account for 1.0% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
636	555	1	635.66	93.47	crqv3q3x9rtgt	SQL*Plus	select /* two / /+ pa...
7	0	1	6.69	0.98	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
1	0	10	0.09	0.13	7frqszzdu8sgg	racgimon@rsthpdbs101.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
0	0	1	0.50	0.07	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	1	0.18	0.03	350myuyx0t1d6		insert into wrh$_tablespace_st...
0	0	1	0.18	0.03	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
0	0	1	0.16	0.02	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	1	0.09	0.01	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
0	0	1	0.09	0.01	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...
0	0	0		0.01	arx2rgss6k33m	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT s.inst_id, s.name, i...

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): 582
Captured SQL account for 95.5% of Total
Total CPU Time (s): 582
Captured PL/SQL account for 0.1% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
555	636	1	554.64	95.32	93.47	crqv3q3x9rtgt	SQL*Plus	select /* two / /+ pa...
0	0	1	0.49	0.08	0.07	bunssq950snhf		insert into wrh$_sga_target_ad...
0	7	1	0.27	0.05	0.98	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0	1	10	0.02	0.04	0.13	7frqszzdu8sgg	racgimon@rsthpdbs101.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
0	0	1	0.09	0.02	0.02	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	1	0.09	0.02	0.01	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...
0	0	1	0.04	0.01	0.03	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
0	0	0		0.01	0.00	0v6s91manuhz8	emagent@rsthpdbs101.us.oracle.com (TNS V1-V3)	/* OracleOEM */ S...
0	0	0		0.00	0.01	8z3tqxkjw4sg4	sqlplus@rsthpdbs101.us.oracle.com (TNS V1-V3)	select px.SID "SID", ...
0	0	1	0.03	0.00	0.00	7g732rx16j8jc		insert into WRH$_SERVICE_STAT ...

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: 2,888,751
Captured SQL account for 94.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
2,711,331	1	2,711,331.00	93.86	554.64	635.66	crqv3q3x9rtgt	SQL*Plus	select /* two / /+ pa...
7,414	1	7,414.00	0.26	0.09	0.09	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...
5,325	1	5,325.00	0.18	0.27	6.69	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
3,515	1	3,515.00	0.12	0.09	0.16	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
839	1	839.00	0.03	0.01	0.01	6c06mfv01xt2h		update wrh$_seg_stat_obj sso ...
577	132	4.37	0.02	0.01	0.01	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
419	1	419.00	0.01	0.01	0.01	61tn3mam0vq0b		SELECT source, (case ...
384	1	384.00	0.01	0.01	0.00	6wm3n4d7bnddg		SELECT source, (case ...
377	1	377.00	0.01	0.01	0.01	4tg8mr2bvy6gr		select smontabv.cnt, smontab....
321	1	321.00	0.01	0.01	0.02	5ax5xu96u2ztd		insert into WRH$_EVENT_HISTOGR...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 3,145,071
Captured SQL account for 95.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
2,995,058	1	2,995,058.00	95.23	554.64	635.66	crqv3q3x9rtgt	SQL*Plus	select /* two / /+ pa...
5	1	5.00	0.00	0.27	6.69	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
3	1	3.00	0.00	0.00	0.03	dtj94u9jj2qj4		insert into wrh$_tablespace_sp...
1	1	1.00	0.00	0.09	0.16	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
1	4	0.25	0.00	0.00	0.02	fnz13xnvkybtj		INSERT INTO sys.wri$_adv_findi...
0	6	0.00	0.00	0.00	0.00	062savj8zgzut		UPDATE sys.wri$_adv_parameters...
0	0		0.00	0.03	0.03	0v6s91manuhz8	emagent@rsthpdbs101.us.oracle.com (TNS V1-V3)	/* OracleOEM */ S...
0	2	0.00	0.00	0.00	0.00	14wnf35dahb7v		SELECT A.ID, A.TYPE FROM SYS.W...
0	1	0.00	0.00	0.02	0.09	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
0	7	0.00	0.00	0.00	0.00	1jqqpfkr0m3yk		SELECT COUNT(*) FROM SYS.WRI$_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 789
Captured SQL account for 42.0% of Total

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

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 494
Captured SQL account for 59.9% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
81	10	16.40	7frqszzdu8sgg	racgimon@rsthpdbs101.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
37	0	7.49	fgqt3gak6vv8x	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT instance_name ...
32	0	6.48	arx2rgss6k33m	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT s.inst_id, s.name, i...
16	0	3.24	aqb79nn78dgyy	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT inst_id, service_name...
9	9	1.82	8x0funf899dka		INSERT INTO wri$_adv_addm_inst...
9	1	1.82	crqv3q3x9rtgt	SQL*Plus	select /* two / /+ pa...
8	0	1.62	8z3tqxkjw4sg4	sqlplus@rsthpdbs101.us.oracle.com (TNS V1-V3)	select px.SID "SID", ...
7	0	1.42	1mjhyad05m8pf	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT value ...
7	0	1.42	8j37z6cqf3s9h	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT value ...
6	6	1.21	062savj8zgzut		UPDATE sys.wri$_adv_parameters...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,136,045	0	0.11	0v6s91manuhz8	emagent@rsthpdbs101.us.oracle.com (TNS V1-V3)	/* OracleOEM */ S...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

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

Cluster Wait Time (s)	%Ela	%Total	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Module	SQL Text
0.06	0.89	47.69	6.69	0.27	1	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0.04	25.22	31.88	0.16	0.09	1	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.02	86.95	12.67	0.02	0.01	22	5yv0nj5hwfz5d		select job, nvl2(last_date, ...
0.01	34.09	5.30	0.02	0.00	4	fnz13xnvkybtj		INSERT INTO sys.wri$_adv_findi...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

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

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

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

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

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

1uk5m5qbzj1vt BEGIN dbms_workload_repository.create_snapshot; END;

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

4tg8mr2bvy6gr select smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time) smontabv where smontab.scn = smontabv.scnmax

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 )

5yv0nj5hwfz5d select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job

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'

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

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

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

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

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

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

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

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

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

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

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

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

crqv3q3x9rtgt select /* two */ /*+ 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

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

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

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

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

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

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

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

SQL Id	SQL Text
062savj8zgzut	UPDATE sys.wri$_adv_parameters SET datatype = :1, value = :2, flags = :3, description = :4 WHERE task_id = :5 AND name = :6
0v6s91manuhz8	/* OracleOEM */ SELECT blocking_sid, num_blocked FROM ( SELECT blocking_sid, SUM(num_blocked) num_blocked FROM ( SELECT l.id1, l.id2, MAX(DECODE(l.block, 1, i.instance_name\|\|'-'\|\|l.sid, 2, i.instance_name\|\|'-'\|\|l.sid, 0 )) blocking_sid, SUM(DECODE(l.request, 0, 0, 1 )) num_blocked FROM gv$lock l, gv$instance i WHERE ( l.block!= 0 OR l.request > 0 ) AND l.inst_id = i.inst_id GROUP BY l.id1, l.id2) GROUP BY blocking_sid ORDER BY num_blocked DESC) WHERE num_blocked != 0 AND blocking_sid != '0'
14wnf35dahb7v	SELECT A.ID, A.TYPE FROM SYS.WRI$_ADV_DEFINITIONS A WHERE A.NAME = :B1
1cq3qr774cu45	insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
1jqqpfkr0m3yk	SELECT COUNT(*) FROM SYS.WRI$_ADV_PARAMETERS A WHERE A.TASK_ID = :B2 AND A.NAME = :B1
1mjhyad05m8pf	SELECT value FROM gv$osstat WHERE inst_id = :p1 and stat_name='NUM_CPU_CORES'
1uk5m5qbzj1vt	BEGIN dbms_workload_repository.create_snapshot; END;
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
4tg8mr2bvy6gr	select smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time) smontabv where smontab.scn = smontabv.scnmax
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 )
5yv0nj5hwfz5d	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
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'
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC
7frqszzdu8sgg	select DECODE(UPPER(d.OPEN_MODE), 'READ WRITE', 'R', 'N') , DECODE(UPPER(i.STATUS), 'OPEN', 'O', 'N') into :b0, :b1 from v$database d , gv$instance i where i.INSTANCE_NAME=:b2
7g732rx16j8jc	insert into WRH$_SERVICE_STAT (snap_id, dbid, instance_number, service_name_hash, stat_id, value) select :snap_id, :dbid, :instance_number, stat.service_name_hash, stat.stat_id, stat.value from v$active_services asvc, v$service_stats stat where asvc.name_hash = stat.service_name_hash
7qjhf5dzmazsr	SELECT snap_id , OBJ#, DATAOBJ# FROM (SELECT /+ ordered use_nl(t2) index(t2) / t2.snap_id , t1.OBJN_KEWRSEG OBJ#, t1.OBJD_KEWRSEG DATAOBJ# FROM X$KEWRTSEGSTAT t1, WRH$_SEG_STAT_OBJ t2 WHERE t2.dbid(+) = :dbid AND t2.OBJ#(+) = t1.OBJN_KEWRSEG AND t2.DATAOBJ#(+) = t1.OBJD_KEWRSEG) WHERE nvl(snap_id, 0) < :snap_id
7vgmvmy8vvb9s	insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)
87gaftwrm2h68	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
8j37z6cqf3s9h	SELECT value FROM gv$osstat WHERE inst_id = :p1 and stat_name='NUM_CPUS'
8x0funf899dka	INSERT INTO wri$_adv_addm_inst ( TASK_ID, INSTANCE_NUMBER, INSTANCE_NAME, HOST_NAME, STATUS, DATABASE_TIME, ACTIVE_SESSIONS, PERC_ACTIVE_SESS, METER_LEVEL, LOCAL_TASK_ID) VALUES ( :tid, :inst_num, :inst_name, :host_name, :st, NULL, NULL, NULL, NULL, NULL)
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
aqb79nn78dgyy	SELECT inst_id, service_name, TO_CHAR(CAST(begin_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') time, TO_CHAR(CAST(end_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') time, intsize_csec, group_id, cpupercall, dbtimepercall, callspersec, dbtimepersec FROM gv$servicemetric_history WHERE service_name = :p1 AND end_time >= SYSDATE - 5/(60*24) AND group_id = 6 ORDER BY inst_id asc, end_time DESC
arx2rgss6k33m	SELECT s.inst_id, s.name, i.instance_name FROM gv$active_services s, gv$instance i WHERE s.name = :p1 AND s.inst_id = i.inst_id
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
crqv3q3x9rtgt	select /* two / /+ 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
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
fgqt3gak6vv8x	SELECT instance_name FROM gv$instance WHERE inst_id = :p1
fnz13xnvkybtj	INSERT INTO sys.wri$_adv_findings (id, task_id, type, parent, obj_id, impact_msg_id, impact_val, msg_id, more_info_id, name_msg_code, flags, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
fstp7x8vrq235	UPDATE SYS.WRI$_ADV_TASKS SET MTIME = SYSDATE, STATUS = NVL(:B4 , STATUS), CLEANUP = NVL(:B3 , CLEANUP), VERSION = NVL(:B2 , VERSION) WHERE ID = :B1
g4vrdfn14tp29	SELECT PROPERTY FROM SYS.WRI$_ADV_TASKS WHERE ID = :B1
gpb7chr15zyrs	SELECT PROPERTY FROM SYS.WRI$_ADV_DEFINITIONS WHERE ID = :B1
grzx1ww6wf4q2	SELECT A.FLAGS FROM SYS.WRI$_ADV_PARAMETERS A WHERE A.TASK_ID = :B2 AND A.NAME = :B1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	2	0.02	0.05
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	12	0.11	0.28
Batched IO buffer defrag count	1	0.01	0.02
Batched IO double miss count	2	0.02	0.05
Batched IO same unit count	7	0.07	0.16
Batched IO single block count	1	0.01	0.02
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	4	0.04	0.09
Batched IO vector read count	1	0.01	0.02
Block Cleanout Optim referenced	77	0.73	1.79
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	58,101	551.74	1,351.19
CPU used when call started	175,436	1,665.98	4,079.91
CR blocks created	2	0.02	0.05
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	42	0.40	0.98
DB time	95,535	907.22	2,221.74
DBWR checkpoint buffers written	136	1.29	3.16
DBWR checkpoints	1	0.01	0.02
DBWR fusion writes	6	0.06	0.14
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	54	0.51	1.26
DBWR undo block writes	84	0.80	1.95
DFO trees parallelized	11	0.10	0.26
DML statements parallelized	0	0.00	0.00
HSC Heap Segment Block Changes	332	3.15	7.72
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	107	1.02	2.49
Heap Segment Array Updates	2	0.02	0.05
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	184	1.75	4.28
PX local messages sent	184	1.75	4.28
PX remote messages recv'd	568	5.39	13.21
PX remote messages sent	648	6.15	15.07
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	11	0.10	0.26
RowCR - row contention	0	0.00	0.00
RowCR attempts	1	0.01	0.02
RowCR hits	1	0.01	0.02
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	60	0.57	1.40
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	61	0.58	1.42
application wait time	2	0.02	0.05
background timeouts	649	6.16	15.09
branch node splits	0	0.00	0.00
buffer is not pinned count	2,839	26.96	66.02
buffer is pinned count	10,761	102.19	250.26
bytes received via SQL*Net from client	66,704	633.44	1,551.26
bytes sent via SQL*Net to client	20,663	196.22	480.53
calls to get snapshot scn: kcmgss	14,251	135.33	331.42
calls to kcmgas	663	6.30	15.42
calls to kcmgcs	91	0.86	2.12
cell blocks helped by minscn optimization	2,865,613	27,212.51	66,642.16
cell blocks processed by cache layer	2,865,613	27,212.51	66,642.16
cell blocks processed by data layer	2,865,613	27,212.51	66,642.16
cell blocks processed by txn layer	2,865,613	27,212.51	66,642.16
cell physical IO bytes eligible for predicate offload	23,421,927,424	222,419,898.62	544,695,986.60
cell physical IO bytes saved during optimized file creation	0	0.00	0.00
cell physical IO interconnect bytes	19,473,986,552	184,929,362.82	452,883,408.19
cell scans	1,488	14.13	34.60
change write time	2	0.02	0.05
cleanout - number of ktugct calls	69	0.66	1.60
cleanouts and rollbacks - consistent read gets	7	0.07	0.16
cleanouts only - consistent read gets	6	0.06	0.14
cluster key scan block gets	38	0.36	0.88
cluster key scans	38	0.36	0.88
cluster wait time	12	0.11	0.28
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: block lost	25	0.24	0.58
commit cleanout failures: callback failure	4	0.04	0.09
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	361	3.43	8.40
commit cleanouts successfully completed	332	3.15	7.72
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	126	1.20	2.93
concurrency wait time	83	0.79	1.93
consistent changes	29	0.28	0.67
consistent gets	2,886,129	27,407.33	67,119.28
consistent gets - examination	1,604	15.23	37.30
consistent gets direct	2,859,122	27,150.87	66,491.21
consistent gets from cache	27,007	256.46	628.07
consistent gets from cache (fastpath)	25,133	238.67	584.49
current blocks converted for CR	0	0.00	0.00
cursor authentications	62	0.59	1.44
data blocks consistent reads - undo records applied	7	0.07	0.16
db block changes	2,443	23.20	56.81
db block gets	2,622	24.90	60.98
db block gets direct	0	0.00	0.00
db block gets from cache	2,622	24.90	60.98
db block gets from cache (fastpath)	686	6.51	15.95
deferred (CURRENT) block cleanout applications	165	1.57	3.84
dirty buffers inspected	0	0.00	0.00
enqueue conversions	223	2.12	5.19
enqueue releases	5,323	50.55	123.79
enqueue requests	5,381	51.10	125.14
enqueue timeouts	58	0.55	1.35
enqueue waits	427	4.05	9.93
exchange deadlocks	0	0.00	0.00
execute count	789	7.49	18.35
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	0	0.00	0.00
free buffer requested	1,694	16.09	39.40
gc CPU used by this session	28	0.27	0.65
gc blocks lost	0	0.00	0.00
gc cr block build time	0	0.00	0.00
gc cr block flush time	0	0.00	0.00
gc cr block receive time	5	0.05	0.12
gc cr block send time	2	0.02	0.05
gc cr blocks received	229	2.17	5.33
gc cr blocks served	218	2.07	5.07
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	11	0.10	0.26
gc current block send time	0	0.00	0.00
gc current blocks received	363	3.45	8.44
gc current blocks served	363	3.45	8.44
gc local grants	55	0.52	1.28
gc reader bypass grants	18	0.17	0.42
gc remote grants	126	1.20	2.93
gcs messages sent	3,902	37.05	90.74
ges messages sent	4,769	45.29	110.91
global enqueue get time	345	3.28	8.02
global enqueue gets async	159	1.51	3.70
global enqueue gets sync	5,730	54.41	133.26
global enqueue releases	5,062	48.07	117.72
heap block compress	9	0.09	0.21
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	13	0.12	0.30
immediate (CURRENT) block cleanout applications	115	1.09	2.67
index crx upgrade (positioned)	22	0.21	0.51
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fetch by key	681	6.47	15.84
index scans kdiixs1	4,520	42.92	105.12
leaf node 90-10 splits	19	0.18	0.44
leaf node splits	27	0.26	0.63
lob reads	0	0.00	0.00
lob writes	2	0.02	0.05
lob writes unaligned	2	0.02	0.05
logons cumulative	203	1.93	4.72
messages received	438	4.16	10.19
messages sent	438	4.16	10.19
min active SCN optimization applied to CR	0	0.00	0.00
no work - consistent read gets	11,494	109.15	267.30
opened cursors cumulative	772	7.33	17.95
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	6	0.06	0.14
parse count (total)	494	4.69	11.49
parse time cpu	9	0.09	0.21
parse time elapsed	14	0.13	0.33
physical IO disk bytes	30,482,078,720	289,464,685.63	708,885,551.63
physical read IO requests	39,538	375.46	919.49
physical read bytes	25,764,421,632	244,664,751.27	599,172,596.09
physical read total IO requests	40,926	388.64	951.77
physical read total bytes	25,786,990,592	244,879,071.19	599,697,455.63
physical read total multi block requests	39,290	373.11	913.72
physical reads	3,145,071	29,866.30	73,141.19
physical reads cache	5	0.05	0.12
physical reads cache prefetch	2	0.02	0.05
physical reads direct	3,145,066	29,866.26	73,141.07
physical reads direct temporary tablespace	285,944	2,715.39	6,649.86
physical reads prefetch warmup	2	0.02	0.05
physical write IO requests	9,336	88.66	217.12
physical write bytes	2,343,600,128	22,255,354.71	54,502,328.56
physical write total IO requests	9,492	90.14	220.74
physical write total bytes	2,346,683,904	22,284,638.94	54,574,044.28
physical write total multi block requests	9,227	87.62	214.58
physical writes	286,084	2,716.72	6,653.12
physical writes direct	285,944	2,715.39	6,649.86
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	285,944	2,715.39	6,649.86
physical writes from cache	140	1.33	3.26
physical writes non checkpoint	285,962	2,715.56	6,650.28
pinned buffers inspected	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	0	0.00	0.00
queries parallelized	11	0.10	0.26
recursive calls	6,258	59.43	145.53
recursive cpu usage	56,679	538.24	1,318.12
redo blocks checksummed by FG (exclusive)	1,930	18.33	44.88
redo blocks written	2,663	25.29	61.93
redo entries	1,368	12.99	31.81
redo ordering marks	80	0.76	1.86
redo size	1,311,264	12,452.06	30,494.51
redo size for direct writes	0	0.00	0.00
redo subscn max counts	90	0.85	2.09
redo synch time	0	0.00	0.00
redo synch writes	3	0.03	0.07
redo wastage	11,260	106.93	261.86
redo write broadcast ack time	1	0.01	0.02
redo write time	1	0.01	0.02
redo writer latching time	0	0.00	0.00
redo writes	51	0.48	1.19
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	0	0.00	0.00
rows fetched via callback	461	4.38	10.72
session connect time	0	0.00	0.00
session cursor cache hits	311	2.95	7.23
session logical reads	2,888,751	27,432.23	67,180.26
shared hash latch upgrades - no wait	179	1.70	4.16
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	4,356	41.37	101.30
sorts (rows)	11,498	109.19	267.40
sql area evicted	0	0.00	0.00
sql area purged	0	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	6	0.06	0.14
table fetch by rowid	6,294	59.77	146.37
table fetch continued row	0	0.00	0.00
table scan blocks gotten	2,860,816	27,166.95	66,530.60
table scan rows gotten	351,212,750	3,335,195.38	8,167,738.37
table scans (direct read)	1,488	14.13	34.60
table scans (long tables)	1,488	14.13	34.60
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	48	0.46	1.12
total number of times SMON posted	0	0.00	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	0	0.00	0.00
undo change vector size	451,152	4,284.24	10,491.91
user I/O wait time	7,098	67.40	165.07
user calls	1,075	10.21	25.00
user commits	23	0.22	0.53
user rollbacks	20	0.19	0.47
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	4,380	41.59	101.86
write clones created in background	0	0.00	0.00
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,615,790,954,992	1,621,193,944,720
session pga memory	1,158,767,737,592	1,159,232,633,240
session pga memory max	6,062,955,587,352	6,070,701,697,784
session cursor cache count	385,700	385,922
session uga memory	1,015,910,551,144	1,015,919,994,592
opened cursors current	57	58
logons current	42	42

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	9,187	87	0.57	31.01	9,222	88
UNDOTBS2	0	0	0.00	0.00	110	1
SYSAUX	3	0	10.00	1.67	0	0
SYSTEM	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)
SYSAUX	+DGA/demo/datafile/sysaux.417.686904815	3	0	10.00	1.67	0	0	0.00
SYSTEM	+DGA/demo/datafile/system.416.686904813	0	0			2	0	0.00
TEMP	+DGA/demo/tempfile/temp.419.686904819	9,187	87	0.57	31.01	9,222	88
UNDOTBS2	+DGA/demo/datafile/undotbs2.420.686904825	0	0			110	1	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	29,639	5	140	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	345	565	6920	1887390	6920
E	0	0	725	3044	9500	1887390	9500

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.13	527,391
D	896	0.18	106,526	1.01	472,062
D	1,344	0.27	159,789	1.01	471,081
D	1,792	0.36	213,052	1.00	470,486
D	2,240	0.45	266,315	1.00	469,963
D	2,688	0.55	319,578	1.00	469,687
D	3,136	0.64	372,841	1.00	469,656
D	3,584	0.73	426,104	1.00	469,601
D	4,032	0.82	479,367	1.00	468,227
D	4,480	0.91	532,630	1.00	468,227
D	4,928	1.00	585,893	1.00	468,227
D	5,376	1.09	639,156	1.00	468,227
D	5,824	1.18	692,419	1.00	468,225
D	6,272	1.27	745,682	1.00	468,219
D	6,720	1.36	798,945	1.00	468,219
D	7,168	1.45	852,208	1.00	468,217
D	7,616	1.55	905,471	1.00	468,217
D	8,064	1.64	958,734	1.00	468,217
D	8,512	1.73	1,011,997	1.00	468,217
D	8,960	1.82	1,065,260	0.98	458,658

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	14,708	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,883	366.37	0.00	0.00	0.00	0.00	1,048,576
E	12,288	10,749	417.27	0.00	0.00	0.00	0.00	1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

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

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	700,248.17	952,626.55	42.00	149	323,354,606
3,072	0.25	700,248.17	64,395.64	92.00	0	149,588,529
6,144	0.50	700,248.17	189.87	100.00	0	137,027,848
9,216	0.75	700,248.17	189.87	100.00	0	137,027,848
12,288	1.00	700,248.17	189.87	100.00	0	137,027,848
14,746	1.20	700,248.17	0.00	100.00	0	136,990,704
17,203	1.40	700,248.17	0.00	100.00	0	136,990,704
19,661	1.60	700,248.17	0.00	100.00	0	136,990,704
22,118	1.80	700,248.17	0.00	100.00	0	136,990,704
24,576	2.00	700,248.17	0.00	100.00	0	136,990,704
36,864	3.00	700,248.17	0.00	100.00	0	136,990,704
49,152	4.00	700,248.17	0.00	100.00	0	136,990,704
73,728	6.00	700,248.17	0.00	100.00	0	136,990,704
98,304	8.00	700,248.17	0.00	100.00	0	136,990,704

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	3	131	11,482	1.00	856	1.00	56
1,024	1.00	131	5,719	11,483	1.00	855	1.00	2,401
1,152	1.13	216	10,134	11,501	1.00	837	0.98	2,402
1,280	1.25	216	10,134	11,501	1.00	837	0.98	2,402
1,408	1.38	216	10,134	11,501	1.00	837	0.98	2,402
1,536	1.50	216	10,134	11,501	1.00	837	0.98	2,402
1,664	1.63	216	10,134	11,501	1.00	837	0.98	2,402
1,792	1.75	216	10,134	11,501	1.00	837	0.98	2,402
1,920	1.88	216	10,134	11,501	1.00	837	0.98	2,402
2,048	2.00	216	10,134	11,501	1.00	837	0.98	2,402

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	274,777	527,364
2,304	0.38	274,557	472,066
3,072	0.50	274,530	470,474
3,840	0.63	274,530	469,959
4,608	0.75	274,530	469,632
5,376	0.88	274,530	468,227
6,144	1.00	274,530	468,227
6,912	1.13	274,530	468,227
7,680	1.25	274,530	468,227
8,448	1.38	274,530	468,227
9,216	1.50	274,530	468,227
9,984	1.63	274,503	458,675
10,752	1.75	274,503	458,675
11,520	1.88	274,503	458,675
12,288	2.00	274,503	458,675

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	509	488	21	355	0.99
CO-KTUCLO Master Slave enq (master slave det)	35	0	35	35	1.43
WF-AWR Flush	20	20	0	16	1.25
CF-Controlfile Transaction	223	223	0	4	2.50
PI-Remote PX Process Spawn Status	4	4	0	4	2.50
TA-Instance Undo	1	1	0	1	10.00
FB-Format Block	4	4	0	4	0.00
AF-Advisor Framework (task serialization)	13	13	0	2	0.00
JQ-Job Queue	2	0	2	2	0.00
KO-Multiple Object Checkpoint (fast object checkpoint)	9	9	0	2	0.00
TD-KTF map table enqueue (KTF dump entries)	1	1	0	1	0.00
TT-Tablespace	2,769	2,769	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	279	0.00		0
ASM map operation freelist	72	0.00		0
ASM map operation hash table	120,071	0.01	0.00	0
ASM network background latch	44	0.00		0
AWR Alerted Metric Element list	823	0.00		0
Change Notification Hash table latch	35	0.00		0
Consistent RBA	51	0.00		0
DML lock allocation	60,700	0.00		0
Event Group Locks	8	0.00		0
FOB s.o list latch	33	0.00		0
File State Object Pool Parent Latch	1	0.00		0
IPC stats buffer allocation latch	462	0.00		479	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	1	0.00		0
JS broadcast add buf latch	24	0.00		0
JS broadcast drop buf latch	24	0.00		0
JS broadcast load blnc latch	21	0.00		0
JS queue access latch	1	0.00		0
JS queue state obj latch	1,260	0.00		0
JS slv state obj latch	7	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KFK SGA Libload latch	1,232	0.00		0
KFMD SGA	3,603	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	939	0.00		636	0.16
KJCT flow control latch	13,127	0.02	0.00	0
KMG MMAN ready and startup request latch	35	0.00		0
KSXR large replies	8	0.00		0
KTF sga latch	2	0.00		34	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		35	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	1,107	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	52	0.00		0
OS process allocation	73	0.00		0
OS process: request allocation	10	0.00		0
PL/SQL warning settings	209	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	283	1.41	1.50	0
SGA IO buffer pool latch	1	0.00		1	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	2	0.00		35	0.00
SQL memory manager workarea list latch	2,630	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,016	0.00		0
active service list	6,322	0.09	0.50	44	0.00
archive control	10	0.00		0
buffer pool	1	0.00		0
business card	23	0.00		0
cache buffer handles	124	0.00		0
cache buffers chains	66,370	0.00		5,163	0.00
cache buffers lru chain	2,728	0.00		4,692	0.00
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	13	0.00		0
channel operations parent latch	94,959	0.01	0.00	0
checkpoint queue latch	4,178	0.00		550	0.00
client/application info	1,116	0.00		0
commit callback allocation	1	0.00		0
compile environment latch	203	0.00		0
cp cmon/server latch	1	0.00		0
cp pool latch	1	0.00		0
cp server hash latch	1	0.00		0
cp sga latch	2	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	2	0.00		0
dml lock allocation	2	0.00		0
done queue latch	1	0.00		0
dummy allocation	407	0.49	0.00	0
enqueue hash chains	17,936	0.25	0.05	1	0.00
enqueues	9,731	0.20	0.05	0
error message lists	203	0.00		0
fifth spare latch	1	0.00		0
file cache latch	59	0.00		0
flashback copy	1	0.00		0
gc element	5,203	0.00		5	0.00
gcs commit scn state	1	0.00		0
gcs opaque info freelist	922	0.00		0
gcs partitioned table hash	298,086	0.00		59	0.00
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	20	0.00		0
gcs remastering latch	80	0.00		0
gcs resource freelist	2	0.00		18	0.00
gcs resource hash	5,861	0.02	2.00	0
gcs resource scan list	1	0.00		0
gcs shadows freelist	905	0.00		1,092	0.00
ges caches resource lists	5,485	0.04	1.00	2,402	0.00
ges deadlock list	442	0.00		0
ges domain table	10,227	0.00		0
ges enqueue table freelist	12,969	0.02	0.00	0
ges group table	15,299	0.00		0
ges process hash list	12,548	0.00		0
ges process parent latch	25,620	0.00		0
ges process table freelist	10	0.00		0
ges resource hash list	26,333	0.36	0.26	1,173	0.17
ges resource scan list	3	0.00		0
ges resource table freelist	2,093	0.00		0
ges timeout list	188	0.00		46	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			32	0.00
hash table modification latch	2	0.00		0
heartbeat check	1	0.00		21	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		4	0.00
job_queue_processes parameter latch	25	0.00		0
k2q global data latch	70	0.00		0
k2q lock allocation	1	0.00		0
kcfis stats shared latch	8	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kks stats	8	0.00		0
kokc descriptor allocation latch	82	0.00		0
ksfv messages	1	0.00		0
ksim membership request latch	660	0.00		95	0.00
kss move lock	3	0.00		0
ksuosstats global area	52	0.00		0
ksv allocation latch	6	0.00		0
ksv class latch	133	0.00		0
ksv msg queue latch	1	0.00		0
ksxp shared latch	10	0.00		0
ksz_so allocation latch	27	0.00		0
ktm global data	2	0.00		0
kwqbsn:qsga	3	0.00		0
lgwr LWN SCN	78	0.00		0
list of block allocation	22	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	3	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,966	0.00		0
messages	9,272	0.11	0.00	0
mostly latch-free SCN	78	0.00		0
msg queue latch	1	0.00		0
multiblock read objects	556	0.00		0
name-service memory objects	584	0.00		0
name-service namespace bucket	1,038	0.00		0
name-service pending queue	72	0.00		0
name-service request	8	0.00		0
name-service request queue	1,315	0.00		0
ncodef allocation latch	2	0.00		0
object queue header heap	283	0.00		89	0.00
object queue header operation	53,457	0.00		0
object stats modification	2,482	0.00		0
parallel query alloc buffer	2,193	0.05	0.00	0
parallel query stats	234	0.43	0.00	0
parallel txn reco latch	1,053	0.00		0
parameter list	38	0.00		0
parameter table management	406	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	75	0.00		37	0.00
process allocation	485	0.00		7	0.00
process group creation	10	0.00		0
process queue	915	0.00		0
process queue reference	28,357	0.00	0.00	1,840	469.57
qmn task queue latch	12	0.00		0
query server freelists	630	0.32	0.00	0
query server process	4	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	208	0.00		1,352	0.00
redo copy	1	0.00		1,352	0.00
redo writing	271	0.00		0
reid allocation latch	17	0.00		0
resmgr group change latch	290	0.00		0
resmgr:active threads	421	0.00		0
resmgr:actses change group	202	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	406	0.49	0.50	0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	55	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	21,504	0.00	0.00	0
second spare latch	1	0.00		0
sequence cache	29	0.00		0
session allocation	3,352	0.72	0.75	0
session idle bit	2,187	0.05	0.00	0
session queue latch	1	0.00		0
session state list latch	406	0.25	0.00	0
session switching	3	0.00		0
session timer	44	0.00		0
shared pool	16,579	0.38	0.46	0
shared pool sim alloc	2	0.00		0
shared pool simulator	13	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	1,220	0.00		0
simulator lru latch	1	0.00		1,191	0.00
sort extent pool	2,928	0.96	0.00	0
space background state object latch	2	0.00		0
space background task latch	80	0.00		70	0.00
state object free list	2	0.00		0
statistics aggregation	1,792	0.00		0
storage server table manipulation latch	121	0.00		0
tablespace key chain	1,511	0.00		0
temp lob duration state obj allocation	1	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
third spare latch	1	0.00		0
threshold alerts latch	2	0.00		0
transaction allocation	14,939	0.00		0
undo global data	7,553	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
ges resource hash list	26,333	96	25	72
shared pool	16,579	63	29	42
enqueue hash chains	17,936	44	2	42
session allocation	3,352	24	18	10
enqueues	9,731	19	1	18
active service list	6,322	6	3	3
Real-time plan statistics latch	283	4	6	0
ges caches resource lists	5,485	2	2	0
resmgr:free threads list	406	2	1	1
gcs resource hash	5,861	1	2	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
Real-time plan statistics latch	keswxAddNewPlanEntry	6	6
active service list	ksws_event: ksws event	3	3
enqueue hash chains	ksqrcl	2	0
enqueues	ksqdel	1	1
gcs resource hash	kjbassume	2	0
ges resource hash list	kjrmas1: lookup master node	10	0
ges resource hash list	kjuscl: lock close request	6	8
ges resource hash list	kjakcai: search for resp by resname	4	3
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	2	0
ges resource hash list	kjrref: find matched resource	2	10
ges resource hash list	kjucvl: lock convert request	1	0
ges resource table freelist	kjruch: cached obj cleanup	2	0
resmgr:free threads list	kskthrcreate	1	1
session allocation	ksuxds: KSUSFCLC not set	11	9
session allocation	kxfprdp	4	3
session allocation	ksuxds: not user session	2	2
session allocation	kxfpqidqr:1	1	4
shared pool	kghfre	18	18
shared pool	kghalo	11	11

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kgllkdl1 85	10
Library Cache	kglhdgn2 106	5
Library Cache	kglpnal2 91	4
Library Cache	kglget2 2	3
Library Cache	kglpnal1 90	3
Library Cache	kgllkal1 80	2
Library Cache	kglpnck1 88	2
Library Cache	kglpndl1 95	2
Library Cache	kgllkc1 57	1
Library Cache	kglpin1 4	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: 2,888,751
Captured Segments account for 9.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
D31	D31	DWB_RTL_TRX	90512_H010	TABLE SUBPARTITION	11,744	0.41
D31	D31	DWB_RTL_TRX	90507_H046	TABLE SUBPARTITION	10,272	0.36
D31	D31	DWB_RTL_TRX	90503_H005	TABLE SUBPARTITION	10,240	0.35
D31	D31	DWB_RTL_TRX	90525_H041	TABLE SUBPARTITION	10,240	0.35
D31	D31	DWB_RTL_TRX	90520_H011	TABLE SUBPARTITION	9,696	0.34

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 3,145,071
Captured Segments account for 3.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
D31	D31	DWB_RTL_TRX	90510_H025	TABLE SUBPARTITION	3,890	0.12
D31	D31	DWB_RTL_TRX	90523_H021	TABLE SUBPARTITION	3,890	0.12
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	AILABLE **	UNDEFINED	3,888	0.12
D31	D31	DWB_RTL_TRX	90508_H010	TABLE SUBPARTITION	3,884	0.12
D31	D31	DWB_RTL_TRX	90531_H060	TABLE SUBPARTITION	3,884	0.12

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 3,145,066
Captured Segments account for 3.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
D31	D31	DWB_RTL_TRX	90510_H025	TABLE SUBPARTITION	3,890	0.12
D31	D31	DWB_RTL_TRX	90523_H021	TABLE SUBPARTITION	3,890	0.12
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	AILABLE **	UNDEFINED	3,888	0.12
D31	D31	DWB_RTL_TRX	90508_H010	TABLE SUBPARTITION	3,884	0.12
D31	D31	DWB_RTL_TRX	90531_H060	TABLE SUBPARTITION	3,884	0.12

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: 1,488
Captured Segments account for 3.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	AILABLE **	UNDEFINED	2	0.13
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	AILABLE **	UNDEFINED	2	0.13
D31	D31	DWB_RTL_TRX	90501_H032	TABLE SUBPARTITION	2	0.13
D31	D31	DWB_RTL_TRX	90503_H005	TABLE SUBPARTITION	2	0.13
D31	D31	DWB_RTL_TRX	90505_H005	TABLE SUBPARTITION	2	0.13

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_PK		INDEX	160	16.95
SYS	SYSAUX	WRI$_ADV_PARAMETERS		TABLE	144	15.25
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	75138_1021	INDEX PARTITION	64	6.78
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	75138_1021	INDEX PARTITION	48	5.08
SYS	SYSAUX	SYS_C001762		INDEX	32	3.39

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 229
Captured Segments account for 58.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSAUX	WRM$_DATABASE_INSTANCE		TABLE	24	10.48
SYS	SYSAUX	WRH$_SYS_TIME_MODEL	75138_1021	TABLE PARTITION	11	4.80
SYS	SYSAUX	WRI$_ADV_ADDM_FDG		TABLE	8	3.49
SYS	SYSAUX	WRM$_SNAPSHOT		TABLE	8	3.49
SYS	SYSAUX	WRI$_ADV_ADDM_TASKS		TABLE	7	3.06

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 363
Captured Segments account for 49.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	75138_1021	INDEX PARTITION	43	11.85
SYS	SYSAUX	WRM$_SNAPSHOT		TABLE	10	2.75
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	AILABLE **	UNDEFINED	8	2.20
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM	75138_1021	TABLE PARTITION	8	2.20
SYS	SYSAUX	WRH$_SYSMETRIC_SUMMARY_INDEX		INDEX	8	2.20

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Dictionary Cache Stats
Dictionary Cache Stats (RAC)

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	6	0.00	2	1
dc_global_oids	56	0.00	0	129
dc_histogram_data	60	0.00	0	2,067
dc_histogram_defs	31	0.00	0	3,268
dc_object_grants	16	0.00	0	283
dc_objects	319	13.79	0	4,091
dc_rollback_segments	2,205	0.00	0	1,055
dc_segments	14	0.00	0	986
dc_sequences	1	100.00	1	2
dc_tablespaces	4,196	0.00	0	50
dc_users	115	0.00	0	106
global database name	100	0.00	0	1

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts	GES Releases
dc_awr_control	4	0	0
dc_objects	28	0	0
dc_sequences	2	0	0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Library Cache Activity
Library Cache Activity (RAC)

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss
BODY	7	0.00	17	0.00
SQL AREA	345	1.74	1,769	0.68
TABLE/PROCEDURE	117	0.00	607	0.00

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases	GES Inval Requests	GES Invali- dations
TABLE/PROCEDURE	524	599	0	0	0

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	333.22		3.06	5.92	31	32	109	108
	Freeable	18.63	0.00	1.10	1.61	7		17	17
	PL/SQL	18.62	2.11	0.42	2.27	15	15	44	44
	SQL	9.43	6.96	0.47	1.86	8	9	20	17
E	Other	374.76		3.32	6.00	32	159	113	112
	Freeable	27.94	0.00	1.12	1.34	7		25	25
	PL/SQL	18.62	2.11	0.33	2.01	15	15	56	44
	SQL	9.49	7.01	0.30	1.48	8	638	32	17

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	64.00	64.00	0.00
large	PX msg pool	54.00	54.00	0.00
large	free memory	9.63	9.63	0.00
shared	ASH buffers	15.50	15.50	0.00
shared	CCursor	17.06	17.11	0.30
shared	FileOpenBlock	11.21	11.21	0.00
shared	KCL name table	48.00	48.00	0.00
shared	PL/SQL DIANA	19.03	19.03	0.00
shared	PL/SQL MPCODE	14.26	14.26	0.00
shared	db_block_hash_buckets	44.50	44.50	0.00
shared	event statistics per sess	12.32	12.32	0.00
shared	free memory	295.06	294.90	-0.05
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	28.60	28.60	0.00
shared	sessions	11.96	11.96	0.00
shared	sql area	106.83	106.89	0.05
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	2
local_listener	LISTENER_DEMO2
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, D_TWO, D2, DEMO
sessions	1131
sga_target	6442450944
spfile	+DGA/demo/spfiledemo.ora
thread	2
undo_tablespace	UNDOTBS2

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	415	3.94	9.65
acks for commit broadcast(logical)	418	3.97	9.72
broadcast msgs on commit(actual)	332	3.15	7.72
broadcast msgs on commit(logical)	336	3.19	7.81
broadcast msgs on commit(wasted)	13	0.12	0.30
broadcast on commit wait time(ms)	3	0.03	0.07
broadcast on commit waits	11	0.10	0.26
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	0	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	357	3.39	8.30
gcs ast xid	0	0.00	0.00
gcs blocked converts	424	4.03	9.86
gcs blocked cr converts	182	1.73	4.23
gcs compatible basts	11	0.10	0.26
gcs compatible cr basts (global)	6	0.06	0.14
gcs compatible cr basts (local)	29	0.28	0.67
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	2	0.02	0.05
gcs dbwr write request msgs	2	0.02	0.05
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	5	0.05	0.12
gcs immediate (null) converts	17	0.16	0.40
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	1	0.01	0.02
gcs indirect ast	55	0.52	1.28
gcs indirect bidless ast	31	0.29	0.72
gcs indirect fg ast	44	0.42	1.02
gcs lms flush pi msgs	9	0.09	0.21
gcs lms write request msgs	5	0.05	0.12
gcs msgs process time(ms)	33	0.31	0.77
gcs msgs received	3,968	37.68	92.28
gcs new served by master	16	0.15	0.37
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	1	0.01	0.02
gcs pkey conflicts retry	0	0.00	0.00
gcs queued converts	0	0.00	0.00
gcs reader bypass N->Xw ping local	0	0.00	0.00
gcs reader bypass N->Xw ping remote	13	0.12	0.30
gcs reader bypass grant X on assume	13	0.12	0.30
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	18	0.17	0.42
gcs reader bypass grant immediate	20	0.19	0.47
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	67	0.64	1.56
gcs retry convert request	718	6.82	16.70
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	69	0.66	1.60
gcs side channel msgs logical	549	5.21	12.77
gcs stale cr	0	0.00	0.00
gcs undo cr	2	0.02	0.05
gcs write notification msgs	0	0.00	0.00
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	53	0.50	1.23
ges msgs received	4,727	44.89	109.93
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	38	0.36	0.88
implicit batch messages sent	59	0.56	1.37
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	300	2.85	6.98
messages queue sent actual	4,468	42.43	103.91
messages queue sent logical	4,612	43.80	107.26
messages received actual	6,846	65.01	159.21
messages received logical	8,695	82.57	202.21
messages sent directly	1,946	18.48	45.26
messages sent indirectly	1,582	15.02	36.79
messages sent not implicit batched	4,409	41.87	102.53
messages sent pbatched	5,816	55.23	135.26
msgs causing lmd to send msgs	2,055	19.51	47.79
msgs causing lms(s) to send msgs	716	6.80	16.65
msgs received queue time (ms)	4	0.04	0.09
msgs received queued	8,695	82.57	202.21
msgs sent queue time (ms)	20,219,489	192,008.82	470,220.67
msgs sent queue time on ksxp (ms)	1,965	18.66	45.70
msgs sent queued	4,533	43.05	105.42
msgs sent queued on ksxp	6,651	63.16	154.67
process batch messages received	3,577	33.97	83.19
process batch messages sent	3,865	36.70	89.88

Global CR Served Stats

Statistic	Total
CR Block Requests	57
CURRENT Block Requests	162
Data Block Requests	57
Undo Block Requests	0
TX Block Requests	107
Current Results	219
Private results	0
Zero Results	0
Disk Read Results	0
Fail Results	0
Fairness Down Converts	16
Fairness Clears	13
Free GC Elements	0
Flushes	5
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	363	100.00	0.00	0.00
Flushes	7	71.43	28.57	0.00
Writes	6	0.00	33.33	66.67

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	data block	37	97.30	2.70	0.00	78	100.00	0.00	0.00
1	data block	32	100.00	0.00	0.00	48	95.83	4.17	0.00
8	data block	9	100.00	0.00	0.00	62	100.00	0.00	0.00
7	data block	17	100.00	0.00	0.00	47	100.00	0.00	0.00
4	data block	16	100.00	0.00	0.00	48	95.83	4.17	0.00
3	data block	18	100.00	0.00	0.00	24	100.00	0.00	0.00
6	data block	10	100.00	0.00	0.00	19	100.00	0.00	0.00
5	Others	11	100.00	0.00	0.00	9	100.00	0.00	0.00
5	undo header	16	68.75	31.25	0.00	1	100.00	0.00	0.00
1	undo header	11	100.00	0.00	0.00	4	100.00	0.00	0.00
8	Others	9	100.00	0.00	0.00	5	100.00	0.00	0.00
1	Others	6	100.00	0.00	0.00	7	100.00	0.00	0.00
7	undo header	9	100.00	0.00	0.00	1	100.00	0.00	0.00
6	undo header	9	100.00	0.00	0.00	0
7	Others	4	100.00	0.00	0.00	4	100.00	0.00	0.00
4	Others	3	100.00	0.00	0.00	5	100.00	0.00	0.00
4	undo header	7	100.00	0.00	0.00	1	100.00	0.00	0.00
3	undo header	4	100.00	0.00	0.00	2	100.00	0.00	0.00
3	Others	1	100.00	0.00	0.00	3	100.00	0.00	0.00
8	undo header	2	100.00	0.00	0.00	1	100.00	0.00	0.00
6	Others	0				1	100.00	0.00	0.00
5	undo block	1	100.00	0.00	0.00	0

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer Times (ms)

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

Inst No	Block Class	All	Immed	Busy	All	Immed	Busy
		CR Avg Time (ms)			Current Avg Time (ms)
5	data block	0.23	0.21	0.96	0.25	0.25
1	data block	0.23	0.23		0.25	0.24	0.32
8	data block	0.23	0.23		0.20	0.20
4	data block	0.21	0.21		0.22	0.22	0.25
7	data block	0.20	0.20		0.24	0.24
3	data block	0.21	0.21		0.88	0.88
6	data block	0.18	0.18		0.27	0.27
5	others	0.15	0.15		0.17	0.17
5	undo header	0.27	0.12	0.58	0.13	0.13
1	undo header	0.11	0.11		0.14	0.14
8	others	0.19	0.19		0.19	0.19
1	others	0.21	0.21		0.20	0.20
7	undo header	0.12	0.12		0.13	0.13
6	undo header	0.12	0.12
4	undo header	0.14	0.14		0.12	0.12
4	others	0.13	0.13		0.19	0.19
7	others	0.17	0.17		0.17	0.17
3	undo header	0.13	0.13		0.11	0.11
3	others	0.12	0.12		0.12	0.12
8	undo header	0.15	0.15		0.15	0.15
5	undo block	0.11	0.11
6	others				0.26	0.26
7	undo block
4	undo block
1	undo block
8	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	data block	0	36	44.44	55.56	78	57.69	42.31
1	data block	0	32	21.88	78.13	46	17.39	82.61
8	data block	0	9	22.22	77.78	62	35.48	64.52
7	data block	0	17	23.53	76.47	47	19.15	80.85
4	data block	0	16	18.75	81.25	46	67.39	32.61
3	data block	0	18	27.78	72.22	24	29.17	70.83
6	data block	0	10	10.00	90.00	19	42.11	57.89
5	others	0	11	72.73	27.27	9	66.67	33.33
1	undo header	0	11	100.00	0.00	4	100.00	0.00
8	others	0	9	0.00	100.00	5	0.00	100.00
1	others	0	6	0.00	100.00	7	0.00	100.00
5	undo header	0	11	100.00	0.00	1	100.00	0.00
7	undo header	0	9	100.00	0.00	1	100.00	0.00
6	undo header	0	9	100.00	0.00	0
4	undo header	0	7	100.00	0.00	1	100.00	0.00
4	others	0	3	66.67	33.33	5	60.00	40.00
7	others	0	4	0.00	100.00	4	25.00	75.00
3	undo header	0	4	100.00	0.00	2	100.00	0.00
3	others	0	1	100.00	0.00	3	100.00	0.00
8	undo header	0	2	100.00	0.00	1	100.00	0.00
5	undo block	0	1	100.00	0.00	0
6	others	0	0			1	0.00	100.00
7	undo block	0	0			0
4	undo block	0	0			0
1	undo block	0	0			0
8	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	data block	0.21	0.15	0.25	0.25	0.23	0.28
1	data block	0.23	0.23	0.23	0.24	0.20	0.25
8	data block	0.23	0.21	0.23	0.20	0.15	0.23
7	data block	0.20	0.16	0.21	0.24	0.17	0.25
4	data block	0.21	0.17	0.22	0.22	0.19	0.26
3	data block	0.21	0.18	0.23	0.88	2.37	0.27
6	data block	0.18	0.12	0.19	0.27	0.20	0.32
5	others	0.15	0.13	0.19	0.17	0.16	0.19
1	undo header	0.11	0.11		0.14	0.14
8	others	0.19		0.19	0.19		0.19
1	others	0.21		0.21	0.20		0.20
5	undo header	0.12	0.12		0.13	0.13
7	undo header	0.12	0.12		0.13	0.13
6	undo header	0.12	0.12
4	undo header	0.14	0.14		0.12	0.12
4	others	0.13	0.12	0.16	0.19	0.18	0.19
7	others	0.17		0.17	0.17	0.13	0.18
3	undo header	0.13	0.13		0.11	0.11
3	others	0.12	0.12		0.12	0.12
8	undo header	0.15	0.15		0.15	0.15
5	undo block	0.11	0.11
6	others				0.26		0.26
7	undo block
4	undo block
1	undo block
8	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	4	1.11	0.21	4	1.09	0.20
2	4	1.11	0.20	4	1.09	0.20
3	4	0.93	0.18	4	0.95	0.20
4	4	0.90	0.18	4	0.89	0.18
5	4	0.85	0.18	4	0.85	0.18
6	4	0.86	0.14	4	0.86	0.15
7	4	0.84	0.15	4	0.82	0.14
8	4	0.79	0.14	4	0.77	0.14

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.04	0.04
Parallel Query	0.03	0.02
DB Locks	0.02	0.02
DB Streams	0.00	0.00
Other	0.00	0.00

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics

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

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

Back to Interconnect Stats
Back to Top

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.98	In-memory Sort %:	100.00
Library Hit %:	99.50	Soft Parse %:	98.79
Execute to Parse %:	37.39	Latch Hit %:	99.97
Parse CPU to Parse Elapsd %:	0.01	% Non-Parse CPU:	99.98

Buffer access - local cache %:	97.99
Buffer access - remote cache %:	2.00
Buffer access - disk %:	0.02

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

Avg message sent queue time (ms):	4,460.5
Avg message sent queue time on ksxp (ms):	0.3
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:	50.84
% of indirect sent messages:	41.33
% of flow controlled messages:	7.84