WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

ORCL 1275538605 orcl 1 10-Jan-13 10:01 11.2.0.1.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ORCL	1275538605	orcl	1	10-Jan-13 10:01	11.2.0.1.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

kwbsdb3850x5 Linux x86 64-bit 16 8 2 31.41

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
kwbsdb3850x5	Linux x86 64-bit	16	8	2	31.41

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 15386 11-Jan-13 09:00:29 308 5.4

End Snap: 15387 11-Jan-13 10:00:33 592 6.7

Elapsed: 60.07 (mins)

DB Time: 116.99 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	15386	11-Jan-13 09:00:29	308	5.4
End Snap:	15387	11-Jan-13 10:00:33	592	6.7
Elapsed:		60.07 (mins)
DB Time:		116.99 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 9,728M 9,216M Std Block Size: 8K

Shared Pool Size: 4,608M 4,608M Log Buffer: 138,260K

	Begin	End
Buffer Cache:	9,728M	9,216M	Std Block Size:	8K
Shared Pool Size:	4,608M	4,608M	Log Buffer:	138,260K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 2.0 0.2 0.00 0.01

DB CPU(s): 1.6 0.1 0.00 0.01

Redo size: 59,262.3 4,800.7

Logical reads: 184,919.5 14,980.0

Block changes: 628.9 51.0

Physical reads: 44.4 3.6

Physical writes: 10.4 0.8

User calls: 292.4 23.7

Parses: 215.8 17.5

Hard parses: 13.3 1.1

W/A MB processed: -0.6 -0.0

Logons: 0.2 0.0

Executes: 10,822.6 876.7

Rollbacks: 0.3 0.0

Transactions: 12.3

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	2.0	0.2	0.00	0.01
DB CPU(s):	1.6	0.1	0.00	0.01
Redo size:	59,262.3	4,800.7
Logical reads:	184,919.5	14,980.0
Block changes:	628.9	51.0
Physical reads:	44.4	3.6
Physical writes:	10.4	0.8
User calls:	292.4	23.7
Parses:	215.8	17.5
Hard parses:	13.3	1.1
W/A MB processed:	-0.6	-0.0
Logons:	0.2	0.0
Executes:	10,822.6	876.7
Rollbacks:	0.3	0.0
Transactions:	12.3

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.71 Soft Parse %: 93.85

Execute to Parse %: 98.01 Latch Hit %: 99.93

Parse CPU to Parse Elapsd %: 93.15 % Non-Parse CPU: 98.81

Shared Pool Statistics

Begin End

Memory Usage %: 45.81 54.74

% SQL with executions>1: 94.32 91.32

% Memory for SQL w/exec>1: 92.92 90.29

	Begin	End
Memory Usage %:	45.81	54.74
% SQL with executions>1:	94.32	91.32
% Memory for SQL w/exec>1:	92.92	90.29

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		5,877		83.72
db file sequential read	87,088	463	5	6.59	User I/O
log file sync	33,063	337	10	4.80	Commit
SQL*Net more data to client	167,353	202	1	2.87	Network
direct path read	18,825	86	5	1.22	User I/O

Host CPU (CPUs: 16 Cores: 8 Sockets: 2)

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

1.01 1.66 9.7 0.6 1.6 89.6

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
1.01	1.66	9.7	0.6	1.6	89.6

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

10.2 98.9 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 32,158.8 32,158.8

SGA use (MB): 15,360.0 14,848.0

PGA use (MB): 2,213.1 4,003.1

% Host Mem used for SGA+PGA: 54.64 58.62

	Begin	End
Host Mem (MB):	32,158.8	32,158.8
SGA use (MB):	15,360.0	14,848.0
PGA use (MB):	2,213.1	4,003.1
% Host Mem used for SGA+PGA:	54.64	58.62

Main Report

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

Wait Events Statistics

Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Wait Event Histogram Detail (64 msec to 2 sec)
Wait Event Histogram Detail (4 sec to 2 min)
Wait Event Histogram Detail (4 min to 1 hr)
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 7019.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
sql execute elapsed time	6,207.26	88.43
DB CPU	5,876.95	83.72
PL/SQL execution elapsed time	414.88	5.91
parse time elapsed	128.35	1.83
hard parse elapsed time	64.19	0.91
hard parse (sharing criteria) elapsed time	47.43	0.68
PL/SQL compilation elapsed time	13.82	0.20
failed parse elapsed time	5.64	0.08
sequence load elapsed time	4.90	0.07
connection management call elapsed time	4.13	0.06
inbound PL/SQL rpc elapsed time	0.73	0.01
hard parse (bind mismatch) elapsed time	0.62	0.01
repeated bind elapsed time	0.12	0.00
DB time	7,019.45
background elapsed time	613.46
background cpu time	27.20

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	597,149
IDLE_TIME	5,170,621
IOWAIT_TIME	92,666
NICE_TIME	32
SYS_TIME	36,574
USER_TIME	557,403
LOAD	1	2
PHYSICAL_MEMORY_BYTES	33,720,983,552
NUM_CPUS	16
NUM_CPU_CORES	8
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
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
11-Jan 09:00:29	1.01
11-Jan 10:00:33	1.66	10.35	9.66	0.63	89.65	1.61

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 100.4% of Total DB time 7,019.45 (s)
Total FG Wait Time: 1,169.90 (s) DB CPU time: 5,876.95 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			5,877		83.72
User I/O	122,000	0	587	5	8.37
Commit	33,063	0	337	10	4.80
Network	885,049	0	233	0	3.32
Application	1,860	0	6	3	0.09
Concurrency	3,158	6	3	1	0.05
Other	136,192	100	2	0	0.03
Configuration	8	25	1	83	0.01
System I/O	171	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
db file sequential read	87,088	0	463	5	1.96	6.59
log file sync	33,063	0	337	10	0.74	4.80
SQL*Net more data to client	167,353	0	202	1	3.76	2.87
direct path read	18,825	0	86	5	0.42	1.22
SQL*Net more data from client	42,304	0	30	1	0.95	0.43
db file scattered read	5,619	0	15	3	0.13	0.21
read by other session	1,341	0	13	10	0.03	0.18
SQL*Net break/reset to client	1,860	0	6	3	0.04	0.09
db file parallel read	641	0	5	8	0.01	0.08
Disk file operations I/O	8,158	0	3	0	0.18	0.05
cursor: pin S wait on X	187	0	2	11	0.00	0.03
direct path read temp	249	0	2	7	0.01	0.02
wait for a undo record	333	1	1	4	0.01	0.02
direct path write temp	79	0	1	15	0.00	0.02
SQL*Net message to client	675,392	0	1	0	15.18	0.02
log file switch completion	6	0	1	109	0.00	0.01
kksfbc child completion	12	100	1	51	0.00	0.01
latch: row cache objects	262	0	1	2	0.01	0.01
buffer busy waits	1,017	0	0	0	0.02	0.00
asynch descriptor resize	135,703	100	0	0	3.05	0.00
enq: TX - index contention	16	0	0	11	0.00	0.00
library cache: mutex X	751	0	0	0	0.02	0.00
PX Deq: Slave Session Stats	96	0	0	1	0.00	0.00
library cache lock	19	0	0	3	0.00	0.00
control file sequential read	171	0	0	0	0.00	0.00
latch: shared pool	151	0	0	0	0.00	0.00
latch free	29	0	0	1	0.00	0.00
latch: cache buffers chains	512	0	0	0	0.01	0.00
undo segment extension	2	100	0	6	0.00	0.00
cursor: mutex S	186	100	0	0	0.00	0.00
cursor: pin S	56	0	0	0	0.00	0.00
latch: redo allocation	17	0	0	0	0.00	0.00
library cache load lock	1	0	0	1	0.00	0.00
SQL*Net message from client	675,107	0	1,256,891	1862	15.17
jobq slave wait	8,476	100	4,245	501	0.19
PX Deq: Txn Recovery Start	174	0	7	42	0.00

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	37,782	0	327	9	0.85	53.29
db file parallel write	15,527	0	118	8	0.35	19.27
flashback log file write	1,617	0	45	28	0.04	7.33
control file parallel write	1,782	0	33	19	0.04	5.44
control file sequential read	6,832	0	26	4	0.15	4.28
os thread startup	247	0	4	18	0.01	0.73
SGA: allocation forcing component growth	32	100	3	101	0.00	0.53
db file sequential read	384	0	2	6	0.01	0.40
log file sequential read	67	0	1	17	0.00	0.18
direct path write	27	0	1	29	0.00	0.13
SQL*Net break/reset to client	130	0	1	5	0.00	0.11
direct path read	58	0	1	11	0.00	0.10
Disk file operations I/O	309	0	0	1	0.01	0.07
flashback log file read	22	0	0	17	0.00	0.06
flashback log file sync	14	0	0	22	0.00	0.05
wait for stopper event to be increased	11	0	0	19	0.00	0.03
SQL*Net more data from client	347	0	0	1	0.01	0.03
Parameter File I/O	24	0	0	6	0.00	0.02
enq: CF - contention	1	0	0	120	0.00	0.02
latch: call allocation	65	0	0	2	0.00	0.02
log file single write	6	0	0	12	0.00	0.01
log file sync	4	0	0	17	0.00	0.01
latch free	30	0	0	2	0.00	0.01
ADR block file write	5	0	0	13	0.00	0.01
ADR block file read	13	0	0	2	0.00	0.01
buffer busy waits	2	0	0	4	0.00	0.00
asynch descriptor resize	800	100	0	0	0.02	0.00
SQL*Net more data to client	347	0	0	0	0.01	0.00
latch: shared pool	28	0	0	0	0.00	0.00
LGWR wait for redo copy	68	0	0	0	0.00	0.00
PX Deq: Slave Session Stats	31	0	0	0	0.00	0.00
reliable message	30	0	0	0	0.00	0.00
enq: PS - contention	7	0	0	0	0.00	0.00
rdbms ipc reply	32	0	0	0	0.00	0.00
rdbms ipc message	53,896	32	64,231	1192	1.21
PX Idle Wait	12,832	99	25,500	1987	0.29
DIAG idle wait	7,170	100	7,177	1001	0.16
shared server idle wait	121	100	3,630	30003	0.00
Streams AQ: qmn slave idle wait	129	0	3,611	27994	0.00
Streams AQ: qmn coordinator idle wait	258	50	3,611	13997	0.01
Space Manager: slave idle wait	722	100	3,604	4992	0.02
pmon timer	1,739	68	3,603	2072	0.04
dispatcher timer	60	100	3,600	60003	0.00
smon timer	14	57	3,500	249987	0.00
SQL*Net message from client	1,794	0	312	174	0.04
SGA: MMAN sleep for component shrink	96	29	0	5	0.00
PX Deq: Join ACK	81	0	0	0	0.00
class slave wait	19	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	13	53.8		23.1	15.4	7.7
ADR block file write	5				20.0	60.0	20.0
ADR file lock	6	100.0
ARCH wait for archivelog lock	3	100.0
Disk file operations I/O	8467	99.8	.1		.0	.0		.0
LGWR wait for redo copy	68	98.5		1.5
Log archive I/O	3	100.0
PX Deq: Signal ACK EXT	52	100.0
PX Deq: Slave Session Stats	126	80.2	17.5	2.4
PX qref latch	1	100.0
Parameter File I/O	24	20.8		8.3	45.8	25.0
SGA: allocation forcing component growth	32							100.0
SQL*Net break/reset to client	1990	65.9	3.0	18.8	2.3	3.7	1.3	5.0
SQL*Net message to client	676.8K	100.0
SQL*Net more data from client	42.7K	86.2	13.4	.2	.0	.0	.0	.1
SQL*Net more data to client	167.7K	98.6	.0	.0	.0	.5	.2	.6	.0
asynch descriptor resize	136.5K	100.0
buffer busy waits	1019	94.4	3.2	1.2	.4	.4	.3	.1
control file parallel write	1781				.8	47.1	47.3	4.8
control file sequential read	7002	58.3	2.4	7.5	21.8	7.0	1.8	1.3
cursor: mutex S	186	100.0
cursor: pin S	56	100.0
cursor: pin S wait on X	187					100.0
db file parallel read	641	21.5	3.3	6.7	32.4	26.1	7.5	2.5
db file parallel write	15.5K	13.6	11.9	20.5	27.2	13.2	11.3	2.4
db file scattered read	5619	72.6	1.4	3.9	11.8	7.9	1.8	.6
db file sequential read	87.5K	37.9	2.6	9.3	29.3	16.9	2.7	1.3
direct path read	18.9K	35.7	6.4	14.5	27.7	12.9	1.9	.9
direct path read temp	249	12.9	6.0	14.9	42.6	15.7	6.8	1.2
direct path write	27	3.7	14.8	7.4	3.7	18.5	25.9	25.9
direct path write temp	79	1.3	1.3	2.5	21.5	49.4	15.2	8.9
enq: CF - contention	1							100.0
enq: PS - contention	7	100.0
enq: TX - index contention	16	12.5			31.3	50.0		6.3
flashback log file read	22	13.6	4.5	4.5	40.9	22.7		13.6
flashback log file sync	14	7.1			35.7	14.3	21.4	21.4
flashback log file write	1611			.1	6.6	20.7	52.6	20.0
kksfbc child completion	12							100.0
latch free	59	44.1	44.1	3.4	1.7	6.8
latch: cache buffers chains	512	99.4	.6
latch: call allocation	66	18.2	37.9	43.9
latch: redo allocation	17	100.0
latch: row cache objects	262	46.6	11.8	21.4	20.2
latch: shared pool	179	92.7	7.3
library cache load lock	1		100.0
library cache lock	19	68.4				31.6
library cache: mutex X	750	96.9	3.1
log file parallel write	37.8K	.3	3.1	13.5	54.3	20.8	5.4	2.5
log file sequential read	67	23.9	3.0	1.5	3.0	11.9	46.3	10.4
log file single write	6				16.7	66.7	16.7
log file switch completion	6			16.7				83.3
log file sync	33.1K	.4	3.1	13.9	45.0	27.2	6.7	3.7
os thread startup	247					38.5	61.5
rdbms ipc reply	32	100.0
read by other session	1341	16.6	5.0	12.8	29.7	21.8	9.0	5.0
reliable message	30	100.0
undo segment extension	2	50.0				50.0
wait for a undo record	333	43.2	14.4	13.8	12.0	14.1	1.8	.6
wait for stopper event to be increased	11	54.5			9.1	18.2		18.2
DIAG idle wait	7170							100.0
PX Deq: Join ACK	81	92.6	4.9	2.5
PX Deq: Txn Recovery Start	174	10.3	3.4	9.2	5.2	28.7	7.5	35.6
PX Idle Wait	12.9K			.0	.0	.0	.0	.7	99.3
SGA: MMAN sleep for component shrink	96	29.2	9.4	12.5	15.6	33.3
SQL*Net message from client	677K	6.4	.5	14.5	8.9	8.2	7.9	48.3	5.3
Space Manager: slave idle wait	722							.1	99.9
Streams AQ: qmn coordinator idle wait	258	50.0							50.0
Streams AQ: qmn slave idle wait	129								100.0
class slave wait	19	100.0
dispatcher timer	60								100.0
jobq slave wait	8476						.0	100.0
pmon timer	1739	30.1	.1					.7	69.2
rdbms ipc message	53.9K	9.0	1.3	1.3	3.2	6.7	8.8	45.9	23.8
shared server idle wait	120								100.0
smon timer	14								100.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
Disk file operations I/O	4	100.0	.0	.0
SGA: allocation forcing component growth	32			100.0
SQL*Net break/reset to client	100	95.0	5.0
SQL*Net more data from client	53	99.9			.0	.1	.0
SQL*Net more data to client	950	99.4	.1	.2	.1	.1	.0	.0	.0
buffer busy waits	1	99.9	.1
control file parallel write	86	95.2	3.8	.8	.2	.1
control file sequential read	89	98.7	.9	.3	.1
db file parallel read	16	97.5	2.0	.5
db file parallel write	365	97.6	2.2	.2	.0
db file scattered read	36	99.4	.5	.1
db file sequential read	1159	98.7	1.1	.2	.0	.0
direct path read	176	99.1	.8	.1	.0
direct path read temp	3	98.8	1.2
direct path write	7	74.1	11.1	14.8
direct path write temp	7	91.1	6.3	2.5
enq: CF - contention	1			100.0
enq: TX - index contention	1	93.8		6.3
flashback log file read	3	86.4	4.5	9.1
flashback log file sync	3	78.6	14.3	7.1
flashback log file write	323	80.0	13.9	4.7	1.2	.1	.1
kksfbc child completion	12		100.0
log file parallel write	959	97.5	1.9	.5	.1	.0
log file sequential read	7	89.6	9.0	1.5
log file switch completion	5	16.7		33.3	50.0
log file sync	1225	96.3	2.6	.8	.3	.0	.0
read by other session	67	95.0	3.6	1.4
wait for a undo record	2	99.4		.6
wait for stopper event to be increased	2	81.8		18.2

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s	< 1m	< 2m	>=2m
		% of Total Waits
SQL*Net more data to client	2	100.0	.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
orcl	6,167	5,274	129	628,108
SYS$USERS	851	602	31	38,230
SYS$BACKGROUND	0	0	1	50
orclXDB	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
orcl	93333	430	1392	1	691952	215
SYS$USERS	28667	157	389	1	193116	18
SYS$BACKGROUND	827	5	1624	5	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
%Total - Elapsed Time as a percentage of Total DB time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 70.2% of Total DB Time (s): 7,019
Captured PL/SQL account for 17.1% of Total DB Time (s): 7,019

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
522.51	18	29.03	7.44	98.50	1.50	bmt4znqvbgcx7	????????	begin if :p_action = '??' then...
410.64	216	1.90	5.85	99.97	0.00	c27zt11fdgxg3	kwappserver.exe	select count(*) from ( select ...
408.51	216	1.89	5.82	99.97	0.00	b0nrxjw98cjha	kwappserver.exe	select t.??????, t.?????? RID,...
313.74	9	34.86	4.47	99.99	0.00	5fgfs1548rar9	????????	select distinct ??, ??, ??, ??...
311.39	2,586,124	0.00	4.44	85.80	14.68	8b5c0u498ufmg	kwappserver.exe	SELECT T.F_LEVEL_ID FROM F_STO...
280.75	5	56.15	4.00	95.02	4.95	3r0ay6u2jtcgr	kwappserver.exe	declare v_type varchar2(40); b...
278.03	104	2.67	3.96	98.40	1.56	8b7dcr1p97g5d	????????????	SELECT :"SYS_B_00" ChildCount,...
275.80	5	55.16	3.93	96.20	3.76	02736fx6r61na	kwappserver.exe	INSERT INTO TT_kwbs3_BILLQRYAL...
260.14	1,516,782	0.00	3.71	100.62	0.00	61g4p0147sg6g	kwappserver.exe	SELECT COUNT(*) FROM ?????? A ...
243.25	12,654,027	0.00	3.47	100.23	0.00	01tt82rqxjavd	kwappserver.exe	SELECT ??????, ???? FROM ???? ...
193.27	294	0.66	2.75	90.43	9.55	fu2n26suy5m5w	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
168.84	12	14.07	2.41	97.80	2.15	czbr3h176gcrj	????????	INSERT INTO TT_BILL_QUERY (ID,...
157.09	6,207,113	0.00	2.24	102.19	0.04	76t78dxcavf4n	kwappserver.exe	SELECT VALUE FROM TS_CUBPENVS ...
155.20	9	17.24	2.21	98.08	1.87	69c126xmaxffy	????????	begin /* p_??: INTEGER = 1; p_...
152.31	207	0.74	2.17	89.98	9.96	apfzy1kgwfwgm	kwappserver.exe	select * from (select t.id, pk...
151.41	194	0.78	2.16	88.51	11.50	0tgwauk52nu5y	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
148.37	2	74.18	2.11	99.50	0.47	74guuptmx7vdj	????	select a.id, a.ROWID AS ROWID2...
142.05	4	35.51	2.02	99.98	0.00	04dn798sjfkxm	????????	select distinct ??, ??, ??, ??...
140.93	13	10.84	2.01	99.99	0.00	b948cyb8fdga1	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
130.60	15	8.71	1.86	98.94	0.99	3z7awvju0qa5u	????????	begin if :p_action = '??' then...
130.22	15	8.68	1.86	99.07	0.85	0k30kvsqp2atq	????????	INSERT INTO TT_BILL_QUERY (ID,...
119.89	8	14.99	1.71	99.99	0.00	gaw3pc7vbdf69	kwbs	SELECT ((SELECT count(*) FROM ...
98.87	38	2.60	1.41	97.75	2.20	asw0k18ru88y3	????????\????????	SELECT NVL(PKG_SX_kwbs_EX.STK_...
98.85	38	2.60	1.41	97.76	2.21	54f9wvbttny1b	????????\????????	SELECT SUM(QTY), MAX(??_??), M...
77.17	79	0.98	1.10	99.90	0.06	210rw3q22c99c	kwappserver.exe	select t.*, t.rowid, (select q...
76.61	207	0.37	1.09	99.86	0.02	77kj18zg2j6r0	kwappserver.exe	select count(*) from ( select ...
76.45	2,982,361	0.00	1.09	95.40	4.42	5xnb8jj14zp2b	kwappserver.exe	SELECT T.PARAM_VALUE FROM F_PA...
76.12	3,288,614	0.00	1.08	100.15	0.00	17gh3ap5auysm	kwappserver.exe	SELECT U.???? FROM ???? U WHER...
75.52	732	0.10	1.08	98.91	0.86	fjghawb6vvf88	BA_java	select t.*, t.rowid, d.receive...
75.17	25	3.01	1.07	99.14	0.80	gf4awny0hgfv5	kwbs	SELECT :"SYS_B_00" ChildCount,...
74.40	2,587,503	0.00	1.06	100.13	0.18	bcv85umzumag1	kwappserver.exe	SELECT T.ID FROM F_LEVEL_TYPE ...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - CPU Time as a percentage of Total DB CPU
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 81.4% of Total CPU Time (s): 5,877
Captured PL/SQL account for 19.5% of Total CPU Time (s): 5,877

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
514.67	18	28.59	8.76	522.51	98.50	1.50	bmt4znqvbgcx7	????????	begin if :p_action = '??' then...
410.51	216	1.90	6.99	410.64	99.97	0.00	c27zt11fdgxg3	kwappserver.exe	select count(*) from ( select ...
408.37	216	1.89	6.95	408.51	99.97	0.00	b0nrxjw98cjha	kwappserver.exe	select t.??????, t.?????? RID,...
313.71	9	34.86	5.34	313.74	99.99	0.00	5fgfs1548rar9	????????	select distinct ??, ??, ??, ??...
273.59	104	2.63	4.66	278.03	98.40	1.56	8b7dcr1p97g5d	????????????	SELECT :"SYS_B_00" ChildCount,...
267.18	2,586,124	0.00	4.55	311.39	85.80	14.68	8b5c0u498ufmg	kwappserver.exe	SELECT T.F_LEVEL_ID FROM F_STO...
266.78	5	53.36	4.54	280.75	95.02	4.95	3r0ay6u2jtcgr	kwappserver.exe	declare v_type varchar2(40); b...
265.33	5	53.07	4.51	275.80	96.20	3.76	02736fx6r61na	kwappserver.exe	INSERT INTO TT_kwbs3_BILLQRYAL...
261.75	1,516,782	0.00	4.45	260.14	100.62	0.00	61g4p0147sg6g	kwappserver.exe	SELECT COUNT(*) FROM ?????? A ...
243.81	12,654,027	0.00	4.15	243.25	100.23	0.00	01tt82rqxjavd	kwappserver.exe	SELECT ??????, ???? FROM ???? ...
174.78	294	0.59	2.97	193.27	90.43	9.55	fu2n26suy5m5w	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
165.12	12	13.76	2.81	168.84	97.80	2.15	czbr3h176gcrj	????????	INSERT INTO TT_BILL_QUERY (ID,...
160.54	6,207,113	0.00	2.73	157.09	102.19	0.04	76t78dxcavf4n	kwappserver.exe	SELECT VALUE FROM TS_CUBPENVS ...
152.22	9	16.91	2.59	155.20	98.08	1.87	69c126xmaxffy	????????	begin /* p_??: INTEGER = 1; p_...
147.63	2	73.81	2.51	148.37	99.50	0.47	74guuptmx7vdj	????	select a.id, a.ROWID AS ROWID2...
142.03	4	35.51	2.42	142.05	99.98	0.00	04dn798sjfkxm	????????	select distinct ??, ??, ??, ??...
140.91	13	10.84	2.40	140.93	99.99	0.00	b948cyb8fdga1	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
137.05	207	0.66	2.33	152.31	89.98	9.96	apfzy1kgwfwgm	kwappserver.exe	select * from (select t.id, pk...
134.02	194	0.69	2.28	151.41	88.51	11.50	0tgwauk52nu5y	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
129.21	15	8.61	2.20	130.60	98.94	0.99	3z7awvju0qa5u	????????	begin if :p_action = '??' then...
129.01	15	8.60	2.20	130.22	99.07	0.85	0k30kvsqp2atq	????????	INSERT INTO TT_BILL_QUERY (ID,...
119.88	8	14.99	2.04	119.89	99.99	0.00	gaw3pc7vbdf69	kwbs	SELECT ((SELECT count(*) FROM ...
96.65	38	2.54	1.64	98.87	97.75	2.20	asw0k18ru88y3	????????\????????	SELECT NVL(PKG_SX_kwbs_EX.STK_...
96.63	38	2.54	1.64	98.85	97.76	2.21	54f9wvbttny1b	????????\????????	SELECT SUM(QTY), MAX(??_??), M...
77.09	79	0.98	1.31	77.17	99.90	0.06	210rw3q22c99c	kwappserver.exe	select t.*, t.rowid, (select q...
76.50	207	0.37	1.30	76.61	99.86	0.02	77kj18zg2j6r0	kwappserver.exe	select count(*) from ( select ...
76.24	3,288,614	0.00	1.30	76.12	100.15	0.00	17gh3ap5auysm	kwappserver.exe	SELECT U.???? FROM ???? U WHER...
74.70	732	0.10	1.27	75.52	98.91	0.86	fjghawb6vvf88	BA_java	select t.*, t.rowid, d.receive...
74.52	25	2.98	1.27	75.17	99.14	0.80	gf4awny0hgfv5	kwbs	SELECT :"SYS_B_00" ChildCount,...
74.50	2,587,503	0.00	1.27	74.40	100.13	0.18	bcv85umzumag1	kwappserver.exe	SELECT T.ID FROM F_LEVEL_TYPE ...
72.94	2,982,361	0.00	1.24	76.45	95.40	4.42	5xnb8jj14zp2b	kwappserver.exe	SELECT T.PARAM_VALUE FROM F_PA...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - User I/O Time as a percentage of Total User I/O Wait time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 25.5% of Total User I/O Wait Time (s): 592
Captured PL/SQL account for 8.4% of Total User I/O Wait Time (s): 592

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
45.72	2,586,124	0.00	7.72	311.39	85.80	14.68	8b5c0u498ufmg	kwappserver.exe	SELECT T.F_LEVEL_ID FROM F_STO...
18.46	294	0.06	3.12	193.27	90.43	9.55	fu2n26suy5m5w	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
17.41	194	0.09	2.94	151.41	88.51	11.50	0tgwauk52nu5y	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
15.17	207	0.07	2.56	152.31	89.98	9.96	apfzy1kgwfwgm	kwappserver.exe	select * from (select t.id, pk...
13.88	5	2.78	2.34	280.75	95.02	4.95	3r0ay6u2jtcgr	kwappserver.exe	declare v_type varchar2(40); b...
12.71	3,923	0.00	2.15	16.78	25.41	75.79	d60w0vs5t8b9f	kwappserver.exe	begin Pkg_CellTree.DoCellTreeV...
10.36	5	2.07	1.75	275.80	96.20	3.76	02736fx6r61na	kwappserver.exe	INSERT INTO TT_kwbs3_BILLQRYAL...
9.56	14,596	0.00	1.61	20.66	49.99	46.26	48kuxbj2zcsj0	kwappserver.exe	begin pkg_celltree.CTLog(:p1, ...
7.84	18	0.44	1.32	522.51	98.50	1.50	bmt4znqvbgcx7	????????	begin if :p_action = '??' then...
4.37	1	4.37	0.74	10.58	59.28	41.27	0cn28wpn7h3tw	????????\????????\????????????	select distinct ??, ??, ??, ??...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - Buffer Gets as a percentage of Total Buffer Gets
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Buffer Gets: 666,503,601
Captured SQL account for 100.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
145,286,358	1,516,782	95.79	21.80	260.14	100.62	0.00	61g4p0147sg6g	kwappserver.exe	SELECT COUNT(*) FROM ?????? A ...
70,084,161	12	5,840,346.75	10.52	168.84	97.80	2.15	czbr3h176gcrj	????????	INSERT INTO TT_BILL_QUERY (ID,...
67,455,960	9	7,495,106.67	10.12	155.20	98.08	1.87	69c126xmaxffy	????????	begin /* p_??: INTEGER = 1; p_...
66,548,556	5	13,309,711.20	9.98	280.75	95.02	4.95	3r0ay6u2jtcgr	kwappserver.exe	declare v_type varchar2(40); b...
66,270,013	5	13,254,002.60	9.94	275.80	96.20	3.76	02736fx6r61na	kwappserver.exe	INSERT INTO TT_kwbs3_BILLQRYAL...
39,964,898	18	2,220,272.11	6.00	522.51	98.50	1.50	bmt4znqvbgcx7	????????	begin if :p_action = '??' then...
37,955,293	12,654,027	3.00	5.69	243.25	100.23	0.00	01tt82rqxjavd	kwappserver.exe	SELECT ??????, ???? FROM ???? ...
33,413,876	13	2,570,298.15	5.01	140.93	99.99	0.00	b948cyb8fdga1	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
28,832,908	294	98,071.12	4.33	193.27	90.43	9.55	fu2n26suy5m5w	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
27,574,154	15	1,838,276.93	4.14	130.60	98.94	0.99	3z7awvju0qa5u	????????	begin if :p_action = '??' then...
27,567,642	15	1,837,842.80	4.14	130.22	99.07	0.85	0k30kvsqp2atq	????????	INSERT INTO TT_BILL_QUERY (ID,...
23,820,518	9	2,646,724.22	3.57	313.74	99.99	0.00	5fgfs1548rar9	????????	select distinct ??, ??, ??, ??...
21,854,796	194	112,653.59	3.28	151.41	88.51	11.50	0tgwauk52nu5y	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
20,771,748	216	96,165.50	3.12	408.51	99.97	0.00	b0nrxjw98cjha	kwappserver.exe	select t.??????, t.?????? RID,...
20,674,603	216	95,715.75	3.10	410.64	99.97	0.00	c27zt11fdgxg3	kwappserver.exe	select count(*) from ( select ...
20,452,360	2,586,124	7.91	3.07	311.39	85.80	14.68	8b5c0u498ufmg	kwappserver.exe	SELECT T.F_LEVEL_ID FROM F_STO...
16,556,619	104	159,198.26	2.48	278.03	98.40	1.56	8b7dcr1p97g5d	????????????	SELECT :"SYS_B_00" ChildCount,...
12,827,380	38	337,562.63	1.92	98.87	97.75	2.20	asw0k18ru88y3	????????\????????	SELECT NVL(PKG_SX_kwbs_EX.STK_...
12,827,228	38	337,558.63	1.92	98.85	97.76	2.21	54f9wvbttny1b	????????\????????	SELECT SUM(QTY), MAX(??_??), M...
12,411,252	6,207,113	2.00	1.86	157.09	102.19	0.04	76t78dxcavf4n	kwappserver.exe	SELECT VALUE FROM TS_CUBPENVS ...
11,924,783	2,982,361	4.00	1.79	76.45	95.40	4.42	5xnb8jj14zp2b	kwappserver.exe	SELECT T.PARAM_VALUE FROM F_PA...
10,859,144	4	2,714,786.00	1.63	142.05	99.98	0.00	04dn798sjfkxm	????????	select distinct ??, ??, ??, ??...
10,231,456	2,587,503	3.95	1.54	74.40	100.13	0.18	bcv85umzumag1	kwappserver.exe	SELECT T.ID FROM F_LEVEL_TYPE ...
10,170,711	3,288,614	3.09	1.53	76.12	100.15	0.00	17gh3ap5auysm	kwappserver.exe	SELECT U.???? FROM ???? U WHER...
9,405,808	2	4,702,904.00	1.41	148.37	99.50	0.47	74guuptmx7vdj	????	select a.id, a.ROWID AS ROWID2...
8,465,382	8	1,058,172.75	1.27	119.89	99.99	0.00	gaw3pc7vbdf69	kwbs	SELECT ((SELECT count(*) FROM ...
8,012,316	207	38,706.84	1.20	152.31	89.98	9.96	apfzy1kgwfwgm	kwappserver.exe	select * from (select t.id, pk...
6,705,837	79	84,884.01	1.01	77.17	99.90	0.06	210rw3q22c99c	kwappserver.exe	select t.*, t.rowid, (select q...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 159,862
Captured SQL account for 27.6% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
11,864	2,586,124	0.00	7.42	311.39	85.80	14.68	8b5c0u498ufmg	kwappserver.exe	SELECT T.F_LEVEL_ID FROM F_STO...
9,346	5	1,869.20	5.85	280.75	95.02	4.95	3r0ay6u2jtcgr	kwappserver.exe	declare v_type varchar2(40); b...
7,416	194	38.23	4.64	151.41	88.51	11.50	0tgwauk52nu5y	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
6,523	18	362.39	4.08	522.51	98.50	1.50	bmt4znqvbgcx7	????????	begin if :p_action = '??' then...
6,296	5	1,259.20	3.94	275.80	96.20	3.76	02736fx6r61na	kwappserver.exe	INSERT INTO TT_kwbs3_BILLQRYAL...
5,561	1	5,561.00	3.48	10.58	59.28	41.27	0cn28wpn7h3tw	????????\????????\????????????	select distinct ??, ??, ??, ??...
3,062	207	14.79	1.92	152.31	89.98	9.96	apfzy1kgwfwgm	kwappserver.exe	select * from (select t.id, pk...
2,126	294	7.23	1.33	193.27	90.43	9.55	fu2n26suy5m5w	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
1,754	5	350.80	1.10	6.39	51.51	48.86	g9m38axch7v6w	kwbs4\????\????????????	select rownum id, ??, ??, ????...
1,385	3,923	0.35	0.87	16.78	25.41	75.79	d60w0vs5t8b9f	kwappserver.exe	begin Pkg_CellTree.DoCellTreeV...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 128,023
Captured SQL account for 5.2% of Total
Total UnOptimized Read Requests: 128,023
Captured SQL account for 5.2% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Opt	%Total	SQL Id	SQL Module	SQL Text
2,476	2,476	5	495.20	0.00	1.93	02736fx6r61na	kwappserver.exe	INSERT INTO TT_kwbs3_BILLQRYAL...
2,360	2,360	1	2,360.00	0.00	1.84	0cn28wpn7h3tw	????????\????????\????????????	select distinct ??, ??, ??, ??...
1,754	1,754	5	350.80	0.00	1.37	g9m38axch7v6w	kwbs4\????\????????????	select rownum id, ??, ??, ????...
17	17	294	0.06	0.00	0.01	fu2n26suy5m5w	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
14	14	6	2.33	0.00	0.01	16xrxqj1ctfhm	????????????	INSERT INTO TT_WH_QUERY (ID, ?...
3	3	4,645	0.00	0.00	0.00	gugnfm7th8tdq	kwappserver.exe	select s.std_detail_name from ...
2	2	76	0.03	0.00	0.00	9jx53z3vrs3dt	kwappserver.exe	INSERT INTO TS_WFID (ID, STATU...
1	1	194	0.01	0.00	0.00	0tgwauk52nu5y	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
0	0	12,654,027	0.00		0.00	01tt82rqxjavd	kwappserver.exe	SELECT ??????, ???? FROM ???? ...
0	0	4	0.00		0.00	04dn798sjfkxm	????????	select distinct ??, ??, ??, ??...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 39,007,811
Captured SQL account for 82.1% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
12,654,027	12,648,647	1.00	243.25	100.23	0.00	01tt82rqxjavd	kwappserver.exe	SELECT ??????, ???? FROM ???? ...
6,207,113	6,204,924	1.00	157.09	102.19	0.04	76t78dxcavf4n	kwappserver.exe	SELECT VALUE FROM TS_CUBPENVS ...
3,288,614	3,288,511	1.00	76.12	100.15	0.00	17gh3ap5auysm	kwappserver.exe	SELECT U.???? FROM ???? U WHER...
2,982,361	2,977,839	1.00	76.45	95.40	4.42	5xnb8jj14zp2b	kwappserver.exe	SELECT T.PARAM_VALUE FROM F_PA...
2,587,503	2,587,736	1.00	74.40	100.13	0.18	bcv85umzumag1	kwappserver.exe	SELECT T.ID FROM F_LEVEL_TYPE ...
2,586,124	2,442,542	0.94	311.39	85.80	14.68	8b5c0u498ufmg	kwappserver.exe	SELECT T.F_LEVEL_ID FROM F_STO...
1,516,782	1,516,690	1.00	260.14	100.62	0.00	61g4p0147sg6g	kwappserver.exe	SELECT COUNT(*) FROM ?????? A ...
61,317	324,585	5.29	8.29	101.71	0.29	3k94ugcdabmx4	????kwbs????	select celltree_urid, CELLTREE...
35,496	309,667	8.72	8.10	100.78	0.00	dxznqjbksb0tb	????kwbs????	select cttreenode_urid, cttree...
14,930	14,930	1.00	2.29	68.39	34.96	5nfbfnv61g86r	kwappserver.exe	INSERT INTO TT_kwbs3_BILLQRYAL...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 777,665
Captured SQL account for 22.8% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
61,317	61,317	7.88	3k94ugcdabmx4	????kwbs????	select celltree_urid, CELLTREE...
35,496	35,496	4.56	dxznqjbksb0tb	????kwbs????	select cttreenode_urid, cttree...
14,596	14,596	1.88	48kuxbj2zcsj0	kwappserver.exe	begin pkg_celltree.CTLog(:p1, ...
9,892	9,892	1.27	4g7rsp31dss71	BA_java	select pkg_celltree.CheckCell...
9,584	9,584	1.23	4wb1dqbwf64kd	kwappserver.exe	begin :doa__value := Pkg_CellT...
8,912	8,912	1.15	duwcj27kc16m8	BA_java	begin :RESULT := Common.GetRes...
8,725	8,907	1.12	3f49wxysh2t0v	kwappserver.exe	SELECT ???? FROM ???? WHERE ??...
8,232	8,232	1.06	cm5vu20fhtnq1		select /*+ connect_by_filterin...
7,175	7,175	0.92	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
6,213	6,219	0.80	8zgzyw9r0bgbb	kwappserver.exe	begin select ???? into :v_Resu...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
41,554,352		0.86	9n4qwuk35d6hg		update F2_SALE_ORDER set ORGID...
5,464,686	61	0.11	6ktz04w5hztk5	BA_java	insert into F2_SALE_ORDER ( ID...
2,326,170	4	0.05	04dn798sjfkxm	????????	select distinct ??, ??, ??, ??...
2,276,392	9	0.05	5fgfs1548rar9	????????	select distinct ??, ??, ??, ??...
1,765,986	11	0.04	ch38s0xzaharu	kwbs4\????\??????????	SELECT rownum id, t.* from ( S...
1,731,003	1	0.04	gp2srf6v3th3r	plsqldev.exe	select s.synonym_name object_n...
1,263,535	1	0.03	5pgyr95fa4f5h	????????\????????\????????????	select distinct ??, ??, ??, ??...
1,239,298	1	0.03	5j2a44wq2rb96	????????	select distinct ??, ??, ??, ??...
1,239,298	1	0.03	5j2a44wq2rb96	????????	select distinct ??, ??, ??, ??...
1,226,165	1	0.03	0cn28wpn7h3tw	????????\????????\????????????	select distinct ??, ??, ??, ??...
1,213,968	2	0.03	5mykk74xr35dd	????????	select distinct ??, ??, ??, ??...
1,213,968	2	0.03	5mykk74xr35dd	????????	select distinct ??, ??, ??, ??...
1,187,775	5	0.02	02736fx6r61na	kwappserver.exe	INSERT INTO TT_kwbs3_BILLQRYAL...
1,181,786	4	0.02	04dn798sjfkxm	????????	select distinct ??, ??, ??, ??...
1,180,298	69	0.02	0d9f4gvk4yduv	BA_java	insert into F2_REQPART ( ID, O...
1,178,123	10	0.02	gm0826zmy37yz	????????	select rownum ID, (select ????...
1,172,855	2	0.02	9yyqn38fmsqsd	kwbs4\????\??????????	SELECT rownum id, t.* from ( S...
1,166,246	14,930	0.02	5nfbfnv61g86r	kwappserver.exe	INSERT INTO TT_kwbs3_BILLQRYAL...
1,156,408	9	0.02	5fgfs1548rar9	????????	select distinct ??, ??, ??, ??...
1,139,545	81	0.02	3ttp4va9rrjuf	BA_java	update F2_SALE_ORDER_D set F2_...
1,106,140	182	0.02	4rv1byncpfspz	????kwbs????	select count(*) from all_proce...
1,098,060	5,470	0.02	db6t9k9mjm202	kwappserver.exe	SELECT OWNER FROM ALL_PROCEDUR...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
410		9n4qwuk35d6hg		update F2_SALE_ORDER set ORGID...
67	61	6ktz04w5hztk5	BA_java	insert into F2_SALE_ORDER ( ID...
24	69	0d9f4gvk4yduv	BA_java	insert into F2_REQPART ( ID, O...
24	81	3ttp4va9rrjuf	BA_java	update F2_SALE_ORDER_D set F2_...
23	210	g4kj2fu199302	BA_java	insert into F2_SALE_ORDER_D ( ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	1,079	0.30	0.02
Batched IO (full) vector count	3	0.00	0.00
Batched IO (space) vector count	0	0.00	0.00
Batched IO block miss count	7,971	2.21	0.18
Batched IO buffer defrag count	36	0.01	0.00
Batched IO double miss count	112	0.03	0.00
Batched IO same unit count	4,310	1.20	0.10
Batched IO single block count	521	0.14	0.01
Batched IO slow jump count	36	0.01	0.00
Batched IO vector block count	3,121	0.87	0.07
Batched IO vector read count	651	0.18	0.01
Block Cleanout Optim referenced	269	0.07	0.01
CCursor + sql area evicted	46	0.01	0.00
CPU used by this session	582,424	161.59	13.09
CPU used when call started	580,912	161.17	13.06
CR blocks created	47,828	13.27	1.07
Cached Commit SCN referenced	6,683	1.85	0.15
Commit SCN cached	2,188	0.61	0.05
DB time	1,118,895	310.43	25.15
DBWR checkpoint buffers written	31,493	8.74	0.71
DBWR checkpoints	3	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	31,493	8.74	0.71
DBWR transaction table writes	245	0.07	0.01
DBWR undo block writes	13,152	3.65	0.30
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	0	0.00	0.00
HSC Heap Segment Block Changes	351,974	97.65	7.91
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	6,826	1.89	0.15
Heap Segment Array Updates	11,302	3.14	0.25
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	31,438	8.72	0.71
PX local messages recv'd	198	0.05	0.00
PX local messages sent	132	0.04	0.00
Parallel operations not downgraded	0	0.00	0.00
RowCR - row contention	2,960	0.82	0.07
RowCR attempts	12,486,614	3,464.38	280.64
RowCR hits	12,488,430	3,464.88	280.68
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment recovery	4	0.00	0.00
SMON posted for undo segment shrink	2	0.00	0.00
SQL*Net roundtrips to/from client	675,497	187.41	15.18
active txn count during cleanout	83,213	23.09	1.87
application wait time	601	0.17	0.01
background checkpoints completed	4	0.00	0.00
background checkpoints started	3	0.00	0.00
background timeouts	17,576	4.88	0.40
branch node splits	2	0.00	0.00
buffer is not pinned count	384,128,005	106,575.22	8,633.45
buffer is pinned count	828,266,123	229,800.08	18,615.65
bytes received via SQL*Net from client	292,503,013	81,154.13	6,574.14
bytes sent via SQL*Net to client	589,369,565	163,518.91	13,246.34
calls to get snapshot scn: kcmgss	38,912,329	10,796.11	874.57
calls to kcmgas	128,711	35.71	2.89
calls to kcmgcs	597,349	165.73	13.43
cell physical IO interconnect bytes	2,717,707,264	754,020.14	61,081.68
change write time	790	0.22	0.02
cleanout - number of ktugct calls	68,296	18.95	1.53
cleanouts and rollbacks - consistent read gets	45,977	12.76	1.03
cleanouts only - consistent read gets	1,242	0.34	0.03
cluster key scan block gets	57,818	16.04	1.30
cluster key scans	37,092	10.29	0.83
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	251	0.07	0.01
commit batch/immediate requested	251	0.07	0.01
commit cleanout failures: block lost	23,561	6.54	0.53
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	51	0.01	0.00
commit cleanout failures: cannot pin	7	0.00	0.00
commit cleanouts	136,764	37.94	3.07
commit cleanouts successfully completed	113,132	31.39	2.54
commit immediate performed	251	0.07	0.01
commit immediate requested	251	0.07	0.01
commit txn count during cleanout	32,078	8.90	0.72
concurrency wait time	782	0.22	0.02
consistent changes	1,131,883	314.04	25.44
consistent gets	664,379,698	184,330.26	14,932.23
consistent gets - examination	276,682,868	76,764.87	6,218.57
consistent gets direct	37,344	10.36	0.84
consistent gets from cache	664,342,381	184,319.90	14,931.39
consistent gets from cache (fastpath)	317,209,898	88,008.98	7,129.43
cursor authentications	6,096	1.69	0.14
data blocks consistent reads - undo records applied	285,672	79.26	6.42
db block changes	2,266,713	628.89	50.95
db block gets	2,124,894	589.55	47.76
db block gets direct	46	0.01	0.00
db block gets from cache	2,124,848	589.53	47.76
db block gets from cache (fastpath)	523,510	145.25	11.77
deferred (CURRENT) block cleanout applications	67,974	18.86	1.53
dirty buffers inspected	606	0.17	0.01
enqueue conversions	1,028	0.29	0.02
enqueue deadlocks	0	0.00	0.00
enqueue releases	231,955	64.36	5.21
enqueue requests	232,685	64.56	5.23
enqueue timeouts	10	0.00	0.00
enqueue waits	24	0.01	0.00
exchange deadlocks	0	0.00	0.00
execute count	39,007,811	10,822.61	876.72
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	5,473,423,391	1,518,585.74	123,017.63
flashback log write bytes	315,228,160	87,459.16	7,084.89
flashback log writes	1,607	0.45	0.04
free buffer inspected	135,634	37.63	3.05
free buffer requested	184,052	51.06	4.14
heap block compress	31,173	8.65	0.70
hot buffers moved to head of LRU	287,700	79.82	6.47
immediate (CR) block cleanout applications	47,219	13.10	1.06
immediate (CURRENT) block cleanout applications	5,377	1.49	0.12
index crx upgrade (positioned)	17,702	4.91	0.40
index crx upgrade (prefetch)	1	0.00	0.00
index fast full scans (full)	7,965	2.21	0.18
index fetch by key	114,518,597	31,772.86	2,573.86
index scans kdiixs1	37,196,781	10,320.14	836.01
leaf node 90-10 splits	371	0.10	0.01
leaf node splits	571	0.16	0.01
lob reads	9,581	2.66	0.22
lob writes	262	0.07	0.01
lob writes unaligned	262	0.07	0.01
logons cumulative	830	0.23	0.02
max cf enq hold time	250	0.07	0.01
messages received	53,825	14.93	1.21
messages sent	53,825	14.93	1.21
min active SCN optimization applied on CR	1,201	0.33	0.03
no buffer to keep pinned count	52,635	14.60	1.18
no work - consistent read gets	372,709,433	103,407.17	8,376.81
non-idle wait count	1,293,618	358.91	29.07
non-idle wait time	173,433	48.12	3.90
opened cursors cumulative	39,124,041	10,854.85	879.33
parse count (describe)	4	0.00	0.00
parse count (failures)	39,528	10.97	0.89
parse count (hard)	47,862	13.28	1.08
parse count (total)	777,665	215.76	17.48
parse time cpu	6,979	1.94	0.16
parse time elapsed	7,492	2.08	0.17
physical read IO requests	128,023	35.52	2.88
physical read bytes	1,309,589,504	363,341.88	29,433.61
physical read total IO requests	135,289	37.54	3.04
physical read total bytes	1,618,152,960	448,951.93	36,368.71
physical read total multi block requests	218	0.06	0.00
physical reads	159,862	44.35	3.59
physical reads cache	112,580	31.24	2.53
physical reads cache prefetch	18,872	5.24	0.42
physical reads direct	47,282	13.12	1.06
physical reads direct (lob)	43,324	12.02	0.97
physical reads direct temporary tablespace	3,780	1.05	0.08
physical reads for flashback new	11,310	3.14	0.25
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	19,912	5.52	0.45
physical write bytes	306,225,152	84,961.30	6,882.55
physical write total IO requests	63,461	17.61	1.43
physical write total bytes	1,099,554,304	305,068.21	24,712.97
physical write total multi block requests	1,777	0.49	0.04
physical writes	37,381	10.37	0.84
physical writes direct	3,962	1.10	0.09
physical writes direct (lob)	14	0.00	0.00
physical writes direct temporary tablespace	3,780	1.05	0.08
physical writes from cache	33,419	9.27	0.75
physical writes non checkpoint	29,062	8.06	0.65
pinned buffers inspected	6	0.00	0.00
pinned cursors current	475	0.13	0.01
prefetch clients - default	82	0.02	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	150	0.04	0.00
process last non-idle time	3,605	1.00	0.08
queries parallelized	0	0.00	0.00
recursive calls	40,919,886	11,353.11	919.69
recursive cpu usage	341,158	94.65	7.67
redo blocks checksummed by FG (exclusive)	29,853	8.28	0.67
redo blocks written	452,157	125.45	10.16
redo buffer allocation retries	9	0.00	0.00
redo entries	1,164,921	323.20	26.18
redo k-bytes read total	183,707	50.97	4.13
redo log space requests	14	0.00	0.00
redo log space wait time	64	0.02	0.00
redo ordering marks	9,896	2.75	0.22
redo size	213,598,376	59,262.26	4,800.72
redo size for direct writes	378,488	105.01	8.51
redo subscn max counts	14,391	3.99	0.32
redo synch time	33,874	9.40	0.76
redo synch writes	33,093	9.18	0.74
redo wastage	9,550,700	2,649.81	214.66
redo write time	33,132	9.19	0.74
redo writes	37,786	10.48	0.85
rollback changes - undo records applied	390,456	108.33	8.78
rollbacks only - consistent read gets	2,005	0.56	0.05
rows fetched via callback	63,689,116	17,670.36	1,431.44
session connect time	0	0.00	0.00
session cursor cache hits	6,226,000	1,727.39	139.93
session logical reads	666,503,601	184,919.53	14,979.97
shared hash latch upgrades - no wait	14,323,675	3,974.06	321.93
shared hash latch upgrades - wait	82	0.02	0.00
sorts (memory)	250,228	69.43	5.62
sorts (rows)	46,357,972	12,861.89	1,041.92
sql area evicted	1,161	0.32	0.03
sql area purged	39,528	10.97	0.89
summed dirty queue length	3,091	0.86	0.07
switch current to new buffer	17,019	4.72	0.38
table fetch by rowid	527,739,885	146,419.93	11,861.19
table fetch continued row	16,138,476	4,477.57	362.72
table scan blocks gotten	139,289,578	38,645.50	3,130.60
table scan rows gotten	5,320,786,532	1,476,237.08	119,587.05
table scans (direct read)	0	0.00	0.00
table scans (long tables)	1	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	171,059	47.46	3.84
temp space allocated (bytes)	685,768,704	190,264.57	15,412.96
total cf enq hold time	19,130	5.31	0.43
total number of cf enq holders	331	0.09	0.01
total number of times SMON posted	6	0.00	0.00
transaction rollbacks	251	0.07	0.01
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	81,744,092	22,679.67	1,837.23
user I/O wait time	59,236	16.43	1.33
user calls	1,053,972	292.42	23.69
user commits	43,593	12.09	0.98
user rollbacks	900	0.25	0.02
workarea executions - onepass	4	0.00	0.00
workarea executions - optimal	226,864	62.94	5.10
write clones created in foreground	4	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	8,264,327,368	12,207,090,352
session cursor cache count	664,124	747,269
session uga memory	7,883,369,857,040	8,241,145,242,968
opened cursors current	1,652	3,988
workarea memory allocated	3,401,645	3,670,510
logons current	308	592
session pga memory	6,099,642,792	7,822,754,480
session uga memory max	37,429,193,480	42,077,783,696

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)	3	3.00

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

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

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Buffer Cache Reads	880M	26.68	.244153	0M	0.00	0M	93.7K	4.79
Others	294M	2.00	.081569	534M	1.48	.148156	10.4K	9.62
Direct Reads	370M	8.84	.102655	2M	0.02	.000554	0
DBWR	0M	0.00	0M	260M	5.41	.072136	0
LGWR	1M	0.01	.000277	222M	10.61	.061593	90	9.30
Direct Writes	0M	0.00	0M	29M	0.09	.008045	0
TOTAL:	1.5G	37.54	.428655	1G	17.61	.290487	104.2K	5.27

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	1.2G	35.46	.339317	257M	5.35	.071303	7.42	10.24
Log File	180M	0.06	.049940	221M	10.59	.061315	0.94	23.78
Flashback Log	2M	0.01	.000554	301M	0.45	.083511	16.14	15.00
Archive Log	0M	0.00	0M	179M	0.05	.049663
Control File	112M	1.94	.031074	56M	0.99	.015537	3.36	12.00
Temp File	29M	0.07	.008045	37M	0.17	.010265	6.82
Other	0M	0.00	0M	0M	0.00	0M	2.11
TOTAL:	1.5G	37.54	.428933	1G	17.61	.291596	7.21	21.53

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Buffer Cache Reads	880M	26.69	.244153	0M	0.00	0M	93.1K	4.77
Buffer Cache Reads (Data File)	880M	26.69	.244153	0M	0.00	0M	93.1K	4.77
Others	294M	2.00	.081569	534M	1.47	.148156	8644	7.89
Others (Flashback Log)	2M	0.01	.000554	301M	0.45	.083511	1634	27.27
Others (Archive Log)	0M	0.00	0M	179M	0.05	.049663	0
Others (Log File)	179M	0.05	.049663	0M	0.00	0M	12	0.08
Others (Control File)	112M	1.93	.031074	54M	0.97	.014982	6954	3.36
Others (Data File)	1M	0.01	.000277	0M	0.00	0M	44	6.43
Direct Reads	370M	8.84	.102655	2M	0.02	.000554	0
Direct Reads (Data File)	370M	8.84	.102655	2M	0.02	.000554	0
DBWR	0M	0.00	0M	260M	5.41	.072136	0
DBWR (Data File)	0M	0.00	0M	260M	5.41	.072136	0
LGWR	1M	0.01	.000277	222M	10.61	.061593	60	4.67
LGWR (Log File)	0M	0.00	0M	221M	10.59	.061315	12	7.08
LGWR (Control File)	1M	0.01	.000277	1M	0.02	.000277	48	4.06
Direct Writes	0M	0.00	0M	29M	0.09	.008045	0
Direct Writes (Data File)	0M	0.00	0M	29M	0.09	.008045	0
TOTAL:	1.5G	37.54	.428655	1G	17.60	.290487	101.8K	5.03

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
kwbs	115,676	32	3.74	1.24	15,504	4	2,013	6.46
UNDOTBS1	10,927	3	3.93	1.00	3,146	1	1,276	0.13
SYSTEM	913	0	3.35	1.74	50	0	3	3.33
TEMP	266	0	0.56	14.26	613	0	0	0.00
SYSAUX	209	0	5.45	1.23	566	0	0	0.00
USERS	9	0	3.33	1.00	30	0	0	0.00
kwbsT	11	0	0.91	1.00	8	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs01.DBF	5,707	2	2.98	1.22	288	0	8	7.50
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs02.DBF	5,043	1	3.34	1.34	340	0	12	9.17
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs03.DBF	6,667	2	2.52	1.48	338	0	17	7.06
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs04.DBF	6,485	2	2.10	1.36	242	0	40	5.25
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs05.DBF	5,094	1	2.71	1.35	201	0	138	8.04
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs06.DBF	5,485	2	2.53	1.24	274	0	158	6.77
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs07.DBF	4,553	1	3.20	1.26	242	0	121	7.02
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs08.DBF	4,090	1	3.76	1.24	345	0	297	5.05
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs09.DBF	4,321	1	3.63	1.27	336	0	335	5.97
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs10.DBF	3,729	1	3.98	1.29	331	0	112	5.45
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs11.dbf	6,700	2	3.21	1.14	308	0	84	5.60
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs12.DBF	5,502	2	4.18	1.40	885	0	51	12.55
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs13.DBF	4,861	1	3.25	1.15	461	0	42	7.62
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs14.DBF	4,419	1	3.18	1.19	312	0	53	6.42
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs15.DBF	6,153	2	2.28	1.27	443	0	52	9.81
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs16.DBF	4,197	1	3.76	1.12	463	0	57	8.77
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs17.DBF	3,570	1	4.44	1.17	425	0	62	6.77
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs18.DBF	3,546	1	3.76	1.19	322	0	49	9.39
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs19.DBF	3,564	1	5.40	1.17	596	0	59	5.08
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs20.DBF	3,049	1	5.57	1.20	732	0	93	4.09
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs21.DBF	3,752	1	5.72	1.12	926	0	36	5.28
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs22.DBF	3,951	1	5.06	1.20	1,277	0	46	6.96
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs23.DBF	3,088	1	5.82	1.11	1,263	0	40	4.50
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs24.DBF	2,833	1	6.13	1.14	1,164	0	10	5.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs25.DBF	2,188	1	6.27	1.04	990	0	15	13.33
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs26.DBF	1,390	0	6.71	1.02	1,031	0	25	3.20
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs27.DBF	940	0	6.83	1.00	657	0	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs28.DBF	799	0	5.13	1.00	312	0	1	0.00
kwbsT	/oracle/ora11gr2/oradata/orcl/kwbsT.DBF	6	0	0.00	1.00	4	0	0	0.00
kwbsT	/oracle/ora11gr2/oradata/orcl/kwbsT2.dbf	5	0	2.00	1.00	4	0	0	0.00
SYSAUX	/oracle/ora11gr2/oradata/orcl/sysaux01.dbf	209	0	5.45	1.23	566	0	0	0.00
SYSTEM	/oracle/ora11gr2/oradata/orcl/system01.dbf	913	0	3.35	1.74	50	0	3	3.33
TEMP	/oracle/ora11gr2/oradata/orcl/temp01.dbf	266	0	0.56	14.26	613	0	0
UNDOTBS1	/oracle/ora11gr2/oradata/orcl/undotbs01.dbf	10,927	3	3.93	1.00	3,146	1	1,276	0.13
USERS	/oracle/ora11gr2/oradata/orcl/users01.dbf	9	0	3.33	1.00	30	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	1,136,268	100	666,169,516	112,562	33,419	0	0	3,292

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 37,381

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	31,493	0	0	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

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

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	82	11941	172053	172044	1658880	172044
E	0	94	14931	204081	203550	1658880	203550

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	768	0.08	95	198.89	550,727	1	4620862.00
D	1,536	0.17	189	118.49	328,113	1	2750073.00
D	2,304	0.25	284	59.81	165,608	1	1384423.00
D	3,072	0.33	379	28.35	78,489	1	652292.00
D	3,840	0.42	473	16.63	46,055	1	379725.00
D	4,608	0.50	568	9.58	26,530	1	215642.00
D	5,376	0.58	663	5.56	15,409	1	122184.00
D	6,144	0.67	758	3.19	8,827	1	66868.00
D	6,912	0.75	852	2.19	6,074	1	43739.00
D	7,680	0.83	947	1.58	4,368	1	29395.00
D	8,448	0.92	1,042	1.23	3,405	1	21309.00
D	9,216	1.00	1,136	1.00	2,769	1	15961.00
D	9,984	1.08	1,231	0.90	2,498	1	13687.00
D	10,752	1.17	1,326	0.82	2,273	1	11795.00
D	11,520	1.25	1,420	0.79	2,191	1	11105.00
D	12,288	1.33	1,515	0.77	2,136	1	10639.00
D	13,056	1.42	1,610	0.75	2,082	1	10192.00
D	13,824	1.50	1,704	0.74	2,059	1	9998.00
D	14,592	1.58	1,799	0.74	2,043	1	9862.00
D	15,360	1.67	1,894	0.72	1,990	1	9415.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
99.59	17,784	73

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs
2K	4K	206,635	206,635	0
64K	128K	4,154	4,154	0
128K	256K	1,512	1,512	0
256K	512K	3,765	3,765	0
512K	1024K	5,402	5,402	0
1M	2M	4,742	4,742	0
2M	4M	325	325	0
4M	8M	205	203	2
8M	16M	50	50	0
16M	32M	25	23	2
32M	64M	3	3	0
64M	128M	10	10	0
256M	512M	4	4	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 PGA Cache Hit %	Estd Time
1,472	0.13	7,419.01	100.00	12,291,395
2,944	0.25	7,419.01	100.00	12,291,395
5,888	0.50	7,419.01	100.00	12,291,395
8,832	0.75	7,419.01	100.00	12,291,395
11,776	1.00	7,419.01	100.00	12,291,395
14,131	1.20	7,419.01	100.00	12,291,395
16,486	1.40	7,419.01	100.00	12,291,395
18,842	1.60	7,419.01	100.00	12,291,395
21,197	1.80	7,419.01	100.00	12,291,395
23,552	2.00	7,419.01	100.00	12,291,395
35,328	3.00	7,419.01	100.00	12,291,395
47,104	4.00	7,419.01	100.00	12,291,395
70,656	6.00	7,419.01	100.00	12,291,395
94,208	8.00	7,419.01	100.00	12,291,395

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)
4,096	0.89	454	23,531	2,018,171	1.00	1,914	1.08	178,802
4,608	1.00	963	42,487	2,018,317	1.00	1,768	1.00	204,742
5,120	1.11	1,248	50,692	2,018,410	1.00	1,675	0.95	204,747
5,632	1.22	1,280	51,554	2,018,436	1.00	1,649	0.93	204,748
6,144	1.33	1,280	51,554	2,018,444	1.00	1,641	0.93	204,748
6,656	1.44	1,280	51,554	2,018,445	1.00	1,640	0.93	204,748
7,168	1.56	1,280	51,554	2,018,445	1.00	1,640	0.93	204,748
7,680	1.67	1,280	51,554	2,018,446	1.00	1,639	0.93	204,748
8,192	1.78	1,280	51,554	2,018,446	1.00	1,639	0.93	204,748
8,704	1.89	1,280	51,554	2,018,446	1.00	1,639	0.93	204,748
9,216	2.00	1,280	51,554	2,018,446	1.00	1,639	0.93	204,748

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
7,424	0.50	1,503,282	183,520,319
9,280	0.63	477,739	51,031,827
11,136	0.75	158,385	9,775,210
12,992	0.88	120,036	4,840,397
14,848	1.00	104,153	2,768,789
16,704	1.13	101,372	2,428,228
18,560	1.25	100,393	2,282,313
20,416	1.38	99,643	2,205,340
22,272	1.50	99,518	2,205,340
24,128	1.63	99,508	2,205,340
25,984	1.75	99,508	2,205,340
27,840	1.88	99,508	2,205,340
29,696	2.00	99,508	2,205,340

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
256	1.00	0	0	0	0
512	2.00	0	0	0	0
768	3.00	0	0	0	0
1,024	4.00	0	0	0	0
1,280	5.00	0	0	0	0
1,536	6.00	0	0	0	0
1,792	7.00	0	0	0	0
2,048	8.00	0	0	0	0
2,304	9.00	0	0	0	0
2,560	10.00	0	0	0	0
2,816	11.00	0	0	0	0
3,072	12.00	0	0	0	0
3,328	13.00	0	0	0	0
3,584	14.00	0	0	0	0
3,840	15.00	0	0	0	0
4,096	16.00	0	0	0	0
4,352	17.00	0	0	0	0
4,608	18.00	0	0	0	0
4,864	19.00	0	0	0	0
5,120	20.00	0	0	0	0

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	2,016	13	6
undo block	1,273	0	0
undo header	3	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Av Wt Time(ms)
TX-Transaction (index contention)	26	26	0	16	10.63
CF-Controlfile Transaction	1,856	1,855	1	1	110.00
PS-PX Process Reservation	448	448	0	7	0.00

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
2	12.21	51,368	6,508	91	1440/1440	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
11-Jan 09:51	958	8,806	6,508	83	1,440	0/0	0/0/0/0/0/0
11-Jan 09:41	1,373	8,843	5,906	91	1,440	0/0	0/0/0/0/0/0
11-Jan 09:31	4,798	10,983	2,448	77	1,440	0/0	0/0/0/0/0/0
11-Jan 09:21	1,017	8,338	1,845	68	1,440	0/0	0/0/0/0/0/0
11-Jan 09:11	1,029	6,756	1,857	56	1,440	0/0	0/0/0/0/0/0
11-Jan 09:01	3,034	7,642	3,761	52	1,440	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
AQ deq hash table latch	1	0.00		0	0
ASM db client latch	2,435	0.00		0	0
ASM map operation hash table	1	0.00		0	0
ASM network state latch	99	0.00		0	0
AWR Alerted Metric Element list	52,693	0.00		0	0
Change Notification Hash table latch	1,200	0.00		0	0
Consistent RBA	37,788	0.00		0	0
DML lock allocation	124,714	0.00		0	0
Event Group Locks	748	0.00		0	0
FAL Queue	102	0.00		0	0
FIB s.o chain latch	42	0.00		0	0
FOB s.o list latch	11,042	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	0
JS Sh mem access	9	0.00		0	0
JS mem alloc latch	9	0.00		0	0
JS queue access latch	10	0.00		0	0
JS queue state obj latch	26,260	0.00		0	0
JS slv state obj latch	265	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	1	0.00		0	0
KJCT flow control latch	1	0.00		0	0
KMG MMAN ready and startup request latch	1,298	0.00		0	0
KMG resize request state object freelist	2	0.00		0	0
KTF sga latch	20	0.00		0	1,207	0.00
KWQP Prop Status	2	0.00		0	0
KWQS pqsubs latch	2	0.00		0	0
KWQS pqueue ctx latch	73	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	1	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	131	0.00		0	1,298	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
MinActiveScn Latch	1	0.00		0	0
Minimum flashback SCN latch	1	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	2,758	0.00		0	0
OS process allocation	3,361	0.06	0.00	0	0
OS process: request allocation	1,172	0.00		0	0
PL/SQL warning settings	210,251	0.00	0.00	0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	16,230	0.00		0	2	0.00
SGA IO buffer pool latch	97	0.00		0	104	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	122	0.00		0	1,184	0.00
SQL memory manager workarea list latch	310,662	0.00	0.00	0	0
Shared B-Tree	330	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	1	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	17,950	0.01	0.00	0	0
active service list	11,453	0.61	0.44	0	2,659	0.04
alert log latch	6	0.00		0	2	0.00
archive control	69	0.00		0	0
archive process latch	309	1.29	1.00	0	0
begin backup scn array	19	0.00		0	0
buffer pool	4	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	692,267	0.01	0.00	0	0
cache buffers chains	1,061,607,557	0.07	0.00	0	1,736,771	0.00
cache buffers lru chain	141,741	0.01	0.00	0	1,776,961	0.02
cache table scan latch	5,619	0.00		0	5,619	0.00
call allocation	7,331	1.79	0.61	0	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	1,211	0.00		0	0
channel operations parent latch	19,400	0.01	0.00	0	0
checkpoint queue latch	675,797	0.00	0.00	0	89,591	0.00
client/application info	29,937	0.00		0	0
compile environment latch	897	0.00		0	0
constraint object allocation	305	0.00		0	0
corrupted undo seg latch	1,170,792	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	99	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	99	0.00		0	0
dml lock allocation	99	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	1,528	2.81	0.02	0	0
enqueue hash chains	465,702	0.00	0.00	0	0
enqueues	217,789	0.03	0.00	0	0
error message lists	195	26.67	0.02	0	0
fifth spare latch	1	0.00		0	0
file cache latch	262	0.00		0	0
flashback FBA barrier	2	0.00		0	0
flashback SCN barrier	4	0.00		0	0
flashback allocation	41,107	0.00		0	0
flashback copy	1	0.00		0	38,255	0.01
flashback hint SCN barrier	2	0.00		0	0
flashback mapping	1,600	0.00		0	0
flashback marker cache	3	0.00		0	0
flashback sync request	108	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	500	0.00		0	0
global tx hash mapping	433	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	1,045	0.00		0	852,311	0.00
hash table modification latch	219	0.00		0	2	0.00
heartbeat check	1	0.00		0	0
hint flashback FBA barrier	2	0.00		0	0
i/o slave adaptor	0			0	2	0.00
internal temp table object number allocation latch	3	0.00		0	0
intra txn parallel recovery	71,997	0.09	0.00	0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	84	0.00		0	84	3.57
job_queue_processes free list latch	172	0.00		0	2	0.00
job_queue_processes parameter latch	868	0.00		0	0
k2q lock allocation	1	0.00		0	0
kcbtsemkid latch	3	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kks stats	14,668	0.01	1.00	0	0
kokc descriptor allocation latch	558	0.00		0	0
ksfv messages	1	0.00		0	0
kss move lock	39	0.00		0	0
ksuosstats global area	243	0.00		0	0
ksv allocation latch	175	0.00		0	0
ksv class latch	77	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	1,172	0.00		0	0
ktm global data	29	0.00		0	0
kwqbsn:qsga	131	0.00		0	0
lgwr LWN SCN	37,825	0.00		0	0
list of block allocation	4,001	0.00		0	0
loader state object freelist	20,108	0.00		0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	13	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	2	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	18	0.00		0	17	0.00
managed standby latch	99	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	94	0.00		0	0
messages	183,927	0.01	0.00	0	0
mostly latch-free SCN	38,040	0.02	0.00	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	25,506	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	99	0.00		0	0
object queue header heap	148,069	0.00		0	4,195	0.00
object queue header operation	610,936	0.00	0.00	0	54,041	0.10
object stats modification	2,391	0.00		0	0
parallel query alloc buffer	1,245	2.65	0.00	0	0
parallel query stats	103	61.17	0.38	0	0
parallel txn reco latch	42,322	1.61	0.00	0	0
parameter list	5,479	0.00		0	0
parameter table management	1,595	0.06	0.00	0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
post/wait queue	52,616	0.00	0.00	0	33,340	0.01
process allocation	1,419	0.14	1.00	0	747	0.00
process group creation	1,172	0.17	0.00	0	0
process queue	551	0.00		0	0
process queue reference	558,966	0.00	0.00	0	15,072	0.01
qmn task queue latch	525	0.19	1.00	0	0
query server freelists	554	0.54	0.00	0	0
query server process	96	0.00		0	64	0.00
queued dump request	12	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	117,761	0.45	0.03	0	1,164,179	0.25
redo copy	65	0.00		0	1,164,878	0.05
redo writing	134,171	0.00	0.00	0	0
resmgr group change latch	5,866	0.00		0	0
resmgr:active threads	1,505	0.00		0	0
resmgr:actses change group	699	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	1,504	3.52	0.02	0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	11	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	5,470,597	0.64	0.01	1	18	0.00
rules engine evaluation context statistics	0			0	2	0.00
rules engine rule set statistics	100	0.00		0	0
second spare latch	1	0.00		0	0
sequence cache	444,172	0.00	0.00	0	0
session allocation	369,562	0.01	0.00	0	123,326	0.00
session idle bit	2,230,372	0.00	0.00	0	49	0.00
session queue latch	1	0.00		0	0
session state list latch	2,254	1.60	0.00	0	0
session switching	2,225	0.22	0.00	0	0
session timer	1,739	0.00		0	0
shared pool	1,734,064	0.12	0.09	0	0
shared pool sim alloc	344	0.00		0	0
shared pool simulator	26,183	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	32,112,354	0.00	0.00	0	0
simulator lru latch	16,153	0.07	0.00	0	32,092,515	0.11
sort extent pool	7,421	0.00		0	0
space background state object latch	8	0.00		0	0
space background task latch	2,670	0.04	0.00	0	2,404	0.00
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
tablespace key chain	1	0.00		0	0
temp lob duration state obj allocation	86	0.00		0	0
temporary table state object allocation	527	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	152	0.00		0	0
transaction allocation	4,403	0.00		0	16	0.00
transaction branch allocation	2,281	0.04	0.00	0	0
undo global data	363,337	0.00	0.00	0	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	1,061,607,557	738,039	517	737,528
row cache objects	5,470,597	35,149	272	34,912
shared pool	1,734,064	2,081	183	1,918
redo allocation	117,761	532	17	515
call allocation	7,331	131	80	67
active service list	11,453	70	31	49
parallel query stats	103	63	24	40
resmgr:free threads list	1,504	53	1	52
error message lists	195	52	1	51
dummy allocation	1,528	43	1	42
archive process latch	309	4	4	0
kks stats	14,668	2	2	0
process allocation	1,419	2	2	0
qmn task queue latch	525	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
active service list	kswslogon: session logout	41	39
active service list	kswsite: service iterator	2	2
active service list	kswsigsn: get service name	1	0
archive process latch	kcrrgpll	4	4
cache buffers chains	kcbgtcr_2	360	303
cache buffers chains	kcbgtcr: fast path (cr pin)	102	101
cache buffers chains	kcbgcur_2	86	33
cache buffers chains	kcbchg1: kslbegin: bufs not pinned	38	49
cache buffers chains	kcbgtcr: fast path	18	4
cache buffers chains	kcbrls_2	15	60
cache buffers chains	kcbrls_1	6	33
cache buffers chains	kcbchg1: kslbegin: call CR func	1	36
cache buffers chains	kcbget: pin buffer	1	0
cache buffers chains	kcbgtcr: kslbegin shared	1	0
cache buffers chains	kcbzwb	1	3
call allocation	ksuxds	77	77
call allocation	ksursi0	3	2
dummy allocation	ktcscnfy	1	1
error message lists	kxfpqsnd	1	0
kks stats	kksAllocChildStat	2	2
parallel query stats	kxfprst: KSLBEGIN:1	24	24
process allocation	ksucrp:1	2	0
qmn task queue latch	kwqmnmvtsks: delay to ready list	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	8	0
redo allocation	kcrfw_redo_gen: redo allocation 3	8	17
redo allocation	kcrfw_redo_gen: redo allocation 2	1	0
resmgr:free threads list	kskthrcreate	1	1
row cache objects	kqrpre: find obj	135	89
row cache objects	kqreqd: reget	75	45
row cache objects	kqreqd	62	138
shared pool	kghalo	151	84
shared pool	kghfre	27	29
shared pool	kghupr1	5	60

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Library Cache	kglIsOwnerVersionable 121	7,218	-0
Library Cache	kglpndl1 95	887	-0
Library Cache	kglpin1 4	558	-0
Cursor Pin	kksfbc [KKSCHLFSP2]	210	0
Library Cache	kglhdgn2 106	195	-0
Cursor Pin	kkslce [KKSCHLPIN2]	188	1
Cursor Stat	kkocsStoreBindAwareStats [KKSSTALOC8]	186	0
Library Cache	kglpnal1 90	137	0
Library Cache	kgldtin1 42	18	0
Library Cache	kgllkc1 57	12	-0
Library Cache	kglhdgn1 62	10	0
Cursor Pin	kksLockDelete [KKSCHLPIN6]	10	0
Library Cache	kgllkdl1 85	9	-0
Library Cache	kglobld1 75	5	-0
Library Cache	kglpur1 28	5	-0
Library Cache	kglget2 2	4	1
Library Cache	kglini1 32	4	0
Library Cache	kglobpn1 71	4	0
Library Cache	kglhdgh1 64	3	-1
Cursor Pin	kksfbc [KKSCHLCREA]	2	11

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 666,503,601
Captured Segments account for 84.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
kwbsPROD	kwbs	IDX??PK	INDEX	118,460,320	17.77
kwbsPROD	kwbs	F_STOCK	TABLE	87,257,152	13.09
kwbsPROD	kwbs	F_SALE_ORDER	TABLE	54,043,616	8.11
kwbsPROD	kwbs	??	TABLE	51,274,320	7.69
kwbsPROD	kwbs	F_SEND	TABLE	26,202,160	3.93

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 159,862
Captured Segments account for 29.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
kwbsPROD	kwbs	F_SALE_ORDER	TABLE	9,169	5.74
kwbsPROD	kwbs	F_STK_DETAIL	TABLE	7,639	4.78
kwbsPROD	kwbs	F_STK_IO	TABLE	6,655	4.16
kwbsPROD	kwbs	IDX_F_STK_LVL	INDEX	6,298	3.94
kwbsPROD	kwbs	F_INST_ORDER	TABLE	4,175	2.61

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 128,023
Captured Segments account for 29.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
kwbsPROD	kwbs	F_STK_DETAIL	TABLE	7,639	5.97
kwbsPROD	kwbs	IDX_F_STK_LVL	INDEX	6,298	4.92
kwbsPROD	kwbs	F_SALE_ORDER	TABLE	5,393	4.21
kwbsPROD	kwbs	F_STK_IO	TABLE	3,454	2.70
kwbsPROD	kwbs	F_INST_ORDER	TABLE	3,100	2.42

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 128,023
Captured Segments account for 29.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
kwbsPROD	kwbs	F_STK_DETAIL	TABLE	7,639	5.97
kwbsPROD	kwbs	IDX_F_STK_LVL	INDEX	6,298	4.92
kwbsPROD	kwbs	F_SALE_ORDER	TABLE	5,393	4.21
kwbsPROD	kwbs	F_STK_IO	TABLE	3,454	2.70
kwbsPROD	kwbs	F_INST_ORDER	TABLE	3,100	2.42

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 47,282
Captured Segments account for 0.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1275538605_15378	TABLE PARTITION	32	0.07
SYS	SYSAUX	SYS_LOB0000006213C00038$$		LOB	13	0.03

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 37,381
Captured Segments account for 15.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
kwbsPROD	kwbs	CELLTREEREADINFOMAYBE		TABLE	1,097	2.93
kwbsPROD	kwbs	XIE1CELLTREEREADINFOX		INDEX	532	1.42
kwbsPROD	kwbs	IDX_F_STK_DETAIL_PART		INDEX	476	1.27
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	372	1.00
kwbsPROD	kwbs	F_SEND		TABLE	370	0.99

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 19,912
Captured Segments account for 22.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
kwbsPROD	kwbs	CELLTREEREADINFOMAYBE		TABLE	883	4.43
kwbsPROD	kwbs	XIE1CELLTREEREADINFOX		INDEX	439	2.20
kwbsPROD	kwbs	IDX_F_STK_DETAIL_PART		INDEX	424	2.13
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	335	1.68
kwbsPROD	kwbs	??		TABLE	318	1.60

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 3,962
Captured Segments account for 1.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1275538605_15378	TABLE PARTITION	32	0.81
SYS	SYSAUX	SYS_LOB0000006213C00038$$		LOB	13	0.33

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 7,966
Captured Segments account for 0.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
kwbsPROD	kwbs	F_INST_ORDER_D		TABLE	1	0.01

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

% of Capture shows % of DB Block Changes for each top segment compared
with total DB Block Changes for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
kwbsPROD	TEMP	IDXTS_CUBPENVSPK		INDEX	132,512	41.13
kwbsPROD	kwbs	F_SALE_ORDER		TABLE	36,128	11.21
kwbsPROD	kwbs	F_STK_IO_D		TABLE	22,720	7.05
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	19,008	5.90
kwbsPROD	kwbs	PK_CELLTREELOG		INDEX	18,304	5.68

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	Obj. Type	Row Lock Waits	% of Capture
kwbsPROD	kwbs	PK_CELLTREELOG	INDEX	19	54.29
kwbsPROD	kwbs	F_STK_IO	TABLE	5	14.29
kwbsPROD	kwbs	F_SALE_ORDER	TABLE	2	5.71
kwbsPROD	kwbs	F_SEND	TABLE	2	5.71
kwbsPROD	kwbs	IDX_F_STK_DETAIL_PART3	INDEX	2	5.71

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	Obj. Type	Buffer Busy Waits	% of Capture
kwbsPROD	kwbs	PK_CELLTREELOG	INDEX	21	80.77
SYS	SYSTEM	JOB$	TABLE	3	11.54
kwbsPROD	kwbs	F_SALE_ORDER	TABLE	1	3.85
kwbsPROD	kwbs	IDX_F_SALE_ORDER2	INDEX	1	3.85

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	65	0.00	2	1
dc_files	34	0.00	0	34
dc_global_oids	798	0.00	0	85
dc_histogram_data	356,477	0.00	0	16,216
dc_histogram_defs	135,316	0.01	0	12,195
dc_object_grants	2,443	0.00	0	273
dc_objects	352,895	0.00	9	4,727
dc_profiles	586	0.00	0	1
dc_rollback_segments	19,623	0.00	0	306
dc_segments	84,036	0.03	13	2,277
dc_sequences	7,172	0.14	7,172	166
dc_table_scns	212	0.00	26	3
dc_tablespaces	712,258	0.00	0	8
dc_users	395,942	0.00	0	220
global database name	2,999	0.00	0	1
outstanding_alerts	34	0.00	0	6
sch_lj_oids	7	0.00	0	12

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
APP CONTEXT	1,338	0.00	1,338	0.00	0	0
BODY	9,068	0.00	260,535	0.00	2	0
CLUSTER	667	0.00	203	0.00	0	0
DBLINK	1,002	0.00	0		0	0
EDITION	598	0.00	1,181	0.00	0	0
INDEX	24	0.00	24	0.00	0	0
QUEUE	63	0.00	215	0.00	0	0
SCHEMA	1,113	0.00	0		0	0
SQL AREA	305,978	32.66	39,313,417	0.29	43,771	39,525
SUBSCRIPTION	19	0.00	19	0.00	0	0
TABLE/PROCEDURE	423,701	0.00	842,368	0.02	125	0
TRIGGER	952	0.00	994	0.10	1	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)	Oper Count	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT buffer cache	9,728.00	9,216.00	9,216.00	10,752.00	1	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	11,264.00	11,776.00	10,752.00	11,776.00	1	GRO/MAN
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	15,360.00	14,848.00	14,848.00	15,872.00	1	SHR/DEF
Shared IO Pool	0.00	0.00	0.00	0.00	0	STA/
java pool	256.00	256.00	256.00	256.00	0	STA/
large pool	256.00	256.00	256.00	256.00	0	STA/
shared pool	4,608.00	4,608.00	4,096.00	5,376.00	0	SHR/DEF
streams pool	256.00	256.00	256.00	256.00	0	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

Resizes, Grows, Shrinks - Operations captured by AWR if there are operations on the same component for the same operation_type, target_size, and with the same start_time only one operation is captured
ordered by Component

Component	Min Size (Mb)	Max Size (Mb)	Avg Size (Mb)	Re- Sizes	Grows	Shrinks
DEFAULT buffer cache	9,216.00	9,216.00	9,216.00	1	0	1
PGA Target	11,776.00	11,776.00	11,776.00	1	1	0
SGA Target	14,848.00	14,848.00	14,848.00	1	0	1

Back to Memory Statistics
Back to Top

Memory Resize Ops

Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred Delta : change in size of the component Target Delta: displayed only if final size <> target_size
Status: COMplete/CANcelled/INActive/PENding/ERRor
ordered by start_time desc,component

Start	Ela (s)	Component	Oper Typ/Mod	Init Size (M)	Delta	Final (M)	Sta
01/11 09:26:23	2	bufcache	SHR/DEF	9,728	-512	9,216	COM
01/11 09:26:21	0	pga	GRO/MAN	11,264	512	11,776	COM
01/11 09:26:21	4	sga	SHR/DEF	15,360	-512	14,848	COM

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	868.36		2.80	3.17	34	34	310	310
	SQL	760.45	711.24	2.61	14.67	238	239	291	271
	PL/SQL	341.79	329.32	1.11	0.58	2	2	308	308
	Freeable	243.00	0.00	1.00	1.45	19		244	244
E	Other	1,727.67		2.73	2.35	33	33	632	632
	SQL	1,062.20	966.46	1.83	10.44	238	239	581	562
	PL/SQL	740.03	711.53	1.17	0.56	2	2	630	598
	Freeable	474.44	0.00	0.93	1.09	19		508	508

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	10,200,547,328	9,663,676,416
Fixed Size	2,214,096
Redo Buffers	141,578,240
Variable Size	17,448,306,480	17,985,177,392

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	256.00	256.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	248.19	248.19	0.00
shared	CCUR	423.37	569.78	34.58
shared	FileOpenBlock	184.70	184.70	0.00
shared	KKSSP		87.32
shared	PCUR	91.16	109.19	19.79
shared	SQLA	518.46	675.01	30.20
shared	SQLP	71.16	99.89	40.38
shared	db_block_hash_buckets	89.00	89.00	0.00
shared	dbktb: trace buffer	46.88	46.88	0.00
shared	event statistics per sess	55.41	55.41	0.00
shared	flashback generation buff	64.00	64.00	0.00
shared	free memory	2,497.22	2,085.79	-16.48
shared	ksunfy : SSO free list	51.34	51.34	0.00
shared	private strands	64.68	64.68	0.00
streams	free memory	256.00	256.00	0.00
	buffer_cache	9,728.00	9,216.00	-5.26
	fixed_sga	2.11	2.11	0.00
	log_buffer	135.02	135.02	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

Streams processes ordered by Foreground CPU Time, descending

Session Type	First Logon	Foreground CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	0110 10:52:05	0.10	0.00	0.00
QMON Coordinator	0110 10:51:55	0.01	0.00	0.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps
%Exp Msgs - % of msgs enqueued with expiry
%Delay Msgs - % of msgs enqueued with delay
%Trasf Time - % of Enqueue time spent in transformation
%Eval Time - % of Enqueue time spent in rule evaluation

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
SYS.ALERT_QUE(12343)	0	0			0.00	0.00
SYS.AQ$_ALERT_QT_E(12342)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(66573)	61	61	0.00	0.00	0.16	0.29	0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps

Queue Name	Enqueue Msgs/sec	Dequeue Msgs/sec	Avg Enqueue sec / msg	Avg Dequeue sec / msg
SYS.ALERT_QUE(12343)	0.00	0.00
SYS.AQ$_ALERT_QT_E(12342)	0.00	0.00
SYSMAN.MGMT_TASK_Q(66573)	0.02	0.02	0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Ordered by Queue Name, Subscriber Name
* indicates Subscriber activity (re)started between Begin/End snaps

Subscriber/Queue	Enqueue Msgs	Dequeue Msgs	Expire Msgs	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE	0	0	0
kwbsDB3850X5__3938_ORCL(22)/SYS.ALERT_QUE	0	0	0	0.00	0.00	0.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Shared Server Statistics

Shared Servers Activity
Shared Servers Rates
Shared Servers Utilization
Shared Servers Common Queue
Shared Servers Dispatchers

Shared Servers Activity

Values represent averages for all samples

Avg Total Connections	Avg Active Connections	Avg Total Shared Srvrs	Avg Active Shared Srvrs	Avg Total Dispatchers	Avg Active Dispatchers
0	0	1	0	1	0

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per Sec	Disp Queue Per Sec	Server Msgs/Sec	Server KB/Sec	Common Queue Total	Disp Queue Total	Server Total Msgs	Server Total(KB)
0	0	0	0.00	0	0	0	0

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Statistics are combined for all servers
Incoming and Outgoing Net % are included in %Busy

Total Server Time (s)	%Busy	%Idle	Incoming Net %	Outgoing Net %
3,605	0.00	100.00	0.00	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

Ordered by %Busy, descending
Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue
Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots

Name	Avg Conns	Total Disp Time (s)	%Busy	%Idle	Total Queued	Total Queue Wait (s)	Avg Queue Wait (ms)
D000	0.00	3,605	0.00	100.00	0	0

Back to Shared Server Statistics
Back to Top

init.ora Parameters

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

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/ora11gr2/admin/orcl/adump
audit_trail	NONE
compatible	11.2.0.0.0
control_files	/oracle/ora11gr2/oradata/orcl/control01.ctl, /oracle/ora11gr2/flash_recovery_area/orcl/control02.ctl
cursor_sharing	FORCE
db_block_size	8192
db_domain
db_flashback_retention_target	2880
db_name	orcl
db_recovery_file_dest	/oracle/ora11gr2/flash_recovery_area
db_recovery_file_dest_size	25769803776
diagnostic_dest	/oracle/ora11gr2
dispatchers	(PROTOCOL=TCP) (SERVICE=orclXDB)
fast_start_mttr_target	0
filesystemio_options	SETALL
log_archive_dest_1	LOCATION=/oracle/ora11gr2/oradata/orcl/archive
log_checkpoints_to_alert	TRUE
memory_target	27917287424
open_cursors	6000
optimizer_mode	CHOOSE
processes	3000
remote_login_passwordfile	EXCLUSIVE
resource_limit	TRUE
session_cached_cursors	500
sessions	4528
undo_retention	86400
undo_tablespace	UNDOTBS1

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.98	In-memory Sort %:	100.00
Library Hit %:	99.71	Soft Parse %:	93.85
Execute to Parse %:	98.01	Latch Hit %:	99.93
Parse CPU to Parse Elapsd %:	93.15	% Non-Parse CPU:	98.81