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: 351 04-Aug-08 11:59:17 59 2.4

End Snap: 352 04-Aug-08 12:02:05 59 2.4

Elapsed: 2.79 (mins)

DB Time: 37.90 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	351	04-Aug-08 11:59:17	59	2.4
End Snap:	352	04-Aug-08 12:02:05	59	2.4
Elapsed:		2.79 (mins)
DB Time:		37.90 (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): 13.6 0.0 0.01 0.00

DB CPU(s): 1.4 0.0 0.00 0.00

Redo size: 560,947.9 488.8

Logical reads: 6,898.0 6.0

Block changes: 4,613.4 4.0

Physical reads: 3.2 0.0

Physical writes: 23.7 0.0

User calls: 2,745.0 2.4

Parses: 1,180.2 1.0

Hard parses: 0.3 0.0

W/A MB processed: 61,514.2 53.6

Logons: 0.1 0.0

Executes: 1,182.7 1.0

Rollbacks: 0.0 0.0

Transactions: 1,147.7

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	13.6	0.0	0.01	0.00
DB CPU(s):	1.4	0.0	0.00	0.00
Redo size:	560,947.9	488.8
Logical reads:	6,898.0	6.0
Block changes:	4,613.4	4.0
Physical reads:	3.2	0.0
Physical writes:	23.7	0.0
User calls:	2,745.0	2.4
Parses:	1,180.2	1.0
Hard parses:	0.3	0.0
W/A MB processed:	61,514.2	53.6
Logons:	0.1	0.0
Executes:	1,182.7	1.0
Rollbacks:	0.0	0.0
Transactions:	1,147.7

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 94.77 Redo NoWait %: 79.21

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

Library Hit %: 100.14 Soft Parse %: 99.98

Execute to Parse %: 0.22 Latch Hit %: 99.17

Parse CPU to Parse Elapsd %: 0.00 % Non-Parse CPU: 98.03

Shared Pool Statistics

Begin End

Memory Usage %: 93.93 93.65

% SQL with executions>1: 80.07 87.18

% Memory for SQL w/exec>1: 70.18 83.37

	Begin	End
Memory Usage %:	93.93	93.65
% SQL with executions>1:	80.07	87.18
% Memory for SQL w/exec>1:	70.18	83.37

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
log file sync	225,194	1,594	7	70.11	Commit
buffer busy waits	60,380	326	5	14.34	Concurrency
DB CPU		237		10.42
latch: In memory undo latch	27,687	72	3	3.16	Concurrency
log file switch (checkpoint incomplete)	52,917	19	0	0.86	Configuration

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

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

0.59 10.75 63.7 25.7 3.6 10.5

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.59	10.75	63.7	25.7	3.6	10.5

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

76.7 85.8 0.0

Memory Statistics

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

Begin End

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

SGA use (MB): 163.6 163.6

PGA use (MB): 105.5 107.0

% Host Mem used for SGA+PGA: 13.29 13.29

	Begin	End
Host Mem (MB):	2,025.5	2,025.5
SGA use (MB):	163.6	163.6
PGA use (MB):	105.5	107.0
% Host Mem used for SGA+PGA:	13.29	13.29

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): 2274s
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	533.20	23.45
DB CPU	236.89	10.42
parse time elapsed	11.24	0.49
connection management call elapsed time	0.31	0.01
hard parse elapsed time	0.29	0.01
hard parse (sharing criteria) elapsed time	0.08	0.00
PL/SQL execution elapsed time	0.08	0.00
hard parse (bind mismatch) elapsed time	0.07	0.00
repeated bind elapsed time	0.00	0.00
DB time	2,274.01
background elapsed time	170.39
background cpu time	20.03

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	29,958
IDLE_TIME	3,521
IOWAIT_TIME	1,198
NICE_TIME	1
SYS_TIME	8,589
USER_TIME	21,312
LOAD	1	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 11:59:17	0.59
04-Aug 12:02:05	10.75	89.48	63.66	25.65	3.58	10.52

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 99.9% of Total DB time 2,274.01 (s)
Total FG Wait Time: 2,034.29 (s) DB CPU time: 236.89 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Commit	225,194	0	1,594	7	70.11
Concurrency	90,691	1	405	4	17.82
DB CPU			237		10.42
Configuration	52,949	0	20	0	0.86
Other	3,266	6	13	4	0.59
Network	262,384	0	2	0	0.08
User I/O	342	0	0	0	0.00
System I/O	460	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
log file sync	225,194	0	1,594	7	1.17	70.11
buffer busy waits	60,380	0	326	5	0.31	14.34
latch: In memory undo latch	27,687	0	72	3	0.14	3.16
log file switch (checkpoint incomplete)	52,917	0	19	0	0.28	0.86
latch: session allocation	1,313	0	7	6	0.01	0.33
latch: cache buffers chains	2,249	0	5	2	0.01	0.23
latch free	1,276	0	4	3	0.01	0.17
SQL*Net message to client	262,384	0	2	0	1.37	0.08
cursor: pin S wait on X	156	99	2	12	0.00	0.08
latch: enqueue hash chains	436	0	1	3	0.00	0.07
cursor: pin S	203	100	0	2	0.00	0.02
cursor: mutex X	219	100	0	0	0.00	0.00
log file switch completion	30	0	0	2	0.00	0.00
latch: undo global data	27	0	0	2	0.00	0.00
latch: redo allocation	7	0	0	8	0.00	0.00
db file sequential read	337	0	0	0	0.00	0.00
control file sequential read	460	0	0	0	0.00	0.00
latch: cache buffers lru chain	2	0	0	5	0.00	0.00
SQL*Net message from client	262,384	0	1,192	5	1.37

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	19,239	0	56	3	0.10	33.05
control file sequential read	85,189	0	2	0	0.44	1.37
events in waitclass Other	1,114	0	1	1	0.01	0.60
control file parallel write	91	0	1	8	0.00	0.45
os thread startup	1	0	1	561	0.00	0.33
control file single write	12	0	0	2	0.00	0.01
log file single write	8	0	0	1	0.00	0.00
buffer busy waits	2	0	0	1	0.00	0.00
latch: In memory undo latch	1	0	0	1	0.00	0.00
rdbms ipc message	10,516	6	1,507	143	0.05
DIAG idle wait	328	100	335	1020	0.00
fbar timer	2	50	300	150001	0.00
Space Manager: slave idle wait	34	100	171	5016	0.00
Streams AQ: qmn coordinator idle wait	11	55	168	15285	0.00
Streams AQ: qmn slave idle wait	6	0	168	28018	0.00
pmon timer	124	43	166	1343	0.00
smon timer	4	0	75	18855	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	1076	83.5	6.2	5.6	3.8	.7		.2
SQL*Net message to client	262K	100.0	.0	.0	.0	.0	.0
buffer busy waits	60K	29.1	14.8	27.4	22.4	5.8	.2	.3	.0
control file parallel write	91	44.0	8.8	4.4	19.8	15.4	3.3	4.4
control file sequential read	85K	100.0	.0					.0
control file single write	12	83.3			8.3	8.3
cursor: mutex X	219	92.2	1.4	1.4	5.0
cursor: pin S	203	59.6	7.4	13.3	12.8	4.4	2.5
cursor: pin S wait on X	156	.6				96.8	2.6
db file scattered read	4	100.0
db file sequential read	516	99.2				.4	.4
direct path read	12	100.0
direct path write	13	100.0
enq: CF - contention	7	42.9		42.9				14.3
latch free	1279	14.0	23.1	37.8	22.6	2.5	.1
latch: In memory undo latch	27K	39.9	15.7	22.9	16.7	4.3	.3	.1
latch: cache buffers chains	2249	41.8	15.0	21.9	17.6	3.6	.2
latch: cache buffers lru chain	3			33.3	66.7
latch: enqueue hash chains	437	15.3	20.6	32.0	26.8	5.3
latch: messages	2	100.0
latch: redo allocation	21	38.1	19.0	9.5	9.5	23.8
latch: redo writing	2	100.0
latch: session allocation	1313	7.5	10.8	22.0	35.7	22.8	1.2
latch: undo global data	27	18.5	40.7	29.6	7.4	3.7
log file parallel write	19K	45.1	20.7	13.8	10.5	8.5	1.1	.2
log file sequential read	8	100.0
log file single write	8	87.5			12.5
log file switch (checkpoint incomplete)	52K	99.5	.2	.1	.1	.0	.0	.0
log file switch completion	30	20.0	46.7	26.7	3.3	3.3
log file sync	225K	14.9	.8	13.1	39.9	27.6	3.0	.7
os thread startup	1							100.0
rdbms ipc reply	13	100.0
DIAG idle wait	328							91.2	8.8
SQL*Net message from client	262K	28.8	7.1	21.3	36.1	6.5	.1	.1	.0
Space Manager: slave idle wait	34								100.0
Streams AQ: qmn coordinator idle wait	11	9.1	9.1		9.1		18.2		54.5
Streams AQ: qmn slave idle wait	6								100.0
fbar timer	2	50.0							50.0
pmon timer	124	54.0						1.6	44.4
rdbms ipc message	10K	49.1	5.1	12.0	9.5	17.1	1.1	2.1	4.1
smon timer	4	25.0							75.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	2,274	237	1,151
15v.regress.rdbms.dev.us.oracle.com	0	0	0
SYS$BACKGROUND	0	0	3

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	347	0	90691	405	0	0	262384	2
SYS$BACKGROUND	191	0	4	1	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): 2,274
Captured SQL account for 23.5% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
517	96	191,994	0.00	22.72	d9pnqk1hnx7h5	stage3@stade50 (TNS V1-V3)	update employees set salary = ...
12	7	2,400	0.01	0.54	cyuknq4uv9gn6	stage3@stade50 (TNS V1-V3)	select employee_id, last_name...
2	1	2,400	0.00	0.11	au7v19t361bn7	stage3@stade50 (TNS V1-V3)	select employee_id, last_name...
1	0	1	0.88	0.04	9ctt1scmwbmbg		begin dbsnmp.bsln_internal.mai...
1	0	1	0.51	0.02	2ntzsd2w869g8	sqlplus@stade50 (TNS V1-V3)	begin :bid := DBMS_WO...
0	0	1	0.42	0.02	7ujay4u33g337		SELECT BLDS.BSLN_GUID , BLDS.M...
0	0	1	0.18	0.01	2cn0kc8u4b81w		select OBJOID, CLSOID, RUNT...
0	0	4	0.03	0.00	2m7dvzfc7t6jh		SELECT OBJOID, CLSOID, DE...
0	0	1	0.10	0.00	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	100	0.00	0.00	96g93hntrzjtr		select /+ rule / bucket_cnt,...

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

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
96	517	191,994	0.00	40.53	22.72	d9pnqk1hnx7h5	stage3@stade50 (TNS V1-V3)	update employees set salary = ...
7	12	2,400	0.00	3.09	0.54	cyuknq4uv9gn6	stage3@stade50 (TNS V1-V3)	select employee_id, last_name...
1	2	2,400	0.00	0.32	0.11	au7v19t361bn7	stage3@stade50 (TNS V1-V3)	select employee_id, last_name...
0	1	1	0.50	0.21	0.02	2ntzsd2w869g8	sqlplus@stade50 (TNS V1-V3)	begin :bid := DBMS_WO...
0	1	1	0.40	0.17	0.04	9ctt1scmwbmbg		begin dbsnmp.bsln_internal.mai...
0	0	1	0.12	0.05	0.02	7ujay4u33g337		SELECT BLDS.BSLN_GUID , BLDS.M...
0	0	1	0.12	0.05	0.01	2cn0kc8u4b81w		select OBJOID, CLSOID, RUNT...
0	0	1	0.10	0.04	0.00	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0	0	1	0.09	0.04	0.00	bqnn4c3gjtmgu		insert into wrh$_bg_event_summ...
0	0	1	0.06	0.03	0.00	8zdyb76axj3ym		select tc.type#, tc.intcol#, t...

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,154,029
Captured SQL account for 83.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
789,860	191,994	4.11	68.44	96.02	516.60	d9pnqk1hnx7h5	stage3@stade50 (TNS V1-V3)	update employees set salary = ...
157,247	2,400	65.52	13.63	7.32	12.20	cyuknq4uv9gn6	stage3@stade50 (TNS V1-V3)	select employee_id, last_name...
7,783	2,400	3.24	0.67	0.77	2.40	au7v19t361bn7	stage3@stade50 (TNS V1-V3)	select employee_id, last_name...
3,319	1	3,319.00	0.29	0.50	0.51	2ntzsd2w869g8	sqlplus@stade50 (TNS V1-V3)	begin :bid := DBMS_WO...
2,137	1	2,137.00	0.19	0.40	0.88	9ctt1scmwbmbg		begin dbsnmp.bsln_internal.mai...
855	1	855.00	0.07	0.10	0.10	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
731	1	731.00	0.06	0.12	0.42	7ujay4u33g337		SELECT BLDS.BSLN_GUID , BLDS.M...
314	17	18.47	0.03	0.02	0.03	3ktacv9r56b51		select owner#, name, namespace...
295	100	2.95	0.03	0.01	0.10	96g93hntrzjtr		select /+ rule / bucket_cnt,...
274	17	16.12	0.02	0.01	0.02	8swypbbr0m372		select order#, columns, types ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 535
Captured SQL account for 74.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
232	1	232.00	43.36	0.50	0.51	2ntzsd2w869g8	sqlplus@stade50 (TNS V1-V3)	begin :bid := DBMS_WO...
149	1	149.00	27.85	0.40	0.88	9ctt1scmwbmbg		begin dbsnmp.bsln_internal.mai...
61	191,994	0.00	11.40	96.02	516.60	d9pnqk1hnx7h5	stage3@stade50 (TNS V1-V3)	update employees set salary = ...
45	1	45.00	8.41	0.10	0.10	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
33	17	1.94	6.17	0.02	0.03	3ktacv9r56b51		select owner#, name, namespace...
31	18	1.72	5.79	0.01	0.01	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
18	1	18.00	3.36	0.00	0.00	6wm3n4d7bnddg		SELECT source, (case ...
16	1	16.00	2.99	0.12	0.42	7ujay4u33g337		SELECT BLDS.BSLN_GUID , BLDS.M...
14	18	0.78	2.62	0.01	0.01	ga9j9xk5cy9s0		select /*+ index(idl_sb4$ i_id...
13	1	13.00	2.43	0.03	0.08	00fx7adv5q5gm		SELECT HOUR, INTRADAY, EXTRA...
12	1	12.00	2.24	0.01	0.02	0z1031991bd7w		insert into wrh$_sysmetric_sum...
12	1	12.00	2.24	0.12	0.18	2cn0kc8u4b81w		select OBJOID, CLSOID, RUNT...
11	52	0.21	2.06	0.01	0.01	04xtrk7uyhknh		select obj#, type#, ctime, mti...
11	18	0.61	2.06	0.01	0.01	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
11	17	0.65	2.06	0.01	0.02	8swypbbr0m372		select order#, columns, types ...
11	26	0.42	2.06	0.01	0.01	db78fxqxwxt7r		select /+ rule / bucket, en...
9	1	9.00	1.68	0.02	0.02	5ax5xu96u2ztd		insert into WRH$_EVENT_HISTOGR...
9	1	9.00	1.68	0.03	0.05	fpvps147hqh7g		SELECT DBID FROM SYS.V_$DATABA...
8	1	8.00	1.50	0.03	0.04	1y4u5x9nr6aqg		INSERT /+ APPEND / INTO WRH$...
8	20	0.40	1.50	0.05	0.05	4vs91dcv7u1p6	sample@stade50 (TNS V1-V3)	insert into sys.aud$( sessioni...
8	1	8.00	1.50	0.02	0.02	f0s0bk5k713yb		insert into wrh$_parameter (...
7	29	0.24	1.31	0.01	0.01	9tgj4g8y4rwy8		select type#, blocks, extents,...
7	2,400	0.00	1.31	0.77	2.40	au7v19t361bn7	stage3@stade50 (TNS V1-V3)	select employee_id, last_name...
6	1	6.00	1.12	0.00	0.00	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
6	12	0.50	1.12	0.00	0.00	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
6	14	0.43	1.12	0.04	0.05	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
6	18	0.33	1.12	0.00	0.01	c6awqs517jpj0		select /*+ index(idl_char$ i_i...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 197,864
Captured SQL account for 99.9% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
191,994	191,996	1.00	0.00	d9pnqk1hnx7h5	stage3@stade50 (TNS V1-V3)	update employees set salary = ...
2,400	2,400	1.00	0.00	au7v19t361bn7	stage3@stade50 (TNS V1-V3)	select employee_id, last_name...
2,400	129,865	54.11	0.01	cyuknq4uv9gn6	stage3@stade50 (TNS V1-V3)	select employee_id, last_name...
100	95	0.95	0.00	96g93hntrzjtr		select /+ rule / bucket_cnt,...
66	66	1.00	0.00	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
52	50	0.96	0.00	04xtrk7uyhknh		select obj#, type#, ctime, mti...
51	57	1.12	0.00	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
33	0	0.00	0.00	6ssrk2dqj7jbx		select job, nvl2(last_date, ...
29	29	1.00	0.00	9tgj4g8y4rwy8		select type#, blocks, extents,...
26	361	13.88	0.00	db78fxqxwxt7r		select /+ rule / bucket, en...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 197,437
Captured SQL account for 99.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
190,292	191,994	96.38	d9pnqk1hnx7h5	stage3@stade50 (TNS V1-V3)	update employees set salary = ...
2,400	2,400	1.22	au7v19t361bn7	stage3@stade50 (TNS V1-V3)	select employee_id, last_name...
2,397	2,400	1.21	cyuknq4uv9gn6	stage3@stade50 (TNS V1-V3)	select employee_id, last_name...
29	29	0.01	9tgj4g8y4rwy8		select type#, blocks, extents,...
25	25	0.01	bsa0wjtftg3uw		select file# from file$ where ...
20	20	0.01	0h6b2sajwb74n		select privilege#, level from ...
20	20	0.01	0k8522rmdzg4k		select privilege# from sysauth...
20	20	0.01	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
20	20	0.01	209fr01svbb5s		update sys.aud$ set action#=:2...
20	20	0.01	459f3z9u4fb3u		select value$ from props$ wher...

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

00fx7adv5q5gm SELECT HOUR, INTRADAY, EXTRADAY FROM BSLN_TIMEGROUPS

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

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

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)

1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)

1y4u5x9nr6aqg INSERT /*+ APPEND */ 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)

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

2cn0kc8u4b81w select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select l.obj#, l.clas s_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bi tand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys. scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID

2m7dvzfc7t6jh SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bit and(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flag s, :5) <> 0 and e.affinity = :6)) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1

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

39m4sx9k63ba2 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#

3ktacv9r56b51 select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

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)

53saa2zkr6wc3 select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1

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 )

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

6ssrk2dqj7jbx select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job

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#

7ujay4u33g337 SELECT BLDS.BSLN_GUID , BLDS.METRIC_ID , :B4 , BLDS.TIMEGROUP , BLDS.DBID , BLDS.INSTANCE_NAME , TP.THRESHOLD_METHOD , TP.NUM_OCCURRENCES , TP.WARNING_PARAM , TP.CRITICAL_PARAM , TP.FAIL_ACTION , ST.SAMPLE_COUNT , ROUND(ST.MINIMUM, 3) AS MINIMUM , ROUND(ST.MAXIMUM, 3) AS MAXIMUM , ROUND(ST.PCTILE_95, 3) AS PCTILE_95 , ROUND(ST.PCTILE_99, 3) AS PCTILE_99 , ROUND(ST.EST_PCTILE_999, 3) AS PCTILE_999 , ROUND(ST.EST_PCTILE_9999, 3) AS PCTILE_9999 , EST_FIT_QUALITY , EST_SAMPLE_COUNT FROM BSLN_THRESHOLD_PARAMS TP , BSLN_STATISTICS ST , (SELECT B.BSLN_GUID AS BSLN_GUID , B.DBID AS DBID , B.INSTANCE_NAME AS INSTANCE_NAME , B.TIMEGROUPING AS TIMEGROUPING , BSLN.TIMEGROUP(B.TIMEGROUPING, :B4 ) AS TIMEGROUP , D.METRIC_ID AS METRIC_ID FROM BSLN_BASELINES B , BSLN_METRIC_DEFAULTS D WHERE B.STATUS = DECODE(:B2 , NULL, :B3 , B.STATUS) AND B.BSLN_GUID = NVL(:B2 , B.BSLN_GUID) AND B.TIMEGROUPING IS NOT NULL AND D.METRIC_ID = NVL(:B1 , D.METRIC_ID) ) BLDS WHERE BLDS.BSLN_GUID = TP.BSLN_GUID AND BLDS.METRIC_ID = TP.METRIC_ID AND BLDS.BSLN_GUID = ST.BSLN_GUID(+) AND BLDS.METRIC_ID = ST.METRIC_ID(+) AND BLDS.TIMEGROUP = ST.TIMEGROUP(+)

8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1

8zdyb76axj3ym select tc.type#, tc.intcol#, tc.position#, c.type#, c.length, c.scale, c.precision#, c.charsetid, c.charsetform, decode(bitand(c.property, 8388608), 8388608, c.spare3, 0) from triggercol$ tc, col$ c , trigger$ tr where tc.obj#=:1 and c.obj#=:2 and tc.intcol#=c.intcol# and tr.obj# = tc.obj# and (bitand(tr.property, 32) != 32 or bitand(tc.type#, 20) = 20) union select type#, intcol#, position#, 69, 0, 0, 0, 0, 0, 0 from triggercol$ where obj#=:3 and intcol#=1001 union select tc.type#, tc.intcol#, tc.position#, 121, 0, 0, 0, 0, 0, 0 from triggercol$ tc, trigger$ tr where tr.obj# = tc.obj# and bitand(tr.property, 32) = 32 and tc.obj# = :4 and bitand(tc.type#, 20) != 20

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

9ctt1scmwbmbg begin dbsnmp.bsln_internal.maintain_thresholds; end;

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

au7v19t361bn7 select employee_id, last_name, salary from employees where employee_id = :EMPNO

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

c6awqs517jpj0 select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#

cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#

cyuknq4uv9gn6 select employee_id, last_name from employees where employee_id > :EMPNO order by employee_id

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

f0s0bk5k713yb insert into wrh$_parameter (snap_id, dbid, instance_number, parameter_hash, value, isdefault, ismodified) select :snap_id, :dbid, :instance_number, i.ksppihash hash, substr(sv.ksppstvl, 1, 512), sv.ksppstdf, decode(bitand(sv.ksppstvf, 7), 1, 'MODIFIED', 'FALSE') from x$ksppi i, x$ksppsv sv where i.indx = sv.indx and (((i.ksppinm not like '#_%' escape '#') or (sv.ksppstdf = 'FALSE') or (bitand(sv.ksppstvf, 5) > 0)) or (i.ksppinm like '#_#_%' escape '#')) order by hash

fpvps147hqh7g SELECT DBID FROM SYS.V_$DATABASE

ga9j9xk5cy9s0 select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#

SQL Id	SQL Text
00fx7adv5q5gm	SELECT HOUR, INTRADAY, EXTRADAY FROM BSLN_TIMEGROUPS
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
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
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)
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1y4u5x9nr6aqg	INSERT /+ APPEND / 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)
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
2cn0kc8u4b81w	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select l.obj#, l.clas s_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bi tand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys. scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
2m7dvzfc7t6jh	SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bit and(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flag s, :5) <> 0 and e.affinity = :6)) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
2ntzsd2w869g8	begin :bid := DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;
39m4sx9k63ba2	select /+ index(idl_ub2$ i_idl_ub21) +/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
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)
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
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 )
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6ssrk2dqj7jbx	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
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#
7ujay4u33g337	SELECT BLDS.BSLN_GUID , BLDS.METRIC_ID , :B4 , BLDS.TIMEGROUP , BLDS.DBID , BLDS.INSTANCE_NAME , TP.THRESHOLD_METHOD , TP.NUM_OCCURRENCES , TP.WARNING_PARAM , TP.CRITICAL_PARAM , TP.FAIL_ACTION , ST.SAMPLE_COUNT , ROUND(ST.MINIMUM, 3) AS MINIMUM , ROUND(ST.MAXIMUM, 3) AS MAXIMUM , ROUND(ST.PCTILE_95, 3) AS PCTILE_95 , ROUND(ST.PCTILE_99, 3) AS PCTILE_99 , ROUND(ST.EST_PCTILE_999, 3) AS PCTILE_999 , ROUND(ST.EST_PCTILE_9999, 3) AS PCTILE_9999 , EST_FIT_QUALITY , EST_SAMPLE_COUNT FROM BSLN_THRESHOLD_PARAMS TP , BSLN_STATISTICS ST , (SELECT B.BSLN_GUID AS BSLN_GUID , B.DBID AS DBID , B.INSTANCE_NAME AS INSTANCE_NAME , B.TIMEGROUPING AS TIMEGROUPING , BSLN.TIMEGROUP(B.TIMEGROUPING, :B4 ) AS TIMEGROUP , D.METRIC_ID AS METRIC_ID FROM BSLN_BASELINES B , BSLN_METRIC_DEFAULTS D WHERE B.STATUS = DECODE(:B2 , NULL, :B3 , B.STATUS) AND B.BSLN_GUID = NVL(:B2 , B.BSLN_GUID) AND B.TIMEGROUPING IS NOT NULL AND D.METRIC_ID = NVL(:B1 , D.METRIC_ID) ) BLDS WHERE BLDS.BSLN_GUID = TP.BSLN_GUID AND BLDS.METRIC_ID = TP.METRIC_ID AND BLDS.BSLN_GUID = ST.BSLN_GUID(+) AND BLDS.METRIC_ID = ST.METRIC_ID(+) AND BLDS.TIMEGROUP = ST.TIMEGROUP(+)
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
8zdyb76axj3ym	select tc.type#, tc.intcol#, tc.position#, c.type#, c.length, c.scale, c.precision#, c.charsetid, c.charsetform, decode(bitand(c.property, 8388608), 8388608, c.spare3, 0) from triggercol$ tc, col$ c , trigger$ tr where tc.obj#=:1 and c.obj#=:2 and tc.intcol#=c.intcol# and tr.obj# = tc.obj# and (bitand(tr.property, 32) != 32 or bitand(tc.type#, 20) = 20) union select type#, intcol#, position#, 69, 0, 0, 0, 0, 0, 0 from triggercol$ where obj#=:3 and intcol#=1001 union select tc.type#, tc.intcol#, tc.position#, 121, 0, 0, 0, 0, 0, 0 from triggercol$ tc, trigger$ tr where tr.obj# = tc.obj# and bitand(tr.property, 32) = 32 and tc.obj# = :4 and bitand(tc.type#, 20) != 20
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
9ctt1scmwbmbg	begin dbsnmp.bsln_internal.maintain_thresholds; end;
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
au7v19t361bn7	select employee_id, last_name, salary from employees where employee_id = :EMPNO
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
c6awqs517jpj0	select /+ index(idl_char$ i_idl_char1) +/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
cyuknq4uv9gn6	select employee_id, last_name from employees where employee_id > :EMPNO order by employee_id
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
f0s0bk5k713yb	insert into wrh$_parameter (snap_id, dbid, instance_number, parameter_hash, value, isdefault, ismodified) select :snap_id, :dbid, :instance_number, i.ksppihash hash, substr(sv.ksppstvl, 1, 512), sv.ksppstdf, decode(bitand(sv.ksppstvf, 7), 1, 'MODIFIED', 'FALSE') from x$ksppi i, x$ksppsv sv where i.indx = sv.indx and (((i.ksppinm not like '#_%' escape '#') or (sv.ksppstdf = 'FALSE') or (bitand(sv.ksppstvf, 5) > 0)) or (i.ksppinm like '#_#_%' escape '#')) order by hash
fpvps147hqh7g	SELECT DBID FROM SYS.V_$DATABASE
ga9j9xk5cy9s0	select /+ index(idl_sb4$ i_idl_sb41) +/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#

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	112	0.67	0.00
CPU used by this session	21,335	127.53	0.11
CPU used when call started	21,299	127.31	0.11
CR blocks created	4,613	27.57	0.02
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	226,834	1,355.87	1.18
DBWR checkpoint buffers written	425	2.54	0.00
DBWR checkpoints	4	0.02	0.00
DBWR thread checkpoint buffers written	425	2.54	0.00
DBWR transaction table writes	80	0.48	0.00
DBWR undo block writes	3,527	21.08	0.02
Effective IO time	0	0.00	0.00
HSC Heap Segment Block Changes	192,283	1,149.34	1.00
Heap Segment Array Inserts	76	0.45	0.00
Heap Segment Array Updates	9	0.05	0.00
IMU CR rollbacks	122	0.73	0.00
IMU Flushes	31,606	188.92	0.16
IMU Redo allocation size	13,379,636	79,974.87	69.68
IMU commits	132,726	793.35	0.69
IMU contention	31,591	188.83	0.16
IMU pool not allocated	27,684	165.48	0.14
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	69,885,868	417,732.84	363.97
IMU- failed to get a private strand	24,565	146.83	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	89	0.53	0.00
RowCR attempts	1,990	11.89	0.01
RowCR hits	1,639	9.80	0.01
SMON posted for undo segment shrink	3	0.02	0.00
SQL*Net roundtrips to/from client	262,384	1,568.36	1.37
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	3,030	18.11	0.02
application wait time	0	0.00	0.00
background checkpoints completed	4	0.02	0.00
background checkpoints started	4	0.02	0.00
background timeouts	640	3.83	0.00
branch node splits	0	0.00	0.00
buffer is not pinned count	405,319	2,422.74	2.11
buffer is pinned count	128,735	769.50	0.67
bytes received via SQL*Net from client	68,379,166	408,726.74	356.12
bytes sent via SQL*Net to client	40,236,949	240,510.64	209.56
calls to get snapshot scn: kcmgss	390,448	2,333.85	2.03
calls to kcmgas	198,221	1,184.84	1.03
calls to kcmgcs	44	0.26	0.00
calls to kcmgrs	1,197,840	7,159.92	6.24
change write time	1,295	7.74	0.01
cleanout - number of ktugct calls	11,003	65.77	0.06
cleanouts and rollbacks - consistent read gets	1,438	8.60	0.01
cleanouts only - consistent read gets	913	5.46	0.00
cluster key scan block gets	138	0.82	0.00
cluster key scans	135	0.81	0.00
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	57	0.34	0.00
commit cleanout failures: cannot pin	54,586	326.28	0.28
commit cleanouts	192,305	1,149.48	1.00
commit cleanouts successfully completed	137,662	822.86	0.72
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	57,503	343.72	0.30
concurrency wait time	40,571	242.51	0.21
consistent changes	17,716	105.89	0.09
consistent gets	410,942	2,456.35	2.14
consistent gets - examination	270,856	1,619.00	1.41
consistent gets direct	0	0.00	0.00
consistent gets from cache	410,942	2,456.35	2.14
consistent gets from cache (fastpath)	115,038	687.62	0.60
cursor authentications	65	0.39	0.00
data blocks consistent reads - undo records applied	16,863	100.80	0.09
db block changes	771,804	4,613.35	4.02
db block gets	743,087	4,441.70	3.87
db block gets direct	7	0.04	0.00
db block gets from cache	743,080	4,441.66	3.87
db block gets from cache (fastpath)	596	3.56	0.00
deferred (CURRENT) block cleanout applications	16,320	97.55	0.08
dirty buffers inspected	2,783	16.63	0.01
enqueue conversions	47	0.28	0.00
enqueue releases	620,183	3,707.06	3.23
enqueue requests	620,183	3,707.06	3.23
enqueue timeouts	0	0.00	0.00
enqueue waits	7	0.04	0.00
exchange deadlocks	0	0.00	0.00
execute count	197,864	1,182.70	1.03
free buffer inspected	4,590	27.44	0.02
free buffer requested	9,442	56.44	0.05
heap block compress	7,355	43.96	0.04
hot buffers moved to head of LRU	702	4.20	0.00
immediate (CR) block cleanout applications	2,351	14.05	0.01
immediate (CURRENT) block cleanout applications	40	0.24	0.00
index crx upgrade (found)	25	0.15	0.00
index crx upgrade (positioned)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fetch by key	195,094	1,166.15	1.02
index scans kdiixs1	3,886	23.23	0.02
leaf node 90-10 splits	14	0.08	0.00
leaf node splits	16	0.10	0.00
lob reads	0	0.00	0.00
lob writes	3	0.02	0.00
lob writes unaligned	3	0.02	0.00
logons cumulative	21	0.13	0.00
messages received	43,924	262.55	0.23
messages sent	43,924	262.55	0.23
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	130,486	779.96	0.68
opened cursors cumulative	197,771	1,182.15	1.03
parse count (failures)	0	0.00	0.00
parse count (hard)	42	0.25	0.00
parse count (total)	197,437	1,180.15	1.03
parse time cpu	467	2.79	0.00
parse time elapsed	888	5.31	0.00
physical read IO requests	521	3.11	0.00
physical read bytes	4,382,720	26,197.09	22.83
physical read total IO requests	86,186	515.16	0.45
physical read total bytes	1,407,766,528	8,414,724.19	7,331.74
physical read total multi block requests	0	0.00	0.00
physical reads	535	3.20	0.00
physical reads cache	523	3.13	0.00
physical reads cache prefetch	14	0.08	0.00
physical reads direct	12	0.07	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	2,818	16.84	0.01
physical write bytes	32,514,048	194,348.10	169.34
physical write total IO requests	23,545	140.74	0.12
physical write total bytes	138,180,096	825,951.87	719.65
physical write total multi block requests	51	0.30	0.00
physical writes	3,969	23.72	0.02
physical writes direct	19	0.11	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	3,950	23.61	0.02
physical writes non checkpoint	3,704	22.14	0.02
pinned buffers inspected	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
process last non-idle time	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	204,598	1,222.96	1.07
recursive cpu usage	4,305	25.73	0.02
redo blocks checksummed by FG (exclusive)	3,925	23.46	0.02
redo blocks read for recovery	0	0.00	0.00
redo blocks read total	0	0.00	0.00
redo blocks written	200,163	1,196.45	1.04
redo blocks written for direct writes	52	0.31	0.00
redo buffer allocation retries	20	0.12	0.00
redo entries	254,722	1,522.56	1.33
redo entries for lost write detection	478	2.86	0.00
redo log space requests	52,951	316.51	0.28
redo log space wait time	2,002	11.97	0.01
redo ordering marks	1,163	6.95	0.01
redo size	93,845,456	560,947.87	488.75
redo size for lost write detection	25,248	150.92	0.13
redo subscn max counts	1,442	8.62	0.01
redo synch time	159,672	954.42	0.83
redo synch writes	192,041	1,147.90	1.00
redo wastage	5,293,016	31,638.25	27.57
redo write time	5,954	35.59	0.03
redo writer latching time	98	0.59	0.00
redo writes	19,239	115.00	0.10
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	2,715	16.23	0.01
rows fetched via callback	2,875	17.18	0.01
session connect time	0	0.00	0.00
session cursor cache hits	197,306	1,179.37	1.03
session logical reads	1,154,029	6,898.04	6.01
shared hash latch upgrades - no wait	4,827	28.85	0.03
shared hash latch upgrades - wait	28	0.17	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	272	1.63	0.00
sorts (rows)	7,181	42.92	0.04
sql area evicted	112	0.67	0.00
sql area purged	0	0.00	0.00
summed dirty queue length	3,430	20.50	0.02
switch current to new buffer	306	1.83	0.00
table fetch by rowid	135,412	809.41	0.71
table fetch continued row	13	0.08	0.00
table scan blocks gotten	230	1.37	0.00
table scan rows gotten	17,458	104.35	0.09
table scans (long tables)	0	0.00	0.00
table scans (short tables)	90	0.54	0.00
total number of times SMON posted	4	0.02	0.00
transaction rollbacks	0	0.00	0.00
undo change vector size	30,243,520	180,776.34	157.51
user I/O wait time	9	0.05	0.00
user calls	459,228	2,744.97	2.39
user commits	192,010	1,147.71	1.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	152	0.91	0.00
write clones created in background	2	0.01	0.00
write clones created in foreground	53	0.32	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
session pga memory max	624,298,380	624,298,380
session cursor cache count	740,139	740,440
session uga memory	1,551,195,743,560	1,551,196,582,804
opened cursors current	142	142
logons current	59	59
session uga memory max	6,283,929,484	6,293,449,868
session pga memory	510,576,392	510,904,072

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)	4	86.07

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	27	0	0.00	1.00	2,374	14	461	1.41
SYSAUX	247	1	0.28	1.06	281	2	0	0.00
SYSTEM	247	1	0.04	1.00	17	0	59,921	5.43

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	247	1	0.28	1.06	281	2	0	0.00
SYSTEM	/ade/jacao_15v/oracle/dbs/t_db1.f	247	1	0.04	1.00	17	0	59,921	5.43
UD1	/ade/jacao_15v/oracle/dbs/t_undo1.f	27	0	0.00	1.00	2,374	14	461	1.41

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,153,577	521	3,786	0	0	60,382

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	16	230	2912	24834	46080	24834
E	0	18	599	34592	46080	46080	181410

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.79	705,531
D	8	0.50	996	1.30	511,733
D	12	0.75	1,494	1.15	452,336
D	16	1.00	1,992	1.00	394,962
D	20	1.25	2,490	0.95	374,546
D	24	1.50	2,988	0.92	364,126
D	28	1.75	3,486	0.90	355,996
D	32	2.00	3,984	0.87	343,087

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	10	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	105.55	0.00	0.00	0.00	0.00	5,939
E	29	4	107.05	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
2K	4K	138	138
256K	512K	2	2
512K	1024K	12	12

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,651.97	195.85	93.00	22	129,555
22	0.75	2,651.97	195.85	93.00	22	129,555
29	1.00	2,651.97	43.65	98.00	22	122,631
35	1.20	2,651.97	43.65	98.00	21	122,631
41	1.40	2,651.97	43.65	98.00	21	122,631
46	1.60	2,651.97	43.65	98.00	18	122,631
52	1.80	2,651.97	43.65	98.00	18	122,631
58	2.00	2,651.97	43.65	98.00	18	122,631
87	3.00	2,651.97	38.51	99.00	0	122,398
116	4.00	2,651.97	38.51	99.00	0	122,398
174	6.00	2,651.97	38.51	99.00	0	122,398
232	8.00	2,651.97	0.00	100.00	0	120,646

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)
44	0.48	0	31	48,945	0.39	78,408	25.85	27
56	0.61	12	897	51,287	0.41	76,066	25.08	777
68	0.74	24	1,886	116,102	0.93	11,251	3.71	1,344
80	0.87	36	2,424	124,183	1.00	3,170	1.05	1,380
92	1.00	48	3,311	124,320	1.00	3,033	1.00	1,383
104	1.13	60	4,820	126,090	1.01	1,263	0.42	1,388
116	1.26	72	6,218	126,357	1.02	996	0.33	1,391
128	1.39	84	7,243	131,830	1.06	1	0.00	1,394
140	1.52	96	7,789	131,847	1.06	1	0.00	1,395
152	1.65	108	9,173	131,889	1.06	1	0.00	1,396
164	1.78	120	9,942	132,468	1.07	1	0.00	1,398
176	1.91	132	11,112	132,530	1.07	1	0.00	1,401
188	2.04	144	11,793	132,582	1.07	1	0.00	1,402

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	59,921	325	5
undo header	456	1	1
undo block	5	0	4

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)
CF-Controlfile Transaction	42,613	42,613	0	7	0	8.57

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	128	0.00		0	0
ASM map operation hash table	1	0.00		0	0
AWR Alerted Metric Element list	1,287	0.00		0	0
Change Notification Hash table latch	56	0.00		0	0
Consistent RBA	19,247	0.00		0	0
DML lock allocation	384,332	0.26	0.12	0	0
Event Group Locks	22	0.00		0	0
FOB s.o list latch	56	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	717,782	6.62	0.60	72	188,927	0.49
JS Sh mem access	1	0.00		0	0
JS queue access latch	1	0.00		0	0
JS queue state obj latch	990	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	56	0.00		0	0
KTF sga latch	0			0	55	0.00
Locator state objects pool parent latch	1	0.00		0	0
MQL Tracking Latch	0			0	4	0.00
Memory Management Latch	1	0.00		0	56	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	5,201	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	70	0.00		0	0
OS process allocation	102	0.00		0	0
OS process: request allocation	42	0.00		0	0
PL/SQL warning settings	26	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	15	0.00		0	0
Result Cache: Latch	384,000	0.11	0.58	1	0
SGA IO buffer pool latch	639	0.00		0	639	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	45	0.00		0	55	0.00
SQL memory manager workarea list latch	6,791	0.00		0	0
Shared B-Tree	7	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	24,707	0.00		0	0
active service list	426	0.00		0	119	0.00
archive control	6	0.00		0	0
begin backup scn array	1	0.00		0	0
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	48	0.00		0	0
cache buffers chains	4,526,153	0.60	0.08	5	7,749	0.45
cache buffers lru chain	17,406	0.03	0.50	0	4,912	0.12
cache table scan latch	4	0.00		0	4	0.00
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	43	0.00		0	0
channel operations parent latch	1,048	0.00		0	0
checkpoint queue latch	22,182	0.00		0	4,265	0.00
client/application info	142	0.00		0	0
commit callback allocation	1	0.00		0	0
compile environment latch	21	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	71	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	71	0.00		0	0
dml lock allocation	71	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	43	0.00		0	0
enqueue hash chains	1,240,405	0.99	0.04	1	0
enqueues	471,808	0.37	0.51	3	0
fifth spare latch	1	0.00		0	0
file cache latch	41	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	0			0	1,187	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	3	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	345	0.00		0	0
kokc descriptor allocation latch	2	0.00		0	0
ksfv messages	1	0.00		0	0
kss move lock	3	0.00		0	0
ksuosstats global area	15	0.00		0	0
ksv allocation latch	75	0.00		0	0
ksv class latch	5	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	42	0.00		0	0
ktm global data	6	0.00		0	0
kwqbsn:qsga	6	0.00		0	0
lgwr LWN SCN	19,248	0.00		0	0
library cache load lock	132	0.00		0	0
list of block allocation	56	0.00		0	0
loader state object freelist	50	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	100,559	0.44	0.01	0	0
mostly latch-free SCN	19,283	0.03	0.00	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	8	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	71	0.00		0	0
object queue header heap	3,486	0.00		0	86	0.00
object queue header operation	25,320	0.01	0.00	0	0
object stats modification	7	0.00		0	0
parallel query alloc buffer	25	0.00		0	0
parallel query stats	1	0.00		0	0
parameter table management	42	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	143,029	0.10	0.13	0	277,493	0.23
process allocation	43	0.00		0	21	0.00
process group creation	42	0.00		0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qmn task queue latch	24	4.17	1.00	0	0
queued dump request	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	413,317	0.14	0.04	0	254,386	0.34
redo copy	1	0.00		0	254,714	0.98
redo writing	115,520	0.03	0.06	0	0
resmgr group change latch	20	0.00		0	0
resmgr:active threads	43	0.00		0	0
resmgr:actses change group	22	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	42	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	8,341	0.00		0	0
second spare latch	1	0.00		0	0
sequence cache	69	0.00		0	0
session allocation	401,362	0.95	0.36	7	0
session idle bit	1,110,501	0.11	0.07	0	0
session queue latch	1	0.00		0	0
session state list latch	6	0.00		0	0
session switching	72	0.00		0	0
session timer	119	0.00		0	0
shared pool	7,377	0.01	0.00	0	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	4,492	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	297,489	0.00		0	0
simulator lru latch	296,678	0.07	0.05	0	281	0.00
sort extent pool	75	0.00		0	0
space background task latch	124	0.00		0	112	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	4	0.00		0	0
transaction allocation	47	0.00		0	0
transaction branch allocation	119	0.00		0	0
undo global data	979,417	0.07	0.05	0	0
user lock	82	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
In memory undo latch	717,782	47,521	28,677	19,905
cache buffers chains	4,526,153	27,303	2,260	25,150
enqueue hash chains	1,240,405	12,331	460	11,894
session allocation	401,362	3,804	1,374	2,491
enqueues	471,808	1,769	907	939
session idle bit	1,110,501	1,246	84	1,162
DML lock allocation	384,332	987	120	870
undo global data	979,417	662	30	635
redo allocation	413,317	590	23	569
messages	100,559	445	3	443
Result Cache: Latch	384,000	419	243	199
simulator lru latch	296,678	206	10	197
post/wait queue	143,029	136	18	118
redo writing	115,520	34	2	32
cache buffers lru chain	17,406	6	3	3
qmn task queue latch	24	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
DML lock allocation	ktaidm	90	21
DML lock allocation	ktaiam	30	99
In memory undo latch	kticmt: child	20,682	5,498
In memory undo latch	ktiFlush: child	6,197	23,695
In memory undo latch	ktichg: child	2,724	0
In memory undo latch	ktiTxnPoolFree	5	0
In memory undo latch	ktiBRacquire	3	0
Result Cache: Latch	Result Cache: Serialization06	195	4
Result Cache: Latch	Result Cache: Serialization05	48	239
cache buffers chains	kcbgtcr: fast path (cr pin)	655	262
cache buffers chains	kcbnlc	612	45
cache buffers chains	kcbgtcr: fast path	411	60
cache buffers chains	kcbgcur_2	286	1,060
cache buffers chains	kcbchg1: kslbegin: bufs not pinned	241	69
cache buffers chains	kcb_commit	84	90
cache buffers chains	kcbzwb	79	209
cache buffers chains	kcb_post_apply: kcbhq62	63	19
cache buffers chains	kcb_pre_apply: kcbhq61	22	198
cache buffers chains	kcbzpbuf	20	278
cache buffers chains	kcbrls_2	17	20
cache buffers chains	kcbchg1: kslbegin: call CR func	5	51
cache buffers chains	kcbgtcr: kslbegin excl	2	4
cache buffers lru chain	kcbzgws_1	2	3
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP_1	1	0
enqueue hash chains	ksqrcl	262	28
enqueue hash chains	ksqgtl3	198	432
enqueues	ksqdel	759	16
enqueues	ksqgel: create enqueue	148	891
messages	ksarcv	2	0
messages	ksaamb: after wakeup	1	3
post/wait queue	kslpstevent:reget	12	0
post/wait queue	kslpstevent:get	6	0
qmn task queue latch	kwqmnmvtsks: delay to ready list	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	16	0
redo allocation	kcrf_pvt_strand_unbind	7	0
redo writing	kcrfws: in loop	2	2
session allocation	ksucri	938	563
session allocation	ksuxds: not user session	404	811
session allocation	ksuprc	21	0
session allocation	ksudlc	9	0
session allocation	ksufap: active sessions	1	0
session allocation	ksuxds: KSUSFCLC set	1	0
session idle bit	ksupuc: set busy	36	26
session idle bit	ksupuc: clear busy	29	22
session idle bit	ksuxds	19	36
simulator lru latch	kcbs_simulate: simulate set	10	10
undo global data	ktudnx:child	26	7
undo global data	ktudba: KSLBEGIN	3	6
undo global data	ktubnd:child	1	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 1,154,029
Captured Segments account for 45.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
HR	SYSTEM	EMPLOYEES	TABLE	263,792	22.86
HR	SYSTEM	EMP_EMP_ID_PK	INDEX	261,104	22.63
SYS	SYSAUX	WRH$_SEG_STAT_OBJ	TABLE	448	0.04
SYS	SYSAUX	WRI$_ADV_PARAMETERS_PK	INDEX	256	0.02
SYS	SYSTEM	OBJ$	TABLE	208	0.02

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 535
Captured Segments account for 42.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	43	8.04
SYS	SYSTEM	I_OBJ2	INDEX	25	4.67
SYS	SYSAUX	WRH$_SQLTEXT	TABLE	19	3.55
SYS	SYSTEM	OBJ$	TABLE	16	2.99
SYS	SYSAUX	WRH$_SQL_BIND_METADATA	TABLE	13	2.43

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	59,921	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	7	0.00	2	1
dc_database_links	40	2.50	0	1
dc_global_oids	8	12.50	0	21
dc_histogram_data	256	10.16	0	431
dc_histogram_defs	549	18.21	0	2,694
dc_objects	837	6.57	0	837
dc_profiles	20	0.00	0	1
dc_rollback_segments	4	0.00	0	23
dc_segments	74	39.19	9	645
dc_tablespaces	351	0.00	0	4
dc_users	785	0.64	0	14
global database name	131	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	15	33.33	19	36.84	1	0
CLUSTER	15	0.00	10	0.00	0	0
INDEX	2	0.00	2	0.00	0	0
SQL AREA	565	16.81	197,982	-0.18	26	1
TABLE/PROCEDURE	351	14.53	419	13.60	13	0
TRIGGER	1	100.00	1	100.00	0	0

Memory Statistics

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

Memory Dynamic Components

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

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	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.66		1.53	2.79	22	22	60	60
	Freeable	12.19	0.00	1.22	1.28	4		10	10
	SQL	1.56	0.84	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.19		1.54	2.81	22	22	60	60
	Freeable	13.25	0.00	1.20	1.22	4		11	11
	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	5.20	4.99	-4.07
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGL buckets	3.00	3.00	0.00
shared	KGL handle	1.81	1.87	3.20
shared	KGLS heap	2.90	3.08	6.39
shared	KQR M PO	1.66	1.74	4.55
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	PCursor	4.78	4.81	0.59
shared	PL/SQL DIANA		0.94
shared	PL/SQL MPCODE	2.03	2.19	7.73
shared	event statistics per sess	1.06	1.06	0.00
shared	free memory	5.58	5.84	4.67
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	15.74	14.99	-4.79
	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 %:	94.77	Redo NoWait %:	79.21
Buffer Hit %:	99.95	In-memory Sort %:	100.00
Library Hit %:	100.14	Soft Parse %:	99.98
Execute to Parse %:	0.22	Latch Hit %:	99.17
Parse CPU to Parse Elapsd %:	0.00	% Non-Parse CPU:	98.03