SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 4 11:13:48 2017 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options AWR Report for DB: JDETEST, Inst: JDETEST1, Snaps: 1956-1957

WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

JDETEST 3035399126 JDETEST1 1 29-Jun-17 18:06 11.2.0.4.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
JDETEST	3035399126	JDETEST1	1	29-Jun-17 18:06	11.2.0.4.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

sodax6-1 Linux x86 64-bit 16 16 1 504.66

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
sodax6-1	Linux x86 64-bit	16	16	1	504.66

Snap Id Snap Time Sessions Cursors/Session Instances

Begin Snap: 1956 04-Jul-17 09:13:41 58 3.9 2

End Snap: 1957 04-Jul-17 09:13:45 58 3.9 2

Elapsed: 0.07 (mins)

DB Time: 0.09 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session	Instances
Begin Snap:	1956	04-Jul-17 09:13:41	58	3.9	2
End Snap:	1957	04-Jul-17 09:13:45	58	3.9	2
Elapsed:		0.07 (mins)
DB Time:		0.09 (mins)

Report Summary

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 1.3 0.0 0.00 0.00

DB CPU(s): 0.9 0.0 0.00 0.00

Redo size (bytes): 1,422,840.5 1,360.2

Logical read (blocks): 13,303.8 12.7

Block changes: 8,209.9 7.9

Physical read (blocks): 0.5 0.0

Physical write (blocks): 39.5 0.0

Read IO requests: 0.5 0.0

Write IO requests: 4.3 0.0

Read IO (MB): 0.0 0.0

Write IO (MB): 0.3 0.0

Global Cache blocks received: 74.7 0.1

Global Cache blocks served: 71.1 0.1

User calls: 1,727.3 1.7

Parses (SQL): 242.0 0.2

Hard parses (SQL): 8.4 0.0

SQL Work Area (MB): 17.6 0.0

Logons: 1.3 0.0

Executes (SQL): 1,858.7 1.8

Rollbacks: 0.3 0.0

Transactions: 1,046.1

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.3	0.0	0.00	0.00
DB CPU(s):	0.9	0.0	0.00	0.00
Redo size (bytes):	1,422,840.5	1,360.2
Logical read (blocks):	13,303.8	12.7
Block changes:	8,209.9	7.9
Physical read (blocks):	0.5	0.0
Physical write (blocks):	39.5	0.0
Read IO requests:	0.5	0.0
Write IO requests:	4.3	0.0
Read IO (MB):	0.0	0.0
Write IO (MB):	0.3	0.0
Global Cache blocks received:	74.7	0.1
Global Cache blocks served:	71.1	0.1
User calls:	1,727.3	1.7
Parses (SQL):	242.0	0.2
Hard parses (SQL):	8.4	0.0
SQL Work Area (MB):	17.6	0.0
Logons:	1.3	0.0
Executes (SQL):	1,858.7	1.8
Rollbacks:	0.3	0.0
Transactions:	1,046.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 98.95 Soft Parse %: 96.55

Execute to Parse %: 86.98 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 66.67 % Non-Parse CPU: 98.85

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
DB CPU		3.5		67.4
reliable message	4,095	1	0	20.0	Other
log file sync	1,483	.3	0	5.8	Commit
Disk file operations I/O	18	.1	3	1.1	User I/O
control file sequential read	120	0	0	.3	System I/O
gc current block 2-way	141	0	0	.3	Cluster
gc cr block 2-way	119	0	0	.3	Cluster
gc current grant 2-way	120	0	0	.2	Cluster
gc current grant busy	56	0	0	.2	Cluster
db file sequential read	11	0	1	.1	User I/O

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
DB CPU		3		67.4	0.9
Other	27,885	1	0	24.7	0.3
System I/O	4,331	0	0	9.5	0.1
Commit	1,483	0	0	5.8	0.1
User I/O	73	0	1	1.4	0.0
Cluster	486	0	0	1.3	0.0
Network	6,822	0	0	.1	0.0
Concurrency	8,243	0	0	.1	0.0
Configuration	1	0	0	.0	0.0

Host CPU

CPUs Cores Sockets Load Average Begin Load Average End %User %System %WIO %Idle

16 16 1 2.89 3.14 9.6 4.0 0.1 86.0

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
16	16	1	2.89	3.14	9.6	4.0	0.1	86.0

Instance CPU

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

7.6 53.9 0.0

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

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 1,101.3 39.8 1,061.5

Database Requests: 4.8 0.5 4.3

Optimized Requests: 0.5 0.3 0.3

Redo Requests: 1,073.9 0.0 1,073.9

Total (MB): 2.6 0.6 2.0

Database (MB): 0.3 0.0 0.3

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB): 1.5 0.0 1.5

Database (blocks): 40.0 0.5 39.5

Via Buffer Cache (blocks): 39.0 0.0 39.0

Direct (blocks): 1.0 0.5 0.5

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	1,101.3	39.8	1,061.5
Database Requests:	4.8	0.5	4.3
Optimized Requests:	0.5	0.3	0.3
Redo Requests:	1,073.9	0.0	1,073.9
Total (MB):	2.6	0.6	2.0
Database (MB):	0.3	0.0	0.3
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	1.5	0.0	1.5
Database (blocks):	40.0	0.5	39.5
Via Buffer Cache (blocks):	39.0	0.0	39.0
Direct (blocks):	1.0	0.5	0.5

Memory Statistics

Begin End

Host Mem (MB): 516,769.8 516,769.8

SGA use (MB): 245,760.0 245,760.0

PGA use (MB): 947.5 947.1

% Host Mem used for SGA+PGA: 47.74 47.74

	Begin	End
Host Mem (MB):	516,769.8	516,769.8
SGA use (MB):	245,760.0	245,760.0
PGA use (MB):	947.5	947.1
% Host Mem used for SGA+PGA:	47.74	47.74

Cache Sizes

Begin End

Buffer Cache: 218,112M 218,112M Std Block Size: 8K

Shared Pool Size: 20,905M 20,905M Log Buffer: 447,164K

	Begin	End
Buffer Cache:	218,112M	218,112M	Std Block Size:	8K
Shared Pool Size:	20,905M	20,905M	Log Buffer:	447,164K

Shared Pool Statistics

Begin End

Memory Usage %: 66.34 66.34

% SQL with executions>1: 99.27 99.27

% Memory for SQL w/exec>1: 93.46 93.10

	Begin	End
Memory Usage %:	66.34	66.34
% SQL with executions>1:	99.27	99.27
% Memory for SQL w/exec>1:	93.46	93.10

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
Shared Server Statistics
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Wait Event Histogram Detail (64 msec to 2 sec)
Wait Event Histogram Detail (4 sec to 2 min)
Wait Event Histogram Detail (4 min to 1 hr)
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 5.2s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
DB CPU	3.49	67.42
sql execute elapsed time	3.03	58.57
PL/SQL execution elapsed time	0.64	12.33
parse time elapsed	0.09	1.72
connection management call elapsed time	0.07	1.39
hard parse elapsed time	0.07	1.28
hard parse (sharing criteria) elapsed time	0.02	0.34
sequence load elapsed time	0.00	0.04
PL/SQL compilation elapsed time	0.00	0.03
hard parse (bind mismatch) elapsed time	0.00	0.01
repeated bind elapsed time	0.00	0.01
DB time	5.17
background elapsed time	1.35
background cpu time	1.27

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Statistic	Value	End Value
BUSY_TIME	882
IDLE_TIME	5,400
IOWAIT_TIME	9
NICE_TIME	0
SYS_TIME	251
USER_TIME	603
LOAD	3	3
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	541,872,373,760
NUM_CPUS	16
NUM_CPU_CORES	16
NUM_CPU_SOCKETS	1
GLOBAL_RECEIVE_SIZE_MAX	134,217,728
GLOBAL_SEND_SIZE_MAX	134,217,728
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	134,217,728
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	65,536
TCP_SEND_SIZE_MAX	134,217,728
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
04-Jul 09:13:41	2.89
04-Jul 09:13:45	3.14	14.04	9.60	4.00	85.96	0.14

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			3		67.42
Other	4,119	0	1	0	20.15
Commit	1,483	0	0	0	5.77
User I/O	63	0	0	1	1.37
Cluster	474	0	0	0	1.22
System I/O	120	0	0	0	0.33
Network	6,807	0	0	0	0.09
Concurrency	5	0	0	0	0.02
Configuration	1	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
reliable message	4,095	0	1	0	0.99	19.99
log file sync	1,483	0	0	0	0.36	5.77
Disk file operations I/O	18	0	0	3	0.00	1.08
control file sequential read	120	0	0	0	0.03	0.33
gc current block 2-way	141	0	0	0	0.03	0.32
gc cr block 2-way	119	0	0	0	0.03	0.30
gc current grant 2-way	120	0	0	0	0.03	0.24
gc current grant busy	56	0	0	0	0.01	0.15
db file sequential read	11	0	0	1	0.00	0.14
Disk file Mirror Read	30	0	0	0	0.01	0.13
gc current block busy	10	0	0	1	0.00	0.12
CSS initialization	1	0	0	5	0.00	0.09
SQL*Net message to client	6,784	0	0	0	1.64	0.09
enq: WF - contention	16	0	0	0	0.00	0.05
gc current multi block request	16	0	0	0	0.00	0.04
gc cr block busy	3	0	0	0	0.00	0.03
SQL*Net message from client	6,784	0	13	2	1.64
Streams AQ: waiting for messages in the queue	1	100	5	5001	0.00
wait for unread message on broadcast channel	4	100	4	1001	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
log file parallel write	4,161	0	0	0	1.01	34.32
LGWR wait for redo copy	2,921	0	0	0	0.71	13.71
ksxr poll remote instances	4,143	100	0	0	1.00	2.33
row cache cleanup	8,263	0	0	0	2.00	0.56
db file parallel write	15	0	0	0	0.00	0.32
row cache process	8,292	0	0	0	2.01	0.28
control file sequential read	24	0	0	0	0.01	0.25
libcache interrupt action by LCK	8,241	0	0	0	1.99	0.23
DFS lock handle	19	100	0	0	0.00	0.18
CSS operation: action	2	0	0	1	0.00	0.17
Disk file Mirror Read	10	0	0	0	0.00	0.16
db file async I/O submit	15	0	0	0	0.00	0.12
gc cr block 2-way	8	0	0	0	0.00	0.08
smon timer	1	0	176	175501	0.00
rdbms ipc message	16,516	1	124	7	4.00
Space Manager: slave idle wait	4	50	17	4206	0.00
DIAG idle wait	39	100	8	205	0.01
gcs remote message	4,865	1	8	2	1.18
GCR sleep	1	100	5	5001	0.00
ges remote message	127	25	4	31	0.03
wait for unread message on broadcast channel	4,103	0	4	1	0.99
pmon timer	2	50	3	1502	0.00
SQL*Net message from client	20	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
% of Waits: value of .0 indicates value was <.05%; value of null is truly 0
% of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
Ordered by Event (idle events last)

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
CGS wait for IPC msg	38	100.0
CSS initialization	1				100.0
CSS operation: action	3	66.7	33.3
DFS lock handle	19	100.0
Disk file Mirror Read	40	100.0
Disk file operations I/O	19	94.7						5.3
KJC: Wait for msg sends to complete	1	100.0
LGWR wait for redo copy	3969	100.0
PX Deq: reap credit	70	100.0
SQL*Net message to client	6879	100.0
SQL*Net more data to client	23	100.0
asynch descriptor resize	5	100.0
control file parallel write	2	100.0
control file sequential read	144	100.0
db file async I/O submit	25	100.0
db file parallel write	25	96.0	4.0
db file sequential read	11	100.0
direct path read temp	2	100.0
direct path write temp	2	100.0
enq: AF - task serialization	1	100.0
enq: CO - master slave det	2	100.0
enq: FB - contention	1	100.0
enq: HW - contention	1	100.0
enq: TA - contention	1	100.0
enq: TD - KTF dump entries	1	100.0
enq: TX - index contention	2	100.0
enq: WF - contention	16	100.0
gc buffer busy release	1	100.0
gc cr block 2-way	123	100.0
gc cr block busy	3	100.0
gc cr block congested	1	100.0
gc cr multi block request	3	100.0
gc current block 2-way	144	100.0
gc current block busy	17	100.0
gc current block congested	2	100.0
gc current grant 2-way	72	100.0
gc current grant busy	49	100.0
gc current grant congested	1	100.0
gc current multi block request	13	100.0
gcs log flush sync	6	100.0
ksxr poll remote instances	4193	100.0
latch: gc element	1	100.0
latch: ges resource hash list	2	100.0
latch: redo allocation	1	100.0
libcache interrupt action by LCK	8348	100.0
log file parallel write	4216	100.0	.0
log file sync	1997	99.9	.1
rdbms ipc reply	2	100.0
reliable message	4149	99.9	.0					.0
row cache cleanup	8367	100.0
row cache lock	3	100.0
row cache process	8396	100.0
DIAG idle wait	39					2.6		97.4
GCR sleep	1								100.0
KSV master wait	2	100.0
PING	3	66.7							33.3
SQL*Net message from client	6885	98.2	.7	.2	.2	.5	.1	.1	.0
Space Manager: slave idle wait	2								100.0
Streams AQ: waiting for messages in the queue	1								100.0
gcs remote message	4830	61.9	31.8	1.7	1.3	1.3	2.0
ges remote message	112	42.0	5.4	3.6	8.0	2.7	4.5	33.9
pmon timer	1								100.0
rdbms ipc message	16.7K	85.3	14.0	.3	.0	.0		.3	.1
smon timer	1								100.0
wait for unread message on broadcast channel	4161	50.1	48.4	1.3	.1			.1

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 64ms to 2s	<32ms	<64ms	<1/2s
		% of Total Waits
Disk file operations I/O	1	94.7	5.3
reliable message	1	100.0		.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Logical Reads (K)
JDETEST	5	3	52
SYS$USERS	0	0	0
JDETESTXDB	0	0	0
SYS$BACKGROUND	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	Concurcy Total Wts	Network Total Wts
JDETEST	63	3	6786
SYS$USERS	0	0	1
SYS$BACKGROUND	10	8208	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
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 - Elapsed Time as a percentage of Total DB time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 39.1% of Total DB Time (s): 5
Captured PL/SQL account for 46.3% of Total DB Time (s): 5

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
2.16	1	2.16	41.81	77.74	0.82	7dwup5bn902rg	SQL*Plus	BEGIN DBMS_WORKLOAD_REPOSITORY...
0.91	1	0.91	17.60	99.08	0.00	bunssq950snhf		insert into wrh$_sga_target_ad...
0.37	2,093	0.00	7.22	99.67	0.00	2hvv64zmrk00p	runbatch@bear.fp.co.nz (TNS V1-V3)	DELETE FROM CRPDTA.F30UI010 WH...
0.27	2,100	0.00	5.31	93.91	0.00	0hz0861v91651	runbatch@bear.fp.co.nz (TNS V1-V3)	UPDATE CRPDTA.F30UI013 SET LKI...
0.23	1	0.23	4.48	86.65	0.20	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.05	5	0.01	1.03	3.74	95.85	4vs91dcv7u1p6	OMS	insert into sys.aud$( sessioni...
0.05	1	0.05	0.95	97.75	0.00	84qubbrsr0kfn		insert into wrh$_latch (snap_i...
0.04	2,098	0.00	0.86	108.20	0.00	7hbpb1vnd8nvj	runbatch@bear.fp.co.nz (TNS V1-V3)	SELECT * FROM CRPDTA.F30UI013 ...
0.03	1	0.03	0.59	91.69	0.00	4dy1xm4nxc0gf		insert into wrh$_system_event ...
0.03	1	0.03	0.57	95.67	0.00	84k66tf2s7y1c		insert into wrh$_bg_event_summ...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - CPU Time as a percentage of Total DB CPU
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 54.8% of Total CPU Time (s): 3
Captured PL/SQL account for 54.0% of Total CPU Time (s): 3

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1.68	1	1.68	48.21	2.16	77.74	0.82	7dwup5bn902rg	SQL*Plus	BEGIN DBMS_WORKLOAD_REPOSITORY...
0.90	1	0.90	25.87	0.91	99.08	0.00	bunssq950snhf		insert into wrh$_sga_target_ad...
0.37	2,093	0.00	10.67	0.37	99.67	0.00	2hvv64zmrk00p	runbatch@bear.fp.co.nz (TNS V1-V3)	DELETE FROM CRPDTA.F30UI010 WH...
0.26	2,100	0.00	7.40	0.27	93.91	0.00	0hz0861v91651	runbatch@bear.fp.co.nz (TNS V1-V3)	UPDATE CRPDTA.F30UI013 SET LKI...
0.20	1	0.20	5.76	0.23	86.65	0.20	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.05	1	0.05	1.38	0.05	97.75	0.00	84qubbrsr0kfn		insert into wrh$_latch (snap_i...
0.05	2,098	0.00	1.38	0.04	108.20	0.00	7hbpb1vnd8nvj	runbatch@bear.fp.co.nz (TNS V1-V3)	SELECT * FROM CRPDTA.F30UI013 ...
0.03	1	0.03	0.80	0.03	91.69	0.00	4dy1xm4nxc0gf		insert into wrh$_system_event ...
0.03	1	0.03	0.80	0.03	95.67	0.00	84k66tf2s7y1c		insert into wrh$_bg_event_summ...
0.02	1	0.02	0.52	0.02	93.57	0.00	48s88ugf199v4		insert into wrh$_parameter (sn...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - User I/O Time as a percentage of Total User I/O Wait time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 76.8% of Total User I/O Wait Time (s): 0
Captured PL/SQL account for 25.0% of Total User I/O Wait Time (s): 0

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.05	5	0.01	70.41	0.05	3.74	95.85	4vs91dcv7u1p6	OMS	insert into sys.aud$( sessioni...
0.02	1	0.02	24.40	2.16	77.74	0.82	7dwup5bn902rg	SQL*Plus	BEGIN DBMS_WORKLOAD_REPOSITORY...
0.00	1	0.00	4.07	0.01	23.33	23.04	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
0.00	1	0.00	1.27	0.00	31.23	28.89	d37dg314005wr		MERGE /*+ opt_param('_optimize...
0.00	1	0.00	0.63	0.23	86.65	0.20	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.00	80	0.00	0.53	0.02	64.56	1.66	3s58mgk0uy2ws		insert into wrm$_snapshot_deta...
0.00	5	0.00	0.53	0.00	88.76	11.36	f711myt0q6cma	jdenet_k@bear.fp.co.nz (TNS V1-V3)	insert into sys.aud$( sessioni...
0.00	1	0.00	0.00	0.01	100.96	0.00	017cf5jjx56jh		SELECT COUNT() FROM (SELECT ...
0.00	6	0.00	0.00	0.00	224.72	0.00	062savj8zgzut		UPDATE sys.wri$_adv_parameters...
0.00	2,100	0.00	0.00	0.27	93.91	0.00	0hz0861v91651	runbatch@bear.fp.co.nz (TNS V1-V3)	UPDATE CRPDTA.F30UI013 SET LKI...

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 as a percentage of Total Buffer Gets
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Buffer Gets: 52,550
Captured SQL account for 85.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
23,146	2,093	11.06	44.05	0.37	99.7	0	2hvv64zmrk00p	runbatch@bear.fp.co.nz (TNS V1-V3)	DELETE FROM CRPDTA.F30UI010 WH...
9,484	1	9,484.00	18.05	2.16	77.7	.8	7dwup5bn902rg	SQL*Plus	BEGIN DBMS_WORKLOAD_REPOSITORY...
8,471	2,100	4.03	16.12	0.27	93.9	0	0hz0861v91651	runbatch@bear.fp.co.nz (TNS V1-V3)	UPDATE CRPDTA.F30UI013 SET LKI...
6,294	2,098	3.00	11.98	0.04	108.2	0	7hbpb1vnd8nvj	runbatch@bear.fp.co.nz (TNS V1-V3)	SELECT * FROM CRPDTA.F30UI013 ...
5,358	1	5,358.00	10.20	0.23	86.7	.2	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
647	80	8.09	1.23	0.01	49.8	0	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
607	80	7.59	1.16	0.02	64.6	1.7	3s58mgk0uy2ws		insert into wrm$_snapshot_deta...
549	171	3.21	1.04	0.01	129.5	0	338sv20sv2kdn	jdenet_k@bear.fp.co.nz (TNS V1-V3)	SELECT * FROM PY900.F98740PYOD...
545	132	4.13	1.04	0.01	81.9	0	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
464	2	232.00	0.88	0.01	129.8	0	0jfcj2hwxrhc4	jdenet_k@bear.fp.co.nz (TNS V1-V3)	SELECT OMENHV, OMAPPLID, OMOBN...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 2
Captured SQL account for 0.0% of Total

Executions	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1	0.01	100.96	0.00	017cf5jjx56jh		SELECT COUNT() FROM (SELECT ...
6	0.00	224.72	0.00	062savj8zgzut		UPDATE sys.wri$_adv_parameters...
2,100	0.27	93.91	0.00	0hz0861v91651	runbatch@bear.fp.co.nz (TNS V1-V3)	UPDATE CRPDTA.F30UI013 SET LKI...
2	0.01	129.78	0.00	0jfcj2hwxrhc4	jdenet_k@bear.fp.co.nz (TNS V1-V3)	SELECT OMENHV, OMAPPLID, OMOBN...
5	0.00	178.64	0.00	0k8522rmdzg4k		select privilege# from sysauth...
5	0.00	0.00	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
3	0.00	0.00	0.00	1198upp2uraxj	cleanup@bear.fp.co.nz (TNS V1-V3)	SELECT * FROM CRPDTA.F0010 WHE...
1	0.00	111.11	0.00	15rbgh4d2ku4u		insert into WRM$_SNAPSHOT (sna...
1	0.01	23.33	23.04	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
2	0.01	106.89	0.00	1pbs13r5f6js7	jdenet_k@bear.fp.co.nz (TNS V1-V3)	SELECT VALUE FROM V$PARAMETER ...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 2
Captured SQL account for 0.0% of Total
Total UnOptimized Read Requests: 2
Captured SQL account for 0.0% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Opt	%Total	SQL Id	SQL Module	SQL Text
131	131	1	131.00	0.00	6550.00	7dwup5bn902rg	SQL*Plus	BEGIN DBMS_WORKLOAD_REPOSITORY...
0	0	1	0.00		0.00	017cf5jjx56jh		SELECT COUNT() FROM (SELECT ...
0	0	6	0.00		0.00	062savj8zgzut		UPDATE sys.wri$_adv_parameters...
0	0	2,100	0.00		0.00	0hz0861v91651	runbatch@bear.fp.co.nz (TNS V1-V3)	UPDATE CRPDTA.F30UI013 SET LKI...
0	0	2	0.00		0.00	0jfcj2hwxrhc4	jdenet_k@bear.fp.co.nz (TNS V1-V3)	SELECT OMENHV, OMAPPLID, OMOBN...
0	0	5	0.00		0.00	0k8522rmdzg4k		select privilege# from sysauth...
0	0	5	0.00		0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
0	0	3	0.00		0.00	1198upp2uraxj	cleanup@bear.fp.co.nz (TNS V1-V3)	SELECT * FROM CRPDTA.F0010 WHE...
0	0	1	0.00		0.00	15rbgh4d2ku4u		insert into WRM$_SNAPSHOT (sna...
0	0	1	0.00		0.00	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 7,342
Captured SQL account for 96.4% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
2,100	2,100	1.00	0.27	93.9	0	0hz0861v91651	runbatch@bear.fp.co.nz (TNS V1-V3)	UPDATE CRPDTA.F30UI013 SET LKI...
2,098	2,098	1.00	0.04	108.2	0	7hbpb1vnd8nvj	runbatch@bear.fp.co.nz (TNS V1-V3)	SELECT * FROM CRPDTA.F30UI013 ...
2,093	2,093	1.00	0.37	99.7	0	2hvv64zmrk00p	runbatch@bear.fp.co.nz (TNS V1-V3)	DELETE FROM CRPDTA.F30UI010 WH...
171	18	0.11	0.01	129.5	0	338sv20sv2kdn	jdenet_k@bear.fp.co.nz (TNS V1-V3)	SELECT * FROM PY900.F98740PYOD...
132	132	1.00	0.01	81.9	0	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
80	80	1.00	0.01	49.8	0	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
80	80	1.00	0.02	64.6	1.7	3s58mgk0uy2ws		insert into wrm$_snapshot_deta...
64	64	1.00	0.01	52.3	0	f80h0xb1qvbsk		SELECT sys.wri$_adv_seq_msggro...
25	25	1.00	0.00	0	0	grwydz59pu6mc		select text from view$ where r...
14	14	1.00	0.00	190.5	0	2gxbvynrd71dr		INSERT INTO sys.wri$_adv_rec_a...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 956
Captured SQL account for 67.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
171	171	17.89	338sv20sv2kdn	jdenet_k@bear.fp.co.nz (TNS V1-V3)	SELECT * FROM PY900.F98740PYOD...
80	80	8.37	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
80	80	8.37	3s58mgk0uy2ws		insert into wrm$_snapshot_deta...
64	64	6.69	f80h0xb1qvbsk		SELECT sys.wri$_adv_seq_msggro...
25	25	2.62	grwydz59pu6mc		select text from view$ where r...
14	14	1.46	2gxbvynrd71dr		INSERT INTO sys.wri$_adv_rec_a...
14	14	1.46	3sqgkcng6vx8r		INSERT INTO sys.wri$_adv_ratio...
14	14	1.46	7gs8x44r7mpnb		INSERT INTO sys.wri$_adv_actio...
14	14	1.46	g5vpd5g3y90qv		INSERT INTO sys.wri$_adv_recom...
12	12	1.26	fnz13xnvkybtj		INSERT INTO sys.wri$_adv_findi...
10	10	1.05	3dyfgxpt4yvb5	jdenet_k@bear.fp.co.nz (TNS V1-V3)	SELECT * FROM PY900.F98762PYOD...
10	10	1.05	42mkua34ay6bc		INSERT INTO wri$_adv_addm_fdg ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
2,888,010	1	0.01	6wm3n4d7bnddg		SELECT source, (case when tim...
2,404,483	1	0.01	1w2vta5jv74ky	runbatch@bear.fp.co.nz (TNS V1-V3)	SELECT OBJECT_NAME FROM SYS.AL...
2,332,093	1	0.01	61tn3mam0vq0b		SELECT source, (case when tim...
1,454,463	2	0.01	69k5bhm12sz98		SELECT dbin.instance_number, d...
1,322,680	1	0.01	317v5hnvvd49h		UPDATE wrh$_seg_stat_obj ob S...
1,242,732	1	0.01	d37dg314005wr		MERGE /*+ opt_param('_optimize...
1,204,390	2	0.01	2j0fw19fph49j		SELECT dbin.instance_number, d...
1,140,829	1	0.01	691p2a1hswk0m		insert into wrh$_seg_stat_obj ...
1,125,045	1	0.01	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Text
29	2	69k5bhm12sz98	SELECT dbin.instance_number, d...
25	1	6wm3n4d7bnddg	SELECT source, (case when tim...
25	1	6wm3n4d7bnddg	SELECT source, (case when tim...
24	2	2j0fw19fph49j	SELECT dbin.instance_number, d...
24	2	63t3ufgq37m0c	SELECT instance_number, instan...
24	2	63t3ufgq37m0c	SELECT instance_number, instan...
24	2	63t3ufgq37m0c	SELECT instance_number, instan...
24	2	63t3ufgq37m0c	SELECT instance_number, instan...
22	2	5s34t44u10q4g	SELECT a.name task_name, nvl(e...
22	1	61tn3mam0vq0b	SELECT source, (case when tim...
22	1	61tn3mam0vq0b	SELECT source, (case when tim...
22	1	aktbxfjwnzgmu	update WRM$_DATABASE_INSTANCE ...
21	2	c8gnrhxma4tas	SELECT owner#, property FROM s...
21	2	gdn3ysuyssf82	SELECT advisor_id FROM sys.wri...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

%Total - Cluster Time as a percentage of Total Cluster Wait Time
%Clu - Cluster Time as a percentage of Elapsed Time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Only SQL with Cluster Wait Time > .005 seconds is reported
Total Cluster Wait Time (s): 0
Captured SQL account for 44.5% of Total

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.06	1	90.45	2.16	2.71	77.74	0.82	7dwup5bn902rg	SQL*Plus	BEGIN DBMS_WORKLOAD_REPOSITORY...
0.02	1	33.31	0.23	9.30	86.65	0.20	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.01	80	13.86	0.02	38.63	64.56	1.66	3s58mgk0uy2ws		insert into wrm$_snapshot_deta...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

017cf5jjx56jh SELECT COUNT(*) FROM (SELECT * FROM DBA_HIST_ACTIVE_SESS_HISTORY WHERE DBID = 3035399126 AND SNAP_ID > 1955 AND SNAP_ID <= 1956 AND SESSION_TYPE = 'FOREGROUND' AND WAIT_CLASS_ID = 3386400367 AND SESSION_STATE = 'WAITING')

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

0hz0861v91651 UPDATE CRPDTA.F30UI013 SET LKITM=:BND1, LKLLX=:BND2 WHERE ( LKITM = :KEY1 )

0jfcj2hwxrhc4 SELECT OMENHV, OMAPPLID, OMOBNM, OMDATP, OMDATS, OMUGRP, OMOAPP, OMDATM, OMOVRE, OMSY, OMSTSO, OMFUNO, OMOCM2, OMOCMDSC FROM SVM900.F986101 WHERE ( OMENHV = :KEY1 AND OMSTSO = :KEY2 AND ( OMUGRP = :KEY3 OR OMUGRP = :KEY4 OR OMUGRP = :KEY5 OR OMUGRP = :KEY6 ) ) ORDER BY OMSTSO ASC, OMAPPLID ASC

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

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

1198upp2uraxj SELECT * FROM CRPDTA.F0010 WHERE ( CCCO = :KEY1 ) ORDER BY CCCO ASC

15rbgh4d2ku4u insert into WRM$_SNAPSHOT (snap_id, dbid, instance_number, startup_time, begin_interval_time, end_interval_time, snap_level, status, error_count, bl_moved, snap_flag, snap_timezone) values (:snap_id, :dbid, :instance_number, :startup_time, :begin_interval_time, :end_interval_time, :snap_level, :status, 0, 0, :bind1, :bind2)

1cq3qr774cu45 insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum (small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)

1pbs13r5f6js7 SELECT VALUE FROM V$PARAMETER WHERE NAME = 'open_cursors'

1w2vta5jv74ky SELECT OBJECT_NAME FROM SYS.ALL_OBJECTS WHERE ( OBJECT_NAME = :KEY1 AND OBJECT_TYPE = :KEY2 AND OWNER = :KEY3 )

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

2hvv64zmrk00p DELETE FROM CRPDTA.F30UI010 WHERE ( WFKIT = :KEY1 AND WFITM = :KEY2 )

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

317v5hnvvd49h UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LO B', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat)

338sv20sv2kdn SELECT * FROM PY900.F98740PYODATEST WHERE ( ELPRDTYP = :KEY1 AND ELOBNM = :KEY2 ) ORDER BY ELPRDTYP ASC, ELOBNM ASC, ELVERS ASC, ELFMNM ASC, ELCTRLID ASC, ELWEVENT ASC, ELERID3 ASC

3dyfgxpt4yvb5 SELECT * FROM PY900.F98762PYODATEST WHERE ( BCFNNM = :KEY1 )

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

3s58mgk0uy2ws insert into wrm$_snapshot_details (snap_id, dbid, instance_number, table_id, begin_time, end_time) values (:snap_id, :dbid, :instance_number, :bind1, :bind2, :bind3)

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

42mkua34ay6bc INSERT INTO wri$_adv_addm_fdg ( TASK_ID, FINDING_ID, RULE_ID, ADDM_FDG_ID, ADDM_SEQ, DATABASE_TIME, ACTIVE_SESSIONS, PERC_ACTIVE_SESS, IS_AGGREGATE, METER_LEVEL, QUERY_TYPE, QUERY_IS_APPROX, QUERY_ARGS) VALUES ( :tid, :kea_id, :rid, :fdg_id, :keh_id, :dbt, round(:dbt / (1000000 * :sint) , 2), round(((:dbt * 100) / :total_dbt) , 2), 'N', NULL, :aqt, decode(:aqa, 0, 'N', 'Y'), decode(:aqargs, ' ', NULL, :aqargs))

48s88ugf199v4 insert into wrh$_parameter (snap_id, dbid, instance_number, parameter_hash, value, isdefault, ismodified) select :snap_id, :dbid, :instance_number, hash, substr(value, 1, 512), isdefault, case when ismodified <> 'FALSE' or isadjusted <> 'FALSE' then 'MODIFIED' else 'FALSE' end from v$system_parameter

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

4vs91dcv7u1p6 insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)

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

5s34t44u10q4g SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1

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

63t3ufgq37m0c SELECT instance_number, instance_name, host_name FROM ( SELECT dbin.instance_number as instance_number, max(dbin.instance_name) as instance_name, max(dbin.host_name) as host_name, sum(case when s.snap_id in (:bid, :eid) then 1 else 0 end) as cnt_edge FROM WRM$_SNAPSHOT s , WRM$_DATABASE_INSTANCE dbin WHERE s.dbid = :dbid AND dbin.instance_number = s.instance_number AND s.snap_id >= :bid AND s.snap_id <= :eid AND dbin.dbid = s.dbid AND dbin.startup_time = s.startup_time GROUP BY dbin.instance_number ) WHERE cnt_edge < 2

691p2a1hswk0m insert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type , tablespace_name) select :lah_snap_id , :dbid , ss1.tsn_kewrseg , ss1.objn_kewrseg , ss1.objd_kewrseg , ss1.ownername_kewrseg , ss1.objname_kewrseg , ss1.subobjname_kewrseg , decode(po.parttype, 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN') , sys.dbms_swrf_internal.awr_decode_object_type(ss1.objtype_kewrseg) , ss1.tsname_kewrseg from x$kewrattrnew at, x$kewrtsegstat ss1, (select tp.obj#, pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# union all select ip.obj#, pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj#) po where at.num1_kewrattr = ss1.tsn_kewrseg and at.num2_kewrattr = ss1.objn_kewrseg and at.num3_kewrattr = ss1.objd_kewrseg and at.num2_kewrattr = po.obj#(+) and (ss1.objtype_kewrseg not in (1 /* INDEX - handled below */, 10 /* NON-EXISTENT */) or (ss1.objtype_kewrseg = 1 and 1 = (select 1 from ind$ i where i.obj# = ss1.objn_kewrseg and i.type# in (1, 2, 3, 4, 5, 6, 7, 8, 9)))) and ss1.objname_kewrseg != '_NEXT_OBJECT' and ss1.objname_kewrseg != '_default_auditing_options_'

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

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

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

7dwup5bn902rg BEGIN DBMS_WORKLOAD_REPOSITORY.create_snapshot; END;

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

7hbpb1vnd8nvj SELECT * FROM CRPDTA.F30UI013 WHERE ( LKITM = :KEY1 )

84k66tf2s7y1c insert into wrh$_bg_event_summary (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_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id

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

aktbxfjwnzgmu update WRM$_DATABASE_INSTANCE set last_ash_sample_id = :last_ash_sample_id where instance_number = :instance_number and dbid = :dbid and startup_time = (select max(startup_time) from WRM$_DATABASE_INSTANCE where instance_number = :instance_number2 and dbid = :dbid2 )

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

c8gnrhxma4tas SELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1

d37dg314005wr MERGE /*+ opt_param('_optimizer_mjc_enabled', 'false') */ INTO wrh$_datafile dfh USING ( SELECT /*+ ordered */ dfh0.dbid, dfh0.file#, dfh0.creation_change#, ts.name tsname, v.name name FROM v$dbfile v, file$ f, ts$ ts, wrh$_datafile dfh0 WHERE dfh0.dbid = :dbid AND dfh0.snap_id < :snap_id AND dfh0.file# = f.file# AND dfh0.creation_change# = f.crscnbas + (f.crscnwrp * power(2, 32)) AND f.status$ = 2 AND f.ts# = ts.ts# AND f.file# = v.file#) s ON (dfh.dbid = s.dbid AND dfh.file# = s.file# AND dfh.creation_change# = s.creation_change#) WHEN MATCHED THEN UPDATE SET snap_id = :lah_snap_id, filename = s.name, tsname = s.tsname

f711myt0q6cma insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)

f80h0xb1qvbsk SELECT sys.wri$_adv_seq_msggroup.nextval FROM dual

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

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

gdn3ysuyssf82 SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1

grwydz59pu6mc select text from view$ where rowid=:1

SQL Id	SQL Text
017cf5jjx56jh	SELECT COUNT() FROM (SELECT FROM DBA_HIST_ACTIVE_SESS_HISTORY WHERE DBID = 3035399126 AND SNAP_ID > 1955 AND SNAP_ID <= 1956 AND SESSION_TYPE = 'FOREGROUND' AND WAIT_CLASS_ID = 3386400367 AND SESSION_STATE = 'WAITING')
062savj8zgzut	UPDATE sys.wri$_adv_parameters SET datatype = :1, value = :2, flags = :3, description = :4 WHERE task_id = :5 AND name = :6
0hz0861v91651	UPDATE CRPDTA.F30UI013 SET LKITM=:BND1, LKLLX=:BND2 WHERE ( LKITM = :KEY1 )
0jfcj2hwxrhc4	SELECT OMENHV, OMAPPLID, OMOBNM, OMDATP, OMDATS, OMUGRP, OMOAPP, OMDATM, OMOVRE, OMSY, OMSTSO, OMFUNO, OMOCM2, OMOCMDSC FROM SVM900.F986101 WHERE ( OMENHV = :KEY1 AND OMSTSO = :KEY2 AND ( OMUGRP = :KEY3 OR OMUGRP = :KEY4 OR OMUGRP = :KEY5 OR OMUGRP = :KEY6 ) ) ORDER BY OMSTSO ASC, OMAPPLID ASC
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
1198upp2uraxj	SELECT * FROM CRPDTA.F0010 WHERE ( CCCO = :KEY1 ) ORDER BY CCCO ASC
15rbgh4d2ku4u	insert into WRM$_SNAPSHOT (snap_id, dbid, instance_number, startup_time, begin_interval_time, end_interval_time, snap_level, status, error_count, bl_moved, snap_flag, snap_timezone) values (:snap_id, :dbid, :instance_number, :startup_time, :begin_interval_time, :end_interval_time, :snap_level, :status, 0, 0, :bind1, :bind2)
1cq3qr774cu45	insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum (small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
1pbs13r5f6js7	SELECT VALUE FROM V$PARAMETER WHERE NAME = 'open_cursors'
1w2vta5jv74ky	SELECT OBJECT_NAME FROM SYS.ALL_OBJECTS WHERE ( OBJECT_NAME = :KEY1 AND OBJECT_TYPE = :KEY2 AND OWNER = :KEY3 )
2gxbvynrd71dr	INSERT INTO sys.wri$_adv_rec_actions (task_id, rec_id, act_id) VALUES (:1, :2, :3)
2hvv64zmrk00p	DELETE FROM CRPDTA.F30UI010 WHERE ( WFKIT = :KEY1 AND WFITM = :KEY2 )
2j0fw19fph49j	SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE _INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time
317v5hnvvd49h	UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'\|\| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LO B', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat)
338sv20sv2kdn	SELECT * FROM PY900.F98740PYODATEST WHERE ( ELPRDTYP = :KEY1 AND ELOBNM = :KEY2 ) ORDER BY ELPRDTYP ASC, ELOBNM ASC, ELVERS ASC, ELFMNM ASC, ELCTRLID ASC, ELWEVENT ASC, ELERID3 ASC
3dyfgxpt4yvb5	SELECT * FROM PY900.F98762PYODATEST WHERE ( BCFNNM = :KEY1 )
3m8smr0v7v1m6	INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
3s58mgk0uy2ws	insert into wrm$_snapshot_details (snap_id, dbid, instance_number, table_id, begin_time, end_time) values (:snap_id, :dbid, :instance_number, :bind1, :bind2, :bind3)
3sqgkcng6vx8r	INSERT INTO sys.wri$_adv_rationale (id, task_id, rec_id, obj_id, impact_msg_id, impact_val, msg_id, type, attr1, attr2, attr3, attr4, attr5, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, ' ', :13) RETURNING rowid INTO :14
42mkua34ay6bc	INSERT INTO wri$_adv_addm_fdg ( TASK_ID, FINDING_ID, RULE_ID, ADDM_FDG_ID, ADDM_SEQ, DATABASE_TIME, ACTIVE_SESSIONS, PERC_ACTIVE_SESS, IS_AGGREGATE, METER_LEVEL, QUERY_TYPE, QUERY_IS_APPROX, QUERY_ARGS) VALUES ( :tid, :kea_id, :rid, :fdg_id, :keh_id, :dbt, round(:dbt / (1000000 * :sint) , 2), round(((:dbt * 100) / :total_dbt) , 2), 'N', NULL, :aqt, decode(:aqa, 0, 'N', 'Y'), decode(:aqargs, ' ', NULL, :aqargs))
48s88ugf199v4	insert into wrh$_parameter (snap_id, dbid, instance_number, parameter_hash, value, isdefault, ismodified) select :snap_id, :dbid, :instance_number, hash, substr(value, 1, 512), isdefault, case when ismodified <> 'FALSE' or isadjusted <> 'FALSE' then 'MODIFIED' else 'FALSE' end from v$system_parameter
4dy1xm4nxc0gf	insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id
4vs91dcv7u1p6	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
5h7w8ykwtb2xt	INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
5s34t44u10q4g	SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1
61tn3mam0vq0b	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_nam e = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
63t3ufgq37m0c	SELECT instance_number, instance_name, host_name FROM ( SELECT dbin.instance_number as instance_number, max(dbin.instance_name) as instance_name, max(dbin.host_name) as host_name, sum(case when s.snap_id in (:bid, :eid) then 1 else 0 end) as cnt_edge FROM WRM$_SNAPSHOT s , WRM$_DATABASE_INSTANCE dbin WHERE s.dbid = :dbid AND dbin.instance_number = s.instance_number AND s.snap_id >= :bid AND s.snap_id <= :eid AND dbin.dbid = s.dbid AND dbin.startup_time = s.startup_time GROUP BY dbin.instance_number ) WHERE cnt_edge < 2
691p2a1hswk0m	insert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type , tablespace_name) select :lah_snap_id , :dbid , ss1.tsn_kewrseg , ss1.objn_kewrseg , ss1.objd_kewrseg , ss1.ownername_kewrseg , ss1.objname_kewrseg , ss1.subobjname_kewrseg , decode(po.parttype, 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN') , sys.dbms_swrf_internal.awr_decode_object_type(ss1.objtype_kewrseg) , ss1.tsname_kewrseg from x$kewrattrnew at, x$kewrtsegstat ss1, (select tp.obj#, pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# union all select ip.obj#, pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj#) po where at.num1_kewrattr = ss1.tsn_kewrseg and at.num2_kewrattr = ss1.objn_kewrseg and at.num3_kewrattr = ss1.objd_kewrseg and at.num2_kewrattr = po.obj#(+) and (ss1.objtype_kewrseg not in (1 /* INDEX - handled below /, 10 / NON-EXISTENT */) or (ss1.objtype_kewrseg = 1 and 1 = (select 1 from ind$ i where i.obj# = ss1.objn_kewrseg and i.type# in (1, 2, 3, 4, 5, 6, 7, 8, 9)))) and ss1.objname_kewrseg != '_NEXT_OBJECT' and ss1.objname_kewrseg != '_default_auditing_options_'
69k5bhm12sz98	SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE _INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGR OUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WH ERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
7dwup5bn902rg	BEGIN DBMS_WORKLOAD_REPOSITORY.create_snapshot; END;
7gs8x44r7mpnb	INSERT INTO sys.wri$_adv_actions (id, task_id, obj_id, command, msg_id, flags, attr1, attr2, attr3, attr4, attr5, attr6, num_attr1, num_attr2, num_attr3, num_attr4, num_attr5, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, ' ', ' ', :11, :12, :13, :14, :15, :16) RETURNING rowid INTO :17
7hbpb1vnd8nvj	SELECT * FROM CRPDTA.F30UI013 WHERE ( LKITM = :KEY1 )
84k66tf2s7y1c	insert into wrh$_bg_event_summary (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_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id
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
aktbxfjwnzgmu	update WRM$_DATABASE_INSTANCE set last_ash_sample_id = :last_ash_sample_id where instance_number = :instance_number and dbid = :dbid and startup_time = (select max(startup_time) from WRM$_DATABASE_INSTANCE where instance_number = :instance_number2 and dbid = :dbid2 )
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
c8gnrhxma4tas	SELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1
d37dg314005wr	MERGE /+ opt_param('_optimizer_mjc_enabled', 'false') / INTO wrh$_datafile dfh USING ( SELECT /+ ordered / dfh0.dbid, dfh0.file#, dfh0.creation_change#, ts.name tsname, v.name name FROM v$dbfile v, file$ f, ts$ ts, wrh$_datafile dfh0 WHERE dfh0.dbid = :dbid AND dfh0.snap_id < :snap_id AND dfh0.file# = f.file# AND dfh0.creation_change# = f.crscnbas + (f.crscnwrp * power(2, 32)) AND f.status$ = 2 AND f.ts# = ts.ts# AND f.file# = v.file#) s ON (dfh.dbid = s.dbid AND dfh.file# = s.file# AND dfh.creation_change# = s.creation_change#) WHEN MATCHED THEN UPDATE SET snap_id = :lah_snap_id, filename = s.name, tsname = s.tsname
f711myt0q6cma	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
f80h0xb1qvbsk	SELECT sys.wri$_adv_seq_msggroup.nextval FROM dual
fnz13xnvkybtj	INSERT INTO sys.wri$_adv_findings (id, task_id, type, parent, obj_id, impact_msg_id, impact_val, msg_id, more_info_id, name_msg_code, flags, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
g5vpd5g3y90qv	INSERT INTO sys.wri$_adv_recommendations (id, task_id, finding_id, rank, benefit_msg_id, benefit_val, type, flags, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9)
gdn3ysuyssf82	SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
grwydz59pu6mc	select text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Key Instance Activity Stats
Other Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Key Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
db block changes	32,429	8,209.87	7.85
execute count	7,342	1,858.73	1.78
gc cr block receive time	1	0.25	0.00
gc cr blocks received	131	33.16	0.03
gc current block receive time	4	1.01	0.00
gc current blocks received	164	41.52	0.04
logons cumulative	5	1.27	0.00
opened cursors cumulative	1,025	259.49	0.25
parse count (total)	956	242.03	0.23
parse time elapsed	6	1.52	0.00
physical reads	2	0.51	0.00
physical writes	156	39.49	0.04
redo size	5,620,220	1,422,840.51	1,360.17
session cursor cache hits	836	211.65	0.20
session logical reads	52,550	13,303.80	12.72
user calls	6,823	1,727.34	1.65
user commits	4,131	1,045.82	1.00
user rollbacks	1	0.25	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	205	51.90	0.05

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	1	0.25	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO (space) vector count	0	0.00	0.00
Batched IO block miss count	5	1.27	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	3	0.76	0.00
Batched IO single block count	0	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	2	0.51	0.00
Batched IO vector read count	1	0.25	0.00
Block Cleanout Optim referenced	5	1.27	0.00
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	326	82.53	0.08
CPU used when call started	323	81.77	0.08
CR blocks created	1	0.25	0.00
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	18	4.56	0.00
DBWR checkpoint buffers written	154	38.99	0.04
DBWR checkpoints	0	0.00	0.00
DBWR fusion writes	0	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	0	0.00	0.00
DBWR undo block writes	128	32.41	0.03
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	0	0.00	0.00
DML statements parallelized	0	0.00	0.00
Effective IO time	190	48.10	0.05
HSC Compressed Segment Block Changes	2	0.51	0.00
HSC Heap Segment Block Changes	4,679	1,184.56	1.13
HSC OLTP Compressed Blocks	0	0.00	0.00
HSC OLTP Non Compressible Blocks	0	0.00	0.00
HSC OLTP Space Saving	1,720	435.44	0.42
HSC OLTP inline compression	0	0.00	0.00
HSC OLTP negative compression	0	0.00	0.00
HSC OLTP positive compression	1	0.25	0.00
HSC OLTP recursive compression	1	0.25	0.00
Heap Segment Array Inserts	109	27.59	0.03
Heap Segment Array Updates	8	2.03	0.00
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	2	0.51	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
PX remote messages recv'd	0	0.00	0.00
PX remote messages sent	0	0.00	0.00
Parallel operations downgraded 75 to 99 pct	0	0.00	0.00
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	0	0.00	0.00
Requests to/from client	6,777	1,715.70	1.64
RowCR - row contention	0	0.00	0.00
RowCR attempts	20	5.06	0.00
RowCR hits	20	5.06	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	6,776	1,715.44	1.64
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	66	16.71	0.02
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	25	6.33	0.01
branch node splits	0	0.00	0.00
buffer is not pinned count	14,112	3,572.66	3.42
buffer is pinned count	22,329	5,652.91	5.40
bytes received via SQL*Net from client	426,122	107,878.99	103.13
bytes sent via SQL*Net to client	1,256,118	318,004.56	304.00
calls to get snapshot scn: kcmgss	11,339	2,870.63	2.74
calls to kcmgas	4,440	1,124.05	1.07
calls to kcmgcs	907	229.62	0.22
cell physical IO interconnect bytes	10,621,952	2,689,101.77	2,570.66
change write time	66	16.71	0.02
cleanout - number of ktugct calls	89	22.53	0.02
cleanouts and rollbacks - consistent read gets	3	0.76	0.00
cleanouts only - consistent read gets	22	5.57	0.01
cluster key scan block gets	17	4.30	0.00
cluster key scans	17	4.30	0.00
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	1	0.25	0.00
commit batch/immediate requested	1	0.25	0.00
commit cleanout failures: block lost	28	7.09	0.01
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	8,682	2,197.97	2.10
commit immediate performed	1	0.25	0.00
commit immediate requested	1	0.25	0.00
commit txn count during cleanout	81	20.51	0.02
consistent changes	47	11.90	0.01
consistent gets	23,412	5,927.09	5.67
consistent gets - examination	18,991	4,807.85	4.60
consistent gets direct	2	0.51	0.00
consistent gets from cache	23,410	5,926.58	5.67
consistent gets from cache (fastpath)	4,151	1,050.89	1.00
cursor authentications	26	6.58	0.01
data blocks consistent reads - undo records applied	3	0.76	0.00
db block gets	29,141	7,377.47	7.05
db block gets direct	2	0.51	0.00
db block gets from cache	29,139	7,376.96	7.05
db block gets from cache (fastpath)	5,733	1,451.39	1.39
deferred (CURRENT) block cleanout applications	1,981	501.52	0.48
enqueue conversions	6	1.52	0.00
enqueue releases	10,721	2,714.18	2.59
enqueue requests	10,719	2,713.67	2.59
enqueue timeouts	1	0.25	0.00
enqueue waits	23	5.82	0.01
exchange deadlocks	1	0.25	0.00
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	0	0.00	0.00
free buffer requested	889	225.06	0.22
gc blocks compressed	204	51.65	0.05
gc cr block flush time	0	0.00	0.00
gc cr blocks served	60	15.19	0.01
gc current block flush time	0	0.00	0.00
gc current block pin time	0	0.00	0.00
gc current blocks served	221	55.95	0.05
gc force cr disk read	0	0.00	0.00
gc kbytes saved	802	203.04	0.19
gc kbytes sent	1,447	366.33	0.35
gc local grants	159	40.25	0.04
gc read wait failures	0	0.00	0.00
gc read wait timeouts	0	0.00	0.00
gc read waits	0	0.00	0.00
gc remote grants	161	40.76	0.04
gcs messages sent	4,705	1,191.14	1.14
ges messages sent	77	19.49	0.02
global enqueue get time	6	1.52	0.00
global enqueue gets async	10	2.53	0.00
global enqueue gets sync	7,220	1,827.85	1.75
global enqueue releases	7,188	1,819.75	1.74
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	2	0.51	0.00
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	25	6.33	0.01
immediate (CURRENT) block cleanout applications	4,066	1,029.37	0.98
index crx upgrade (positioned)	3	0.76	0.00
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (direct read)	0	0.00	0.00
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	7,380	1,868.35	1.79
index scans kdiixs1	1,752	443.54	0.42
leaf node 90-10 splits	18	4.56	0.00
leaf node splits	28	7.09	0.01
lob reads	0	0.00	0.00
lob writes	53	13.42	0.01
lob writes unaligned	53	13.42	0.01
logical read bytes from cache	430,473,216	108,980,561.01	104,180.35
max cf enq hold time	0	0.00	0.00
messages received	4,196	1,062.28	1.02
messages sent	4,196	1,062.28	1.02
min active SCN optimization applied on CR	0	0.00	0.00
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	3,785	958.23	0.92
non-idle wait count	60,974	15,436.46	14.76
parse count (describe)	8	2.03	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	33	8.35	0.01
parse time cpu	4	1.01	0.00
physical read IO requests	2	0.51	0.00
physical read bytes	16,384	4,147.85	3.97
physical read total IO requests	157	39.75	0.04
physical read total bytes	2,465,792	624,251.14	596.76
physical read total multi block requests	0	0.00	0.00
physical reads cache	0	0.00	0.00
physical reads cache prefetch	0	0.00	0.00
physical reads direct	2	0.51	0.00
physical reads direct (lob)	2	0.51	0.00
physical reads direct temporary tablespace	2	0.51	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	17	4.30	0.00
physical write bytes	1,277,952	323,532.15	309.28
physical write total IO requests	4,193	1,061.52	1.01
physical write total bytes	8,156,160	2,064,850.63	1,973.90
physical write total multi block requests	8	2.03	0.00
physical writes direct	2	0.51	0.00
physical writes direct (lob)	2	0.51	0.00
physical writes direct temporary tablespace	2	0.51	0.00
physical writes from cache	154	38.99	0.04
physical writes non checkpoint	130	32.91	0.03
pinned buffers inspected	0	0.00	0.00
pinned cursors current	0	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	4	1.01	0.00
queries parallelized	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	7,952	2,013.16	1.92
recursive cpu usage	227	57.47	0.05
redo KB read	0	0.00	0.00
redo blocks checksummed by FG (exclusive)	1,969	498.48	0.48
redo blocks written	13,400	3,392.41	3.24
redo buffer allocation retries	0	0.00	0.00
redo entries	22,539	5,706.08	5.45
redo entries for lost write detection	0	0.00	0.00
redo log space requests	0	0.00	0.00
redo ordering marks	224	56.71	0.05
redo size for direct writes	0	0.00	0.00
redo size for lost write detection	0	0.00	0.00
redo subscn max counts	116	29.37	0.03
redo synch long waits	0	0.00	0.00
redo synch poll writes	4,117	1,042.28	1.00
redo synch polls	1,794	454.18	0.43
redo synch time	29	7.34	0.01
redo synch time (usec)	296,795	75,137.97	71.83
redo synch time overhead (usec)	308,404	78,076.96	74.64
redo synch time overhead count (<128 msec)	0	0.00	0.00
redo synch time overhead count (<2 msec)	2,629	665.57	0.64
redo synch time overhead count (<32 msec)	0	0.00	0.00
redo synch time overhead count (<8 msec)	0	0.00	0.00
redo synch time overhead count (>=128 msec)	0	0.00	0.00
redo synch writes	4,117	1,042.28	1.00
redo wastage	1,014,584	256,856.71	245.54
redo write broadcast ack count	1,095	277.22	0.27
redo write broadcast ack time	30,583	7,742.53	7.40
redo write broadcast lgwr post count	0	0.00	0.00
redo write info find	2,629	665.57	0.64
redo write info find fail	0	0.00	0.00
redo write time	47	11.90	0.01
redo writes	4,157	1,052.41	1.01
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	2	0.51	0.00
rollbacks only - consistent read gets	0	0.00	0.00
root node splits	0	0.00	0.00
rows fetched via callback	2,740	693.67	0.66
session connect time	0	0.00	0.00
shared hash latch upgrades - no wait	124	31.39	0.03
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	169	42.78	0.04
sorts (rows)	10,285	2,603.80	2.49
sql area evicted	0	0.00	0.00
sql area purged	0	0.00	0.00
switch current to new buffer	6	1.52	0.00
table fetch by rowid	13,220	3,346.84	3.20
table fetch continued row	0	0.00	0.00
table scan blocks gotten	1,528	386.84	0.37
table scan rows gotten	70,968	17,966.58	17.18
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	53	13.42	0.01
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	0	0.00	0.00
total number of cf enq holders	0	0.00	0.00
total number of times SMON posted	1	0.25	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	1	0.25	0.00
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	1,678,392	424,909.37	406.19
user logons cumulative	5	1.27	0.00
user logouts cumulative	5	1.27	0.00
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
logons current	58	58
opened cursors current	227	227
session cursor cache count	2,948,388	2,948,555
session pga memory	11,964,790,672	11,963,938,704
session pga memory max	16,242,197,008	16,241,738,256
session uga memory	120,735,018,768	120,735,183,808
session uga memory max	798,255,796,312	798,267,863,864
workarea memory allocated	152,254	152,254

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

IOStat by Function summary
IOStat by Filetype summary
IOStat by Function/Filetype summary
Tablespace IO Stats
File IO Stats

IOStat by Function summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
ordered by (Data Read + Write) desc

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
LGWR	0M	0.00	0M	6M	1073.16	1.519M	4216	0.00
DBWR	0M	0.00	0M	3M	6.33	.759M	0
Others	3M	39.24	.759M	0M	1.01	0M	117	0.00
Direct Reads	0M	0.51	0M	0M	0.00	0M	0
TOTAL:	3M	39.75	.759M	9M	1080.51	2.278M	4333	0.00

Back to IO Stats
Back to Top

IOStat by Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Small Read and Large Read are average service times, in milliseconds
Ordered by (Data Read + Write) desc

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read
Log File	0M	0.00	0M	6M	1073.92	1.519M
Data File	0M	2.78	0M	3M	6.33	.759M	0.00
Control File	2M	36.46	.506M	0M	0.51	0M	0.00
Temp File	0M	0.51	0M	0M	0.51	0M	0.00
TOTAL:	2M	39.75	.506M	9M	1081.27	2.278M	0.00

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Ordered by (Data Read + Write) desc for each function

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
LGWR	0M	0.00	0M	6M	1074.94	1.519M	0
LGWR (Log File)	0M	0.00	0M	6M	1074.94	1.519M	0
DBWR	0M	0.00	0M	3M	6.33	.759M	0
DBWR (Data File)	0M	0.00	0M	3M	6.33	.759M	0
Others	2M	39.24	.506M	0M	1.01	0M	115	0.00
Others (Control File)	2M	36.46	.506M	0M	0.51	0M	104	0.00
Others (Data File)	0M	2.78	0M	0M	0.51	0M	11	0.00
Direct Reads	0M	0.51	0M	0M	0.00	0M	0
Direct Reads (Data File)	0M	0.51	0M	0M	0.00	0M	0
TOTAL:	2M	39.75	.506M	9M	1082.28	2.278M	115	0.00

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rds/s	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes avg/s	Av Writes(ms)
UNDOTBS1	0	0	0.00	10	0.00	3	1.00
CRPINDEX2	0	0	0.00	5	0.00	1	0.00
TEMP	2	1	1.00	2	0.51	1	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Av Buf Wt(ms)
CRPINDEX2	/u02/app/oracle/oradata/datastore/.ACFS/snaps/JDETEST/JDETEST/datafile/o1_mf_crpindex_do74kgb1_.dbf	0	0			0		5	1	0.00
TEMP	/u02/app/oracle/oradata/datastore/.ACFS/snaps/JDETEST/JDETEST/datafile/o1_mf_temp_do1bjob2_.tmp	2	1	0.00	1.00	1	0.00	2	1
UNDOTBS1	/u02/app/oracle/oradata/datastore/.ACFS/snaps/JDETEST/JDETEST/datafile/o1_mf_undotbs1_dnz09x39_.dbf	0	0			0		10	3	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

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	25,555,740	100	52,504	0	154	0	0	0

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 156

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	154	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats
MTTR Advisory
Buffer Pool Advisory
Buffer Cache Advisory (for ADDM)
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
PGA Target Advisory (for ADDM)
Shared Pool Advisory
Shared Pool Advisory (for ADDM)
SGA Target Advisory
SGA Target Advisory (for ADDM)
Streams Pool Advisory
Streams Pool Advisory (for ADDM)
Java Pool Advisory

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	150	36	15848	826702	3397383	3397383	4885777		6622	17
E	150	36	16411	832328	3397383	3397383	4888522		6622	17

Back to Advisory Statistics
Back to Top

MTTR Advisory

Only rows at end snap are displayed
Estimated Writes and I/Os are in thousands

Size for Est (s)	Dirty Limit	Est Cache Writes	Est Cache Write Fctr	Est Total Writes	Est Total Write Fctr
30	43,913	29,310	1.14	41,828	1.09
70	102,464	27,101	1.05	39,618	1.04
110	161,015	26,254	1.02	38,771	1.01
150	219,566	25,901	1.01	38,418	1.00
200	292,143	25,753	1.00	38,270	1.00

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 (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	21,504	0.10	2,520	1.05	14,045	1	984.00
D	43,008	0.20	5,039	1.03	13,783	1	951.00
D	64,512	0.30	7,559	1.02	13,650	1	934.00
D	86,016	0.39	10,078	1.02	13,562	1	923.00
D	107,520	0.49	12,598	1.01	13,481	1	913.00
D	129,024	0.59	15,117	1.01	13,412	1	904.00
D	150,528	0.69	17,637	1.00	13,358	1	898.00
D	172,032	0.79	20,157	1.00	13,343	1	896.00
D	193,536	0.89	22,676	1.00	13,343	1	896.00
D	215,040	0.99	25,196	1.00	13,343	1	896.00
D	218,112	1.00	25,556	1.00	13,343	1	896.00
D	236,544	1.08	27,715	1.00	13,343	1	896.00
D	258,048	1.18	30,235	1.00	13,343	1	896.00
D	279,552	1.28	32,755	1.00	13,343	1	896.00
D	301,056	1.38	35,274	1.00	13,343	1	896.00
D	322,560	1.48	37,794	1.00	13,343	1	896.00
D	344,064	1.58	40,313	1.00	13,343	1	896.00
D	365,568	1.68	42,833	1.00	13,343	1	896.00
D	387,072	1.77	45,352	1.00	13,343	1	896.00
D	408,576	1.87	47,872	1.00	13,343	1	896.00
D	430,080	1.97	50,392	0.97	12,948	1	846.00

Back to Advisory Statistics
Back to Top

Buffer Cache Advisory (for ADDM)

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

ON	Block Size	Size Factr	Size for Est (M) Beg Snap	Size for Est (M) End Snap	Est Physical Read Factor
ON	8192	0.10	21,504	21,504	1.33
ON	8192	0.20	43,008	43,008	1.00
ON	8192	0.30	64,512	64,512	1.00
ON	8192	0.39	86,016	86,016	1.00
ON	8192	0.49	107,520	107,520	1.00
ON	8192	0.59	129,024	129,024	1.00
ON	8192	0.69	150,528	150,528	1.00
ON	8192	0.79	172,032	172,032	1.00
ON	8192	0.89	193,536	193,536	1.00
ON	8192	0.99	215,040	215,040	1.00
ON	8192	1.00	218,112	218,112	1.00
ON	8192	1.08	236,544	236,544	1.00
ON	8192	1.18	258,048	258,048	1.00
ON	8192	1.28	279,552	279,552	1.00
ON	8192	1.38	301,056	301,056	1.00
ON	8192	1.48	322,560	322,560	1.00
ON	8192	1.58	344,064	344,064	1.00
ON	8192	1.68	365,568	365,568	1.00
ON	8192	1.77	387,072	387,072	1.00
ON	8192	1.87	408,576	408,576	1.00
ON	8192	1.97	430,080	430,080	1.00

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	70	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	245,760	220,613	947.48	148.69	15.69	100.00	0.00	1,048,576
E	245,760	220,610	947.10	148.69	15.70	100.00	0.00	1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	125	125
64K	128K	6	6
256K	512K	4	4
512K	1024K	44	44
1M	2M	24	24
2M	4M	2	2

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd Time
30,720	0.13	851,912.54	25,345.02	97.00	9,406,458
61,440	0.25	851,912.54	25,345.02	97.00	9,406,458
122,880	0.50	851,912.54	25,345.02	97.00	9,406,458
184,320	0.75	851,912.54	25,345.02	97.00	9,406,458
245,760	1.00	851,912.54	23,463.32	97.00	9,386,281
294,912	1.20	851,912.54	23,463.32	97.00	9,386,281
344,064	1.40	851,912.54	23,463.32	97.00	9,386,281
393,216	1.60	851,912.54	23,463.32	97.00	9,386,281
442,368	1.80	851,912.54	23,463.32	97.00	9,386,281
491,520	2.00	851,912.54	23,463.32	97.00	9,386,281
737,280	3.00	851,912.54	23,463.32	97.00	9,386,281
983,040	4.00	851,912.54	23,463.32	97.00	9,386,281
1,474,560	6.00	851,912.54	23,463.32	97.00	9,386,281
1,966,080	8.00	851,912.54	23,463.32	97.00	9,386,281

Back to Advisory Statistics
Back to Top

PGA Target Advisory (for ADDM)

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

PGA Size Factor	Beg snap PGA Size Mb	End snap PGA Size Mb	M bytes Processed
0.13	30,720	30,720	70
0.25	61,440	61,440	70
0.50	122,880	122,880	70
0.75	184,320	184,320	70
1.00	245,760	245,760	70
1.20	294,912	294,912	70
1.40	344,064	344,064	70
1.60	393,216	393,216	70
1.80	442,368	442,368	70
2.00	491,520	491,520	70
3.00	737,280	737,280	70
4.00	983,040	983,040	70
6.00	1,474,560	1,474,560	70
8.00	1,966,080	1,966,080	70

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)
14,336	0.65	522	27,733	3,591,430	1.00	5,508	1.00	297,563
16,896	0.77	1,180	53,606	3,591,446	1.00	5,492	1.00	297,565
17,408	0.79	1,180	53,606	3,591,446	1.00	5,492	1.00	297,565
17,920	0.81	1,180	53,606	3,591,446	1.00	5,492	1.00	297,565
18,432	0.84	1,180	53,606	3,591,446	1.00	5,492	1.00	297,565
18,944	0.86	1,180	53,606	3,591,446	1.00	5,492	1.00	297,565
19,456	0.88	1,180	53,606	3,591,446	1.00	5,492	1.00	297,565
19,968	0.91	1,180	53,606	3,591,446	1.00	5,492	1.00	297,565
20,480	0.93	1,180	53,606	3,591,446	1.00	5,492	1.00	297,565
20,992	0.95	1,180	53,606	3,591,446	1.00	5,492	1.00	297,565
21,504	0.98	1,180	53,606	3,591,446	1.00	5,492	1.00	297,565
22,016	1.00	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
22,528	1.02	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
23,040	1.05	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
23,552	1.07	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
24,064	1.09	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
24,576	1.12	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
25,088	1.14	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
25,600	1.16	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
26,112	1.19	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
26,624	1.21	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
27,136	1.23	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
29,696	1.35	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
32,256	1.47	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
34,816	1.58	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
37,376	1.70	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
39,936	1.81	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
42,496	1.93	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011
45,056	2.05	1,180	53,606	3,591,446	1.00	5,492	1.00	298,011

Back to Advisory Statistics
Back to Top

Shared Pool Advisory (for ADDM)

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.

SP Size Factor	Total Time Saved Seconds	Beg Snap Shared Pool Size Mb	End Snap Shared Pool Size Mb	Beg Snap Lib Cache Size Mb	End Snap Lib Cache Size Mb
0.65	9	14,336	14,336	522	522
0.77	9	16,896	16,896	1,180	1,180
0.79	9	17,408	17,408	1,180	1,180
0.81	9	17,920	17,920	1,180	1,180
0.84	9	18,432	18,432	1,180	1,180
0.86	9	18,944	18,944	1,180	1,180
0.88	9	19,456	19,456	1,180	1,180
0.91	9	19,968	19,968	1,180	1,180
0.93	9	20,480	20,480	1,180	1,180
0.95	9	20,992	20,992	1,180	1,180
0.98	9	21,504	21,504	1,180	1,180
1.00	9	22,016	22,016	1,180	1,180
1.02	9	22,528	22,528	1,180	1,180
1.05	9	23,040	23,040	1,180	1,180
1.07	9	23,552	23,552	1,180	1,180
1.09	9	24,064	24,064	1,180	1,180
1.12	9	24,576	24,576	1,180	1,180
1.14	9	25,088	25,088	1,180	1,180
1.16	9	25,600	25,600	1,180	1,180
1.19	9	26,112	26,112	1,180	1,180
1.21	9	26,624	26,624	1,180	1,180
1.23	9	27,136	27,136	1,180	1,180
1.35	9	29,696	29,696	1,180	1,180
1.47	9	32,256	32,256	1,180	1,180
1.58	9	34,816	34,816	1,180	1,180
1.70	9	37,376	37,376	1,180	1,180
1.81	9	39,936	39,936	1,180	1,180
1.93	9	42,496	42,496	1,180	1,180
2.05	9	45,056	45,056	1,180	1,180

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
46,080	0.19	584,719	14,044,642
61,440	0.25	584,660	13,783,123
76,800	0.31	584,660	13,783,123
92,160	0.38	584,660	13,649,695
107,520	0.44	584,602	13,561,632
122,880	0.50	584,602	13,480,241
138,240	0.56	584,602	13,480,241
153,600	0.63	584,602	13,412,193
168,960	0.69	584,602	13,358,821
184,320	0.75	584,602	13,342,810
199,680	0.81	584,602	13,342,810
215,040	0.88	584,602	13,342,810
230,400	0.94	584,602	13,342,810
245,760	1.00	584,602	13,342,810
261,120	1.06	584,602	13,342,810
276,480	1.13	584,602	13,342,810
291,840	1.19	584,602	13,342,810
307,200	1.25	584,602	13,342,810
322,560	1.31	584,602	13,342,810
337,920	1.38	584,602	13,342,810
353,280	1.44	584,602	13,342,810
368,640	1.50	584,602	13,342,810
384,000	1.56	584,602	13,342,810
399,360	1.63	584,602	13,342,810
414,720	1.69	584,602	13,342,810
430,080	1.75	584,544	12,947,863
445,440	1.81	584,544	12,947,863
460,800	1.88	584,544	12,947,863
476,160	1.94	584,544	12,947,863
491,520	2.00	584,544	12,947,863

Back to Advisory Statistics
Back to Top

SGA Target Advisory (for ADDM)

The Estimated DB Time and Estimated Physical Reads values are diffs of the begin and end values.
Note: The output is invalid if the Begin Snap SGA Target Size is different from the End Snap SGA Target Size.

SGA Size Factor	Beg Snap SGA Target Size(M)	End Snap SGA Target Size(M)	Est DB Time (s)
0.19	46,080	46,080	6
0.25	61,440	61,440	6
0.31	76,800	76,800	6
0.38	92,160	92,160	5
0.44	107,520	107,520	5
0.50	122,880	122,880	5
0.56	138,240	138,240	5
0.63	153,600	153,600	5
0.69	168,960	168,960	5
0.75	184,320	184,320	5
0.81	199,680	199,680	5
0.88	215,040	215,040	5
0.94	230,400	230,400	5
1.00	245,760	245,760	6
1.06	261,120	261,120	5
1.13	276,480	276,480	5
1.19	291,840	291,840	5
1.25	307,200	307,200	5
1.31	322,560	322,560	5
1.38	337,920	337,920	5
1.44	353,280	353,280	5
1.50	368,640	368,640	5
1.56	384,000	384,000	5
1.63	399,360	399,360	5
1.69	414,720	414,720	5
1.75	430,080	430,080	5
1.81	445,440	445,440	5
1.88	460,800	460,800	5
1.94	476,160	476,160	5
2.00	491,520	491,520	5

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory (for ADDM)

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Av Wt Time(ms)
WF-AWR Flush	23	23	0	16	0.63
TX-Transaction (index contention)	2	2	0	2	0.00
AF-Advisor Framework (task serialization)	13	13	0	1	0.00
HW-Segment High Water Mark	8	8	0	1	0.00
CO-KTUCLO Master Slave enq (master slave det)	1	0	1	1	0.00
TA-Instance Undo	1	1	0	1	0.00
TD-KTF map table enqueue (KTF dump entries)	1	1	0	1	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0
ASM db client latch	2	0.00		0
ASM map operation hash table	1	0.00		0
AWR Alerted Metric Element list	8	0.00		0
Change Notification Hash table latch	1	0.00		0
Consistent RBA	4,166	0.00		0
DML lock allocation	8,653	0.00		0
Event Group Locks	11	0.00		0
FAL Queue	1	0.00		0
FOB s.o list latch	37	0.00		0
File State Object Pool Parent Latch	1	0.00		0
I/O Staticstics latch	1	0.00		0
IPC other latch	2	0.00		0
IPC stats buffer allocation latch	10	0.00		17	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	1	0.00		0
JS broadcast add buf latch	1	0.00		0
JS broadcast drop buf latch	1	0.00		0
JS broadcast load blnc latch	1	0.00		0
JS queue access latch	1	0.00		0
JS queue state obj latch	36	0.00		0
JS slv state obj latch	1	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	162	0.00		22	0.00
KJCT flow control latch	9,339	0.00		0
KMG MMAN ready and startup request latch	1	0.00		0
KSXR large replies	2	0.00		0
KTF sga latch	2	0.00		2	0.00
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	1	0.00		0
Memory Management Latch	1	0.00		1	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	1	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	21	0.00		0
OS process allocation	18	0.00		0
OS process: request allocation	10	0.00		0
PL/SQL warning settings	9	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Result Cache: MB Latch	4,097	0.00		0
Result Cache: RC Latch	4,097	0.00		0
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	1	0.00		1	0.00
SQL memory manager workarea list latch	403	0.00		0
Shared B-Tree	1	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
WCR: sync	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
X$KSFQP	1	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	17	0.00		0
active service list	120	0.00		1,052	0.00
archive control	1	0.00		0
archive process latch	3	0.00		0
buffer pool	1	0.00		0
business card	1	0.00		0
cache buffer handles	282	0.00		0
cache buffers chains	154,542	0.00		2,942	0.00
cache buffers lru chain	1,048	0.00		2,686	0.00
call allocation	60	0.00		0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	13	0.00		0
channel operations parent latch	513,359	0.00	0.00	0
checkpoint queue latch	783	0.00		777	0.00
client/application info	37	0.00		0
compile environment latch	5	0.00		0
corrupted undo seg latch	7	0.00		0
cp cmon/server latch	1	0.00		0
cp pool latch	1	0.00		0
cp server hash latch	1	0.00		0
cvmap freelist lock	1	0.00		0
done queue latch	1	0.00		0
dummy allocation	11	0.00		0
eighth spare latch - X parent	1	0.00		0
eleventh spare latch - children	1	0.00		0
enqueue freelist latch	1	0.00		4,414	0.00
enqueue hash chains	34,355	0.00		0
fifteenth spare latch - children	1	0.00		0
file cache latch	19	0.00		0
first Audit Vault latch	5	0.00		0
flashback copy	1	0.00		0
fourteenth spare latch - children	1	0.00		0
fourth Audit Vault latch	1	0.00		0
gc element	2,526	0.00		52	0.00
gcs commit scn state	1	0.00		0
gcs opaque info freelist	468	0.00		0
gcs partitioned table hash	2,385	0.00		0
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	2	0.00		0
gcs resource freelist	142	0.00		0
gcs resource hash	2,408	0.17	0.00	0
gcs resource scan list	1	0.00		0
gcs resource validate list	1	0.00		0
gcs shadows freelist	200	0.00		0
ges caches resource lists	4,777	0.02	0.00	126	0.00
ges deadlock list	4	0.00		0
ges domain table	14,409	0.00		0
ges enqueue table freelist	14,450	0.00		0
ges group table	14,415	0.00		0
ges process hash list	27	0.00		0
ges process parent latch	28,962	0.00		0
ges process table freelist	10	0.00		0
ges resource hash list	24,696	0.01	1.00	0
ges resource scan list	1	0.00		0
ges resource table freelist	13	0.00		0
ges timeout list	12	0.00		0
ges value block free list	1	0.00		0
global KZLD latch for mem in SGA	5	0.00		0
global tx hash mapping	1	0.00		0
granule operation	1	0.00		0
hash table column usage latch	0			747	0.00
hash table modification latch	10	0.00		0
heartbeat check	1	0.00		4	0.00
heartbeat structure management	0			1	0.00
internal temp table object number allocation latch	6	0.00		0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	1	0.00		0
job_queue_processes parameter latch	1	0.00		0
k2q global data latch	2	0.00		0
k2q lock allocation	1	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kgnfs mount latch	1	0.00		0
kokc descriptor allocation latch	4	0.00		0
ksfv messages	1	0.00		0
ksim group membership cache	1	0.00		0
ksim membership request latch	4	0.00		4	0.00
kss move lock	1	0.00		0
ksuosstats global area	3	0.00		0
ksv class latch	7	0.00		0
ksv msg queue latch	1	0.00		0
ksxp shared latch	10	0.00		0
ksxp so latch	10	0.00		0
ksz_so allocation latch	10	0.00		0
ktm global data	5	0.00		0
lgwr LWN SCN	4,165	0.00		0
list of block allocation	34	0.00		0
loader state object freelist	12	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	1	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	1	0.00		0
logminer local	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	1	0.00		0
managed standby latch	1	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	12,320	0.00		0
messages	37,303	0.01	0.00	0
mostly latch-free SCN	4,168	0.02	0.00	0
msg queue latch	1	0.00		0
multiblock read objects	496	0.00		0
name-service memory objects	14	0.00		0
name-service namespace bucket	30	0.00		0
name-service pending queue	14	0.00		0
name-service request queue	52	0.00		0
nineth spare latch - X parent	1	0.00		0
object queue header heap	221	0.00		73	0.00
object queue header operation	3,000	0.00		0
object stats modification	1	0.00		0
parallel query alloc buffer	5	0.00		0
parallel query stats	1	0.00		0
parallel txn reco latch	42	0.00		0
parameter list	48	0.00		0
parameter table management	10	0.00		0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
post/wait queue	141	0.00		137	0.00
process allocation	29	0.00		5	0.00
process group creation	10	0.00		0
process queue	1	0.00		0
process queue reference	1	0.00		0
query server freelists	1	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	12,493	0.18	0.59	22,520	0.09
redo copy	1	0.00		22,528	12.99
redo writing	12,502	0.00		0
resmgr group change latch	5	0.00		0
resmgr:active threads	11	0.00		0
resmgr:actses change group	6	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	10	0.00		0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	51	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	7,717	0.00		0
second Audit Vault latch	1	0.00		0
sequence cache	240	0.00		0
session allocation	4,153	0.00		4,143	0.00
session idle bit	17,803	0.00		0
session queue latch	1	0.00		0
session state list latch	4	0.00		0
session switching	6	0.00		0
session timer	1	0.00		0
seventh spare latch - X parent	1	0.00		0
shared pool	5,684	0.04	0.00	0
shared pool sim alloc	1	0.00		0
shared pool simulator	39	0.00		0
sim partition latch	2	0.00		32	0.00
simulator hash latch	1,819	0.00		0
simulator lru latch	1	0.00		1,810	0.00
sixth spare latch - X parent	1	0.00		0
sort extent pool	13	0.00		0
space background task latch	10	0.00		3	0.00
state object free list	12	0.00		0
statistics aggregation	140	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	4	0.00		0
tenth spare latch - X parent	1	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
thirteenth spare latch - children	1	0.00		0
transaction allocation	22	0.00		0
twelfth spare latch - children	1	0.00		0
twenty-fifth spare latch - S par	1	0.00		0
twenty-first spare latch - S par	1	0.00		0
twenty-fourth spare latch - S par	1	0.00		0
twenty-second spare latch - S par	1	0.00		0
twenty-third spare latch - S par	1	0.00		0
undo global data	13,009	0.00		17	0.00
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0
write info latch	0			5,255	0.40

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
redo allocation	12,493	22	13	9
ges resource hash list	24,696	2	2	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
ges resource hash list	kjakcai: search for resp by resname	1	1
ges resource hash list	kjrmas1: lookup master node	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	13	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 52,550
Captured Segments account for 75.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
CRPDTA	CRPINDEX2	F30UI010_PK	INDEX	11,584	22.04
CRPDTA	CRPINDEX2	F30UI013_PK	INDEX	8,176	15.56
CRPDTA	CRPINDEX2	F30UI010_2	INDEX	5,840	11.11
CRPDTA	CRPDATA	F30UI013	TABLE	3,776	7.19
CRPDTA	CRPDATA	F30UI010	TABLE	2,352	4.48

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	98.95	Soft Parse %:	96.55
Execute to Parse %:	86.98	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	66.67	% Non-Parse CPU:	98.85

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSAUX	WRH$_PARAMETER_PK	WRH$_PARAME_3035399126_1825	INDEX PARTITION	10	7.63
SYS	SYSAUX	WRH$_SYSSTAT_PK	WRH$_SYSSTA_3035399126_1825	INDEX PARTITION	8	6.11
SYS	SYSAUX	WRH$_SYSSTAT	WRH$_SYSSTA_3035399126_1825	TABLE PARTITION	7	5.34
SYS	SYSAUX	WRH$_SYSTEM_EVENT_PK	WRH$_SYSTEM_3035399126_1825	INDEX PARTITION	6	4.58
SYS	SYSAUX	WRH$_SQLSTAT_PK	WRH$_SQLSTA_3035399126_1825	INDEX PARTITION	5	3.82

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSAUX	WRM$_SNAPSHOT_DETAILS_INDEX		INDEX	12	7.32
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	WRH$_SQLSTA_3035399126_1825	INDEX PARTITION	7	4.27
SYS	SYSAUX	WRH$_LATCH_MISSES_SUMMARY_PK	WRH$_LATCH__3035399126_1825	INDEX PARTITION	6	3.66
SYS	SYSAUX	WRH$_DB_CACHE_ADVICE_PK	WRH$_DB_CAC_3035399126_1825	INDEX PARTITION	5	3.05
SYS	SYSAUX	WRH$_PARAMETER_PK	WRH$_PARAME_3035399126_1825	INDEX PARTITION	5	3.05

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	5	0.00	2	1
dc_global_oids	31	0.00	0	171
dc_histogram_data	424	0.00	0	34,907
dc_histogram_defs	349	0.00	0	18,477
dc_objects	638	0.00	0	19,451
dc_profiles	10	0.00	0	1
dc_rollback_segments	71	0.00	0	44
dc_segments	258	0.39	1	5,194
dc_sequences	6	0.00	6	12
dc_tablespaces	340	0.00	0	13
dc_users	867	0.00	0	213
global database name	9	0.00	0	1

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
ACCOUNT_STATUS	15	0.00	0		0
BODY	12	0.00	29	0.00	0
DBLINK	15	0.00	0		0
EDITION	5	0.00	10	0.00	0
INDEX	35	0.00	35	0.00	0
QUEUE	0		2	0.00	0
SCHEMA	5	0.00	0		0
SQL AREA	307	2.28	7,799	1.04	16
SQL AREA BUILD	25	28.00	0		0
SQL AREA STATS	25	36.00	25	36.00	0
TABLE/PROCEDURE	131	0.00	647	0.00	0

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	218,112.00	218,112.00	218,112.00	218,112.00	INI/
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	245,760.00	245,760.00	245,760.00	245,760.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	245,760.00	245,760.00	245,760.00	245,760.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	2,048.00	2,048.00	2,048.00	2,048.00	STA/
large pool	2,048.00	2,048.00	2,048.00	2,048.00	STA/
shared pool	22,016.00	22,016.00	22,016.00	22,016.00	STA/
streams pool	0.00	0.00	0.00	0.00	STA/

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	684.66		6.28	16.46	112	112	109	109
B	SQL	151.09	0.91	1.87	16.55	149	780	81	27
B	Freeable	88.25	0.00	1.15	1.49	10		77	77
B	PL/SQL	23.54	7.85	0.22	0.74	7	7	107	91
E	Other	683.78		6.27	16.46	112	112	109	109
E	SQL	151.09	0.90	1.87	16.55	149	780	81	27
E	Freeable	88.75	0.00	1.15	1.50	10		77	77
E	PL/SQL	23.54	7.85	0.22	0.74	7	7	107	91

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	228,707,008,512
Fixed Size	2,269,072
Redo Buffers	457,895,936
Variable Size	27,380,416,624

Pool	Name	Begin MB	End MB	% Diff
java	free memory	2,048.00	2,048.00	0.00
large	PX msg pool	54.00	54.00	0.00
large	free memory	1,994.00	1,994.00	0.00
shared	KGLH0	491.63	491.75	0.02
shared	SQLA	932.44	932.75	0.03
shared	db_block_hash_buckets	1,424.00	1,424.00	0.00
shared	free memory	7,036.38	7,035.93	-0.01
shared	gc name table	384.00	384.00	0.00
shared	gcs res hash bucket	256.00	256.00	0.00
shared	gcs resources	6,133.95	6,133.95	0.00
shared	gcs shadows	4,246.58	4,246.58	0.00
	buffer_cache	218,112.00	218,112.00	0.00
	fixed_sga	2.16	2.16	0.00
	log_buffer	436.68	436.68	0.00

Name	Avg Conns	Total Disp Time (s)	%Busy	%Idle
D000	0.00	4	0.00	100.00
D000	0.00	4	0.00	100.00
D000		4	0.00	100.00
D000		4	0.00	100.00
Sum	0.00
Avg	0.00		0.00	100.00
Std	0.00		0.00	0.00

Parameter Name	Begin value	End value (if different)
_datafile_write_errors_crash_instance	FALSE
_db_writer_coalesce_area_size	16777216
_disable_interface_checking	TRUE
_enable_NUMA_support	FALSE
_file_size_increase_increment	2143289344
_fix_control	off
_gc_policy_time	0
_gc_undo_affinity	FALSE
audit_file_dest	/u01/app/oracle/admin/JDETEST/adump
audit_sys_operations	TRUE
audit_trail	DB
cluster_database	TRUE
compatible	11.2.0.4.0
control_files	/u01/app/oracle/oradata/datastore/JDETEST/JDETEST/controlfile/o1_mf_dnz09p30_.ctl
cpu_count	16
cursor_sharing	EXACT
db_block_checking	FULL
db_block_checksum	FULL
db_block_size	8192
db_create_file_dest	/u02/app/oracle/oradata/datastore/.ACFS/snaps/JDETEST
db_create_online_log_dest_1	/u01/app/oracle/oradata/datastore/JDETEST
db_domain
db_files	1024
db_lost_write_protect	TYPICAL
db_name	JDETEST
db_recovery_file_dest	/u01/app/oracle/fast_recovery_area/datastore/JDETEST
db_recovery_file_dest_size	499289948160
db_writer_processes	2
diagnostic_dest	/u01/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=JDETESTXDB)
fast_start_mttr_target	300
filesystemio_options	setall
global_names	TRUE
instance_number	1
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=140.83.210.34)(PORT=1521))
log_archive_format	%t_%s_%r.dbf
log_buffer	63995904
nls_language	AMERICAN
nls_territory	NEW ZEALAND
open_cursors	1000
os_authent_prefix
parallel_adaptive_multi_user	FALSE
parallel_degree_limit	2
parallel_degree_policy	LIMITED
parallel_execution_message_size	16384
parallel_force_local	TRUE
parallel_max_servers	400
parallel_min_servers	48
parallel_min_time_threshold	12
parallel_threads_per_cpu	1
pga_aggregate_target	257698037760
plsql_warnings	DISABLE:ALL
processes	2400
remote_listener	sodax6-scan:1521
remote_login_passwordfile	EXCLUSIVE
session_cached_cursors	100
sga_target	257698037760
spfile	/u02/app/oracle/oradata/datastore/.ACFS/snaps/JDETEST/JDETEST/spfileJDETEST.ora
sql92_security	TRUE
thread	1
undo_retention	900
undo_tablespace	UNDOTBS1
use_large_pages	ONLY

	Per Second	Per Transaction
Global Cache blocks received:	74.68	0.07
Global Cache blocks served:	71.14	0.07
GCS/GES messages received:	1,216.71	1.16
GCS/GES messages sent:	1,210.63	1.16
DBWR Fusion writes:	0.00	0.00
Estd Interconnect traffic (KB)	1,640.67

Buffer access - local cache %:	99.44
Buffer access - remote cache %:	0.56
Buffer access - disk %:	0.00

Avg global enqueue get time (ms):	0.0
Avg global cache cr block receive time (ms):	0.1
Avg global cache current block receive time (ms):	0.2
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	3.3
Avg global cache cr block flush time (ms):	0.0
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.9
Avg global cache current block flush time (ms):	0.0

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.1
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:	95.39
% of indirect sent messages:	4.55
% of flow controlled messages:	0.06

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	25	6.33	0.01
acks for commit broadcast(logical)	29	7.34	0.01
broadcast msgs on commit(actual)	4,141	1,048.35	1.00
broadcast msgs on commit(logical)	4,158	1,052.66	1.01
broadcast msgs on commit(wasted)	62	15.70	0.02
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
flow control messages received	0	0.00	0.00
flow control messages sent	3	0.76	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	112	28.35	0.03
gcs ast xid	0	0.00	0.00
gcs blocked converts	225	56.96	0.05
gcs blocked cr converts	101	25.57	0.02
gcs compatible basts	6	1.52	0.00
gcs compatible cr basts (global)	9	2.28	0.00
gcs compatible cr basts (local)	14	3.54	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	0	0.00	0.00
gcs dbwr write request msgs	0	0.00	0.00
gcs delta msgs sent	0	0.00	0.00
gcs delta push aborted by cancel	0	0.00	0.00
gcs delta push aborted by remastering	0	0.00	0.00
gcs delta push cancelled	0	0.00	0.00
gcs delta push cancelled at master	0	0.00	0.00
gcs delta push cancelled by close	0	0.00	0.00
gcs delta push cancelled by consign	0	0.00	0.00
gcs delta push cancelled by cvt ping	0	0.00	0.00
gcs delta push cancelled by dwncvt	0	0.00	0.00
gcs delta push create pi	0	0.00	0.00
gcs delta update master msgs sent	0	0.00	0.00
gcs delta wait aborted by remastering	0	0.00	0.00
gcs delta wait cancelled	0	0.00	0.00
gcs error msgs	0	0.00	0.00
gcs force cr block only	0	0.00	0.00
gcs force cr grant	0	0.00	0.00
gcs force cr no current	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	1	0.25	0.00
gcs immediate (null) converts	239	60.51	0.06
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	0	0.00	0.00
gcs indirect ast	30	7.59	0.01
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	30	7.59	0.01
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)	14	3.54	0.00
gcs msgs received	4,731	1,197.72	1.14
gcs new served by master	64	16.20	0.02
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 push delta	0	0.00	0.00
gcs queued converts	0	0.00	0.00
gcs reader bypass N->Xw ping local	0	0.00	0.00
gcs reader bypass N->Xw ping remote	0	0.00	0.00
gcs reader bypass grant X on assume	0	0.00	0.00
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	0	0.00	0.00
gcs reader bypass grant immediate	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	0	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	0	0.00	0.00
gcs side channel msgs logical	0	0.00	0.00
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)	1	0.25	0.00
ges msgs received	75	18.99	0.02
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	71	17.97	0.02
implicit batch messages sent	6	1.52	0.00
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	3	0.76	0.00
messages queue sent actual	231	58.48	0.06
messages queue sent logical	18	4.56	0.00
messages received actual	4,644	1,175.70	1.12
messages received logical	4,806	1,216.71	1.16
messages sent directly	4,445	1,125.32	1.08
messages sent indirectly	212	53.67	0.05
messages sent not implicit batched	0	0.00	0.00
messages sent pbatched	178	45.06	0.04
msgs causing lmd to send msgs	28	7.09	0.01
msgs causing lms(s) to send msgs	27	6.84	0.01
msgs received queue time (ms)	24	6.08	0.01
msgs received queued	4,806	1,216.71	1.16
msgs sent queue time (ms)	6	1.52	0.00
msgs sent queue time on ksxp (ms)	580	146.84	0.14
msgs sent queued	243	61.52	0.06
msgs sent queued on ksxp	4,721	1,195.19	1.14
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	4,164	1,054.18	1.01
process batch messages sent	124	31.39	0.03

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

Statistic	Total	% <1ms
Pins	0	0.00
Flushes	2	100.00
Writes	0	0.00

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	118	96.61	2.54	0.85	165	88.48	10.30	1.21
2	Others	7	85.71	0.00	14.29	7	100.00	0.00	0.00
2	undo header	6	100.00	0.00	0.00	1	100.00	0.00	0.00
2	undo block	1	100.00	0.00	0.00	0

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
2	data block	0.15	0.14	0.46	0.14	0.17	0.12	0.56	0.11
2	others	0.09	0.09		0.12	0.09	0.09
2	undo header	0.08	0.08			0.10	0.10
2	undo block	0.08	0.08

WORKLOAD REPOSITORY report for

Report Summary

Main Report

RAC Statistics

Wait Events Statistics

Time Model Statistics

Operating System Statistics

Operating System Statistics - Detail

Foreground Wait Class

Foreground Wait Events

Background Wait Events

Wait Event Histogram

Wait Event Histogram Detail (64 msec to 2 sec)

Wait Event Histogram Detail (4 sec to 2 min)

Wait Event Histogram Detail (4 min to 1 hr)

Service Statistics

Service Wait Class Stats

SQL Statistics

SQL ordered by Elapsed Time

SQL ordered by CPU Time

SQL ordered by User I/O Wait Time

SQL ordered by Gets

SQL ordered by Reads

SQL ordered by Physical Reads (UnOptimized)

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

Instance Activity Statistics

Key Instance Activity Stats

Other Instance Activity Stats

Instance Activity Stats - Absolute Values

Instance Activity Stats - Thread Activity

IO Stats

IOStat by Function summary

IOStat by Filetype summary

IOStat by Function/Filetype summary

Tablespace IO Stats

File IO Stats

Buffer Pool Statistics

Buffer Pool Statistics

Checkpoint Activity

Advisory Statistics

Instance Recovery Stats

MTTR Advisory

Buffer Pool Advisory

Buffer Cache Advisory (for ADDM)

PGA Aggr Summary

PGA Aggr Target Stats

PGA Aggr Target Histogram

PGA Memory Advisory

PGA Target Advisory (for ADDM)

Shared Pool Advisory

Shared Pool Advisory (for ADDM)

SGA Target Advisory

SGA Target Advisory (for ADDM)

Streams Pool Advisory

Streams Pool Advisory (for ADDM)

Java Pool Advisory

Wait Statistics

Buffer Wait Statistics

Enqueue Activity

Undo Statistics

Undo Segment Summary

Undo Segment Stats

Latch Statistics

Latch Activity

Latch Sleep Breakdown

Latch Miss Sources

Mutex Sleep Summary

Parent Latch Statistics

Child Latch Statistics

Segment Statistics

Segments by Logical Reads

Segments by Physical Reads

Segments by Physical Read Requests

Segments by UnOptimized Reads

Segments by Optimized Reads

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	0.33	0.39
Parallel Query	0.00	0.00
DB Locks	0.17	0.19
DB Streams	0.00	0.00
Other	0.07	0.02