WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

ORCL 1306904245 orcl 1 22-Aug-12 12:08 11.2.0.3.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ORCL	1306904245	orcl	1	22-Aug-12 12:08	11.2.0.3.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

1AXDXPL14WV0L1 Microsoft Windows IA (32-bit) 2 2 1 3.45

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
1AXDXPL14WV0L1	Microsoft Windows IA (32-bit)	2	2	1	3.45

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 80 22-Aug-12 13:04:36 22 1.7

End Snap: 81 22-Aug-12 13:07:19 24 1.4

Elapsed: 2.72 (mins)

DB Time: 6.58 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	80	22-Aug-12 13:04:36	22	1.7
End Snap:	81	22-Aug-12 13:07:19	24	1.4
Elapsed:		2.72 (mins)
DB Time:		6.58 (mins)

Report Summary

Cache Sizes

Begin End

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

Shared Pool Size: 264M 264M Log Buffer: 5,124K

	Begin	End
Buffer Cache:	424M	424M	Std Block Size:	8K
Shared Pool Size:	264M	264M	Log Buffer:	5,124K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 2.4 0.0 0.00 0.00

DB CPU(s): 0.7 0.0 0.00 0.00

Redo size: 980,863.8 500.8

Logical reads: 14,047.0 7.2

Block changes: 7,883.5 4.0

Physical reads: 0.6 0.0

Physical writes: 29.6 0.0

User calls: 7,834.7 4.0

Parses: 4.7 0.0

Hard parses: 0.4 0.0

W/A MB processed: 0.2 0.0

Logons: 0.1 0.0

Executes: 1,972.9 1.0

Rollbacks: 0.0 0.0

Transactions: 1,958.6

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	2.4	0.0	0.00	0.00
DB CPU(s):	0.7	0.0	0.00	0.00
Redo size:	980,863.8	500.8
Logical reads:	14,047.0	7.2
Block changes:	7,883.5	4.0
Physical reads:	0.6	0.0
Physical writes:	29.6	0.0
User calls:	7,834.7	4.0
Parses:	4.7	0.0
Hard parses:	0.4	0.0
W/A MB processed:	0.2	0.0
Logons:	0.1	0.0
Executes:	1,972.9	1.0
Rollbacks:	0.0	0.0
Transactions:	1,958.6

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.96 Redo NoWait %: 99.99

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

Library Hit %: 100.15 Soft Parse %: 92.50

Execute to Parse %: 99.76 Latch Hit %: 99.61

Parse CPU to Parse Elapsd %: 78.07 % Non-Parse CPU: 95.98

Shared Pool Statistics

Begin End

Memory Usage %: 51.73 52.58

% SQL with executions>1: 76.24 83.24

% Memory for SQL w/exec>1: 60.84 70.91

	Begin	End
Memory Usage %:	51.73	52.58
% SQL with executions>1:	76.24	83.24
% Memory for SQL w/exec>1:	60.84	70.91

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
log file sync	320,008	289	1	73.13	Commit
DB CPU		109		27.56
SQL*Net message to client	640,097	2	0	0.43	Network
log file switch completion	12	1	70	0.21	Configuration
Disk file operations I/O	25	0	17	0.11	User I/O

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

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

38.6 34.0 27.4

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
		38.6	34.0		27.4

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

42.8 59.0 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 3,535.8 3,535.8

SGA use (MB): 736.0 736.0

PGA use (MB): 32.6 32.3

% Host Mem used for SGA+PGA: 21.74 21.73

	Begin	End
Host Mem (MB):	3,535.8	3,535.8
SGA use (MB):	736.0	736.0
PGA use (MB):	32.6	32.3
% Host Mem used for SGA+PGA:	21.74	21.73

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): 395.1s
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	108.88	27.56
sql execute elapsed time	32.76	8.29
parse time elapsed	11.27	2.85
hard parse elapsed time	0.13	0.03
hard parse (sharing criteria) elapsed time	0.13	0.03
PL/SQL execution elapsed time	0.12	0.03
connection management call elapsed time	0.02	0.00
PL/SQL compilation elapsed time	0.00	0.00
repeated bind elapsed time	0.00	0.00
DB time	395.09
background elapsed time	144.77
background cpu time	30.92

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
AVG_BUSY_TIME	11,843
AVG_IDLE_TIME	4,467
AVG_SYS_TIME	5,545
AVG_USER_TIME	6,295
BUSY_TIME	23,699
IDLE_TIME	8,945
SYS_TIME	11,101
USER_TIME	12,598
PHYSICAL_MEMORY_BYTES	3,707,600,896
NUM_CPUS	2
NUM_CPU_CORES	2
NUM_CPU_SOCKETS	1
TCP_RECEIVE_SIZE_MAX	64,512

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
22-Aug 13:04:36	0.00
22-Aug 13:07:19	0.00	72.60	38.59	34.01	27.40	0.00

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 101.8% of Total DB time 395.09 (s)
Total FG Wait Time: 293.21 (s) DB CPU time: 108.88 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Commit	320,008	0	289	1	73.13
DB CPU			109		27.56
Network	640,097	0	2	0	0.43
Configuration	18	0	1	68	0.31
User I/O	69	0	1	10	0.18
Concurrency	2,421	0	0	0	0.10
System I/O	134	0	0	2	0.06
Other	204	0	0	0	0.01

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
log file sync	320,008	0	289	1	1.00	73.13
SQL*Net message to client	640,097	0	2	0	2.00	0.43
log file switch completion	12	0	1	70	0.00	0.21
Disk file operations I/O	25	0	0	17	0.00	0.11
log file switch (checkpoint incomplete)	6	0	0	64	0.00	0.10
control file sequential read	134	0	0	2	0.00	0.06
library cache lock	3	0	0	74	0.00	0.06
db file sequential read	29	0	0	6	0.00	0.04
db file scattered read	15	0	0	8	0.00	0.03
latch: In memory undo latch	1,433	0	0	0	0.00	0.01
buffer busy waits	821	0	0	0	0.00	0.01
cursor: pin S wait on X	2	0	0	14	0.00	0.01
cursor: pin S	34	0	0	1	0.00	0.00
library cache: mutex X	3	0	0	5	0.00	0.00
enq: TX - contention	17	0	0	1	0.00	0.00
latch: enqueue hash chains	47	0	0	0	0.00	0.00
latch free	103	0	0	0	0.00	0.00
latch: cache buffers chains	125	0	0	0	0.00	0.00
latch: undo global data	14	0	0	0	0.00	0.00
jobq slave wait	360	100	180	500	0.00
SQL*Net message from client	640,097	0	154	0	2.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	189,075	0	104	1	0.59	72.18
db file parallel write	559	0	3	5	0.00	2.02
control file sequential read	217	0	1	7	0.00	0.98
control file parallel write	139	0	1	5	0.00	0.52
db file async I/O submit	310	0	1	2	0.00	0.35
os thread startup	8	0	0	32	0.00	0.17
direct path read	11	0	0	15	0.00	0.11
log file sequential read	10	0	0	11	0.00	0.07
LGWR wait for redo copy	2,689	0	0	0	0.01	0.04
direct path write	5	0	0	6	0.00	0.02
db file sequential read	2	0	0	9	0.00	0.01
log file single write	10	0	0	1	0.00	0.01
reliable message	50	0	0	0	0.00	0.00
latch: redo allocation	25	0	0	0	0.00	0.00
rdbms ipc message	73,752	1	1,651	22	0.23
Space Manager: slave idle wait	71	87	328	4621	0.00
DIAG idle wait	327	100	327	1000	0.00
smon timer	10	0	323	32334	0.00
shared server idle wait	6	100	180	30010	0.00
dispatcher timer	3	100	180	60010	0.00
pmon timer	56	95	164	2927	0.00
Streams AQ: qmn slave idle wait	5	0	140	28009	0.00
Streams AQ: qmn coordinator idle wait	9	56	140	15561	0.00
SQL*Net message from client	20	0	0	1	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
Disk file operations I/O	26	19.2	15.4	19.2		15.4	11.5	19.2
LGWR wait for redo copy	2689	100.0	.0
SQL*Net message to client	640.1K	100.0
asynch descriptor resize	13	100.0
buffer busy waits	822	100.0
control file parallel write	139		33.8	39.6	12.9	5.0	7.2	1.4
control file sequential read	351	42.2	24.2	12.0	6.3	11.4	3.4	.6
cursor: pin S	34	94.1		2.9	2.9
cursor: pin S wait on X	2					100.0
db file async I/O submit	310	84.8	5.8	.3	1.0	6.5	1.3	.3
db file parallel write	559	27.2	19.0	22.0	20.2	5.7	3.6	2.3
db file scattered read	12	8.3	8.3	16.7	16.7	41.7	8.3
db file sequential read	28	21.4	14.3	7.1	17.9	28.6	10.7
direct path read	11	9.1			27.3	18.2	45.5
direct path write	5		20.0	20.0	40.0	20.0
enq: FB - contention	5	100.0
enq: TX - contention	17	82.4	17.6
latch free	108	100.0
latch: In memory undo latch	1433	100.0
latch: cache buffers chains	125	100.0
latch: enqueue hash chains	47	100.0
latch: messages	19	100.0
latch: redo allocation	25	100.0
latch: session allocation	1	100.0
latch: undo global data	14	100.0
library cache lock	3							100.0
library cache: mutex X	3	66.7				33.3
log file parallel write	189.1K	97.3	1.6	.6	.3	.1	.1	.1
log file sequential read	10	10.0	10.0	20.0	20.0	20.0	20.0
log file single write	10	70.0	20.0	10.0
log file switch (checkpoint incomplete)	6						33.3	66.7
log file switch completion	12							100.0
log file sync	320K	92.1	5.5	1.1	.6	.4	.2	.1
os thread startup	8						62.5	37.5
reliable message	50	98.0	2.0
DIAG idle wait	326							100.0
SQL*Net message from client	640.1K	99.6	.3	.1	.0	.0	.0
Space Manager: slave idle wait	72	1.4				1.4		2.8	94.4
Streams AQ: qmn coordinator idle wait	9	44.4							55.6
Streams AQ: qmn slave idle wait	5								100.0
class slave wait	2	100.0
dispatcher timer	3								100.0
jobq slave wait	359							100.0
pmon timer	56								100.0
rdbms ipc message	73.8K	98.7	.2	.0	.0	.0	.0	.5	.6
shared server idle wait	6								100.0
smon timer	10							60.0	40.0

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/8s	<1/4s	<1/2s	<1s
		% of Total Waits
Disk file operations I/O	5	80.8	15.4	3.8
control file parallel write	2	98.6	.7	.7
control file sequential read	2	99.4	.3			.3
db file async I/O submit	1	99.7		.3
db file parallel write	13	97.7	1.6	.5	.2
library cache lock	3		33.3	66.7
log file parallel write	106	99.9	.0	.0	.0	.0
log file switch (checkpoint incomplete)	4	33.3		66.7
log file switch completion	12		66.7	33.3
log file sync	480	99.9	.1	.0	.0	.0	.0
os thread startup	3	62.5	37.5

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)
SYS$USERS	395	109	2,292
SYS$BACKGROUND	0	0	3
orcl.usf.ad.usfood.local	0	0	0
orclXDB	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	69	1	2421	0	0	0	640097	2
SYS$BACKGROUND	18	0	9	0	0	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by 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
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 0.5% of Total DB Time (s): 395
Captured PL/SQL account for 0.2% of Total DB Time (s): 395

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.39	1	0.39	0.10	51.67	45.93	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0.34	1	0.34	0.09	95.52	0.00	dayq182sk41ks		insert into wrh$_memory_target...
0.34	1	0.34	0.09	95.66	0.00	bm2pwrpcr8ru6		select sga_size s, sga_size_fa...
0.34	1	0.34	0.09	101.95	0.00	bunssq950snhf		insert into wrh$_sga_target_ad...
0.27	3	0.09	0.07	46.65	36.35	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0.25	5	0.05	0.06	6.28	47.67	2ts960gft6nsd	SQL*Plus	select name n from v$database
0.13	1	0.13	0.03	11.87	95.08	350myuyx0t1d6		insert into wrh$_tablespace_st...
0.10	13	0.01	0.02	0.00	97.78	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
0.08	548	0.00	0.02	57.18	21.55	3c1kubcdjnppq		update sys.col_usage$ set equa...
0.07	1	0.07	0.02	66.82	45.58	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - 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 1.3% of Total CPU Time (s): 109
Captured PL/SQL account for 0.4% of Total CPU Time (s): 109

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.34	1	0.34	0.32	0.34	101.95	0.00	bunssq950snhf		insert into wrh$_sga_target_ad...
0.33	1	0.33	0.30	0.34	95.66	0.00	bm2pwrpcr8ru6		select sga_size s, sga_size_fa...
0.33	1	0.33	0.30	0.34	95.52	0.00	dayq182sk41ks		insert into wrh$_memory_target...
0.20	1	0.20	0.19	0.39	51.67	45.93	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0.13	3	0.04	0.11	0.27	46.65	36.35	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0.05	548	0.00	0.04	0.08	57.18	21.55	3c1kubcdjnppq		update sys.col_usage$ set equa...
0.05	1	0.05	0.04	0.03	142.30	0.00	5dfmd823r8dsp		insert into wrh$_memory_resize...
0.05	1	0.05	0.04	0.07	66.82	45.58	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.02	12	0.00	0.01	0.00	1098.80	0.00	08bqjmf8490s2	SEVERITY EVALUATION	SELECT PARAMETER_VALUE FROM MG...
0.02	1	0.02	0.01	0.01	120.98	0.00	0bdpb49gvdzgg		insert into wrh$_tempstatxs (s...

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 54.2% of Total User I/O Wait Time (s): 1
Captured PL/SQL account for 33.3% of Total User I/O Wait Time (s): 1

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.18	1	0.18	19.37	0.39	51.67	45.93	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
0.13	1	0.13	13.43	0.13	11.87	95.08	350myuyx0t1d6		insert into wrh$_tablespace_st...
0.12	5	0.02	12.73	0.25	6.28	47.67	2ts960gft6nsd	SQL*Plus	select name n from v$database
0.10	3	0.03	10.45	0.27	46.65	36.35	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0.09	13	0.01	10.07	0.10	0.00	97.78	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
0.06	1	0.06	6.38	0.06	0.00	97.63	0z1031991bd7w		insert into wrh$_sysmetric_sum...
0.03	1	0.03	3.43	0.07	66.82	45.58	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.03	1	0.03	3.21	0.03	0.00	96.41	4rcrxkvaqt37f		insert into wrh$_shared_pool_a...
0.03	66	0.00	3.21	0.03	0.00	90.39	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
0.03	1	0.03	2.92	0.03	0.00	96.31	d87cd6s72f197		insert into wrh$_seg_stat (sna...
0.02	548	0.00	1.90	0.08	57.18	21.55	3c1kubcdjnppq		update sys.col_usage$ set equa...

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: 2,295,278
Captured SQL account for 0.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
3,179	3	1,059.67	0.14	0.27	46.6	36.3	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
2,235	1	2,235.00	0.10	0.39	51.7	45.9	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
1,854	548	3.38	0.08	0.08	57.2	21.5	3c1kubcdjnppq		update sys.col_usage$ set equa...
857	1	857.00	0.04	0.07	66.8	45.6	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
642	158	4.06	0.03	0.01	0	0	cm5vu20fhtnq1		select /*+ connect_by_filterin...
514	9	57.11	0.02	0.02	84.3	0	3am9cfkvx7gq1		CALL MGMT_ADMIN_DATA.EVALUATE_...
378	39	9.69	0.02	0.01	0	34.9	8vwv6hx92ymmm		UPDATE MGMT_CURRENT_METRICS SE...
331	112	2.96	0.01	0.01	104.3	0	g00cj285jmgsw		update sys.mon_mods$ set inser...
240	66	3.64	0.01	0.03	0	90.4	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
201	10	20.10	0.01	0.01	0	0	4jrfrtx4u6zcx		SELECT TASK_TGT.TARGET_GUID TA...

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

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
58	1	58.00	63.04	0.39	51.67	45.93	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
6	1	6.00	6.52	0.03	0.00	96.31	d87cd6s72f197		insert into wrh$_seg_stat (sna...
5	1	5.00	5.43	0.06	0.00	97.63	0z1031991bd7w		insert into wrh$_sysmetric_sum...
3	1	3.00	3.26	0.03	0.00	96.41	4rcrxkvaqt37f		insert into wrh$_shared_pool_a...
3	66	0.05	3.26	0.03	0.00	90.39	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
3	1	3.00	3.26	0.07	66.82	45.58	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
2	548	0.00	2.17	0.08	57.18	21.55	3c1kubcdjnppq		update sys.col_usage$ set equa...
0	46	0.00	0.00	0.00	0.00	0.00	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
0	12	0.00	0.00	0.00	1098.80	0.00	08bqjmf8490s2	SEVERITY EVALUATION	SELECT PARAMETER_VALUE FROM MG...
0	1	0.00	0.00	0.01	120.98	0.00	0bdpb49gvdzgg		insert into wrh$_tempstatxs (s...

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: 53
Captured SQL account for 192.5% of Total
Total UnOptimized Read Requests: 53
Captured SQL account for 192.5% 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
60	60	1	60.00	0.00	113.21	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
35	35	5	7.00	0.00	66.04	2ts960gft6nsd	SQL*Plus	select name n from v$database
32	32	1	32.00	0.00	60.38	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
12	12	1	12.00	0.00	22.64	3jyk0fjp6yjyf		INSERT INTO wrh$_tempfile (sna...
7	7	1	7.00	0.00	13.21	35y2u24f4rxqm		insert into wrh$_seg_stat_obj ...
7	7	1	7.00	0.00	13.21	934ur8r7tqbjx		SELECT DBID FROM V$DATABASE
4	4	1	4.00	0.00	7.55	1tn90bbpyjshq		UPDATE wrh$_tempfile tfh SET (...
3	3	66	0.05	0.00	5.66	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
2	2	548	0.00	0.00	3.77	3c1kubcdjnppq		update sys.col_usage$ set equa...
0	0	46	0.00		0.00	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...

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: 322,379
Captured SQL account for 0.5% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
548	548	1.00	0.08	57.2	21.5	3c1kubcdjnppq		update sys.col_usage$ set equa...
204	0	0.00	0.01	0	0	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
158	421	2.66	0.01	0	0	cm5vu20fhtnq1		select /*+ connect_by_filterin...
112	0	0.00	0.00	0	0	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
112	108	0.96	0.01	104.3	0	g00cj285jmgsw		update sys.mon_mods$ set inser...
66	66	1.00	0.03	0	90.4	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
54	54	1.00	0.00	0	0	bsa0wjtftg3uw		select file# from file$ where ...
46	46	1.00	0.00	0	0	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
39	39	1.00	0.01	0	0	5kyb5bvnu3s04		SELECT DISTINCT METRIC_GUID FR...
39	39	1.00	0.01	0	34.9	8vwv6hx92ymmm		UPDATE MGMT_CURRENT_METRICS SE...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 760
Captured SQL account for 62.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
204	204	26.84	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
112	112	14.74	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
8	8	1.05	0k8522rmdzg4k		select privilege# from sysauth...
8	158	1.05	cm5vu20fhtnq1		select /*+ connect_by_filterin...
6	54	0.79	bsa0wjtftg3uw		select file# from file$ where ...
5	5	0.66	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
5	5	0.66	2ts960gft6nsd	SQL*Plus	select name n from v$database
5	5	0.66	459f3z9u4fb3u		select value$ from props$ wher...
5	5	0.66	4vs91dcv7u1p6	sqlplus.exe	insert into sys.aud$( sessioni...
5	5	0.66	5qgz1p0cut7mx	sqlplus.exe	BEGIN DBMS_OUTPUT.DISABLE; END...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

089dbukv1aanh SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL

08bqjmf8490s2 SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1

0bdpb49gvdzgg insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select /*+ leading (tf ts ftio fn fw) */ :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ftio.kcftiopyr, ftio.kcftiopyw, ftio.kcftiosbr, floor(ftio.kcftioprt / 10000), floor(ftio.kcftiopwt / 10000), floor(ftio.kcftiosbt / 10000), ftio.kcftiopbr, ftio.kcftiopbw, fw.count, fw.time from x$kcftio ftio, x$kcctf tf, x$kcbfwait fw, x$kccfn fn, x$kccts ts where ts.tstsn = tf.tftsn and ftio.kcftiofno = fn.fnfno and ftio.kcftiofno = tf.tfnum and tf.tfnum = fn.fnfno and tf.tffnh = fn.fnnum and tf.tfdup <> 0 and fn.fntyp = 7 and fn.fnnam is not null and bitand(tf.tfsta, 32) <> 32 and fw.indx+1 = (fn.fnfno + :db_files)

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

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

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

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)

1tn90bbpyjshq UPDATE wrh$_tempfile tfh SET (snap_id, filename, tsname) = (SELECT :lah_snap_id, tf.name name, ts.name tsname FROM v$tempfile tf, ts$ ts WHERE tf.ts# = ts.ts# AND tfh.file# = tf.file# AND tfh.creation_change# = tf.creation_change#) WHERE (file#, creation_change#) IN (SELECT tf.tfnum, to_number(tf.tfcrc_scn) creation_change# FROM x$kcctf tf WHERE tf.tfdup != 0) AND dbid = :dbid AND snap_id < :snap_id

1uk5m5qbzj1vt BEGIN dbms_workload_repository.create_snapshot; END;

2ts960gft6nsd select name n from v$database

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

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

35y2u24f4rxqm 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.objn_kewrseg and at.num2_kewrattr = ss1.objd_kewrseg and at.num1_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_'

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

3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln

3jyk0fjp6yjyf INSERT INTO wrh$_tempfile (snap_id, dbid, file#, creation_change#, filename, ts#, tsname, block_size) SELECT :lah_snap_id lah, :dbid dbid, tf.file# file#, tf.creation_change# cr_chg#, tf.name name, ts.ts# ts#, ts.name tsname, tf.block_size block_size FROM v$tempfile tf, ts$ ts WHERE tf.ts# = ts.ts# AND not exists (SELECT 1 FROM wrh$_tempfile tfh WHERE tfh.file# = tf.file# AND tfh.creation_change# = tf.creation_change# AND tfh.dbid = :dbid2)

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

4jrfrtx4u6zcx SELECT TASK_TGT.TARGET_GUID TARGET_GUID, LEAD(TASK_TGT.TARGET_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B9 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B9 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B9 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B9 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, TASK_TGT.COLL_NAME , POLICY.VIOLATION_LEVEL, DECODE(POLICY.POLICY_TYPE, :B3 , :B10 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B9 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, DECODE(CFG.IS_EXCEPTION, :B1 , MGMT_POLICY_PARAM_VAL_ARRAY(), CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME, CRIT_THRESHOLD, WARN_THRESHOLD, INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS, DECODE(POLICY.CONDITION_TYPE, :B8 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), MGMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B7 , 0, MGMT_MEDIUM_STRING_ARRAY(), 1, MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE), CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG, MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC

4rcrxkvaqt37f insert into wrh$_shared_pool_advice (snap_id, dbid, instance_number, shared_pool_size_for_estimate, shared_pool_size_factor, estd_lc_size, estd_lc_memory_objects, estd_lc_time_saved, estd_lc_time_saved_factor, estd_lc_load_time, estd_lc_load_time_factor, estd_lc_memory_object_hits) select :snap_id, :dbid, :instance_number, shared_pool_size_for_estimate, shared_pool_size_factor, estd_lc_size, estd_lc_memory_objects, estd_lc_time_saved, estd_lc_time_saved_factor, estd_lc_load_time, estd_lc_load_time_factor, estd_lc_memory_object_hits from v$shared_pool_advice

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)

5dfmd823r8dsp insert into wrh$_memory_resize_ops (snap_id, dbid, instance_number, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status) select snap_id, dbid, instance_num, component, oper_type, start_time, max(end_time), target_size, max(oper_mode), max(parameter), max(initial_size), max(final_size), max(status) from (select :snap_id snap_id, :dbid dbid, :instance_number instance_num, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status from v$memory_resize_ops where :begin_interval_time <= end_time and end_time < :end_interval_time) group by snap_id, dbid, instance_num, component, oper_type, start_time, target_size

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

5kyb5bvnu3s04 SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1

5qgz1p0cut7mx BEGIN DBMS_OUTPUT.DISABLE; END;

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

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

8vwv6hx92ymmm UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1

934ur8r7tqbjx SELECT DBID FROM V$DATABASE

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

bm2pwrpcr8ru6 select sga_size s, sga_size_factor * 100 f, estd_db_time t, estd_physical_reads p from v$sga_target_advice order by sga_size

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

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

cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

d87cd6s72f197 insert into wrh$_seg_stat (snap_id, dbid, instance_number, ts#, obj#, dataobj#, logical_reads_total, logical_reads_delta, buffer_busy_waits_total, buffer_busy_waits_delta, db_block_changes_total, db_block_changes_delta, physical_reads_total, physical_reads_delta, physical_writes_total, physical_writes_delta, physical_reads_direct_total, physical_reads_direct_delta, physical_writes_direct_total, physical_writes_direct_delta, itl_waits_total, itl_waits_delta, row_lock_waits_total, row_lock_waits_delta, gc_buffer_busy_total, gc_buffer_busy_delta, gc_cr_blocks_received_total, gc_cr_blocks_received_delta, gc_cu_blocks_received_total, gc_cu_blocks_received_delta, space_used_total, space_used_delta, space_allocated_total, space_allocated_delta, table_scans_total, table_scans_delta, chain_row_excess_total, chain_row_excess_delta, physical_read_requests_total, physical_read_requests_delta, physical_write_requests_total, physical_write_requests_delta, optimized_physical_reads_total, optimized_physical_reads_delta) select :snap_id, :dbid, :instance_number, tsn_kewrseg, objn_kewrseg, objd_kewrseg, log_rds_kewrseg, log_rds_dl_kewrseg, buf_busy_wts_kewrseg, buf_busy_wts_dl_kewrseg, db_blk_chgs_kewrseg, db_blk_chgs_dl_kewrseg, phy_rds_kewrseg, phy_rds_dl_kewrseg, phy_wrts_kewrseg, phy_wrts_dl_kewrseg, phy_rds_drt_kewrseg, phy_rds_drt_dl_kewrseg, phy_wrts_drt_kewrseg, phy_wrts_drt_dl_kewrseg, itl_wts_kewrseg, itl_wts_dl_kewrseg, row_lck_wts_kewrseg, row_lck_wts_dl_kewrseg, gc_buf_busy_kewrseg, gc_buf_busy_dl_kewrseg, gc_cr_blks_rcv_kewrseg, gc_cr_blks_rcv_dl_kewrseg, gc_cu_blks_rcv_kewrseg, gc_cu_blks_rcv_dl_kewrseg, space_used_kewrseg, space_used_dl_kewrseg, space_alloc_kewrseg, space_alloc_dl_kewrseg, tbl_scns_kewrseg, tbl_scns_dl_kewrseg, chn_exc_kewrseg, chn_exc_dl_kewrseg, phy_rd_reqs_kewrseg, phy_rd_reqs_dl_kewrseg, phy_wrt_reqs_kewrseg, phy_wrt_reqs_dl_kewrseg, opt_phy_rds_kewrseg, opt_phy_rds_dl_kewrseg from X$KEWRTSEGSTAT order by objn_kewrseg, objd_kewrseg

dayq182sk41ks insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice

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

SQL Id	SQL Text
089dbukv1aanh	SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2	SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
0bdpb49gvdzgg	insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select /+ leading (tf ts ftio fn fw) / :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ftio.kcftiopyr, ftio.kcftiopyw, ftio.kcftiosbr, floor(ftio.kcftioprt / 10000), floor(ftio.kcftiopwt / 10000), floor(ftio.kcftiosbt / 10000), ftio.kcftiopbr, ftio.kcftiopbw, fw.count, fw.time from x$kcftio ftio, x$kcctf tf, x$kcbfwait fw, x$kccfn fn, x$kccts ts where ts.tstsn = tf.tftsn and ftio.kcftiofno = fn.fnfno and ftio.kcftiofno = tf.tfnum and tf.tfnum = fn.fnfno and tf.tffnh = fn.fnnum and tf.tfdup <> 0 and fn.fntyp = 7 and fn.fnnam is not null and bitand(tf.tfsta, 32) <> 32 and fw.indx+1 = (fn.fnfno + :db_files)
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')
0z1031991bd7w	insert into wrh$_sysmetric_summary (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, num_interval, maxval, minval, average, standard_deviation, sum_squares) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, numintv, max, min, avg, std, sumsq FROM x$kewmsmdv WHERE groupid = 2
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
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)
1tn90bbpyjshq	UPDATE wrh$_tempfile tfh SET (snap_id, filename, tsname) = (SELECT :lah_snap_id, tf.name name, ts.name tsname FROM v$tempfile tf, ts$ ts WHERE tf.ts# = ts.ts# AND tfh.file# = tf.file# AND tfh.creation_change# = tf.creation_change#) WHERE (file#, creation_change#) IN (SELECT tf.tfnum, to_number(tf.tfcrc_scn) creation_change# FROM x$kcctf tf WHERE tf.tfdup != 0) AND dbid = :dbid AND snap_id < :snap_id
1uk5m5qbzj1vt	BEGIN dbms_workload_repository.create_snapshot; END;
2ts960gft6nsd	select name n from v$database
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
35y2u24f4rxqm	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.objn_kewrseg and at.num2_kewrattr = ss1.objd_kewrseg and at.num1_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_'
3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3jyk0fjp6yjyf	INSERT INTO wrh$_tempfile (snap_id, dbid, file#, creation_change#, filename, ts#, tsname, block_size) SELECT :lah_snap_id lah, :dbid dbid, tf.file# file#, tf.creation_change# cr_chg#, tf.name name, ts.ts# ts#, ts.name tsname, tf.block_size block_size FROM v$tempfile tf, ts$ ts WHERE tf.ts# = ts.ts# AND not exists (SELECT 1 FROM wrh$_tempfile tfh WHERE tfh.file# = tf.file# AND tfh.creation_change# = tf.creation_change# AND tfh.dbid = :dbid2)
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4jrfrtx4u6zcx	SELECT TASK_TGT.TARGET_GUID TARGET_GUID, LEAD(TASK_TGT.TARGET_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B9 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B9 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B9 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B9 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, TASK_TGT.COLL_NAME , POLICY.VIOLATION_LEVEL, DECODE(POLICY.POLICY_TYPE, :B3 , :B10 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B9 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, DECODE(CFG.IS_EXCEPTION, :B1 , MGMT_POLICY_PARAM_VAL_ARRAY(), CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME, CRIT_THRESHOLD, WARN_THRESHOLD, INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS, DECODE(POLICY.CONDITION_TYPE, :B8 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), MGMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B7 , 0, MGMT_MEDIUM_STRING_ARRAY(), 1, MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE), CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG, MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC
4rcrxkvaqt37f	insert into wrh$_shared_pool_advice (snap_id, dbid, instance_number, shared_pool_size_for_estimate, shared_pool_size_factor, estd_lc_size, estd_lc_memory_objects, estd_lc_time_saved, estd_lc_time_saved_factor, estd_lc_load_time, estd_lc_load_time_factor, estd_lc_memory_object_hits) select :snap_id, :dbid, :instance_number, shared_pool_size_for_estimate, shared_pool_size_factor, estd_lc_size, estd_lc_memory_objects, estd_lc_time_saved, estd_lc_time_saved_factor, estd_lc_load_time, estd_lc_load_time_factor, estd_lc_memory_object_hits from v$shared_pool_advice
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)
5dfmd823r8dsp	insert into wrh$_memory_resize_ops (snap_id, dbid, instance_number, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status) select snap_id, dbid, instance_num, component, oper_type, start_time, max(end_time), target_size, max(oper_mode), max(parameter), max(initial_size), max(final_size), max(status) from (select :snap_id snap_id, :dbid dbid, :instance_number instance_num, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status from v$memory_resize_ops where :begin_interval_time <= end_time and end_time < :end_interval_time) group by snap_id, dbid, instance_num, component, oper_type, start_time, target_size
5h7w8ykwtb2xt	INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
5kyb5bvnu3s04	SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1
5qgz1p0cut7mx	BEGIN DBMS_OUTPUT.DISABLE; END;
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
8vwv6hx92ymmm	UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
934ur8r7tqbjx	SELECT DBID FROM V$DATABASE
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
bm2pwrpcr8ru6	select sga_size s, sga_size_factor * 100 f, estd_db_time t, estd_physical_reads p from v$sga_target_advice order by sga_size
bsa0wjtftg3uw	select file# from file$ where ts#=:1
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
d87cd6s72f197	insert into wrh$_seg_stat (snap_id, dbid, instance_number, ts#, obj#, dataobj#, logical_reads_total, logical_reads_delta, buffer_busy_waits_total, buffer_busy_waits_delta, db_block_changes_total, db_block_changes_delta, physical_reads_total, physical_reads_delta, physical_writes_total, physical_writes_delta, physical_reads_direct_total, physical_reads_direct_delta, physical_writes_direct_total, physical_writes_direct_delta, itl_waits_total, itl_waits_delta, row_lock_waits_total, row_lock_waits_delta, gc_buffer_busy_total, gc_buffer_busy_delta, gc_cr_blocks_received_total, gc_cr_blocks_received_delta, gc_cu_blocks_received_total, gc_cu_blocks_received_delta, space_used_total, space_used_delta, space_allocated_total, space_allocated_delta, table_scans_total, table_scans_delta, chain_row_excess_total, chain_row_excess_delta, physical_read_requests_total, physical_read_requests_delta, physical_write_requests_total, physical_write_requests_delta, optimized_physical_reads_total, optimized_physical_reads_delta) select :snap_id, :dbid, :instance_number, tsn_kewrseg, objn_kewrseg, objd_kewrseg, log_rds_kewrseg, log_rds_dl_kewrseg, buf_busy_wts_kewrseg, buf_busy_wts_dl_kewrseg, db_blk_chgs_kewrseg, db_blk_chgs_dl_kewrseg, phy_rds_kewrseg, phy_rds_dl_kewrseg, phy_wrts_kewrseg, phy_wrts_dl_kewrseg, phy_rds_drt_kewrseg, phy_rds_drt_dl_kewrseg, phy_wrts_drt_kewrseg, phy_wrts_drt_dl_kewrseg, itl_wts_kewrseg, itl_wts_dl_kewrseg, row_lck_wts_kewrseg, row_lck_wts_dl_kewrseg, gc_buf_busy_kewrseg, gc_buf_busy_dl_kewrseg, gc_cr_blks_rcv_kewrseg, gc_cr_blks_rcv_dl_kewrseg, gc_cu_blks_rcv_kewrseg, gc_cu_blks_rcv_dl_kewrseg, space_used_kewrseg, space_used_dl_kewrseg, space_alloc_kewrseg, space_alloc_dl_kewrseg, tbl_scns_kewrseg, tbl_scns_dl_kewrseg, chn_exc_kewrseg, chn_exc_dl_kewrseg, phy_rd_reqs_kewrseg, phy_rd_reqs_dl_kewrseg, phy_wrt_reqs_kewrseg, phy_wrt_reqs_dl_kewrseg, opt_phy_rds_kewrseg, opt_phy_rds_dl_kewrseg from X$KEWRTSEGSTAT order by objn_kewrseg, objd_kewrseg
dayq182sk41ks	insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	1	0.01	0.00
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	8,611	52.70	0.03
CPU used when call started	8,599	52.63	0.03
CR blocks created	21	0.13	0.00
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	55,918	342.22	0.17
DBWR checkpoint buffers written	4,819	29.49	0.02
DBWR checkpoints	5	0.03	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	4,308	26.36	0.01
DBWR transaction table writes	64	0.39	0.00
DBWR undo block writes	3,641	22.28	0.01
HSC Heap Segment Block Changes	321,112	1,965.19	1.00
Heap Segment Array Inserts	88	0.54	0.00
Heap Segment Array Updates	20	0.12	0.00
IMU CR rollbacks	20	0.12	0.00
IMU Flushes	18,357	112.34	0.06
IMU Redo allocation size	7,081,476	43,338.29	22.13
IMU commits	298,613	1,827.50	0.93
IMU contention	16,920	103.55	0.05
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	3,083	18.87	0.01
IMU recursive-transaction flush	1	0.01	0.00
IMU undo allocation size	125,513,152	768,134.35	392.18
IMU- failed to get a private strand	3,083	18.87	0.01
Requests to/from client	640,097	3,917.36	2.00
RowCR attempts	6	0.04	0.00
RowCR hits	6	0.04	0.00
SMON posted for undo segment shrink	7	0.04	0.00
SQL*Net roundtrips to/from client	640,097	3,917.36	2.00
active txn count during cleanout	11,507	70.42	0.04
application wait time	0	0.00	0.00
background checkpoints completed	3	0.02	0.00
background checkpoints started	5	0.03	0.00
background timeouts	785	4.80	0.00
buffer is not pinned count	4,626	28.31	0.01
buffer is pinned count	1,618	9.90	0.01
bytes received via SQL*Net from client	129,305,538	791,343.56	404.03
bytes sent via SQL*Net to client	88,990,060	544,614.81	278.06
calls to get snapshot scn: kcmgss	322,572	1,974.12	1.01
calls to kcmgas	320,723	1,962.81	1.00
calls to kcmgcs	321,070	1,964.93	1.00
cell physical IO interconnect bytes	255,357,440	1,562,775.03	797.89
change write time	548	3.35	0.00
cleanout - number of ktugct calls	26,455	161.90	0.08
cleanouts only - consistent read gets	1	0.01	0.00
cluster key scan block gets	21	0.13	0.00
cluster key scans	20	0.12	0.00
commit batch/immediate performed	3	0.02	0.00
commit batch/immediate requested	3	0.02	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: callback failure	6	0.04	0.00
commit cleanout failures: cannot pin	14,318	87.63	0.04
commit cleanouts	320,877	1,963.75	1.00
commit cleanouts successfully completed	306,553	1,876.09	0.96
commit immediate performed	3	0.02	0.00
commit immediate requested	3	0.02	0.00
commit txn count during cleanout	28,239	172.82	0.09
concurrency wait time	65	0.40	0.00
consistent changes	42	0.26	0.00
consistent gets	367,082	2,246.52	1.15
consistent gets - examination	43,603	266.85	0.14
consistent gets direct	0	0.00	0.00
consistent gets from cache	367,082	2,246.52	1.15
consistent gets from cache (fastpath)	323,152	1,977.67	1.01
cursor authentications	107	0.65	0.00
data blocks consistent reads - undo records applied	24	0.15	0.00
db block changes	1,288,166	7,883.51	4.03
db block gets	1,928,196	11,800.47	6.02
db block gets direct	0	0.00	0.00
db block gets from cache	1,928,196	11,800.47	6.02
db block gets from cache (fastpath)	519,463	3,179.09	1.62
deferred (CURRENT) block cleanout applications	308,993	1,891.02	0.97
enqueue conversions	251	1.54	0.00
enqueue releases	642,864	3,934.30	2.01
enqueue requests	642,864	3,934.30	2.01
enqueue timeouts	0	0.00	0.00
enqueue waits	22	0.13	0.00
execute count	322,379	1,972.94	1.01
file io service time	0	0.00	0.00
file io wait time	49,747,815	304,454.19	155.44
free buffer requested	5,313	32.52	0.02
heap block compress	5	0.03	0.00
immediate (CR) block cleanout applications	1	0.01	0.00
immediate (CURRENT) block cleanout applications	115	0.70	0.00
in call idle wait time	325,832	1,994.08	1.02
index crx upgrade (positioned)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fetch by key	1,771	10.84	0.01
index scans kdiixs1	1,031	6.31	0.00
leaf node 90-10 splits	11	0.07	0.00
leaf node splits	16	0.10	0.00
lob writes	18	0.11	0.00
lob writes unaligned	18	0.11	0.00
logical read bytes from cache	18,802,917,376	115,072,933.76	58,751.77
logons cumulative	16	0.10	0.00
max cf enq hold time	0	0.00	0.00
messages received	189,754	1,161.29	0.59
messages sent	189,754	1,161.29	0.59
min active SCN optimization applied on CR	76	0.47	0.00
no work - consistent read gets	2,296	14.05	0.01
non-idle wait count	1,481,243	9,065.13	4.63
non-idle wait time	40,393	247.20	0.13
opened cursors cumulative	642,194	3,930.20	2.01
parse count (describe)	0	0.00	0.00
parse count (hard)	57	0.35	0.00
parse count (total)	760	4.65	0.00
parse time cpu	438	2.68	0.00
parse time elapsed	561	3.43	0.00
physical read IO requests	53	0.32	0.00
physical read bytes	753,664	4,612.39	2.35
physical read total IO requests	419	2.56	0.00
physical read total bytes	6,550,528	40,088.91	20.47
physical read total multi block requests	0	0.00	0.00
physical reads	92	0.56	0.00
physical reads cache	77	0.47	0.00
physical reads cache prefetch	39	0.24	0.00
physical reads direct	15	0.09	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	39	0.24	0.00
physical write IO requests	759	4.65	0.00
physical write bytes	39,600,128	242,350.84	123.73
physical write total IO requests	194,175	1,188.34	0.61
physical write total bytes	248,806,912	1,522,686.12	777.42
physical write total multi block requests	232	1.42	0.00
physical writes	4,834	29.58	0.02
physical writes direct	15	0.09	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	4,819	29.49	0.02
physical writes non checkpoint	3,756	22.99	0.01
process last non-idle time	164	1.00	0.00
recursive calls	328,756	2,011.97	1.03
recursive cpu usage	1,316	8.05	0.00
redo blocks checksummed by FG (exclusive)	1,445	8.84	0.00
redo blocks written	399,701	2,446.15	1.25
redo buffer allocation retries	18	0.11	0.00
redo entries	347,146	2,124.52	1.08
redo log space requests	23	0.14	0.00
redo log space wait time	122	0.75	0.00
redo ordering marks	206	1.26	0.00
redo size	160,273,152	980,863.84	500.79
redo size for direct writes	0	0.00	0.00
redo subscn max counts	360	2.20	0.00
redo synch long waits	118	0.72	0.00
redo synch poll writes	0	0.00	0.00
redo synch polls	0	0.00	0.00
redo synch time	29,252	179.02	0.09
redo synch time (usec)	292,535,138	1,790,300.72	914.06
redo synch writes	320,034	1,958.59	1.00
redo wastage	37,522,776	229,637.55	117.24
redo write time	10,721	65.61	0.03
redo writes	189,075	1,157.13	0.59
rollback changes - undo records applied	3	0.02	0.00
rollbacks only - consistent read gets	12	0.07	0.00
rows fetched via callback	818	5.01	0.00
session connect time	164	1.00	0.00
session cursor cache hits	117,148	716.94	0.37
session logical reads	2,295,278	14,046.99	7.17
shared hash latch upgrades - no wait	616	3.77	0.00
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	613	3.75	0.00
sorts (rows)	6,324	38.70	0.02
sql area evicted	0	0.00	0.00
sql area purged	0	0.00	0.00
switch current to new buffer	28	0.17	0.00
table fetch by rowid	1,762	10.78	0.01
table fetch continued row	0	0.00	0.00
table scan blocks gotten	428	2.62	0.00
table scan rows gotten	44,463	272.11	0.14
table scans (long tables)	0	0.00	0.00
table scans (short tables)	110	0.67	0.00
total cf enq hold time	1,078	6.60	0.00
total number of cf enq holders	15	0.09	0.00
total number of times SMON posted	10	0.06	0.00
transaction rollbacks	3	0.02	0.00
undo change vector size	42,644,828	260,984.26	133.25
user I/O wait time	93	0.57	0.00
user calls	1,280,182	7,834.65	4.00
user commits	320,040	1,958.63	1.00
workarea executions - optimal	360	2.20	0.00
write clones created in background	0	0.00	0.00
write clones created in foreground	17	0.10	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
opened cursors current	37	33
logons current	22	24
session uga memory max	198,178,696	211,750,356
session pga memory	159,907,896	164,993,332
session pga memory max	183,648,956	188,734,392
session cursor cache count	6,197	6,509
session uga memory	339,323,629,008	352,209,440,712

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)	5	110.16

Back to Instance Activity Statistics
Back to Top

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	1M	0.54	.006119	196M	1182.61	1.19951	189.2K	0.56
DBWR	0M	0.00	0M	38M	4.55	.232558	0
Others	4M	1.70	.024479	3M	1.08	.018359	365	5.32
Buffer Cache Reads	0M	0.21	0M	0M	0.00	0M	35	7.49
Direct Reads	0M	0.09	0M	0M	0.00	0M	0
Direct Writes	0M	0.00	0M	0M	0.09	0M	0
TOTAL:	5M	2.55	.030599	237M	1188.33	1.45042	189.6K	0.57

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.06	0M	194M	1182.00	1.18727	10.50
Data File	1M	0.34	.006119	39M	4.65	.238678	15.53
Control File	6M	2.15	.036719	5M	1.69	.030599	4.67
TOTAL:	7M	2.55	.042839	238M	1188.33	1.45654	6.25

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	1M	0.54	.006119	196M	1182.61	1.19951	99	4.41
LGWR (Log File)	0M	0.06	0M	194M	1182.00	1.18727	20	5.85
LGWR (Control File)	1M	0.48	.006119	2M	0.61	.012239	79	4.05
DBWR	0M	0.00	0M	38M	4.55	.232558	0
DBWR (Data File)	0M	0.00	0M	38M	4.55	.232558	0
Others	4M	1.70	.024479	3M	1.08	.018359	277	4.87
Others (Control File)	4M	1.66	.024479	3M	1.08	.018359	272	4.85
Others (Data File)	0M	0.03	0M	0M	0.00	0M	5	6.00
Buffer Cache Reads	0M	0.21	0M	0M	0.00	0M	35	7.49
Buffer Cache Reads (Data File)	0M	0.21	0M	0M	0.00	0M	35	7.49
Direct Reads	0M	0.09	0M	0M	0.00	0M	0
Direct Reads (Data File)	0M	0.09	0M	0M	0.00	0M	0
Direct Writes	0M	0.00	0M	0M	0.09	0M	0
Direct Writes (Data File)	0M	0.00	0M	0M	0.09	0M	0
TOTAL:	5M	2.55	.030599	237M	1188.33	1.45042	411	4.98

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SYSAUX	42	6.67	2.07	345	2	0	0.00
UNDOTBS1	3	0.00	1.00	325	2	322	0.03
SYSTEM	5	4.00	1.00	43	0	0	0.00
USERS	3	0.00	1.00	43	0	524	0.06
EXAMPLE	3	0.00	1.00	3	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
EXAMPLE	C:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF	3	0.00	1.00	3	0	0	0.00
SYSAUX	C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF	42	6.67	2.07	345	2	0	0.00
SYSTEM	C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF	5	4.00	1.00	43	0	0	0.00
UNDOTBS1	C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF	3	0.00	1.00	325	2	322	0.03
USERS	C:\ORACLE\ORADATA\ORCL\USERS01.DBF	3	0.00	1.00	43	0	524	0.06

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	52,735	100	2,288,740	74	4,819	0	0	846

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 4,834

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	4,101	0	0	511	207

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats
MTTR Advisory
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	45	573	3616	165888	165888	465625
E	0	85	2227	165739	165888	165888	459700

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

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	40	0.09	5	1.14	15	1	84.00
D	80	0.19	10	1.05	14	1	75.00
D	120	0.28	15	1.04	14	1	74.00
D	160	0.38	20	1.03	14	1	73.00
D	200	0.47	25	1.02	14	1	72.00
D	240	0.57	30	1.01	13	1	70.00
D	280	0.66	35	1.00	13	1	70.00
D	320	0.75	40	1.00	13	1	70.00
D	360	0.85	45	1.00	13	1	70.00
D	400	0.94	50	1.00	13	1	70.00
D	424	1.00	53	1.00	13	1	70.00
D	440	1.04	55	1.00	13	1	70.00
D	480	1.13	60	1.00	13	1	70.00
D	520	1.23	65	1.00	13	1	70.00
D	560	1.32	70	1.00	13	1	70.00
D	600	1.42	75	1.00	13	1	70.00
D	640	1.51	80	1.00	13	1	70.00
D	680	1.60	85	1.00	13	1	70.00
D	720	1.70	90	1.00	13	1	70.00
D	760	1.79	95	1.00	13	1	70.00
D	800	1.89	100	1.00	13	1	70.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	27	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

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	332	332
64K	128K	2	2
512K	1024K	24	24
4M	8M	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 PGA Cache Hit %	Estd Time
62	0.13	124.86	100.00	56,373
124	0.25	124.86	100.00	56,373
248	0.50	124.86	100.00	56,373
372	0.75	124.86	100.00	56,373
496	1.00	124.86	100.00	56,373
595	1.20	124.86	100.00	56,373
694	1.40	124.86	100.00	56,373
794	1.60	124.86	100.00	56,373
893	1.80	124.86	100.00	56,373
992	2.00	124.86	100.00	56,373
1,488	3.00	124.86	100.00	56,373
1,984	4.00	124.86	100.00	56,373
2,976	6.00	124.86	100.00	56,373
3,968	8.00	124.86	100.00	56,373

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)
104	0.39	16	1,533	18,631	0.97	680	8.40	471
136	0.52	46	3,348	18,695	0.97	616	7.60	473
168	0.64	49	3,607	18,695	0.97	616	7.60	473
184	0.70	49	3,607	18,695	0.97	616	7.60	473
192	0.73	49	3,607	18,695	0.97	616	7.60	473
200	0.76	49	3,607	18,695	0.97	616	7.60	473
208	0.79	49	3,607	18,695	0.97	616	7.60	473
216	0.82	49	3,607	18,695	0.97	616	7.60	473
224	0.85	49	3,607	18,695	0.97	616	7.60	473
232	0.88	49	3,607	18,778	0.98	533	6.58	473
240	0.91	49	3,607	18,861	0.98	450	5.56	473
248	0.94	49	3,607	18,944	0.99	367	4.53	473
256	0.97	49	3,607	19,087	0.99	224	2.77	474
264	1.00	49	3,607	19,230	1.00	81	1.00	474
272	1.03	49	3,607	19,230	1.00	81	1.00	474
280	1.06	49	3,607	19,230	1.00	81	1.00	474
288	1.09	49	3,607	19,230	1.00	81	1.00	474
296	1.12	49	3,607	19,230	1.00	81	1.00	474
304	1.15	49	3,607	19,230	1.00	81	1.00	474
312	1.18	49	3,607	19,230	1.00	81	1.00	474
320	1.21	49	3,607	19,230	1.00	81	1.00	474
328	1.24	49	3,607	19,230	1.00	81	1.00	474
336	1.27	49	3,607	19,230	1.00	81	1.00	474
360	1.36	49	3,607	19,230	1.00	81	1.00	474
392	1.48	49	3,607	19,230	1.00	81	1.00	474
424	1.61	49	3,607	19,230	1.00	81	1.00	474
456	1.73	49	3,607	19,230	1.00	81	1.00	474
488	1.85	49	3,607	19,230	1.00	81	1.00	474
520	1.97	49	3,607	19,230	1.00	81	1.00	474
552	2.09	49	3,607	19,230	1.00	81	1.00	474

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
184	0.25	19,333	15,030
368	0.50	18,734	15,030
552	0.75	18,721	13,371
736	1.00	18,721	13,270
920	1.25	18,721	13,270
1,104	1.50	18,721	13,270
1,288	1.75	18,721	13,270
1,472	2.00	18,721	13,270

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
8	1.00	0	0	0	0
16	2.00	0	0	0	0
24	3.00	0	0	0	0
32	4.00	0	0	0	0
40	5.00	0	0	0	0
48	6.00	0	0	0	0
56	7.00	0	0	0	0
64	8.00	0	0	0	0
72	9.00	0	0	0	0
80	10.00	0	0	0	0
88	11.00	0	0	0	0
96	12.00	0	0	0	0
104	13.00	0	0	0	0
112	14.00	0	0	0	0
120	15.00	0	0	0	0
128	16.00	0	0	0	0
136	17.00	0	0	0	0
144	18.00	0	0	0	0
152	19.00	0	0	0	0
160	20.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	487	0	0
undo header	322	0	0
segment header	19	0	0
1st level bmb	14	0	0
2nd level bmb	4	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction	318,384	319,797	0	17	0	0.00
FB-Format Block	48	48	0	5	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0
ASM db client latch	182	0.00		0
ASM map operation hash table	1	0.00		0
ASM network state latch	4	0.00		0
AWR Alerted Metric Element list	834	0.00		0
Change Notification Hash table latch	54	0.00		0
Consistent RBA	189,089	0.00		0
DML lock allocation	641,214	0.15	0.00	0
Event Group Locks	30	0.00		0
FOB s.o list latch	51	0.00		0
File State Object Pool Parent Latch	1	0.00		0
I/O Staticstics latch	1	0.00		0
IPC stats buffer allocation latch	1	0.00		0
In memory undo latch	1,287,792	0.23	0.49	320,089	0.00
JS Sh mem access	1	0.00		0
JS broadcast autostart latch	3	0.00		0
JS queue access latch	1	0.00		0
JS queue state obj latch	1,152	0.00		0
JS slv state obj latch	13	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	1	0.00		0
KJCT flow control latch	1	0.00		0
KMG MMAN ready and startup request latch	55	0.00		0
KTF sga latch	2	0.00		53	0.00
KWQMN job cache list latch	1	0.00		0
KWQP Prop Status	2	0.00		0
KWQS pqsubs latch	2	0.00		0
KWQS pqueue ctx latch	22	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	1	0.00		0
MQL Tracking Latch	0			3	0.00
Memory Management Latch	1	0.00		55	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
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	87	0.00		0
OS process allocation	362	0.28	0.00	0
OS process: request allocation	24	0.00		0
PL/SQL warning settings	37	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	2	0.00		0
SGA IO buffer pool latch	18	0.00		18	0.00
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	6	0.00		54	0.00
SQL memory manager workarea list latch	3,882	0.00		0
Shared B-Tree	53	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	635	0.00		0
active service list	471	0.00		662	0.00
buffer pool	1	0.00		0
business card	1	0.00		0
cache buffer handles	394	0.00		0
cache buffers chains	9,024,207	0.52	0.00	5,358	0.00
cache buffers lru chain	4,997	0.00		10,584	0.03
call allocation	239	0.00		0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	28	0.00		0
channel operations parent latch	1,517	0.00		0
checkpoint queue latch	12,236	0.00		6,397	0.03
client/application info	70	0.00		0
compile environment latch	16	0.00		0
corrupted undo seg latch	12	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
cp sga latch	4	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	4	0.00		0
dml lock allocation	6	0.00		0
done queue latch	1	0.00		0
dummy allocation	31	0.00		0
enqueue freelist latch	1	0.00		3,576	0.00
enqueue hash chains	1,286,017	1.05	0.00	0
enqueues	4	0.00		0
fifth spare latch	1	0.00		0
file cache latch	111	0.00		0
flashback copy	1	0.00		0
fourth Audit Vault latch	1	0.00		0
gc element	1	0.00		0
gcs commit scn state	1	0.00		0
gcs partitioned table hash	1	0.00		0
gcs pcm hashed value bucket hash	1	0.00		0
gcs resource freelist	1	0.00		0
gcs resource hash	1	0.00		0
gcs resource scan list	1	0.00		0
gcs shadows freelist	1	0.00		0
ges domain table	1	0.00		0
ges enqueue table freelist	1	0.00		0
ges group table	1	0.00		0
ges process hash list	1	0.00		0
ges process parent latch	1	0.00		0
ges resource hash list	1	0.00		0
ges resource scan list	1	0.00		0
ges resource table freelist	1	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	223	0.00		2,067	0.00
hash table modification latch	1	0.00		0
heartbeat check	1	0.00		0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	4	0.00		3	0.00
job_queue_processes free list latch	6	0.00		0
job_queue_processes parameter latch	37	0.00		0
k2q lock allocation	1	0.00		0
kcbtsemkid latch	5	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	52	0.00		0
ksfv messages	1	0.00		0
ksim group membership cache	1	0.00		0
kss move lock	5	0.00		0
ksuosstats global area	19	0.00		0
ksv allocation latch	10	0.00		0
ksv class latch	5	0.00		0
ksv msg queue latch	1	0.00		0
ksz_so allocation latch	24	4.17	0.00	0
ktm global data	41	0.00		0
kwqbsn:qsga	7	0.00		0
lgwr LWN SCN	189,179	0.00		0
list of block allocation	37	0.00		0
loader state object freelist	36	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	3	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	2	0.00		0
logminer work area	1	0.00		0
longop free list parent	1	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	157	0.00		0
messages	493,181	1.09	0.00	0
mostly latch-free SCN	189,760	0.21	0.03	0
msg queue latch	1	0.00		0
multiblock read objects	28	0.00		0
name-service namespace bucket	1	0.00		0
ncodef allocation latch	4	0.00		0
object queue header heap	1,250	0.00		2	0.00
object queue header operation	23,090	0.02	0.00	0
object stats modification	157	0.00		0
parallel query alloc buffer	25	0.00		0
parallel query stats	1	0.00		0
parameter list	24	0.00		0
parameter table management	129	0.78	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	348,576	0.03	0.00	319,829	0.43
process allocation	32	0.00		13	0.00
process group creation	24	4.17	0.00	0
process queue	1	0.00		0
process queue reference	1	0.00		0
qmn task queue latch	20	15.00	0.67	0
query server freelists	1	0.00		0
queued dump request	1	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	1,210,576	0.01	0.38	345,821	1.25
redo copy	1	0.00		347,134	0.90
redo writing	572,034	0.00	0.00	0
resmgr group change latch	11	0.00		0
resmgr:active threads	31	0.00		0
resmgr:actses change group	11	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	30	3.33	0.00	0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	1	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	17,532	0.00		0
rules engine rule set statistics	100	0.00		0
second Audit Vault latch	1	0.00		0
second spare latch	1	0.00		0
sequence cache	36	0.00		0
session allocation	320,124	0.09	0.00	320,099	0.05
session idle bit	2,880,444	0.01	0.25	0
session queue latch	1	0.00		0
session state list latch	26	0.00		0
session switching	16	0.00		0
session timer	56	0.00		0
shared pool	7,008	0.36	0.00	0
shared pool sim alloc	3	0.00		0
shared pool simulator	92	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	86,998	0.00		0
simulator lru latch	4,361	0.00		82,003	0.08
sort extent pool	20	0.00		0
space background state object latch	2	0.00		0
space background task latch	268	1.12	1.00	111	0.00
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	2	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
third spare latch	1	0.00		0
threshold alerts latch	3	0.00		0
transaction allocation	195	0.00		0
undo global data	1,640,016	0.60	0.00	0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	9,024,207	46,825	126	46,700
enqueue hash chains	1,286,017	13,484	47	13,437
undo global data	1,640,016	9,787	14	9,773
messages	493,181	5,358	19	5,339
In memory undo latch	1,287,792	2,941	1,434	1,508
DML lock allocation	641,214	979	4	975
mostly latch-free SCN	189,760	393	12	381
session idle bit	2,880,444	344	87	257
session allocation	320,124	273	1	272
redo allocation	1,210,576	66	25	41
qmn task queue latch	20	3	2	1
space background task latch	268	3	3	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
DML lock allocation	ktaiam	2	1
DML lock allocation	ktaidm	2	3
In memory undo latch	kticmt: child	879	307
In memory undo latch	ktiFlush: child	658	1,241
In memory undo latch	ktichg: child	10	0
In memory undo latch	kticflush_2	1	0
PC and Classifier lists for WLM	No latch	2	0
cache buffers chains	kcbgcur: fast path (shr)	1,474	1,475
cache buffers chains	kcbgcur_2	7	9
cache buffers chains	kcbnlc	6	0
cache buffers chains	kcbrls_2	4	2
cache buffers chains	kcbchg1: mod cr pin	2	1
cache buffers chains	kcbgcur_4	2	3
cache buffers chains	kcbgtcr: fast path	2	4
cache buffers chains	kcbchg1: mod cur pin	1	0
cache buffers chains	kcbrls: fast release	1	4
cache buffers chains	kcbzpbuf	1	0
enqueue hash chains	ksqrcl	28	27
enqueue hash chains	ksqgtl3	19	20
messages	ksaamb: after wakeup	16	17
messages	ksarcv	2	2
messages	ksarcv: after wait	1	0
mostly latch-free SCN	kcs05	10	0
mostly latch-free SCN	kcs04	2	12
qmn task queue latch	kwqmnmvtsks: delay to ready list	2	0
redo allocation	kcrfw_redo_gen: redo allocation 1	25	0
session allocation	ksucri_int : SSO	1	0
session idle bit	ksupuc: set busy	63	17
session idle bit	ksupuc: clear busy	22	42
session idle bit	ksuxds	3	29
space background task latch	ktsj_grab_task	1	3
undo global data	ktudnx:child	8	4
undo global data	ktubnd_4	3	0
undo global data	ktudba: KSLBEGIN	2	0
undo global data	ktufrbs_2	1	10

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Cursor Pin	kksfbc [KKSCHLPIN1]	40
Cursor Pin	kkslce [KKSCHLPIN2]	6
Library Cache	kglati1 45	5
Cursor Pin	kksLockDelete [KKSCHLPIN6]	4
Library Cache	kglget2 2	1

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by 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 Logical Reads

Total Logical Reads: 2,295,278
Captured Segments account for 56.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TESTUSER	USERS	TESTTABLE	TABLE	1,286,688	56.06
SYS	SYSTEM	I_COL_USAGE$	INDEX	1,056	0.05
SYS	SYSTEM	I_SYSAUTH1	INDEX	832	0.04
SYS	SYSTEM	COL_USAGE$	TABLE	544	0.02
SYS	SYSAUX	WRM$_SNAPSHOT_DETAILS	TABLE	352	0.02

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 92
Captured Segments account for 77.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	31	33.70
SYS	SYSAUX	WRH$_SQLTEXT		TABLE	12	13.04
SYS	SYSAUX	WRH$_MVPARAMETER_PK	WRH$_MVPARA_1306904245_58	INDEX PARTITION	5	5.43
SYS	SYSAUX	WRH$_SYSMETRIC_SUMMARY		TABLE	5	5.43
SYS	SYSAUX	WRM$_SNAPSHOT_DETAILS_INDEX		INDEX	5	5.43

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 53
Captured Segments account for 66.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Read Requests	%Total
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	16	30.19
SYS	SYSAUX	WRH$_MVPARAMETER_PK	WRH$_MVPARA_1306904245_58	INDEX PARTITION	4	7.55
SYS	SYSAUX	WRH$_OSSTAT_PK	WRH$_OSSTAT_1306904245_58	INDEX PARTITION	3	5.66
SYS	SYSAUX	WRI$_ADV_PARAMETERS_PK		INDEX	3	5.66
SYS	SYSTEM	COL_USAGE$		TABLE	2	3.77

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 53
Captured Segments account for 66.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	UnOptimized Reads	%Total
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	16	30.19
SYS	SYSAUX	WRH$_MVPARAMETER_PK	WRH$_MVPARA_1306904245_58	INDEX PARTITION	4	7.55
SYS	SYSAUX	WRH$_OSSTAT_PK	WRH$_OSSTAT_1306904245_58	INDEX PARTITION	3	5.66
SYS	SYSAUX	WRI$_ADV_PARAMETERS_PK		INDEX	3	5.66
SYS	SYSTEM	COL_USAGE$		TABLE	2	3.77

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 4,834
Captured Segments account for 17.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
TESTUSER	USERS	TESTTABLE		TABLE	515	10.65
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	WRH$_SQLSTA_1306904245_58	INDEX PARTITION	24	0.50
SYS	SYSTEM	COL_USAGE$		TABLE	19	0.39
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM	WRH$_EVENT__1306904245_58	TABLE PARTITION	15	0.31
SYS	SYSAUX	WRH$_LATCH	WRH$_LATCH_1306904245_58	TABLE PARTITION	15	0.31

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 759
Captured Segments account for 24.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
TESTUSER	USERS	TESTTABLE		TABLE	36	4.74
SYS	SYSAUX	WRH$_SQL_PLAN_PK		INDEX	10	1.32
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	8	1.05
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK		INDEX	6	0.79
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1306904245_58	TABLE PARTITION	6	0.79

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
TESTUSER	USERS	TESTTABLE		TABLE	6,192	79.96
SYS	SYSTEM	COL_USAGE$		TABLE	528	6.82
SYS	SYSTEM	MON_MODS$		TABLE	128	1.65
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	WRH$_SQLSTA_1306904245_58	INDEX PARTITION	128	1.65
SYS	SYSAUX	WRM$_SNAPSHOT_DETAILS		TABLE	96	1.24

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
TESTUSER	USERS	TESTTABLE		TABLE	524	100.00

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)
"Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	6	0.00	2	1
dc_global_oids	43	0.00	0	52
dc_histogram_data	314	0.00	0	1,359
dc_histogram_defs	2,019	0.05	0	4,066
dc_object_grants	19	0.00	0	69
dc_objects	656	0.91	0	1,804
dc_profiles	8	0.00	0	1
dc_rollback_segments	73	0.00	0	34
dc_segments	385	0.26	8	677
dc_tablespaces	891	0.00	0	7
dc_users	1,355	0.07	0	103
global database name	119	0.00	0	1

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	10	0.00	0		0	0
BODY	91	0.00	134	0.00	0	0
CLUSTER	1	0.00	1	0.00	0	0
DBLINK	10	0.00	0		0	0
EDITION	8	0.00	16	0.00	0	0
INDEX	12	0.00	12	0.00	0	0
QUEUE	7	0.00	29	0.00	0	0
SCHEMA	12	0.00	0		0	0
SQL AREA	616	0.32	322,701	-0.17	1	1
SQL AREA BUILD	65	3.08	0		0	0
SQL AREA STATS	65	98.46	65	98.46	0	0
SUBSCRIPTION	1	0.00	1	0.00	0	0
TABLE/PROCEDURE	343	1.17	1,166	0.60	0	0
TRIGGER	10	0.00	19	0.00	0	0

Memory Statistics

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

Memory Dynamic Components

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

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	424.00	424.00	424.00	424.00	INI/
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	496.00	496.00	496.00	496.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	736.00	736.00	736.00	736.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	24.00	24.00	24.00	24.00	STA/
large pool	8.00	8.00	8.00	8.00	STA/
shared pool	264.00	264.00	264.00	264.00	STA/
streams pool	8.00	8.00	8.00	8.00	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	32.04		1.33	1.24	5	5	24	24
B	SQL	0.51	0.42	0.05	0.14	0	4	11	7
B	PL/SQL	0.34	0.28	0.02	0.03	0	0	22	22
E	Other	31.74		1.22	1.14	5	5	26	26
E	SQL	0.45	0.38	0.04	0.11	0	4	12	8
E	PL/SQL	0.34	0.28	0.01	0.03	0	0	24	24

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	444,596,224
Fixed Size	1,384,856
Redo Buffers	5,246,976
Variable Size	327,159,400

Back to Memory Statistics
Back to Top

SGA breakdown difference

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Pool	Name	Begin MB	End MB	% Diff
java	free memory	24.00	24.00	0.00
large	PX msg pool	0.47	0.47	0.00
large	free memory	7.53	7.53	0.00
shared	ASH buffers	4.00	4.00	0.00
shared	KCB Table Scan Buffer	4.00	4.00	0.00
shared	KGLH0	20.35	21.01	3.23
shared	KGLHD	3.97	4.00	0.79
shared	KGLS	10.46	10.47	0.11
shared	KGLSG	3.52	3.52	0.00
shared	KQR M PO	2.87	2.88	0.12
shared	KSFD SGA I/O b	4.00	4.00	0.00
shared	PLDIA	2.71	2.71	0.00
shared	PLMCD	5.44	5.44	0.00
shared	SQLA	17.64	19.08	8.16
shared	dbwriter coalesce buffer	4.00	4.00	0.00
shared	event statistics per sess	3.10	3.10	0.00
shared	free memory	127.42	125.18	-1.76
shared	ksunfy : SSO free list	2.69	2.69	0.00
shared	row cache	3.62	3.62	0.00
streams	free memory	8.00	8.00	0.00
	buffer_cache	424.00	424.00	0.00
	fixed_sga	1.32	1.32	0.00
	log_buffer	5.00	5.00	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Capture Rate
Streams Apply
Streams Apply Rate
Buffered Queues
Buffered Queue Subscribers
Rule Set
Persistent Queues
Persistent Queues Rate
Persistent Queue Subscribers

Streams CPU/IO Usage

Streams processes ordered by CPU Time, descending

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Coordinator	0822 12:01:20	0.00	0.00	0.00
QMON Slaves	0822 12:01:30	0.00	0.00	0.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps
%Exp Msgs - % of msgs enqueued with expiry
%Delay Msgs - % of msgs enqueued with delay
%Trasf Time - % of Enqueue time spent in transformation
%Eval Time - % of Enqueue time spent in rule evaluation

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Deq Time(s)	%Transf Time	%Eval Time
SYS.ALERT_QUE(12733)	0	0			0.00
SYS.AQ$_ALERT_QT_E(12732)	0	0			0.00
SYSMAN.MGMT_TASK_Q(68711)	10	10	0.00	0.00	0.01	0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps

Queue Name	Enqueue Msgs/sec	Dequeue Msgs/sec	Avg Enqueue sec / msg	Avg Dequeue sec / msg
SYS.ALERT_QUE(12733)	0.00	0.00
SYS.AQ$_ALERT_QT_E(12732)	0.00	0.00
SYSMAN.MGMT_TASK_Q(68711)	0.06	0.06	0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Ordered by Queue Name, Subscriber Name
* indicates Subscriber activity (re)started between Begin/End snaps

Subscriber/Queue	Enqueue Msgs	Dequeue Msgs	Expire Msgs	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE	0	0	0
LOCALHOST_3938_ORCL(41)/SYS.ALERT_QUE	0	0	0	0.00	0.00	0.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Shared Server Statistics

Shared Servers Activity
Shared Servers Rates
Shared Servers Utilization
Shared Servers Common Queue
Shared Servers Dispatchers

Shared Servers Activity

Values represent averages for all samples

Avg Total Connections	Avg Active Connections	Avg Total Shared Srvrs	Avg Active Shared Srvrs	Avg Total Dispatchers	Avg Active Dispatchers
0	0	1	0	1	0

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per Sec	Disp Queue Per Sec	Server Msgs/Sec	Server KB/Sec	Common Queue Total	Disp Queue Total	Server Total Msgs	Server Total(KB)
0	0	0	0.00	0	0	0	0

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Statistics are combined for all servers
Incoming and Outgoing Net % are included in %Busy

Total Server Time (s)	%Busy	%Idle	Incoming Net %	Outgoing Net %
163	0.00	100.00	0.00	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

Ordered by %Busy, descending
Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue
Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots

Name	Avg Conns	Total Disp Time (s)	%Busy	%Idle	Total Queued	Total Queue Wait (s)	Avg Queue Wait (ms)
D000	0.00	163	0.00	100.00	0	0

Back to Shared Server Statistics
Back to Top

init.ora Parameters

init.ora Parameters
init.ora Multi-Valued Parameters

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	C:\ORACLE\ADMIN\ORCL\ADUMP
audit_trail	DB
compatible	11.2.0.0.0
control_files	C:\ORACLE\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL
db_block_size	8192
db_domain	usf.ad.usfood.local
db_name	orcl
db_recovery_file_dest	C:\oracle\fast_recovery_area
db_recovery_file_dest_size	4353687552
diagnostic_dest	C:\ORACLE
dispatchers	(PROTOCOL=TCP) (SERVICE=orclXDB)
event	10503 trace name context forever, level 4000
local_listener	LISTENER_ORCL
memory_target	1291845632
open_cursors	300
processes	150
remote_login_passwordfile	EXCLUSIVE
undo_tablespace	UNDOTBS1

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

This section only displays parameters that have more one value
'(NULL)' indicates a missing parameter value
A blank in the End Snapshot indicates the same value as the BeginSnapshot

Parameter Name	Begin value	End value (if different)
control_files	C:\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL
control_files	C:\ORACLE\ORADATA\ORCL\CONTROL01.CTL

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	99.96	Redo NoWait %:	99.99
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	100.15	Soft Parse %:	92.50
Execute to Parse %:	99.76	Latch Hit %:	99.61
Parse CPU to Parse Elapsd %:	78.07	% Non-Parse CPU:	95.98