WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

TEST 215918786 TEST 1 24-Mar-15 11:03 11.2.0.3.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
TEST	215918786	TEST	1	24-Mar-15 11:03	11.2.0.3.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

ebs02 Solaris[tm] OE (64-bit) 128 16 2 63.50

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
ebs02	Solaris[tm] OE (64-bit)	128	16	2	63.50

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 19252 24-Mar-15 12:04:11 38 1.1

End Snap: 19259 24-Mar-15 19:01:03 116 10.2

Elapsed: 416.87 (mins)

DB Time: 510.53 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	19252	24-Mar-15 12:04:11	38	1.1
End Snap:	19259	24-Mar-15 19:01:03	116	10.2
Elapsed:		416.87 (mins)
DB Time:		510.53 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 1,264M 976M Std Block Size: 8K

Shared Pool Size: 688M 960M Log Buffer: 21,904K

	Begin	End
Buffer Cache:	1,264M	976M	Std Block Size:	8K
Shared Pool Size:	688M	960M	Log Buffer:	21,904K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 1.2 3.4 0.05 0.31

DB CPU(s): 0.5 1.4 0.02 0.13

Redo size: 5,306.9 14,717.4

Logical reads: 1,111.7 3,083.0

Block changes: 31.9 88.5

Physical reads: 34.0 94.2

Physical writes: 2.6 7.2

User calls: 4.0 11.0

Parses: 2.4 6.7

Hard parses: 0.5 1.4

W/A MB processed: 0.3 0.9

Logons: 0.1 0.2

Executes: 24.5 68.0

Rollbacks: 0.2 0.4

Transactions: 0.4

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.2	3.4	0.05	0.31
DB CPU(s):	0.5	1.4	0.02	0.13
Redo size:	5,306.9	14,717.4
Logical reads:	1,111.7	3,083.0
Block changes:	31.9	88.5
Physical reads:	34.0	94.2
Physical writes:	2.6	7.2
User calls:	4.0	11.0
Parses:	2.4	6.7
Hard parses:	0.5	1.4
W/A MB processed:	0.3	0.9
Logons:	0.1	0.2
Executes:	24.5	68.0
Rollbacks:	0.2	0.4
Transactions:	0.4

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 97.34 Soft Parse %: 78.37

Execute to Parse %: 90.21 Latch Hit %: 99.87

Parse CPU to Parse Elapsd %: 84.01 % Non-Parse CPU: 85.47

Shared Pool Statistics

Begin End

Memory Usage %: 89.86 88.93

% SQL with executions>1: 70.57 77.88

% Memory for SQL w/exec>1: 50.75 69.21

	Begin	End
Memory Usage %:	89.86	88.93
% SQL with executions>1:	70.57	77.88
% Memory for SQL w/exec>1:	50.75	69.21

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
library cache pin	41	14,322	349309	46.75	Concurrency
DB CPU		12,580		41.07
enq: TQ - DDL contention	12	2,501	208420	8.16	Other
db file sequential read	198,904	341	2	1.11	User I/O
db file scattered read	49,016	211	4	0.69	User I/O

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

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

2.78 2.84 0.5 1.5 0.0 98.0

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
2.78	2.84	0.5	1.5	0.0	98.0

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

0.4 22.5 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 65,024.0 65,024.0

SGA use (MB): 2,048.0 2,048.0

PGA use (MB): 182.7 502.0

% Host Mem used for SGA+PGA: 3.43 3.92

	Begin	End
Host Mem (MB):	65,024.0	65,024.0
SGA use (MB):	2,048.0	2,048.0
PGA use (MB):	182.7	502.0
% Host Mem used for SGA+PGA:	3.43	3.92

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

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	26,798.80	87.49
PL/SQL execution elapsed time	17,367.33	56.70
DB CPU	12,579.76	41.07
parse time elapsed	5,200.29	16.98
hard parse elapsed time	5,056.30	16.51
failed parse elapsed time	3,372.67	11.01
connection management call elapsed time	1,469.68	4.80
hard parse (sharing criteria) elapsed time	187.48	0.61
PL/SQL compilation elapsed time	82.57	0.27
Java execution elapsed time	53.13	0.17
inbound PL/SQL rpc elapsed time	50.29	0.16
hard parse (bind mismatch) elapsed time	20.07	0.07
sequence load elapsed time	1.77	0.01
repeated bind elapsed time	0.35	0.00
DB time	30,631.59
background elapsed time	3,580.79
background cpu time	1,727.77

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	48,518
AVG_IDLE_TIME	2,449,922
AVG_SYS_TIME	35,112
AVG_USER_TIME	12,168
BUSY_TIME	6,369,374
IDLE_TIME	313,752,704
SYS_TIME	4,650,773
USER_TIME	1,718,601
LOAD	3	3
OS_CPU_WAIT_TIME	1,219,200
PHYSICAL_MEMORY_BYTES	68,182,605,824
NUM_CPUS	128
NUM_CPU_CORES	16
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
24-Mar 12:04:11	2.78
24-Mar 13:00:44	5.48	1.22	0.16	1.06	98.78	0.00
24-Mar 14:00:12	3.30	2.95	1.90	1.05	97.05	0.00
24-Mar 15:00:38	0.86	0.64	0.18	0.46	99.36	0.00
24-Mar 16:00:16	1.80	1.42	0.23	1.19	98.58	0.00
24-Mar 17:00:51	4.09	2.02	0.33	1.69	97.98	0.00
24-Mar 18:00:33	11.98	3.25	0.65	2.61	96.75	0.00
24-Mar 19:01:03	2.84	2.39	0.30	2.08	97.61	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 99.4% of Total DB time 30,631.59 (s)
Total FG Wait Time: 17,855.31 (s) DB CPU time: 12,579.76 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Concurrency	8,178	0	14,540	1778	47.47
DB CPU			12,580		41.07
Other	16,936	56	2,516	149	8.21
User I/O	348,396	0	652	2	2.13
Network	84,789	0	84	1	0.27
Application	3,586	0	31	9	0.10
Commit	3,864	0	30	8	0.10
Configuration	123	4	2	19	0.01
System I/O	14,535	0	0	0	0.00
Administrative	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 pin	41	7	14,322	349309	0.00	46.75
enq: TQ - DDL contention	12	0	2,501	208420	0.00	8.16
db file sequential read	198,904	0	341	2	22.05	1.11
db file scattered read	49,016	0	211	4	5.43	0.69
cursor: pin S wait on X	71	0	124	1749	0.01	0.41
TCP Socket (KGAS)	438	16	83	190	0.05	0.27
os thread startup	16	0	78	4859	0.00	0.25
utl_file I/O	90,178	0	42	0	10.00	0.14
log file sync	3,864	0	30	8	0.43	0.10
direct path read	4,168	0	24	6	0.46	0.08
enq: TX - row lock contention	73	0	20	275	0.01	0.07
db file parallel read	731	0	18	24	0.08	0.06
library cache load lock	120	0	7	57	0.01	0.02
direct path write	396	0	6	16	0.04	0.02
library cache: mutex X	5,271	0	6	1	0.58	0.02
enq: UL - contention	2	100	6	3000	0.00	0.02
local write wait	629	0	6	9	0.07	0.02
enq: CR - block range reuse ckpt	301	0	6	19	0.03	0.02
PX Deq: Slave Session Stats	2,682	0	5	2	0.30	0.02
enq: RO - fast object reuse	337	0	3	9	0.04	0.01
library cache lock	11	0	2	204	0.00	0.01
SQL*Net break/reset to client	3,174	0	2	1	0.35	0.01
PX Deq: Signal ACK EXT	1,348	0	1	1	0.15	0.00
direct path write temp	313	0	1	4	0.03	0.00
enq: TX - allocate ITL entry	113	0	1	10	0.01	0.00
read by other session	70	0	1	16	0.01	0.00
buffer busy waits	505	0	1	2	0.06	0.00
sort segment request	1	100	1	1000	0.00	0.00
blocking txn id for DDL	9,300	100	1	0	1.03	0.00
direct path sync	116	0	1	8	0.01	0.00
control file sequential read	14,535	0	0	0	1.61	0.00
Disk file operations I/O	3,871	0	0	0	0.43	0.00
reliable message	675	0	0	1	0.07	0.00
SQL*Net message to client	77,223	0	0	0	8.56	0.00
kksfbc child completion	5	100	0	50	0.00	0.00
enq: SQ - contention	3	0	0	60	0.00	0.00
SGA: allocation forcing component growth	4	0	0	43	0.00	0.00
SQL*Net more data to client	5,891	0	0	0	0.65	0.00
row cache lock	16	0	0	9	0.00	0.00
SQL*Net message from dblink	69	0	0	2	0.01	0.00
enq: PS - contention	233	0	0	0	0.03	0.00
PX Deq: Table Q Get Keys	600	0	0	0	0.07	0.00
latch: shared pool	704	0	0	0	0.08	0.00
latch free	834	0	0	0	0.09	0.00
latch: cache buffers chains	1,251	0	0	0	0.14	0.00
undo segment extension	5	80	0	6	0.00	0.00
enq: HW - contention	1	0	0	25	0.00	0.00
SQL*Net more data from client	1,085	0	0	0	0.12	0.00
PX Deq: Signal ACK RSG	140	0	0	0	0.02	0.00
latch: call allocation	52	0	0	0	0.01	0.00
PX Deq: Table Q qref	612	0	0	0	0.07	0.00
latch: row cache objects	80	0	0	0	0.01	0.00
cursor: pin S	84	0	0	0	0.01	0.00
SQL*Net more data to dblink	18	0	0	0	0.00	0.00
PX qref latch	91	100	0	0	0.01	0.00
SQL*Net message from client	77,162	0	222,312	2881	8.56
Streams AQ: waiting for messages in the queue	5,409	93	39,741	7347	0.60
pipe get	2,841	99	11,619	4090	0.32
jobq slave wait	905	99	449	497	0.10
PX Deq: Execution Msg	9,236	0	372	40	1.02
PX Deq: Execute Reply	7,839	0	64	8	0.87
PX Deq Credit: send blkd	626	0	51	82	0.07
PX Deq: Table Q Normal	4,520	0	37	8	0.50
PL/SQL lock timer	2	100	31	15501	0.00
PX Deq Credit: need buffer	44	0	9	204	0.00
PX Deq: Parse Reply	1,348	0	5	3	0.15
PX Deq: Join ACK	1,348	0	2	1	0.15
single-task message	5	0	1	224	0.00
PX Deq: Table Q Sample	8	0	0	1	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
os thread startup	142	0	531	3736	0.02	14.82
db file parallel write	14,624	0	120	8	1.62	3.36
log file parallel write	12,192	0	98	8	1.35	2.73
control file parallel write	9,050	0	73	8	1.00	2.03
db file sequential read	10,065	0	26	3	1.12	0.72
library cache lock	8	0	20	2494	0.00	0.56
enq: PV - syncstart	3	0	15	5025	0.00	0.42
rdbms ipc reply	4	50	5	1297	0.00	0.14
JS coord start wait	4	100	5	1250	0.00	0.14
enq: PR - contention	1	0	5	4889	0.00	0.14
db file scattered read	926	0	3	3	0.10	0.08
LGWR wait for redo copy	314	0	3	9	0.03	0.08
db file parallel read	7	0	3	405	0.00	0.08
reliable message	103	2	2	24	0.01	0.07
control file sequential read	51,757	0	2	0	5.74	0.07
library cache load lock	38	0	2	52	0.00	0.06
direct path write	98	0	1	11	0.01	0.03
sort segment request	1	100	1	1000	0.00	0.03
db file async I/O submit	14,425	0	1	0	1.60	0.01
log file sync	24	0	0	20	0.00	0.01
buffer busy waits	11	0	0	40	0.00	0.01
enq: TQ - TM contention	1	0	0	366	0.00	0.01
library cache: mutex X	4,493	0	0	0	0.50	0.01
Disk file operations I/O	4,330	0	0	0	0.48	0.01
ADR block file read	112	0	0	2	0.01	0.01
latch: call allocation	817	0	0	0	0.09	0.00
ADR block file write	35	0	0	3	0.00	0.00
direct path sync	11	0	0	11	0.00	0.00
library cache pin	7	0	0	15	0.00	0.00
local write wait	3	0	0	23	0.00	0.00
kksfbc child completion	1	100	0	50	0.00	0.00
latch: shared pool	65	0	0	0	0.01	0.00
read by other session	1	0	0	24	0.00	0.00
latch: checkpoint queue latch	2	0	0	11	0.00	0.00
latch: active service list	457	0	0	0	0.05	0.00
cursor: pin S wait on X	1	0	0	10	0.00	0.00
latch free	10	0	0	1	0.00	0.00
enq: JS - queue lock	3	0	0	2	0.00	0.00
asynch descriptor resize	812	100	0	0	0.09	0.00
SQL*Net message to client	1,723	0	0	0	0.19	0.00
latch: redo writing	12	0	0	0	0.00	0.00
rdbms ipc message	296,940	82	669,986	2256	32.92
Streams AQ: qmn slave idle wait	8,038	0	50,004	6221	0.89
DIAG idle wait	49,534	100	49,537	1000	5.49
Space Manager: slave idle wait	10,022	95	48,322	4822	1.11
Streams AQ: qmn coordinator idle wait	10,458	38	25,013	2392	1.16
smon timer	243	29	25,000	102880	0.03
pmon timer	8,337	100	24,991	2998	0.92
Streams AQ: waiting for time management or cleanup tasks	115	62	24,587	213802	0.01
VKRM Idle	1	0	14,392	14392488	0.00
JOX Jit Process Sleep	841	100	12,322	14652	0.09
PX Idle Wait	1,364	0	11,401	8359	0.15
SQL*Net message from client	2,376	0	99	42	0.26
SGA: MMAN sleep for component shrink	987	96	10	10	0.11
class slave wait	125	0	0	0	0.01

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	120	93.3			.8	2.5		3.3
ADR block file write	35	42.9		8.6	48.6
ADR file lock	42	100.0
Disk file operations I/O	8199	100.0			.0	.0
JS coord start wait	4							50.0	50.0
LGWR wait for redo copy	314	72.6				1.3	14.0	12.1
PX Deq: Signal ACK EXT	1348	83.2	.2	1.7	13.4	1.2	.3
PX Deq: Signal ACK RSG	140	99.3				.7
PX Deq: Slave Session Stats	2685	72.1	.1	1.6	18.8	6.3	1.0
PX Deq: Table Q Get Keys	602	99.3	.2	.5
PX Deq: Table Q qref	612	100.0
PX qref latch	91	100.0
SGA: allocation forcing component growth	4					25.0	25.0	50.0
SQL*Net break/reset to client	3182	98.8	.1	.6	.2	.0	.1	.1
SQL*Net message from dblink	69	72.5	15.9	2.9	5.8	1.4		1.4
SQL*Net message to client	79.2K	100.0
SQL*Net message to dblink	65	100.0
SQL*Net more data from client	1085	99.9	.1
SQL*Net more data to client	5919	100.0
SQL*Net more data to dblink	18	94.4	5.6
TCP Socket (KGAS)	438	81.1	1.1	1.1	3.2	3.0		2.5	8.0
asynch descriptor resize	813	100.0
blocking txn id for DDL	9300	99.0				1.0
buffer busy waits	516	95.9	.6				1.2	2.3
buffer deadlock	27	100.0
control file parallel write	9051		21.2	1.4	31.8	42.8	2.2	.6	.0
control file sequential read	66.3K	99.9	.0	.0	.0	.0	.0	.0
cursor: mutex X	3	100.0
cursor: pin S	85	100.0
cursor: pin S wait on X	72					15.3	9.7	48.6	26.4
db file async I/O submit	14.4K	99.9	.1	.0			.0
db file parallel read	738	75.2	.4	.7	3.7	9.1	4.5	6.2	.3
db file parallel write	14.6K	24.6	6.3	5.1	37.1	13.5	10.4	3.0
db file scattered read	49.9K	59.9	.5	1.1	18.0	16.7	3.3	.6
db file sequential read	208.8K	83.6	.1	.4	7.3	7.3	1.0	.3
direct path read	4168	57.9	2.5	5.3	13.3	12.8	6.2	1.9
direct path read temp	4	100.0
direct path sync	127	63.0	1.6	3.1	6.3	13.4	5.5	7.1
direct path write	489	30.5	1.8	9.0	14.9	17.4	12.1	14.3
direct path write temp	314	39.8	3.2	6.7	42.4	6.1	1.6	.3
enq: CR - block range reuse ckpt	301				6.3	54.8	29.2	9.6
enq: HW - contention	1						100.0
enq: JS - queue lock	3	33.3		66.7
enq: PR - contention	1								100.0
enq: PS - contention	233	97.9				2.1
enq: PV - syncstart	3								100.0
enq: RO - fast object reuse	337	42.4	.3	2.1	13.9	24.0	14.5	2.7
enq: SQ - contention	3		33.3					66.7
enq: TQ - DDL contention	12							8.3	91.7
enq: TQ - TM contention	1							100.0
enq: TX - allocate ITL entry	113	86.7			.9		1.8	10.6
enq: TX - row lock contention	73	86.3						9.6	4.1
enq: UL - contention	2							50.0	50.0
kksfbc child completion	6							100.0
latch free	846	99.5	.4		.1
latch: In memory undo latch	6	100.0
latch: active service list	458	99.8	.2
latch: cache buffers chains	1265	100.0
latch: cache buffers lru chain	2	100.0
latch: call allocation	869	100.0
latch: checkpoint queue latch	2		50.0				50.0
latch: enqueue hash chains	1	100.0
latch: messages	1	100.0
latch: object queue header operation	11	100.0
latch: parallel query alloc buffer	9	100.0
latch: redo writing	12	100.0
latch: row cache objects	82	100.0
latch: shared pool	770	97.8	.9	.8	.4	.1
library cache load lock	158	17.1	5.7	8.2	10.8	12.0	17.1	28.5	.6
library cache lock	19	21.1	5.3		15.8			42.1	15.8
library cache pin	48	20.8				2.1	6.3	8.3	62.5
library cache: mutex X	9712	94.6	.0	.0		4.5	.9
local write wait	632	3.0	3.3	1.7	43.0	41.1	6.2	1.6
log file parallel write	12.2K	17.9	3.9	6.3	46.0	16.9	6.8	2.2	.0
log file sync	3871	12.1	7.4	4.9	44.7	23.5	5.9	1.5
os thread startup	158							24.1	75.9
rdbms ipc reply	4					25.0			75.0
read by other session	71	23.9		12.7	32.4	26.8	1.4	2.8
reliable message	779	98.3	.3		.1	.3	.4	.6
row cache lock	17	94.1						5.9
sort segment request	2							100.0
undo segment extension	5	60.0				20.0	20.0
utl_file I/O	90.2K	99.8	.0	.0	.0		.0	.1
DIAG idle wait	49.5K							100.0
JOX Jit Process Sleep	842							.5	99.5
PL/SQL lock timer	2							50.0	50.0
PX Deq Credit: need buffer	44	15.9		2.3	2.3	2.3		72.7	4.5
PX Deq Credit: send blkd	623	83.6	.2		.5	1.0	1.9	9.5	3.4
PX Deq: Execute Reply	7839	90.2	1.0	1.3	2.3	1.8	1.1	2.2	.2
PX Deq: Execution Msg	9205	57.8	6.8	1.1	8.6	11.2	8.1	5.6	.7
PX Deq: Join ACK	1348	84.3	14.5	.6	.1	.1	.1	.2
PX Deq: Parse Reply	1348	68.3	11.8	1.6	.1	17.7	.1	.4
PX Deq: Table Q Normal	4490	87.7	4.0	3.1	2.6	.7	.6	1.2	.2
PX Deq: Table Q Sample	8	100.0
PX Idle Wait	1345	.1				1.5	52.9	33.9	11.6
SGA: MMAN sleep for component shrink	987	.8	.8	.6	1.0	96.8
SQL*Net message from client	79.8K	76.4	6.3	4.4	1.6	1.0	1.5	3.4	5.3
Space Manager: slave idle wait	9795	.6	.4	.3	.1	.0	.1	1.4	97.1
Streams AQ: qmn coordinator idle wait	10.5K	61.5				.0		.0	38.4
Streams AQ: qmn slave idle wait	8036								100.0
Streams AQ: waiting for messages in the queue	5425	3.6			.0	.2	.1	1.4	94.6
Streams AQ: waiting for time management or cleanup tasks	115	13.0						35.7	51.3
VKRM Idle	1								100.0
class slave wait	125	100.0
jobq slave wait	905	.1			.1			99.8
pipe get	2852		.0					9.0	91.0
pmon timer	8339	.0				.0	.0	.0	99.9
rdbms ipc message	296.4K	8.0	1.2	.6	1.8	1.7	1.9	18.7	66.1
single-task message	5							100.0
smon timer	245	13.5	4.5	2.4	.8	.8	2.0	17.1	58.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	>=2s
		% of Total Waits
ADR block file read	4	96.7	3.3
JS coord start wait	4					25.0	25.0	50.0
LGWR wait for redo copy	38	87.9	8.9	3.2
SGA: allocation forcing component growth	2	50.0	25.0	25.0
SQL*Net break/reset to client	4	99.9	.1			.0	.0
SQL*Net message from dblink	1	98.6	1.4
TCP Socket (KGAS)	12	89.5		.9	.5	.9	.2	.2	7.8
buffer busy waits	12	97.7	.4	1.4	.6
control file parallel write	59	99.3	.5	.1	.1		.0	.0
control file sequential read	3	100.0	.0
cursor: pin S wait on X	42	25.0	4.2	6.9	8.3	12.5	16.7	9.7	16.7
db file parallel read	48	93.5	2.3	.9	.8	.4	1.8	.3
db file parallel write	442	97.0	2.5	.5	.0
db file scattered read	275	99.4	.4	.1	.0	.0	.0
db file sequential read	599	99.7	.2	.0	.0	.0	.0
direct path read	81	98.1	1.4	.3	.0	.2	.0
direct path sync	9	92.9	3.9	2.4	.8
direct path write	70	85.7	11.9	1.4	.8	.2
direct path write temp	1	99.7	.3
enq: CR - block range reuse ckpt	29	90.4	7.6	1.7		.3
enq: RO - fast object reuse	9	97.3	1.5	1.2
enq: SQ - contention	2	33.3		66.7
enq: TQ - DDL contention	1					8.3			91.7
enq: TQ - TM contention	1					100.0
enq: TX - allocate ITL entry	12	89.4	3.5	5.3	1.8
enq: TX - row lock contention	7	86.3		5.5	2.7		1.4		4.1
enq: UL - contention	1						50.0		50.0
kksfbc child completion	6		100.0
library cache load lock	46	70.9	12.7	10.1	1.9	1.9	1.9	.6
library cache lock	9	42.1		5.3	10.5	5.3	21.1	5.3	10.5
library cache pin	9	29.2	4.2	2.1	2.1			10.4	52.1
local write wait	10	98.4	1.6
log file parallel write	270	97.8	1.8	.3	.1		.0	.0
log file sync	59	98.5	1.3	.2	.1
os thread startup	43		11.4	5.1	2.5	2.5	2.5	3.2	72.8
rdbms ipc reply	3	25.0						75.0
read by other session	2	97.2	1.4				1.4
reliable message	5	99.4	.3			.1	.3
row cache lock	1	94.1			5.9
sort segment request	2						100.0
utl_file I/O	123	99.9	.0	.0	.0	.1	.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

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

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s	>=2m
		% of Total Waits
TCP Socket (KGAS)	34	92.2	7.8
cursor: pin S wait on X	12	83.3	2.8	5.6	6.9	1.4
enq: PR - contention	1			100.0
enq: PV - syncstart	3		66.7		33.3
enq: TQ - DDL contention	8	8.3	25.0	33.3	8.3		25.0
enq: TX - row lock contention	3	95.9	2.7		1.4
enq: UL - contention	1	50.0		50.0
library cache lock	2	89.5		10.5
library cache pin	8	47.9	12.5	4.2			35.4
os thread startup	115	27.2	7.0	65.2	.6

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes) h is 4096*1024 milliseconds (approximately 70 minutes or 1.17 hours)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 4m to 1h	<2m	<1/4h
		% of Total Waits
enq: TQ - DDL contention	3	75.0	25.0
library cache pin	17	64.6	35.4

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)
TEST	26,252	8,826	323	15,160
SYS$USERS	4,376	3,750	510	12,103
SYS$BACKGROUND	0	0	17	548

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	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	107376	332	15	0	0	0	226	0
SYS$BACKGROUND	15461	33	4720	553	0	0	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 15.7% of Total DB Time (s): 30,632
Captured PL/SQL account for 74.9% of Total DB Time (s): 30,632

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
6,342.77	8	792.85	20.71	0.01	0.00	fnpyvpk41nd5s	e:FND:cp:STANDARD	begin FND_CP_OPP_REQ.postproce...
5,322.51	520	10.24	17.38	0.11	0.00	7b5w34atn8q1h	JDBC Thin Client	BEGIN FND_CP_OPP_IPC.Get_Messa...
4,503.69	8	562.96	14.70	0.52	0.05	2vq15mt5gn0uz	JDBC Thin Client	BEGIN FND_CP_OPP_IPC.Subscribe...
3,678.98	1	3,678.98	12.01	93.50	6.76	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
1,375.05	2,414	0.57	4.49	100.05	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
660.08	3	220.03	2.15	0.96	0.04	1n491n6hwbn7a	e::cp:30	begin fnd_cp_opp_ipc.unsubscri...
331.77	3	110.59	1.08	98.90	1.16	4dkfc6zjqrznf	CUX_AR_GL_GENERATE	BEGIN CUX_AR_GENERATE_JOUNARY_...
321.62	2	160.81	1.05	99.45	0.56	3r50y3ay9zznd	CUX_AR_GL_GENERATE	SELECT GCC1.SEGMENT1 \|\| '_' \|\|...
318.32	2,185	0.15	1.04	99.03	0.94	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
202.25	1	202.25	0.66	100.00	0.12	asgrbd81fst6b	CUXARERG	BEGIN cux_ar_heb_gnt_jounary_p...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - CPU Time as a percentage of Total DB CPU
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 36.4% of Total CPU Time (s): 12,580
Captured PL/SQL account for 44.8% of Total CPU Time (s): 12,580

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
3,439.78	1	3,439.78	27.34	3,678.98	93.50	6.76	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
1,375.70	2,414	0.57	10.94	1,375.05	100.05	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
328.14	3	109.38	2.61	331.77	98.90	1.16	4dkfc6zjqrznf	CUX_AR_GL_GENERATE	BEGIN CUX_AR_GENERATE_JOUNARY_...
319.87	2	159.94	2.54	321.62	99.45	0.56	3r50y3ay9zznd	CUX_AR_GL_GENERATE	SELECT GCC1.SEGMENT1 \|\| '_' \|\|...
315.25	2,185	0.14	2.51	318.32	99.03	0.94	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
202.25	1	202.25	1.61	202.25	100.00	0.12	asgrbd81fst6b	CUXARERG	BEGIN cux_ar_heb_gnt_jounary_p...
201.98	1	201.98	1.61	201.99	99.99	0.00	4yk1pn41haaf7	CUXARERG	SELECT GCC1.SEGMENT1 \|\| '_' \|\|...
194.48	224	0.87	1.55	194.38	100.05	0.01	gj1mbaw0hyzru	JDBC Thin Client	BEGIN fnd_security_pkg.fnd_enc...
178.82	93	1.92	1.42	178.81	100.00	0.01	2sjraytcfcv2n	FNDCPUCF@ebs02 (TNS V1-V3)	SELECT /+ USE_NL (A B I) / D...
146.18	7	20.88	1.16	175.43	83.33	0.78	356pyutkc5ksk	e:AR:bes:oracle.apps.xla.accounting.preaccountin	SELECT TABLE1.APPLICATION_ID A...
137.95	9	15.33	1.10	142.96	96.50	3.69	9bf4vuu4tyduy	DBMS_SCHEDULER	/* SQL Analyze(1033, 1) */ SEL...
135.53	1	135.53	1.08	136.41	99.36	1.10	461dt9c3f3f2v	CUXAREXCEPT	BEGIN cux_ar_heb_gnt_jounary_p...
133.47	1	133.47	1.06	133.58	99.92	0.10	1cdm5x3ysc292	CUXAREXCEPT	SELECT GCC1.SEGMENT1 \|\| '_' \|\|...

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
248.84	1	248.84	36.33	3,678.98	93.50	6.76	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
14.36	1	14.36	2.10	128.19	89.82	11.20	5t39uchjqpyfm	XLAACCUP	BEGIN xla_accounting_pkg.unit_...
13.48	4,652	0.00	1.97	18.67	29.84	72.23	3ktacv9r56b51		select owner#, name, namespace...
13.48	1	13.48	1.97	93.86	86.60	14.37	fqmpmkfr6pqyk	plsqldev.exe	select s.synonym_name object_n...
11.62	8	1.45	1.70	80.73	93.35	14.40	656sk77p7a7qs	XLAACCPB	Declare l_flag Boolean; BEGIN ...
10.44	8	1.30	1.52	178.51	65.97	5.85	0z0c9bt4rf2c5	FNDWFLSC	BEGIN wf_local_synch.bulksynch...
8.30	718	0.01	1.21	8.67	5.54	95.73	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
6.31	1	6.31	0.92	60.53	88.60	10.43	agu5hk0yafawj	HEBBAABQ	BEGIN heb_ap_cmb_acc_balance_p...
5.94	1	5.94	0.87	64.27	91.05	9.24	5sw7btgwnwq7c	PL/SQL Developer	declare rflag char(20); begin ...
5.47	1,011	0.01	0.80	6.32	17.40	86.49	4g4k54qrsawn6		select /*+ index(idl_ub1$ i_id...

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: 27,805,470
Captured SQL account for 23.4% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
11,265,441	1	11,265,441.00	40.52	3,678.98	93.5	6.8	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
1,655,886	1	1,655,886.00	5.96	63.46	38.1	4.5	7yqcrnkxhx4p8	FNDWFWITSTATCC	BEGIN WF_OAM_METRICS.workItems...
1,225,244	4	306,311.00	4.41	15.34	88.6	13.4	dc9bdxa7xpv8s	PL/SQL Developer	declare t_owner varchar2(30); ...
976,035	571	1,709.34	3.51	17.30	92.4	7.4	3ppkc2qq9ks8d		select nvl(s.bytes, 0) from db...
960,416	9	106,712.89	3.45	142.96	96.5	3.7	9bf4vuu4tyduy	DBMS_SCHEDULER	/* SQL Analyze(1033, 1) */ SEL...
815,034	3	271,678.00	2.93	4.43	82.2	22.7	1c1uw2maxn8mr	PL/SQL Developer	SELECT /+rule/ CONSTRAINT_TY...
540,494	8	67,561.75	1.94	178.51	66	5.8	0z0c9bt4rf2c5	FNDWFLSC	BEGIN wf_local_synch.bulksynch...
400,479	1	400,479.00	1.44	93.86	86.6	14.4	fqmpmkfr6pqyk	plsqldev.exe	select s.synonym_name object_n...
344,116	1	344,116.00	1.24	64.27	91.1	9.2	5sw7btgwnwq7c	PL/SQL Developer	declare rflag char(20); begin ...
318,230	78,841	4.04	1.14	38.97	101.7	1.2	6842742n5dmp6	DBMS_SCHEDULER	SELECT DECODE(:B4 , 0, FLV.MEA...
311,925	3	103,975.00	1.12	68.88	94.5	5.7	59x5pnb9rangn	plsqldev.exe	select object_name, object_typ...

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: 849,356
Captured SQL account for 9.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
448,275	1	448,275.00	52.78	3,678.98	93.50	6.76	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
26,031	1	26,031.00	3.06	27.06	99.34	1.43	9n126p922amjm	FNDWFWITSTATCC	SELECT /*+ PARALLEL(wf_item_ac...
15,956	1	15,956.00	1.88	93.86	86.60	14.37	fqmpmkfr6pqyk	plsqldev.exe	select s.synonym_name object_n...
7,905	9	878.33	0.93	142.96	96.50	3.69	9bf4vuu4tyduy	DBMS_SCHEDULER	/* SQL Analyze(1033, 1) */ SEL...
5,918	4	1,479.50	0.70	15.34	88.58	13.39	dc9bdxa7xpv8s	PL/SQL Developer	declare t_owner varchar2(30); ...
5,017	3	1,672.33	0.59	4.43	82.23	22.72	1c1uw2maxn8mr	PL/SQL Developer	SELECT /+rule/ CONSTRAINT_TY...
4,233	8	529.13	0.50	178.51	65.97	5.85	0z0c9bt4rf2c5	FNDWFLSC	BEGIN wf_local_synch.bulksynch...
2,911	1	2,911.00	0.34	128.19	89.82	11.20	5t39uchjqpyfm	XLAACCUP	BEGIN xla_accounting_pkg.unit_...
2,663	1	2,663.00	0.31	63.46	38.13	4.51	7yqcrnkxhx4p8	FNDWFWITSTATCC	BEGIN WF_OAM_METRICS.workItems...
2,209	25	88.36	0.26	43.30	93.66	6.53	39c3gyvun83f9	FNDWFLSC	BEGIN DBMS_STATS.GATHER_TABLE_...

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: 273,255
Captured SQL account for 18.8% of Total
Total UnOptimized Read Requests: 273,255
Captured SQL account for 18.8% 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
97,172	97,172	1	97,172.00	35.56	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
15,943	15,943	1	15,943.00	5.83	fqmpmkfr6pqyk	plsqldev.exe	select s.synonym_name object_n...
13,904	13,904	976	14.25	5.09	424h0nf7bhqzd	DBMS_SCHEDULER	SELECT sqlset_row(sql_id, for...
2,816	2,816	8	352.00	1.03	0z0c9bt4rf2c5	FNDWFLSC	BEGIN wf_local_synch.bulksynch...
2,716	2,716	4	679.00	0.99	dc9bdxa7xpv8s	PL/SQL Developer	declare t_owner varchar2(30); ...
2,685	2,685	1	2,685.00	0.98	5t39uchjqpyfm	XLAACCUP	BEGIN xla_accounting_pkg.unit_...
2,651	2,651	1	2,651.00	0.97	7yqcrnkxhx4p8	FNDWFWITSTATCC	BEGIN WF_OAM_METRICS.workItems...
2,155	2,155	9	239.44	0.79	9bf4vuu4tyduy	DBMS_SCHEDULER	/* SQL Analyze(1033, 1) */ SEL...
1,815	1,815	3	605.00	0.66	1c1uw2maxn8mr	PL/SQL Developer	SELECT /+rule/ CONSTRAINT_TY...
1,795	1,795	8	224.38	0.66	656sk77p7a7qs	XLAACCPB	Declare l_flag Boolean; BEGIN ...

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: 613,057
Captured SQL account for 50.7% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
78,841	78,841	1.00	38.97	101.7	1.2	6842742n5dmp6	DBMS_SCHEDULER	SELECT DECODE(:B4 , 0, FLV.MEA...
77,414	0	0.00	15.89	87.4	14.1	073n31wnz5tg1		SELECT 'Y' FROM AR_CASH_RECEIP...
19,595	7,044	0.36	3.34	84.4	4.9	7qs7fx89194u1	DBMS_SCHEDULER	SELECT PROFILE_OPTION_VALUE FR...
17,751	15,950	0.90	8.19	99.3	3.7	0wmwsjy9kd92f	DBMS_SCHEDULER	SELECT PROFILE_OPTION_ID, APPL...
11,805	10,275	0.87	5.17	30.4	70.3	96g93hntrzjtr		select /+ rule / bucket_cnt,...
6,774	7,730	1.14	1.49	57.6	49.7	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
6,658	6,453	0.97	2.20	78.2	18.6	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
5,664	2,230	0.39	1.62	92.2	3.1	dawf7hvg1ym94	JDBC Thin Client	select V.PROFILE_OPTION_VALUE ...
4,956	39,648	8.00	1.10	103.1	0	8w57t3xaxs89k	e:fnd:bes:oracle.apps.fnd.profile.value.update	SELECT NAME, VERSION FROM FND_...
4,652	14,799	3.18	18.67	29.8	72.2	3ktacv9r56b51		select owner#, name, namespace...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 60,013
Captured SQL account for 30.5% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
3,021	3,021	5.03	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
1,499	1,499	2.50	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
666	666	1.11	0k8522rmdzg4k		select privilege# from sysauth...
613	17,751	1.02	0wmwsjy9kd92f	DBMS_SCHEDULER	SELECT PROFILE_OPTION_ID, APPL...
576	576	0.96	0q8w0cndsp865	DBMS_SCHEDULER	SELECT FPOV.PROFILE_OPTION_VAL...
576	576	0.96	bazquck2vuvm1	DBMS_SCHEDULER	SELECT RELEASE_NAME FROM FND_P...
484	2,414	0.81	cm5vu20fhtnq1		select /*+ connect_by_filterin...
416	19,595	0.69	7qs7fx89194u1	DBMS_SCHEDULER	SELECT PROFILE_OPTION_VALUE FR...
415	415	0.69	459f3z9u4fb3u		select value$ from props$ wher...
410	410	0.68	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,234,972	1	0.12	81y55ua0qr1rx	e:AR:bes:oracle.apps.xla.accounting.extract	SELECT /*+ leading(xet) cardin...

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

ERROR: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 919 ORA-06512: at line 1

SQL Id SQL Text

073n31wnz5tg1 SELECT 'Y' FROM AR_CASH_RECEIPT_HISTORY_ALL CRH WHERE CRH.CASH_RECEIPT_ID = :B1 AND CRH.CURRENT_RECORD_FLAG = 'Y' AND CRH.STATUS = 'REVERSED'

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	97.46	In-memory Sort %:	100.00
Library Hit %:	97.34	Soft Parse %:	78.37
Execute to Parse %:	90.21	Latch Hit %:	99.87
Parse CPU to Parse Elapsd %:	84.01	% Non-Parse CPU:	85.47