WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

LINUXS 570420430 linuxs 1 24-Sep-09 17:09 11.2.0.1.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
LINUXS	570420430	linuxs	1	24-Sep-09 17:09	11.2.0.1.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

stadf26 Linux IA (32-bit) 2 1 1 1.98

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
stadf26	Linux IA (32-bit)	2	1	1	1.98

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 884 25-Sep-09 14:13:03 28 1.3

End Snap: 885 25-Sep-09 14:13:17 28 1.3

Elapsed: 0.23 (mins)

DB Time: 1.09 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	884	25-Sep-09 14:13:03	28	1.3
End Snap:	885	25-Sep-09 14:13:17	28	1.3
Elapsed:		0.23 (mins)
DB Time:		1.09 (mins)

Report Summary

Cache Sizes

Begin End

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

Shared Pool Size: 100M 100M Log Buffer: 6,504K

	Begin	End
Buffer Cache:	16M	16M	Std Block Size:	8K
Shared Pool Size:	100M	100M	Log Buffer:	6,504K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 4.8 0.3 0.01 0.00

DB CPU(s): 0.9 0.1 0.00 0.00

Redo size: 361,171.3 24,539.9

Logical reads: 7,853.3 533.6

Block changes: 2,412.5 163.9

Physical reads: 24.7 1.7

Physical writes: 37.5 2.6

User calls: 1,137.4 77.3

Parses: 43.2 2.9

Hard parses: 0.3 0.0

W/A MB processed: 1.9 0.1

Logons: 1.5 0.1

Executes: 346.3 23.5

Rollbacks: 0.0 0.0

Transactions: 14.7

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	4.8	0.3	0.01	0.00
DB CPU(s):	0.9	0.1	0.00	0.00
Redo size:	361,171.3	24,539.9
Logical reads:	7,853.3	533.6
Block changes:	2,412.5	163.9
Physical reads:	24.7	1.7
Physical writes:	37.5	2.6
User calls:	1,137.4	77.3
Parses:	43.2	2.9
Hard parses:	0.3	0.0
W/A MB processed:	1.9	0.1
Logons:	1.5	0.1
Executes:	346.3	23.5
Rollbacks:	0.0	0.0
Transactions:	14.7

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.16 Redo NoWait %: 100.00

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

Library Hit %: 99.31 Soft Parse %: 99.32

Execute to Parse %: 87.53 Latch Hit %: 98.89

Parse CPU to Parse Elapsd %: 133.33 % Non-Parse CPU: 99.67

Shared Pool Statistics

Begin End

Memory Usage %: 92.01 92.05

% SQL with executions>1: 72.61 75.32

% Memory for SQL w/exec>1: 67.28 70.40

	Begin	End
Memory Usage %:	92.01	92.05
% SQL with executions>1:	72.61	75.32
% Memory for SQL w/exec>1:	67.28	70.40

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
enq: RC - Result Cache: Contention	1,510	28	18	42.30	Application
DB CPU		12		18.29
buffer busy waits	615	9	15	13.64	Concurrency
log file sync	191	4	20	5.69	Commit
latch: In memory undo latch	412	3	8	4.96	Concurrency

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

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

0.37 2.61 53.4 17.4 9.6 29.1

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.37	2.61	53.4	17.4	9.6	29.1

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

45.0 63.5 0.0

Memory Statistics

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

Begin End

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

SGA use (MB): 171.6 171.6

PGA use (MB): 44.0 44.3

% Host Mem used for SGA+PGA: 10.65 10.66

	Begin	End
Host Mem (MB):	2,025.4	2,025.4
SGA use (MB):	171.6	171.6
PGA use (MB):	44.0	44.3
% Host Mem used for SGA+PGA:	10.65	10.66

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): 65.6s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	56.76	86.53
DB CPU	12.00	18.29
connection management call elapsed time	0.34	0.52
PL/SQL execution elapsed time	0.17	0.26
parse time elapsed	0.11	0.16
sequence load elapsed time	0.03	0.04
hard parse elapsed time	0.02	0.03
repeated bind elapsed time	0.00	0.00
DB time	65.60
background elapsed time	5.03
background cpu time	0.24

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Statistic	Value	End Value
BUSY_TIME	1,927
IDLE_TIME	790
IOWAIT_TIME	260
NICE_TIME	0
SYS_TIME	472
USER_TIME	1,452
LOAD	0	3
PHYSICAL_MEMORY_BYTES	2,123,755,520
NUM_CPUS	2
NUM_CPU_CORES	1
NUM_CPU_SOCKETS	1
GLOBAL_RECEIVE_SIZE_MAX	524,288
GLOBAL_SEND_SIZE_MAX	524,288
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	174,760
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	131,072
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
25-Sep 14:13:03	0.37
25-Sep 14:13:17	2.61	70.92	53.44	17.37	29.08	9.57

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 92.2% of Total DB time 65.60 (s)
Total FG Wait Time: 48.47 (s) DB CPU time: 12.00 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Application	1,518	0	28	19	43.06
Concurrency	1,266	0	15	12	22.96
DB CPU			12		18.29
Commit	191	0	4	20	5.69
Other	129	6	1	9	1.84
User I/O	345	0	0	0	0.17
Network	15,471	0	0	0	0.16
System I/O	81	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
enq: RC - Result Cache: Contention	1,510	28	18	7.51	42.30
buffer busy waits	615	9	15	3.06	13.64
log file sync	191	4	20	0.95	5.69
latch: In memory undo latch	412	3	8	2.05	4.96
latch: cache buffers chains	221	2	9	1.10	2.92
latch free	58	1	15	0.29	1.33
library cache: mutex X	3	1	217	0.01	0.99
enq: TX - row lock contention	8	1	63	0.04	0.76
latch: change notification client cache latch	61	0	5	0.30	0.47
library cache load lock	12	0	21	0.06	0.38
SQL*Net message to client	15,471	0	0	76.97	0.16
direct path write temp	51	0	2	0.25	0.12
latch: row cache objects	2	0	20	0.01	0.06
latch: undo global data	1	0	27	0.00	0.04
Disk file operations I/O	28	0	1	0.14	0.02
db file sequential read	249	0	0	1.24	0.02
control file sequential read	81	0	0	0.40	0.00
SQL*Net message from client	15,471	147	10	76.97

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	476	0	3	6	2.37	55.73
db file async I/O submit	3	0	1	476	0.01	28.38
control file parallel write	4	0	1	296	0.02	23.56
reliable message	3	0	0	40	0.01	2.36
rdbms ipc reply	3	0	0	12	0.01	0.75
LGWR wait for redo copy	4	0	0	4	0.02	0.35
smon timer	2	0	207	103272	0.01
rdbms ipc message	296	18	139	470	1.47
EMON slave idle wait	12	100	60	5027	0.06
Streams AQ: qmn coordinator idle wait	2	50	28	14037	0.01
Streams AQ: qmn slave idle wait	1	0	28	28065	0.00
DIAG idle wait	26	100	26	1011	0.13
Space Manager: slave idle wait	3	100	15	5015	0.01
pmon timer	6	50	12	1918	0.03
Streams AQ: emn coordinator idle wait	1	100	10	10002	0.00
SQL*Net message from client	80	0	0	1	0.40

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	28	92.9	7.1
LGWR wait for redo copy	4	25.0		25.0	50.0
SQL*Net message to client	15.5K	100.0	.0			.0
asynch descriptor resize	29	100.0
buffer busy waits	615	37.7	3.6	4.4	8.6	16.7	17.2	11.7
control file parallel write	4	50.0				25.0			25.0
control file sequential read	89	100.0
db file async I/O submit	3						33.3	66.7
db file scattered read	8	100.0
db file sequential read	211	100.0
direct path read temp	9	100.0
direct path write temp	51	70.6	15.7	3.9	9.8
enq: RC - Result Cache: Contention	1510	2.5	6.4	14.6	19.9	26.1	21.7	8.8
enq: TX - row lock contention	8					12.5	12.5	75.0
latch free	58	6.9	5.2	5.2	22.4	8.6	51.7
latch: In memory undo latch	412	43.2	2.4	2.4	11.4	24.3	13.6	2.7
latch: cache buffers chains	221	38.5	3.6	4.5	11.3	23.1	13.1	5.9
latch: change notification client cache latch	61	24.6	9.8	27.9	14.8	18.0	4.9
latch: enqueue hash chains	1	100.0
latch: row cache objects	2						100.0
latch: shared pool	1	100.0
latch: undo global data	1						100.0
library cache load lock	12			8.3		25.0	50.0	16.7
library cache: mutex X	3							100.0
log file parallel write	476	70.8	8.8	4.4	5.5	5.3	3.4	1.7	.2
log file sync	191	9.4	8.4	19.4	8.9	23.0	23.0	7.3	.5
rdbms ipc reply	3				33.3	33.3	33.3
reliable message	3					33.3	33.3	33.3
DIAG idle wait	26							100.0
EMON slave idle wait	12								100.0
SQL*Net message from client	15.5K	39.3	12.5	13.1	12.4	12.3	6.8	3.5	.1
Space Manager: slave idle wait	3								100.0
Streams AQ: emn coordinator idle wait	1								100.0
Streams AQ: qmn coordinator idle wait	2						50.0		50.0
Streams AQ: qmn slave idle wait	1								100.0
pmon timer	6							16.7	83.3
rdbms ipc message	295	12.5	.7	1.4	7.5	9.5	12.9	43.7	11.9
smon timer	2	50.0							50.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	<2s
		% of Total Waits
buffer busy waits	72	88.3	8.6	2.0	1.1
control file parallel write	1	75.0						25.0
db file async I/O submit	2	33.3					66.7
enq: RC - Result Cache: Contention	133	91.2	7.3	.7		.3	.5
enq: TX - row lock contention	6	25.0	37.5	25.0	12.5
latch: In memory undo latch	11	97.3	2.7
latch: cache buffers chains	13	94.1	5.9
library cache load lock	2	83.3	16.7
library cache: mutex X	3				100.0
log file parallel write	9	98.1	1.3	.4				.2
log file sync	15	92.1	6.8	.5				.5
reliable message	1	66.7		33.3

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	66	12	107
SYS$BACKGROUND	0	0	0
linuxs.regress.rdbms.dev.us.oracle.com	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	351	0	1266	15	0	0	15471	0
SYS$BACKGROUND	1	0	0	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 84.3% of Total DB Time (s): 66
Captured PL/SQL account for 1.5% of Total DB Time (s): 66

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
40.54	3,851	0.01	61.81	9.48	0.00	g7jtuggkvm0vw	stage5@stadf26 (TNS V1-V3)	select /+ result_cache / emp...
12.01	200	0.06	18.31	20.40	0.10	b6vvz2u69xdma	stage5@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
2.14	61	0.04	3.26	12.36	0.08	9whcc4w2ws87n	stage5@stadf26 (TNS V1-V3)	select region_id, region_name ...
0.78	1	0.78	1.18	79.94	12.70	2ntzsd2w869g8	sqlplus@stadf26 (TNS V1-V3)	begin :bid := DBMS_WORKLOAD_RE...
0.24	1	0.24	0.36	66.15	0.30	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.16	1	0.16	0.24	36.69	70.08	5dfmd823r8dsp		insert into wrh$_memory_resize...
0.04	78	0.00	0.05	70.33	0.00	14s9r0q98gw40		select queryId, queryflags, se...
0.02	1	0.02	0.04	97.24	0.58	fs3v23b2ytmfc		SELECT SYS.WRI$_ADV_SEQ_TASK.N...
0.02	4	0.01	0.03	108.39	0.62	axmdf8vq7k1rh		select increment$, minvalue, m...
0.02	20	0.00	0.03	100.43	2.34	4vs91dcv7u1p6	stage5@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...

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 58.4% of Total CPU Time (s): 12
Captured PL/SQL account for 6.5% of Total CPU Time (s): 12

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
3.84	3,851	0.00	32.03	40.54	9.48	0.00	g7jtuggkvm0vw	stage5@stadf26 (TNS V1-V3)	select /+ result_cache / emp...
2.45	200	0.01	20.43	12.01	20.40	0.10	b6vvz2u69xdma	stage5@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
0.62	1	0.62	5.18	0.78	79.94	12.70	2ntzsd2w869g8	sqlplus@stadf26 (TNS V1-V3)	begin :bid := DBMS_WORKLOAD_RE...
0.26	61	0.00	2.20	2.14	12.36	0.08	9whcc4w2ws87n	stage5@stadf26 (TNS V1-V3)	select region_id, region_name ...
0.16	1	0.16	1.30	0.24	66.15	0.30	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.06	1	0.06	0.48	0.16	36.69	70.08	5dfmd823r8dsp		insert into wrh$_memory_resize...
0.03	66	0.00	0.22	0.02	132.07	0.43	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
0.02	78	0.00	0.21	0.04	70.33	0.00	14s9r0q98gw40		select queryId, queryflags, se...
0.02	4	0.01	0.20	0.02	108.39	0.62	axmdf8vq7k1rh		select increment$, minvalue, m...
0.02	1	0.02	0.19	0.02	97.24	0.58	fs3v23b2ytmfc		SELECT SYS.WRI$_ADV_SEQ_TASK.N...

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.11	1	0.11	102.21	0.16	36.69	70.08	5dfmd823r8dsp		insert into wrh$_memory_resize...
0.10	1	0.10	91.04	0.78	79.94	12.70	2ntzsd2w869g8	sqlplus@stadf26 (TNS V1-V3)	begin :bid := DBMS_WORKLOAD_RE...
0.01	200	0.00	11.32	12.01	20.40	0.10	b6vvz2u69xdma	stage5@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
0.00	61	0.00	1.56	2.14	12.36	0.08	9whcc4w2ws87n	stage5@stadf26 (TNS V1-V3)	select region_id, region_name ...
0.00	3	0.00	0.72	0.01	112.87	8.82	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
0.00	3,851	0.00	0.68	40.54	9.48	0.00	g7jtuggkvm0vw	stage5@stadf26 (TNS V1-V3)	select /+ result_cache / emp...
0.00	1	0.00	0.66	0.24	66.15	0.30	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.00	2	0.00	0.59	0.02	10.90	3.49	cg0jgkqay6any		insert into chnf$_queries valu...
0.00	3	0.00	0.48	0.00	51.47	26.71	2q93zsrvbdw48		select grantee#, privilege#, n...
0.00	20	0.00	0.45	0.02	100.43	2.34	4vs91dcv7u1p6	stage5@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...

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: 107,253
Captured SQL account for 98.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
70,039	3,851	18.19	65.30	40.54	9.48	0.00	g7jtuggkvm0vw	stage5@stadf26 (TNS V1-V3)	select /+ result_cache / emp...
32,106	200	160.53	29.93	12.01	20.40	0.10	b6vvz2u69xdma	stage5@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
4,087	1	4,087.00	3.81	0.78	79.94	12.70	2ntzsd2w869g8	sqlplus@stadf26 (TNS V1-V3)	begin :bid := DBMS_WORKLOAD_RE...
1,070	1	1,070.00	1.00	0.24	66.15	0.30	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
710	1	710.00	0.66	0.02	100.40	0.26	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAOBJ...
225	61	3.69	0.21	2.14	12.36	0.08	9whcc4w2ws87n	stage5@stadf26 (TNS V1-V3)	select region_id, region_name ...
208	66	3.15	0.19	0.02	132.07	0.43	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
165	1	165.00	0.15	0.02	101.69	0.50	586b2udq6dbng		insert into wrh$_sysstat (snap...
147	78	1.88	0.14	0.04	70.33	0.00	14s9r0q98gw40		select queryId, queryflags, se...
143	1	143.00	0.13	0.01	100.92	4.71	6wm3n4d7bnddg		SELECT source, (case when tim...

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

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
376	1	376.00	111.57	0.78	79.94	12.70	2ntzsd2w869g8	sqlplus@stadf26 (TNS V1-V3)	begin :bid := DBMS_WORKLOAD_RE...
63	1	63.00	18.69	0.16	36.69	70.08	5dfmd823r8dsp		insert into wrh$_memory_resize...
59	1	59.00	17.51	0.24	66.15	0.30	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
49	1	49.00	14.54	0.01	100.92	4.71	6wm3n4d7bnddg		SELECT source, (case when tim...
12	61	0.20	3.56	2.14	12.36	0.08	9whcc4w2ws87n	stage5@stadf26 (TNS V1-V3)	select region_id, region_name ...
9	1	9.00	2.67	0.01	103.93	1.78	84qubbrsr0kfn		insert into wrh$_latch (snap_i...
4	3	1.33	1.19	0.01	112.87	8.82	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
4	4	1.00	1.19	0.02	108.39	0.62	axmdf8vq7k1rh		select increment$, minvalue, m...
4	1	4.00	1.19	0.02	97.24	0.58	fs3v23b2ytmfc		SELECT SYS.WRI$_ADV_SEQ_TASK.N...
3	1	3.00	0.89	0.02	101.69	0.50	586b2udq6dbng		insert into wrh$_sysstat (snap...

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: 242
Captured SQL account for 32.2% of Total
Total UnOptimized Read Requests: 242
Captured SQL account for 32.2% 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	%Total	SQL Id	SQL Module	SQL Text
365	365	1	365.00	150.83	2ntzsd2w869g8	sqlplus@stadf26 (TNS V1-V3)	begin :bid := DBMS_WORKLOAD_RE...
24	24	1	24.00	9.92	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
12	12	61	0.20	4.96	9whcc4w2ws87n	stage5@stadf26 (TNS V1-V3)	select region_id, region_name ...
9	9	1	9.00	3.72	5dfmd823r8dsp		insert into wrh$_memory_resize...
4	4	3	1.33	1.65	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
4	4	4	1.00	1.65	axmdf8vq7k1rh		select increment$, minvalue, m...
4	4	1	4.00	1.65	fs3v23b2ytmfc		SELECT SYS.WRI$_ADV_SEQ_TASK.N...
3	3	66	0.05	1.24	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
3	3	200	0.02	1.24	b6vvz2u69xdma	stage5@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
3	3	3,851	0.00	1.24	g7jtuggkvm0vw	stage5@stadf26 (TNS V1-V3)	select /+ result_cache / emp...

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: 4,730
Captured SQL account for 95.7% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
3,851	29,487	7.66	40.54	9.48	0.00	g7jtuggkvm0vw	stage5@stadf26 (TNS V1-V3)	select /+ result_cache / emp...
200	15,200	76.00	12.01	20.40	0.10	b6vvz2u69xdma	stage5@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
78	68	0.87	0.04	70.33	0.00	14s9r0q98gw40		select queryId, queryflags, se...
66	66	1.00	0.02	132.07	0.43	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
61	61	1.00	2.14	12.36	0.08	9whcc4w2ws87n	stage5@stadf26 (TNS V1-V3)	select region_id, region_name ...
40	0	0.00	0.01	76.64	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
20	40	2.00	0.01	84.49	0.00	0k8522rmdzg4k		select privilege# from sysauth...
20	20	1.00	0.01	90.18	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
20	20	1.00	0.01	109.19	0.00	459f3z9u4fb3u		select value$ from props$ wher...
20	20	1.00	0.02	100.43	2.34	4vs91dcv7u1p6	stage5@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 590
Captured SQL account for 67.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
78	78	13.22	14s9r0q98gw40		select queryId, queryflags, se...
40	40	6.78	cm5vu20fhtnq1		select /*+ connect_by_filterin...
20	20	3.39	0k8522rmdzg4k		select privilege# from sysauth...
20	20	3.39	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
20	20	3.39	459f3z9u4fb3u		select value$ from props$ wher...
20	20	3.39	4vs91dcv7u1p6	stage5@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
20	20	3.39	5ur69atw3vfhj		select decode(failover_method,...
20	61	3.39	9whcc4w2ws87n	stage5@stadf26 (TNS V1-V3)	select region_id, region_name ...
20	200	3.39	b6vvz2u69xdma	stage5@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
20	20	3.39	f711myt0q6cma	stage5@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
20	3,851	3.39	g7jtuggkvm0vw	stage5@stadf26 (TNS V1-V3)	select /+ result_cache / emp...
11	11	1.86	65ybjbqzzub8u		select regflags, numobjs, obja...
11	11	1.86	fqpqxphhajgtn		select connection# from loc$ w...
6	6	1.02	11nt23ch7gw4a		update SYS.invalidation_regist...
6	6	1.02	ayrdj17v4uv2w		select queryId, queryflags, se...

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

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

11nt23ch7gw4a update SYS.invalidation_registry$ set numobjs = :1, objarray = :2 where regid = :3 and numobjs = :4

14s9r0q98gw40 select queryId, queryflags, selectList, fromList, whereClause, userid from SYS.chnf$_queries where hashval = :1

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)

2ntzsd2w869g8 begin :bid := DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;

2q93zsrvbdw48 select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#

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

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)

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

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 )

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

65ybjbqzzub8u select regflags, numobjs, objarray, plsqlcallback, changelag, username from SYS.invalidation_registry$ where regid = :1 for update NOWAIT

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

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

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

7qjhf5dzmazsr SELECT snap_id , OBJ#, DATAOBJ# FROM (SELECT /*+ ordered use_nl(t2) index(t2) */ t2.snap_id , t1.OBJN_KEWRSEG OBJ#, t1.OBJD_KEWRSEG DATAOBJ# FROM X$KEWRTSEGSTAT t1, WRH$_SEG_STAT_OBJ t2 WHERE t2.dbid(+) = :dbid AND t2.OBJ#(+) = t1.OBJN_KEWRSEG AND t2.DATAOBJ#(+) = t1.OBJD_KEWRSEG) WHERE nvl(snap_id, 0) < :snap_id

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

9whcc4w2ws87n select region_id, region_name from regions where region_id = :regionID

axmdf8vq7k1rh select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1

ayrdj17v4uv2w select queryId, queryflags, selectList, fromList, whereClause, userid from SYS.chnf$_queries where hashval = :1 for update

b6vvz2u69xdma update myemp set sal = :sal where empno = :id

cg0jgkqay6any insert into chnf$_queries values (:1, :2, :3, :4, :5, :6, :7, :8)

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

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

fqpqxphhajgtn select connection# from loc$ where location_name = :1 and emon# = :2

fs3v23b2ytmfc SELECT SYS.WRI$_ADV_SEQ_TASK.NEXTVAL FROM DUAL

g7jtuggkvm0vw select /*+ result_cache */ empno, ename from empview where empno > :EMPNO order by empno

SQL Id	SQL Text
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')
11nt23ch7gw4a	update SYS.invalidation_registry$ set numobjs = :1, objarray = :2 where regid = :3 and numobjs = :4
14s9r0q98gw40	select queryId, queryflags, selectList, fromList, whereClause, userid from SYS.chnf$_queries where hashval = :1
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)
2ntzsd2w869g8	begin :bid := DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
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)
586b2udq6dbng	insert into wrh$_sysstat (snap_id, dbid, instance_number, stat_id, value) select :snap_id, :dbid, :instance_number, stat_id, value from v$sysstat order by stat_id
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 )
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
65ybjbqzzub8u	select regflags, numobjs, objarray, plsqlcallback, changelag, username from SYS.invalidation_registry$ where regid = :1 for update NOWAIT
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7qjhf5dzmazsr	SELECT snap_id , OBJ#, DATAOBJ# FROM (SELECT /+ ordered use_nl(t2) index(t2) / t2.snap_id , t1.OBJN_KEWRSEG OBJ#, t1.OBJD_KEWRSEG DATAOBJ# FROM X$KEWRTSEGSTAT t1, WRH$_SEG_STAT_OBJ t2 WHERE t2.dbid(+) = :dbid AND t2.OBJ#(+) = t1.OBJN_KEWRSEG AND t2.DATAOBJ#(+) = t1.OBJD_KEWRSEG) WHERE nvl(snap_id, 0) < :snap_id
84qubbrsr0kfn	insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
9whcc4w2ws87n	select region_id, region_name from regions where region_id = :regionID
axmdf8vq7k1rh	select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
ayrdj17v4uv2w	select queryId, queryflags, selectList, fromList, whereClause, userid from SYS.chnf$_queries where hashval = :1 for update
b6vvz2u69xdma	update myemp set sal = :sal where empno = :id
cg0jgkqay6any	insert into chnf$_queries values (:1, :2, :3, :4, :5, :6, :7, :8)
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
f711myt0q6cma	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
fqpqxphhajgtn	select connection# from loc$ where location_name = :1 and emon# = :2
fs3v23b2ytmfc	SELECT SYS.WRI$_ADV_SEQ_TASK.NEXTVAL FROM DUAL
g7jtuggkvm0vw	select /+ result_cache / empno, ename from empview where empno > :EMPNO order by empno

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 (bound) vector count	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	2	0.15	0.01
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	1,032	75.57	5.13
CPU used when call started	1,036	75.86	5.15
CR blocks created	677	49.57	3.37
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	20	1.46	0.10
DB time	6,454	472.58	32.11
DBWR checkpoint buffers written	0	0.00	0.00
DBWR checkpoints	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	0	0.00	0.00
DBWR undo block writes	39	2.86	0.19
HSC Heap Segment Block Changes	15,483	1,133.70	77.03
Heap Segment Array Inserts	69	5.05	0.34
Heap Segment Array Updates	23	1.68	0.11
IMU CR rollbacks	7,902	578.60	39.31
IMU Flushes	103	7.54	0.51
IMU Redo allocation size	1,552,104	113,648.97	7,721.91
IMU commits	95	6.96	0.47
IMU contention	100	7.32	0.50
IMU pool not allocated	3	0.22	0.01
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	4,405,924	322,612.87	21,920.02
IMU- failed to get a private strand	0	0.00	0.00
LOB table id lookup cache misses	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SMON posted for undo segment shrink	1	0.07	0.00
SQL*Net roundtrips to/from client	15,471	1,132.83	76.97
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	1,173	85.89	5.84
application wait time	2,825	206.85	14.05
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	53	3.88	0.26
buffer is not pinned count	2,622	191.99	13.04
buffer is pinned count	3,867	283.15	19.24
bytes received via SQL*Net from client	556,932	40,779.97	2,770.81
bytes sent via SQL*Net to client	2,911,488	213,186.50	14,485.01
calls to get snapshot scn: kcmgss	24,636	1,803.91	122.57
calls to kcmgas	1,133	82.96	5.64
calls to kcmgcs	4,301	314.93	21.40
cell physical IO interconnect bytes	13,682,176	1,001,843.45	68,070.53
change write time	32	2.34	0.16
cleanout - number of ktugct calls	620	45.40	3.08
cleanouts and rollbacks - consistent read gets	546	39.98	2.72
cleanouts only - consistent read gets	23	1.68	0.11
cluster key scan block gets	18	1.32	0.09
cluster key scans	16	1.17	0.08
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	14	1.03	0.07
commit cleanout failures: cannot pin	21	1.54	0.10
commit cleanouts	515	37.71	2.56
commit cleanouts successfully completed	480	35.15	2.39
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	92	6.74	0.46
concurrency wait time	1,506	110.27	7.49
consistent changes	71,092	5,205.54	353.69
consistent gets	89,373	6,544.12	444.64
consistent gets - examination	65,709	4,811.38	326.91
consistent gets from cache	89,373	6,544.12	444.64
consistent gets from cache (fastpath)	22,935	1,679.36	114.10
cursor authentications	1	0.07	0.00
data blocks consistent reads - undo records applied	70,736	5,179.47	351.92
db block changes	32,948	2,412.54	163.92
db block gets	17,880	1,309.22	88.96
db block gets direct	0	0.00	0.00
db block gets from cache	17,880	1,309.22	88.96
db block gets from cache (fastpath)	445	32.58	2.21
deferred (CURRENT) block cleanout applications	195	14.28	0.97
dirty buffers inspected	175	12.81	0.87
enqueue conversions	24	1.76	0.12
enqueue releases	7,429	543.97	36.96
enqueue requests	7,658	560.74	38.10
enqueue timeouts	229	16.77	1.14
enqueue waits	1,518	111.15	7.55
execute count	4,730	346.34	23.53
file io service time	0	0.00	0.00
file io wait time	1,429,494	104,671.16	7,111.91
free buffer inspected	581	42.54	2.89
free buffer requested	1,332	97.53	6.63
heap block compress	18	1.32	0.09
hot buffers moved to head of LRU	134	9.81	0.67
immediate (CR) block cleanout applications	569	41.66	2.83
immediate (CURRENT) block cleanout applications	54	3.95	0.27
index crx upgrade (positioned)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fetch by key	16,362	1,198.07	81.40
index scans kdiixs1	2,320	169.88	11.54
leaf node 90-10 splits	11	0.81	0.05
leaf node splits	14	1.03	0.07
lob reads	0	0.00	0.00
lob writes	3	0.22	0.01
lob writes unaligned	3	0.22	0.01
logons cumulative	20	1.46	0.10
max cf enq hold time	0	0.00	0.00
messages received	253	18.53	1.26
messages sent	253	18.53	1.26
min active SCN optimization applied on CR	0	0.00	0.00
no buffer to keep pinned count	12	0.88	0.06
no work - consistent read gets	18,469	1,352.35	91.89
non-idle wait count	23,234	1,701.25	115.59
non-idle wait time	5,405	395.77	26.89
opened cursors cumulative	702	51.40	3.49
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	4	0.29	0.02
parse count (total)	590	43.20	2.94
parse time cpu	4	0.29	0.02
parse time elapsed	3	0.22	0.01
physical read IO requests	242	17.72	1.20
physical read bytes	2,760,704	202,145.71	13,734.85
physical read total IO requests	334	24.46	1.66
physical read total bytes	4,243,456	310,716.56	21,111.72
physical read total multi block requests	0	0.00	0.00
physical reads	337	24.68	1.68
physical reads cache	274	20.06	1.36
physical reads cache prefetch	41	3.00	0.20
physical reads direct	63	4.61	0.31
physical reads direct temporary tablespace	63	4.61	0.31
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	172	12.59	0.86
physical write bytes	4,194,304	307,117.52	20,867.18
physical write total IO requests	416	30.46	2.07
physical write total bytes	9,438,720	691,126.89	46,958.81
physical write total multi block requests	4	0.29	0.02
physical writes	512	37.49	2.55
physical writes direct	357	26.14	1.78
physical writes direct temporary tablespace	357	26.14	1.78
physical writes from cache	155	11.35	0.77
physical writes non checkpoint	509	37.27	2.53
pinned buffers inspected	2	0.15	0.01
pinned cursors current	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	4,589	336.02	22.83
recursive cpu usage	105	7.69	0.52
redo blocks checksummed by FG (exclusive)	6,623	484.95	32.95
redo blocks read for recovery	0	0.00	0.00
redo blocks written	10,115	740.65	50.32
redo buffer allocation retries	0	0.00	0.00
redo entries	6,004	439.63	29.87
redo entries for lost write detection	224	16.40	1.11
redo k-bytes read for recovery	0	0.00	0.00
redo k-bytes read total	0	0.00	0.00
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	156	11.42	0.78
redo size	4,932,516	361,171.27	24,539.88
redo size for direct writes	0	0.00	0.00
redo size for lost write detection	12,796	936.96	63.66
redo subscn max counts	235	17.21	1.17
redo synch time	375	27.46	1.87
redo synch writes	240	17.57	1.19
redo wastage	54,256	3,972.76	269.93
redo write time	288	21.09	1.43
redo writes	238	17.43	1.18
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	200	14.64	1.00
rows fetched via callback	288	21.09	1.43
session cursor cache hits	167	12.23	0.83
session logical reads	107,253	7,853.34	533.60
shared hash latch upgrades - no wait	503	36.83	2.50
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	2,153	157.65	10.71
sorts (rows)	19,703	1,442.70	98.02
sql area evicted	3	0.22	0.01
sql area purged	0	0.00	0.00
summed dirty queue length	160	11.72	0.80
switch current to new buffer	79	5.78	0.39
table fetch by rowid	2,329	170.54	11.59
table fetch continued row	0	0.00	0.00
table scan blocks gotten	2,257	165.26	11.23
table scan rows gotten	48,984	3,586.73	243.70
table scans (long tables)	0	0.00	0.00
table scans (short tables)	2,056	150.55	10.23
temp space allocated (bytes)	1,048,576	76,779.38	5,216.80
total cf enq hold time	0	0.00	0.00
total number of cf enq holders	0	0.00	0.00
total number of times SMON posted	2	0.15	0.01
transaction rollbacks	0	0.00	0.00
undo change vector size	2,154,536	157,760.56	10,719.08
user I/O wait time	10	0.73	0.05
user calls	15,533	1,137.37	77.28
user commits	201	14.72	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	2	0.15	0.01
workarea executions - optimal	2,058	150.69	10.24
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
opened cursors current	36	37
logons current	28	28
session uga memory max	393,109,432	400,376,716
session pga memory	94,484,980	94,616,052
session pga memory max	113,490,420	114,014,708
session cursor cache count	5,871	6,074
session uga memory	184,717,398,556	184,718,770,004

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

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

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
LGWR	0M	0.00	0M	4M	17.57	.292890	238	11.25
Direct Writes	0M	0.00	0M	3M	3.73	.219667	51	1.41
Buffer Cache Reads	2M	15.45	.146445	0M	0.00	0M	211	0.00
DBWR	0M	0.00	0M	2M	8.86	.146445	3	475.33
Others	2M	6.74	.146445	0M	0.29	0M	100	23.64
Direct Reads	1M	0.66	.073222	0M	0.00	0M	9	0.00
TOTAL:	5M	22.85	.366112	9M	30.46	.659002	612	10.68

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read
Log File	0M	0.00	0M	4M	17.57	.292890
Control File	2M	6.59	.146445	0M	0.37	0M	0.00
Data File	1M	15.60	.073222	1M	8.86	.073222	0.00
Temp File	0M	0.66	0M	2M	3.73	.146445	0.00
TOTAL:	3M	22.85	.219667	7M	30.53	.512557	0.00

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
LGWR	0M	0.00	0M	4M	17.57	.292890	0
LGWR (Log File)	0M	0.00	0M	4M	17.57	.292890	0
Direct Writes	0M	0.00	0M	3M	3.73	.219667	0
Direct Writes (Data File)	0M	0.00	0M	3M	3.73	.219667	0
Buffer Cache Reads	2M	15.16	.146445	0M	0.00	0M	207	0.00
Buffer Cache Reads (Data File)	2M	15.16	.146445	0M	0.00	0M	207	0.00
DBWR	0M	0.00	0M	2M	8.86	.146445	0
DBWR (Data File)	0M	0.00	0M	2M	8.86	.146445	0
Direct Reads	1M	0.66	.073222	0M	0.00	0M	0
Direct Reads (Data File)	1M	0.66	.073222	0M	0.00	0M	0
Others	1M	6.81	.073222	0M	0.37	0M	93	0.00
Others (Control File)	1M	6.59	.073222	0M	0.37	0M	90	0.00
Others (Data File)	0M	0.22	0M	0M	0.00	0M	3	0.00
TOTAL:	4M	22.63	.292890	9M	30.53	.659002	300	0.00

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SYSAUX	222	16	0.09	1.18	97	7	0	0.00
TEMP	9	1	0.00	7.00	51	4	0	0.00
SYSTEM	36	3	0.00	1.00	1	0	570	12.25
UD1	5	0	0.00	1.00	23	2	326	6.23

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SYSAUX	/ade/b/3050220379/oracle/dbs/t_ax1.f	222	16	0.09	1.18	97	7	0	0.00
SYSTEM	/ade/b/3050220379/oracle/dbs/t_db1.f	36	3	0.00	1.00	1	0	570	12.25
TEMP	/ade/b/3050220379/oracle/dbs/t_tmp1.f	9	1	0.00	7.00	51	4	0
UD1	/ade/b/3050220379/oracle/dbs/t_undo1.f	5	0	0.00	1.00	23	2	326	6.23

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	1,984	100	107,213	289	155	0	0	896

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 512

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

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	13	257	543	2550	41472	2550
E	0	13	615	10658	12048	41472	12048

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	4	0.25	0	1.78	78	1	783.00
D	8	0.50	1	1.31	57	1	574.00
D	12	0.75	1	1.21	53	1	528.00
D	16	1.00	2	1.00	44	1	438.00
D	20	1.25	2	0.94	41	1	412.00
D	24	1.50	3	0.92	40	1	403.00
D	28	1.75	3	0.89	39	1	392.00
D	32	2.00	4	0.88	38	1	384.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
77.41	26	8

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	29	4	44.01	0.00	0.00	0.00	0.00	5,939
E	29	4	44.26	0.00	0.00	0.00	0.00	5,939

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	1-Pass Execs
2K	4K	2,034	2,034	0
64K	128K	2	2	0
512K	1024K	20	20	0
2M	4M	2	0	2

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
15	0.50	948.12	15.23	98.00	3	1,237,684
22	0.75	948.12	15.23	98.00	3	1,237,684
29	1.00	948.12	3.81	100.00	3	1,223,008
35	1.20	948.12	3.81	100.00	2	1,223,008
41	1.40	948.12	0.00	100.00	1	1,218,117
46	1.60	948.12	0.00	100.00	1	1,218,117
52	1.80	948.12	0.00	100.00	1	1,218,117
58	2.00	948.12	0.00	100.00	0	1,218,117
87	3.00	948.12	0.00	100.00	0	1,218,117
116	4.00	948.12	0.00	100.00	0	1,218,117
174	6.00	948.12	0.00	100.00	0	1,218,117
232	8.00	948.12	0.00	100.00	0	1,218,117

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)
76	0.76	1	108	2,040	0.99	58	2.15	11
88	0.88	12	924	2,044	0.99	54	2.00	90
100	1.00	24	1,373	2,071	1.00	27	1.00	93
112	1.12	34	1,825	2,088	1.01	10	0.37	95
124	1.24	46	2,447	2,091	1.01	7	0.26	95
136	1.36	58	3,112	2,092	1.01	6	0.22	95
148	1.48	69	3,890	2,092	1.01	6	0.22	95
160	1.60	75	4,323	2,092	1.01	6	0.22	95
172	1.72	75	4,323	2,092	1.01	6	0.22	95
184	1.84	75	4,323	2,092	1.01	6	0.22	95
196	1.96	75	4,323	2,092	1.01	6	0.22	95
208	2.08	75	4,323	2,092	1.01	6	0.22	95

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	570	7	12
undo block	247	2	6
undo header	79	0	6

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)
RC-Result Cache: Enqueue (Result Cache: Contention)	6,677	6,486	191	1,510	28	18.54
TX-Transaction (row lock contention)	12	8	4	8	1	63.75

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	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0	0
ASM db client latch	20	0.00		0	0
ASM map operation hash table	1	0.00		0	0
ASM network state latch	3	0.00		0	0
AWR Alerted Metric Element list	8	0.00		0	0
Change Notification Hash table latch	66,646	0.04	0.00	0	0
Change Notification Latch	950	0.00		0	0
Consistent RBA	238	0.00		0	0
DML lock allocation	886	0.00		0	0
Event Group Locks	21	0.00		0	0
FOB s.o list latch	55	0.00		0	0
File State Object Pool Parent Latch	1	0.00		0	0
IPC stats buffer allocation latch	1	0.00		0	0
In memory undo latch	20,575	2.28	1.18	3	211	0.00
JS Sh mem access	1	0.00		0	0
JS queue access latch	1	0.00		0	0
JS queue state obj latch	90	0.00		0	0
JS slv state obj latch	1	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	1	0.00		0	0
KJCT flow control latch	1	0.00		0	0
KKCN reg stat latch	2	0.00		0	0
KMG MMAN ready and startup request latch	4	0.00		0	0
KTF sga latch	0			0	4	0.00
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	1	0.00		0	0
Memory Management Latch	1	0.00		0	4	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	61	0.00		0	0
OS process allocation	44	0.00		0	0
OS process: request allocation	40	0.00		0	0
PL/SQL warning settings	22	0.00		0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Result Cache: RC Latch	11,884	1.57	0.04	0	0
Result Cache: SO Latch	40	0.00		0	0
SGA IO buffer pool latch	9	0.00		0	9	0.00
SGA blob parent	1	0.00		0	0
SGA bucket locks	1	0.00		0	0
SGA heap locks	1	0.00		0	0
SGA pool locks	1	0.00		0	0
SQL memory manager latch	39	0.00		0	4	0.00
SQL memory manager workarea list latch	2,960	0.00		0	0
Shared B-Tree	2	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	1	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	7	0.00		0	0
active service list	184	0.00		0	372	0.00
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	34	0.00		0	0
cache buffers chains	370,454	1.46	0.06	2	858	0.47
cache buffers lru chain	354	0.00		0	2,169	0.00
cache table scan latch	8	0.00		0	8	0.00
call allocation	104	0.00		0	0
cas latch	1	0.00		0	0
change notification client cache latch	123,734	0.90	0.06	0	0
channel handle pool latch	41	0.00		0	0
channel operations parent latch	205	0.00		0	0
checkpoint queue latch	420	0.00		0	530	0.00
client/application info	141	0.00		0	0
compile environment latch	20	0.00		0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	3	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	3	0.00		0	0
dml lock allocation	3	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	41	0.00		0	0
enqueue hash chains	17,670	0.32	0.02	0	7	0.00
enqueues	13,874	2.47	0.21	1	0
fifth spare latch	1	0.00		0	0
file cache latch	14	0.00		0	0
flashback copy	1	0.00		0	0
gc element	1	0.00		0	0
gcs commit scn state	1	0.00		0	0
gcs partitioned table hash	1	0.00		0	0
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs resource freelist	1	0.00		0	0
gcs resource hash	1	0.00		0	0
gcs resource scan list	1	0.00		0	0
gcs shadows freelist	1	0.00		0	0
ges domain table	1	0.00		0	0
ges enqueue table freelist	1	0.00		0	0
ges group table	1	0.00		0	0
ges process hash list	1	0.00		0	0
ges process parent latch	1	0.00		0	0
ges resource hash list	1	0.00		0	0
ges resource scan list	1	0.00		0	0
ges resource table freelist	1	0.00		0	0
ges value block free list	1	0.00		0	0
global KZLD latch for mem in SGA	20	0.00		0	0
global tx hash mapping	1	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	0			0	8	0.00
hash table modification latch	22	0.00		0	0
heartbeat check	1	0.00		0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	1	0.00		0	0
job_queue_processes parameter latch	4	0.00		0	0
k2q lock allocation	1	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kks stats	10	0.00		0	0
kokc descriptor allocation latch	4	0.00		0	0
kpon sga structure	1	0.00		0	0
ksfv messages	1	0.00		0	0
kss move lock	1	0.00		0	0
ksuosstats global area	4	0.00		0	0
ksv allocation latch	3	0.00		0	0
ksv class latch	1	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	40	0.00		0	0
ktm global data	3	0.00		0	0
kwqbsn:qsga	1	0.00		0	0
lgwr LWN SCN	244	0.00		0	0
list of block allocation	51	0.00		0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	1	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
logical standby cache	1	0.00		0	0
logminer context allocation	1	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	1	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	19	0.00		0	0
messages	926	0.00		0	0
mostly latch-free SCN	244	0.00		0	0
msg queue latch	1	0.00		0	0
multiblock read objects	16	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	3	0.00		0	0
object queue header heap	48	0.00		0	13	0.00
object queue header operation	2,215	0.00		0	0
object stats modification	3	0.00		0	0
parallel query alloc buffer	1	0.00		0	0
parallel query stats	1	0.00		0	0
parameter list	1	0.00		0	0
parameter table management	40	0.00		0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
post/wait queue	468	0.00		0	385	0.00
process allocation	40	0.00		0	20	0.00
process group creation	40	0.00		0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qmn task queue latch	4	0.00		0	0
query server freelists	1	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	1,149	0.00		0	6,037	0.00
redo copy	1	0.00		0	6,037	0.08
redo writing	730	0.00		0	0
resmgr group change latch	20	0.00		0	0
resmgr:active threads	41	0.00		0	0
resmgr:actses change group	21	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	40	0.00		0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	1	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	3,295	0.12	0.50	0	0
second spare latch	1	0.00		0	0
sequence cache	87	0.00		0	0
session allocation	1,027	0.10	0.00	0	342	0.00
session idle bit	31,389	0.12	0.00	0	0
session queue latch	1	0.00		0	0
session switching	104	0.00		0	0
session timer	4	0.00		0	0
shared pool	1,572	0.06	1.00	0	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	137	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	7,713	0.00		0	0
simulator lru latch	1	0.00		0	7,656	0.34
sort extent pool	18	0.00		0	0
space background task latch	11	0.00		0	10	0.00
state object free list	2	0.00		0	0
statistics aggregation	336	0.00		0	0
tablespace key chain	1	0.00		0	0
temp lob duration state obj allocation	1	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
third spare latch	1	0.00		0	0
transaction allocation	89	0.00		0	0
undo global data	4,684	0.15	4.43	0	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	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	370,454	5,392	318	5,171
change notification client cache latch	123,734	1,108	65	1,047
In memory undo latch	20,575	470	554	59
enqueues	13,874	342	71	291
Result Cache: RC Latch	11,884	187	7	180
enqueue hash chains	17,670	56	1	55
undo global data	4,684	7	31	6
row cache objects	3,295	4	2	2
shared pool	1,572	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	ktichg: child	396	42
In memory undo latch	kticmt: child	116	0
In memory undo latch	ktiFlush: child	45	49
In memory undo latch	kturbk	6	470
Result Cache: RC Latch	Result Cache: Serialization12	9	1
cache buffers chains	kcbgtcr: fast path (cr pin)	198	62
cache buffers chains	kcbchg1: kslbegin: bufs not pinned	88	86
cache buffers chains	kcbchg1: kslbegin: call CR func	13	85
cache buffers chains	kcbzwb	12	4
cache buffers chains	kcbgtcr: kslbegin excl	8	7
cache buffers chains	kcbgtcr: fast path	4	9
cache buffers chains	kcbrls_1	3	36
cache buffers chains	kcbgcur_2	2	23
cache buffers chains	kcb_post_apply: kcbhq62	1	3
cache buffers chains	kcbnlc	1	0
change notification client cache latch	ktcnc compute query invalidation	70	0
change notification client cache latch	ktcncAddInvalidation	2	2
enqueue hash chains	ksqrcl	1	0
enqueues	ksqdel	36	32
enqueues	ksqgel: create enqueue	35	39
row cache objects	kqreqd: reget	2	0
shared pool	kghalo	1	1
undo global data	ktudba: KSLBEGIN	31	31

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Library Cache	kgllldl2 112	2	136
Library Cache	kglhdgn2 106	1	188

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: 107,253
Captured Segments account for 38.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
OCIHOL	SYSTEM	MYEMP	TABLE	21,248	19.81
OCIHOL	SYSTEM	SYS_C004756	INDEX	16,000	14.92
SYS	SYSAUX	WRH$_SEG_STAT_OBJ_PK	INDEX	848	0.79
SYS	SYSTEM	AUD$	TABLE	384	0.36
SYS	SYSTEM	I_SYSAUTH1	INDEX	320	0.30

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 337
Captured Segments account for 65.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	SCHEDULER$_EVENT_LOG	TABLE	49	14.54
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	42	12.46
SYS	SYSAUX	WRH$_SQL_PLAN_PK	INDEX	16	4.75
SYS	SYSAUX	WRH$_SQL_BIND_METADATA	TABLE	11	3.26
SYS	SYSAUX	WRH$_SQLTEXT	TABLE	9	2.67

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 242
Captured Segments account for 74.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	42	17.36
SYS	SYSAUX	WRH$_SQL_PLAN_PK	INDEX	16	6.61
SYS	SYSAUX	WRH$_SQL_BIND_METADATA	TABLE	11	4.55
SYS	SYSAUX	WRH$_SQLTEXT	TABLE	9	3.72
SYS	SYSAUX	SCHEDULER$_EVENT_LOG	TABLE	8	3.31

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 242
Captured Segments account for 74.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	42	17.36
SYS	SYSAUX	WRH$_SQL_PLAN_PK	INDEX	16	6.61
SYS	SYSAUX	WRH$_SQL_BIND_METADATA	TABLE	11	4.55
SYS	SYSAUX	WRH$_SQLTEXT	TABLE	9	3.72
SYS	SYSAUX	SCHEDULER$_EVENT_LOG	TABLE	8	3.31

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SYS	SYSAUX	WRH$_SEG_STAT_PK	WRH$_SEG_ST_570420430_874	INDEX PARTITION	11	2.15
SYS	SYSAUX	WRH$_LATCH	WRH$_LATCH_570420430_874	TABLE PARTITION	10	1.95
SYS	SYSAUX	WRH$_LATCH_MISSES_SUMMARY	WRH$_LATCH__570420430_874	TABLE PARTITION	10	1.95
SYS	SYSAUX	WRH$_SEG_STAT	WRH$_SEG_ST_570420430_874	TABLE PARTITION	10	1.95
SYS	SYSAUX	WRH$_SYSTEM_EVENT	WRH$_SYSTEM_570420430_874	TABLE PARTITION	10	1.95

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 172
Captured Segments account for 36.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
SYS	SYSAUX	WRH$_SEG_STAT_PK	WRH$_SEG_ST_570420430_874	INDEX PARTITION	11	6.40
SYS	SYSAUX	WRH$_LATCH_MISSES_SUMMARY	WRH$_LATCH__570420430_874	TABLE PARTITION	10	5.81
SYS	SYSAUX	WRH$_SEG_STAT	WRH$_SEG_ST_570420430_874	TABLE PARTITION	10	5.81
SYS	SYSAUX	WRH$_BG_EVENT_SUMMARY_PK		INDEX	6	3.49
SYS	SYSAUX	WRH$_ENQUEUE_STAT_PK		INDEX	5	2.91

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
OCIHOL	SYSTEM	MYEMP		TABLE	75,712	99.00
SYS	SYSTEM	INVALIDATION_REGISTRY$		TABLE	160	0.21
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	WRH$_SQLSTA_570420430_874	INDEX PARTITION	64	0.08
SYS	SYSAUX	WRI$_ADV_PARAMETERS		TABLE	48	0.06
SYS	SYSTEM	I2_CHNF$_REG_QUERIES		INDEX	32	0.04

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared
with total row lock waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
OCIHOL	SYSTEM	MYEMP		TABLE	8	66.67
SYS	SYSTEM	INVALIDATION_REGISTRY$		TABLE	4	33.33

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
OCIHOL	SYSTEM	MYEMP		TABLE	570	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	5	0.00	2	1
dc_global_oids	11	0.00	0	19
dc_histogram_defs	12	83.33	0	981
dc_objects	293	1.71	0	699
dc_profiles	20	0.00	0	1
dc_rollback_segments	28	0.00	0	28
dc_segments	11	0.00	1	563
dc_sequences	3	100.00	3	4
dc_tablespaces	135	0.00	0	4
dc_users	672	0.00	0	15
global database name	28	0.00	0	1

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	7	0.00	9	0.00	0
DBLINK	40	0.00	0		0
EDITION	20	0.00	40	2.50	1
LOCATION	11	100.00	11	100.00	0
QUEUE	0		3	0.00	0
SCHEMA	44	0.00	0		0
SQL AREA	492	0.81	4,979	0.12	1
SUBSCRIPTION	2	50.00	2	50.00	0
TABLE/PROCEDURE	120	0.83	187	9.09	3

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	16.00	16.00	16.00	16.00	STA/
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	32.00	32.00	32.00	32.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	0.00	0.00	0.00	0.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	48.00	48.00	48.00	48.00	STA/
large pool	0.00	0.00	0.00	0.00	STA/
shared pool	100.00	100.00	100.00	100.00	STA/
streams pool	0.00	0.00	0.00	0.00	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	38.94		1.39	2.01	11	11	28	28
	Freeable	4.06	0.00	0.68	0.73	2		6	6
	SQL	0.55	0.52	0.03	0.12	1	3	17	9
	PL/SQL	0.48	0.41	0.02	0.04	0	0	28	28
E	Other	39.27		1.40	2.01	11	11	28	28
	Freeable	3.94	0.00	0.66	0.71	2		6	6
	SQL	0.59	0.56	0.03	0.13	1	3	17	9
	PL/SQL	0.48	0.41	0.02	0.04	0	0	28	28

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	16,777,216
Fixed Size	1,335,276
Redo Buffers	6,660,096
Variable Size	155,189,268

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	48.00	48.00	0.00
shared	ASH buffers	4.00	4.00	0.00
shared	CCUR	4.46	4.46	0.00
shared	FileOpenBlock	3.79	3.79	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGLH0	2.17	2.22	2.50
shared	KGLHD	1.26	1.26	0.38
shared	KGLS	2.47	2.50	1.10
shared	KGLSG	3.52	3.52	0.00
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	PCUR	2.22	2.23	0.17
shared	PLMCD	2.90	2.90	0.00
shared	PX msg pool	3.14	3.14	0.00
shared	SQLA	16.34	16.28	-0.41
shared	dbktb: trace buffer	1.56	1.56	0.00
shared	event statistics per sess	1.84	1.84	0.00
shared	free memory	7.99	7.95	-0.52
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kse signatures	1.83	1.83	0.00
shared	ksunfy : SSO free list	1.78	1.78	0.00
shared	message pool freequeue	1.09	1.09	0.00
shared	obj stats allocation chun	2.21	2.21	0.00
shared	row cache	3.62	3.62	0.00
	buffer_cache	16.00	16.00	0.00
	fixed_sga	1.27	1.27	0.00
	log_buffer	6.35	6.35	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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams 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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

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

No data exists for this section of the report.

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

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

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

Parameter Name	Begin value	End value (if different)
O7_DICTIONARY_ACCESSIBILITY	FALSE
_assm_default	FALSE
_auto_bmr	disabled
_cgs_node_kill_escalation	FALSE
_controlfile_enqueue_holding_time	300
_controlfile_enqueue_holding_time_tracking_size	25
_controlfile_update_check	HIGH
_db_block_bad_write_check	TRUE
_db_block_check_for_debug	TRUE
_db_cache_process_cr_pin_max	500
_dead_process_scan_interval	10
_disable_adaptive_shrunk_aggregation	FALSE
_disable_cpu_check	TRUE
_diskmon_pipe_name	/ade/b/3050220379/oracle/work/pipe1
_enable_NUMA_support	FALSE
_enable_automatic_sqltune	FALSE
_fix_control	6670551:OFF
_force_oltp_compress	TRUE
_gc_integrity_checks	2
_ges_dd_debug	2
_high_priority_processes	VKTM
_hm_analysis_oradebug_node_dump_level	4
_hm_analysis_oradebug_sys_dump_level	10
_hm_analysis_output_disk	TRUE
_kcl_debug	TRUE
_kdz_hcc_flags	15
_kgl_kqr_cap_so_stacks	TRUE
_kill_enqueue_blocker	3
_kse_signature_entries	60000
_kse_signature_limit	7
_ksu_diag_kill_time	30
_ksuitm_addon_trccmd	/ade/b/3050220379/oracle/rdbms/test/tkin/sosd/tkinksuitm.sh
_lm_dd_interval	5
_lm_rcvr_hang_allow_time	150
_lm_validate_pbatch	TRUE
_lm_validate_resource_type	TRUE
_log_archive_security_enabled	FALSE
_optimizer_autostats_job	FALSE
_optimizer_cost_model	fixed
_oradbg_pathname	/ade/b/3050220379/oracle/rdbms/utl/oradbg
_pgactx_cap_stacks	TRUE
_qa_lrg_type	1
_realfree_heap_mode	3
_recovery_asserts	TRUE
_recovery_verify_writes	TRUE
_redo_compatibility_check	TRUE
_sga_early_trace	1
_shared_io_pool_size	0
_smm_auto_cost_enabled	FALSE
_trace_buffers	FGS:512;BGS:1024
_trace_events	10432:6:ALL, 10435:6:LMON, LMD0, 10427:6:ALL, 10429:6:ALL, 10434:6:LMD0, LMS0, LMS1, LMS2, LMS3, LMS4, LMS5, LMS6, LMS7, LMS8, LMS9, 10401:8:ALL, 10249:5:FGS, 10257:1:ALL, 10720:1:ALL:FAST, 10722:1:ALL:FAST, 10298:1:ALL
_trace_files_public	TRUE
audit_trail	DB
cell_offload_processing	FALSE
client_result_cache_size	65536
commit_point_strength	1
compatible	11.2.0.0.0
control_files	/ade/b/3050220379/oracle/dbs/t_cf1.f
db_block_checking	true
db_block_checksum	true
db_block_size	8192
db_cache_size	16777216
db_domain	regress.rdbms.dev.us.oracle.com
db_name	linuxs
diagnostic_dest	/ade/b/3050220379/oracle/log
event	10808 trace name context forever, level 7, 10809 trace name context forever, level 37, 29715 trace name context forever, level 3, 29718 trace name context forever, level 5, 10235 trace name context forever, level 2, 10828 trace name context forever, level 0, 10753 trace name context forever, level 1, 19392 trace name context forever, level 2, 19394 trace name context forever, level 8, 19396 trace name context forever, level 2, 10324 trace name context forever, level 1, 1578 trace name errorstack level 1; na
global_names	FALSE
ifile	/ade/b/3050220379/oracle/work/tkinit.ora
instance_name	linuxs
instance_number	1
java_pool_size	50331648
log_archive_trace	8191
log_checkpoints_to_alert	TRUE
nls_length_semantics	BYTE
open_cursors	300
open_links	10
open_links_per_instance	20
pga_aggregate_target	30408704
plsql_optimize_level	2
processes	100
remote_login_passwordfile	SHARED
service_names	linuxs.regress.rdbms.dev.us.oracle.com
sessions	172
shared_pool_size	104857600
transactions	21
transactions_per_rollback_segment	21
undo_management	AUTO

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	99.16	Redo NoWait %:	100.00
Buffer Hit %:	99.74	In-memory Sort %:	100.00
Library Hit %:	99.31	Soft Parse %:	99.32
Execute to Parse %:	87.53	Latch Hit %:	98.89
Parse CPU to Parse Elapsd %:	133.33	% Non-Parse CPU:	99.67