WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
dbone	118511790	dbone	1	10.2.0.5.0	NO	dbone.com

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	26178	06-Nov-13 18:00:53	683	6.4
End Snap:	26179	06-Nov-13 18:30:54	683	6.4
Elapsed:		30.02 (mins)
DB Time:		24.41 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	37,584M	37,584M	Std Block Size:	8K
Shared Pool Size:	3,296M	3,296M	Log Buffer:	14,256K

Load Profile

	Per Second	Per Transaction
Redo size:	5,139.67	4,518.17
Logical reads:	184.98	162.61
Block changes:	28.13	24.73
Physical reads:	0.42	0.37
Physical writes:	3.24	2.85
User calls:	154.48	135.80
Parses:	40.67	35.75
Hard parses:	0.15	0.13
Sorts:	1.54	1.36
Logons:	0.18	0.16
Executes:	45.74	40.20
Transactions:	1.14

% Blocks changed per Read:	15.21	Recursive Call %:	21.58
Rollback per transaction %:	0.00	Rows per Sort:	224.84

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.78	In-memory Sort %:	100.00
Library Hit %:	98.42	Soft Parse %:	99.63
Execute to Parse %:	11.08	Latch Hit %:	99.84
Parse CPU to Parse Elapsd %:	11.13	% Non-Parse CPU:	32.12

Shared Pool Statistics

	Begin	End
Memory Usage %:	80.43	66.40
% SQL with executions>1:	99.60	98.25
% Memory for SQL w/exec>1:	92.42	87.32

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
latch: library cache	262	928	3,544	63.4	Concurrency
library cache lock	112	275	2,455	18.8	Concurrency
CPU time		144		9.8
cursor: pin S wait on X	3,927	42	11	2.9	Concurrency
cursor: pin S	40,951,979	17	0	1.2	Other

Main Report

Wait Events Statistics

Time Model Statistics

Total time in database user-calls (DB Time): 1464.6s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
parse time elapsed	856.54	58.48
sql execute elapsed time	418.45	28.57
DB CPU	143.67	9.81
connection management call elapsed time	108.49	7.41
PL/SQL execution elapsed time	85.23	5.82
hard parse elapsed time	1.17	0.08
hard parse (sharing criteria) elapsed time	0.24	0.02
sequence load elapsed time	0.03	0.00
hard parse (bind mismatch) elapsed time	0.01	0.00
repeated bind elapsed time	0.01	0.00
PL/SQL compilation elapsed time	0.01	0.00
failed parse elapsed time	0.00	0.00
DB time	1,464.62
background elapsed time	21.60
background cpu time	12.89

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%Total Call Time
Concurrency	4,720	85	1,247	264	85.12
CPU time			144		9.81
Other	40,952,178		18	0	1.21
User I/O	909		6	6	0.39
System I/O	9,189		5	1	0.34
Commit	4,029		5	1	0.33
Network	211,625		0	0	0.01
Application	10		0	9	0.01

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
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
latch: library cache	262		928	3544	0.13
library cache lock	112	71	275	2455	0.05
cursor: pin S wait on X	3,927	100	42	11	1.92
cursor: pin S	40,951,979		17	0	19,986.32
db file sequential read	909		6	6	0.44
log file sync	4,029		5	1	1.97
log file parallel write	4,230		5	1	2.06
latch: shared pool	184		1	5	0.09
control file parallel write	640		0	1	0.31
latch: session allocation	39		0	5	0.02
latch free	157		0	1	0.08
SQL*Net message to client	210,660		0	0	102.81
os thread startup	6		0	22	0.00
enq: TX - row lock contention	1		0	81	0.00
control file sequential read	4,319		0	0	2.11
SQL*Net more data from client	469		0	0	0.23
SQL*Net break/reset to client	9		0	1	0.00
SQL*Net more data to client	496		0	0	0.24
buffer busy waits	3		0	1	0.00
latch: library cache lock	6		0	0	0.00
cursor: mutex S	3		0	0	0.00
cursor: mutex X	216		0	0	0.11
rdbms ipc reply	3		0	0	0.00
latch: cache buffers chains	1		0	0	0.00
SQL*Net message from client	210,976		449,495	2131	102.97
Streams AQ: qmn slave idle wait	131		3,555	27140	0.06
Streams AQ: qmn coordinator idle wait	195	33	1,778	9116	0.10
virtual circuit status	60	100	1,758	29297	0.03
EMON idle wait	362	99	1,758	4855	0.18
Streams AQ: waiting for messages in the queue	361	99	1,751	4852	0.18
Streams AQ: waiting for time management or cleanup tasks	19	58	1,641	86355	0.01
jobq slave wait	20	100	59	2931	0.01
wait for unread message on broadcast channel	339		1	2	0.17
class slave wait	5		0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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
log file parallel write	4,230		5	1	2.06
latch: library cache	3		2	502	0.00
control file parallel write	640		0	1	0.31
os thread startup	6		0	22	0.00
events in waitclass Other	133		0	0	0.06
control file sequential read	3,280		0	0	1.60
latch: shared pool	6		0	2	0.00
buffer busy waits	1		0	0	0.00
rdbms ipc message	12,576	58	28,135	2237	6.14
Streams AQ: qmn slave idle wait	131		3,555	27140	0.06
Streams AQ: qmn coordinator idle wait	195	33	1,778	9116	0.10
smon timer	6	100	1,758	293014	0.00
pmon timer	607	100	1,758	2896	0.30
EMON idle wait	362	99	1,758	4855	0.18
Streams AQ: waiting for time management or cleanup tasks	19	58	1,641	86355	0.01
wait for unread message on broadcast channel	60		0	4	0.03

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	21,993
IDLE_TIME	2,859,773
IOWAIT_TIME	12,399
NICE_TIME	0
SYS_TIME	4,480
USER_TIME	17,017
LOAD	0
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	188,432,384
VM_OUT_BYTES	201,900,032
PHYSICAL_MEMORY_BYTES	67,580,121,088
NUM_CPUS	16
NUM_CPU_SOCKETS	2

Back to Wait Events Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	13,839	7.68	6.75
CPU used when call started	12,972	7.20	6.33
CR blocks created	19	0.01	0.01
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	335,147	186.07	163.57
DBWR checkpoint buffers written	5,841	3.24	2.85
DBWR checkpoints	0	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	0	0.00	0.00
DBWR transaction table writes	59	0.03	0.03
DBWR undo block writes	2,152	1.19	1.05
Misses for writing mapping	0	0.00	0.00
OS Involuntary context switches	0	0.00	0.00
OS Page faults	0	0.00	0.00
OS Page reclaims	0	0.00	0.00
OS System time used	0	0.00	0.00
OS User time used	0	0.00	0.00
OS Voluntary context switches	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
RowCR - row contention	53	0.03	0.03
RowCR attempts	1,450	0.81	0.71
RowCR hits	1,422	0.79	0.69
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	209,621	116.38	102.30
active txn count during cleanout	3,114	1.73	1.52
application wait time	9	0.00	0.00
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	7,264	4.03	3.55
branch node splits	0	0.00	0.00
buffer is not pinned count	120,369	66.83	58.75
buffer is pinned count	112,121	62.25	54.72
bytes received via SQL*Net from client	31,415,664	17,441.20	15,332.19
bytes sent via SQL*Net to client	32,497,140	18,041.61	15,860.00
calls to get snapshot scn: kcmgss	91,800	50.97	44.80
calls to kcmgas	6,914	3.84	3.37
calls to kcmgcs	349	0.19	0.17
change write time	22	0.01	0.01
cleanout - number of ktugct calls	420	0.23	0.20
cleanouts and rollbacks - consistent read gets	3	0.00	0.00
cleanouts only - consistent read gets	103	0.06	0.05
cluster key scan block gets	1,726	0.96	0.84
cluster key scans	297	0.16	0.14
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	1	0.00	0.00
commit batch/immediate requested	1	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	139	0.08	0.07
commit cleanout failures: cannot pin	1	0.00	0.00
commit cleanouts	14,220	7.89	6.94
commit cleanouts successfully completed	14,080	7.82	6.87
commit immediate performed	1	0.00	0.00
commit immediate requested	1	0.00	0.00
commit txn count during cleanout	2,548	1.41	1.24
concurrency wait time	124,084	68.89	60.56
consistent changes	158	0.09	0.08
consistent gets	245,431	136.26	119.78
consistent gets - examination	191,996	106.59	93.70
consistent gets direct	0	0.00	0.00
consistent gets from cache	245,431	136.26	119.78
current blocks converted for CR	0	0.00	0.00
cursor authentications	155	0.09	0.08
data blocks consistent reads - undo records applied	23	0.01	0.01
db block changes	50,666	28.13	24.73
db block gets	87,753	48.72	42.83
db block gets direct	0	0.00	0.00
db block gets from cache	87,753	48.72	42.83
deferred (CURRENT) block cleanout applications	4,173	2.32	2.04
dirty buffers inspected	0	0.00	0.00
enqueue conversions	101,624	56.42	49.60
enqueue deadlocks	0	0.00	0.00
enqueue releases	218,715	121.43	106.74
enqueue requests	218,715	121.43	106.74
enqueue timeouts	0	0.00	0.00
enqueue waits	1	0.00	0.00
exchange deadlocks	0	0.00	0.00
execute count	82,380	45.74	40.20
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	1,428	0.79	0.70
free buffer requested	2,150	1.19	1.05
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	37	0.02	0.02
hot buffers moved to head of LRU	4,980	2.76	2.43
immediate (CR) block cleanout applications	106	0.06	0.05
immediate (CURRENT) block cleanout applications	224	0.12	0.11
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	2,776	1.54	1.35
index fast full scans (full)	0	0.00	0.00
index fetch by key	45,442	25.23	22.18
index scans kdiixs1	12,355	6.86	6.03
leaf node 90-10 splits	41	0.02	0.02
leaf node splits	58	0.03	0.03
lob reads	32	0.02	0.02
lob writes	32	0.02	0.02
lob writes unaligned	32	0.02	0.02
logons cumulative	333	0.18	0.16
messages received	8,299	4.61	4.05
messages sent	8,299	4.61	4.05
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	46,418	25.77	22.65
opened cursors cumulative	73,397	40.75	35.82
parse count (failures)	2	0.00	0.00
parse count (hard)	268	0.15	0.13
parse count (total)	73,250	40.67	35.75
parse time cpu	9,752	5.41	4.76
parse time elapsed	87,627	48.65	42.77
physical read IO requests	748	0.42	0.37
physical read bytes	6,127,616	3,401.90	2,990.54
physical read total IO requests	6,305	3.50	3.08
physical read total bytes	79,259,648	44,003.00	38,682.11
physical read total multi block requests	240	0.13	0.12
physical reads	748	0.42	0.37
physical reads cache	748	0.42	0.37
physical reads cache prefetch	0	0.00	0.00
physical reads direct	0	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	3,487	1.94	1.70
physical write bytes	47,849,472	26,564.84	23,352.60
physical write total IO requests	9,631	5.35	4.70
physical write total bytes	89,969,152	49,948.65	43,908.81
physical write total multi block requests	2,483	1.38	1.21
physical writes	5,841	3.24	2.85
physical writes direct	0	0.00	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	5,841	3.24	2.85
physical writes non checkpoint	1,675	0.93	0.82
pinned buffers inspected	0	0.00	0.00
pinned cursors current	0	0.00	0.00
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	1	0.00	0.00
process last non-idle time	1,800	1.00	0.88
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	76,582	42.52	37.38
recursive cpu usage	813	0.45	0.40
redo blocks read for recovery	0	0.00	0.00
redo blocks written	20,825	11.56	10.16
redo buffer allocation retries	0	0.00	0.00
redo entries	32,357	17.96	15.79
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	2,134	1.18	1.04
redo size	9,257,736	5,139.67	4,518.17
redo subscn max counts	2,679	1.49	1.31
redo synch time	504	0.28	0.25
redo synch writes	4,052	2.25	1.98
redo wastage	1,220,248	677.45	595.53
redo write time	482	0.27	0.24
redo writer latching time	0	0.00	0.00
redo writes	4,224	2.35	2.06
rollback changes - undo records applied	2	0.00	0.00
rollbacks only - consistent read gets	16	0.01	0.01
root node splits	0	0.00	0.00
rows fetched via callback	47,459	26.35	23.16
session connect time	0	0.00	0.00
session cursor cache hits	69,652	38.67	33.99
session logical reads	333,184	184.98	162.61
shared hash latch upgrades - no wait	4,831	2.68	2.36
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	2,782	1.54	1.36
sorts (rows)	625,511	347.27	305.28
sql area evicted	35,544	19.73	17.35
sql area purged	16	0.01	0.01
summed dirty queue length	0	0.00	0.00
switch current to new buffer	12	0.01	0.01
table fetch by rowid	61,129	33.94	29.83
table fetch continued row	26	0.01	0.01
table scan blocks gotten	16,537	9.18	8.07
table scan rows gotten	865,488	480.50	422.40
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	718	0.40	0.35
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	1	0.00	0.00
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	3,244,648	1,801.35	1,583.53
user I/O wait time	574	0.32	0.28
user calls	278,248	154.48	135.80
user commits	2,049	1.14	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	1,726	0.96	0.84
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session pga memory max	55,929,198,080	55,935,085,936
session cursor cache count	80,361,170	80,364,192
session uga memory	1.9E+14	1.9E+14
opened cursors current	4,353	4,368
logons current	683	683
session uga memory max	5.7E+12	5.7E+12
session pga memory	46,393,037,664	46,398,728,912

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

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	4,648,671	100	333,177	748	5,841	0	0	3

Advisory Statistics

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	8	1050	3985	22343	737280	22343
E	0	8	937	3233	21331	737280	21331

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	3,744	0.10	463,086	2615.56	1.8E+11
D	7,488	0.20	926,172	932.21	64,259,712,586
D	11,232	0.30	1,389,258	15.29	1,054,176,918
D	14,976	0.40	1,852,344	2.54	175,043,652
D	18,720	0.50	2,315,430	1.77	122,077,923
D	22,464	0.60	2,778,516	1.43	98,258,455
D	26,208	0.70	3,241,602	1.24	85,661,220
D	29,952	0.80	3,704,688	1.13	77,786,478
D	33,696	0.90	4,167,774	1.05	72,449,500
D	37,440	1.00	4,630,860	1.00	69,057,229
D	37,584	1.00	4,648,671	1.00	68,933,024
D	41,184	1.10	5,093,946	0.95	65,442,745
D	44,928	1.20	5,557,032	0.92	63,179,078
D	48,672	1.30	6,020,118	0.89	61,223,818
D	52,416	1.39	6,483,204	0.85	58,356,160
D	56,160	1.49	6,946,290	0.81	55,606,986
D	59,904	1.59	7,409,376	0.76	52,583,310
D	63,648	1.69	7,872,462	0.74	51,008,923
D	67,392	1.79	8,335,548	0.71	49,198,974
D	71,136	1.89	8,798,634	0.70	48,004,746
D	74,880	1.99	9,261,720	0.62	42,507,372

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	138	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	8,192	7,002	558.48	0.00	0.00	0.00	0.00	838,860
E	8,192	7,002	562.91	0.00	0.00	0.00	0.00	838,860

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	1,544	1,544
64K	128K	43	43
128K	256K	2	2
512K	1024K	101	101
1M	2M	33	33
2M	4M	3	3

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 %
1,024	0.13	2,579,124.12	39,667.30	98.00
2,048	0.25	2,579,124.12	37,131.96	99.00
4,096	0.50	2,579,124.12	36,717.46	99.00
6,144	0.75	2,579,124.12	36,717.46	99.00
8,192	1.00	2,579,124.12	36,717.46	99.00
9,830	1.20	2,579,124.12	3,245.73	100.00
11,469	1.40	2,579,124.12	3,245.73	100.00
13,107	1.60	2,579,124.12	3,245.73	100.00
14,746	1.80	2,579,124.12	3,245.73	100.00
16,384	2.00	2,579,124.12	3,245.73	100.00
24,576	3.00	2,579,124.12	3,245.73	100.00
32,768	4.00	2,579,124.12	3,245.73	100.00
49,152	6.00	2,579,124.12	3,245.73	100.00
65,536	8.00	2,579,124.12	3,245.73	100.00

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
1,616	0.49	375	36,594	4,615,873	1.00	43,995	1.18	1,314,390
1,952	0.59	704	57,064	4,620,613	1.00	39,255	1.05	1,314,858
2,288	0.69	1,039	79,887	4,622,209	1.00	37,659	1.01	1,314,990
2,624	0.80	1,374	107,407	4,622,453	1.00	37,415	1.00	1,315,010
2,960	0.90	1,709	136,157	4,622,523	1.00	37,345	1.00	1,315,016
3,296	1.00	2,044	164,823	4,622,588	1.00	37,280	1.00	1,315,019
3,632	1.10	2,379	191,529	4,622,610	1.00	37,258	1.00	1,315,022
3,968	1.20	2,714	220,149	4,622,624	1.00	37,244	1.00	1,315,024
4,304	1.31	3,049	251,380	4,622,634	1.00	37,234	1.00	1,315,025
4,640	1.41	3,384	282,424	4,622,642	1.00	37,226	1.00	1,315,026
4,976	1.51	3,705	305,992	4,622,647	1.00	37,221	1.00	1,315,027
5,312	1.61	4,040	325,228	4,622,654	1.00	37,214	1.00	1,315,028
5,648	1.71	4,375	352,634	4,622,657	1.00	37,211	1.00	1,315,029
5,984	1.82	4,710	374,913	4,622,659	1.00	37,209	1.00	1,315,030
6,320	1.92	5,028	394,738	4,622,660	1.00	37,208	1.00	1,315,030
6,656	2.02	5,363	416,218	4,622,661	1.00	37,207	1.00	1,315,031

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
10,240	0.25	326,979,088	67,686,893,170
20,480	0.50	20,699,820	128,587,661
30,720	0.75	20,491,371	81,933,791
40,960	1.00	20,436,193	68,933,023
51,200	1.25	20,409,626	64,486,843
61,440	1.50	20,368,754	55,387,684
71,680	1.75	20,346,274	50,562,372
81,920	2.00	20,321,750	44,771,998

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)
16	0.50	0	0	0	0
32	1.00	0	0	0	0
48	1.50	0	0	0	0
64	2.00	0	0	0	0
80	2.50	0	0	0	0
96	3.00	0	0	0	0
112	3.50	0	0	0	0
128	4.00	0	0	0	0
144	4.50	0	0	0	0
160	5.00	0	0	0	0
176	5.50	0	0	0	0
192	6.00	0	0	0	0
208	6.50	0	0	0	0
224	7.00	0	0	0	0
240	7.50	0	0	0	0
256	8.00	0	0	0	0
272	8.50	0	0	0	0
288	9.00	0	0	0	0
304	9.50	0	0	0	0
320	10.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

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	2	0	0
undo block	1	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	1	1	0	1	0	80.00

Back to Wait Statistics
Back to Top

Undo Statistics

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
1	2.91	3,264	0	7	240/240	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 Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
06-Nov 18:32	686	763	3	240	0/0	0/0/0/0/0/0
06-Nov 18:22	664	698	3	240	0/0	0/0/0/0/0/0
06-Nov 18:12	779	998	7	240	0/0	0/0/0/0/0/0
06-Nov 18:02	781	805	3	240	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	1,206	0.00		0	0
AWR Alerted Metric Element list	26,966	0.00		0	0
Consistent RBA	4,230	0.00		0	0
DMON Work Queues Latch	876	0.00		0	0
FAL request queue	36	0.00		0	0
FAL subheap alocation	36	0.00		0	0
FIB s.o chain latch	1,672	0.06	0.00	0	0
FOB s.o list latch	2,304	0.04	0.00	0	0
Fast-Start Failover State Latch	120	0.00		0	0
JS mem alloc latch	5	0.00		0	0
JS queue access latch	5	0.00		0	0
JS queue state obj latch	13,014	0.00		0	0
JS slv state obj latch	2	0.00		0	0
KMG MMAN ready and startup request latch	600	0.00		0	0
KPON ksr channel latch	370	0.00		0	0
KTF sga latch	4,515	0.00		0	537	0.00
KWQMN job cache list latch	43	9.30	1.00	0	0
KWQP Prop Status	2	0.00		0	0
MQL Tracking Latch	0			0	36	0.00
Memory Management Latch	0			0	600	0.00
NSV command ID generation latch	60	0.00		0	0
NSV creation/termination latch	60	0.00		0	0
OS process	1,032	0.00		0	0
OS process allocation	1,288	0.00		0	0
OS process: request allocation	664	0.00		0	0
PL/SQL warning settings	2,438	0.00		0	0
RSM SQL latch	3,120	0.00		0	0
RSM process latch	180	0.00		0	0
Request id generation latch	342	0.00		0	0
SQL memory manager latch	1	0.00		0	600	0.00
SQL memory manager workarea list latch	41,795	0.00		0	0
Shared B-Tree	94	0.00		0	0
active checkpoint queue latch	4,690	0.00		0	0
active service list	10,000	0.01	0.00	0	4,051	0.00
alert log latch	3,084	0.00		0	0
archive control	4,038	0.00		0	0
archive process latch	672	0.00		0	0
cache buffer handles	472	0.00		0	0
cache buffers chains	612,018	0.00	0.05	0	2,193	0.00
cache buffers lru chain	11,770	0.00		0	2,169	0.00
channel anchor	740	0.00		0	0
channel handle pool latch	784	0.00		0	0
channel operations parent latch	16,765	0.10	0.00	0	0
checkpoint queue latch	143,912	0.00		0	5,644	0.00
client/application info	4,065	0.00		0	0
commit callback allocation	24	0.00		0	0
compile environment latch	333	0.00		0	0
dictionary lookup	11	0.00		0	0
dml lock allocation	19,055	0.00		0	0
dummy allocation	666	0.15	0.00	0	0
enqueue hash chains	539,291	0.00	0.00	0	0
enqueues	441,179	0.02	0.00	0	0
event group latch	332	0.00		0	0
file cache latch	308	0.00		0	0
global KZLD latch for mem in SGA	78	0.00		0	0
global tx hash mapping	254,658	0.00	0.00	0	0
hash table column usage latch	68	0.00		0	4,536	0.00
hash table modification latch	30	0.00		0	0
interrupt manipulation	3	0.00		0	0
job workq parent latch	0			0	2	0.00
job_queue_processes parameter latch	31	0.00		0	0
kks stats	70,249	3.10	0.00	0	0
kokc descriptor allocation latch	4,516	0.00		0	0
ksuosstats global area	122	0.00		0	0
ktm global data	6	0.00		0	0
kwqbsn:qsga	93	0.00		0	0
lgwr LWN SCN	4,230	0.00		0	0
library cache	130,662	0.58	0.35	928	219	0.00
library cache load lock	38	0.00		0	0
library cache lock	261,435	0.34	0.01	0	345	0.00
library cache lock allocation	1,639	0.00		0	0
library cache pin	28,339	0.09	0.00	0	0
library cache pin allocation	26	0.00		0	0
list of block allocation	45	0.00		0	0
logminer context allocation	1	0.00		0	0
message pool operations parent latch	1,676	0.06	0.00	0	0
messages	37,340	0.02	0.00	0	0
mostly latch-free SCN	4,230	0.00		0	0
ncodef allocation latch	29	0.00		0	0
object queue header heap	71	0.00		0	23	0.00
object queue header operation	21,163	0.00		0	0
object stats modification	1	0.00		0	0
parallel query alloc buffer	228	0.00		0	0
parameter list	43	0.00		0	0
parameter table management	677	0.00		0	0
post/wait queue	6,057	0.00		0	4,031	0.00
process allocation	664	1.51	1.00	0	332	0.00
process group creation	664	0.00		0	0
qmn task queue latch	456	28.51	1.00	0	0
redo allocation	12,678	0.00		0	32,429	0.00
redo copy	0			0	32,429	0.01
redo writing	18,675	0.00		0	0
resmgr group change latch	1,078	0.00		0	0
resmgr:active threads	657	0.00		0	0
resmgr:actses change group	327	0.00		0	0
resmgr:free threads list	656	0.15	0.00	0	0
resmgr:resource group CPU method	327	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	74,090	0.26	0.00	0	2	0.00
rules engine aggregate statistics	4	0.00		0	0
rules engine rule set statistics	108	0.00		0	0
sequence cache	6,794	0.00		0	0
session allocation	58,563	0.08	0.83	0	0
session idle bit	584,658	0.00	0.00	0	0
session state list latch	844	0.24	0.00	0	0
session switching	1,689	0.00		0	0
session timer	607	0.00		0	0
shared pool	354,362	0.87	0.06	1	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	52,936	0.00		0	0
simulator hash latch	24,897	0.00		0	0
simulator lru latch	5,841	0.00		0	19,016	0.03
slave class	5	0.00		0	0
slave class create	20	5.00	1.00	0	0
sort extent pool	50	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
threshold alerts latch	178	0.00		0	0
transaction allocation	398,583	0.00		0	0
transaction branch allocation	232,539	0.02	0.00	0	0
undo global data	38,077	0.00		0	0
user lock	320	0.63	1.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
shared pool	354,362	3,068	184	2,943
kks stats	70,249	2,178	10	2,168
library cache lock	261,435	888	6	882
library cache	130,662	755	262	497
qmn task queue latch	456	130	130	0
session allocation	58,563	47	39	10
cache buffers chains	612,018	21	1	20
process allocation	664	10	10	0
KWQMN job cache list latch	43	4	4	0
user lock	320	2	2	0
slave class create	20	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
KWQMN job cache list latch	kwqmnuji: update job item	4	4
cache buffers chains	kcbgtcr: kslbegin excl	3	2
cache buffers chains	kcbgtcr: fast path	1	0
cost function	kzulgt: find user res	1	1
cost function	kzulrl	1	1
event range base latch	No latch	130	131
kks stats	kks stats alloc/free	10	10
library cache	kgldte: child 0	88	98
library cache	kglhdiv: child	48	0
library cache	kglukp: child	32	29
library cache	kglpndl: child: after processing	24	0
library cache	kglLockCursor	20	13
library cache	kglhdgn: child:	17	70
library cache	kglobpn: child:	8	22
library cache	kglpnp: child	4	12
library cache	kglscn: parent	4	0
library cache	kglpin	3	0
library cache	kglpndl: child: before processing	3	2
library cache	kglhdbrnl: child	2	9
library cache	kgllkal: parent	1	0
library cache lock	kgllkdl: child: no lock handle	9	7
library cache lock	kgllkdl: child: cleanup	3	0
library cache lock	kgllkal: child: in loop	1	1
library cache lock	kgllkal: child: multiinstance	1	3
process allocation	ksucrp	9	0
process allocation	ksudlp	1	1
session allocation	ksufap: active sessions	23	2
session allocation	ksucri	9	30
session allocation	ksuxds: not user session	6	4
session allocation	ksuxds: KSUSFCLC not set	1	2
shared pool	kghfre	101	36
shared pool	kghupr1	36	32
shared pool	kghfrh	35	2
shared pool	kghalo	12	109
slave class create	ksvcreate	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

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	35	0.00	2	1
dc_database_links	643	0.00	0	1
dc_global_oids	2,397	0.00	0	32
dc_histogram_data	1,521	0.00	0	14,492
dc_histogram_defs	1,530	0.39	0	4,537
dc_object_grants	14	0.00	0	57
dc_object_ids	4,482	0.31	9	1,571
dc_objects	3,687	0.46	34	1,311
dc_profiles	170	1.76	3	23
dc_rollback_segments	1,037	0.00	0	90
dc_segments	666	0.45	2	886
dc_sequences	108	2.78	108	15
dc_tablespaces	1,403	0.00	0	15
dc_usernames	2,014	0.20	3	68
dc_users	6,413	0.05	3	140
outstanding_alerts	71	2.82	4	23

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	157	0.00	767	0.00	0	0
CLUSTER	12	0.00	23	0.00	0	0
SQL AREA	2,910	3.06	91,531	1.75	218	35,792
TABLE/PROCEDURE	563	1.95	10,571	0.29	13	0
TRIGGER	300	0.00	300	0.00	0	0

Memory Statistics

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	483.50		0.71	1.10	22	22	685	685
	Freeable	46.19	0.00	0.64	1.63	10		72	72
	SQL	16.95	2.22	0.03	0.32	8	8	672	532
	PL/SQL	12.40	10.04	0.02	0.01	0	0	683	683
E	Other	488.01		0.71	1.10	22	22	685	685
	Freeable	46.06	0.00	0.74	1.73	10		62	62
	SQL	17.00	2.17	0.03	0.32	8	8	672	531
	PL/SQL	12.40	10.04	0.02	0.01	0	0	683	683

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	39,409,680,384
Fixed Size	2,175,824
Redo Buffers	14,598,144
Variable Size	3,523,218,608

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	16.00	16.00	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	CCursor	303.22	213.18	-29.70
shared	KTI-UNDO	48.83	48.83	0.00
shared	PCursor	202.59	178.07	-12.10
shared	db_block_hash_buckets	360.00	360.00	0.00
shared	event statistics per sess	59.71	59.71	0.00
shared	free memory	645.07	1,107.57	71.70
shared	kglsim object batch	56.89	56.89	0.01
shared	library cache	148.08	143.32	-3.21
shared	private strands	91.58	91.58	0.00
shared	sessions	34.70	34.70	0.00
shared	sql area	954.64	613.50	-35.73
streams	Sender info	1.36	1.36	0.00
streams	free memory	31.78	31.78	0.00
	buffer_cache	37,584.00	37,584.00	0.00
	fixed_sga	2.08	2.08	0.00
	log_buffer	13.92	13.92	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage

Streams processes ordered by CPU usage
CPU and I/O Time in micro seconds

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Slaves	110,984	0	0
QMON Coordinator	2,999	0	0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Rule Sets ordered by Evaluations

Ruleset Name	Evals	Fast Evals	SQL Execs	CPU Time	Elapsed Time
SYS.ALERT_QUE_R	4	0	0	0	0

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
archive_lag_target	0
audit_file_dest
audit_sys_operations	TRUE
audit_trail	DB
background_dump_dest	/U01/app/oracle/admin/dbone/bdump
compatible	10.2.0.5.0
control_files
core_dump_dest
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_files	1000
db_name	dbone
db_recovery_file_dest
db_recovery_file_dest_size	2147483648
dg_broker_start	TRUE
dispatchers	(PROTOCOL=TCP) (SERVICE=dboneXDB)
fal_client	sdbone
fal_server	dbone
job_queue_processes	10
license_max_sessions	5700
license_sessions_warning	4000
local_listener	dbone
log_archive_config	dg_config=(sdbone)
log_archive_dest_1
log_archive_dest_2	service="(DESCRIPTION=(ADDRESS_LIST=(AD
log_archive_dest_state_1	ENABLE
log_archive_dest_state_2	ENABLE
log_archive_max_processes	2
log_archive_min_succeed_dest	1
log_archive_trace	0
open_cursors	300
optimizer_index_caching	90
optimizer_index_cost_adj	30
pga_aggregate_target	8589934592
processes	6000
remote_login_passwordfile	EXCLUSIVE
session_cached_cursors	800
sessions	6610
sga_max_size	42949672960
sga_target	42949672960
standby_archive_dest
standby_file_management	MANUAL
undo_management	AUTO
undo_retention	14400
undo_tablespace	UNDOTBS1
user_dump_dest
utl_file_dir

End of Report