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: 349 04-Aug-08 11:53:00 59 2.4

End Snap: 350 04-Aug-08 11:55:02 59 2.4

Elapsed: 2.03 (mins)

DB Time: 12.38 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	349	04-Aug-08 11:53:00	59	2.4
End Snap:	350	04-Aug-08 11:55:02	59	2.4
Elapsed:		2.03 (mins)
DB Time:		12.38 (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): 6.1 74.3 0.00 0.00

DB CPU(s): 1.6 19.3 0.00 0.00

Redo size: 8,226.0 100,422.8

Logical reads: 3,019.7 36,864.9

Block changes: 17.2 210.0

Physical reads: 11.6 141.2

Physical writes: 1.4 17.3

User calls: 3,753.9 45,827.0

Parses: 1,700.2 20,756.1

Hard parses: 47.2 575.9

W/A MB processed: 86,630.7 1,057,587.2

Logons: 0.2 2.0

Executes: 1,730.5 21,126.0

Rollbacks: 0.0 0.0

Transactions: 0.1

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	6.1	74.3	0.00	0.00
DB CPU(s):	1.6	19.3	0.00	0.00
Redo size:	8,226.0	100,422.8
Logical reads:	3,019.7	36,864.9
Block changes:	17.2	210.0
Physical reads:	11.6	141.2
Physical writes:	1.4	17.3
User calls:	3,753.9	45,827.0
Parses:	1,700.2	20,756.1
Hard parses:	47.2	575.9
W/A MB processed:	86,630.7	1,057,587.2
Logons:	0.2	2.0
Executes:	1,730.5	21,126.0
Rollbacks:	0.0	0.0
Transactions:	0.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 93.42 Soft Parse %: 97.23

Execute to Parse %: 1.75 Latch Hit %: 98.45

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

Shared Pool Statistics

Begin End

Memory Usage %: 94.03 91.13

% SQL with executions>1: 78.85 95.13

% Memory for SQL w/exec>1: 70.22 93.48

	Begin	End
Memory Usage %:	94.03	91.13
% SQL with executions>1:	78.85	95.13
% Memory for SQL w/exec>1:	70.22	93.48

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
library cache: mutex X	290,875	345	1	46.52	Concurrency
DB CPU		193		26.05
latch: row cache objects	3,553	126	35	16.93	Concurrency
latch: shared pool	1,844	30	16	4.02	Concurrency
latch: session allocation	358	4	10	0.50	Other

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

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

2.73 15.69 70.3 25.5 0.1 4.2

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
2.73	15.69	70.3	25.5	0.1	4.2

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

78.9 82.4 0.0

Memory Statistics

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

Begin End

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

SGA use (MB): 163.6 163.6

PGA use (MB): 110.3 107.2

% Host Mem used for SGA+PGA: 13.53 13.53

	Begin	End
Host Mem (MB):	2,025.5	2,025.5
SGA use (MB):	163.6	163.6
PGA use (MB):	110.3	107.2
% Host Mem used for SGA+PGA:	13.53	13.53

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

Statistic Name	Time (s)	% of DB Time
parse time elapsed	571.50	76.96
hard parse elapsed time	477.68	64.32
DB CPU	193.45	26.05
sql execute elapsed time	57.94	7.80
connection management call elapsed time	0.40	0.05
PL/SQL compilation elapsed time	0.12	0.02
PL/SQL execution elapsed time	0.11	0.02
repeated bind elapsed time	0.02	0.00
DB time	742.62
background elapsed time	27.41
background cpu time	2.16

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	23,749
IDLE_TIME	1,029
IOWAIT_TIME	13
NICE_TIME	0
SYS_TIME	6,318
USER_TIME	17,426
LOAD	3	16
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:53:00	2.73
04-Aug 11:55:02	15.69	95.85	70.33	25.50	0.05	4.15

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 95.3% of Total DB time 742.62 (s)
Total FG Wait Time: 513.93 (s) DB CPU time: 193.45 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Concurrency	296,579	98	506	2	68.16
DB CPU			193		26.05
Other	449	1	6	13	0.77
Network	261,429	0	2	0	0.26
Commit	24	0	0	3	0.01
User I/O	497	0	0	0	0.00
System I/O	456	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
library cache: mutex X	290,875	100	345	1	29,087.50	46.52
latch: row cache objects	3,553	0	126	35	355.30	16.93
latch: shared pool	1,844	0	30	16	184.40	4.02
latch: session allocation	358	0	4	10	35.80	0.50
cursor: pin S wait on X	246	100	3	11	24.60	0.38
library cache load lock	23	0	2	91	2.30	0.28
SQL*Net message to client	261,429	0	2	0	26,142.90	0.26
latch free	71	0	1	19	7.10	0.18
cursor: pin S	3	100	1	185	0.30	0.07
latch: cache buffers chains	36	0	0	6	3.60	0.03
latch: enqueue hash chains	16	0	0	10	1.60	0.02
log file sync	24	0	0	3	2.40	0.01
db file sequential read	493	0	0	0	49.30	0.00
cursor: mutex X	2	100	0	10	0.20	0.00
latch: redo allocation	1	0	0	15	0.10	0.00
control file sequential read	456	0	0	0	45.60	0.00
SQL*Net message from client	261,429	0	1,786	7	26,142.90

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
control file parallel write	38	0	6	163	3.80	22.60
latch: row cache objects	7	0	0	39	0.70	1.00
latch: shared pool	8	0	0	29	0.80	0.84
log file parallel write	69	0	0	3	6.90	0.70
db file scattered read	71	0	0	0	7.10	0.10
db file sequential read	82	0	0	0	8.20	0.02
events in waitclass Other	1	0	0	4	0.10	0.01
control file sequential read	38	0	0	0	3.80	0.01
rdbms ipc message	523	89	1,211	2315	52.30
smon timer	1	100	300	300015	0.10
DIAG idle wait	240	100	246	1023	24.00
pmon timer	43	95	124	2892	4.30
Space Manager: slave idle wait	25	96	122	4874	2.50
Streams AQ: qmn coordinator idle wait	8	50	112	14017	0.80
Streams AQ: qmn slave idle wait	4	0	112	28030	0.40

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
SQL*Net message to client	261K	100.0	.0	.0	.0			.0
control file parallel write	38	15.8	5.3	5.3	13.2	47.4	5.3	5.3	2.6
control file sequential read	494	100.0
cursor: mutex X	2			50.0		50.0
cursor: pin S	3							100.0
cursor: pin S wait on X	246	.4				98.8	.8
db file scattered read	75	98.7					1.3
db file sequential read	616	99.7		.2	.2
latch free	73	9.6	2.7	4.1	11.0	20.5	39.7	12.3
latch: cache buffers chains	36	36.1	2.8	2.8	27.8	30.6
latch: enqueue hash chains	16	18.8		6.3	31.3	18.8	25.0
latch: redo allocation	1					100.0
latch: row cache objects	3560	15.2	.4	1.3	4.0	9.5	19.5	50.0	.1
latch: session allocation	358	14.8	5.0	10.6	25.7	26.8	15.9	1.1
latch: shared pool	1852	19.0	5.8	8.5	18.5	17.5	17.0	13.7	.1
library cache load lock	23					26.1	21.7	52.2
library cache: mutex X	290K	99.6	.1	.0	.0	.0	.0	.1	.0
log file parallel write	69	65.2	8.7	4.3	8.7	8.7	4.3
log file sync	24	58.3	8.3	4.2	25.0	4.2
DIAG idle wait	242							92.1	7.9
SQL*Net message from client	261K	32.4	5.9	10.0	25.8	23.8	1.7	.4	.0
Space Manager: slave idle wait	26							3.8	96.2
Streams AQ: qmn coordinator idle wait	10	10.0			10.0	10.0	20.0		50.0
Streams AQ: qmn slave idle wait	5								100.0
pmon timer	43	4.7							95.3
rdbms ipc message	524	.8	.2	.8	3.1	.4		28.1	66.8
smon timer	1								100.0

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
SYS$USERS	741	192	1	360
15v.regress.rdbms.dev.us.oracle.com	0	0	0	0
SYS$BACKGROUND	0	0	1	4

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	493	0	296579	506	0	0	261429	2
SYS$BACKGROUND	153	0	15	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): 743
Captured SQL account for 26.5% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
14	1	119	0.12	1.87	80n8t2qzbdf7s	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
14	0	119	0.12	1.86	07azhqtn52srv	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
14	0	119	0.12	1.86	g734cwcxrsj68	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
12	0	20	0.62	1.68	7r049cf0btb8k	stage2@stade50 (TNS V1-V3)	select employee_id, last_name...
11	1	119	0.09	1.44	0h0nc9r7bdb7w	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
11	1	119	0.09	1.44	5y1qzjy5qbdmc	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
11	1	119	0.09	1.44	a2x710cg44pyy	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
11	0	103	0.10	1.42	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
10	0	117	0.09	1.41	d9ux3b861xqr8	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
9	0	118	0.08	1.20	7tywa5jy10pup	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
8	0	117	0.07	1.09	94qqkq26xrrfy	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
8	0	117	0.07	1.05	7k7hxybq0sdzx	stage2@stade50 (TNS V1-V3)	update employees set salary = ...

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

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
3	3	0		1.64	0.43	48jvprb98hg2c	sqlplus@stade50 (TNS V1-V3)	begin :eid := DBMS_WO...
1	11	119	0.01	0.54	1.44	a2x710cg44pyy	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
1	11	119	0.01	0.53	1.44	5y1qzjy5qbdmc	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
1	11	119	0.01	0.52	1.44	0h0nc9r7bdb7w	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
1	14	119	0.01	0.46	1.87	80n8t2qzbdf7s	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
1	1	1	0.51	0.26	0.07	2ntzsd2w869g8	sqlplus@stade50 (TNS V1-V3)	begin :bid := DBMS_WO...
0	14	119	0.00	0.24	1.86	g734cwcxrsj68	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
0	6	23	0.02	0.22	0.82	6ssrk2dqj7jbx		select job, nvl2(last_date, ...
0	11	103	0.00	0.21	1.42	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
0	6	1	0.31	0.16	0.84	0shksdzxpp4bh		select snap_interval, retenti...

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: 368,649
Captured SQL account for 10.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
19,980	0		5.42	3.17	3.19	48jvprb98hg2c	sqlplus@stade50 (TNS V1-V3)	begin :eid := DBMS_WO...
6,725	2,482	2.71	1.82	0.18	6.11	96g93hntrzjtr		select /+ rule / bucket_cnt,...
3,505	1	3,505.00	0.95	0.51	0.53	2ntzsd2w869g8	sqlplus@stade50 (TNS V1-V3)	begin :bid := DBMS_WO...
2,563	547	4.69	0.70	0.04	0.04	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
1,606	492	3.26	0.44	0.09	0.12	9tgj4g8y4rwy8		select type#, blocks, extents,...
1,377	103	13.37	0.37	0.40	10.58	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
1,334	641	2.08	0.36	0.18	0.37	db78fxqxwxt7r		select /+ rule / bucket, en...
1,273	76	16.75	0.35	0.02	0.03	a73wbv1yu8x5c		select con#, type#, condlength...
1,250	19	65.79	0.34	0.19	0.20	130dvvr5s8bgn		select obj#, dataobj#, part#...
1,248	128	9.75	0.34	0.13	0.66	5n1fs4m2n2y0r		select pos#, intcol#, col#, sp...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 1,412
Captured SQL account for 36.6% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
402	0		28.47	3.17	3.19	48jvprb98hg2c	sqlplus@stade50 (TNS V1-V3)	begin :eid := DBMS_WO...
272	1	272.00	19.26	0.51	0.53	2ntzsd2w869g8	sqlplus@stade50 (TNS V1-V3)	begin :bid := DBMS_WO...
96	641	0.15	6.80	0.18	0.37	db78fxqxwxt7r		select /+ rule / bucket, en...
73	10	7.30	5.17	0.02	0.02	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
46	23	2.00	3.26	0.43	6.10	6ssrk2dqj7jbx		select job, nvl2(last_date, ...
38	93	0.41	2.69	0.25	5.76	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
32	2,482	0.01	2.27	0.18	6.11	96g93hntrzjtr		select /+ rule / bucket_cnt,...
27	1	27.00	1.91	0.19	0.20	8hfqt6v8rh09t		INSERT INTO WRH$_ACTIVE_SESSIO...
23	246	0.09	1.63	0.12	0.25	04xtrk7uyhknh		select obj#, type#, ctime, mti...
20	20	1.00	1.42	0.21	0.21	209fr01svbb5s		update sys.aud$ set action#=:2...
20	103	0.19	1.42	0.40	10.58	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
15	492	0.03	1.06	0.09	0.12	9tgj4g8y4rwy8		select type#, blocks, extents,...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 211,260
Captured SQL account for 5.6% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
2,482	1,693	0.68	0.00	96g93hntrzjtr		select /+ rule / bucket_cnt,...
641	10,273	16.03	0.00	db78fxqxwxt7r		select /+ rule / bucket, en...
547	725	1.33	0.00	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
492	492	1.00	0.00	9tgj4g8y4rwy8		select type#, blocks, extents,...
246	244	0.99	0.00	04xtrk7uyhknh		select obj#, type#, ctime, mti...
180	165	0.92	0.00	87gaftwrm2h68		select o.owner#, o.name, o.nam...
180	88	0.49	0.00	asvzxj61dc5vs		select timestamp, flags from ...
128	364	2.84	0.01	5n1fs4m2n2y0r		select pos#, intcol#, col#, sp...
120	0	0.00	0.00	0ac5j0ty071sk	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
120	0	0.00	0.00	10tvawjdzu21z	stage2@stade50 (TNS V1-V3)	update employees set salary = ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 207,561
Captured SQL account for 3.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
492	492	0.24	9tgj4g8y4rwy8		select type#, blocks, extents,...
180	180	0.09	asvzxj61dc5vs		select timestamp, flags from ...
120	120	0.06	0ac5j0ty071sk	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
120	120	0.06	10tvawjdzu21z	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
120	120	0.06	179c02qf111rn	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
120	120	0.06	218a4b5jx5190	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
120	120	0.06	2gqwcuh54g2bv	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
120	120	0.06	3n168h7drh0tm	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
120	120	0.06	44pvxff93w0sh	stage2@stade50 (TNS V1-V3)	update employees set salary = ...
120	120	0.06	45f88tztm63d4	stage2@stade50 (TNS V1-V3)	update employees set salary = ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

07azhqtn52srv update employees set salary = 137960796 where employee_id = 137961116

0ac5j0ty071sk update employees set salary = 137959432 where employee_id = 137959752

0h0nc9r7bdb7w update employees set salary = 137967216 where employee_id = 137967536

0shksdzxpp4bh select snap_interval, retention, most_recent_snap_time, most_recent_snap_id, status_flag, most_recent_purge_time, most_recent_split_id, most_recent_split_time, mrct_snap_time_num, mrct_purge_time_num, snapint_num, retention_num, swrf_version, registration_status, mrct_baseline_id, topnsql, mrct_bltmpl_id from wrm$_wr_control where dbid = :dbid

10tvawjdzu21z update employees set salary = 137964588 where employee_id = 137964908

130dvvr5s8bgn select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part#

179c02qf111rn update employees set salary = 137968476 where employee_id = 137968796

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# (+)

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

218a4b5jx5190 update employees set salary = 137968336 where employee_id = 137968656

2gqwcuh54g2bv update employees set salary = 137959396 where employee_id = 137959716

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#

3n168h7drh0tm update employees set salary = 137958900 where employee_id = 137959220

44pvxff93w0sh update employees set salary = 137959484 where employee_id = 137959804

45f88tztm63d4 update employees set salary = 137964500 where employee_id = 137964820

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

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

5n1fs4m2n2y0r select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1

5y1qzjy5qbdmc update employees set salary = 137967764 where employee_id = 137968084

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

7k7hxybq0sdzx update employees set salary = 137963128 where employee_id = 137963448

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#

7r049cf0btb8k select employee_id, last_name from employees where employee_id > 146 order by employee_id

7tywa5jy10pup update employees set salary = 137963804 where employee_id = 137964124

80n8t2qzbdf7s update employees set salary = 137962720 where employee_id = 137963040

87gaftwrm2h68 select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1

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

94qqkq26xrrfy update employees set salary = 137958060 where employee_id = 137958380

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

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

a2x710cg44pyy update employees set salary = 137969044 where employee_id = 137969364

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

asvzxj61dc5vs select timestamp, flags from fixed_obj$ where obj#=:1

d9ux3b861xqr8 update employees set salary = 137963920 where employee_id = 137964240

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

g734cwcxrsj68 update employees set salary = 137966588 where employee_id = 137966908

SQL Id	SQL Text
04xtrk7uyhknh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
07azhqtn52srv	update employees set salary = 137960796 where employee_id = 137961116
0ac5j0ty071sk	update employees set salary = 137959432 where employee_id = 137959752
0h0nc9r7bdb7w	update employees set salary = 137967216 where employee_id = 137967536
0shksdzxpp4bh	select snap_interval, retention, most_recent_snap_time, most_recent_snap_id, status_flag, most_recent_purge_time, most_recent_split_id, most_recent_split_time, mrct_snap_time_num, mrct_purge_time_num, snapint_num, retention_num, swrf_version, registration_status, mrct_baseline_id, topnsql, mrct_bltmpl_id from wrm$_wr_control where dbid = :dbid
10tvawjdzu21z	update employees set salary = 137964588 where employee_id = 137964908
130dvvr5s8bgn	select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part#
179c02qf111rn	update employees set salary = 137968476 where employee_id = 137968796
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# (+)
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
218a4b5jx5190	update employees set salary = 137968336 where employee_id = 137968656
2gqwcuh54g2bv	update employees set salary = 137959396 where employee_id = 137959716
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#
3n168h7drh0tm	update employees set salary = 137958900 where employee_id = 137959220
44pvxff93w0sh	update employees set salary = 137959484 where employee_id = 137959804
45f88tztm63d4	update employees set salary = 137964500 where employee_id = 137964820
48jvprb98hg2c	begin :eid := DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5n1fs4m2n2y0r	select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
5y1qzjy5qbdmc	update employees set salary = 137967764 where employee_id = 137968084
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
7k7hxybq0sdzx	update employees set salary = 137963128 where employee_id = 137963448
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#
7r049cf0btb8k	select employee_id, last_name from employees where employee_id > 146 order by employee_id
7tywa5jy10pup	update employees set salary = 137963804 where employee_id = 137964124
80n8t2qzbdf7s	update employees set salary = 137962720 where employee_id = 137963040
87gaftwrm2h68	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
8hfqt6v8rh09t	INSERT INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial# , current_obj#, current_file#, current_block#, current_row# , consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial# , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
94qqkq26xrrfy	update employees set salary = 137958060 where employee_id = 137958380
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
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
a2x710cg44pyy	update employees set salary = 137969044 where employee_id = 137969364
a73wbv1yu8x5c	select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1
asvzxj61dc5vs	select timestamp, flags from fixed_obj$ where obj#=:1
d9ux3b861xqr8	update employees set salary = 137963920 where employee_id = 137964240
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
g734cwcxrsj68	update employees set salary = 137966588 where employee_id = 137966908

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	1,431	11.72	143.10
CPU used by this session	17,010	139.33	1,701.00
CPU used when call started	16,672	136.57	1,667.20
CR blocks created	0	0.00	0.00
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	71,646	586.88	7,164.60
DBWR checkpoint buffers written	27	0.22	2.70
DBWR checkpoints	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	18	0.15	1.80
DBWR undo block writes	49	0.40	4.90
Effective IO time	0	0.00	0.00
HSC Heap Segment Block Changes	320	2.62	32.00
Heap Segment Array Inserts	76	0.62	7.60
Heap Segment Array Updates	9	0.07	0.90
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	0	0.00	0.00
IMU Redo allocation size	0	0.00	0.00
IMU commits	0	0.00	0.00
IMU contention	0	0.00	0.00
IMU pool not allocated	192,033	1,573.01	19,203.30
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	0	0.00	0.00
IMU- failed to get a private strand	192,033	1,573.01	19,203.30
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	0	0.00	0.00
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	261,429	2,141.46	26,142.90
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	41	0.34	4.10
application wait time	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	463	3.79	46.30
branch node splits	0	0.00	0.00
buffer is not pinned count	452,261	3,704.63	45,226.10
buffer is pinned count	127,352	1,043.18	12,735.20
bytes received via SQL*Net from client	55,508,577	454,690.18	5,550,857.70
bytes sent via SQL*Net to client	40,090,146	328,392.41	4,009,014.60
calls to get snapshot scn: kcmgss	212,791	1,743.05	21,279.10
calls to kcmgas	204	1.67	20.40
calls to kcmgcs	28	0.23	2.80
calls to kcmgrs	387,999	3,178.24	38,799.90
change write time	6	0.05	0.60
cleanout - number of ktugct calls	44	0.36	4.40
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	2	0.02	0.20
cluster key scan block gets	1,260	10.32	126.00
cluster key scans	1,194	9.78	119.40
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	3	0.02	0.30
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	317	2.60	31.70
commit cleanouts successfully completed	314	2.57	31.40
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	21	0.17	2.10
concurrency wait time	50,668	415.04	5,066.80
consistent changes	4	0.03	0.40
consistent gets	366,550	3,002.54	36,655.00
consistent gets - examination	203,335	1,665.59	20,333.50
consistent gets direct	0	0.00	0.00
consistent gets from cache	366,550	3,002.54	36,655.00
consistent gets from cache (fastpath)	160,196	1,312.22	16,019.60
cursor authentications	2,480	20.31	248.00
data blocks consistent reads - undo records applied	0	0.00	0.00
db block changes	2,100	17.20	210.00
db block gets	2,099	17.19	209.90
db block gets direct	0	0.00	0.00
db block gets from cache	2,099	17.19	209.90
db block gets from cache (fastpath)	574	4.70	57.40
deferred (CURRENT) block cleanout applications	195	1.60	19.50
dirty buffers inspected	184	1.51	18.40
enqueue conversions	25	0.20	2.50
enqueue releases	198,963	1,629.78	19,896.30
enqueue requests	198,963	1,629.78	19,896.30
enqueue timeouts	0	0.00	0.00
enqueue waits	0	0.00	0.00
exchange deadlocks	0	0.00	0.00
execute count	211,260	1,730.50	21,126.00
free buffer inspected	1,621	13.28	162.10
free buffer requested	1,582	12.96	158.20
heap block compress	3	0.02	0.30
hot buffers moved to head of LRU	292	2.39	29.20
immediate (CR) block cleanout applications	2	0.02	0.20
immediate (CURRENT) block cleanout applications	46	0.38	4.60
index crx upgrade (found)	24	0.20	2.40
index crx upgrade (positioned)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fetch by key	196,510	1,609.68	19,651.00
index scans kdiixs1	6,296	51.57	629.60
leaf node 90-10 splits	15	0.12	1.50
leaf node splits	20	0.16	2.00
lob reads	0	0.00	0.00
lob writes	1	0.01	0.10
lob writes unaligned	1	0.01	0.10
logons cumulative	20	0.16	2.00
messages received	90	0.74	9.00
messages sent	90	0.74	9.00
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	160,323	1,313.26	16,032.30
opened cursors cumulative	211,259	1,730.50	21,125.90
parse count (failures)	0	0.00	0.00
parse count (hard)	5,759	47.17	575.90
parse count (total)	207,561	1,700.20	20,756.10
parse time cpu	6,148	50.36	614.80
parse time elapsed	57,675	472.44	5,767.50
physical read IO requests	679	5.56	67.90
physical read bytes	11,567,104	94,750.20	1,156,710.40
physical read total IO requests	1,176	9.63	117.60
physical read total bytes	19,685,376	161,249.80	1,968,537.60
physical read total multi block requests	27	0.22	2.70
physical reads	1,412	11.57	141.20
physical reads cache	1,412	11.57	141.20
physical reads cache prefetch	733	6.00	73.30
physical reads direct	0	0.00	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	139	1.14	13.90
physical write bytes	1,417,216	11,608.91	141,721.60
physical write total IO requests	284	2.33	28.40
physical write total bytes	3,643,392	29,844.30	364,339.20
physical write total multi block requests	2	0.02	0.20
physical writes	173	1.42	17.30
physical writes direct	0	0.00	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	173	1.42	17.30
physical writes non checkpoint	144	1.18	14.40
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	339,277	2,779.14	33,927.70
recursive cpu usage	5,543	45.40	554.30
redo blocks checksummed by FG (exclusive)	1,215	9.95	121.50
redo blocks read for recovery	0	0.00	0.00
redo blocks read total	0	0.00	0.00
redo blocks written	1,916	15.69	191.60
redo blocks written for direct writes	0	0.00	0.00
redo buffer allocation retries	0	0.00	0.00
redo entries	1,863	15.26	186.30
redo entries for lost write detection	656	5.37	65.60
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	78	0.64	7.80
redo size	1,004,228	8,225.98	100,422.80
redo size for lost write detection	54,636	447.54	5,463.60
redo subscn max counts	187	1.53	18.70
redo synch time	7	0.06	0.70
redo synch writes	41	0.34	4.10
redo wastage	15,000	122.87	1,500.00
redo write time	18	0.15	1.80
redo writer latching time	0	0.00	0.00
redo writes	69	0.57	6.90
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	0	0.00	0.00
rows fetched via callback	2,947	24.14	294.70
session connect time	0	0.00	0.00
session cursor cache hits	13,580	111.24	1,358.00
session logical reads	368,649	3,019.73	36,864.90
shared hash latch upgrades - no wait	2,689	22.03	268.90
shared hash latch upgrades - wait	24	0.20	2.40
sorts (disk)	0	0.00	0.00
sorts (memory)	1,170	9.58	117.00
sorts (rows)	17,380	142.37	1,738.00
sql area evicted	5,094	41.73	509.40
sql area purged	0	0.00	0.00
summed dirty queue length	143	1.17	14.30
switch current to new buffer	34	0.28	3.40
table fetch by rowid	155,789	1,276.12	15,578.90
table fetch continued row	71	0.58	7.10
table scan blocks gotten	1,041	8.53	104.10
table scan rows gotten	18,645	152.73	1,864.50
table scans (long tables)	1	0.01	0.10
table scans (short tables)	61	0.50	6.10
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	0	0.00	0.00
undo change vector size	321,404	2,632.73	32,140.40
user I/O wait time	6	0.05	0.60
user calls	458,270	3,753.85	45,827.00
user commits	10	0.08	1.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	563	4.61	56.30
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session pga memory max	619,106,728	619,172,264
session cursor cache count	739,039	740,035
session uga memory	1,546,899,791,628	1,546,900,721,836
opened cursors current	142	142
logons current	59	59
session uga memory max	6,270,625,072	6,279,203,868
session pga memory	512,921,380	509,430,944

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

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
SYSTEM	373	3	0.13	2.93	2	0
SYSAUX	257	2	0.12	1.05	93	1
UD1	11	0	0.00	1.00	44	0

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
SYSAUX	/ade/jacao_15v/oracle/dbs/t_ax1.f	257	2	0.12	1.05	93	1
SYSTEM	/ade/jacao_15v/oracle/dbs/t_db1.f	373	3	0.13	2.93	2	0
UD1	/ade/jacao_15v/oracle/dbs/t_undo1.f	11	0	0.00	1.00	44	0

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	365,845	1,403	173	0	0	0

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	168	1068	23667	46080	23667
E	0	16	379	2226	25634	46080	25634

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	704,959
D	8	0.50	996	1.30	510,008
D	12	0.75	1,494	1.15	450,298
D	16	1.00	1,992	1.00	392,963
D	20	1.25	2,490	0.95	372,721
D	24	1.50	2,988	0.92	362,750
D	28	1.75	3,486	0.91	355,641
D	32	2.00	3,984	0.87	342,852

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	110.31	0.00	0.00	0.00	0.00	5,939
E	29	4	107.17	0.00	0.00	0.00	0.00	5,939

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs	M-Pass Execs
2K	4K	534	534	0	0
512K	1024K	12	12	0	0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
15	0.50	2,579.34	195.85	93.00	22	126,251
22	0.75	2,579.34	195.85	93.00	22	126,251
29	1.00	2,579.34	43.65	98.00	22	119,327
35	1.20	2,579.34	43.65	98.00	21	119,327
41	1.40	2,579.34	43.65	98.00	21	119,327
46	1.60	2,579.34	43.65	98.00	18	119,327
52	1.80	2,579.34	43.65	98.00	18	119,327
58	2.00	2,579.34	43.65	98.00	18	119,327
87	3.00	2,579.34	38.51	99.00	0	119,094
116	4.00	2,579.34	38.51	99.00	0	119,094
174	6.00	2,579.34	38.51	99.00	0	119,094
232	8.00	2,579.34	0.00	100.00	0	117,341

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
56	0.61	6	559	48,450	0.39	78,270	25.95	426
68	0.74	18	1,298	86,580	0.70	40,140	13.31	1,081
80	0.87	30	2,304	120,069	0.97	6,651	2.21	1,354
92	1.00	42	3,818	123,704	1.00	3,016	1.00	1,372
104	1.13	54	5,185	124,780	1.01	1,940	0.64	1,376
116	1.26	66	6,266	125,605	1.02	1,115	0.37	1,379
128	1.39	78	7,000	128,867	1.04	1	0.00	1,382
140	1.52	90	8,063	131,311	1.06	1	0.00	1,384
152	1.65	102	9,087	131,328	1.06	1	0.00	1,385
164	1.78	114	10,079	131,677	1.06	1	0.00	1,387
176	1.91	126	10,986	131,968	1.07	1	0.00	1,389
188	2.04	138	11,759	132,024	1.07	1	0.00	1,391

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

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

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	76	0.00		0	0
ASM map operation hash table	1	0.00		0	0
AWR Alerted Metric Element list	854	0.00		0	0
Change Notification Hash table latch	39	0.00		0	0
Consistent RBA	69	0.00		0	0
DML lock allocation	384,330	0.42	0.01	0	0
Event Group Locks	21	0.00		0	0
FOB s.o list latch	19	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	1	0.00		0	192,033	0.23
JS Sh mem access	1	0.00		0	0
JS queue access latch	1	0.00		0	0
JS queue state obj latch	690	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	41	0.00		0	0
KTF sga latch	1	0.00		0	36	0.00
Locator state objects pool parent latch	1	0.00		0	0
MQL Tracking Latch	0			0	2	0.00
Memory Management Latch	1	0.00		0	41	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	521	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	61	0.00		0	0
OS process allocation	80	0.00		0	0
OS process: request allocation	40	0.00		0	0
PL/SQL warning settings	23	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	8	0.00		0	0
SGA IO buffer pool latch	10	0.00		0	10	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	83	0.00		0	38	0.00
SQL memory manager workarea list latch	8,278	0.00		0	0
Shared B-Tree	5	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	71	0.00		0	0
active service list	332	0.00		0	43	0.00
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	44	0.00		0	0
cache buffers chains	379,945	3.69	0.00	0	2,484	0.00
cache buffers lru chain	1,949	0.00		0	1,033	0.00
cache table scan latch	75	0.00		0	75	0.00
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	41	0.00		0	0
channel operations parent latch	678	0.00		0	0
checkpoint queue latch	1,082	0.00		0	350	0.00
client/application info	141	0.00		0	0
commit callback allocation	1	0.00		0	0
compile environment latch	20	0.00		0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	2	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	2	0.00		0	0
dml lock allocation	2	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	41	0.00		0	0
enqueue hash chains	397,842	2.32	0.00	0	0
enqueues	13,321	0.22	0.66	0	0
fifth spare latch	1	0.00		0	0
file cache latch	12	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	19,756	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	2	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	31,140	0.14	0.95	1	0
kokc descriptor allocation latch	2	0.00		0	0
ksfv messages	1	0.00		0	0
kss move lock	1	0.00		0	0
ksuosstats global area	11	0.00		0	0
ksv allocation latch	2	0.00		0	0
ksv class latch	1	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	40	0.00		0	0
ktm global data	2	0.00		0	0
kwqbsn:qsga	4	0.00		0	0
lgwr LWN SCN	97	0.00		0	0
library cache load lock	662	0.15	0.00	0	0
list of block allocation	53	0.00		0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	3	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	1,188	0.00		0	0
mostly latch-free SCN	97	0.00		0	0
msg queue latch	1	0.00		0	0
multiblock read objects	162	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	2	0.00		0	0
object queue header heap	92	0.00		0	43	0.00
object queue header operation	3,947	0.00		0	0
object stats modification	5	0.00		0	0
parallel query alloc buffer	17	0.00		0	0
parallel query stats	1	0.00		0	0
parameter table management	40	0.00		0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
pesom_heap_alloc	1	0.00		0	0
post/wait queue	36	0.00		0	24	0.00
process allocation	40	0.00		0	20	0.00
process group creation	40	0.00		0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qmn task queue latch	16	0.00		0	0
queued dump request	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	192,297	3.39	0.00	0	1,786	0.00
redo copy	1	0.00		0	1,786	0.00
redo writing	359	0.00		0	0
resmgr group change latch	20	0.00		0	0
resmgr:active threads	41	0.00		0	0
resmgr:actses change group	21	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	40	0.00		0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	1	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	581,868	1.38	0.55	116	1,930	3.16
second spare latch	1	0.00		0	0
sequence cache	69	0.00		0	0
session allocation	504,926	3.81	0.02	4	0
session idle bit	1,113,635	0.08	0.00	0	0
session queue latch	1	0.00		0	0
session switching	3	0.00		0	0
session timer	43	0.00		0	0
shared pool	458,602	2.17	0.21	29	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	316,054	0.02	0.06	0	0
sim partition latch	1	0.00		0	0
simulator hash latch	58,713	0.00		0	0
simulator lru latch	58,509	0.33	0.00	0	92	0.00
sort extent pool	3	0.00		0	0
space background task latch	93	1.08	1.00	0	80	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	2	0.00		0	0
transaction allocation	46	0.00		0	0
transaction branch allocation	43	0.00		0	0
undo global data	454	0.00		0	0
user lock	80	0.00		0	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
session allocation	504,926	19,260	411	18,902
cache buffers chains	379,945	14,035	34	14,003
shared pool	458,602	9,935	2,042	8,087
enqueue hash chains	397,842	9,248	17	9,232
row cache objects	581,868	8,018	4,401	4,462
redo allocation	192,297	6,520	1	6,519
DML lock allocation	384,330	1,627	9	1,618
session idle bit	1,113,635	920	1	919
shared pool simulator	316,054	50	3	47
kks stats	31,140	43	41	4
enqueues	13,321	29	19	10
space background task latch	93	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	9	1
PC and Classifier lists for WLM	No latch	1	0
cache buffers chains	kcbgtcr: fast path	44	29
enqueue hash chains	ksqrcl	13	2
enqueue hash chains	ksqgtl3	4	15
enqueues	ksqdel	10	7
enqueues	ksqgel: create enqueue	9	12
kks stats	kksAllocChildStat	41	41
redo allocation	kcrf_pvt_strand_bind	1	1
row cache objects	kqreqd: reget	3,342	67
row cache objects	kqrpre: find obj	929	3,605
row cache objects	kqreqd	70	680
row cache objects	kqrso	1	0
session allocation	ksuxds: not user session	265	51
session allocation	ksuprc	57	0
session allocation	ksucri	45	360
session allocation	ksudlc	44	0
session idle bit	ksupuc: set busy	1	0
shared pool	kghupr1	1,027	1,256
shared pool	kghalo	583	457
shared pool	kghalp	353	256
shared pool	kghfre	58	5
shared pool	kghfrunp: clatch: nowait	45	0
shared pool	kghfrunp: clatch: wait	14	49
shared pool	kghfrunp: alloc: wait	12	12
shared pool	kgh_heap_sizes	9	56
shared pool simulator	kglsim_unpin_simhp	2	0
shared pool simulator	kglsim_upd_newhp	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: 368,649
Captured Segments account for 97.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
HR	SYSTEM	EMP_EMP_ID_PK	INDEX	260,640	70.70
HR	SYSTEM	EMPLOYEES	TABLE	69,168	18.76
SYS	SYSTEM	CDEF$	TABLE	18,848	5.11
SYS	SYSTEM	I_HH_OBJ#_INTCOL#	INDEX	2,016	0.55
SYS	SYSTEM	HIST_HEAD$	TABLE	976	0.26

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 1,412
Captured Segments account for 84.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	TAB$	TABLE	809	57.29
SYS	SYSTEM	HISTGRM$	TABLE	94	6.66
SYS	SYSTEM	IDL_UB2$	TABLE	64	4.53
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	45	3.19
SYS	SYSAUX	WRH$_SQL_PLAN_PK	INDEX	31	2.20

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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	6	16.67	2	1
dc_database_links	40	0.00	0	0
dc_free_extents	2	100.00	0	0
dc_global_oids	4	0.00	0	0
dc_histogram_data	968	65.08	0	292
dc_histogram_defs	14,063	11.32	0	1,022
dc_objects	126,890	0.17	0	331
dc_profiles	20	0.00	0	0
dc_rollback_segments	44	0.00	0	23
dc_segments	38,997	0.67	8	267
dc_tablespaces	870	0.34	0	3
dc_users	12,198	0.01	0	4
global database name	98	0.00	0	1

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	7	0.00	10	10.00	1	0
CLUSTER	135	0.74	95	1.05	0	0
INDEX	9	100.00	9	100.00	0	0
SQL AREA	199,497	1.94	232,455	7.40	3,830	38
TABLE/PROCEDURE	12,882	0.79	29,220	1.06	45	0
TRIGGER	4,616	0.02	4,616	0.24	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	99.03		1.65	2.98	22	22	60	60
	Freeable	9.63	0.00	0.88	0.51	2		11	11
	SQL	1.52	0.81	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.36		1.54	2.80	22	22	60	60
	Freeable	13.13	0.00	1.09	0.90	3		12	12
	SQL	1.55	0.82	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	4.95	7.04	42.12
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGL buckets	3.00	3.00	0.00
shared	KGL handle	1.79	1.20	-33.01
shared	KGLS heap	2.92	1.23	-57.98
shared	KQR M PO	1.66		-100.00
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	PCursor	4.92	4.07	-17.22
shared	PL/SQL MPCODE	1.76		-100.00
shared	event statistics per sess	1.06	1.06	0.00
shared	free memory	5.49	8.16	48.62
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kglsim object batch	1.21	1.21	0.00
shared	kse signatures	1.83	1.83	0.00
shared	message pool freequeue	1.11	1.11	0.00
shared	obj stats allocation chun	1.90	1.90	0.00
shared	returns from metrics req	0.95	0.95	0.00
shared	row cache	3.61	3.61	0.00
shared	sessions	1.14	1.14	0.00
shared	sql area	16.23	19.28	18.78
	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 %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.62	In-memory Sort %:	100.00
Library Hit %:	93.42	Soft Parse %:	97.23
Execute to Parse %:	1.75	Latch Hit %:	98.45
Parse CPU to Parse Elapsd %:	0.00	% Non-Parse CPU:	68.22