	\| 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 Cluster Host

VIS 127695557 VIS 1 10.1.0.5.0 NO db0

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 54 18-May-06 20:51:42 3699 181.5

End Snap: 55 18-May-06 21:53:00 3727 233.2

Elapsed: 61.31 (mins)

DB Time: 747.99 (mins)

Report Summary

Cache Sizes (end)

Buffer Cache: 7,168M Std Block Size: 8K

Shared Pool Size: 3,072M Log Buffer: 16,384K

Load Profile

Per Second Per Transaction

Redo size: 8,268,482.75 31,317.99

Logical reads: 501,805.49 1,900.66

Block changes: 51,173.66 193.83

Physical reads: 263.73 1.00

Physical writes: 730.48 2.77

User calls: 9,146.60 34.64

Parses: 2,291.13 8.68

Hard parses: 2.21 0.01

Sorts: 2,905.29 11.00

Logons: 1.98 0.01

Executes: 21,631.84 81.93

Transactions: 264.02

% Blocks changed per Read: 10.20 Recursive Call %: 80.01

Rollback per transaction %: 19.11 Rows per Sort: 21.22

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97 Redo NoWait %: 100.00

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

Library Hit %: 99.99 Soft Parse %: 99.90

Execute to Parse %: 89.41 Latch Hit %: 98.84

Parse CPU to Parse Elapsd %: 51.02 % Non-Parse CPU: 97.38

Shared Pool Statistics

Begin End

Memory Usage %: 66.28 91.99

% SQL with executions>1: 64.61 80.65

% Memory for SQL w/exec>1: 71.64 59.87

Top 5 Timed Events

Event Waits Time(s) Percent Total DB Time Wait Class

CPU time 24,901 55.48

db file sequential read 776,411 3,230 7.20 User I/O

latch: cache buffers chains 102,687 1,096 2.44 Concurrency

log file sync 360,905 978 2.18 Commit

log file parallel write 1,343,916 852 1.90 System I/O

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
SGA Statistics
Resource Limit Statistics
init.ora Parameters

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	Timeouts	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file sequential read	776,411	0	3,230	4	0.80
latch: cache buffers chains	102,687	102,687	1,096	11	0.11
log file sync	360,905	0	978	3	0.37
log file parallel write	1,343,916	0	852	1	1.38
enq: UL - contention	4,128	35	560	136	0.00
enq: TX - row lock contention	616	111	349	567	0.00
db file parallel write	227,709	0	326	1	0.23
buffer busy waits	532,562	8	148	0	0.55
SQL*Net more data from client	1,821,495	0	123	0	1.88
read by other session	83,966	0	118	1	0.09
library cache pin	3,248	0	89	27	0.00
latch: In memory undo latch	5,991	0	59	10	0.01
enq: TX - index contention	14,313	0	56	4	0.01
latch: undo global data	5,963	0	51	9	0.01
db file scattered read	17,760	0	50	3	0.02
SQL*Net more data to client	1,597,480	0	45	0	1.64
rdbms ipc reply	17,904	5	32	2	0.02
latch free	2,643	2,546	31	12	0.00
SQL*Net message to client	35,026,603	0	27	0	36.07
library cache load lock	711	0	26	37	0.00
latch: library cache	7,615	0	25	3	0.01
SQL*Net break/reset to client	50,204	0	23	0	0.05
local write wait	3,304	0	18	6	0.00
enq: CI - contention	6,521	0	18	3	0.01
direct path read temp	9,890	0	17	2	0.01
LGWR wait for redo copy	46,169	71	9	0	0.05
library cache lock	309	0	8	26	0.00
enq: RO - fast object reuse	36	0	8	214	0.00
PX Deq Credit: send blkd	5,582	0	8	1	0.01
direct path write temp	3,171	0	6	2	0.00
control file parallel write	1,638	0	5	3	0.00
enq: HW - contention	2,687	0	4	2	0.00
enq: TX - contention	2,717	0	4	2	0.00
enq: TM - contention	2	0	4	1,768	0.00
enq: SQ - contention	3,735	0	3	1	0.00
latch: redo allocation	616	0	3	4	0.00
latch: library cache pin	1,261	0	2	2	0.00
PX Deq: Signal ACK	123	34	2	13	0.00
log file switch completion	35	0	1	32	0.00
control file sequential read	923	0	1	1	0.00
latch: cache buffers lru chain	148	0	1	7	0.00
enq: DV - contention	69	0	1	12	0.00
latch: row cache objects	102	0	1	8	0.00
row cache lock	869	0	1	1	0.00
process startup	17	0	0	29	0.00
enq: CU - contention	28	0	0	17	0.00
enq: FB - contention	1,030	0	0	0	0.00
latch: session allocation	104	0	0	3	0.00
latch: cache buffer handles	80	0	0	2	0.00
latch: shared pool	50	0	0	2	0.00
latch: object queue header operation	44	0	0	3	0.00
control file single write	134	0	0	1	0.00
latch: library cache lock	44	0	0	3	0.00
PX qref latch	10	9	0	11	0.00
buffer deadlock	5,980	5,957	0	0	0.01
kksfbc child completion	2	2	0	49	0.00
enq: TX - allocate ITL entry	167	0	0	1	0.00
direct path read	420	0	0	0	0.00
undo segment extension	16,791	16,742	0	0	0.02
latch: enqueue hash chains	15	0	0	3	0.00
latch: redo writing	13	0	0	3	0.00
direct path write	2,950	0	0	0	0.00
db file parallel read	1	0	0	6	0.00
latch: checkpoint queue latch	2	0	0	2	0.00
log file sequential read	2	0	0	1	0.00
enq: PS - contention	15	0	0	0	0.00
log file single write	2	0	0	0	0.00
PX Deq: Table Q qref	12	0	0	0	0.00
L1 validation	1	0	0	0	0.00
SQL*Net message from client	35,026,574	0	7,652,778	218	36.07
queue messages	6,756	6,054	41,096	6,083	0.01
pipe get	17,814	5,013	21,552	1,210	0.02
PL/SQL lock timer	710	709	8,191	11,536	0.00
PX Idle Wait	2,595	2,453	4,816	1,856	0.00
Queue Monitor Wait	123	123	3,583	29,134	0.00
wakeup time manager	1,760	914	2,754	1,565	0.00
PX Deq: Execution Msg	5,468	20	81	15	0.01
jobq slave wait	22	21	63	2,885	0.00
PX Deq: Execute Reply	3,823	1	15	4	0.00
PX Deq: Msg Fragment	1,035	0	2	2	0.00
PX Deq: Parse Reply	87	0	1	13	0.00
PX Deq Credit: need buffer	974	0	1	1	0.00
PX Deq: Table Q Normal	1,556	0	1	0	0.00
PX Deq: Table Q Sample	40	0	0	2	0.00
PX Deq: Join ACK	96	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)

Event	Waits	Timeouts	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	1,343,890	0	852	1	1.38
db file parallel write	227,709	0	326	1	0.23
LGWR wait for redo copy	46,170	71	9	0	0.05
db file scattered read	1,855	0	7	4	0.00
control file parallel write	1,634	0	5	3	0.00
latch: cache buffers chains	238	238	3	11	0.00
db file sequential read	883	0	2	2	0.00
rdbms ipc reply	7,114	0	1	0	0.01
latch free	141	131	1	10	0.00
control file sequential read	690	0	1	1	0.00
latch: redo allocation	264	0	1	2	0.00
latch: library cache	250	0	0	2	0.00
enq: CI - contention	54	0	0	4	0.00
buffer busy waits	576	0	0	0	0.00
latch: cache buffers lru chain	55	0	0	2	0.00
control file single write	133	0	0	1	0.00
direct path read	420	0	0	0	0.00
latch: redo writing	13	0	0	3	0.00
process startup	1	0	0	37	0.00
latch: library cache pin	21	0	0	2	0.00
latch: session allocation	8	0	0	3	0.00
direct path write	220	0	0	0	0.00
latch: shared pool	9	0	0	2	0.00
latch: object queue header operation	7	0	0	2	0.00
latch: In memory undo latch	8	0	0	1	0.00
latch: library cache lock	2	0	0	3	0.00
latch: undo global data	5	0	0	1	0.00
log file sequential read	2	0	0	1	0.00
latch: checkpoint queue latch	1	0	0	1	0.00
log file single write	2	0	0	0	0.00
undo segment extension	220	219	0	0	0.00
rdbms ipc message	677,543	9,543	26,928	40	0.70
Queue Monitor Wait	123	123	3,583	29,134	0.00
smon timer	53,148	0	3,555	67	0.05
wakeup time manager	1,760	914	2,754	1,565	0.00

Back to Wait Events Statistics
Back to Top

Time Model Statistics

ordered by Time (seconds) desc

Statistic Name	Time (seconds)	% Total DB Time
DB time	44,879.34	100.00
sql execute elapsed time	38,914.87	86.71
DB CPU	24,901.06	55.48
PL/SQL execution elapsed time	8,959.25	19.96
inbound PL/SQL rpc elapsed time	7,212.29	16.07
Java execution elapsed time	2,486.05	5.54
background elapsed time	2,204.50	4.91
parse time elapsed	1,224.60	2.73
hard parse elapsed time	843.74	1.88
background cpu time	583.59	1.30
sequence load elapsed time	23.00	0.05
connection management call elapsed time	15.27	0.03
PL/SQL compilation elapsed time	10.77	0.02
failed parse elapsed time	3.93	0.01
hard parse (sharing criteria) elapsed time	2.73	0.01
hard parse (bind mismatch) elapsed time	2.03	0.00
failed parse (out of shared memory) elapsed t	0.00	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Name	Value
AVG_BUSY_TICKS	4,665,185
AVG_IDLE_TICKS	126,891
AVG_IN_BYTES	86,784
AVG_IOWAIT_TICKS	10,014
AVG_OUT_BYTES	905,472
AVG_SYS_TICKS	16,039
AVG_USER_TICKS	224,564
BUSY_TICKS	74,644,766
IDLE_TICKS	2,032,077
IN_BYTES	1,388,544
IOWAIT_TICKS	161,939
OS_CPU_WAIT_TIME	4,640,200
OUT_BYTES	14,487,552
RSRC_MGR_CPU_WAIT_TIME	0
SYS_TICKS	258,597
USER_TICKS	3,594,926

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
VIS	34,643.50	18,833.90	413,743	1,656,616,604
SYS$USERS	10,231.80	6,066.50	540,689	171,041,257
SYS$BACKGROUND	0.00	0.00	15,806	18,204,740

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	Network Total Wts	Network Wt Time
VIS	429,623	129,917	659,778	147,527	16,747,188	16,580
SYS$USERS	465,498	213,103	8,736	3,281	21,687,405	2,888
SYS$BACKGROUND	3,378	894	1,095	340	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
4,964	2,687	8	620.45	11.06	ghw9svn8x4vzu	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
3,368	1,771	10	336.83	7.51	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
2,885	1,128	276	10.45	6.43	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
1,472	744	10	147.15	3.28	8c30hkqv9n7cr	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,071	684	8	133.87	2.39	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
972	481	8	121.46	2.17	1nj7kuvxgpwah	RAXTRX	begin ARP_TAX . SET_DEFAULT_TA...
797	437	49,980	0.02	1.78	gk43kd7q5mak4	RAXTRX	update ra_customer_trx_lines l...
701	96	1,630	0.43	1.56	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
697	15	1,630	0.43	1.55	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
695	431	54,857	0.01	1.55	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
608	482	76,694	0.01	1.35	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
603	480	154,847	0.00	1.34	5kqw5535fjvw6	ARXTWMAI	SELECT NVL(RCTT.ATTRIBUTE10, ...
551	120	166,092	0.00	1.23	6gnth2mfbs2nq	WSHFRREL	declare v_ret number := 0...
501	262	975	0.51	1.12	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
499	265	8	62.32	1.11	8vmj377jqyqwq	WSHASCSRS	BEGIN WSH_BATCH_PROCESS.CONFIR...
489	316	5,000	0.10	1.09	2fjd6cndjby9p	ARTERRPW	INSERT INTO RA_CUST_TRX_LINE_G...

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
2,687	4,964	8	335.83	11.06	ghw9svn8x4vzu	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
1,771	3,368	10	177.09	7.51	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,128	2,885	276	4.09	6.43	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
744	1,472	10	74.37	3.28	8c30hkqv9n7cr	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
684	1,071	8	85.51	2.39	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
482	608	76,694	0.01	1.35	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
481	972	8	60.07	2.17	1nj7kuvxgpwah	RAXTRX	begin ARP_TAX . SET_DEFAULT_TA...
480	603	154,847	0.00	1.34	5kqw5535fjvw6	ARXTWMAI	SELECT NVL(RCTT.ATTRIBUTE10, ...
437	797	49,980	0.01	1.78	gk43kd7q5mak4	RAXTRX	update ra_customer_trx_lines l...
431	695	54,857	0.01	1.55	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
316	489	5,000	0.06	1.09	2fjd6cndjby9p	ARTERRPW	INSERT INTO RA_CUST_TRX_LINE_G...
265	499	8	33.14	1.11	8vmj377jqyqwq	WSHASCSRS	BEGIN WSH_BATCH_PROCESS.CONFIR...
262	501	975	0.27	1.12	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
120	551	166,092	0.00	1.23	6gnth2mfbs2nq	WSHFRREL	declare v_ret number := 0...
96	701	1,630	0.06	1.56	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
15	697	1,630	0.01	1.55	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...

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,845,878,943
Captured SQL accounts for 34.6% of Total Buffer Gets

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
239,659,840	8	29,957,480.00	12.98	2,686.64	4,963.62	ghw9svn8x4vzu	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
167,759,314	10	16,775,931.40	9.09	1,770.86	3,368.35	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
127,978,690	8	15,997,336.25	6.93	480.52	971.72	1nj7kuvxgpwah	RAXTRX	begin ARP_TAX . SET_DEFAULT_TA...
120,250,674	49,980	2,405.98	6.51	437.46	797.05	gk43kd7q5mak4	RAXTRX	update ra_customer_trx_lines l...
106,174,425	8	13,271,803.13	5.75	684.10	1,070.93	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
84,023,742	154,847	542.62	4.55	480.39	602.54	5kqw5535fjvw6	ARXTWMAI	SELECT NVL(RCTT.ATTRIBUTE10, ...
81,634,949	10	8,163,494.90	4.42	743.67	1,471.52	8c30hkqv9n7cr	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
48,745,291	276	176,613.37	2.64	1,128.33	2,885.48	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
45,193,653	8	5,649,206.63	2.45	272.90	390.12	1du9v021t8m46	ARGLTP	insert into gl_interface(creat...
44,949,409	8	5,618,676.13	2.44	154.37	384.94	815ygd4pc1bpd	RAXTRX	INSERT INTO RA_CUSTOMER_TRX_LI...
42,720,179	8	5,340,022.38	2.31	165.61	340.94	5qyckzm5v1qmj	RAXTRX	begin :return_value:i_return_v...
39,136,891	54,857	713.43	2.12	430.58	695.16	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
38,123,429	166,060	229.58	2.07	312.28	420.90	gf1u933c95jb5	WSHFRREL	DECLARE l_ret_stat varchar2...
38,122,936	166,058	229.58	2.07	330.34	441.33	3b3psftuyks81	WSHFRREL	BEGIN INV_TXNSTUB_PUB.postTran...
35,634,935	5,000	7,126.99	1.93	316.14	488.61	2fjd6cndjby9p	ARTERRPW	INSERT INTO RA_CUST_TRX_LINE_G...
34,788,273	984	35,353.94	1.88	149.59	230.21	0qcpgw43yqj5r	WSHPSRS	( SELECT DISTINCT WDD.SOURCE_L...
33,282,078	8	4,160,259.75	1.80	191.61	281.25	bp8crdjba8zgt	ARGLTP	update ra_cust_trx_line_gl_dis...
27,741,885	48	577,955.94	1.50	148.88	309.41	37f1qguwxw0sk	RAXTRX	begin IF ( :v_msg_level:i_msg_...
26,810,724	2,072	12,939.54	1.45	150.30	247.65	4adc1zhg5cmx0	WSHINTERFACE	UPDATE WSH_DELIVERY_DETAILS DD...
26,381,998	9,999	2,638.46	1.43	117.57	343.53	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
21,570,110	1,374,997	15.69	1.17	189.65	238.36	66tmsr3446uqn	OEXOETEL	SELECT WIAS.ACTIVITY_STATUS, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 970,106
Captured SQL accounts for 42.6% of Total Disk Reads

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
150,304	1,630	92.21	15.49	14.79	697.01	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
113,113	1,630	69.39	11.66	96.26	700.53	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
54,669	2,816	19.41	5.64	10.37	260.59	72cqcsuq5wgh0	asn.dashboard.server.DashboardAM	SELECT aslrt.meaning as rank_n...
54,465	9,999	5.45	5.61	117.57	343.53	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
21,664	10	2,166.40	2.23	1,770.86	3,368.35	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
17,137	268,503	0.06	1.77	86.06	127.98	ccprbqfuu8wb1	WSHINTERFACE	SELECT NUMBER_VALUE FROM WF_IT...
16,559	14,700	1.13	1.71	87.29	271.06	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
9,555	1	9,555.00	0.98	30.01	42.46	gczkkgwgkyjh3	SQL*Plus	select /*+ parallel(t, 8) para...
2,826	8	353.25	0.29	272.90	390.12	1du9v021t8m46	ARGLTP	insert into gl_interface(creat...
2,427	8	303.38	0.25	191.61	281.25	bp8crdjba8zgt	ARGLTP	update ra_cust_trx_line_gl_dis...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 79,572,170
Captured SQL accounts for 13.0% of Total Executions

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
1,374,997	712,433	0.52	66tmsr3446uqn	OEXOETEL	SELECT WIAS.ACTIVITY_STATUS, ...
865,962	865,962	1.00	cgb6kp2umq52a		select t.schema, t.name, t.f...
865,678	865,678	1.00	8bsm049u7thjd		select min(next_date) from "AP...
784,308	784,027	1.00	cd9mbmqyf4qhp	OEXOETEL	UPDATE WF_ITEM_ACTIVITY_STATUS...
731,652	731,116	1.00	gnhmcahkmrnzs	OEXOETEL	INSERT INTO WF_ITEM_ACTIVITY_S...
426,540	426,583	1.00	821fx90awyvj7	OEXOETEL	SELECT ACCOUNTING_RULE_ID , A...
410,265	410,229	1.00	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
268,503	267,709	1.00	ccprbqfuu8wb1	WSHINTERFACE	SELECT NUMBER_VALUE FROM WF_IT...
254,432	198,120	0.78	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
219,964	217,524	0.99	91hakq9n36htp	ap.oie.server.WebExpensesAM	SELECT TEXT_VALUE FROM WF_ITEM...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 8,427,854
Captured SQL accounts for 56.8% of Total Parse Calls

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
865,962	865,962	10.28	cgb6kp2umq52a		select t.schema, t.name, t.f...
865,678	1,416	10.27	20rc3cmapyvnz		select q_name, state, delay,...
865,678	865,678	10.27	8bsm049u7thjd		select min(next_date) from "AP...
410,274	410,265	4.87	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
254,548	254,432	3.02	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
166,037	166,092	1.97	6gnth2mfbs2nq	WSHFRREL	declare v_ret number := 0...
111,255	111,255	1.32	1c0b7sas42w2z	WSHFRREL	SELECT NVL(ITEM_COST, 0), ...
87,825	87,885	1.04	76sw2a4vnc89j	ARXTWMAI	begin FND_FLEX_WORKFLOW_APIS.S...
83,795	83,783	0.99	bf7uwg5pa3pj6	ARXTWMAI	begin FND_FLEX_WORKFLOW_APIS.V...
83,788	87,854	0.99	dcvv68fju01g4	ARXTWMAI	begin FND_FLEX_WORKFLOW_APIS.E...

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
5,313,112	8	0.16	awz0s801s8fh2	RAXMTR	select /*+ parallel(t, 8) para...
2,218,920	8	0.07	45z5kajtbgmj0	RAXMTR	select /*+ parallel(t, 8) para...
1,064,052	1	0.03	gczkkgwgkyjh3	SQL*Plus	select /*+ parallel(t, 8) para...

WORKLOAD REPOSITORY report for

Report Summary

Main Report

Wait Events Statistics

Wait Events

Background Wait Events

Time Model Statistics

Operating System Statistics

Service Statistics

Service Wait Class Stats

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