WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

ORCL 1275538605 orcl 1 08-Apr-13 11:04 11.2.0.1.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ORCL	1275538605	orcl	1	08-Apr-13 11:04	11.2.0.1.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

rkdsdb3850x5.realkw.com.cn Linux x86 64-bit 16 8 2 31.41

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
rkdsdb3850x5.realkw.com.cn	Linux x86 64-bit	16	8	2	31.41

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 17648 15-Apr-13 15:00:46 802 9.5

End Snap: 17649 15-Apr-13 16:00:45 1666 5.8

Elapsed: 59.98 (mins)

DB Time: 15,720.27 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	17648	15-Apr-13 15:00:46	802	9.5
End Snap:	17649	15-Apr-13 16:00:45	1666	5.8
Elapsed:		59.98 (mins)
DB Time:		15,720.27 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 10,240M 10,240M Std Block Size: 8K

Shared Pool Size: 5,120M 5,120M Log Buffer: 138,260K

	Begin	End
Buffer Cache:	10,240M	10,240M	Std Block Size:	8K
Shared Pool Size:	5,120M	5,120M	Log Buffer:	138,260K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 262.1 20.6 0.02 1.13

DB CPU(s): 6.6 0.5 0.00 0.03

Redo size: 37,811.0 2,967.8

Logical reads: 166,283.4 13,051.6

Block changes: 274.6 21.6

Physical reads: 39.5 3.1

Physical writes: 9.7 0.8

User calls: 231.4 18.2

Parses: 183.9 14.4

Hard parses: 7.3 0.6

W/A MB processed: 2.3 0.2

Logons: 0.5 0.0

Executes: 10,649.9 835.9

Rollbacks: 0.3 0.0

Transactions: 12.7

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	262.1	20.6	0.02	1.13
DB CPU(s):	6.6	0.5	0.00	0.03
Redo size:	37,811.0	2,967.8
Logical reads:	166,283.4	13,051.6
Block changes:	274.6	21.6
Physical reads:	39.5	3.1
Physical writes:	9.7	0.8
User calls:	231.4	18.2
Parses:	183.9	14.4
Hard parses:	7.3	0.6
W/A MB processed:	2.3	0.2
Logons:	0.5	0.0
Executes:	10,649.9	835.9
Rollbacks:	0.3	0.0
Transactions:	12.7

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 99.88

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

Library Hit %: 99.78 Soft Parse %: 96.03

Execute to Parse %: 98.27 Latch Hit %: 99.94

Parse CPU to Parse Elapsd %: 2.42 % Non-Parse CPU: 97.68

Shared Pool Statistics

Begin End

Memory Usage %: 54.71 55.91

% SQL with executions>1: 89.90 90.41

% Memory for SQL w/exec>1: 91.74 91.17

	Begin	End
Memory Usage %:	54.71	55.91
% SQL with executions>1:	89.90	90.41
% Memory for SQL w/exec>1:	91.74	91.17

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
cursor: mutex S	22,522,392	841,696	37	89.24	Concurrency
DB CPU		23,726		2.52
latch free	62,543	15,498	248	1.64	Other
library cache lock	2,243	8,040	3585	0.85	Concurrency
log file sync	28,330	2,689	95	0.29	Commit

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

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

2.78 1.0E+03 38.6 4.3 3.9 57.0

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
2.78	1.0E+03	38.6	4.3	3.9	57.0

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

40.5 94.2 0.0

Memory Statistics

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

Begin End

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

SGA use (MB): 16,384.0 16,384.0

PGA use (MB): 6,605.4 8,645.8

% Host Mem used for SGA+PGA: 71.49 77.83

	Begin	End
Host Mem (MB):	32,158.8	32,158.8
SGA use (MB):	16,384.0	16,384.0
PGA use (MB):	6,605.4	8,645.8
% Host Mem used for SGA+PGA:	71.49	77.83

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): 943216.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	929,346.13	98.53
parse time elapsed	912,819.02	96.78
failed parse elapsed time	25,019.65	2.65
DB CPU	23,726.01	2.52
connection management call elapsed time	2,544.56	0.27
PL/SQL execution elapsed time	1,948.96	0.21
hard parse elapsed time	413.04	0.04
inbound PL/SQL rpc elapsed time	140.56	0.01
hard parse (sharing criteria) elapsed time	84.03	0.01
sequence load elapsed time	62.66	0.01
PL/SQL compilation elapsed time	54.12	0.01
hard parse (bind mismatch) elapsed time	6.36	0.00
repeated bind elapsed time	0.16	0.00
DB time	943,216.43
background elapsed time	6,583.69
background cpu time	104.16

Back to Wait Events Statistics
Back to Top

Operating System Statistics

*TIME statistic values are diffed. All others display actual values. End Value is displayed if different
ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Statistic	Value	End Value
BUSY_TIME	2,530,450
IDLE_TIME	3,353,506
IOWAIT_TIME	229,886
NICE_TIME	40
SYS_TIME	250,309
USER_TIME	2,274,029
LOAD	3	1,032
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
15-Apr 15:00:46	2.78
15-Apr 16:00:45	1,031.79	43.01	38.65	4.25	56.99	3.91

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 95.9% of Total DB time 943,216.43 (s)
Total FG Wait Time: 880,635.46 (s) DB CPU time: 23,726.01 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Concurrency	22,538,878	100	856,458	38	90.80
DB CPU			23,726		2.52
Other	440,544	85	17,947	41	1.90
Commit	28,330	0	2,689	95	0.29
User I/O	71,639	0	2,063	29	0.22
Application	2,058	0	702	341	0.07
Network	805,993	0	652	1	0.07
Configuration	60	0	87	1442	0.01
System I/O	2,015	0	37	18	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
cursor: mutex S	22,522,392	100	841,696	37	491.20	89.24
latch free	62,543	0	15,498	248	1.36	1.64
library cache lock	2,243	0	8,040	3585	0.05	0.85
log file sync	28,330	0	2,689	95	0.62	0.29
latch: shared pool	4,369	0	2,657	608	0.10	0.28
library cache: mutex X	3,746	0	1,763	471	0.08	0.19
wait list latch free	787	0	1,641	2085	0.02	0.17
latch: cache buffers chains	2,534	0	1,320	521	0.06	0.14
db file sequential read	34,385	0	1,282	37	0.75	0.14
enq: TX - row lock contention	3	0	681	227070	0.00	0.07
latch: row cache objects	1,054	0	673	638	0.02	0.07
direct path read	30,069	0	643	21	0.66	0.07
SQL*Net more data to client	232,029	0	630	3	5.06	0.07
latch: call allocation	268	0	405	1510	0.01	0.04
inactive session	207	100	207	1002	0.00	0.02
cursor: pin S wait on X	2,016	0	156	77	0.04	0.02
wait for a undo record	1,375	85	132	96	0.03	0.01
Disk file operations I/O	6,263	0	85	14	0.14	0.01
enq: TX - index contention	81	0	69	848	0.00	0.01
log file switch completion	22	0	64	2919	0.00	0.01
buffer busy waits	302	0	47	155	0.01	0.00
control file sequential read	1,984	0	37	19	0.04	0.00
cursor: pin S	137	0	36	265	0.00	0.00
latch: redo allocation	56	0	22	399	0.00	0.00
enq: SQ - contention	36	0	22	620	0.00	0.00
SQL*Net break/reset to client	2,055	0	21	10	0.04	0.00
db file parallel read	21	0	18	843	0.00	0.00
db file scattered read	566	0	16	28	0.01	0.00
SQL*Net more data from client	34,270	0	15	0	0.75	0.00
read by other session	29	0	15	522	0.00	0.00
latch: cache buffers lru chain	19	0	14	722	0.00	0.00
latch: cache buffer handles	55	0	12	212	0.00	0.00
SQL*Net message to client	539,694	0	8	0	11.77	0.00
PX Deq: Slave Session Stats	32	0	6	202	0.00	0.00
kksfbc child completion	77	100	4	51	0.00	0.00
latch: parallel query alloc buffer	13	0	3	243	0.00	0.00
row cache lock	4	0	3	706	0.00	0.00
direct path read temp	230	0	3	12	0.01	0.00
direct path write temp	76	0	2	27	0.00	0.00
latch: object queue header operation	14	0	1	73	0.00	0.00
asynch descriptor resize	375,083	100	1	0	8.18	0.00
buffer deadlock	9	100	1	76	0.00	0.00
latch: messages	3	0	0	110	0.00	0.00
log file sequential read	31	0	0	9	0.00	0.00
latch: session allocation	1	0	0	118	0.00	0.00
latch: enqueue hash chains	2	0	0	21	0.00	0.00
log buffer space	1	0	0	7	0.00	0.00
enq: HW - contention	1	0	0	1	0.00	0.00
SQL*Net message from client	539,391	0	2,477,836	4594	11.76
jobq slave wait	8,089	100	4,053	501	0.18
PX Deq: Txn Recovery Start	603	83	1,075	1783	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
latch: shared pool	1,165	0	807	692	0.03	12.25
log file parallel write	30,292	0	796	26	0.66	12.09
flashback log file write	1,811	0	464	256	0.04	7.04
os thread startup	183	0	336	1836	0.00	5.10
control file sequential read	6,437	0	318	49	0.14	4.84
db file sequential read	2,509	0	308	123	0.05	4.67
control file parallel write	1,605	0	236	147	0.04	3.58
latch: call allocation	159	0	217	1363	0.00	3.29
latch free	275	0	133	485	0.01	2.03
db file parallel write	7,305	0	106	14	0.16	1.60
enq: PR - contention	9	0	79	8811	0.00	1.20
process diagnostic dump	1,011	0	50	50	0.02	0.77
latch: redo allocation	173	0	36	208	0.00	0.55
enq: CF - contention	9	0	27	2996	0.00	0.41
wait list latch free	15	0	15	972	0.00	0.22
LGWR wait for redo copy	195	0	12	61	0.00	0.18
Disk file operations I/O	348	0	11	33	0.01	0.17
library cache: mutex X	9	0	9	989	0.00	0.14
flashback log file sync	23	9	8	351	0.00	0.12
latch: row cache objects	4	0	8	1887	0.00	0.11
latch: redo writing	17	0	6	342	0.00	0.09
log file sync	11	0	6	521	0.00	0.09
direct path write	38	0	5	143	0.00	0.08
latch: parallel query alloc buffer	8	0	5	598	0.00	0.07
log file sequential read	45	0	5	105	0.00	0.07
latch: messages	9	0	5	509	0.00	0.07
latch: checkpoint queue latch	3	0	4	1354	0.00	0.06
wait for stopper event to be increased	31	77	3	83	0.00	0.04
direct path read	35	0	3	73	0.00	0.04
buffer busy waits	8	0	2	284	0.00	0.03
enq: JS - queue lock	1	0	2	2273	0.00	0.03
SQL*Net more data from client	489	0	2	4	0.01	0.03
latch: cache buffers chains	5	0	2	373	0.00	0.03
latch: object queue header operation	6	0	2	264	0.00	0.02
ADR block file read	52	0	2	29	0.00	0.02
SQL*Net more data to client	489	0	1	3	0.01	0.02
RVWR wait for flashback copy	102	97	1	11	0.00	0.02
ADR block file write	25	0	1	39	0.00	0.01
flashback log file read	26	0	1	29	0.00	0.01
db file scattered read	197	0	1	3	0.00	0.01
enq: PS - contention	3	0	1	197	0.00	0.01
PX Deq: Signal ACK EXT	34	0	0	13	0.00	0.01
latch: cache buffers lru chain	3	0	0	142	0.00	0.01
log file single write	4	0	0	73	0.00	0.00
cursor: mutex S	1	100	0	120	0.00	0.00
SQL*Net message to client	3,380	0	0	0	0.07	0.00
PX Deq: Slave Session Stats	6	0	0	10	0.00	0.00
ADR file lock	28	14	0	2	0.00	0.00
asynch descriptor resize	1,800	100	0	0	0.04	0.00
PX qref latch	1	100	0	11	0.00	0.00
rdbms ipc message	43,722	37	61,534	1407	0.95
DIAG idle wait	6,830	100	7,097	1039	0.15
PX Idle Wait	2,739	99	5,536	2021	0.06
dispatcher timer	61	100	3,662	60039	0.00
shared server idle wait	122	100	3,660	30003	0.00
Space Manager: slave idle wait	731	100	3,657	5002	0.02
Streams AQ: qmn slave idle wait	130	0	3,640	28004	0.00
Streams AQ: qmn coordinator idle wait	260	50	3,640	14001	0.01
smon timer	13	85	3,502	269412	0.00
pmon timer	1,950	57	3,454	1772	0.04
SQL*Net message from client	4,943	0	155	31	0.11
PX Deq: Join ACK	31	13	21	665	0.00
class slave wait	33	0	0	6	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	52	13.5		5.8	7.7	23.1	32.7	17.3
ADR block file write	25				8.0	16.0	40.0	36.0
ADR file lock	28	96.4						3.6
ARCH wait for archivelog lock	3	100.0
Disk file operations I/O	6644	92.6	.2	.1	.4	.6	.6	5.2	.2
LGWR wait for redo copy	196	75.5	1.5	.5	5.6	3.6	3.1	8.2	2.0
Log archive I/O	2	100.0
PX Deq: Signal ACK EXT	34	91.2						8.8
PX Deq: Slave Session Stats	38	7.9			2.6	5.3	10.5	73.7
PX qref latch	1					100.0
RVWR wait for flashback copy	102				1.0	97.1	1.0	1.0
SQL*Net break/reset to client	2047	64.6	.8	13.7	3.3	5.9	4.1	7.5	.1
SQL*Net message to client	542.3K	100.0	.0		.0	.0	.0	.0	.0
SQL*Net more data from client	34.7K	87.6	11.9	.3	.0	.0	.0	.1	.0
SQL*Net more data to client	232.2K	98.4	.0	.0	.0	.4	.1	1.1	.0
asynch descriptor resize	377.1K	100.0	.0				.0	.0
buffer busy waits	311	23.8	7.1	3.9	4.5	6.4	6.1	47.6	.6
buffer deadlock	9	33.3			11.1	11.1		44.4
control file parallel write	1612					26.9	38.2	32.3	2.7
control file sequential read	8411	33.0	1.5	4.0	24.5	7.8	6.3	22.8	.1
cursor: mutex S	22.9M	.0	.0	.4	6.1	19.8	38.3	35.2	.1
cursor: pin S	137	38.7		.7	2.2	1.5	4.4	48.2	4.4
cursor: pin S wait on X	2016					87.3	5.0	5.9	1.8
db file parallel read	21				19.0	14.3	9.5	42.9	14.3
db file parallel write	7319	27.8	6.4	12.2	18.2	14.2	13.8	7.4
db file scattered read	744	36.0	2.4	.9	8.6	28.2	14.9	8.7	.1
db file sequential read	36.8K	22.7	1.0	4.2	19.3	25.6	13.0	13.6	.6
direct path read	30.1K	30.6	5.9	10.4	20.8	12.6	6.0	13.6	.0
direct path read temp	230	11.3	2.6	8.3	24.3	30.9	19.1	3.5
direct path write	38	2.6			7.9	5.3	2.6	81.6
direct path write temp	76	1.3		3.9	13.2	28.9	30.3	22.4
enq: CF - contention	9							22.2	77.8
enq: HW - contention	1		100.0
enq: JS - queue lock	1								100.0
enq: PR - contention	9							22.2	77.8
enq: PS - contention	3	33.3				33.3		33.3
enq: SQ - contention	36	11.1	2.8		2.8	13.9	11.1	47.2	11.1
enq: TX - index contention	81	4.9	4.9	2.5	3.7	12.3	7.4	28.4	35.8
enq: TX - row lock contention	3							33.3	66.7
flashback log file read	26	11.5			19.2	26.9	23.1	19.2
flashback log file sync	23	13.0					13.0	73.9
flashback log file write	1818				1.3	5.0	34.2	54.2	5.3
inactive session	229							100.0
kksfbc child completion	77							100.0
latch free	62.8K	1.6	.4	.8	1.9	3.9	10.4	77.0	4.0
latch: cache buffer handles	55			1.8	7.3	5.5	5.5	74.5	5.5
latch: cache buffers chains	2563	19.8	.8	1.6	2.1	3.2	3.9	53.9	14.6
latch: cache buffers lru chain	22	4.5		4.5			9.1	63.6	18.2
latch: call allocation	427	7.7	.7	1.2	.9	1.9	5.6	49.9	32.1
latch: checkpoint queue latch	3							66.7	33.3
latch: enqueue hash chains	2	50.0						50.0
latch: messages	12	16.7		8.3	8.3	8.3	8.3	25.0	25.0
latch: object queue header operation	20	25.0	5.0		5.0		10.0	55.0
latch: parallel query alloc buffer	21						9.5	81.0	9.5
latch: redo allocation	230	18.3	2.2	2.6	2.6	5.7	5.2	57.0	6.5
latch: redo writing	17	5.9					11.8	76.5	5.9
latch: row cache objects	1058	2.0	.4	.7	1.2	2.5	2.8	68.5	21.9
latch: session allocation	1							100.0
latch: shared pool	5536	1.8	1.0	2.2	3.5	3.3	5.7	65.5	17.1
library cache lock	2243	56.0	6.4	2.2	3.7	10.4	2.8	9.3	9.1
library cache: mutex X	3759	35.1	3.0	3.0	3.7	4.3	5.2	34.1	11.6
log buffer space	1				100.0
log file parallel write	30.3K	.3	1.9	8.0	39.3	27.5	9.4	13.6	.0
log file sequential read	76	28.9		1.3	6.6	10.5	32.9	18.4	1.3
log file single write	4					25.0	25.0	50.0
log file switch completion	22							31.8	68.2
log file sync	28.3K	.3	2.0	8.0	30.2	30.6	10.0	16.7	2.2
os thread startup	185					6.5	38.9	21.1	33.5
process diagnostic dump	1011	.7				5.2	31.0	62.9	.2
read by other session	29	3.4				3.4	3.4	86.2	3.4
row cache lock	4							100.0
wait for a undo record	1375	4.0	.1	.1	.4	.6	2.7	92.1
wait for stopper event to be increased	31	12.9					3.2	83.9
wait list latch free	802					5.4	7.6	31.7	55.4
DIAG idle wait	6865							92.5	7.5
PX Deq: Join ACK	31	9.7	3.2	3.2		3.2	6.5	41.9	32.3
PX Deq: Txn Recovery Start	603	4.8	.7	.7		.2		2.7	91.0
PX Idle Wait	3155							.4	99.6
SQL*Net message from client	543.6K	7.9	.9	11.6	7.9	9.2	9.7	46.7	6.2
Space Manager: slave idle wait	736								100.0
Streams AQ: qmn coordinator idle wait	262	48.1	.8	.4			.4	.4	50.0
Streams AQ: qmn slave idle wait	132	.8							99.2
Streams AQ: waiting for time management or cleanup tasks	1								100.0
class slave wait	33	75.8	9.1	6.1			3.0	6.1
dispatcher timer	61								100.0
jobq slave wait	8138	.0			.0	.0		100.0
pmon timer	2006	35.6	.6	.5	.5	.3	.5	4.0	57.9
rdbms ipc message	43.8K	9.8	.6	1.3	2.8	5.5	8.6	43.5	27.9
shared server idle wait	122								100.0
smon timer	14	7.1							92.9

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
ADR block file read	9	82.7	5.8	5.8	5.8
ADR block file write	9	64.0	24.0	8.0	4.0
ADR file lock	1	96.4	3.6
Disk file operations I/O	358	94.6	1.2	1.5	1.4	1.0	.2	.2	.1
LGWR wait for redo copy	19	89.8	.5	1.5	2.6	3.1	.5	1.5	.5
PX Deq: Signal ACK EXT	3	91.2		5.9	2.9
PX Deq: Slave Session Stats	28	26.3			73.7
RVWR wait for flashback copy	1	99.0	1.0
SQL*Net break/reset to client	155	92.4	4.3	2.5	.5	.1	.0	.1
SQL*Net message to client	18	100.0	.0	.0	.0	.0	.0		.0
SQL*Net more data from client	26	99.9	.0	.0	.0	.0	.0	.0
SQL*Net more data to client	2489	98.9	.2	.3	.3	.2	.1	.0	.0
asynch descriptor resize	3	100.0		.0	.0
buffer busy waits	149	51.8	8.7	10.0	10.3	7.1	11.6	.3	.3
buffer deadlock	4	55.6		33.3		11.1
control file parallel write	557	65.1	8.7	5.8	4.7	6.7	6.3	2.3	.4
control file sequential read	1920	77.1	6.8	6.0	5.7	3.6	.7	.1	.0
cursor: mutex S	8094K	64.7	23.0	10.0	1.8	.3	.2	.1	.0
cursor: pin S	71	47.4	3.6	8.8	8.8	16.8	10.2	3.6	.7
cursor: pin S wait on X	136	92.3	1.9	1.5	.4	1.3	.7	.9	.9
db file parallel read	10	42.9	4.8	14.3	9.5	9.5	4.8	4.8	9.5
db file parallel write	543	92.6	3.4	2.1	1.2	.5	.1
db file scattered read	65	91.1	4.8	1.9	.8	1.1	.1		.1
db file sequential read	5156	85.8	4.8	3.2	2.7	1.9	1.0	.5	.2
direct path read	4108	86.4	5.3	4.0	2.9	1.3	.1	.0
direct path read temp	8	96.5	2.6	.9
direct path write	31	18.4	13.2	36.8	15.8	13.2	2.6
direct path write temp	17	77.6	15.8	3.9	2.6
enq: CF - contention	5		11.1				11.1	33.3	44.4
enq: PR - contention	2		11.1				11.1		77.8
enq: PS - contention	1	66.7					33.3
enq: SQ - contention	18	41.7	2.8	8.3	19.4	13.9	2.8	2.8	8.3
enq: TX - index contention	30	35.8	7.4	8.6	3.7	6.2	2.5	8.6	27.2
enq: TX - row lock contention	1						33.3		66.7
flashback log file read	5	80.8	3.8	7.7	7.7
flashback log file sync	17	26.1		13.0	21.7	8.7	30.4
flashback log file write	1073	40.5	12.4	7.1	9.5	13.4	11.8	4.8	.5
inactive session	229						100.0
kksfbc child completion	77		100.0
latch free	48.8K	18.9	21.4	29.8	18.1	6.6	1.1	.6	3.4
latch: cache buffer handles	44	20.0	16.4	21.8	25.5	9.1	1.8	5.5
latch: cache buffers chains	1604	31.4	5.4	8.5	12.2	14.2	13.7	8.7	6.0
latch: cache buffers lru chain	17	18.2		4.5	13.6	9.1	36.4	13.6	4.5
latch: call allocation	267	18.0	5.9	8.9	11.7	14.8	8.7	12.6	19.4
latch: checkpoint queue latch	2						66.7		33.3
latch: enqueue hash chains	1	50.0	50.0
latch: messages	6	50.0	8.3		8.3	8.3		25.0
latch: object queue header operation	11	45.0	10.0	5.0	25.0	10.0	5.0
latch: parallel query alloc buffer	18	9.5	14.3	9.5	28.6	28.6		4.8	4.8
latch: redo allocation	144	36.5	9.1	14.8	11.7	11.3	10.0	5.7	.9
latch: redo writing	14	17.6	5.9	17.6	17.6	17.6	17.6	5.9
latch: row cache objects	895	9.5	6.0	9.3	16.7	18.1	18.3	16.1	5.9
latch: session allocation	1			100.0
latch: shared pool	4158	17.4	9.2	11.9	15.9	15.4	13.0	9.6	7.4
library cache lock	213	81.5	3.9	3.1	1.3	.7	.3	.2	9.0
library cache: mutex X	1488	54.3	6.1	5.2	7.0	8.4	7.3	5.5	6.1
log file parallel write	4115	86.4	5.0	3.9	2.8	1.6	.3	.0
log file sequential read	15	80.3	9.2	1.3	1.3	5.3	1.3	1.3
log file single write	2	50.0		25.0	25.0
log file switch completion	8			4.5	4.5	22.7		4.5	63.6
log file sync	5231	81.1	4.2	3.0	2.6	3.5	3.4	1.8	.4
os thread startup	52	45.4	8.1	4.3	2.2	2.2	4.3	7.0	26.5
process diagnostic dump	637	36.9	53.3	5.9	2.8	.7	.2	.1	.1
read by other session	25	10.3	6.9	13.8	31.0	24.1	10.3		3.4
row cache lock	4					25.0	75.0
wait for a undo record	1266	7.9	4.1	82.9	4.9	.1
wait for stopper event to be increased	26	16.1	6.5	77.4
wait list latch free	306	13.0	1.6	2.6	1.2	19.6	6.6	6.5	48.9

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
Disk file operations I/O	4	99.9	.0	.0
LGWR wait for redo copy	1	99.5	.5
SQL*Net message to client	1	100.0	.0
SQL*Net more data to client	22	100.0	.0	.0
buffer busy waits	1	99.7	.3
control file parallel write	6	99.6	.3	.1
control file sequential read	2	100.0	.0
cursor: mutex S	3763	100.0	.0	.0	.0	.0	.0
cursor: pin S	1	99.3		.7
cursor: pin S wait on X	19	99.1	.4	.5
db file parallel read	2	90.5	4.8		4.8
db file scattered read	1	99.9	.1
db file sequential read	59	99.8	.1	.0
enq: CF - contention	4	55.6	33.3		11.1
enq: JS - queue lock	1		100.0
enq: PR - contention	7	22.2		33.3	33.3	11.1
enq: SQ - contention	3	91.7		8.3
enq: TX - index contention	22	72.8	27.2
enq: TX - row lock contention	1	33.3	33.3						33.3
flashback log file write	9	99.5	.4	.1
latch free	2133	96.6	1.8	1.6
latch: cache buffers chains	153	94.0	5.0	1.0
latch: cache buffers lru chain	1	95.5	4.5
latch: call allocation	83	80.6	8.0	7.0	4.4
latch: checkpoint queue latch	1	66.7	33.3
latch: parallel query alloc buffer	1	95.2	4.8
latch: redo allocation	2	99.1	.9
latch: row cache objects	62	94.1	5.3	.6
latch: shared pool	412	92.6	5.3	2.0	.1
library cache lock	201	91.0	.1	.8	1.2	1.2	4.9	.8
library cache: mutex X	228	93.9	3.0	2.8	.2
log file switch completion	14	36.4	31.8	31.8
log file sync	127	99.6	.4	.1		.0
os thread startup	49	73.5	14.1	5.9	4.9	1.6
process diagnostic dump	1	99.9	.1
read by other session	1	96.6		3.4
wait list latch free	392	51.1	41.4	5.5	2.0

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	66.7			33.3

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	504,833	14,472	118	565,269
SYS$USERS	411,040	8,896	18	33,596
SYS$BACKGROUND	0	0	6	59
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	56052	1370	11773981	464831	711962	652
SYS$USERS	15585	693	10711570	388300	94191	0
SYS$BACKGROUND	3070	334	870	801	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 10.4% of Total DB Time (s): 943,216
Captured PL/SQL account for 56.3% of Total DB Time (s): 943,216

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
346,448.68	1,872	185.07	36.73	1.83	0.00	05q41cr2p962s	????rkws????	begin :doa__value := Pkg_CellT...
172,363.76	3,283	52.50	18.27	1.99	0.00	5p3k8wkjk61bg	??????(????)	begin :p_ur := Pkg_CellTree.Ch...
60,474.80	549	110.15	6.41	1.93	0.00	brpn42kb2n1cy	??????	select (select count(*) from (...
15,309.23	197	77.71	1.62	2.11	0.00	dffxc5zfqqtvs	????????\????????	select CELLTREEID from (select...
8,068.36	191	42.24	0.86	2.00	0.00	4u7fp1044v8jf	??????????	select (select count(*) from (...
4,843.65	25	193.75	0.51	1.73	0.00	c7cwqrn192ayg	NSAppServer.exe	select (select count(*) from (...
2,327.24	499	4.66	0.25	7.24	8.00	as10b5kn8p4yt	NSAppServer.exe	declare v_Owner varchar2(200);...
2,231.59	512	4.36	0.24	7.36	8.46	7jjzdat38s75b	NSAppServer.exe	begin :R := URRP_LOGIN(:U, :P,...
1,857.47	659	2.82	0.20	4.45	9.60	dp76759j3zz22	BA_java	declare v_Owner varchar2(200)...
1,718.59	659	2.61	0.18	4.73	10.38	cr6zmgzj0415k	BA_java	begin :R := URRP_LOGIN(:U, :P,...

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 23.2% of Total CPU Time (s): 23,726
Captured PL/SQL account for 45.1% of Total CPU Time (s): 23,726

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
6,324.74	1,872	3.38	26.66	346,448.68	1.83	0.00	05q41cr2p962s	????rkws????	begin :doa__value := Pkg_CellT...
3,424.69	3,283	1.04	14.43	172,363.76	1.99	0.00	5p3k8wkjk61bg	??????(????)	begin :p_ur := Pkg_CellTree.Ch...
1,167.03	549	2.13	4.92	60,474.80	1.93	0.00	brpn42kb2n1cy	??????	select (select count(*) from (...
418.91	4,085,460	0.00	1.77	532.35	78.69	11.44	8b5c0u498ufmg	BA_java	SELECT T.F_LEVEL_ID FROM F_STO...
322.71	197	1.64	1.36	15,309.23	2.11	0.00	dffxc5zfqqtvs	????????\????????	select CELLTREEID from (select...
304.53	151	2.02	1.28	305.53	99.68	0.00	c27zt11fdgxg3	NSAppServer.exe	select count(*) from ( select ...
302.68	149	2.03	1.28	303.19	99.83	0.00	b0nrxjw98cjha	NSAppServer.exe	select t.??????, t.?????? RID,...
251.86	4	62.96	1.06	335.74	75.02	3.39	3r0ay6u2jtcgr	????????????	declare v_type varchar2(40); b...
251.66	4	62.91	1.06	327.20	76.91	1.97	02736fx6r61na	????????\????????????\????????????	INSERT INTO TT_rkws3_BILLQRYAL...
215.39	1,763,197	0.00	0.91	214.78	100.28	0.00	61g4p0147sg6g	??????????	SELECT COUNT(*) FROM ?????? A ...

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 33.8% of Total User I/O Wait Time (s): 2,398
Captured PL/SQL account for 42.2% of Total User I/O Wait Time (s): 2,398

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
290.68	13	22.36	12.12	632.16	1.61	45.98	fdjtrdaz8hpvg		INSERT /*+ APPEND LEADING(@"SE...
265.17	2,326	0.11	11.06	550.42	2.21	48.18	6svchcy2q99ny	NSAppServer.exe	INSERT INTO ??(????, ??????, ?...
188.75	512	0.37	7.87	2,231.59	7.36	8.46	7jjzdat38s75b	NSAppServer.exe	begin :R := URRP_LOGIN(:U, :P,...
186.28	499	0.37	7.77	2,327.24	7.24	8.00	as10b5kn8p4yt	NSAppServer.exe	declare v_Owner varchar2(200);...
178.32	659	0.27	7.44	1,718.59	4.73	10.38	cr6zmgzj0415k	BA_java	begin :R := URRP_LOGIN(:U, :P,...
178.32	659	0.27	7.44	1,857.47	4.45	9.60	dp76759j3zz22	BA_java	declare v_Owner varchar2(200)...
83.42	572	0.15	3.48	519.44	9.90	16.06	8zju0c4fn1vxh	NSAppServer.exe	begin Common.GetDBLoginInfoByU...
71.45	1,283	0.06	2.98	446.17	7.92	16.01	32xsq65sn0sg5	BA_java	declare v_LogId integer; EXCE...
60.92	4,085,460	0.00	2.54	532.35	78.69	11.44	8b5c0u498ufmg	BA_java	SELECT T.F_LEVEL_ID FROM F_STO...
59.66	992	0.06	2.49	876.46	4.09	6.81	4pt196kpr3ww6	BA_java	select t.??? as username, t.?...
58.22	990	0.06	2.43	400.60	4.17	14.53	6subn4g3kjws0	BA_java	SELECT COUNT(*) FROM ?????? T,...
47.57	12,458	0.00	1.98	649.50	3.02	7.32	48kuxbj2zcsj0	????rkws????	begin pkg_celltree.CTLog(:p1, ...
41.97	60	0.70	1.75	340.25	3.07	12.33	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...

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: 598,440,959
Captured SQL account for 88.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
109,434,182	1,763,197	62.07	18.29	214.78	100.28	0.00	61g4p0147sg6g	??????????	SELECT COUNT(*) FROM ?????? A ...
60,956,497	4	15,239,124.25	10.19	335.74	75.02	3.39	3r0ay6u2jtcgr	????????????	declare v_type varchar2(40); b...
60,951,157	4	15,237,789.25	10.18	327.20	76.91	1.97	02736fx6r61na	????????\????????????\????????????	INSERT INTO TT_rkws3_BILLQRYAL...
42,254,988	624,523	67.66	7.06	160.85	83.04	0.00	adrcm50bvs4hh	??????	SELECT COUNT(*) FROM ?????? T,...
37,544,929	101	371,731.97	6.27	150.74	99.39	0.00	8u1zt1ywywf2z	????????	SELECT :"SYS_B_00" ChildCount,...
33,686,128	12	2,807,177.33	5.63	140.82	99.15	0.00	b948cyb8fdga1	??????????????	SELECT :"SYS_B_00" ChildCount,...
33,136,611	114	290,672.03	5.54	270.15	69.43	1.51	38nj6fq08n777	????rkws????	select t.*, t.rowid, pkg_ctobj...
32,385,488	4,085,460	7.93	5.41	532.35	78.69	11.44	8b5c0u498ufmg	BA_java	SELECT T.F_LEVEL_ID FROM F_STO...
28,759,925	9,588,975	3.00	4.81	241.41	79.25	0.00	01tt82rqxjavd	NSAppServer.exe	SELECT ??????, ???? FROM ???? ...
16,909,002	44	384,295.50	2.83	314.08	42.87	4.80	asw0k18ru88y3	????????\????????	SELECT NVL(PKG_SX_rkws_EX.STK_...
16,908,826	44	384,291.50	2.83	314.04	42.87	4.80	54f9wvbttny1b	????????\????????	SELECT SUM(QTY), MAX(??_??), M...
16,690,323	12	1,390,860.25	2.79	85.84	98.40	0.75	0k30kvsqp2atq	????????	INSERT INTO TT_BILL_QUERY (ID,...
16,318,774	4,087,346	3.99	2.73	121.94	96.78	0.15	bcv85umzumag1	BA_java	SELECT T.ID FROM F_LEVEL_TYPE ...
14,529,433	151	96,221.41	2.43	305.53	99.68	0.00	c27zt11fdgxg3	NSAppServer.exe	select count(*) from ( select ...
14,497,182	149	97,296.52	2.42	303.19	99.83	0.00	b0nrxjw98cjha	NSAppServer.exe	select t.??????, t.?????? RID,...
9,844,686	232	42,433.99	1.65	191.10	88.13	3.26	apfzy1kgwfwgm	??????????????????	select * from (select t.id, pk...
9,817,781	79	124,275.71	1.64	166.92	98.09	0.21	8b7dcr1p97g5d	????????????	SELECT :"SYS_B_00" ChildCount,...
8,791,340	4,396,313	2.00	1.47	121.48	96.32	3.34	76t78dxcavf4n	NSAppServer.exe	SELECT VALUE FROM TS_CUBPENVS ...
8,367,283	54	154,949.69	1.40	154.86	99.76	0.00	gf4awny0hgfv5	????????	SELECT :"SYS_B_00" ChildCount,...
7,335,773	3	2,445,257.67	1.23	113.50	99.95	0.00	a3rz8wrk214p0	???? ???? (???? 0 ??????)	select * from (select * from (...

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: 142,092
Captured SQL account for 12.1% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
5,199	4,085,460	0.00	3.66	532.35	78.69	11.44	8b5c0u498ufmg	BA_java	SELECT T.F_LEVEL_ID FROM F_STO...
4,698	13	361.38	3.31	632.16	1.61	45.98	fdjtrdaz8hpvg		INSERT /*+ APPEND LEADING(@"SE...
3,658	4	914.50	2.57	335.74	75.02	3.39	3r0ay6u2jtcgr	????????????	declare v_type varchar2(40); b...
3,600	4	900.00	2.53	327.20	76.91	1.97	02736fx6r61na	????????\????????????\????????????	INSERT INTO TT_rkws3_BILLQRYAL...
1,141	2,326	0.49	0.80	550.42	2.21	48.18	6svchcy2q99ny	NSAppServer.exe	INSERT INTO ??(????, ??????, ?...
913	12,458	0.07	0.64	649.50	3.02	7.32	48kuxbj2zcsj0	????rkws????	begin pkg_celltree.CTLog(:p1, ...
897	3,518	0.25	0.63	41.39	8.96	57.84	d60w0vs5t8b9f	????rkws????	begin Pkg_CellTree.DoCellTreeV...
738	512	1.44	0.52	2,231.59	7.36	8.46	7jjzdat38s75b	NSAppServer.exe	begin :R := URRP_LOGIN(:U, :P,...
716	499	1.43	0.50	2,327.24	7.24	8.00	as10b5kn8p4yt	NSAppServer.exe	declare v_Owner varchar2(200);...
619	60	10.32	0.44	340.25	3.07	12.33	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...

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: 90,958
Captured SQL account for 3.9% of Total
Total UnOptimized Read Requests: 90,958
Captured SQL account for 3.9% 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
1,681	1,681	13	129.31	1.85	fdjtrdaz8hpvg		INSERT /*+ APPEND LEADING(@"SE...
1,141	1,141	2,326	0.49	1.25	6svchcy2q99ny	NSAppServer.exe	INSERT INTO ??(????, ??????, ?...
913	913	12,458	0.07	1.00	48kuxbj2zcsj0	????rkws????	begin pkg_celltree.CTLog(:p1, ...
897	897	3,518	0.25	0.99	d60w0vs5t8b9f	????rkws????	begin Pkg_CellTree.DoCellTreeV...
499	499	659	0.76	0.55	cr6zmgzj0415k	BA_java	begin :R := URRP_LOGIN(:U, :P,...
499	499	659	0.76	0.55	dp76759j3zz22	BA_java	declare v_Owner varchar2(200)...
326	326	232	1.41	0.36	apfzy1kgwfwgm	??????????????????	select * from (select t.id, pk...
313	313	990	0.32	0.34	6subn4g3kjws0	BA_java	SELECT COUNT(*) FROM ?????? T,...
312	312	4	78.00	0.34	3r0ay6u2jtcgr	????????????	declare v_type varchar2(40); b...
254	254	572	0.44	0.28	8zju0c4fn1vxh	NSAppServer.exe	begin Common.GetDBLoginInfoByU...

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: 38,328,249
Captured SQL account for 64.5% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
9,588,975	9,581,344	1.00	241.41	79.25	0.00	01tt82rqxjavd	NSAppServer.exe	SELECT ??????, ???? FROM ???? ...
4,396,313	4,395,048	1.00	121.48	96.32	3.34	76t78dxcavf4n	NSAppServer.exe	SELECT VALUE FROM TS_CUBPENVS ...
4,087,346	4,087,770	1.00	121.94	96.78	0.15	bcv85umzumag1	BA_java	SELECT T.ID FROM F_LEVEL_TYPE ...
4,085,460	3,776,708	0.92	532.35	78.69	11.44	8b5c0u498ufmg	BA_java	SELECT T.F_LEVEL_ID FROM F_STO...
1,763,197	1,763,163	1.00	214.78	100.28	0.00	61g4p0147sg6g	??????????	SELECT COUNT(*) FROM ?????? A ...
624,523	624,520	1.00	160.85	83.04	0.00	adrcm50bvs4hh	??????	SELECT COUNT(*) FROM ?????? T,...
54,044	483,622	8.95	24.13	85.32	0.00	dxznqjbksb0tb	NSAppServer.exe	select cttreenode_urid, cttree...
35,396	245,325	6.93	4.88	98.57	0.00	3k94ugcdabmx4	????rkws????	select celltree_urid, CELLTREE...
17,129	74,024	4.32	115.53	6.05	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
12,458	12,458	1.00	649.50	3.02	7.32	48kuxbj2zcsj0	????rkws????	begin pkg_celltree.CTLog(:p1, ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 661,721
Captured SQL account for 24.5% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
54,044	54,044	8.17	dxznqjbksb0tb	NSAppServer.exe	select cttreenode_urid, cttree...
35,396	35,396	5.35	3k94ugcdabmx4	????rkws????	select celltree_urid, CELLTREE...
17,130	17,129	2.59	cm5vu20fhtnq1		select /*+ connect_by_filterin...
12,458	12,458	1.88	48kuxbj2zcsj0	????rkws????	begin pkg_celltree.CTLog(:p1, ...
7,353	7,353	1.11	4wb1dqbwf64kd	??????(????)	begin :doa__value := Pkg_CellT...
6,087	6,882	0.92	3f49wxysh2t0v	??????(????)	SELECT ???? FROM ???? WHERE ??...
6,080	6,080	0.92	86050uqtj0sfr	NSAppServer.exe	begin :result := pkg_sx_rkds.i...
5,613	5,613	0.85	fyvwfw72dj4z4	NSAppServer.exe	select status from F_SALE_ORDE...
5,323	5,328	0.80	8zgzyw9r0bgbb	??????(????)	begin select ???? into :v_Resu...
5,102	5,102	0.77	3vvf40yagma8f	NSAppServer.exe	begin :result := pkg_sx_rkds.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
99,677,808		1.86	5pfm9m3gfu46h		update F2_SALE_ORDER set ORGID...
42,124,840		0.78	ds4h0z0k55sxj		insert into F2_SALE_ORDER ( ID...
7,143,264	1	0.13	5mykk74xr35dd	????????	select distinct ??, ??, ??, ??...
2,957,602	2	0.06	ab3swhv5g138y		select OBJOID, CLSOID, RUNTIME...
1,925,576	15	0.04	bn4b3vjw2mj3u		SELECT OBJOID, CLSOID, DECODE(...
1,652,559	161	0.03	9av0n32rax4st	BA_java	insert into F2_SALE_ORDER_D ( ...
1,643,798	549	0.03	brpn42kb2n1cy	??????	select (select count(*) from (...
1,632,668	4	0.03	5crc6g20kgp1p	BA_java	update ??? set ORGID = :1 , DA...
1,443,091	126	0.03	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
1,427,325	1	0.03	38ntwnp135utx	BA_java	SELECT SALE_CODE, DECODE(T.STA...
1,398,535	8	0.03	8f1sjvfxuup9w	PL/SQL Developer	select t., o., m.comments fr...
1,326,219	12	0.02	0k30kvsqp2atq	????????	INSERT INTO TT_BILL_QUERY (ID,...
1,320,397	17	0.02	08f07y1w1xvx1	BA_java	INSERT INTO TS_??????(ID, ???,...
1,213,077	1	0.02	2am60vd2kw8ux		SELECT mgmt_metric_value_obj....
1,187,807	4	0.02	02736fx6r61na	????????\????????????\????????????	INSERT INTO TT_rkws3_BILLQRYAL...

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
987		5pfm9m3gfu46h		update F2_SALE_ORDER set ORGID...
543		ds4h0z0k55sxj		insert into F2_SALE_ORDER ( ID...
67	549	brpn42kb2n1cy	??????	select (select count(*) from (...
64	126	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
49	161	9av0n32rax4st	BA_java	insert into F2_SALE_ORDER_D ( ...
26	1,542	1x28cg3c4zxw5	????????	SELECT NVL(TOTAL_AMOUNT, 0) FR...
26	889	3c1kubcdjnppq		update sys.col_usage$ set equa...
22	133	18naypzfmabd6		INSERT INTO MGMT_SYSTEM_PERFOR...
22	1	23nad9x295gkf		SELECT (m.current_size / 10485...
22	625	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
21	2,141	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
21	3	f0w24abs2byd9	rkws4\????????\????????????	SELECT 0 ID, R.ID TEMPID, R.NA...
21	3	f0w24abs2byd9	rkws4\????????\????????????	SELECT 0 ID, R.ID TEMPID, R.NA...
21	3	f0w24abs2byd9	rkws4\????????\????????????	SELECT 0 ID, R.ID TEMPID, R.NA...
21	3	f0w24abs2byd9	rkws4\????????\????????????	SELECT 0 ID, R.ID TEMPID, R.NA...
21	3	f0w24abs2byd9	rkws4\????????\????????????	SELECT 0 ID, R.ID TEMPID, R.NA...
21	1	gdn3ysuyssf82		SELECT advisor_id FROM sys.wri...

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	30	0.01	0.00
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	681	0.19	0.01
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	27	0.01	0.00
Batched IO same unit count	332	0.09	0.01
Batched IO single block count	32	0.01	0.00
Batched IO slow jump count	1	0.00	0.00
Batched IO vector block count	310	0.09	0.01
Batched IO vector read count	22	0.01	0.00
Block Cleanout Optim referenced	15	0.00	0.00
CCursor + sql area evicted	17	0.00	0.00
CPU used by this session	635,877	176.69	13.87
CPU used when call started	631,108	175.36	13.76
CR blocks created	69,321	19.26	1.51
Cached Commit SCN referenced	83,261	23.13	1.82
Commit SCN cached	1,096	0.30	0.02
DB time	5,200,445	1,445.00	113.42
DBWR checkpoint buffers written	28,445	7.90	0.62
DBWR checkpoints	2	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	28,445	7.90	0.62
DBWR transaction table writes	160	0.04	0.00
DBWR undo block writes	8,738	2.43	0.19
DFO trees parallelized	0	0.00	0.00
HSC Heap Segment Block Changes	167,892	46.65	3.66
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	5,202	1.45	0.11
Heap Segment Array Updates	6,554	1.82	0.14
LOB table id lookup cache misses	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
Number of read IOs issued	52,651	14.63	1.15
PX local messages recv'd	96	0.03	0.00
PX local messages sent	64	0.02	0.00
Parallel operations not downgraded	0	0.00	0.00
RowCR - row contention	3,101	0.86	0.07
RowCR attempts	8,944,103	2,485.22	195.06
RowCR hits	8,947,009	2,486.02	195.13
SMON posted for undo segment recovery	1	0.00	0.00
SMON posted for undo segment shrink	1	0.00	0.00
SQL*Net roundtrips to/from client	538,850	149.73	11.75
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	109,222	30.35	2.38
application wait time	70,188	19.50	1.53
background checkpoints completed	3	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	16,561	4.60	0.36
branch node splits	1	0.00	0.00
buffer is not pinned count	356,475,935	99,050.75	7,774.49
buffer is pinned count	769,729,257	213,877.73	16,787.26
bytes received via SQL*Net from client	260,730,592	72,446.86	5,686.35
bytes sent via SQL*Net to client	711,710,098	197,756.47	15,521.90
calls to get snapshot scn: kcmgss	38,304,430	10,643.31	835.39
calls to kcmgas	135,477	37.64	2.95
calls to kcmgcs	750,305	208.48	16.36
cell physical IO interconnect bytes	2,476,434,944	688,104.64	54,009.31
change write time	15,457	4.29	0.34
cleanout - number of ktugct calls	92,382	25.67	2.01
cleanouts and rollbacks - consistent read gets	63,780	17.72	1.39
cleanouts only - consistent read gets	1,942	0.54	0.04
cluster key scan block gets	50,464	14.02	1.10
cluster key scans	40,176	11.16	0.88
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	216	0.06	0.00
commit batch/immediate requested	216	0.06	0.00
commit cleanout failures: block lost	35,076	9.75	0.76
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	53	0.01	0.00
commit cleanout failures: cannot pin	45	0.01	0.00
commit cleanouts	123,176	34.23	2.69
commit cleanouts successfully completed	87,975	24.44	1.92
commit immediate performed	216	0.06	0.00
commit immediate requested	216	0.06	0.00
commit txn count during cleanout	40,929	11.37	0.89
concurrency wait time	86,455,818	24,022.70	1,885.54
consistent changes	527,548	146.59	11.51
consistent gets	597,525,875	166,029.13	13,031.62
consistent gets - examination	255,908,302	71,106.93	5,581.18
consistent gets direct	59,360	16.49	1.29
consistent gets from cache	597,466,453	166,012.62	13,030.32
consistent gets from cache (fastpath)	308,681,286	85,770.49	6,732.12
cursor authentications	772	0.21	0.02
data blocks consistent reads - undo records applied	265,388	73.74	5.79
db block changes	988,379	274.63	21.56
db block gets	912,517	253.55	19.90
db block gets direct	2,468	0.69	0.05
db block gets from cache	910,047	252.87	19.85
db block gets from cache (fastpath)	194,098	53.93	4.23
deferred (CURRENT) block cleanout applications	61,596	17.12	1.34
dirty buffers inspected	170	0.05	0.00
enqueue conversions	764	0.21	0.02
enqueue deadlocks	0	0.00	0.00
enqueue releases	198,655	55.20	4.33
enqueue requests	199,619	55.47	4.35
enqueue timeouts	21	0.01	0.00
enqueue waits	143	0.04	0.00
exchange deadlocks	9	0.00	0.00
execute count	38,328,249	10,649.92	835.91
failed probes on index block reclamation	1	0.00	0.00
file io service time	61,699	17.14	1.35
file io wait time	44,026,428,588	12,233,226.67	960,185.57
flashback log write bytes	238,927,872	66,388.73	5,210.85
flashback log writes	1,801	0.50	0.04
frame signature mismatch	0	0.00	0.00
free buffer inspected	80,469	22.36	1.75
free buffer requested	151,843	42.19	3.31
heap block compress	20,999	5.83	0.46
hot buffers moved to head of LRU	226,554	62.95	4.94
immediate (CR) block cleanout applications	65,722	18.26	1.43
immediate (CURRENT) block cleanout applications	4,635	1.29	0.10
index crx upgrade (positioned)	30,976	8.61	0.68
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	12,061	3.35	0.26
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	98,401,535	27,341.95	2,146.07
index scans kdiixs1	45,433,830	12,624.29	990.88
leaf node 90-10 splits	475	0.13	0.01
leaf node splits	623	0.17	0.01
lob reads	15,862	4.41	0.35
lob writes	518	0.14	0.01
lob writes unaligned	518	0.14	0.01
logons cumulative	1,824	0.51	0.04
max cf enq hold time	40,770	11.33	0.89
messages received	38,086	10.58	0.83
messages sent	38,086	10.58	0.83
min active SCN optimization applied on CR	111	0.03	0.00
no buffer to keep pinned count	75,086	20.86	1.64
no work - consistent read gets	330,103,897	91,722.99	7,199.33
non-idle wait count	29,368,118	8,160.25	640.50
non-idle wait time	89,129,313	24,765.56	1,943.85
opened cursors cumulative	38,407,884	10,672.05	837.65
parse count (describe)	0	0.00	0.00
parse count (failures)	24,854	6.91	0.54
parse count (hard)	26,266	7.30	0.57
parse count (total)	661,721	183.87	14.43
parse time cpu	55,059	15.30	1.20
parse time elapsed	2,274,402	631.97	49.60
physical read IO requests	90,958	25.27	1.98
physical read bytes	1,164,017,664	323,435.09	25,386.41
physical read total IO requests	99,774	27.72	2.18
physical read total bytes	1,625,619,456	451,696.22	35,453.62
physical read total multi block requests	635	0.18	0.01
physical reads	142,092	39.48	3.10
physical reads cache	66,467	18.47	1.45
physical reads cache prefetch	28,873	8.02	0.63
physical reads direct	75,625	21.01	1.65
physical reads direct (lob)	69,465	19.30	1.51
physical reads direct temporary tablespace	3,585	1.00	0.08
physical reads for flashback new	6,588	1.83	0.14
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	18,382	5.11	0.40
physical write bytes	286,015,488	79,472.54	6,237.80
physical write total IO requests	54,612	15.17	1.19
physical write total bytes	850,815,488	236,408.43	18,555.69
physical write total multi block requests	1,382	0.38	0.03
physical writes	34,914	9.70	0.76
physical writes direct	6,161	1.71	0.13
physical writes direct (lob)	1	0.00	0.00
physical writes direct temporary tablespace	3,586	1.00	0.08
physical writes from cache	28,753	7.99	0.63
physical writes non checkpoint	25,152	6.99	0.55
pinned buffers inspected	4	0.00	0.00
pinned cursors current	1,073	0.30	0.02
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	3,665	1.02	0.08
queries parallelized	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	40,442,860	11,237.49	882.03
recursive cpu usage	373,134	103.68	8.14
redo blocks checksummed by FG (exclusive)	72,808	20.23	1.59
redo blocks read for recovery	0	0.00	0.00
redo blocks written	290,742	80.79	6.34
redo buffer allocation retries	38	0.01	0.00
redo entries	530,459	147.39	11.57
redo k-bytes read for recovery	0	0.00	0.00
redo k-bytes read total	306,165	85.07	6.68
redo log space requests	661	0.18	0.01
redo log space wait time	6,418	1.78	0.14
redo ordering marks	3,784	1.05	0.08
redo size	136,078,740	37,810.97	2,967.78
redo size for direct writes	20,300,808	5,640.80	442.75
redo subscn max counts	9,162	2.55	0.20
redo synch time	287,517	79.89	6.27
redo synch writes	28,672	7.97	0.63
redo wastage	7,862,780	2,184.76	171.48
redo write time	124,691	34.65	2.72
redo writes	30,288	8.42	0.66
rollback changes - undo records applied	104,994	29.17	2.29
rollbacks only - consistent read gets	5,554	1.54	0.12
root node splits	1	0.00	0.00
rows fetched via callback	58,297,115	16,198.49	1,271.42
scheduler wait time	0	0.00	0.00
session connect time	75,463	20.97	1.65
session cursor cache hits	3,060,432	850.37	66.75
session logical reads	598,440,959	166,283.39	13,051.58
shared hash latch upgrades - no wait	10,636,987	2,955.60	231.99
shared hash latch upgrades - wait	80	0.02	0.00
sorts (memory)	577,295	160.41	12.59
sorts (rows)	51,838,561	14,403.91	1,130.56
sql area evicted	749	0.21	0.02
sql area purged	24,854	6.91	0.54
summed dirty queue length	292	0.08	0.01
switch current to new buffer	11,719	3.26	0.26
table fetch by rowid	483,221,186	134,268.31	10,538.72
table fetch continued row	15,158,369	4,211.92	330.59
table scan blocks gotten	109,915,572	30,541.25	2,397.18
table scan rows gotten	3,780,159,877	1,050,358.93	82,442.64
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (short tables)	246,974	68.62	5.39
temp space allocated (bytes)	697,303,040	193,753.31	15,207.69
total cf enq hold time	147,220	40.91	3.21
total number of cf enq holders	320	0.09	0.01
total number of times SMON posted	3	0.00	0.00
transaction rollbacks	216	0.06	0.00
transaction tables consistent read rollbacks	1	0.00	0.00
transaction tables consistent reads - undo records applied	138	0.04	0.00
undo change vector size	41,409,996	11,506.22	903.12
user I/O wait time	240,009	66.69	5.23
user calls	832,732	231.38	18.16
user commits	44,855	12.46	0.98
user rollbacks	997	0.28	0.02
workarea executions - onepass	2	0.00	0.00
workarea executions - optimal	228,954	63.62	4.99
write clones created in background	1	0.00	0.00
write clones created in foreground	30	0.01	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	47,873,344,584	50,323,259,528
session cursor cache count	3,946,188	3,997,976
session uga memory	58,940,210,464,320	59,267,837,646,872
opened cursors current	7,602	9,716
workarea memory allocated	2,210,937	2,388,861
logons current	802	1,666
session pga memory	38,327,560,392	40,061,824,904
session uga memory max	235,827,048,080	239,905,352,336

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)	2	2.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)
Others	441M	2.44	.122536	400M	1.44	.111144	11.9K	88.64
Direct Reads	589M	14.72	.163660	5M	0.02	.001389	0
Buffer Cache Reads	512M	10.46	.142264	0M	0.00	0M	37.4K	43.06
DBWR	0M	0.00	0M	225M	5.01	.062518	0
LGWR	1M	0.01	.000277	141M	8.65	.039178	58	81.19
Direct Writes	1M	0.00	.000277	37M	0.09	.010280	0
Streams AQ	0M	0.00	0M	0M	0.00	0M	4	28.25
TOTAL:	1.5G	27.63	.429017	808M	15.21	.224511	49.3K	54.10

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	1G	25.09	.298422	247M	5.04	.068631	37.58	166.68
Log File	302M	0.09	.083914	141M	8.64	.039178	68.61	113.12
Flashback Log	4M	0.01	.001111	226M	0.50	.062796	25.88	57.00
Control File	134M	2.34	.037233	51M	0.90	.014170	42.06	28.50
Archive Log	0M	0.00	0M	118M	0.03	.032787
Temp File	29M	0.10	.008057	30M	0.09	.008335	39.79	55.00
TOTAL:	1.5G	27.63	.428739	813M	15.21	.225900	37.97	139.66

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)
Others	440M	2.44	.122258	400M	1.44	.111144	10.3K	79.71
Others (Log File)	302M	0.09	.083914	0M	0.00	0M	17	55.59
Others (Flashback Log)	4M	0.01	.001111	227M	0.51	.063074	1844	251.77
Others (Control File)	133M	2.33	.036955	50M	0.89	.013893	8403	42.04
Others (Archive Log)	0M	0.00	0M	118M	0.03	.032787	0
Others (Data File)	1M	0.01	.000277	5M	0.01	.001389	37	72.38
Direct Reads	589M	14.72	.163660	5M	0.02	.001389	0
Direct Reads (Data File)	589M	14.72	.163660	5M	0.02	.001389	0
Buffer Cache Reads	510M	10.44	.141709	0M	0.00	0M	37.3K	42.64
Buffer Cache Reads (Data File)	510M	10.44	.141709	0M	0.00	0M	37.3K	42.64
DBWR	0M	0.00	0M	225M	5.01	.062518	0
DBWR (Data File)	0M	0.00	0M	225M	5.01	.062518	0
LGWR	1M	0.01	.000277	140M	8.65	.038900	38	54.61
LGWR (Log File)	0M	0.00	0M	140M	8.64	.038900	8	75.63
LGWR (Control File)	1M	0.01	.000277	0M	0.01	0M	30	49.00
Direct Writes	1M	0.00	.000277	37M	0.09	.010280	0
Direct Writes (Data File)	1M	0.00	.000277	37M	0.09	.010280	0
Streams AQ	0M	0.00	0M	0M	0.00	0M	4	28.25
Streams AQ (Data File)	0M	0.00	0M	0M	0.00	0M	4	28.25
TOTAL:	1.5G	27.62	.428183	807M	15.21	.224233	47.6K	50.67

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)
rkws	82,526	23	9.73	1.54	16,425	5	204	259.36
UNDOTBS1	6,025	2	106.71	1.00	830	0	203	54.78
SYSAUX	1,870	1	69.93	2.71	604	0	0	0.00
TEMP	346	0	32.17	10.78	325	0	0	0.00
SYSTEM	171	0	77.02	1.00	47	0	3	3.33
USERS	3	0	0.00	1.00	49	0	0	0.00
rkwsT	6	0	0.00	1.00	6	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)
rkws	/oracle/ora11gr2/oradata/orcl/rkws01.DBF	2,297	1	13.45	1.49	228	0	3	370.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws02.DBF	3,709	1	6.17	1.62	253	0	0	0.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws03.DBF	5,164	1	3.85	1.73	231	0	3	500.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws04.DBF	4,837	1	5.60	1.66	325	0	0	0.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws05.DBF	5,389	1	2.58	1.48	179	0	4	122.50
rkws	/oracle/ora11gr2/oradata/orcl/rkws06.DBF	4,977	1	1.95	1.22	185	0	0	0.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws07.DBF	1,857	1	12.47	1.49	208	0	0	0.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws08.DBF	1,530	0	14.85	1.25	211	0	1	220.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws09.DBF	2,213	1	13.32	1.57	216	0	2	220.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws10.DBF	1,665	0	10.95	1.74	241	0	0	0.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws11.dbf	2,754	1	6.87	1.37	256	0	0	0.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws12.DBF	1,324	0	15.26	6.06	298	0	0	0.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws13.DBF	3,080	1	5.62	1.68	363	0	0	0.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws14.DBF	1,918	1	8.62	2.23	250	0	0	0.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws15.DBF	2,589	1	4.84	1.52	218	0	1	160.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws16.DBF	2,668	1	10.22	1.40	583	0	0	0.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws17.DBF	1,948	1	10.12	2.02	292	0	0	0.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws18.DBF	2,423	1	11.93	1.78	506	0	1	180.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws19.DBF	18,180	5	1.89	1.02	1,003	0	2	50.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws20.DBF	2,008	1	21.49	1.93	2,663	1	1	0.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws21.DBF	1,444	0	35.17	1.86	1,353	0	2	475.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws22.DBF	1,449	0	28.72	1.87	1,182	0	1	130.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws23.DBF	2,171	1	17.80	2.05	865	0	0	0.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws24.DBF	993	0	26.31	1.78	791	0	67	327.46
rkws	/oracle/ora11gr2/oradata/orcl/rkws25.DBF	1,176	0	30.20	1.16	1,018	0	7	84.29
rkws	/oracle/ora11gr2/oradata/orcl/rkws26.DBF	1,003	0	52.59	1.24	782	0	4	365.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws27.DBF	1,011	0	68.82	1.00	825	0	9	422.22
rkws	/oracle/ora11gr2/oradata/orcl/rkws28.DBF	735	0	41.40	1.00	887	0	96	206.67
rkws	/oracle/ora11gr2/oradata/orcl/rkws29.DBF	11	0	31.82	1.00	10	0	0	0.00
rkws	/oracle/ora11gr2/oradata/orcl/rkws30.DBF	3	0	0.00	1.00	3	0	0	0.00
rkwsT	/oracle/ora11gr2/oradata/orcl/rkwsT.DBF	3	0	0.00	1.00	3	0	0	0.00
rkwsT	/oracle/ora11gr2/oradata/orcl/rkwsT2.dbf	3	0	0.00	1.00	3	0	0	0.00
SYSAUX	/oracle/ora11gr2/oradata/orcl/sysaux01.dbf	1,870	1	69.93	2.71	604	0	0	0.00
SYSTEM	/oracle/ora11gr2/oradata/orcl/system01.dbf	171	0	77.02	1.00	47	0	3	3.33
TEMP	/oracle/ora11gr2/oradata/orcl/temp01.dbf	346	0	32.17	10.78	325	0	0
UNDOTBS1	/oracle/ora11gr2/oradata/orcl/undotbs01.dbf	6,025	2	106.71	1.00	830	0	203	54.78
USERS	/oracle/ora11gr2/oradata/orcl/users01.dbf	3	0	0.00	1.00	49	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,262,079	100	598,208,134	66,487	28,714	0	0	411

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 34,914

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	28,445	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	105	15984	246392	246331	1658880	246331
E	0	83	11633	172357	171888	1658880	171888

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	1,024	0.10	126	368.50	2,251,763	1	14042225.00
D	2,048	0.20	253	163.22	997,376	1	6216344.00
D	3,072	0.30	379	63.40	387,415	1	2410912.00
D	4,096	0.40	505	33.51	204,742	1	1271253.00
D	5,120	0.50	631	17.42	106,451	1	658036.00
D	6,144	0.60	758	8.42	51,458	1	314942.00
D	7,168	0.70	884	4.72	28,826	1	173748.00
D	8,192	0.80	1,010	2.46	15,060	1	87865.00
D	9,216	0.90	1,136	1.28	7,805	1	42599.00
D	10,240	1.00	1,263	1.00	6,111	1	32030.00
D	11,264	1.10	1,389	0.83	5,061	1	25484.00
D	12,288	1.20	1,515	0.71	4,367	1	21153.00
D	13,312	1.30	1,641	0.65	3,943	1	18505.00
D	14,336	1.40	1,768	0.61	3,717	1	17094.00
D	15,360	1.50	1,894	0.59	3,629	1	16550.00
D	16,384	1.60	2,020	0.58	3,566	1	16156.00
D	17,408	1.70	2,146	0.57	3,506	1	15782.00
D	18,432	1.80	2,273	0.56	3,446	1	15407.00
D	19,456	1.90	2,399	0.55	3,386	1	15033.00
D	20,480	2.00	2,525	0.54	3,326	1	14659.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.48	12,429	65

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin Snap E: End Snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	10,240	6,576	6,605.43	1,986.09	30.07	100.00	0.00	1,048,576
E	10,240	5,311	8,645.82	2,159.84	24.98	100.00	0.00	1,048,576

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	210,425	210,425	0
64K	128K	6,425	6,425	0
128K	256K	1,325	1,325	0
256K	512K	5,295	5,295	0
512K	1024K	3,391	3,391	0
1M	2M	1,557	1,557	0
2M	4M	321	321	0
4M	8M	126	126	0
8M	16M	47	47	0
16M	32M	22	22	0
32M	64M	14	12	2
128M	256M	8	8	0
256M	512M	2	2	0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
1,344	0.13	589,245.24	596,779.94	50.00	29,779	2,059,699,047
2,688	0.25	589,245.24	389,010.31	60.00	14,324	1,698,877,946
5,376	0.50	589,245.24	13,224.21	98.00	0	1,046,272,683
8,064	0.75	589,245.24	633.99	100.00	0	1,024,407,999
10,752	1.00	589,245.24	633.99	100.00	0	1,024,407,999
12,902	1.20	589,245.24	0.00	100.00	0	1,023,306,991
15,053	1.40	589,245.24	0.00	100.00	0	1,023,306,991
17,203	1.60	589,245.24	0.00	100.00	0	1,023,306,991
19,354	1.80	589,245.24	0.00	100.00	0	1,023,306,991
21,504	2.00	589,245.24	0.00	100.00	0	1,023,306,991
32,256	3.00	589,245.24	0.00	100.00	0	1,023,306,991
43,008	4.00	589,245.24	0.00	100.00	0	1,023,306,991
64,512	6.00	589,245.24	0.00	100.00	0	1,023,306,991
86,016	8.00	589,245.24	0.00	100.00	0	1,023,306,991

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.80	136	6,525	298,671,987	1.00	914,514	1.00	336,284
4,608	0.90	652	29,278	298,672,135	1.00	914,366	1.00	1,277,277
5,120	1.00	1,160	46,398	298,672,679	1.00	913,822	1.00	1,277,306
5,632	1.10	1,671	64,054	298,673,159	1.00	913,342	1.00	1,277,332
6,144	1.20	2,183	82,992	298,673,576	1.00	912,925	1.00	1,277,355
6,656	1.30	2,694	101,544	298,673,942	1.00	912,559	1.00	1,277,374
7,168	1.40	3,206	118,228	298,674,248	1.00	912,253	1.00	1,277,391
7,680	1.50	3,678	133,030	298,674,480	1.00	912,021	1.00	1,277,403
8,192	1.60	4,012	143,570	298,674,678	1.00	911,823	1.00	1,277,413
8,704	1.70	4,243	151,141	298,674,831	1.00	911,670	1.00	1,277,421
9,216	1.80	4,397	156,088	298,674,935	1.00	911,566	1.00	1,277,426
9,728	1.90	4,513	159,806	298,675,017	1.00	911,484	1.00	1,277,431
10,240	2.00	4,574	161,518	298,675,074	1.00	911,427	1.00	1,277,433

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
6,144	0.38	13,755,704	2,718,551,051
8,192	0.50	3,684,867	467,724,437
10,240	0.63	2,167,198	128,518,535
12,288	0.75	1,747,944	34,801,693
14,336	0.88	1,634,264	9,422,709
16,384	1.00	1,619,366	6,110,706
18,432	1.13	1,613,374	4,760,240
20,480	1.25	1,611,269	4,487,091
22,528	1.38	1,610,136	4,381,987
24,576	1.50	1,609,326	4,305,603
26,624	1.63	1,608,678	4,160,780
28,672	1.75	1,608,043	4,015,956
30,720	1.88	1,607,574	4,015,956
32,768	2.00	1,607,421	4,015,956

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	207	53	256
undo header	21	6	270
undo block	182	5	30

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)	16	7	9	3	681	227,036.67
PR-Process Startup	183	183	0	9	79	8,807.78
TX-Transaction (index contention)	116	116	0	81	69	848.77
CF-Controlfile Transaction	1,728	1,723	5	9	27	2,994.44
SQ-Sequence Cache	2,949	2,949	0	36	22	620.28
JS-Job Scheduler (queue lock)	12,437	12,437	0	1	2	2,270.00
PS-PX Process Reservation	128	128	0	3	1	200.00
HW-Segment High Water Mark	3,772	3,772	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.00	51,457	4,543	144	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
15-Apr 15:53	844	10,015	4,543	111	1,440	0/0	0/0/0/0/0/0
15-Apr 15:43	926	7,850	3,935	138	1,440	0/0	0/0/0/0/0/0
15-Apr 15:33	722	8,134	3,914	144	1,440	0/0	0/0/0/0/0/0
15-Apr 15:23	914	7,248	2,275	142	1,440	0/0	0/0/0/0/0/0
15-Apr 15:13	904	8,087	1,629	139	1,440	0/0	0/0/0/0/0/0
15-Apr 15:03	1,691	10,123	2,769	137	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,156	0.00		0	0
ASM map operation hash table	1	0.00		0	0
ASM network state latch	183	0.00		0	0
AWR Alerted Metric Element list	81,823	0.00		0	0
Change Notification Hash table latch	1,143	0.00		0	0
Consistent RBA	30,294	0.00		0	0
DML lock allocation	1,560,641	0.01	0.77	3	0
Event Group Locks	1,749	0.00		0	0
FAL Queue	103	0.00		0	0
FIB s.o chain latch	46	0.00		0	0
FOB s.o list latch	11,029	2.10	1.01	88	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	7	0.00		0	0
JS mem alloc latch	6	0.00		0	0
JS queue access latch	7	0.00		0	0
JS queue state obj latch	24,874	0.00		0	0
JS slv state obj latch	237	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,219	0.00		0	0
KTF sga latch	20	0.00		0	1,201	0.00
KWQMN job cache list latch	3	0.00		0	0
KWQP Prop Status	2	0.00		0	0
KWQS pqsubs latch	5	0.00		0	0
KWQS pqueue ctx latch	86	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	73	0.00
Memory Management Latch	1	0.00		0	1,219	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
Minimum flashback SCN latch	1	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	153,112	0.00		0	0
OS process allocation	4,540	1.59	0.99	40	0
OS process: request allocation	2,595	1.66	0.98	23	0
PL/SQL warning settings	176,243	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	177,860	44.71	0.84	15323	0
SGA IO buffer pool latch	62	0.00		0	65	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	118	0.00		0	1,077	0.00
SQL memory manager workarea list latch	520,808	0.00	0.21	0	0
Shared B-Tree	367	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	9,239	0.01	0.00	0	0
active service list	15,590	0.34	0.92	11	3,713	0.03
alert log latch	4	0.00		0	0
archive control	66	0.00		0	0
archive process latch	311	0.32	1.00	0	0
begin backup scn array	90	0.00		0	0
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	402,329	0.02	0.61	12	0
cache buffers chains	943,930,517	0.06	0.01	1322	279,348	0.14
cache buffers lru chain	59,852	0.04	0.96	14	347,874	0.03
cache table scan latch	763	0.00		0	763	0.00
call allocation	11,806	3.82	1.05	621	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	2,628	0.68	0.83	1	0
channel operations parent latch	20,321	0.00	0.00	0	0
checkpoint queue latch	476,026	0.00	1.00	4	24,440	0.00
client/application info	35,952	0.00	0.00	0	0
compile environment latch	1,824	0.05	0.00	0	0
constraint object allocation	396	0.00		0	0
corrupted undo seg latch	315,164	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	183	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	183	0.00		0	0
dml lock allocation	183	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	2,787	2.01	0.95	45	0
enqueue hash chains	399,460	0.01	0.03	0	284	0.00
enqueues	172,785	0.03	0.35	3	0
error message lists	65	0.00		0	0
fifth spare latch	1	0.00		0	0
file cache latch	239	0.00		0	0
flashback FBA barrier	2	0.00		0	0
flashback SCN barrier	4	0.00		0	0
flashback allocation	32,007	0.00		0	0
flashback copy	1	0.00		0	28,948	0.99
flashback hint SCN barrier	2	0.00		0	0
flashback mapping	1,797	0.00		0	0
flashback marker cache	3	0.00		0	0
flashback sync request	631	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	1,564	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	486	0.00		0	31,932	0.00
hash table modification latch	118	0.00		0	0
heartbeat check	1	0.00		0	0
hint flashback FBA barrier	2	0.00		0	0
intra txn parallel recovery	14,853	0.04	0.00	0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	77	0.00		0	76	2.63
job_queue_processes free list latch	156	0.00		0	0
job_queue_processes parameter latch	821	0.00		0	0
k2q lock allocation	1	0.00		0	0
kcbtsemkid latch	2	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kks stats	6,326	0.03	1.00	0	0
kokc descriptor allocation latch	566	0.00		0	0
ksfv messages	1	0.00		0	0
kss move lock	67	0.00		0	0
ksuosstats global area	243	0.00		0	0
ksv allocation latch	315	0.00		0	0
ksv class latch	133	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	2,595	0.92	0.88	8	0
ktm global data	21	0.00		0	0
kwqbsn:qsga	132	0.00		0	0
lgwr LWN SCN	30,500	0.00		0	0
list of block allocation	2,915	0.27	1.13	1	0
loader state object freelist	32,584	0.01	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	25	0.00		0	25	0.00
managed standby latch	101	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	1	0.00		0	0
messages	140,940	0.01	0.67	5	0
mostly latch-free SCN	30,747	0.08	0.00	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	2,486	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	183	0.00		0	0
object queue header heap	78,301	0.00	0.50	0	2,067	0.00
object queue header operation	419,888	0.01	0.91	3	0
object stats modification	2,792	0.00		0	1	0.00
parallel query alloc buffer	725	3.03	1.18	8	0
parallel query stats	35	0.00		0	0
parallel txn reco latch	12,269	0.02	0.00	0	0
parameter list	7,487	0.01	5.00	0	0
parameter table management	2,898	0.28	1.25	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	64,627	0.01	0.00	0	50,003	0.01
process allocation	2,778	2.34	50.06	39	1,748	0.00
process group creation	2,595	0.27	0.86	2	0
process queue	163	0.00		0	0
process queue reference	4,269,670	0.00		0	124,755	0.00
qmn task queue latch	529	0.19	0.00	0	0
query server freelists	164	0.61	1.00	0	0
query server process	32	0.00		0	0
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	94,566	0.28	0.90	58	530,269	0.17
redo copy	65	0.00		0	530,543	0.33
redo writing	103,845	0.02	0.77	6	0
resmgr group change latch	6,529	0.00		0	0
resmgr:active threads	2,780	0.00		0	0
resmgr:actses change group	1,706	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	2,779	2.55	0.92	13	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	71	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	2,407,134	0.09	0.48	680	711	0.56
rules engine aggregate statistics	3	0.00		0	0
rules engine rule set statistics	106	0.00		0	0
second spare latch	1	0.00		0	0
sequence cache	185,277	0.01	0.09	1	0
session allocation	217,011	0.00	0.14	0	72,914	0.01
session idle bit	1,736,462	0.00	0.05	0	0
session queue latch	1	0.00		0	0
session state list latch	4,287	0.21	0.33	0	0
session switching	5,233	0.02	0.00	0	0
session timer	1,946	0.00		0	0
shared pool	901,208	0.67	1.01	3464	0
shared pool sim alloc	62	0.00		0	0
shared pool simulator	11,041	0.01	1.00	0	0
sim partition latch	1	0.00		0	0
simulator hash latch	28,761,293	0.00	0.02	6	0
simulator lru latch	11,640	0.07	0.25	1	28,746,770	0.13
sort extent pool	7,892	0.22	0.76	6	0
space background state object latch	10	0.00		0	0
space background task latch	2,700	0.00		0	2,436	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	71	0.00		0	0
temporary table state object allocation	716	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	154	0.00		0	0
trace latch	864	0.46	0.75	2	0
transaction allocation	362,480	0.00	1.35	1	0
transaction branch allocation	2,470	0.00		0	0
undo global data	414,742	0.00	0.00	0	268	0.00
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	943,930,517	527,402	2,689	524,866
Real-time plan statistics latch	177,860	79,528	67,144	18,051
shared pool	901,208	6,056	6,106	614
row cache objects	2,407,134	2,264	1,077	1,209
call allocation	11,806	451	474	25
redo allocation	94,566	262	236	34
FOB s.o list latch	11,029	232	235	4
simulator hash latch	28,761,293	230	5	225
DML lock allocation	1,560,641	132	101	54
cache buffer handles	402,329	90	55	35
OS process allocation	4,540	72	71	1
resmgr:free threads list	2,779	71	65	6
process allocation	2,778	65	3,254	1
enqueue hash chains	399,460	59	2	57
enqueues	172,785	57	20	38
dummy allocation	2,787	56	53	4
active service list	15,590	53	49	11
OS process: request allocation	2,595	43	42	1
ksz_so allocation latch	2,595	24	21	3
cache buffers lru chain	59,852	23	22	1
sequence cache	185,277	23	2	21
object queue header operation	419,888	22	20	2
parallel query alloc buffer	725	22	26	1
redo writing	103,845	22	17	5
session idle bit	1,736,462	22	1	21
SQL memory manager workarea list latch	520,808	19	4	15
channel handle pool latch	2,628	18	15	3
messages	140,940	18	12	6
sort extent pool	7,892	17	13	4
transaction allocation	362,480	17	23	4
session state list latch	4,287	9	3	6
list of block allocation	2,915	8	9	0
parameter table management	2,898	8	10	1
simulator lru latch	11,640	8	2	6
process group creation	2,595	7	6	1
session allocation	217,011	7	1	6
trace latch	864	4	3	1
checkpoint queue latch	476,026	3	3	0
kks stats	6,326	2	2	0
object queue header heap	78,301	2	1	1
archive process latch	311	1	1	0
parameter list	7,487	1	5	0
query server freelists	164	1	1	0
shared pool simulator	11,041	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
DML lock allocation	ktadmc	99	0
DML lock allocation	ktaiam	1	55
DML lock allocation	ktaidm	1	49
FOB s.o list latch	ksfd_allfob	222	227
FOB s.o list latch	ksfd_fobd	13	8
OS process allocation	kso_new_process:2	58	54
OS process allocation	ksosp_scrub:1	5	9
OS process allocation	ksoreq_submit	3	1
OS process allocation	kso_delete_process:1	2	3
OS process allocation	kso_new_process:1	2	5
OS process allocation	ksosp_forknew	1	0
OS process: request allocation	kso_new_process	42	42
Real-time plan statistics latch	keswxAddNewPlanEntry	67,142	67,144
Real-time plan statistics latch	keswxReclaim	2	0
SQL memory manager workarea list latch	qesmmIUnRegisterWorkArea	3	0
SQL memory manager workarea list latch	qesmmIRefreshBound	1	0
active service list	kswslogon: session logout	28	6
active service list	kswsasidlist: return list of service name	16	13
active service list	kswslogon: session login	7	8
active service list	kswsite: service iterator	2	9
archive process latch	kcrrgpll	1	1
cache buffer handles	kcbzgs	46	51
cache buffer handles	kcbzfs	9	4
cache buffers chains	kcbchg1: kslbegin: bufs not pinned	1,377	229
cache buffers chains	kcbgtcr: fast path (cr pin)	1,260	1,415
cache buffers chains	kcbgtcr: fast path	122	57
cache buffers chains	kcbrls_1	88	765
cache buffers chains	kcbgtcr_2	55	30
cache buffers chains	kcbgcur_2	44	22
cache buffers chains	kcbrls_2	32	182
cache buffers chains	kcbget: pin buffer	12	6
cache buffers chains	kcbnlc	11	98
cache buffers chains	kcbzwb	8	2
cache buffers chains	kcbchg1: kslbegin: call CR func	6	169
cache buffers chains	kcbcge	5	38
cache buffers chains	kcbnew: new latch again	3	0
cache buffers chains	kcbbxsv	2	2
cache buffers chains	kcbgcur: fast path (shr)	2	0
cache buffers chains	kcbgtcr: kslbegin excl	1	5
cache buffers lru chain	kcbzgws	9	0
cache buffers lru chain	kcbzgb	6	14
cache buffers lru chain	kcbo_ivd_proc	2	6
cache buffers lru chain	kcbzswcu	2	0
cache buffers lru chain	kcbbic2	1	3
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP_1	1	0
cache buffers lru chain	kcbo_link_q	1	1
call allocation	ksuprc	196	215
call allocation	ksucrp: top call	134	93
call allocation	ksudlc : rec call	78	67
call allocation	ksuxds	42	45
call allocation	ksudlp: top call	22	29
call allocation	ksusin_int	2	2
channel handle pool latch	ksrchconnect()	15	14
checkpoint queue latch	kcbklbc_cql	2	0
checkpoint queue latch	kcbswcu: Switch buffers	1	1
dummy allocation	ktcscnfy	42	41
dummy allocation	ktcdod	11	12
enqueue hash chains	ksqgtl3	2	1
enqueues	ksqgel: create enqueue	14	11
enqueues	ksqdel	5	12
enqueues	ksqgtl2	1	0
kks stats	kksAllocChildStat	2	2
ksz_so allocation latch	ksznfy1	20	19
ksz_so allocation latch	ksz_parent_so_del1	1	2
list of block allocation	ktlabl	9	6
messages	ksaamb: after wakeup	10	5
messages	ksarcv	1	4
messages	ksarcv: after wait	1	3
object queue header heap	kcbo_check_flist	1	0
object queue header operation	kcbo_link_q	10	2
object queue header operation	kcbo_switch_q_bg	4	0
object queue header operation	kcbo_ivbo	2	3
object queue header operation	kcbo_unlink_q	2	5
object queue header operation	kcbo_sw_buf	1	2
object queue header operation	kcbo_switch_cq	1	4
parallel query alloc buffer	kxfpbalo	26	24
parameter list	kmmsvcl	5	5
parameter table management	kspcpy	10	6
process allocation	ksuapc	3,185	2,777
process allocation	ksucrp:1	65	0
process allocation	ksu_reserve	2	53
process allocation	ksudlp	2	429
process group creation	ksupgpadd	6	6
query server freelists	kxfpobadf	1	1
redo allocation	kcrfw_redo_gen: redo allocation 1	196	0
redo allocation	kcrfw_redo_gen: redo allocation 3	24	63
redo allocation	kcrfw_redo_gen: redo allocation 2	10	0
redo allocation	kcrfw_redo_write: before write	5	55
redo allocation	kcrfw_post: more space	1	141
redo writing	kcrfw_post: rba scn pair	10	0
redo writing	kcrfw_cal_target_rba	6	0
redo writing	kcrfw_post: after write	1	0
resmgr:free threads list	kskthrcreate	65	61
row cache objects	kqreqd: reget	797	0
row cache objects	kqrpre: find obj	237	989
row cache objects	kqrso	23	2
row cache objects	kqreqd	17	84
row cache objects	kqrget2	1	0
sequence cache	kdnnxt: cached seq	1	0
sequence cache	kdnssd	1	0
session allocation	ksuxds	1	1
session idle bit	ksukls: mark killed	1	0
session state list latch	kpseqd	2	0
session state list latch	kpscad	1	5
shared pool	kghalo	4,357	3,675
shared pool	kghupr1	813	1,285
shared pool	kghfre	698	1,035
shared pool	kghalp	201	71
shared pool	kgh_heap_sizes	14	4
shared pool	kghfree_extents: scan	11	24
shared pool	kghasp	7	4
shared pool	kgh_next_free	5	8
shared pool	kghfrunp: clatch: nowait	2	0
shared pool	kghfrunp: alloc: cursor dur	1	0
shared pool simulator	kglsim_upd_newhp	1	0
simulator hash latch	kcbsacc: lookup dba	4	5
simulator hash latch	kcbs_lookup_setid: lookup dba	1	0
simulator lru latch	kcbs_lookup_setid	1	0
simulator lru latch	kcbs_simulate: simulate set	1	0
sort extent pool	ktstallobj1	5	12
sort extent pool	ktst dump	4	1
sort extent pool	ktstcrtobj	4	0
trace latch	kstipg	3	3
transaction allocation	ktcxbr	22	21
transaction allocation	ktiNonImuPoolAllocate	1	1

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
hash table	kkshGetNextChild [KKSHBKLOC1]	34,768,756	0
Library Cache	kglhdgn2 106	2,323,581	324
Library Cache	kglIsOwnerVersionable 121	1,063,158	706
Library Cache	kglpin1 4	881,884	136
Library Cache	kgllkdl1 85	342,860	1,837
Library Cache	kglpndl1 95	232,976	44
Library Cache	kglrfcl1 79	125,419	394
Library Cache	kgllkc1 57	119,538	4,927
Cursor Pin	kksfbc [KKSCHLPIN1]	70,150	0
Library Cache	kgldtin1 42	39,112	0
Library Cache	kglhdgn1 62	27,956	7
Cursor Pin	kkslce [KKSCHLPIN2]	23,729	-11
Library Cache	kglget2 2	12,843	300
Library Cache	kglini1 32	7,528	-0
Library Cache	kgllkal3 82	6,161	5
Library Cache	kglUpgradeLock 119	5,291	-1
Library Cache	kglpnal1 90	4,094	32
Library Cache	kglobld1 75	1,562	-0
hash table	kkscsSearchChildList [KKSHBKLOC2]	1,281	0
Cursor Stat	kkocsStoreBindAwareStats [KKSSTALOC8]	913	0
Cursor Parent	kkscsAddChildNode [KKSPRTLOC34]	673	0
Library Cache	kglhdgh1 64	558	0
Cursor Pin	kksfbc [KKSCHLFSP2]	444	0
Library Cache	kgluhfs1 53	275	-38
Cursor Pin	kksLockDelete [KKSCHLPIN6]	241	0
Library Cache	kglobpn1 71	127	1,349
Library Cache	kgllkal5 84	33	0
Library Cache	kglhbh1 63	5	0
Cursor Pin	kksxsccmp [KKSCHLPIN5]	4	0
Library Cache	kglpur1 28	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: 598,440,959
Captured Segments account for 87.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
rkwsPROD	rkws	IDX??PK	INDEX	99,574,400	16.64
rkwsPROD	rkws	F_SALE_ORDER	TABLE	68,399,168	11.43
rkwsPROD	rkws	F_STOCK	TABLE	66,776,336	11.16
rkwsPROD	rkws	??	TABLE	42,911,440	7.17
rkwsPROD	rkws	F_SEND	TABLE	20,493,952	3.42

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 142,092
Captured Segments account for 9.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
rkwsPROD	rkws	IDX_F_STK_LVL		INDEX	3,258	2.29
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1275538605_17644	TABLE PARTITION	2,208	1.55
rkwsPROD	rkws	F_STOCK_LEVEL		TABLE	1,979	1.39
rkwsPROD	rkws	F_OPER_LOG		TABLE	1,375	0.97
rkwsPROD	rkws	F2_STK_DETAIL		TABLE	1,003	0.71

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 90,958
Captured Segments account for 13.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
rkwsPROD	rkws	IDX_F_STK_LVL	INDEX	3,258	3.58
rkwsPROD	rkws	F_STOCK_LEVEL	TABLE	1,979	2.18
rkwsPROD	rkws	F_OPER_LOG	TABLE	1,375	1.51
rkwsPROD	rkws	F2_STK_DETAIL	TABLE	1,003	1.10
rkwsPROD	rkws	XIE1CELLTREEREADINFOX	INDEX	503	0.55

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 90,958
Captured Segments account for 13.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
rkwsPROD	rkws	IDX_F_STK_LVL	INDEX	3,258	3.58
rkwsPROD	rkws	F_STOCK_LEVEL	TABLE	1,979	2.18
rkwsPROD	rkws	F_OPER_LOG	TABLE	1,375	1.51
rkwsPROD	rkws	F2_STK_DETAIL	TABLE	1,003	1.10
rkwsPROD	rkws	XIE1CELLTREEREADINFOX	INDEX	503	0.55

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: 75,625
Captured Segments account for 2.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1275538605_17644	TABLE PARTITION	2,106	2.78

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 34,914
Captured Segments account for 24.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1275538605_17644	TABLE PARTITION	2,113	6.05
rkwsPROD	rkws	XIE1CELLTREEREADINFOX		INDEX	642	1.84
rkwsPROD	rkws	F_SALE_ORDER		TABLE	555	1.59
rkwsPROD	rkws	IDX??_????_??		INDEX	540	1.55
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	538	1.54

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 18,382
Captured Segments account for 30.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
rkwsPROD	rkws	XIE1CELLTREEREADINFOX		INDEX	541	2.94
rkwsPROD	rkws	F_SALE_ORDER		TABLE	497	2.70
rkwsPROD	rkws	IDX_F_OPER_LOG		INDEX	488	2.65
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	481	2.62
rkwsPROD	rkws	IDX??_????_??		INDEX	467	2.54

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 6,161
Captured Segments account for 34.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1275538605_17644	TABLE PARTITION	2,106	34.18

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

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
rkwsPROD	rkws	F_SALE_ORDER		TABLE	91,264	33.97
rkwsPROD	rkws	F_SALE_ORDER_D		TABLE	33,136	12.33
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	15,552	5.79
rkwsPROD	rkws	PK_CELLTREELOG		INDEX	14,432	5.37
rkwsPROD	rkws	F_SEND		TABLE	14,064	5.23

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
rkwsPROD	rkws	PK_CELLTREELOG		INDEX	43	33.33
rkwsPROD	rkws	PK_??		INDEX	41	31.78
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1275538605_17644	INDEX PARTITION	16	12.40
rkwsPROD	rkws	F_SALE_ORDER		TABLE	5	3.88
rkwsPROD	rkws	F_INST_ORDER_D		TABLE	4	3.10

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

% of Capture shows % of Buffer Busy Waits for each top segment compared
with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
rkwsPROD	rkws	PK_CELLTREELOG		INDEX	83	49.40
rkwsPROD	rkws	PK_??		INDEX	67	39.88
rkwsPROD	rkws	????		TABLE	7	4.17
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	3	1.79
SYS	SYSTEM	SEQ$		TABLE	3	1.79

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	87	0.00	2	1
dc_files	36	0.00	0	36
dc_global_oids	652	0.00	0	66
dc_histogram_data	34,216	0.08	0	18,899
dc_histogram_defs	14,098	0.43	0	12,970
dc_object_grants	4,144	0.00	0	254
dc_objects	65,558	0.02	5	6,543
dc_profiles	1,642	0.00	0	1
dc_rollback_segments	23,552	0.00	0	306
dc_segments	11,774	0.05	42	3,228
dc_sequences	2,988	0.23	2,988	223
dc_table_scns	669	0.00	34	3
dc_tablespaces	319,932	0.00	0	8
dc_users	381,302	0.00	0	162
global database name	3,939	0.00	0	1
outstanding_alerts	39	7.69	3	9
sch_lj_oids	5	0.00	0	39

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
APP CONTEXT	2,212	0.00	2,212	0.00	0	0
BODY	11,509	0.00	231,490	0.00	1	0
CLUSTER	37	0.00	11	0.00	0	0
DBLINK	3,131	0.00	0		0	0
EDITION	1,668	0.00	3,308	0.00	0	0
QUEUE	59	0.00	234	0.00	0	0
RULESET	3	0.00	3	0.00	0	0
SCHEMA	3,400	0.00	0		0	0
SQL AREA	239,693	36.45	38,617,607	0.22	26,157	24,859
SUBSCRIPTION	17	0.00	17	0.00	0	0
TABLE/PROCEDURE	218,793	0.03	542,958	0.04	66	0
TRIGGER	1,064	0.00	1,110	0.09	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)	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	10,240.00	10,240.00	4,352.00	10,496.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	16,128.00	SHR/MAN
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	16,384.00	16,384.00	11,008.00	16,384.00	GRO/MAN
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	0.00	256.00	GRO/IMM
shared pool	5,120.00	5,120.00	1,792.00	5,888.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,512.20		3.12	2.21	33	33	804	804
	SQL	2,339.04	2,199.53	2.98	11.92	281	282	785	772
	PL/SQL	1,089.53	1,042.72	1.36	0.53	3	3	802	802
	Freeable	664.88	0.00	0.96	1.15	19		696	696
E	Other	3,681.86		2.16	1.79	33	34	1,704	1,704
	SQL	2,458.26	2,347.87	1.49	8.68	281	282	1,651	1,607
	PL/SQL	1,529.38	1,474.34	0.90	0.65	2	3	1,701	1,669
	Freeable	980.50	0.00	0.84	0.97	19		1,165	1,165

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	10,737,418,240
Fixed Size	2,214,096
Redo Buffers	141,578,240
Variable Size	16,911,435,568

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	535.75	546.78	2.06
shared	FileOpenBlock	184.70	184.70	0.00
shared	KGH: NO ACCESS	2,557.34	2,557.51	0.01
shared	KKSSP	147.49	169.36	14.83
shared	PCUR	223.97	227.38	1.53
shared	SQLA	790.07	795.63	0.70
shared	SQLP	83.87	86.87	3.58
shared	db_block_hash_buckets	89.00	89.00	0.00
shared	free memory	2,318.64	2,257.45	-2.64
streams	free memory	256.00	256.00	0.00
	buffer_cache	10,240.00	10,240.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	0408 11:03:58	0.52	0.11	0.00
QMON Coordinator	0408 11:03:48	0.02	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	3	0.00	0	0.00	0.48	0.00	0.00	0.16	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)	3	0	100.00	0.00	20.75	0.00	0.00	27.04
SYS.AQ$_ALERT_QT_E(12342)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(66573)	75	75	0.00	0.00	6.81	14.38	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	6.92
SYS.AQ$_ALERT_QT_E(12342)	0.00	0.00
SYSMAN.MGMT_TASK_Q(66573)	0.02	0.02	0.09	0.19

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
rkwsDB3850X5__3938_ORCL(22)/SYS.ALERT_QUE	3	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,686	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,685	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
pga_aggregate_target	10737418240
processes	3000
remote_login_passwordfile	EXCLUSIVE
resource_limit	TRUE
session_cached_cursors	500
sessions	4528
sga_target	17179869184
shadow_core_dump	partial	PARTIAL
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.88
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	99.78	Soft Parse %:	96.03
Execute to Parse %:	98.27	Latch Hit %:	99.94
Parse CPU to Parse Elapsd %:	2.42	% Non-Parse CPU:	97.68