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: 15367 10-Jan-13 14:00:58 692 6.1

End Snap: 15368 10-Jan-13 15:00:03 732 6.4

Elapsed: 59.07 (mins)

DB Time: 156.29 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	15367	10-Jan-13 14:00:58	692	6.1
End Snap:	15368	10-Jan-13 15:00:03	732	6.4
Elapsed:		59.07 (mins)
DB Time:		156.29 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 9,984M 9,984M Std Block Size: 8K

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

	Begin	End
Buffer Cache:	9,984M	9,984M	Std Block Size:	8K
Shared Pool Size:	4,864M	4,864M	Log Buffer:	138,260K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 2.7 0.2 0.00 0.01

DB CPU(s): 2.1 0.2 0.00 0.01

Redo size: 48,327.4 3,767.9

Logical reads: 279,005.0 21,753.1

Block changes: 269.4 21.0

Physical reads: 55.1 4.3

Physical writes: 11.1 0.9

User calls: 325.6 25.4

Parses: 234.4 18.3

Hard parses: 11.0 0.9

W/A MB processed: 5.6 0.4

Logons: 0.2 0.0

Executes: 13,026.7 1,015.7

Rollbacks: 0.3 0.0

Transactions: 12.8

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	2.7	0.2	0.00	0.01
DB CPU(s):	2.1	0.2	0.00	0.01
Redo size:	48,327.4	3,767.9
Logical reads:	279,005.0	21,753.1
Block changes:	269.4	21.0
Physical reads:	55.1	4.3
Physical writes:	11.1	0.9
User calls:	325.6	25.4
Parses:	234.4	18.3
Hard parses:	11.0	0.9
W/A MB processed:	5.6	0.4
Logons:	0.2	0.0
Executes:	13,026.7	1,015.7
Rollbacks:	0.3	0.0
Transactions:	12.8

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 99.99

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

Library Hit %: 99.78 Soft Parse %: 95.29

Execute to Parse %: 98.20 Latch Hit %: 99.97

Parse CPU to Parse Elapsd %: 95.22 % Non-Parse CPU: 99.13

Shared Pool Statistics

Begin End

Memory Usage %: 33.23 34.99

% SQL with executions>1: 86.95 87.71

% Memory for SQL w/exec>1: 85.76 88.44

	Begin	End
Memory Usage %:	33.23	34.99
% SQL with executions>1:	86.95	87.71
% Memory for SQL w/exec>1:	85.76	88.44

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		7,371		78.61
log file sync	38,342	390	10	4.16	Commit
db file sequential read	66,903	292	4	3.11	User I/O
SQL*Net more data to client	194,992	220	1	2.34	Network
direct path read	23,858	109	5	1.16	User I/O

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

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

2.51 2.07 12.5 0.6 1.5 86.8

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
2.51	2.07	12.5	0.6	1.5	86.8

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

13.0 99.0 0.0

Memory Statistics

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

Begin End

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

SGA use (MB): 15,872.0 15,872.0

PGA use (MB): 4,870.3 5,033.5

% Host Mem used for SGA+PGA: 64.50 65.01

	Begin	End
Host Mem (MB):	32,158.8	32,158.8
SGA use (MB):	15,872.0	15,872.0
PGA use (MB):	4,870.3	5,033.5
% Host Mem used for SGA+PGA:	64.50	65.01

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

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	8,465.67	90.28
DB CPU	7,371.44	78.61
PL/SQL execution elapsed time	476.32	5.08
parse time elapsed	82.38	0.88
hard parse elapsed time	18.58	0.20
failed parse elapsed time	5.50	0.06
hard parse (sharing criteria) elapsed time	5.33	0.06
sequence load elapsed time	4.74	0.05
connection management call elapsed time	3.82	0.04
PL/SQL compilation elapsed time	2.33	0.02
inbound PL/SQL rpc elapsed time	0.47	0.01
hard parse (bind mismatch) elapsed time	0.25	0.00
repeated bind elapsed time	0.13	0.00
DB time	9,377.63
background elapsed time	668.61
background cpu time	29.47

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	747,209
IDLE_TIME	4,930,470
IOWAIT_TIME	86,138
NICE_TIME	33
SYS_TIME	35,298
USER_TIME	708,424
LOAD	3	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
10-Jan 14:00:58	2.51
10-Jan 15:00:03	2.07	13.16	12.48	0.62	86.84	1.52

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 100.3% of Total DB time 9,377.63 (s)
Total FG Wait Time: 2,031.73 (s) DB CPU time: 7,371.44 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			7,371		78.61
User I/O	98,989	0	420	4	4.48
Commit	38,342	0	390	10	4.16
Network	977,789	0	249	0	2.66
Application	2,121	0	10	5	0.10
Other	121,915	100	8	0	0.08
Configuration	17	18	2	145	0.03
Concurrency	2,695	19	2	1	0.03
System I/O	38	0	0	2	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
log file sync	38,342	0	390	10	0.84	4.16
db file sequential read	66,903	0	292	4	1.47	3.11
SQL*Net more data to client	194,992	0	220	1	4.29	2.34
direct path read	23,858	0	109	5	0.52	1.16
SQL*Net more data from client	50,195	0	29	1	1.10	0.30
SQL*Net break/reset to client	2,121	0	10	5	0.05	0.10
wait for a undo record	365	12	7	19	0.01	0.07
db file scattered read	1,823	0	7	4	0.04	0.07
direct path write	201	0	6	30	0.00	0.07
db file parallel read	368	0	3	9	0.01	0.04
log file switch completion	12	0	2	203	0.00	0.03
Disk file operations I/O	5,833	0	2	0	0.13	0.02
cursor: pin S wait on X	148	0	2	11	0.00	0.02
SQL*Net message to client	732,602	0	1	0	16.12	0.01
flashback log file sync	3	0	1	275	0.00	0.01
kksfbc child completion	11	100	1	51	0.00	0.01
buffer busy waits	1,157	0	0	0	0.03	0.00
enq: TX - index contention	23	0	0	13	0.00	0.00
PX Deq: Slave Session Stats	192	0	0	1	0.00	0.00
asynch descriptor resize	121,283	100	0	0	2.67	0.00
library cache: mutex X	512	0	0	0	0.01	0.00
control file sequential read	38	0	0	2	0.00	0.00
library cache lock	16	0	0	3	0.00	0.00
latch free	59	0	0	1	0.00	0.00
undo segment extension	3	100	0	11	0.00	0.00
latch: shared pool	78	0	0	0	0.00	0.00
cursor: mutex S	512	100	0	0	0.01	0.00
enq: SQ - contention	2	0	0	2	0.00	0.00
enq: TX - contention	1	0	0	5	0.00	0.00
latch: cache buffers chains	152	0	0	0	0.00	0.00
cursor: pin S	77	0	0	0	0.00	0.00
latch: row cache objects	20	0	0	0	0.00	0.00
PX qref latch	2	100	0	1	0.00	0.00
SQL*Net message from client	732,561	0	2,334,085	3186	16.11
jobq slave wait	8,436	100	4,224	501	0.19
PX Deq: Txn Recovery Start	303	0	14	47	0.01

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	41,612	0	346	8	0.92	51.78
db file parallel write	19,579	0	141	7	0.43	21.07
flashback log file write	1,653	0	49	30	0.04	7.36
control file parallel write	1,751	0	34	19	0.04	5.04
control file sequential read	6,869	0	28	4	0.15	4.11
db file sequential read	678	0	8	12	0.01	1.23
os thread startup	308	0	5	17	0.01	0.79
log file sequential read	67	0	3	43	0.00	0.43
SQL*Net break/reset to client	492	0	1	2	0.01	0.13
Disk file operations I/O	315	0	1	2	0.01	0.11
wait for stopper event to be increased	14	7	1	39	0.00	0.08
direct path read	29	0	0	16	0.00	0.07
flashback log file read	40	0	0	9	0.00	0.05
direct path write	13	0	0	25	0.00	0.05
flashback log file sync	7	0	0	45	0.00	0.05
log file switch completion	1	0	0	262	0.00	0.04
latch: call allocation	129	0	0	1	0.00	0.03
SQL*Net more data from client	299	0	0	1	0.01	0.03
db file scattered read	28	0	0	4	0.00	0.02
log file single write	6	0	0	14	0.00	0.01
log file sync	4	0	0	15	0.00	0.01
buffer busy waits	13	0	0	4	0.00	0.01
ADR block file write	5	0	0	10	0.00	0.01
ADR block file read	13	0	0	3	0.00	0.01
reliable message	184	0	0	0	0.00	0.01
latch free	44	0	0	1	0.00	0.00
latch: shared pool	28	0	0	0	0.00	0.00
PX Deq: Slave Session Stats	61	0	0	0	0.00	0.00
asynch descriptor resize	836	100	0	0	0.02	0.00
rdbms ipc reply	184	0	0	0	0.00	0.00
SQL*Net more data to client	298	0	0	0	0.01	0.00
PX Deq: Signal ACK EXT	101	0	0	0	0.00	0.00
enq: PS - contention	8	0	0	0	0.00	0.00
LGWR wait for redo copy	57	0	0	0	0.00	0.00
SQL*Net message to client	1,500	0	0	0	0.03	0.00
rdbms ipc message	58,145	30	63,405	1090	1.28
PX Idle Wait	26,209	99	52,104	1988	0.58
SQL*Net message from client	1,942	0	19,698	10143	0.04
DIAG idle wait	7,051	100	7,058	1001	0.16
Streams AQ: qmn slave idle wait	127	0	3,557	28010	0.00
Streams AQ: qmn coordinator idle wait	254	50	3,557	14005	0.01
Space Manager: slave idle wait	709	100	3,543	4997	0.02
pmon timer	1,905	59	3,543	1860	0.04
shared server idle wait	118	100	3,540	30002	0.00
dispatcher timer	59	100	3,540	60002	0.00
smon timer	19	32	3,351	176349	0.00
PX Deq: Join ACK	179	0	0	0	0.00
class slave wait	20	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	46.2			53.8
ADR block file write	5				40.0	60.0
ADR file lock	6	100.0
ARCH wait for archivelog lock	2	100.0
Disk file operations I/O	6150	99.8	.0		.0		.1	.0
LGWR wait for redo copy	57	100.0
Log archive I/O	3	100.0
PX Deq: Signal ACK EXT	101	100.0
PX Deq: Slave Session Stats	253	57.7	34.0	8.3
PX qref latch	2	100.0
SQL*Net break/reset to client	2613	67.7	.3	20.5	.6	1.8	3.3	5.7
SQL*Net message to client	734.9K	100.0
SQL*Net more data from client	50.6K	85.8	13.8	.3	.0	.0	.0	.1
SQL*Net more data to client	195.4K	99.1	.0	.0	.1	.2	.1	.6	.0
asynch descriptor resize	122.2K	100.0
buffer busy waits	1170	97.2	.7	.3	.7	.7	.3	.2
control file parallel write	1741				.6	47.4	46.7	5.3
control file sequential read	6878	57.5	1.8	5.7	21.7	8.9	2.8	1.6
cursor: mutex S	512	100.0
cursor: pin S	77	100.0
cursor: pin S wait on X	148					100.0
db file parallel read	368	11.1	2.2	8.7	34.5	32.9	9.0	1.6
db file parallel write	19.7K	13.7	12.6	21.8	27.3	12.5	9.8	2.2
db file scattered read	4283	83.4	2.0	.9	5.2	5.8	1.7	.9
db file sequential read	67.9K	46.3	3.1	7.9	25.0	14.6	2.1	1.0
direct path read	23.9K	35.5	7.7	14.4	27.3	11.9	2.3	1.0
direct path write	214	1.4	1.9	5.6	9.8	18.2	26.6	36.4
enq: PS - contention	8	100.0
enq: SQ - contention	2	50.0			50.0
enq: TX - contention	1				100.0
enq: TX - index contention	23	30.4		13.0	17.4	17.4	13.0	8.7
enq: TX - row lock contention	1								100.0
flashback log file read	40	12.5	2.5	17.5	37.5	22.5	2.5	5.0
flashback log file sync	10					20.0	20.0	60.0
flashback log file write	1652				5.2	18.5	51.0	25.3
kksfbc child completion	11							100.0
latch free	103	72.8	25.2	1.0		1.0
latch: cache buffers chains	152	100.0
latch: call allocation	129	32.6	43.4	24.0
latch: object queue header operation	1	100.0
latch: redo allocation	4	100.0
latch: row cache objects	20	100.0
latch: shared pool	106	89.6	8.5	.9	.9
library cache lock	16	68.8				31.3
library cache: mutex X	513	95.7	4.1	.2
log file parallel write	41.7K	.8	4.4	14.8	53.5	18.8	5.1	2.6
log file sequential read	64	17.2	3.1	1.6	1.6	12.5	39.1	25.0
log file single write	4				25.0	25.0	50.0
log file switch completion	11							100.0
log file sync	38.4K	.7	4.4	14.8	45.1	24.8	6.1	4.1
os thread startup	308					47.7	52.3
rdbms ipc reply	184	100.0
reliable message	184	99.5	.5
undo segment extension	3	33.3				33.3	33.3
wait for a undo record	365	37.3	2.5	10.7	14.8	11.2	6.6	17.0
wait for stopper event to be increased	14	42.9			7.1	7.1		42.9
DIAG idle wait	7057							100.0
PX Deq: Join ACK	179	94.4	5.6
PX Deq: Txn Recovery Start	302	6.0	6.3	10.6	15.9	8.3	12.3	40.7
PX Idle Wait	26.3K	.0		.0	.0	.0	.0	.7	99.3
SQL*Net message from client	735.3K	7.4	.9	17.1	5.6	6.5	8.9	45.2	8.4
Space Manager: slave idle wait	710								100.0
Streams AQ: qmn coordinator idle wait	254	50.0							50.0
Streams AQ: qmn slave idle wait	127								100.0
class slave wait	20	100.0
dispatcher timer	59								100.0
jobq slave wait	8436							100.0
pmon timer	1906	34.1	.1					3.0	62.9
rdbms ipc message	58.2K	9.2	1.3	1.7	3.4	8.7	9.6	44.4	21.7
shared server idle wait	118								100.0
smon timer	19								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
		% of Total Waits
Disk file operations I/O	3	100.0		.0		.0
SQL*Net break/reset to client	150	94.3	5.6	.0	.0	.0
SQL*Net more data from client	39	99.9		.0	.0	.0	.0
SQL*Net more data to client	1106	99.4	.1	.2	.2	.1	.0	.0
buffer busy waits	2	99.8	.2
control file parallel write	92	94.7	4.4	.7	.2	.1
control file sequential read	111	98.4	1.2	.3	.1
db file parallel read	6	98.4	1.1	.5
db file parallel write	427	97.8	1.9	.2	.0	.0
db file scattered read	39	99.1	.6	.1	.2
db file sequential read	695	99.0	.8	.2	.0	.0
direct path read	241	99.0	.8	.1	.0	.0
direct path write	78	63.6	27.6	7.9	.9
enq: TX - index contention	2	91.3	4.3	4.3
flashback log file read	2	95.0	5.0
flashback log file sync	6	40.0	30.0	20.0			10.0
flashback log file write	418	74.7	16.2	8.4	.6	.1
kksfbc child completion	11		100.0
log file parallel write	1094	97.4	2.0	.6	.1	.0
log file sequential read	16	75.0	7.8	6.3	10.9
log file switch completion	11		9.1	18.2	36.4	36.4
log file sync	1562	95.9	2.5	1.2	.3	.0	.0
wait for a undo record	62	83.0	3.0	14.0
wait for stopper event to be increased	6	57.1		42.9

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes) h is 4096*1024 milliseconds (approximately 70 minutes or 1.17 hours)
% 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 4m to 1h	<2m	<4m	<8m	<1/4h	<1/2h	< 1h	>=1h
		% of Total Waits
enq: TX - row lock contention	1					100.0

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
orcl	8,535	6,777	158	956,201
SYS$USERS	829	590	23	32,556
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	76070	297	1104	1	783810	233
SYS$USERS	22802	123	304	1	193971	16
SYS$BACKGROUND	1143	10	1602	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 73.1% of Total DB Time (s): 9,378
Captured PL/SQL account for 16.8% of Total DB Time (s): 9,378

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
943.12	1	943.12	10.06	0.00	0.00	51616g4hxd2u9	????????\????????????\??????????????	update F_SEND set APP_DATE = :...
513.90	249	2.06	5.48	99.97	0.00	b0nrxjw98cjha	kwappserver.exe	select t.??????, t.?????? RID,...
509.17	249	2.04	5.43	99.97	0.00	c27zt11fdgxg3	kwappserver.exe	select count(*) from ( select ...
502.31	10	50.23	5.36	99.89	0.10	3r0ay6u2jtcgr	kwappserver.exe	declare v_type varchar2(40); b...
501.73	10	50.17	5.35	99.96	0.03	02736fx6r61na	kwappserver.exe	INSERT INTO TT_kwbs3_BILLQRYAL...
401.52	2	200.76	4.28	99.80	0.19	gydxt0d1r5u17	????????????	begin --raise_application_erro...
400.81	2,679,584	0.00	4.27	99.85	0.00	61g4p0147sg6g	kwappserver.exe	SELECT COUNT(*) FROM ?????? A ...
399.00	2	199.50	4.25	99.96	0.03	9rsattbtc5dnw	????????????	select id, type, ??, ??, ??, ?...
331.39	28	11.84	3.53	99.99	0.00	gaw3pc7vbdf69	kwbs	SELECT ((SELECT count(*) FROM ...
321.20	142	2.26	3.43	99.95	0.03	8b7dcr1p97g5d	????????????	SELECT :"SYS_B_00" ChildCount,...
317.52	2,995,674	0.00	3.39	93.23	7.14	8b5c0u498ufmg	kwappserver.exe	SELECT T.F_LEVEL_ID FROM F_STO...
273.51	13,623,309	0.00	2.92	100.20	0.00	01tt82rqxjavd	kwappserver.exe	SELECT ??????, ???? FROM ???? ...
217.61	32	6.80	2.32	99.60	0.36	czbr3h176gcrj	????????	INSERT INTO TT_BILL_QUERY (ID,...
191.92	7,207,593	0.00	2.05	101.92	0.08	76t78dxcavf4n	kwappserver.exe	SELECT VALUE FROM TS_CUBPENVS ...
188.12	78	2.41	2.01	99.36	0.63	asw0k18ru88y3	????????\????????	SELECT NVL(PKG_SX_kwbs_EX.STK_...
188.09	78	2.41	2.01	99.36	0.63	54f9wvbttny1b	????????\????????	SELECT SUM(QTY), MAX(??_??), M...
185.73	238	0.78	1.98	99.92	0.01	0tgwauk52nu5y	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
153.94	156	0.99	1.64	99.35	0.63	4t5muy9n6ua4s	??????	declare v_rtn varchar2(2000); ...
150.46	2	75.23	1.60	100.00	0.00	5vbgvgyzy1y4p	????????\????????	SELECT ((SELECT count(*) FROM ...
148.66	17	8.74	1.59	96.32	3.61	3z7awvju0qa5u	????????	begin if :p_action = '??' then...
148.21	17	8.72	1.58	96.42	3.50	0k30kvsqp2atq	????????	INSERT INTO TT_BILL_QUERY (ID,...
142.76	13	10.98	1.52	99.99	0.00	b948cyb8fdga1	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
136.83	6	22.81	1.46	99.97	0.03	bmt4znqvbgcx7	????????	begin if :p_action = '??' then...
123.66	141	0.88	1.32	99.82	0.00	cxxnuaa8y3fqu	kwappserver.exe	SELECT ((SELECT count(*) FROM ...
118.22	16	7.39	1.26	99.63	0.34	gukzhpj5njv4v	????????	begin /* p_??: INTEGER = 1; p_...
116.08	190	0.61	1.24	98.93	1.06	apfzy1kgwfwgm	kwappserver.exe	select * from (select t.id, pk...
114.01	330	0.35	1.22	99.54	0.37	fu2n26suy5m5w	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...

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 79.6% of Total CPU Time (s): 7,371
Captured PL/SQL account for 20.9% of Total CPU Time (s): 7,371

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
513.75	249	2.06	6.97	513.90	99.97	0.00	b0nrxjw98cjha	kwappserver.exe	select t.??????, t.?????? RID,...
509.00	249	2.04	6.90	509.17	99.97	0.00	c27zt11fdgxg3	kwappserver.exe	select count(*) from ( select ...
501.77	10	50.18	6.81	502.31	99.89	0.10	3r0ay6u2jtcgr	kwappserver.exe	declare v_type varchar2(40); b...
501.54	10	50.15	6.80	501.73	99.96	0.03	02736fx6r61na	kwappserver.exe	INSERT INTO TT_kwbs3_BILLQRYAL...
400.72	2	200.36	5.44	401.52	99.80	0.19	gydxt0d1r5u17	????????????	begin --raise_application_erro...
400.23	2,679,584	0.00	5.43	400.81	99.85	0.00	61g4p0147sg6g	kwappserver.exe	SELECT COUNT(*) FROM ?????? A ...
398.83	2	199.41	5.41	399.00	99.96	0.03	9rsattbtc5dnw	????????????	select id, type, ??, ??, ??, ?...
331.35	28	11.83	4.50	331.39	99.99	0.00	gaw3pc7vbdf69	kwbs	SELECT ((SELECT count(*) FROM ...
321.03	142	2.26	4.36	321.20	99.95	0.03	8b7dcr1p97g5d	????????????	SELECT :"SYS_B_00" ChildCount,...
296.01	2,995,674	0.00	4.02	317.52	93.23	7.14	8b5c0u498ufmg	kwappserver.exe	SELECT T.F_LEVEL_ID FROM F_STO...
274.05	13,623,309	0.00	3.72	273.51	100.20	0.00	01tt82rqxjavd	kwappserver.exe	SELECT ??????, ???? FROM ???? ...
216.75	32	6.77	2.94	217.61	99.60	0.36	czbr3h176gcrj	????????	INSERT INTO TT_BILL_QUERY (ID,...
195.60	7,207,593	0.00	2.65	191.92	101.92	0.08	76t78dxcavf4n	kwappserver.exe	SELECT VALUE FROM TS_CUBPENVS ...
186.92	78	2.40	2.54	188.12	99.36	0.63	asw0k18ru88y3	????????\????????	SELECT NVL(PKG_SX_kwbs_EX.STK_...
186.89	78	2.40	2.54	188.09	99.36	0.63	54f9wvbttny1b	????????\????????	SELECT SUM(QTY), MAX(??_??), M...
185.58	238	0.78	2.52	185.73	99.92	0.01	0tgwauk52nu5y	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
152.94	156	0.98	2.07	153.94	99.35	0.63	4t5muy9n6ua4s	??????	declare v_rtn varchar2(2000); ...
150.46	2	75.23	2.04	150.46	100.00	0.00	5vbgvgyzy1y4p	????????\????????	SELECT ((SELECT count(*) FROM ...
143.18	17	8.42	1.94	148.66	96.32	3.61	3z7awvju0qa5u	????????	begin if :p_action = '??' then...
142.90	17	8.41	1.94	148.21	96.42	3.50	0k30kvsqp2atq	????????	INSERT INTO TT_BILL_QUERY (ID,...
142.74	13	10.98	1.94	142.76	99.99	0.00	b948cyb8fdga1	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
136.79	6	22.80	1.86	136.83	99.97	0.03	bmt4znqvbgcx7	????????	begin if :p_action = '??' then...
123.43	141	0.88	1.67	123.66	99.82	0.00	cxxnuaa8y3fqu	kwappserver.exe	SELECT ((SELECT count(*) FROM ...
117.78	16	7.36	1.60	118.22	99.63	0.34	gukzhpj5njv4v	????????	begin /* p_??: INTEGER = 1; p_...
114.83	190	0.60	1.56	116.08	98.93	1.06	apfzy1kgwfwgm	kwappserver.exe	select * from (select t.id, pk...
113.49	330	0.34	1.54	114.01	99.54	0.37	fu2n26suy5m5w	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
90.82	856	0.11	1.23	91.56	99.19	0.59	fjghawb6vvf88	BA_java	select t.*, t.rowid, d.receive...
88.16	106	0.83	1.20	88.28	99.87	0.08	210rw3q22c99c	kwappserver.exe	select t.*, t.rowid, (select q...
87.45	126	0.69	1.19	87.76	99.65	0.26	grqzp6jktp876	??????	SELECT :"SYS_B_00" ChildCount,...
85.22	7	12.17	1.16	85.23	99.98	0.00	0gvkd0rqhnzyb	??????	SELECT ((SELECT count(*) FROM ...

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 10.2% of Total User I/O Wait Time (s): 430
Captured PL/SQL account for 7.0% of Total User I/O Wait Time (s): 430

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
22.66	2,995,674	0.00	5.26	317.52	93.23	7.14	8b5c0u498ufmg	kwappserver.exe	SELECT T.F_LEVEL_ID FROM F_STO...
11.67	4,915	0.00	2.71	16.59	30.31	70.36	d60w0vs5t8b9f	kwappserver.exe	begin Pkg_CellTree.DoCellTreeV...
9.59	16,722	0.00	2.23	21.85	54.25	43.91	48kuxbj2zcsj0	kwappserver.exe	begin pkg_celltree.CTLog(:p1, ...
5.37	17	0.32	1.25	148.66	96.32	3.61	3z7awvju0qa5u	????????	begin if :p_action = '??' then...
5.19	17	0.31	1.21	148.21	96.42	3.50	0k30kvsqp2atq	????????	INSERT INTO TT_BILL_QUERY (ID,...
3.07	4,538	0.00	0.71	4.09	24.61	74.93	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
1.79	216	0.01	0.42	1.89	6.60	94.29	g4kj2fu199302	BA_java	insert into F2_SALE_ORDER_D ( ...
1.64	139	0.01	0.38	1.71	4.79	95.89	1hpjnsmy83yas	BA_java	insert into F2_REQPART_D ( ID,...
1.23	190	0.01	0.29	116.08	98.93	1.06	apfzy1kgwfwgm	kwappserver.exe	select * from (select t.id, pk...
1.18	78	0.02	0.27	188.09	99.36	0.63	54f9wvbttny1b	????????\????????	SELECT SUM(QTY), MAX(??_??), M...

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: 988,874,758
Captured SQL account for 98.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
213,131,930	2,679,584	79.54	21.55	400.81	99.85	0.00	61g4p0147sg6g	kwappserver.exe	SELECT COUNT(*) FROM ?????? A ...
131,723,107	10	13,172,310.70	13.32	502.31	99.89	0.10	3r0ay6u2jtcgr	kwappserver.exe	declare v_type varchar2(40); b...
131,706,057	10	13,170,605.70	13.32	501.73	99.96	0.03	02736fx6r61na	kwappserver.exe	INSERT INTO TT_kwbs3_BILLQRYAL...
118,588,382	2	59,294,191.00	11.99	401.52	99.80	0.19	gydxt0d1r5u17	????????????	begin --raise_application_erro...
118,555,922	2	59,277,961.00	11.99	399.00	99.96	0.03	9rsattbtc5dnw	????????????	select id, type, ??, ??, ??, ?...
79,001,132	32	2,468,785.38	7.99	217.61	99.60	0.36	czbr3h176gcrj	????????	INSERT INTO TT_BILL_QUERY (ID,...
41,430,802	17	2,437,106.00	4.19	148.66	96.32	3.61	3z7awvju0qa5u	????????	begin if :p_action = '??' then...
41,419,496	17	2,436,440.94	4.19	148.21	96.42	3.50	0k30kvsqp2atq	????????	INSERT INTO TT_BILL_QUERY (ID,...
40,865,175	13,623,309	3.00	4.13	273.51	100.20	0.00	01tt82rqxjavd	kwappserver.exe	SELECT ??????, ???? FROM ???? ...
34,035,973	13	2,618,151.77	3.44	142.76	99.99	0.00	b948cyb8fdga1	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
33,641,566	16	2,102,597.88	3.40	118.22	99.63	0.34	gukzhpj5njv4v	????????	begin /* p_??: INTEGER = 1; p_...
28,583,461	238	120,098.58	2.89	185.73	99.92	0.01	0tgwauk52nu5y	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
27,688,384	78	354,979.28	2.80	188.12	99.36	0.63	asw0k18ru88y3	????????\????????	SELECT NVL(PKG_SX_kwbs_EX.STK_...
27,688,072	78	354,975.28	2.80	188.09	99.36	0.63	54f9wvbttny1b	????????\????????	SELECT SUM(QTY), MAX(??_??), M...
26,837,334	330	81,325.25	2.71	114.01	99.54	0.37	fu2n26suy5m5w	kwappserver.exe	SELECT :"SYS_B_00" ChildCount,...
23,898,847	249	95,979.31	2.42	513.90	99.97	0.00	b0nrxjw98cjha	kwappserver.exe	select t.??????, t.?????? RID,...
23,791,400	249	95,547.79	2.41	509.17	99.97	0.00	c27zt11fdgxg3	kwappserver.exe	select count(*) from ( select ...
23,626,318	2,995,674	7.89	2.39	317.52	93.23	7.14	8b5c0u498ufmg	kwappserver.exe	SELECT T.F_LEVEL_ID FROM F_STO...
23,326,922	156	149,531.55	2.36	153.94	99.35	0.63	4t5muy9n6ua4s	??????	declare v_rtn varchar2(2000); ...
22,934,432	28	819,086.86	2.32	331.39	99.99	0.00	gaw3pc7vbdf69	kwbs	SELECT ((SELECT count(*) FROM ...
19,720,534	142	138,877.00	1.99	321.20	99.95	0.03	8b7dcr1p97g5d	????????????	SELECT :"SYS_B_00" ChildCount,...
14,561,412	141	103,272.43	1.47	123.66	99.82	0.00	cxxnuaa8y3fqu	kwappserver.exe	SELECT ((SELECT count(*) FROM ...
14,396,937	7,207,593	2.00	1.46	191.92	101.92	0.08	76t78dxcavf4n	kwappserver.exe	SELECT VALUE FROM TS_CUBPENVS ...
14,340,990	2	7,170,495.00	1.45	150.46	100.00	0.00	5vbgvgyzy1y4p	????????\????????	SELECT ((SELECT count(*) FROM ...
10,987,226	6	1,831,204.33	1.11	136.83	99.97	0.03	bmt4znqvbgcx7	????????	begin if :p_action = '??' then...

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: 195,163
Captured SQL account for 5.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
7,312	2,995,674	0.00	3.75	317.52	93.23	7.14	8b5c0u498ufmg	kwappserver.exe	SELECT T.F_LEVEL_ID FROM F_STO...
1,230	4,915	0.25	0.63	16.59	30.31	70.36	d60w0vs5t8b9f	kwappserver.exe	begin Pkg_CellTree.DoCellTreeV...
1,139	16,722	0.07	0.58	21.85	54.25	43.91	48kuxbj2zcsj0	kwappserver.exe	begin pkg_celltree.CTLog(:p1, ...
1,023	17	60.18	0.52	148.66	96.32	3.61	3z7awvju0qa5u	????????	begin if :p_action = '??' then...
864	17	50.82	0.44	148.21	96.42	3.50	0k30kvsqp2atq	????????	INSERT INTO TT_BILL_QUERY (ID,...
420	4,538	0.09	0.22	4.09	24.61	74.93	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
276	190	1.45	0.14	116.08	98.93	1.06	apfzy1kgwfwgm	kwappserver.exe	select * from (select t.id, pk...
246	216	1.14	0.13	1.89	6.60	94.29	g4kj2fu199302	BA_java	insert into F2_SALE_ORDER_D ( ...
241	2	120.50	0.12	401.52	99.80	0.19	gydxt0d1r5u17	????????????	begin --raise_application_erro...
231	10	23.10	0.12	502.31	99.89	0.10	3r0ay6u2jtcgr	kwappserver.exe	declare v_type varchar2(40); b...

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: 112,134
Captured SQL account for 8.7% of Total
Total UnOptimized Read Requests: 112,134
Captured SQL account for 8.7% 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	%Total	SQL Id	SQL Module	SQL Text
7,313	7,313	2,995,674	0.00	6.52	8b5c0u498ufmg	kwappserver.exe	SELECT T.F_LEVEL_ID FROM F_STO...
1,230	1,230	4,915	0.25	1.10	d60w0vs5t8b9f	kwappserver.exe	begin Pkg_CellTree.DoCellTreeV...
1,139	1,139	16,722	0.07	1.02	48kuxbj2zcsj0	kwappserver.exe	begin pkg_celltree.CTLog(:p1, ...
1,023	1,023	17	60.18	0.91	3z7awvju0qa5u	????????	begin if :p_action = '??' then...
864	864	17	50.82	0.77	0k30kvsqp2atq	????????	INSERT INTO TT_BILL_QUERY (ID,...
420	420	4,538	0.09	0.37	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
276	276	190	1.45	0.25	apfzy1kgwfwgm	kwappserver.exe	select * from (select t.id, pk...
241	241	2	120.50	0.21	gydxt0d1r5u17	????????????	begin --raise_application_erro...
231	231	10	23.10	0.21	3r0ay6u2jtcgr	kwappserver.exe	declare v_type varchar2(40); b...
150	150	78	1.92	0.13	54f9wvbttny1b	????????\????????	SELECT SUM(QTY), MAX(??_??), M...

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: 46,170,532
Captured SQL account for 57.8% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
13,623,309	13,615,021	1.00	273.51	100.20	0.00	01tt82rqxjavd	kwappserver.exe	SELECT ??????, ???? FROM ???? ...
7,207,593	7,195,982	1.00	191.92	101.92	0.08	76t78dxcavf4n	kwappserver.exe	SELECT VALUE FROM TS_CUBPENVS ...
2,995,674	2,680,960	0.89	317.52	93.23	7.14	8b5c0u498ufmg	kwappserver.exe	SELECT T.F_LEVEL_ID FROM F_STO...
2,679,584	2,679,518	1.00	400.81	99.85	0.00	61g4p0147sg6g	kwappserver.exe	SELECT COUNT(*) FROM ?????? A ...
55,629	338,123	6.08	7.44	100.12	0.04	3k94ugcdabmx4	????kwbs????	select celltree_urid, CELLTREE...
31,552	275,263	8.72	7.27	97.00	0.00	dxznqjbksb0tb	????kwbs????	select cttreenode_urid, cttree...
16,722	16,722	1.00	21.85	54.25	43.91	48kuxbj2zcsj0	kwappserver.exe	begin pkg_celltree.CTLog(:p1, ...
11,113	11,112	1.00	5.44	92.65	5.75	4wb1dqbwf64kd	kwappserver.exe	begin :doa__value := Pkg_CellT...
10,330	10,291	1.00	0.83	101.28	0.00	3f49wxysh2t0v	kwappserver.exe	SELECT ???? FROM ???? WHERE ??...
9,983	9,983	1.00	25.23	96.62	0.00	4g7rsp31dss71	BA_java	select pkg_celltree.CheckCell...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 830,697
Captured SQL account for 20.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
55,629	55,629	6.70	3k94ugcdabmx4	????kwbs????	select celltree_urid, CELLTREE...
31,552	31,552	3.80	dxznqjbksb0tb	????kwbs????	select cttreenode_urid, cttree...
16,722	16,722	2.01	48kuxbj2zcsj0	kwappserver.exe	begin pkg_celltree.CTLog(:p1, ...
11,113	11,113	1.34	4wb1dqbwf64kd	kwappserver.exe	begin :doa__value := Pkg_CellT...
10,100	10,330	1.22	3f49wxysh2t0v	kwappserver.exe	SELECT ???? FROM ???? WHERE ??...
9,983	9,983	1.20	4g7rsp31dss71	BA_java	select pkg_celltree.CheckCell...
9,345	9,345	1.12	duwcj27kc16m8	BA_java	begin :RESULT := Common.GetRes...
7,547	7,558	0.91	8zgzyw9r0bgbb	kwappserver.exe	begin select ???? into :v_Resu...
7,461	7,461	0.90	cm5vu20fhtnq1		select /*+ connect_by_filterin...
7,447	7,447	0.90	86050uqtj0sfr	kwappserver.exe	begin :result := pkg_sx_kwbs.i...

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
21,081,216		0.41	9n4qwuk35d6hg		update F2_SALE_ORDER set ORGID...
2,448,702	69	0.05	6ktz04w5hztk5	BA_java	insert into F2_SALE_ORDER ( ID...
1,213,968	4	0.02	5mykk74xr35dd	????????	select distinct ??, ??, ??, ??...
1,181,786	2	0.02	04dn798sjfkxm	????????	select distinct ??, ??, ??, ??...

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
208		9n4qwuk35d6hg		update F2_SALE_ORDER set ORGID...
30	69	6ktz04w5hztk5	BA_java	insert into F2_SALE_ORDER ( ID...

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	580	0.16	0.01
Batched IO (full) vector count	0	0.00	0.00
Batched IO (space) vector count	0	0.00	0.00
Batched IO block miss count	3,944	1.11	0.09
Batched IO buffer defrag count	37	0.01	0.00
Batched IO double miss count	288	0.08	0.01
Batched IO same unit count	2,098	0.59	0.05
Batched IO single block count	489	0.14	0.01
Batched IO slow jump count	53	0.01	0.00
Batched IO vector block count	1,312	0.37	0.03
Batched IO vector read count	367	0.10	0.01
Block Cleanout Optim referenced	335	0.09	0.01
CCursor + sql area evicted	9	0.00	0.00
CPU used by this session	730,980	206.24	16.08
CPU used when call started	729,571	205.84	16.05
CR blocks created	71,231	20.10	1.57
Cached Commit SCN referenced	64,677	18.25	1.42
Commit SCN cached	2,213	0.62	0.05
DB time	1,430,642	403.65	31.47
DBWR checkpoint buffers written	31,499	8.89	0.69
DBWR checkpoints	3	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	31,499	8.89	0.69
DBWR transaction table writes	210	0.06	0.00
DBWR undo block writes	6,082	1.72	0.13
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	0	0.00	0.00
HSC Heap Segment Block Changes	170,768	48.18	3.76
Heap Segment Array Inserts	8,273	2.33	0.18
Heap Segment Array Updates	9,155	2.58	0.20
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	38,728	10.93	0.85
PX local messages recv'd	297	0.08	0.01
PX local messages sent	198	0.06	0.00
Parallel operations not downgraded	0	0.00	0.00
RowCR - row contention	3,090	0.87	0.07
RowCR attempts	14,590,902	4,116.73	320.97
RowCR hits	14,593,026	4,117.33	321.02
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment recovery	8	0.00	0.00
SMON posted for undo segment shrink	5	0.00	0.00
SQL*Net roundtrips to/from client	732,769	206.75	16.12
active txn count during cleanout	121,222	34.20	2.67
application wait time	95,867	27.05	2.11
background checkpoints completed	2	0.00	0.00
background checkpoints started	3	0.00	0.00
background timeouts	17,291	4.88	0.38
branch node splits	4	0.00	0.00
buffer is not pinned count	547,415,298	154,449.87	12,041.96
buffer is pinned count	1,772,410,838	500,074.86	38,989.22
bytes received via SQL*Net from client	335,463,584	94,649.00	7,379.48
bytes sent via SQL*Net to client	664,760,592	187,558.13	14,623.30
calls to get snapshot scn: kcmgss	46,052,413	12,993.41	1,013.05
calls to kcmgas	140,864	39.74	3.10
calls to kcmgcs	1,228,491	346.61	27.02
cell physical IO interconnect bytes	2,996,214,784	845,363.65	65,910.27
change write time	654	0.18	0.01
cleanout - number of ktugct calls	80,458	22.70	1.77
cleanouts and rollbacks - consistent read gets	67,597	19.07	1.49
cleanouts only - consistent read gets	806	0.23	0.02
cluster key scan block gets	45,251	12.77	1.00
cluster key scans	29,385	8.29	0.65
commit batch performed	2	0.00	0.00
commit batch requested	2	0.00	0.00
commit batch/immediate performed	329	0.09	0.01
commit batch/immediate requested	329	0.09	0.01
commit cleanout failures: block lost	13,345	3.77	0.29
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	58	0.02	0.00
commit cleanout failures: cannot pin	6	0.00	0.00
commit cleanouts	140,958	39.77	3.10
commit cleanouts successfully completed	127,511	35.98	2.80
commit immediate performed	327	0.09	0.01
commit immediate requested	327	0.09	0.01
commit txn count during cleanout	22,409	6.32	0.49
concurrency wait time	777	0.22	0.02
consistent changes	559,414	157.84	12.31
consistent gets	987,919,100	278,735.32	21,732.09
consistent gets - examination	387,295,798	109,273.14	8,519.67
consistent gets direct	45,774	12.91	1.01
consistent gets from cache	987,873,329	278,722.41	21,731.08
consistent gets from cache (fastpath)	489,859,854	138,210.96	10,775.86
cursor authentications	971	0.27	0.02
data blocks consistent reads - undo records applied	421,787	119.00	9.28
db block changes	954,724	269.37	21.00
db block gets	955,190	269.50	21.01
db block gets direct	5,823	1.64	0.13
db block gets from cache	949,367	267.86	20.88
db block gets from cache (fastpath)	193,034	54.46	4.25
deferred (CURRENT) block cleanout applications	68,699	19.38	1.51
dirty buffers inspected	1,232	0.35	0.03
enqueue conversions	1,683	0.47	0.04
enqueue deadlocks	0	0.00	0.00
enqueue releases	206,320	58.21	4.54
enqueue requests	206,511	58.27	4.54
enqueue timeouts	9	0.00	0.00
enqueue waits	35	0.01	0.00
execute count	46,170,532	13,026.73	1,015.65
failed probes on index block reclamation	1	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	2,285,903,114	644,953.56	50,284.94
flashback log write bytes	327,778,304	92,480.64	7,210.42
flashback log writes	1,636	0.46	0.04
free buffer inspected	171,490	48.38	3.77
free buffer requested	225,830	63.72	4.97
heap block compress	33,683	9.50	0.74
hot buffers moved to head of LRU	397,396	112.12	8.74
immediate (CR) block cleanout applications	68,403	19.30	1.50
immediate (CURRENT) block cleanout applications	5,168	1.46	0.11
index crx upgrade (positioned)	23,129	6.53	0.51
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	5,257	1.48	0.12
index fetch by key	144,108,278	40,659.27	3,170.07
index scans kdiixs1	99,640,352	28,112.92	2,191.87
leaf node 90-10 splits	260	0.07	0.01
leaf node splits	440	0.12	0.01
lob reads	11,416	3.22	0.25
lob writes	620	0.17	0.01
lob writes unaligned	620	0.17	0.01
logons cumulative	861	0.24	0.02
max cf enq hold time	230	0.06	0.01
messages received	61,825	17.44	1.36
messages sent	61,825	17.44	1.36
min active SCN optimization applied on CR	721	0.20	0.02
no buffer to keep pinned count	85,583	24.15	1.88
no work - consistent read gets	578,139,887	163,118.63	12,717.83
non-idle wait count	1,368,629	386.15	30.11
non-idle wait time	265,198	74.82	5.83
opened cursors cumulative	46,281,283	13,057.98	1,018.09
parse count (describe)	5	0.00	0.00
parse count (failures)	37,759	10.65	0.83
parse count (hard)	39,126	11.04	0.86
parse count (total)	830,697	234.38	18.27
parse time cpu	6,448	1.82	0.14
parse time elapsed	6,772	1.91	0.15
physical read IO requests	112,134	31.64	2.47
physical read bytes	1,599,012,864	451,151.69	35,174.84
physical read total IO requests	119,313	33.66	2.62
physical read total bytes	1,909,636,096	538,792.13	42,007.88
physical read total multi block requests	1,116	0.31	0.02
physical reads	195,163	55.06	4.29
physical reads cache	136,964	38.64	3.01
physical reads cache prefetch	66,360	18.72	1.46
physical reads direct	58,199	16.42	1.28
physical reads direct (lob)	52,310	14.76	1.15
physical reads direct temporary tablespace	0	0.00	0.00
physical reads for flashback new	6,462	1.82	0.14
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	24,664	6.96	0.54
physical write bytes	323,084,288	91,156.25	7,107.16
physical write total IO requests	71,895	20.28	1.58
physical write total bytes	1,086,578,688	306,571.52	23,902.39
physical write total multi block requests	1,591	0.45	0.03
physical writes	39,439	11.13	0.87
physical writes direct	5,891	1.66	0.13
physical writes direct (lob)	6	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	33,548	9.47	0.74
physical writes non checkpoint	26,588	7.50	0.58
pinned buffers inspected	4	0.00	0.00
pinned cursors current	250	0.07	0.01
prefetch clients - default	21	0.01	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	0	0.00	0.00
process last non-idle time	3,547	1.00	0.08
recursive calls	48,162,366	13,588.72	1,059.47
recursive cpu usage	419,843	118.46	9.24
redo blocks checksummed by FG (exclusive)	111,616	31.49	2.46
redo blocks written	366,771	103.48	8.07
redo buffer allocation retries	21	0.01	0.00
redo entries	539,542	152.23	11.87
redo k-bytes read total	185,994	52.48	4.09
redo log space requests	46	0.01	0.00
redo log space wait time	275	0.08	0.01
redo ordering marks	4,971	1.40	0.11
redo size	171,286,516	48,327.44	3,767.93
redo size for direct writes	47,914,108	13,518.67	1,054.01
redo subscn max counts	9,842	2.78	0.22
redo synch time	39,228	11.07	0.86
redo synch writes	38,376	10.83	0.84
redo wastage	10,341,628	2,917.83	227.49
redo write time	34,985	9.87	0.77
redo writes	41,621	11.74	0.92
rollback changes - undo records applied	29,363	8.28	0.65
rollbacks only - consistent read gets	3,738	1.05	0.08
rows fetched via callback	70,272,036	19,826.82	1,545.83
session connect time	0	0.00	0.00
session cursor cache hits	5,236,952	1,477.57	115.20
session logical reads	988,874,758	279,004.96	21,753.11
shared hash latch upgrades - no wait	21,146,356	5,966.31	465.17
shared hash latch upgrades - wait	11	0.00	0.00
sorts (memory)	416,589	117.54	9.16
sorts (rows)	48,863,798	13,786.62	1,074.90
sql area evicted	9	0.00	0.00
sql area purged	37,759	10.65	0.83
summed dirty queue length	8,453	2.38	0.19
switch current to new buffer	13,221	3.73	0.29
table fetch by rowid	1,033,992,135	291,734.55	22,745.60
table fetch continued row	28,020,427	7,905.79	616.39
table scan blocks gotten	158,149,556	44,620.93	3,478.95
table scan rows gotten	6,521,334,446	1,839,954.58	143,455.30
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	376,066	106.10	8.27
temp space allocated (bytes)	138,412,032	39,052.11	3,044.77
total cf enq hold time	18,280	5.16	0.40
total number of cf enq holders	338	0.10	0.01
total number of times SMON posted	13	0.00	0.00
transaction rollbacks	329	0.09	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	42,018,796	11,855.35	924.32
user I/O wait time	43,244	12.20	0.95
user calls	1,154,145	325.63	25.39
user commits	44,351	12.51	0.98
user rollbacks	1,108	0.31	0.02
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	222,928	62.90	4.90
write clones created in foreground	9	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,756,078,048	9,326,332,408
session cursor cache count	275,806	352,068
session uga memory	1,120,403,934,176	1,468,338,831,480
opened cursors current	4,197	4,715
workarea memory allocated	1,681,853	1,877,222
logons current	692	732
session pga memory	4,946,117,664	5,213,627,128
session uga memory max	15,286,213,960	18,798,342,480

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.05

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	1.2G	20.75	.343651	0M	0.00	0M	72.6K	3.98
Others	297M	2.15	.083796	568M	1.79	.160257	10.3K	10.45
Direct Reads	440M	11.22	.124143	10M	0.10	.002821	0
DBWR	0M	0.00	0M	265M	6.57	.074768	0
LGWR	0M	0.01	0M	180M	11.84	.050785	58	15.72
Direct Writes	0M	0.00	0M	3M	0.04	.000846	0
TOTAL:	1.9G	34.13	.551591	1G	20.34	.289479	83K	4.80

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.6G	32.12	.470898	306M	6.92	.086336	7.21	4.02
Log File	165M	0.05	.046553	179M	11.83	.050503	7.31	65.26
Flashback Log	4M	0.01	.001128	311M	0.47	.087746	8.39	14.50
Archive Log	0M	0.00	0M	171M	0.05	.048246
Control File	109M	1.94	.030753	55M	0.98	.015517	3.67	21.50
Temp File	1M	0.01	.000282	6M	0.09	.001692	6.24
TOTAL:	1.9G	34.13	.549616	1G	20.34	.290043	7.01	11.31

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	1.2G	20.76	.343369	0M	0.00	0M	72.3K	3.96
Buffer Cache Reads (Data File)	1.2G	20.76	.343369	0M	0.00	0M	72.3K	3.96
Others	289M	2.15	.081539	569M	1.79	.160539	8581	8.80
Others (Flashback Log)	4M	0.01	.001128	312M	0.47	.088028	1693	28.95
Others (Archive Log)	0M	0.00	0M	171M	0.05	.048246	0
Others (Control File)	109M	1.93	.030753	54M	0.97	.015235	6841	3.65
Others (Log File)	161M	0.05	.045425	0M	0.00	0M	9	9.44
Others (Data File)	15M	0.16	.004232	32M	0.30	.009028	38	38.95
Direct Reads	440M	11.22	.124143	10M	0.10	.002821	0
Direct Reads (Data File)	440M	11.22	.124143	10M	0.10	.002821	0
DBWR	0M	0.00	0M	265M	6.57	.074768	0
DBWR (Data File)	0M	0.00	0M	265M	6.57	.074768	0
LGWR	0M	0.01	0M	180M	11.84	.050785	38	9.95
LGWR (Log File)	0M	0.00	0M	179M	11.83	.050503	8	7.88
LGWR (Control File)	0M	0.01	0M	1M	0.01	.000282	30	10.50
Direct Writes	0M	0.00	0M	3M	0.04	.000846	0
Direct Writes (Data File)	0M	0.00	0M	3M	0.04	.000846	0
TOTAL:	1.9G	34.14	.549051	1G	20.34	.289761	80.9K	4.48

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	103,999	29	2.51	1.67	23,097	7	52	5.19
UNDOTBS1	5,991	2	6.24	1.00	702	0	2,825	0.06
SYSAUX	492	0	12.83	1.08	531	0	0	0.00
SYSTEM	249	0	5.98	1.54	39	0	7	1.43
TEMP	37	0	6.49	1.00	210	0	0	0.00
USERS	2	0	0.00	1.00	42	0	0	0.00
kwbsT	4	0	0.00	1.00	4	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	Buffer Waits	Av Buf Wt(ms)
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs01.DBF	5,582	2	1.41	1.59	526	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs02.DBF	4,298	1	1.72	2.12	432	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs03.DBF	6,760	2	1.19	1.67	483	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs04.DBF	7,546	2	0.94	1.47	419	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs05.DBF	4,953	1	1.19	1.55	640	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs06.DBF	5,731	2	1.19	1.62	454	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs07.DBF	4,298	1	1.30	1.37	323	1	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs08.DBF	1,973	1	2.50	1.54	390	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs09.DBF	4,552	1	1.47	1.47	395	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs10.DBF	3,381	1	1.98	1.71	520	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs11.dbf	4,562	1	1.87	2.03	459	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs12.DBF	2,639	1	3.42	3.84	780	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs13.DBF	4,778	1	1.94	1.67	825	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs14.DBF	3,413	1	2.70	2.01	502	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs15.DBF	6,909	2	1.55	1.69	705	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs16.DBF	3,019	1	3.77	2.03	697	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs17.DBF	3,404	1	3.95	1.94	661	29	8.62
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs18.DBF	3,358	1	2.92	1.94	640	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs19.DBF	2,997	1	4.77	1.71	990	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs20.DBF	2,351	1	5.22	1.87	1,203	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs21.DBF	3,564	1	4.97	1.04	1,560	1	20.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs22.DBF	3,168	1	5.09	1.29	1,692	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs23.DBF	2,375	1	5.28	1.15	1,735	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs24.DBF	1,883	1	6.08	1.10	1,700	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs25.DBF	2,296	1	4.65	1.09	1,441	20	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs26.DBF	1,806	1	3.58	1.10	1,372	0	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs27.DBF	1,094	0	5.65	1.17	974	1	0.00
kwbs	/oracle/ora11gr2/oradata/orcl/kwbs28.DBF	1,309	0	3.46	1.14	579	0	0.00
kwbsT	/oracle/ora11gr2/oradata/orcl/kwbsT.DBF	2	0	0.00	1.00	2	0	0.00
kwbsT	/oracle/ora11gr2/oradata/orcl/kwbsT2.dbf	2	0	0.00	1.00	2	0	0.00
SYSAUX	/oracle/ora11gr2/oradata/orcl/sysaux01.dbf	492	0	12.83	1.08	531	0	0.00
SYSTEM	/oracle/ora11gr2/oradata/orcl/system01.dbf	249	0	5.98	1.54	39	7	1.43
TEMP	/oracle/ora11gr2/oradata/orcl/temp01.dbf	37	0	6.49	1.00	210	0
UNDOTBS1	/oracle/ora11gr2/oradata/orcl/undotbs01.dbf	5,991	2	6.24	1.00	702	2,825	0.06
USERS	/oracle/ora11gr2/oradata/orcl/users01.dbf	2	0	0.00	1.00	42	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,230,957	100	988,338,799	130,663	33,548	0	0	2,885

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 39,439

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	31,499	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	98	16229	182303	180290	1658880	180290
E	0	99	16040	250764	249991	1658880	249991

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	189.90	325,516	1	4292354.00
D	1,536	0.15	189	87.50	149,987	1	1972503.00
D	2,304	0.23	284	47.16	80,833	1	1058537.00
D	3,072	0.31	379	24.24	41,554	1	539412.00
D	3,840	0.38	473	12.39	21,238	1	270908.00
D	4,608	0.46	568	7.87	13,483	1	168412.00
D	5,376	0.54	663	4.34	7,434	1	88468.00
D	6,144	0.62	758	2.50	4,280	1	46782.00
D	6,912	0.69	852	1.64	2,806	1	27306.00
D	7,680	0.77	947	1.28	2,193	1	19201.00
D	8,448	0.85	1,042	1.09	1,873	1	14968.00
D	9,216	0.92	1,136	1.04	1,784	1	13800.00
D	9,984	1.00	1,231	1.00	1,714	1	12875.00
D	10,752	1.08	1,326	0.97	1,667	1	12249.00
D	11,520	1.15	1,420	0.97	1,662	1	12190.00
D	12,288	1.23	1,515	0.97	1,662	1	12190.00
D	13,056	1.31	1,610	0.97	1,662	1	12190.00
D	13,824	1.38	1,704	0.97	1,662	1	12190.00
D	14,592	1.46	1,799	0.97	1,662	1	12190.00
D	15,360	1.54	1,894	0.94	1,604	1	11417.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
100.00	17,884	0

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
2K	4K	204,358	204,358
64K	128K	3,559	3,559
128K	256K	1,354	1,354
256K	512K	4,118	4,118
512K	1024K	4,782	4,782
1M	2M	3,996	3,996
2M	4M	277	277
4M	8M	263	263
8M	16M	63	63
16M	32M	25	25
32M	64M	11	11
64M	128M	33	33

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
1,344	0.13	91,282.68	84,822.40	52.00	3,540	356,167,846
2,688	0.25	91,282.68	62,781.59	59.00	2,165	311,590,889
5,376	0.50	91,282.68	60.65	100.00	0	184,739,458
8,064	0.75	91,282.68	60.65	100.00	0	184,739,458
10,752	1.00	91,282.68	60.65	100.00	0	184,739,458
12,902	1.20	91,282.68	0.00	100.00	0	184,616,794
15,053	1.40	91,282.68	0.00	100.00	0	184,616,794
17,203	1.60	91,282.68	0.00	100.00	0	184,616,794
19,354	1.80	91,282.68	0.00	100.00	0	184,616,794
21,504	2.00	91,282.68	0.00	100.00	0	184,616,794
32,256	3.00	91,282.68	0.00	100.00	0	184,616,794
43,008	4.00	91,282.68	0.00	100.00	0	184,616,794
64,512	6.00	91,282.68	0.00	100.00	0	184,616,794
86,016	8.00	91,282.68	0.00	100.00	0	184,616,794

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)
1,280	0.26	10	482	1,118,836	1.00	497	1.00	1,859
1,792	0.37	482	22,334	1,118,836	1.00	497	1.00	86,252
2,304	0.47	488	22,669	1,118,838	1.00	495	1.00	86,252
2,816	0.58	488	22,669	1,118,838	1.00	495	1.00	86,252
3,328	0.68	488	22,669	1,118,838	1.00	495	1.00	86,252
3,840	0.79	488	22,669	1,118,838	1.00	495	1.00	86,252
4,352	0.89	488	22,669	1,118,838	1.00	495	1.00	86,252
4,864	1.00	488	22,669	1,118,838	1.00	495	1.00	86,252
5,376	1.11	488	22,669	1,118,838	1.00	495	1.00	86,252
5,888	1.21	488	22,669	1,118,838	1.00	495	1.00	86,252
6,400	1.32	488	22,669	1,118,838	1.00	495	1.00	86,252
6,912	1.42	488	22,669	1,118,838	1.00	495	1.00	86,252
7,424	1.53	488	22,669	1,118,838	1.00	495	1.00	86,252
7,936	1.63	488	22,669	1,118,838	1.00	495	1.00	86,252
8,448	1.74	488	22,669	1,118,838	1.00	495	1.00	86,252
8,960	1.84	488	22,669	1,118,838	1.00	495	1.00	86,252
9,472	1.95	488	22,669	1,118,838	1.00	495	1.00	86,252
9,984	2.05	488	22,669	1,118,838	1.00	495	1.00	86,252

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
5,952	0.38	588,780	42,774,837
7,936	0.50	130,001	7,598,935
9,920	0.63	59,521	2,195,248
11,904	0.75	53,158	1,707,342
13,888	0.88	52,460	1,653,920
15,872	1.00	52,460	1,653,920
17,856	1.13	51,673	1,593,552
19,840	1.25	51,673	1,593,552
21,824	1.38	51,673	1,593,552
23,808	1.50	51,673	1,593,552
25,792	1.63	51,673	1,593,552
27,776	1.75	51,673	1,593,552
29,760	1.88	51,673	1,593,552
31,744	2.00	51,673	1,593,552

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	Avg Time (ms)
data block	58	5
undo block	2,816	0
undo header	9	7
segment header	1	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	6	1	6	1	1,747	1,747,140.00
TX-Transaction (index contention)	28	28	0	23	0	14.35
SQ-Sequence Cache	4,518	4,518	0	2	0	5.00
PS-PX Process Reservation	896	896	0	8	0	0.00
TX-Transaction	50,813	50,813	0	1	0	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	6.01	49,251	4,836	96	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
10-Jan 14:51	1,074	8,857	1,055	89	1,440	0/0	0/0/0/0/0/0
10-Jan 14:41	1,156	8,131	3,959	96	1,440	0/0	0/0/0/0/0/0
10-Jan 14:31	747	7,821	4,836	88	1,440	0/0	0/0/0/0/0/0
10-Jan 14:21	567	6,449	4,233	89	1,440	0/0	0/0/0/0/0/0
10-Jan 14:11	1,082	8,386	3,631	86	1,440	0/0	0/0/0/0/0/0
10-Jan 14:01	1,379	9,607	2,396	94	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	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0
ASM db client latch	2,706	0.00		0
ASM map operation hash table	1	0.00		0
ASM network state latch	213	0.00		0
AWR Alerted Metric Element list	66,432	0.00		0
Change Notification Hash table latch	1,182	0.00		0
Consistent RBA	41,617	0.00		0
DML lock allocation	55,091,618	0.00	0.00	0
Event Group Locks	749	0.00		0
FAL Queue	101	0.00		0
FIB s.o chain latch	48	0.00		0
FOB s.o list latch	11,223	0.00		0
File State Object Pool Parent Latch	1	0.00		0
IPC stats buffer allocation latch	1	0.00		0
In memory undo latch	1	0.00		0
JS Sh mem access	9	0.00		0
JS mem alloc latch	6	0.00		0
JS queue access latch	7	0.00		0
JS queue state obj latch	25,738	0.00		0
JS slv state obj latch	257	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	1	0.00		0
KJCT flow control latch	1	0.00		0
KMG MMAN ready and startup request latch	1,182	0.00		0
KTF sga latch	20	0.00		1,189	0.00
KWQMN job cache list latch	8	0.00		0
KWQP Prop Status	2	0.00		0
KWQS pqsubs latch	10	0.00		0
KWQS pqueue ctx latch	83	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	1	0.00		0
MQL Tracking Latch	0			71	0.00
Memory Management Latch	1	0.00		1,182	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	1	0.00		0
Minimum flashback SCN latch	2	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	4,119	0.00		0
OS process allocation	3,839	0.03	0.00	0
OS process: request allocation	1,426	0.07	0.00	0
PL/SQL warning settings	235,354	0.00	0.00	0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	16,667	0.00		0
SGA IO buffer pool latch	33	0.00		33	0.00
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	119	0.00		1,165	0.00
SQL memory manager workarea list latch	227,867	0.00	0.00	0
Shared B-Tree	350	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
WCR: sync	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
X$KSFQP	1	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	21,945	0.01	0.00	0
active service list	11,986	1.15	0.45	39,954	0.00
alert log latch	6	0.00		0
archive control	68	0.00		0
archive process latch	306	0.33	1.00	0
begin backup scn array	1,507	0.00		0
buffer pool	1	0.00		0
business card	1	0.00		0
cache buffer handles	1,016,562	0.01	0.00	0
cache buffers chains	1,593,982,887	0.03	0.00	501,636	0.00
cache buffers lru chain	66,413	0.00	0.00	548,507	0.01
cache table scan latch	2,219	0.00		2,220	0.00
call allocation	9,472	2.66	0.60	0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	1,475	0.00		0
channel operations parent latch	23,777	0.01	0.00	0
checkpoint queue latch	726,027	0.00		31,735	0.00
client/application info	31,424	0.00		0
compile environment latch	989	0.00		0
constraint object allocation	412	0.00		0
corrupted undo seg latch	88,622	0.01	0.00	0
cp cmon/server latch	1	0.00		0
cp pool latch	1	0.00		0
cp server hash latch	1	0.00		0
cp sga latch	213	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	213	0.00		0
dml lock allocation	215	0.00		0
done queue latch	1	0.00		0
dummy allocation	1,945	2.93	0.02	0
enqueue hash chains	415,408	0.01	0.00	324	0.00
enqueues	178,699	0.06	0.11	0
error message lists	390	27.69	0.00	0
fifth spare latch	1	0.00		0
file cache latch	444	0.00		0
flashback FBA barrier	2	0.00		0
flashback SCN barrier	4	0.00		0
flashback allocation	42,956	0.00	0.00	0
flashback copy	1	0.00		39,955	0.02
flashback hint SCN barrier	2	0.00		0
flashback mapping	1,633	0.00		0
flashback marker cache	4	0.00		0
flashback sync request	5,931	0.00		0
gc element	1	0.00		0
gcs commit scn state	1	0.00		0
gcs partitioned table hash	1	0.00		0
gcs pcm hashed value bucket hash	1	0.00		0
gcs resource freelist	1	0.00		0
gcs resource hash	1	0.00		0
gcs resource scan list	1	0.00		0
gcs shadows freelist	1	0.00		0
ges domain table	1	0.00		0
ges enqueue table freelist	1	0.00		0
ges group table	1	0.00		0
ges process hash list	1	0.00		0
ges process parent latch	1	0.00		0
ges resource hash list	1	0.00		0
ges resource scan list	1	0.00		0
ges resource table freelist	1	0.00		0
ges value block free list	1	0.00		0
global KZLD latch for mem in SGA	440	0.00		0
global tx hash mapping	433	0.00		0
granule operation	1	0.00		0
hash table column usage latch	373	0.00		44,311	0.00
hash table modification latch	182	0.00		0
heartbeat check	1	0.00		0
hint flashback FBA barrier	2	0.00		0
internal temp table object number allocation latch	3	0.00		0
intra txn parallel recovery	27,959	0.06	0.00	0
io pool granule metadata list	1	0.00		0
job workq parent latch	82	0.00		86	3.49
job_queue_processes free list latch	166	0.00		0
job_queue_processes parameter latch	852	0.00		0
k2q lock allocation	1	0.00		0
kcbtsemkid latch	3	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kks stats	2,836	0.00		0
kokc descriptor allocation latch	542	0.00		0
ksfv messages	1	0.00		0
kss move lock	41	0.00		0
ksuosstats global area	239	0.00		0
ksv allocation latch	293	0.00		0
ksv class latch	81	0.00		0
ksv msg queue latch	1	0.00		0
ksz_so allocation latch	1,426	0.00		0
ktm global data	46	0.00		0
kwqbsn:qsga	129	0.00		0
lgwr LWN SCN	41,656	0.00		0
list of block allocation	3,834	0.03	0.00	0
loader state object freelist	22,330	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	13	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	2	0.00		0
logminer work area	1	0.00		0
longop free list parent	60	0.00		28	0.00
managed standby latch	98	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	553	0.00		0
messages	204,883	0.01	0.00	0
mostly latch-free SCN	41,942	0.06	0.00	0
msg queue latch	1	0.00		0
multiblock read objects	5,677	0.00		0
name-service namespace bucket	1	0.00		0
ncodef allocation latch	213	0.00		0
object queue header heap	179,319	0.00		3,134	0.00
object queue header operation	692,781	0.00	0.25	0
object stats modification	3,058	0.00		0
parallel query alloc buffer	2,001	2.15	0.00	0
parallel query stats	205	47.32	0.31	0
parallel txn reco latch	22,654	0.24	0.00	0
parameter list	5,190	0.00		0
parameter table management	2,021	0.25	0.00	0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
post/wait queue	60,150	0.00	0.00	38,746	0.00
process allocation	1,734	0.06	1.00	748	0.00
process group creation	1,426	0.42	0.00	0
process queue	1,069	0.00		0
process queue reference	532,426	0.00	0.00	13,931	0.01
qmn task queue latch	517	0.00		0
query server freelists	1,075	1.77	0.32	0
query server process	160	0.00		128	0.00
queued dump request	12	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	128,653	0.06	0.05	539,170	0.13
redo copy	65	0.00		539,360	0.06
redo writing	149,562	0.00	0.00	0
resmgr group change latch	6,147	0.00		0
resmgr:active threads	1,939	0.00		0
resmgr:actses change group	734	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	1,938	3.41	0.03	0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	1	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	1,206,746	0.35	0.01	0
rules engine aggregate statistics	8	0.00		0
rules engine rule set statistics	116	0.00		0
second spare latch	1	0.00		0
sequence cache	281,571	0.00	0.00	0
session allocation	358,262	0.00	0.00	119,404	0.00
session idle bit	2,426,889	0.00	0.00	127	0.00
session queue latch	1	0.00		0
session state list latch	2,517	1.83	0.00	0
session switching	3,715	0.27	0.00	0
session timer	1,903	0.00		0
shared pool	1,200,775	0.22	0.04	0
shared pool sim alloc	99	0.00		0
shared pool simulator	3,785	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	52,174,565	0.00	0.00	0
simulator lru latch	9,027	0.09	0.00	52,153,571	0.10
sort extent pool	7,307	0.00		0
space background state object latch	10	0.00		0
space background task latch	2,622	0.04	0.00	2,364	0.00
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	125	0.00		0
temporary table state object allocation	608	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
third spare latch	1	0.00		0
threshold alerts latch	159	0.00		0
trace latch	59	0.00		0
transaction allocation	13,600,162	0.00		0
transaction branch allocation	2,395	0.08	0.00	0
undo global data	419,775	0.00	0.00	0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		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,593,982,887	535,508	164	535,357
row cache objects	1,206,746	4,243	22	4,224
shared pool	1,200,775	2,595	107	2,498
call allocation	9,472	252	152	131
active service list	11,986	138	62	90
enqueues	178,699	112	12	100
parallel query stats	205	97	30	71
redo allocation	128,653	77	4	73
resmgr:free threads list	1,938	66	2	64
dummy allocation	1,945	57	1	56
query server freelists	1,075	19	6	13
object queue header operation	692,781	4	1	3
archive process latch	306	1	1	0
process allocation	1,734	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	62	58
active service list	kswsgsnp: get service name ptr	14	8
active service list	kswsigsn: get service name	1	0
active service list	kswslogon: session login	1	9
archive process latch	kcrrsarc	1	0
cache buffers chains	kcbgcur_2	90	44
cache buffers chains	kcbgtcr: fast path (cr pin)	48	5
cache buffers chains	kcbgtcr_2	38	11
cache buffers chains	kcbgtcr: fast path	23	6
cache buffers chains	kcbrls_2	23	65
cache buffers chains	kcbgcur: fast path (shr)	14	1
cache buffers chains	kcbrls_1	9	56
cache buffers chains	kcbzwb	8	19
cache buffers chains	kcbget: pin buffer	6	0
cache buffers chains	kcbchg1: kslbegin: bufs not pinned	4	39
cache buffers chains	kcbchg1: kslbegin: call CR func	3	21
cache buffers chains	kcbnew: new latch again	1	0
call allocation	ksuxds	148	147
call allocation	ksursi0	4	4
dummy allocation	ktcscnfy	1	1
enqueues	ksqdel	11	11
enqueues	ksqgel: create enqueue	1	1
object queue header operation	kcbo_unlink_q	1	0
parallel query stats	kxfprst: KSLBEGIN:1	30	30
process allocation	ksucrp:1	1	0
query server freelists	kxfpobrmf	6	6
redo allocation	kcrfw_redo_gen: redo allocation 1	2	0
redo allocation	kcrfw_redo_gen: redo allocation 2	1	0
redo allocation	kcrfw_redo_gen: redo allocation 3	1	2
resmgr:free threads list	kskthrcreate	2	2
row cache objects	kqrpre: find obj	18	10
row cache objects	kqreqd: reget	3	1
row cache objects	kqreqd	1	11
shared pool	kghalo	66	67
shared pool	kghfre	41	40

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	5,849	-1
Library Cache	kglpin1 4	981	0
Library Cache	kglpndl1 95	803	0
Cursor Stat	kkocsStoreBindAwareStats [KKSSTALOC8]	512	0
Library Cache	kglhdgn2 106	196	-0
Cursor Pin	kkslce [KKSCHLPIN2]	157	1
Library Cache	kgllkc1 57	118	0
Cursor Pin	kksfbc [KKSCHLFSP2]	57	0
Library Cache	kglget2 2	37	0
Library Cache	kglpnal1 90	28	1
Cursor Pin	kksLockDelete [KKSCHLPIN6]	12	0
Library Cache	kgldtin1 42	6	-0
Library Cache	kgllkdl1 85	5	0
Library Cache	kglhdgn1 62	4	-0
Library Cache	kglini1 32	3	-0
Library Cache	kglobpn1 71	3	0
Library Cache	kglobld1 75	1	0

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: 988,874,758
Captured Segments account for 88.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
kwbsPROD	kwbs	IDX??PK	INDEX	159,628,016	16.14
kwbsPROD	kwbs	F_STOCK	TABLE	135,625,728	13.72
kwbsPROD	kwbs	IDX_F_DET_D_FK	INDEX	83,451,280	8.44
kwbsPROD	kwbs	F_SALE_ORDER	TABLE	69,218,064	7.00
kwbsPROD	kwbs	??	TABLE	66,797,152	6.75

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 195,163
Captured Segments account for 45.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
kwbsPROD	kwbs	F2_STK_DETAIL	TABLE	51,200	26.23
kwbsPROD	kwbs	F_STK_DETAIL	TABLE	21,598	11.07
kwbsPROD	kwbs	IDX_??_2	INDEX	5,875	3.01
kwbsPROD	kwbs	IDX_F_STK_LVL	INDEX	4,665	2.39
kwbsPROD	kwbs	IDX_F_STK_IO_D2	INDEX	954	0.49

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 112,134
Captured Segments account for 33.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
kwbsPROD	kwbs	F_STK_DETAIL	TABLE	21,598	19.26
kwbsPROD	kwbs	IDX_F_STK_LVL	INDEX	4,665	4.16
kwbsPROD	kwbs	F2_STK_DETAIL	TABLE	3,902	3.48
kwbsPROD	kwbs	IDX_??_2	INDEX	1,600	1.43
kwbsPROD	kwbs	IDX_F_STK_IO_D2	INDEX	954	0.85

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 112,134
Captured Segments account for 33.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
kwbsPROD	kwbs	F_STK_DETAIL	TABLE	21,598	19.26
kwbsPROD	kwbs	IDX_F_STK_LVL	INDEX	4,665	4.16
kwbsPROD	kwbs	F2_STK_DETAIL	TABLE	3,902	3.48
kwbsPROD	kwbs	IDX_??_2	INDEX	1,600	1.43
kwbsPROD	kwbs	IDX_F_STK_IO_D2	INDEX	954	0.85

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: 58,199
Captured Segments account for 10.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
kwbsPROD	kwbs	IDX_??_2		INDEX	5,774	9.92
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1275538605_15354	TABLE PARTITION	43	0.07

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 39,439
Captured Segments account for 35.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
kwbsPROD	kwbs	IDX_??_2		INDEX	5,774	14.64
kwbsPROD	kwbs	CELLTREEREADINFOMAYBE		TABLE	1,618	4.10
kwbsPROD	kwbs	F_RECIPROCITY		TABLE	1,175	2.98
kwbsPROD	kwbs	IDX_F_OPER_LOG		INDEX	505	1.28
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	498	1.26

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 24,664
Captured Segments account for 30.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
kwbsPROD	kwbs	IDX_??_2		INDEX	1,499	6.08
kwbsPROD	kwbs	CELLTREEREADINFOMAYBE		TABLE	1,262	5.12
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	472	1.91
kwbsPROD	kwbs	IDX_F_OPER_LOG		INDEX	472	1.91
kwbsPROD	kwbs	F_SALE_ORDER		TABLE	431	1.75

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 5,891
Captured Segments account for 98.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
kwbsPROD	kwbs	IDX_??_2		INDEX	5,774	98.01
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1275538605_15354	TABLE PARTITION	43	0.73

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 5,257
Captured Segments account for 0.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
kwbsPROD	kwbs	PK_F_SALE_ORDER		INDEX	1	0.02

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	Obj. Type	DB Block Changes	% of Capture
kwbsPROD	kwbs	IDX_F_STK_IO_D2	INDEX	106,032	25.06
kwbsPROD	kwbs	F_SALE_ORDER	TABLE	97,856	23.13
kwbsPROD	kwbs	F_STK_IO_D	TABLE	23,168	5.48
kwbsPROD	kwbs	F_INST_ORDER_D	TABLE	22,896	5.41
kwbsPROD	kwbs	F_INST_ORDER	TABLE	21,648	5.12

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	25	73.53
kwbsPROD	kwbs	F_INST_ORDER	TABLE	2	5.88
kwbsPROD	kwbs	F_SALE_ORDER	TABLE	2	5.88
kwbsPROD	kwbs	F_SEND	TABLE	1	2.94
kwbsPROD	kwbs	F_STK_IO	TABLE	1	2.94

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	29	49.15
kwbsPROD	kwbs	SYS_C0028117	INDEX	20	33.90
SYS	SYSTEM	I_SLOG1	INDEX	4	6.78
SYS	SYSTEM	JOB$	TABLE	3	5.08
kwbsPROD	kwbs	F_SEND	TABLE	1	1.69

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	658	0.15	0	61
dc_histogram_data	58,328	0.44	0	9,498
dc_histogram_defs	19,076	2.37	0	10,295
dc_object_grants	1,095	0.00	0	226
dc_objects	84,895	0.09	8	3,281
dc_profiles	523	0.00	0	1
dc_rollback_segments	23,913	0.00	0	306
dc_segments	12,132	0.32	70	2,120
dc_sequences	4,532	0.35	4,532	196
dc_table_scns	178	0.00	24	3
dc_tablespaces	111,222	0.00	0	7
dc_users	133,169	0.00	0	115
global database name	2,900	0.00	0	1
outstanding_alerts	43	6.98	8	7
sch_lj_oids	5	0.00	0	2

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
APP CONTEXT	1,070	0.00	1,070	0.00	0	0
BODY	7,840	0.00	269,499	0.00	0	0
CLUSTER	2	0.00	2	0.00	0	0
DBLINK	882	0.00	0		0	0
EDITION	536	0.00	1,057	0.00	0	0
INDEX	18	11.11	17	11.76	0	0
OBJECT ID	1	100.00	0		0	0
QUEUE	61	0.00	224	0.00	0	0
RULESET	8	0.00	8	0.00	0	0
SCHEMA	1,053	0.00	0		0	0
SQL AREA	305,820	36.97	46,482,941	0.22	37,927	37,820
SUBSCRIPTION	24	0.00	24	0.00	0	0
TABLE/PROCEDURE	321,130	0.01	724,823	0.02	0	0
TRIGGER	1,093	0.09	1,130	0.09	0	0

Memory Statistics

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

Memory Dynamic Components

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

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	9,984.00	9,984.00	9,472.00	9,984.00	GRO/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	10,752.00	10,752.00	10,752.00	10,752.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	15,872.00	15,872.00	15,872.00	15,872.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	256.00	256.00	256.00	256.00	STA/
large pool	256.00	256.00	256.00	256.00	STA/
shared pool	4,864.00	4,864.00	4,864.00	5,376.00	SHR/DEF
streams pool	256.00	256.00	256.00	256.00	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

B: Begin Snap E: End Snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	2,009.84		2.85	2.12	28	28	704	704
	SQL	1,472.32	1,357.01	2.15	13.53	238	239	685	670
	PL/SQL	867.75	831.88	1.24	0.49	2	3	702	702
	Freeable	518.19	0.00	0.85	0.86	19		609	609
E	Other	2,207.81		2.86	2.34	28	28	773	773
	SQL	1,313.81	1,181.66	1.82	9.52	238	239	722	697
	PL/SQL	943.36	905.15	1.22	0.56	2	3	771	739
	Freeable	569.13	0.00	0.88	0.86	19		644	644

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	10,468,982,784
Fixed Size	2,214,096
Redo Buffers	141,578,240
Variable Size	17,179,871,024

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	193.01	216.36	12.10
shared	FileOpenBlock	184.70	184.70	0.00
shared	KKSSP	111.21	122.65	10.28
shared	PCUR	51.91	58.50	12.69
shared	SQLA	290.29	322.69	11.16
shared	SQLP		48.91
shared	db_block_hash_buckets	89.00	89.00	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	3,247.63	3,161.97	-2.64
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,984.00	9,984.00	0.00
	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.02	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

Rule Sets ordered by Evaluations
* indicates Rule Set activity (re)started between Begin/End snaps
SQL per Eval - average # of SQL statements executed for non-SQL free evals
CPU(s),Ela(s) per Eval - avg CPU and Elapsed time per evaluation includes both SQL free and non-SQL free evals

Rule	Evals	No-SQL Eval%	SQL Execs	CPU(s)	Ela(s)	Eval /Sec	SQL per Eval	Ela(s) per Eval	CPU(s) per Eval	Reloads
SYS.ALERT_QUE_R	8	0.00	0	0.00	0.00	0.00	0.00	0.00	0.00	0

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)	8	0	100.00	0.00	0.05	0.00	0.00	2.02
SYS.AQ$_ALERT_QT_E(12342)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(66573)	63	63	0.00	0.00	0.08	0.22	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	0.01
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	8	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,548	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,548	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 %:	99.99
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	99.78	Soft Parse %:	95.29
Execute to Parse %:	98.20	Latch Hit %:	99.97
Parse CPU to Parse Elapsd %:	95.22	% Non-Parse CPU:	99.13