	\| 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 118468335 VIS 1 10.1.0.4.0 NO oasb-db.oasb.hp

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 969 18-Mar-08 06:12:05 1840 147.3

End Snap: 970 18-Mar-08 07:12:06 1847 162.1

Elapsed: 60.02 (mins)

DB Time: 132.41 (mins)

Report Summary

Cache Sizes (end)

Buffer Cache: 5,024M Std Block Size: 8K

Shared Pool Size: 3,104M Log Buffer: 2,048K

Load Profile

Per Second Per Transaction

Redo size: 2,268,683.17 23,308.73

Logical reads: 111,982.73 1,150.52

Block changes: 14,028.95 144.14

Physical reads: 81.02 0.83

Physical writes: 223.00 2.29

User calls: 4,170.92 42.85

Parses: 2,029.60 20.85

Hard parses: 1.94 0.02

Sorts: 1,199.80 12.33

Logons: 0.92 0.01

Executes: 9,203.76 94.56

Transactions: 97.33

% Blocks changed per Read: 12.53 Recursive Call %: 80.59

Rollback per transaction %: 23.15 Rows per Sort: 14.21

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99 Redo NoWait %: 100.00

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

Library Hit %: 99.98 Soft Parse %: 99.90

Execute to Parse %: 77.95 Latch Hit %: 99.85

Parse CPU to Parse Elapsd %: 96.74 % Non-Parse CPU: 95.15

Shared Pool Statistics

Begin End

Memory Usage %: 44.99 56.78

% SQL with executions>1: 88.54 83.37

% Memory for SQL w/exec>1: 86.79 66.45

Top 5 Timed Events

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

CPU time 7,078 89.09

db file sequential read 153,380 621 7.81 User I/O

log file parallel write 564,983 124 1.56 System I/O

log file sync 146,957 86 1.08 Commit

db file scattered read 13,564 60 .76 User 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	153,380	0	621	4	0.44
log file parallel write	564,983	0	124	0	1.61
log file sync	146,957	0	86	1	0.42
db file scattered read	13,564	0	60	4	0.04
enq: TX - row lock contention	196	0	60	306	0.00
db file parallel write	93,699	0	43	0	0.27
enq: TM - contention	16	1	36	2,243	0.00
buffer busy waits	28,409	1	28	1	0.08
SQL*Net message to client	15,729,075	0	24	0	44.87
library cache pin	1,434	3	24	16	0.00
read by other session	9,380	0	21	2	0.03
enq: TX - index contention	4,969	0	15	3	0.01
SQL*Net more data from client	770,080	0	13	0	2.20
enq: UL - contention	420	3	13	30	0.00
rdbms ipc reply	2,730	5	12	4	0.01
SQL*Net more data to client	642,321	0	6	0	1.83
latch: library cache	12,169	0	5	0	0.03
SQL*Net break/reset to client	31,296	0	4	0	0.09
PX Deq: Signal ACK	280	106	4	15	0.00
direct path read temp	1,529	0	3	2	0.00
control file sequential read	1,505	0	3	2	0.00
enq: RO - fast object reuse	197	0	1	7	0.00
library cache load lock	138	0	1	8	0.00
control file parallel write	1,570	0	1	1	0.00
local write wait	1,241	0	1	1	0.00
direct path write temp	1,869	0	1	0	0.01
enq: DV - contention	73	0	1	8	0.00
PX Deq Credit: send blkd	1,669	0	1	0	0.00
latch: library cache pin	1,064	0	0	0	0.00
enq: SQ - contention	2,244	0	0	0	0.01
latch: session allocation	529	0	0	1	0.00
latch: shared pool	1,613	0	0	0	0.00
PX qref latch	56	26	0	6	0.00
process startup	20	0	0	14	0.00
latch: cache buffers chains	717	0	0	0	0.00
LGWR wait for redo copy	4,561	0	0	0	0.01
enq: CU - contention	10	0	0	15	0.00
kksfbc child completion	3	3	0	50	0.00
latch: undo global data	1,345	0	0	0	0.00
direct path read	200	0	0	1	0.00
latch: In memory undo latch	979	0	0	0	0.00
latch free	210	0	0	0	0.00
enq: TX - allocate ITL entry	8	0	0	6	0.00
control file single write	123	0	0	0	0.00
enq: HW - contention	41	0	0	1	0.00
enq: TX - contention	66	0	0	1	0.00
latch: library cache lock	69	0	0	0	0.00
latch: row cache objects	36	0	0	1	0.00
latch: object queue header operation	22	0	0	1	0.00
latch: cache buffers lru chain	49	0	0	0	0.00
latch: redo allocation	68	0	0	0	0.00
latch: enqueue hash chains	10	0	0	0	0.00
latch: checkpoint queue latch	12	0	0	0	0.00
direct path write	1,266	0	0	0	0.00
log buffer space	1	0	0	3	0.00
latch: cache buffer handles	16	0	0	0	0.00
undo segment extension	1,377	1,365	0	0	0.00
enq: FB - contention	17	0	0	0	0.00
enq: PS - contention	29	0	0	0	0.00
latch: redo writing	3	0	0	0	0.00
PX Deq: Table Q qref	16	0	0	0	0.00
row cache lock	7	0	0	0	0.00
buffer deadlock	589	587	0	0	0.00
latch: messages	2	0	0	0	0.00
SQL*Net message from client	15,729,067	0	3,653,911	232	44.87
pipe get	12,645	6,716	17,570	1,389	0.04
queue messages	1,258	967	10,184	8,095	0.00
PX Idle Wait	2,736	2,400	4,707	1,721	0.01
Queue Monitor Wait	120	120	3,489	29,074	0.00
wakeup time manager	1,695	688	3,171	1,871	0.00
PL/SQL lock timer	59	55	1,465	24,829	0.00
PX Deq: Execution Msg	7,006	33	149	21	0.02
jobq slave wait	22	21	63	2,886	0.00
PX Deq: Execute Reply	4,834	2	18	4	0.01
class slave wait	2	2	10	4,883	0.00
PX Deq: Table Q Normal	1,899	0	1	0	0.01
PX Deq: Msg Fragment	2,026	0	1	0	0.01
PX Deq Credit: need buffer	830	0	0	0	0.00
PX Deq: Parse Reply	158	0	0	1	0.00
PX Deq: Join ACK	221	0	0	0	0.00
PX Deq: Table Q Sample	67	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	565,015	0	124	0	1.61
db file parallel write	93,699	0	43	0	0.27
db file scattered read	2,588	0	5	2	0.01
control file sequential read	627	0	2	3	0.00
db file sequential read	694	0	1	2	0.00
buffer busy waits	399	0	1	2	0.00
control file parallel write	1,570	0	1	1	0.00
rdbms ipc reply	2,366	0	0	0	0.01
latch: library cache	574	0	0	0	0.00
LGWR wait for redo copy	4,561	0	0	0	0.01
direct path read	200	0	0	1	0.00
process startup	3	0	0	15	0.00
control file single write	123	0	0	0	0.00
latch: shared pool	172	0	0	0	0.00
latch free	48	0	0	0	0.00
latch: redo allocation	67	0	0	0	0.00
latch: cache buffers lru chain	18	0	0	1	0.00
latch: library cache pin	29	0	0	0	0.00
latch: library cache lock	26	0	0	0	0.00
latch: session allocation	53	0	0	0	0.00
latch: undo global data	23	0	0	0	0.00
latch: object queue header operation	5	0	0	1	0.00
direct path write	150	0	0	0	0.00
latch: redo writing	3	0	0	0	0.00
latch: In memory undo latch	8	0	0	0	0.00
latch: enqueue hash chains	6	0	0	0	0.00
latch: cache buffers chains	5	0	0	0	0.00
enq: TX - index contention	1	0	0	0	0.00
latch: checkpoint queue latch	2	0	0	0	0.00
latch: messages	2	0	0	0	0.00
rdbms ipc message	320,739	9,871	26,632	83	0.92
Queue Monitor Wait	120	120	3,489	29,074	0.00
smon timer	10,972	0	3,448	314	0.03
wakeup time manager	1,695	688	3,171	1,871	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	7,944.33	100.00
DB CPU	7,077.72	89.09
sql execute elapsed time	6,629.04	83.44
PL/SQL execution elapsed time	1,997.44	25.14
inbound PL/SQL rpc elapsed time	1,689.93	21.27
background elapsed time	666.54	8.39
background cpu time	475.54	5.99
parse time elapsed	322.47	4.06
Java execution elapsed time	212.49	2.67
hard parse elapsed time	154.41	1.94
sequence load elapsed time	6.59	0.08
connection management call elapsed time	5.67	0.07
PL/SQL compilation elapsed time	2.91	0.04
failed parse elapsed time	1.31	0.02
hard parse (sharing criteria) elapsed time	0.64	0.01
hard parse (bind mismatch) elapsed time	0.61	0.01
failed parse (out of shared memory) elapsed t	0.00	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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	Logical Reads
VIS	6,326.90	5,684.60	170,933	326,146,471
SYS$USERS	1,617.10	1,392.70	70,589	42,731,755
SYS$BACKGROUND	0.00	0.00	32,790	34,163,988

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	128,062	47,794	46,319	7,184	12,152,077	3,542
SYS$USERS	43,162	20,779	2,585	110	4,984,168	837
SYS$BACKGROUND	11,326	2,173	1,044	110	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
398	398	2	198.81	5.01	ghw9svn8x4vzu	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
314	310	47,220	0.01	3.96	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
306	306	4	76.58	3.86	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
232	231	49,199	0.00	2.92	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
218	218	62	3.52	2.75	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
181	176	4	45.18	2.28	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
173	172	33,394	0.01	2.18	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
139	138	433	0.32	1.75	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
126	5	720	0.18	1.59	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
124	124	90,845	0.00	1.56	4dqasqjrvudqn	JDBC Thin Client	begin dbms_session.reset_packa...
124	57	5,000	0.02	1.56	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
114	106	3	38.06	1.44	8c30hkqv9n7cr	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
112	52	211	0.53	1.41	g0g2sj2by3p75	JDBC Thin Client	BEGIN WF_EVENT.LISTEN ( p_ag...
103	96	1,000	0.10	1.30	2fjd6cndjby9p	ARTERRPW	INSERT INTO RA_CUST_TRX_LINE_G...
92	64	6,485	0.01	1.15	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
85	85	2,186,809	0.00	1.07	6cjfxb1c4kx16		SELECT PROFILE_OPTION_ID, APP...
83	83	905,816	0.00	1.05	cgb6kp2umq52a		select t.schema, t.name, t.f...
82	82	12,165	0.01	1.04	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...

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
398	398	2	198.81	5.01	ghw9svn8x4vzu	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
310	314	47,220	0.01	3.96	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
306	306	4	76.58	3.86	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
231	232	49,199	0.00	2.92	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
218	218	62	3.51	2.75	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
176	181	4	44.03	2.28	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
172	173	33,394	0.01	2.18	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
138	139	433	0.32	1.75	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
124	124	90,845	0.00	1.56	4dqasqjrvudqn	JDBC Thin Client	begin dbms_session.reset_packa...
106	114	3	35.35	1.44	8c30hkqv9n7cr	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
96	103	1,000	0.10	1.30	2fjd6cndjby9p	ARTERRPW	INSERT INTO RA_CUST_TRX_LINE_G...
85	85	2,186,809	0.00	1.07	6cjfxb1c4kx16		SELECT PROFILE_OPTION_ID, APP...
83	83	905,816	0.00	1.05	cgb6kp2umq52a		select t.schema, t.name, t.f...
82	82	12,165	0.01	1.04	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
64	92	6,485	0.01	1.15	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
57	124	5,000	0.01	1.56	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
52	112	211	0.25	1.41	g0g2sj2by3p75	JDBC Thin Client	BEGIN WF_EVENT.LISTEN ( p_ag...
5	126	720	0.01	1.59	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: 403,293,371
Captured SQL accounts for 18.1% of Total Buffer Gets

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
25,045,672	4	6,261,418.00	6.21	306.31	306.31	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
22,048,178	4	5,512,044.50	5.47	176.13	180.74	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
21,343,432	2	10,671,716.00	5.29	397.63	397.63	ghw9svn8x4vzu	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
11,858,482	5,000	2,371.70	2.94	57.43	124.00	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
9,683,083	3	3,227,694.33	2.40	106.04	114.17	8c30hkqv9n7cr	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
9,643,067	2,832,039	3.40	2.39	74.23	74.25	c4y7jp0q2awbf		SELECT PROFILE_OPTION_VALUE FR...
9,631,831	47,220	203.98	2.39	310.25	314.47	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
9,226,312	1,000	9,226.31	2.29	95.99	102.92	2fjd6cndjby9p	ARTERRPW	INSERT INTO RA_CUST_TRX_LINE_G...
8,925,370	433	20,612.86	2.21	137.79	138.95	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
8,646,618	62	139,461.58	2.14	217.70	218.32	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
7,246,524	905,816	8.00	1.80	83.12	83.12	cgb6kp2umq52a		select t.schema, t.name, t.f...
6,121,099	2,186,809	2.80	1.52	85.40	85.40	6cjfxb1c4kx16		SELECT PROFILE_OPTION_ID, APP...
5,947,055	12,165	488.87	1.47	82.30	82.47	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
5,854,751	49,199	119.00	1.45	231.14	231.67	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
4,672,151	33,394	139.91	1.16	172.34	173.32	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 291,785
Captured SQL accounts for 33.6% of Total Disk Reads

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
32,686	720	45.40	11.20	5.33	126.06	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
27,617	5,000	5.52	9.46	57.43	124.00	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
16,732	16,354	1.02	5.73	25.77	65.14	3vy5h9xkfv1s5	OEXOETEL	INSERT INTO WF_ITEM_ATTRIBUTE_...
9,886	720	13.73	3.39	33.10	73.01	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
9,554	1	9,554.00	3.27	17.57	19.70	bb995vqx5y1zd	SQL*Plus	select /*+ cursor_sharing_exa...
8,343	6,485	1.29	2.86	63.85	91.69	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
7,651	3	2,550.33	2.62	106.04	114.17	8c30hkqv9n7cr	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,783	360	4.95	0.61	59.22	64.78	3cb7xm8ykx1qh	icx.por.req.server.RequisitionAM	begin :1 := POR_UTIL_PKG.subm...
1,447	4,504	0.32	0.50	53.72	59.86	00y09j4jtwps1	JDBC Thin Client	declare sid number; l_enc_ke...
905	108	8.38	0.31	57.03	60.19	fumydqvpk1g21	qotSCopOverview.jsp	BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 33,146,335
Captured SQL accounts for 35.1% of Total Executions

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
2,832,039	1,139,524	0.40	c4y7jp0q2awbf		SELECT PROFILE_OPTION_VALUE FR...
2,186,809	1,747,479	0.80	6cjfxb1c4kx16		SELECT PROFILE_OPTION_ID, APP...
905,816	905,816	1.00	cgb6kp2umq52a		select t.schema, t.name, t.f...
905,612	905,612	1.00	8bsm049u7thjd		select min(next_date) from "AP...
885,318	885,318	1.00	bc7t6t6jfx2n7		SELECT VERSION FROM FND_CACHE_...
848,232	848,232	1.00	9dvfguzd15kpv	JDBC Thin Client	SELECT VALUE FROM V$NLS_PARAME...
283,451	116,401	0.41	4g5vzcyf68n9w		SELECT PROFILE_OPTION_VALUE FR...
181,854	181,854	1.00	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
147,981	147,981	1.00	0w785m9gmw41a		SELECT USERENV('SESSIONID') FR...
147,553	147,553	1.00	29x3dahwzdj8b		SELECT U.USER_NAME, NVL(U.EMP...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 7,309,365
Captured SQL accounts for 64.7% of Total Parse Calls

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
905,816	905,816	12.39	cgb6kp2umq52a		select t.schema, t.name, t.f...
905,612	630	12.39	20rc3cmapyvnz		select q_name, state, delay,...
905,612	905,612	12.39	8bsm049u7thjd		select min(next_date) from "AP...
188,393	2,186,809	2.58	6cjfxb1c4kx16		SELECT PROFILE_OPTION_ID, APP...
181,854	181,854	2.49	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
173,242	2,832,039	2.37	c4y7jp0q2awbf		SELECT PROFILE_OPTION_VALUE FR...
101,436	101,436	1.39	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
94,189	147,981	1.29	0w785m9gmw41a		SELECT USERENV('SESSIONID') FR...
93,761	147,553	1.28	29x3dahwzdj8b		SELECT U.USER_NAME, NVL(U.EMP...
93,761	147,553	1.28	5as61q63aqmts		SELECT A.APPLICATION_SHORT_NAM...
93,761	147,553	1.28	95pbs94n69z3d		SELECT NVL(MULTI_ORG_FLAG, 'N...
93,761	885,318	1.28	bc7t6t6jfx2n7		SELECT VERSION FROM FND_CACHE_...
93,761	147,553	1.28	bvyqm6268u2as		SELECT NODE_NAME FROM FND_NODE...
93,761	93,761	1.28	fhqzxap2n0ybj		select NAME from HR_OPERATING_...
87,401	87,401	1.20	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...

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
2,269,603	2,165	0.07	8ay7m8qubw98j	POXBWVRP	select * from PO_TAX_LINES_SUM...
2,053,137	126	0.06	azfadzhfxbxj3	ARXTWMAI	SELECT ROW_ID, APBA_INACTIVE_D...
1,998,648	74	0.06	2fr5f5xzmffd8	POXPRPOP	SELECT decode ( : P_sortby , ...
1,846,684	8	0.06	9trqpr8qyg7xm	POXPRPOP	SELECT distinct pol . line_num...
1,753,326	6,267	0.05	8q8zmrwmrccz4	OEXOETEL	SELECT /*+ ORDERED USE_NL(adj ...
1,665,529	2,162	0.05	bf4kcv5v66czb	ibuSRDetails.jsp	SELECT 'NOTE', '2', b.creat...
1,562,909	2,161	0.05	bk9zgysk994av	OEXOETEL	SELECT /*+ ORDERED USE_NL(qpq ...
1,398,997	1	0.04	0tdy0gjxn6wrb	RAXMTR	select /*+ cursor_sharing_exa...
1,365,042	1	0.04	dkvvgc7c1wksu	RAXTRX	select CONTRACT_ID\|\|'~'\|\|L.AGR...
1,364,873	1	0.04	bb995vqx5y1zd	SQL*Plus	select /*+ cursor_sharing_exa...
1,309,965	4,322	0.04	fc74w8q18dtdu	OEXOETEL	SELECT /*+ ORDERED USE_NL(QPQ ...
1,274,416	359	0.04	2nfc4vng01c8t	POXPOVPO	SELECT END_DATE, START_DATE, R...
1,238,830	73	0.04	3c086a4sm741b	ARXAGE	select decode ( UPPER ( : p_or...