WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

15V 1635817246 15v 1 29-Jul-08 12:07 11.1.0.6.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
15V	1635817246	15v	1	29-Jul-08 12:07	11.1.0.6.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

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

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

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 355 04-Aug-08 12:04:52 59 2.4

End Snap: 356 04-Aug-08 12:06:08 59 2.4

Elapsed: 1.26 (mins)

DB Time: 21.62 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	355	04-Aug-08 12:04:52	59	2.4
End Snap:	356	04-Aug-08 12:06:08	59	2.4
Elapsed:		1.26 (mins)
DB Time:		21.62 (mins)

Report Summary

Cache Sizes

Begin End

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

Shared Pool Size: 92M 92M Log Buffer: 6,552K

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

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 17.1 0.5 0.14 0.12

DB CPU(s): 1.7 0.1 0.01 0.01

Redo size: 659,607.0 20,761.5

Logical reads: 18,266.2 574.9

Block changes: 5,224.3 164.4

Physical reads: 2.6 0.1

Physical writes: 31.6 1.0

User calls: 146.6 4.6

Parses: 19.7 0.6

Hard parses: 0.3 0.0

W/A MB processed: 126,218.1 3,972.8

Logons: 0.3 0.0

Executes: 118.8 3.7

Rollbacks: 0.0 0.0

Transactions: 31.8

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	17.1	0.5	0.14	0.12
DB CPU(s):	1.7	0.1	0.01	0.01
Redo size:	659,607.0	20,761.5
Logical reads:	18,266.2	574.9
Block changes:	5,224.3	164.4
Physical reads:	2.6	0.1
Physical writes:	31.6	1.0
User calls:	146.6	4.6
Parses:	19.7	0.6
Hard parses:	0.3	0.0
W/A MB processed:	126,218.1	3,972.8
Logons:	0.3	0.0
Executes:	118.8	3.7
Rollbacks:	0.0	0.0
Transactions:	31.8

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 98.47 Redo NoWait %: 91.00

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

Library Hit %: 99.33 Soft Parse %: 98.60

Execute to Parse %: 83.40 Latch Hit %: 99.17

Parse CPU to Parse Elapsd %: 0.03 % Non-Parse CPU: 99.84

Shared Pool Statistics

Begin End

Memory Usage %: 86.57 86.56

% SQL with executions>1: 71.95 75.76

% Memory for SQL w/exec>1: 53.99 76.54

	Begin	End
Memory Usage %:	86.57	86.56
% SQL with executions>1:	71.95	75.76
% Memory for SQL w/exec>1:	53.99	76.54

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
buffer busy waits	21,142	711	34	54.84	Concurrency
DB CPU		130		10.03
log file sync	4,003	88	22	6.81	Commit
latch: cache buffers chains	3,035	66	22	5.05	Concurrency
latch: In memory undo latch	1,297	25	20	1.95	Concurrency

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

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

6.11 10.60 83.0 10.6 0.9 6.3

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
6.11	10.60	83.0	10.6	0.9	6.3

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

89.2 95.2 0.0

Memory Statistics

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

Begin End

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

SGA use (MB): 163.6 163.6

PGA use (MB): 101.9 101.9

% Host Mem used for SGA+PGA: 13.11 13.11

	Begin	End
Host Mem (MB):	2,025.5	2,025.5
SGA use (MB):	163.6	163.6
PGA use (MB):	101.9	101.9
% Host Mem used for SGA+PGA:	13.11	13.11

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
init.ora Parameters

Time Model Statistics

Total time in database user-calls (DB Time): 1297.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
sql execute elapsed time	1,203.06	92.75
DB CPU	130.16	10.03
connection management call elapsed time	0.20	0.02
parse time elapsed	0.08	0.01
PL/SQL execution elapsed time	0.07	0.01
hard parse elapsed time	0.01	0.00
repeated bind elapsed time	0.00	0.00
DB time	1,297.14
background elapsed time	54.14
background cpu time	5.28

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	14,221
IDLE_TIME	959
IOWAIT_TIME	136
NICE_TIME	0
SYS_TIME	1,612
USER_TIME	12,594
LOAD	6	11
PHYSICAL_MEMORY_BYTES	2,123,849,728
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
04-Aug 12:04:52	6.11
04-Aug 12:06:08	10.60	93.68	82.96	10.62	0.90	6.32

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 79.5% of Total DB time 1,297.14 (s)
Total FG Wait Time: 900.45 (s) DB CPU time: 130.16 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Concurrency	25,477	0	802	31	61.85
DB CPU			130		10.03
Commit	4,003	0	88	22	6.81
Configuration	13,045	0	5	0	0.40
Application	38	0	3	75	0.22
Other	92	0	1	16	0.11
Network	11,058	0	0	0	0.02
User I/O	110	0	0	0	0.00
System I/O	456	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
buffer busy waits	21,142	0	711	34	8.77	54.84
log file sync	4,003	0	88	22	1.66	6.81
latch: cache buffers chains	3,035	0	66	22	1.26	5.05
latch: In memory undo latch	1,297	0	25	20	0.54	1.95
log file switch (checkpoint incomplete)	13,038	0	5	0	5.41	0.40
enq: RC - Result Cache: Contention	38	0	3	75	0.02	0.22
latch free	71	0	1	16	0.03	0.09
SQL*Net message to client	11,058	0	0	0	4.59	0.02
latch: session allocation	15	0	0	19	0.01	0.02
latch: undo global data	6	0	0	12	0.00	0.01
cursor: pin S wait on X	2	100	0	11	0.00	0.00
db file sequential read	110	0	0	0	0.05	0.00
control file sequential read	456	0	0	0	0.19	0.00
log file switch completion	5	0	0	2	0.00	0.00
SQL*Net message from client	11,058	0	262	24	4.59

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	1,724	0	22	13	0.72	41.36
events in waitclass Other	589	26	4	7	0.24	7.67
control file sequential read	42,156	0	1	0	17.49	2.27
control file parallel write	42	0	1	26	0.02	2.04
control file single write	6	0	0	5	0.00	0.06
latch: cache buffers chains	1	0	0	21	0.00	0.04
db file sequential read	66	0	0	0	0.03	0.01
rdbms ipc message	10,949	2	713	65	4.54
fbar timer	1	100	300	300073	0.00
smon timer	1	100	300	300009	0.00
DIAG idle wait	147	100	152	1034	0.06
Space Manager: slave idle wait	15	100	76	5042	0.01
pmon timer	29	83	75	2601	0.01
Streams AQ: qmn slave idle wait	2	0	56	28078	0.00
Streams AQ: qmn coordinator idle wait	3	67	56	18718	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
LGWR wait for redo copy	580	41.7	2.9	7.9	12.8	25.2	5.9	3.6
SQL*Net message to client	11K	99.9				.0	.0	.0
buffer busy waits	21K	38.4	2.2	5.8	4.8	3.8	8.0	37.0	.1
control file parallel write	42	31.0	11.9	2.4	2.4	4.8	21.4	26.2
control file sequential read	42K	100.0						.0
control file single write	6	83.3					16.7
cursor: pin S wait on X	2					100.0
db file scattered read	1	100.0
db file sequential read	200	99.0			1.0
direct path read	6	100.0
direct path write	6	100.0
enq: CF - contention	4	50.0		25.0				25.0
enq: RC - Result Cache: Contention	38	2.6	2.6	5.3	2.6	2.6	5.3	78.9
latch free	72	20.8	6.9	6.9	6.9	22.2	19.4	16.7
latch: In memory undo latch	1297	25.8	2.7	4.2	8.6	14.4	21.0	23.4
latch: cache buffers chains	3036	34.8	2.7	3.9	4.1	9.5	18.7	26.3
latch: redo allocation	4	50.0				50.0
latch: redo writing	2	100.0
latch: session allocation	15	6.7		6.7	20.0	13.3	40.0	13.3
latch: undo global data	6				33.3	50.0	16.7
library cache: mutex X	1	100.0
log file parallel write	1725	27.0	11.7	9.0	13.6	14.9	11.6	12.2
log file sequential read	4	100.0
log file single write	4	100.0
log file switch (checkpoint incomplete)	13K	99.4	.4	.0	.1	.1	.0	.0
log file switch completion	5	60.0	20.0		20.0
log file sync	4003	41.0	2.3	3.2	5.1	9.5	15.2	23.6
DIAG idle wait	146							77.4	22.6
SQL*Net message from client	11K	55.3	5.6	4.6	4.9	9.1	8.8	11.6	.1
Space Manager: slave idle wait	15								100.0
Streams AQ: qmn coordinator idle wait	3	33.3							66.7
Streams AQ: qmn slave idle wait	2								100.0
fbar timer	1								100.0
pmon timer	29	3.4			3.4	3.4		3.4	86.2
rdbms ipc message	10K	80.8	.6	.6	1.4	2.7	4.3	7.8	1.8
smon timer	1								100.0

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	1,297	130	1,382
15v.regress.rdbms.dev.us.oracle.com	0	0	0
SYS$BACKGROUND	0	0	4

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	104	0	25477	802	0	0	11058	0
SYS$BACKGROUND	79	0	1	0	0	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
739	40	2,400	0.31	56.97	d9pnqk1hnx7h5	stage3@stade50 (TNS V1-V3)	update employees set salary = ...
304	61	2,400	0.13	23.47	0fwmrgfjsmhmq	stage5@stade50 (TNS V1-V3)	select /+ result_cache / ...
157	26	2,400	0.07	12.07	9n2yvagk4drxd	stage5@stade50 (TNS V1-V3)	select /+ result_cache / ...
2	0	769	0.00	0.14	3c1kubcdjnppq		update sys.col_usage$ set eq...
1	0	77	0.02	0.10	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
1	0	6	0.14	0.06	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
1	0	77	0.01	0.05	g00cj285jmgsw		update sys.mon_mods$ set inser...
0	0	1	0.46	0.04	2ntzsd2w869g8	sqlplus@stade50 (TNS V1-V3)	begin :bid := DBMS_WO...
0	0	3	0.07	0.02	a73wbv1yu8x5c		select con#, type#, condlength...
0	0	0		0.01	48jvprb98hg2c	sqlplus@stade50 (TNS V1-V3)	begin :eid := DBMS_WO...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total is the CPU Time divided into the Total CPU Time times 100
Total CPU Time (s): 130
Captured SQL account for 98.3% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
61	304	2,400	0.03	46.49	23.47	0fwmrgfjsmhmq	stage5@stade50 (TNS V1-V3)	select /+ result_cache / ...
40	739	2,400	0.02	30.84	56.97	d9pnqk1hnx7h5	stage3@stade50 (TNS V1-V3)	update employees set salary = ...
26	157	2,400	0.01	19.84	12.07	9n2yvagk4drxd	stage5@stade50 (TNS V1-V3)	select /+ result_cache / ...
0	0	1	0.46	0.35	0.04	2ntzsd2w869g8	sqlplus@stade50 (TNS V1-V3)	begin :bid := DBMS_WO...
0	2	769	0.00	0.23	0.14	3c1kubcdjnppq		update sys.col_usage$ set eq...
0	0	0		0.12	0.01	48jvprb98hg2c	sqlplus@stade50 (TNS V1-V3)	begin :eid := DBMS_WO...
0	0	1	0.09	0.07	0.01	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	1	0.09	0.07	0.01	bqnn4c3gjtmgu		insert into wrh$_bg_event_summ...
0	0	271	0.00	0.07	0.01	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
0	1	77	0.00	0.04	0.05	g00cj285jmgsw		update sys.mon_mods$ set inser...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
Total Buffer Gets: 1,385,599
Captured SQL account for 99.7% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
694,010	2,400	289.17	50.09	60.51	304.40	0fwmrgfjsmhmq	stage5@stade50 (TNS V1-V3)	select /+ result_cache / ...
393,993	2,400	164.16	28.43	40.14	739.00	d9pnqk1hnx7h5	stage3@stade50 (TNS V1-V3)	update employees set salary = ...
287,550	2,400	119.81	20.75	25.82	156.58	9n2yvagk4drxd	stage5@stade50 (TNS V1-V3)	select /+ result_cache / ...
3,013	1	3,013.00	0.22	0.46	0.46	2ntzsd2w869g8	sqlplus@stade50 (TNS V1-V3)	begin :bid := DBMS_WO...
2,658	769	3.46	0.19	0.29	1.80	3c1kubcdjnppq		update sys.col_usage$ set eq...
990	0		0.07	0.16	0.16	48jvprb98hg2c	sqlplus@stade50 (TNS V1-V3)	begin :eid := DBMS_WO...
874	1	874.00	0.06	0.09	0.10	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
291	95	3.06	0.02	0.02	0.03	bsa0wjtftg3uw		select file# from file$ where ...
266	77	3.45	0.02	0.05	0.68	g00cj285jmgsw		update sys.mon_mods$ set inser...
236	1	236.00	0.02	0.02	0.02	5ax5xu96u2ztd		insert into WRH$_EVENT_HISTOGR...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 200
Captured SQL account for 67.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
71	1	71.00	35.50	0.46	0.46	2ntzsd2w869g8	sqlplus@stade50 (TNS V1-V3)	begin :bid := DBMS_WO...
36	0		18.00	0.16	0.16	48jvprb98hg2c	sqlplus@stade50 (TNS V1-V3)	begin :eid := DBMS_WO...
28	769	0.04	14.00	0.29	1.80	3c1kubcdjnppq		update sys.col_usage$ set eq...
11	1	11.00	5.50	0.01	0.01	0z1031991bd7w		insert into wrh$_sysmetric_sum...
8	1	8.00	4.00	0.02	0.04	9wncfacx0nj9h		insert into smon_scn_time (thr...
7	1	7.00	3.50	0.02	0.02	8hfqt6v8rh09t		INSERT INTO WRH$_ACTIVE_SESSIO...
7	1	7.00	3.50	0.01	0.04	chsyr0gssbuqf		select f.file#, f.block#, f....
7	1	7.00	3.50	0.01	0.08	fr31mzzknv0wh		select max(RETENTION) from SYS...
6	1	6.00	3.00	0.01	0.01	586b2udq6dbng		insert into wrh$_sysstat (sn...
6	32	0.19	3.00	0.00	0.00	96g93hntrzjtr		select /+ rule / bucket_cnt,...
6	1	6.00	3.00	0.01	0.01	f9nzhpn9854xz		insert into wrh$_seg_stat (s...
5	6	0.83	2.50	0.01	0.81	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
5	1	5.00	2.50	0.02	0.02	84qubbrsr0kfn		insert into wrh$_latch (snap...
4	5	0.80	2.00	0.00	0.00	04xtrk7uyhknh		select obj#, type#, ctime, mti...
4	271	0.01	2.00	0.09	0.10	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
4	17	0.24	2.00	0.01	0.01	db78fxqxwxt7r		select /+ rule / bucket, en...
3	1	3.00	1.50	0.02	0.02	5ax5xu96u2ztd		insert into WRH$_EVENT_HISTOGR...
3	2,400	0.00	1.50	40.14	739.00	d9pnqk1hnx7h5	stage3@stade50 (TNS V1-V3)	update employees set salary = ...
3	1	3.00	1.50	0.01	0.12	dma0vxbwh325p		update smon_scn_time set time_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 9,012
Captured SQL account for 98.0% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
2,400	128,716	53.63	0.03	0.13	0fwmrgfjsmhmq	stage5@stade50 (TNS V1-V3)	select /+ result_cache / ...
2,400	2,400	1.00	0.01	0.07	9n2yvagk4drxd	stage5@stade50 (TNS V1-V3)	select /+ result_cache / ...
2,400	192,000	80.00	0.02	0.31	d9pnqk1hnx7h5	stage3@stade50 (TNS V1-V3)	update employees set salary = ...
769	769	1.00	0.00	0.00	3c1kubcdjnppq		update sys.col_usage$ set eq...
271	0	0.00	0.00	0.00	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
95	95	1.00	0.00	0.00	bsa0wjtftg3uw		select file# from file$ where ...
77	0	0.00	0.00	0.02	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
77	77	1.00	0.00	0.01	g00cj285jmgsw		update sys.mon_mods$ set inser...
66	66	1.00	0.00	0.00	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
32	32	1.00	0.00	0.00	96g93hntrzjtr		select /+ rule / bucket_cnt,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,496
Captured SQL account for 70.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
271	769	18.11	3c1kubcdjnppq		update sys.col_usage$ set eq...
271	271	18.11	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
95	95	6.35	bsa0wjtftg3uw		select file# from file$ where ...
77	77	5.15	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
77	77	5.15	g00cj285jmgsw		update sys.mon_mods$ set inser...
20	2,400	1.34	0fwmrgfjsmhmq	stage5@stade50 (TNS V1-V3)	select /+ result_cache / ...
20	20	1.34	0h6b2sajwb74n		select privilege#, level from ...
20	20	1.34	0k8522rmdzg4k		select privilege# from sysauth...
20	20	1.34	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
20	20	1.34	209fr01svbb5s		update sys.aud$ set action#=:2...
20	20	1.34	459f3z9u4fb3u		select value$ from props$ wher...
20	20	1.34	4vs91dcv7u1p6	sample@stade50 (TNS V1-V3)	insert into sys.aud$( sessioni...
20	20	1.34	5ur69atw3vfhj		select decode(failover_method,...
20	2,400	1.34	9n2yvagk4drxd	stage5@stade50 (TNS V1-V3)	select /+ result_cache / ...
20	2,400	1.34	d9pnqk1hnx7h5	stage3@stade50 (TNS V1-V3)	update employees set salary = ...

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

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

0fwmrgfjsmhmq select /*+ result_cache */ employee_id, last_name from employees where employee_id > :EMPNO order by employee_id

0h6b2sajwb74n select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

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

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

209fr01svbb5s update sys.aud$ set action#=:2, returncode=:3, logoff$time=cast(SYS_EXTRACT_UTC(systimestamp) as date), logoff$pread=:4, logoff$lread=:5, logoff$lwrite=:6, logoff$dead=:7, sessioncpu=:8 where sessionid=:1 and entryid=1 and action#=100

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

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

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

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

48jvprb98hg2c begin :eid := DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;

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

5ax5xu96u2ztd insert into WRH$_EVENT_HISTOGRAM (snap_id, dbid, instance_number, event_id, wait_time_milli, wait_count) select :snap_id, :dbid, :instance_number, d.ksledhash, s.kslsesmaxdur, s.kslsesval from x$kslseshist s, x$ksled d where s.kslsesenum = d.indx and s.kslsesval > 0 order by d.ksledhash, s.kslsesmaxdur

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

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

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#

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

8hfqt6v8rh09t INSERT INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial# , current_obj#, current_file#, current_block#, current_row# , consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial# , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)

96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2

9n2yvagk4drxd select /*+ result_cache */ employee_id, last_name, salary from employees where employee_id = :EMPNO

9wncfacx0nj9h insert into smon_scn_time (thread, time_mp, time_dp, scn, scn_wrp, scn_bas, num_mappings, tim_scn_map) values (0, :1, :2, :3, :4, :5, :6, :7)

a73wbv1yu8x5c select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

bqnn4c3gjtmgu insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select /*+ ordered use_nl(e) */ :snap_id, :dbid, :instance_number, e.event_id, sum(e.total_waits), sum(e.total_timeouts), sum(e.time_waited_micro) from v$session bgsids, v$session_event e where bgsids.type = 'BACKGROUND' and bgsids.sid = e.sid group by e.event_id

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

chsyr0gssbuqf select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t where t.ts#=f.ts# and t.dflextpct!=0 and t.bitmapped=0

d9pnqk1hnx7h5 update employees set salary = :sal where employee_id = :id

db78fxqxwxt7r select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

dma0vxbwh325p update smon_scn_time set time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4, scn_bas=:5, num_mappings=:6, tim_scn_map=:7 where scn = (select min(scn) from smon_scn_time)

f9nzhpn9854xz 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) 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 from X$KEWRTSEGSTAT order by objn_kewrseg, objd_kewrseg

fr31mzzknv0wh select max(RETENTION) from SYS_FBA_FA

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
04xtrk7uyhknh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0fwmrgfjsmhmq	select /+ result_cache / employee_id, last_name from employees where employee_id > :EMPNO order by employee_id
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
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
209fr01svbb5s	update sys.aud$ set action#=:2, returncode=:3, logoff$time=cast(SYS_EXTRACT_UTC(systimestamp) as date), logoff$pread=:4, logoff$lread=:5, logoff$lwrite=:6, logoff$dead=:7, sessioncpu=:8 where sessionid=:1 and entryid=1 and action#=100
2ntzsd2w869g8	begin :bid := DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
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
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
48jvprb98hg2c	begin :eid := DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;
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
5ax5xu96u2ztd	insert into WRH$_EVENT_HISTOGRAM (snap_id, dbid, instance_number, event_id, wait_time_milli, wait_count) select :snap_id, :dbid, :instance_number, d.ksledhash, s.kslsesmaxdur, s.kslsesval from x$kslseshist s, x$ksled d where s.kslsesenum = d.indx and s.kslsesval > 0 order by d.ksledhash, s.kslsesmaxdur
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
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
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#
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
8hfqt6v8rh09t	INSERT INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial# , current_obj#, current_file#, current_block#, current_row# , consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial# , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9n2yvagk4drxd	select /+ result_cache / employee_id, last_name, salary from employees where employee_id = :EMPNO
9wncfacx0nj9h	insert into smon_scn_time (thread, time_mp, time_dp, scn, scn_wrp, scn_bas, num_mappings, tim_scn_map) values (0, :1, :2, :3, :4, :5, :6, :7)
a73wbv1yu8x5c	select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
bqnn4c3gjtmgu	insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select /+ ordered use_nl(e) / :snap_id, :dbid, :instance_number, e.event_id, sum(e.total_waits), sum(e.total_timeouts), sum(e.time_waited_micro) from v$session bgsids, v$session_event e where bgsids.type = 'BACKGROUND' and bgsids.sid = e.sid group by e.event_id
bsa0wjtftg3uw	select file# from file$ where ts#=:1
chsyr0gssbuqf	select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t where t.ts#=f.ts# and t.dflextpct!=0 and t.bitmapped=0
d9pnqk1hnx7h5	update employees set salary = :sal where employee_id = :id
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dma0vxbwh325p	update smon_scn_time set time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4, scn_bas=:5, num_mappings=:6, tim_scn_map=:7 where scn = (select min(scn) from smon_scn_time)
f9nzhpn9854xz	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) 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 from X$KEWRTSEGSTAT order by objn_kewrseg, objd_kewrseg
fr31mzzknv0wh	select max(RETENTION) from SYS_FBA_FA
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO 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
CCursor + sql area evicted	4	0.05	0.00
CPU used by this session	12,973	171.02	5.38
CPU used when call started	12,881	169.81	5.34
CR blocks created	3,750	49.44	1.56
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	129,731	1,710.23	53.83
DBWR checkpoint buffers written	402	5.30	0.17
DBWR checkpoints	2	0.03	0.00
DBWR thread checkpoint buffers written	402	5.30	0.17
DBWR transaction table writes	40	0.53	0.02
DBWR undo block writes	1,912	25.21	0.79
Effective IO time	0	0.00	0.00
HSC Heap Segment Block Changes	193,095	2,545.55	80.12
Heap Segment Array Inserts	80	1.05	0.03
Heap Segment Array Updates	6	0.08	0.00
IMU CR rollbacks	5,924	78.10	2.46
IMU Flushes	1,257	16.57	0.52
IMU Redo allocation size	14,280,872	188,262.92	5,925.67
IMU commits	270	3.56	0.11
IMU contention	1,208	15.92	0.50
IMU pool not allocated	888	11.71	0.37
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	20,775,648	273,882.73	8,620.60
IMU- failed to get a private strand	322	4.24	0.13
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
RowCR - row contention	547	7.21	0.23
RowCR attempts	2,117	27.91	0.88
RowCR hits	1,307	17.23	0.54
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	11,058	145.78	4.59
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	14,786	194.92	6.14
application wait time	285	3.76	0.12
background checkpoints completed	2	0.03	0.00
background checkpoints started	2	0.03	0.00
background timeouts	285	3.76	0.12
branch node splits	0	0.00	0.00
buffer is not pinned count	42,425	559.28	17.60
buffer is pinned count	244,439	3,222.41	101.43
bytes received via SQL*Net from client	2,506,607	33,044.28	1,040.09
bytes sent via SQL*Net to client	3,158,898	41,643.35	1,310.75
calls to get snapshot scn: kcmgss	201,802	2,660.33	83.74
calls to kcmgas	8,542	112.61	3.54
calls to kcmgcs	39	0.51	0.02
calls to kcmgrs	418,838	5,521.49	173.79
change write time	1,910	25.18	0.79
cleanout - number of ktugct calls	2,708	35.70	1.12
cleanouts and rollbacks - consistent read gets	2,575	33.95	1.07
cleanouts only - consistent read gets	6	0.08	0.00
cluster key scan block gets	55	0.73	0.02
cluster key scans	52	0.69	0.02
commit batch/immediate performed	1	0.01	0.00
commit batch/immediate requested	1	0.01	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	6	0.08	0.00
commit cleanout failures: cannot pin	126	1.66	0.05
commit cleanouts	3,302	43.53	1.37
commit cleanouts successfully completed	3,170	41.79	1.32
commit immediate performed	1	0.01	0.00
commit immediate requested	1	0.01	0.00
commit txn count during cleanout	592	7.80	0.25
concurrency wait time	80,227	1,057.62	33.29
consistent changes	955,383	12,594.69	396.42
consistent gets	1,178,654	15,538.05	489.07
consistent gets - examination	973,144	12,828.83	403.79
consistent gets direct	0	0.00	0.00
consistent gets from cache	1,178,654	15,538.05	489.07
consistent gets from cache (fastpath)	197,702	2,606.28	82.03
cursor authentications	14	0.18	0.01
data blocks consistent reads - undo records applied	953,671	12,572.12	395.71
db block changes	396,291	5,224.25	164.44
db block gets	206,945	2,728.13	85.87
db block gets direct	0	0.00	0.00
db block gets from cache	206,945	2,728.13	85.87
db block gets from cache (fastpath)	792	10.44	0.33
deferred (CURRENT) block cleanout applications	647	8.53	0.27
dirty buffers inspected	1,621	21.37	0.67
enqueue conversions	21	0.28	0.01
enqueue releases	39,435	519.87	16.36
enqueue requests	39,530	521.12	16.40
enqueue timeouts	95	1.25	0.04
enqueue waits	42	0.55	0.02
exchange deadlocks	0	0.00	0.00
execute count	9,012	118.80	3.74
free buffer inspected	2,790	36.78	1.16
free buffer requested	6,804	89.70	2.82
heap block compress	43,201	569.51	17.93
hot buffers moved to head of LRU	720	9.49	0.30
immediate (CR) block cleanout applications	2,581	34.02	1.07
immediate (CURRENT) block cleanout applications	45	0.59	0.02
index crx upgrade (found)	37	0.49	0.02
index crx upgrade (positioned)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fetch by key	195,699	2,579.88	81.20
index scans kdiixs1	3,300	43.50	1.37
leaf node 90-10 splits	14	0.18	0.01
leaf node splits	17	0.22	0.01
lob reads	0	0.00	0.00
lob writes	1	0.01	0.00
lob writes unaligned	1	0.01	0.00
logons cumulative	20	0.26	0.01
messages received	13,058	172.14	5.42
messages sent	13,058	172.14	5.42
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	197,140	2,598.87	81.80
opened cursors cumulative	1,678	22.12	0.70
parse count (failures)	0	0.00	0.00
parse count (hard)	21	0.28	0.01
parse count (total)	1,496	19.72	0.62
parse time cpu	21	0.28	0.01
parse time elapsed	174	2.29	0.07
physical read IO requests	199	2.62	0.08
physical read bytes	1,638,400	21,598.82	679.83
physical read total IO requests	42,818	564.46	17.77
physical read total bytes	699,820,032	9,225,638.47	290,381.76
physical read total multi block requests	0	0.00	0.00
physical reads	200	2.64	0.08
physical reads cache	194	2.56	0.08
physical reads cache prefetch	1	0.01	0.00
physical reads direct	6	0.08	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	1,686	22.23	0.70
physical write bytes	19,660,800	259,185.83	8,158.01
physical write total IO requests	3,692	48.67	1.53
physical write total bytes	73,523,712	969,253.74	30,507.76
physical write total multi block requests	37	0.49	0.02
physical writes	2,400	31.64	1.00
physical writes direct	6	0.08	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	2,394	31.56	0.99
physical writes non checkpoint	2,167	28.57	0.90
pinned buffers inspected	74	0.98	0.03
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	10,815	142.57	4.49
recursive cpu usage	125	1.65	0.05
redo blocks checksummed by FG (exclusive)	26,029	343.14	10.80
redo blocks read for recovery	0	0.00	0.00
redo blocks read total	0	0.00	0.00
redo blocks written	102,317	1,348.83	42.46
redo blocks written for direct writes	0	0.00	0.00
redo buffer allocation retries	9	0.12	0.00
redo entries	144,985	1,911.32	60.16
redo entries for lost write detection	184	2.43	0.08
redo log space requests	13,048	172.01	5.41
redo log space wait time	526	6.93	0.22
redo ordering marks	1,913	25.22	0.79
redo size	50,035,152	659,607.04	20,761.47
redo size for lost write detection	9,596	126.50	3.98
redo subscn max counts	2,165	28.54	0.90
redo synch time	8,866	116.88	3.68
redo synch writes	2,441	32.18	1.01
redo wastage	479,688	6,323.67	199.04
redo write time	2,254	29.71	0.94
redo writer latching time	408	5.38	0.17
redo writes	1,725	22.74	0.72
rollback changes - undo records applied	2	0.03	0.00
rollbacks only - consistent read gets	1,487	19.60	0.62
rows fetched via callback	2,744	36.17	1.14
session connect time	0	0.00	0.00
session cursor cache hits	601	7.92	0.25
session logical reads	1,385,599	18,266.18	574.94
shared hash latch upgrades - no wait	5,634	74.27	2.34
shared hash latch upgrades - wait	39	0.51	0.02
sorts (disk)	0	0.00	0.00
sorts (memory)	149	1.96	0.06
sorts (rows)	6,236	82.21	2.59
sql area evicted	7	0.09	0.00
sql area purged	0	0.00	0.00
summed dirty queue length	2,189	28.86	0.91
switch current to new buffer	490	6.46	0.20
table fetch by rowid	132,347	1,744.71	54.92
table fetch continued row	0	0.00	0.00
table scan blocks gotten	294	3.88	0.12
table scan rows gotten	17,758	234.10	7.37
table scans (long tables)	0	0.00	0.00
table scans (short tables)	151	1.99	0.06
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	1	0.01	0.00
undo change vector size	18,247,088	240,549.04	7,571.41
user I/O wait time	2	0.03	0.00
user calls	11,119	146.58	4.61
user commits	2,410	31.77	1.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	63	0.83	0.03
write clones created in background	0	0.00	0.00
write clones created in foreground	13	0.17	0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session pga memory max	624,298,380	624,298,380
session cursor cache count	740,637	740,797
session uga memory	1,551,197,382,084	1,551,198,181,364
opened cursors current	142	142
logons current	59	59
session uga memory max	6,299,485,948	6,305,522,028
session pga memory	510,314,248	511,100,680

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)	2	94.92

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
UD1	6	0	0.00	1.00	1,292	17	2,077	16.58
SYSAUX	104	1	0.10	1.00	370	5	0	0.00
SYSTEM	64	1	0.00	1.02	24	0	19,065	35.49

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/jacao_15v/oracle/dbs/t_ax1.f	104	1	0.10	1.00	370	5	0	0.00
SYSTEM	/ade/jacao_15v/oracle/dbs/t_db1.f	64	1	0.00	1.02	24	0	19,065	35.49
UD1	/ade/jacao_15v/oracle/dbs/t_undo1.f	6	0	0.00	1.00	1,292	17	2,077	16.58

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	1,992	100	1,385,491	183	2,394	0	0	21,142

Advisory Statistics

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

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	18	471	36831	46080	46080	155171
E	0	18	675	45673	46080	46080	169122

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	4	0.25	498	1.78	704,492
D	8	0.50	996	1.29	512,865
D	12	0.75	1,494	1.14	453,341
D	16	1.00	1,992	1.00	396,464
D	20	1.25	2,490	0.95	376,330
D	24	1.50	2,988	0.92	365,991
D	28	1.75	3,486	0.90	357,213
D	32	2.00	3,984	0.87	343,851

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	29	4	101.92	0.00	0.00	0.00	0.00	5,939
E	29	4	101.92	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	M-Pass Execs
2K	4K	51	51	0	0
512K	1024K	12	12	0	0

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	2,787.11	195.85	93.00	22	135,703
22	0.75	2,787.11	195.85	93.00	22	135,703
29	1.00	2,787.11	43.65	98.00	22	128,779
35	1.20	2,787.11	43.65	98.00	21	128,779
41	1.40	2,787.11	43.65	98.00	21	128,779
46	1.60	2,787.11	43.65	98.00	18	128,779
52	1.80	2,787.11	43.65	98.00	18	128,779
58	2.00	2,787.11	43.65	98.00	18	128,779
87	3.00	2,787.11	38.51	99.00	0	128,545
116	4.00	2,787.11	38.51	99.00	0	128,545
174	6.00	2,787.11	38.51	99.00	0	128,545
232	8.00	2,787.11	0.00	100.00	0	126,793

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)
56	0.61	3	217	49,171	0.40	78,307	25.80	192
68	0.74	15	1,151	65,944	0.53	61,534	20.27	911
80	0.87	27	2,140	118,152	0.95	9,326	3.07	1,360
92	1.00	39	2,733	124,443	1.00	3,035	1.00	1,389
104	1.13	51	3,693	124,959	1.00	2,519	0.83	1,392
116	1.26	63	5,187	126,349	1.02	1,129	0.37	1,397
128	1.39	75	6,546	127,824	1.03	1	0.00	1,400
140	1.52	87	7,454	132,077	1.06	1	0.00	1,402
152	1.65	99	8,180	132,096	1.06	1	0.00	1,404
164	1.78	111	9,392	132,262	1.06	1	0.00	1,405
176	1.91	123	10,281	132,725	1.07	1	0.00	1,407
188	2.04	135	11,324	132,785	1.07	1	0.00	1,409

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	19,065	677	35
undo block	2,033	34	17
undo header	39	1	13
file header block	5	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)
RC-Result Cache: Enqueue (Result Cache: Contention)	11,836	11,741	95	38	3	75.79
CF-Controlfile Transaction	21,086	21,086	0	4	0	32.50

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
ASM db client latch	50	0.00		0	0
ASM map operation hash table	1	0.00		0	0
AWR Alerted Metric Element list	439	0.00		0	0
Change Notification Hash table latch	25	0.00		0	0
Consistent RBA	1,728	0.00		0	0
DML lock allocation	5,830	0.00		0	0
Event Group Locks	21	0.00		0	0
FOB s.o list latch	44	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	76,466	2.05	1.10	25	1,859	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	450	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
KFR redo allocation latch	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
KMG MMAN ready and startup request latch	25	0.00		0	0
KTF sga latch	1	0.00		0	25	0.00
Locator state objects pool parent latch	1	0.00		0	0
MQL Tracking Latch	0			0	1	0.00
Memory Management Latch	1	0.00		0	25	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
MinActiveScn Latch	1,113	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	65	0.00		0	0
OS process: request allocation	40	0.00		0	0
PL/SQL warning settings	23	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	5	0.00		0	0
Result Cache: Latch	24,950	0.18	0.27	0	0
Result Cache: SO Latch	40	5.00	1.00	0	0
SGA IO buffer pool latch	350	0.00		0	350	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	34	0.00		0	24	0.00
SQL memory manager workarea list latch	3,953	0.00		0	0
Shared B-Tree	3	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
Write State Object Pool Parent Latch	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	11,351	0.00		0	0
active service list	258	0.00		0	27	0.00
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	74	0.00		0	0
cache buffers chains	4,316,725	0.97	0.08	66	5,064	2.09
cache buffers lru chain	12,136	0.01	0.00	0	4,238	0.02
cache table scan latch	1	0.00		0	1	0.00
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	41	0.00		0	0
channel operations parent latch	464	0.00		0	0
checkpoint queue latch	7,394	0.00		0	2,541	0.00
client/application info	141	0.00		0	0
commit callback allocation	1	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	5	0.00		0	0
cv apply list lock	1	0.00		0	0
cv free list lock	1	0.00		0	0
deferred cleanup latch	5	0.00		0	0
dml lock allocation	5	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	41	0.00		0	0
enqueue hash chains	79,017	0.01	0.00	0	0
enqueues	67,383	0.10	0.87	1	0
fifth spare latch	1	0.00		0	0
file cache latch	94	0.00		0	0
flashback archiver latch	1	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	274	0.00		0	51	0.00
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	1	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	402	0.00		0	0
kokc descriptor allocation latch	2	0.00		0	0
ksfv messages	1	0.00		0	0
kss move lock	1	0.00		0	0
ksuosstats global area	8	0.00		0	0
ksv allocation latch	5	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	2	0.00		0	0
kwqbsn:qsga	2	0.00		0	0
lgwr LWN SCN	1,724	0.00		0	0
library cache load lock	30	0.00		0	0
list of block allocation	54	0.00		0	0
loader state object freelist	24	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	1	0.00		0	0
messages	37,831	1.02	0.00	0	0
mostly latch-free SCN	1,733	0.00		0	0
msg queue latch	1	0.00		0	0
multiblock read objects	2	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	5	0.00		0	0
object queue header heap	847	0.00		0	35	0.00
object queue header operation	14,778	0.01	0.00	0	0
object stats modification	1	0.00		0	0
parallel query alloc buffer	13	0.00		0	0
parallel query stats	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
pesom_heap_alloc	1	0.00		0	0
post/wait queue	21,575	0.00		0	17,046	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	8	12.50	1.00	0	0
recovery domain hash list	1	0.00		0	0
redo allocation	8,932	0.13	0.50	0	144,899	0.09
redo copy	1	0.00		0	144,948	0.48
redo writing	19,283	0.03	0.33	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	4,979	0.02	0.00	0	5	0.00
second spare latch	1	0.00		0	0
sequence cache	69	0.00		0	0
session allocation	9,442	0.21	1.20	0	0
session idle bit	24,685	0.01	0.00	0	0
session queue latch	1	0.00		0	0
session switching	6	0.00		0	0
session timer	27	0.00		0	0
shared pool	4,639	0.00		0	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	2,771	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	244,916	0.00		0	0
simulator lru latch	244,457	0.06	0.09	0	153	0.00
sort extent pool	6	0.00		0	0
space background task latch	55	0.00		0	50	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
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
threshold alerts latch	1	0.00		0	0
transaction allocation	47	0.00		0	0
transaction branch allocation	27	0.00		0	0
undo global data	49,518	0.02	0.83	0	0
user lock	80	0.00		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	4,316,725	41,858	3,396	38,939
In memory undo latch	76,466	1,568	1,721	273
simulator lru latch	244,457	151	14	139
enqueues	67,383	69	60	22
Result Cache: Latch	24,950	44	12	34
session allocation	9,442	20	24	5
redo allocation	8,932	12	6	8
undo global data	49,518	12	10	6
redo writing	19,283	6	2	4
Result Cache: SO Latch	40	2	2	0
qmn task queue latch	8	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	1,069	474
In memory undo latch	ktiFlush: child	561	709
In memory undo latch	kticmt: child	94	1
Result Cache: Latch	Result Cache: Serialization12	9	2
Result Cache: Latch	Result Cache: Serialization06	2	0
Result Cache: Latch	Result Cache: Serialization03	1	2
Result Cache: SO Latch	qesrcSO_Get	2	2
cache buffers chains	kcbgtcr: fast path	979	212
cache buffers chains	kcbgtcr: fast path (cr pin)	922	181
cache buffers chains	kcbchg1: kslbegin: bufs not pinned	681	602
cache buffers chains	kcbchg1: kslbegin: call CR func	390	1,598
cache buffers chains	kcbzwb	328	312
cache buffers chains	kcbgcur_2	156	299
cache buffers chains	kcb_post_apply: kcbhq62	63	17
cache buffers chains	kcb_pre_apply: kcbhq61	12	76
cache buffers chains	kcbnlc	11	2
cache buffers chains	kcbrls_2	11	68
cache buffers chains	kcbso1: set no access	7	29
cache buffers chains	kcbzpbuf	7	4
cache buffers chains	kcbcxx	1	3
cache buffers chains	kcbgtcr_9	1	28
enqueues	ksqdel	39	21
enqueues	ksqgel: create enqueue	21	39
qmn task queue latch	kwqmnmvtsks: delay to ready list	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	6	0
redo writing	kcrfws: in loop	2	2
session allocation	ksucri	10	19
session allocation	ksuprc	10	0
session allocation	ksuxds: not user session	4	5
simulator lru latch	kcbs_simulate: simulate set	14	14
undo global data	ktudba: KSLBEGIN	10	10

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 1,385,599
Captured Segments account for 29.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
HR	SYSTEM	EMPLOYEES	TABLE	203,536	14.69
HR	SYSTEM	EMP_EMP_ID_PK	INDEX	200,528	14.47
SYS	SYSTEM	I_COL_USAGE$	INDEX	1,536	0.11
SYS	SYSTEM	COL_USAGE$	TABLE	768	0.06
SYS	SYSAUX	WRH$_SEG_STAT_OBJ	TABLE	448	0.03

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 200
Captured Segments account for 52.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	28	14.00
SYS	SYSTEM	COL_USAGE$	TABLE	15	7.50
SYS	SYSAUX	WRH$_SQLTEXT	TABLE	11	5.50
SYS	SYSTEM	I_COL_USAGE$	INDEX	7	3.50
SYS	SYSAUX	WRH$_SYSMETRIC_SUMMARY	TABLE	6	3.00

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
HR	SYSTEM	EMPLOYEES		TABLE	19,065	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_database_links	40	0.00	0	1
dc_free_extents	2	100.00	0	2
dc_global_oids	4	0.00	0	10
dc_histogram_data	19	89.47	0	356
dc_histogram_defs	68	47.06	0	935
dc_objects	679	0.88	0	610
dc_profiles	20	0.00	0	1
dc_rollback_segments	22	0.00	0	23
dc_segments	127	1.57	6	179
dc_tablespaces	304	0.00	0	4
dc_users	465	0.00	0	13
global database name	70	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
BODY	7	0.00	10	0.00	0	0
CLUSTER	11	9.09	7	14.29	0	0
SQL AREA	1,017	1.57	9,996	0.55	10	1
TABLE/PROCEDURE	413	0.00	480	2.92	7	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	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	92.00	92.00	92.00	92.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	91.56		1.53	2.79	22	22	60	60
	Freeable	8.75	0.00	0.88	0.60	2		10	10
	SQL	1.47	0.80	0.03	0.05	0	4	50	48
	PL/SQL	0.16	0.04	0.00	0.00	0	0	60	59
E	Other	92.26		1.54	2.80	22	22	60	60
	Freeable	8.06	0.00	0.81	0.42	2		10	10
	SQL	1.47	0.80	0.03	0.05	0	4	50	48
	PL/SQL	0.16	0.04	0.00	0.00	0	0	60	59

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,298,612
Redo Buffers	6,709,248
Variable Size	146,804,556

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	CCursor	3.71	3.71	-0.19
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGL buckets	3.00	3.00	0.00
shared	KGL handle	1.86	1.81	-2.37
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	PCursor	3.42	3.38	-1.17
shared	PL/SQL MPCODE	1.75	1.75	0.00
shared	event statistics per sess	1.06	1.06	0.00
shared	free memory	12.35	12.36	0.10
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kglsim object batch	1.21	1.21	0.00
shared	kse signatures	1.83	1.83	0.00
shared	message pool freequeue	1.11	1.11	0.00
shared	obj stats allocation chun	1.90	1.90	0.00
shared	returns from metrics req	0.95	0.95	0.00
shared	row cache	3.61	3.61	0.00
shared	sessions	1.14	1.14	0.00
shared	sql area	16.09	16.20	0.73
	buffer_cache	16.00	16.00	0.00
	fixed_sga	1.24	1.24	0.00
	log_buffer	6.40	6.40	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

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

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
processes	61	83	100	100
sessions	68	110	120	120

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
_cgs_reconfig_timeout	240
_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
_enable_automatic_sqltune	FALSE
_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
_imr_disk_voting_interval	20
_kcl_debug	TRUE
_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/jacao_15v/oracle/rdbms/test/tkin/sosd/tkinksuitm.sh
_lm_dd_interval	5
_lm_validate_resource_type	TRUE
_log_archive_security_enabled	FALSE
_optimizer_autostats_job	FALSE
_optimizer_cost_model	fixed
_oradbg_pathname	/ade/jacao_15v/oracle/rdbms/utl/oradbg
_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
client_result_cache_size	10485760
commit_point_strength	1
compatible	10.0.0.0
control_files	/ade/jacao_15v/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	15v
diagnostic_dest	/ade/jacao_15v/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/jacao_15v/oracle/work/tkinit.ora
instance_name	15v
instance_number	1
java_pool_size	50331648
log_archive_trace	8191
log_checkpoints_to_alert	TRUE
nls_length_semantics	BYTE
open_cursors	52
open_links	10
open_links_per_instance	20
pga_aggregate_target	30408704
plsql_native_library_dir	/ade/jacao_15v/oracle/dbs/plsqlnld1
plsql_optimize_level	2
processes	100
remote_login_passwordfile	SHARED
service_names	15v.regress.rdbms.dev.us.oracle.com
sessions	120
shared_pool_size	96468992
transactions	21
transactions_per_rollback_segment	21
undo_management	AUTO

End of Report

Buffer Nowait %:	98.47	Redo NoWait %:	91.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	99.33	Soft Parse %:	98.60
Execute to Parse %:	83.40	Latch Hit %:	99.17
Parse CPU to Parse Elapsd %:	0.03	% Non-Parse CPU:	99.84