WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

CLOUDDBS 3149139862 clouddbs2 2 10.2.0.5.0 YES DB_2

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
CLOUDDBS	3149139862	clouddbs2	2	10.2.0.5.0	YES	DB_2

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 8081 19-Nov-13 09:00:18 38 2.2

End Snap: 8082 19-Nov-13 10:00:25 38 2.2

Elapsed: 60.11 (mins)

DB Time: 4.92 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	8081	19-Nov-13 09:00:18	38	2.2
End Snap:	8082	19-Nov-13 10:00:25	38	2.2
Elapsed:		60.11 (mins)
DB Time:		4.92 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 30,240M 30,240M Std Block Size: 8K

Shared Pool Size: 2,464M 2,464M Log Buffer: 14,272K

	Begin	End
Buffer Cache:	30,240M	30,240M	Std Block Size:	8K
Shared Pool Size:	2,464M	2,464M	Log Buffer:	14,272K

Load Profile

Per Second Per Transaction

Redo size: 465.05 1,615.93

Logical reads: 507.90 1,764.84

Block changes: 1.99 6.91

Physical reads: 0.92 3.20

Physical writes: 0.61 2.12

User calls: 2.77 9.61

Parses: 2.38 8.28

Hard parses: 0.00 0.00

Sorts: 2.75 9.55

Logons: 0.29 1.02

Executes: 2.44 8.48

Transactions: 0.29

	Per Second	Per Transaction
Redo size:	465.05	1,615.93
Logical reads:	507.90	1,764.84
Block changes:	1.99	6.91
Physical reads:	0.92	3.20
Physical writes:	0.61	2.12
User calls:	2.77	9.61
Parses:	2.38	8.28
Hard parses:	0.00	0.00
Sorts:	2.75	9.55
Logons:	0.29	1.02
Executes:	2.44	8.48
Transactions:	0.29

% Blocks changed per Read: 0.39 Recursive Call %: 86.02

Rollback per transaction %: 6.36 Rows per Sort: 31.41

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98 Redo NoWait %: 99.93

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

Library Hit %: 99.95 Soft Parse %: 99.99

Execute to Parse %: 2.36 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 86.30 % Non-Parse CPU: 99.35

Shared Pool Statistics

Begin End

Memory Usage %: 82.46 82.42

% SQL with executions>1: 91.98 93.66

% Memory for SQL w/exec>1: 83.03 87.02

	Begin	End
Memory Usage %:	82.46	82.42
% SQL with executions>1:	91.98	93.66
% Memory for SQL w/exec>1:	83.03	87.02

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

gc cr multi block request 6,567 2,107 321 713.8 Cluster

gc cr block lost 1,636 1,415 865 479.2 Cluster

control file sequential read 263,876 108 0 36.7 System I/O

gc buffer busy 365 100 273 33.8 Cluster

CPU time 98 33.0

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
gc cr multi block request	6,567	2,107	321	713.8	Cluster
gc cr block lost	1,636	1,415	865	479.2	Cluster
control file sequential read	263,876	108	0	36.7	System I/O
gc buffer busy	365	100	273	33.8	Cluster
CPU time		98		33.0

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: 2.41 8.38

Global Cache blocks served: 0.40 1.38

GCS/GES messages received: 8.40 29.18

GCS/GES messages sent: 18.23 63.34

DBWR Fusion writes: 0.03 0.12

Estd Interconnect traffic (KB) 27.67

	Per Second	Per Transaction
Global Cache blocks received:	2.41	8.38
Global Cache blocks served:	0.40	1.38
GCS/GES messages received:	8.40	29.18
GCS/GES messages sent:	18.23	63.34
DBWR Fusion writes:	0.03	0.12
Estd Interconnect traffic (KB)	27.67

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

Buffer access - local cache %: 99.51

Buffer access - remote cache %: 0.48

Buffer access - disk %: 0.02

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.8

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

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

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

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

Global cache log flushes for cr blocks served %: 2.4

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

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

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

Global cache log flushes for current blocks served %: 5.0

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1

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

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 35.03

% of indirect sent messages: 41.31

% of flow controlled messages: 23.65

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
Wait Class
Wait Events
Background Wait Events
Operating System Statistics
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 295.3s
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	271.94	92.10
connection management call elapsed time	163.66	55.43
DB CPU	97.52	33.03
parse time elapsed	0.71	0.24
PL/SQL execution elapsed time	0.28	0.09
DB time	295.26
background elapsed time	151.40
background cpu time	26.90

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%Total Call Time
Cluster	11,572	1	3,678	318	1245.75
System I/O	268,539		128	0	43.34
CPU time			98		33.03
User I/O	8,958		12	1	4.23
Other	81,929	97	9	0	3.08
Commit	972	1	5	6	1.84
Concurrency	194		1	3	0.22
Configuration	20		0	24	0.17
Application	131		0	2	0.07
Network	7,509		0	0	0.01

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
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
gc cr multi block request	6,567	0	2,107	321	6.33
gc cr block lost	1,636	0	1,415	865	1.58
control file sequential read	263,876		108	0	254.22
gc buffer busy	365	19	100	273	0.35
gc current block busy	276	5	34	121	0.27
gc current block 2-way	1,643	1	21	12	1.58
control file parallel write	2,817		12	4	2.71
db file sequential read	4,440		11	2	4.28
log file sync	972	1	5	6	0.94
log file parallel write	1,284		5	4	1.24
enq: WF - contention	21	10	2	105	0.02
enq: CF - contention	309	0	2	6	0.30
log file sequential read	351		2	5	0.34
direct path read	3,000		2	1	2.89
CGS wait for IPC msg	69,366	100	1	0	66.83
cr request retry	4,045	100	1	0	3.90
gc cr block busy	5		1	190	0.00
gcs log flush sync	114	20	1	8	0.11
gc cr block 2-way	487		1	1	0.47
latch free	54		0	9	0.05
os thread startup	11		0	44	0.01
log file switch completion	3		0	158	0.00
log file single write	140		0	2	0.13
PX Deq Credit: send blkd	138	25	0	2	0.13
gc cr grant 2-way	227		0	1	0.22
enq: TM - contention	117		0	2	0.11
enq: PS - contention	231		0	1	0.22
DFS lock handle	200		0	1	0.19
gc current multi block request	268		0	1	0.26
reliable message	267		0	0	0.26
gc current grant busy	80		0	1	0.08
latch: session allocation	53		0	2	0.05
buffer busy waits	76		0	1	0.07
PX Deq: reap credit	3,514	98	0	0	3.39
row cache lock	65		0	1	0.06
enq: WL - contention	71		0	1	0.07
IPC send completion sync	30	100	0	2	0.03
PX Deq: Signal ACK	193	34	0	0	0.19
direct path write	1,508		0	0	1.45
ksxr poll remote instances	2,996	92	0	0	2.89
db file parallel read	5		0	6	0.00
db file scattered read	4		0	7	0.00
LGWR wait for redo copy	143		0	0	0.14
rdbms ipc reply	126		0	0	0.12
CSS operation: query	6		0	3	0.01
SQL*Net message to client	7,509		0	0	7.23
enq: HW - contention	17		0	1	0.02
gc current grant 2-way	17		0	1	0.02
Log archive I/O	71		0	0	0.07
enq: TA - contention	12		0	1	0.01
enq: RO - fast object reuse	14		0	1	0.01
gc cr failure	1		0	5	0.00
ges inquiry response	6		0	1	0.01
enq: TD - KTF dump entries	7		0	1	0.01
library cache pin	3		0	1	0.00
enq: JS - job run lock - synchronize	3		0	1	0.00
CSS initialization	2		0	2	0.00
wait for scn ack	4		0	1	0.00
enq: FB - contention	3		0	1	0.00
latch: cache buffers chains	36		0	0	0.03
library cache lock	3		0	1	0.00
enq: DR - contention	2		0	1	0.00
enq: MW - contention	2		0	1	0.00
CSS operation: action	4		0	0	0.00
enq: AF - task serialization	1		0	1	0.00
read by other session	1		0	1	0.00
latch: ges resource hash list	3		0	0	0.00
latch: redo allocation	1		0	0	0.00
KJC: Wait for msg sends to complete	1		0	0	0.00
cursor: pin S	1		0	0	0.00
gcs remote message	984,104	96	28,155	29	948.08
SQL*Net message from client	7,509		7,017	935	7.23
ASM background timer	1,788		3,523	1970	1.72
DIAG idle wait	18,024		3,522	195	17.36
PX Idle Wait	1,490	93	3,522	2364	1.44
ges remote message	47,663	93	3,522	74	45.92
class slave wait	1,127	50	3,520	3123	1.09
Streams AQ: qmn slave idle wait	128		3,518	27483	0.12
Streams AQ: qmn coordinator idle wait	269	47	3,518	13077	0.26
virtual circuit status	120	100	3,504	29199	0.12
jobq slave wait	60	100	176	2931	0.06
KSV master wait	632		3	4	0.61
PX Deq: Execution Msg	329	7	1	2	0.32
PX Deq: Join ACK	205	35	0	2	0.20
PX Deq: Msg Fragment	139	6	0	2	0.13
PX Deq: Parse Reply	204	34	0	1	0.20
Streams AQ: waiting for time management or cleanup tasks	1	100	0	92	0.00
PX Deq: Execute Reply	208	35	0	0	0.20
Streams AQ: RAC qmn coordinator idle wait	269	100	0	0	0.26

Back to Wait Events Statistics
Back to Top

Background Wait Events

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
control file sequential read	80,251		37	0	77.31
control file parallel write	2,817		12	4	2.71
events in waitclass Other	73,364	98	6	0	70.68
log file parallel write	1,285		5	4	1.24
log file sequential read	351		2	5	0.34
direct path read	3,000		2	1	2.89
os thread startup	11		0	44	0.01
log file single write	140		0	2	0.13
log file switch completion	2		0	78	0.00
db file sequential read	7		0	15	0.01
enq: TM - contention	117		0	1	0.11
gc current block busy	2		0	27	0.00
direct path write	1,505		0	0	1.45
gc cr block 2-way	93		0	0	0.09
db file parallel read	2		0	9	0.00
Log archive I/O	71		0	0	0.07
enq: RO - fast object reuse	14		0	1	0.01
gc current grant 2-way	8		0	1	0.01
gc cr grant 2-way	4		0	1	0.00
latch: cache buffers chains	2		0	0	0.00
gc current block 2-way	77		-0	-0	0.07
enq: HW - contention	9		-0	-1	0.01
gc current multi block request	8		-0	-2	0.01
db file scattered read	1		-0	-37	0.00
gc current grant busy	21		-0	-2	0.02
rdbms ipc message	94,878	92	59,537	628	91.40
gcs remote message	984,115	96	28,155	29	948.09
ASM background timer	1,788		3,523	1970	1.72
DIAG idle wait	18,024		3,522	195	17.36
ges remote message	47,665	93	3,522	74	45.92
pmon timer	1,271	98	3,521	2770	1.22
class slave wait	1,119	50	3,520	3145	1.08
Streams AQ: qmn slave idle wait	128		3,518	27483	0.12
Streams AQ: qmn coordinator idle wait	269	47	3,518	13077	0.26
smon timer	18		3,485	193585	0.02
KSV master wait	632		3	4	0.61
Streams AQ: waiting for time management or cleanup tasks	1	100	0	92	0.00
Streams AQ: RAC qmn coordinator idle wait	269	100	0	0	0.26

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	77,189
IDLE_TIME	11,470,409
IOWAIT_TIME	7,503
NICE_TIME	252
SYS_TIME	40,367
USER_TIME	34,033
LOAD	0
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	4,390,334,464
VM_OUT_BYTES	529,768,448
PHYSICAL_MEMORY_BYTES	67,561,590,784
NUM_CPUS	32
NUM_CPU_SOCKETS	4

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
SYS$USERS	298.30	99.00	225	1,824,103
SYS$BACKGROUND	0.10	0.10	3,046	21,222
clouddbs	0.00	0.00	0	0
clouddbsXDB	0.00	0.00	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts
SYS$USERS	4351	11	119	0	6544
SYS$BACKGROUND	4605	2	74	1	0
clouddbs	0	0	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
154	3	964	0.16	52.20	59ztnpf9xxy0c	racgmdb@DB_2 (TNS V1-V3)	BEGIN INSERT INTO LOGON_TABLE ...
153	2	964	0.16	51.94	bzxvnna751nvb	racgmdb@DB_2 (TNS V1-V3)	INSERT INTO LOGON_TABLE VALUES...
61	29	55	1.11	20.76	apx329443j0w6	sqlplus@DB_2 (TNS V1-V3)	select TABLESPACE_NAME, ROUND(...
44	8	55	0.79	14.73	0s07s16dca7m1	sqlplus@DB_2 (TNS V1-V3)	select STATUS from v$datafile
6	5	54	0.11	2.10	2kh56ug11hvzb	sqlplus@DB_2 (TNS V1-V3)	SELECT wm_concat(TABLE_NAME\|\|'...
1	1	106	0.01	0.43	934ur8r7tqbjx	DBMS_SCHEDULER	SELECT DBID FROM V$DATABASE
1	1	1	1.25	0.42	bunssq950snhf		insert into wrh$_sga_target_ad...
1	1	1	1.24	0.42	84qubbrsr0kfn		insert into wrh$_latch (snap_i...
1	1	54	0.02	0.38	6n68yz03y5tm4	sqlplus@DB_2 (TNS V1-V3)	SELECT wm_concat(TABLE_NAME\|\|'...
1	0	55	0.02	0.34	aczgxpjdr3dmv	sqlplus@DB_2 (TNS V1-V3)	select status, type from v$log...

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

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
29	61	55	0.52	29.51	20.76	apx329443j0w6	sqlplus@DB_2 (TNS V1-V3)	select TABLESPACE_NAME, ROUND(...
8	44	55	0.14	7.96	14.73	0s07s16dca7m1	sqlplus@DB_2 (TNS V1-V3)	select STATUS from v$datafile
5	6	54	0.10	5.27	2.10	2kh56ug11hvzb	sqlplus@DB_2 (TNS V1-V3)	SELECT wm_concat(TABLE_NAME\|\|'...
3	154	964	0.00	3.21	52.20	59ztnpf9xxy0c	racgmdb@DB_2 (TNS V1-V3)	BEGIN INSERT INTO LOGON_TABLE ...
2	153	964	0.00	2.38	51.94	bzxvnna751nvb	racgmdb@DB_2 (TNS V1-V3)	INSERT INTO LOGON_TABLE VALUES...
1	1	1	1.28	1.31	0.42	bunssq950snhf		insert into wrh$_sga_target_ad...
1	1	54	0.02	1.12	0.38	6n68yz03y5tm4	sqlplus@DB_2 (TNS V1-V3)	SELECT wm_concat(TABLE_NAME\|\|'...
1	1	1	1.02	1.04	0.42	84qubbrsr0kfn		insert into wrh$_latch (snap_i...
1	1	106	0.01	0.96	0.43	934ur8r7tqbjx	DBMS_SCHEDULER	SELECT DBID FROM V$DATABASE
1	1	964	0.00	0.61	0.19	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: 1,831,908
Captured SQL account for 99.8% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
976,818	55	17,760.33	53.32	28.78	61.31	apx329443j0w6	sqlplus@DB_2 (TNS V1-V3)	select TABLESPACE_NAME, ROUND(...
752,490	54	13,935.00	41.08	5.14	6.19	2kh56ug11hvzb	sqlplus@DB_2 (TNS V1-V3)	SELECT wm_concat(TABLE_NAME\|\|'...
51,678	54	957.00	2.82	1.10	1.12	6n68yz03y5tm4	sqlplus@DB_2 (TNS V1-V3)	SELECT wm_concat(TABLE_NAME\|\|'...
8,755	480	18.24	0.48	0.08	0.09	bsa0wjtftg3uw		select file# from file$ where ...
6,304	3	2,101.33	0.34	0.15	0.15	8mrg623amm8rx		select OBJOID, CLSOID, RUNTIME...
4,929	53	93.00	0.27	0.11	0.10	3ujgs5s9hyu6p	sqlplus@DB_2 (TNS V1-V3)	SELECT MAX(VALUE)-MIN(VALUE) D...
4,929	53	93.00	0.27	0.10	0.10	gczdtkrqtcbbh	sqlplus@DB_2 (TNS V1-V3)	SELECT MAX(VALUE)-MIN(VALUE) C...
4,465	964	4.63	0.24	3.13	154.12	59ztnpf9xxy0c	racgmdb@DB_2 (TNS V1-V3)	BEGIN INSERT INTO LOGON_TABLE ...
3,856	964	4.00	0.21	0.59	0.56	459f3z9u4fb3u		select value$ from props$ wher...
3,501	964	3.63	0.19	2.32	153.35	bzxvnna751nvb	racgmdb@DB_2 (TNS V1-V3)	INSERT INTO LOGON_TABLE VALUES...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 3,322
Captured SQL account for 8.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
220	55	4.00	6.62	28.78	61.31	apx329443j0w6	sqlplus@DB_2 (TNS V1-V3)	select TABLESPACE_NAME, ROUND(...
17	1	17.00	0.51	0.02	0.68	71k5024zn7c9a		insert into wrh$_latch_misses_...
9	1	9.00	0.27	1.02	1.24	84qubbrsr0kfn		insert into wrh$_latch (snap_i...
7	1	7.00	0.21	0.03	0.15	32wqka2zwvu65		insert into wrh$_parameter (sn...
4	1	4.00	0.12	0.01	0.14	1uym1vta995yb		insert into wrh$_rowcache_summ...
4	1	4.00	0.12	0.02	0.12	350myuyx0t1d6		insert into wrh$_tablespace_st...
4	1	4.00	0.12	0.02	0.25	cp3gpd7z878w8		insert into wrh$_sgastat (snap...
4	1	4.00	0.12	0.02	0.12	cv0wdp1w4g9c5		insert into wrh$_inst_cache_tr...
3	1	3.00	0.09	0.06	0.12	agpd044zj368m		insert into wrh$_system_event ...
0	4	0.00	0.00	0.02	0.03	04xtrk7uyhknh		select obj#, type#, ctime, mti...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 8,798
Captured SQL account for 83.1% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
964	964	1.00	0.00	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
964	964	1.00	0.00	0.00	459f3z9u4fb3u		select value$ from props$ wher...
964	964	1.00	0.00	0.16	59ztnpf9xxy0c	racgmdb@DB_2 (TNS V1-V3)	BEGIN INSERT INTO LOGON_TABLE ...
964	964	1.00	0.00	0.16	bzxvnna751nvb	racgmdb@DB_2 (TNS V1-V3)	INSERT INTO LOGON_TABLE VALUES...
718	718	1.00	0.00	0.00	8kyvv5knwptbf		select count(*) from sys.job$ ...
480	4,165	8.68	0.00	0.00	bsa0wjtftg3uw		select file# from file$ where ...
221	221	1.00	0.00	0.00	2ym6hhaq30r73		select type#, blocks, extents,...
219	219	1.00	0.00	0.00	cb21bacyh3c7d		select metadata from kopm$ whe...
120	240	2.00	0.00	0.00	8p447s6p0rv6b		select java_pool_size_for_esti...
120	2,400	20.00	0.00	0.00	aykvshm7zsabd		select size_for_estimate, size...
110	110	1.00	0.00	0.00	5t10uu7v11s5t	sqlplus@DB_2 (TNS V1-V3)	BEGIN DBMS_OUTPUT.ENABLE(NULL)...
110	110	1.00	0.00	0.00	9babjv8yq8ru3	sqlplus@DB_2 (TNS V1-V3)	BEGIN DBMS_OUTPUT.GET_LINES(:L...
106	106	1.00	0.00	0.00	7fv62j26113x4	sqlplus@DB_2 (TNS V1-V3)	SELECT MIN(SNAP_ID) FROM DBA_H...
106	106	1.00	0.01	0.01	934ur8r7tqbjx	DBMS_SCHEDULER	SELECT DBID FROM V$DATABASE
106	106	1.00	0.00	0.00	9ngj2sw70fxra	sqlplus@DB_2 (TNS V1-V3)	SELECT MAX(SNAP_ID) FROM DBA_H...
106	106	1.00	0.00	0.00	avxj4t4gujr3p	sqlplus@DB_2 (TNS V1-V3)	SELECT INSTANCE_NUMBER FROM V$...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 8,590
Captured SQL account for 74.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
964	964	11.22	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
964	964	11.22	459f3z9u4fb3u		select value$ from props$ wher...
964	964	11.22	59ztnpf9xxy0c	racgmdb@DB_2 (TNS V1-V3)	BEGIN INSERT INTO LOGON_TABLE ...
964	964	11.22	bzxvnna751nvb	racgmdb@DB_2 (TNS V1-V3)	INSERT INTO LOGON_TABLE VALUES...
480	480	5.59	bsa0wjtftg3uw		select file# from file$ where ...
221	221	2.57	2ym6hhaq30r73		select type#, blocks, extents,...
219	219	2.55	cb21bacyh3c7d		select metadata from kopm$ whe...
110	110	1.28	5t10uu7v11s5t	sqlplus@DB_2 (TNS V1-V3)	BEGIN DBMS_OUTPUT.ENABLE(NULL)...
110	110	1.28	9babjv8yq8ru3	sqlplus@DB_2 (TNS V1-V3)	BEGIN DBMS_OUTPUT.GET_LINES(:L...
106	106	1.23	7fv62j26113x4	sqlplus@DB_2 (TNS V1-V3)	SELECT MIN(SNAP_ID) FROM DBA_H...
106	106	1.23	934ur8r7tqbjx	DBMS_SCHEDULER	SELECT DBID FROM V$DATABASE
106	106	1.23	9ngj2sw70fxra	sqlplus@DB_2 (TNS V1-V3)	SELECT MAX(SNAP_ID) FROM DBA_H...
106	106	1.23	avxj4t4gujr3p	sqlplus@DB_2 (TNS V1-V3)	SELECT INSTANCE_NUMBER FROM V$...

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

Cluster Wait Time (s)	CWT % of Elapsd Time	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Module	SQL Text
150.85	97.88	154.12	3.13	964	59ztnpf9xxy0c	racgmdb@DB_2 (TNS V1-V3)	BEGIN INSERT INTO LOGON_TABLE ...
150.85	98.37	153.35	2.32	964	bzxvnna751nvb	racgmdb@DB_2 (TNS V1-V3)	INSERT INTO LOGON_TABLE VALUES...
2.99	4.87	61.31	28.78	55	apx329443j0w6	sqlplus@DB_2 (TNS V1-V3)	select TABLESPACE_NAME, ROUND(...
1.19	19.29	6.19	5.14	54	2kh56ug11hvzb	sqlplus@DB_2 (TNS V1-V3)	SELECT wm_concat(TABLE_NAME\|\|'...
0.14	20.39	0.68	0.02	1	71k5024zn7c9a		insert into wrh$_latch_misses_...
0.12	9.81	1.24	1.02	1	84qubbrsr0kfn		insert into wrh$_latch (snap_i...
0.07	50.57	0.14	0.07	1	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
0.07	56.65	0.12	0.02	1	cv0wdp1w4g9c5		insert into wrh$_inst_cache_tr...
0.06	42.21	0.15	0.03	1	32wqka2zwvu65		insert into wrh$_parameter (sn...
0.05	42.44	0.12	0.06	1	agpd044zj368m		insert into wrh$_system_event ...
0.05	20.21	0.25	0.02	1	cp3gpd7z878w8		insert into wrh$_sgastat (snap...
0.04	3.98	1.12	1.10	54	6n68yz03y5tm4	sqlplus@DB_2 (TNS V1-V3)	SELECT wm_concat(TABLE_NAME\|\|'...
0.04	34.59	0.12	0.02	1	350myuyx0t1d6		insert into wrh$_tablespace_st...
0.04	29.64	0.14	0.01	1	1uym1vta995yb		insert into wrh$_rowcache_summ...
0.04	9.15	0.42	0.09	1	73tk9n05dzgdu		INSERT /*+ APPEND LEADING(@"SE...
0.02	76.98	0.03	0.01	1	31a13pnjps7j3		SELECT source, (case when time...
0.01	5.02	0.21	0.20	106	9ngj2sw70fxra	sqlplus@DB_2 (TNS V1-V3)	SELECT MAX(SNAP_ID) FROM DBA_H...
0.01	5.05	0.15	0.15	3	8mrg623amm8rx		select OBJOID, CLSOID, RUNTIME...
0.01	13.16	0.05	0.05	221	2ym6hhaq30r73		select type#, blocks, extents,...
0.01	23.08	0.02	0.02	68	g00cj285jmgsw		update sys.mon_mods$ set inser...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

04xtrk7uyhknh select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

0s07s16dca7m1 select STATUS from v$datafile

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

1uym1vta995yb insert into wrh$_rowcache_summary (snap_id, dbid, instance_number, parameter, total_usage, usage, gets, getmisses, scans, scanmisses, scancompletes, modifications, flushes, dlm_requests, dlm_conflicts, dlm_releases) select :snap_id, :dbid, :instance_number, parameter, sum("COUNT"), sum(usage), sum(gets), sum(getmisses), sum(scans), sum(scanmisses), sum(scancompletes), sum(modifications), sum(flushes), sum(dlm_requests), sum(dlm_conflicts), sum(dlm_releases) from v$rowcache group by parameter order by parameter

2kh56ug11hvzb SELECT wm_concat(TABLE_NAME||' '||SIZE_G||'G') FROM (SELECT ROWNUM RN, A.OWNER||'.'||TABLE_NAME TABLE_NAME, SIZE_G FROM (SELECT T.OWNER, T.TABLE_NAME, ROUND(S.BYTES/1024/1024/1024, 2) SIZE_G FROM DBA_SEGMENTS S, DBA_TABLES T WHERE S.OWNER=T.OWNER AND S.SEGMENT_NAME=T.TABLE_NAME AND S.SEGMENT_TYPE='TABLE' AND T.PARTITIONED='NO' AND S.PARTITION_NAME IS NULL AND S.BYTES > 20*1024*1024*1024 ORDER BY S.BYTES DESC) A) WHERE RN <= 10

2ym6hhaq30r73 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC

32wqka2zwvu65 insert into wrh$_parameter (snap_id, dbid, instance_number, parameter_hash, value, isdefault, ismodified) select :snap_id, :dbid, :instance_number, i.ksppihash hash, sv.ksppstvl, 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

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

3ujgs5s9hyu6p SELECT MAX(VALUE)-MIN(VALUE) DBTIME FROM DBA_HIST_SYS_TIME_MODEL WHERE DBID=3149139862 AND INSTANCE_NUMBER= 2 AND SNAP_ID IN( 8063, 8064) AND STAT_NAME='DB time'

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

59ztnpf9xxy0c BEGIN INSERT INTO LOGON_TABLE VALUES (SYS_CONTEXT('USERENV', 'SESSION_USER'), SYS_CONTEXT('USERENV', 'INSTANCE'), SYS_CONTEXT('USERENV', 'TERMINAL'), SYS_CONTEXT('USERENV', 'IP_ADDRESS'), SYS_CONTEXT('USERENV', 'HOST'), SYSDATE); COMMIT; END;

5t10uu7v11s5t BEGIN DBMS_OUTPUT.ENABLE(NULL); END;

6n68yz03y5tm4 SELECT wm_concat(TABLE_NAME||' '||NUM_ROWS) FROM (SELECT ROWNUM RN, OWNER||'.'||TABLE_NAME TABLE_NAME, NUM_ROWS FROM (SELECT OWNER, TABLE_NAME, NUM_ROWS, LAST_ANALYZED FROM DBA_TABLES WHERE PARTITIONED='NO' AND NUM_ROWS > 50000000 ORDER BY NUM_ROWS DESC) A) WHERE RN <= 10

71k5024zn7c9a insert into wrh$_latch_misses_summary (snap_id, dbid, instance_number, parent_name, where_in_code, nwfail_count, sleep_count, wtr_slp_count) select :snap_id, :dbid, :instance_number, parent_name, "WHERE", sum(nwfail_count), sum(sleep_count), sum(wtr_slp_count) from v$latch_misses where sleep_count > 0 group by parent_name, "WHERE" order by parent_name, "WHERE"

73tk9n05dzgdu INSERT /*+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id, machine, port, ecid ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id, a.machine, a.port, a.ecid FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)

7fv62j26113x4 SELECT MIN(SNAP_ID) FROM DBA_HIST_SNAPSHOT WHERE END_INTERVAL_TIME BETWEEN TRUNC(SYSDATE)-1+9/24 AND TRUNC(SYSDATE)-1+17/24 AND SNAP_ID< 8064 AND DBID=3149139862 AND INSTANCE_NUMBER= 2 AND STARTUP_TIME=(SELECT STARTUP_TIME FROM DBA_HIST_SNAPSHOT WHERE SNAP_ID= 8064 AND DBID=3149139862 AND INSTANCE_NUMBER= 2)

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

8kyvv5knwptbf select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))

8mrg623amm8rx select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) 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))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID

8p447s6p0rv6b select java_pool_size_for_estimate s, java_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$java_pool_advice

934ur8r7tqbjx SELECT DBID FROM V$DATABASE

9babjv8yq8ru3 BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;

9ngj2sw70fxra SELECT MAX(SNAP_ID) FROM DBA_HIST_SNAPSHOT WHERE END_INTERVAL_TIME BETWEEN TRUNC(SYSDATE)-1+9/24 AND TRUNC(SYSDATE)-1+17/24 AND DBID=3149139862 AND INSTANCE_NUMBER= 2

aczgxpjdr3dmv select status, type from v$logfile

agpd044zj368m insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro from v$system_event order by event_id

apx329443j0w6 select TABLESPACE_NAME, ROUND(used/total*100, 2) percent from (SELECT TABLESPACE_NAME, SUM(USED_SPACE) used, SUM(SUM_SPACE) total FROM((SELECT TABLESPACE_NAME, SUM(MAXBYTES) SUM_SPACE, SUM(USER_BYTES) USED_SPACE FROM DBA_DATA_FILES WHERE AUTOEXTENSIBLE='YES' GROUP BY TABLESPACE_NAME) UNION ALL (SELECT D.TABLESPACE_NAME TABLESPACE_NAME, SPACE SUM_SPACE, SPACE - NVL(FREE_SPACE, 0) USED_SPACE FROM (SELECT FILE_ID, TABLESPACE_NAME, SUM(bytes) SPACE FROM DBA_DATA_FILES WHERE AUTOEXTENSIBLE='NO' GROUP BY FILE_ID, TABLESPACE_NAME) D, (SELECT FILE_ID, TABLESPACE_NAME, SUM(BYTES) FREE_SPACE FROM DBA_FREE_SPACE where FILE_ID in (select file_id from DBA_DATA_FILES where AUTOEXTENSIBLE='NO' and bytes > 3000000000 ) GROUP BY FILE_ID, TABLESPACE_NAME) F WHERE D.FILE_ID = F.FILE_ID(+))) GROUP BY TABLESPACE_NAME)a where a.used/a.total*100>80

avxj4t4gujr3p SELECT INSTANCE_NUMBER FROM V$INSTANCE

aykvshm7zsabd select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'

bsa0wjtftg3uw select file# from file$ where ts#=:1

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

bzxvnna751nvb INSERT INTO LOGON_TABLE VALUES (SYS_CONTEXT('USERENV', 'SESSION_USER'), SYS_CONTEXT('USERENV', 'INSTANCE'), SYS_CONTEXT('USERENV', 'TERMINAL'), SYS_CONTEXT('USERENV', 'IP_ADDRESS'), SYS_CONTEXT('USERENV', 'HOST'), SYSDATE)

cb21bacyh3c7d select metadata from kopm$ where name='DB_FDO'

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

cv0wdp1w4g9c5 insert into wrh$_inst_cache_transfer (snap_id, dbid, instance_number, instance, class, cr_block, cr_busy, cr_congested, current_block, current_busy, current_congested) select :snap_id, :dbid, :instance_number, instance, class, sum(cr_block), sum(cr_busy), sum(cr_congested), sum(current_block), sum(current_busy), sum(current_congested)from (select instance, case when class in ('data block', 'undo header', 'undo block') then class else 'Others' end as class, cr_block, cr_busy, cr_congested, current_block, current_busy, current_congested from v$instance_cache_transfer where ((cr_block + cr_busy + cr_congested + current_block + current_busy + current_congested) > 0)) group by instance, class

d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;

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

gczdtkrqtcbbh SELECT MAX(VALUE)-MIN(VALUE) CPUTIME FROM DBA_HIST_SYS_TIME_MODEL WHERE DBID=3149139862 AND INSTANCE_NUMBER= 2 AND SNAP_ID IN( 8063, 8064) AND STAT_NAME='DB CPU'

SQL Id	SQL Text
04xtrk7uyhknh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0s07s16dca7m1	select STATUS from v$datafile
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')
1uym1vta995yb	insert into wrh$_rowcache_summary (snap_id, dbid, instance_number, parameter, total_usage, usage, gets, getmisses, scans, scanmisses, scancompletes, modifications, flushes, dlm_requests, dlm_conflicts, dlm_releases) select :snap_id, :dbid, :instance_number, parameter, sum("COUNT"), sum(usage), sum(gets), sum(getmisses), sum(scans), sum(scanmisses), sum(scancompletes), sum(modifications), sum(flushes), sum(dlm_requests), sum(dlm_conflicts), sum(dlm_releases) from v$rowcache group by parameter order by parameter
2kh56ug11hvzb	SELECT wm_concat(TABLE_NAME\|\|' '\|\|SIZE_G\|\|'G') FROM (SELECT ROWNUM RN, A.OWNER\|\|'.'\|\|TABLE_NAME TABLE_NAME, SIZE_G FROM (SELECT T.OWNER, T.TABLE_NAME, ROUND(S.BYTES/1024/1024/1024, 2) SIZE_G FROM DBA_SEGMENTS S, DBA_TABLES T WHERE S.OWNER=T.OWNER AND S.SEGMENT_NAME=T.TABLE_NAME AND S.SEGMENT_TYPE='TABLE' AND T.PARTITIONED='NO' AND S.PARTITION_NAME IS NULL AND S.BYTES > 2010241024*1024 ORDER BY S.BYTES DESC) A) WHERE RN <= 10
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
31a13pnjps7j3	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
32wqka2zwvu65	insert into wrh$_parameter (snap_id, dbid, instance_number, parameter_hash, value, isdefault, ismodified) select :snap_id, :dbid, :instance_number, i.ksppihash hash, sv.ksppstvl, 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
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
3ujgs5s9hyu6p	SELECT MAX(VALUE)-MIN(VALUE) DBTIME FROM DBA_HIST_SYS_TIME_MODEL WHERE DBID=3149139862 AND INSTANCE_NUMBER= 2 AND SNAP_ID IN( 8063, 8064) AND STAT_NAME='DB time'
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
59ztnpf9xxy0c	BEGIN INSERT INTO LOGON_TABLE VALUES (SYS_CONTEXT('USERENV', 'SESSION_USER'), SYS_CONTEXT('USERENV', 'INSTANCE'), SYS_CONTEXT('USERENV', 'TERMINAL'), SYS_CONTEXT('USERENV', 'IP_ADDRESS'), SYS_CONTEXT('USERENV', 'HOST'), SYSDATE); COMMIT; END;
5t10uu7v11s5t	BEGIN DBMS_OUTPUT.ENABLE(NULL); END;
6n68yz03y5tm4	SELECT wm_concat(TABLE_NAME\|\|' '\|\|NUM_ROWS) FROM (SELECT ROWNUM RN, OWNER\|\|'.'\|\|TABLE_NAME TABLE_NAME, NUM_ROWS FROM (SELECT OWNER, TABLE_NAME, NUM_ROWS, LAST_ANALYZED FROM DBA_TABLES WHERE PARTITIONED='NO' AND NUM_ROWS > 50000000 ORDER BY NUM_ROWS DESC) A) WHERE RN <= 10
71k5024zn7c9a	insert into wrh$_latch_misses_summary (snap_id, dbid, instance_number, parent_name, where_in_code, nwfail_count, sleep_count, wtr_slp_count) select :snap_id, :dbid, :instance_number, parent_name, "WHERE", sum(nwfail_count), sum(sleep_count), sum(wtr_slp_count) from v$latch_misses where sleep_count > 0 group by parent_name, "WHERE" order by parent_name, "WHERE"
73tk9n05dzgdu	INSERT /+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") / INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id, machine, port, ecid ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id, a.machine, a.port, a.ecid FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
7fv62j26113x4	SELECT MIN(SNAP_ID) FROM DBA_HIST_SNAPSHOT WHERE END_INTERVAL_TIME BETWEEN TRUNC(SYSDATE)-1+9/24 AND TRUNC(SYSDATE)-1+17/24 AND SNAP_ID< 8064 AND DBID=3149139862 AND INSTANCE_NUMBER= 2 AND STARTUP_TIME=(SELECT STARTUP_TIME FROM DBA_HIST_SNAPSHOT WHERE SNAP_ID= 8064 AND DBID=3149139862 AND INSTANCE_NUMBER= 2)
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
8kyvv5knwptbf	select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))
8mrg623amm8rx	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) 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))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
8p447s6p0rv6b	select java_pool_size_for_estimate s, java_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$java_pool_advice
934ur8r7tqbjx	SELECT DBID FROM V$DATABASE
9babjv8yq8ru3	BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;
9ngj2sw70fxra	SELECT MAX(SNAP_ID) FROM DBA_HIST_SNAPSHOT WHERE END_INTERVAL_TIME BETWEEN TRUNC(SYSDATE)-1+9/24 AND TRUNC(SYSDATE)-1+17/24 AND DBID=3149139862 AND INSTANCE_NUMBER= 2
aczgxpjdr3dmv	select status, type from v$logfile
agpd044zj368m	insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro from v$system_event order by event_id
apx329443j0w6	select TABLESPACE_NAME, ROUND(used/total100, 2) percent from (SELECT TABLESPACE_NAME, SUM(USED_SPACE) used, SUM(SUM_SPACE) total FROM((SELECT TABLESPACE_NAME, SUM(MAXBYTES) SUM_SPACE, SUM(USER_BYTES) USED_SPACE FROM DBA_DATA_FILES WHERE AUTOEXTENSIBLE='YES' GROUP BY TABLESPACE_NAME) UNION ALL (SELECT D.TABLESPACE_NAME TABLESPACE_NAME, SPACE SUM_SPACE, SPACE - NVL(FREE_SPACE, 0) USED_SPACE FROM (SELECT FILE_ID, TABLESPACE_NAME, SUM(bytes) SPACE FROM DBA_DATA_FILES WHERE AUTOEXTENSIBLE='NO' GROUP BY FILE_ID, TABLESPACE_NAME) D, (SELECT FILE_ID, TABLESPACE_NAME, SUM(BYTES) FREE_SPACE FROM DBA_FREE_SPACE where FILE_ID in (select file_id from DBA_DATA_FILES where AUTOEXTENSIBLE='NO' and bytes > 3000000000 ) GROUP BY FILE_ID, TABLESPACE_NAME) F WHERE D.FILE_ID = F.FILE_ID(+))) GROUP BY TABLESPACE_NAME)a where a.used/a.total100>80
avxj4t4gujr3p	SELECT INSTANCE_NUMBER FROM V$INSTANCE
aykvshm7zsabd	select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
bsa0wjtftg3uw	select file# from file$ where ts#=:1
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
bzxvnna751nvb	INSERT INTO LOGON_TABLE VALUES (SYS_CONTEXT('USERENV', 'SESSION_USER'), SYS_CONTEXT('USERENV', 'INSTANCE'), SYS_CONTEXT('USERENV', 'TERMINAL'), SYS_CONTEXT('USERENV', 'IP_ADDRESS'), SYS_CONTEXT('USERENV', 'HOST'), SYSDATE)
cb21bacyh3c7d	select metadata from kopm$ where name='DB_FDO'
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
cv0wdp1w4g9c5	insert into wrh$_inst_cache_transfer (snap_id, dbid, instance_number, instance, class, cr_block, cr_busy, cr_congested, current_block, current_busy, current_congested) select :snap_id, :dbid, :instance_number, instance, class, sum(cr_block), sum(cr_busy), sum(cr_congested), sum(current_block), sum(current_busy), sum(current_congested)from (select instance, case when class in ('data block', 'undo header', 'undo block') then class else 'Others' end as class, cr_block, cr_busy, cr_congested, current_block, current_busy, current_congested from v$instance_cache_transfer where ((cr_block + cr_busy + cr_congested + current_block + current_busy + current_congested) > 0)) group by instance, class
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
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
gczdtkrqtcbbh	SELECT MAX(VALUE)-MIN(VALUE) CPUTIME FROM DBA_HIST_SYS_TIME_MODEL WHERE DBID=3149139862 AND INSTANCE_NUMBER= 2 AND SNAP_ID IN( 8063, 8064) AND STAT_NAME='DB CPU'

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
CPU used by this session	6,124	1.70	5.90
CPU used when call started	5,831	1.62	5.62
CR blocks created	33	0.01	0.03
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	46,971	13.02	45.25
DBWR checkpoint buffers written	553	0.15	0.53
DBWR checkpoints	76	0.02	0.07
DBWR fusion writes	126	0.03	0.12
DBWR thread checkpoint buffers written	197	0.05	0.19
DBWR transaction table writes	134	0.04	0.13
DBWR undo block writes	205	0.06	0.20
DFO trees parallelized	72	0.02	0.07
PX local messages recv'd	390	0.11	0.38
PX local messages sent	390	0.11	0.38
PX remote messages recv'd	186	0.05	0.18
PX remote messages sent	306	0.08	0.29
Parallel operations not downgraded	72	0.02	0.07
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	6,541	1.81	6.30
active txn count during cleanout	168	0.05	0.16
application wait time	23	0.01	0.02
background checkpoints completed	70	0.02	0.07
background checkpoints started	70	0.02	0.07
background timeouts	17,533	4.86	16.89
buffer is not pinned count	609,682	169.04	587.36
buffer is pinned count	813,599	225.57	783.81
bytes received via SQL*Net from client	659,017	182.71	634.89
bytes sent via SQL*Net to client	2,310,542	640.61	2,225.96
calls to get snapshot scn: kcmgss	581,666	161.27	560.37
calls to kcmgas	4,643	1.29	4.47
calls to kcmgcs	451	0.13	0.43
change write time	34	0.01	0.03
cleanout - number of ktugct calls	351	0.10	0.34
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	26	0.01	0.03
cluster key scan block gets	303,952	84.27	292.82
cluster key scans	203,993	56.56	196.53
cluster wait time	367,933	102.01	354.46
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: block lost	8	0.00	0.01
commit cleanout failures: callback failure	2	0.00	0.00
commit cleanout failures: cannot pin	225	0.06	0.22
commit cleanouts	1,364	0.38	1.31
commit cleanouts successfully completed	1,129	0.31	1.09
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	274	0.08	0.26
concurrency wait time	70	0.02	0.07
consistent changes	34	0.01	0.03
consistent gets	1,780,820	493.74	1,715.63
consistent gets - examination	335,094	92.91	322.83
consistent gets direct	2	0.00	0.00
consistent gets from cache	1,780,818	493.74	1,715.62
cursor authentications	15	0.00	0.01
data blocks consistent reads - undo records applied	12	0.00	0.01
db block changes	7,170	1.99	6.91
db block gets	51,088	14.16	49.22
db block gets direct	14	0.00	0.01
db block gets from cache	51,074	14.16	49.20
deferred (CURRENT) block cleanout applications	711	0.20	0.68
enqueue conversions	1,504	0.42	1.45
enqueue releases	113,219	31.39	109.07
enqueue requests	113,225	31.39	109.08
enqueue timeouts	6	0.00	0.01
enqueue waits	803	0.22	0.77
exchange deadlocks	0	0.00	0.00
execute count	8,798	2.44	8.48
free buffer inspected	0	0.00	0.00
free buffer requested	68,276	18.93	65.78
gc CPU used by this session	1,079	0.30	1.04
gc blocks lost	4,045	1.12	3.90
gc cr block build time	2	0.00	0.00
gc cr block flush time	2	0.00	0.00
gc cr block receive time	138	0.04	0.13
gc cr block send time	1	0.00	0.00
gc cr blocks received	557	0.15	0.54
gc cr blocks served	540	0.15	0.52
gc current block flush time	94	0.03	0.09
gc current block pin time	702	0.19	0.68
gc current block receive time	8,040	2.23	7.75
gc current block send time	4	0.00	0.00
gc current blocks received	8,146	2.26	7.85
gc current blocks served	888	0.25	0.86
gc local grants	0	0.00	0.00
gc remote grants	948	0.26	0.91
gcs messages sent	62,600	17.36	60.31
ges messages sent	3,146	0.87	3.03
global enqueue get time	533	0.15	0.51
global enqueue gets async	268	0.07	0.26
global enqueue gets sync	6,395	1.77	6.16
global enqueue releases	5,720	1.59	5.51
heap block compress	12	0.00	0.01
hot buffers moved to head of LRU	6	0.00	0.01
immediate (CR) block cleanout applications	26	0.01	0.03
immediate (CURRENT) block cleanout applications	72	0.02	0.07
index crx upgrade (positioned)	2,889	0.80	2.78
index fast full scans (full)	0	0.00	0.00
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	450,428	124.88	433.94
index scans kdiixs1	3,612	1.00	3.48
leaf node 90-10 splits	11	0.00	0.01
leaf node splits	16	0.00	0.02
lob reads	0	0.00	0.00
lob writes	6	0.00	0.01
lob writes unaligned	6	0.00	0.01
logons cumulative	1,056	0.29	1.02
messages received	3,594	1.00	3.46
messages sent	3,594	1.00	3.46
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	867,361	240.48	835.61
opened cursors cumulative	8,691	2.41	8.37
parse count (failures)	0	0.00	0.00
parse count (hard)	1	0.00	0.00
parse count (total)	8,590	2.38	8.28
parse time cpu	63	0.02	0.06
parse time elapsed	73	0.02	0.07
physical read IO requests	3,313	0.92	3.19
physical read bytes	27,213,824	7,545.13	26,217.56
physical read total IO requests	271,769	75.35	261.82
physical read total bytes	4,387,890,176	1,216,557.74	4,227,254.50
physical read total multi block requests	66	0.02	0.06
physical reads	3,322	0.92	3.20
physical reads cache	320	0.09	0.31
physical reads cache prefetch	49	0.01	0.05
physical reads direct	3,002	0.83	2.89
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	49	0.01	0.05
physical write IO requests	2,099	0.58	2.02
physical write bytes	17,997,824	4,989.96	17,338.94
physical write total IO requests	9,261	2.57	8.92
physical write total bytes	114,914,816	31,860.53	110,707.92
physical write total multi block requests	1,009	0.28	0.97
physical writes	2,197	0.61	2.12
physical writes direct	1,519	0.42	1.46
physical writes direct (lob)	2	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	678	0.19	0.65
physical writes non checkpoint	1,785	0.49	1.72
pinned buffers inspected	0	0.00	0.00
pinned cursors current	0	0.00	0.00
prefetch warmup blocks flushed out before use	2	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	0	0.00	0.00
queries parallelized	72	0.02	0.07
recursive calls	61,379	17.02	59.13
recursive cpu usage	860	0.24	0.83
redo blocks written	4,357	1.21	4.20
redo buffer allocation retries	2	0.00	0.00
redo entries	4,297	1.19	4.14
redo log space requests	3	0.00	0.00
redo log space wait time	49	0.01	0.05
redo ordering marks	67	0.02	0.06
redo size	1,677,336	465.05	1,615.93
redo subscn max counts	91	0.03	0.09
redo synch time	556	0.15	0.54
redo synch writes	966	0.27	0.93
redo wastage	469,512	130.17	452.32
redo write broadcast ack time	90	0.02	0.09
redo write time	553	0.15	0.53
redo writer latching time	1	0.00	0.00
redo writes	1,301	0.36	1.25
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	12	0.00	0.01
rows fetched via callback	117,180	32.49	112.89
session connect time	0	0.00	0.00
session cursor cache hits	922	0.26	0.89
session logical reads	1,831,908	507.90	1,764.84
shared hash latch upgrades - no wait	3,071	0.85	2.96
sorts (disk)	0	0.00	0.00
sorts (memory)	9,912	2.75	9.55
sorts (rows)	311,289	86.31	299.89
sql area evicted	21	0.01	0.02
sql area purged	0	0.00	0.00
switch current to new buffer	4	0.00	0.00
table fetch by rowid	149,524	41.46	144.05
table fetch continued row	0	0.00	0.00
table scan blocks gotten	511,504	141.82	492.78
table scan rows gotten	30,717,629	8,516.57	29,593.09
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	286,053	79.31	275.58
total number of times SMON posted	18	0.00	0.02
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	448,380	124.31	431.97
user I/O wait time	1,329	0.37	1.28
user calls	9,975	2.77	9.61
user commits	972	0.27	0.94
user rollbacks	66	0.02	0.06
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	9,679	2.68	9.32

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	57,129,598,528	57,427,112,800
session cursor cache count	63,315	70,752
session uga memory	5,147,398,528	5,178,218,928
opened cursors current	84	84
workarea memory allocated	265	265
logons current	38	38
session uga memory max	10,076,943,832	10,842,777,760
session pga memory	35,411,196,160	35,564,138,016

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)	70	69.87

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
TS_REPORT_DATA	2,566	1	0.67	1.00	1,079	0	0.00
TS_REPORT_INDEX	312	0	0.00	1.00	160	0	0.00
TS_PORTAL_XM_BAK_DATA	228	0	0.00	1.00	152	0	0.00
UNDOTBS2	19	0	0.00	1.00	299	1	0.00
SYSAUX	50	0	4.80	1.16	266	1	0.00
SYSTEM	43	0	0.00	1.00	105	437	233.71
UNDOTBS1	19	0	0.00	1.00	19	0	0.00
USERS	19	0	0.00	1.00	19	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
SYSAUX	+DATANEW/clouddbs/datafile/sysaux.260.780318995	50	4.80	1.16	266	1	0.00
SYSTEM	+DATANEW/clouddbs/datafile/system.263.780319091	24	0.00	1.00	80	437	233.71
SYSTEM	+DATANEW/clouddbs/datafile/system_001.dbf	19	0.00	1.00	25	0	0.00
TS_PORTAL_XM_BAK_DATA	+DATANEW/clouddbs/datafile/ts_portal_xm_bak_data_001.dbf	19	0.00	1.00	19	0	0.00
TS_PORTAL_XM_BAK_DATA	+DATANEW/clouddbs/datafile/ts_portal_xm_bak_data_002.dbf	19	0.00	1.00	19	0	0.00
TS_PORTAL_XM_BAK_DATA	+DATANEW/clouddbs/datafile/ts_portal_xm_bak_data_003.dbf	19	0.00	1.00	19	0	0.00
TS_PORTAL_XM_BAK_DATA	+DATANEW/clouddbs/datafile/ts_portal_xm_bak_data_004.dbf	19	0.00	1.00	19	0	0.00
TS_PORTAL_XM_BAK_DATA	+DATANEW/clouddbs/datafile/ts_portal_xm_bak_data_005.dbf	38	0.00	1.00	19	0	0.00
TS_PORTAL_XM_BAK_DATA	+DATANEW/clouddbs/datafile/ts_portal_xm_bak_data_006.dbf	38	0.00	1.00	19	0	0.00
TS_PORTAL_XM_BAK_DATA	+DATANEW/clouddbs/datafile/ts_portal_xm_bak_data_007.dbf	38	0.00	1.00	19	0	0.00
TS_PORTAL_XM_BAK_DATA	+DATANEW/clouddbs/datafile/ts_portal_xm_bak_data_008.dbf	38	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data.1307.782937765	19	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data.362.782937845	19	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data.366.782937877	74	3.51	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_001.dbf	19	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_002.dbf	19	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_003.dbf	19	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_004.dbf	38	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_005.dbf	38	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_006.dbf	38	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_007.dbf	93	3.33	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_008.dbf	38	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_009.dbf	38	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_010.dbf	38	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_011.dbf	38	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_012.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_013.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_014.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_015.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_016.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_017.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_018.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_019.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_020.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_021.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_022.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_023.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_024.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_025.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_026.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_027.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_028.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_029.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_030.dbf	52	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_031.dbf	52	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_032.dbf	52	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_033.dbf	52	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_034.dbf	52	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_035.dbf	107	4.11	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_036.dbf	52	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_037.dbf	52	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_038.dbf	52	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_039.dbf	52	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_040.dbf	52	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_041.dbf	52	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_042.dbf	52	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_043.dbf	52	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_044.dbf	19	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_045.dbf	38	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_046.dbf	38	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_047.dbf	93	7.63	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_048.dbf	38	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_data_049.dbf	38	0.00	1.00	19	0	0.00
TS_REPORT_DATA	+DATANEW/clouddbs/datafile/ts_report_index_001.dbf	19	0.00	1.00	19	0	0.00
TS_REPORT_INDEX	+DATANEW/clouddbs/datafile/ts_report_index.359.782937897	19	0.00	1.00	19	0	0.00
TS_REPORT_INDEX	+DATANEW/clouddbs/datafile/ts_report_index_002.dbf	19	0.00	1.00	19	0	0.00
TS_REPORT_INDEX	+DATANEW/clouddbs/datafile/ts_report_index_003.dbf	38	0.00	1.00	19	0	0.00
TS_REPORT_INDEX	+DATANEW/clouddbs/datafile/ts_report_index_004.dbf	38	0.00	1.00	19	0	0.00
TS_REPORT_INDEX	+DATANEW/clouddbs/datafile/ts_report_index_005.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_INDEX	+DATANEW/clouddbs/datafile/ts_report_index_006.dbf	54	0.00	1.00	23	0	0.00
TS_REPORT_INDEX	+DATANEW/clouddbs/datafile/ts_report_index_007.dbf	52	0.00	1.00	19	0	0.00
TS_REPORT_INDEX	+DATANEW/clouddbs/datafile/ts_report_index_008.dbf	38	0.00	1.00	19	0	0.00
UNDOTBS1	+DATANEW/clouddbs/datafile/undotbs1.265.780319109	19	0.00	1.00	19	0	0.00
UNDOTBS2	+DATANEW/clouddbs/datafile/undotbs2.264.780319105	19	0.00	1.00	299	1	0.00
USERS	+DATANEW/clouddbs/datafile/users.266.780319111	19	0.00	1.00	19	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	3,623,130	100	1,831,641	305	678	0	0	439

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	172	944	872	184320	872
E	0	0	247	1021	184320	184320

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	3,024	0.10	362,313	1.04	480,217
D	6,048	0.20	724,626	1.01	464,133
D	9,072	0.30	1,086,939	1.00	463,227
D	12,096	0.40	1,449,252	1.00	461,248
D	15,120	0.50	1,811,565	1.00	461,248
D	18,144	0.60	2,173,878	1.00	461,248
D	21,168	0.70	2,536,191	1.00	461,248
D	24,192	0.80	2,898,504	1.00	461,248
D	27,216	0.90	3,260,817	1.00	461,248
D	30,240	1.00	3,623,130	1.00	461,248
D	33,264	1.10	3,985,443	1.00	461,248
D	36,288	1.20	4,347,756	1.00	461,248
D	39,312	1.30	4,710,069	1.00	461,248
D	42,336	1.40	5,072,382	1.00	461,248
D	45,360	1.50	5,434,695	1.00	461,248
D	48,384	1.60	5,797,008	1.00	461,248
D	51,408	1.70	6,159,321	1.00	461,248
D	54,432	1.80	6,521,634	1.00	461,248
D	57,456	1.90	6,883,947	1.00	461,248
D	60,480	2.00	7,246,260	1.00	461,184

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	447	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	12,288	10,898	559.45	0.26	0.05	0.00	100.00	1,048,576
E	12,288	10,896	561.51	0.26	0.05	0.00	100.00	1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	9,171	9,171
64K	128K	3	3
256K	512K	2	2
512K	1024K	445	445
1M	2M	58	58

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 %
1,536	0.13	5,953.55	342.62	95.00
3,072	0.25	5,953.55	342.62	95.00
6,144	0.50	5,953.55	342.62	95.00
9,216	0.75	5,953.55	342.62	95.00
12,288	1.00	5,953.55	342.62	95.00
14,746	1.20	5,953.55	0.00	100.00
17,203	1.40	5,953.55	0.00	100.00
19,661	1.60	5,953.55	0.00	100.00
22,118	1.80	5,953.55	0.00	100.00
24,576	2.00	5,953.55	0.00	100.00
36,864	3.00	5,953.55	0.00	100.00
49,152	4.00	5,953.55	0.00	100.00
73,728	6.00	5,953.55	0.00	100.00
98,304	8.00	5,953.55	0.00	100.00

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)
2,224	0.90	86	6,357	3,719	1.00	84	1.00	238
2,480	1.00	86	6,357	3,719	1.00	84	1.00	238
2,736	1.10	86	6,357	3,719	1.00	84	1.00	238
2,992	1.21	86	6,357	3,719	1.00	84	1.00	238
3,248	1.31	86	6,357	3,719	1.00	84	1.00	238
3,504	1.41	86	6,357	3,719	1.00	84	1.00	238
3,760	1.52	86	6,357	3,719	1.00	84	1.00	238
4,016	1.62	86	6,357	3,719	1.00	84	1.00	238
4,272	1.72	86	6,357	3,719	1.00	84	1.00	238
4,528	1.83	86	6,357	3,719	1.00	84	1.00	238
4,784	1.93	86	6,357	3,719	1.00	84	1.00	238
5,040	2.03	86	6,357	3,719	1.00	84	1.00	238

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
8,192	0.25	4,545	464,085
16,384	0.50	4,534	461,180
24,576	0.75	4,534	461,180
32,768	1.00	4,534	461,180
40,960	1.25	4,534	461,180
49,152	1.50	4,534	461,180
57,344	1.75	4,534	461,180
65,536	2.00	4,534	461,134

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)
16	1.00	0	0	0	0
32	2.00	0	0	0	0
48	3.00	0	0	0	0
64	4.00	0	0	0	0
80	5.00	0	0	0	0
96	6.00	0	0	0	0
112	7.00	0	0	0	0
128	8.00	0	0	0	0
144	9.00	0	0	0	0
160	10.00	0	0	0	0
176	11.00	0	0	0	0
192	12.00	0	0	0	0
208	13.00	0	0	0	0
224	14.00	0	0	0	0
240	15.00	0	0	0	0
256	16.00	0	0	0	0
272	17.00	0	0	0	0
288	18.00	0	0	0	0
304	19.00	0	0	0	0
320	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

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	438	102	233
undo header	1	0	0

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)
WF-AWR Flush	19	19	0	19	2	116.84
CF-Controlfile Transaction	73,803	73,798	5	284	2	6.94
TM-DML	1,198	1,198	0	118	0	2.12
PS-PX Process Reservation	492	492	0	222	0	0.63
WL-Being Written Redo Log	70	70	0	70	0	0.71
HW-Segment High Water Mark	174	174	0	19	0	1.58
RO-Multiple Object Reuse (fast object reuse)	24	24	0	12	0	0.83
TD-KTF map table enqueue (KTF dump entries)	7	7	0	7	0	1.43
JS-Job Scheduler (job run lock - synchronize)	3	3	0	3	0	3.33
TA-Instance Undo	12	12	0	12	0	0.00
FB-Format Block	4	4	0	4	0	0.00
DR-Distributed Recovery	2	2	0	2	0	0.00
MW-MWIN Schedule	2	2	0	2	0	0.00
AF-Advisor Framework (task serialization)	7	7	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
5	0.12	1,257	0	4	15/68.4	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 Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
19-Nov 10:08	50	134	4	68	0/0	0/0/0/0/0/0
19-Nov 09:58	3	170	2	58	0/0	0/0/0/0/0/0
19-Nov 09:48	3	164	3	48	0/0	0/0/0/0/0/0
19-Nov 09:38	3	185	2	15	0/0	0/0/0/0/0/0
19-Nov 09:28	3	167	2	15	0/0	0/0/0/0/0/0
19-Nov 09:18	5	245	2	53	0/0	0/0/0/0/0/0
19-Nov 09:08	50	192	4	43	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
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 allocation	2,240	0.00		0
ASM db client latch	2,497	0.00		0
ASM map headers	1,750	0.00		0
ASM map load waiting list	210	0.00		0
ASM map operation freelist	1,106	0.27	0.00	0
ASM map operation hash table	1,287,081	0.01	0.12	0
ASM network background latch	3,647	0.00		0
AWR Alerted Metric Element list	16,928	0.00		0
Consistent RBA	1,355	0.00		0
FAL request queue	212	0.00		0
FAL subheap alocation	212	0.00		0
FIB s.o chain latch	420	0.00		0
FOB s.o list latch	15,041	0.03	0.00	0
JS broadcast add buf latch	827	0.00		0
JS broadcast drop buf latch	827	0.00		0
JS broadcast load blnc latch	718	0.00		0
JS mem alloc latch	5	0.00		0
JS queue access latch	5	0.00		0
JS queue state obj latch	26,114	0.00		0
JS slv state obj latch	6	0.00		0
KCL gc element parent latch	187,421	0.03	0.00	3,793	0.00
KFK SGA context latch	1,996	0.00		0
KFMD SGA	1,314	0.76	0.00	0
KJC message pool free list	32,866	0.18	0.00	1,249	0.16
KJCT flow control latch	101,161	0.08	0.00	0
KMG MMAN ready and startup request latch	1,203	0.00		0
KTF sga latch	14	0.00		1,054	0.00
KWQMN job cache list latch	270	0.00		0
KWQP Prop Status	2	0.00		0
MQL Tracking Latch	0			72	0.00
Memory Management Latch	0			1,203	0.00
OS process	2,994	0.00		0
OS process allocation	3,197	0.00		0
OS process: request allocation	1,951	0.00		0
PL/SQL warning settings	2,241	0.00		0
SGA IO buffer pool latch	28	0.00		28	0.00
SQL memory manager latch	1	0.00		1,198	0.00
SQL memory manager workarea list latch	82,153	0.00		0
Shared B-Tree	131	0.00		0
active checkpoint queue latch	5,951	0.29	0.00	0
active service list	11,745	0.02	0.00	1,865	0.00
alert log latch	140	0.00		0
archive control	436	0.00		0
archive process latch	1,762	0.00		0
begin backup scn array	3	0.00		0
business card	144	0.00		0
cache buffer handles	442	0.00		0
cache buffers chains	4,748,642	0.01	0.13	71,457	0.00
cache buffers lru chain	69,978	0.00		497,141	0.00
channel handle pool latch	1,963	0.00		0
channel operations parent latch	125,949	0.01	0.00	0
checkpoint queue latch	403,829	0.00		1,176	0.00
client/application info	5,158	0.00		0
compile environment latch	1,056	0.00		0
dml lock allocation	2,473	0.00		0
dummy allocation	2,112	0.00		0
enqueue hash chains	236,674	0.00	0.00	3,811	0.00
enqueues	224,840	0.00	0.00	0
error message lists	348	0.00		0
event group latch	975	0.00		0
file cache latch	1,089	0.00		0
gcs resource hash	56,079	0.00		0
ges caches resource lists	5,102	0.02	0.00	72,615	0.00
ges deadlock list	20	0.00		0
ges domain table	11,440	0.00		0
ges enqueue table freelist	11,840	0.00		0
ges group table	16,696	0.00		0
ges process hash list	6,607	0.00		0
ges process parent latch	26,648	0.00		0
ges process table freelist	1,953	0.00		0
ges resource hash list	19,517	0.05	0.33	795	4.15
ges resource scan list	10	0.00		0
ges resource table freelist	847	0.00		0
ges timeout list	844	0.00		395	0.00
hash table column usage latch	89	0.00		39	0.00
hash table modification latch	58	0.00		0
interrupt manipulation	600	0.00		0
job workq parent latch	0			6	0.00
job_queue_processes parameter latch	63	0.00		0
kks stats	10	0.00		0
kokc descriptor allocation latch	4	0.00		0
ksuosstats global area	243	0.00		0
ktm global data	18	0.00		0
kwqbsn:qsga	130	0.00		0
lgwr LWN SCN	2,204	0.05	0.00	0
library cache	44,575	0.08	0.00	69	0.00
library cache lock	63,657	0.01	0.00	0
library cache lock allocation	2,765	0.00		0
library cache pin	10,429	0.01	0.00	0
library cache pin allocation	2	0.00		0
list of block allocation	1,949	0.05	0.00	0
loader state object freelist	974	0.00		0
logminer context allocation	1	0.00		0
longop free list parent	1,271	0.00		0
message pool operations parent latch	1,028	0.00		0
messages	195,552	0.03	0.00	0
mostly latch-free SCN	2,207	0.00		0
msg queue	420	0.00		420	0.00
multiblock read objects	8,790	0.00		0
name-service memory objects	5,804	0.00		0
name-service namespace bucket	72,908	0.00		0
name-service pending queue	1,294	0.00		0
name-service request queue	72,831	0.00		0
ncodef allocation latch	77	0.00		0
object queue header heap	23,110	0.00		323	0.00
object queue header operation	585,432	0.00		0
object stats modification	16	0.00		0
parallel query alloc buffer	1,920	0.00		0
parallel query stats	294	0.00		0
parallel txn reco latch	528	0.00		0
parameter list	38	0.00		0
parameter table management	2,113	0.00		0
post/wait queue	2,161	0.09	0.00	1,092	0.00
process allocation	71,376	0.07	0.89	969	0.62
process group creation	1,951	0.00		0
process queue	780	0.00		0
process queue reference	13,652	0.00		1,272	0.00
qmn task queue latch	512	0.00		0
query server freelists	648	0.00		0
queued dump request	18,024	0.00		0
redo allocation	6,347	0.36	0.04	4,066	0.47
redo copy	0			4,075	5.69
redo writing	12,295	0.05	0.00	0
resmgr group change latch	2,066	0.00		0
resmgr:active threads	2,097	0.00		0
resmgr:actses change group	1,042	0.00		0
resmgr:free threads list	2,096	0.10	0.00	0
resmgr:resource group CPU method	1,042	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	75,815	0.00	0.00	122	0.00
rules engine rule set statistics	100	0.00		0
segmented array pool	420	0.00		0
sequence cache	9	0.00		0
session allocation	14,885	0.89	0.40	0
session idle bit	24,192	0.00		0
session state list latch	2,116	0.00		0
session switching	4,957	0.00		0
session timer	1,271	0.00		0
shared pool	32,239	0.04	0.00	0
shared pool simulator	58	0.00		0
simulator hash latch	94,142	0.00		0
simulator lru latch	0			94,124	0.01
slave class	2,108	0.00		0
slave class create	2,103	0.05	1.00	0
sort extent pool	131	0.00		0
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
threshold alerts latch	166	0.00		0
transaction allocation	1,968	0.00		0
transaction branch allocation	1,271	0.00		0
undo global data	9,295	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
cache buffers chains	4,748,642	282	36	247
session allocation	14,885	132	53	80
ASM map operation hash table	1,287,081	90	11	79
process allocation	71,376	47	42	6
redo allocation	6,347	23	1	22
ges resource hash list	19,517	9	3	6
slave class create	2,103	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
ASM map operation hash table	kffmDoDone_1	7	8
ASM map operation hash table	kffmTranslate	4	3
KCL gc element parent latch	kclchkping	1	0
cache buffers chains	kcbgtcr: kslbegin excl	60	18
cache buffers chains	kcbgtcr: fast path	8	0
cache buffers chains	kcbzwb	5	6
cache buffers chains	kcbgcur: kslbegin	4	7
cache buffers chains	kcbchg: kslbegin: call CR func	3	4
cache buffers chains	kclbla	2	2
ges resource hash list	kjrmas1: lookup master node	2	0
ges resource hash list	kjucvl: lock convert request	1	3
process allocation	ksucrp	35	0
process allocation	ksudlp	3	6
process allocation	ksufap: active procs	3	14
process allocation	ksuapc	1	32
redo allocation	kcrfw_redo_gen: redo allocation 1	1	0
session allocation	ksufap: active sessions	47	26
session allocation	ksuxds: not user session	3	6
session allocation	ksucri	2	19
session allocation	ksuxds: KSUSFCLC not set	1	1
slave class create	ksvcreate	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by 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: 1,831,908
Captured Segments account for 98.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	FILE$	TABLE	888,640	48.51
SYS	SYSTEM	SEG$	TABLE	246,096	13.43
SYS	SYSTEM	TS$	TABLE	115,568	6.31
SYS	SYSTEM	I_FILE#_BLOCK#	INDEX	114,464	6.25
SYS	SYSTEM	TAB$	TABLE	108,400	5.92

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 3,322
Captured Segments account for 0.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	WRH$_LATCH_PK	39862_8053	INDEX PARTITION	7	0.21
SYS	SYSTEM	I_FILE#_BLOCK#		INDEX	5	0.15
SYS	SYSAUX	WRH$_LATCH	39862_8053	TABLE PARTITION	4	0.12
SYS	SYSAUX	WRH$_DLM_MISC	39862_8054	TABLE PARTITION	2	0.06
SYS	SYSAUX	WRH$_SEG_STAT_OBJ_PK		INDEX	2	0.06

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

% of Capture shows % of Buffer Busy Waits for each top segment compared
with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	LOGON_TABLE		TABLE	75	100.00

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

% of Capture shows % of GC Buffer Busy for each top segment compared
with GC Buffer Busy for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	GC Buffer Busy	% of Capture
SYS	SYSTEM	LOGON_TABLE		TABLE	361	99.72
SYS	SYSAUX	WRH$_SYS_TIME_MODEL_PK	39862_8054	INDEX PARTITION	1	0.28

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 557
Captured Segments account for 80.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSTEM	SEG$	TABLE	144	25.85
SYS	SYSTEM	SMON_SCN_TIME	TABLE	50	8.98
SYS	SYSTEM	OBJ$	TABLE	33	5.92
SYS	SYSTEM	TAB$	TABLE	21	3.77
SYS	SYSAUX	WRH$_SQL_PLAN_PK	INDEX	20	3.59

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 8,146
Captured Segments account for 85.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	6,193	76.03
SYS	SYSTEM	LOGON_TABLE		TABLE	564	6.92
SYS	SYSTEM	SEG$		TABLE	46	0.56
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	39862_8053	INDEX PARTITION	25	0.31
SYS	SYSTEM	SMON_SCN_TIME_TIM_IDX		INDEX	15	0.18

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	63	3.17	0	1
dc_database_links	966	0.00	0	1
dc_files	15,967	0.00	0	75
dc_global_oids	887	0.00	0	29
dc_histogram_data	18	0.00	0	4,118
dc_histogram_defs	11	0.00	0	4,131
dc_object_ids	690	0.87	0	879
dc_objects	220	4.09	0	924
dc_rollback_segments	1,083	0.00	0	46
dc_segments	14	7.14	13	8,686
dc_tablespaces	2,673	0.00	0	10
dc_usernames	119	0.00	0	45
dc_users	2,334	0.00	0	58
outstanding_alerts	48	72.92	0	1

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts
dc_awr_control	2	2
dc_object_ids	6	3
dc_objects	9	9
dc_segments	26	12
outstanding_alerts	96	42

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	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	333	443	0.00	0	0
CLUSTER	2	2	0.00	0	0
INDEX	1	9	0.00	0	0
SQL AREA	5,832	9,921	0.03	1	20
TABLE/PROCEDURE	230	1,029	0.29	3	0
TRIGGER	964	964	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
CLUSTER	2	0	0	0
INDEX	9	0	1	2
TABLE/PROCEDURE	572	6	8	19

Back to Library Cache Statistics
Back to Top

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

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	Freeable	352.56	0.00	32.05	101.89	339		11	11
	Other	204.45		5.11	4.71	13	13	40	40
	PL/SQL	2.45	0.41	0.06	0.35	2	2	39	39
	SQL	0.48	0.22	0.04	0.05	0	338	13	11
E	Freeable	349.56	0.00	26.89	93.86	339		13	13
	Other	209.51		5.24	4.70	13	13	40	40
	PL/SQL	2.45	0.41	0.06	0.35	2	2	39	39
	SQL	0.48	0.22	0.04	0.05	0	338	13	11

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	31,708,938,240
Fixed Size	2,159,376
Redo Buffers	14,614,528
Variable Size	2,634,026,224

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	16.00	16.00	0.00
large	ASM map operations hashta	0.38	0.38	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.60	14.60	0.00
shared	ASH buffers	50.00	50.00	0.00
shared	db_block_hash_buckets	180.00	180.00	0.00
shared	free memory	432.17	433.10	0.21
shared	gcs resources	1,153.22	1,153.22	0.00
shared	gcs shadows	379.81	379.81	0.00
shared	sql area	36.71	35.88	-2.26
streams	free memory	16.00	16.00	0.00
	buffer_cache	30,240.00	30,240.00	0.00
	fixed_sga	2.06	2.06	0.00
	log_buffer	13.94	13.94	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

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 Coordinator	1,000	0	0
QMON Slaves	0	0	0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Rule Sets ordered by Evaluations

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
active_instance_count	1
audit_file_dest	/oracle/app/oracle/admin/clouddbs/adump
audit_trail	DB
background_dump_dest	/oracle/app/oracle/admin/clouddbs/bdump
cluster_database	TRUE
cluster_database_instances	2
compatible	10.2.0.5.0
control_files	+DATANEW/clouddbs/controlfile/current.256.780317391, +DATANEW/clouddbs/controlfile/current.257.780317393
core_dump_dest	/oracle/app/oracle/admin/clouddbs/cdump
db_block_size	8192
db_create_file_dest	+datanew
db_domain
db_file_multiblock_read_count	16
db_name	clouddbs
db_recovery_file_dest	+datanew
db_recovery_file_dest_size	214748364800
dispatchers	(PROTOCOL=TCP) (SERVICE=clouddbsXDB)
instance_number	2
job_queue_processes	10
local_listener	(ADDRESS = (PROTOCOL = TCP)(HOST = 10.46.51.218)(PORT = 1521))
log_archive_dest_1	location=+DATANEW/
log_archive_format	%t_%s_%r.dbf
open_cursors	300
pga_aggregate_target	12884901888
processes	1000
remote_listener	LISTENERS_CLOUDDBS
remote_login_passwordfile	EXCLUSIVE
sessions	1105
sga_max_size	34359738368
sga_target	34359738368
spfile	+DATANEW/clouddbs/spfileclouddbs.ora
thread	2
undo_management	AUTO
undo_tablespace	UNDOTBS2
user_dump_dest	/oracle/app/oracle/admin/clouddbs/udump

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	18,260	5.06	17.59
acks for commit broadcast(logical)	18,408	5.10	17.73
broadcast msgs on commit(actual)	1,293	0.36	1.25
broadcast msgs on commit(logical)	1,299	0.36	1.25
broadcast msgs on commit(wasted)	105	0.03	0.10
broadcast on commit wait time(ms)	772	0.21	0.74
broadcast on commit waits	1,105	0.31	1.06
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
false posts waiting for scn acks	2	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	0	0.00	0.00
gcs ast xid	0	0.00	0.00
gcs blocked converts	0	0.00	0.00
gcs blocked cr converts	0	0.00	0.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	126	0.03	0.12
gcs dbwr write request msgs	62	0.02	0.06
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 lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	0	0.00	0.00
gcs msgs process time(ms)	441	0.12	0.42
gcs msgs received	27,943	7.75	26.92
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 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 side channel msgs actual	4,933	1.37	4.75
gcs side channel msgs logical	15,877	4.40	15.30
gcs stale cr	0	0.00	0.00
gcs undo cr	0	0.00	0.00
gcs write notification msgs	0	0.00	0.00
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	72	0.02	0.07
ges msgs received	2,347	0.65	2.26
global posts dropped	0	0.00	0.00
global posts queue time	0	0.00	0.00
global posts queued	0	0.00	0.00
global posts requested	0	0.00	0.00
global posts sent	0	0.00	0.00
implicit batch messages received	328	0.09	0.32
implicit batch messages sent	9,510	2.64	9.16
lmd msg send time(ms)	18	0.00	0.02
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	15,564	4.32	14.99
messages queue sent actual	16,211	4.49	15.62
messages queue sent logical	42,747	11.85	41.18
messages received actual	29,941	8.30	28.84
messages received logical	30,290	8.40	29.18
messages sent directly	23,051	6.39	22.21
messages sent indirectly	27,183	7.54	26.19
messages sent not implicit batched	6,701	1.86	6.46
messages sent pbatched	0	0.00	0.00
msgs causing lmd to send msgs	895	0.25	0.86
msgs causing lms(s) to send msgs	1,317	0.37	1.27
msgs received queue time (ms)	1,232	0.34	1.19
msgs received queued	30,290	8.40	29.18
msgs sent queue time (ms)	5,132	1.42	4.94
msgs sent queue time on ksxp (ms)	51,107	14.17	49.24
msgs sent queued	42,718	11.84	41.15
msgs sent queued on ksxp	39,263	10.89	37.83
number of ges deadlock detected	0	0.00	0.00
process batch messages received	0	0.00	0.00
process batch messages sent	0	0.00	0.00

Global CR Served Stats

Statistic	Total
CR Block Requests	347
CURRENT Block Requests	207
Data Block Requests	347
Undo Block Requests	0
TX Block Requests	156
Current Results	554
Private results	0
Zero Results	0
Disk Read Results	0
Fail Results	0
Fairness Down Converts	98
Fairness Clears	0
Free GC Elements	0
Flushes	13
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	6
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	% <1s
Pins	918	75.38	0.33	24.18	0.11
Flushes	44	45.45	25.00	22.73	6.82
Writes	126	34.92	48.41	16.67	0.00

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	401	98.75	1.25	0.00	6,929	96.35	3.65	0.00
1	Others	33	100.00	0.00	0.00	1,213	98.60	1.40	0.00
1	undo header	117	98.29	1.71	0.00	2	100.00	0.00	0.00
1	undo block	1	100.00	0.00	0.00	0

End of Report

% Blocks changed per Read:	0.39	Recursive Call %:	86.02
Rollback per transaction %:	6.36	Rows per Sort:	31.41

Buffer Nowait %:	99.98	Redo NoWait %:	99.93
Buffer Hit %:	99.98	In-memory Sort %:	100.00
Library Hit %:	99.95	Soft Parse %:	99.99
Execute to Parse %:	2.36	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	86.30	% Non-Parse CPU:	99.35

Buffer access - local cache %:	99.51
Buffer access - remote cache %:	0.48
Buffer access - disk %:	0.02

Avg global enqueue get time (ms):	0.8
Avg global cache cr block receive time (ms):	2.5
Avg global cache current block receive time (ms):	9.9
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	2.4
Avg global cache cr block flush time (ms):	1.5
Avg global cache current block pin time (ms):	7.9
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	5.0
Avg global cache current block flush time (ms):	21.4

Avg message sent queue time (ms):	0.1
Avg message sent queue time on ksxp (ms):	1.3
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	35.03
% of indirect sent messages:	41.31
% of flow controlled messages:	23.65