WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

CUBS 2121269038 cubs1 1 04-Feb-08 13:02 11.1.0.6.0 YES

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

Host Name Platform CPUs Cores Sockets Memory (GB)

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

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
rac1.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:39:02 41 1.0

End Snap: 96 04-Feb-08 15:50:21 41 1.0

Elapsed: 11.31 (mins)

DB Time: 0.62 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	95	04-Feb-08 15:39:02	41	1.0
End Snap:	96	04-Feb-08 15:50:21	41	1.0
Elapsed:		11.31 (mins)
DB Time:		0.62 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 0.1 0.2 0.00 0.00

DB CPU(s): 0.0 0.1 0.00 0.00

Redo size: 2,213.7 6,533.1

Logical reads: 51.7 152.4

Block changes: 6.1 18.0

Physical reads: 0.0 0.1

Physical writes: 0.9 2.7

User calls: 14.1 41.5

Parses: 16.2 47.9

Hard parses: 0.0 0.1

W/A MB processed: 134,658.4 397,405.5

Logons: 2.0 5.8

Executes: 14.0 41.3

Rollbacks: 0.1 0.3

Transactions: 0.3

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.1	0.2	0.00	0.00
DB CPU(s):	0.0	0.1	0.00	0.00
Redo size:	2,213.7	6,533.1
Logical reads:	51.7	152.4
Block changes:	6.1	18.0
Physical reads:	0.0	0.1
Physical writes:	0.9	2.7
User calls:	14.1	41.5
Parses:	16.2	47.9
Hard parses:	0.0	0.1
W/A MB processed:	134,658.4	397,405.5
Logons:	2.0	5.8
Executes:	14.0	41.3
Rollbacks:	0.1	0.3
Transactions:	0.3

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.81 Soft Parse %: 99.90

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

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

Shared Pool Statistics

Begin End

Memory Usage %: 73.52 73.73

% SQL with executions>1: 86.28 81.14

% Memory for SQL w/exec>1: 86.01 73.07

	Begin	End
Memory Usage %:	73.52	73.73
% SQL with executions>1:	86.28	81.14
% Memory for SQL w/exec>1:	86.01	73.07

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		11		29.27
PX Deq: reap credit	507	9	18	24.24	Other
PX Deq: Slave Session Stats	31	7	216	17.93	Other
SQL*Net break/reset to client	132	1	7	2.49	Application
IPC send completion sync	158	1	4	1.87	Other

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

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

1.27 28.65 89.8 9.3 0.0 0.8

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
1.27	28.65	89.8	9.3	0.0	0.8

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

1.3 1.3 0.0

Memory Statistics

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

Begin End

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

SGA use (MB): 336.0 336.0

PGA use (MB): 233.0 234.0

% Host Mem used for SGA+PGA: 28.22 28.22

	Begin	End
Host Mem (MB):	2,016.2	2,016.2
SGA use (MB):	336.0	336.0
PGA use (MB):	233.0	234.0
% Host Mem used for SGA+PGA:	28.22	28.22

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.84 2.47

Global Cache blocks served: 0.89 2.61

GCS/GES messages received: 5.51 16.27

GCS/GES messages sent: 4.09 12.06

DBWR Fusion writes: 0.27 0.80

Estd Interconnect traffic (KB) 15.64

	Per Second	Per Transaction
Global Cache blocks received:	0.84	2.47
Global Cache blocks served:	0.89	2.61
GCS/GES messages received:	5.51	16.27
GCS/GES messages sent:	4.09	12.06
DBWR Fusion writes:	0.27	0.80
Estd Interconnect traffic (KB)	15.64

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

Buffer access - local cache %: 98.35

Buffer access - remote cache %: 1.62

Buffer access - disk %: 0.04

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1

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

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

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

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

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

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 1.1

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

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

% of indirect sent messages: 32.03

% of flow controlled messages: 18.27

Cluster Interconnect

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
eth1	192.168.2.101	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): 37.4s
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	25.61	68.52
DB CPU	10.94	29.27
connection management call elapsed time	2.48	6.65
parse time elapsed	1.07	2.85
PL/SQL execution elapsed time	0.65	1.75
hard parse elapsed time	0.13	0.35
repeated bind elapsed time	0.00	0.01
DB time	37.38
background elapsed time	49.00
background cpu time	6.47

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	134,770
IDLE_TIME	1,155
IOWAIT_TIME	22
NICE_TIME	1
SYS_TIME	12,637
USER_TIME	122,074
LOAD	1	29
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:39:02	1.27
04-Feb 15:50:21	28.65	99.15	89.81	9.30	0.02	0.85

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 81.2% of Total DB time 37.38 (s)
Total FG Wait Time: 19.43 (s) DB CPU time: 10.94 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Other	922	73	18	20	48.13
DB CPU			11		29.27
Application	132	0	1	7	2.49
Cluster	11	0	0	29	0.85
Network	4,217	0	0	0	0.29
Concurrency	61	0	0	1	0.16
Commit	3	0	0	5	0.04
System I/O	7	0	0	1	0.02
Configuration	0		0		0.00
User I/O	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: reap credit	507	100	9	18	2.20	24.24
PX Deq: Slave Session Stats	31	10	7	216	0.13	17.93
SQL*Net break/reset to client	132	0	1	7	0.57	2.49
IPC send completion sync	158	98	1	4	0.69	1.87
enq: PS - contention	34	15	1	15	0.15	1.39
reliable message	10	0	0	43	0.04	1.16
gc current grant busy	11	0	0	29	0.05	0.85
rdbms ipc reply	133	0	0	2	0.58	0.64
name-service call wait	2	0	0	114	0.01	0.61
SQL*Net more data from client	18	0	0	4	0.08	0.21
PX Deq Credit: Session Stats	14	0	0	4	0.06	0.13
row cache lock	56	0	0	1	0.24	0.13
latch: ges resource hash list	2	0	0	15	0.01	0.08
KJC: Wait for msg sends to complete	29	0	0	1	0.13	0.08
SQL*Net message to client	4,188	0	0	0	18.21	0.08
log file sync	3	0	0	5	0.01	0.04
library cache lock	2	0	0	5	0.01	0.03
control file sequential read	7	0	0	1	0.03	0.02
SQL*Net more data to client	11	0	0	0	0.05	0.00
library cache pin	2	0	0	1	0.01	0.00
SQL*Net message from client	4,189	0	3,753	896	18.21
jobq slave wait	287	46	664	2314	1.25
Streams AQ: waiting for messages in the queue	66	100	66	1004	0.29
PX Deq: Execution Msg	135	22	18	132	0.59
PX Deq: Msg Fragment	53	11	0	5	0.23
PX Deq Credit: send blkd	4	0	0	5	0.02
PX Deq: Join ACK	6	33	0	4	0.03
PX Deq: Execute Reply	4	25	0	3	0.02
PX Deq: Parse Reply	3	33	0	4	0.01

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
os thread startup	22	23	10	476	0.10	21.35
control file sequential read	1,780	0	5	3	7.74	10.38
control file parallel write	236	0	3	11	1.03	5.17
log file parallel write	140	0	2	13	0.61	3.84
events in waitclass Other	7,653	97	1	0	33.27	2.60
gc cr block 2-way	56	0	0	8	0.24	0.92
gc current block 2-way	6	0	0	10	0.03	0.12
gc current multi block request	3	0	0	17	0.01	0.10
latch: cache buffers chains	1	0	0	10	0.00	0.02
library cache pin	4	0	0	0	0.02	0.00
library cache lock	3	0	0	1	0.01	0.00
enq: TM - contention	2	100	0	1	0.01	0.00
rdbms ipc message	12,096	81	15,108	1249	52.59
DIAG idle wait	25,029	98	1,356	54	108.82
Streams AQ: qmn slave idle wait	25	0	690	27613	0.11
Streams AQ: qmn coordinator idle wait	48	50	690	14382	0.21
PING	236	18	681	2885	1.03
wait for unread message on broadcast channel	676	100	680	1005	2.94
ges remote message	8,552	86	679	79	37.18
gcs remote message	17,058	90	679	40	74.17
pmon timer	421	53	673	1599	1.83
smon timer	2	100	600	300020	0.01
fbar timer	2	100	600	300005	0.01
Space Manager: slave idle wait	16	100	80	5009	0.07
KSV master wait	408	100	0	0	1.77
Streams AQ: RAC qmn coordinator idle wait	49	100	0	0	0.21

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	6293	100.0
DFS lock handle	22	90.9	4.5	4.5
IPC send completion sync	161	72.0	3.1	3.7	3.7	6.8	7.5	3.1
KJC: Wait for msg sends to complete	53	98.1					1.9
PX Deq Credit: Session Stats	14	85.7		7.1				7.1
PX Deq: Signal ACK EXT	2	100.0
PX Deq: Signal ACK RSG	4	100.0
PX Deq: Slave Session Stats	35	65.7		2.9		11.4	2.9	8.6	8.6
PX Deq: reap credit	1132	96.6	.1			.2	.1	1.1	1.9
SQL*Net break/reset to client	138	70.3	2.2	4.3	4.3	4.3	9.4	5.1
SQL*Net message to client	5642	100.0			.0
SQL*Net more data from client	19	89.5	5.3					5.3
SQL*Net more data to client	11	100.0
buffer deadlock	1	100.0
control file parallel write	249		4.0	53.8	6.8	13.7	15.7	6.0
control file sequential read	2565	84.7	2.8	2.5	3.2	4.2	2.0	.5
db file scattered read	2		50.0			50.0
db file sequential read	12	83.3	8.3				8.3
enq: CF - contention	25	52.0	4.0	4.0	4.0	20.0	16.0
enq: DR - contention	1						100.0
enq: HW - contention	3	100.0
enq: MW - contention	1	100.0
enq: PI - contention	1			100.0
enq: PS - contention	40	42.5	2.5	10.0	7.5	22.5	7.5	7.5
enq: TA - contention	2	100.0
enq: TD - KTF dump entries	1	100.0
enq: TM - contention	2	100.0
enq: TT - contention	1	100.0
enq: WF - contention	6	83.3	16.7
gc cr block 2-way	311	91.0	1.0	1.3	.6	4.8	.6	.6
gc cr block busy	8		12.5	75.0			12.5
gc cr multi block request	2	100.0
gc current block 2-way	168	94.6	2.4		.6	1.8	.6
gc current block busy	1							100.0
gc current grant busy	103	86.4	1.9	2.9	1.0	2.9	1.9	2.9
gc current multi block request	85	85.9	4.7	1.2		4.7	1.2	1.2	1.2
gcs log flush sync	24	75.0	16.7			4.2	4.2
ksxr poll remote instances	1392	99.9				.1
latch: cache buffers chains	1					100.0
latch: gcs resource hash	1					100.0
latch: ges resource hash list	5	80.0					20.0
latch: shared pool	1	100.0
library cache lock	8	87.5				12.5
library cache pin	14	100.0
log file parallel write	142	14.1	21.8	9.2	5.6	12.7	28.2	8.5
log file sync	5	20.0		20.0		20.0	20.0	20.0
name-service call wait	3							100.0
os thread startup	22						9.1	90.9
rdbms ipc reply	319	90.3	2.8	2.8	.3	1.9	1.6	.3
reliable message	62	56.5	12.9	3.2	6.5	4.8	8.1	8.1
row cache lock	71	69.0	26.8	1.4	1.4		1.4
wait for scn ack	116	77.6	1.7	1.7	9.5	3.4	3.4	2.6
DIAG idle wait	25K	1.1	.1	.1	.2	2.3	60.7	35.6
KSV master wait	422	99.8			.2
PING	244	72.1	.8			.4	.8	.8	25.0
PX Deq Credit: send blkd	6	66.7				33.3
PX Deq: Execute Reply	7	85.7				14.3
PX Deq: Execution Msg	135	53.3	9.6	8.9	6.7	8.1	6.7	1.5	5.2
PX Deq: Join ACK	11	63.6	18.2			18.2
PX Deq: Msg Fragment	53	66.0	1.9	1.9	3.8	13.2	11.3	1.9
PX Deq: Parse Reply	7	85.7				14.3
PX Idle Wait	546	.2		.2		.2		1.5	98.0
SQL*Net message from client	7619	41.5	8.8	9.0	1.1	1.4	4.3	29.5	4.4
Space Manager: slave idle wait	141	.7							99.3
Streams AQ: RAC qmn coordinator idle wait	51	100.0
Streams AQ: qmn coordinator idle wait	50	32.0	4.0	4.0	6.0	2.0	2.0		50.0
Streams AQ: qmn slave idle wait	26	3.8							96.2
Streams AQ: waiting for messages in the queue	69							100.0
class slave wait	1	100.0
cmon timer	9636	64.6	12.1	1.2	1.3	6.4	1.5	11.2	1.7
dispatcher timer	12								100.0
fbar timer	2								100.0
gcs remote message	17K	5.0	1.1	.8	.6	.6	1.3	90.6
ges remote message	8839	3.2	.7	2.4	.7	1.1	1.6	90.3
jobq slave wait	299	3.3					.3	3.0	93.3
pmon timer	436	37.8	.7	1.1	.9	2.5	1.1	2.1	53.7
pool server timer	2382	2.9	.1	.2	.9	1.8	3.9	53.4	36.8
rdbms ipc message	12K	6.0	.5	.5	.5	.6	.6	64.9	26.4
smon timer	2								100.0
virtual circuit status	24								100.0
wait for unread message on broadcast channel	702							99.4	.6

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	32	3	11
cubs.colestock.test	5	8	17
SYS$BACKGROUND	1	0	7
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	Concurcy Wt Time	Network Total Wts
SYS$USERS	0	60	0	351
cubs.colestock.test	0	1	0	3867
SYS$BACKGROUND	14	56	11	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): 37
Captured SQL account for 171.0% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
28	1	1	27.85	74.50	bunssq950snhf		insert into wrh$_sga_target_ad...
11	1	11	1.00	29.51	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
10	0	10	1.00	26.64	3am9cfkvx7gq1		CALL MGMT_ADMIN_DATA.EVALUATE_...
4	0	1	3.63	9.70	a1xgxtssv5rrp	MMON_SLAVE	select sum(used_blocks), ts.t...
2	0	1	1.89	5.06	dqbhc9r7gz0a5		SELECT DECODE(COUNT(CLIENT_INF...
2	0	1	1.81	4.84	6mvfay19q3v4n		SELECT COUNT(CLIENT_INFO) FROM...
1	0	1	1.43	3.83	5jxwda6s8nvc7	MMON_SLAVE	select tablespace_id, rfno, ...
1	0	23	0.05	2.79	1rswbxwhbpmr7		select decode(bitand(a.flags, ...
1	0	1	0.93	2.48	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
1	0	1,336	0.00	1.46	0k8522rmdzg4k		select privilege# from sysauth...
0	0	3,131	0.00	1.18	0h6b2sajwb74n		select privilege#, level from ...
0	0	1	0.42	1.13	bqnn4c3gjtmgu		insert into wrh$_bg_event_summ...

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

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
1	28	1	1.04	9.49	74.50	bunssq950snhf		insert into wrh$_sga_target_ad...
1	11	11	0.07	6.54	29.51	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0	1	23	0.02	4.49	2.79	1rswbxwhbpmr7		select decode(bitand(a.flags, ...
0	0	3,131	0.00	3.56	1.18	0h6b2sajwb74n		select privilege#, level from ...
0	1	1,336	0.00	3.06	1.46	0k8522rmdzg4k		select privilege# from sysauth...
0	0	1	0.30	2.71	1.13	bqnn4c3gjtmgu		insert into wrh$_bg_event_summ...
0	0	2	0.09	1.61	0.47	bg8xn87xfqpm9	emagent@rac1.colestock.test (TNS V1-V3)	/* OracleOEM */ SEL...
0	0	1	0.12	1.09	0.69	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	664	0.00	0.99	0.46	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
0	0	664	0.00	0.92	0.28	459f3z9u4fb3u		select value$ from props$ wher...

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: 35,060
Captured SQL account for 71.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
8,475	1,336	6.34	24.17	0.33	0.55	0k8522rmdzg4k	select privilege# from sysauth...
7,065	3,131	2.26	20.15	0.39	0.44	0h6b2sajwb74n	select privilege#, level from ...
6,413	11	583.00	18.29	0.72	11.03	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
2,656	664	4.00	7.58	0.10	0.10	459f3z9u4fb3u	select value$ from props$ wher...
1,992	664	3.00	5.68	0.09	0.09	5ur69atw3vfhj	select decode(failover_method,...
979	1	979.00	2.79	0.12	0.26	6ajkhukk78nsr	begin prvt_hdm.auto_execute( :...
725	10	72.50	2.07	0.05	9.96	3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_...
506	23	22.00	1.44	0.49	1.04	1rswbxwhbpmr7	select decode(bitand(a.flags, ...
464	59	7.86	1.32	0.03	0.08	18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFOR...
422	1	422.00	1.20	0.03	0.17	5ax5xu96u2ztd	insert into WRH$_EVENT_HISTOGR...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 13
Captured SQL account for 15.4% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
3	1	3.00	23.08	0.12	0.26	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
2	2	1.00	15.38	0.02	0.10	fnk7155mk2jq6		insert into wrh$_sysmetric_his...
0	70	0.00	0.00	0.00	0.01	089dbukv1aanh		SELECT SYS_EXTRACT_UTC(SYSTIME...
0	52	0.00	0.00	0.00	0.01	08bqjmf8490s2		SELECT PARAMETER_VALUE FROM MG...
0	3,131	0.00	0.00	0.39	0.44	0h6b2sajwb74n		select privilege#, level from ...
0	1,336	0.00	0.00	0.33	0.55	0k8522rmdzg4k		select privilege# from sysauth...
0	0		0.00	0.02	0.03	0v6s91manuhz8	emagent@rac2.colestock.test (TNS V1-V3)	/* OracleOEM */ S...
0	664	0.00	0.00	0.11	0.17	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
0	59	0.00	0.00	0.03	0.08	18naypzfmabd6		INSERT INTO MGMT_SYSTEM_PERFOR...
0	1	0.00	0.00	0.00	0.00	19rkm1wsf9axx		insert into WRI$_ALERT_HISTORY...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 9,487
Captured SQL account for 85.4% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
3,131	847	0.27	0h6b2sajwb74n		select privilege#, level from ...
1,336	3,131	2.34	0k8522rmdzg4k		select privilege# from sysauth...
664	664	1.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
664	664	1.00	459f3z9u4fb3u		select value$ from props$ wher...
664	664	1.00	5ur69atw3vfhj		select decode(failover_method,...
662	662	1.00	1gy9qq7yjm054		select /+ result_cache / cou...
80	0	0.00	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
80	80	1.00	g00cj285jmgsw		update sys.mon_mods$ set inser...
70	70	1.00	089dbukv1aanh		SELECT SYS_EXTRACT_UTC(SYSTIME...
69	0	0.00	3972rvxu3knn3	racgimon@rac1.colestock.test (TNS V1-V3)	delete from sdo_geor_ddl__tabl...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 11,026
Captured SQL account for 71.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
3,131	3,131	28.40	0h6b2sajwb74n		select privilege#, level from ...
1,336	1,336	12.12	0k8522rmdzg4k		select privilege# from sysauth...
664	664	6.02	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
664	664	6.02	459f3z9u4fb3u		select value$ from props$ wher...
664	664	6.02	5ur69atw3vfhj		select decode(failover_method,...
662	662	6.00	1gy9qq7yjm054		select /+ result_cache / cou...
80	80	0.73	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
80	80	0.73	g00cj285jmgsw		update sys.mon_mods$ set inser...
69	69	0.63	3972rvxu3knn3	racgimon@rac1.colestock.test (TNS V1-V3)	delete from sdo_geor_ddl__tabl...
69	69	0.63	a6u3yjca29nqc	racgimon@rac1.colestock.test (TNS V1-V3)	declare m_stmt varchar2(512...

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,227,286
Captured SQL accounts for 3.28% of Total Cluster Wait Time

Cluster Wait Time (s)	%Ela	%Total	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Text
3.47	12.45	282.49	27.85	1.04	1	bunssq950snhf	insert into wrh$_sga_target_ad...
0.32	98.16	25.91	0.32	0.01	11	aq8yqxyyb40nn	update sys.job$ set this_date=...
0.18	99.76	14.92	0.18	0.00	1	7qvb1fw60p3r5	select last_sample_date_num, ...
0.11	43.57	9.17	0.26	0.12	1	6ajkhukk78nsr	begin prvt_hdm.auto_execute( :...
0.09	53.35	7.61	0.17	0.03	1	5ax5xu96u2ztd	insert into WRH$_EVENT_HISTOGR...
0.08	81.49	6.36	0.10	0.02	1	4dy1xm4nxc0gf	insert into wrh$_system_event ...
0.07	17.39	6.01	0.42	0.30	1	bqnn4c3gjtmgu	insert into wrh$_bg_event_summ...
0.04	37.49	3.13	0.10	0.02	2	fnk7155mk2jq6	insert into wrh$_sysmetric_his...
0.03	32.55	2.21	0.08	0.01	1	7g732rx16j8jc	insert into WRH$_SERVICE_STAT ...
0.02	45.59	1.62	0.04	0.03	1	f0s0bk5k713yb	insert into wrh$_parameter (...
0.01	15.53	1.17	0.09	0.03	1	586b2udq6dbng	insert into wrh$_sysstat (sn...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

089dbukv1aanh SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL

08bqjmf8490s2 SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1

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')

18naypzfmabd6 INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))

19rkm1wsf9axx insert into WRI$_ALERT_HISTORY (sequence_id, reason_id, owner, object_name, subobject_name, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, time_suggested, creation_time, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, message_level, hosting_client_id, process_id, host_id, host_nw_addr, instance_name, instance_number, user_id, execution_context_id, error_instance_id, resolution, metric_value) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29)

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

1rswbxwhbpmr7 select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time), a.obj#, decode(bitand(a.flags, 16384), 0, 0, 1), a.sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q UNION ALL select j.job, 0, cast(j.next_date as timestamp with time zone), 1, NULL, cast(j.next_date as timestamp with time zone), NULL, 0 from sys.job$ j where (:1 = 1) and (j.field1 is null or j.field1 = 0) and j.job not in (select v.id2 from v$lock v where v.type = 'JQ')) a where bitand(a.job_status, 3) = 1 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and a.instance_id is NULL and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) = (select min(decode(bitand(c.flags, 16384), 0, c.next_run_date, c.last_enabled_time)) from (sele ct r.flags flags, r.next_run_date next_run_date, r.job_status job_status, r.class_oid class_oid, r.last_enabled_time last_enabled_time, r.instance_id instance_id from sys.scheduler$_job r UNION ALL select s.flags, s.next_run_date, s.job_status, s.class_oid, s.last_enabled_time, s.instance_id from sys.scheduler$_lightweight_job s UNION ALL select 0, cast(k.next_date as timestamp with time zone), 1, NULL, cast(k.next_date as timestamp with time zone), NULL from sys.job$ k where (:2 = 1) and (k.field1 is null or k.field1 = 0) and k.job not in (select w.id2 from v$lock w where w.type = 'JQ')) c where bitand(c.job_status, 3) = 1 and ((bitand(c.flags, 134217728 + 268435456) = 0) or (bitand(c.job_status, 1024) <> 0)) and bitand(c.flags, 4096) = 0 and c.instance_id is NULL and (c.class_oid is null or (c.class_oid is not null and c.class_oid in (select d.obj# from sys.scheduler$_class d where d.affinity is null))))

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

3972rvxu3knn3 delete from sdo_geor_ddl__table$$

3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)

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

4dy1xm4nxc0gf insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id

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

5jxwda6s8nvc7 select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :w or (changescn_wrap = :w and changescn_base >= :b))

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;

6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

6mvfay19q3v4n SELECT COUNT(CLIENT_INFO) FROM GV$SESSION WHERE USERNAME=:B2 AND CLIENT_INFO = :B1 GROUP BY CLIENT_INFO

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

7qvb1fw60p3r5 select last_sample_date_num, last_sample_date, total_samples from WRI$_DBU_USAGE_SAMPLE where dbid = :dbid and version = :version

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)

a1xgxtssv5rrp select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#

a6u3yjca29nqc declare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end;

aq8yqxyyb40nn update sys.job$ set this_date=:1 where job=:2

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

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

dqbhc9r7gz0a5 SELECT DECODE(COUNT(CLIENT_INFO), 0, 'down', 'up') FROM GV$SESSION WHERE CLIENT_INFO = :B1

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

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

SQL Id	SQL Text
089dbukv1aanh	SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2	SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
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')
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
19rkm1wsf9axx	insert into WRI$_ALERT_HISTORY (sequence_id, reason_id, owner, object_name, subobject_name, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, time_suggested, creation_time, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, message_level, hosting_client_id, process_id, host_id, host_nw_addr, instance_name, instance_number, user_id, execution_context_id, error_instance_id, resolution, metric_value) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29)
1gy9qq7yjm054	select /+ result_cache / count(*) from scott.dept
1rswbxwhbpmr7	select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time), a.obj#, decode(bitand(a.flags, 16384), 0, 0, 1), a.sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q UNION ALL select j.job, 0, cast(j.next_date as timestamp with time zone), 1, NULL, cast(j.next_date as timestamp with time zone), NULL, 0 from sys.job$ j where (:1 = 1) and (j.field1 is null or j.field1 = 0) and j.job not in (select v.id2 from v$lock v where v.type = 'JQ')) a where bitand(a.job_status, 3) = 1 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and a.instance_id is NULL and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) = (select min(decode(bitand(c.flags, 16384), 0, c.next_run_date, c.last_enabled_time)) from (sele ct r.flags flags, r.next_run_date next_run_date, r.job_status job_status, r.class_oid class_oid, r.last_enabled_time last_enabled_time, r.instance_id instance_id from sys.scheduler$_job r UNION ALL select s.flags, s.next_run_date, s.job_status, s.class_oid, s.last_enabled_time, s.instance_id from sys.scheduler$_lightweight_job s UNION ALL select 0, cast(k.next_date as timestamp with time zone), 1, NULL, cast(k.next_date as timestamp with time zone), NULL from sys.job$ k where (:2 = 1) and (k.field1 is null or k.field1 = 0) and k.job not in (select w.id2 from v$lock w where w.type = 'JQ')) c where bitand(c.job_status, 3) = 1 and ((bitand(c.flags, 134217728 + 268435456) = 0) or (bitand(c.job_status, 1024) <> 0)) and bitand(c.flags, 4096) = 0 and c.instance_id is NULL and (c.class_oid is null or (c.class_oid is not null and c.class_oid in (select d.obj# from sys.scheduler$_class d where d.affinity is null))))
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
3972rvxu3knn3	delete from sdo_geor_ddl__table$$
3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4dy1xm4nxc0gf	insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id
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
5jxwda6s8nvc7	select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :w or (changescn_wrap = :w and changescn_base >= :b))
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;
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6mvfay19q3v4n	SELECT COUNT(CLIENT_INFO) FROM GV$SESSION WHERE USERNAME=:B2 AND CLIENT_INFO = :B1 GROUP BY CLIENT_INFO
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
7qvb1fw60p3r5	select last_sample_date_num, last_sample_date, total_samples from WRI$_DBU_USAGE_SAMPLE where dbid = :dbid and version = :version
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)
a1xgxtssv5rrp	select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#
a6u3yjca29nqc	declare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end;
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
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
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
dqbhc9r7gz0a5	SELECT DECODE(COUNT(CLIENT_INFO), 0, 'down', 'up') FROM GV$SESSION WHERE CLIENT_INFO = :B1
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
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

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 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	876	1.29	3.81
CPU used when call started	729	1.07	3.17
CR blocks created	23	0.03	0.10
DB time	73,356	108.07	318.94
DBWR checkpoint buffers written	472	0.70	2.05
DBWR fusion writes	184	0.27	0.80
DBWR transaction table writes	21	0.03	0.09
DBWR undo block writes	153	0.23	0.67
DFO trees parallelized	4	0.01	0.02
HSC Heap Segment Block Changes	504	0.74	2.19
Heap Segment Array Inserts	87	0.13	0.38
Heap Segment Array Updates	1	0.00	0.00
PX local messages recv'd	17	0.03	0.07
PX local messages sent	17	0.03	0.07
PX remote messages recv'd	112	0.17	0.49
PX remote messages sent	64	0.09	0.28
Parallel operations not downgraded	4	0.01	0.02
RowCR attempts	43	0.06	0.19
RowCR hits	43	0.06	0.19
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	4,186	6.17	18.20
active txn count during cleanout	84	0.12	0.37
application wait time	93	0.14	0.40
background timeouts	3,743	5.51	16.27
buffer is not pinned count	15,531	22.88	67.53
buffer is pinned count	3,458	5.09	15.03
bytes received via SQL*Net from client	1,429,499	2,105.99	6,215.21
bytes sent via SQL*Net to client	1,127,767	1,661.46	4,903.33
calls to get snapshot scn: kcmgss	14,502	21.36	63.05
calls to kcmgas	1,002	1.48	4.36
calls to kcmgcs	341	0.50	1.48
calls to kcmgrs	6,968	10.27	30.30
change write time	9	0.01	0.04
cleanout - number of ktugct calls	85	0.13	0.37
cleanouts and rollbacks - consistent read gets	3	0.00	0.01
cleanouts only - consistent read gets	1	0.00	0.00
cluster key scan block gets	19	0.03	0.08
cluster key scans	19	0.03	0.08
cluster wait time	136	0.20	0.59
commit batch/immediate performed	5	0.01	0.02
commit batch/immediate requested	5	0.01	0.02
commit cleanout failures: block lost	4	0.01	0.02
commit cleanout failures: callback failure	3	0.00	0.01
commit cleanouts	865	1.27	3.76
commit cleanouts successfully completed	858	1.26	3.73
commit immediate performed	5	0.01	0.02
commit immediate requested	5	0.01	0.02
commit txn count during cleanout	43	0.06	0.19
concurrency wait time	1,058	1.56	4.60
consistent changes	38	0.06	0.17
consistent gets	31,201	45.97	135.66
consistent gets - examination	9,574	14.10	41.63
consistent gets direct	0	0.00	0.00
consistent gets from cache	31,201	45.97	135.66
consistent gets from cache (fastpath)	20,694	30.49	89.97
cursor authentications	8	0.01	0.03
data blocks consistent reads - undo records applied	25	0.04	0.11
db block changes	4,133	6.09	17.97
db block gets	3,859	5.69	16.78
db block gets direct	0	0.00	0.00
db block gets from cache	3,859	5.69	16.78
db block gets from cache (fastpath)	958	1.41	4.17
deferred (CURRENT) block cleanout applications	449	0.66	1.95
dirty buffers inspected	2	0.00	0.01
enqueue conversions	153	0.23	0.67
enqueue releases	9,763	14.38	42.45
enqueue requests	9,764	14.38	42.45
enqueue timeouts	1	0.00	0.00
enqueue waits	81	0.12	0.35
execute count	9,487	13.98	41.25
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	630	0.93	2.74
free buffer requested	1,424	2.10	6.19
gc CPU used by this session	51	0.08	0.22
gc cr block build time	0	0.00	0.00
gc cr block flush time	4	0.01	0.02
gc cr block receive time	65	0.10	0.28
gc cr block send time	1	0.00	0.00
gc cr blocks received	315	0.46	1.37
gc cr blocks served	293	0.43	1.27
gc current block flush time	2	0.00	0.01
gc current block pin time	1	0.00	0.00
gc current block receive time	33	0.05	0.14
gc current block send time	2	0.00	0.01
gc current blocks received	252	0.37	1.10
gc current blocks served	308	0.45	1.34
gc local grants	99	0.15	0.43
gc remote grants	0	0.00	0.00
gcs messages sent	1,629	2.40	7.08
ges messages sent	1,144	1.69	4.97
global enqueue get time	186	0.27	0.81
global enqueue gets async	76	0.11	0.33
global enqueue gets sync	14,150	20.85	61.52
global enqueue releases	14,120	20.80	61.39
heap block compress	8	0.01	0.03
hot buffers moved to head of LRU	5	0.01	0.02
immediate (CR) block cleanout applications	4	0.01	0.02
immediate (CURRENT) block cleanout applications	227	0.33	0.99
index crx upgrade (positioned)	198	0.29	0.86
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fetch by key	2,590	3.82	11.26
index scans kdiixs1	7,464	11.00	32.45
leaf node 90-10 splits	0	0.00	0.00
leaf node splits	30	0.04	0.13
lob reads	0	0.00	0.00
lob writes	1	0.00	0.00
lob writes unaligned	1	0.00	0.00
logons cumulative	1,336	1.97	5.81
messages received	1,238	1.82	5.38
messages sent	1,064	1.57	4.63
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	16,880	24.87	73.39
opened cursors cumulative	12,073	17.79	52.49
parse count (failures)	0	0.00	0.00
parse count (hard)	11	0.02	0.05
parse count (total)	11,026	16.24	47.94
parse time cpu	36	0.05	0.16
parse time elapsed	80	0.12	0.35
physical read IO requests	9	0.01	0.04
physical read bytes	106,496	156.89	463.03
physical read total IO requests	2,498	3.68	10.86
physical read total bytes	40,845,312	60,174.68	177,588.31
physical read total multi block requests	0	0.00	0.00
physical reads	13	0.02	0.06
physical reads cache	13	0.02	0.06
physical reads cache prefetch	4	0.01	0.02
physical reads direct	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	4	0.01	0.02
physical write IO requests	441	0.65	1.92
physical write bytes	5,169,152	7,615.37	22,474.57
physical write total IO requests	1,669	2.46	7.26
physical write total bytes	24,247,296	35,721.93	105,423.03
physical write total multi block requests	10	0.01	0.04
physical writes	631	0.93	2.74
physical writes direct	0	0.00	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes from cache	631	0.93	2.74
physical writes non checkpoint	349	0.51	1.52
pinned buffers inspected	2	0.00	0.01
process last non-idle time	0	0.00	0.00
queries parallelized	4	0.01	0.02
recursive calls	67,871	99.99	295.09
recursive cpu usage	543	0.80	2.36
redo blocks checksummed by FG (exclusive)	2,121	3.12	9.22
redo blocks written	3,527	5.20	15.33
redo blocks written for direct writes	0	0.00	0.00
redo entries	2,669	3.93	11.60
redo ordering marks	93	0.14	0.40
redo size	1,502,608	2,213.69	6,533.08
redo subscn max counts	110	0.16	0.48
redo synch time	8	0.01	0.03
redo synch writes	13	0.02	0.06
redo wastage	40,036	58.98	174.07
redo write time	188	0.28	0.82
redo writer latching time	0	0.00	0.00
redo writes	141	0.21	0.61
rollback changes - undo records applied	10	0.01	0.04
rollbacks only - consistent read gets	22	0.03	0.10
rows fetched via callback	1,678	2.47	7.30
session connect time	0	0.00	0.00
session cursor cache hits	4,363	6.43	18.97
session logical reads	35,060	51.65	152.43
shared hash latch upgrades - no wait	970	1.43	4.22
sorts (memory)	6,874	10.13	29.89
sorts (rows)	12,705	18.72	55.24
sql area evicted	0	0.00	0.00
sql area purged	0	0.00	0.00
summed dirty queue length	28	0.04	0.12
switch current to new buffer	3	0.00	0.01
table fetch by rowid	3,531	5.20	15.35
table fetch continued row	0	0.00	0.00
table scan blocks gotten	4,750	7.00	20.65
table scan rows gotten	121,792	179.43	529.53
table scans (long tables)	1	0.00	0.00
table scans (short tables)	1,736	2.56	7.55
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	5	0.01	0.02
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	544,752	802.55	2,368.49
user I/O wait time	5	0.01	0.02
user calls	9,544	14.06	41.50
user commits	161	0.24	0.70
user rollbacks	69	0.10	0.30
workarea executions - optimal	846	1.25	3.68

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	2,506,436,296	2,719,457,464
session cursor cache count	58,634	66,952
session uga memory	498,575,617,888	545,872,578,916
opened cursors current	41	40
logons current	41	41
session uga memory max	2,607,926,144	2,970,720,964
session pga memory	687,990,436	735,926,420

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	Av Writes/s
SYSAUX	9	5.56	1.44	378	1
UNDOTBS1	0	0.00	0.00	55	0
SYSTEM	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 Rd(ms)	Av Blks/Rd	Writes	Av Writes/s
SYSAUX	/u02/app/oradata/cubs/sysaux01.dbf	9	5.56	1.44	378	1
SYSTEM	/u02/app/oradata/cubs/system01.dbf	0			8	0
UNDOTBS1	/u02/app/oradata/cubs/undotbs01.dbf	0			55	0

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	15,488	100	35,214	13	631	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	381	1393	2022	92160	2022
E	0	0	301	1354	4851	92160	4851

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.09	1,452	1.57	11,948
D	24	0.19	2,904	1.26	9,601
D	36	0.28	4,356	1.17	8,849
D	48	0.38	5,808	1.13	8,551
D	60	0.47	7,260	1.10	8,346
D	72	0.56	8,712	1.08	8,210
D	84	0.66	10,164	1.01	7,645
D	96	0.75	11,616	1.00	7,595
D	108	0.84	13,068	1.00	7,595
D	120	0.94	14,520	1.00	7,595
D	128	1.00	15,488	1.00	7,595
D	132	1.03	15,972	1.00	7,595
D	144	1.13	17,424	1.00	7,595
D	156	1.22	18,876	1.00	7,595
D	168	1.31	20,328	1.00	7,595
D	180	1.41	21,780	1.00	7,595
D	192	1.50	23,232	1.00	7,595
D	204	1.59	24,684	1.00	7,595
D	216	1.69	26,136	1.00	7,595
D	228	1.78	27,588	1.00	7,595
D	240	1.88	29,040	0.79	6,011

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	87	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	8	233.03	0.00	0.00	0.00	0.00	23,756
E	116	8	234.00	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	750	750
64K	128K	4	4
512K	1024K	92	92

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	968.85	20.86	98.00	8	16,825
29	0.25	968.85	20.86	98.00	8	16,825
58	0.50	968.85	20.86	98.00	8	16,825
87	0.75	968.85	20.86	98.00	8	16,825
116	1.00	968.85	0.00	100.00	1	16,470
139	1.20	968.85	0.00	100.00	0	16,470
162	1.40	968.85	0.00	100.00	0	16,470
186	1.60	968.85	0.00	100.00	0	16,470
209	1.80	968.85	0.00	100.00	0	16,470
232	2.00	968.85	0.00	100.00	0	16,470
348	3.00	968.85	0.00	100.00	0	16,470
464	4.00	968.85	0.00	100.00	0	16,470
696	6.00	968.85	0.00	100.00	0	16,470
928	8.00	968.85	0.00	100.00	0	16,470

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)
80	0.50	0	31	2,743	0.97	126	3.94	3
96	0.60	16	1,080	2,745	0.97	124	3.88	108
112	0.70	32	2,900	2,837	1.00	32	1.00	110
128	0.80	41	4,388	2,837	1.00	32	1.00	110
144	0.90	41	4,388	2,837	1.00	32	1.00	110
160	1.00	41	4,388	2,837	1.00	32	1.00	110
176	1.10	41	4,388	2,837	1.00	32	1.00	110
192	1.20	41	4,388	2,837	1.00	32	1.00	110
208	1.30	41	4,388	2,837	1.00	32	1.00	110
224	1.40	41	4,388	2,837	1.00	32	1.00	110
240	1.50	41	4,388	2,837	1.00	32	1.00	110
256	1.60	41	4,388	2,837	1.00	32	1.00	110
272	1.70	41	4,388	2,837	1.00	32	1.00	110
288	1.80	41	4,388	2,837	1.00	32	1.00	110
304	1.90	41	4,388	2,837	1.00	32	1.00	110
320	2.00	41	4,388	2,837	1.00	32	1.00	110

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	241	8,852
252	0.75	239	7,591
336	1.00	239	7,591
420	1.25	237	6,005
504	1.50	237	6,005
588	1.75	237	6,018
672	2.00	237	6,018

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
PS-PX Process Reservation	51	50	1	40	1	14.50
CF-Controlfile Transaction	1,524	1,524	0	23	0	6.96
DR-Distributed Recovery	1	1	0	1	0	20.00
HW-Segment High Water Mark	31	31	0	8	0	1.25
PI-Remote PX Process Spawn Status	1	1	0	1	0	10.00
WF-AWR Flush	21	21	0	6	0	0.00
FB-Format Block	3	3	0	2	0	0.00
TA-Instance Undo	2	2	0	2	0	0.00
TM-DML	1,177	1,177	0	2	0	0.00
MW-MWIN Schedule	1	1	0	1	0	0.00
TD-KTF map table enqueue (KTF dump entries)	1	1	0	1	0	0.00
TT-Tablespace	25	25	0	1	0	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
1	0.13	250	908	3	29.2/29.2	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:47	126	250	908	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	451	0.00		0
ASM map operation hash table	1	0.00		0
AWR Alerted Metric Element list	4,406	0.00		0
Change Notification Hash table latch	226	0.00		0
Consistent RBA	140	0.00		0
DML lock allocation	509,822	0.00		0
Event Group Locks	19	0.00		0
FAL request queue	17	0.00		0
FAL subheap alocation	17	0.00		0
FOB s.o list latch	25	0.00		0
File State Object Pool Parent Latch	1	0.00		0
IPC stats buffer allocation latch	123	0.00		126	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	3	0.00		0
JS broadcast add buf latch	157	0.00		0
JS broadcast autostart latch	11	0.00		0
JS broadcast drop buf latch	157	0.00		0
JS broadcast load blnc latch	137	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,932	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	538	0.00		152	0.00
KJCT flow control latch	4,352	0.00		0
KMG MMAN ready and startup request latch	226	0.00		0
KSXR large replies	46	0.00		0
KTF sga latch	5	0.00		205	0.00
KWQMN job cache list latch	54	0.00		0
KWQS pqsubs latch	12	0.00		0
KWQS pqueue ctx latch	15	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	2,232	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	139	0.00		0
OS process allocation	320	0.00		0
OS process: request allocation	34	0.00		0
PL/SQL warning settings	1,426	0.00		0
QMT	1	0.00		0
Result Cache: Latch	1,932	0.00		0
Result Cache: SO Latch	1,288	0.00		0
SGA IO buffer pool latch	1	0.00		1	0.00
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	289	0.00		224	0.00
SQL memory manager workarea list latch	35,026	0.00		0
Shared B-Tree	54	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	770	0.00		0
active service list	10,438	0.00		420	0.00
archive control	28	0.00		0
archive process latch	258	0.00		0
buffer pool	1	0.00		0
business card	9	0.00		0
cache buffer handles	113	0.00		0
cache buffers chains	53,680	0.00	1.00	2,834	0.00
cache buffers lru chain	4,816	0.00		2,748	0.29
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	37	0.00		0
channel operations parent latch	96,666	0.00		0
checkpoint queue latch	8,865	0.00		539	0.00
client/application info	8,834	0.00		0
commit callback allocation	31	0.00		0
compile environment latch	1,337	0.00		0
connection pool sga data lock	3,283	0.00		0
corrupted undo seg lock	28	0.00		0
cp cmon array latch	420	0.00		0
cp cmon/server latch	13,854	0.00		0
cp cso latch	1,288	0.00		0
cp pool latch	22	0.00		0
cp server array latch	22	0.00		0
cp server hash latch	9,759	0.00		0
cp sga latch	197	0.00		0
cv apply list lock	1	0.00		0
cv free list lock	1	0.00		0
deferred cleanup latch	197	0.00		0
dml lock allocation	197	0.00		0
done queue latch	1	0.00		0
dummy allocation	2,675	0.00		0
enqueue hash chains	25,141	0.00	0.00	0
enqueues	16,496	0.00		0
error message lists	18	0.00		0
fifth spare latch	1	0.00		0
file cache latch	53	0.00		0
flashback archiver latch	2	0.00		0
flashback copy	1	0.00		0
gc element	6,030	0.00		61	0.00
gcs commit scn state	1	0.00		0
gcs opaque info freelist	1,440	0.00		0
gcs partitioned table hash	1,850,777	0.00		0
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	3	0.00		0
gcs remastering latch	40	0.00		0
gcs resource freelist	404	0.00		162	0.00
gcs resource hash	6,209	0.02	1.00	1	0.00
gcs resource scan list	3	0.00		0
gcs shadows freelist	1,189	0.00		717	0.00
ges caches resource lists	12,156	0.00		7,197	0.00
ges deadlock list	44	0.00		0
ges domain table	27,889	0.00		0
ges enqueue table freelist	28,482	0.00		0
ges group table	41,706	0.00		0
ges process hash list	451	0.00		0
ges process parent latch	56,980	0.00		0
ges process table freelist	34	0.00		0
ges resource hash list	43,801	0.01	1.00	829	0.00
ges resource scan list	1	0.00		0
ges resource table freelist	1,729	0.00		0
ges timeout list	112	0.00		52	0.00
ges value block free list	1	0.00		0
global KZLD latch for mem in SGA	647	0.00		0
global tx hash mapping	1	0.00		0
granule operation	1	0.00		0
hash table column usage latch	6	0.00		18	0.00
hash table modification latch	47	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		22	0.00
job_queue_processes parameter latch	22	0.00		0
k2q global data latch	454	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	23	0.00		0
kokc descriptor allocation latch	638	0.00		0
kpplsSyncStateListSga: lock	1,932	0.00		0
ksfv messages	1	0.00		0
ksim membership request latch	94	0.00		518	0.00
kss move lock	13	0.00		0
ksuosstats global area	48	0.00		0
ksv allocation latch	221	0.00		0
ksv class latch	841	0.00		0
ksv msg queue latch	1	0.00		0
ksxp shared latch	34	0.00		0
ksz_so allocation latch	34	0.00		0
ktm global data	3	0.00		0
kwqbsn:qsga	26	0.00		0
lgwr LWN SCN	323	0.00		0
library cache load lock	16	0.00		0
list of block allocation	44	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	3	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	1	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	1,103	0.00		0
messages	27,115	0.01	0.00	0
mostly latch-free SCN	323	0.00		0
msg queue latch	1	0.00		0
multiblock read objects	444	0.00		0
name-service memory objects	737	0.00		0
name-service namespace bucket	6,436	0.00		0
name-service pending queue	456	0.00		0
name-service request	6	0.00		0
name-service request queue	6,650	0.00		0
ncodef allocation latch	197	0.00		0
object queue header heap	827	0.00		59	0.00
object queue header operation	5,678	0.00		0
object stats modification	42	0.00		0
parallel query alloc buffer	357	0.00		0
parallel query stats	41	0.00		0
parallel txn reco latch	80	0.00		0
parameter list	864	0.00		0
parameter table management	3,318	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	44	0.00		32	0.00
process allocation	6,033	0.00		18	0.00
process group creation	34	0.00		0
process queue	116	0.00		0
process queue reference	3,035	0.00		315	0.00
qmn task queue latch	100	0.00		0
query server freelists	84	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	787	0.00		2,716	0.00
redo copy	1	0.00		2,716	0.00
redo writing	1,663	0.00		0
resmgr group change latch	1,406	0.00		0
resmgr:active threads	2,675	0.00		0
resmgr:actses change group	1,337	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	2,674	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	61,153	0.00	0.00	0
rules engine aggregate statistics	3	0.00		0
rules engine rule set statistics	6	0.00		0
second spare latch	1	0.00		0
sequence cache	3,924	0.00		0
session allocation	10,833	0.01	0.00	0
session idle bit	20,560	0.00		0
session queue latch	1	0.00		0
session state list latch	96	0.00		0
session switching	198	0.00		0
session timer	413	0.00		0
shared pool	75,874	0.01	0.14	0
shared pool sim alloc	3	0.00		0
shared pool simulator	15,080	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	868	0.00		0
simulator lru latch	615	0.00		99	0.00
sort extent pool	211	0.00		0
space background state object latch	2	0.00		0
space background task latch	503	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	2	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	28	0.00		0
transaction allocation	114,666	0.00		0
transaction branch allocation	413	0.00		0
undo global data	1,398	0.00		0
user lock	2,795	0.00		0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
shared pool	75,874	7	1	6
ges resource hash list	43,801	5	5	0
cache buffers chains	53,680	1	1	0
gcs resource hash	6,209	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
cache buffers chains	kclebs_2	1	0
gcs resource hash	kjbrwrdone reget	1	0
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	2	0
ges resource hash list	kjakcai: search for resp by resname	1	1
ges resource hash list	kjlrlr: remove lock from resource queue	1	2
ges resource hash list	kjrmas1: lookup master node	1	0
shared pool	kghalo	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: 35,060
Captured Segments account for 83.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	I_SYSAUTH1	INDEX	14,992	42.76
SYS	SYSTEM	PROPS$	TABLE	2,704	7.71
SYS	SYSTEM	SERVICE$	TABLE	1,904	5.43
SYS	SYSTEM	TAB$	TABLE	1,232	3.51
SYS	SYSTEM	JOB$	TABLE	768	2.19

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 13
Captured Segments account for 84.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	6	46.15
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY	TABLE	2	15.38
SYS	SYSAUX	WRH$_BG_EVENT_SUMMARY_PK	INDEX	1	7.69
SYS	SYSAUX	WRH$_SYSMETRIC_SUMMARY	TABLE	1	7.69
SYS	SYSAUX	WRI$_ADV_PARAMETERS	TABLE	1	7.69

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

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSAUX	WRH$_SQL_PLAN_PK	INDEX	20	6.35
SYS	SYSAUX	WRH$_SQL_BIND_METADATA_PK	INDEX	19	6.03
SYS	SYSAUX	WRI$_ADV_TASKS_PK	INDEX	12	3.81
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	10	3.17
SYS	SYSAUX	WRH$_SQLTEXT_PK	INDEX	9	2.86

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 252
Captured Segments account for 66.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	1269038_84	INDEX PARTITION	13	5.16
SYS	SYSAUX	WRH$_PARAMETER_PK	1269038_84	INDEX PARTITION	9	3.57
SYS	SYSAUX	WRH$_BG_EVENT_SUMMARY_PK		INDEX	8	3.17
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	1269038_84	INDEX PARTITION	8	3.17
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM	1269038_84	TABLE PARTITION	7	2.78

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	15	13.33	0	1
dc_database_links	1,295	0.00	0	1
dc_global_oids	522	0.00	0	51
dc_histogram_data	25	0.00	0	1,333
dc_histogram_defs	148	37.84	0	3,937
dc_objects	2,043	0.15	0	1,696
dc_profiles	1,305	0.00	0	2
dc_rollback_segments	339	0.00	0	42
dc_segments	18	5.56	1	565
dc_tablespaces	456	0.00	0	6
dc_users	14,471	0.00	0	122
global database name	2,132	0.00	0	1
outstanding_alerts	11	63.64	3	7

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts
dc_awr_control	2	2
dc_histogram_defs	56	0
dc_objects	3	0
dc_segments	2	8
outstanding_alerts	18	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
BODY	318	0.00	369	0.00	0
CLUSTER	1	0.00	1	0.00	0
SQL AREA	8,283	0.24	17,584	0.19	1
TABLE/PROCEDURE	2,208	0.09	3,638	0.22	2
TRIGGER	70	0.00	78	0.00	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
CLUSTER	1	1	0	0	0
TABLE/PROCEDURE	233	3,609	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	128.00	128.00	128.00	128.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	36.00	36.00	36.00	36.00	STA/
large pool	4.00	4.00	4.00	4.00	STA/
shared pool	160.00	160.00	160.00	160.00	STA/
streams pool	0.00	0.00	0.00	0.00	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	217.81		4.36	6.96	22	24	50	50
	Freeable	14.50	0.00	1.32	1.01	3		11	11
	SQL	0.71	0.30	0.03	0.05	0	8	23	13
	PL/SQL	0.17	0.08	0.00	0.01	0	0	47	42
E	Other	220.00		4.23	6.86	22	24	52	52
	Freeable	13.38	0.00	1.34	1.05	3		10	10
	SQL	0.67	0.28	0.03	0.04	0	8	25	13
	PL/SQL	0.17	0.08	0.00	0.01	0	0	49	42

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	134,217,728
Fixed Size	1,299,876
Redo Buffers	6,287,360
Variable Size	209,717,852

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	36.00	36.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	4.30	4.33	0.77
shared	Heap0: KGL	1.88	1.88	0.21
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KCL partition table	1.69	1.69	0.00
shared	KGL buckets	3.00	3.00	0.00
shared	KGL handle	2.62	2.63	0.25
shared	KGLS heap	4.94	4.96	0.37
shared	KQR L PO	1.77	1.77	0.17
shared	KQR M PO	3.11	3.14	1.22
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	KSXR receive buffers	2.02	2.02	0.00
shared	PCursor	2.23	2.25	0.90
shared	PL/SQL MPCODE	3.78	3.78	0.00
shared	free memory	42.36	42.02	-0.80
shared	gcs resources	1.94	1.94	0.00
shared	ges big msg buffers	3.79	3.79	0.00
shared	ges enqueues	1.99	1.99	0.00
shared	ges resource	1.74	1.75	0.45
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kppls: cso user ctx		1.84
shared	obj stats allocation chun	1.90	1.90	0.00
shared	row cache	3.61	3.61	0.00
shared	sql area	19.13	19.32	1.00
	buffer_cache	128.00	128.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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

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

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
gcs_resources	17,942	18,460	18739	18739
gcs_shadows	14,533	16,047	18739	18739

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	1
job_queue_processes	10
local_listener	listener_cubs1
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	1
undo_management	AUTO
undo_tablespace	UNDOTBS1

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	62	0.09	0.27
acks for commit broadcast(logical)	70	0.10	0.30
broadcast msgs on commit(actual)	127	0.19	0.55
broadcast msgs on commit(logical)	141	0.21	0.61
broadcast msgs on commit(wasted)	8	0.01	0.03
broadcast on commit wait time(ms)	44	0.06	0.19
broadcast on commit waits	114	0.17	0.50
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	308	0.45	1.34
gcs ast xid	0	0.00	0.00
gcs blocked converts	763	1.12	3.32
gcs blocked cr converts	574	0.85	2.50
gcs compatible basts	2	0.00	0.01
gcs compatible cr basts (global)	18	0.03	0.08
gcs compatible cr basts (local)	49	0.07	0.21
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	177	0.26	0.77
gcs dbwr write request msgs	31	0.05	0.13
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	24	0.04	0.10
gcs immediate (null) converts	129	0.19	0.56
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	62	0.09	0.27
gcs indirect ast	204	0.30	0.89
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	204	0.30	0.89
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	17	0.03	0.07
gcs msgs process time(ms)	97	0.14	0.42
gcs msgs received	2,624	3.87	11.41
gcs new served by master	82	0.12	0.36
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	2	0.00	0.01
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	271	0.40	1.18
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	19	0.03	0.08
gcs side channel msgs logical	577	0.85	2.51
gcs stale cr	0	0.00	0.00
gcs undo cr	0	0.00	0.00
gcs write notification msgs	2	0.00	0.01
gcs writes refused	6	0.01	0.03
ges msgs process time(ms)	10	0.01	0.04
ges msgs received	1,118	1.65	4.86
global posts dropped	0	0.00	0.00
global posts queue time	162	0.24	0.70
global posts queued	13	0.02	0.06
global posts requested	15	0.02	0.07
global posts sent	13	0.02	0.06
implicit batch messages received	250	0.37	1.09
implicit batch messages sent	26	0.04	0.11
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	239	0.35	1.04
messages queue sent actual	1,438	2.12	6.25
messages queue sent logical	1,444	2.13	6.28
messages received actual	2,627	3.87	11.42
messages received logical	3,742	5.51	16.27
messages sent directly	650	0.96	2.83
messages sent indirectly	419	0.62	1.82
messages sent not implicit batched	1,422	2.09	6.18
messages sent pbatched	1,541	2.27	6.70
msgs causing lmd to send msgs	850	1.25	3.70
msgs causing lms(s) to send msgs	133	0.20	0.58
msgs received queue time (ms)	3	0.00	0.01
msgs received queued	3,742	5.51	16.27
msgs sent queue time (ms)	1,682	2.48	7.31
msgs sent queue time on ksxp (ms)	4,714	6.94	20.50
msgs sent queued	1,508	2.22	6.56
msgs sent queued on ksxp	2,428	3.58	10.56
process batch messages received	502	0.74	2.18
process batch messages sent	1,230	1.81	5.35

Global CR Served Stats

Statistic	Total
CR Block Requests	142
CURRENT Block Requests	142
Data Block Requests	142
Undo Block Requests	0
TX Block Requests	5
Current Results	282
Private results	0
Zero Results	2
Disk Read Results	0
Fail Results	0
Fairness Down Converts	34
Fairness Clears	11
Free GC Elements	0
Flushes	2
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	0
Errors	0

Global CURRENT Served Stats

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

Statistic	Total	% <1ms	% <10ms	% <100ms
Pins	294	100.00	0.00	0.00
Flushes	4	0.00	100.00	0.00
Writes	184	33.15	58.15	8.70

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	151	96.03	3.97	0.00	182	100.00	0.00	0.00
2	Others	126	100.00	0.00	0.00	71	100.00	0.00	0.00
2	undo header	35	94.29	5.71	0.00	0
2	undo block	1	100.00	0.00	0.00	0

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer Times (ms)

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

Inst No	Block Class	All	Immed	Busy	All	Immed
		CR Avg Time (ms)			Current Avg Time (ms)
2	data block	2.12	1.96	6.12	1.57	1.57
2	others	1.04	1.04		1.14	1.14
2	undo header	6.14	6.36	2.65
2	undo block	0.64	0.64

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	145	100.00	0.00	182	100.00	0.00
2	others	0	126	100.00	0.00	71	100.00	0.00
2	undo header	0	33	100.00	0.00	0
2	undo block	0	1	100.00	0.00	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)
2	data block	1.96	1.96	1.57	1.57
2	others	1.04	1.04	1.14	1.14
2	undo header	6.36	6.36
2	undo block	0.64	0.64

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	67	0.98	1.93	67	0.96	1.93
2	67	0.75	1.50	66	2.28	5.22

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.01	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.101	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.96	In-memory Sort %:	100.00
Library Hit %:	99.81	Soft Parse %:	99.90
Execute to Parse %:	-16.22	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	0.00	% Non-Parse CPU:	96.71

Buffer access - local cache %:	98.35
Buffer access - remote cache %:	1.62
Buffer access - disk %:	0.04

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	2.1
Avg global cache current block receive time (ms):	1.3
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 %:	0.7
Avg global cache cr block flush time (ms):	20.0
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 %:	1.3
Avg global cache current block flush time (ms):	5.0

Avg message sent queue time (ms):	1.1
Avg message sent queue time on ksxp (ms):	1.9
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:	49.69
% of indirect sent messages:	32.03
% of flow controlled messages:	18.27