WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

CUBS 2121269038 cubs2 2 04-Feb-08 13:02 11.1.0.6.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
CUBS	2121269038	cubs2	2	04-Feb-08 13:02	11.1.0.6.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

rac2.colestock.test Linux IA (32-bit) 2 1 1 1.97

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
rac2.colestock.test	Linux IA (32-bit)	2	1	1	1.97

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 95 04-Feb-08 15:36:24 39 .9

End Snap: 96 04-Feb-08 15:47:42 40 1.0

Elapsed: 11.30 (mins)

DB Time: 0.43 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	95	04-Feb-08 15:36:24	39	.9
End Snap:	96	04-Feb-08 15:47:42	40	1.0
Elapsed:		11.30 (mins)
DB Time:		0.43 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 144M 144M Std Block Size: 8K

Shared Pool Size: 172M 172M Log Buffer: 6,140K

	Begin	End
Buffer Cache:	144M	144M	Std Block Size:	8K
Shared Pool Size:	172M	172M	Log Buffer:	6,140K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 0.0 0.8 0.00 0.00

DB CPU(s): 0.0 0.2 0.00 0.00

Redo size: 2,186.1 43,589.9

Logical reads: 39.6 789.2

Block changes: 6.9 137.5

Physical reads: 0.1 2.5

Physical writes: 0.8 15.1

User calls: 11.7 232.5

Parses: 12.0 238.4

Hard parses: 0.1 1.2

W/A MB processed: 33,743.9 672,828.2

Logons: 1.6 32.2

Executes: 9.5 189.8

Rollbacks: 0.0 0.4

Transactions: 0.1

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.0	0.8	0.00	0.00
DB CPU(s):	0.0	0.2	0.00	0.00
Redo size:	2,186.1	43,589.9
Logical reads:	39.6	789.2
Block changes:	6.9	137.5
Physical reads:	0.1	2.5
Physical writes:	0.8	15.1
User calls:	11.7	232.5
Parses:	12.0	238.4
Hard parses:	0.1	1.2
W/A MB processed:	33,743.9	672,828.2
Logons:	1.6	32.2
Executes:	9.5	189.8
Rollbacks:	0.0	0.4
Transactions:	0.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.07 Soft Parse %: 99.52

Execute to Parse %: -25.60 Latch Hit %: 100.00

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

Shared Pool Statistics

Begin End

Memory Usage %: 88.04 88.74

% SQL with executions>1: 89.33 87.55

% Memory for SQL w/exec>1: 90.55 82.10

	Begin	End
Memory Usage %:	88.04	88.74
% SQL with executions>1:	89.33	87.55
% Memory for SQL w/exec>1:	90.55	82.10

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
PX Deq: Slave Session Stats	139	12	88	47.94	Other
DB CPU		7		28.90
DFS lock handle	2	5	2531	19.82	Other
reliable message	103	1	12	4.88	Other
control file sequential read	884	0	0	1.60	System I/O

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

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

0.04 0.18 1.8 1.1 0.2 97.1

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.04	0.18	1.8	1.1	0.2	97.1

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

0.7 25.1 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 2,016.2 2,016.2

SGA use (MB): 336.0 336.0

PGA use (MB): 284.3 289.5

% Host Mem used for SGA+PGA: 30.77 30.77

	Begin	End
Host Mem (MB):	2,016.2	2,016.2
SGA use (MB):	336.0	336.0
PGA use (MB):	284.3	289.5
% Host Mem used for SGA+PGA:	30.77	30.77

RAC Statistics

Begin End

Number of Instances: 2 2

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 0.80 15.91

Global Cache blocks served: 0.74 14.82

GCS/GES messages received: 3.81 76.06

GCS/GES messages sent: 5.19 103.41

DBWR Fusion writes: 0.07 1.38

Estd Interconnect traffic (KB) 14.09

	Per Second	Per Transaction
Global Cache blocks received:	0.80	15.91
Global Cache blocks served:	0.74	14.82
GCS/GES messages received:	3.81	76.06
GCS/GES messages sent:	5.19	103.41
DBWR Fusion writes:	0.07	1.38
Estd Interconnect traffic (KB)	14.09

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

Buffer access - local cache %: 97.70

Buffer access - remote cache %: 2.02

Buffer access - disk %: 0.28

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 1.1

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

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

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

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

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

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

Global cache log flushes for current blocks served %: 0.0

Avg global cache current block flush time (ms):

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.6

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

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

% of indirect sent messages: 42.61

% of flow controlled messages: 6.01

Cluster Interconnect

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
eth1	192.168.2.102	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): 25.5s
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	11.13	43.56
DB CPU	7.38	28.90
connection management call elapsed time	1.30	5.09
PL/SQL execution elapsed time	1.21	4.74
parse time elapsed	0.56	2.19
hard parse elapsed time	0.23	0.88
sequence load elapsed time	0.01	0.05
hard parse (sharing criteria) elapsed time	0.00	0.01
repeated bind elapsed time	0.00	0.00
failed parse elapsed time	0.00	0.00
DB time	25.54
background elapsed time	14.89
background cpu time	2.49

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	3,932
IDLE_TIME	131,681
IOWAIT_TIME	297
SYS_TIME	1,475
USER_TIME	2,413
LOAD	0	0
PHYSICAL_MEMORY_BYTES	2,114,179,072
NUM_CPUS	2
NUM_CPU_CORES	1
NUM_CPU_SOCKETS	1
GLOBAL_RECEIVE_SIZE_MAX	16,777,216
GLOBAL_SEND_SIZE_MAX	16,777,216
TCP_RECEIVE_SIZE_DEFAULT	524,288
TCP_RECEIVE_SIZE_MAX	16,777,216
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	524,288
TCP_SEND_SIZE_MAX	16,777,216
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
04-Feb 15:36:24	0.04
04-Feb 15:47:42	0.18	2.90	1.78	1.09	0.22	97.10

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 111.2% of Total DB time 25.54 (s)
Total FG Wait Time: 21.03 (s) DB CPU time: 7.38 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Other	1,723	62	20	11	76.46
DB CPU			7		28.90
Cluster	726	0	1	1	2.78
System I/O	884	0	0	0	1.60
User I/O	71	0	0	3	0.71
Concurrency	193	0	0	1	0.70
Network	3,500	0	0	0	0.06
Configuration	18	6	0	0	0.03
Commit	1	0	0	1	0.00
Application	5	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
PX Deq: Slave Session Stats	139	31	12	88	4.09	47.94
DFS lock handle	2	0	5	2531	0.06	19.82
reliable message	103	1	1	12	3.03	4.88
control file sequential read	884	0	0	0	26.00	1.60
gc cr multi block request	44	0	0	8	1.29	1.32
PX Deq: Signal ACK EXT	19	0	0	14	0.56	1.04
IPC send completion sync	78	60	0	2	2.29	0.74
name-service call wait	2	0	0	71	0.06	0.56
PX Deq: Signal ACK RSG	36	50	0	3	1.06	0.41
enq: PS - contention	30	10	0	3	0.88	0.39
gc cr block 2-way	193	0	0	1	5.68	0.39
db file scattered read	8	0	0	11	0.24	0.35
gc current block 2-way	168	0	0	1	4.94	0.35
db file sequential read	51	0	0	2	1.50	0.34
gc current grant busy	160	0	0	1	4.71	0.33
PX Deq: reap credit	957	100	0	0	28.15	0.33
row cache lock	102	0	0	1	3.00	0.31
gc current multi block request	102	0	0	0	3.00	0.19
os thread startup	1	0	0	48	0.03	0.19
rdbms ipc reply	282	0	0	0	8.29	0.16
PX Deq Credit: Session Stats	29	0	0	1	0.85	0.13
gc current block busy	5	0	0	7	0.15	0.13
library cache pin	49	0	0	1	1.44	0.11
library cache lock	41	0	0	1	1.21	0.09
gc current grant 2-way	44	0	0	0	1.29	0.05
SQL*Net message to client	3,469	0	0	0	102.03	0.05
enq: WF - contention	14	0	0	1	0.41	0.03
enq: HW - contention	18	6	0	0	0.53	0.03
db file parallel read	3	0	0	1	0.09	0.02
gc cr grant 2-way	8	0	0	0	0.24	0.01
enq: FB - contention	4	0	0	1	0.12	0.01
SQL*Net more data from client	18	0	0	0	0.53	0.01
gc cr block busy	1	0	0	2	0.03	0.01
enq: AF - task serialization	2	0	0	1	0.06	0.01
SQL*Net message from client	3,466	0	3,331	961	101.94
PX Deq: Execution Msg	134	16	54	403	3.94
PX Deq: Join ACK	74	38	33	450	2.18
PX Deq: Parse Reply	69	33	0	4	2.03
PX Deq: Msg Fragment	65	9	0	3	1.91
PX Deq: Execute Reply	63	25	0	3	1.85
PX Deq Credit: send blkd	79	33	0	2	2.32

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
events in waitclass Other	8,554	94	8	1	251.59	53.89
control file sequential read	1,761	0	1	1	51.79	7.16
control file parallel write	226	0	1	3	6.65	4.12
os thread startup	12	0	0	26	0.35	2.09
log file parallel write	84	0	0	3	2.47	1.48
gc cr block 2-way	71	0	0	1	2.09	0.28
gc cr block busy	1	0	0	34	0.03	0.23
library cache pin	1	0	0	20	0.03	0.13
gc current block 2-way	19	0	0	1	0.56	0.07
row cache lock	2	0	0	1	0.06	0.01
rdbms ipc message	12,084	81	15,105	1250	355.41
DIAG idle wait	23,094	98	1,355	59	679.24
Streams AQ: waiting for time management or cleanup tasks	42	76	827	19684	1.24
Streams AQ: qmn coordinator idle wait	49	49	683	13934	1.44
PING	366	12	681	1860	10.76
pmon timer	386	59	678	1757	11.35
ges remote message	8,533	86	678	79	250.97
wait for unread message on broadcast channel	677	100	678	1001	19.91
gcs remote message	16,662	92	677	41	490.06
fbar timer	2	100	600	300007	0.06
smon timer	2	100	600	300007	0.06
Space Manager: slave idle wait	16	100	80	5000	0.47
KSV master wait	406	100	0	0	11.94

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
CGS wait for IPC msg	6015	100.0
DFS lock handle	22	95.5							4.5
IPC send completion sync	81	84.0	1.2	6.2		3.7	2.5	2.5
KJC: Wait for msg sends to complete	20	100.0
PX Deq Credit: Session Stats	29	93.1		3.4			3.4
PX Deq: Signal ACK EXT	21	52.4	4.8	4.8		19.0	4.8	14.3
PX Deq: Signal ACK RSG	38	81.6	2.6		5.3	2.6	7.9
PX Deq: Slave Session Stats	149	73.8	6.7	2.0	1.3	4.0	5.4	4.0	2.7
PX Deq: reap credit	1562	99.8				.1	.1
SQL*Net break/reset to client	5	100.0
SQL*Net message to client	4552	100.0
SQL*Net more data from client	19	94.7	5.3
SQL*Net more data to client	13	100.0
Streams AQ: qmn coordinator waiting for slave to start	1								100.0
control file parallel write	225		.4	98.7		.4	.4
control file sequential read	2645	99.4	.4	.2	.0
db file parallel read	3	33.3	66.7
db file scattered read	7		42.9	14.3			42.9
db file sequential read	45	91.1				6.7	2.2
direct path write	9	100.0
enq: AF - task serialization	2	100.0
enq: CF - contention	23	100.0
enq: CO - master slave det	226	92.5	2.7	2.2	2.2	.4
enq: DR - contention	1	100.0
enq: FB - contention	5	100.0
enq: HW - contention	15	100.0
enq: PS - contention	32	28.1	46.9	3.1	12.5	6.3	3.1
enq: TA - contention	2	100.0
enq: WF - contention	15	93.3	6.7
gc buffer busy release	1	100.0
gc cr block 2-way	259	99.6	.4
gc cr block busy	2		50.0					50.0
gc cr grant 2-way	6	100.0
gc cr multi block request	46	89.1						10.9
gc current block 2-way	188	98.9	1.1
gc current block busy	5		20.0	40.0		40.0
gc current grant 2-way	32	100.0
gc current grant busy	139	98.6	.7				.7
gc current multi block request	117	94.0	6.0
gcs log flush sync	20	65.0	30.0				5.0
ges inquiry response	378	88.1	7.1	1.9	2.1	.5		.3
ksxr poll remote instances	1775	100.0
latch free	5	100.0
library cache lock	40	97.5		2.5
library cache pin	49	93.9		2.0	2.0		2.0
library cache: mutex X	1	100.0
lock escalate retry	1	100.0
log file parallel write	81	53.1	29.6	8.6	1.2	2.5	4.9
log file sync	1	100.0
name-service call wait	3					33.3	33.3	33.3
os thread startup	13						92.3	7.7
rdbms ipc reply	573	100.0
reliable message	110	80.9	3.6	4.5	1.8	4.5	2.7	1.8
row cache lock	107	80.4	13.1	.9	1.9	.9	1.9	.9
wait for scn ack	57	96.5	1.8	1.8
DIAG idle wait	23K	.9	.1	.1	.2	.8	56.6	41.3
KSV master wait	406	100.0
PING	366	79.0	.3	1.1	.5	1.9	.5	.5	16.1
PX Deq Credit: send blkd	81	86.4	1.2	1.2	1.2	4.9	4.9
PX Deq: Execute Reply	67	71.6	3.0	4.5	7.5	7.5	6.0
PX Deq: Execution Msg	134	26.9	6.0	7.5	5.2	12.7	8.2	15.7	17.9
PX Deq: Join ACK	80	53.8		1.3	1.3	3.8	1.3	17.5	21.3
PX Deq: Msg Fragment	65	80.0	1.5	1.5	1.5	9.2	6.2
PX Deq: Parse Reply	74	75.7	2.7	4.1	1.4	8.1	5.4	2.7
PX Idle Wait	520				.2			1.3	98.5
SQL*Net message from client	6134	40.3	7.7	8.9	2.3	2.5	4.5	32.0	1.7
Space Manager: slave idle wait	136								100.0
Streams AQ: RAC qmn coordinator idle wait	50	100.0
Streams AQ: qmn coordinator idle wait	49	49.0							51.0
Streams AQ: qmn slave idle wait	28								100.0
Streams AQ: waiting for time management or cleanup tasks	42	21.4						38.1	40.5
class slave wait	6	83.3							16.7
cmon timer	7842	62.2	9.8	2.2	2.1	6.5	3.4	12.5	1.3
dispatcher timer	11								100.0
fbar timer	2								100.0
gcs remote message	16K	3.5	1.2	.8	.6	.7	1.1	92.0
ges remote message	8513	3.0	.8	2.4	.8	1.2	1.5	90.3
pmon timer	386	38.3	.3	.5	1.0	.5	.3	.5	58.5
pool server timer	1848	.4	1.2	.3	.3	.8	2.2	57.8	37.1
rdbms ipc message	12K	5.6	.8	.6	.5	.6	.7	65.7	25.5
smon timer	2								100.0
virtual circuit status	23								100.0
wait for unread message on broadcast channel	678							100.0

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Logical Reads (K)
SYS$USERS	18	3	9
SYS$BACKGROUND	6	0	3
cubs.colestock.test	2	5	14
cubsXDB	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	Concurcy Total Wts	Network Total Wts
SYS$USERS	71	193	330
SYS$BACKGROUND	0	22	0
cubs.colestock.test	0	0	3170

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): 26
Captured SQL account for 48.2% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
5	0	2	2.63	20.63	0v6s91manuhz8	emagent@rac2.colestock.test (TNS V1-V3)	/* OracleOEM */ S...
3	1	1	3.17	12.42	1uk5m5qbzj1vt	sqlplus@rac2.colestock.test (TNS V1-V3)	BEGIN dbms_workload_repository...
0	0	1	0.49	1.93	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	1	0.32	1.25	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	1	0.30	1.19	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
0	0	4	0.07	1.16	gawhngsp3cptg	sqlplus@rac2.colestock.test (TNS V1-V3)	select executions_total, sort...
0	0	1	0.29	1.12	bqnn4c3gjtmgu		insert into wrh$_bg_event_summ...
0	0	1,066	0.00	0.76	0k8522rmdzg4k		select privilege# from sysauth...
0	0	11	0.02	0.75	7frqszzdu8sgg	racgimon@rac2.colestock.test (TNS V1-V3)	select DECODE(UPPER(d.OPEN_MOD...
0	0	2,128	0.00	0.72	0h6b2sajwb74n		select privilege#, level from ...

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): 7
Captured SQL account for 56.0% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
1	3	1	1.39	18.79	12.42	1uk5m5qbzj1vt	sqlplus@rac2.colestock.test (TNS V1-V3)	BEGIN dbms_workload_repository...
0	0	1	0.49	6.58	1.93	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	1	0.28	3.81	1.12	bqnn4c3gjtmgu		insert into wrh$_bg_event_summ...
0	0	1,066	0.00	2.78	0.76	0k8522rmdzg4k		select privilege# from sysauth...
0	0	1	0.18	2.42	1.25	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	2,128	0.00	2.38	0.72	0h6b2sajwb74n		select privilege#, level from ...
0	0	1	0.17	2.25	0.67	8cb76kfva01mr	sqlplus@rac2.colestock.test (TNS V1-V3)	select executions from v$sql w...
0	0	1	0.11	1.52	0.44	g4906kr96ammw	sqlplus@rac2.colestock.test (TNS V1-V3)	select sql_id, executions fr...
0	0	1	0.11	1.50	0.43	amnhd8z01mk78	sqlplus@rac2.colestock.test (TNS V1-V3)	select executions from v$sql w...
0	0	1	0.11	1.45	0.43	6q5agjvdqxmun	sqlplus@rac2.colestock.test (TNS V1-V3)	select executions from v$sql w...
0	0	2	0.05	1.33	0.38	bg8xn87xfqpm9	emagent@rac2.colestock.test (TNS V1-V3)	/* OracleOEM */ SEL...
0	0	535	0.00	1.08	0.31	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
0	0	1	0.08	1.04	1.19	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...

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: 26,831
Captured SQL account for 74.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
6,392	1,066	6.00	23.82	0.20	0.20	0k8522rmdzg4k		select privilege# from sysauth...
4,256	2,128	2.00	15.86	0.18	0.18	0h6b2sajwb74n		select privilege#, level from ...
4,224	1	4,224.00	15.74	1.39	3.17	1uk5m5qbzj1vt	sqlplus@rac2.colestock.test (TNS V1-V3)	BEGIN dbms_workload_repository...
2,206	1	2,206.00	8.22	0.18	0.32	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
2,140	535	4.00	7.98	0.05	0.05	459f3z9u4fb3u		select value$ from props$ wher...
1,655	1	1,655.00	6.17	0.07	0.07	bzqc6shkya3s0	sqlplus@rac2.colestock.test (TNS V1-V3)	select table_name from dict wh...
1,605	535	3.00	5.98	0.06	0.05	5ur69atw3vfhj		select decode(failover_method,...
928	16	58.00	3.46	0.00	0.01	4cvqvs489pd6k		select min(next_date) from "SY...
460	136	3.38	1.71	0.01	0.05	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
408	136	3.00	1.52	0.02	0.09	6ssrk2dqj7jbx		select job, nvl2(last_date, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 86
Captured SQL account for 19.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
30	1	30.00	34.88	1.39	3.17	1uk5m5qbzj1vt	sqlplus@rac2.colestock.test (TNS V1-V3)	BEGIN dbms_workload_repository...
7	1	7.00	8.14	0.00	0.03	0z1031991bd7w		insert into wrh$_sysmetric_sum...
6	1	6.00	6.98	0.00	0.03	fnk7155mk2jq6		insert into wrh$_sysmetric_his...
2	136	0.01	2.33	0.01	0.05	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
2	1	2.00	2.33	0.18	0.32	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
1	1	1.00	1.16	0.02	0.03	84qubbrsr0kfn		insert into wrh$_latch (snap...
1	4	0.25	1.16	0.01	0.30	gawhngsp3cptg	sqlplus@rac2.colestock.test (TNS V1-V3)	select executions_total, sort...
0	1	0.00	0.00	0.00	0.00	05xcf43d9psvm	emagent@rac2.colestock.test (TNS V1-V3)	SELECT NVL(SUM(FAILURES), 0) ...
0	6	0.00	0.00	0.00	0.00	062savj8zgzut		UPDATE sys.wri$_adv_parameters...
0	2,128	0.00	0.00	0.18	0.18	0h6b2sajwb74n		select privilege#, level from ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 6,452
Captured SQL account for 91.5% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Text
2,128	0	0.00	0h6b2sajwb74n	select privilege#, level from ...
1,066	2,128	2.00	0k8522rmdzg4k	select privilege# from sysauth...
535	535	1.00	0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', ...
535	535	1.00	459f3z9u4fb3u	select value$ from props$ wher...
535	535	1.00	5ur69atw3vfhj	select decode(failover_method,...
529	529	1.00	1gy9qq7yjm054	select /+ result_cache / cou...
136	136	1.00	5h7w8ykwtb2xt	INSERT INTO SYS.WRI$_ADV_PARAM...
136	0	0.00	6ssrk2dqj7jbx	select job, nvl2(last_date, ...
69	1	0.01	96g93hntrzjtr	select /+ rule / bucket_cnt,...
16	16	1.00	4cvqvs489pd6k	select min(next_date) from "SY...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 8,104
Captured SQL account for 68.9% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
2,128	2,128	26.26	0h6b2sajwb74n	select privilege#, level from ...
1,066	1,066	13.15	0k8522rmdzg4k	select privilege# from sysauth...
535	535	6.60	0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', ...
535	535	6.60	459f3z9u4fb3u	select value$ from props$ wher...
535	535	6.60	5ur69atw3vfhj	select decode(failover_method,...
529	529	6.53	1gy9qq7yjm054	select /+ result_cache / cou...
16	16	0.20	4cvqvs489pd6k	select min(next_date) from "SY...
16	16	0.20	52kfqq6q4ntj5	select o.obj#, t.flags from t...
16	16	0.20	bkdusjx00dsmc	select i.obj#, i.ts#, i.file#,...
16	16	0.20	cgb6kp2umq52a	select t.schema, t.name, t.f...

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): 800,006
Captured SQL accounts for 3.13% of Total Cluster Wait Time

Cluster Wait Time (s)	%Ela	%Total	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Module	SQL Text
0.32	9.96	39.49	3.17	1.39	1	1uk5m5qbzj1vt	sqlplus@rac2.colestock.test (TNS V1-V3)	BEGIN dbms_workload_repository...
0.28	94.21	34.76	0.30	0.01	4	gawhngsp3cptg	sqlplus@rac2.colestock.test (TNS V1-V3)	select executions_total, sort...
0.10	32.07	12.82	0.32	0.18	1	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.07	73.91	8.27	0.09	0.02	136	6ssrk2dqj7jbx		select job, nvl2(last_date, ...
0.05	89.14	5.90	0.05	0.00	2	abbsy20x6ayv5	sqlplus@rac2.colestock.test (TNS V1-V3)	select executions_total, sort...
0.03	71.55	4.11	0.05	0.01	136	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
0.01	37.85	1.75	0.04	0.02	1	586b2udq6dbng		insert into wrh$_sysstat (sn...
0.01	43.53	1.72	0.03	0.02	1	84qubbrsr0kfn		insert into wrh$_latch (snap...
0.01	37.78	1.60	0.03	0.02	1	f0s0bk5k713yb		insert into wrh$_parameter (...
0.01	49.69	1.46	0.02	0.01	1	5ax5xu96u2ztd		insert into WRH$_EVENT_HISTOGR...
0.01	20.93	0.90	0.03	0.00	1	fnk7155mk2jq6		insert into wrh$_sysmetric_his...
0.01	30.58	0.65	0.02	0.01	1	cp3gpd7z878w8		insert into wrh$_sgastat (sn...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

05xcf43d9psvm SELECT NVL(SUM(FAILURES), 0) FROM SYS.DBA_QUEUE_SCHEDULES

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

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

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or 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')

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

1gy9qq7yjm054 select /*+ result_cache */ count(*) from scott.dept

1uk5m5qbzj1vt BEGIN dbms_workload_repository.create_snapshot; END;

459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'

4cvqvs489pd6k select min(next_date) from "SYS"."AQ$_ALERT_QT_T"

52kfqq6q4ntj5 select o.obj#, t.flags from tab$ t, obj$ o, user$ u where u.user# = :1 and u.user# = o.owner# and o.name = :2 and o.obj# = t.obj#

586b2udq6dbng insert into wrh$_sysstat (snap_id, dbid, instance_number, stat_id, value) select :snap_id, :dbid, :instance_number, stat_id, value from v$sysstat order by stat_id

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

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

5ur69atw3vfhj select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1

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

6q5agjvdqxmun select executions from v$sql where sql_fulltext like '%SCOTT%'

6ssrk2dqj7jbx 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

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

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

84qubbrsr0kfn insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash

8cb76kfva01mr select executions from v$sql where sql_fulltext like '%SCOTT.DEPT%'

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

abbsy20x6ayv5 select executions_total, sorts_total, disk_reads_total, cpu_time_total, iowait_total, optimizer_cost from dba_hist_sqlstat where sql_id='1gy9qq7yjm054'

amnhd8z01mk78 select executions from v$sql where sql_fulltext like '%dept%'

bg8xn87xfqpm9 /* OracleOEM */ SELECT /*+ ORDERED */ TO_CHAR(CAST(m.end_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD'), SUM(CASE WHEN a.internal_metric_name = 'logons' THEN m.value ELSE 0 END) logons, SUM(CASE WHEN a.internal_metric_name = 'opencursors' THEN m.value ELSE 0 END) opencursors, SUM(CASE WHEN a.internal_metric_name = 'user_limit' THEN m.value ELSE 0 END) user_limit, SUM(CASE WHEN a.internal_metric_name = 'process_usage' THEN m.value ELSE 0 END) process_usage, SUM(CASE WHEN a.internal_metric_name = 'session_usage' THEN m.value ELSE 0 END) session_usage FROM v$alert_types a, v$threshold_types t, v$sysmetric m WHERE a.internal_metric_category = 'Database_Resource_Usage' AND a.reason_id = t.alert_reason_id AND t.metrics_id = m.metric_id AND m.group_id = 2 AND :1 != 'BASIC' GROUP BY m.end_time ORDER BY m.end_time ASC

bkdusjx00dsmc select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, spare2, spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)) from ind$ i, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.bo#=:1 order by i.obj#

bqnn4c3gjtmgu insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select /*+ ordered use_nl(e) */ :snap_id, :dbid, :instance_number, e.event_id, sum(e.total_waits), sum(e.total_timeouts), sum(e.time_waited_micro) from v$session bgsids, v$session_event e where bgsids.type = 'BACKGROUND' and bgsids.sid = e.sid group by e.event_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

bzqc6shkya3s0 select table_name from dict where table_name like '%MONITOR%'

cgb6kp2umq52a select t.schema, t.name, t.flags, q.name, t.timezone from system.aq$_queue_tables t, system.aq$_queues q where t.objno = :1 and q.table_objno = t.objno and q.usage = 0 and NOT ( t.name in ('DEF$_AQCALL' , 'DEF$_AQERROR') and t.schema = 'SYSTEM')

cp3gpd7z878w8 insert into wrh$_sgastat (snap_id, dbid, instance_number, pool, name, bytes) select :snap_id, :dbid, :instance_number, pool, name, bytes from (select pool, name, bytes, 100*(bytes) / (sum(bytes) over (partition by pool)) part_pct from v$sgastat) where part_pct >= 1 or pool is null or name = 'free memory' order by name, pool

f0s0bk5k713yb insert into wrh$_parameter (snap_id, dbid, instance_number, parameter_hash, value, isdefault, ismodified) select :snap_id, :dbid, :instance_number, i.ksppihash hash, substr(sv.ksppstvl, 1, 512), sv.ksppstdf, decode(bitand(sv.ksppstvf, 7), 1, 'MODIFIED', 'FALSE') from x$ksppi i, x$ksppsv sv where i.indx = sv.indx and (((i.ksppinm not like '#_%' escape '#') or (sv.ksppstdf = 'FALSE') or (bitand(sv.ksppstvf, 5) > 0)) or (i.ksppinm like '#_#_%' escape '#')) order by hash

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

g4906kr96ammw select sql_id, executions from v$sql where sql_fulltext like '%dept%'

gawhngsp3cptg select executions_total, sorts_total, disk_reads_total, cpu_time_total, iowait_total from dba_hist_sqlstat where sql_id='1gy9qq7yjm054'

SQL Id	SQL Text
05xcf43d9psvm	SELECT NVL(SUM(FAILURES), 0) FROM SYS.DBA_QUEUE_SCHEDULES
062savj8zgzut	UPDATE sys.wri$_adv_parameters SET datatype = :1, value = :2, flags = :3, description = :4 WHERE task_id = :5 AND name = :6
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or 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')
0z1031991bd7w	insert into wrh$_sysmetric_summary (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, num_interval, maxval, minval, average, standard_deviation, sum_squares) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, numintv, max, min, avg, std, sumsq FROM x$kewmsmdv WHERE groupid = 2
1gy9qq7yjm054	select /+ result_cache / count(*) from scott.dept
1uk5m5qbzj1vt	BEGIN dbms_workload_repository.create_snapshot; END;
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4cvqvs489pd6k	select min(next_date) from "SYS"."AQ$_ALERT_QT_T"
52kfqq6q4ntj5	select o.obj#, t.flags from tab$ t, obj$ o, user$ u where u.user# = :1 and u.user# = o.owner# and o.name = :2 and o.obj# = t.obj#
586b2udq6dbng	insert into wrh$_sysstat (snap_id, dbid, instance_number, stat_id, value) select :snap_id, :dbid, :instance_number, stat_id, value from v$sysstat order by stat_id
5ax5xu96u2ztd	insert into WRH$_EVENT_HISTOGRAM (snap_id, dbid, instance_number, event_id, wait_time_milli, wait_count) select :snap_id, :dbid, :instance_number, d.ksledhash, s.kslsesmaxdur, s.kslsesval from x$kslseshist s, x$ksled d where s.kslsesenum = d.indx and s.kslsesval > 0 order by d.ksledhash, s.kslsesmaxdur
5h7w8ykwtb2xt	INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6q5agjvdqxmun	select executions from v$sql where sql_fulltext like '%SCOTT%'
6ssrk2dqj7jbx	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
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
7vgmvmy8vvb9s	insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)
84qubbrsr0kfn	insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
8cb76kfva01mr	select executions from v$sql where sql_fulltext like '%SCOTT.DEPT%'
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
abbsy20x6ayv5	select executions_total, sorts_total, disk_reads_total, cpu_time_total, iowait_total, optimizer_cost from dba_hist_sqlstat where sql_id='1gy9qq7yjm054'
amnhd8z01mk78	select executions from v$sql where sql_fulltext like '%dept%'
bg8xn87xfqpm9	/* OracleOEM / SELECT /+ ORDERED */ TO_CHAR(CAST(m.end_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD'), SUM(CASE WHEN a.internal_metric_name = 'logons' THEN m.value ELSE 0 END) logons, SUM(CASE WHEN a.internal_metric_name = 'opencursors' THEN m.value ELSE 0 END) opencursors, SUM(CASE WHEN a.internal_metric_name = 'user_limit' THEN m.value ELSE 0 END) user_limit, SUM(CASE WHEN a.internal_metric_name = 'process_usage' THEN m.value ELSE 0 END) process_usage, SUM(CASE WHEN a.internal_metric_name = 'session_usage' THEN m.value ELSE 0 END) session_usage FROM v$alert_types a, v$threshold_types t, v$sysmetric m WHERE a.internal_metric_category = 'Database_Resource_Usage' AND a.reason_id = t.alert_reason_id AND t.metrics_id = m.metric_id AND m.group_id = 2 AND :1 != 'BASIC' GROUP BY m.end_time ORDER BY m.end_time ASC
bkdusjx00dsmc	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, spare2, spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)) from ind$ i, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.bo#=:1 order by i.obj#
bqnn4c3gjtmgu	insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select /+ ordered use_nl(e) / :snap_id, :dbid, :instance_number, e.event_id, sum(e.total_waits), sum(e.total_timeouts), sum(e.time_waited_micro) from v$session bgsids, v$session_event e where bgsids.type = 'BACKGROUND' and bgsids.sid = e.sid group by e.event_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
bzqc6shkya3s0	select table_name from dict where table_name like '%MONITOR%'
cgb6kp2umq52a	select t.schema, t.name, t.flags, q.name, t.timezone from system.aq$_queue_tables t, system.aq$_queues q where t.objno = :1 and q.table_objno = t.objno and q.usage = 0 and NOT ( t.name in ('DEF$_AQCALL' , 'DEF$_AQERROR') and t.schema = 'SYSTEM')
cp3gpd7z878w8	insert into wrh$_sgastat (snap_id, dbid, instance_number, pool, name, bytes) select :snap_id, :dbid, :instance_number, pool, name, bytes from (select pool, name, bytes, 100*(bytes) / (sum(bytes) over (partition by pool)) part_pct from v$sgastat) where part_pct >= 1 or pool is null or name = 'free memory' order by name, pool
f0s0bk5k713yb	insert into wrh$_parameter (snap_id, dbid, instance_number, parameter_hash, value, isdefault, ismodified) select :snap_id, :dbid, :instance_number, i.ksppihash hash, substr(sv.ksppstvl, 1, 512), sv.ksppstdf, decode(bitand(sv.ksppstvf, 7), 1, 'MODIFIED', 'FALSE') from x$ksppi i, x$ksppsv sv where i.indx = sv.indx and (((i.ksppinm not like '#_%' escape '#') or (sv.ksppstdf = 'FALSE') or (bitand(sv.ksppstvf, 5) > 0)) or (i.ksppinm like '#_#_%' escape '#')) order by hash
fnk7155mk2jq6	insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv order by groupid, metricid, begtime
g4906kr96ammw	select sql_id, executions from v$sql where sql_fulltext like '%dept%'
gawhngsp3cptg	select executions_total, sorts_total, disk_reads_total, cpu_time_total, iowait_total from dba_hist_sqlstat where sql_id='1gy9qq7yjm054'

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	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	507	0.75	14.91
CPU used when call started	472	0.70	13.88
CR blocks created	3	0.00	0.09
DB time	4,763	7.03	140.09
DBWR checkpoint buffers written	454	0.67	13.35
DBWR fusion writes	47	0.07	1.38
DBWR transaction table writes	19	0.03	0.56
DBWR undo block writes	108	0.16	3.18
DFO trees parallelized	25	0.04	0.74
Effective IO time	0	0.00	0.00
HSC Heap Segment Block Changes	845	1.25	24.85
Heap Segment Array Inserts	89	0.13	2.62
Heap Segment Array Updates	9	0.01	0.26
Number of read IOs issued	0	0.00	0.00
PX local messages recv'd	149	0.22	4.38
PX local messages sent	149	0.22	4.38
PX remote messages recv'd	64	0.09	1.88
PX remote messages sent	112	0.17	3.29
Parallel operations not downgraded	25	0.04	0.74
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	3,473	5.12	102.15
active txn count during cleanout	53	0.08	1.56
application wait time	0	0.00	0.00
background timeouts	3,742	5.52	110.06
buffer is not pinned count	8,872	13.09	260.94
buffer is pinned count	1,274	1.88	37.47
bytes received via SQL*Net from client	867,089	1,279.02	25,502.62
bytes sent via SQL*Net to client	940,910	1,387.91	27,673.82
calls to get snapshot scn: kcmgss	9,637	14.22	283.44
calls to kcmgas	549	0.81	16.15
calls to kcmgcs	290	0.43	8.53
calls to kcmgrs	4,638	6.84	136.41
change write time	2	0.00	0.06
cleanout - number of ktugct calls	109	0.16	3.21
cleanouts and rollbacks - consistent read gets	3	0.00	0.09
cleanouts only - consistent read gets	6	0.01	0.18
cluster key scan block gets	67	0.10	1.97
cluster key scans	61	0.09	1.79
cluster wait time	79	0.12	2.32
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: block lost	16	0.02	0.47
commit cleanout failures: callback failure	3	0.00	0.09
commit cleanouts	344	0.51	10.12
commit cleanouts successfully completed	325	0.48	9.56
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	76	0.11	2.24
concurrency wait time	59	0.09	1.74
consistent changes	18	0.03	0.53
consistent gets	22,562	33.28	663.59
consistent gets - examination	4,722	6.97	138.88
consistent gets direct	10	0.01	0.29
consistent gets from cache	22,552	33.27	663.29
consistent gets from cache (fastpath)	17,271	25.48	507.97
cursor authentications	23	0.03	0.68
data blocks consistent reads - undo records applied	3	0.00	0.09
db block changes	4,675	6.90	137.50
db block gets	4,269	6.30	125.56
db block gets direct	10	0.01	0.29
db block gets from cache	4,259	6.28	125.26
db block gets from cache (fastpath)	1,283	1.89	37.74
deferred (CURRENT) block cleanout applications	274	0.40	8.06
dirty buffers inspected	1	0.00	0.03
enqueue conversions	240	0.35	7.06
enqueue releases	8,502	12.54	250.06
enqueue requests	8,733	12.88	256.85
enqueue timeouts	230	0.34	6.76
enqueue waits	323	0.48	9.50
execute count	6,452	9.52	189.76
free buffer inspected	659	0.97	19.38
free buffer requested	1,176	1.73	34.59
gc CPU used by this session	35	0.05	1.03
gc cr block build time	0	0.00	0.00
gc cr block flush time	6	0.01	0.18
gc cr block receive time	20	0.03	0.59
gc cr block send time	1	0.00	0.03
gc cr blocks received	283	0.42	8.32
gc cr blocks served	280	0.41	8.24
gc current block flush time	0	0.00	0.00
gc current block pin time	0	0.00	0.00
gc current block receive time	21	0.03	0.62
gc current block send time	2	0.00	0.06
gc current blocks received	258	0.38	7.59
gc current blocks served	224	0.33	6.59
gc local grants	68	0.10	2.00
gc remote grants	287	0.42	8.44
gcs messages sent	2,404	3.55	70.71
ges messages sent	1,112	1.64	32.71
global enqueue get time	1,087	1.60	31.97
global enqueue gets async	114	0.17	3.35
global enqueue gets sync	9,766	14.41	287.24
global enqueue releases	9,384	13.84	276.00
heap block compress	26	0.04	0.76
hot buffers moved to head of LRU	14	0.02	0.41
immediate (CR) block cleanout applications	9	0.01	0.26
immediate (CURRENT) block cleanout applications	79	0.12	2.32
index crx upgrade (positioned)	34	0.05	1.00
index fast full scans (full)	2	0.00	0.06
index fetch by key	736	1.09	21.65
index scans kdiixs1	4,849	7.15	142.62
leaf node 90-10 splits	11	0.02	0.32
leaf node splits	16	0.02	0.47
lob reads	0	0.00	0.00
lob writes	34	0.05	1.00
lob writes unaligned	34	0.05	1.00
logons cumulative	1,095	1.62	32.21
messages received	1,254	1.85	36.88
messages sent	984	1.45	28.94
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	14,408	21.25	423.76
opened cursors cumulative	8,375	12.35	246.32
parse count (failures)	2	0.00	0.06
parse count (hard)	39	0.06	1.15
parse count (total)	8,104	11.95	238.35
parse time cpu	52	0.08	1.53
parse time elapsed	57	0.08	1.68
physical read IO requests	51	0.08	1.50
physical read bytes	704,512	1,039.20	20,720.94
physical read total IO requests	2,724	4.02	80.12
physical read total bytes	44,269,568	65,300.70	1,302,046.12
physical read total multi block requests	0	0.00	0.00
physical reads	86	0.13	2.53
physical reads cache	76	0.11	2.24
physical reads cache prefetch	45	0.07	1.32
physical reads direct	10	0.01	0.29
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	45	0.07	1.32
physical write IO requests	357	0.53	10.50
physical write bytes	4,194,304	6,186.89	123,361.88
physical write total IO requests	1,431	2.11	42.09
physical write total bytes	22,191,104	32,733.43	652,679.53
physical write total multi block requests	8	0.01	0.24
physical writes	512	0.76	15.06
physical writes direct	10	0.01	0.29
physical writes direct (lob)	10	0.01	0.29
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	502	0.74	14.76
physical writes non checkpoint	299	0.44	8.79
pinned buffers inspected	2	0.00	0.06
process last non-idle time	6,658	9.82	195.82
queries parallelized	23	0.03	0.68
recursive calls	51,159	75.46	1,504.68
recursive cpu usage	274	0.40	8.06
redo blocks checksummed by FG (exclusive)	1,123	1.66	33.03
redo blocks written	3,111	4.59	91.50
redo blocks written for direct writes	82,280	121.37	2,420.00
redo entries	2,984	4.40	87.76
redo ordering marks	67	0.10	1.97
redo size	1,482,056	2,186.14	43,589.88
redo subscn max counts	76	0.11	2.24
redo synch time	0	0.00	0.00
redo synch writes	10	0.01	0.29
redo wastage	21,188	31.25	623.18
redo write time	27	0.04	0.79
redo writer latching time	0	0.00	0.00
redo writes	84	0.12	2.47
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	0	0.00	0.00
rows fetched via callback	469	0.69	13.79
session connect time	0	0.00	0.00
session cursor cache hits	1,457	2.15	42.85
session logical reads	26,831	39.58	789.15
shared hash latch upgrades - no wait	225	0.33	6.62
sorts (memory)	4,738	6.99	139.35
sorts (rows)	12,909	19.04	379.68
sql area evicted	0	0.00	0.00
sql area purged	2	0.00	0.06
summed dirty queue length	1	0.00	0.03
switch current to new buffer	23	0.03	0.68
table fetch by rowid	1,230	1.81	36.18
table fetch continued row	0	0.00	0.00
table scan blocks gotten	2,496	3.68	73.41
table scan rows gotten	112,033	165.26	3,295.09
table scans (long tables)	0	0.00	0.00
table scans (short tables)	1,331	1.96	39.15
total number of times SMON posted	0	0.00	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	0	0.00	0.00
undo change vector size	399,608	589.45	11,753.18
user I/O wait time	17	0.03	0.50
user calls	7,904	11.66	232.47
user commits	21	0.03	0.62
user rollbacks	13	0.02	0.38
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	369	0.54	10.85

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 pga memory max	1,184,160,236	1,257,144,960
session cursor cache count	20,592	26,450
session uga memory	166,082,800	210,032,892
opened cursors current	36	38
logons current	39	40
session uga memory max	1,037,251,768	1,299,077,716
session pga memory	378,012,772	398,568,696

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 Rd(ms)	Av Blks/Rd	Writes
SYSAUX	55	2.91	1.64	290
UNDOTBS2	2	5.00	1.00	43
SYSTEM	0	0.00	0.00	24

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes
SYSAUX	/u02/app/oradata/cubs/sysaux01.dbf	55	2.91	1.64	290
SYSTEM	/u02/app/oradata/cubs/system01.dbf	0			24
UNDOTBS2	/u02/app/oradata/cubs/undotbs02.dbf	2	5.00	1.00	43

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	17,424	100	26,669	79	502	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	280	1051	1106	92160	1106
E	0	0	189	330	4402	92160	4402

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	12	0.08	1,452	1.75	20,230
D	24	0.17	2,904	1.42	16,349
D	36	0.25	4,356	1.20	13,903
D	48	0.33	5,808	1.11	12,838
D	60	0.42	7,260	1.08	12,508
D	72	0.50	8,712	1.05	12,129
D	84	0.58	10,164	1.01	11,661
D	96	0.67	11,616	1.01	11,608
D	108	0.75	13,068	1.00	11,568
D	120	0.83	14,520	1.00	11,550
D	132	0.92	15,972	1.00	11,550
D	144	1.00	17,424	1.00	11,550
D	156	1.08	18,876	1.00	11,550
D	168	1.17	20,328	1.00	11,550
D	180	1.25	21,780	1.00	11,550
D	192	1.33	23,232	1.00	11,550
D	204	1.42	24,684	1.00	11,550
D	216	1.50	26,136	1.00	11,550
D	228	1.58	27,588	1.00	11,550
D	240	1.67	29,040	0.56	6,497

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	22	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	116	7	284.31	0.32	0.11	100.00	0.00	23,756
E	116	7	289.55	0.00	0.00	0.00	0.00	23,756

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	336	336
64K	128K	6	6
512K	1024K	27	27

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
15	0.13	835.79	73.89	92.00	15	5,556
29	0.25	835.79	73.89	92.00	15	5,556
58	0.50	835.79	73.89	92.00	15	5,556
87	0.75	835.79	73.89	92.00	15	5,556
116	1.00	835.79	3.06	100.00	14	5,123
139	1.20	835.79	3.06	100.00	8	5,123
162	1.40	835.79	0.00	100.00	0	5,104
186	1.60	835.79	0.00	100.00	0	5,104
209	1.80	835.79	0.00	100.00	0	5,104
232	2.00	835.79	0.00	100.00	0	5,104
348	3.00	835.79	0.00	100.00	0	5,104
464	4.00	835.79	0.00	100.00	0	5,104
696	6.00	835.79	0.00	100.00	0	5,104
928	8.00	835.79	0.00	100.00	0	5,104

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)
112	0.65	9	786	3,974	0.99	76	2.24	35
132	0.77	29	2,548	3,993	0.99	57	1.68	79
152	0.88	47	4,550	4,016	1.00	34	1.00	79
172	1.00	57	5,804	4,016	1.00	34	1.00	79
192	1.12	57	5,804	4,016	1.00	34	1.00	79
212	1.23	57	5,804	4,016	1.00	34	1.00	79
232	1.35	57	5,804	4,016	1.00	34	1.00	79
252	1.47	57	5,804	4,016	1.00	34	1.00	79
272	1.58	57	5,804	4,016	1.00	34	1.00	79
292	1.70	57	5,804	4,016	1.00	34	1.00	79
312	1.81	57	5,804	4,016	1.00	34	1.00	79
332	1.93	57	5,804	4,016	1.00	34	1.00	79
352	2.05	57	5,804	4,016	1.00	34	1.00	79

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
168	0.50	265	20,189
252	0.75	230	12,493
336	1.00	229	11,536
420	1.25	220	6,483
504	1.50	220	6,483
588	1.75	220	6,483
672	2.00	220	6,483

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)
4	1.00	0	0	0	0
8	2.00	0	0	0	0
12	3.00	0	0	0	0
16	4.00	0	0	0	0
20	5.00	0	0	0	0
24	6.00	0	0	0	0
28	7.00	0	0	0	0
32	8.00	0	0	0	0
36	9.00	0	0	0	0
40	10.00	0	0	0	0
44	11.00	0	0	0	0
48	12.00	0	0	0	0
52	13.00	0	0	0	0
56	14.00	0	0	0	0
60	15.00	0	0	0	0
64	16.00	0	0	0	0
68	17.00	0	0	0	0
72	18.00	0	0	0	0
76	19.00	0	0	0	0
80	20.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	Av Wt Time(ms)
CO-KTUCLO Master Slave enq (master slave det)	225	0	225	225	0.80
PS-PX Process Reservation	180	176	4	32	2.81
CF-Controlfile Transaction	1,524	1,524	0	23	0.87
HW-Segment High Water Mark	47	47	0	18	0.56
DR-Distributed Recovery	1	1	0	1	10.00
WF-AWR Flush	21	21	0	15	0.00
FB-Format Block	6	6	0	4	0.00
AF-Advisor Framework (task serialization)	13	13	0	2	0.00
TA-Instance Undo	2	2	0	2	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

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

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
04-Feb 15:44	83	96	903	3	29	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
ASM db client latch	454	0.00		0
ASM map operation hash table	1	0.00		0
AWR Alerted Metric Element list	4,421	0.00		0
Change Notification Hash table latch	225	0.00		0
Consistent RBA	84	0.00		0
DML lock allocation	21,702	0.00		0
Event Group Locks	18	0.00		0
FAL request queue	17	0.00		0
FAL subheap alocation	17	0.00		0
FOB s.o list latch	4	0.00		0
File State Object Pool Parent Latch	1	0.00		0
IPC stats buffer allocation latch	96	0.00		102	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	1	0.00		0
JS broadcast add buf latch	155	0.00		0
JS broadcast drop buf latch	155	0.00		0
JS broadcast load blnc latch	136	0.00		0
JS mem alloc latch	1	0.00		0
JS queue access latch	2	0.00		0
JS queue state obj latch	4,896	0.00		0
JS slv state obj latch	1	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KFR redo allocation latch	1	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	445	0.00		95	0.00
KJCT flow control latch	5,032	0.00		0
KMG MMAN ready and startup request latch	226	0.00		0
KSXR large replies	2	0.00		0
KTF sga latch	6	0.00		209	0.00
KWQMN job cache list latch	128	0.78	1.00	0
KWQP Prop Status	2	0.00		0
KWQS pqsubs latch	9	0.00		0
KWQS pqueue ctx latch	5	0.00		0
Locator state objects pool parent latch	1	0.00		0
MQL Tracking Latch	0			13	0.00
Memory Management Latch	1	0.00		226	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	1,290	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	124	0.00		0
OS process allocation	309	0.00		0
OS process: request allocation	31	0.00		0
PL/SQL warning settings	1,119	0.00		0
QMT	1	0.00		0
Result Cache: Latch	1,587	0.00		0
Result Cache: SO Latch	1,058	0.00		0
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	96	2.08	1.00	226	0.00
SQL memory manager workarea list latch	21,706	0.00		0
Shared B-Tree	46	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	679	0.00		0
active service list	10,151	0.00		384	0.00
archive control	32	0.00		0
archive process latch	260	0.00		0
begin backup scn array	9	0.00		0
buffer pool	1	0.00		0
business card	51	0.00		0
cache buffer handles	52	0.00		0
cache buffers chains	44,304	0.00		2,203	0.00
cache buffers lru chain	3,880	0.00		1,366	0.00
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	35	0.00		0
channel operations parent latch	106,951	0.00		0
checkpoint queue latch	8,438	0.00		539	0.00
client/application info	7,075	0.00		0
commit callback allocation	3	0.00		0
compile environment latch	1,096	0.00		0
connection pool sga data lock	2,733	0.00		0
cp cmon array latch	384	0.00		0
cp cmon/server latch	8,102	0.00		0
cp cso latch	1,058	0.00		0
cp pool latch	18	0.00		0
cp server array latch	19	0.00		0
cp server hash latch	8,055	0.00		0
cp sga latch	162	0.00		0
cv apply list lock	1	0.00		0
cv free list lock	1	0.00		0
deferred cleanup latch	162	0.00		0
dml lock allocation	162	0.00		0
done queue latch	1	0.00		0
dummy allocation	2,192	0.00		0
enqueue hash chains	21,041	0.00	0.00	2	0.00
enqueues	16,675	0.01	0.00	0
error message lists	121	0.00		0
fifth spare latch	1	0.00		0
file cache latch	58	0.00		0
flashback archiver latch	2	0.00		0
flashback copy	1	0.00		0
gc element	6,909	0.00		3	0.00
gcs commit scn state	1	0.00		0
gcs opaque info freelist	2	0.00		0
gcs partitioned table hash	1,841,534	0.00		0
gcs pcm hashed value bucket hash	1	0.00		0
gcs remastering latch	7	0.00		0
gcs resource freelist	1	0.00		0
gcs resource hash	4,896	0.00		0
gcs resource scan list	1	0.00		0
gcs shadows freelist	2	0.00		1	0.00
ges caches resource lists	1,641	0.00		6,578	0.00
ges deadlock list	182	0.00		0
ges domain table	18,708	0.00		0
ges enqueue table freelist	19,483	0.01	0.00	0
ges group table	27,550	0.00		0
ges process hash list	31,321	0.00		0
ges process parent latch	39,111	0.00		0
ges process table freelist	31	0.00		0
ges resource hash list	31,348	0.03	0.00	257	0.00
ges resource scan list	9	0.00		0
ges resource table freelist	537	0.00		0
ges timeout list	182	0.00		70	0.00
ges value block free list	1	0.00		0
global KZLD latch for mem in SGA	533	0.00		0
global tx hash mapping	1	0.00		0
granule operation	1	0.00		0
hash table column usage latch	0			1,078	0.00
hash table modification latch	48	0.00		0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	1	0.00		0
job_queue_processes parameter latch	11	0.00		0
k2q global data latch	452	0.00		0
k2q lock allocation	1	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kks stats	74	0.00		0
kokc descriptor allocation latch	2	0.00		0
kpplsSyncStateListSga: lock	1,587	0.00		0
ksfv messages	1	0.00		0
ksim membership request latch	88	0.00		560	0.00
kss move lock	11	0.00		0
ksuosstats global area	48	0.00		0
ksv allocation latch	182	0.00		0
ksv class latch	835	0.00		0
ksv msg queue latch	1	0.00		0
ksxp shared latch	31	0.00		0
ksz_so allocation latch	31	0.00		0
ktm global data	3	0.00		0
kwqbsn:qsga	28	0.00		0
lgwr LWN SCN	271	0.00		0
library cache load lock	50	0.00		0
list of block allocation	19	0.00		0
loader state object freelist	52	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	3	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	2	0.00		0
logminer work area	1	0.00		0
longop free list parent	1	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	1,096	0.00		0
messages	27,510	0.01	0.00	0
mostly latch-free SCN	271	0.00		0
msg queue latch	1	0.00		0
multiblock read objects	342	0.00		0
name-service memory objects	737	0.00		0
name-service namespace bucket	6,672	0.00		0
name-service pending queue	284	0.00		0
name-service request	6	0.00		0
name-service request queue	6,549	0.00		0
ncodef allocation latch	162	0.00		0
object queue header heap	717	0.00		31	0.00
object queue header operation	5,320	0.00		0
object stats modification	59	0.00		0
parallel query alloc buffer	613	0.00		0
parallel query stats	102	0.00		0
parallel txn reco latch	80	0.00		0
parameter list	700	0.00		0
parameter table management	2,720	0.00		0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
pesom_heap_alloc	1	0.00		0
post/wait queue	34	0.00		27	0.00
process allocation	6,186	0.00		17	0.00
process group creation	31	0.00		0
process queue	284	0.00		0
process queue reference	7,378	0.00		678	0.00
qmn state object latch	2	0.00		0
qmn task context latch	1	0.00		0
qmn task queue latch	107	1.87	1.00	0
query server freelists	231	0.00		0
query server process	1	0.00		1	0.00
queued dump request	2	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	627	0.00		2,992	0.00
redo copy	1	0.00		2,992	0.00
redo writing	1,408	0.00		0
resmgr group change latch	1,112	0.00		0
resmgr:active threads	2,192	0.00		0
resmgr:actses change group	1,096	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	2,191	0.00		0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	1	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	46,523	0.00	0.00	0
rules engine aggregate statistics	1	0.00		0
rules engine rule set statistics	102	0.00		0
second spare latch	1	0.00		0
sequence cache	3,236	0.00		0
session allocation	7,646	0.01	0.00	0
session idle bit	16,999	0.00		0
session queue latch	1	0.00		0
session state list latch	68	0.00		0
session switching	163	0.00		0
session timer	377	0.00		0
shared pool	60,326	0.01	0.00	0
shared pool sim alloc	2	0.00		0
shared pool simulator	16,068	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	776	0.00		0
simulator lru latch	683	0.00		71	0.00
sort extent pool	174	0.00		0
space background state object latch	2	0.00		0
space background task latch	501	0.00		452	0.00
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	1	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
third spare latch	1	0.00		0
threshold alerts latch	26	0.00		0
trace latch	1	0.00		0
transaction allocation	4,786	0.00		0
transaction branch allocation	377	0.00		0
undo global data	498	0.00		0
user lock	2,400	0.00		0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps
SQL memory manager latch	96	2	2
qmn task queue latch	107	2	2
KWQMN job cache list latch	128	1	1

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
KWQMN job cache list latch	kwqmnprsc: loop	1	0
SQL memory manager latch	qesmmIQueryRefreshBound	2	2
qmn task queue latch	kwqmngettsk: get task	1	2
qmn task queue latch	kwqmnmvtsks: delay to ready list	1	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

No data exists for this section of the report.

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 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: 26,831
Captured Segments account for 92.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	I_SYSAUTH1	INDEX	10,464	39.00
SYS	SYSTEM	PROPS$	TABLE	2,144	7.99
SYS	SYSAUX	SYS_IOT_TOP_8826	INDEX	1,856	6.92
SYS	SYSTEM	I_OBJ2	INDEX	1,632	6.08
SYS	SYSTEM	SERVICE$	TABLE	1,584	5.90

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 86
Captured Segments account for 83.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	25	29.07
SYS	SYSAUX	WRH$_SQL_PLAN_PK	INDEX	12	13.95
SYS	SYSAUX	WRH$_SYSMETRIC_SUMMARY	TABLE	7	8.14
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY	TABLE	6	6.98
SYS	SYSAUX	WRI$_ADV_PARAMETERS	TABLE	6	6.98

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSTEM	JOB$		TABLE	50	17.67
SYS	SYSAUX	SYS_IOT_TOP_8826		INDEX	10	3.53
SYS	SYSAUX	WRH$_SQLSTAT	1269038_84	TABLE PARTITION	8	2.83
SYS	SYSAUX	WRH$_SQLSTAT_PK	1269038_84	INDEX PARTITION	8	2.83
SYS	SYSAUX	SMON_SCN_TIME		TABLE	7	2.47

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 258
Captured Segments account for 57.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	14	5.43
SYS	SYSTEM	JOB$		TABLE	12	4.65
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	1269038_84	INDEX PARTITION	10	3.88
SYS	SYSAUX	WRH$_SQL_PLAN_PK		INDEX	10	3.88
SYS	SYSAUX	WRH$_LATCH_PK	1269038_84	INDEX PARTITION	8	3.10

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	17	0.00	2	1
dc_database_links	1,067	0.00	0	1
dc_global_oids	6	0.00	0	38
dc_histogram_data	204	0.00	0	1,319
dc_histogram_defs	569	13.01	0	4,426
dc_objects	1,425	0.49	0	1,891
dc_profiles	1,066	0.00	0	2
dc_rollback_segments	142	0.00	0	42
dc_segments	104	0.96	9	668
dc_sequences	10	10.00	10	6
dc_tablespaces	318	0.00	0	7
dc_users	10,845	0.00	0	88
global database name	1,692	0.00	0	1
outstanding_alerts	9	66.67	1	3

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts
dc_awr_control	4	0
dc_histogram_defs	74	0
dc_objects	7	0
dc_segments	18	2
dc_sequences	20	0
outstanding_alerts	15	4

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	18	0.00	0	0
INDEX	8	0.00	8	0.00	0	0
SQL AREA	6,749	1.01	12,668	0.92	0	2
TABLE/PROCEDURE	1,218	0.82	2,489	1.00	2	0
TRIGGER	4	0.00	4	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	8	8	0	0	0
TABLE/PROCEDURE	205	2,380	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	144.00	144.00	144.00	144.00	INI/
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	116.00	116.00	116.00	116.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	336.00	336.00	336.00	336.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	4.00	4.00	4.00	4.00	STA/
large pool	4.00	4.00	4.00	4.00	STA/
shared pool	172.00	172.00	172.00	172.00	STA/
streams pool	4.00	4.00	4.00	4.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	270.28		5.63	10.13	55	55	48	48
	Freeable	12.81	0.00	1.42	1.14	3		9	9
	SQL	1.28	0.80	0.06	0.12	0	8	21	13
	PL/SQL	0.15	0.07	0.00	0.01	0	0	45	40
E	Other	275.42		5.40	9.88	55	55	51	51
	Freeable	13.06	0.00	1.45	1.18	3		9	9
	SQL	0.95	0.47	0.04	0.08	0	8	24	14
	PL/SQL	0.15	0.07	0.00	0.01	0	0	48	41

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	150,994,944
Fixed Size	1,299,876
Redo Buffers	6,287,360
Variable Size	192,940,636

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	4.00	4.00	0.00
large	PX msg pool	0.86	0.86	0.00
large	free memory	3.14	3.14	0.00
shared	ASH buffers	4.00	4.00	0.00
shared	CCursor	7.58	7.73	2.02
shared	Heap0: KGL	2.16	2.17	0.69
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGL buckets	3.00	3.00	0.00
shared	KGL handle	2.54	2.57	1.04
shared	KGLS heap	6.32	6.39	1.09
shared	KQR L PO	1.92	1.93	0.36
shared	KQR M PO	3.49	3.54	1.46
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	KSXR receive buffers	2.02	2.02	0.00
shared	PCursor	3.38	3.45	2.26
shared	PL/SQL DIANA	1.90	1.90	0.00
shared	PL/SQL MPCODE	3.55	3.55	0.00
shared	free memory	20.58	19.37	-5.88
shared	gcs resources	2.19	2.19	0.00
shared	ges big msg buffers	3.79	3.79	0.00
shared	ges enqueues	1.94	1.94	0.00
shared	ges resource		1.74
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	obj stats allocation chun	1.90	1.90	0.00
shared	row cache	3.61	3.61	0.00
shared	sql area	43.96	44.70	1.70
streams	free memory	4.00	4.00	0.00
	buffer_cache	144.00	144.00	0.00
	fixed_sga	1.24	1.24	0.00
	log_buffer	6.00	6.00	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	30,997	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	1	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

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
RAC1_COLESTOC_3872_CUBS1	0	0	0
RAC1_COLESTOC_3873_CUBS1	0	0	0
RAC2_COLESTOC_3872_CUBS2	0	0	0
RAC2_COLESTOC_3938_CUBS2	0	0	0
HAE_SUB	0	0	0

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

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

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u02/app/oradata/cubs/admin/adump
client_result_cache_lag	10000
client_result_cache_size	0
cluster_database	TRUE
cluster_database_instances	2
compatible	11.0.0
control_files	/u02/app/oradata/cubs/control01.ctl, /u02/app/oradata2/cubs/control02.ctl
db_block_size	8192
db_domain	colestock.test
db_file_multiblock_read_count	16
db_name	cubs
diagnostic_dest	/u02/app/oradata/cubs/admin/log
dispatchers	(PROTOCOL=TCP) (SERVICE=cubsXDB)
instance_number	2
job_queue_processes	10
local_listener	listener_cubs2
log_archive_dest_1	LOCATION=/u02/app/oradata/cubs/arch/ mandatory reopen=5
log_archive_format	cubs_%t_%s_%r.arc
open_cursors	300
pga_aggregate_target	121634816
processes	150
remote_listener	listeners_cubs
remote_login_passwordfile	EXCLUSIVE
sga_target	352321536
thread	2
undo_management	AUTO
undo_tablespace	UNDOTBS2

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	115	0.17	3.38
acks for commit broadcast(logical)	119	0.18	3.50
broadcast msgs on commit(actual)	68	0.10	2.00
broadcast msgs on commit(logical)	82	0.12	2.41
broadcast msgs on commit(wasted)	15	0.02	0.44
broadcast on commit wait time(ms)	30	0.04	0.88
broadcast on commit waits	58	0.09	1.71
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
false posts waiting for scn acks	0	0.00	0.00
flow control messages received	0	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	1	0.00	0.03
gcs ast xid	0	0.00	0.00
gcs blocked converts	2	0.00	0.06
gcs blocked cr converts	34	0.05	1.00
gcs compatible basts	0	0.00	0.00
gcs compatible cr basts (global)	0	0.00	0.00
gcs compatible cr basts (local)	0	0.00	0.00
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	45	0.07	1.32
gcs dbwr write request msgs	139	0.21	4.09
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	0	0.00	0.00
gcs immediate (null) converts	0	0.00	0.00
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	0	0.00	0.00
gcs indirect ast	0	0.00	0.00
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	0	0.00	0.00
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	0	0.00	0.00
gcs msgs process time(ms)	38	0.06	1.12
gcs msgs received	1,444	2.13	42.47
gcs new served by master	0	0.00	0.00
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	0	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs queued converts	0	0.00	0.00
gcs reader bypass N->Xw ping local	0	0.00	0.00
gcs reader bypass N->Xw ping remote	0	0.00	0.00
gcs reader bypass grant X on assume	0	0.00	0.00
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	0	0.00	0.00
gcs reader bypass grant immediate	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	0	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	88	0.13	2.59
gcs side channel msgs logical	683	1.01	20.09
gcs stale cr	0	0.00	0.00
gcs undo cr	1	0.00	0.03
gcs write notification msgs	0	0.00	0.00
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	37	0.05	1.09
ges msgs received	1,142	1.68	33.59
global posts dropped	0	0.00	0.00
global posts queue time	0	0.00	0.00
global posts queued	1	0.00	0.03
global posts requested	1	0.00	0.03
global posts sent	1	0.00	0.03
implicit batch messages received	25	0.04	0.74
implicit batch messages sent	243	0.36	7.15
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	169	0.25	4.97
messages queue sent actual	868	1.28	25.53
messages queue sent logical	1,562	2.30	45.94
messages received actual	2,294	3.38	67.47
messages received logical	2,586	3.81	76.06
messages sent directly	1,446	2.13	42.53
messages sent indirectly	1,199	1.77	35.26
messages sent not implicit batched	625	0.92	18.38
messages sent pbatched	805	1.19	23.68
msgs causing lmd to send msgs	190	0.28	5.59
msgs causing lms(s) to send msgs	108	0.16	3.18
msgs received queue time (ms)	2	0.00	0.06
msgs received queued	2,586	3.81	76.06
msgs sent queue time (ms)	889	1.31	26.15
msgs sent queue time on ksxp (ms)	1,733	2.56	50.97
msgs sent queued	1,562	2.30	45.94
msgs sent queued on ksxp	2,531	3.73	74.44
process batch messages received	1,136	1.68	33.41
process batch messages sent	472	0.70	13.88

Global CR Served Stats

Statistic	Total
CR Block Requests	139
CURRENT Block Requests	139
Data Block Requests	139
Undo Block Requests	1
TX Block Requests	34
Current Results	275
Private results	0
Zero Results	3
Disk Read Results	0
Fail Results	0
Fairness Down Converts	5
Fairness Clears	28
Free GC Elements	0
Flushes	9
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	2
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	237	100.00	0.00	0.00
Flushes	0	0.00	0.00	0.00
Writes	47	12.77	65.96	21.28

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
1	data block	135	98.52	1.48	0.00	179	97.77	2.23	0.00
1	Others	133	100.00	0.00	0.00	77	98.70	1.30	0.00
1	undo header	5	100.00	0.00	0.00	1	100.00	0.00	0.00

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer Times (ms)

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

Inst No	Block Class	All	Immed	Busy	All	Immed	Busy
		CR Avg Time (ms)			Current Avg Time (ms)
1	data block	0.94	0.68	18.18	0.89	0.80	4.89
1	others	0.61	0.61		0.81	0.63	14.51
1	undo header	0.54	0.54		0.56	0.56
1	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
1	data block	0	133	100.00	0.00	175	100.00	0.00
1	others	0	133	100.00	0.00	76	100.00	0.00
1	undo header	0	5	100.00	0.00	1	100.00	0.00
1	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	Immed	2hop
		CR Avg Time (ms)		Current Avg Time (ms)
1	data block	0.68	0.68	0.80	0.80
1	others	0.61	0.61	0.63	0.63
1	undo header	0.54	0.54	0.56	0.56
1	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	68	1.70	2.93	67	1.79	2.90
2	68	0.32	0.05	68	0.31	0.05

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Throughput of interconnect usage by major consumers.
All throughput numbers are megabytes per second

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	0.00	0.01
Parallel Query	0.00	0.00
DB Locks	0.00	0.00
DB Streams	0.00	0.00
Other	0.00	0.00

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics

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

Device Name	IP Address	Public	Source	Send Mbytes/sec	Send Errors	Send Dropped	Send Buffer Overrun	Send Carrier Lost	Receive Mbytes/sec	Receive Errors	Receive Dropped	Receive Buffer Overrun	Receive Frame Errors
eth1	192.168.2.102	NO	Oracle Cluster Repository	0.04	0	0	0	0	0.08	0	0	0	0

Back to Interconnect Stats
Back to Top

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.72	In-memory Sort %:	100.00
Library Hit %:	99.07	Soft Parse %:	99.52
Execute to Parse %:	-25.60	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	0.01	% Non-Parse CPU:	92.95

Buffer access - local cache %:	97.70
Buffer access - remote cache %:	2.02
Buffer access - disk %:	0.28

Avg global enqueue get time (ms):	1.1
Avg global cache cr block receive time (ms):	0.7
Avg global cache current block receive time (ms):	0.8
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 %:	3.2
Avg global cache cr block flush time (ms):	6.7
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.1
Global cache log flushes for current blocks served %:	0.0
Avg global cache current block flush time (ms):

Avg message sent queue time (ms):	0.6
Avg message sent queue time on ksxp (ms):	0.7
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:	51.39
% of indirect sent messages:	42.61
% of flow controlled messages:	6.01