	\| Worldwide
	Secure Search
PRODUCTS AND SERVICES INDUSTRIES SUPPORT PARTNERS COMMUNITIES ABOUT

ORACLE CORPORATION

Legal | Privacy

AWR Report

WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

VIS 187584551 VIS 1 10.2.0.3.0 NO hpdb1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1 15-Feb-08 09:45:20 3582 205.0

End Snap: 2 15-Feb-08 10:45:26 3596 238.0

Elapsed: 60.09 (mins)

DB Time: 496.19 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 18,240M 18,096M Std Block Size: 8K

Shared Pool Size: 2,144M 2,288M Log Buffer: 14,320K

Load Profile

Per Second Per Transaction

Redo size: 8,346,812.95 32,071.41

Logical reads: 509,917.13 1,959.28

Block changes: 51,490.32 197.84

Physical reads: 124.93 0.48

Physical writes: 814.49 3.13

User calls: 9,386.44 36.07

Parses: 1,887.54 7.25

Hard parses: 1.99 0.01

Sorts: 2,317.99 8.91

Logons: 2.13 0.01

Executes: 22,593.53 86.81

Transactions: 260.26

% Blocks changed per Read: 10.10 Recursive Call %: 79.66

Rollback per transaction %: 18.94 Rows per Sort: 12.76

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95 Redo NoWait %: 100.00

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

Library Hit %: 99.79 Soft Parse %: 99.89

Execute to Parse %: 91.65 Latch Hit %: 98.72

Parse CPU to Parse Elapsd %: 84.59 % Non-Parse CPU: 97.83

Shared Pool Statistics

Begin End

Memory Usage %: 84.40 84.72

% SQL with executions>1: 89.45 89.34

% Memory for SQL w/exec>1: 67.07 65.96

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

CPU time 23,675 79.5

db file sequential read 257,143 2,995 12 10.1 User I/O

log file sync 379,744 890 2 3.0 Commit

db file scattered read 15,998 489 31 1.6 User I/O

SQL*Net more data from client 1,779,829 465 0 1.6 Network

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
init.ora Parameters

Time Model Statistics

Total time in database user-calls (DB Time): 29771.5s
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	25,736.23	86.45
DB CPU	23,675.37	79.52
PL/SQL execution elapsed time	5,535.00	18.59
inbound PL/SQL rpc elapsed time	5,516.98	18.53
parse time elapsed	676.97	2.27
Java execution elapsed time	645.20	2.17
hard parse elapsed time	308.74	1.04
repeated bind elapsed time	87.61	0.29
sequence load elapsed time	17.87	0.06
connection management call elapsed time	11.92	0.04
PL/SQL compilation elapsed time	10.04	0.03
hard parse (sharing criteria) elapsed time	4.55	0.02
failed parse elapsed time	1.41	0.00
hard parse (bind mismatch) elapsed time	1.18	0.00
DB time	29,771.49
background elapsed time	1,481.70
background cpu time	501.45

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
User I/O	314,399	0.05	3,878	12	0.34
Commit	379,744	0.00	890	2	0.40
Concurrency	2,389,562	0.24	641	0	2.55
Application	52,413	0.33	581	11	0.06
Network	38,819,629	0.00	544	0	41.37
System I/O	677,613	0.00	329	0	0.72
Other	139,050	34.34	107	1	0.15
Configuration	7,713	0.01	13	2	0.01

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file sequential read	257,143	0.00	2,995	12	0.27
log file sync	379,744	0.00	890	2	0.40
db file scattered read	15,998	0.00	489	31	0.02
SQL*Net more data from client	1,779,829	0.00	465	0	1.90
buffer busy waits	838,419	0.04	437	1	0.89
enq: RO - fast object reuse	160	78.75	386	2410	0.00
log file parallel write	646,395	0.00	324	1	0.69
local write wait	1,557	9.63	232	149	0.00
read by other session	37,056	0.01	163	4	0.04
enq: UL - contention	1,982	1.87	125	63	0.00
latch: cache buffers chains	1,477,872	0.00	66	0	1.57
cursor: pin S wait on X	5,752	93.53	59	10	0.01
rdbms ipc reply	28	92.86	54	1931	0.00
enq: TX - row lock contention	405	1.73	50	123	0.00
SQL*Net message to client	35,463,929	0.00	47	0	37.79
SQL*Net more data to client	1,575,871	0.00	33	0	1.68
library cache load lock	782	0.00	29	37	0.00
enq: TX - index contention	31,232	0.00	29	1	0.03
PX Deq Credit: send blkd	21,673	0.00	23	1	0.02
SQL*Net break/reset to client	49,858	0.00	12	0	0.05
enq: HW - contention	2,936	0.00	11	4	0.00
latch: library cache	11,432	0.00	10	1	0.01
enq: TM - contention	8	25.00	8	1060	0.00
kksfbc child completion	113	85.84	5	43	0.00
control file parallel write	1,859	0.00	4	2	0.00
latch: undo global data	7,390	0.00	4	0	0.01
latch: In memory undo latch	16,038	0.00	3	0	0.02
os thread startup	76	0.00	3	40	0.00
latch free	4,680	0.00	3	1	0.00
latch: library cache pin	3,464	0.00	2	1	0.00
latch: object queue header operation	16,059	0.00	2	0	0.02
wait list latch free	181	0.00	2	11	0.00
PX Deq: Signal ACK	275	23.27	2	6	0.00
latch: cache buffers lru chain	1,405	0.00	2	1	0.00
buffer deadlock	47,542	98.59	2	0	0.05
enq: DV - contention	171	0.00	1	9	0.00
LGWR wait for redo copy	25,466	0.00	1	0	0.03
enq: TX - contention	2,694	0.00	1	1	0.00
latch: redo allocation	2,497	0.00	1	0	0.00
latch: row cache objects	1,191	0.00	1	1	0.00
latch: session allocation	1,716	0.00	1	1	0.00
enq: SQ - contention	4,113	0.00	1	0	0.00
log file switch completion	47	0.00	1	18	0.00
row cache lock	905	0.00	1	1	0.00
enq: TX - allocate ITL entry	158	0.00	1	3	0.00
SGA: allocation forcing component growth	46	71.74	0	11	0.00
PX qref latch	720	91.25	0	1	0.00
library cache pin	1,428	0.00	0	0	0.00
write complete waits	8	12.50	0	32	0.00
enq: FB - contention	932	0.00	0	0	0.00
control file sequential read	29,347	0.00	0	0	0.03
cursor: pin S	4,654	0.00	0	0	0.00
reliable message	33	0.00	0	7	0.00
latch: object queue header heap	383	0.00	0	1	0.00
latch: shared pool	428	0.00	0	0	0.00
latch: cache buffer handles	223	0.00	0	1	0.00
latch: library cache lock	188	0.00	0	1	0.00
latch: messages	86	0.00	0	1	0.00
log file sequential read	6	0.00	0	7	0.00
latch: redo writing	451	0.00	0	0	0.00
cursor: mutex S	119	0.00	0	0	0.00
latch: enqueue hash chains	23	0.00	0	0	0.00
cursor: mutex X	236	0.00	0	0	0.00
latch: checkpoint queue latch	8	0.00	0	0	0.00
direct path read	1,830	0.00	0	0	0.00
enq: CU - contention	1	0.00	0	3	0.00
enq: PS - contention	49	0.00	0	0	0.00
enq: US - contention	1	0.00	0	2	0.00
direct path write	771	0.00	0	0	0.00
log file single write	6	0.00	0	0	0.00
direct path write temp	38	0.00	0	0	0.00
direct path read temp	6	0.00	0	0	0.00
L1 validation	1	0.00	0	0	0.00
SQL*Net message from client	35,463,916	0.00	6,983,862	197	37.79
pipe get	21,908	21.07	21,063	961	0.02
Streams AQ: waiting for messages in the queue	2,389	100.00	11,658	4880	0.00
PX Idle Wait	3,284	76.49	5,180	1577	0.00
Streams AQ: qmn slave idle wait	129	0.00	3,517	27263	0.00
Streams AQ: qmn coordinator idle wait	258	50.00	3,517	13631	0.00
Streams AQ: waiting for time management or cleanup tasks	2,221	38.63	3,513	1582	0.00
PL/SQL lock timer	260	99.62	2,859	10995	0.00
jobq slave wait	612	99.51	1,792	2927	0.00
PX Deq: Execution Msg	11,497	0.00	64	6	0.01
PX Deq: Msg Fragment	9,341	0.00	3	0	0.01
PX Deq Credit: need buffer	3,718	0.00	3	1	0.00
PX Deq: Execute Reply	4,272	0.00	2	1	0.00
PX Deq: Table Q Normal	8,191	0.00	1	0	0.01
PX Deq: Parse Reply	318	0.00	0	1	0.00
PX Deq: Join ACK	205	0.00	0	0	0.00
class slave wait	1	0.00	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)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	646,399	0.00	324	1	0.69
db file scattered read	189	0.00	6	31	0.00
control file parallel write	1,859	0.00	4	2	0.00
events in waitclass Other	35,017	0.00	3	0	0.04
os thread startup	60	0.00	2	41	0.00
db file sequential read	127	0.00	2	14	0.00
latch: cache buffers chains	37	0.00	0	1	0.00
log file sequential read	6	0.00	0	7	0.00
latch: redo writing	451	0.00	0	0	0.00
control file sequential read	1,019	0.00	0	0	0.00
direct path read	1,830	0.00	0	0	0.00
log file sync	1	0.00	0	1	0.00
latch: shared pool	2	0.00	0	0	0.00
log file single write	6	0.00	0	0	0.00
direct path write	666	0.00	0	0	0.00
buffer busy waits	6	0.00	0	0	0.00
latch: library cache pin	1	0.00	0	0	0.00
latch: library cache	1	0.00	0	0	0.00
rdbms ipc message	957,368	1.05	30,235	32	1.02
pmon timer	1,245	98.15	3,518	2826	0.00
Streams AQ: qmn slave idle wait	129	0.00	3,517	27263	0.00
Streams AQ: qmn coordinator idle wait	258	50.00	3,517	13631	0.00
Streams AQ: waiting for time management or cleanup tasks	2,221	38.63	3,513	1582	0.00
smon timer	110,961	0.00	3,500	32	0.12

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	2,602,998
IDLE_TIME	3,159,677
IOWAIT_TIME	176,689
NICE_TIME	24,344
SYS_TIME	167,761
USER_TIME	2,320,535
LOAD	5
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,680
NUM_CPUS	16
NUM_CPU_SOCKETS	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	Logical Reads
SYS$USERS	29,764.10	23,670.60	439,838	1,835,664,722
SYS$BACKGROUND	0.00	0.00	10,477	2,750,458
VIS	0.00	0.00	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in centisecond (100th of a second)

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	311579	387071	2389439	63818	0	0	38808378	54444
SYS$BACKGROUND	2814	769	107	252	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 Gets
SQL ordered by Reads
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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
913	905	300	3.04	3.07	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
606	16	1,608	0.38	2.04	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
576	106	1,608	0.36	1.93	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
516	509	54,779	0.01	1.73	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
492	441	75,489	0.01	1.65	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
477	153	10,000	0.05	1.60	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
469	382	135,421	0.00	1.58	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
462	456	54,753	0.01	1.55	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
451	445	54,777	0.01	1.52	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
426	3	56	7.60	1.43	9k7t8q4kfcb7y	SQL*Plus	begin GL.apps_ddl.apps_ddl(:dd...
395	393	250,190	0.00	1.33	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
395	392	63,632	0.01	1.33	auzgm2ap4faw2	JDBC Thin Client	(SELECT SUB.GUID SUB_GUID, DE...
361	260	178,061	0.00	1.21	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
340	153	14,428	0.02	1.14	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
332	327	61,003	0.01	1.11	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
325	304	960	0.34	1.09	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...

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 DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
905	913	300	3.02	3.07	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
509	516	54,779	0.01	1.73	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
456	462	54,753	0.01	1.55	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
445	451	54,777	0.01	1.52	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
441	492	75,489	0.01	1.65	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
393	395	250,190	0.00	1.33	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
392	395	63,632	0.01	1.33	auzgm2ap4faw2	JDBC Thin Client	(SELECT SUB.GUID SUB_GUID, DE...
382	469	135,421	0.00	1.58	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
327	332	61,003	0.01	1.11	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
304	325	960	0.32	1.09	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
260	361	178,061	0.00	1.21	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
153	340	14,428	0.01	1.14	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
153	477	10,000	0.02	1.60	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
106	576	1,608	0.07	1.93	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
16	606	1,608	0.01	2.04	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
3	426	56	0.06	1.43	9k7t8q4kfcb7y	SQL*Plus	begin GL.apps_ddl.apps_ddl(:dd...

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: 1,838,606,145
Captured SQL account for 19.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
154,609,170	63,632	2,429.74	8.41	392.26	394.54	auzgm2ap4faw2	JDBC Thin Client	(SELECT SUB.GUID SUB_GUID, DE...
50,983,873	135,421	376.48	2.77	381.69	469.18	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
49,501,029	178,061	278.00	2.69	259.95	361.11	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
48,884,721	54,779	892.40	2.66	508.71	515.98	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
42,139,016	300	140,463.39	2.29	905.24	913.37	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
34,792,380	54,777	635.16	1.89	444.59	451.10	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
30,757,598	166,006	185.28	1.67	226.40	232.70	gf1u933c95jb5	INVTTMTX	DECLARE l_ret_stat varchar2...
30,734,080	165,952	185.20	1.67	242.56	248.94	3b3psftuyks81	INVTTMTX	BEGIN INV_TXNSTUB_PUB.postTran...
29,083,420	4,810	6,046.45	1.58	177.65	266.54	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
28,496,267	1,367,169	20.84	1.55	157.03	158.39	66tmsr3446uqn	ap.oie.server.WebExpensesAM	SELECT WIAS.ACTIVITY_STATUS, ...
26,396,111	10,000	2,639.61	1.44	152.71	476.63	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
25,274,754	11	2,297,704.91	1.37	137.45	137.45	bp8crdjba8zgt	ARGLTP	update ra_cust_trx_line_gl_dis...
23,569,103	61,003	386.36	1.28	327.00	331.62	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
22,723,860	54,753	415.02	1.24	456.16	461.98	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 450,456
Captured SQL account for 39.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
45,235	10,000	4.52	10.04	152.71	476.63	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
43,071	1,608	26.79	9.56	15.51	606.16	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
31,440	1,608	19.55	6.98	106.27	576.00	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
26,190	4,744	5.52	5.81	5.22	200.72	auudu2jzbt9s0	CSCCCCRC	SELECT HD.ID CONTRACT_ID , HD....
21,900	14,428	1.52	4.86	153.03	340.37	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
13,330	178,061	0.07	2.96	259.95	361.11	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
11,601	2,728	4.25	2.58	14.54	177.88	72cqcsuq5wgh0	asn.dashboard.server.DashboardAM	SELECT aslrt.meaning as rank_n...
11,213	481	23.31	2.49	121.19	201.73	dk0sqcvc2xjvs	qotSCopHdrUpd.jsp	BEGIN ASO_QUOTE_PUB_W.Create_Q...
10,332	4,810	2.15	2.29	177.65	266.54	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
10,277	135,421	0.08	2.28	381.69	469.18	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
4,600	9,999	0.46	1.02	193.93	231.76	csvvv0fmhr1yc	PYUSLV	BEGIN FFP1893_01010001.FORMULA...
4,511	10,000	0.45	1.00	161.22	195.25	63t8zpm02skgh	PYUSLV	SELECT DECODE(COUNT(PRR.RUN_RE...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 81,465,418
Captured SQL account for 9.7% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
1,367,169	708,194	0.52	66tmsr3446uqn	ap.oie.server.WebExpensesAM	SELECT WIAS.ACTIVITY_STATUS, ...
779,854	779,828	1.00	cd9mbmqyf4qhp	ap.oie.server.WebExpensesAM	UPDATE WF_ITEM_ACTIVITY_STATUS...
727,444	727,393	1.00	gnhmcahkmrnzs	ap.oie.server.WebExpensesAM	INSERT INTO WF_ITEM_ACTIVITY_S...
425,176	182,983	0.43	0wrz2kbatczjk	CSCCCCRC	SELECT EXECUTE_FLAG FROM JTF_U...
402,534	402,535	1.00	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
251,282	196,270	0.78	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
250,190	250,182	1.00	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
197,021	3,349,185	17.00	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
178,061	0	0.00	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
166,006	165,994	1.00	gf1u933c95jb5	INVTTMTX	DECLARE l_ret_stat varchar2...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 6,805,891
Captured SQL account for 44.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
402,538	402,534	5.91	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
251,283	251,282	3.69	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
250,194	250,190	3.68	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
197,022	197,021	2.89	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
165,288	165,994	2.43	6gnth2mfbs2nq	INVTTMTX	declare v_ret number := 0...
135,422	135,421	1.99	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
116,403	116,817	1.71	fb13x9qx0ftks	OEXOETEL	begin OE_STANDARD_WF.OEOL_SELE...
111,002	111,241	1.63	1c0b7sas42w2z	INVTTMTX	SELECT NVL(ITEM_COST, 0), ...
87,408	87,546	1.28	76sw2a4vnc89j	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.S...
83,466	83,492	1.23	bf7uwg5pa3pj6	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.V...
83,461	87,538	1.23	dcvv68fju01g4	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.E...
83,439	83,524	1.23	608c0n36kaw62	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.C...
80,329	80,328	1.18	162ttnv4ubqun	OEXOETEL	begin OE_DS_PVT.Check_PO_Appr...
74,300	74,309	1.09	8camsgjsr9zya	OEXOETEL	begin OE_TRANSACTION_TYPES_PK...
69,996	69,995	1.03	97mt0g20bcfc3	PYUSLV	begin ...

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

0wrz2kbatczjk SELECT EXECUTE_FLAG FROM JTF_USER_HOOKS WHERE PKG_NAME = :B4 AND API_NAME = :B3 AND PROCESSING_TYPE = :B2 AND USER_HOOK_TYPE = :B1

0z318y6g3uagc declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx

SQL Id	SQL Text
0wrz2kbatczjk	SELECT EXECUTE_FLAG FROM JTF_USER_HOOKS WHERE PKG_NAME = :B4 AND API_NAME = :B3 AND PROCESSING_TYPE = :B2 AND USER_HOOK_TYPE = :B1
0z318y6g3uagc	declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx