WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

DEMO 3430975138 DEMO1 1 30-Jun-09 12:06 11.1.0.7.0 YES

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

Host Name Platform CPUs Cores Sockets Memory (GB)

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

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

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1041 02-Jul-09 12:43:26 46 1.7

End Snap: 1042 02-Jul-09 12:46:16 46 1.8

Elapsed: 2.84 (mins)

DB Time: 43.29 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1041	02-Jul-09 12:43:26	46	1.7
End Snap:	1042	02-Jul-09 12:46:16	46	1.8
Elapsed:		2.84 (mins)
DB Time:		43.29 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 3,840M 3,840M Std Block Size: 8K

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

	Begin	End
Buffer Cache:	3,840M	3,840M	Std Block Size:	8K
Shared Pool Size:	1,920M	1,920M	Log Buffer:	35,328K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 15.2 64.9 1.63 1.45

DB CPU(s): 6.1 26.1 0.65 0.58

Redo size: 10,622.5 45,272.2

Logical reads: 44,951.8 191,580.1

Block changes: 24.7 105.2

Physical reads: 69,308.2 295,384.6

Physical writes: 24,580.6 104,760.0

User calls: 10.5 44.9

Parses: 7.3 31.0

Hard parses: 0.1 0.4

W/A MB processed: 90,708,772.7 386,591,718.4

Logons: 1.6 6.9

Executes: 9.4 40.0

Rollbacks: 0.1 0.4

Transactions: 0.2

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	15.2	64.9	1.63	1.45
DB CPU(s):	6.1	26.1	0.65	0.58
Redo size:	10,622.5	45,272.2
Logical reads:	44,951.8	191,580.1
Block changes:	24.7	105.2
Physical reads:	69,308.2	295,384.6
Physical writes:	24,580.6	104,760.0
User calls:	10.5	44.9
Parses:	7.3	31.0
Hard parses:	0.1	0.4
W/A MB processed:	90,708,772.7	386,591,718.4
Logons:	1.6	6.9
Executes:	9.4	40.0
Rollbacks:	0.1	0.4
Transactions:	0.2

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 98.69 Soft Parse %: 98.87

Execute to Parse %: 22.47 Latch Hit %: 99.95

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

Shared Pool Statistics

Begin End

Memory Usage %: 77.65 77.67

% SQL with executions>1: 99.15 99.01

% Memory for SQL w/exec>1: 97.73 97.12

	Begin	End
Memory Usage %:	77.65	77.67
% SQL with executions>1:	99.15	99.01
% Memory for SQL w/exec>1:	97.73	97.12

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		1,045		40.24
direct path read temp	135,237	524	4	20.19	User I/O
direct path write temp	135,173	350	3	13.47	User I/O
cell smart table scan	40,398	313	8	12.05	User I/O
enq: TT - contention	1,934	84	43	3.22	Other

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

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

0.54 18.37 79.7 4.9 0.0 14.5

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.54	18.37	79.7	4.9	0.0	14.5

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

77.0 90.0 0.0

Memory Statistics

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

Begin End

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

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

PGA use (MB): 690.2 727.5

% Host Mem used for SGA+PGA: 21.23 21.23

	Begin	End
Host Mem (MB):	32,189.6	32,189.6
SGA use (MB):	6,144.0	6,144.0
PGA use (MB):	690.2	727.5
% Host Mem used for SGA+PGA:	21.23	21.23

RAC Statistics

Begin End

Number of Instances: 8 8

	Begin	End
Number of Instances:	8	8

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 14.32 61.05

Global Cache blocks served: 4.21 17.93

GCS/GES messages received: 111.97 477.23

GCS/GES messages sent: 141.81 604.38

DBWR Fusion writes: 0.03 0.13

Estd Interconnect traffic (KB) 197.81

	Per Second	Per Transaction
Global Cache blocks received:	14.32	61.05
Global Cache blocks served:	4.21	17.93
GCS/GES messages received:	111.97	477.23
GCS/GES messages sent:	141.81	604.38
DBWR Fusion writes:	0.03	0.13
Estd Interconnect traffic (KB)	197.81

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

Buffer access - local cache %: 93.92

Buffer access - remote cache %: 6.08

Buffer access - disk %: 0.00

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 2.9

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

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

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

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

Global cache log flushes for cr blocks served %: 2.6

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

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 8,402.6

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

% of indirect sent messages: 33.77

% of flow controlled messages: 8.45

Cluster Interconnect

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
bond0	172.31.88.109	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): 2597.2s
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	2,564.33	98.73
DB CPU	1,045.20	40.24
parse time elapsed	6.46	0.25
PL/SQL execution elapsed time	1.74	0.07
hard parse elapsed time	0.47	0.02
failed parse elapsed time	0.41	0.02
PL/SQL compilation elapsed time	0.37	0.01
connection management call elapsed time	0.08	0.00
hard parse (sharing criteria) elapsed time	0.04	0.00
sequence load elapsed time	0.00	0.00
repeated bind elapsed time	0.00	0.00
DB time	2,597.21
background elapsed time	25.21
background cpu time	5.17

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	116,673
IDLE_TIME	19,786
IOWAIT_TIME	21
NICE_TIME	0
SYS_TIME	6,686
USER_TIME	108,758
LOAD	1	18
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,753,260,032
NUM_CPUS	8
NUM_CPU_CORES	8
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	2,097,152
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
02-Jul 12:43:26	0.54
02-Jul 12:46:16	18.37	85.50	79.70	4.90	0.02	14.50

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 91.4% of Total DB time 2,597.21 (s)
Total FG Wait Time: 1,329.61 (s) DB CPU time: 1,045.20 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
User I/O	310,831	5	1,187	4	45.72
DB CPU			1,045		40.24
Other	93,961	58	128	1	4.93
Concurrency	1,526	0	12	8	0.46
System I/O	1,221	0	1	1	0.05
Cluster	1,301	0	1	0	0.02
Application	46	0	0	9	0.02
Network	388	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	135,237	0	524	4	3,380.93	20.19
direct path write temp	135,173	0	350	3	3,379.33	13.47
cell smart table scan	40,398	37	313	8	1,009.95	12.05
enq: TT - contention	1,934	0	84	43	48.35	3.22
rdbms ipc reply	34,960	0	13	0	874.00	0.49
enq: PS - contention	1,891	51	9	5	47.28	0.35
library cache lock	623	0	7	11	15.58	0.27
DFS lock handle	59	0	6	108	1.48	0.25
reliable message	761	0	6	8	19.03	0.23
library cache pin	830	0	5	6	20.75	0.18
PX Deq: Slave Session Stats	404	0	4	9	10.10	0.14
PX Deq: reap credit	8,881	100	3	0	222.03	0.13
control file sequential read	1,221	0	1	1	30.53	0.05
IPC send completion sync	1,382	99	1	1	34.55	0.04
PX Deq: Signal ACK RSG	139	56	1	7	3.48	0.04
latch: ges resource hash list	206	0	1	4	5.15	0.03
SQL*Net break/reset to client	42	0	0	7	1.05	0.01
cell single block physical read	22	0	0	13	0.55	0.01
gc cr block busy	28	0	0	10	0.70	0.01
os thread startup	3	0	0	91	0.08	0.01
PX qref latch	43,167	100	0	0	1,079.18	0.01
gc cr multi block request	451	0	0	0	11.28	0.01
latch: enqueue hash chains	54	0	0	2	1.35	0.00
enq: KO - fast object checkpoint	3	0	0	39	0.08	0.00
latch free	29	0	0	3	0.73	0.00
gc cr block 3-way	317	0	0	0	7.93	0.00
gc current block busy	7	0	0	6	0.18	0.00
gc current block 3-way	221	0	0	0	5.53	0.00
PX Deq: Signal ACK EXT	32	0	0	1	0.80	0.00
gc cr block 2-way	130	0	0	0	3.25	0.00
gc current grant busy	53	0	0	0	1.33	0.00
gc current block 2-way	77	0	0	0	1.93	0.00
row cache lock	40	0	0	0	1.00	0.00
enq: WF - contention	18	0	0	0	0.45	0.00
latch: session allocation	21	0	0	0	0.53	0.00
enq: PI - contention	14	100	0	0	0.35	0.00
SQL*Net message to client	383	0	0	0	9.58	0.00
gc current grant 2-way	15	0	0	0	0.38	0.00
latch: shared pool	25	0	0	0	0.63	0.00
SQL*Net message from client	383	0	1,123	2931	9.58
Streams AQ: waiting for messages in the queue	50	100	186	3725	1.25
PX Deq: Execute Reply	463	13	171	370	11.58
PX Deq: Execution Msg	1,144	1	52	45	28.60
PX Deq: Parse Reply	396	0	3	8	9.90
PX Deq: Join ACK	618	25	2	3	15.45
PX Deq: Table Q Normal	6	0	0	67	0.15
PX Deq Credit: send blkd	64	0	0	5	1.60
PX Deq: Msg Fragment	48	0	0	1	1.20

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
PX Deq: reap credit	4,393	100	10	2	109.83	40.18
library cache lock	412	9	4	9	10.30	14.98
control file sequential read	392	0	3	7	9.80	10.24
library cache pin	414	0	2	6	10.35	9.67
control file parallel write	60	0	2	31	1.50	7.26
name-service call wait	5	0	0	84	0.13	1.66
gc cr block 2-way	455	0	0	1	11.38	1.17
os thread startup	3	0	0	79	0.08	0.94
ksxr poll remote instances	36,600	100	0	0	915.00	0.84
reliable message	15	0	0	7	0.38	0.40
ges DFS hang analysis phase 2 acks	2	0	0	42	0.05	0.33
CGS wait for IPC msg	18,286	100	0	0	457.15	0.33
enq: CF - contention	7	86	0	12	0.18	0.32
DFS lock handle	197	0	0	0	4.93	0.27
db file parallel write	5	0	0	11	0.13	0.21
gc cr block 3-way	5	0	0	10	0.13	0.20
row cache lock	30	0	0	1	0.75	0.13
gc current block 3-way	1	0	0	28	0.03	0.11
enq: TT - contention	32	94	0	1	0.80	0.10
gcs log flush sync	39	0	0	1	0.98	0.10
log file parallel write	57	0	0	0	1.43	0.10
enq: PS - contention	25	52	0	1	0.63	0.07
latch free	17	0	0	1	0.43	0.05
rdbms ipc reply	7	0	0	1	0.18	0.02
gc current block 2-way	17	0	0	0	0.43	0.02
ASM file metadata operation	34	0	0	0	0.85	0.01
latch: session allocation	11	0	0	0	0.28	0.01
PX Deq: Slave Session Stats	3	0	0	0	0.08	0.00
PX Idle Wait	3,994	93	9,651	2416	99.85
rdbms ipc message	35,637	7	3,059	86	890.93
wait for unread message on broadcast channel	340	100	341	1004	8.50
gcs remote message	10,662	75	341	32	266.55
DIAG idle wait	6,650	73	340	51	166.25
fbar timer	1	100	300	300011	0.03
shared server idle wait	6	100	180	30004	0.15
dispatcher timer	3	100	180	60007	0.08
PING	28	18	175	6249	0.70
Streams AQ: qmn slave idle wait	6	0	174	29019	0.15
Streams AQ: qmn coordinator idle wait	12	50	174	14510	0.30
ASM background timer	34	0	172	5060	0.85
pmon timer	69	83	171	2484	1.73
ges remote message	13,879	7	170	12	346.98
Space Manager: slave idle wait	33	100	169	5115	0.83
Streams AQ: waiting for time management or cleanup tasks	3	67	31	10336	0.08
SQL*Net message from client	20	0	0	4	0.50
PX Deq: Join ACK	9	22	0	2	0.23
PX Deq: Parse Reply	7	0	0	0	0.18

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	34	100.0
CGS wait for IPC msg	18K	100.0
DFS lock handle	256	87.9	1.2	.8			.4	9.8
IPC send completion sync	1396	97.9	.8	.2	.1	.1	.2	.7
KJC: Wait for msg sends to complete	7	100.0
PX Deq: Signal ACK EXT	34	85.3	8.8		2.9		2.9
PX Deq: Signal ACK RSG	143	88.8	.7		3.5	2.1	2.1	2.8
PX Deq: Slave Session Stats	407	78.9	6.4	2.9	3.7	2.7	.7	4.7
PX Deq: reap credit	13K	99.1	.1	.1	.1	.1	.1	.5	.0
PX qref latch	43K	100.0	.0
SQL*Net break/reset to client	42	78.6	4.8	4.8		2.4		9.5
SQL*Net message to client	403	100.0
SQL*Net more data from client	5	100.0
cell single block physical read	22			13.6	40.9	27.3	4.5	13.6
cell smart table scan	40K	66.7	9.1	4.3	2.2	4.7	5.8	7.1
control file parallel write	60	15.0	15.0	15.0	15.0	3.3	11.7	25.0
control file sequential read	1613	84.7	5.6	3.2	2.1	1.7	1.1	1.7
db file parallel write	5	40.0		20.0	20.0			20.0
direct path read temp	135K	58.7	2.0	6.4	16.3	12.6	3.2	.8
direct path write	1	100.0
direct path write temp	135K	49.6	14.2	18.1	12.7	3.4	1.3	.7
enq: AF - task serialization	1	100.0
enq: CF - contention	7	42.9	28.6				14.3	14.3
enq: FB - contention	2	100.0
enq: KO - fast object checkpoint	4	75.0						25.0
enq: PI - contention	16	100.0
enq: PS - contention	1916	83.6	4.3	2.2	1.9	2.0	1.7	4.3
enq: TM - contention	1	100.0
enq: TQ - TM contention	1	100.0
enq: TT - contention	1962	24.0	5.6	3.7	4.8	5.7	11.0	45.3
enq: WF - contention	18	100.0
gc cr block 2-way	582	93.3	3.3	.9	1.0	1.2	.2	.2
gc cr block 3-way	315	99.7						.3
gc cr block busy	27	77.8	3.7				3.7	14.8
gc cr grant 2-way	1	100.0
gc cr multi block request	451	99.3			.2			.4
gc current block 2-way	107	99.1	.9
gc current block 3-way	227	99.6					.4
gc current block busy	6	83.3				16.7
gc current grant 2-way	15	100.0
gc current grant busy	61	100.0
gc current multi block request	10	100.0
gcs log flush sync	47	93.6	4.3			2.1
ges DFS hang analysis phase 2 acks	2						50.0	50.0
ksxr poll remote instances	36K	100.0	.0
latch free	46	56.5	41.3					2.2
latch: cache buffers chains	1	100.0
latch: enqueue hash chains	54	79.6	5.6	11.1				3.7
latch: gc element	1	100.0
latch: ges resource hash list	211	79.6	8.1	5.7	1.4	.5	1.9	2.8
latch: session allocation	32	100.0
latch: shared pool	28	100.0
library cache lock	1037	66.1	8.0	5.0	4.1	3.6	3.7	9.6
library cache pin	1246	81.1	5.0	2.7	1.8	2.2	2.2	5.0
library cache: mutex X	5	100.0
log file parallel write	62	96.8	1.6		1.6
name-service call wait	5							100.0
os thread startup	6						16.7	83.3
rdbms ipc reply	34K	98.3	.7	.4	.2	.2	.1	.1
reliable message	774	85.4	4.4	1.4	.9	1.3	1.3	5.3
row cache lock	70	85.7	7.1	4.3	2.9
ASM background timer	34								100.0
DIAG idle wait	6675	20.8	1.0	.8	1.1	2.5	30.7	43.1
KSV master wait	102	100.0
PING	28	60.7	3.6		3.6			7.1	25.0
PX Deq Credit: send blkd	64	70.3	4.7	9.4	4.7	3.1	1.6	6.3
PX Deq: Execute Reply	465	53.5	3.2	1.1	.4	1.1	2.2	25.8	12.7
PX Deq: Execution Msg	1144	58.0	10.3	8.5	4.4	4.5	4.0	8.7	1.7
PX Deq: Join ACK	627	83.1	7.5	2.9	.6	1.4	1.3	3.2
PX Deq: Msg Fragment	48	87.5	2.1	4.2	2.1	2.1	2.1
PX Deq: Parse Reply	403	76.9	8.2	2.7	2.2	2.5	2.0	5.5
PX Deq: Table Q Normal	6	50.0				16.7		33.3
PX Idle Wait	3986	.0		.1	.6	.3	.3	3.6	95.2
SQL*Net message from client	403	64.8	9.2	1.5	2.0	3.7	2.7	4.5	11.7
Space Manager: slave idle wait	33								100.0
Streams AQ: RAC qmn coordinator idle wait	12	100.0
Streams AQ: qmn coordinator idle wait	12	33.3	8.3		8.3				50.0
Streams AQ: qmn slave idle wait	6								100.0
Streams AQ: waiting for messages in the queue	50							32.0	68.0
Streams AQ: waiting for time management or cleanup tasks	3	33.3						33.3	33.3
class slave wait	1	100.0
dispatcher timer	3								100.0
fbar timer	1								100.0
gcs remote message	10K	15.3	3.5	2.6	2.0	1.4	1.2	74.0
ges remote message	13K	61.8	6.6	5.0	3.9	4.5	4.9	13.3
pmon timer	68	11.8				1.5	1.5	2.9	82.4
rdbms ipc message	35K	87.8	.6	.5	.4	.5	.5	7.5	2.2
shared server idle wait	6								100.0
wait for unread message on broadcast channel	340							98.8	1.2

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_ONE	2,541	1,041	11,815	7,661
SYS$USERS	55	4	0	1
DEMO	1	0	0	0
SYS$BACKGROUND	1	0	0	1
D1	0	0	0	0
DEMOXDB	0	0	0	0
D_EIGHT	0	0	0	0
D_FOUR	0	0	0	0
D_TWO	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	Concurcy Wt Time	Network Total Wts
D_ONE	310831	1187	177	2	3
SYS$USERS	0	0	1308	10	343
DEMO	0	0	35	1	42
SYS$BACKGROUND	0	0	860	6	0
D1	0	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): 2,597
Captured SQL account for 98.0% of Total
Total DB Time (s): 2,597
Captured PL/SQL account for 0.4% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
2,505	1,022	1	2505.24	96.46	arty65g64fmt7	SQL*Plus	select /* one / /+ pa...
9	1	16	0.55	0.34	arx2rgss6k33m	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT s.inst_id, s.name, i...
8	1	16	0.51	0.32	aqb79nn78dgyy	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT inst_id, service_name...
8	5	1	7.97	0.31	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
5	0	16	0.32	0.20	7frqszzdu8sgg	racgimon@rsthpdbs101.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
4	4	1	4.49	0.17	7g732rx16j8jc		insert into WRH$_SERVICE_STAT ...
4	0	37	0.10	0.14	fgqt3gak6vv8x	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT instance_name ...
4	0	1	3.51	0.14	0v6s91manuhz8	emagent@rsthpdbs101.us.oracle.com (TNS V1-V3)	/* OracleOEM */ S...
3	0	2	1.73	0.13	8z3tqxkjw4sg4	sqlplus@rsthpdbs101.us.oracle.com (TNS V1-V3)	select px.SID "SID", ...
1	0	1	0.71	0.03	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...

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): 1,045
Captured SQL account for 98.5% of Total
Total CPU Time (s): 1,045
Captured PL/SQL account for 0.5% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
1,022	2,505	1	1022.02	97.78	96.46	arty65g64fmt7	SQL*Plus	select /* one / /+ pa...
5	8	1	4.83	0.46	0.31	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
4	4	1	4.08	0.39	0.17	7g732rx16j8jc		insert into WRH$_SERVICE_STAT ...
1	8	16	0.06	0.10	0.32	aqb79nn78dgyy	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT inst_id, service_name...
1	9	16	0.05	0.07	0.34	arx2rgss6k33m	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT s.inst_id, s.name, i...
0	1	1	0.29	0.03	0.03	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	1	0.27	0.03	0.01	bunssq950snhf		insert into wrh$_sga_target_ad...
0	5	16	0.01	0.02	0.20	7frqszzdu8sgg	racgimon@rsthpdbs101.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
0	4	37	0.00	0.02	0.14	fgqt3gak6vv8x	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT instance_name ...
0	0	1	0.09	0.01	0.00	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...

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: 7,663,204
Captured SQL account for 98.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
7,533,664	1	7,533,664.00	98.31	1022.02	2505.24	arty65g64fmt7	SQL*Plus	select /* one / /+ pa...
21,641	1	21,641.00	0.28	4.83	7.97	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
10,055	1	10,055.00	0.13	0.29	0.71	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
7,623	1	7,623.00	0.10	0.09	0.09	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAO...
1,432	1	1,432.00	0.02	0.04	0.05	972qhvq36awwy		SELECT startsn.stat_id, smap...
1,132	108	10.48	0.01	0.01	0.00	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
1,095	1	1,095.00	0.01	0.04	0.14	084n00125zh7c		SELECT count(*) over () as to...
298	1	298.00	0.00	0.01	0.01	5ax5xu96u2ztd		insert into WRH$_EVENT_HISTOGR...
196	19	10.32	0.00	0.00	0.00	fnz13xnvkybtj		INSERT INTO sys.wri$_adv_findi...
193	75	2.57	0.00	0.00	0.01	87gaftwrm2h68		select o.owner#, o.name, o.nam...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 11,815,384
Captured SQL account for 99.3% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
11,730,906	1	11,730,906.00	99.29	1022.02	2505.24	arty65g64fmt7	SQL*Plus	select /* one / /+ pa...
1	1	1.00	0.00	4.83	7.97	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0	1	0.00	0.00	0.04	0.14	084n00125zh7c		SELECT count(*) over () as to...
0	8	0.00	0.00	0.00	0.00	0h6b2sajwb74n		select privilege#, level from ...
0	1	0.00	0.00	0.04	3.51	0v6s91manuhz8	emagent@rsthpdbs101.us.oracle.com (TNS V1-V3)	/* OracleOEM */ S...
0	6	0.00	0.00	0.00	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
0	1	0.00	0.00	0.05	0.12	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
0	7	0.00	0.00	0.04	0.28	1mjhyad05m8pf	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT value ...
0	7	0.00	0.00	0.00	0.43	1ytruncyx2kdb	OEM.DefaultPool	BEGIN MGMT_HTTP_SESSION.sessio...
0	1	0.00	0.00	0.01	0.01	2afsg03va7jtm		INSERT /+ APPEND / INTO WRH$...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 1,598
Captured SQL account for 45.3% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
108	108	1.00	0.00	0.00	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
99	99	1.00	0.00	0.00	f80h0xb1qvbsk		SELECT sys.wri$_adv_seq_msggro...
75	28	0.37	0.00	0.00	87gaftwrm2h68		select o.owner#, o.name, o.nam...
41	41	1.00	0.00	0.00	6xvp6nxs4a9n4		select nvl(sum(space), 0) from...
41	0	0.00	0.00	0.00	csnp95dz2r8ss		select file#, block# from rec...
37	37	1.00	0.00	0.10	fgqt3gak6vv8x	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT instance_name ...
34	0	0.00	0.00	0.00	5yv0nj5hwfz5d		select job, nvl2(last_date, ...
33	0	0.00	0.00	0.00	c4nhd1ntptxq7		select message_level, sequenc...
24	24	1.00	0.00	0.00	3sqgkcng6vx8r		INSERT INTO sys.wri$_adv_ratio...
19	19	1.00	0.00	0.00	fnz13xnvkybtj		INSERT INTO sys.wri$_adv_findi...
16	16	1.00	0.00	0.00	2gxbvynrd71dr		INSERT INTO sys.wri$_adv_rec_a...
16	16	1.00	0.01	0.32	7frqszzdu8sgg	racgimon@rsthpdbs101.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
16	16	1.00	0.00	0.00	7gs8x44r7mpnb		INSERT INTO sys.wri$_adv_actio...
16	265	16.56	0.06	0.51	aqb79nn78dgyy	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT inst_id, service_name...
16	55	3.44	0.05	0.55	arx2rgss6k33m	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT s.inst_id, s.name, i...
16	16	1.00	0.00	0.00	g5vpd5g3y90qv		INSERT INTO sys.wri$_adv_recom...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,239
Captured SQL account for 69.8% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
131	16	10.57	7frqszzdu8sgg	racgimon@rsthpdbs101.us.oracle.com (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
108	108	8.72	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
99	99	7.99	f80h0xb1qvbsk		SELECT sys.wri$_adv_seq_msggro...
53	37	4.28	fgqt3gak6vv8x	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT instance_name ...
48	16	3.87	arx2rgss6k33m	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT s.inst_id, s.name, i...
41	41	3.31	6xvp6nxs4a9n4		select nvl(sum(space), 0) from...
41	41	3.31	csnp95dz2r8ss		select file#, block# from rec...
33	33	2.66	c4nhd1ntptxq7		select message_level, sequenc...
32	16	2.58	aqb79nn78dgyy	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT inst_id, service_name...
24	24	1.94	3sqgkcng6vx8r		INSERT INTO sys.wri$_adv_ratio...
23	7	1.86	1mjhyad05m8pf	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT value ...
23	7	1.86	8j37z6cqf3s9h	perl@rsthpdbs101.us.oracle.com (TNS V1-V3)	SELECT value ...
19	19	1.53	fnz13xnvkybtj		INSERT INTO sys.wri$_adv_findi...
17	1	1.37	arty65g64fmt7	SQL*Plus	select /* one / /+ pa...
16	16	1.29	2gxbvynrd71dr		INSERT INTO sys.wri$_adv_rec_a...
16	16	1.29	7gs8x44r7mpnb		INSERT INTO sys.wri$_adv_actio...
16	16	1.29	g5vpd5g3y90qv		INSERT INTO sys.wri$_adv_recom...
15	15	1.21	g1m6f233p8bth		INSERT INTO wri$_adv_addm_fdg ...

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

Cluster Wait Time (s)	%Ela	%Total	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Module	SQL Text
0.58	7.24	60.32	7.97	4.83	1	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0.44	62.50	46.10	0.71	0.29	1	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.11	81.10	11.64	0.14	0.04	1	084n00125zh7c		SELECT count(*) over () as to...
0.10	98.14	10.28	0.10	0.00	1	94zfpcfa9qk2g		SELECT sum(s2.writes_mttr - s...
0.09	82.52	9.81	0.11	0.01	1	5cdjt2acrtjjg		SELECT /*+ NO_MERGE(map) USE_...
0.05	95.64	5.31	0.05	0.01	34	5yv0nj5hwfz5d		select job, nvl2(last_date, ...
0.02	45.83	2.39	0.05	0.04	1	972qhvq36awwy		SELECT startsn.stat_id, smap...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

084n00125zh7c SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.fg_cnt, sd_xe_ash_nm.fg_wts_diff, sd_xe_ash_nm.fg_tmo_diff, sd_xe_ash_nm.fg_tim_wait_diff, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tot_tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt, nvl(ash.fg_cnt, 0) as fg_cnt FROM ( SELECT nvl(xe.k eh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.fg_wts_diff, 0) as fg_wts_diff, nvl(sd.fg_tmo_diff, 0) as fg_tmo_diff, nvl(sd.fg_tim_wait_diff, 0) as fg_tim_wait_diff, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tot_tim_wait_diff, 0) as tot_tim_wait_diff FROM ( SELECT endsn.event_id as event_id, sum(endsn.total_waits_fg - nvl(begsn.total_waits_fg, 0)) as fg_wts_diff, sum(endsn.total_timeouts_fg - nvl(begsn.total_timeouts_fg, 0)) as fg_tmo_diff, sum(endsn.time_waited_micro_fg - nvl(begsn.time_waited_micro_fg, 0)) as fg_tim_wait_diff, sum(endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, sum(endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, sum(endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tot_tim_wait_diff FROM ( SELECT * FROM WRH$_SYSTEM_EVENT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) endsn LEFT OUTER JOIN ( SELECT * FROM WRH$_SYSTEM_EVENT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) begsn ON (endsn.event_id = begsn.event_id AND endsn.instance_number = begsn.instance_number) GROUP BY endsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt, sum(decode(a.session_type, 1, 1, 0)) as fg_cnt FROM WRH$_ACTIVE_SESSION_HISTORY a WHERE a.dbid = :dbid AND a.snap_id > :bid AND a.snap_id <= :eid and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.fg_tim_wait_diff DESC, sd_xe_ash_nm.event_id

0h6b2sajwb74n select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

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

0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

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)

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

1uk5m5qbzj1vt BEGIN dbms_workload_repository.create_snapshot; END;

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

2afsg03va7jtm INSERT /*+ APPEND */ 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)

2gxbvynrd71dr INSERT INTO sys.wri$_adv_rec_actions (task_id, rec_id, act_id) VALUES (:1, :2, :3)

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

3sqgkcng6vx8r INSERT INTO sys.wri$_adv_rationale (id, task_id, rec_id, obj_id, impact_msg_id, impact_val, msg_id, type, attr1, attr2, attr3, attr4, attr5, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, ' ', :13) RETURNING rowid INTO :14

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

5cdjt2acrtjjg SELECT /*+ NO_MERGE(map) USE_HASH(map) */ p.parameter_hash as parameter_hash, max(map.parameter_name) as parameter_name, max (map.keh_id) as keh_id, max (case when p.snap_id = :bid then upper(p.value) else null end) as first_value, max (case when p.snap_id = :eid then upper(p.value) else null end) as last_value, max (case when p.isdefault = 'TRUE' then upper(p.value) else null end) as default_value, max (upper(p.value)) as max_value, min (upper(p.value)) as min_value, max (case when p.snap_id = :bid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as first_is_mod, max (case when p.snap_id = :eid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as last_is_mod FROM ( SELECT /*+ USE_HASH(xmap) */ xmap.keh_id as keh_id, xmap.parameter_hash as parameter_hash, pn.parameter_name as parameter_name FROM X$KEHPRMMAP xmap , WRH$_PARAMETER_NAME pn WHERE pn.dbid = :dbid AND pn.parameter_hash = xmap.parameter_hash ) map, WRH$_PARAMETER p WHERE p.parameter_hash = map.parameter_hash AND p.dbid = :dbid AND p.snap_id >= :bid AND p.snap_id <= :eid GROUP BY p.parameter_hash

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

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

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

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

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

7gs8x44r7mpnb INSERT INTO sys.wri$_adv_actions (id, task_id, obj_id, command, msg_id, flags, attr1, attr2, attr3, attr4, attr5, attr6, num_attr1, num_attr2, num_attr3, num_attr4, num_attr5, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, ' ', ' ', :11, :12, :13, :14, :15, :16) RETURNING rowid INTO :17

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

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

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

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

94zfpcfa9qk2g SELECT sum(s2.writes_mttr - s1.writes_mttr), sum(s2.writes_logfile_size - s1.writes_logfile_size), sum(s2.WRITES_LOG_CHECKPOINT_SETTINGS + s2.WRITES_OTHER_SETTINGS) - sum(s1.WRITES_LOG_CHECKPOINT_SETTINGS + s1.WRITES_OTHER_SETTINGS) FROM WRH$_INSTANCE_RECOVERY s1 , WRH$_INSTANCE_RECOVERY s2 WHERE s2.dbid = :dbid AND s2.snap_id = :eid AND s1.dbid = :dbid AND s1.instance_number = s2.instance_number AND s1.snap_id = :bid

972qhvq36awwy SELECT startsn.stat_id, smap.keh_id, sum(GREATEST( 0, (endsn.value - startsn.value) )) as value_diff FROM WRH$_SYSSTAT startsn , WRH$_SYSSTAT endsn , X$KEHSYSMAP smap WHERE startsn.stat_id = endsn.stat_id and startsn.stat_id = smap.statistic_hash and endsn.dbid = :dbid AND endsn.snap_id = :eid AND startsn.dbid = :dbid AND startsn.instance_number = endsn.instance_number AND startsn.snap_id = :bid GROUP BY startsn.stat_id, smap.keh_id ORDER BY startsn.stat_id ASC

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

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

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

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

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

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

f80h0xb1qvbsk SELECT sys.wri$_adv_seq_msggroup.nextval FROM dual

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

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

g1m6f233p8bth INSERT INTO wri$_adv_addm_fdg ( TASK_ID, FINDING_ID, RULE_ID, ADDM_FDG_ID, ADDM_SEQ, DATABASE_TIME, ACTIVE_SESSIONS, PERC_ACTIVE_SESS, IS_AGGREGATE, METER_LEVEL) VALUES ( :tid, :kea_id, :rid, :fdg_id, :keh_id, :dbt, round(:dbt / (1000000 * :sint) , 2), round(((:dbt * 100) / :total_dbt) , 2), 'N', NULL)

g5vpd5g3y90qv INSERT INTO sys.wri$_adv_recommendations (id, task_id, finding_id, rank, benefit_msg_id, benefit_val, type, flags, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9)

SQL Id	SQL Text
084n00125zh7c	SELECT count() over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.fg_cnt, sd_xe_ash_nm.fg_wts_diff, sd_xe_ash_nm.fg_tmo_diff, sd_xe_ash_nm.fg_tim_wait_diff, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tot_tim_wait_diff FROM ( SELECT sd_xe_ash., evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe., nvl(ash.cnt, 0) as ash_cnt, nvl(ash.fg_cnt, 0) as fg_cnt FROM ( SELECT nvl(xe.k eh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.fg_wts_diff, 0) as fg_wts_diff, nvl(sd.fg_tmo_diff, 0) as fg_tmo_diff, nvl(sd.fg_tim_wait_diff, 0) as fg_tim_wait_diff, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tot_tim_wait_diff, 0) as tot_tim_wait_diff FROM ( SELECT endsn.event_id as event_id, sum(endsn.total_waits_fg - nvl(begsn.total_waits_fg, 0)) as fg_wts_diff, sum(endsn.total_timeouts_fg - nvl(begsn.total_timeouts_fg, 0)) as fg_tmo_diff, sum(endsn.time_waited_micro_fg - nvl(begsn.time_waited_micro_fg, 0)) as fg_tim_wait_diff, sum(endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, sum(endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, sum(endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tot_tim_wait_diff FROM ( SELECT FROM WRH$_SYSTEM_EVENT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) endsn LEFT OUTER JOIN ( SELECT * FROM WRH$_SYSTEM_EVENT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) begsn ON (endsn.event_id = begsn.event_id AND endsn.instance_number = begsn.instance_number) GROUP BY endsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt, sum(decode(a.session_type, 1, 1, 0)) as fg_cnt FROM WRH$_ACTIVE_SESSION_HISTORY a WHERE a.dbid = :dbid AND a.snap_id > :bid AND a.snap_id <= :eid and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.fg_tim_wait_diff DESC, sd_xe_ash_nm.event_id
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0v6s91manuhz8	/* OracleOEM */ SELECT blocking_sid, num_blocked FROM ( SELECT blocking_sid, SUM(num_blocked) num_blocked FROM ( SELECT l.id1, l.id2, MAX(DECODE(l.block, 1, i.instance_name\|\|'-'\|\|l.sid, 2, i.instance_name\|\|'-'\|\|l.sid, 0 )) blocking_sid, SUM(DECODE(l.request, 0, 0, 1 )) num_blocked FROM gv$lock l, gv$instance i WHERE ( l.block!= 0 OR l.request > 0 ) AND l.inst_id = i.inst_id GROUP BY l.id1, l.id2) GROUP BY blocking_sid ORDER BY num_blocked DESC) WHERE num_blocked != 0 AND blocking_sid != '0'
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
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)
1mjhyad05m8pf	SELECT value FROM gv$osstat WHERE inst_id = :p1 and stat_name='NUM_CPU_CORES'
1uk5m5qbzj1vt	BEGIN dbms_workload_repository.create_snapshot; END;
1ytruncyx2kdb	BEGIN MGMT_HTTP_SESSION.session_expired(:1); END;
2afsg03va7jtm	INSERT /+ APPEND / 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)
2gxbvynrd71dr	INSERT INTO sys.wri$_adv_rec_actions (task_id, rec_id, act_id) VALUES (:1, :2, :3)
3m8smr0v7v1m6	INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
3sqgkcng6vx8r	INSERT INTO sys.wri$_adv_rationale (id, task_id, rec_id, obj_id, impact_msg_id, impact_val, msg_id, type, attr1, attr2, attr3, attr4, attr5, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, ' ', :13) RETURNING rowid INTO :14
5ax5xu96u2ztd	insert into WRH$_EVENT_HISTOGRAM (snap_id, dbid, instance_number, event_id, wait_time_milli, wait_count) select :snap_id, :dbid, :instance_number, d.ksledhash, s.kslsesmaxdur, s.kslsesval from x$kslseshist s, x$ksled d where s.kslsesenum = d.indx and s.kslsesval > 0 order by d.ksledhash, s.kslsesmaxdur
5cdjt2acrtjjg	SELECT /+ NO_MERGE(map) USE_HASH(map) / p.parameter_hash as parameter_hash, max(map.parameter_name) as parameter_name, max (map.keh_id) as keh_id, max (case when p.snap_id = :bid then upper(p.value) else null end) as first_value, max (case when p.snap_id = :eid then upper(p.value) else null end) as last_value, max (case when p.isdefault = 'TRUE' then upper(p.value) else null end) as default_value, max (upper(p.value)) as max_value, min (upper(p.value)) as min_value, max (case when p.snap_id = :bid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as first_is_mod, max (case when p.snap_id = :eid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as last_is_mod FROM ( SELECT /+ USE_HASH(xmap) / xmap.keh_id as keh_id, xmap.parameter_hash as parameter_hash, pn.parameter_name as parameter_name FROM X$KEHPRMMAP xmap , WRH$_PARAMETER_NAME pn WHERE pn.dbid = :dbid AND pn.parameter_hash = xmap.parameter_hash ) map, WRH$_PARAMETER p WHERE p.parameter_hash = map.parameter_hash AND p.dbid = :dbid AND p.snap_id >= :bid AND p.snap_id <= :eid GROUP BY p.parameter_hash
5yv0nj5hwfz5d	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6xvp6nxs4a9n4	select nvl(sum(space), 0) from recyclebin$ where ts# = :1
7frqszzdu8sgg	select DECODE(UPPER(d.OPEN_MODE), 'READ WRITE', 'R', 'N') , DECODE(UPPER(i.STATUS), 'OPEN', 'O', 'N') into :b0, :b1 from v$database d , gv$instance i where i.INSTANCE_NAME=:b2
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
7gs8x44r7mpnb	INSERT INTO sys.wri$_adv_actions (id, task_id, obj_id, command, msg_id, flags, attr1, attr2, attr3, attr4, attr5, attr6, num_attr1, num_attr2, num_attr3, num_attr4, num_attr5, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, ' ', ' ', :11, :12, :13, :14, :15, :16) RETURNING rowid INTO :17
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
87gaftwrm2h68	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
8j37z6cqf3s9h	SELECT value FROM gv$osstat WHERE inst_id = :p1 and stat_name='NUM_CPUS'
8z3tqxkjw4sg4	select px.SID "SID", p.PID, p.SPID "SPID", px.INST_ID "Inst", px.SERVER_GROUP "Group", px.SERVER_SET "Set", px.DEGREE "Degree", px.REQ_DEGREE "Req Degree", w.event "Wait Event", s.sql_id from GV$SESSION s, GV$PX_SESSION px, GV$PROCESS p, GV$SESSION_WAIT w where s.sid (+) = px.sid and s.inst_id (+) = px.inst_id and s.sid = w.sid (+) and s.inst_id = w.inst_id (+) and s.paddr = p.addr (+) and s.inst_id = p.inst_id (+) ORDER BY decode(px.QCINST_ID, NULL, px.INST_ID, px.QCINST_ID), px.QCSID, decode(px.SERVER_GROUP, NULL, 0, px.SERVER_GROUP), px.SERVER_SET, px.INST_ID
94zfpcfa9qk2g	SELECT sum(s2.writes_mttr - s1.writes_mttr), sum(s2.writes_logfile_size - s1.writes_logfile_size), sum(s2.WRITES_LOG_CHECKPOINT_SETTINGS + s2.WRITES_OTHER_SETTINGS) - sum(s1.WRITES_LOG_CHECKPOINT_SETTINGS + s1.WRITES_OTHER_SETTINGS) FROM WRH$_INSTANCE_RECOVERY s1 , WRH$_INSTANCE_RECOVERY s2 WHERE s2.dbid = :dbid AND s2.snap_id = :eid AND s1.dbid = :dbid AND s1.instance_number = s2.instance_number AND s1.snap_id = :bid
972qhvq36awwy	SELECT startsn.stat_id, smap.keh_id, sum(GREATEST( 0, (endsn.value - startsn.value) )) as value_diff FROM WRH$_SYSSTAT startsn , WRH$_SYSSTAT endsn , X$KEHSYSMAP smap WHERE startsn.stat_id = endsn.stat_id and startsn.stat_id = smap.statistic_hash and endsn.dbid = :dbid AND endsn.snap_id = :eid AND startsn.dbid = :dbid AND startsn.instance_number = endsn.instance_number AND startsn.snap_id = :bid GROUP BY startsn.stat_id, smap.keh_id ORDER BY startsn.stat_id ASC
aqb79nn78dgyy	SELECT inst_id, service_name, TO_CHAR(CAST(begin_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') time, TO_CHAR(CAST(end_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') time, intsize_csec, group_id, cpupercall, dbtimepercall, callspersec, dbtimepersec FROM gv$servicemetric_history WHERE service_name = :p1 AND end_time >= SYSDATE - 5/(60*24) AND group_id = 6 ORDER BY inst_id asc, end_time DESC
arty65g64fmt7	select /* one / /+ parallel (t1, 16) parallel (t2, 16) */ min (t1.bsns_unit_key + t2.bsns_unit_key), max (t1.day_key + t2.day_key), avg (t1.day_key + t2.day_key), max (t1.bsns_unit_typ_cd), max (t2.curr_ind), max (t1.load_dt) from d31.dwb_rtl_trx t1, d31.dwb_rtl_trx t2 where t1.trx_nbr = t2.trx_nbr
arx2rgss6k33m	SELECT s.inst_id, s.name, i.instance_name FROM gv$active_services s, gv$instance i WHERE s.name = :p1 AND s.inst_id = i.inst_id
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
c4nhd1ntptxq7	select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4
csnp95dz2r8ss	select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
f80h0xb1qvbsk	SELECT sys.wri$_adv_seq_msggroup.nextval FROM dual
fgqt3gak6vv8x	SELECT instance_name FROM gv$instance WHERE inst_id = :p1
fnz13xnvkybtj	INSERT INTO sys.wri$_adv_findings (id, task_id, type, parent, obj_id, impact_msg_id, impact_val, msg_id, more_info_id, name_msg_code, flags, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
g1m6f233p8bth	INSERT INTO wri$_adv_addm_fdg ( TASK_ID, FINDING_ID, RULE_ID, ADDM_FDG_ID, ADDM_SEQ, DATABASE_TIME, ACTIVE_SESSIONS, PERC_ACTIVE_SESS, IS_AGGREGATE, METER_LEVEL) VALUES ( :tid, :kea_id, :rid, :fdg_id, :keh_id, :dbt, round(:dbt / (1000000 * :sint) , 2), round(((:dbt * 100) / :total_dbt) , 2), 'N', NULL)
g5vpd5g3y90qv	INSERT INTO sys.wri$_adv_recommendations (id, task_id, finding_id, rank, benefit_msg_id, benefit_val, type, flags, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9)

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	3	0.02	0.08
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	87	0.51	2.18
Batched IO buffer defrag count	1	0.01	0.03
Batched IO double miss count	23	0.13	0.58
Batched IO same unit count	36	0.21	0.90
Batched IO single block count	7	0.04	0.18
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	36	0.21	0.90
Batched IO vector read count	7	0.04	0.18
Block Cleanout Optim referenced	36	0.21	0.90
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	104,529	613.16	2,613.23
CPU used when call started	208,372	1,222.30	5,209.30
CR blocks created	25	0.15	0.63
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	48	0.28	1.20
DB time	297,826	1,747.03	7,445.65
DBWR checkpoint buffers written	27	0.16	0.68
DBWR checkpoints	1	0.01	0.03
DBWR fusion writes	5	0.03	0.13
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	4	0.02	0.10
DBWR undo block writes	5	0.03	0.13
DFO trees parallelized	129	0.76	3.23
DML statements parallelized	0	0.00	0.00
Effective IO time	0	0.00	0.00
HSC Compressed Segment Block Changes	0	0.00	0.00
HSC Heap Segment Block Changes	626	3.67	15.65
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	116	0.68	2.90
Heap Segment Array Updates	5	0.03	0.13
LOB table id lookup cache misses	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
Number of read IOs issued	0	0.00	0.00
PX local messages recv'd	860	5.04	21.50
PX local messages sent	860	5.04	21.50
PX remote messages recv'd	2,042	11.98	51.05
PX remote messages sent	2,042	11.98	51.05
Parallel operations downgraded 1 to 25 pct	0	0.00	0.00
Parallel operations downgraded 25 to 50 pct	0	0.00	0.00
Parallel operations downgraded 75 to 99 pct	0	0.00	0.00
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	129	0.76	3.23
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for dropping temp segment	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	383	2.25	9.58
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	111	0.65	2.78
application wait time	42	0.25	1.05
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	1,052	6.17	26.30
branch node splits	0	0.00	0.00
buffer is not pinned count	4,939	28.97	123.48
buffer is pinned count	31,496	184.75	787.40
bytes received via SQL*Net from client	261,427	1,533.51	6,535.68
bytes sent via SQL*Net to client	166,967	979.42	4,174.18
calls to get snapshot scn: kcmgss	18,017	105.69	450.43
calls to kcmgas	707	4.15	17.68
calls to kcmgcs	666	3.91	16.65
cell blocks helped by minscn optimization	7,641,804	44,826.27	191,045.10
cell blocks processed by cache layer	7,641,804	44,826.27	191,045.10
cell blocks processed by data layer	7,641,804	44,826.27	191,045.10
cell blocks processed by txn layer	7,641,804	44,826.27	191,045.10
cell physical IO bytes eligible for predicate offload	62,447,910,912	366,314,970.51	1,561,197,772.80
cell physical IO bytes saved during optimized file creation	0	0.00	0.00
cell physical IO interconnect bytes	136,136,558,768	798,567,298.43	3,403,413,969.20
cell scans	3,968	23.28	99.20
change write time	2	0.01	0.05
cleanout - number of ktugct calls	156	0.92	3.90
cleanouts and rollbacks - consistent read gets	30	0.18	0.75
cleanouts only - consistent read gets	43	0.25	1.08
cluster key scan block gets	42	0.25	1.05
cluster key scans	42	0.25	1.05
cluster wait time	96	0.56	2.40
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: block lost	25	0.15	0.63
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	5	0.03	0.13
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	447	2.62	11.18
commit cleanouts successfully completed	417	2.45	10.43
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	281	1.65	7.03
concurrency wait time	1,855	10.88	46.38
consistent changes	82	0.48	2.05
consistent gets	7,658,348	44,923.32	191,458.70
consistent gets - examination	2,280	13.37	57.00
consistent gets direct	7,623,036	44,716.18	190,575.90
consistent gets from cache	35,312	207.14	882.80
consistent gets from cache (fastpath)	31,667	185.76	791.68
current blocks converted for CR	0	0.00	0.00
cursor authentications	9	0.05	0.23
data blocks consistent reads - undo records applied	31	0.18	0.78
db block changes	4,208	24.68	105.20
db block gets	4,857	28.49	121.43
db block gets direct	9	0.05	0.23
db block gets from cache	4,848	28.44	121.20
db block gets from cache (fastpath)	1,597	9.37	39.93
deferred (CURRENT) block cleanout applications	203	1.19	5.08
dirty buffers inspected	0	0.00	0.00
enqueue conversions	2,137	12.54	53.43
enqueue releases	40,157	235.56	1,003.93
enqueue requests	40,547	237.85	1,013.68
enqueue timeouts	390	2.29	9.75
enqueue waits	3,932	23.06	98.30
exchange deadlocks	0	0.00	0.00
execute count	1,598	9.37	39.95
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	0	0.00	0.00
free buffer requested	2,561	15.02	64.03
gc CPU used by this session	20	0.12	0.50
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	251	1.47	6.28
gc cr block send time	1	0.01	0.03
gc cr blocks received	1,991	11.68	49.78
gc cr blocks served	270	1.58	6.75
gc current block flush time	3	0.02	0.08
gc current block pin time	0	0.00	0.00
gc current block receive time	22	0.13	0.55
gc current block send time	1	0.01	0.03
gc current blocks received	451	2.65	11.28
gc current blocks served	447	2.62	11.18
gc local grants	37	0.22	0.93
gc reader bypass grants	26	0.15	0.65
gc remote grants	98	0.57	2.45
gcs messages sent	4,886	28.66	122.15
ges messages sent	19,289	113.15	482.23
global enqueue get time	12,921	75.79	323.03
global enqueue gets async	759	4.45	18.98
global enqueue gets sync	43,210	253.47	1,080.25
global enqueue releases	40,778	239.20	1,019.45
heap block compress	10	0.06	0.25
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	73	0.43	1.83
immediate (CURRENT) block cleanout applications	127	0.74	3.18
index crx upgrade (positioned)	136	0.80	3.40
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fetch by key	867	5.09	21.68
index scans kdiixs1	5,077	29.78	126.93
leaf node 90-10 splits	31	0.18	0.78
leaf node splits	40	0.23	1.00
lob reads	0	0.00	0.00
lob writes	65	0.38	1.63
lob writes unaligned	65	0.38	1.63
logons cumulative	275	1.61	6.88
messages received	35,198	206.47	879.95
messages sent	35,198	206.47	879.95
min active SCN optimization applied to CR	0	0.00	0.00
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	15,439	90.56	385.98
opened cursors cumulative	1,595	9.36	39.88
parse count (describe)	2	0.01	0.05
parse count (failures)	5	0.03	0.13
parse count (hard)	14	0.08	0.35
parse count (total)	1,239	7.27	30.98
parse time cpu	20	0.12	0.50
parse time elapsed	609	3.57	15.23
physical IO disk bytes	165,486,289,920	970,730,718.22	4,137,157,248.00
physical read IO requests	217,524	1,275.98	5,438.10
physical read bytes	96,791,625,728	567,772,740.61	2,419,790,643.20
physical read total IO requests	219,158	1,285.57	5,478.95
physical read total bytes	96,818,225,152	567,928,770.92	2,420,455,628.80
physical read total multi block requests	216,392	1,269.34	5,409.80
physical reads	11,815,384	69,308.20	295,384.60
physical reads cache	1	0.01	0.03
physical reads cache prefetch	0	0.00	0.00
physical reads direct	11,815,383	69,308.19	295,384.58
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	4,192,347	24,592.01	104,808.68
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	135,202	793.09	3,380.05
physical write bytes	34,327,764,992	201,364,209.58	858,194,124.80
physical write total IO requests	135,440	794.48	3,386.00
physical write total bytes	34,332,557,824	201,392,323.99	858,313,945.60
physical write total multi block requests	135,177	792.94	3,379.43
physical writes	4,190,401	24,580.59	104,760.03
physical writes direct	4,190,372	24,580.42	104,759.30
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	4,190,363	24,580.37	104,759.08
physical writes from cache	29	0.17	0.73
physical writes non checkpoint	4,190,374	24,580.43	104,759.35
pinned buffers inspected	0	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	0	0.00	0.00
queries parallelized	106	0.62	2.65
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	42,241	247.78	1,056.03
recursive cpu usage	103,326	606.10	2,583.15
redo blocks checksummed by FG (exclusive)	2,484	14.57	62.10
redo blocks written	3,716	21.80	92.90
redo buffer allocation retries	0	0.00	0.00
redo entries	2,268	13.30	56.70
redo k-bytes read total	0	0.00	0.00
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	94	0.55	2.35
redo size	1,810,888	10,622.54	45,272.20
redo size for direct writes	52	0.31	1.30
redo subscn max counts	159	0.93	3.98
redo synch time	0	0.00	0.00
redo synch writes	2	0.01	0.05
redo wastage	14,168	83.11	354.20
redo write broadcast ack time	1	0.01	0.03
redo write time	2	0.01	0.05
redo writer latching time	0	0.00	0.00
redo writes	59	0.35	1.48
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	1	0.01	0.03
rows fetched via callback	522	3.06	13.05
session connect time	0	0.00	0.00
session cursor cache hits	891	5.23	22.28
session logical reads	7,663,204	44,951.81	191,580.10
shared hash latch upgrades - no wait	348	2.04	8.70
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	4,626	27.14	115.65
sorts (rows)	15,891	93.22	397.28
sql area evicted	0	0.00	0.00
sql area purged	5	0.03	0.13
summed dirty queue length	0	0.00	0.00
switch current to new buffer	6	0.04	0.15
table fetch by rowid	17,444	102.33	436.10
table fetch continued row	0	0.00	0.00
table scan blocks gotten	7,626,978	44,739.31	190,674.45
table scan rows gotten	936,569,491	5,493,849.52	23,414,237.28
table scans (direct read)	3,968	23.28	99.20
table scans (long tables)	3,968	23.28	99.20
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	110	0.65	2.75
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
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	648,192	3,802.25	16,204.80
user I/O wait time	118,735	696.49	2,968.38
user calls	1,797	10.54	44.93
user commits	23	0.13	0.58
user rollbacks	17	0.10	0.43
workarea executions - onepass	80	0.47	2.00
workarea executions - optimal	4,625	27.13	115.63
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session uga memory max	1,565,381,517,728	1,572,912,530,928
session pga memory	1,006,202,027,200	1,006,811,496,256
session pga memory max	5,493,187,473,856	5,503,865,321,184
session cursor cache count	18,446,744,073,708,879,535	18,446,744,073,708,879,033
session uga memory	895,796,990,144	895,810,097,848
opened cursors current	80	83
workarea memory allocated	0	354
logons current	46	46

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	134,938	792	2.20	31.02	135,143	793
SYSAUX	1	0	80.00	1.00	21	0
UNDOTBS1	0	0	0.00	0.00	8	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	80.00	1.00	21	0	0.00
TEMP	+DGA/demo/tempfile/temp.419.686904819	134,938	792	2.20	31.02	135,143	793
UNDOTBS1	+DGA/demo/datafile/undotbs1.418.686904817	0	0			8	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	456,540	100	40,053	1	29	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	300	1444	11499	1887390	11499
E	0	1	896	5022	11468	1887390	11468

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	384	0.10	45,654	1.26	19,317
D	768	0.20	91,308	1.15	17,562
D	1,152	0.30	136,962	1.07	16,381
D	1,536	0.40	182,616	1.02	15,607
D	1,920	0.50	228,270	1.01	15,406
D	2,304	0.60	273,924	1.01	15,383
D	2,688	0.70	319,578	1.01	15,374
D	3,072	0.80	365,232	1.00	15,330
D	3,456	0.90	410,886	1.00	15,310
D	3,840	1.00	456,540	1.00	15,281
D	4,224	1.10	502,194	1.00	15,266
D	4,608	1.20	547,848	1.00	15,249
D	4,992	1.30	593,502	1.00	15,237
D	5,376	1.40	639,156	1.00	15,227
D	5,760	1.50	684,810	1.00	15,222
D	6,144	1.60	730,464	0.99	15,195
D	6,528	1.70	776,118	0.98	14,938
D	6,912	1.80	821,772	0.98	14,916
D	7,296	1.90	867,426	0.97	14,893
D	7,680	2.00	913,080	0.97	14,800

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.05	36,754	36,684

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,793	690.16	0.00	0.00	0.00	0.00	1,048,576
E	12,288	10,791	727.54	0.35	0.05	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	4,547	4,547	0
64K	128K	5	5	0
128K	256K	2	2	0
256K	512K	2	2	0
512K	1024K	57	57	0
1M	2M	12	12	0
256M	512M	80	0	80

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
1,536	0.13	848,549.55	858,518.48	50.00	89	957,916,777
3,072	0.25	848,549.55	94,673.52	90.00	0	529,287,166
6,144	0.50	848,549.55	73,516.57	92.00	0	517,414,997
9,216	0.75	848,549.55	73,516.57	92.00	0	517,414,997
12,288	1.00	848,549.55	73,516.57	92.00	0	517,414,997
14,746	1.20	848,549.55	29,375.06	97.00	0	492,645,107
17,203	1.40	848,549.55	29,375.06	97.00	0	492,645,107
19,661	1.60	848,549.55	29,375.06	97.00	0	492,645,107
22,118	1.80	848,549.55	29,375.06	97.00	0	492,645,107
24,576	2.00	848,549.55	29,375.06	97.00	0	492,645,107
36,864	3.00	848,549.55	0.00	100.00	0	476,161,367
49,152	4.00	848,549.55	0.00	100.00	0	476,161,367
73,728	6.00	848,549.55	0.00	100.00	0	476,161,367
98,304	8.00	848,549.55	0.00	100.00	0	476,161,367

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)
1,344	0.70	88	7,204	83,643	0.99	2,734	1.23	4,790
1,536	0.80	282	20,101	83,774	1.00	2,603	1.17	10,592
1,728	0.90	472	30,280	84,015	1.00	2,362	1.06	10,625
1,920	1.00	664	45,340	84,152	1.00	2,225	1.00	10,643
2,112	1.10	856	60,742	84,221	1.00	2,156	0.97	10,654
2,304	1.20	1,048	70,753	84,260	1.00	2,117	0.95	10,662
2,496	1.30	1,240	81,966	84,278	1.00	2,099	0.94	10,666
2,688	1.40	1,432	95,998	84,289	1.00	2,088	0.94	10,667
2,880	1.50	1,624	121,877	84,297	1.00	2,080	0.93	10,668
3,072	1.60	1,816	153,380	84,306	1.00	2,071	0.93	10,670
3,264	1.70	2,008	170,249	84,319	1.00	2,058	0.92	10,671
3,456	1.80	2,200	179,568	84,331	1.00	2,046	0.92	10,672
3,648	1.90	2,392	191,654	84,337	1.00	2,040	0.92	10,672
3,840	2.00	2,554	203,461	84,337	1.00	2,040	0.92	10,672

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
2,304	0.38	434,746	19,161
3,072	0.50	434,269	19,161
3,840	0.63	434,225	19,161
4,608	0.75	434,182	17,419
5,376	0.88	434,182	16,250
6,144	1.00	434,182	15,281
6,912	1.13	434,182	15,206
7,680	1.25	434,182	15,157
8,448	1.38	434,182	15,125
9,216	1.50	434,182	15,113
9,984	1.63	434,182	15,099
10,752	1.75	434,182	14,795
11,520	1.88	434,182	14,771
12,288	2.00	434,182	14,680

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
64	0.50	0	0	0	0
128	1.00	0	0	0	0
192	1.50	0	0	0	0
256	2.00	0	0	0	0
320	2.50	0	0	0	0
384	3.00	0	0	0	0
448	3.50	0	0	0	0
512	4.00	0	0	0	0
576	4.50	0	0	0	0
640	5.00	0	0	0	0
704	5.50	0	0	0	0
768	6.00	0	0	0	0
832	6.50	0	0	0	0
896	7.00	0	0	0	0
960	7.50	0	0	0	0
1,024	8.00	0	0	0	0
1,088	8.50	0	0	0	0
1,152	9.00	0	0	0	0
1,216	9.50	0	0	0	0
1,280	10.00	0	0	0	0

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	Wt Time (s)	Av Wt Time(ms)
TT-Tablespace	34,726	34,726	0	1,966	84	42.82
PS-PX Process Reservation	3,774	3,385	389	1,916	9	4.80
KO-Multiple Object Checkpoint (fast object checkpoint)	9	9	0	4	0	27.50
CF-Controlfile Transaction	362	362	0	7	0	11.43
WF-AWR Flush	21	21	0	18	0	0.00
PI-Remote PX Process Spawn Status	30	30	0	16	0	0.00
FB-Format Block	2	2	0	2	0	0.00
AF-Advisor Framework (task serialization)	13	13	0	1	0	0.00
TM-DML	583	583	0	1	0	0.00
TQ-Queue table enqueue (TM contention)	1	1	0	1	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	636	0.00		0	0
ASM map operation freelist	6	0.00		0	0
ASM map operation hash table	980,477	0.00	0.00	0	0
ASM network background latch	68	0.00		0	0
AWR Alerted Metric Element list	1,289	0.00		0	0
Change Notification Hash table latch	57	0.00		0	0
Consistent RBA	57	0.00		0	0
DML lock allocation	302,198	0.00		0	0
Event Group Locks	13	0.00		0	0
FOB s.o list latch	26	0.00		0	0
File State Object Pool Parent Latch	1	0.00		0	0
IPC stats buffer allocation latch	1,331	0.00		0	1,353	0.00
In memory undo latch	1	0.00		0	0
JS Sh mem access	3	0.00		0	0
JS broadcast add buf latch	39	0.00		0	0
JS broadcast drop buf latch	39	0.00		0	0
JS broadcast load blnc latch	35	0.00		0	0
JS queue access latch	1	0.00		0	0
JS queue state obj latch	2,310	0.00		0	0
JS slv state obj latch	1	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KFK SGA Libload latch	1,848	0.00		0	0
KFMD SGA	75	0.00		0	0
KFR redo allocation latch	1	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	2,359	0.25	0.00	0	3,217	0.00
KJCT flow control latch	39,687	0.02	0.00	0	0
KMG MMAN ready and startup request latch	57	0.00		0	0
KSXR large replies	56	0.00		0	0
KTF sga latch	3	0.00		0	51	0.00
KWQMN job cache list latch	17	0.00		0	0
KWQP Prop Status	2	0.00		0	0
KWQS pqsubs latch	12	0.00		0	0
KWQS pqueue ctx latch	7	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
MQL Tracking Latch	0			0	4	0.00
Memory Management Latch	1	0.00		0	57	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
MinActiveScn Latch	2,018	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	58	0.00		0	0
OS process allocation	100	0.00		0	0
OS process: request allocation	19	0.00		0	0
PL/SQL warning settings	309	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	407	0.98	0.00	0	0
SGA IO buffer pool latch	1	0.00		0	1	0.00
SGA blob parent	1	0.00		0	0
SGA bucket locks	1	0.00		0	0
SGA heap locks	1	0.00		0	0
SGA pool locks	1	0.00		0	0
SQL memory manager latch	1	0.00		0	56	0.00
SQL memory manager workarea list latch	4,327	0.00		0	0
Shared B-Tree	34	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	4,039	0.00		0	0
active service list	20,187	0.16	1.39	0	69	0.00
archive control	17	0.00		0	0
begin backup scn array	1	0.00		0	0
buffer pool	1	0.00		0	0
business card	257	0.00		0	0
cache buffer handles	90	0.00		0	0
cache buffers chains	93,524	0.00	1.00	0	8,412	0.01
cache buffers lru chain	294	0.00		0	10,486	0.01
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	29	0.00		0	0
channel operations parent latch	1,855,134	0.00	0.00	0	0
checkpoint queue latch	6,493	0.00		0	639	0.00
client/application info	1,554	0.00		0	0
commit callback allocation	1	0.00		0	0
compile environment latch	275	0.00		0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	4	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	4	0.00		0	0
dml lock allocation	4	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	551	0.00		0	0
enqueue hash chains	159,031	0.37	0.11	0	155	0.00
enqueues	79,176	0.15	0.06	0	0
error message lists	2,184	0.05	0.00	0	0
fifth spare latch	1	0.00		0	0
file cache latch	891	0.00		0	0
flashback archiver latch	1	0.00		0	0
flashback copy	1	0.00		0	0
gc element	8,691	0.01	1.00	0	3	0.00
gcs commit scn state	1	0.00		0	0
gcs opaque info freelist	498	0.00		0	0
gcs partitioned table hash	479,434	0.00		0	16	0.00
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs remaster request queue	162	0.00		0	0
gcs remastering latch	645	0.00		0	0
gcs resource freelist	1	0.00		0	3	0.00
gcs resource hash	8,214	0.00		0	1	0.00
gcs resource scan list	3	0.00		0	0
gcs shadows freelist	1,202	0.00		0	619	0.00
ges DFS wait callback info	13	0.00		0	2	0.00
ges caches resource lists	52,311	0.01	0.00	0	22,151	0.01
ges deadlock list	4,486	0.00		0	1	0.00
ges domain table	81,145	0.00		0	0
ges enqueue table freelist	83,848	0.02	0.13	0	0
ges group table	123,783	0.01	0.00	0	0
ges process hash list	966	0.00		0	0
ges process parent latch	178,053	0.00		0	0
ges process table freelist	19	0.00		0	0
ges resource hash list	146,294	0.69	0.23	1	5,179	0.64
ges resource scan list	35	0.00		0	0
ges resource table freelist	8,886	0.01	0.00	0	0
ges timeout list	1,744	0.06	0.00	0	615	0.00
ges value block free list	1	0.00		0	0
global KZLD latch for mem in SGA	4	0.00		0	0
global tx hash mapping	1	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	0			0	208	0.00
heartbeat check	1	0.00		0	35	0.00
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	1	0.00		0	0
job_queue_processes parameter latch	38	0.00		0	0
k2q global data latch	114	0.00		0	0
k2q lock allocation	1	0.00		0	0
kcfis stats shared latch	16	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kks stats	13	0.00		0	0
kokc descriptor allocation latch	130	0.00		0	0
ksfv messages	1	0.00		0	0
ksim membership request latch	70,008	0.00		0	171	0.00
kss move lock	3	0.00		0	0
ksuosstats global area	57	0.00		0	0
ksv allocation latch	8	0.00		0	0
ksv class latch	213	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksxp shared latch	19	0.00		0	0
ksz_so allocation latch	22	0.00		0	0
kwqbsn:qsga	8	0.00		0	0
lgwr LWN SCN	101	0.00		0	0
list of block allocation	26	0.00		0	0
loader state object freelist	2	0.00		0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	1	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
logical standby cache	1	0.00		0	0
logminer context allocation	2	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	65	0.00		0	64	0.00
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	2,672	0.00		0	0
messages	217,740	0.19	0.00	0	0
mostly latch-free SCN	101	0.00		0	0
msg queue latch	1	0.00		0	0
multiblock read objects	206	0.00		0	0
name-service memory objects	1,321	0.00		0	0
name-service namespace bucket	4,306	0.02	0.00	0	0
name-service pending queue	172	0.00		0	0
name-service request	10	0.00		0	0
name-service request queue	1,748	0.00		0	0
ncodef allocation latch	4	0.00		0	0
object queue header heap	372	0.00		0	95	0.00
object queue header operation	57,905	0.00		0	0
object stats modification	98	0.00		0	0
parallel query alloc buffer	8,408	0.06	0.00	0	0
parallel query stats	633	0.32	0.50	0	0
parameter list	51	0.00		0	0
parameter table management	550	0.00		0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
post/wait queue	87	0.00		0	39	0.00
process allocation	735	0.00		0	12	0.00
process group creation	19	0.00		0	0
process queue	4,185	0.00		0	0
process queue reference	100,479	0.01	0.00	0	7,925	544.69
qmn task queue latch	36	0.00		0	0
query server freelists	3,007	0.20	0.17	0	0
query server process	5	0.00		0	0
queued dump request	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	257	0.00		0	2,205	0.00
redo copy	1	0.00		0	2,205	0.00
redo writing	353	0.00		0	0
reid allocation latch	3	0.00		0	0
resmgr group change latch	425	0.00		0	0
resmgr:active threads	565	0.00		0	0
resmgr:actses change group	276	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	550	0.18	0.00	0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	55	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	34,256	0.00		0	0
rules engine rule set statistics	100	0.00		0	0
second spare latch	1	0.00		0	0
sequence cache	352	0.00		0	0
session allocation	8,419	0.64	0.69	0	0
session idle bit	3,678	0.00		0	0
session queue latch	1	0.00		0	0
session state list latch	542	0.18	0.00	0	0
session switching	5	0.00		0	0
session timer	69	0.00		0	0
shared pool	28,193	0.32	0.37	0	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	12	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	1,432	0.00		0	0
simulator lru latch	1	0.00		0	1,379	0.00
sort extent pool	36,261	0.21	0.01	0	0
space background task latch	123	0.00		0	114	0.00
state object free list	2	0.00		0	0
statistics aggregation	32,508	0.00		0	0
storage server table manipulation latch	12	0.00		0	0
tablespace key chain	3,997	0.00		0	0
temp lob duration state obj allocation	1	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
third spare latch	1	0.00		0	0
threshold alerts latch	73	0.00		0	0
transaction allocation	74,657	0.00		0	0
undo global data	971	0.00		0	0
user lock	16	0.00		0	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	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	146,294	1,011	228	802
enqueue hash chains	159,031	587	62	533
enqueues	79,176	121	7	114
shared pool	28,193	90	33	62
sort extent pool	36,261	77	1	76
session allocation	8,419	54	37	24
active service list	20,187	33	46	2
ges enqueue table freelist	83,848	15	2	14
query server freelists	3,007	6	1	5
parallel query stats	633	2	1	1
cache buffers chains	93,524	1	1	0
gc element	8,691	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
active service list	ksws_event: ksws event	26	30
active service list	kswsgsnp: get service name ptr	17	10
active service list	kswsigsn: get service name	3	6
cache buffers chains	kcbchg1: kslbegin: call CR func	1	0
enqueue hash chains	ksqcmi: if lk mode not requested	19	8
enqueue hash chains	ksqrcl	18	18
enqueue hash chains	ksqcmi: if lk mode requested	17	27
enqueue hash chains	ksqgtl3	8	9
enqueues	ksqdel	5	1
enqueues	ksqgel: create enqueue	2	6
gc element	kclchkping	1	0
ges enqueue table freelist	kjlalc: lock allocation	1	2
ges enqueue table freelist	kjlfr: remove lock from parent object	1	0
ges resource hash list	kjuscl: lock close request	160	121
ges resource hash list	kjrmas1: lookup master node	47	3
ges resource hash list	kjakcai: search for resp by resname	17	2
ges resource hash list	kjrref: find matched resource	3	100
ges resource hash list	kjucvl: lock convert request	1	1
parallel query stats	kxfprst: KSLBEGIN:1	1	1
query server freelists	kxfpobadf	1	1
session allocation	ksuxds: KSUSFCLC not set	28	14
session allocation	kxfprdp	6	7
session allocation	kxfpqidqr:1	3	16
shared pool	kghfre	24	26
shared pool	kghalo	9	7
sort extent pool	ktatobjstats	1	1

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kglpndl1 95	2
Library Cache	kglhdgn1 62	1
Library Cache	kglhdgn2 106	1
Library Cache	kglpnal2 91	1

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 7,663,204
Captured Segments account for 3.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
D31	D31	DWB_RTL_TRX	90526_H017	TABLE SUBPARTITION	11,008	0.14
D31	D31	DWB_RTL_TRX	90529_H052	TABLE SUBPARTITION	10,720	0.14
D31	D31	DWB_RTL_TRX	90508_H050	TABLE SUBPARTITION	10,400	0.14
D31	D31	DWB_RTL_TRX	90526_H029	TABLE SUBPARTITION	10,240	0.13
D31	D31	DWB_RTL_TRX	90511_H010	TABLE SUBPARTITION	10,144	0.13

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 11,815,384
Captured Segments account for 1.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
D31	D31	DWB_RTL_TRX	90508_H050	TABLE SUBPARTITION	3,900	0.03
D31	D31	DWB_RTL_TRX	90510_H003	TABLE SUBPARTITION	3,890	0.03
D31	D31	DWB_RTL_TRX	90510_H020	TABLE SUBPARTITION	3,886	0.03
D31	D31	DWB_RTL_TRX	90506_H049	TABLE SUBPARTITION	3,880	0.03
D31	D31	DWB_RTL_TRX	90531_H038	TABLE SUBPARTITION	3,880	0.03

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 11,815,383
Captured Segments account for 1.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
D31	D31	DWB_RTL_TRX	90508_H050	TABLE SUBPARTITION	3,900	0.03
D31	D31	DWB_RTL_TRX	90510_H003	TABLE SUBPARTITION	3,890	0.03
D31	D31	DWB_RTL_TRX	90510_H020	TABLE SUBPARTITION	3,886	0.03
D31	D31	DWB_RTL_TRX	90506_H049	TABLE SUBPARTITION	3,880	0.03
D31	D31	DWB_RTL_TRX	90531_H038	TABLE SUBPARTITION	3,880	0.03

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 4,190,401
Captured Segments account for 0.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	75138_1021	TABLE PARTITION	9	0.00

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 4,190,372
Captured Segments account for 0.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	75138_1021	TABLE PARTITION	9	0.00

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 3,968
Captured Segments account for 1.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
D31	D31	DWB_RTL_TRX	90502_H007	TABLE SUBPARTITION	2	0.05
D31	D31	DWB_RTL_TRX	90503_H023	TABLE SUBPARTITION	2	0.05
D31	D31	DWB_RTL_TRX	90504_H061	TABLE SUBPARTITION	2	0.05
D31	D31	DWB_RTL_TRX	90505_H020	TABLE SUBPARTITION	2	0.05
D31	D31	DWB_RTL_TRX	90506_H049	TABLE SUBPARTITION	2	0.05

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	75138_1021	INDEX PARTITION	96	16.22
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	75138_1021	INDEX PARTITION	80	13.51
SYS	SYSAUX	WRI$_ADV_TASKS_PK		INDEX	80	13.51
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM	75138_1021	TABLE PARTITION	64	10.81
SYS	SYSAUX	WRH$_PARAMETER_PK	75138_1021	INDEX PARTITION	48	8.11

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSAUX	WRH$_SYSSTAT	75138_1021	TABLE PARTITION	671	33.70
SYS	SYSAUX	WRH$_SYSTEM_EVENT	75138_1021	TABLE PARTITION	324	16.27
SYS	SYSAUX	WRH$_INST_CACHE_TRANSFER	75138_1021	TABLE PARTITION	48	2.41
SYS	SYSAUX	WRH$_FILESTATXS	75138_1021	TABLE PARTITION	42	2.11
SYS	SYSAUX	WRH$_SQLSTAT	75138_1021	TABLE PARTITION	35	1.76

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 451
Captured Segments account for 55.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSAUX	WRH$_SYSTEM_EVENT	75138_1021	TABLE PARTITION	108	23.95
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	75138_1021	INDEX PARTITION	45	9.98
SYS	SYSAUX	WRM$_SNAPSHOT		TABLE	12	2.66
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM	75138_1021	TABLE PARTITION	10	2.22
SYS	SYSAUX	WRI$_ADV_ADDM_FDG		TABLE	9	2.00

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_database_links	10	0.00	0	1
dc_global_oids	86	0.00	0	271
dc_histogram_data	6	0.00	0	4,644
dc_histogram_defs	123	0.00	0	19,928
dc_object_grants	4,590	0.00	0	459
dc_objects	1,160	6.47	0	5,750
dc_profiles	4	0.00	0	1
dc_rollback_segments	2,414	0.00	0	1,055
dc_segments	57	0.00	0	4,076
dc_sequences	11	18.18	11	9
dc_tablespaces	4,683	0.00	0	88
dc_users	536	0.00	0	748
global database name	504	0.00	0	2
outstanding_alerts	35	94.29	0	10

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts
dc_awr_control	4	0
dc_objects	28	58
dc_sequences	22	0
outstanding_alerts	70	33

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	Invali- dations
BODY	10	0.00	36	0.00	0	0
INDEX	10	0.00	10	0.00	0	0
SQL AREA	551	1.81	3,137	1.75	5	5
TABLE/PROCEDURE	2,640	0.00	1,000	0.00	0	0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases	GES Inval Requests	GES Invali- dations
INDEX	10	10	0	0	0
TABLE/PROCEDURE	637	956	0	0	0

Back to Library Cache Statistics
Back to Top

Memory Statistics

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

Memory Dynamic Components

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

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	3,840.00	3,840.00	3,648.00	4,352.00	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	12,288.00	12,288.00	12,288.00	12,288.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	6,144.00	6,144.00	6,144.00	6,144.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	64.00	64.00	64.00	64.00	STA/
large pool	128.00	128.00	128.00	512.00	SHR/DEF
shared pool	1,920.00	1,920.00	1,408.00	1,920.00	GRO/DEF
streams pool	128.00	128.00	128.00	128.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	566.29		4.97	8.78	64	77	114	113
	Freeable	108.44	0.00	1.22	2.07	18		89	89
	PL/SQL	18.99	2.22	0.17	1.41	15	15	113	113
	SQL	10.67	7.61	0.12	0.89	8	444	89	18
E	Other	602.23		5.06	8.82	64	77	119	118
	Freeable	109.50	0.00	1.22	2.05	18		90	90
	PL/SQL	19.00	2.22	0.16	1.38	15	15	118	113
	SQL	11.04	7.97	0.12	0.87	8	444	94	18

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	4,026,531,840
Fixed Size	2,160,112
Redo Buffers	36,175,872
Variable Size	2,348,812,816

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	73.63	73.63	0.00
shared	CCursor	264.53	264.56	0.01
shared	KCL name table	48.00	48.00	0.00
shared	KGL handle	37.39	37.40	0.02
shared	KQR L PO	25.08	25.08	0.00
shared	PCursor	70.44	70.46	0.02
shared	PL/SQL DIANA	19.43	19.43	0.00
shared	db_block_hash_buckets	22.25	22.25	0.00
shared	free memory	429.06	428.80	-0.06
shared	gcs dynamic s	40.06	40.06	0.00
shared	gcs resources	85.98	85.98	0.00
shared	gcs shadows	57.32	57.32	0.00
shared	ges big msg buffers	22.03	22.03	0.00
shared	ges enqueues	19.33	19.33	0.00
shared	kglsim object batch	19.41	19.41	0.00
shared	sql area	425.20	425.40	0.05
streams	Sender info	6.48	6.48	0.00
streams	free memory	126.99	126.99	0.00
	buffer_cache	3,840.00	3,840.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

Streams processes ordered by CPU usage
CPU and I/O Time in micro seconds

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Slaves	2,000	0	0
QMON Coordinator	1,000	0	0

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

Rule Sets ordered by Evaluations

Ruleset Name	Evals	Fast Evals	SQL Execs	CPU Time	Elapsed Time
SYS.ALERT_QUE_R	0	0	0	0	0

Back to Streams Statistics
Back to Top

Persistent Queues

Persistent Queue statistics ordered by enqueue rate

Queue Schema and Name	Incoming Msg per second	Outgoing Msg per second	Expired Msg per second	Ready Msg per second
SYS.ALERT_QUE	0	0	0	0
SYS.AQ$_ALERT_QT_E	0	0	0	0
SYSMAN.MGMT_NOTIFY_Q	0	0	0	0
SYSMAN.MGMT_TASK_Q	0	0	0	0

Back to Streams Statistics
Back to Top

Persistent Subscribers

Persistent Subscribers Statistics ordered by enqueue rate

Subscriber Name	Incoming Msg per second	Outgoing Msg per second	Expired Msg per second
HAE_SUB	0	0	0
RSTHPDBS101_U_1831_DEMO1	0	0	0
RSTHPDBS102_U_1831_DEMO2	0	0	0
RSTHPDBS103_U_1831_DEMO3	0	0	0
RSTHPDBS104_U_1831_DEMO4	0	0	0
RSTHPDBS105_U_1831_DEMO5	0	0	0
RSTHPDBS106_U_1831_DEMO6	0	0	0
RSTHPDBS107_U_1831_DEMO7	0	0	0
RSTHPDBS108_U_1831_DEMO8	0	0	0

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_shadows	626,068	1,063,628	626068	626068

init.ora Parameters

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

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

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	566	3.32	14.15
acks for commit broadcast(logical)	588	3.45	14.70
broadcast msgs on commit(actual)	382	2.24	9.55
broadcast msgs on commit(logical)	385	2.26	9.63
broadcast msgs on commit(wasted)	20	0.12	0.50
broadcast on commit wait time(ms)	1	0.01	0.03
broadcast on commit waits	4	0.02	0.10
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	1	0.01	0.03
flow control messages sent	0	0.00	0.00
gcs assume cvt	2	0.01	0.05
gcs assume no cvt	195	1.14	4.88
gcs ast xid	0	0.00	0.00
gcs blocked converts	215	1.26	5.38
gcs blocked cr converts	240	1.41	6.00
gcs compatible basts	5	0.03	0.13
gcs compatible cr basts (global)	19	0.11	0.48
gcs compatible cr basts (local)	26	0.15	0.65
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	5	0.03	0.13
gcs dbwr write request msgs	1	0.01	0.03
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	2	0.01	0.05
gcs immediate (null) converts	3	0.02	0.08
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	0	0.00	0.00
gcs indirect ast	14	0.08	0.35
gcs indirect bidless ast	12	0.07	0.30
gcs indirect fg ast	11	0.06	0.28
gcs lms flush pi msgs	10	0.06	0.25
gcs lms write request msgs	4	0.02	0.10
gcs msgs process time(ms)	20	0.12	0.50
gcs msgs received	3,590	21.06	89.75
gcs new served by master	0	0.00	0.00
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	1	0.01	0.03
gcs pkey conflicts retry	0	0.00	0.00
gcs queued converts	3	0.02	0.08
gcs reader bypass N->Xw ping local	1	0.01	0.03
gcs reader bypass N->Xw ping remote	2	0.01	0.05
gcs reader bypass grant X on assume	3	0.02	0.08
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	18	0.11	0.45
gcs reader bypass grant immediate	17	0.10	0.43
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	37	0.22	0.93
gcs retry convert request	426	2.50	10.65
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	137	0.80	3.43
gcs side channel msgs logical	2,491	14.61	62.28
gcs stale cr	0	0.00	0.00
gcs undo cr	0	0.00	0.00
gcs write notification msgs	0	0.00	0.00
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	694	4.07	17.35
ges msgs received	15,499	90.92	387.48
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	72	0.42	1.80
implicit batch messages sent	371	2.18	9.28
lmd msg send time(ms)	2	0.01	0.05
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	1,229	7.21	30.73
messages queue sent actual	12,289	72.09	307.23
messages queue sent logical	13,056	76.59	326.40
messages received actual	17,464	102.44	436.60
messages received logical	19,089	111.97	477.23
messages sent directly	8,408	49.32	210.20
messages sent indirectly	4,914	28.83	122.85
messages sent not implicit batched	11,918	69.91	297.95
messages sent pbatched	14,004	82.15	350.10
msgs causing lmd to send msgs	5,242	30.75	131.05
msgs causing lms(s) to send msgs	465	2.73	11.63
msgs received queue time (ms)	315	1.85	7.88
msgs received queued	19,089	111.97	477.23
msgs sent queue time (ms)	106,620,756	625,429.71	2,665,518.90
msgs sent queue time on ksxp (ms)	6,079	35.66	151.98
msgs sent queued	12,689	74.43	317.23
msgs sent queued on ksxp	20,870	122.42	521.75
process batch messages received	11,003	64.54	275.08
process batch messages sent	11,094	65.08	277.35

Global CR Served Stats

Statistic	Total
CR Block Requests	158
CURRENT Block Requests	69
Data Block Requests	158
Undo Block Requests	0
TX Block Requests	22
Current Results	227
Private results	0
Zero Results	0
Disk Read Results	0
Fail Results	0
Fairness Down Converts	45
Fairness Clears	9
Free GC Elements	0
Flushes	7
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	4
Errors	0

Global CURRENT Served Stats

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

Statistic	Total	% <1ms	% <10ms	% <100ms
Pins	445	100.00	0.00	0.00
Flushes	11	63.64	27.27	9.09
Writes	5	20.00	20.00	60.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
2	data block	274	92.70	1.46	5.84	75	100.00	0.00	0.00
5	data block	247	91.50	8.10	0.40	75	100.00	0.00	0.00
8	data block	209	96.17	3.83	0.00	74	98.65	1.35	0.00
7	data block	183	94.54	5.46	0.00	76	98.68	1.32	0.00
3	data block	159	94.34	5.66	0.00	47	100.00	0.00	0.00
6	data block	185	94.59	5.41	0.00	20	100.00	0.00	0.00
4	data block	130	88.46	11.54	0.00	19	84.21	15.79	0.00
5	undo header	97	96.91	3.09	0.00	6	100.00	0.00	0.00
3	undo header	70	100.00	0.00	0.00	5	100.00	0.00	0.00
2	undo header	72	100.00	0.00	0.00	2	100.00	0.00	0.00
7	undo header	66	100.00	0.00	0.00	2	100.00	0.00	0.00
4	undo header	61	100.00	0.00	0.00	7	100.00	0.00	0.00
8	undo header	67	100.00	0.00	0.00	1	100.00	0.00	0.00
6	undo header	67	100.00	0.00	0.00	0
5	Others	20	100.00	0.00	0.00	7	100.00	0.00	0.00
7	Others	16	100.00	0.00	0.00	8	100.00	0.00	0.00
8	Others	16	100.00	0.00	0.00	7	100.00	0.00	0.00
2	Others	13	100.00	0.00	0.00	8	75.00	25.00	0.00
4	Others	13	100.00	0.00	0.00	4	100.00	0.00	0.00
3	Others	13	100.00	0.00	0.00	3	100.00	0.00	0.00
6	Others	6	100.00	0.00	0.00	0
5	undo block	1	100.00	0.00	0.00	0

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer Times (ms)

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

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy
		CR Avg Time (ms)				Current Avg Time (ms)
2	data block	3.37	0.59	1.05	48.05	0.32	0.32
5	data block	1.03	0.66	5.14	2.22	0.39	0.39
8	data block	1.75	0.68	28.68		0.28	0.28	0.14
7	data block	0.90	0.89	1.20		0.38	0.39	0.12
3	data block	0.93	0.55	7.33		0.43	0.43
6	data block	0.80	0.77	1.44		1.56	1.56
4	data block	0.55	0.47	1.17		0.76	0.23	3.59
5	undo header	1.33	0.89	15.18		0.14	0.14
3	undo header	0.78	0.78			0.43	0.43
2	undo header	0.49	0.49			0.18	0.18
4	undo header	0.56	0.56			0.29	0.29
8	undo header	0.25	0.25			0.15	0.15
7	undo header	0.52	0.52			0.20	0.20
6	undo header	0.75	0.75
5	others	0.28	0.28			0.20	0.20
7	others	0.23	0.23			0.22	0.22
8	others	0.31	0.31			0.30	0.30
2	others	0.26	0.26			0.21	0.22	0.18
4	others	0.18	0.18			0.15	0.15
3	others	0.26	0.26			0.28	0.28
6	others	0.23	0.23
5	undo block	0.13	0.13
3	undo block
7	undo block
4	undo block
8	undo block
6	undo block
2	undo block

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer (Immediate)

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

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
2	data block	0	254	38.58	61.42	75	24.00	76.00
5	data block	0	226	11.06	88.94	75	22.67	77.33
8	data block	0	201	6.97	93.03	73	17.81	82.19
7	data block	0	173	13.87	86.13	75	16.00	84.00
3	data block	0	150	32.00	68.00	47	51.06	48.94
6	data block	0	175	12.00	88.00	20	15.00	85.00
4	data block	0	115	20.87	79.13	16	25.00	75.00
5	undo header	0	94	100.00	0.00	6	100.00	0.00
3	undo header	0	70	100.00	0.00	5	100.00	0.00
2	undo header	0	72	100.00	0.00	2	100.00	0.00
4	undo header	0	61	100.00	0.00	7	100.00	0.00
8	undo header	0	67	100.00	0.00	1	100.00	0.00
7	undo header	0	66	100.00	0.00	2	100.00	0.00
6	undo header	0	67	100.00	0.00	0
5	others	0	20	10.00	90.00	7	42.86	57.14
7	others	0	16	0.00	100.00	8	0.00	100.00
8	others	0	16	6.25	93.75	7	0.00	100.00
2	others	0	13	7.69	92.31	6	0.00	100.00
4	others	0	13	53.85	46.15	4	50.00	50.00
3	others	0	13	30.77	69.23	3	0.00	100.00
6	others	0	6	0.00	100.00	0
5	undo block	0	1	100.00	0.00	0
3	undo block	0	0			0
7	undo block	0	0			0
4	undo block	0	0			0
8	undo block	0	0			0
6	undo block	0	0			0
2	undo block	0	0			0

Back to Global Cache Transfer Stats
Back to Top

Global Cache Times (Immediate)

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

Src Inst#	Block Class	Immed	2hop	3hop	Immed	2hop	3hop
		CR Avg Time (ms)			Current Avg Time (ms)
2	data block	0.59	0.54	0.62	0.32	0.15	0.38
5	data block	0.66	0.15	0.73	0.39	0.16	0.46
8	data block	0.68	0.22	0.71	0.28	0.16	0.30
7	data block	0.89	0.19	1.00	0.39	0.17	0.43
3	data block	0.55	0.42	0.61	0.43	0.31	0.55
6	data block	0.77	0.18	0.85	1.56	0.15	1.81
4	data block	0.47	0.18	0.54	0.23	0.16	0.25
5	undo header	0.89	0.89		0.14	0.14
3	undo header	0.78	0.78		0.43	0.43
2	undo header	0.49	0.49		0.18	0.18
4	undo header	0.56	0.56		0.29	0.29
8	undo header	0.25	0.25		0.15	0.15
7	undo header	0.52	0.52		0.20	0.20
6	undo header	0.75	0.75
5	others	0.28	0.23	0.29	0.20	0.14	0.25
7	others	0.23		0.23	0.22		0.22
8	others	0.31	0.70	0.29	0.30		0.30
2	others	0.26	0.15	0.27	0.22		0.22
4	others	0.18	0.14	0.23	0.15	0.12	0.19
3	others	0.26	0.16	0.31	0.28		0.28
6	others	0.23		0.23
5	undo block	0.13	0.13
3	undo block
7	undo block
4	undo block
8	undo block
6	undo block
2	undo block

Back to Global Cache Transfer Stats
Back to Top

Interconnect Stats

Interconnect Latency Stats
Interconnect Throughput by Client
Interconnect Device Stats

Interconnect Ping Latency Stats

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

Target Instance	500B Ping Count	Avg Latency 500B msg	Stddev 500B msg	8K Ping Count	Avg Latency 8K msg	Stddev 8K msg
1	7	13.49	20.01	7	13.48	20.01
2	7	7.00	12.13	7	6.96	12.15
3	7	6.96	12.12	7	6.96	12.11
4	7	13.30	20.05	7	13.34	20.03
5	7	13.31	20.04	7	13.34	20.02
6	7	6.89	12.11	7	6.92	12.09
7	7	13.26	20.06	8	6,261.61	10,818.76
8	7	6.88	12.12	7	6.90	12.11

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.11
Parallel Query	0.05	0.04
DB Locks	0.02	0.02
DB Streams	0.00	0.00
Other	0.02	0.01

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.109	NO	Oracle Cluster Repository	0.01	0	0	0	0	0.00	0	0	0	0

Back to Interconnect Stats
Back to Top

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	98.69	Soft Parse %:	98.87
Execute to Parse %:	22.47	Latch Hit %:	99.95
Parse CPU to Parse Elapsd %:	0.00	% Non-Parse CPU:	99.98

Buffer access - local cache %:	93.92
Buffer access - remote cache %:	6.08
Buffer access - disk %:	0.00

Avg global enqueue get time (ms):	2.9
Avg global cache cr block receive time (ms):	1.3
Avg global cache current block receive time (ms):	0.5
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	2.6
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 %:	2.5
Avg global cache current block flush time (ms):	2.7

Avg message sent queue time (ms):	8,402.6
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:	57.78
% of indirect sent messages:	33.77
% of flow controlled messages:	8.45