WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

VIS 424395205 VIS 1 14-Sep-15 13:09 11.2.0.3.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
VIS	424395205	VIS	1	14-Sep-15 13:09	11.2.0.3.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

dbzone0.priv.com Solaris[tm] OE (64-bit) 432 54 2 1914.29

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
dbzone0.priv.com	Solaris[tm] OE (64-bit)	432	54	2	1914.29

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 256 15-Sep-15 18:00:41 9587 73.3

End Snap: 260 15-Sep-15 19:00:53 10393 73.7

Elapsed: 60.20 (mins)

DB Time: 1,289.93 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	256	15-Sep-15 18:00:41	9587	73.3
End Snap:	260	15-Sep-15 19:00:53	10393	73.7
Elapsed:		60.20 (mins)
DB Time:		1,289.93 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 60,416M 59,136M Std Block Size: 8K

Shared Pool Size: 18,432M 19,712M Log Buffer: 172,632K

	Begin	End
Buffer Cache:	60,416M	59,136M	Std Block Size:	8K
Shared Pool Size:	18,432M	19,712M	Log Buffer:	172,632K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 21.4 0.0 0.00 0.00

DB CPU(s): 19.7 0.0 0.00 0.00

Redo size: 7,935,012.8 10,218.4

Logical reads: 1,219,830.6 1,570.9

Block changes: 46,004.2 59.2

Physical reads: 77.3 0.1

Physical writes: 733.0 0.9

User calls: 21,032.5 27.1

Parses: 662.3 0.9

Hard parses: 11.5 0.0

W/A MB processed: 99.4 0.1

Logons: 3.1 0.0

Executes: 35,687.6 46.0

Rollbacks: 131.4 0.2

Transactions: 776.5

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	21.4	0.0	0.00	0.00
DB CPU(s):	19.7	0.0	0.00	0.00
Redo size:	7,935,012.8	10,218.4
Logical reads:	1,219,830.6	1,570.9
Block changes:	46,004.2	59.2
Physical reads:	77.3	0.1
Physical writes:	733.0	0.9
User calls:	21,032.5	27.1
Parses:	662.3	0.9
Hard parses:	11.5	0.0
W/A MB processed:	99.4	0.1
Logons:	3.1	0.0
Executes:	35,687.6	46.0
Rollbacks:	131.4	0.2
Transactions:	776.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 100.02 Soft Parse %: 98.26

Execute to Parse %: 98.14 Latch Hit %: 98.57

Parse CPU to Parse Elapsd %: 94.16 % Non-Parse CPU: 98.83

Shared Pool Statistics

Begin End

Memory Usage %: 36.18 44.10

% SQL with executions>1: 65.41 84.68

% Memory for SQL w/exec>1: 37.90 61.37

	Begin	End
Memory Usage %:	36.18	44.10
% SQL with executions>1:	65.41	84.68
% Memory for SQL w/exec>1:	37.90	61.37

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		71,193		91.99
library cache: mutex X	872,615	7,803	9	10.08	Concurrency
log file sync	1,436,144	966	1	1.25	Commit
db file sequential read	277,781	778	3	1.01	User I/O
SQL*Net message to client	65,482,738	99	0	0.13	Network

Host CPU (CPUs: 432 Cores: 54 Sockets: 2)

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

259.87 280.29 26.5 5.8 0.0 67.7

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
259.87	280.29	26.5	5.8	0.0	67.7

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

4.7 14.6 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 1,960,232.0 1,960,232.0

SGA use (MB): 81,920.0 81,920.0

PGA use (MB): 96,881.2 108,102.7

% Host Mem used for SGA+PGA: 9.12 9.69

	Begin	End
Host Mem (MB):	1,960,232.0	1,960,232.0
SGA use (MB):	81,920.0	81,920.0
PGA use (MB):	96,881.2	108,102.7
% Host Mem used for SGA+PGA:	9.12	9.69

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): 77395.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	71,193.46	91.99
sql execute elapsed time	48,646.77	62.85
inbound PL/SQL rpc elapsed time	33,339.30	43.08
PL/SQL execution elapsed time	26,409.49	34.12
parse time elapsed	1,059.67	1.37
Java execution elapsed time	389.24	0.50
hard parse elapsed time	179.72	0.23
connection management call elapsed time	163.90	0.21
repeated bind elapsed time	32.26	0.04
sequence load elapsed time	16.22	0.02
hard parse (sharing criteria) elapsed time	5.31	0.01
hard parse (bind mismatch) elapsed time	4.65	0.01
failed parse elapsed time	2.79	0.00
PL/SQL compilation elapsed time	0.47	0.00
DB time	77,395.80
background elapsed time	4,978.41
background cpu time	2,503.72

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
AVG_BUSY_TIME	116,495
AVG_IDLE_TIME	244,384
AVG_SYS_TIME	20,901
AVG_USER_TIME	95,415
BUSY_TIME	50,404,744
IDLE_TIME	105,654,061
SYS_TIME	9,107,123
USER_TIME	41,297,621
LOAD	260	280
OS_CPU_WAIT_TIME	3,681,800
VM_IN_BYTES	47,685,632
PHYSICAL_MEMORY_BYTES	2,055,452,229,632
NUM_CPUS	432
NUM_CPU_CORES	54
NUM_CPU_SOCKETS	2
TCP_RECEIVE_SIZE_DEFAULT	128,000
TCP_SEND_SIZE_DEFAULT	49,152

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
15-Sep 18:00:41	259.87
15-Sep 18:15:44	290.44	32.87	25.89	6.98	67.13	0.00
15-Sep 18:30:46	293.21	32.45	26.77	5.68	67.55	0.00
15-Sep 18:45:49	270.51	31.95	26.44	5.51	68.05	0.00
15-Sep 19:00:53	280.29	31.93	26.75	5.18	68.07	0.00

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 104.7% of Total DB time 77,395.80 (s)
Total FG Wait Time: 9,804.88 (s) DB CPU time: 71,193.46 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			71,193		91.99
Concurrency	1,807,541	0	7,844	4	10.13
Commit	1,436,144	0	966	1	1.25
User I/O	316,178	0	815	3	1.05
Network	66,007,788	0	121	0	0.16
Application	229,245	0	56	0	0.07
Other	4,674	24	3	1	0.00
Configuration	876	0	1	1	0.00
System I/O	0		0		0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
library cache: mutex X	872,615	0	7,803	9	0.31	10.08
log file sync	1,436,144	0	966	1	0.51	1.25
db file sequential read	277,781	0	778	3	0.10	1.01
SQL*Net message to client	65,482,738	0	99	0	23.35	0.13
SQL*Net break/reset to client	229,120	0	51	0	0.08	0.07
latch: cache buffers chains	803,928	0	25	0	0.29	0.03
SQL*Net more data to client	371,665	0	18	0	0.13	0.02
local write wait	3,753	0	15	4	0.00	0.02
Disk file operations I/O	29,867	0	12	0	0.01	0.02
buffer busy waits	100,493	0	11	0	0.04	0.01
direct path write	2,566	0	6	2	0.00	0.01
enq: TX - row lock contention	125	0	5	42	0.00	0.01
SQL*Net more data from client	153,385	0	4	0	0.05	0.01
db file scattered read	318	0	2	7	0.00	0.00
latch: row cache objects	12,585	0	2	0	0.00	0.00
direct path write temp	1,582	0	1	1	0.00	0.00
latch: shared pool	983	0	1	1	0.00	0.00
enq: US - contention	364	0	1	3	0.00	0.00
SGA: allocation forcing component growth	10	0	1	89	0.00	0.00
cursor: pin S wait on X	33	0	1	23	0.00	0.00
cursor: pin S	12,905	0	1	0	0.00	0.00
log buffer space	5	0	1	109	0.00	0.00
enq: HW - contention	287	0	0	1	0.00	0.00
latch: In memory undo latch	2,830	0	0	0	0.00	0.00
kksfbc child completion	6	100	0	50	0.00	0.00
latch free	2,275	0	0	0	0.00	0.00
latch: session allocation	63	0	0	3	0.00	0.00
enq: SQ - contention	568	0	0	0	0.00	0.00
enq: TX - index contention	667	0	0	0	0.00	0.00
row cache lock	269	0	0	0	0.00	0.00
read by other session	17	0	0	7	0.00	0.00
library cache load lock	18	0	0	6	0.00	0.00
latch: active service list	4	0	0	22	0.00	0.00
latch: object queue header operation	770	0	0	0	0.00	0.00
buffer deadlock	1,094	100	0	0	0.00	0.00
utl_file I/O	294	0	0	0	0.00	0.00
library cache lock	2	0	0	4	0.00	0.00
cursor: mutex X	212	0	0	0	0.00	0.00
latch: undo global data	44	0	0	0	0.00	0.00
enq: FB - contention	11	0	0	0	0.00	0.00
enq: TX - contention	3	0	0	1	0.00	0.00
wait list latch free	2	0	0	1	0.00	0.00
latch: call allocation	21	0	0	0	0.00	0.00
enq: TX - allocate ITL entry	16	0	0	0	0.00	0.00
SQL*Net message from client	65,482,367	0	19,070,797	291	23.35
Streams AQ: waiting for messages in the queue	46,975	17	74,685	1590	0.02
pipe get	4,325	99	18,041	4171	0.00
PL/SQL lock timer	1,440	100	14,401	10000	0.00
jobq slave wait	7,351	100	3,673	500	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
db file parallel write	437,421	0	2,130	5	0.16	42.78
log file parallel write	2,108,994	0	729	0	0.75	14.64
db file async I/O submit	434,041	0	22	0	0.15	0.45
os thread startup	158	0	20	128	0.00	0.41
LGWR wait for redo copy	95,629	0	5	0	0.03	0.10
library cache: mutex X	638	0	3	5	0.00	0.07
control file parallel write	1,757	0	2	1	0.00	0.04
control file sequential read	7,909	0	2	0	0.00	0.04
latch free	1,589	0	1	1	0.00	0.02
db file sequential read	604	0	0	0	0.00	0.01
latch: active service list	11	0	0	22	0.00	0.00
SGA: allocation forcing component growth	3	0	0	79	0.00	0.00
direct path write	26	0	0	6	0.00	0.00
latch: object queue header operation	869	0	0	0	0.00	0.00
Disk file operations I/O	644	0	0	0	0.00	0.00
SQL*Net message to client	30,167	0	0	0	0.01	0.00
buffer busy waits	265	0	0	0	0.00	0.00
asynch descriptor resize	10,362	100	0	0	0.00	0.00
latch: shared pool	8	0	0	1	0.00	0.00
ADR block file write	5	0	0	1	0.00	0.00
log file sync	10	0	0	0	0.00	0.00
latch: redo allocation	46	0	0	0	0.00	0.00
latch: cache buffers chains	54	0	0	0	0.00	0.00
latch: cache buffers lru chain	13	0	0	0	0.00	0.00
reliable message	8	0	0	0	0.00	0.00
rdbms ipc message	1,984,435	1	64,955	33	0.71
Space Manager: slave idle wait	11,064	37	35,416	3201	0.00
Streams AQ: qmn slave idle wait	1,033	0	7,226	6996	0.00
DIAG idle wait	6,918	100	6,919	1000	0.00
Streams AQ: qmn coordinator idle wait	1,115	46	3,613	3241	0.00
smon timer	379	0	3,610	9525	0.00
Streams AQ: waiting for time management or cleanup tasks	986	73	3,571	3622	0.00
JOX Jit Process Sleep	235	100	3,525	15000	0.00
pmon timer	2,257	20	2,448	1084	0.00
SQL*Net message from client	40,375	0	28	1	0.01
class slave wait	38	0	0	5	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	19	100.0
ADR block file write	5	60.0	40.0
ADR file lock	6	100.0
Disk file operations I/O	30.5K	97.4	.2	.3	.6	1.1	.4	.1
LGWR wait for redo copy	95.7K	100.0	.0	.0		.0
SGA: allocation forcing component growth	13							100.0
SQL*Net break/reset to client	229.2K	99.7	.1	.1	.0	.0	.0	.0	.0
SQL*Net message to client	65.3M	100.0
SQL*Net more data from client	153K	100.0	.0	.0	.0			.0
SQL*Net more data to client	370.8K	100.0	.0	.0
asynch descriptor resize	10.4K	100.0
buffer busy waits	100.9K	99.3	.3	.2	.1	.0	.0	.0
buffer deadlock	1102	100.0
control file parallel write	1753	3.6	94.8	1.1	.3	.1	.1
control file sequential read	7899	99.9	.0	.1	.0	.0
cursor: mutex S	1	100.0
cursor: mutex X	212	100.0
cursor: pin S	12.9K	99.7	.1	.1		.2
cursor: pin S wait on X	33	6.1	9.1			48.5	21.2	15.2
db file async I/O submit	433.9K	100.0					.0
db file parallel write	437.3K	56.4	17.5	4.2	5.1	7.9	5.5	3.4
db file scattered read	318	20.8	9.7	9.1	22.0	28.9	9.1	.3
db file sequential read	278.3K	44.3	16.7	8.5	24.2	6.0	.3	.1
direct path write	2592	63.2	8.8	5.6	17.4	4.6	.3
direct path write temp	1582	97.9	1.6	.3	.2			.1
enq: FB - contention	11	100.0
enq: HW - contention	284	87.3	2.8	1.1	4.2	4.2	.4
enq: SQ - contention	570	99.8	.2
enq: TX - allocate ITL entry	16	100.0
enq: TX - contention	3	66.7	33.3
enq: TX - index contention	673	99.0	.3	.7
enq: TX - row lock contention	124	6.5		1.6	1.6	3.2	21.8	65.3
enq: US - contention	364	27.2	18.7	32.7	19.5	1.6	.3
kksfbc child completion	6							100.0
latch free	3860	96.5	.6	.3	2.6	.0
latch: In memory undo latch	2837	100.0
latch: active service list	15	53.3	6.7	6.7	6.7			26.7
latch: cache buffers chains	804.8K	100.0	.0	.0	.0	.0	.0	.0
latch: cache buffers lru chain	14	100.0
latch: call allocation	26	100.0
latch: enqueue hash chains	5	100.0
latch: messages	4	100.0
latch: object queue header operation	1638	100.0
latch: redo allocation	46	100.0
latch: redo writing	1	100.0
latch: row cache objects	12.6K	98.5	1.3	.2	.0
latch: session allocation	63	15.9	7.9	50.8	25.4
latch: shared pool	991	75.2	5.7	11.5	6.8	.9
latch: undo global data	45	100.0
library cache load lock	18	16.7	33.3	11.1	11.1	11.1	16.7
library cache lock	2	50.0			50.0
library cache: mutex X	873.6K	42.3	.7	.1	.0	39.2	14.5	3.1
local write wait	3684	1.1	46.6	37.4	4.9	5.6	3.5	1.0
log buffer space	5			40.0		20.0		40.0
log file parallel write	2110K	99.3	.1	.2	.3	.1	.0	.0
log file sync	1436.8K	96.8	.7	.9	1.0	.3	.1	.2
os thread startup	156							99.4	.6
read by other session	17	29.4	17.6	5.9	23.5	11.8	11.8
reliable message	8	100.0
row cache lock	269	89.6	9.7	.7
utl_file I/O	294	100.0
wait list latch free	2		100.0
DIAG idle wait	6919							100.0
JOX Jit Process Sleep	235								100.0
PL/SQL lock timer	1418								100.0
SQL*Net message from client	65.4M	79.4	6.4	4.2	3.4	3.2	1.7	1.1	.4
Space Manager: slave idle wait	10.9K	.4	.1			.1	.2	17.7	81.5
Streams AQ: qmn coordinator idle wait	1115	53.7							46.3
Streams AQ: qmn slave idle wait	1033	.1							99.9
Streams AQ: waiting for messages in the queue	47K	1.6	1.5	3.0	5.2	9.3	14.4	47.5	17.4
Streams AQ: waiting for time management or cleanup tasks	986	27.0						53.2	19.8
class slave wait	38	68.4	2.6	7.9	7.9	2.6	5.3	5.3
jobq slave wait	7348	.0	.0	.0				99.9
pipe get	4317							8.2	91.8
pmon timer	2258	31.3	.1	.0	.2	.5	.4	28.1	39.4
rdbms ipc message	1985.3K	57.2	19.3	15.5	5.9	.7	.1	.4	.9
smon timer	379	.5						8.7	90.8

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s
		% of Total Waits
Disk file operations I/O	17	99.9	.0	.0	.0
SGA: allocation forcing component growth	13		15.4	84.6
SQL*Net break/reset to client	21	100.0	.0	.0	.0	.0		.0
SQL*Net more data from client	1	100.0				.0
buffer busy waits	19	100.0	.0	.0	.0	.0	.0
cursor: pin S wait on X	5	84.8	12.1			3.0
db file parallel write	14.7K	96.6	3.1	.2	.0	.0
db file scattered read	1	99.7	.3
db file sequential read	202	99.9	.1	.0	.0	.0	.0
direct path write temp	1	99.9		.1
enq: TX - row lock contention	81	34.7	47.6	17.7
kksfbc child completion	6		100.0
latch: active service list	4	73.3		26.7
latch: cache buffers chains	1	100.0	.0
library cache: mutex X	27.5K	96.9	2.7	.4	.0	.0
local write wait	36	99.0	.9	.0		.0	.0
log buffer space	2	60.0			20.0	20.0
log file parallel write	134	100.0	.0	.0	.0	.0
log file sync	2336	99.8	.1	.0	.0	.0	.0
os thread startup	156		53.2	22.4	13.5	7.7	2.6	.6

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

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)
VIS	77,321	71,121	279	4,398,599
SYS$USERS	9	12	0	59
SYS$BACKGROUND	0	0	0	2,401

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
VIS	316167	815	1807511	7843	66004152	121
SYS$USERS	5	0	11	0	0	0
SYS$BACKGROUND	1274	1	1126	24	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 30.5% of Total DB Time (s): 77,396
Captured PL/SQL account for 60.5% of Total DB Time (s): 77,396

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
17,347.06	60,190	0.29	22.41	99.82	0.00	dhfmyks0dra9b	e:CS:frm:CSXSRISR	begin CSM_WF_PKG.SR_Post_Upd(...
16,849.58	60,188	0.28	21.77	99.89	0.00	6qw73fgxy7x1f	e:CS:frm:CSXSRISR	SELECT 1 FROM ASG_USER AU, CS_...
5,888.24	14,982	0.39	7.61	99.10	0.03	8jb36w62w5hqf		BEGIN IBU_REQ_PKG.UpdateServic...
5,202.93	15,475	0.34	6.72	99.14	0.19	cnwp4awtp6qbb		BEGIN IBU_REQ_PKG.UpdateServic...
3,736.68	360	10.38	4.83	99.53	0.19	0bujgc94rg3fj	e:SYSADMIN:gsm:WFALSNRSVC:10000:InboundThread1	begin WF_EVENT.setNavigationPa...
3,601.49	285,980	0.01	4.65	98.78	0.03	67mmmbx5hb3p0	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,172.33	74,884	0.03	2.81	99.78	0.06	8m3upvff5g0ds	e:SYSADMIN:bes:oracle.apps.cs.sr.ServiceRequest.	begin :v1 := WF_RULE.default_r...
1,737.67	45,191	0.04	2.25	99.70	0.13	agtxztg8fs5qd	e:CS:bes:oracle.apps.cs.sr.ServiceRequest.status	begin :v1 := ADS_ITIL_DEMO_PKG...
1,456.21	16,385	0.09	1.88	99.50	0.07	aaw4na3kmdfkq	JDBC Thin Client	DECLARE l_result varchar2(1); ...
1,276.92	193,745	0.01	1.65	98.14	0.00	1rd31t40r4fu5	JDBC Thin Client	BEGIN fnd_global.bless_next_in...
1,058.80	31,854	0.03	1.37	99.27	0.06	bqf04xkudk4zt	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.crea...
943.65	16,384	0.06	1.22	100.02	0.00	1wr32ytknh1u9	JDBC Thin Client	SELECT P.PID, S.PROCESS, P.SER...

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 32.6% of Total CPU Time (s): 71,193
Captured PL/SQL account for 65.4% of Total CPU Time (s): 71,193

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
17,316.22	60,190	0.29	24.32	17,347.06	99.82	0.00	dhfmyks0dra9b	e:CS:frm:CSXSRISR	begin CSM_WF_PKG.SR_Post_Upd(...
16,830.26	60,188	0.28	23.64	16,849.58	99.89	0.00	6qw73fgxy7x1f	e:CS:frm:CSXSRISR	SELECT 1 FROM ASG_USER AU, CS_...
5,835.28	14,982	0.39	8.20	5,888.24	99.10	0.03	8jb36w62w5hqf		BEGIN IBU_REQ_PKG.UpdateServic...
5,157.97	15,475	0.33	7.25	5,202.93	99.14	0.19	cnwp4awtp6qbb		BEGIN IBU_REQ_PKG.UpdateServic...
3,719.26	360	10.33	5.22	3,736.68	99.53	0.19	0bujgc94rg3fj	e:SYSADMIN:gsm:WFALSNRSVC:10000:InboundThread1	begin WF_EVENT.setNavigationPa...
3,557.66	285,980	0.01	5.00	3,601.49	98.78	0.03	67mmmbx5hb3p0	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,167.50	74,884	0.03	3.04	2,172.33	99.78	0.06	8m3upvff5g0ds	e:SYSADMIN:bes:oracle.apps.cs.sr.ServiceRequest.	begin :v1 := WF_RULE.default_r...
1,732.42	45,191	0.04	2.43	1,737.67	99.70	0.13	agtxztg8fs5qd	e:CS:bes:oracle.apps.cs.sr.ServiceRequest.status	begin :v1 := ADS_ITIL_DEMO_PKG...
1,448.95	16,385	0.09	2.04	1,456.21	99.50	0.07	aaw4na3kmdfkq	JDBC Thin Client	DECLARE l_result varchar2(1); ...
1,253.14	193,745	0.01	1.76	1,276.92	98.14	0.00	1rd31t40r4fu5	JDBC Thin Client	BEGIN fnd_global.bless_next_in...
1,051.06	31,854	0.03	1.48	1,058.80	99.27	0.06	bqf04xkudk4zt	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.crea...
943.86	16,384	0.06	1.33	943.65	100.02	0.00	1wr32ytknh1u9	JDBC Thin Client	SELECT P.PID, S.PROCESS, P.SER...
764.21	120,292	0.01	1.07	765.95	99.77	0.19	3vy5h9xkfv1s5	e:CS:wf:SERVEREQ	INSERT INTO WF_ITEM_ATTRIBUTE_...

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
431.45	36,315	0.01	52.93	469.64	11.46	91.87	4hkpja39f83t3	e:CS:frm:CSXSRISR	select cp.phone, cp.phone_exte...
9.73	15,475	0.00	1.19	5,202.93	99.14	0.19	cnwp4awtp6qbb		BEGIN IBU_REQ_PKG.UpdateServic...
7.16	360	0.02	0.88	3,736.68	99.53	0.19	0bujgc94rg3fj	e:SYSADMIN:gsm:WFALSNRSVC:10000:InboundThread1	begin WF_EVENT.setNavigationPa...
3.91	539,940	0.00	0.48	481.99	100.03	0.81	ad4bs1dj94p28		SELECT DISTINCT a.PERMISSION_N...
2.34	45,191	0.00	0.29	1,737.67	99.70	0.13	agtxztg8fs5qd	e:CS:bes:oracle.apps.cs.sr.ServiceRequest.status	begin :v1 := ADS_ITIL_DEMO_PKG...
1.64	14,982	0.00	0.20	5,888.24	99.10	0.03	8jb36w62w5hqf		BEGIN IBU_REQ_PKG.UpdateServic...
1.47	120,292	0.00	0.18	765.95	99.77	0.19	3vy5h9xkfv1s5	e:CS:wf:SERVEREQ	INSERT INTO WF_ITEM_ATTRIBUTE_...
1.36	74,884	0.00	0.17	2,172.33	99.78	0.06	8m3upvff5g0ds	e:SYSADMIN:bes:oracle.apps.cs.sr.ServiceRequest.	begin :v1 := WF_RULE.default_r...
1.26	285,980	0.00	0.15	3,601.49	98.78	0.03	67mmmbx5hb3p0	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
1.24	9,337,253	0.00	0.15	353.70	100.56	0.35	7qs7fx89194u1	ICM@appszone0 (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...

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: 4,405,685,314
Captured SQL account for 90.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
3,565,173,683	60,188	59,233.96	80.92	16,849.58	99.9	0	6qw73fgxy7x1f	e:CS:frm:CSXSRISR	SELECT 1 FROM ASG_USER AU, CS_...
2,458,854,810	60,190	40,851.55	55.81	17,347.06	99.8	0	dhfmyks0dra9b	e:CS:frm:CSXSRISR	begin CSM_WF_PKG.SR_Post_Upd(...
931,118,382	14,982	62,149.14	21.13	5,888.24	99.1	0	8jb36w62w5hqf		BEGIN IBU_REQ_PKG.UpdateServic...
901,265,871	15,475	58,240.12	20.46	5,202.93	99.1	.2	cnwp4awtp6qbb		BEGIN IBU_REQ_PKG.UpdateServic...
143,356,383	360	398,212.18	3.25	3,736.68	99.5	.2	0bujgc94rg3fj	e:SYSADMIN:gsm:WFALSNRSVC:10000:InboundThread1	begin WF_EVENT.setNavigationPa...
122,283,707	74,884	1,632.98	2.78	2,172.33	99.8	.1	8m3upvff5g0ds	e:SYSADMIN:bes:oracle.apps.cs.sr.ServiceRequest.	begin :v1 := WF_RULE.default_r...
116,262,611	120,292	966.50	2.64	765.95	99.8	.2	3vy5h9xkfv1s5	e:CS:wf:SERVEREQ	INSERT INTO WF_ITEM_ATTRIBUTE_...
85,936,570	45,191	1,901.63	1.95	1,737.67	99.7	.1	agtxztg8fs5qd	e:CS:bes:oracle.apps.cs.sr.ServiceRequest.status	begin :v1 := ADS_ITIL_DEMO_PKG...
70,031,575	539,940	129.70	1.59	481.99	100	.8	ad4bs1dj94p28		SELECT DISTINCT a.PERMISSION_N...
54,441,366	520,400	104.61	1.24	366.18	100.1	0	34141mdmp6hd4		select m.context_value2, m.con...

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: 279,256
Captured SQL account for 48.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
132,220	36,315	3.64	47.35	469.64	11.46	91.87	4hkpja39f83t3	e:CS:frm:CSXSRISR	select cp.phone, cp.phone_exte...
3,984	15,475	0.26	1.43	5,202.93	99.14	0.19	cnwp4awtp6qbb		BEGIN IBU_REQ_PKG.UpdateServic...
1,853	539,940	0.00	0.66	481.99	100.03	0.81	ad4bs1dj94p28		SELECT DISTINCT a.PERMISSION_N...
762	45,191	0.02	0.27	1,737.67	99.70	0.13	agtxztg8fs5qd	e:CS:bes:oracle.apps.cs.sr.ServiceRequest.status	begin :v1 := ADS_ITIL_DEMO_PKG...
761	14,982	0.05	0.27	5,888.24	99.10	0.03	8jb36w62w5hqf		BEGIN IBU_REQ_PKG.UpdateServic...
513	9,337,253	0.00	0.18	353.70	100.56	0.35	7qs7fx89194u1	ICM@appszone0 (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
312	16,384	0.02	0.11	433.89	91.73	0.17	dt2vdh82d4hrb	JDBC Thin Client	BEGIN :1 := FND_WEB_SEC.valida...
74	360	0.21	0.03	3,736.68	99.53	0.19	0bujgc94rg3fj	e:SYSADMIN:gsm:WFALSNRSVC:10000:InboundThread1	begin WF_EVENT.setNavigationPa...
53	31,854	0.00	0.02	1,058.80	99.27	0.06	bqf04xkudk4zt	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.crea...
41	16,385	0.00	0.01	1,456.21	99.50	0.07	aaw4na3kmdfkq	JDBC Thin Client	DECLARE l_result varchar2(1); ...

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: 278,475
Captured SQL account for 48.2% of Total
Total UnOptimized Read Requests: 278,475
Captured SQL account for 48.2% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
131,784	131,784	36,315	3.63	47.32	4hkpja39f83t3	e:CS:frm:CSXSRISR	select cp.phone, cp.phone_exte...
3,965	3,965	15,475	0.26	1.42	cnwp4awtp6qbb		BEGIN IBU_REQ_PKG.UpdateServic...
1,854	1,854	539,940	0.00	0.67	ad4bs1dj94p28		SELECT DISTINCT a.PERMISSION_N...
762	762	14,982	0.05	0.27	8jb36w62w5hqf		BEGIN IBU_REQ_PKG.UpdateServic...
762	762	45,191	0.02	0.27	agtxztg8fs5qd	e:CS:bes:oracle.apps.cs.sr.ServiceRequest.status	begin :v1 := ADS_ITIL_DEMO_PKG...
513	513	9,337,253	0.00	0.18	7qs7fx89194u1	ICM@appszone0 (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
312	312	16,384	0.02	0.11	dt2vdh82d4hrb	JDBC Thin Client	BEGIN :1 := FND_WEB_SEC.valida...
74	74	360	0.21	0.03	0bujgc94rg3fj	e:SYSADMIN:gsm:WFALSNRSVC:10000:InboundThread1	begin WF_EVENT.setNavigationPa...
53	53	31,854	0.00	0.02	bqf04xkudk4zt	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.crea...
41	41	16,385	0.00	0.01	aaw4na3kmdfkq	JDBC Thin Client	DECLARE l_result varchar2(1); ...

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: 128,893,477
Captured SQL account for 30.6% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
9,394,724	9,140,468	0.97	504.60	101.3	0	0wmwsjy9kd92f	ICM@appszone0 (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APPL...
9,337,253	2,393,684	0.26	353.70	100.6	.4	7qs7fx89194u1	ICM@appszone0 (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
3,629,707	32,671,314	9.00	148.32	99.8	0	8w57t3xaxs89k	ICM@appszone0 (TNS V1-V3)	SELECT NAME, VERSION FROM FND_...
3,191,290	1,205,828	0.38	304.20	100.9	0	dawf7hvg1ym94	JDBC Thin Client	select V.PROFILE_OPTION_VALUE ...
1,909,197	1,909,713	1.00	118.49	103	0	3vmu4pf29j2t7	frmweb@appszone0 (TNS V1-V3)	SELECT TCU.TCE_CODE TCE_CODE F...
1,580,201	1,579,894	1.00	196.73	100.7	0	16614jtsr33r0	ICM@appszone0 (TNS V1-V3)	begin fnd_date.initialize_with...
1,264,162	30	0.00	54.59	102.2	0	55dc767ajydh3	e::cp:30	SELECT PROFILE_OPTION_VALUE FR...
1,205,980	1,206,085	1.00	97.57	102.9	0	3350m9wncvqvn	JDBC Thin Client	select HIERARCHY_TYPE, SITE_EN...
1,143,691	1,143,767	1.00	118.99	101.7	0	37kp7bjxfn4u5	ICM@appszone0 (TNS V1-V3)	SELECT NLS_DATE_LANGUAGE FROM ...
1,142,320	21,267,568	18.62	172.09	101.7	0	ckjxdxw91auhn		SELECT a.perz_data_id, a.profi...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 2,391,974
Captured SQL account for 15.8% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
60,193	60,193	2.52	28p185u4mm36a		insert into "APPLSYS"."AQ$_WF_...
45,185	49,419	1.89	044sqfsxv2kf4	e:CS:wf:SERVEREQ	begin CS_WF_AUTO_NTFY_UPDATE_P...
45,185	90,381	1.89	1sx6uhx6xrr5b	e:CS:wf:SERVEREQ	begin WF_STANDARD.COMPARE (:v1...
16,766	9,394,724	0.70	0wmwsjy9kd92f	ICM@appszone0 (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APPL...
11,888	9,337,253	0.50	7qs7fx89194u1	ICM@appszone0 (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
11,026	102,289	0.46	cm5vu20fhtnq1		select /*+ connect_by_filterin...
11,025	11,026	0.46	0k8522rmdzg4k		select privilege# from sysauth...
10,899	10,899	0.46	0q8w0cndsp865	ICM@appszone0 (TNS V1-V3)	SELECT FPOV.PROFILE_OPTION_VAL...
10,899	10,899	0.46	bazquck2vuvm1	ICM@appszone0 (TNS V1-V3)	SELECT RELEASE_NAME FROM FND_P...
8,685	8,685	0.36	5ur69atw3vfhj		select decode(failover_method,...

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

044sqfsxv2kf4 begin CS_WF_AUTO_NTFY_UPDATE_PKG.GET_REQUEST_ATTRIBUTES (:v1, :v2, :v3, :v4, :v5); end;

0bujgc94rg3fj begin WF_EVENT.setNavigationParams ( p_agentName => :1, p_navigationThreshold => :2 ); WF_EVENT.LISTEN ( p_agent_name => :3, p_wait => :4, p_correlation => :5, p_deq_condition => null, p_message_count => :6, p_max_error_count => :7 );end;

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

0q8w0cndsp865 SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO WHERE FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_ENABLED' AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPOV.LEVEL_ID = 10001 AND FPO.APPLICATION_ID = FPOV.APPLICATION_ID

0wmwsjy9kd92f SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE

16614jtsr33r0 begin fnd_date.initialize_with_calendar(:1, null, :2); end;

1rd31t40r4fu5 BEGIN fnd_global.bless_next_init('FND_PERMIT_0006'); FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;

1sx6uhx6xrr5b begin WF_STANDARD.COMPARE (:v1, :v2, :v3, :v4, :v5); end;

1wr32ytknh1u9 SELECT P.PID, S.PROCESS, P.SERIAL#, P.SPID FROM V$PROCESS P, V$SESSION S WHERE S.AUDSID = USERENV('SESSIONID') AND S.PADDR = P.ADDR

28p185u4mm36a insert into "APPLSYS"."AQ$_WF_JAVA_DEFERRED_L" values (:1, :2, :3, :4, :5, :6, :7, :8)

3350m9wncvqvn select HIERARCHY_TYPE, SITE_ENABLED_FLAG, APP_ENABLED_FLAG, RESP_ENABLED_FLAG, USER_ENABLED_FLAG, SERVER_ENABLED_FLAG, ORG_ENABLED_FLAG, SQL_VALIDATION, SERVERRESP_ENABLED_FLAG from FND_PROFILE_OPTIONS where PROFILE_OPTION_NAME = :1

34141mdmp6hd4 select m.context_value2, m.context_value3 from CS_CF_SOURCE_CXT_TARGETS m , CS_CF_SOURCE_CXT_TYPES t where cust_target_value1 = :1 and m.source_context_type_id = t.source_context_type_id and t.source_code = :2 and t.context_type = :3 and t.purpose = :4 and t.source_type = :5

37kp7bjxfn4u5 SELECT NLS_DATE_LANGUAGE FROM (SELECT UTF8_DATE_LANGUAGE NLS_DATE_LANGUAGE FROM FND_LANGUAGES WHERE NLS_CHARSET_NAME(NLS_CHARSET_ID('CHAR_CS')) IN ('UTF8', 'AL32UTF8') AND INSTALLED_FLAG <>'D' AND NLS_LANGUAGE = :B1 UNION SELECT LOCAL_DATE_LANGUAGE NLS_DATE_LANGUAGE FROM FND_LANGUAGES WHERE NLS_CHARSET_NAME(NLS_CHARSET_ID('CHAR_CS')) NOT IN ('UTF8', 'AL32UTF8') AND INSTALLED_FLAG <>'D' AND NLS_LANGUAGE = :B1 )

3vmu4pf29j2t7 SELECT TCU.TCE_CODE TCE_CODE FROM OKX_UNITS_OF_MEASURE_V UOM , OKC_TIME_CODE_UNITS_V TCU WHERE UOM.UOM_CODE = :B1 AND TCU.UOM_CODE = UOM.UOM_CODE AND TCU.QUANTITY = 1 AND TCU.TCE_CODE = 'MINUTE'

3vy5h9xkfv1s5 INSERT INTO WF_ITEM_ATTRIBUTE_VALUES ( ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE ) SELECT :B1 , :B2 , WIA.NAME, WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT FROM WF_ITEM_ATTRIBUTES WIA WHERE WIA.ITEM_TYPE = :B1

4hkpja39f83t3 select cp.phone, cp.phone_extension, cp.cont_point_type_meaning, cp.phone_line_type_meaning, rel_party_number, sub_party_name, sub_person_last_name, sub_person_first_name, sub_person_pre_name_adjunct, rel_email_address, rel_address, rel_city, rel_state, rel_country, rel_province, rel_postal_code, party_relationship_meaning, obj_party_number, obj_party_name, obj_known_as, obj_email_address, obj_address, obj_city, obj_state, obj_country, obj_province, obj_postal_code, rel_party_id, obj_party_id, cp.contact_point_id, cp.timezone_id, cp.contact_point_type from cs_sr_hz_cont_pts_p_phones_v cp, cs_sr_hz_relationships_v cs where cp.transposed_phone_number like :1 and cp.owner_table_id = cs.rel_party_id and cs.rel_party_type = :"SYS_B_0" and cs.sub_party_type = :"SYS_B_1" and cs.obj_party_type = :"SYS_B_2" order by :"SYS_B_3"

55dc767ajydh3 SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL

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

67mmmbx5hb3p0 BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, true);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;:21 := fnd_session_management.g_proxy_user_id; :22 := fnd_session_management.g_mode_code; END;

6qw73fgxy7x1f SELECT 1 FROM ASG_USER AU, CS_INCIDENTS_ALL_B CSA WHERE CSA.INCIDENT_ID = :B1 AND (CSA.OWNER_GROUP_ID = AU.GROUP_ID AND AU.USER_ID=AU.OWNER_ID) OR AU.USER_ID=CSA.CREATED_BY OR EXISTS(SELECT 1 FROM JTF_TASK_ASSIGNMENTS JTA, JTF_TASKS_B JT WHERE JT.SOURCE_OBJECT_ID = CSA.INCIDENT_ID AND JT.SOURCE_OBJECT_TYPE_CODE = 'SR' AND JTA.TASK_ID = JT.TASK_ID AND AU.RESOURCE_ID = JTA.RESOURCE_ID) OR EXISTS(SELECT 1 FROM JTF_TASKS_B JT WHERE JT.SOURCE_OBJECT_ID = CSA.INCIDENT_ID AND JT.SOURCE_OBJECT_TYPE_CODE = 'SR' AND JT.CREATED_BY=AU.USER_ID)

7qs7fx89194u1 SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL

8jb36w62w5hqf BEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;

8m3upvff5g0ds begin :v1 := WF_RULE.default_rule(:v2, :v3); end;

8w57t3xaxs89k SELECT NAME, VERSION FROM FND_CACHE_VERSIONS

aaw4na3kmdfkq DECLARE l_result varchar2(1); BEGIN l_result := FND_AOLJ_UTIL.convertGuestSession(:1, :2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20); :21 := l_result;END;

ad4bs1dj94p28 SELECT DISTINCT a.PERMISSION_NAME, dom.DOMAIN_NAME, a.MAINTENANCE_MODE_FLAG FROM JTF_AUTH_PERMISSIONS_B A, JTF_AUTH_PRINCIPAL_MAPS B, JTF_AUTH_ROLE_PERMS C, JTF_AUTH_PRINCIPALS_B D, JTF_AUTH_PRINCIPALS_B E, JTF_AUTH_DOMAINS_B dom WHERE D.PRINCIPAL_NAME = :1 AND D.IS_USER_FLAG = :"SYS_B_0" AND D.JTF_AUTH_PRINCIPAL_ID = B.JTF_AUTH_PRINCIPAL_ID AND B.JTF_AUTH_PARENT_PRINCIPAL_ID=E.JTF_AUTH_PRINCIPAL_ID AND E.IS_USER_FLAG = :"SYS_B_1" AND E.JTF_AUTH_PRINCIPAL_ID = C.JTF_AUTH_PRINCIPAL_ID AND C.JTF_AUTH_PERMISSION_ID = A.JTF_AUTH_PERMISSION_ID AND C.POSITIVE_FLAG=:"SYS_B_2" AND B.JTF_AUTH_DOMAIN_ID = dom.JTF_AUTH_DOMAIN_ID ORDER BY A.PERMISSION_NAME

agtxztg8fs5qd begin :v1 := ADS_ITIL_DEMO_PKG.Custom_Rule(:v2, :v3); end;

bazquck2vuvm1 SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS ORDER BY PRODUCT_GROUP_ID

bqf04xkudk4zt BEGIN :1 := FND_AOLJ_UTIL.createSession(:2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22);:23 := fnd_session_management.g_enc_key;:24 := fnd_session_management.g_mac_key;END;

ckjxdxw91auhn SELECT a.perz_data_id, a.profile_id, a.application_id, a.perz_data_name, a.perz_data_type, a.perz_data_desc, b.attribute_name, b.attribute_type, b.attribute_value, b.attribute_context FROM JTF_PERZ_DATA a, JTF_PERZ_DATA_ATTRIB b WHERE a.perz_data_id = :1 AND a.perz_data_id = b.perz_data_id ORDER BY a.perz_data_id

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

cnwp4awtp6qbb BEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;

dawf7hvg1ym94 select V.PROFILE_OPTION_VALUE from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V where O.PROFILE_OPTION_NAME = :1 and V.LEVEL_ID = :2 and O.START_DATE_ACTIVE <= SYSDATE and nvl(O.END_DATE_ACTIVE, SYSDATE) >= SYSDATE and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID and O.APPLICATION_ID = V.APPLICATION_ID and V.LEVEL_VALUE = :3

dhfmyks0dra9b begin CSM_WF_PKG.SR_Post_Upd(:1); end;

dt2vdh82d4hrb BEGIN :1 := FND_WEB_SEC.validate_login(:2, :3); END;

SQL Id	SQL Text
044sqfsxv2kf4	begin CS_WF_AUTO_NTFY_UPDATE_PKG.GET_REQUEST_ATTRIBUTES (:v1, :v2, :v3, :v4, :v5); end;
0bujgc94rg3fj	begin WF_EVENT.setNavigationParams ( p_agentName => :1, p_navigationThreshold => :2 ); WF_EVENT.LISTEN ( p_agent_name => :3, p_wait => :4, p_correlation => :5, p_deq_condition => null, p_message_count => :6, p_max_error_count => :7 );end;
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0q8w0cndsp865	SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO WHERE FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_ENABLED' AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPOV.LEVEL_ID = 10001 AND FPO.APPLICATION_ID = FPOV.APPLICATION_ID
0wmwsjy9kd92f	SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
16614jtsr33r0	begin fnd_date.initialize_with_calendar(:1, null, :2); end;
1rd31t40r4fu5	BEGIN fnd_global.bless_next_init('FND_PERMIT_0006'); FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
1sx6uhx6xrr5b	begin WF_STANDARD.COMPARE (:v1, :v2, :v3, :v4, :v5); end;
1wr32ytknh1u9	SELECT P.PID, S.PROCESS, P.SERIAL#, P.SPID FROM V$PROCESS P, V$SESSION S WHERE S.AUDSID = USERENV('SESSIONID') AND S.PADDR = P.ADDR
28p185u4mm36a	insert into "APPLSYS"."AQ$_WF_JAVA_DEFERRED_L" values (:1, :2, :3, :4, :5, :6, :7, :8)
3350m9wncvqvn	select HIERARCHY_TYPE, SITE_ENABLED_FLAG, APP_ENABLED_FLAG, RESP_ENABLED_FLAG, USER_ENABLED_FLAG, SERVER_ENABLED_FLAG, ORG_ENABLED_FLAG, SQL_VALIDATION, SERVERRESP_ENABLED_FLAG from FND_PROFILE_OPTIONS where PROFILE_OPTION_NAME = :1
34141mdmp6hd4	select m.context_value2, m.context_value3 from CS_CF_SOURCE_CXT_TARGETS m , CS_CF_SOURCE_CXT_TYPES t where cust_target_value1 = :1 and m.source_context_type_id = t.source_context_type_id and t.source_code = :2 and t.context_type = :3 and t.purpose = :4 and t.source_type = :5
37kp7bjxfn4u5	SELECT NLS_DATE_LANGUAGE FROM (SELECT UTF8_DATE_LANGUAGE NLS_DATE_LANGUAGE FROM FND_LANGUAGES WHERE NLS_CHARSET_NAME(NLS_CHARSET_ID('CHAR_CS')) IN ('UTF8', 'AL32UTF8') AND INSTALLED_FLAG <>'D' AND NLS_LANGUAGE = :B1 UNION SELECT LOCAL_DATE_LANGUAGE NLS_DATE_LANGUAGE FROM FND_LANGUAGES WHERE NLS_CHARSET_NAME(NLS_CHARSET_ID('CHAR_CS')) NOT IN ('UTF8', 'AL32UTF8') AND INSTALLED_FLAG <>'D' AND NLS_LANGUAGE = :B1 )
3vmu4pf29j2t7	SELECT TCU.TCE_CODE TCE_CODE FROM OKX_UNITS_OF_MEASURE_V UOM , OKC_TIME_CODE_UNITS_V TCU WHERE UOM.UOM_CODE = :B1 AND TCU.UOM_CODE = UOM.UOM_CODE AND TCU.QUANTITY = 1 AND TCU.TCE_CODE = 'MINUTE'
3vy5h9xkfv1s5	INSERT INTO WF_ITEM_ATTRIBUTE_VALUES ( ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE ) SELECT :B1 , :B2 , WIA.NAME, WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT FROM WF_ITEM_ATTRIBUTES WIA WHERE WIA.ITEM_TYPE = :B1
4hkpja39f83t3	select cp.phone, cp.phone_extension, cp.cont_point_type_meaning, cp.phone_line_type_meaning, rel_party_number, sub_party_name, sub_person_last_name, sub_person_first_name, sub_person_pre_name_adjunct, rel_email_address, rel_address, rel_city, rel_state, rel_country, rel_province, rel_postal_code, party_relationship_meaning, obj_party_number, obj_party_name, obj_known_as, obj_email_address, obj_address, obj_city, obj_state, obj_country, obj_province, obj_postal_code, rel_party_id, obj_party_id, cp.contact_point_id, cp.timezone_id, cp.contact_point_type from cs_sr_hz_cont_pts_p_phones_v cp, cs_sr_hz_relationships_v cs where cp.transposed_phone_number like :1 and cp.owner_table_id = cs.rel_party_id and cs.rel_party_type = :"SYS_B_0" and cs.sub_party_type = :"SYS_B_1" and cs.obj_party_type = :"SYS_B_2" order by :"SYS_B_3"
55dc767ajydh3	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
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
67mmmbx5hb3p0	BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, true);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;:21 := fnd_session_management.g_proxy_user_id; :22 := fnd_session_management.g_mode_code; END;
6qw73fgxy7x1f	SELECT 1 FROM ASG_USER AU, CS_INCIDENTS_ALL_B CSA WHERE CSA.INCIDENT_ID = :B1 AND (CSA.OWNER_GROUP_ID = AU.GROUP_ID AND AU.USER_ID=AU.OWNER_ID) OR AU.USER_ID=CSA.CREATED_BY OR EXISTS(SELECT 1 FROM JTF_TASK_ASSIGNMENTS JTA, JTF_TASKS_B JT WHERE JT.SOURCE_OBJECT_ID = CSA.INCIDENT_ID AND JT.SOURCE_OBJECT_TYPE_CODE = 'SR' AND JTA.TASK_ID = JT.TASK_ID AND AU.RESOURCE_ID = JTA.RESOURCE_ID) OR EXISTS(SELECT 1 FROM JTF_TASKS_B JT WHERE JT.SOURCE_OBJECT_ID = CSA.INCIDENT_ID AND JT.SOURCE_OBJECT_TYPE_CODE = 'SR' AND JT.CREATED_BY=AU.USER_ID)
7qs7fx89194u1	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
8jb36w62w5hqf	BEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
8m3upvff5g0ds	begin :v1 := WF_RULE.default_rule(:v2, :v3); end;
8w57t3xaxs89k	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS
aaw4na3kmdfkq	DECLARE l_result varchar2(1); BEGIN l_result := FND_AOLJ_UTIL.convertGuestSession(:1, :2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20); :21 := l_result;END;
ad4bs1dj94p28	SELECT DISTINCT a.PERMISSION_NAME, dom.DOMAIN_NAME, a.MAINTENANCE_MODE_FLAG FROM JTF_AUTH_PERMISSIONS_B A, JTF_AUTH_PRINCIPAL_MAPS B, JTF_AUTH_ROLE_PERMS C, JTF_AUTH_PRINCIPALS_B D, JTF_AUTH_PRINCIPALS_B E, JTF_AUTH_DOMAINS_B dom WHERE D.PRINCIPAL_NAME = :1 AND D.IS_USER_FLAG = :"SYS_B_0" AND D.JTF_AUTH_PRINCIPAL_ID = B.JTF_AUTH_PRINCIPAL_ID AND B.JTF_AUTH_PARENT_PRINCIPAL_ID=E.JTF_AUTH_PRINCIPAL_ID AND E.IS_USER_FLAG = :"SYS_B_1" AND E.JTF_AUTH_PRINCIPAL_ID = C.JTF_AUTH_PRINCIPAL_ID AND C.JTF_AUTH_PERMISSION_ID = A.JTF_AUTH_PERMISSION_ID AND C.POSITIVE_FLAG=:"SYS_B_2" AND B.JTF_AUTH_DOMAIN_ID = dom.JTF_AUTH_DOMAIN_ID ORDER BY A.PERMISSION_NAME
agtxztg8fs5qd	begin :v1 := ADS_ITIL_DEMO_PKG.Custom_Rule(:v2, :v3); end;
bazquck2vuvm1	SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS ORDER BY PRODUCT_GROUP_ID
bqf04xkudk4zt	BEGIN :1 := FND_AOLJ_UTIL.createSession(:2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22);:23 := fnd_session_management.g_enc_key;:24 := fnd_session_management.g_mac_key;END;
ckjxdxw91auhn	SELECT a.perz_data_id, a.profile_id, a.application_id, a.perz_data_name, a.perz_data_type, a.perz_data_desc, b.attribute_name, b.attribute_type, b.attribute_value, b.attribute_context FROM JTF_PERZ_DATA a, JTF_PERZ_DATA_ATTRIB b WHERE a.perz_data_id = :1 AND a.perz_data_id = b.perz_data_id ORDER BY a.perz_data_id
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cnwp4awtp6qbb	BEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
dawf7hvg1ym94	select V.PROFILE_OPTION_VALUE from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V where O.PROFILE_OPTION_NAME = :1 and V.LEVEL_ID = :2 and O.START_DATE_ACTIVE <= SYSDATE and nvl(O.END_DATE_ACTIVE, SYSDATE) >= SYSDATE and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID and O.APPLICATION_ID = V.APPLICATION_ID and V.LEVEL_VALUE = :3
dhfmyks0dra9b	begin CSM_WF_PKG.SR_Post_Upd(:1); end;
dt2vdh82d4hrb	BEGIN :1 := FND_WEB_SEC.validate_login(:2, :3); END;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	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 slow jump 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	15	0.00	0.00
CCursor + sql area evicted	9	0.00	0.00
CPU used by this session	6,423,615	1,778.55	2.29
CPU used when call started	6,401,910	1,772.54	2.28
CR blocks created	35,940,229	9,951.00	12.81
Cached Commit SCN referenced	3,355,760	929.13	1.20
Commit SCN cached	1,588,765	439.89	0.57
DB time	15,523,183	4,298.00	5.53
DBWR checkpoint buffers written	2,633,449	729.14	0.94
DBWR checkpoints	0	0.00	0.00
DBWR revisited being-written buffer	1	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	1,571	0.43	0.00
DBWR undo block writes	1,537,537	425.71	0.55
DFO trees parallelized	0	0.00	0.00
Effective IO time	0	0.00	0.00
HSC Heap Segment Block Changes	30,787,280	8,524.27	10.98
Heap Segment Array Inserts	413,082	114.37	0.15
Heap Segment Array Updates	2,022	0.56	0.00
IMU CR rollbacks	137,588	38.09	0.05
IMU Flushes	305,044	84.46	0.11
IMU Redo allocation size	432,460,436	119,738.12	154.19
IMU commits	667,978	184.95	0.24
IMU contention	15,516	4.30	0.01
IMU ktichg flush	13,444	3.72	0.00
IMU pool not allocated	1,958,620	542.30	0.70
IMU recursive-transaction flush	435	0.12	0.00
IMU undo allocation size	2,106,235,448	583,167.03	750.98
IMU- failed to get a private strand	78	0.02	0.00
Number of read IOs issued	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations downgraded 75 to 99 pct	0	0.00	0.00
Requests to/from client	65,499,506	18,135.27	23.35
RowCR - row contention	33,306	9.22	0.01
RowCR attempts	17,289,501	4,787.06	6.16
RowCR hits	16,649,025	4,609.72	5.94
SQL*Net roundtrips to/from client	65,511,466	18,138.58	23.36
active txn count during cleanout	22,691,171	6,282.65	8.09
application wait time	5,577	1.54	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	25,836	7.15	0.01
branch node splits	2,214	0.61	0.00
buffer is not pinned count	3,407,300,326	943,401.28	1,214.88
buffer is pinned count	672,771,252	186,274.53	239.88
bytes received via SQL*Net from client	8,703,308,378	2,409,741.28	3,103.18
bytes sent via SQL*Net to client	11,317,025,085	3,133,417.93	4,035.10
calls to get snapshot scn: kcmgss	125,207,798	34,667.09	44.64
calls to kcmgas	40,010,897	11,078.08	14.27
calls to kcmgcs	8,227,835	2,278.09	2.93
cell physical IO interconnect bytes	54,716,446,720	15,149,696.51	19,509.24
change write time	68,943	19.09	0.02
cleanout - number of ktugct calls	15,509,025	4,294.08	5.53
cleanouts and rollbacks - consistent read gets	14,481,522	4,009.59	5.16
cleanouts only - consistent read gets	112,732	31.21	0.04
cluster key scan block gets	3,337,267	924.01	1.19
cluster key scans	2,233,413	618.38	0.80
commit batch performed	18,485	5.12	0.01
commit batch requested	18,485	5.12	0.01
commit batch/immediate performed	38,848	10.76	0.01
commit batch/immediate requested	38,848	10.76	0.01
commit cleanout failures: block lost	69,566	19.26	0.02
commit cleanout failures: buffer being written	80	0.02	0.00
commit cleanout failures: callback failure	92,382	25.58	0.03
commit cleanout failures: cannot pin	24,543	6.80	0.01
commit cleanouts	16,083,230	4,453.07	5.73
commit cleanouts successfully completed	15,896,649	4,401.41	5.67
commit immediate performed	20,363	5.64	0.01
commit immediate requested	20,363	5.64	0.01
commit txn count during cleanout	3,149,160	871.93	1.12
concurrency wait time	786,848	217.86	0.28
consistent changes	56,367,927	15,606.95	20.10
consistent gets	4,222,667,214	1,169,157.18	1,505.60
consistent gets - examination	462,447,402	128,040.80	164.89
consistent gets direct	8	0.00	0.00
consistent gets from cache	4,222,670,364	1,169,158.06	1,505.60
consistent gets from cache (fastpath)	3,509,683,740	971,748.84	1,251.38
cursor authentications	1,332	0.37	0.00
data blocks consistent reads - undo records applied	55,187,972	15,280.25	19.68
db block changes	166,154,288	46,004.21	59.24
db block gets	183,062,523	50,685.70	65.27
db block gets direct	5,102	1.41	0.00
db block gets from cache	183,057,313	50,684.26	65.27
db block gets from cache (fastpath)	37,829,184	10,474.01	13.49
deferred (CURRENT) block cleanout applications	2,018,565	558.89	0.72
dirty buffers inspected	2,454	0.68	0.00
enqueue conversions	824	0.23	0.00
enqueue releases	9,255,619	2,562.66	3.30
enqueue requests	9,261,800	2,564.37	3.30
enqueue timeouts	3,967	1.10	0.00
enqueue waits	2,046	0.57	0.00
exchange deadlocks	1,102	0.31	0.00
execute count	128,893,477	35,687.57	45.96
failed probes on index block reclamation	498	0.14	0.00
file io service time	9,998,763	2,768.42	3.57
file io wait time	2,957,150,392	818,765.36	1,054.38
free buffer inspected	57,023	15.79	0.02
free buffer requested	39,009,749	10,800.88	13.91
heap block compress	461,276	127.72	0.16
hot buffers moved to head of LRU	5,266	1.46	0.00
immediate (CR) block cleanout applications	14,594,247	4,040.80	5.20
immediate (CURRENT) block cleanout applications	1,547,138	428.37	0.55
in call idle wait time	24,213,034	6,704.02	8.63
index crx upgrade (positioned)	352,825	97.69	0.13
index fetch by key	160,065,981	44,318.50	57.07
index scans kdiixs1	487,615,947	135,009.38	173.86
java call heap collected bytes	266,290,432	73,729.55	94.95
java call heap collected count	2,451,233	678.69	0.87
java call heap gc count	1,466	0.41	0.00
java call heap live object count	0	0.00	0.00
java call heap live object count max	0	0.00	0.00
java call heap live size	0	0.00	0.00
java call heap live size max	0	0.00	0.00
java call heap object count	1,030,287	285.26	0.37
java call heap object count max	1,036,521	286.99	0.37
java call heap total size	0	0.00	0.00
java call heap total size max	0	0.00	0.00
java call heap used size	96,558,144	26,734.68	34.43
java call heap used size max	96,898,176	26,828.82	34.55
java session heap live object count	0	0.00	0.00
java session heap live object count max	0	0.00	0.00
java session heap live size	210,604,032	58,311.30	75.09
java session heap live size max	210,604,032	58,311.30	75.09
java session heap object count	0	0.00	0.00
java session heap object count max	0	0.00	0.00
java session heap used size	210,604,032	58,311.30	75.09
java session heap used size max	210,604,032	58,311.30	75.09
leaf node 90-10 splits	7,410	2.05	0.00
leaf node splits	352,917	97.71	0.13
lob reads	185,747	51.43	0.07
lob writes	535,879	148.37	0.19
lob writes unaligned	535,880	148.37	0.19
logical read bytes from cache	36,091,764,998,144	9,992,960,415.29	12,868,577.21
logons cumulative	11,197	3.10	0.00
max cf enq hold time	0	0.00	0.00
messages received	2,550,932	706.29	0.91
messages sent	2,550,931	706.29	0.91
min active SCN optimization applied on CR	10,708,252	2,964.86	3.82
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	3,684,719,453	1,020,212.11	1,313.79
non-idle wait count	75,886,747	21,011.25	27.06
non-idle wait time	1,272,683	352.38	0.45
opened cursors cumulative	106,651,064	29,529.17	38.03
parse count (describe)	28	0.01	0.00
parse count (failures)	5,303	1.47	0.00
parse count (hard)	41,550	11.50	0.01
parse count (total)	2,391,974	662.28	0.85
parse time cpu	83,036	22.99	0.03
parse time elapsed	88,187	24.42	0.03
physical read IO requests	278,475	77.10	0.10
physical read bytes	2,287,673,344	633,402.92	815.67
physical read total IO requests	286,620	79.36	0.10
physical read total bytes	2,419,097,600	669,791.20	862.53
physical read total multi block requests	0	0.00	0.00
physical reads	279,256	77.32	0.10
physical reads cache	279,248	77.32	0.10
physical reads cache prefetch	782	0.22	0.00
physical reads direct	8	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	782	0.22	0.00
physical write IO requests	442,532	122.53	0.16
physical write bytes	21,685,796,864	6,004,286.84	7,732.11
physical write total IO requests	3,905,510	1,081.34	1.39
physical write total bytes	52,297,375,744	14,479,912.68	18,646.71
physical write total multi block requests	130,722	36.19	0.05
physical writes	2,647,196	732.95	0.94
physical writes direct	5,102	1.41	0.00
physical writes direct (lob)	4,757	1.32	0.00
physical writes direct temporary tablespace	1,582	0.44	0.00
physical writes from cache	2,642,094	731.53	0.94
physical writes non checkpoint	2,274,878	629.86	0.81
pinned buffers inspected	192	0.05	0.00
pinned cursors current	3,855	1.07	0.00
prefetch warmup blocks aged out before use	163	0.05	0.00
process last non-idle time	3,612	1.00	0.00
queries parallelized	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	193,470,714	53,567.49	68.98
recursive cpu usage	3,617,270	1,001.54	1.29
redo blocks checksummed by FG (exclusive)	13,368,902	3,701.53	4.77
redo blocks written	59,620,629	16,507.55	21.26
redo buffer allocation retries	6	0.00	0.00
redo entries	89,135,507	24,679.52	31.78
redo ordering marks	909,881	251.92	0.32
redo size	28,659,036,504	7,935,012.80	10,218.43
redo size for direct writes	172,380	47.73	0.06
redo subscn max counts	2,311,725	640.06	0.82
redo synch long waits	3,129	0.87	0.00
redo synch time	98,599	27.30	0.04
redo synch time (usec)	988,168,404	273,600.58	352.33
redo synch writes	1,585,826	439.08	0.57
redo wastage	874,007,520	241,992.12	311.63
redo write time	75,519	20.91	0.03
redo writes	2,109,879	584.18	0.75
rollback changes - undo records applied	451,997	125.15	0.16
rollbacks only - consistent read gets	21,636,843	5,990.73	7.71
root node splits	33	0.01	0.00
rows fetched via callback	102,623,968	28,414.16	36.59
session connect time	0	0.00	0.00
session cursor cache hits	87,731,462	24,290.78	31.28
session logical reads	4,405,685,314	1,219,830.59	1,570.85
shared hash latch upgrades - no wait	35,524,090	9,835.78	12.67
shared hash latch upgrades - wait	95,474	26.43	0.03
sorts (memory)	8,377,254	2,319.46	2.99
sorts (rows)	3,145,875,990	871,019.03	1,121.67
sql area evicted	23,251	6.44	0.01
sql area purged	3,122	0.86	0.00
summed dirty queue length	17,258	4.78	0.01
switch current to new buffer	383,344	106.14	0.14
table fetch by rowid	534,655,181	148,033.44	190.63
table fetch continued row	385,623,019	106,769.94	137.49
table scan blocks gotten	254,159,856	70,370.88	90.62
table scan rows gotten	7,103,645,257	1,966,832.21	2,532.82
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	4,646,993	1,286.64	1.66
temp space allocated (bytes)	827,326,464	229,067.23	294.98
total cf enq hold time	735	0.20	0.00
total number of cf enq holders	139	0.04	0.00
total number of times SMON posted	380	0.11	0.00
transaction rollbacks	38,475	10.65	0.01
transaction tables consistent read rollbacks	57	0.02	0.00
transaction tables consistent reads - undo records applied	3,194	0.88	0.00
undo change vector size	9,773,188,756	2,705,965.98	3,484.65
user I/O wait time	81,521	22.57	0.03
user calls	75,963,479	21,032.50	27.08
user commits	2,330,252	645.19	0.83
user rollbacks	474,391	131.35	0.17
workarea executions - optimal	7,426,153	2,056.13	2.65
write clones created in background	3,712	1.03	0.00
write clones created in foreground	322	0.09	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session pga memory max	121,450,440,160	134,642,193,248
session cursor cache count	2,667,930	4,809,320
session uga memory	8,204,511,270,056	8,489,801,563,688
opened cursors current	702,807	766,134
workarea memory allocated	7,618	14,229
logons current	9,587	10,393
session uga memory max	105,127,274,824	170,258,642,720
session pga memory	109,886,756,896	119,585,865,824

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)
LGWR	0M	0.00	0M	28.4G	957.57	8.06181	2110K	0.04
DBWR	0M	0.00	0M	20.2G	121.11	5.71306	0
Buffer Cache Reads	2.1G	77.06	.603590	0M	0.00	0M	278.3K	2.45
Others	126M	2.26	.034886	120M	2.76	.033225	9904	0.19
Direct Writes	0M	0.00	0M	1M	0.02	.000276	0
TOTAL:	2.3G	79.32	.638477	48.7G	1081.46	13.8083	2398.2K	0.32

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
Log File	0M	0.00	0M	28.4G	957.58	8.06181
Data File	2.1G	76.71	.599991	20.1G	120.34	5.70337	2.46
Control File	123M	2.19	.034055	82M	1.46	.022703	0.00
Temp File	12M	0.43	.003322	80M	2.14	.022150	0.04
TOTAL:	2.2G	79.32	.637369	48.7G	1081.52	13.8100	2.38

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)
LGWR	0M	0.00	0M	28.4G	957.56	8.06181	0
LGWR (Log File)	0M	0.00	0M	28.4G	957.56	8.06181	0
DBWR	0M	0.00	0M	20.2G	121.11	5.71306	0
DBWR (Data File)	0M	0.00	0M	20.2G	121.11	5.71306	0
Buffer Cache Reads	2.1G	77.06	.603590	0M	0.00	0M	278.3K	2.45
Buffer Cache Reads (Data File)	2.1G	77.06	.603590	0M	0.00	0M	278.3K	2.45
Others	126M	2.26	.034886	120M	2.76	.033225	8151	0.01
Others (Control File)	124M	2.19	.034332	82M	1.46	.022703	7899	0.00
Others (Data File)	2M	0.07	.000553	38M	1.30	.010521	252	0.12
Direct Writes	0M	0.00	0M	1M	0.02	.000276	0
Direct Writes (Data File)	0M	0.00	0M	1M	0.02	.000276	0
TOTAL:	2.3G	79.32	.638477	48.7G	1081.45	13.8083	286.5K	2.38

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
APPS_TS_TX_DATA	246,322	68	2.87	1.00	129,496	36	67,533	0.07
APPS_TS_TX_IDX	23,984	7	2.50	1.00	146,134	40	23,718	0.06
APPS_UNDOTS1	0	0	0.00	0.00	112,993	31	13,812	0.07
APPS_TS_QUEUES	20	0	3.00	1.00	25,005	7	1,164	0.11
APPS_TS_SEED	2,162	1	2.08	1.00	12,592	3	80	0.00
TEMP1	1,562	0	0.33	1.00	7,758	2	130	27.77
APPS_TS_SUMMARY	3,952	1	2.30	1.00	3,619	1	0	0.00
SYSAUX	395	0	0.91	1.00	2,295	1	27	0.00
APPS_TS_ARCHIVE	41	0	4.15	1.00	2,116	1	228	0.09
SYSTEM	7	0	4.29	1.00	464	0	342	0.18

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
APPS_TS_ARCHIVE	/ebizdata/data/archive_01.dbf	41	0	4.15	1.00	2,116	1	228	0.09
APPS_TS_QUEUES	/ebizdata/data/queues_01.dbf	20	0	3.00	1.00	25,005	7	1,164	0.11
APPS_TS_SEED	/ebizdata/data/reference_01.dbf	1,083	0	1.76	1.00	6,471	2	0	0.00
APPS_TS_SEED	/ebizdata/data/reference_02.dbf	1,079	0	2.40	1.00	6,121	2	80	0.00
APPS_TS_SUMMARY	/ebizdata/data/summary_01.dbf	3,952	1	2.30	1.00	3,619	1	0	0.00
APPS_TS_TX_DATA	/ebizdata/data/tx_data_01.dbf	61,165	17	3.09	1.00	36,814	10	22,181	0.06
APPS_TS_TX_DATA	/ebizdata/data/tx_data_02.dbf	60,372	17	2.36	1.00	19,167	5	533	0.08
APPS_TS_TX_DATA	/ebizdata/data/tx_data_03.dbf	61,540	17	2.95	1.00	37,072	10	23,525	0.05
APPS_TS_TX_DATA	/ebizdata/data/tx_data_04.dbf	63,245	18	3.05	1.00	36,443	10	21,294	0.10
APPS_TS_TX_IDX	/ebizdata/data/tx_idx_01.dbf	6,531	2	2.64	1.00	36,511	10	2,681	0.08
APPS_TS_TX_IDX	/ebizdata/data/tx_idx_02.dbf	6,303	2	2.49	1.00	36,843	10	3,519	0.06
APPS_TS_TX_IDX	/ebizdata/data/tx_idx_03.dbf	5,621	2	2.76	1.00	38,254	11	3,742	0.05
APPS_TS_TX_IDX	/ebizdata/data/tx_idx_04.dbf	5,529	2	2.08	1.00	34,526	10	13,776	0.06
APPS_UNDOTS1	/ebizdata/data/undo_01.dbf	0	0			67,338	19	7,807	0.06
APPS_UNDOTS1	/ebizdata/data/undo_03.dbf	0	0			45,655	13	6,005	0.09
SYSAUX	/ebizdata/data/sysaux_01.dbf	395	0	0.91	1.00	2,295	1	27	0.00
SYSTEM	/ebizdata/data/sys_01.dbf	7	0	4.29	1.00	464	0	342	0.18
TEMP1	/ebizdata/data/temp1_01.dbf	813	0	0.36	1.00	4,812	1	64	43.13
TEMP1	/ebizdata/data/temp1_02.dbf	749	0	0.31	1.00	2,946	1	66	12.88

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	7,291,977	100	4,396,905,725	279,232	2,641,286	0	0	107,067

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 2,647,196

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	2,632,311	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	350	229677	5177924	31257291	154581048	31257291
E	0	320	207900	5022704	29345860	154581048	29345860

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

No data exists for this section of the report.

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	374,276	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	16,384	1,024	96,881.21	8.15	0.01	100.00	0.00	1,048,576
E	16,384	1,024	108,102.68	15.20	0.01	100.00	0.00	1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	7,235,051	7,235,051
64K	128K	1,592	1,592
128K	256K	1,640	1,640
256K	512K	230	230
512K	1024K	48,525	48,525
1M	2M	23,816	23,816
2M	4M	99,735	99,735

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,048	0.13	525,280.82	100.00	1,160,008,499
4,096	0.25	525,280.82	100.00	1,160,008,499
8,192	0.50	525,280.82	100.00	1,160,008,499
12,288	0.75	525,280.82	100.00	1,160,008,499
16,384	1.00	525,280.82	100.00	1,160,008,499
19,661	1.20	525,280.82	100.00	1,160,008,499
22,938	1.40	525,280.82	100.00	1,160,008,499
26,214	1.60	525,280.82	100.00	1,160,008,499
29,491	1.80	525,280.82	100.00	1,160,008,499
32,768	2.00	525,280.82	100.00	1,160,008,499
49,152	3.00	525,280.82	100.00	1,160,008,499
65,536	4.00	525,280.82	100.00	1,160,008,499
98,304	6.00	525,280.82	100.00	1,160,008,499
131,072	8.00	525,280.82	100.00	1,160,008,499

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)
17,664	0.90	532	79,163	2,623,257	0.81	617,968	357.62	260,035
17,920	0.91	780	80,317	2,756,119	0.85	485,106	280.73	274,367
18,176	0.92	1,033	81,303	2,880,454	0.89	360,771	208.78	287,880
18,432	0.94	1,282	82,386	3,002,262	0.93	238,963	138.29	301,117
18,688	0.95	1,532	83,475	3,234,124	1.00	7,101	4.11	325,381
18,944	0.96	1,788	84,433	3,238,394	1.00	2,831	1.64	326,175
19,200	0.97	2,044	85,455	3,238,955	1.00	2,270	1.31	326,280
19,456	0.99	2,300	86,482	3,239,236	1.00	1,989	1.15	326,310
19,712	1.00	2,556	87,459	3,239,497	1.00	1,728	1.00	326,339
19,968	1.01	2,812	88,379	3,239,498	1.00	1,727	1.00	326,339
20,224	1.03	3,068	89,647	3,239,498	1.00	1,727	1.00	326,339
20,480	1.04	3,324	90,646	3,239,498	1.00	1,727	1.00	326,339
20,736	1.05	3,580	91,919	3,239,498	1.00	1,727	1.00	326,339
20,992	1.06	3,836	92,901	3,239,498	1.00	1,727	1.00	326,339
21,248	1.08	4,092	96,275	3,239,498	1.00	1,727	1.00	326,339
21,504	1.09	4,348	98,796	3,239,498	1.00	1,727	1.00	326,339
21,760	1.10	4,604	100,003	3,239,498	1.00	1,727	1.00	326,339
22,016	1.12	4,860	101,042	3,239,498	1.00	1,727	1.00	326,339
23,808	1.21	6,652	118,387	3,239,498	1.00	1,727	1.00	326,340
25,856	1.31	7,155	129,504	3,239,498	1.00	1,727	1.00	326,340
27,904	1.42	7,155	129,504	3,239,498	1.00	1,727	1.00	326,340
29,952	1.52	7,155	129,504	3,239,498	1.00	1,727	1.00	326,340
32,000	1.62	7,155	129,504	3,239,498	1.00	1,727	1.00	326,340
34,048	1.73	7,155	129,504	3,239,498	1.00	1,727	1.00	326,340
36,096	1.83	7,155	129,504	3,239,498	1.00	1,727	1.00	326,340
38,144	1.94	7,155	129,504	3,239,498	1.00	1,727	1.00	326,340
40,192	2.04	7,155	129,504	3,239,498	1.00	1,727	1.00	326,340

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)
30,720	0.38	107,928
35,840	0.44	107,928
40,960	0.50	107,929
46,080	0.56	107,930
51,200	0.63	107,931
56,320	0.69	107,943
61,440	0.75	107,944
66,560	0.81	107,946
71,680	0.88	107,946
76,800	0.94	107,948
81,920	1.00	107,926
87,040	1.06	107,948
92,160	1.13	107,950
97,280	1.19	107,951
102,400	1.25	107,953
107,520	1.31	107,965
112,640	1.38	107,970
117,760	1.44	107,946
122,880	1.50	107,973
128,000	1.56	107,974
133,120	1.63	107,985
138,240	1.69	107,986
143,360	1.75	107,986
148,480	1.81	107,987
153,600	1.88	107,988
158,720	1.94	107,989
163,840	2.00	107,990

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
256	0.50	0	0	0	0
512	1.00	0	0	0	0
768	1.50	0	0	0	0
1,024	2.00	0	0	0	0
1,280	2.50	0	0	0	0
1,536	3.00	0	0	0	0
1,792	3.50	0	0	0	0
2,048	4.00	0	0	0	0
2,304	4.50	0	0	0	0
2,560	5.00	0	0	0	0
2,816	5.50	0	0	0	0
3,072	6.00	0	0	0	0
3,328	6.50	0	0	0	0
3,584	7.00	0	0	0	0
3,840	7.50	0	0	0	0
4,096	8.00	0	0	0	0
4,352	8.50	0	0	0	0
4,608	9.00	0	0	0	0
4,864	9.50	0	0	0	0
5,120	10.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)	JP 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
1,792	1.00	12	451	19,034	1.00	1,729	1.00	90,303
2,048	1.14	12	451	19,034	1.00	1,729	1.00	90,304
2,304	1.29	12	451	19,034	1.00	1,729	1.00	90,304
2,560	1.43	12	451	19,034	1.00	1,729	1.00	90,304
2,816	1.57	12	451	19,034	1.00	1,729	1.00	90,304
3,072	1.71	12	451	19,034	1.00	1,729	1.00	90,304
3,328	1.86	12	451	19,034	1.00	1,729	1.00	90,304
3,584	2.00	12	451	19,034	1.00	1,729	1.00	90,304
3,840	2.14	12	451	19,034	1.00	1,729	1.00	90,304
4,096	2.29	12	451	19,034	1.00	1,729	1.00	90,304

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	90,562	6	0
file header block	131	4	27
undo header	5,789	1	0
undo block	8,031	0	0
1st level bmb	1,793	0	0
system undo header	212	0	0
segment header	533	0	0
system undo block	12	0	1
2nd level bmb	1	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	2,612	263	2,349	125	5	41.75
US-Undo Segment	1,074	1,074	0	364	1	2.66
HW-Segment High Water Mark	92,821	92,819	0	287	0	1.20
SQ-Sequence Cache	35,634	35,634	0	570	0	0.32
TX-Transaction (index contention)	10,338	10,338	0	667	0	0.24
TX-Transaction (allocate ITL entry)	111	111	0	16	0	0.13
FB-Format Block	39,006	39,005	0	11	0	0.18
TX-Transaction	2,772,571	2,773,813	0	3	0	0.67

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	1,524.22	2,750,237	1,892	1,024	2077.8/3448.2	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
15-Sep 18:55	253,696	458,737	1,688	1,024	2,078	0/0	0/0/0/0/0/0
15-Sep 18:45	250,695	457,531	1,837	1,024	2,254	0/0	0/0/0/0/0/0
15-Sep 18:35	256,448	461,453	1,892	1,010	2,463	0/0	0/0/0/0/0/0
15-Sep 18:25	257,533	462,805	1,765	952	2,724	0/0	0/0/0/0/0/0
15-Sep 18:15	240,792	437,539	1,800	844	3,053	0/0	0/0/0/0/0/0
15-Sep 18:05	265,060	472,172	1,729	766	3,448	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	3,005,681	0.01	0.08	0	0
AQ deq log cmt cbk chunk latch	286,457	0.04	0.00	0	0
AQ deq log statistics latch	54,759	0.00		0	0
AQ dequeue txn counter latch	381,017	0.18	0.00	0	0
AQ disk delete txn counter latch	108,540	0.00		0	0
AQ ht cmt cbk chunk latch	181,529	0.01	0.00	0	0
ASM db client latch	2,402	0.00		0	0
ASM map operation hash table	4	0.00		0	0
ASM network state latch	2,096	0.00		0	0
AWR Alerted Metric Element list	649,564	0.00		0	0
Change Notification Hash table latch	1,208	0.00		0	0
Consistent RBA	2,111,135	0.01	0.00	0	0
DML lock allocation	11,877,238	0.01	0.00	0	0
Event Group Locks	21,566	0.00		0	0
FOB s.o list latch	51,188	0.01	0.00	0	0
File State Object Pool Parent Latch	4	0.00		0	0
I/O Staticstics latch	4	0.00		0	0
IPC stats buffer allocation latch	4	0.00		0	0
In memory undo latch	35,952,521	0.01	0.61	0	1,275,869	0.20
JOX SGA heap latch	558,769	0.00	0.00	0	0
JS Sh mem access	12	0.00		0	0
JS queue access latch	4	0.00		0	0
JS queue state obj latch	21,630	0.00		0	0
JS slv state obj latch	244	0.41	0.00	0	0
KFC FX Hash Latch	4	0.00		0	0
KFC Hash Latch	4	0.00		0	0
KFCL LE Freelist	4	0.00		0	0
KGNFS-NFS:SHM structure	4	0.00		0	0
KGNFS-NFS:SVR LIST	4	0.00		0	0
KJC message pool free list	4	0.00		0	0
KJCT flow control latch	4	0.00		0	0
KMG MMAN ready and startup request latch	1,222	0.00		0	0
KMG resize request state object freelist	10	0.00		0	0
KTF sga latch	23	0.00		0	1,216	0.00
KWQMN job cache list latch	146,335	0.15	0.22	0	0
KWQP Prop Status	460	0.00		0	0
KWQS pqsubs latch	387,028	0.00		0	0
KWQS pqueue ctx latch	387,494	0.19	0.56	0	0
Locator state objects pool parent latch	4	0.00		0	0
Lsod array latch	4	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	142	0.00		0	1,209	0.00
Memory Queue	24	0.00		0	0
Memory Queue Message Subscriber #1	4	0.00		0	0
Memory Queue Message Subscriber #2	4	0.00		0	0
Memory Queue Message Subscriber #3	4	0.00		0	0
Memory Queue Message Subscriber #4	4	0.00		0	0
Memory Queue Subscriber	4	0.00		0	0
MinActiveScn Latch	40	0.00		0	0
Mutex	4	0.00		0	0
Mutex Stats	4	0.00		0	0
OS process	41,007	0.00		0	0
OS process allocation	28,128	0.04	0.00	0	0
OS process: request allocation	20,313	0.02	0.00	0	0
PL/SQL warning settings	4,023,886	0.04	0.00	0	0
PX hash array latch	4	0.00		0	0
QMT	4	0.00		0	0
Real-time plan statistics latch	23,168	0.00		0	0
SGA blob parent	4	0.00		0	0
SGA bucket locks	4	0.00		0	0
SGA heap locks	4	0.00		0	0
SGA pool locks	4	0.00		0	0
SQL memory manager latch	4	0.00		0	1,197	0.00
SQL memory manager workarea list latch	6,688,573	0.00	0.00	0	0
Shared B-Tree	778,718	0.00	0.00	0	0
Streams Generic	4	0.00		0	0
Testing	4	0.00		0	0
Token Manager	4	0.00		0	0
WCR: sync	4	0.00		0	0
Write State Object Pool Parent Latch	4	0.00		0	0
X$KSFQP	4	0.00		0	0
XDB NFS Security Latch	4	0.00		0	0
XDB unused session pool	4	0.00		0	0
XDB used session pool	4	0.00		0	0
active checkpoint queue latch	449,682	0.24	0.00	0	0
active service list	69,592	0.03	0.73	0	4,284	0.02
begin backup scn array	3,194	0.00		0	0
bq:time manger info latch	129	0.00		0	0
buffer pool	14	0.00		0	0
bufq statistics	20	0.00		0	0
business card	4	0.00		0	0
cache buffer handles	4,650,222	0.09	0.00	0	0
cache buffers chains	8,715,733,581	1.56	0.01	25	39,071,511	0.08
cache buffers lru chain	3,999,336	0.01	0.03	0	77,835,814	0.08
call allocation	1,423,232	0.17	0.01	0	0
cas latch	4	0.00		0	0
change notification client cache latch	4	0.00		0	0
channel handle pool latch	26,998	0.04	0.00	0	0
channel operations parent latch	58,372	0.01	0.00	0	0
checkpoint queue latch	80,536,178	0.00	0.00	0	2,610,547	0.00
client/application info	3,189,183	0.00	0.00	0	0
compile environment latch	11,199	0.00		0	0
corrupted undo seg latch	1,393,679	0.00	0.00	0	0
cp cmon/server latch	4	0.00		0	0
cp pool latch	4	0.00		0	0
cp server hash latch	4	0.00		0	0
cp sga latch	2,096	0.00		0	0
cvmap freelist lock	4	0.00		0	0
deferred cleanup latch	2,096	0.00		0	0
dml lock allocation	2,832	0.00		0	0
done queue latch	4	0.00		0	0
dummy allocation	21,591	0.10	0.00	0	0
enqueue freelist latch	4	0.00		0	968,701	0.00
enqueue hash chains	18,513,426	0.07	0.00	0	0
enqueues	5,492	0.15	0.00	0	0
fifth spare latch	4	0.00		0	0
file cache latch	18,783	0.01	0.00	0	0
flashback copy	4	0.00		0	0
fourth Audit Vault latch	4	0.00		0	0
gc element	4	0.00		0	0
gcs commit scn state	4	0.00		0	0
gcs partitioned table hash	4	0.00		0	0
gcs pcm hashed value bucket hash	4	0.00		0	0
gcs resource freelist	4	0.00		0	0
gcs resource hash	4	0.00		0	0
gcs resource scan list	4	0.00		0	0
gcs shadows freelist	4	0.00		0	0
ges domain table	4	0.00		0	0
ges enqueue table freelist	4	0.00		0	0
ges group table	4	0.00		0	0
ges process hash list	4	0.00		0	0
ges process parent latch	4	0.00		0	0
ges resource hash list	4	0.00		0	0
ges resource scan list	4	0.00		0	0
ges resource table freelist	4	0.00		0	0
ges value block free list	4	0.00		0	0
global KZLD latch for mem in SGA	10,976	0.00		0	0
global ctx hash table latch	3,464,674	0.02	0.00	0	0
global tx hash mapping	4	0.00		0	0
granule operation	4	0.00		0	0
hash table column usage latch	1,094	0.00		0	42,884	0.00
hash table modification latch	3	0.00		0	0
heartbeat check	4	0.00		0	0
internal temp table object number allocation latch	12	0.00		0	0
intra txn parallel recovery	4	0.00		0	0
io pool granule metadata list	4	0.00		0	0
job workq parent latch	69	0.00		0	65	0.00
job_queue_processes free list latch	130	0.00		0	0
job_queue_processes parameter latch	845	0.00		0	0
k2q lock allocation	4	0.00		0	0
kdlx hb parent latch	4	0.00		0	0
kgb parent	4	0.00		0	0
kgnfs mount latch	4	0.00		0	0
kokc descriptor allocation latch	5,487,808	1.34	0.00	0	0
ksfv messages	4	0.00		0	0
ksim group membership cache	4	0.00		0	0
kss move lock	80	0.00		0	0
ksuosstats global area	373	0.00		0	0
ksv allocation latch	2,247	0.00		0	0
ksv class latch	156	0.64	0.00	0	0
ksv msg queue latch	4	0.00		0	0
ksz_so allocation latch	20,313	0.06	0.00	0	0
ktm global data	1,537	0.00		0	0
kwqbsn:qsga	2,234	0.13	0.00	0	0
lgwr LWN SCN	2,113,890	0.07	0.00	0	0
list of block allocation	300,975	0.01	0.00	0	0
loader state object freelist	14,274	0.01	0.00	0	0
lob segment dispenser latch	4	0.00		0	0
lob segment hash table latch	16	0.00		0	0
lob segment query latch	4	0.00		0	0
lock DBA buffer during media recovery	4	0.00		0	0
logical standby cache	4	0.00		0	0
logminer context allocation	8	0.00		0	0
logminer work area	4	0.00		0	0
longop free list parent	4	0.00		0	0
mapped buffers lru chain	4	0.00		0	0
message pool operations parent latch	28	0.00		0	0
messages	7,530,349	0.21	0.00	0	0
mostly latch-free SCN	2,321,579	5.44	0.00	0	0
msg queue latch	4	0.00		0	0
multiblock read objects	932	0.00		0	0
name-service namespace bucket	4	0.00		0	0
ncodef allocation latch	2,096	0.00		0	0
object queue header heap	24,549,985	0.00	0.17	0	247,843	0.01
object queue header operation	268,193,883	0.39	0.00	0	0
object stats modification	13,788	0.01	0.00	0	0
parallel query alloc buffer	12,856	0.00		0	0
parallel query stats	4	0.00		0	0
parameter list	88,543	0.03	0.00	0	0
parameter table management	6,625,595	0.28	0.07	0	0
peshm	4	0.00		0	0
pesom_free_list	2,964,956	0.01	0.00	0	0
pesom_hash_node	4,375,194	0.01	0.00	0	0
pesom_heap_alloc	18,927	0.00		0	0
post/wait queue	13,405,714	0.01	0.00	0	1,530,605	0.03
process allocation	20,471	0.51	0.88	1	10,352	0.11
process group creation	20,313	0.00	0.00	0	0
process queue	4	0.00		0	0
process queue reference	4	0.00		0	0
qmn task queue latch	3,904	0.67	0.00	0	0
query server freelists	4	0.00		0	0
queued dump request	12	0.00		0	0
queuing load statistics	4	0.00		0	0
recovery domain hash list	4	0.00		0	0
redo allocation	63,049,383	0.19	0.00	0	88,931,416	1.21
redo copy	4	0.00		0	89,106,169	0.21
redo writing	8,119,276	0.04	0.00	0	0
resmgr group change latch	11,112	0.00		0	0
resmgr:active threads	21,591	0.00		0	0
resmgr:actses change group	11,083	0.00		0	0
resmgr:actses change state	4	0.00		0	0
resmgr:free threads list	21,586	0.18	0.00	0	0
resmgr:plan CPU method	4	0.00		0	0
resmgr:resource group CPU method	4	0.00		0	0
resmgr:schema config	4	0.00		0	0
resmgr:session queuing	4	0.00		0	0
rm cas latch	4	0.00		0	0
row cache objects	111,256,857	1.33	0.01	2	1,633	0.31
rules engine aggregate statistics	276,950	0.03	0.00	0	0
rules engine rule set statistics	831,244	0.03	0.00	0	0
rules engine rule statistics	276,949	0.00	0.00	0	0
second Audit Vault latch	4	0.00		0	0
second spare latch	4	0.00		0	0
sequence cache	4,266,117	0.28	0.00	0	0
session allocation	6,281,179	0.00	0.63	0	6,256,079	0.25
session idle bit	158,135,119	0.00	0.00	0	0
session queue latch	4	0.00		0	0
session state list latch	65,259	0.18	0.55	0	0
session switching	12,422	0.01	0.00	0	0
session timer	2,258	0.00		0	0
shared pool	29,284,573	0.28	0.01	1	0
shared pool sim alloc	2,712	0.00		0	0
shared pool simulator	87,106	0.00		0	0
sim partition latch	4	0.00		0	0
simulator hash latch	19,744	0.00		0	0
simulator lru latch	36,734	0.00		0	0
sort extent pool	413,151	0.52	0.00	0	0
space background state object latch	34	0.00		0	0
space background task latch	25,714	16.46	0.37	0	2,769	0.54
state object free list	8	0.00		0	0
statistics aggregation	1,344	0.00		0	0
tablespace key chain	4	0.00		0	0
temp lob duration state obj allocation	8	0.00		0	0
temporary table state object allocation	1,156	0.00		0	0
test excl. parent l0	4	0.00		0	0
test excl. parent2 l0	4	0.00		0	0
third spare latch	4	0.00		0	0
threshold alerts latch	733	0.00		0	0
trace latch	672	0.00		0	0
transaction allocation	3,836,019	0.00	0.00	0	0
undo global data	89,872,072	0.14	0.00	0	21,785	0.24
virtual circuit buffers	4	0.00		0	0
virtual circuit holder	4	0.00		0	0
virtual circuit queues	4	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	8,715,733,581	136,094,524	850,834	133,334,659
row cache objects	111,256,857	1,478,561	12,630	1,467,523
object queue header operation	268,193,883	1,048,048	1,691	1,046,409
mostly latch-free SCN	2,321,579	126,289	125	126,164
undo global data	89,872,072	125,102	46	125,057
redo allocation	63,049,383	118,537	46	118,491
shared pool	29,284,573	82,698	1,040	81,712
kokc descriptor allocation latch	5,487,808	73,274	244	73,037
parameter table management	6,625,595	18,818	1,363	17,457
messages	7,530,349	15,477	4	15,473
enqueue hash chains	18,513,426	12,796	5	12,791
sequence cache	4,266,117	11,839	5	11,834
In memory undo latch	35,952,521	4,797	2,921	1,969
space background task latch	25,714	4,233	1,564	2,741
session idle bit	158,135,119	3,886	8	3,878
redo writing	8,119,276	2,993	1	2,992
call allocation	1,423,232	2,433	25	2,408
DML lock allocation	11,877,238	1,140	1	1,139
KWQS pqueue ctx latch	387,494	736	412	338
cache buffers lru chain	3,999,336	462	14	448
AQ deq hash table latch	3,005,681	312	24	289
KWQMN job cache list latch	146,335	220	48	172
session state list latch	65,259	116	64	53
process allocation	20,471	105	92	14
session allocation	6,281,179	100	63	37
active service list	69,592	22	16	7
object queue header heap	24,549,985	18	3	15

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
AQ deq hash table latch	kwqdlChkInsHt: check and insert	12	20
AQ deq hash table latch	kwqdlDelHt: delete elements	12	3
DML lock allocation	ktaiam	1	0
In memory undo latch	ktiFlush: child	1,512	803
In memory undo latch	kticmt: child	1,227	396
In memory undo latch	ktichg: child	218	959
In memory undo latch	ktiFlushMe	89	49
In memory undo latch	kturbk	21	886
In memory undo latch	ktigetmypoollatch_2	13	0
In memory undo latch	ktiTxnPoolFree	10	2
In memory undo latch	ktbgfc	6	4
In memory undo latch	ktiBRacquire	2	0
In memory undo latch	ktiFlushTopTxn	1	0
KWQMN job cache list latch	kwqmnuji: update job item	134	135
KWQMN job cache list latch	kwqmngti: get index	1	0
KWQS pqueue ctx latch	kwqspqcbkf: updatepqs	546	546
PC and Classifier lists for WLM	No latch	281	0
active service list	kswslogon: session logout	8	7
active service list	kswsclstabc: scan list to return rows	5	2
active service list	kswsgsnp: get service name ptr	4	4
active service list	kswsite: service iterator	1	0
cache buffers chains	kcbchg1: mod cr pin	697,766	248,329
cache buffers chains	kcbgtcr: fast path (cr pin)	278,188	176,469
cache buffers chains	kcbgtcr: kslbegin excl	21,130	50,080
cache buffers chains	kcbgtcr_2	20,066	8,434
cache buffers chains	kcbgtcr: fast path	16,963	1,404
cache buffers chains	kcbrls: fast release	12,279	185,038
cache buffers chains	kcbrls_2	4,702	225,763
cache buffers chains	kcbgcur_2	3,732	1,250
cache buffers chains	kcbzwb	3,514	5,097
cache buffers chains	kcbchg1: clear MS bit	1,078	30,097
cache buffers chains	kcbget: fast exchange	998	379
cache buffers chains	kcbgcur: fast path (shr)	813	244
cache buffers chains	kcbcge	808	116,926
cache buffers chains	kcbget: pin buffer	502	339
cache buffers chains	kcbzar_fpin_1	186	2,462
cache buffers chains	kcbnlc	124	459
cache buffers chains	kcbget: fast path	100	91
cache buffers chains	kcbrls_1	79	4,045
cache buffers chains	kcbgkcbcr	68	552
cache buffers chains	kcb_trim_hash_chain	54	100
cache buffers chains	kcbzgb: scan from tail. nowait	48	0
cache buffers chains	kcbgcur_4	34	388
cache buffers chains	kcbchg1: aux pin	32	68
cache buffers chains	kcbnew: new latch again	32	0
cache buffers chains	kcbso1: set no access	24	137
cache buffers chains	kcbbxsv	21	3
cache buffers chains	kcb_is_private	18	1,521
cache buffers chains	kcbesc: escalate	17	2
cache buffers chains	kcbchg1: mod cur pin	15	1,982
cache buffers chains	kcbget: release shr	11	74
cache buffers chains	kcbzar_fpin_2	8	27
cache buffers chains	kcbget: exchange	7	1,009
cache buffers chains	kcbget: release excl	6	853
cache buffers chains	kcbget_1	6	1
cache buffers chains	kcb_pre_apply: kcbhq61	3	244
cache buffers chains	kcbgtcr_1	3	0
cache buffers chains	kcbzpbuf	2	286
cache buffers chains	kcb_post_apply: kcbhq62	1	53
cache buffers chains	kcbbic2	1	3
cache buffers chains	kcbgtcr: kslbegin shared	1	0
cache buffers chains	kcbo_ivd_process	1	0
cache buffers lru chain	kcbzgws	12	0
cache buffers lru chain	kcbo_link_q	2	0
call allocation	ksuxds	25	2
client/application info	ksuinfos_cinfo	1	0
client/application info	ksuinfos_modact	1	0
enqueue hash chains	ksqgtl3	3	3
enqueue hash chains	ksqrcl	2	2
kokc descriptor allocation latch	kokcdlt: regular free	183	103
kokc descriptor allocation latch	kokcdlt: allocation	61	141
lgwr LWN SCN	kcs023	7	0
messages	ksaamb: after wakeup	2	1
messages	ksarcv	1	2
messages	ksarcv: after wait	1	1
mostly latch-free SCN	kcslcu3	116	123
object queue header heap	kcbo_check_flist	3	0
object queue header operation	kcbo_ivbo	1,567	682
object queue header operation	kcbo_switch_mq_bg	58	168
object queue header operation	kcbo_switch_q_bg	54	161
object queue header operation	kcbo_unlink_q	39	27
object queue header operation	kcbo_link_q	25	68
object queue header operation	kcbo_switch_cq	18	62
object queue header operation	kcbo_link_q:reget	1	4
parameter table management	kspcpy	785	1
parameter table management	ksp_param_table_free	701	2
parameter table management	kspptval	14	1,506
parameter table management	kspallmod	10	0
process allocation	ksucrp:1	89	0
process allocation	ksu_reserve	1	0
process allocation	ksuapc	1	100
process allocation	ksudlp	1	8
redo allocation	kcrfw_redo_gen: redo allocation 1	46	0
redo writing	kcrfwcr	1	1
row cache objects	kqrpre: find obj	6,329	4,978
row cache objects	kqreqd: reget	4,040	3,454
row cache objects	kqreqd	2,222	4,111
row cache objects	kqrcmt: while loop	13	26
row cache objects	kqrpre: init complete	6	8
row cache objects	kqrget	5	8
row cache objects	kqrcmt: clear flag	4	30
row cache objects	kqrso	4	5
sequence cache	kdnssd	3	2
sequence cache	kdnnxt: cached seq	2	0
session allocation	kspallmod	61	0
session allocation	ksucri_int : SSO	1	80
session allocation	ksuxds	1	46
session idle bit	ksupuc: set busy	6	2
session idle bit	ksupuc: clear busy	2	8
session state list latch	kpseqd	62	1
session state list latch	kpscad	2	0
shared pool	kghalo	527	403
shared pool	kghfre	245	237
shared pool	kghupr1	228	379
shared pool	kghnospc request bits	21	0
shared pool	kghalp	17	19
shared pool	kghfrunp: clatch: nowait	2	0
shared pool	kghasp	1	2
shared pool	kghfrunp: alloc: session dur	1	0
space background task latch	ktsj_grab_task	1,282	1,564
space background task latch	ktsj_detach_task	1	0
undo global data	ktuswr_3	27	0
undo global data	ktudba: KSLBEGIN	8	32
undo global data	ktucof: at start	5	0
undo global data	ktudnx:child	3	2
undo global data	kturax	1	0
undo global data	ktusm AvailCache Manipulation	1	1
undo global data	ktusmupst: KSLBEGIN	1	10

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kglget1 1	1,141,812
Library Cache	kglpndl1 95	543,931
Library Cache	kglpin1 4	331,829
Library Cache	kglpnal1 90	84,645
Library Cache	kglhdgn1 62	16,115
Library Cache	kgllkdl1 85	14,070
Cursor Pin	kksfbc [KKSCHLFSP2]	12,007
Library Cache	kglhdgn2 106	10,821
Library Cache	kglobpn1 71	2,740
Library Cache	kgllkc1 57	2,537
Library Cache	kglget2 2	781
Library Cache	kglGetHandleReference 124	769
Cursor Pin	kksfbc [KKSCHLPIN1]	590
Cursor Pin	kksLockDelete [KKSCHLPIN6]	236
Cursor Parent	kkscsAddChildNode [KKSPRTLOC34]	212
Cursor Pin	kksxsccmp [KKSCHLPIN5]	190
Cursor Pin	kkslce [KKSCHLPIN2]	125
Library Cache	kglhdgh1 64	71
Library Cache	kglhbh1 63	45
Library Cache	kglReleaseHandleReference 125	30
Library Cache	kgldtin1 42	21
Library Cache	kglic1 49	7
Library Cache	kglati1 45	2
Library Cache	kglini1 32	1
Library Cache	kgllldl2 112	1
Library Cache	kglnti1 46	1
hash table	kkscsSearchChildList [KKSHBKLOC2]	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: 4,405,685,314
Captured Segments account for 90.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
CS	APPS_TS_TX_DATA	CS_INCIDENTS_ALL_B	TABLE	2,992,049,776	67.91
JTF	APPS_TS_TX_IDX	JTF_TASKS_B_N1	INDEX	451,927,392	10.26
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK	INDEX	101,127,552	2.30
CS	APPS_TS_TX_DATA	CS_CF_SOURCE_CXT_TARGETS	TABLE	51,245,056	1.16
APPLSYS	APPS_TS_TX_IDX	FND_PROFILE_OPTION_VALUES_U1	INDEX	41,940,736	0.95

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 279,256
Captured Segments account for 0.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
AR	APPS_TS_TX_IDX	HZ_PARTIES_U1		INDEX	684	0.24
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_424395205_135	TABLE PARTITION	83	0.03
ICX	APPS_TS_TX_IDX	ICX_SESSIONS_N1		INDEX	43	0.02
ICX	APPS_TS_TX_IDX	ICX_SESSIONS_U1		INDEX	37	0.01
JTF	APPS_TS_TX_DATA	JTF_TASK_ASSIGNMENTS		TABLE	25	0.01

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 278,475
Captured Segments account for 0.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Read Requests	%Total
AR	APPS_TS_TX_IDX	HZ_PARTIES_U1		INDEX	684	0.25
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_424395205_135	TABLE PARTITION	83	0.03
ICX	APPS_TS_TX_IDX	ICX_SESSIONS_N1		INDEX	43	0.02
ICX	APPS_TS_TX_IDX	ICX_SESSIONS_U1		INDEX	37	0.01
JTF	APPS_TS_TX_DATA	JTF_TASK_ASSIGNMENTS		TABLE	25	0.01

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 278,475
Captured Segments account for 0.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	UnOptimized Reads	%Total
AR	APPS_TS_TX_IDX	HZ_PARTIES_U1		INDEX	684	0.25
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_424395205_135	TABLE PARTITION	83	0.03
ICX	APPS_TS_TX_IDX	ICX_SESSIONS_N1		INDEX	43	0.02
ICX	APPS_TS_TX_IDX	ICX_SESSIONS_U1		INDEX	37	0.01
JTF	APPS_TS_TX_DATA	JTF_TASK_ASSIGNMENTS		TABLE	25	0.01

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: 2,647,196
Captured Segments account for 33.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK	INDEX	365,368	13.80
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ATTRIBUTE_VALUES	TABLE	207,156	7.83
APPLSYS	APPS_TS_QUEUES	WF_DEFERRED	TABLE	33,293	1.26
CS	APPS_TS_TX_DATA	CS_INCIDENTS_AUDIT_B	TABLE	31,372	1.19
ICX	APPS_TS_TX_IDX	ICX_SESSION_ATTRIBUTES_U1	INDEX	20,434	0.77

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 442,532
Captured Segments account for 43.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK		INDEX	86,287	19.50
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ATTRIBUTE_VALUES		TABLE	28,893	6.53
APPLSYS	APPS_TS_QUEUES	WF_DEFERRED		TABLE	8,052	1.82
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_PK	WF_ITEM66	INDEX PARTITION	6,500	1.47
CS	APPS_TS_TX_DATA	CS_INCIDENTS_ALL_B		TABLE	5,556	1.26

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 5,102
Captured Segments account for 63.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
APPLSYS	APPS_TS_QUEUES	SYS_LOB0000181457C00040$$		LOB	3,164	62.01
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_424395205_135	TABLE PARTITION	89	1.74
SYS	SYSAUX	SYS_LOB0000006316C00004$$		LOB	3	0.06

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
CS	APPS_TS_TX_DATA	CS_INCIDENTS_ALL_B		TABLE	68,028,400	50.42
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ATTRIBUTE_VALUES		TABLE	24,351,744	18.05
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK		INDEX	23,768,688	17.62
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_N1		INDEX	2,558,368	1.90
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ACTIVITY_STATUSES	WF_ITEM66	TABLE PARTITION	2,014,496	1.49

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK	INDEX	4,988	46.46
APPLSYS	APPS_TS_TX_DATA	FND_CONCURRENT_REQUESTS	TABLE	1,321	12.30
CS	APPS_TS_TX_DATA	CS_INCIDENTS_ALL_B	TABLE	1,023	9.53
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_N4	INDEX	427	3.98
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_N3	INDEX	422	3.93

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
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK		INDEX	28	35.90
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_N4		INDEX	7	8.97
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_PK	WF_ITEM66	INDEX PARTITION	6	7.69
APPLSYS	APPS_TS_QUEUES	SYS_IOT_TOP_146294		INDEX	5	6.41
APPLSYS	APPS_TS_TX_IDX	WF_ITEMS_N2		INDEX	5	6.41

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
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ATTRIBUTE_VALUES		TABLE	42,920	47.18
CS	APPS_TS_TX_DATA	CS_INCIDENTS_ALL_B		TABLE	13,664	15.02
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_N1		INDEX	12,276	13.50
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ACTIVITY_STATUSES	WF_ITEM66	TABLE PARTITION	4,188	4.60
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK		INDEX	3,341	3.67

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	83	1.20	8	1
dc_global_oids	8,536,446	0.00	0	42
dc_histogram_data	632	30.70	0	163
dc_histogram_defs	19,734	17.53	0	567
dc_object_grants	1,677	0.89	0	43
dc_objects	9,238,775	0.01	0	864
dc_profiles	11,040	0.01	0	1
dc_rollback_segments	769,510	0.05	1,104	1,028
dc_segments	703,671	0.29	1,865	628
dc_sequences	35,061	0.08	35,061	24
dc_tablespaces	3,789,215	0.00	0	55
dc_users	14,770,246	0.00	0	112
global database name	13,704	0.01	0	1
outstanding_alerts	320	16.56	0	53

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	21,952	0.02	0		0	0
APP CONTEXT	22,162	0.00	3,986,005	-0.00	0	0
BODY	873,950	0.00	64,483,122	-0.05	1,646	0
CLUSTER	51	1.96	51	1.96	0	0
CONTEXT POLICY	171,430	0.00	161,366	0.00	0	0
DBLINK	21,954	0.01	0		0	0
DIRECTORY	48	2.08	48	2.08	0	0
EDITION	11,297	0.02	22,338	0.02	0	0
INDEX	95	31.58	95	31.58	0	0
JAVA DATA	4,402	0.00	10,526	0.00	0	0
PIPE	1,068	0.00	1,069	0.00	0	0
QUEUE	18,016	0.02	493,407	0.00	6	0
RULESET	6,659	0.00	276,951	0.00	0	0
SCHEMA	11,317	0.00	0		0	0
SQL AREA	1,011,297	3.48	133,974,849	0.02	6,439	3,127
SQL AREA BUILD	42,301	85.12	0		0	0
SQL AREA STATS	39,096	91.99	39,096	91.99	0	0
SUBSCRIPTION	6,657	0.00	6,657	0.00	0	0
TABLE/PROCEDURE	22,658,180	-0.01	81,995,103	-0.11	2,791	0
TRIGGER	13	0.00	74	1.35	1	0
XML SCHEMA	1,544	0.00	2,316	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)	Oper Count	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT buffer cache	60,416.00	59,136.00	59,136.00	64,000.00	5	SHR/IMM
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	16,384.00	16,384.00	16,384.00	16,384.00	0	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	81,920.00	81,920.00	81,920.00	81,920.00	0	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	0	STA/
java pool	1,792.00	1,792.00	256.00	1,792.00	0	GRO/IMM
large pool	256.00	256.00	0.00	256.00	0	GRO/IMM
shared pool	18,432.00	19,712.00	16,384.00	19,712.00	5	GRO/IMM
streams pool	512.00	512.00	0.00	512.00	0	GRO/IMM

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

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

Component	Min Size (Mb)	Max Size (Mb)	Avg Size (Mb)	Re- Sizes	Grows	Shrinks
DEFAULT buffer cache	59,136.00	60,160.00	59,648.00	5	0	5
shared pool	18,688.00	19,712.00	19,200.00	5	5	0

Back to Memory Statistics
Back to Top

Memory Resize Ops

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

Start	Component	Oper Typ/Mod	Init Size (M)	Delta	Final (M)	Sta
09/15 18:06:14	bufcache	SHR/IMM	59,392	-256	59,136	COM
09/15 18:06:14	shared	GRO/IMM	19,456	256	19,712	COM
09/15 18:02:35	bufcache	SHR/IMM	59,648	-256	59,392	COM
09/15 18:02:35	shared	GRO/IMM	19,200	256	19,456	COM
09/15 18:02:14	bufcache	SHR/IMM	59,904	-256	59,648	COM
09/15 18:02:14	shared	GRO/IMM	18,944	256	19,200	COM
09/15 18:01:50	bufcache	SHR/IMM	60,160	-256	59,904	COM
09/15 18:01:50	shared	GRO/IMM	18,688	256	18,944	COM
09/15 18:01:31	bufcache	SHR/IMM	60,416	-256	60,160	COM
09/15 18:01:31	shared	GRO/IMM	18,432	256	18,688	COM

Back to Memory Statistics
Back to Top

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	53,202.21		10.64	2.25	32	32	5,001	5,001
B	PL/SQL	30,026.07	24,397.60	6.00	1.39	7	7	5,001	5,001
B	Freeable	6,967.50	0.00	1.43	0.62	23		4,873	4,873
B	SQL	5,986.53	347.94	1.20	0.29	3	6	4,983	4,979
B	JAVA	810.65	809.42	4.11	13.14	188	196	197	197
E	Other	58,349.15		10.78	2.33	33	33	5,415	5,415
E	PL/SQL	32,502.34	23,558.49	6.00	1.41	7	7	5,415	5,415
E	Freeable	9,995.94	0.00	1.88	1.04	33		5,305	5,305
E	SQL	6,602.31	73.15	1.22	0.30	4	6	5,397	5,391
E	JAVA	737.89	736.63	4.27	14.02	188	196	173	173

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	63,350,767,616	62,008,590,336
Fixed Size	2,168,728
Redo Buffers	176,775,168
Variable Size	22,011,709,544	23,353,886,824

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	JOXLE	20.12	20.12	0.00
java	free memory	1,771.02	1,771.02	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	248.19	248.19	0.00
shared	ASH buffers	254.00	254.00	0.00
shared	Checkpoint queue	216.21	216.21	0.00
shared	KGLH0	365.09	771.77	111.39
shared	KKSSP	2,256.15	2,499.35	10.78
shared	PLMCD	305.46	309.86	1.44
shared	SQLA	891.71	2,143.56	140.39
shared	db_block_hash_buckets	356.00	356.00	0.00
shared	dirty object counts array	216.00	216.00	0.00
shared	free memory	11,764.14	11,018.60	-6.34
shared	parameter table block	201.08	218.06	8.44
streams	free memory	508.76	508.78	0.00
	buffer_cache	60,416.00	59,136.00	-2.12
	fixed_sga	2.07	2.07	0.00
	log_buffer	168.59	168.59	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 Slaves	0914 13:46:13	41.27	0.00	0.00
QMON Coordinator	0914 13:46:03	0.14	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

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

Queue Name	Enq Msgs	Enq Msgs/sec	Deq Msgs	Deq Msgs/sec	Spill Msgs	Spill Msgs/sec	%Spill Msgs
APPLSYS.WF_CONTROL(423650)	0	0.00	0	0.00	0	0.00

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

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

Subscriber/Queue	Enq Msgs	Enq Msgs/sec	Deq Msgs	Deq Msgs/sec	Spill Msgs	Spill Msgs/sec	%Spill Msgs
WFBESCL_21142(17411)/APPLSYS.WF_CONTROL	0	0.00	0	0.00	0	0.00
WFBESCL_21143(17410)/APPLSYS.WF_CONTROL	0	0.00	0	0.00	0	0.00
WFBESCL_21144(17409)/APPLSYS.WF_CONTROL	0	0.00	0	0.00	0	0.00

Back to Streams Statistics
Back to Top

Rule Set

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

Rule	Evals	CPU(s)	Ela(s)	Eval /Sec
APPLSYS.WF_DEFERRED_R	215,504	200.64	341.40	59.67
APPLSYS.WF_JAVA_DEFERRED_R	60,199	31.76	42.17	16.67
APPLSYS.WF_NOTIFICATION_OUT_R	1,582	0.17	0.24	0.44

Back to Streams Statistics
Back to Top

Persistent Queues

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

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
APPLSYS.FND_CP_GSM_IPC_AQ(425717)	0	0			0.00	0.00
APPLSYS.FND_CP_GSM_OPP_AQ(423855)	56	0	100.00	0.00	0.06	0.00	0.00	0.00
APPLSYS.WF_CONTROL(423650)	0	0			0.00	0.00
APPLSYS.WF_DEFERRED(423674)	215,503	0	0.00	0.00	602.24	54.61	0.00	65.05
APPLSYS.WF_ERROR(423830)	2,028	1,694	0.00	0.00	1.64	1.31	0.00	0.00
APPLSYS.WF_JAVA_DEFERRED(423754)	60,199	0	0.00	0.00	108.15	2,448.63	0.00	46.71
APPLSYS.WF_NOTIFICATION_OUT(423750)	1,582	0	0.00	0.00	8.55	0.00	0.00	6.44

Back to Streams Statistics
Back to Top

Persistent Queues Rate

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

Queue Name	Enqueue Msgs/sec	Dequeue Msgs/sec	Avg Enqueue sec / msg	Avg Dequeue sec / msg
APPLSYS.FND_CP_GSM_IPC_AQ(425717)	0.00	0.00
APPLSYS.FND_CP_GSM_OPP_AQ(423855)	0.02	0.00	0.00
APPLSYS.WF_CONTROL(423650)	0.00	0.00
APPLSYS.WF_DEFERRED(423674)	59.67	0.00	0.00
APPLSYS.WF_ERROR(423830)	0.56	0.47	0.00	0.00
APPLSYS.WF_JAVA_DEFERRED(423754)	16.67	0.00	0.00
APPLSYS.WF_NOTIFICATION_OUT(423750)	0.44	0.00	0.01

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

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

Subscriber/Queue	Enqueue Msgs	Dequeue Msgs	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
FNDCPGSMIPC_CARTRIDGE_1598054(264)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0
FNDCPGSMIPC_CARTRIDGE_1598055(266)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0
FNDCPGSMIPC_CARTRIDGE_1598056(268)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0
FNDCPGSMIPC_CARTRIDGE_1598057(270)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0
FNDCPGSMIPC_SERVICE_1598049(255)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1598050(257)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1598051(259)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1598052(261)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1598053(263)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1598054(265)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1598055(267)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1598056(269)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1598057(271)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1598058(273)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1598059(275)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1598060(277)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1598061(279)/APPLSYS.FND_CP_GSM_IPC_AQ	0	0	0.00	0.00	0.00
OPP1598058(978)/APPLSYS.FND_CP_GSM_OPP_AQ	0	0
WFBESCL_21142(17411)/APPLSYS.WF_CONTROL	0	0	0.00	0.00	0.00
WFBESCL_21143(17410)/APPLSYS.WF_CONTROL	0	0	0.00	0.00	0.00
WFBESCL_21144(17409)/APPLSYS.WF_CONTROL	0	0	0.00	0.00	0.00
WF_DEFERRED(1)/APPLSYS.WF_DEFERRED	215,503	81,145	59.67	22.47	0.00
WF_ERROR(3)/APPLSYS.WF_ERROR	2,028	2,012	0.56	0.56	0.00
WF_JAVA_DEFERRED(1)/APPLSYS.WF_JAVA_DEFERRED	60,199	60,201	16.67	16.67	0.00
WF_NOTIFICATION_OUT(1)/APPLSYS.WF_NOTIFICATION_OUT	1,582	0	0.44	0.00	0.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

only rows with Current or Maximum Utilization > 80% of Limit are shown
ordered by resource name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
sessions	10,412	10,905	12096	12096

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	0	0	0	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

No data exists for this section of the report.

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

No data exists for this section of the report.

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)
O7_DICTIONARY_ACCESSIBILITY	FALSE
_ash_size	266338304
_b_tree_bitmap_plans	FALSE
_fast_full_scan_enabled	FALSE
_kgl_hot_object_copies	255
_like_with_bind_as_equality	TRUE
_optimizer_autostats_job	FALSE
_sort_elimination_cost_ratio	5
_system_trig_enabled	TRUE
_trace_files_public	FALSE
aq_tm_processes	1
audit_sys_operations	TRUE
compatible	11.2.0
control_files	/ebizdata/data/cntrl01.dbf, /ebizdata/data/cntrl02.dbf, /ebizdata/data/cntrl03.dbf
cursor_sharing	FORCE
db_block_checking	FALSE
db_block_checksum	TRUE
db_block_size	8192
db_cache_advice	OFF
db_files	512
db_name	VIS
db_writer_processes	8
diagnostic_dest	/export/home/oracle/app/oracle/product/11.2.0/dbhome_1/admin/VIS_dbzone0
dml_locks	10000
filesystemio_options	setall
ifile	/export/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/VIS_dbzone0_ifile.ora
job_queue_processes	2
local_listener	VIS_LOCAL
log_archive_dest_1	LOCATION=/ebizdata/data/archive
log_archive_format	%t_%s_%r.dbf
log_buffer	104841216
log_checkpoints_to_alert	TRUE
max_dump_file_size	20480
nls_comp	binary
nls_date_format	DD-MON-RR
nls_length_semantics	BYTE
nls_numeric_characters	.,
nls_sort	binary
nls_territory	america
olap_page_pool_size	4194304
open_cursors	600
optimizer_secure_view_merging	FALSE
os_authent_prefix
parallel_max_servers	8
parallel_min_servers	0
pga_aggregate_target	17179869184
plsql_code_type	INTERPRETED
plsql_optimize_level	2
processes	8000
recyclebin	OFF
sec_case_sensitive_logon	FALSE
session_cached_cursors	1000
sessions	12096
sga_target	85899345920
shared_pool_reserved_size	8589934592
shared_pool_size	17179869184
sql92_security	TRUE
undo_management	AUTO
undo_tablespace	APPS_UNDOTS1
utl_file_dir	/usr/tmp, /usr/tmp, /export/home/oracle/app/oracle/product/11.2.0/dbhome_1/appsutil/outbound/VIS_dbzone0, /usr/tmp
workarea_size_policy	AUTO

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	/ebizdata/data/cntrl01.dbf
control_files	/ebizdata/data/cntrl02.dbf
control_files	/ebizdata/data/cntrl03.dbf
utl_file_dir	/export/home/oracle/app/oracle/product/11.2.0/dbhome_1/appsutil/outbound/VIS_dbzone0
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp

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 %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	100.02	Soft Parse %:	98.26
Execute to Parse %:	98.14	Latch Hit %:	98.57
Parse CPU to Parse Elapsd %:	94.16	% Non-Parse CPU:	98.83