WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

DAILY 3206806247 daily 1 14-Sep-16 18:09 11.2.0.4.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
DAILY	3206806247	daily	1	14-Sep-16 18:09	11.2.0.4.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

volteyy3 Linux x86 64-bit 40 20 2 127.91

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
volteyy3	Linux x86 64-bit	40	20	2	127.91

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 444 18-Sep-16 13:00:56 145 1.1

End Snap: 445 18-Sep-16 14:00:00 149 1.1

Elapsed: 59.07 (mins)

DB Time: 647.55 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	444	18-Sep-16 13:00:56	145	1.1
End Snap:	445	18-Sep-16 14:00:00	149	1.1
Elapsed:		59.07 (mins)
DB Time:		647.55 (mins)

Report Summary

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 11.0 0.6 0.01 0.00

DB CPU(s): 8.0 0.4 0.00 0.00

Redo size (bytes): 352,127.5 18,757.9

Logical read (blocks): 191,279.4 10,189.5

Block changes: 3,184.0 169.6

Physical read (blocks): 2.0 0.1

Physical write (blocks): 4,660.4 248.3

Read IO requests: 1.9 0.1

Write IO requests: 213.8 11.4

Read IO (MB): 0.0 0.0

Write IO (MB): 36.4 1.9

User calls: 3,333.5 177.6

Parses (SQL): 2,058.8 109.7

Hard parses (SQL): 0.0 0.0

SQL Work Area (MB): 0.2 0.0

Logons: 25.2 1.3

Executes (SQL): 2,040.4 108.7

Rollbacks: 0.0 0.0

Transactions: 18.8

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	11.0	0.6	0.01	0.00
DB CPU(s):	8.0	0.4	0.00	0.00
Redo size (bytes):	352,127.5	18,757.9
Logical read (blocks):	191,279.4	10,189.5
Block changes:	3,184.0	169.6
Physical read (blocks):	2.0	0.1
Physical write (blocks):	4,660.4	248.3
Read IO requests:	1.9	0.1
Write IO requests:	213.8	11.4
Read IO (MB):	0.0	0.0
Write IO (MB):	36.4	1.9
User calls:	3,333.5	177.6
Parses (SQL):	2,058.8	109.7
Hard parses (SQL):	0.0	0.0
SQL Work Area (MB):	0.2	0.0
Logons:	25.2	1.3
Executes (SQL):	2,040.4	108.7
Rollbacks:	0.0	0.0
Transactions:	18.8

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95 Redo NoWait %: 100.00

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

Library Hit %: 100.04 Soft Parse %: 100.00

Execute to Parse %: -0.90 Latch Hit %: 99.98

Parse CPU to Parse Elapsd %: 23.56 % Non-Parse CPU: 99.89

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
DB CPU		28.4K		73.1
buffer busy waits	101,108	4383.6	43	11.3	Concurrency
enq: HW - contention	19,773	4220.5	213	10.9	Configuration
Disk file operations I/O	75,163	612.2	8	1.6	User I/O
direct path write	219,825	529	2	1.4	User I/O
log file sync	139,516	518.2	4	1.3	Commit
row cache lock	1,588	176.3	111	.5	Concurrency
SQL*Net more data from client	512,021	137.6	0	.4	Network
enq: TX - row lock contention	8,862	99.2	11	.3	Application
enq: TX - allocate ITL entry	12,924	79.3	6	.2	Configuration

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
DB CPU		28,391		73.1	8.0
Concurrency	114,848	4,568	40	11.8	1.3
Configuration	32,723	4,300	131	11.1	1.2
User I/O	301,819	1,149	4	3.0	0.3
System I/O	694,780	832	1	2.1	0.2
Commit	139,517	518	4	1.3	0.1
Network	7,502,719	149	0	.4	0.0
Application	18,319	101	6	.3	0.0
Other	170,768	29	0	.1	0.0
Scheduler	283	0	2	.0	0.0

Host CPU

CPUs Cores Sockets Load Average Begin Load Average End %User %System %WIO %Idle

40 20 2 11.14 11.14 28.5 3.3 2.1 67.6

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
40	20	2	11.14	11.14	28.5	3.3	2.1	67.6

Instance CPU

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

20.2 62.4 0.0

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

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 305.0 2.8 302.3

Database Requests: 215.7 1.9 213.8

Optimized Requests: 0.0 0.0 0.0

Redo Requests: 87.5 0.0 87.5

Total (MB): 36.8 0.0 36.8

Database (MB): 36.4 0.0 36.4

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB): 0.4 0.0 0.4

Database (blocks): 4,662.4 2.0 4,660.4

Via Buffer Cache (blocks): 249.7 1.9 247.8

Direct (blocks): 4,412.7 0.1 4,412.6

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	305.0	2.8	302.3
Database Requests:	215.7	1.9	213.8
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	87.5	0.0	87.5
Total (MB):	36.8	0.0	36.8
Database (MB):	36.4	0.0	36.4
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	0.4	0.0	0.4
Database (blocks):	4,662.4	2.0	4,660.4
Via Buffer Cache (blocks):	249.7	1.9	247.8
Direct (blocks):	4,412.7	0.1	4,412.6

Memory Statistics

Begin End

Host Mem (MB): 130,975.3 130,975.3

SGA use (MB): 51,200.0 51,200.0

PGA use (MB): 227.4 229.3

% Host Mem used for SGA+PGA: 39.26 39.27

	Begin	End
Host Mem (MB):	130,975.3	130,975.3
SGA use (MB):	51,200.0	51,200.0
PGA use (MB):	227.4	229.3
% Host Mem used for SGA+PGA:	39.26	39.27

Cache Sizes

Begin End

Buffer Cache: 41,856M 41,856M Std Block Size: 8K

Shared Pool Size: 5,598M 5,598M Log Buffer: 25,860K

	Begin	End
Buffer Cache:	41,856M	41,856M	Std Block Size:	8K
Shared Pool Size:	5,598M	5,598M	Log Buffer:	25,860K

Shared Pool Statistics

Begin End

Memory Usage %: 66.93 66.94

% SQL with executions>1: 99.75 99.75

% Memory for SQL w/exec>1: 98.59 98.34

	Begin	End
Memory Usage %:	66.93	66.94
% SQL with executions>1:	99.75	99.75
% Memory for SQL w/exec>1:	98.59	98.34

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

Statistic Name	Time (s)	% of DB Time
DB CPU	28,390.97	73.07
sql execute elapsed time	4,154.25	10.69
connection management call elapsed time	227.44	0.59
parse time elapsed	161.81	0.42
PL/SQL execution elapsed time	24.06	0.06
repeated bind elapsed time	0.40	0.00
hard parse elapsed time	0.11	0.00
sequence load elapsed time	0.01	0.00
failed parse elapsed time	0.00	0.00
hard parse (sharing criteria) elapsed time	0.00	0.00
DB time	38,852.76
background elapsed time	906.09
background cpu time	88.75

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	4,563,351
IDLE_TIME	9,528,243
IOWAIT_TIME	295,063
NICE_TIME	1
SYS_TIME	469,238
USER_TIME	4,021,190
LOAD	11
RSRC_MGR_CPU_WAIT_TIME	42
VM_IN_BYTES	1,703,936
VM_OUT_BYTES	0
PHYSICAL_MEMORY_BYTES	137,337,577,472
NUM_CPUS	40
NUM_CPU_CORES	20
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
18-Sep 13:00:56	11.14
18-Sep 14:00:00	11.14	32.38	28.54	3.33	67.62	2.09

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 100.9% of Total DB time 38,852.76 (s)
Total FG Wait Time: 10,793.33 (s) DB CPU time: 28,390.97 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			28,391		73.07
Concurrency	114,784	0	4,562	40	11.74
Configuration	32,722	0	4,300	131	11.07
User I/O	301,585	0	1,148	4	2.96
Commit	139,516	0	518	4	1.33
Network	7,234,883	0	149	0	0.38
Application	18,319	0	101	6	0.26
Other	59,539	3	15	0	0.04
Scheduler	283	0	0	2	0.00
System I/O	23	0	0	1	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
buffer busy waits	101,108	0	4,384	43	1.52	11.28
enq: HW - contention	19,773	0	4,221	213	0.30	10.86
Disk file operations I/O	75,163	0	612	8	1.13	1.58
direct path write	219,825	0	529	2	3.30	1.36
log file sync	139,516	0	518	4	2.10	1.33
row cache lock	1,588	0	176	111	0.02	0.45
SQL*Net more data from client	512,021	0	138	0	7.70	0.35
enq: TX - row lock contention	8,862	0	99	11	0.13	0.26
enq: TX - allocate ITL entry	12,924	0	79	6	0.19	0.20
reliable message	56,785	0	12	0	0.85	0.03
SQL*Net message to client	6,696,797	0	10	0	100.66	0.03
db file sequential read	6,584	0	7	1	0.10	0.02
enq: CR - block range reuse ckpt	287	0	2	9	0.00	0.01
enq: TM - contention	9,447	0	2	0	0.14	0.01
library cache: mutex X	11,063	0	1	0	0.17	0.00
SQL*Net more data to client	26,065	0	1	0	0.39	0.00
resmgr:cpu quantum	283	0	0	2	0.00	0.00
cursor: pin S	262	0	0	1	0.00	0.00
enq: TX - contention	4	0	0	45	0.00	0.00
undo segment extension	25	84	0	6	0.00	0.00
SQL*Net break/reset to client	9	0	0	8	0.00	0.00
latch: enqueue hash chains	295	0	0	0	0.00	0.00
control file sequential read	20	0	0	1	0.00	0.00
latch free	289	0	0	0	0.00	0.00
latch: cache buffers chains	620	0	0	0	0.01	0.00
buffer deadlock	1,807	100	0	0	0.03	0.00
latch: row cache objects	114	0	0	0	0.00	0.00
enq: KO - fast object checkpoint	1	0	0	11	0.00	0.00
db file scattered read	8	0	0	1	0.00	0.00
latch: shared pool	18	0	0	0	0.00	0.00
latch: call allocation	59	0	0	0	0.00	0.00
SQL*Net message from client	6,696,800	0	72,660	11	100.66
jobq slave wait	960	100	481	501	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
db file parallel write	213,056	0	634	3	3.20	70.00
log file parallel write	263,962	0	164	1	3.97	18.15
db file async I/O submit	212,972	0	26	0	3.20	2.87
latch free	2,746	0	13	5	0.04	1.43
os thread startup	27	0	6	221	0.00	0.66
control file parallel write	1,730	0	4	2	0.03	0.39
control file sequential read	3,033	0	3	1	0.05	0.38
db file sequential read	134	0	1	7	0.00	0.10
asynch descriptor resize	89,207	100	1	0	1.34	0.06
LGWR wait for redo copy	18,876	0	0	0	0.28	0.05
Disk file operations I/O	96	0	0	1	0.00	0.02
SQL*Net message to client	267,836	0	0	0	4.03	0.01
ADR block file read	16	0	0	4	0.00	0.01
buffer busy waits	14	0	0	1	0.00	0.00
latch: call allocation	312	0	0	0	0.00	0.00
reliable message	18	0	0	0	0.00	0.00
latch: shared pool	8	0	0	1	0.00	0.00
rdbms ipc message	339,952	6	55,871	164	5.11
Space Manager: slave idle wait	13,967	40	35,458	2539	0.21
DIAG idle wait	7,071	100	7,078	1001	0.11
smon timer	613	0	3,570	5823	0.01
pmon timer	1,180	100	3,544	3003	0.02
shared server idle wait	118	100	3,541	30009	0.00
dispatcher timer	59	100	3,541	60009	0.00
Streams AQ: qmn slave idle wait	126	0	3,529	28009	0.00
Streams AQ: qmn coordinator idle wait	252	50	3,529	14005	0.00
SQL*Net message from client	357,117	0	114	0	5.37
class slave wait	11	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	16	75.0				18.8	6.3
ADR block file write	5	100.0
ADR file lock	6	100.0
Data file init write	2	100.0
Disk file operations I/O	75.3K	35.5	2.2	47.0	6.6	3.3	2.0	3.5	.0
LGWR wait for redo copy	18.9K	100.0		.0	.0
SQL*Net break/reset to client	9	55.6				22.2	22.2
SQL*Net message to client	6957.9K	100.0	.0	.0	.0
SQL*Net more data from client	512.1K	99.7	.3	.0	.0	.0	.0
SQL*Net more data to client	26.1K	100.0	.0		.0			.0
asynch descriptor resize	89.2K	100.0				.0
buffer busy waits	101.1K	73.0	3.4	4.6	2.3	2.8	2.7	10.1	1.1
buffer deadlock	1807	99.9	.1
control file parallel write	1734	96.0	.4	.6	1.8	.3	.1	.7	.1
control file sequential read	3057	97.6	.3	.2	.6	.4	.3	.6
cursor: mutex S	6	100.0
cursor: mutex X	5	100.0
cursor: pin S	264	90.2		.4		9.5
db file async I/O submit	212.7K	99.9	.0	.1	.0	.0	.0	.0
db file parallel write	213K	8.5	2.7	86.3	1.4	.5	.4	.3
db file scattered read	9	88.9		11.1
db file sequential read	6718	87.3	1.0	5.0	2.6	2.4	1.4	.3
db file single write	1	100.0
direct path read	2	100.0
direct path write	219.8K	46.6	25.2	23.4	1.5	1.2	1.0	1.0
enq: CR - block range reuse ckpt	286	2.4	5.6	37.4	24.8	23.8	3.8	2.1
enq: HW - contention	19.8K	53.3	3.3	1.3	.5	.6	1.6	33.6	5.7
enq: KO - fast object checkpoint	1					100.0
enq: TM - contention	9448	99.5	.3	.2		.0
enq: TX - allocate ITL entry	12.9K	97.5	.1	.1	.0	.2	.4	1.7
enq: TX - contention	4					50.0		50.0
enq: TX - row lock contention	8862	93.9	1.2	.2	.0	.5	.9	2.8	.3
latch free	3035	48.4	.0	.0	48.4	3.1	.1
latch: active service list	14	100.0
latch: cache buffers chains	623	99.8		.2
latch: cache buffers lru chain	3	100.0
latch: call allocation	371	99.7	.3
latch: checkpoint queue latch	2	100.0
latch: enqueue hash chains	295	100.0
latch: messages	2	100.0
latch: object queue header operation	13	100.0
latch: redo allocation	19	100.0
latch: redo writing	1	100.0
latch: row cache objects	119	98.3	.8	.8
latch: shared pool	26	88.5	3.8	7.7
library cache: mutex X	11.1K	98.8	.0	.0	.0	1.1	.0
log file parallel write	264K	94.4	.6	1.1	2.7	.6	.4	.2	.0
log file sync	139.5K	70.0	8.7	6.2	8.1	3.7	1.9	1.3	.0
os thread startup	27							100.0
rdbms ipc reply	1	100.0
reliable message	56.8K	99.8	.1	.0	.0	.0		.0
resmgr:cpu quantum	283	68.9	9.5	8.8	6.7	5.7	.4
row cache lock	1588	17.0	2.2	4.8	7.1	16.8	23.4	26.1	2.6
undo segment extension	25	60.0				24.0	16.0
DIAG idle wait	7072							100.0
SQL*Net message from client	7051.8K	91.0	1.9	2.8	.8	1.2	.8	1.3	.2
Space Manager: slave idle wait	13.8K	1.9	1.0	2.2	2.2	3.6	7.3	27.1	54.7
Streams AQ: qmn coordinator idle wait	252	50.0							50.0
Streams AQ: qmn slave idle wait	126								100.0
class slave wait	11	100.0
dispatcher timer	59								100.0
jobq slave wait	960							100.0
pmon timer	1180								100.0
rdbms ipc message	339.9K	29.6	7.1	8.6	12.0	14.1	11.0	13.6	3.9
shared server idle wait	118								100.0
smon timer	613	7.2	1.3	3.9	3.4	5.2	10.3	23.2	45.5

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
Disk file operations I/O	2618	96.5	1.6	.9	.4	.3	.2	.0
SQL*Net more data to client	1	100.0	.0
buffer busy waits	11.1K	88.8	2.7	2.3	1.8	1.8	1.4	.9	.2
control file parallel write	13	99.3	.2	.3	.1		.1	.1
control file sequential read	18	99.4	.2	.2	.2	.0	.0
db file async I/O submit	17	100.0		.0	.0	.0	.0
db file parallel write	589	99.7	.2	.1	.0	.0
db file sequential read	20	99.7	.2	.1
direct path write	2271	99.0	.6	.3	.1	.0
enq: CR - block range reuse ckpt	6	97.9	.7	.7	.3	.3
enq: HW - contention	7750	60.6	3.7	5.0	6.1	7.8	11.0	5.6	.2
enq: TX - allocate ITL entry	214	98.3	.5	.2	.3	.2	.5
enq: TX - contention	2	50.0		50.0
enq: TX - row lock contention	279	96.8	.7	.8	.8	.3	.2	.3	.0
log file parallel write	479	99.8	.1	.0	.0	.0	.0	.0
log file sync	1885	98.6	.6	.3	.3	.1	.0	.0
os thread startup	27				81.5	18.5
reliable message	20	100.0	.0	.0	.0	.0	.0
row cache lock	449	71.3	11.6	3.7	2.6	3.8	4.5	2.1	.4

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
		% of Total Waits
buffer busy waits	183	99.8	.2
enq: HW - contention	31	99.8	.2
enq: TX - row lock contention	3	100.0	.0
row cache lock	7	99.6	.4

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
daily	38,847	28,385	7	676,815
SYS$USERS	4	4	0	2
SYS$BACKGROUND	0	0	0	1,101
dailyXDB	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
daily	301575	1148	114783	4562	7234989	149
SYS$USERS	6	0	0	0	0	0
SYS$BACKGROUND	233	1	56	6	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.8% of Total DB Time (s): 38,853
Captured PL/SQL account for 0.2% of Total DB Time (s): 38,853

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
2,340.73	66,499	0.04	6.02	1.60	0.01	g7mt7ptq286u7		insert into seg$ (file#, block...
795.33	177,939	0.00	2.05	2.02	0.00	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
232.88	66,493	0.00	0.60	86.17	0.00	cqwfdp2kgp1y6	SQL Loader Direct Path Load	SELECT VALUE FROM SYS.LOADER_S...
190.21	66,494	0.00	0.49	4.12	0.01	7zx0nu1u7qccz		delete from seg$ where ts#=:1 ...
137.70	66,486	0.00	0.35	97.22	0.00	cnumpcz520unc		SELECT COUNT(*) FROM ALL_OBJEC...
121.95	1,983,756	0.00	0.31	9.31	0.00	50ggpna5fc13f	SQL Loader Direct Path Load	SELECT :"SYS_B_0" FROM LOADER_...
121.15	1,983,765	0.00	0.31	8.93	0.00	7y31wf82g4wnd	SQL Loader Direct Path Load	SELECT :"SYS_B_0" FROM LOADER_...
56.91	66,496	0.00	0.15	87.10	0.00	8vwac6wpcqm0z		call SYS.KUPU$UTILITIES.UPDATE...
40.99	446,561	0.00	0.11	81.08	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
21.60	89,230	0.00	0.06	34.61	0.00	0k8522rmdzg4k		select privilege# from sysauth...

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 1.9% of Total CPU Time (s): 28,391
Captured PL/SQL account for 0.2% of Total CPU Time (s): 28,391

CPU Time (s)	Executions	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
200.67	66,493	0.71	232.88	86.17	0.00	cqwfdp2kgp1y6	SQL Loader Direct Path Load	SELECT VALUE FROM SYS.LOADER_S...
133.88	66,486	0.47	137.70	97.22	0.00	cnumpcz520unc		SELECT COUNT(*) FROM ALL_OBJEC...
49.57	66,496	0.17	56.91	87.10	0.00	8vwac6wpcqm0z		call SYS.KUPU$UTILITIES.UPDATE...
37.45	66,499	0.13	2,340.73	1.60	0.01	g7mt7ptq286u7		insert into seg$ (file#, block...
33.24	446,561	0.12	40.99	81.08	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
16.10	177,939	0.06	795.33	2.02	0.00	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
15.82	89,216	0.06	16.33	96.88	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
11.35	1,983,756	0.04	121.95	9.31	0.00	50ggpna5fc13f	SQL Loader Direct Path Load	SELECT :"SYS_B_0" FROM LOADER_...
10.82	1,983,765	0.04	121.15	8.93	0.00	7y31wf82g4wnd	SQL Loader Direct Path Load	SELECT :"SYS_B_0" FROM LOADER_...
10.21	89,240	0.04	10.22	99.84	0.00	459f3z9u4fb3u		select value$ from props$ wher...

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 0.4% of Total User I/O Wait Time (s): 1,149
Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 1,149

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
4.40	1	4.40	0.38	5.38	18.15	81.94	8105qhn37k4wn	plsqldev.exe	select s.synonym_name object_n...
0.23	66,499	0.00	0.02	2,340.73	1.60	0.01	g7mt7ptq286u7		insert into seg$ (file#, block...
0.09	1	0.09	0.01	3.26	96.97	2.72	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.04	177,939	0.00	0.00	795.33	2.02	0.00	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
0.03	2	0.01	0.00	0.03	0.00	99.19	grwydz59pu6mc		select text from view$ where r...
0.03	1	0.03	0.00	0.81	63.77	3.23	gsk2zxba11r9m	plsqldev.exe	select object_name, object_typ...
0.02	66,494	0.00	0.00	190.21	4.12	0.01	7zx0nu1u7qccz		delete from seg$ where ts#=:1 ...
0.01	66,493	0.00	0.00	6.43	10.86	0.14	4k4ftgwj6rc9x	SQL Loader Direct Path Load	SELECT DECODE(COUNT(*), :"SYS_...
0.00	66,496	0.00	0.00	10.76	77.14	0.00	8agwdqgvnpqzh		UPDATE SYS.KU_UTLUSE SET USECN...
0.00	66,496	0.00	0.00	56.91	87.10	0.00	8vwac6wpcqm0z		call SYS.KUPU$UTILITIES.UPDATE...

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: 677,915,449
Captured SQL account for 8.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
18,634,518	1,983,765	9.39	2.75	121.15	8.9	0	7y31wf82g4wnd	SQL Loader Direct Path Load	SELECT :"SYS_B_0" FROM LOADER_...
18,634,291	1,983,756	9.39	2.75	121.95	9.3	0	50ggpna5fc13f	SQL Loader Direct Path Load	SELECT :"SYS_B_0" FROM LOADER_...
3,988,050	132,972	29.99	0.59	11.93	63	0	26njhkbrccvs4		select count(*) from ts$ where...
2,854,976	446,561	6.39	0.42	40.99	81.1	0	cm5vu20fhtnq1		select /*+ connect_by_filterin...
1,603,704	66,499	24.12	0.24	2,340.73	1.6	0	g7mt7ptq286u7		insert into seg$ (file#, block...
1,189,458	66,488	17.89	0.18	9.37	12.7	0	gkxs3yrxkcuz2	SQL Loader Direct Path Load	SELECT DECODE(ELEMENT_SUBSTITU...
1,083,228	1	1,083,228.00	0.16	3.26	97	2.7	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
924,842	177,939	5.20	0.14	795.33	2	0	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
803,430	89,230	9.00	0.12	21.60	34.6	0	0k8522rmdzg4k		select privilege# from sysauth...
668,022	66,486	10.05	0.10	137.70	97.2	0	cnumpcz520unc		SELECT COUNT(*) FROM ALL_OBJEC...

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: 6,986
Captured SQL account for 20.3% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,413	1	1,413.00	20.23	5.38	18.15	81.94	8105qhn37k4wn	plsqldev.exe	select s.synonym_name object_n...
61	1	61.00	0.87	3.26	96.97	2.72	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
1	66,493	0.00	0.01	6.43	10.86	0.14	4k4ftgwj6rc9x	SQL Loader Direct Path Load	SELECT DECODE(COUNT(*), :"SYS_...
1	66,499	0.00	0.01	2,340.73	1.60	0.01	g7mt7ptq286u7		insert into seg$ (file#, block...
1	2	0.50	0.01	0.03	0.00	99.19	grwydz59pu6mc		select text from view$ where r...
1	1	1.00	0.01	0.81	63.77	3.23	gsk2zxba11r9m	plsqldev.exe	select object_name, object_typ...
0	66,492	0.00	0.00	3.77	9.33	0.00	05k5qtcfz4uf7	SQL Loader Direct Path Load	SELECT DISTINCT INDEXNAME, SUB...
0	66,496	0.00	0.00	5.15	129.69	0.00	0dnmypnrq1f92		LOCK TABLE SYS.KU_UTLUSE IN EX...
0	89,230	0.00	0.00	21.60	34.61	0.00	0k8522rmdzg4k		select privilege# from sysauth...
0	177,939	0.00	0.00	795.33	2.02	0.00	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...

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: 6,716
Captured SQL account for 21.4% of Total
Total UnOptimized Read Requests: 6,716
Captured SQL account for 21.4% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Opt	%Total	SQL Id	SQL Module	SQL Text
1,413	1,413	1	1,413.00	0.00	21.04	8105qhn37k4wn	plsqldev.exe	select s.synonym_name object_n...
23	23	66,499	0.00	0.00	0.34	g7mt7ptq286u7		insert into seg$ (file#, block...
15	15	1	15.00	0.00	0.22	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
1	1	66,493	0.00	0.00	0.01	4k4ftgwj6rc9x	SQL Loader Direct Path Load	SELECT DECODE(COUNT(*), :"SYS_...
0	0	66,492	0.00		0.00	05k5qtcfz4uf7	SQL Loader Direct Path Load	SELECT DISTINCT INDEXNAME, SUB...
0	0	66,496	0.00		0.00	0dnmypnrq1f92		LOCK TABLE SYS.KU_UTLUSE IN EX...
0	0	89,230	0.00		0.00	0k8522rmdzg4k		select privilege# from sysauth...
0	0	177,939	0.00		0.00	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
0	0	89,216	0.00		0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
0	0	66,488	0.00		0.00	0zwyk1z0w9w35	SQL Loader Direct Path Load	SELECT :"SYS_B_0" FROM SYS.ALL...

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: 7,231,485
Captured SQL account for 96.3% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	SQL Id	SQL Module	SQL Text
1,983,765	0	0.00	121.15	8.9	7y31wf82g4wnd	SQL Loader Direct Path Load	SELECT :"SYS_B_0" FROM LOADER_...
1,983,756	0	0.00	121.95	9.3	50ggpna5fc13f	SQL Loader Direct Path Load	SELECT :"SYS_B_0" FROM LOADER_...
446,561	3,658,230	8.19	40.99	81.1	cm5vu20fhtnq1		select /*+ connect_by_filterin...
282,689	282,653	1.00	7.10	6.3	fhzj09a7fnrnb	SQL Loader Direct Path Load	SELECT DBTIMEZONE, LENGTH(DBTI...
177,939	177,942	1.00	795.33	2	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
132,972	132,950	1.00	11.93	63	26njhkbrccvs4		select count(*) from ts$ where...
89,240	89,212	1.00	10.22	99.8	459f3z9u4fb3u		select value$ from props$ wher...
89,230	446,665	5.01	21.60	34.6	0k8522rmdzg4k		select privilege# from sysauth...
89,216	89,225	1.00	16.33	96.9	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
89,177	89,165	1.00	5.17	96.4	5ur69atw3vfhj		select decode(failover_method,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 7,296,523
Captured SQL account for 93.8% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
1,982,689	1,983,765	27.17	7y31wf82g4wnd	SQL Loader Direct Path Load	SELECT :"SYS_B_0" FROM LOADER_...
1,982,657	1,983,756	27.17	50ggpna5fc13f	SQL Loader Direct Path Load	SELECT :"SYS_B_0" FROM LOADER_...
446,195	446,561	6.12	cm5vu20fhtnq1		select /*+ connect_by_filterin...
282,558	282,689	3.87	fhzj09a7fnrnb	SQL Loader Direct Path Load	SELECT DBTIMEZONE, LENGTH(DBTI...
132,878	132,972	1.82	26njhkbrccvs4		select count(*) from ts$ where...
89,155	89,240	1.22	459f3z9u4fb3u		select value$ from props$ wher...
89,149	89,230	1.22	0k8522rmdzg4k		select privilege# from sysauth...
89,148	89,216	1.22	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
89,134	89,177	1.22	5ur69atw3vfhj		select decode(failover_method,...
66,496	66,493	0.91	4k4ftgwj6rc9x	SQL Loader Direct Path Load	SELECT DECODE(COUNT(*), :"SYS_...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

05k5qtcfz4uf7 SELECT DISTINCT INDEXNAME, SUBNAME, MESSAGE, MESSAGE_NUM FROM V$LOADISTAT WHERE OWNER = :1 AND TABNAME = :2 ORDER BY INDEXNAME, SUBNAME

0dnmypnrq1f92 LOCK TABLE SYS.KU_UTLUSE IN EXCLUSIVE MODE

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

0kkhhb2w93cx0 update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3

0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

0zwyk1z0w9w35 SELECT :"SYS_B_0" FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJECT_TYPE = :"SYS_B_1"

26njhkbrccvs4 select count(*) from ts$ where (contents$=0 and bitand(flags, 16)=0) and bitmapped=0 and online$=1

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

4k4ftgwj6rc9x SELECT DECODE(COUNT(*), :"SYS_B_0", :"SYS_B_1", :"SYS_B_2") FROM SYS.ALL_TAB_COLS WHERE TABLE_NAME = :tname AND OWNER = :owner AND COLUMN_NAME = :"SYS_B_3"

50ggpna5fc13f SELECT :"SYS_B_0" FROM LOADER_COL_FLAGS L WHERE L.TABLE_OWNER = :owner AND L.TABLE_NAME = :tname AND L.COLNAME = :cname AND L.ISVIRTUAL = :"SYS_B_1"

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

6ajkhukk78nsr begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;

7y31wf82g4wnd SELECT :"SYS_B_0" FROM LOADER_COL_FLAGS L WHERE L.TABLE_OWNER = UPPER(:owner) AND L.TABLE_NAME = UPPER(:tname) AND L.COLNAME = UPPER(:cname) AND L.ISVIRTUAL = :"SYS_B_1"

7zx0nu1u7qccz delete from seg$ where ts#=:1 and file#=:2 and block#=:3

8105qhn37k4wn select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in (:"SYS_B_0", user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in (:"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5", :"SYS_B_6", :"SYS_B_7")

8agwdqgvnpqzh UPDATE SYS.KU_UTLUSE SET USECNT = USECNT + 1, ENCRYPTCNT = ENCRYPTCNT + :1, COMPRESSCNT = COMPRESSCNT + :2, LAST_USED = CURRENT_TIMESTAMP WHERE UTLNAME = :3

8vwac6wpcqm0z call SYS.KUPU$UTILITIES.UPDATEFEATURETABLE ('Oracle Utility SQL Loader (Direct Path Load)', 0, 0)

cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

cnumpcz520unc SELECT COUNT(*) FROM ALL_OBJECT_TABLES OT, ALL_XML_TABLES XT WHERE OT.OWNER = XT.OWNER AND OT.TABLE_NAME = XT.TABLE_NAME AND XT.STORAGE_TYPE = 'CLOB' AND OT.OWNER = :OWN AND OT.TABLE_NAME = :TAB

cqwfdp2kgp1y6 SELECT VALUE FROM SYS.LOADER_SKIP_UNUSABLE_INDEXES

fhzj09a7fnrnb SELECT DBTIMEZONE, LENGTH(DBTIMEZONE) FROM SYS.DUAL

g7mt7ptq286u7 insert into seg$ (file#, block#, type#, ts#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, lists, groups, cachehint, hwmincr, spare1, scanhint, bitmapranges) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, DECODE(:17, 0, NULL, :17), :18, :19)

gkxs3yrxkcuz2 SELECT DECODE(ELEMENT_SUBSTITUTABLE, :"SYS_B_0", :"SYS_B_1", :"SYS_B_2") FROM SYS.ALL_NESTED_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner

grwydz59pu6mc select text from view$ where rowid=:1

gsk2zxba11r9m select object_name, object_type from sys.user_objects o where o.object_type in (:"SYS_B_0", :"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5", :"SYS_B_6")

SQL Id	SQL Text
05k5qtcfz4uf7	SELECT DISTINCT INDEXNAME, SUBNAME, MESSAGE, MESSAGE_NUM FROM V$LOADISTAT WHERE OWNER = :1 AND TABNAME = :2 ORDER BY INDEXNAME, SUBNAME
0dnmypnrq1f92	LOCK TABLE SYS.KU_UTLUSE IN EXCLUSIVE MODE
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0kkhhb2w93cx0	update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
0zwyk1z0w9w35	SELECT :"SYS_B_0" FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJECT_TYPE = :"SYS_B_1"
26njhkbrccvs4	select count(*) from ts$ where (contents$=0 and bitand(flags, 16)=0) and bitmapped=0 and online$=1
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4k4ftgwj6rc9x	SELECT DECODE(COUNT(*), :"SYS_B_0", :"SYS_B_1", :"SYS_B_2") FROM SYS.ALL_TAB_COLS WHERE TABLE_NAME = :tname AND OWNER = :owner AND COLUMN_NAME = :"SYS_B_3"
50ggpna5fc13f	SELECT :"SYS_B_0" FROM LOADER_COL_FLAGS L WHERE L.TABLE_OWNER = :owner AND L.TABLE_NAME = :tname AND L.COLNAME = :cname AND L.ISVIRTUAL = :"SYS_B_1"
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
7y31wf82g4wnd	SELECT :"SYS_B_0" FROM LOADER_COL_FLAGS L WHERE L.TABLE_OWNER = UPPER(:owner) AND L.TABLE_NAME = UPPER(:tname) AND L.COLNAME = UPPER(:cname) AND L.ISVIRTUAL = :"SYS_B_1"
7zx0nu1u7qccz	delete from seg$ where ts#=:1 and file#=:2 and block#=:3
8105qhn37k4wn	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in (:"SYS_B_0", user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in (:"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5", :"SYS_B_6", :"SYS_B_7")
8agwdqgvnpqzh	UPDATE SYS.KU_UTLUSE SET USECNT = USECNT + 1, ENCRYPTCNT = ENCRYPTCNT + :1, COMPRESSCNT = COMPRESSCNT + :2, LAST_USED = CURRENT_TIMESTAMP WHERE UTLNAME = :3
8vwac6wpcqm0z	call SYS.KUPU$UTILITIES.UPDATEFEATURETABLE ('Oracle Utility SQL Loader (Direct Path Load)', 0, 0)
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cnumpcz520unc	SELECT COUNT(*) FROM ALL_OBJECT_TABLES OT, ALL_XML_TABLES XT WHERE OT.OWNER = XT.OWNER AND OT.TABLE_NAME = XT.TABLE_NAME AND XT.STORAGE_TYPE = 'CLOB' AND OT.OWNER = :OWN AND OT.TABLE_NAME = :TAB
cqwfdp2kgp1y6	SELECT VALUE FROM SYS.LOADER_SKIP_UNUSABLE_INDEXES
fhzj09a7fnrnb	SELECT DBTIMEZONE, LENGTH(DBTIMEZONE) FROM SYS.DUAL
g7mt7ptq286u7	insert into seg$ (file#, block#, type#, ts#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, lists, groups, cachehint, hwmincr, spare1, scanhint, bitmapranges) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, DECODE(:17, 0, NULL, :17), :18, :19)
gkxs3yrxkcuz2	SELECT DECODE(ELEMENT_SUBSTITUTABLE, :"SYS_B_0", :"SYS_B_1", :"SYS_B_2") FROM SYS.ALL_NESTED_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner
grwydz59pu6mc	select text from view$ where rowid=:1
gsk2zxba11r9m	select object_name, object_type from sys.user_objects o where o.object_type in (:"SYS_B_0", :"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5", :"SYS_B_6")

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Key Instance Activity Stats
Other Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Key Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
db block changes	11,284,548	3,184.03	169.61
execute count	7,231,485	2,040.42	108.69
logons cumulative	89,321	25.20	1.34
opened cursors cumulative	7,142,834	2,015.41	107.36
parse count (total)	7,296,523	2,058.77	109.67
parse time elapsed	12,922	3.65	0.19
physical reads	6,986	1.97	0.11
physical writes	16,517,019	4,660.41	248.26
redo size	1,247,979,056	352,127.53	18,757.86
session cursor cache hits	4,588,990	1,294.82	68.98
session logical reads	677,915,449	191,279.41	10,189.47
user calls	11,814,389	3,333.53	177.58
user commits	66,530	18.77	1.00
user rollbacks	1	0.00	0.00
workarea executions - optimal	358,882	101.26	5.39

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	6	0.00	0.00
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	171,835	48.48	2.58
CPU used when call started	171,034	48.26	2.57
CR blocks created	20,095	5.67	0.30
Cached Commit SCN referenced	1,936	0.55	0.03
Commit SCN cached	410	0.12	0.01
DBWR checkpoint buffers written	876,255	247.24	13.17
DBWR checkpoints	1	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	329	0.09	0.00
DBWR transaction table writes	947	0.27	0.01
DBWR undo block writes	37,092	10.47	0.56
Effective IO time	600	0.17	0.01
HSC Heap Segment Block Changes	378,665	106.84	5.69
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	118	0.03	0.00
Heap Segment Array Updates	227,985	64.33	3.43
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	66,516	18.77	1.00
IMU Redo allocation size	104,996	29.63	1.58
IMU commits	66,519	18.77	1.00
IMU contention	14	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	101,877,648	28,745.61	1,531.28
IMU- failed to get a private strand	0	0.00	0.00
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	2	0.00	0.00
Requests to/from client	6,696,823	1,889.56	100.66
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for undo segment recovery	1	0.00	0.00
SMON posted for undo segment shrink	31	0.01	0.00
SQL*Net roundtrips to/from client	6,696,835	1,889.57	100.66
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	79,114	22.32	1.19
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	21,940	6.19	0.33
branch node splits	0	0.00	0.00
buffer is not pinned count	33,309,785	9,398.63	500.67
buffer is pinned count	1,919,303	541.55	28.85
bytes received via SQL*Net from client	113,147,613,791	31,925,527.67	1,700,675.08
bytes sent via SQL*Net to client	3,078,726,740	868,688.01	46,275.07
calls to get snapshot scn: kcmgss	7,636,393	2,154.67	114.78
calls to kcmgas	1,040,134	293.48	15.63
calls to kcmgcs	1,401,494	395.44	21.07
cell physical IO interconnect bytes	136,857,220,096	38,615,387.64	2,057,044.39
change write time	5,358	1.51	0.08
cleanout - number of ktugct calls	94,619	26.70	1.42
cleanouts and rollbacks - consistent read gets	14,332	4.04	0.22
cleanouts only - consistent read gets	6,045	1.71	0.09
cluster key scan block gets	6,181,756	1,744.23	92.92
cluster key scans	4,412,694	1,245.08	66.33
commit batch/immediate performed	80,868	22.82	1.22
commit batch/immediate requested	80,868	22.82	1.22
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	15	0.00	0.00
commit cleanout failures: cannot pin	25,329	7.15	0.38
commit cleanouts	643,183	181.48	9.67
commit cleanouts successfully completed	617,839	174.33	9.29
commit immediate performed	80,868	22.82	1.22
commit immediate requested	80,868	22.82	1.22
commit txn count during cleanout	26,859	7.58	0.40
consistent changes	28,138	7.94	0.42
consistent gets	56,565,385	15,960.39	850.21
consistent gets - examination	30,288,260	8,546.08	455.25
consistent gets direct	14	0.00	0.00
consistent gets from cache	56,565,376	15,960.38	850.21
consistent gets from cache (fastpath)	25,384,289	7,162.39	381.54
cursor authentications	7	0.00	0.00
data blocks consistent reads - undo records applied	23,690	6.68	0.36
db block gets	621,350,064	175,319.02	9,339.26
db block gets direct	15,638,848	4,412.63	235.06
db block gets from cache	605,711,216	170,906.39	9,104.20
db block gets from cache (fastpath)	580,609,604	163,823.76	8,726.90
deferred (CURRENT) block cleanout applications	338,717	95.57	5.09
dirty buffers inspected	41	0.01	0.00
enqueue conversions	231,545	65.33	3.48
enqueue releases	3,033,251	855.86	45.59
enqueue requests	3,033,301	855.87	45.59
enqueue timeouts	37	0.01	0.00
enqueue waits	51,294	14.47	0.77
exchange deadlocks	1,807	0.51	0.03
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
free buffer inspected	890,203	251.18	13.38
free buffer requested	1,173,913	331.23	17.64
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	1,234,289	348.26	18.55
hot buffers moved to head of LRU	215,285	60.74	3.24
immediate (CR) block cleanout applications	20,377	5.75	0.31
immediate (CURRENT) block cleanout applications	102,880	29.03	1.55
index crx upgrade (positioned)	0	0.00	0.00
index fast full scans (full)	1	0.00	0.00
index fetch by key	9,840,875	2,776.68	147.91
index scans kdiixs1	8,238,173	2,324.47	123.82
leaf node 90-10 splits	27	0.01	0.00
leaf node splits	38	0.01	0.00
lob reads	0	0.00	0.00
lob writes	44	0.01	0.00
lob writes unaligned	44	0.01	0.00
logical read bytes from cache	5,425,355,055,104	1,530,808,446.77	81,546,272.49
max cf enq hold time	50	0.01	0.00
messages received	483,675	136.47	7.27
messages sent	483,675	136.47	7.27
min active SCN optimization applied on CR	731	0.21	0.01
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	24,531,071	6,921.64	368.72
non-idle wait count	9,062,599	2,557.09	136.22
parse count (describe)	0	0.00	0.00
parse count (failures)	4	0.00	0.00
parse count (hard)	19	0.01	0.00
parse time cpu	3,045	0.86	0.05
physical read IO requests	6,716	1.89	0.10
physical read bytes	57,229,312	16,147.72	860.19
physical read total IO requests	9,786	2.76	0.15
physical read total bytes	107,421,696	30,309.91	1,614.61
physical read total multi block requests	3	0.00	0.00
physical reads cache	6,815	1.92	0.10
physical reads cache prefetch	102	0.03	0.00
physical reads direct	171	0.05	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	757,890	213.84	11.39
physical write bytes	135,307,419,648	38,178,098.72	2,033,749.98
physical write total IO requests	1,071,316	302.28	16.10
physical write total bytes	136,749,798,400	38,585,077.72	2,055,429.78
physical write total multi block requests	505,992	142.77	7.61
physical writes direct	15,638,840	4,412.63	235.06
physical writes direct (lob)	3	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	878,179	247.79	13.20
physical writes non checkpoint	16,485,526	4,651.53	247.79
pinned buffers inspected	18	0.01	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	32	0.01	0.00
process last non-idle time	3,545	1.00	0.05
recursive calls	14,828,231	4,183.91	222.88
recursive cpu usage	69,404	19.58	1.04
redo blocks checksummed by FG (exclusive)	19,810	5.59	0.30
redo blocks written	2,686,362	757.98	40.38
redo buffer allocation retries	0	0.00	0.00
redo entries	8,225,744	2,320.96	123.64
redo log space requests	0	0.00	0.00
redo ordering marks	1	0.00	0.00
redo size for direct writes	32,109,960	9,060.09	482.63
redo subscn max counts	2,869	0.81	0.04
redo synch long waits	0	0.00	0.00
redo synch poll writes	213,291	60.18	3.21
redo synch polls	644,673	181.90	9.69
redo synch time	48,368	13.65	0.73
redo synch time (usec)	518,533,340	146,308.44	7,793.86
redo synch time overhead (usec)	168,707,937	47,602.33	2,535.78
redo synch time overhead count (<128 msec)	577	0.16	0.01
redo synch time overhead count (<2 msec)	163,466	46.12	2.46
redo synch time overhead count (<32 msec)	1,476	0.42	0.02
redo synch time overhead count (<8 msec)	11,448	3.23	0.17
redo synch time overhead count (>=128 msec)	46	0.01	0.00
redo synch writes	213,291	60.18	3.21
redo wastage	80,918,036	22,831.69	1,216.25
redo write info find	177,013	49.95	2.66
redo write time	16,562	4.67	0.25
redo writes	263,960	74.48	3.97
rollback changes - undo records applied	821	0.23	0.01
rollbacks only - consistent read gets	5,325	1.50	0.08
rows fetched via callback	4,833,400	1,363.78	72.65
session connect time	0	0.00	0.00
shared hash latch upgrades - no wait	557,172	157.21	8.37
shared hash latch upgrades - wait	6,388	1.80	0.10
sorts (memory)	1,296,685	365.87	19.49
sorts (rows)	5,081,362	1,433.75	76.38
sql area evicted	4	0.00	0.00
sql area purged	4	0.00	0.00
summed dirty queue length	143	0.04	0.00
switch current to new buffer	297,844	84.04	4.48
table fetch by rowid	5,495,902	1,550.71	82.61
table fetch continued row	0	0.00	0.00
table scan blocks gotten	5,155,207	1,454.58	77.49
table scan rows gotten	38,112,743	10,753.82	572.86
table scans (direct read)	1	0.00	0.00
table scans (long tables)	1	0.00	0.00
table scans (short tables)	379,169	106.99	5.70
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	460	0.13	0.01
total number of cf enq holders	142	0.04	0.00
total number of times SMON posted	617	0.17	0.01
transaction rollbacks	591	0.17	0.01
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	286,063,752	80,715.23	4,299.71
user logons cumulative	89,286	25.19	1.34
user logouts cumulative	89,282	25.19	1.34
write clones created in background	3	0.00	0.00
write clones created in foreground	10	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
logons current	145	149
opened cursors current	158	162
session cursor cache count	243,237,422	245,857,777
session pga memory	1,263,896,880	1,279,768,592
session pga memory max	1,552,714,032	1,575,073,808
session uga memory	430,262,966,336	434,894,178,672
session uga memory max	9,505,755,110,216	9,608,178,103,384
workarea memory allocated	0	280

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

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)
Direct Writes	0M	0.00	0M	67.4G	79.99	19.466M	0
Others	48M	0.86	.014M	52G	74.64	15.029M	4800	1.37
DBWR	0M	0.00	0M	6.7G	60.17	1.935M	5	0.00
LGWR	0M	0.00	0M	1.3G	87.46	.37M	264K	0.51
Buffer Cache Reads	53M	1.89	.015M	0M	0.00	0M	6711	0.97
Direct Reads	1M	0.00	0M	0M	0.00	0M	0
TOTAL:	102M	2.76	.029M	127.4G	302.27	36.8M	275.5K	0.54

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	55M	1.90	.016M	126G	213.86	36.412M	0.98	869.00
Log File	0M	0.00	0M	1.3G	87.46	.37M
Control File	48M	0.86	.014M	55M	0.98	.016M	1.05
TOTAL:	103M	2.76	.029M	127.4G	302.30	36.798M	1.00	869.00

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)
Direct Writes	0M	0.00	0M	67.4G	79.99	19.466M	0
Direct Writes (Data File)	0M	0.00	0M	67.4G	79.99	19.466M	0
Others	49M	0.86	.014M	52G	74.64	15.029M	3066	1.07
Others (Data File)	1M	0.00	0M	52G	73.66	15.013M	14	5.86
Others (Control File)	48M	0.86	.014M	54M	0.98	.015M	3052	1.05
DBWR	0M	0.00	0M	6.7G	60.17	1.935M	5	0.00
DBWR (Data File)	0M	0.00	0M	6.7G	60.17	1.935M	0
DBWR (Control File)	0M	0.00	0M	0M	0.00	0M	5	0.00
LGWR	0M	0.00	0M	1.3G	87.46	.37M	0
LGWR (Log File)	0M	0.00	0M	1.3G	87.46	.37M	0
Buffer Cache Reads	53M	1.90	.015M	0M	0.00	0M	6717	0.98
Buffer Cache Reads (Data File)	53M	1.90	.015M	0M	0.00	0M	6717	0.98
Direct Reads	1M	0.00	0M	0M	0.00	0M	0
Direct Reads (Data File)	1M	0.00	0M	0M	0.00	0M	0
TOTAL:	103M	2.76	.029M	127.4G	302.27	36.8M	9788	1.01

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
DAILY2	11	0	10.00	1.00	196,821	0.00	10	56	27,559	12.36
DAILY5	9	0	18.89	1.00	155,681	0.00	19	44	16,815	15.21
DAILY1	5,042	1	0.40	1.00	143,885	1.42	0	41	17,905	18.30
DAILY4	8	0	10.00	1.00	148,553	0.00	10	42	17,262	15.91
DAILY3	100	0	1.70	3.24	108,806	0.03	2	31	20,711	16.53
UNDOTBS1	5	0	6.00	1.00	3,293	0.00	6	1	4,331	0.09
SYSTEM	1,417	0	3.14	1.00	240	0.40	3	0	200,526	14.08
SYSAUX	124	0	6.29	1.37	449	0.03	6	0	0	0.00
DAILY	0	0	0.00	0.00	5	0.00	0	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
DAILY	/data/oradata/daily/daily.dbf	0	0			0		5	0	0	0.00
DAILY1	/data/oradata/daily/DAILY1.dbf	5,042	1	0.40	1.00	1	0.40	143,885	41	17,905	18.30
DAILY2	/data/oradata/daily/DAILY2.dbf	11	0	10.00	1.00	0	10.00	196,821	56	27,559	12.36
DAILY3	/data/oradata/daily/DAILY3.dbf	100	0	1.70	3.24	0	1.80	108,806	31	20,711	16.53
DAILY4	/data/oradata/daily/DAILY4.dbf	8	0	10.00	1.00	0	10.00	148,553	42	17,262	15.91
DAILY5	/data/oradata/daily/DAILY5.dbf	9	0	18.89	1.00	0	18.89	155,681	44	16,815	15.21
SYSAUX	/opt/oracle/oradata/daily/sysaux01.dbf	124	0	6.29	1.37	0	6.34	449	0	0	0.00
SYSTEM	/opt/oracle/oradata/daily/system01.dbf	1,417	0	3.14	1.00	0	3.14	240	0	200,526	14.08
UNDOTBS1	/opt/oracle/oradata/daily/undotbs01.dbf	5	0	6.00	1.00	0	6.00	3,293	1	4,331	0.09

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	5,155,809	100	662,203,798	6,818	878,037	0	0	306,193

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 16,517,019

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	875,566	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	56	74313	231836	1345712	13589532	1345712
E	0	57	78077	244316	1389188	13589532	1389188

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	4,096	0.10	505	1.16	45,188	1	36624.00
D	8,192	0.20	1,009	1.11	43,393	1	34486.00
D	12,288	0.29	1,514	1.09	42,582	1	33520.00
D	16,384	0.39	2,018	1.07	41,847	1	32645.00
D	20,480	0.49	2,523	1.05	41,149	1	31814.00
D	24,576	0.59	3,027	1.04	40,541	1	31089.00
D	28,672	0.69	3,532	1.02	39,952	1	30388.00
D	32,768	0.78	4,036	1.01	39,624	1	29997.00
D	36,864	0.88	4,541	1.01	39,381	1	29709.00
D	40,960	0.98	5,045	1.00	39,158	1	29442.00
D	41,856	1.00	5,156	1.00	39,121	1	29399.00
D	45,056	1.08	5,550	1.00	38,955	1	29201.00
D	49,152	1.17	6,055	0.99	38,830	1	29052.00
D	53,248	1.27	6,559	0.99	38,691	1	28886.00
D	57,344	1.37	7,064	0.99	38,583	1	28758.00
D	61,440	1.47	7,568	0.98	38,473	1	28626.00
D	65,536	1.57	8,073	0.98	38,343	1	28473.00
D	69,632	1.66	8,577	0.98	38,217	1	28322.00
D	73,728	1.76	9,082	0.97	38,080	1	28159.00
D	77,824	1.86	9,586	0.97	37,932	1	27982.00
D	81,920	1.96	10,091	0.97	37,755	1	27772.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	778	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	20,480	18,278	227.38	1.45	0.64	100.00	0.00	1,048,576
E	20,480	18,279	229.25	1.04	0.45	0.00	100.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
2K	4K	358,612	358,612
64K	128K	6	6
128K	256K	2	2
512K	1024K	16	16
1M	2M	23	23
2M	4M	4	4
4M	8M	4	4

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd PGA Cache Hit %	Estd Time
2,560	0.13	90,370.44	100.00	1,040,837
5,120	0.25	90,370.44	100.00	1,040,837
10,240	0.50	90,370.44	100.00	1,040,837
15,360	0.75	90,370.44	100.00	1,040,837
20,480	1.00	90,370.44	100.00	1,040,837
24,576	1.20	90,370.44	100.00	1,040,837
28,672	1.40	90,370.44	100.00	1,040,837
32,768	1.60	90,370.44	100.00	1,040,837
36,864	1.80	90,370.44	100.00	1,040,837
40,960	2.00	90,370.44	100.00	1,040,837
61,440	3.00	90,370.44	100.00	1,040,837
81,920	4.00	90,370.44	100.00	1,040,837
122,880	6.00	90,370.44	100.00	1,040,837
163,840	8.00	90,370.44	100.00	1,040,837

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,864	0.79	85	56,295	5,752,154	0.74	2,077,097	125.32	530,680
4,992	0.81	213	66,840	6,578,368	0.84	1,250,883	75.47	608,941
5,120	0.83	341	82,682	7,332,378	0.94	496,873	29.98	679,506
5,248	0.85	469	98,248	7,812,664	1.00	16,587	1.00	723,607
5,376	0.88	597	113,918	7,812,669	1.00	16,582	1.00	723,608
5,504	0.90	725	129,785	7,812,672	1.00	16,579	1.00	723,609
5,632	0.92	853	146,582	7,812,672	1.00	16,579	1.00	723,609
5,760	0.94	981	164,186	7,812,672	1.00	16,579	1.00	723,609
5,888	0.96	1,109	181,415	7,812,672	1.00	16,579	1.00	723,610
6,016	0.98	1,236	198,629	7,812,672	1.00	16,579	1.00	723,610
6,144	1.00	1,364	215,167	7,812,677	1.00	16,574	1.00	723,695
6,272	1.02	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
6,400	1.04	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
6,528	1.06	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
6,656	1.08	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
6,784	1.10	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
6,912	1.13	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
7,040	1.15	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
7,168	1.17	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
7,296	1.19	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
7,424	1.21	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
8,064	1.31	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
8,704	1.42	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
9,344	1.52	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
9,984	1.63	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
10,624	1.73	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
11,264	1.83	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
11,904	1.94	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695
12,544	2.04	1,489	230,897	7,812,677	1.00	16,574	1.00	723,695

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
12,800	0.25	3,532,606	45,380,302
19,200	0.38	3,529,433	42,763,110
25,600	0.50	3,528,728	42,023,724
32,000	0.63	3,526,967	40,713,173
38,400	0.75	3,525,909	39,793,830
44,800	0.88	3,525,558	39,547,368
51,200	1.00	3,525,202	39,120,950
57,600	1.13	3,524,852	38,854,928
64,000	1.25	3,524,852	38,745,389
70,400	1.38	3,524,501	38,506,751
76,800	1.50	3,524,149	38,244,641
83,200	1.63	3,524,149	38,092,069
89,600	1.75	3,523,797	37,916,025
96,000	1.88	3,523,797	37,916,025
102,400	2.00	3,523,797	37,916,025

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)
128	0.13	0	0	0	0
256	0.25	0	0	0	0
384	0.38	0	0	0	0
512	0.50	0	0	0	0
640	0.63	0	0	0	0
768	0.75	0	0	0	0
896	0.88	0	0	0	0
1,024	1.00	0	0	0	0
1,152	1.13	0	0	0	0
1,280	1.25	0	0	0	0
1,408	1.38	0	0	0	0
1,536	1.50	0	0	0	0
1,664	1.63	0	0	0	0
1,792	1.75	0	0	0	0
1,920	1.88	0	0	0	0
2,048	2.00	0	0	0	0
2,176	2.13	0	0	0	0
2,304	2.25	0	0	0	0
2,432	2.38	0	0	0	0
2,560	2.50	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	200,328	2,821	14
file header block	100,198	1,540	15
undo header	3,084	0	0
undo block	1,247	0	0
segment header	69	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)
HW-Segment High Water Mark	213,873	213,837	0	19,772	4,221	213.47
TX-Transaction (row lock contention)	8,934	8,934	0	8,862	100	11.25
TX-Transaction (allocate ITL entry)	13,004	12,967	37	12,924	79	6.14
TM-DML	444,723	444,696	0	9,447	2	0.26
CR-Reuse Block Range (block range reuse ckpt)	346,229	345,775	0	287	2	8.33
TX-Transaction	670,809	670,374	0	4	0	50.00
KO-Multiple Object Checkpoint (fast object checkpoint)	10	10	0	1	0	10.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	37.63	676,779	1,161	82	180/180	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
18-Sep 13:51	6,528	117,440	553	82	180	0/0	0/0/0/0/0/0
18-Sep 13:41	6,182	111,921	1,156	80	180	0/0	0/0/0/0/0/0
18-Sep 13:31	6,149	110,851	555	82	180	0/0	0/0/0/0/0/0
18-Sep 13:21	6,201	111,295	1,159	82	180	0/0	0/0/0/0/0/0
18-Sep 13:11	6,119	110,594	558	81	180	0/0	0/0/0/0/0/0
18-Sep 13:01	6,455	114,678	1,161	80	180	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	59,848	0.00		0	0
ASM map operation hash table	1	0.00		0	0
ASM network state latch	56	0.00		0	0
AWR Alerted Metric Element list	31,633	0.00		0	0
Change Notification Hash table latch	67,675	0.00	0.00	0	0
Consistent RBA	264,077	0.00	0.00	0	0
DML lock allocation	889,497	0.01	0.00	0	0
Event Group Locks	178,617	0.17	0.00	0	0
FIB s.o chain latch	2	0.00		0	0
FOB s.o list latch	150,512	0.21	0.00	0	0
File State Object Pool Parent Latch	1	0.00		0	0
I/O Staticstics latch	1	0.00		0	0
IPC stats buffer allocation latch	1	0.00		0	0
In memory undo latch	600,575	0.00	0.00	0	200,290	0.59
JS Sh mem access	7	0.00		0	0
JS mem alloc latch	13	0.00		0	0
JS queue access latch	14	0.00		0	0
JS queue state obj latch	25,666	0.00		0	0
JS slv state obj latch	33	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,181	0.00		0	0
KTF sga latch	23	0.00		0	1,182	0.00
KWQMN job cache list latch	1	0.00		0	0
KWQP Prop Status	2	0.00		0	0
KWQS pqueue ctx latch	2	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	71	0.00
Memory Management Latch	1	0.00		0	1,181	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
MinActiveScn Latch	40	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	357,378	0.00		0	0
OS process allocation	185,778	0.50	0.00	0	0
OS process: request allocation	178,618	3.38	0.00	0	0
PL/SQL warning settings	89,345	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	37,590	0.00		0	0
SGA IO buffer pool latch	1	0.00		0	1	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	1	0.00		0	1,179	0.00
SQL memory manager workarea list latch	877,194	0.01	0.00	0	0
Shared B-Tree	132	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	225,875	1.14	0.00	0	0
active service list	544,168	0.29	0.01	0	1,843	0.00
begin backup scn array	544,536	0.04	0.00	0	0
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	268	0.00		0	0
cache buffers chains	1,321,862,819	0.01	0.01	0	946,160	0.03
cache buffers lru chain	1,579,181	0.05	0.00	0	1,981,973	0.40
cache table scan latch	0			0	9	0.00
call allocation	598,760	0.53	0.12	0	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	293,198	2.11	0.00	0	0
channel operations parent latch	922,100	0.48	0.00	0	0
checkpoint queue latch	6,392,620	0.04	0.00	0	881,880	0.02
client/application info	691,569	0.00	0.00	0	0
compile environment latch	89,314	0.01	0.00	0	0
corrupted undo seg latch	3,054	0.98	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	56	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	56	0.00		0	0
dml lock allocation	133,053	0.11	0.01	0	0
done queue latch	1	0.00		0	0
dummy allocation	178,635	0.40	0.00	0	0
eighth spare latch - X parent	1	0.00		0	0
eleventh spare latch - children	1	0.00		0	0
enqueue freelist latch	1	0.00		0	3,523,688	0.01
enqueue hash chains	6,351,623	0.26	0.02	0	1,596	0.00
enqueues	19	0.00		0	0
fifteenth spare latch - children	1	0.00		0	0
file cache latch	204,330	0.03	0.00	0	0
first Audit Vault latch	89,279	0.90	0.00	0	0
flashback copy	1	0.00		0	0
fourteenth spare latch - children	1	0.00		0	0
fourth Audit Vault latch	1	0.00		0	0
gc element	1	0.00		0	0
gcs commit scn state	1	0.00		0	0
gcs partitioned table hash	1	0.00		0	0
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs resource freelist	1	0.00		0	0
gcs resource hash	1	0.00		0	0
gcs resource scan list	1	0.00		0	0
gcs resource validate 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	89,272	0.23	0.00	0	0
global tx hash mapping	5	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	10	0.00		0	299	0.00
hash table modification latch	139	0.00		0	0
heartbeat check	1	0.00		0	0
interrupt manipulation	1	0.00		0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	9	0.00		0	8	0.00
job_queue_processes free list latch	20	0.00		0	0
job_queue_processes parameter latch	777	0.00		0	0
k2q lock allocation	1	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kgnfs mount latch	1	0.00		0	0
kokc descriptor allocation latch	4	0.00		0	0
ksfv messages	1	0.00		0	0
ksim group membership cache	1	0.00		0	0
kss move lock	23	0.00		0	0
ksuosstats global area	358	0.00		0	0
ksv allocation latch	100	0.00		0	0
ksv class latch	45	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	178,618	2.92	0.00	0	0
ktm global data	2,480	0.00		0	0
kwqbsn:qsga	128	0.00		0	0
lgwr LWN SCN	265,461	0.09	0.00	0	0
list of block allocation	133,053	0.05	0.00	0	0
loader state object freelist	133,007	0.02	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 local	1	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	1	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	172,678	0.17	0.00	0	0
messages	1,497,588	0.48	0.00	0	0
mostly latch-free SCN	275,160	1.91	0.00	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	20	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	56	0.00		0	0
nineth spare latch - X parent	1	0.00		0	0
object queue header heap	1,192,729	0.00		0	2,402	0.00
object queue header operation	5,845,873	0.09	0.00	0	0
object stats modification	132	0.00		0	0
parallel query alloc buffer	1,131	0.00		0	0
parallel query stats	1	0.00		0	0
parameter list	806,936	0.13	0.00	0	0
parameter table management	1,221,745	0.61	0.00	0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
post/wait queue	8,079	2.85	0.00	0	14,084	1.88
process allocation	178,645	4.54	0.19	13	82,930	7.69
process group creation	178,618	0.03	0.00	0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qmn task queue latch	513	0.00		0	0
query server freelists	1	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	1,254,592	0.74	0.00	0	8,212,520	0.61
redo copy	1	0.00		0	8,226,353	0.30
redo writing	1,064,737	0.16	0.00	0	0
resmgr group change latch	89,337	0.00	0.00	0	0
resmgr:active threads	179,402	0.01	0.96	0	1,241	0.00
resmgr:actses change group	89,332	0.00		0	0
resmgr:actses change state	51,308	0.00		0	0
resmgr:free threads list	178,656	0.79	0.00	0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1,469,082	0.21	0.00	0	0
resmgr:schema config	794	0.00		0	59	0.00
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	24,250,039	0.56	0.00	0	254	0.39
rules engine rule set statistics	100	0.00		0	0
second Audit Vault latch	1	0.00		0	0
sequence cache	268,068	0.26	0.00	0	0
session allocation	859,314	0.01	0.00	0	680,695	0.00
session idle bit	24,219,775	0.00	0.00	0	0
session queue latch	1	0.00		0	0
session state list latch	311,657	0.71	0.11	0	0
session switching	89,369	0.59	0.00	0	0
session timer	1,180	0.00		0	0
seventh spare latch - X parent	1	0.00		0	0
shared pool	8,161,712	0.19	0.00	0	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	44	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	57,569,881	0.03	0.00	0	0
simulator lru latch	877,045	0.30	0.00	0	56,586,806	0.02
sixth spare latch - X parent	1	0.00		0	0
sort extent pool	709	0.00		0	0
space background task latch	32,084	10.85	0.33	0	56,372	0.36
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	2	0.00		0	0
tenth spare latch - X parent	1	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
thirteenth spare latch - children	1	0.00		0	0
threshold alerts latch	208	0.00		0	0
trace latch	1	0.00		0	0
transaction allocation	516,286	0.01	0.00	0	0
transaction branch allocation	1,182	0.00		0	0
twelfth spare latch - children	1	0.00		0	0
twenty-fifth spare latch - S par	1	0.00		0	0
twenty-first spare latch - S par	1	0.00		0	0
twenty-fourth spare latch - S par	1	0.00		0	0
twenty-second spare latch - S par	1	0.00		0	0
twenty-third spare latch - S par	1	0.00		0	0
undo global data	3,128,256	0.01	0.00	0	1	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
write info latch	0			0	263,961	0.00

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
row cache objects	24,250,039	136,820	119	136,703
cache buffers chains	1,321,862,819	83,698	626	83,091
simulator hash latch	57,569,881	18,693	8	18,685
enqueue hash chains	6,351,623	16,678	295	16,393
shared pool	8,161,712	15,171	26	15,145
redo allocation	1,254,592	9,223	19	9,204
process allocation	178,645	8,108	1,568	6,685
parameter table management	1,221,745	7,497	10	7,487
messages	1,497,588	7,210	2	7,208
channel handle pool latch	293,198	6,192	1	6,191
OS process: request allocation	178,618	6,037	20	6,017
object queue header operation	5,845,873	5,463	14	5,450
mostly latch-free SCN	275,160	5,250	2	5,248
ksz_so allocation latch	178,618	5,221	1	5,220
channel operations parent latch	922,100	4,440	4	4,437
space background task latch	32,084	3,482	1,161	2,330
call allocation	598,760	3,151	374	2,784
resmgr:resource group CPU method	1,469,082	3,049	5	3,044
checkpoint queue latch	6,392,620	2,866	2	2,864
simulator lru latch	877,045	2,637	4	2,633
active checkpoint queue latch	225,875	2,584	1	2,583
session state list latch	311,657	2,204	234	1,971
redo writing	1,064,737	1,724	1	1,723
active service list	544,168	1,597	14	1,583
resmgr:free threads list	178,656	1,417	2	1,415
cache buffers lru chain	1,579,181	840	3	837
session idle bit	24,219,775	813	2	811
post/wait queue	8,079	230	1	229
dml lock allocation	133,053	143	1	142
resmgr:active threads	179,402	26	25	1

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
OS process: request allocation	kso_new_process	20	20
PC and Classifier lists for WLM	No latch	17	0
active checkpoint queue latch	kcbbacq: scan active checkpoints	1	1
active service list	kswslogon: session logout	40	27
active service list	kswslogon: session login	2	0
active service list	kswsite: service iterator	1	0
cache buffers chains	kcbgtcr: fast path (cr pin)	353	192
cache buffers chains	kcbgcur_2	307	147
cache buffers chains	kcbchg1: mod cr pin	196	198
cache buffers chains	kcbzwb	141	95
cache buffers chains	kcbgtcr: fast path	113	78
cache buffers chains	kcbget: fast exchange	90	26
cache buffers chains	kcbgtcr_2	38	16
cache buffers chains	kcbgtcr: kslbegin excl	18	23
cache buffers chains	kcbrls_2	12	74
cache buffers chains	kcbnlc	9	55
cache buffers chains	kcbchg1: clear MS bit	8	181
cache buffers chains	kcbbxsv	3	3
cache buffers chains	kcbchg1: aux pin	1	0
cache buffers chains	kcbchg1: mod cur pin	1	151
cache buffers chains	kcbgcur: fast path (shr)	1	2
cache buffers chains	kcbgcur_4	1	5
cache buffers chains	kcbnew: new latch again	1	0
cache buffers chains	kcbrls: fast release	1	22
cache buffers lru chain	kcbzgws	3	0
call allocation	ksuxds	364	292
call allocation	ksudlp: top call	6	14
call allocation	ksudlc : rec call	2	19
call allocation	ksuinfos_modact	1	20
call allocation	ksuprc	1	20
channel handle pool latch	ksrchconnect()	1	1
channel operations parent latch	ksrmfree()	2	0
channel operations parent latch	ksrchconnect()	1	0
channel operations parent latch	ksrwait()	1	0
checkpoint queue latch	kcbbwdl: thread checkpoint queue	1	0
checkpoint queue latch	kcbkubc_4	1	1
dml lock allocation	ktaiat	1	1
enqueue hash chains	ksqrcl	222	109
enqueue hash chains	ksqcmi: get hash chain latch after wait	67	183
enqueue hash chains	ksqgtl3	6	3
ksz_so allocation latch	ksznfy1	1	1
lgwr LWN SCN	kcs023	2	0
messages	ksaamb: after wakeup	1	1
messages	ksarcv	1	1
object queue header operation	kcbo_switch_mq_bg	10	7
object queue header operation	kcbo_switch_cq	2	3
object queue header operation	kcbo_switch_q_bg	2	4
object queue header operation	kcbo_unlink_q	2	1
parameter table management	ksp_param_table_free	51	0
parameter table management	kspcpy	50	2
parameter table management	kspptval	2	101
post/wait queue	ksliwat:add:nowait	1	0
process allocation	ksucrp:1	1,312	0
process allocation	ksudlp	132	2
process allocation	ksuapc	117	1,555
redo allocation	kcrfw_redo_gen: redo allocation 1	18	0
redo allocation	kcrfw_post: more space	1	9
redo writing	kcrfw_post: rba scn pair	1	0
resmgr:active threads	kskdynthreshact	16	0
resmgr:active threads	kgsksimsetup1	8	0
resmgr:active threads	kgskmetricupd	1	0
resmgr:free threads list	kskthrcreate	2	2
resmgr:resource group CPU method	kgkprrpicknext	5	4
row cache objects	kqreqd: reget	66	1
row cache objects	kqrpre: find obj	37	84
row cache objects	kqreqd	10	20
row cache objects	kqrcmt: while loop	2	4
row cache objects	kqrso	2	3
row cache objects	kqrget	1	3
session idle bit	ksupuc: clear busy	4	2
session state list latch	kpseqd	216	9
session state list latch	kpscad	18	94
shared pool	kghalo	21	19
shared pool	kghfre	5	5
shared pool	kghfrunp: clatch: nowait	1	0
simulator hash latch	kcbs_lookup_setid: lookup dba	7	8
simulator hash latch	kcbsacc: lookup dba	1	0
simulator lru latch	kcbs_simulate: simulate set	4	0
space background task latch	ktsj_grab_task	1,141	1,161
space background task latch	ktsj_detach_task	2	0
space background task latch	ktsjCreateTask	1	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kglhdgn2 106	2,967
Library Cache	kgllkc1 57	2,629
Library Cache	kglhdgn1 62	1,228
Library Cache	kglpin1 4	1,226
Library Cache	kgllkdl1 85	1,142
Library Cache	kglpndl1 95	671
Library Cache	kglpnal1 90	624
Library Cache	kglget1 1	532
Library Cache	kglget2 2	281
Library Cache	kglhdgh1 64	231
Cursor Pin	kksfbc [KKSCHLPIN1]	161
Cursor Pin	kksLockDelete [KKSCHLPIN6]	117
Cursor Pin	kksfbc [KKSCHLFSP2]	35
Cursor Pin	kkslce [KKSCHLPIN2]	26
Library Cache	kglobpn1 71	8
Cursor Parent	kkscsAddChildNode [KKSPRTLOC34]	5
hash table	kkshGetNextChild [KKSHBKLOC1]	3
hash table	kkscsSearchChildList [KKSHBKLOC2]	2
Cursor Parent	kkscsPruneChild [KKSPRTLOC35]	1

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: 677,915,449
Captured Segments account for 99.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
DAILY	DAILY1	GXFLOW_2016091811	TABLE	578,697,648	85.36
DAILY	DAILY2	ISCSIPCTRL_2016091811	TABLE	19,667,392	2.90
SYS	SYSTEM	I_OBJ2	INDEX	17,245,840	2.54
SYS	SYSTEM	I_OBJ#	INDEX	8,174,624	1.21
SYS	SYSTEM	I_USER1	INDEX	6,100,240	0.90

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 6,986
Captured Segments account for 70.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
DAILY	DAILY1	GXFLOW_2016091811		TABLE	3,478	49.79
SYS	SYSTEM	I_OBJ5		INDEX	1,407	20.14
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_3206806247_0	TABLE PARTITION	48	0.69
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_3206806247_0	INDEX PARTITION	6	0.09
SYS	SYSAUX	WRI$_ADV_PARAMETERS_PK		INDEX	3	0.04

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 6,716
Captured Segments account for 73.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Read Requests	%Total
DAILY	DAILY1	GXFLOW_2016091811		TABLE	3,478	51.79
SYS	SYSTEM	I_OBJ5		INDEX	1,407	20.95
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_3206806247_0	INDEX PARTITION	6	0.09
SYS	SYSAUX	WRI$_ADV_PARAMETERS_PK		INDEX	3	0.04
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_3206806247_0	TABLE PARTITION	2	0.03

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 6,716
Captured Segments account for 73.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	UnOptimized Reads	%Total
DAILY	DAILY1	GXFLOW_2016091811		TABLE	3,478	51.79
SYS	SYSTEM	I_OBJ5		INDEX	1,407	20.95
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_3206806247_0	INDEX PARTITION	6	0.09
SYS	SYSAUX	WRI$_ADV_PARAMETERS_PK		INDEX	3	0.04
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_3206806247_0	TABLE PARTITION	2	0.03

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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 16,517,019
Captured Segments account for 93.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
DAILY	DAILY1	GXFLOW_2016091811	TABLE	3,769,188	22.82
DAILY	DAILY2	ISCSIPCTRL_2016091811	TABLE	3,709,187	22.46
DAILY	DAILY5	GXCMCCXDR_2016091811	TABLE	1,264,410	7.66
DAILY	DAILY5	MGSIPCTRL_2016091811	TABLE	916,927	5.55
DAILY	DAILY3	MWSIPCTRL_2016091811	TABLE	782,456	4.74

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 757,890
Captured Segments account for 91.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
DAILY	DAILY2	ISCSIPCTRL_2016091811	TABLE	196,807	25.97
DAILY	DAILY1	GXFLOW_2016091811	TABLE	131,860	17.40
DAILY	DAILY5	GXCMCCXDR_2016091811	TABLE	52,407	6.91
DAILY	DAILY5	MGSIPCTRL_2016091811	TABLE	46,444	6.13
DAILY	DAILY3	MWSIPCTRL_2016091811	TABLE	39,919	5.27

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 15,638,840
Captured Segments account for 94.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Direct Writes	%Total
DAILY	DAILY1	GXFLOW_2016091811	TABLE	3,677,593	23.52
DAILY	DAILY2	ISCSIPCTRL_2016091811	TABLE	3,446,790	22.04
DAILY	DAILY5	GXCMCCXDR_2016091811	TABLE	1,231,565	7.88
DAILY	DAILY5	MGSIPCTRL_2016091811	TABLE	849,443	5.43
DAILY	DAILY3	MWSIPCTRL_2016091811	TABLE	722,206	4.62

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 2
Captured Segments account for 50.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	I_OBJ2		INDEX	1	50.00

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

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

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
DAILY	DAILY2	ISCSIPCTRL_2016091811	TABLE	1,882,688	27.88
SYS	SYSTEM	I_FILE#_BLOCK#	INDEX	832,304	12.32
SYS	SYSTEM	SEG$	TABLE	828,576	12.27
DAILY	DAILY1	GXFLOW_2016091811	TABLE	503,152	7.45
DAILY	DAILY5	MGSIPCTRL_2016091811	TABLE	474,784	7.03

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
SYS	SYSTEM	I_FILE#_BLOCK#		INDEX	8,904	99.78
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_3206806247_0	INDEX PARTITION	12	0.13
SYS	SYSAUX	WRH$_SEG_STAT_OBJ_PK		INDEX	2	0.02
SYS	SYSAUX	WRH$_SEG_STAT_PK	WRH$_SEG_ST_3206806247_0	INDEX PARTITION	2	0.02
SYS	SYSAUX	WRH$_SQLSTAT_PK	WRH$_SQLSTA_3206806247_0	INDEX PARTITION	2	0.02

Back to Segment Statistics
Back to Top

Segments by ITL Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	ITL Waits	% of Capture
SYS	SYSTEM	SEG$		TABLE	12,894	100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	SEG$		TABLE	179,258	88.99
SYS	SYSTEM	I_FILE#_BLOCK#		INDEX	22,184	11.01

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	67	0.00	2	1
dc_global_oids	7	0.00	0	63
dc_histogram_data	38	0.00	0	599
dc_histogram_defs	400	31.00	0	33,349
dc_objects	157,559	0.00	5	421,777
dc_profiles	178,570	0.00	0	1
dc_rollback_segments	4,075	0.00	0	83
dc_segments	1,068,164	6.28	310,950	77,742
dc_sequences	15	0.00	15	12
dc_tablespaces	2,117,923	0.00	0	14
dc_users	5,246,499	0.00	0	49,884
global database name	91,662	0.00	0	1
outstanding_alerts	60	0.00	0	11
sch_lj_oids	4	0.00	0	28

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	267,849	0.00	0		0	0
BODY	199,562	0.00	200,358	0.00	0	0
CLUSTER	2	0.00	2	0.00	0	0
DBLINK	267,851	0.00	0		0	0
EDITION	89,302	0.00	178,593	0.00	0	0
SCHEMA	89,296	0.00	0		0	0
SQL AREA	2,753,068	0.00	8,783,134	-0.04	7	10
SQL AREA BUILD	19	57.89	0		0	0
SQL AREA STATS	19	63.16	19	63.16	0	0
TABLE/PROCEDURE	488,348	0.00	1,110,664	-0.00	0	0

Memory Statistics

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

Memory Dynamic Components

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

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	41,856.00	41,856.00	41,856.00	41,856.00	INI/
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	20,480.00	20,480.00	20,480.00	20,480.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	51,200.00	51,200.00	51,200.00	51,200.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	896.00	896.00	896.00	896.00	STA/
large pool	1,024.00	1,024.00	1,024.00	1,024.00	STA/
shared pool	6,144.00	6,144.00	6,144.00	6,144.00	STA/
streams pool	1,024.00	1,024.00	1,024.00	1,024.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	196.58		1.32	1.52	12	12	149	149
B	Freeable	25.56	0.00	1.83	1.84	5		14	14
B	PL/SQL	0.72	0.42	0.00	0.02	0	0	147	147
B	SQL	0.51	0.17	0.00	0.00	0	3	131	126
E	Other	200.23		1.31	1.50	12	12	153	153
E	Freeable	26.44	0.00	1.76	1.78	5		15	15
E	SQL	1.43	1.08	0.01	0.08	1	4	134	130
E	PL/SQL	0.79	0.47	0.01	0.02	0	0	151	151

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	43,889,197,056
Fixed Size	2,265,864
Redo Buffers	26,480,640
Variable Size	9,529,462,008

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	896.00	896.00	0.00
large	free memory	1,016.19	1,016.19	0.00
shared	ASH buffers	80.00	80.00	0.00
shared	KGLDA	68.79	68.79	0.00
shared	KGLH0	1,296.40	1,296.42	0.00
shared	KGLHD	271.81	271.82	0.01
shared	KGLS	542.55	542.53	-0.00
shared	KQR L PO	460.76	460.67	-0.02
shared	SQLA	670.53	670.88	0.05
shared	db_block_hash_buckets	356.00	356.00	0.00
shared	free memory	1,851.12	1,850.48	-0.03
streams	free memory	1,024.00	1,024.00	0.00
	buffer_cache	41,856.00	41,856.00	0.00
	fixed_sga	2.16	2.16	0.00
	log_buffer	25.25	25.25	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 CPU Time, descending

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Coordinator	0914 18:01:39	0.04	0.00	0.00
QMON Slaves	0914 18:01:49	0.03	0.00	0.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

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,544	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,544	0.00	100.00	0	0

Back to Shared Server Statistics
Back to Top

init.ora Parameters

init.ora Parameters
init.ora Multi-Valued Parameters

init.ora Parameters

Parameter Name	Begin value	End value (if different)
_buffer_busy_wait_timeout	2
audit_file_dest	/opt/oracle/admin/daily/adump
audit_trail	NONE
compatible	11.2.0.4.0
control_files	/opt/oracle/oradata/daily/control01.ctl, /opt/oracle/fast_recovery_area/daily/control02.ctl
core_dump_dest	/opt/oracle/diag/rdbms/daily/daily/cdump
cursor_sharing	FORCE
db_block_size	8192
db_cache_size	42949672960
db_domain
db_file_multiblock_read_count	256
db_name	daily
diagnostic_dest	/opt/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=dailyXDB)
filesystemio_options	SETALL
large_pool_size	1073741824
lock_sga	TRUE
open_cursors	1500
optimizer_dynamic_sampling	2
optimizer_mode	ALL_ROWS
pga_aggregate_target	21474836480
plsql_warnings	DISABLE:ALL
pre_page_sga	TRUE
processes	1500
recyclebin	OFF
remote_login_passwordfile	EXCLUSIVE
session_cached_cursors	200
sessions	2280
sga_max_size	53687091200
sga_target	53687091200
shared_pool_size	6442450944
streams_pool_size	1073741824
undo_retention	10800
undo_tablespace	UNDOTBS1

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

This section only displays parameters that have more one value
'(NULL)' indicates a missing parameter value
A blank in the End Snapshot indicates the same value as the BeginSnapshot

Parameter Name	Begin value	End value (if different)
control_files	/opt/oracle/fast_recovery_area/daily/control02.ctl
control_files	/opt/oracle/oradata/daily/control01.ctl

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	99.95	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	100.04	Soft Parse %:	100.00
Execute to Parse %:	-0.90	Latch Hit %:	99.98
Parse CPU to Parse Elapsd %:	23.56	% Non-Parse CPU:	99.89