WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

DEMO 3430975138 DEMO3 3 26-Jun-09 00:06 11.1.0.7.0 YES

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

Host Name Platform CPUs Cores Sockets Memory (GB)

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

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

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 916 27-Jun-09 17:53:39 41 1.3

End Snap: 917 27-Jun-09 17:56:00 41 1.4

Elapsed: 2.34 (mins)

DB Time: 5.40 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	916	27-Jun-09 17:53:39	41	1.3
End Snap:	917	27-Jun-09 17:56:00	41	1.4
Elapsed:		2.34 (mins)
DB Time:		5.40 (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): 2.3 5.1 0.23 0.43

DB CPU(s): 1.4 3.1 0.14 0.26

Redo size: 10,123.2 22,247.1

Logical reads: 7,026.6 15,441.8

Block changes: 26.1 57.4

Physical reads: 11,104.0 24,402.6

Physical writes: 4,197.3 9,224.1

User calls: 5.4 11.8

Parses: 7.6 16.6

Hard parses: 0.4 0.9

W/A MB processed: 154,645.9 339,856.0

Logons: 1.0 2.1

Executes: 10.2 22.5

Rollbacks: 0.3 0.7

Transactions: 0.5

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	2.3	5.1	0.23	0.43
DB CPU(s):	1.4	3.1	0.14	0.26
Redo size:	10,123.2	22,247.1
Logical reads:	7,026.6	15,441.8
Block changes:	26.1	57.4
Physical reads:	11,104.0	24,402.6
Physical writes:	4,197.3	9,224.1
User calls:	5.4	11.8
Parses:	7.6	16.6
Hard parses:	0.4	0.9
W/A MB processed:	154,645.9	339,856.0
Logons:	1.0	2.1
Executes:	10.2	22.5
Rollbacks:	0.3	0.7
Transactions:	0.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 96.42 Soft Parse %: 94.64

Execute to Parse %: 26.11 Latch Hit %: 100.00

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

Shared Pool Statistics

Begin End

Memory Usage %: 70.58 70.79

% SQL with executions>1: 88.91 93.90

% Memory for SQL w/exec>1: 79.25 86.51

	Begin	End
Memory Usage %:	70.58	70.79
% SQL with executions>1:	88.91	93.90
% Memory for SQL w/exec>1:	79.25	86.51

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		197		60.84
direct path read temp	19,045	96	5	29.65	User I/O
direct path write temp	19,043	15	1	4.61	User I/O
PX Deq: reap credit	620,364	10	0	3.10	Other
cell smart table scan	1,758	2	1	0.69	User I/O

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

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

0.11 1.45 15.9 2.1 0.0 81.1

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.11	1.45	15.9	2.1	0.0	81.1

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

17.6 93.2 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
17.6	93.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): 436.1 435.7

% Host Mem used for SGA+PGA: 20.44 20.44

	Begin	End
Host Mem (MB):	32,189.6	32,189.6
SGA use (MB):	6,144.0	6,144.0
PGA use (MB):	436.1	435.7
% Host Mem used for SGA+PGA:	20.44	20.44

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: 3.83 8.41

Global Cache blocks served: 4.78 10.52

GCS/GES messages received: 45.17 99.27

GCS/GES messages sent: 49.18 108.08

DBWR Fusion writes: 0.02 0.05

Estd Interconnect traffic (KB) 87.31

	Per Second	Per Transaction
Global Cache blocks received:	3.83	8.41
Global Cache blocks served:	4.78	10.52
GCS/GES messages received:	45.17	99.27
GCS/GES messages sent:	49.18	108.08
DBWR Fusion writes:	0.02	0.05
Estd Interconnect traffic (KB)	87.31

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

Buffer access - local cache %: 96.81

Buffer access - remote cache %: 3.18

Buffer access - disk %: 0.01

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1

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

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

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

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

Global cache log flushes for cr blocks served %: 1.8

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

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 648.0

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

% of indirect sent messages: 30.51

% of flow controlled messages: 5.54

Cluster Interconnect

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

Main Report

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

Wait Events Statistics

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

Time Model Statistics

Total time in database user-calls (DB Time): 324.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	315.83	97.45
DB CPU	197.19	60.84
PL/SQL execution elapsed time	0.67	0.21
parse time elapsed	0.17	0.05
hard parse elapsed time	0.12	0.04
hard parse (sharing criteria) elapsed time	0.11	0.04
sequence load elapsed time	0.00	0.00
PL/SQL compilation elapsed time	0.00	0.00
repeated bind elapsed time	0.00	0.00
DB time	324.10
background elapsed time	1.68
background cpu time	0.79

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Statistic	Value	End Value
BUSY_TIME	21,240
IDLE_TIME	91,096
IOWAIT_TIME	29
NICE_TIME	0
SYS_TIME	2,347
USER_TIME	17,881
LOAD	0	1
PHYSICAL_MEMORY_BYTES	33,753,260,032
NUM_CPUS	8
NUM_CPU_CORES	8
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	2,097,152
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
27-Jun 17:53:39	0.11
27-Jun 17:56:00	1.45	18.91	15.92	2.09	0.03	81.09

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			197		60.84
User I/O	39,896	0	114	3	35.14
Other	644,453	100	12	0	3.58
System I/O	1,268	0	1	0	0.19
Concurrency	380	0	0	0	0.04
Cluster	538	0	0	0	0.03
Application	30	0	0	0	0.00
Network	87	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
direct path read temp	19,045	0	96	5	297.58	29.65
direct path write temp	19,043	0	15	1	297.55	4.61
PX Deq: reap credit	620,364	100	10	0	9,693.19	3.10
cell smart table scan	1,758	2	2	1	27.47	0.69
control file sequential read	1,268	0	1	0	19.81	0.19
cell single block physical read	50	0	1	13	0.78	0.19
reliable message	133	0	1	5	2.08	0.19
PX Deq: Slave Session Stats	142	0	0	2	2.22	0.07
PX Nsq: PQ load info query	1	100	0	201	0.02	0.06
enq: PS - contention	417	44	0	0	6.52	0.05
PX Deq: Signal ACK RSG	73	51	0	2	1.14	0.05
library cache pin	194	0	0	0	3.03	0.03
IPC send completion sync	582	99	0	0	9.09	0.02
PX qref latch	22,649	100	0	0	353.89	0.02
enq: WF - contention	16	0	0	3	0.25	0.02
gc current block 3-way	220	0	0	0	3.44	0.01
library cache lock	167	0	0	0	2.61	0.01
gc cr block 3-way	123	0	0	0	1.92	0.01
PX Deq: Signal ACK EXT	26	0	0	0	0.41	0.00
gc current block 2-way	90	0	0	0	1.41	0.00
gc current grant busy	33	0	0	0	0.52	0.00
gc current block busy	7	0	0	1	0.11	0.00
row cache lock	18	0	0	0	0.28	0.00
gc cr block 2-way	41	0	0	0	0.64	0.00
rdbms ipc reply	34	0	0	0	0.53	0.00
SQL*Net break/reset to client	28	0	0	0	0.44	0.00
gc current grant 2-way	20	0	0	0	0.31	0.00
SQL*Net message from client	87	0	270	3103	1.36
PX Deq: Execute Reply	787	10	134	170	12.30
PX Deq: Execution Msg	688	6	113	165	10.75
PX Deq Credit: send blkd	75,594	0	87	1	1,181.16
jobq slave wait	10	100	30	3001	0.16
Streams AQ: waiting for messages in the queue	16	88	14	876	0.25
PX Deq: Table Q Normal	37,322	0	14	0	583.16
PX Deq Credit: need buffer	26,504	0	14	1	414.13
PX Deq: Join ACK	126	16	0	2	1.97
PX Deq: Parse Reply	98	1	0	1	1.53

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
control file sequential read	319	0	0	1	4.98	24.38
control file parallel write	47	0	0	2	0.73	4.79
DFS lock handle	152	99	0	1	2.38	4.61
log file parallel write	232	0	0	0	3.63	2.63
PX Deq: reap credit	3,949	100	0	0	61.70	2.22
enq: CO - master slave det	46	100	0	1	0.72	1.89
ges inquiry response	50	0	0	0	0.78	1.23
os thread startup	1	0	0	17	0.02	1.00
CGS wait for IPC msg	1,167	100	0	0	18.23	0.46
gcs log flush sync	30	0	0	0	0.47	0.37
ksxr poll remote instances	527	100	0	0	8.23	0.24
gc current block 2-way	19	0	0	0	0.30	0.19
enq: TM - contention	2	100	0	1	0.03	0.16
enq: CF - contention	5	100	0	1	0.08	0.15
gc cr block 3-way	6	0	0	0	0.09	0.10
gc current block 3-way	6	0	0	0	0.09	0.09
db file parallel write	4	0	0	0	0.06	0.08
ASM file metadata operation	28	0	0	0	0.44	0.08
LGWR wait for redo copy	23	0	0	0	0.36	0.07
PX Idle Wait	3,817	97	9,448	2475	59.64
rdbms ipc message	3,950	53	2,530	641	61.72
smon timer	1	100	300	300010	0.02
gcs remote message	9,181	71	281	31	143.45
DIAG idle wait	4,373	93	281	64	68.33
wait for unread message on broadcast channel	280	100	280	1001	4.38
shared server idle wait	5	100	150	30000	0.08
Streams AQ: qmn slave idle wait	5	0	143	28609	0.08
Streams AQ: qmn coordinator idle wait	10	50	143	14304	0.16
pmon timer	50	94	141	2820	0.78
ges remote message	4,461	32	140	31	69.70
ASM background timer	28	0	140	5005	0.44
Space Manager: slave idle wait	28	100	140	5001	0.44
PING	35	14	125	3571	0.55
dispatcher timer	2	100	120	60001	0.03

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	28	100.0
CGS wait for IPC msg	1166	100.0
DFS lock handle	152	89.5	5.9	2.6	2.0
IPC send completion sync	582	97.4	1.5	.9	.2
KJC: Wait for msg sends to complete	1	100.0
LGWR wait for redo copy	23	100.0
PX Deq: Signal ACK EXT	26	88.5	3.8	3.8	3.8
PX Deq: Signal ACK RSG	73	82.2	8.2	6.8	1.4			1.4
PX Deq: Slave Session Stats	142	54.2	23.2	16.9	3.5	2.1
PX Deq: reap credit	624K	100.0	.0	.0
PX Nsq: PQ load info query	1							100.0
PX qref latch	22K	100.0
SQL*Net break/reset to client	28	100.0
SQL*Net message to client	87	100.0
cell single block physical read	50		2.0	6.0	62.0	26.0		4.0
cell smart table scan	1758	65.3	21.2	8.2	2.0	3.0	.3	.1
control file parallel write	47	68.1	12.8	10.6	4.3	4.3
control file sequential read	1587	91.1	3.3	2.0	2.4	1.1	.1
db file parallel write	4	100.0
direct path read temp	19K	17.2	6.0	19.8	42.0	14.3	.5	.2
direct path write temp	19K	65.9	23.5	8.6	1.8	.2		.0
enq: AF - task serialization	1	100.0
enq: CF - contention	5	100.0
enq: CO - master slave det	47	85.1	12.8	2.1
enq: FB - contention	1	100.0
enq: JQ - contention	1	100.0
enq: KO - fast object checkpoint	3	100.0
enq: PS - contention	417	91.1	5.3	2.6	1.0
enq: TA - contention	1	100.0
enq: TD - KTF dump entries	1	100.0
enq: TM - contention	2	50.0		50.0
enq: TT - contention	2	100.0
enq: WF - contention	16	87.5	6.3					6.3
gc cr block 2-way	47	100.0
gc cr block 3-way	138	100.0
gc cr block busy	1	100.0
gc cr multi block request	2	100.0
gc current block 2-way	124	100.0
gc current block 3-way	220	100.0
gc current block busy	3	33.3	66.7
gc current grant 2-way	19	100.0
gc current grant busy	35	100.0
gc current multi block request	1	100.0
gcs log flush sync	42	95.2	2.4	2.4
ges inquiry response	51	92.2	5.9	2.0
ksxr poll remote instances	516	100.0
latch free	1	100.0
latch: cache buffers chains	1	100.0
latch: ges resource hash list	2	100.0
latch: session allocation	8	100.0
latch: shared pool	1	100.0
library cache lock	74	98.6		1.4
library cache pin	86	100.0
library cache: mutex X	1	100.0
log file parallel write	233	98.7		.9	.4
os thread startup	1						100.0
rdbms ipc reply	39	100.0
reliable message	133	92.5	4.5	2.3				.8
row cache lock	10	100.0
ASM background timer	28								100.0
DIAG idle wait	4364	3.1	.4	.5	.3	.8	36.8	58.2
KSV master wait	84	100.0
PING	35	85.7							14.3
PX Deq Credit: need buffer	26K	86.0	8.5	4.6	.7	.1	.0
PX Deq Credit: send blkd	75K	79.0	13.0	6.3	1.4	.2	.0	.0	.0
PX Deq: Execute Reply	787	21.3	4.4	4.4	7.4	10.5	14.1	31.1	6.6
PX Deq: Execution Msg	688	42.7	14.0	18.3	10.6	4.1	1.2	2.8	6.4
PX Deq: Join ACK	126	88.1	6.3	1.6	1.6	.8		1.6
PX Deq: Parse Reply	98	86.7	6.1	3.1	1.0	2.0	1.0
PX Deq: Table Q Normal	37K	92.3	4.8	2.4	.4	.0		.0
PX Idle Wait	3804	.3		.0	.1	.2	.1	2.2	97.2
SQL*Net message from client	87	34.5	26.4	5.7					33.3
Space Manager: slave idle wait	29								100.0
Streams AQ: RAC qmn coordinator idle wait	10	100.0
Streams AQ: qmn coordinator idle wait	10	40.0	10.0						50.0
Streams AQ: qmn slave idle wait	5								100.0
Streams AQ: waiting for messages in the queue	16							100.0
dispatcher timer	2								100.0
gcs remote message	8829	16.7	2.7	2.2	1.7	1.4	1.9	73.4
ges remote message	4212	40.2	4.7	5.4	3.9	4.1	4.1	37.7
jobq slave wait	10								100.0
pmon timer	50	6.0							94.0
rdbms ipc message	3942	25.8	1.1	1.6	2.2	1.3	1.4	49.2	17.5
shared server idle wait	5								100.0
smon timer	1								100.0
wait for unread message on broadcast channel	281							100.0

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
D_EIGHT	322	196	12,351	7,644
SYS$USERS	1	0	0	0
SYS$BACKGROUND	0	0	0	3
D3	0	0	0	0
DEMO	0	0	0	0
DEMOXDB	0	0	0	0
D_FOUR	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Network Total Wts
D_EIGHT	39896	114	389	3
SYS$USERS	0	0	1	84
SYS$BACKGROUND	0	0	2	0
DEMO	0	0	0	0
D_FOUR	0	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
311	195	1	311.18	96.01	7b1a4ngy9q7kc	SQL*Plus	select /* eight / /+ paralle...
3	1	1	2.65	0.82	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
1	0	1	0.51	0.16	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	14	0.04	0.15	7frqszzdu8sgg	racgimon@host102.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
0	0	1	0.43	0.13	350myuyx0t1d6		insert into wrh$_tablespace_st...
0	0	1	0.31	0.09	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
0	0	1	0.25	0.08	f318xdxdn0pdc		insert into wrh$_log (s...
0	0	1	0.18	0.06	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
0	0	1	0.14	0.04	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	1	0.07	0.02	71y370j6428cb		insert into wrh$_thread (s...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total is the CPU Time divided into the Total CPU Time times 100
Total CPU Time (s): 197
Captured SQL account for 99.3% of Total
Total CPU Time (s): 197
Captured PL/SQL account for 0.6% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
195	311	1	194.84	98.81	96.01	7b1a4ngy9q7kc	SQL*Plus	select /* eight / /+ paralle...
1	3	1	1.02	0.52	0.82	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0	1	1	0.50	0.25	0.16	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	14	0.01	0.06	0.15	7frqszzdu8sgg	racgimon@host102.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
0	0	1	0.10	0.05	0.04	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	1	0.07	0.03	0.09	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
0	0	1	0.05	0.02	0.01	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...
0	0	381	0.00	0.02	0.00	3c1kubcdjnppq		update sys.col_usage$ set eq...
0	0	1	0.02	0.01	0.06	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
0	0	1	0.02	0.01	0.01	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: 988,278
Captured SQL account for 99.6% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
971,917	1	971,917.00	98.34	194.84	311.18	7b1a4ngy9q7kc	SQL*Plus	select /* eight / /+ paralle...
13,211	1	13,211.00	1.34	1.02	2.65	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
6,502	1	6,502.00	0.66	0.05	0.05	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...
3,467	1	3,467.00	0.35	0.10	0.14	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
1,291	381	3.39	0.13	0.04	0.01	3c1kubcdjnppq		update sys.col_usage$ set eq...
710	1	710.00	0.07	0.01	0.01	6c06mfv01xt2h		update wrh$_seg_stat_obj sso ...
583	132	4.42	0.06	0.01	0.01	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
427	1	427.00	0.04	0.02	0.02	61tn3mam0vq0b		SELECT source, (case ...
382	1	382.00	0.04	0.01	0.00	6wm3n4d7bnddg		SELECT source, (case ...
382	95	4.02	0.04	0.01	0.00	g00cj285jmgsw		update sys.mon_mods$ set inser...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 1,561,769
Captured SQL account for 100.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,561,768	1	1,561,768.00	100.00	194.84	311.18	7b1a4ngy9q7kc	SQL*Plus	select /* eight / /+ paralle...
1	1	1.00	0.00	1.02	2.65	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
1	132	0.01	0.00	0.01	0.01	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
1	1	1.00	0.00	0.10	0.14	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	6	0.00	0.00	0.00	0.00	062savj8zgzut		UPDATE sys.wri$_adv_parameters...
0	2	0.00	0.00	0.00	0.00	14wnf35dahb7v		SELECT A.ID, A.TYPE FROM SYS.W...
0	1	0.00	0.00	0.01	0.01	18qf2n840jchr		INSERT INTO WRH$_ACTIVE_SESSIO...
0	1	0.00	0.00	0.02	0.18	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
0	7	0.00	0.00	0.00	0.00	1jqqpfkr0m3yk		SELECT COUNT(*) FROM SYS.WRI$_...
0	2	0.00	0.00	0.00	0.01	1pu1hgtzs05tb		SELECT dbin.instance_number, ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 1,440
Captured SQL account for 69.4% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
381	381	1.00	0.00	0.00	3c1kubcdjnppq		update sys.col_usage$ set eq...
146	0	0.00	0.00	0.00	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
132	132	1.00	0.00	0.00	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
95	0	0.00	0.00	0.00	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
95	95	1.00	0.00	0.00	g00cj285jmgsw		update sys.mon_mods$ set inser...
14	14	1.00	0.01	0.04	7frqszzdu8sgg	racgimon@host102.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
11	11	1.00	0.00	0.00	g4vrdfn14tp29		SELECT PROPERTY FROM SYS.WRI$_...
9	9	1.00	0.00	0.00	8x0funf899dka		INSERT INTO wri$_adv_addm_inst...
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$_...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,064
Captured SQL account for 68.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
146	381	13.72	3c1kubcdjnppq		update sys.col_usage$ set eq...
146	146	13.72	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
112	14	10.53	7frqszzdu8sgg	racgimon@host102.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
95	95	8.93	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
95	95	8.93	g00cj285jmgsw		update sys.mon_mods$ set inser...
9	9	0.85	8x0funf899dka		INSERT INTO wri$_adv_addm_inst...
8	0	0.75	1rsnjtn0upcut	sqlplus@host101.us.oracle.com (TNS V1-V3)	select px.SID "SID", ...
6	6	0.56	062savj8zgzut		UPDATE sys.wri$_adv_parameters...
6	6	0.56	grwydz59pu6mc		select text from view$ where r...
5	1	0.47	7b1a4ngy9q7kc	SQL*Plus	select /* eight / /+ paralle...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

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

Cluster Wait Time (s)	%Ela	%Total	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Module	SQL Text
0.08	3.17	87.01	2.65	1.02	1	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0.02	15.80	23.47	0.14	0.10	1	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

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

18qf2n840jchr INSERT INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, ecid ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a. seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.ecid FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)

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

1pu1hgtzs05tb SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time

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

1uk5m5qbzj1vt BEGIN dbms_workload_repository.create_snapshot; END;

350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait

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#

3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln

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

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

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

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

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

71y370j6428cb insert into wrh$_thread (snap_id, dbid, instance_number, thread#, thread_instance_number, status, open_time, current_group#, sequence#) select :snap_id, :dbid, :instance_number, t.thread#, i.instance_number, t.status, t.open_time, t.current_group#, t.sequence# from v$thread t, v$instance i where i.thread#(+) = t.thread#

7b1a4ngy9q7kc select /* eight */ /*+ parallel (t1, 16) parallel (t2, 16) */ min(t1.BSNS_UNIT_KEY + t2.BSNS_UNIT_KEY ) , max(t1.DAY_KEY + t2.DAY_KEY), avg(t1.DAY_KEY + t2.DAY_KEY), max(t1.BSNS_UNIT_TYP_CD ), max(t2.CURR_IND) , max(t1.LOAD_DT) from retail.DWB_RTL_TRX t1 , retail.DWB_RTL_TRX t2 where t1.TRX_NBR = t2.TRX_NBR

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)

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)

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

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

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

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

g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

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

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

grwydz59pu6mc select text from view$ where rowid=:1

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
14wnf35dahb7v	SELECT A.ID, A.TYPE FROM SYS.WRI$_ADV_DEFINITIONS A WHERE A.NAME = :B1
18qf2n840jchr	INSERT INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, ecid ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a. seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.ecid FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
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
1pu1hgtzs05tb	SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time
1rsnjtn0upcut	select px.SID "SID", p.PID, p.SPID "SPID", px.INST_ID "Inst", px.SERVER_GROUP "Group", px.SERVER_SET "Set", px.DEGREE "Degree", px.REQ_DEGREE "Req Degree", w.event "Wait Event" from GV$SESSION s, GV$PX_SESSION px, GV$PROCESS p, GV$SESSION_WAIT w where s.sid (+) = px.sid and s.inst_id (+) = px.inst_id and s.sid = w.sid (+) and s.inst_id = w.inst_id (+) and s.paddr = p.addr (+) and s.inst_id = p.inst_id (+) ORDER BY decode(px.QCINST_ID, NULL, px.INST_ID, px.QCINST_ID), px.QCSID, decode(px.SERVER_GROUP, NULL, 0, px.SERVER_GROUP), px.SERVER_SET, px.INST_ID
1uk5m5qbzj1vt	BEGIN dbms_workload_repository.create_snapshot; END;
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
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#
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
5h7w8ykwtb2xt	INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
61tn3mam0vq0b	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMB ERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6c06mfv01xt2h	update wrh$_seg_stat_obj sso set (index_type, base_obj#, base_object_name, base_object_owner) = (select decode(ind.type#, 1, 'NORMAL'\|\| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner from sys.ind$ ind, sys.user$ base_owner, sys.obj$ base_obj where ind.obj# = sso.obj# and ind.dataobj# = sso.dataobj# and ind.bo# = base_obj.obj# and base_obj.owner# = base_owner.user#) where sso.dbid = :dbid and (obj#, dataobj#) in (select objn_kewrseg, objd_kewrseg from x$kewrtsegstat ss1 where objtype_kewrseg = 1) and sso.snap_id = :lah_snap_id and sso.object_type = 'INDEX'
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
71y370j6428cb	insert into wrh$_thread (snap_id, dbid, instance_number, thread#, thread_instance_number, status, open_time, current_group#, sequence#) select :snap_id, :dbid, :instance_number, t.thread#, i.instance_number, t.status, t.open_time, t.current_group#, t.sequence# from v$thread t, v$instance i where i.thread#(+) = t.thread#
7b1a4ngy9q7kc	select /* eight / /+ parallel (t1, 16) parallel (t2, 16) */ min(t1.BSNS_UNIT_KEY + t2.BSNS_UNIT_KEY ) , max(t1.DAY_KEY + t2.DAY_KEY), avg(t1.DAY_KEY + t2.DAY_KEY), max(t1.BSNS_UNIT_TYP_CD ), max(t2.CURR_IND) , max(t1.LOAD_DT) from retail.DWB_RTL_TRX t1 , retail.DWB_RTL_TRX t2 where t1.TRX_NBR = t2.TRX_NBR
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)
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)
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
f318xdxdn0pdc	insert into wrh$_log (snap_id, dbid, instance_number, group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time) select :snap_id, :dbid, :instance_number, group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time from v$log
fstp7x8vrq235	UPDATE SYS.WRI$_ADV_TASKS SET MTIME = SYSDATE, STATUS = NVL(:B4 , STATUS), CLEANUP = NVL(:B3 , CLEANUP), VERSION = NVL(:B2 , VERSION) WHERE ID = :B1
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g4vrdfn14tp29	SELECT PROPERTY FROM SYS.WRI$_ADV_TASKS WHERE ID = :B1
gpb7chr15zyrs	SELECT PROPERTY FROM SYS.WRI$_ADV_DEFINITIONS WHERE ID = :B1
grwydz59pu6mc	select text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	2	0.01	0.03
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	13	0.09	0.20
Batched IO buffer defrag count	1	0.01	0.02
Batched IO double miss count	3	0.02	0.05
Batched IO same unit count	7	0.05	0.11
Batched IO single block count	2	0.01	0.03
Batched IO vector block count	4	0.03	0.06
Batched IO vector read count	1	0.01	0.02
Block Cleanout Optim referenced	23	0.16	0.36
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	19,667	139.83	307.30
CPU used when call started	174,220	1,238.69	2,722.19
CR blocks created	0	0.00	0.00
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	4	0.03	0.06
DB time	60,947	433.33	952.30
DBWR checkpoint buffers written	4	0.03	0.06
DBWR checkpoints	1	0.01	0.02
DBWR fusion writes	3	0.02	0.05
DBWR transaction table writes	0	0.00	0.00
DBWR undo block writes	0	0.00	0.00
DFO trees parallelized	15	0.11	0.23
HSC Heap Segment Block Changes	782	5.56	12.22
Heap Segment Array Inserts	89	0.63	1.39
Heap Segment Array Updates	0	0.00	0.00
PX local messages recv'd	44,993	319.90	703.02
PX local messages sent	44,993	319.90	703.02
PX remote messages recv'd	308,407	2,192.74	4,818.86
PX remote messages sent	314,386	2,235.25	4,912.28
Parallel operations not downgraded	15	0.11	0.23
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	87	0.62	1.36
active txn count during cleanout	88	0.63	1.38
application wait time	0	0.00	0.00
background timeouts	864	6.14	13.50
branch node splits	0	0.00	0.00
buffer is not pinned count	3,557	25.29	55.58
buffer is pinned count	10,556	75.05	164.94
bytes received via SQL*Net from client	91,406	649.89	1,428.22
bytes sent via SQL*Net to client	27,795	197.62	434.30
calls to get snapshot scn: kcmgss	2,106	14.97	32.91
calls to kcmgas	740	5.26	11.56
calls to kcmgcs	82	0.58	1.28
cell blocks helped by minscn optimization	974,578	6,929.15	15,227.78
cell blocks processed by cache layer	974,578	6,929.15	15,227.78
cell blocks processed by data layer	974,578	6,929.15	15,227.78
cell blocks processed by txn layer	974,578	6,929.15	15,227.78
cell physical IO bytes eligible for predicate offload	7,957,487,616	56,576,922.81	124,335,744.00
cell physical IO interconnect bytes	18,760,890,512	133,388,012.09	293,138,914.25
cell scans	71	0.50	1.11
change write time	7	0.05	0.11
cleanout - number of ktugct calls	71	0.50	1.11
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	3	0.02	0.05
cluster key scan block gets	135	0.96	2.11
cluster key scans	134	0.95	2.09
cluster wait time	10	0.07	0.16
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: block lost	21	0.15	0.33
commit cleanout failures: callback failure	4	0.03	0.06
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	596	4.24	9.31
commit cleanouts successfully completed	571	4.06	8.92
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	51	0.36	0.80
concurrency wait time	12	0.09	0.19
consistent changes	17	0.12	0.27
consistent gets	984,988	7,003.16	15,390.44
consistent gets - examination	2,796	19.88	43.69
consistent gets direct	971,373	6,906.36	15,177.70
consistent gets from cache	13,615	96.80	212.73
consistent gets from cache (fastpath)	10,579	75.22	165.30
cursor authentications	56	0.40	0.88
data blocks consistent reads - undo records applied	0	0.00	0.00
db block changes	3,672	26.11	57.38
db block gets	3,290	23.39	51.41
db block gets direct	0	0.00	0.00
db block gets from cache	3,290	23.39	51.41
db block gets from cache (fastpath)	632	4.49	9.88
deferred (CURRENT) block cleanout applications	303	2.15	4.73
dirty buffers inspected	6	0.04	0.09
enqueue conversions	326	2.32	5.09
enqueue releases	8,124	57.76	126.94
enqueue requests	8,238	58.57	128.72
enqueue timeouts	114	0.81	1.78
enqueue waits	495	3.52	7.73
exchange deadlocks	0	0.00	0.00
execute count	1,440	10.24	22.50
free buffer inspected	612	4.35	9.56
free buffer requested	635	4.51	9.92
gc CPU used by this session	21	0.15	0.33
gc blocks lost	0	0.00	0.00
gc cr block build time	0	0.00	0.00
gc cr block flush time	0	0.00	0.00
gc cr block receive time	3	0.02	0.05
gc cr block send time	1	0.01	0.02
gc cr blocks received	191	1.36	2.98
gc cr blocks served	220	1.56	3.44
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	7	0.05	0.11
gc current block send time	1	0.01	0.02
gc current blocks received	347	2.47	5.42
gc current blocks served	453	3.22	7.08
gc local grants	72	0.51	1.13
gc reader bypass grants	25	0.18	0.39
gc remote grants	55	0.39	0.86
gcs messages sent	3,572	25.40	55.81
ges messages sent	3,345	23.78	52.27
global enqueue get time	65	0.46	1.02
global enqueue gets async	38	0.27	0.59
global enqueue gets sync	8,328	59.21	130.13
global enqueue releases	7,772	55.26	121.44
heap block compress	5	0.04	0.08
hot buffers moved to head of LRU	13	0.09	0.20
immediate (CR) block cleanout applications	3	0.02	0.05
immediate (CURRENT) block cleanout applications	82	0.58	1.28
index crx upgrade (positioned)	30	0.21	0.47
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fetch by key	1,395	9.92	21.80
index scans kdiixs1	4,369	31.06	68.27
leaf node 90-10 splits	12	0.09	0.19
leaf node splits	28	0.20	0.44
lob reads	0	0.00	0.00
lob writes	2	0.01	0.03
lob writes unaligned	2	0.01	0.03
logons cumulative	133	0.95	2.08
messages received	413	2.94	6.45
messages sent	413	2.94	6.45
min active SCN optimization applied to CR	0	0.00	0.00
no work - consistent read gets	9,788	69.59	152.94
opened cursors cumulative	1,317	9.36	20.58
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	57	0.41	0.89
parse count (total)	1,064	7.56	16.63
parse time cpu	7	0.05	0.11
parse time elapsed	6	0.04	0.09
physical IO disk bytes	22,502,519,808	159,990,613.57	351,601,872.00
physical read IO requests	30,080	213.87	470.00
physical read bytes	12,794,011,648	90,964,113.84	199,906,432.00
physical read total IO requests	31,716	225.50	495.56
physical read total bytes	12,820,414,464	91,151,835.16	200,318,976.00
physical read total multi block requests	29,846	212.20	466.34
physical reads	1,561,769	11,104.02	24,402.64
physical reads cache	1	0.01	0.02
physical reads cache prefetch	0	0.00	0.00
physical reads direct	1,561,768	11,104.01	24,402.63
physical reads direct temporary tablespace	590,395	4,197.65	9,224.92
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	19,050	135.44	297.66
physical write bytes	4,836,065,280	34,383,929.36	75,563,520.00
physical write total IO requests	19,423	138.10	303.48
physical write total bytes	4,839,897,600	34,411,176.76	75,623,400.00
physical write total multi block requests	19,045	135.41	297.58
physical writes	590,340	4,197.26	9,224.06
physical writes direct	590,333	4,197.21	9,223.95
physical writes direct temporary tablespace	590,333	4,197.21	9,223.95
physical writes from cache	7	0.05	0.11
physical writes non checkpoint	590,336	4,197.23	9,224.00
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	3	0.02	0.05
process last non-idle time	0	0.00	0.00
queries parallelized	15	0.11	0.23
recursive calls	10,045	71.42	156.95
recursive cpu usage	19,600	139.35	306.25
redo blocks checksummed by FG (exclusive)	1,755	12.48	27.42
redo blocks written	2,973	21.14	46.45
redo entries	1,924	13.68	30.06
redo ordering marks	62	0.44	0.97
redo size	1,423,812	10,123.16	22,247.06
redo size for direct writes	0	0.00	0.00
redo subscn max counts	57	0.41	0.89
redo synch time	0	0.00	0.00
redo synch writes	2	0.01	0.03
redo wastage	65,792	467.77	1,028.00
redo write broadcast ack time	6	0.04	0.09
redo write time	6	0.04	0.09
redo writer latching time	0	0.00	0.00
redo writes	232	1.65	3.63
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	0	0.00	0.00
rows fetched via callback	580	4.12	9.06
session connect time	0	0.00	0.00
session cursor cache hits	515	3.66	8.05
session logical reads	988,278	7,026.56	15,441.84
shared hash latch upgrades - no wait	131	0.93	2.05
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	456	3.24	7.13
sorts (rows)	15,298	108.77	239.03
sql area evicted	0	0.00	0.00
sql area purged	0	0.00	0.00
summed dirty queue length	4	0.03	0.06
switch current to new buffer	4	0.03	0.06
table fetch by rowid	6,250	44.44	97.66
table fetch continued row	5	0.04	0.08
table scan blocks gotten	971,910	6,910.18	15,186.09
table scan rows gotten	119,301,194	848,219.28	1,864,081.16
table scans (direct read)	71	0.50	1.11
table scans (long tables)	71	0.50	1.11
table scans (rowid ranges)	71	0.50	1.11
table scans (short tables)	44	0.31	0.69
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	495,872	3,525.60	7,748.00
user I/O wait time	11,390	80.98	177.97
user calls	752	5.35	11.75
user commits	22	0.16	0.34
user rollbacks	42	0.30	0.66
workarea executions - onepass	2	0.01	0.03
workarea executions - optimal	411	2.92	6.42
write clones created in background	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	53,054,955,360	55,608,627,064
session pga memory	423,849,205,368	424,142,567,832
session pga memory max	1,025,076,756,664	1,031,750,310,872
session cursor cache count	245,760	245,781
session uga memory	1,043,481,276,280	1,043,487,463,104
opened cursors current	55	56
workarea memory allocated	374	374
logons current	41	41

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	19,045	135	1.71	31.00	19,043	135
SYSAUX	1	0	0.00	1.00	6	0
SYSTEM	0	0	0.00	0.00	1	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	1	0	0.00	1.00	6	0	0.00
SYSTEM	+DGA/demo/datafile/system.416.686904813	0	0			1	0	0.00
TEMP	+DGA/demo/tempfile/temp.419.686904819	19,045	135	1.71	31.00	19,043	135

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	16,906	1	7	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	262	576	11214	1887390	11214
E	0	0	691	3545	14246	1887390	14246

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.00	12,771,329
D	896	0.18	106,526	1.00	12,766,044
D	1,344	0.27	159,789	1.00	12,763,895
D	1,792	0.36	213,052	1.00	12,762,255
D	2,240	0.45	266,315	1.00	12,761,491
D	2,688	0.55	319,578	1.00	12,758,418
D	3,136	0.64	372,841	1.00	12,758,036
D	3,584	0.73	426,104	1.00	12,757,925
D	4,032	0.82	479,367	1.00	12,757,766
D	4,480	0.91	532,630	1.00	12,757,575
D	4,928	1.00	585,893	1.00	12,757,320
D	5,376	1.09	639,156	1.00	12,757,288
D	5,824	1.18	692,419	1.00	12,757,161
D	6,272	1.27	745,682	1.00	12,724,398
D	6,720	1.36	798,945	0.94	12,007,991
D	7,168	1.45	852,208	0.94	12,006,924
D	7,616	1.55	905,471	0.94	12,005,778
D	8,064	1.64	958,734	0.94	12,005,746
D	8,512	1.73	1,011,997	0.86	11,021,695
D	8,960	1.82	1,065,260	0.86	11,020,708

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
50.15	3,653	3,632

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,870	436.13	0.37	0.08	100.00	0.00	1,048,576
E	12,288	10,838	435.69	0.37	0.08	100.00	0.00	1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs
2K	4K	383	383	0
64K	128K	4	4	0
512K	1024K	20	20	0
1M	2M	4	4	0
1G	2G	2	0	2

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

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

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)
768	0.75	82	7,699	6,237	1.00	65	1.00	1,424
896	0.88	90	8,402	6,237	1.00	65	1.00	1,554
1,024	1.00	90	8,402	6,237	1.00	65	1.00	1,554
1,152	1.13	90	8,402	6,237	1.00	65	1.00	1,554
1,280	1.25	90	8,402	6,237	1.00	65	1.00	1,554
1,408	1.38	90	8,402	6,237	1.00	65	1.00	1,554
1,536	1.50	90	8,402	6,237	1.00	65	1.00	1,554
1,664	1.63	90	8,402	6,237	1.00	65	1.00	1,554
1,792	1.75	90	8,402	6,237	1.00	65	1.00	1,554
1,920	1.88	90	8,402	6,237	1.00	65	1.00	1,554
2,048	2.00	90	8,402	6,237	1.00	65	1.00	1,554

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	21,163	12,771,353
2,304	0.38	21,146	12,763,699
3,072	0.50	21,142	12,762,423
3,840	0.63	21,133	12,758,596
4,608	0.75	21,131	12,757,320
5,376	0.88	21,131	12,757,320
6,144	1.00	21,131	12,757,320
6,912	1.13	21,131	12,757,320
7,680	1.25	21,082	12,008,465
8,448	1.38	21,082	12,007,190
9,216	1.50	21,082	12,005,914
9,984	1.63	21,082	11,021,049
10,752	1.75	21,082	11,021,049
11,520	1.88	21,082	11,021,049
12,288	2.00	21,082	11,021,049

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	631	564	67	417	0.43
WF-AWR Flush	20	20	0	16	3.75
CO-KTUCLO Master Slave enq (master slave det)	46	0	46	46	0.22
CF-Controlfile Transaction	299	299	0	5	0.00
KO-Multiple Object Checkpoint (fast object checkpoint)	9	9	0	3	0.00
TM-DML	513	513	0	2	0.00
AF-Advisor Framework (task serialization)	13	13	0	1	0.00
FB-Format Block	1	1	0	1	0.00
JQ-Job Queue	1	0	1	1	0.00
TA-Instance Undo	1	1	0	1	0.00
TD-KTF map table enqueue (KTF dump entries)	1	1	0	1	0.00
TT-Tablespace	4,790	4,790	0	1	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
5	0.09	330	749	3	28.7/28.7	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
27-Jun 17:54	91	330	749	3	29	0/0	0/0/0/0/0/0

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	117	0.00		0
ASM map operation hash table	141,447	0.00		0
ASM network background latch	56	0.00		0
AWR Alerted Metric Element list	1,505	0.00		0
Change Notification Hash table latch	46	0.00		0
Consistent RBA	232	0.00		0
DML lock allocation	1,038	0.00		0
Event Group Locks	2	0.00		0
FOB s.o list latch	86	0.00		0
File State Object Pool Parent Latch	1	0.00		0
IPC stats buffer allocation latch	431	0.00		428	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	1	0.00		0
JS broadcast add buf latch	32	0.00		0
JS broadcast drop buf latch	32	0.00		0
JS broadcast load blnc latch	28	0.00		0
JS queue access latch	1	0.00		0
JS queue state obj latch	1,512	0.00		0
JS slv state obj latch	4	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KFK SGA Libload latch	1,232	0.00		0
KFMD SGA	147	0.00		0
KFR redo allocation latch	1	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	1,696	0.06	1.00	600	0.00
KJCT flow control latch	12,337	0.01	0.00	0
KMG MMAN ready and startup request latch	47	0.00		0
KSXR large replies	8	0.00		0
KTF sga latch	2	0.00		46	0.00
KWQMN job cache list latch	10	0.00		0
Locator state objects pool parent latch	1	0.00		0
MQL Tracking Latch	0			4	0.00
Memory Management Latch	1	0.00		47	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,821	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	10	0.00		0
OS process allocation	52	0.00		0
OS process: request allocation	2	0.00		0
PL/SQL warning settings	137	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	44	2.27	0.00	0
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	1	0.00		47	0.00
SQL memory manager workarea list latch	3,300	0.00		0
Shared B-Tree	6	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	124	0.00		0
active service list	4,581	0.02	0.00	50	0.00
archive control	14	0.00		0
buffer pool	1	0.00		0
business card	31	0.00		0
cache buffer handles	42	0.00		0
cache buffers chains	40,210	0.00	1.00	1,862	0.00
cache buffers lru chain	205	0.00		2,219	0.00
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	5	0.00		0
channel operations parent latch	61,751	0.00	0.00	0
checkpoint queue latch	5,288	0.00		462	0.00
client/application info	673	0.00		0
commit callback allocation	1	0.00		0
compile environment latch	132	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	3	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	3	0.00		0
dml lock allocation	3	0.00		0
done queue latch	1	0.00		0
dummy allocation	267	0.00		0
enqueue hash chains	28,421	0.05	0.00	0
enqueues	14,613	0.01	0.00	0
error message lists	303	0.00		0
fifth spare latch	1	0.00		0
file cache latch	375	0.00		0
flashback copy	1	0.00		0
gc element	2,965	0.07	0.50	0
gcs commit scn state	1	0.00		0
gcs opaque info freelist	952	0.00		0
gcs partitioned table hash	382,727	0.00		70	0.00
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	6	0.00		0
gcs remastering latch	56	0.00		0
gcs resource freelist	71	0.00		33	0.00
gcs resource hash	3,437	0.00		0
gcs resource scan list	1	0.00		0
gcs shadows freelist	212	0.00		421	0.00
ges caches resource lists	8,026	0.01	0.00	2,645	0.00
ges deadlock list	658	0.00		0
ges domain table	15,959	0.00		0
ges enqueue table freelist	16,982	0.00		0
ges group table	23,997	0.00		0
ges process hash list	13,622	0.00		0
ges process parent latch	34,549	0.00		0
ges process table freelist	2	0.00		0
ges resource hash list	29,138	0.14	0.05	962	0.42
ges resource scan list	3	0.00		0
ges resource table freelist	1,627	0.00		0
ges timeout list	278	0.00		71	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	196	0.00		1,325	0.00
hash table modification latch	1	0.00		0
heartbeat check	1	0.00		28	0.00
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	1	0.00		2	0.00
job_queue_processes parameter latch	31	0.00		0
k2q global data latch	94	0.00		0
k2q lock allocation	1	0.00		0
kcfis stats shared latch	2	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kks stats	69	0.00		0
kokc descriptor allocation latch	114	0.00		0
ksfv messages	1	0.00		0
ksim membership request latch	76	0.00		140	0.00
kss move lock	1	0.00		0
ksuosstats global area	13	0.00		0
ksv allocation latch	3	0.00		0
ksv class latch	169	0.00		0
ksv msg queue latch	1	0.00		0
ksxp shared latch	2	0.00		0
ksz_so allocation latch	5	0.00		0
ktm global data	2	0.00		0
kwqbsn:qsga	5	0.00		0
lgwr LWN SCN	271	0.00		0
list of block allocation	17	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	1	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	5	0.00		4	0.00
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	1,529	0.00		0
messages	8,628	0.03	0.00	0
mostly latch-free SCN	273	0.37	0.00	0
msg queue latch	1	0.00		0
multiblock read objects	18	0.00		0
name-service memory objects	632	0.00		0
name-service namespace bucket	1,370	0.00		0
name-service pending queue	76	0.00		0
name-service request queue	1,789	0.00		0
ncodef allocation latch	3	0.00		0
object queue header heap	270	0.00		17	0.00
object queue header operation	35,054	0.00		0
object stats modification	2	0.00		0
parallel query alloc buffer	2,301	0.00		0
parallel query stats	178	0.00		0
parallel txn reco latch	1,053	0.00		0
parameter list	17	0.00		0
parameter table management	266	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	79	0.00		30	0.00
process allocation	634	0.00		1	0.00
process group creation	2	0.00		0
process queue	931	0.00		0
process queue reference	10,496,599	0.00	0.00	674,158	3.36
qmn task queue latch	20	0.00		0
query server freelists	726	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	775	0.13	0.00	1,904	0.05
redo copy	1	0.00		1,904	1.84
redo writing	853	0.00		0
reid allocation latch	3	0.00		0
resmgr group change latch	252	0.00		0
resmgr:active threads	267	0.00		0
resmgr:actses change group	133	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	266	0.38	0.00	0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	6	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	17,388	0.00		0
second spare latch	1	0.00		0
sequence cache	29	0.00		0
session allocation	4,591	0.30	0.64	0
session idle bit	1,554	0.00		0
session queue latch	1	0.00		0
session state list latch	266	0.38	0.00	0
session switching	4	0.00		0
session timer	50	0.00		0
shared pool	10,268	0.16	0.06	0
shared pool sim alloc	4	0.00		0
shared pool simulator	191	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	995	0.00		0
simulator lru latch	1	0.00		968	0.00
sort extent pool	4,951	0.00		0
space background task latch	103	0.00		94	0.00
state object free list	2	0.00		0
statistics aggregation	1,568	0.00		0
storage server table manipulation latch	9	0.00		0
tablespace key chain	281	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	3	0.00		0
transaction allocation	6	0.00		0
undo global data	1,174	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	29,138	42	2	40
shared pool	10,268	16	1	15
session allocation	4,591	14	9	6
gc element	2,965	2	1	1
KJC message pool free list	1,696	1	1	0
cache buffers chains	40,210	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
KJC message pool free list	kjcsmpav: allocate a msg buffer	1	1
cache buffers chains	kcbget: pin buffer	1	0
channel operations parent latch	ksrwait()	1	0
gc element	kclbla	1	0
ges resource hash list	kjuscl: lock close request	2	1
session allocation	ksuxds: KSUSFCLC not set	6	1
session allocation	ksufap: active sessions	2	0
session allocation	kxfpqidqr:1	1	6
shared pool	kghalo	1	1

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

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

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: 988,278
Captured Segments account for 98.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
RETAIL	RETAIL_20090515	DWB_RTL_TRX	R20090515	TABLE PARTITION	98,256	9.94
RETAIL	RETAIL_20090524	DWB_RTL_TRX	R20090524	TABLE PARTITION	81,136	8.21
RETAIL	RETAIL_20090512	DWB_RTL_TRX	R20090512	TABLE PARTITION	74,480	7.54
RETAIL	RETAIL_20090510	DWB_RTL_TRX	R20090510	TABLE PARTITION	55,968	5.66
RETAIL	RETAIL_20090527	DWB_RTL_TRX	R20090527	TABLE PARTITION	52,400	5.30

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 1,561,769
Captured Segments account for 62.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
RETAIL	RETAIL_20090515	DWB_RTL_TRX	R20090515	TABLE PARTITION	95,494	6.11
RETAIL	RETAIL_20090524	DWB_RTL_TRX	R20090524	TABLE PARTITION	82,084	5.26
RETAIL	RETAIL_20090512	DWB_RTL_TRX	R20090512	TABLE PARTITION	68,010	4.35
RETAIL	RETAIL_20090510	DWB_RTL_TRX	R20090510	TABLE PARTITION	55,492	3.55
RETAIL	RETAIL_20090530	DWB_RTL_TRX	R20090530	TABLE PARTITION	55,056	3.53

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 1,561,768
Captured Segments account for 62.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
RETAIL	RETAIL_20090515	DWB_RTL_TRX	R20090515	TABLE PARTITION	95,494	6.11
RETAIL	RETAIL_20090524	DWB_RTL_TRX	R20090524	TABLE PARTITION	82,084	5.26
RETAIL	RETAIL_20090512	DWB_RTL_TRX	R20090512	TABLE PARTITION	68,010	4.35
RETAIL	RETAIL_20090510	DWB_RTL_TRX	R20090510	TABLE PARTITION	55,492	3.55
RETAIL	RETAIL_20090530	DWB_RTL_TRX	R20090530	TABLE PARTITION	55,056	3.53

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 590,340
Captured Segments account for 0.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	975138_895	INDEX PARTITION	2	0.00
SYS	SYSAUX	WRH$_SERVICE_STAT_PK	975138_895	INDEX PARTITION	2	0.00

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
RETAIL	RETAIL_20090515	DWB_RTL_TRX	R20090515	TABLE PARTITION	7	9.86
RETAIL	RETAIL_20090524	DWB_RTL_TRX	R20090524	TABLE PARTITION	6	8.45
RETAIL	RETAIL_20090512	DWB_RTL_TRX	R20090512	TABLE PARTITION	5	7.04
RETAIL	RETAIL_20090502	DWB_RTL_TRX	R20090502	TABLE PARTITION	4	5.63
RETAIL	RETAIL_20090510	DWB_RTL_TRX	R20090510	TABLE PARTITION	4	5.63

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	SYSTEM	COL_USAGE$		TABLE	400	31.65
SYS	SYSAUX	WRI$_ADV_PARAMETERS_PK		INDEX	160	12.66
SYS	SYSAUX	WRI$_ADV_PARAMETERS		TABLE	144	11.39
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	975138_895	INDEX PARTITION	128	10.13
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	975138_895	INDEX PARTITION	64	5.06

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSAUX	WRM$_DATABASE_INSTANCE		TABLE	24	12.57
SYS	SYSAUX	WRH$_SYS_TIME_MODEL	975138_895	TABLE PARTITION	12	6.28
SYS	SYSAUX	WRM$_SNAPSHOT		TABLE	10	5.24
SYS	SYSAUX	WRI$_ADV_ADDM_FDG		TABLE	8	4.19
SYS	SYSAUX	WRI$_ADV_ADDM_TASKS		TABLE	7	3.66

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 347
Captured Segments account for 66.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	975138_895	INDEX PARTITION	65	18.73
SYS	SYSTEM	COL_USAGE$		TABLE	12	3.46
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	975138_895	INDEX PARTITION	12	3.46
SYS	SYSAUX	WRM$_SNAPSHOT		TABLE	11	3.17
SYS	SYSTEM	HISTGRM$		TABLE	10	2.88

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Dictionary Cache Stats
Dictionary Cache Stats (RAC)

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	7	0.00	2	1
dc_global_oids	76	0.00	0	139
dc_histogram_data	1,006	3.28	0	4,283
dc_histogram_defs	1,576	0.89	0	4,971
dc_object_grants	16	0.00	0	89
dc_objects	1,004	0.80	0	4,122
dc_rollback_segments	1,110	0.00	0	1,055
dc_segments	246	0.00	0	6,959
dc_sequences	1	100.00	1	2
dc_tablespaces	581	0.00	0	49
dc_users	393	0.00	0	137
global database name	129	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_histogram_defs	14	0	0
dc_objects	1	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	Reloads
BODY	7	0.00	9	0.00	0
CLUSTER	2	0.00	1	0.00	0
INDEX	14	0.00	14	0.00	0
SQL AREA	522	1.15	2,915	4.53	0
TABLE/PROCEDURE	498	0.00	1,080	1.11	3

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace	GES Lock Requests	GES Pin Requests
CLUSTER	1	1
INDEX	14	14
TABLE/PROCEDURE	640	723

Back to Library Cache Statistics
Back to Top

Memory Statistics

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

Memory Dynamic Components

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

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

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	393.15		3.45	7.14	41	41	114	114
	Freeable	32.38	0.00	1.20	1.32	7		27	27
	SQL	8.68	6.50	0.27	1.29	7	1,185	32	15
	PL/SQL	1.97	0.33	0.04	0.23	2	2	56	45
E	Other	393.13		3.45	7.15	41	41	114	114
	Freeable	32.00	0.00	1.23	1.33	7		26	26
	SQL	8.64	6.50	0.27	1.29	7	1,185	32	15
	PL/SQL	1.97	0.33	0.04	0.23	2	2	56	45

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	14.06	14.37	2.23
shared	FileOpenBlock	11.21	11.21	0.00
shared	KCL name table	48.00	48.00	0.00
shared	KQR L PO	12.98	12.99	0.11
shared	PL/SQL DIANA	18.60	18.60	0.00
shared	PL/SQL MPCODE	12.45	12.45	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	301.28	299.08	-0.73
shared	gcs dynamic r	23.17	23.17	0.00
shared	gcs dynamic s	16.00	16.00	0.00
shared	gcs resources	97.36	97.36	0.00
shared	gcs shadows	64.90	64.90	0.00
shared	ges big msg buffers	22.03	22.03	0.00
shared	ges enqueues	20.77	20.77	0.00
shared	sessions	11.96	11.96	0.00
shared	sql area	76.08	77.77	2.21
shared	write state object	14.95	14.95	0.00
	buffer_cache	4,928.00	4,928.00	0.00
	fixed_sga	2.06	2.06	0.00
	log_buffer	34.50	34.50	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

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

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
gcs_resources	117,260	835,759	708930	708930
gcs_shadows	64,837	883,610	708930	708930

init.ora Parameters

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

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

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	372	2.64	5.81
acks for commit broadcast(logical)	374	2.66	5.84
broadcast msgs on commit(actual)	1,592	11.32	24.88
broadcast msgs on commit(logical)	1,596	11.35	24.94
broadcast msgs on commit(wasted)	16	0.11	0.25
broadcast on commit wait time(ms)	15	0.11	0.23
broadcast on commit waits	115	0.82	1.80
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	11	0.08	0.17
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	390	2.77	6.09
gcs ast xid	0	0.00	0.00
gcs blocked converts	255	1.81	3.98
gcs blocked cr converts	219	1.56	3.42
gcs compatible basts	38	0.27	0.59
gcs compatible cr basts (global)	23	0.16	0.36
gcs compatible cr basts (local)	168	1.19	2.63
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	3	0.02	0.05
gcs dbwr write request msgs	5	0.04	0.08
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	4	0.03	0.06
gcs immediate (null) converts	33	0.23	0.52
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	0	0.00	0.00
gcs indirect ast	42	0.30	0.66
gcs indirect bidless ast	7	0.05	0.11
gcs indirect fg ast	39	0.28	0.61
gcs lms flush pi msgs	2	0.01	0.03
gcs lms write request msgs	1	0.01	0.02
gcs msgs process time(ms)	25	0.18	0.39
gcs msgs received	3,538	25.15	55.28
gcs new served by master	32	0.23	0.50
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	0	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs queued converts	0	0.00	0.00
gcs reader bypass N->Xw ping local	1	0.01	0.02
gcs reader bypass N->Xw ping remote	2	0.01	0.03
gcs reader bypass grant X on assume	3	0.02	0.05
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	25	0.18	0.39
gcs reader bypass grant immediate	4	0.03	0.06
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	82	0.58	1.28
gcs retry convert request	0	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	85	0.60	1.33
gcs side channel msgs logical	541	3.85	8.45
gcs stale cr	0	0.00	0.00
gcs undo cr	3	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)	18	0.13	0.28
ges msgs received	2,815	20.01	43.98
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	30	0.21	0.47
implicit batch messages sent	83	0.59	1.30
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	269	1.91	4.20
messages queue sent actual	3,139	22.32	49.05
messages queue sent logical	3,257	23.16	50.89
messages received actual	6,078	43.21	94.97
messages received logical	6,353	45.17	99.27
messages sent directly	3,104	22.07	48.50
messages sent indirectly	1,481	10.53	23.14
messages sent not implicit batched	3,056	21.73	47.75
messages sent pbatched	2,757	19.60	43.08
msgs causing lmd to send msgs	1,182	8.40	18.47
msgs causing lms(s) to send msgs	404	2.87	6.31
msgs received queue time (ms)	5	0.04	0.08
msgs received queued	6,353	45.17	99.27
msgs sent queue time (ms)	2,105,499	14,969.88	32,898.42
msgs sent queue time on ksxp (ms)	1,692	12.03	26.44
msgs sent queued	3,249	23.10	50.77
msgs sent queued on ksxp	6,261	44.52	97.83
process batch messages received	3,665	26.06	57.27
process batch messages sent	2,222	15.80	34.72

Global CR Served Stats

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

Global CURRENT Served Stats

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

Statistic	Total	% <1ms	% <10ms
Pins	425	100.00	0.00
Flushes	7	57.14	42.86
Writes	3	100.00	0.00

Global Cache Transfer Stats

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

Global Cache Transfer Stats

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

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
8	data block	28	96.43	3.57	0.00	98	100.00	0.00	0.00
2	data block	17	100.00	0.00	0.00	87	97.70	2.30	0.00
4	data block	19	100.00	0.00	0.00	32	100.00	0.00	0.00
5	data block	10	100.00	0.00	0.00	37	97.30	2.70	0.00
1	data block	18	100.00	0.00	0.00	27	100.00	0.00	0.00
7	data block	18	100.00	0.00	0.00	15	100.00	0.00	0.00
6	data block	12	100.00	0.00	0.00	18	100.00	0.00	0.00
5	Others	13	100.00	0.00	0.00	8	100.00	0.00	0.00
4	Others	10	100.00	0.00	0.00	6	100.00	0.00	0.00
1	Others	9	100.00	0.00	0.00	5	100.00	0.00	0.00
8	Others	10	100.00	0.00	0.00	4	100.00	0.00	0.00
6	Others	7	100.00	0.00	0.00	5	100.00	0.00	0.00
5	undo header	9	100.00	0.00	0.00	1	100.00	0.00	0.00
7	Others	4	100.00	0.00	0.00	2	100.00	0.00	0.00
4	undo header	1	100.00	0.00	0.00	2	100.00	0.00	0.00
7	undo header	1	100.00	0.00	0.00	2	100.00	0.00	0.00
2	undo header	2	100.00	0.00	0.00	0
8	undo header	1	100.00	0.00	0.00	1	100.00	0.00	0.00
2	Others	1	100.00	0.00	0.00	0
1	undo header	1	100.00	0.00	0.00	0
6	undo header	1	100.00	0.00	0.00	0

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer Times (ms)

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

Inst No	Block Class	All	Immed	Busy	All	Immed	Busy
		CR Avg Time (ms)			Current Avg Time (ms)
8	data block	0.20	0.19	0.45	0.19	0.19
2	data block	0.20	0.20		0.21	0.19	0.86
4	data block	0.18	0.18		0.17	0.17
5	data block	0.21	0.21		0.24	0.20	1.87
1	data block	0.17	0.17		0.21	0.21
7	data block	0.17	0.17		0.20	0.20
6	data block	0.16	0.16		0.18	0.18
5	others	0.14	0.14		0.17	0.17
4	others	0.17	0.17		0.16	0.16
1	others	0.17	0.17		0.18	0.18
8	others	0.17	0.17		0.23	0.23
6	others	0.19	0.19		0.21	0.21
5	undo header	0.12	0.12		0.12	0.12
7	others	0.17	0.17		0.17	0.17
4	undo header	0.14	0.14		0.13	0.13
7	undo header	0.12	0.12		0.13	0.13
2	undo header	0.14	0.14
8	undo header	0.15	0.15		0.18	0.18
2	others	0.18	0.18
6	undo header	0.14	0.14
1	undo header	0.14	0.14
1	undo block
8	undo block
6	undo block
7	undo block
4	undo block
2	undo block
5	undo block

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer (Immediate)

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

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
8	data block	0	27	14.81	85.19	98	35.71	64.29
2	data block	0	17	17.65	82.35	85	28.24	71.76
4	data block	0	19	0.00	100.00	32	62.50	37.50
5	data block	0	10	30.00	70.00	36	30.56	69.44
1	data block	0	18	22.22	77.78	27	44.44	55.56
7	data block	0	18	22.22	77.78	15	20.00	80.00
6	data block	0	12	25.00	75.00	18	44.44	55.56
5	others	0	13	61.54	38.46	8	50.00	50.00
4	others	0	10	30.00	70.00	6	33.33	66.67
1	others	0	9	11.11	88.89	5	0.00	100.00
8	others	0	10	10.00	90.00	4	25.00	75.00
6	others	0	7	0.00	100.00	5	0.00	100.00
5	undo header	0	9	100.00	0.00	1	100.00	0.00
7	others	0	4	0.00	100.00	2	0.00	100.00
4	undo header	0	1	100.00	0.00	2	100.00	0.00
7	undo header	0	1	100.00	0.00	2	100.00	0.00
2	undo header	0	2	100.00	0.00	0
8	undo header	0	1	100.00	0.00	1	100.00	0.00
2	others	0	1	0.00	100.00	0
6	undo header	0	1	100.00	0.00	0
1	undo header	0	1	100.00	0.00	0
1	undo block	0	0			0
8	undo block	0	0			0
6	undo block	0	0			0
7	undo block	0	0			0
4	undo block	0	0			0
2	undo block	0	0			0
5	undo block	0	0			0

Back to Global Cache Transfer Stats
Back to Top

Global Cache Times (Immediate)

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

Src Inst#	Block Class	Immed	2hop	3hop	Immed	2hop	3hop
		CR Avg Time (ms)			Current Avg Time (ms)
8	data block	0.19	0.13	0.20	0.19	0.16	0.21
2	data block	0.20	0.18	0.20	0.19	0.15	0.21
4	data block	0.18		0.18	0.17	0.15	0.20
5	data block	0.21	0.19	0.22	0.20	0.13	0.22
1	data block	0.17	0.17	0.17	0.21	0.21	0.22
7	data block	0.17	0.13	0.18	0.20	0.12	0.22
6	data block	0.16	0.14	0.17	0.18	0.16	0.20
5	others	0.14	0.13	0.17	0.17	0.16	0.19
4	others	0.17	0.13	0.19	0.16	0.13	0.18
1	others	0.17	0.13	0.17	0.18		0.18
8	others	0.17	0.13	0.17	0.23	0.14	0.26
6	others	0.19		0.19	0.21		0.21
5	undo header	0.12	0.12		0.12	0.12
7	others	0.17		0.17	0.17		0.17
4	undo header	0.14	0.14		0.13	0.13
7	undo header	0.12	0.12		0.13	0.13
2	undo header	0.14	0.14
8	undo header	0.15	0.15		0.18	0.18
2	others	0.18		0.18
6	undo header	0.14	0.14
1	undo header	0.14	0.14
1	undo block
8	undo block
6	undo block
7	undo block
4	undo block
2	undo block
5	undo block

Back to Global Cache Transfer Stats
Back to Top

Interconnect Stats

Interconnect Latency Stats
Interconnect Throughput by Client
Interconnect Device Stats

Interconnect Ping Latency Stats

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

Target Instance	500B Ping Count	Avg Latency 500B msg	Stddev 500B msg	8K Ping Count	Avg Latency 8K msg	Stddev 8K msg
1	5	0.59	0.03	5	0.58	0.03
2	5	0.60	0.09	5	0.61	0.10
3	5	0.52	0.12	5	0.54	0.12
4	5	0.55	0.09	5	0.55	0.09
5	5	0.56	0.14	5	0.63	0.14
6	5	0.51	0.13	5	0.52	0.14
7	5	0.41	0.10	5	0.43	0.11
8	5	0.42	0.06	5	0.42	0.06

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.03	0.03
Parallel Query	35.40	34.74
DB Locks	0.01	0.01
DB Streams	0.00	0.00
Other	0.00	0.00

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics

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

Device Name	IP Address	Public	Source	Send Mbytes/sec	Send Errors	Send Dropped	Send Buffer Overrun	Send Carrier Lost	Receive Mbytes/sec	Receive Errors	Receive Dropped	Receive Buffer Overrun	Receive Frame Errors
bond0	172.31.88.111	NO	Oracle Cluster Repository	0.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.99	In-memory Sort %:	100.00
Library Hit %:	96.42	Soft Parse %:	94.64
Execute to Parse %:	26.11	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	0.00	% Non-Parse CPU:	99.96

Buffer access - local cache %:	96.81
Buffer access - remote cache %:	3.18
Buffer access - disk %:	0.01

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

Avg message sent queue time (ms):	648.0
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:	63.95
% of indirect sent messages:	30.51
% of flow controlled messages:	5.54