	\| 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 200195696 VIS1 1 10.2.0.3.0 YES hprac1.ebs.hp.com

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1 10-Mar-08 11:35:57 1737 151.1

End Snap: 2 10-Mar-08 12:36:06 1704 156.9

Elapsed: 60.16 (mins)

DB Time: 372.22 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 22,480M 22,480M Std Block Size: 8K

Shared Pool Size: 3,008M 3,008M Log Buffer: 30,696K

Load Profile

Per Second Per Transaction

Redo size: 8,280,072.76 52,695.21

Logical reads: 387,730.27 2,467.55

Block changes: 50,297.33 320.10

Physical reads: 45.78 0.29

Physical writes: 826.38 5.26

User calls: 4,033.05 25.67

Parses: 2,179.88 13.87

Hard parses: 1.12 0.01

Sorts: 2,259.10 14.38

Logons: 2.13 0.01

Executes: 19,279.35 122.70

Transactions: 157.13

% Blocks changed per Read: 12.97 Recursive Call %: 89.36

Rollback per transaction %: 8.28 Rows per Sort: 9.32

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95 Redo NoWait %: 100.00

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

Library Hit %: 99.81 Soft Parse %: 99.95

Execute to Parse %: 88.69 Latch Hit %: 98.83

Parse CPU to Parse Elapsd %: 90.32 % Non-Parse CPU: 97.26

Shared Pool Statistics

Begin End

Memory Usage %: 70.02 82.09

% SQL with executions>1: 82.13 80.91

% Memory for SQL w/exec>1: 55.37 52.34

Top 5 Timed Events

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

CPU time 20,277 90.8

gc buffer busy 24,792 465 19 2.1 Cluster

log file sync 167,457 348 2 1.6 Commit

log file parallel write 518,152 267 1 1.2 System I/O

db file sequential read 70,047 223 3 1.0 User I/O

RAC Statistics

Begin End

Number of Instances: 2 2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 72.26 0.46

Global Cache blocks served: 109.05 0.69

GCS/GES messages received: 636.03 4.05

GCS/GES messages sent: 645.89 4.11

DBWR Fusion writes: 8.73 0.06

Estd Interconnect traffic (KB) 1,700.89

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %: 99.97

Buffer access - remote cache %: 0.02

Buffer access - disk %: 0.01

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1

Avg global cache cr block receive time (ms): 0.9

Avg global cache current block receive time (ms): 0.6

Avg global cache cr block build time (ms): 0.0

Avg global cache cr block send time (ms): 0.0

Global cache log flushes for cr blocks served %: 18.0

Avg global cache cr block flush time (ms): 1.5

Avg global cache current block pin time (ms): 3,628.3

Avg global cache current block send time (ms): 0.0

Global cache log flushes for current blocks served %: 1.2

Avg global cache current block flush time (ms): 34.2

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 2,162.7

Avg message sent queue time on ksxp (ms): 0.2

Avg message received queue time (ms): 0.1

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 25.44

% of indirect sent messages: 28.28

% of flow controlled messages: 46.28

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

Wait Events Statistics

Time Model Statistics
Wait Class
Wait Events
Background Wait Events
Operating System Statistics
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 22333.2s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
DB CPU	20,277.02	90.79
sql execute elapsed time	19,390.01	86.82
PL/SQL execution elapsed time	4,989.78	22.34
inbound PL/SQL rpc elapsed time	4,699.43	21.04
parse time elapsed	666.26	2.98
Java execution elapsed time	643.16	2.88
hard parse elapsed time	404.79	1.81
repeated bind elapsed time	35.00	0.16
sequence load elapsed time	33.92	0.15
connection management call elapsed time	13.12	0.06
PL/SQL compilation elapsed time	4.61	0.02
hard parse (sharing criteria) elapsed time	4.52	0.02
hard parse (bind mismatch) elapsed time	1.18	0.01
DB time	22,333.23
background elapsed time	1,309.20
background cpu time	714.78

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
Cluster	638,958	0.07	722	1	1.13
System I/O	758,728	0.00	384	1	1.34
Other	1,399,147	54.28	376	0	2.47
Commit	167,457	0.00	348	2	0.30
User I/O	94,146	0.00	345	4	0.17
Concurrency	1,377,245	0.36	297	0	2.43
Application	43,563	1.04	267	6	0.08
Network	18,545,607	0.00	90	0	32.70
Configuration	106,878	60.64	49	0	0.19

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
gc buffer busy	24,792	1.85	465	19	0.04
log file sync	167,457	0.00	348	2	0.30
log file parallel write	518,152	0.00	267	1	0.91
db file sequential read	70,047	0.00	223	3	0.12
enq: UL - contention	34,357	0.61	139	4	0.06
enq: TX - row lock contention	965	24.66	120	124	0.00
db file parallel write	229,500	0.00	105	0	0.40
enq: TX - index contention	32,374	0.09	82	3	0.06
buffer busy waits	712,522	0.00	80	0	1.26
wait for scn ack	303,907	0.00	80	0	0.54
db file scattered read	11,938	0.00	77	6	0.02
gcs log flush sync	67,046	12.72	77	1	0.12
gc cr block busy	26,309	0.00	70	3	0.05
gc cr block 2-way	128,626	0.00	55	0	0.23
cursor: pin S wait on X	5,282	94.26	54	10	0.01
SQL*Net more data from client	1,767,968	0.00	46	0	3.12
enq: HW - contention	35,275	0.00	45	1	0.06
read by other session	10,944	0.04	44	4	0.02
DFS lock handle	19,952	0.30	38	2	0.04
enq: TX - contention	3,448	0.61	36	10	0.01
row cache lock	83,636	0.00	28	0	0.15
gc current block 2-way	69,042	0.00	28	0	0.12
gc current multi block request	251,246	0.00	27	0	0.44
latch: cache buffers chains	523,138	0.00	26	0	0.92
cr request retry	38	84.21	24	644	0.00
global enqueue expand wait	2,491	84.62	24	9	0.00
SQL*Net more data to client	1,448,526	0.00	23	0	2.55
gc current grant busy	31,647	0.00	22	1	0.06
SQL*Net message to client	15,329,113	0.00	21	0	27.03
gc cr multi block request	41,548	0.00	19	0	0.07
enq: FB - contention	20,621	0.00	17	1	0.04
gcs drm freeze in enter server mode	64	10.94	14	224	0.00
library cache load lock	605	0.00	13	22	0.00
enq: US - contention	9,870	0.01	13	1	0.02
gc current grant 2-way	34,236	0.00	12	0	0.06
gc current block busy	1,136	0.00	12	10	0.00
control file sequential read	9,361	0.00	10	1	0.02
latch: object queue header operation	12,795	0.00	8	1	0.02
gc cr grant 2-way	30,221	0.00	8	0	0.05
latch: library cache	8,576	0.00	5	1	0.02
enq: RO - fast object reuse	82	7.32	5	57	0.00
latch: undo global data	6,647	0.00	4	1	0.01
kksfbc child completion	98	83.67	4	42	0.00
name-service call wait	68	0.00	4	56	0.00
PX Deq Credit: send blkd	12,640	39.11	4	0	0.02
enq: SQ - contention	6,522	0.00	3	1	0.01
SQL*Net break/reset to client	8,064	0.00	3	0	0.01
ksxr poll remote instances	260,783	57.48	3	0	0.46
latch: cache buffers lru chain	1,279	0.00	3	2	0.00
library cache lock	3,286	0.00	3	1	0.01
PX Deq: reap credit	146,895	81.07	3	0	0.26
enq: DV - contention	873	0.00	2	3	0.00
LGWR wait for redo copy	35,528	0.01	2	0	0.06
os thread startup	28	0.00	2	76	0.00
reliable message	666	0.00	2	3	0.00
gc remaster	29	0.00	2	68	0.00
buffer deadlock	39,290	98.89	2	0	0.07
wait list latch free	166	0.00	2	11	0.00
latch: library cache pin	2,921	0.00	2	1	0.01
control file parallel write	1,715	0.00	1	1	0.00
CGS wait for IPC msg	226,703	99.86	1	0	0.40
latch free	2,784	0.00	1	0	0.00
library cache pin	3,642	0.00	1	0	0.01
PX qref latch	209,211	99.95	1	0	0.37
latch: redo allocation	2,630	0.00	1	0	0.00
enq: WF - contention	10	20.00	1	101	0.00
gc quiesce wait	4	25.00	1	245	0.00
gc recovery quiesce	4	25.00	1	244	0.00
latch: ges resource hash list	1,830	0.00	1	0	0.00
rdbms ipc reply	1,242	0.00	1	1	0.00
latch: session allocation	1,154	0.00	1	1	0.00
enq: TX - allocate ITL entry	130	0.00	1	5	0.00
enq: TM - contention	95	0.00	1	6	0.00
local write wait	394	0.00	1	2	0.00
write complete waits	11	45.45	1	50	0.00
enq: PS - contention	1,194	0.00	1	0	0.00
PX Deq: Signal ACK	386	34.72	0	1	0.00
latch: row cache objects	555	0.00	0	1	0.00
gc current retry	41	0.00	0	6	0.00
ges global resource directory to be frozen	16	100.00	0	12	0.00
latch: messages	469	0.00	0	0	0.00
latch: library cache lock	257	0.00	0	1	0.00
undo segment extension	64,847	99.93	0	0	0.11
enq: CF - contention	151	0.00	0	1	0.00
latch: gcs resource hash	361	0.00	0	0	0.00
db file parallel read	14	0.00	0	10	0.00
cursor: pin S	4,582	0.00	0	0	0.01
latch: object queue header heap	104	0.00	0	1	0.00
latch: shared pool	141	0.00	0	1	0.00
enq: TT - contention	137	0.00	0	1	0.00
enq: TS - contention	27	0.00	0	2	0.00
latch: enqueue hash chains	76	0.00	0	1	0.00
IPC send completion sync	251	33.47	0	0	0.00
kjbdrmcvtq lmon drm quiesce: ping completion	16	43.75	0	3	0.00
latch: cache buffer handles	232	0.00	0	0	0.00
enq: CU - contention	2	0.00	0	22	0.00
enq: TO - contention	65	0.00	0	1	0.00
latch: redo writing	79	0.00	0	0	0.00
log buffer space	6	0.00	0	5	0.00
gc cr block congested	15	0.00	0	2	0.00
latch: KCL gc element parent latch	171	0.00	0	0	0.00
enq: TA - contention	42	0.00	0	0	0.00
enq: ST - contention	8	0.00	0	2	0.00
gc cr failure	35	0.00	0	0	0.00
cursor: pin X	1	100.00	0	12	0.00
gc current grant congested	6	0.00	0	2	0.00
cursor: mutex S	110	0.00	0	0	0.00
gc current block congested	6	0.00	0	1	0.00
latch: checkpoint queue latch	22	0.00	0	0	0.00
latch: parallel query alloc buffer	13	0.00	0	1	0.00
gc cr grant congested	4	0.00	0	1	0.00
enq: MD - contention	9	0.00	0	0	0.00
enq: PI - contention	6	0.00	0	1	0.00
direct path write	339	0.00	0	0	0.00
cursor: mutex X	172	0.00	0	0	0.00
enq: KM - contention	7	0.00	0	0	0.00
gc cr disk read	9	0.00	0	0	0.00
lock escalate retry	35	85.71	0	0	0.00
KJC: Wait for msg sends to complete	29	0.00	0	0	0.00
direct path read	426	0.00	0	0	0.00
enq: DR - contention	2	0.00	0	0	0.00
gc current split	2	0.00	0	0	0.00
enq: DL - contention	2	0.00	0	0	0.00
enq: MW - contention	3	0.00	0	0	0.00
direct path write temp	38	0.00	0	0	0.00
ges2 LMON to wake up LMD - mrcvr	4	0.00	0	0	0.00
direct path read temp	6	0.00	0	0	0.00
lock deadlock retry	3	100.00	0	0	0.00
SQL*Net message from client	15,329,136	0.00	3,149,719	205	27.03
pipe get	27,350	16.11	21,140	773	0.05
Streams AQ: waiting for messages in the queue	2,809	98.11	15,206	5413	0.00
gcs remote message	2,246,568	73.60	13,802	6	3.96
PX Idle Wait	4,104	83.09	8,824	2150	0.01
DIAG idle wait	17,870	0.00	3,523	197	0.03
Streams AQ: qmn slave idle wait	140	0.00	3,512	25088	0.00
ges remote message	287,442	56.15	3,504	12	0.51
Streams AQ: qmn coordinator idle wait	265	47.55	3,504	13223	0.00
PL/SQL lock timer	220	96.82	2,408	10943	0.00
Streams AQ: waiting for time management or cleanup tasks	1	100.00	1,254	1253716	0.00
PX Deq: Execution Msg	15,536	8.44	212	14	0.03
PX Deq: Msg Fragment	8,931	0.07	12	1	0.02
PX Deq: Execute Reply	10,080	28.87	12	1	0.02
PX Deq: Parse Reply	988	17.00	10	10	0.00
PX Deq: Table Q Normal	7,607	27.82	5	1	0.01
PX Deq: Join ACK	1,162	40.71	0	0	0.00
PX Deq Credit: need buffer	1,242	33.98	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	266	100.00	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	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	518,150	0.00	267	1	0.91
events in waitclass Other	918,142	41.94	175	0	1.62
db file parallel write	229,500	0.00	105	0	0.40
control file sequential read	7,405	0.00	9	1	0.01
control file parallel write	1,715	0.00	1	1	0.00
os thread startup	12	0.00	1	47	0.00
enq: HW - contention	1,131	0.00	0	0	0.00
row cache lock	261	0.00	0	1	0.00
gc current block 2-way	135	0.00	0	0	0.00
buffer busy waits	219	0.00	0	0	0.00
gc cr block 2-way	147	0.00	0	0	0.00
latch: redo writing	79	0.00	0	0	0.00
enq: RO - fast object reuse	15	0.00	0	1	0.00
gc current grant busy	48	0.00	0	0	0.00
library cache lock	29	0.00	0	0	0.00
db file sequential read	2	0.00	0	4	0.00
latch: cache buffers chains	134	0.00	0	0	0.00
enq: TM - contention	12	0.00	0	0	0.00
latch: row cache objects	9	0.00	0	0	0.00
direct path write	242	0.00	0	0	0.00
direct path read	426	0.00	0	0	0.00
gc current grant 2-way	3	0.00	0	0	0.00
gc cr multi block request	2	0.00	0	0	0.00
latch: shared pool	1	0.00	0	0	0.00
latch: library cache	2	0.00	0	0	0.00
enq: ST - contention	1	0.00	0	0	0.00
rdbms ipc message	1,311,988	4.73	37,528	29	2.31
gcs remote message	2,246,585	73.60	13,802	6	3.96
DIAG idle wait	17,871	0.00	3,524	197	0.03
pmon timer	2,549	99.02	3,516	1379	0.00
Streams AQ: qmn slave idle wait	140	0.00	3,512	25088	0.00
ges remote message	287,252	56.13	3,504	12	0.51
Streams AQ: qmn coordinator idle wait	265	47.55	3,504	13223	0.00
smon timer	135,842	0.00	3,497	26	0.24
Streams AQ: waiting for time management or cleanup tasks	1	100.00	1,254	1253716	0.00
PX Deq: Parse Reply	26	42.31	0	1	0.00
PX Deq: Join ACK	25	48.00	0	1	0.00
PX Deq: Execute Reply	20	25.00	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	266	100.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	2,259,783
IDLE_TIME	3,502,000
IOWAIT_TIME	61,482
NICE_TIME	0
SYS_TIME	153,922
USER_TIME	2,060,972
LOAD	3
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	21,803,232
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
VIS	22,224.10	20,216.20	124,929	1,395,208,618
SYS$USERS	109.00	60.70	40,002	3,514,578
SYS$BACKGROUND	0.00	0.00	428	874,160

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	87109	33176	1367608	29509	18527209	9038
SYS$USERS	6371	1286	8952	151	5699	3
SYS$BACKGROUND	670	1	709	79	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
SQL ordered by Cluster Wait Time
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
2,488	2,337	8	310.99	11.14	ghw9svn8x4vzu	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
1,911	1,892	10	191.13	8.56	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,073	1,048	301	3.56	4.80	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
1,000	853	12	83.32	4.48	1g4jfpxpupdt6	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
722	655	16	45.11	3.23	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
559	527	1,302	0.43	2.50	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
454	446	56,472	0.01	2.03	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
439	435	5,420	0.08	1.96	a957tvxz9w038	icx.por.req.server.RequisitionAM	BEGIN :1 := por_util_pkg.inter...
423	404	56,487	0.01	1.89	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
411	360	5,000	0.08	1.84	2fjd6cndjby9p	ARTERRPW	INSERT INTO RA_CUST_TRX_LINE_G...
389	353	56,482	0.01	1.74	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
345	330	62,797	0.01	1.55	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
321	320	8	40.16	1.44	8vmj377jqyqwq	WSHASCSRS	BEGIN WSH_BATCH_PROCESS.CONFIR...
320	317	58,082	0.01	1.43	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
304	302	984	0.31	1.36	0qcpgw43yqj5r	WSHPSRS	( SELECT DISTINCT WDD.SOURCE_L...
303	161	10,000	0.03	1.36	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
291	291	9	32.39	1.31	1du9v021t8m46	ARGLTP	insert into gl_interface(creat...

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,337	2,488	8	292.18	11.14	ghw9svn8x4vzu	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
1,892	1,911	10	189.19	8.56	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,048	1,073	301	3.48	4.80	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
853	1,000	12	71.06	4.48	1g4jfpxpupdt6	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
655	722	16	40.91	3.23	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
527	559	1,302	0.40	2.50	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
446	454	56,472	0.01	2.03	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
435	439	5,420	0.08	1.96	a957tvxz9w038	icx.por.req.server.RequisitionAM	BEGIN :1 := por_util_pkg.inter...
404	423	56,487	0.01	1.89	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
360	411	5,000	0.07	1.84	2fjd6cndjby9p	ARTERRPW	INSERT INTO RA_CUST_TRX_LINE_G...
353	389	56,482	0.01	1.74	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
330	345	62,797	0.01	1.55	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
320	321	8	40.03	1.44	8vmj377jqyqwq	WSHASCSRS	BEGIN WSH_BATCH_PROCESS.CONFIR...
317	320	58,082	0.01	1.43	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
302	304	984	0.31	1.36	0qcpgw43yqj5r	WSHPSRS	( SELECT DISTINCT WDD.SOURCE_L...
291	291	9	32.29	1.31	1du9v021t8m46	ARGLTP	insert into gl_interface(creat...
161	303	10,000	0.02	1.36	64qc329wgjv39	PYUSLV	select /*+ ORD