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: 347 04-Aug-08 11:43:44 59 2.4

End Snap: 348 04-Aug-08 11:47:27 59 2.4

Elapsed: 3.71 (mins)

DB Time: 11.17 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	347	04-Aug-08 11:43:44	59	2.4
End Snap:	348	04-Aug-08 11:47:27	59	2.4
Elapsed:		3.71 (mins)
DB Time:		11.17 (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): 3.0 67.0 0.00 0.00

DB CPU(s): 1.4 31.9 0.00 0.00

Redo size: 25,208.7 561,622.8

Logical reads: 1,888.8 42,079.5

Block changes: 138.1 3,076.6

Physical reads: 19.7 439.8

Physical writes: 1.9 41.3

User calls: 2,102.1 46,831.5

Parses: 992.2 22,106.1

Hard parses: 11.3 252.6

W/A MB processed: 46,514.3 1,036,288.0

Logons: 10.8 240.0

Executes: 995.7 22,182.1

Rollbacks: 0.0 0.0

Transactions: 0.0

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	3.0	67.0	0.00	0.00
DB CPU(s):	1.4	31.9	0.00	0.00
Redo size:	25,208.7	561,622.8
Logical reads:	1,888.8	42,079.5
Block changes:	138.1	3,076.6
Physical reads:	19.7	439.8
Physical writes:	1.9	41.3
User calls:	2,102.1	46,831.5
Parses:	992.2	22,106.1
Hard parses:	11.3	252.6
W/A MB processed:	46,514.3	1,036,288.0
Logons:	10.8	240.0
Executes:	995.7	22,182.1
Rollbacks:	0.0	0.0
Transactions:	0.0

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.91 Redo NoWait %: 100.00

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

Library Hit %: 97.06 Soft Parse %: 98.86

Execute to Parse %: 0.34 Latch Hit %: 99.16

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

Shared Pool Statistics

Begin End

Memory Usage %: 87.71 92.31

% SQL with executions>1: 62.96 94.67

% Memory for SQL w/exec>1: 54.11 93.14

	Begin	End
Memory Usage %:	87.71	92.31
% SQL with executions>1:	62.96	94.67
% Memory for SQL w/exec>1:	54.11	93.14

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		318		47.50
library cache: mutex X	26,802	227	8	33.86	Concurrency
log file sync	3,908	64	16	9.55	Commit
latch: row cache objects	1,754	55	32	8.25	Concurrency
latch: shared pool	2,252	24	11	3.56	Concurrency

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

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

0.54 19.20 54.7 42.7 0.2 2.6

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.54	19.20	54.7	42.7	0.2	2.6

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

71.5 73.4 0.0

Memory Statistics

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

Begin End

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

SGA use (MB): 163.6 163.6

PGA use (MB): 101.5 101.6

% Host Mem used for SGA+PGA: 13.09 13.09

	Begin	End
Host Mem (MB):	2,025.5	2,025.5
SGA use (MB):	163.6	163.6
PGA use (MB):	101.5	101.6
% Host Mem used for SGA+PGA:	13.09	13.09

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

Statistic Name	Time (s)	% of DB Time
DB CPU	318.46	47.50
connection management call elapsed time	307.90	45.93
parse time elapsed	244.88	36.53
sql execute elapsed time	104.58	15.60
hard parse elapsed time	96.09	14.33
PL/SQL compilation elapsed time	0.13	0.02
PL/SQL execution elapsed time	0.13	0.02
repeated bind elapsed time	0.05	0.01
hard parse (bind mismatch) elapsed time	0.00	0.00
hard parse (sharing criteria) elapsed time	0.00	0.00
DB time	670.37
background elapsed time	39.29
background cpu time	2.99

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	43,821
IDLE_TIME	1,148
IOWAIT_TIME	80
NICE_TIME	0
SYS_TIME	19,196
USER_TIME	24,577
LOAD	1	19
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:43:44	0.54
04-Aug 11:47:27	19.20	97.45	54.65	42.69	0.18	2.55

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 107.5% of Total DB time 670.37 (s)
Total FG Wait Time: 402.04 (s) DB CPU time: 318.46 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			318		47.50
Concurrency	31,451	86	316	10	47.18
Commit	3,908	0	64	16	9.55
Other	978	0	14	15	2.13
User I/O	4,489	0	5	1	0.69
Network	266,714	0	3	0	0.42
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	26,802	100	227	8	2,680.20	33.86
log file sync	3,908	0	64	16	390.80	9.55
latch: row cache objects	1,754	0	55	32	175.40	8.25
latch: shared pool	2,252	0	24	11	225.20	3.56
latch: session allocation	684	0	9	13	68.40	1.30
read by other session	172	0	4	25	17.20	0.64
buffer busy waits	222	0	4	18	22.20	0.60
cursor: pin S wait on X	255	100	4	15	25.50	0.56
latch free	159	0	3	18	15.90	0.44
SQL*Net message to client	266,714	0	3	0	26,671.40	0.42
latch: cache buffers chains	163	0	2	14	16.30	0.34
cursor: pin S	1	100	1	1423	0.10	0.21
latch: enqueue hash chains	131	0	1	9	13.10	0.18
db file sequential read	4,317	0	0	0	431.70	0.05
enq: TX - index contention	3	0	0	27	0.30	0.01
latch: redo allocation	3	0	0	7	0.30	0.00
control file sequential read	456	0	0	0	45.60	0.00
SQL*Net message from client	266,714	0	1,839	7	26,671.40

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	4,271	0	23	5	427.10	59.73
events in waitclass Other	55	20	1	24	5.50	3.37
control file parallel write	73	0	1	15	7.30	2.74
latch: shared pool	6	0	0	21	0.60	0.32
latch: row cache objects	2	0	0	14	0.20	0.07
db file sequential read	64	0	0	0	6.40	0.07
control file sequential read	73	0	0	0	7.30	0.03
rdbms ipc message	4,848	17	4,001	825	484.80
DIAG idle wait	437	100	447	1022	43.70
fbar timer	1	100	300	300018	0.10
smon timer	1	100	300	300016	0.10
Space Manager: slave idle wait	45	100	227	5035	4.50
Streams AQ: qmn slave idle wait	8	0	224	28052	0.80
Streams AQ: qmn coordinator idle wait	15	53	224	14958	1.50
pmon timer	76	96	221	2904	7.60

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	50	46.0	4.0	6.0	22.0	18.0	4.0
SQL*Net message to client	273K	100.0	.0	.0	.0	.0	.0	.0
buffer busy waits	222	12.2	1.8	4.1	15.8	18.9	36.5	10.8
control file parallel write	73	9.6	1.4	1.4	32.9	27.4	16.4	11.0
control file sequential read	529	99.8			.2
cursor: pin S	1								100.0
cursor: pin S wait on X	255					72.2	27.8
db file sequential read	4416	99.6	.1	.1	.1	.0	.1
enq: TX - index contention	3					33.3	33.3	33.3
latch free	180	6.1	2.8	13.9	21.1	18.9	27.8	9.4
latch: cache buffers chains	163	19.6	5.5	11.0	17.2	11.0	25.8	9.8
latch: enqueue hash chains	132	3.0	8.3	15.2	32.6	25.0	9.8	6.1
latch: redo allocation	4			25.0	50.0	25.0
latch: row cache objects	1756	14.7	.7	1.2	4.6	11.3	24.2	43.3	.1
latch: session allocation	715	16.1	6.9	12.0	22.1	18.7	16.5	7.7
latch: shared pool	2307	28.0	4.9	10.1	17.6	19.6	12.9	6.9
library cache: mutex X	26K	95.4	.1	.4	.3	.4	.5	2.7	.1
log file parallel write	4272	47.6	8.2	10.4	13.4	11.4	7.1	1.9
log file sync	3908	10.1	9.0	5.8	14.3	24.4	24.6	11.8
read by other session	172	13.4	1.7	3.5	11.0	22.7	19.2	28.5
DIAG idle wait	439							92.5	7.5
SQL*Net message from client	273K	39.0	5.3	7.6	21.3	18.5	6.6	1.7	.0
Space Manager: slave idle wait	45								100.0
Streams AQ: qmn coordinator idle wait	15			6.7		6.7	13.3	20.0	53.3
Streams AQ: qmn slave idle wait	8								100.0
fbar timer	1								100.0
pmon timer	77	3.9							96.1
rdbms ipc message	4856	9.9	.8	2.4	6.4	11.8	18.1	38.5	12.1
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	669	317	4	415
15v.regress.rdbms.dev.us.oracle.com	0	0	0	0
SYS$BACKGROUND	0	0	0	1

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	4472	5	31438	316	0	0	266714	3
SYS$BACKGROUND	64	0	8	0	0	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
55	2	2,400	0.02	8.22	0h6b2sajwb74n		select privilege#, level from ...
14	3	2,400	0.01	2.13	209fr01svbb5s		update sys.aud$ set action#=:2...
14	5	2,400	0.01	2.12	4vs91dcv7u1p6	sample@stade50 (TNS V1-V3)	insert into sys.aud$( sessioni...
9	1	2,400	0.00	1.30	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
9	2	2,400	0.00	1.27	0k8522rmdzg4k		select privilege# from sysauth...
3	1	2,400	0.00	0.41	5ur69atw3vfhj		select decode(failover_method,...
2	0	2	1.24	0.37	ddwc2t7wr092f		select min(BARRIERSCN) from SY...
2	0	33	0.06	0.30	dj7v93cakvpgc	stage1@stade50 (TNS V1-V3)	select employee_id, last_name...
2	0	120	0.02	0.27	4p3msq7dja6fn	stage1@stade50 (TNS V1-V3)	update employees set salary = ...
2	1	2,400	0.00	0.26	459f3z9u4fb3u		select value$ from props$ wher...

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

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
5	14	2,400	0.00	1.67	2.12	4vs91dcv7u1p6	sample@stade50 (TNS V1-V3)	insert into sys.aud$( sessioni...
3	14	2,400	0.00	0.98	2.13	209fr01svbb5s		update sys.aud$ set action#=:2...
2	9	2,400	0.00	0.60	1.27	0k8522rmdzg4k		select privilege# from sysauth...
2	55	2,400	0.00	0.56	8.22	0h6b2sajwb74n		select privilege#, level from ...
2	2	0		0.48	0.23	48jvprb98hg2c	sqlplus@stade50 (TNS V1-V3)	begin :eid := DBMS_WO...
1	9	2,400	0.00	0.46	1.30	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
1	2	2,400	0.00	0.38	0.26	459f3z9u4fb3u		select value$ from props$ wher...
1	3	2,400	0.00	0.30	0.41	5ur69atw3vfhj		select decode(failover_method,...
0	1	1	0.45	0.14	0.08	2ntzsd2w869g8	sqlplus@stade50 (TNS V1-V3)	begin :bid := DBMS_WO...
0	0	19	0.02	0.09	0.05	130dvvr5s8bgn		select obj#, dataobj#, part#...

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: 420,795
Captured SQL account for 25.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
15,411	2,400	6.42	3.66	3.13	14.25	209fr01svbb5s		update sys.aud$ set action#=:2...
12,670	2,400	5.28	3.01	5.31	14.24	4vs91dcv7u1p6	sample@stade50 (TNS V1-V3)	insert into sys.aud$( sessioni...
11,999	2,400	5.00	2.85	1.91	8.54	0k8522rmdzg4k		select privilege# from sysauth...
9,600	2,400	4.00	2.28	1.20	1.76	459f3z9u4fb3u		select value$ from props$ wher...
8,798	0		2.09	1.53	1.54	48jvprb98hg2c	sqlplus@stade50 (TNS V1-V3)	begin :eid := DBMS_WO...
7,197	2,400	3.00	1.71	0.96	2.72	5ur69atw3vfhj		select decode(failover_method,...
5,490	2,069	2.65	1.30	0.13	0.21	96g93hntrzjtr		select /+ rule / bucket_cnt,...
4,800	2,400	2.00	1.14	1.79	55.09	0h6b2sajwb74n		select privilege#, level from ...
3,232	32	101.00	0.77	0.11	0.16	6gp4u1hphhmd3	stage1@stade50 (TNS V1-V3)	select employee_id, last_name...
3,090	30	103.00	0.73	0.13	0.14	7aam8gxktw429	stage1@stade50 (TNS V1-V3)	select employee_id, last_name...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 4,398
Captured SQL account for 19.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
327	0		7.44	1.53	1.54	48jvprb98hg2c	sqlplus@stade50 (TNS V1-V3)	begin :eid := DBMS_WO...
94	322	0.29	2.14	0.09	0.19	db78fxqxwxt7r		select /+ rule / bucket, en...
77	10	7.70	1.75	0.02	0.02	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
77	1	77.00	1.75	0.28	0.28	8hfqt6v8rh09t		INSERT INTO WRH$_ACTIVE_SESSIO...
55	2,069	0.03	1.25	0.13	0.21	96g93hntrzjtr		select /+ rule / bucket_cnt,...
49	19	2.58	1.11	0.30	0.31	130dvvr5s8bgn		select obj#, dataobj#, part#...
46	2,400	0.02	1.05	3.13	14.25	209fr01svbb5s		update sys.aud$ set action#=:2...
44	1	44.00	1.00	0.45	0.50	2ntzsd2w869g8	sqlplus@stade50 (TNS V1-V3)	begin :bid := DBMS_WO...
43	252	0.17	0.98	0.06	0.12	04xtrk7uyhknh		select obj#, type#, ctime, mti...
41	2	20.50	0.93	0.25	2.48	ddwc2t7wr092f		select min(BARRIERSCN) from SY...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 221,821
Captured SQL account for 11.7% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
2,400	0	0.00	0.02	0h6b2sajwb74n		select privilege#, level from ...
2,400	2,400	1.00	0.00	0k8522rmdzg4k		select privilege# from sysauth...
2,400	2,400	1.00	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
2,400	2,400	1.00	0.01	209fr01svbb5s		update sys.aud$ set action#=:2...
2,400	2,400	1.00	0.00	459f3z9u4fb3u		select value$ from props$ wher...
2,400	2,400	1.00	0.01	4vs91dcv7u1p6	sample@stade50 (TNS V1-V3)	insert into sys.aud$( sessioni...
2,400	2,400	1.00	0.00	5ur69atw3vfhj		select decode(failover_method,...
2,069	1,284	0.62	0.00	96g93hntrzjtr		select /+ rule / bucket_cnt,...
542	720	1.33	0.00	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
490	490	1.00	0.00	9tgj4g8y4rwy8		select type#, blocks, extents,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 221,061
Captured SQL account for 9.9% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
2,400	2,400	1.09	0h6b2sajwb74n		select privilege#, level from ...
2,400	2,400	1.09	0k8522rmdzg4k		select privilege# from sysauth...
2,400	2,400	1.09	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
2,400	2,400	1.09	209fr01svbb5s		update sys.aud$ set action#=:2...
2,400	2,400	1.09	459f3z9u4fb3u		select value$ from props$ wher...
2,400	2,400	1.09	4vs91dcv7u1p6	sample@stade50 (TNS V1-V3)	insert into sys.aud$( sessioni...
2,400	2,400	1.09	5ur69atw3vfhj		select decode(failover_method,...
490	490	0.22	9tgj4g8y4rwy8		select type#, blocks, extents,...
180	180	0.08	asvzxj61dc5vs		select timestamp, flags from ...
120	120	0.05	1k5mzq82mk0w7	stage1@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

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

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#

1k5mzq82mk0w7 update employees set salary = 134795456 where employee_id = 134795776

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

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

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#

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

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

4p3msq7dja6fn update employees set salary = 134792424 where employee_id = 134792744

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

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

6gp4u1hphhmd3 select employee_id, last_name from employees where employee_id > 107 order by employee_id

7aam8gxktw429 select employee_id, last_name from employees where employee_id > 105 order by employee_id

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

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

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

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

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

ddwc2t7wr092f select min(BARRIERSCN) from SYS_FBA_BARRIERSCN

dj7v93cakvpgc select employee_id, last_name from employees where employee_id > 196 order by employee_id

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
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')
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#
1k5mzq82mk0w7	update employees set salary = 134795456 where employee_id = 134795776
209fr01svbb5s	update sys.aud$ set action#=:2, returncode=:3, logoff$time=cast(SYS_EXTRACT_UTC(systimestamp) as date), logoff$pread=:4, logoff$lread=:5, logoff$lwrite=:6, logoff$dead=:7, sessioncpu=:8 where sessionid=:1 and entryid=1 and action#=100
2ntzsd2w869g8	begin :bid := DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;
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#
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
48jvprb98hg2c	begin :eid := DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;
4p3msq7dja6fn	update employees set salary = 134792424 where employee_id = 134792744
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
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6gp4u1hphhmd3	select employee_id, last_name from employees where employee_id > 107 order by employee_id
7aam8gxktw429	select employee_id, last_name from employees where employee_id > 105 order by employee_id
8hfqt6v8rh09t	INSERT INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial# , current_obj#, current_file#, current_block#, current_row# , consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial# , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
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
asvzxj61dc5vs	select timestamp, flags from fixed_obj$ where obj#=:1
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
ddwc2t7wr092f	select min(BARRIERSCN) from SYS_FBA_BARRIERSCN
dj7v93cakvpgc	select employee_id, last_name from employees where employee_id > 196 order by employee_id

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	755	3.39	75.50
CPU used by this session	18,786	84.32	1,878.60
CPU used when call started	18,359	82.41	1,835.90
CR blocks created	61	0.27	6.10
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	62,352	279.87	6,235.20
DBWR checkpoint buffers written	20	0.09	2.00
DBWR checkpoints	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	2	0.01	0.20
DBWR undo block writes	166	0.75	16.60
Effective IO time	0	0.00	0.00
HSC Heap Segment Block Changes	7,401	33.22	740.10
Heap Segment Array Inserts	75	0.34	7.50
Heap Segment Array Updates	5	0.02	0.50
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	2	0.01	0.20
IMU Redo allocation size	18,372	82.46	1,837.20
IMU commits	8	0.04	0.80
IMU contention	0	0.00	0.00
IMU pool not allocated	17	0.08	1.70
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	10,009,960	44,930.23	1,000,996.00
IMU- failed to get a private strand	0	0.00	0.00
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	266,714	1,197.16	26,671.40
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	170	0.76	17.00
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	858	3.85	85.80
branch node splits	0	0.00	0.00
buffer is not pinned count	446,743	2,005.23	44,674.30
buffer is pinned count	128,367	576.18	12,836.70
bytes received via SQL*Net from client	57,592,555	258,507.17	5,759,255.50
bytes sent via SQL*Net to client	45,265,253	203,175.44	4,526,525.30
calls to get snapshot scn: kcmgss	239,982	1,077.17	23,998.20
calls to kcmgas	11,410	51.21	1,141.00
calls to kcmgcs	72	0.32	7.20
calls to kcmgrs	419,598	1,883.39	41,959.80
change write time	463	2.08	46.30
cleanout - number of ktugct calls	255	1.14	25.50
cleanouts and rollbacks - consistent read gets	18	0.08	1.80
cleanouts only - consistent read gets	32	0.14	3.20
cluster key scan block gets	933	4.19	93.30
cluster key scans	891	4.00	89.10
commit batch/immediate performed	1	0.00	0.10
commit batch/immediate requested	1	0.00	0.10
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	19	0.09	1.90
commit cleanout failures: cannot pin	73	0.33	7.30
commit cleanouts	7,452	33.45	745.20
commit cleanouts successfully completed	7,360	33.04	736.00
commit immediate performed	1	0.00	0.10
commit immediate requested	1	0.00	0.10
commit txn count during cleanout	120	0.54	12.00
concurrency wait time	31,638	142.01	3,163.80
consistent changes	97	0.44	9.70
consistent gets	397,142	1,782.59	39,714.20
consistent gets - examination	210,015	942.66	21,001.50
consistent gets direct	0	0.00	0.00
consistent gets from cache	397,142	1,782.59	39,714.20
consistent gets from cache (fastpath)	177,090	794.88	17,709.00
cursor authentications	1,946	8.73	194.60
data blocks consistent reads - undo records applied	84	0.38	8.40
db block changes	30,766	138.09	3,076.60
db block gets	23,653	106.17	2,365.30
db block gets direct	0	0.00	0.00
db block gets from cache	23,653	106.17	2,365.30
db block gets from cache (fastpath)	2,895	12.99	289.50
deferred (CURRENT) block cleanout applications	3,287	14.75	328.70
dirty buffers inspected	307	1.38	30.70
enqueue conversions	47	0.21	4.70
enqueue releases	208,628	936.44	20,862.80
enqueue requests	208,628	936.44	20,862.80
enqueue timeouts	0	0.00	0.00
enqueue waits	3	0.01	0.30
exchange deadlocks	0	0.00	0.00
execute count	221,821	995.66	22,182.10
free buffer inspected	1,369	6.14	136.90
free buffer requested	7,161	32.14	716.10
heap block compress	188	0.84	18.80
hot buffers moved to head of LRU	1,126	5.05	112.60
immediate (CR) block cleanout applications	50	0.22	5.00
immediate (CURRENT) block cleanout applications	57	0.26	5.70
index crx upgrade (found)	29	0.13	2.90
index crx upgrade (positioned)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fetch by key	196,133	880.35	19,613.30
index scans kdiixs1	15,501	69.58	1,550.10
leaf node 90-10 splits	16	0.07	1.60
leaf node splits	23	0.10	2.30
lob reads	0	0.00	0.00
lob writes	1	0.00	0.10
lob writes unaligned	1	0.00	0.10
logons cumulative	2,400	10.77	240.00
messages received	4,296	19.28	429.60
messages sent	4,296	19.28	429.60
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	172,173	772.81	17,217.30
opened cursors cumulative	226,568	1,016.96	22,656.80
parse count (failures)	0	0.00	0.00
parse count (hard)	2,526	11.34	252.60
parse count (total)	221,061	992.24	22,106.10
parse time cpu	4,766	21.39	476.60
parse time elapsed	24,358	109.33	2,435.80
physical read IO requests	4,398	19.74	439.80
physical read bytes	36,028,416	161,715.42	3,602,841.60
physical read total IO requests	4,930	22.13	493.00
physical read total bytes	44,720,128	200,728.62	4,472,012.80
physical read total multi block requests	0	0.00	0.00
physical reads	4,398	19.74	439.80
physical reads cache	4,398	19.74	439.80
physical reads cache prefetch	0	0.00	0.00
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	263	1.18	26.30
physical write bytes	3,383,296	15,186.10	338,329.60
physical write total IO requests	4,690	21.05	469.00
physical write total bytes	12,738,048	57,175.39	1,273,804.80
physical write total multi block requests	6	0.03	0.60
physical writes	413	1.85	41.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	413	1.85	41.30
physical writes non checkpoint	337	1.51	33.70
pinned buffers inspected	2	0.01	0.20
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	505,226	2,267.73	50,522.60
recursive cpu usage	5,189	23.29	518.90
redo blocks checksummed by FG (exclusive)	1,912	8.58	191.20
redo blocks read for recovery	0	0.00	0.00
redo blocks read total	0	0.00	0.00
redo blocks written	13,599	61.04	1,359.90
redo blocks written for direct writes	0	0.00	0.00
redo buffer allocation retries	0	0.00	0.00
redo entries	19,932	89.47	1,993.20
redo entries for lost write detection	4,230	18.99	423.00
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	223	1.00	22.30
redo size	5,616,228	25,208.73	561,622.80
redo size for lost write detection	219,960	987.30	21,996.00
redo subscn max counts	369	1.66	36.90
redo synch time	6,466	29.02	646.60
redo synch writes	4,801	21.55	480.10
redo wastage	945,280	4,242.94	94,528.00
redo write time	2,444	10.97	244.40
redo writer latching time	28	0.13	2.80
redo writes	4,272	19.18	427.20
rollback changes - undo records applied	4	0.02	0.40
rollbacks only - consistent read gets	37	0.17	3.70
rows fetched via callback	2,880	12.93	288.00
session connect time	0	0.00	0.00
session cursor cache hits	7,771	34.88	777.10
session logical reads	420,795	1,888.76	42,079.50
shared hash latch upgrades - no wait	2,652	11.90	265.20
shared hash latch upgrades - wait	29	0.13	2.90
sorts (disk)	0	0.00	0.00
sorts (memory)	5,648	25.35	564.80
sorts (rows)	12,281	55.12	1,228.10
sql area evicted	1,347	6.05	134.70
sql area purged	0	0.00	0.00
summed dirty queue length	308	1.38	30.80
switch current to new buffer	2,363	10.61	236.30
table fetch by rowid	147,843	663.60	14,784.30
table fetch continued row	71	0.32	7.10
table scan blocks gotten	7,347	32.98	734.70
table scan rows gotten	179,029	803.58	17,902.90
table scans (long tables)	0	0.00	0.00
table scans (short tables)	4,822	21.64	482.20
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	1	0.00	0.10
undo change vector size	1,513,484	6,793.35	151,348.40
user I/O wait time	463	2.08	46.30
user calls	468,315	2,102.06	46,831.50
user commits	10	0.04	1.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	459	2.06	45.90
write clones created in background	0	0.00	0.00
write clones created in foreground	1	0.00	0.10

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	612,456,256	612,456,256
session cursor cache count	620,800	738,939
session uga memory	1,542,508,790,840	1,542,604,704,440
opened cursors current	142	142
logons current	59	59
session uga memory max	5,542,950,744	6,268,193,380
session pga memory	505,681,084	506,270,908

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	Buffer Waits	Av Buf Wt(ms)
SYSTEM	4,295	19	0.10	1.00	5	359	20.92
SYSAUX	53	0	0.38	1.00	98	0	0.00
UD1	10	0	0.00	1.00	80	35	18.29

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	Buffer Waits	Av Buf Wt(ms)
SYSAUX	/ade/jacao_15v/oracle/dbs/t_ax1.f	53	0	0.38	1.00	98	0	0.00
SYSTEM	/ade/jacao_15v/oracle/dbs/t_db1.f	4,295	19	0.10	1.00	5	359	20.92
UD1	/ade/jacao_15v/oracle/dbs/t_undo1.f	10	0	0.00	1.00	80	35	18.29

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	99	417,769	4,392	413	0	0	394

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	526	3489	8196	46080	8196
E	0	17	575	17068	20830	46080	20830

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.80	700,100
D	8	0.50	996	1.30	506,010
D	12	0.75	1,494	1.15	446,558
D	16	1.00	1,992	1.00	390,000
D	20	1.25	2,490	0.95	370,240
D	24	1.50	2,988	0.92	360,697
D	28	1.75	3,486	0.91	354,162
D	32	2.00	3,984	0.88	341,667

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	101.50	0.00	0.00	0.00	0.00	5,939
E	29	4	101.63	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	430	430	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,505.72	195.85	93.00	22	122,902
22	0.75	2,505.72	195.85	93.00	22	122,902
29	1.00	2,505.72	43.65	98.00	22	115,978
35	1.20	2,505.72	43.65	98.00	21	115,978
41	1.40	2,505.72	43.65	98.00	21	115,978
46	1.60	2,505.72	43.65	98.00	18	115,978
52	1.80	2,505.72	43.65	98.00	18	115,978
58	2.00	2,505.72	43.65	98.00	18	115,978
87	3.00	2,505.72	38.51	98.00	0	115,744
116	4.00	2,505.72	38.51	98.00	0	115,744
174	6.00	2,505.72	38.51	98.00	0	115,744
232	8.00	2,505.72	0.00	100.00	0	113,992

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	1	187	42,152	0.40	65,082	26.67	103
68	0.74	13	1,314	50,360	0.48	56,874	23.31	761
80	0.87	25	2,021	97,763	0.93	9,471	3.88	1,209
92	1.00	37	3,585	104,794	1.00	2,440	1.00	1,239
104	1.13	49	4,386	105,111	1.00	2,123	0.87	1,242
116	1.26	61	5,382	106,672	1.02	562	0.23	1,246
128	1.39	73	6,774	107,580	1.03	1	0.00	1,248
140	1.52	85	7,512	112,391	1.07	1	0.00	1,251
152	1.65	97	8,415	112,403	1.07	1	0.00	1,252
164	1.78	109	9,598	112,509	1.07	1	0.00	1,253
176	1.91	121	10,244	113,021	1.08	1	0.00	1,255
188	2.04	133	10,993	113,071	1.08	1	0.00	1,257

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	358	7	21
undo header	32	1	18
segment header	1	0	80
undo block	3	0	20

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (index contention)	3	3	0	3	0	26.67

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
3	0.22	2,136	632	6	24.6/24.6	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
04-Aug 11:44	215	2,136	632	6	25	0/0	0/0/0/0/0/0

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	146	0.00		0	0
ASM map operation hash table	1	0.00		0	0
AWR Alerted Metric Element list	1,678	0.00		0	0
Change Notification Hash table latch	74	0.00		0	0
Consistent RBA	4,272	0.02	1.00	0	0
DML lock allocation	393,850	0.26	0.04	1	0
Event Group Locks	2,401	0.00		0	0
FOB s.o list latch	594	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	384,153	0.00		0	192,038	0.27
JS Sh mem access	1	0.00		0	0
JS queue access latch	1	0.00		0	0
JS queue state obj latch	1,350	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	74	0.00		0	0
KTF sga latch	0			0	72	0.00
Locator state objects pool parent latch	1	0.00		0	0
MQL Tracking Latch	0			0	5	0.00
Memory Management Latch	1	0.00		0	74	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	9,090	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	7,201	0.00		0	0
OS process allocation	4,874	0.00		0	0
OS process: request allocation	4,800	0.04	0.50	0	0
PL/SQL warning settings	2,403	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	12	0.00		0	0
SGA IO buffer pool latch	18	0.00		0	18	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	84	0.00		0	73	0.00
SQL memory manager workarea list latch	10,688	0.00		0	0
Shared B-Tree	9	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	95	0.00		0	0
active service list	14,806	0.03	0.75	0	77	0.00
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	80	0.00		0	0
cache buffers chains	513,557	2.44	0.01	2	1,323	0.08
cache buffers lru chain	10,160	0.01	0.00	0	6,089	0.13
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	4,801	0.06	0.67	0	0
channel operations parent latch	8,378	0.00		0	0
checkpoint queue latch	4,220	0.00		0	431	0.00
client/application info	16,801	0.00		0	0
commit callback allocation	1	0.00		0	0
compile environment latch	2,400	0.00		0	0
corrupted undo seg lock	13	0.00		0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	3	0.00		0	0
cv apply list lock	1	0.00		0	0
cv free list lock	1	0.00		0	0
deferred cleanup latch	3	0.00		0	0
dml lock allocation	3	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	4,801	0.12	0.83	0	0
enqueue hash chains	417,215	1.47	0.02	1	0
enqueues	13,622	0.12	0.76	0	0
fifth spare latch	1	0.00		0	0
file cache latch	9	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	2,400	0.00		0	0
global tx hash mapping	1	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	0			0	8,503	0.01
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	1	0.00		0	0
job_queue_processes parameter latch	4	0.00		0	0
k2q lock allocation	1	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kks stats	9,335	0.15	0.93	0	0
kokc descriptor allocation latch	2	0.00		0	0
ksfv messages	1	0.00		0	0
kss move lock	1	0.00		0	0
ksuosstats global area	18	0.00		0	0
ksv allocation latch	3	0.00		0	0
ksv class latch	1	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	4,800	0.13	0.50	0	0
ktm global data	1	0.00		0	0
kwqbsn:qsga	8	0.00		0	0
lgwr LWN SCN	4,271	0.00		0	0
library cache load lock	624	0.00		0	0
list of block allocation	4,829	0.02	1.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	17,126	0.01	0.00	0	0
mostly latch-free SCN	4,282	0.07	1.33	0	0
msg queue latch	1	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	3	0.00		0	0
object queue header heap	114	0.00		0	24	0.00
object queue header operation	17,626	0.00		0	0
object stats modification	3	0.00		0	0
parallel query alloc buffer	29	0.00		0	0
parallel query stats	1	0.00		0	0
parameter table management	4,800	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	6,206	0.00		0	3,921	0.00
process allocation	4,800	0.25	1.75	0	2,400	0.00
process group creation	4,800	0.02	0.00	0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qmn task queue latch	32	3.13	1.00	0	0
queued dump request	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	396,975	0.02	0.05	0	19,892	0.03
redo copy	1	0.00		0	19,895	0.51
redo writing	13,070	0.00		0	0
resmgr group change latch	2,400	0.00		0	0
resmgr:active threads	4,801	0.00		0	0
resmgr:actses change group	2,401	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	4,800	0.10	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	374,452	0.98	0.61	50	1,446	6.02
second spare latch	1	0.00		0	0
sequence cache	7,209	0.00		0	0
session allocation	500,628	2.44	0.06	10	0
session idle bit	1,135,603	0.07	0.04	0	0
session queue latch	1	0.00		0	0
session switching	4	0.00		0	0
session timer	77	0.00		0	0
shared pool	532,771	1.49	0.31	24	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	277,303	0.01	0.23	0	0
sim partition latch	1	0.00		0	0
simulator hash latch	64,813	0.00		0	0
simulator lru latch	64,704	0.24	0.01	0	43	0.00
sort extent pool	4	0.00		0	0
space background task latch	164	0.00		0	148	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	5	0.00		0	0
transaction allocation	4,824	0.00		0	0
transaction branch allocation	77	0.00		0	0
undo global data	15,003	0.01	0.00	0	0
user lock	9,600	0.41	1.03	1	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	513,557	12,544	167	12,386
session allocation	500,628	12,230	745	11,515
shared pool	532,771	7,945	2,431	5,639
enqueue hash chains	417,215	6,127	140	5,995
row cache objects	374,452	3,661	2,226	1,906
DML lock allocation	393,850	1,005	43	963
session idle bit	1,135,603	787	35	752
simulator lru latch	64,704	157	2	155
redo allocation	396,975	81	4	77
user lock	9,600	39	40	0
shared pool simulator	277,303	26	6	20
enqueues	13,622	17	13	6
kks stats	9,335	14	13	1
process allocation	4,800	12	21	0
dummy allocation	4,801	6	5	1
ksz_so allocation latch	4,800	6	3	3
active service list	14,806	4	3	1
channel handle pool latch	4,801	3	2	1
mostly latch-free SCN	4,282	3	4	0
OS process: request allocation	4,800	2	1	1
Consistent RBA	4,272	1	1	0
list of block allocation	4,829	1	1	0
qmn task queue latch	32	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	30	0
DML lock allocation	ktaiam	13	43
OS process: request allocation	kso_new_process	1	1
active service list	ksws_event: ksws event	2	1
active service list	kswsgetso: get service object	1	0
cache buffers chains	kcbgtcr: fast path	108	68
cache buffers chains	kcbgtcr: fast path (cr pin)	73	74
cache buffers chains	kcbzwb	6	4
cache buffers chains	kcbchg1: kslbegin: bufs not pinned	5	2
cache buffers chains	kcbrls_2	5	0
cache buffers chains	kcbgcur_2	3	2
cache buffers chains	kcbnlc	1	4
channel handle pool latch	ksrchconnect()	2	2
cost function	kzulgt: find user res	30	25
cost function	kzulrl	10	15
dummy allocation	ktcscnfy	5	5
enqueue hash chains	ksqrcl	97	12
enqueue hash chains	ksqgtl3	43	128
enqueues	ksqgel: create enqueue	12	12
enqueues	ksqdel	1	1
kks stats	kksAllocChildStat	13	13
ksz_so allocation latch	ksznfy	3	3
list of block allocation	ktcdod	1	2
mostly latch-free SCN	kcs04	2	4
mostly latch-free SCN	kcs05	2	0
mostly latch-free SCN	kcsnew_scn_rba	1	0
process allocation	ksucrp:1	11	0
process allocation	ksuapc	9	21
process allocation	ksudlp	1	0
qmn task queue latch	kwqmnmvtsks: delay to ready list	1	0
redo allocation	kcrf_pvt_strand_unbind	2	0
redo allocation	kcrf_pvt_strand_bind	1	3
redo allocation	kcrfw_redo_gen: redo allocation 1	1	0
row cache objects	kqreqd: reget	1,593	24
row cache objects	kqrpre: find obj	491	1,778
row cache objects	kqreqd	40	337
row cache objects	kqrso	24	4
session allocation	ksuxds: not user session	486	139
session allocation	ksucri	99	584
session allocation	ksuxds: KSUSFCLC not set	87	7
session allocation	ksuprc	26	0
session allocation	ksudlp	23	8
session allocation	ksudlc	21	2
session allocation	ksucrp	3	5
session idle bit	ksupuc: set busy	21	14
session idle bit	ksupuc: clear busy	10	9
session idle bit	ksuxds	4	12
shared pool	kghupr1	1,471	1,592
shared pool	kghalo	663	636
shared pool	kghalp	149	112
shared pool	kghfre	118	31
shared pool	kghfrunp: clatch: nowait	48	0
shared pool	kghfrunp: clatch: wait	30	77
shared pool	kghfrunp: alloc: wait	24	31
shared pool	kgh_heap_sizes	6	29
shared pool simulator	kglsim_unpin_simhp	5	0
shared pool simulator	kglsim_unpin_simhp: fast path	1	6
simulator lru latch	kcbs_simulate: simulate set	2	2

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: 420,795
Captured Segments account for 95.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
HR	SYSTEM	EMP_EMP_ID_PK	INDEX	260,448	61.89
HR	SYSTEM	EMPLOYEES	TABLE	70,000	16.64
SYS	SYSTEM	I_SYSAUTH1	INDEX	17,072	4.06
SYS	SYSTEM	AUD$	TABLE	11,840	2.81
SYS	SYSTEM	PROPS$	TABLE	9,808	2.33

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 4,398
Captured Segments account for 95.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	CDEF$	TABLE	3,915	89.02
SYS	SYSTEM	HISTGRM$	TABLE	92	2.09
SYS	SYSTEM	IDL_UB2$	TABLE	64	1.46
SYS	SYSTEM	HIST_HEAD$	TABLE	36	0.82
SYS	SYSTEM	I_OBJ2	INDEX	17	0.39

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
SYS	SYSTEM	I_AUD1		INDEX	3	100.00

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
SYS	SYSTEM	AUD$		TABLE	160	85.56
SYS	SYSTEM	I_AUD1		INDEX	27	14.44

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	8	12.50	2	1
dc_database_links	4,801	0.00	0	1
dc_free_extents	2	100.00	0	0
dc_global_oids	4	0.00	0	0
dc_histogram_data	633	50.55	0	298
dc_histogram_defs	6,578	19.40	0	1,052
dc_objects	56,307	0.38	0	340
dc_profiles	2,400	0.00	0	1
dc_rollback_segments	22	0.00	0	23
dc_segments	16,510	1.61	3	271
dc_tablespaces	477	0.63	0	3
dc_users	55,370	0.00	0	9
global database name	2,548	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	97	0.00	70	0.00	0	0
INDEX	9	100.00	9	100.00	0	0
SQL AREA	217,739	1.24	242,888	3.06	1,150	21
TABLE/PROCEDURE	7,872	1.31	18,477	1.66	43	0
TRIGGER	2,026	0.00	2,026	0.00	0	0

Memory Statistics

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

Memory Dynamic Components

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

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	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	89.44		1.49	2.79	22	22	60	60
	Freeable	10.50	0.00	0.95	0.63	2		11	11
	SQL	1.42	0.80	0.03	0.05	0	4	50	48
	PL/SQL	0.16	0.04	0.00	0.00	0	0	60	59
E	Other	89.90		1.50	2.79	22	22	60	60
	Freeable	10.06	0.00	0.91	0.63	2		11	11
	SQL	1.53	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	3.68	7.03	91.24
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGL buckets	3.00	3.00	0.00
shared	KGL handle	1.58	1.22	-22.91
shared	KGLS heap	1.12	1.22	8.95
shared	KQR M PO	1.14		-100.00
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	PCursor	3.57	4.19	17.32
shared	PL/SQL MPCODE	1.75		-100.00
shared	event statistics per sess	1.06	1.06	0.00
shared	free memory	11.31	7.07	-37.43
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.32	20.20	23.74
	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 %:	99.91	Redo NoWait %:	100.00
Buffer Hit %:	98.95	In-memory Sort %:	100.00
Library Hit %:	97.06	Soft Parse %:	98.86
Execute to Parse %:	0.34	Latch Hit %:	99.16
Parse CPU to Parse Elapsd %:	0.00	% Non-Parse CPU:	85.03