	\| 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 192418558 VISB 2 10.2.0.3.0 YES oracle8.engr.sgi.com

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 2 03-Jan-08 19:33:31 4440 241.9

End Snap: 4 03-Jan-08 20:38:45 3408 290.8

Elapsed: 65.27 (mins)

DB Time: 555.57 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 8,000M 8,000M Std Block Size: 8K

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

Load Profile

Per Second Per Transaction

Redo size: 1,190,890.93 5,681.28

Logical reads: 171,857.79 819.87

Block changes: 8,187.80 39.06

Physical reads: 52.86 0.25

Physical writes: 174.33 0.83

User calls: 9,912.01 47.29

Parses: 1,408.04 6.72

Hard parses: 1.25 0.01

Sorts: 1,488.29 7.10

Logons: 1.20 0.01

Executes: 14,643.53 69.86

Transactions: 209.62

% Blocks changed per Read: 4.76 Recursive Call %: 69.89

Rollback per transaction %: 33.31 Rows per Sort: 10.66

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 100.03 Soft Parse %: 99.91

Execute to Parse %: 90.38 Latch Hit %: 99.70

Parse CPU to Parse Elapsd %: 83.16 % Non-Parse CPU: 98.50

Shared Pool Statistics

Begin End

Memory Usage %: 74.15 82.04

% SQL with executions>1: 98.02 97.82

% Memory for SQL w/exec>1: 98.55 98.40

Top 5 Timed Events

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

CPU time 28,715 86.1

log file sync 423,095 1,127 3 3.4 Commit

library cache lock 273,095 775 3 2.3 Concurrency

db file sequential read 199,133 746 4 2.2 User I/O

gc buffer busy 10,650 345 32 1.0 Cluster

RAC Statistics

Begin End

Number of Instances: 2 2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 93.02 0.44

Global Cache blocks served: 147.59 0.70

GCS/GES messages received: 820.01 3.91

GCS/GES messages sent: 762.97 3.64

DBWR Fusion writes: 8.21 0.04

Estd Interconnect traffic (KB) 2,234.06

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

Buffer access - local cache %: 99.93

Buffer access - remote cache %: 0.05

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): 1.8

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

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

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

Global cache log flushes for cr blocks served %: 34.9

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

Avg global cache current block pin time (ms): 0.2

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

Global cache log flushes for current blocks served %: 1.6

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1

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

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: 38.09

% of indirect sent messages: 30.46

% of flow controlled messages: 31.45

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): 33334.3s
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	28,714.60	86.14
sql execute elapsed time	27,516.24	82.55
inbound PL/SQL rpc elapsed time	8,862.78	26.59
PL/SQL execution elapsed time	6,611.26	19.83
parse time elapsed	568.80	1.71
repeated bind elapsed time	193.80	0.58
Java execution elapsed time	65.22	0.20
hard parse elapsed time	60.02	0.18
sequence load elapsed time	37.78	0.11
connection management call elapsed time	12.09	0.04
failed parse elapsed time	10.49	0.03
PL/SQL compilation elapsed time	2.85	0.01
hard parse (sharing criteria) elapsed time	1.73	0.01
hard parse (bind mismatch) elapsed time	0.01	0.00
DB time	33,334.32
background elapsed time	1,594.25
background cpu time	911.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
Commit	423,095	0.00	1,127	3	0.53
Cluster	525,260	0.03	1,012	2	0.66
Concurrency	480,468	0.53	966	2	0.60
User I/O	202,775	0.00	749	4	0.26
Other	1,608,853	47.05	542	0	2.02
System I/O	732,124	0.00	234	0	0.92
Network	43,089,210	0.00	214	0	54.20
Application	77,110	0.00	42	1	0.10
Configuration	11,954	0.08	36	3	0.02

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
log file sync	423,095	0.00	1,127	3	0.53
library cache lock	273,095	0.00	775	3	0.34
db file sequential read	199,133	0.00	746	4	0.25
gc buffer busy	10,650	1.46	345	32	0.01
wait for scn ack	468,099	0.00	280	1	0.59
log file parallel write	584,308	0.00	187	0	0.73
gc cr block busy	45,697	0.00	180	4	0.06
gc cr block 2-way	157,764	0.00	160	1	0.20
SQL*Net more data from client	2,455,336	0.00	153	0	3.09
gcs log flush sync	235,218	7.53	126	1	0.30
gc current block 2-way	130,975	0.00	111	1	0.16
gc current block busy	4,514	0.00	70	16	0.01
gc current grant busy	45,741	0.00	57	1	0.06
gc cr grant 2-way	67,229	0.00	46	1	0.08
db file parallel write	136,879	0.00	44	0	0.17
latch: cache buffers chains	130,040	0.00	42	0	0.16
latch: library cache	22,699	0.00	42	2	0.03
SQL*Net message to client	39,466,791	0.00	39	0	49.64
SQL*Net break/reset to client	75,476	0.00	35	0	0.09
enq: HW - contention	11,568	0.09	35	3	0.01
enq: TT - contention	13,033	0.00	34	3	0.02
row cache lock	28,172	0.00	31	1	0.04
cursor: pin S wait on X	2,539	99.68	29	12	0.00
cr request retry	35	97.14	23	645	0.00
SQL*Net more data to client	1,167,083	0.00	21	0	1.47
latch: library cache pin	11,044	0.00	20	2	0.01
gc current grant 2-way	27,706	0.00	19	1	0.03
enq: US - contention	19,879	0.00	14	1	0.03
latch: object queue header operation	28,302	0.00	10	0	0.04
enq: TX - index contention	563	0.36	8	14	0.00
latch free	4,488	0.00	6	1	0.01
latch: row cache objects	3,938	0.00	6	2	0.00
enq: FB - contention	2,426	0.00	6	2	0.00
buffer busy waits	6,610	0.02	5	1	0.01
latch: ges resource hash list	4,044	0.00	5	1	0.01
gc current multi block request	19,020	0.00	5	0	0.02
CGS wait for IPC msg	635,471	99.98	4	0	0.80
gc cr multi block request	13,705	0.00	4	0	0.02
gc current retry	104	0.00	4	40	0.00
DFS lock handle	5,081	0.00	4	1	0.01
enq: UL - contention	1,344	0.00	3	2	0.00
name-service call wait	44	0.00	3	70	0.00
latch: cache buffers lru chain	1,973	0.00	3	2	0.00
gc recovery quiesce	7	42.86	3	419	0.00
LGWR wait for redo copy	12,642	0.16	3	0	0.02
enq: TX - contention	127	0.79	3	23	0.00
gc cr block congested	799	0.00	3	4	0.00
os thread startup	31	0.00	3	91	0.00
PX Deq Credit: send blkd	2,056	29.62	3	1	0.00
latch: library cache lock	1,331	0.00	3	2	0.00
latch: session allocation	2,269	0.00	2	1	0.00
gc current block congested	635	0.00	2	3	0.00
control file sequential read	9,175	0.00	2	0	0.01
enq: TM - contention	57	1.75	2	29	0.00
cursor: pin S	21,442	0.00	2	0	0.03
enq: TO - contention	481	0.00	2	3	0.00
latch: undo global data	1,345	0.00	1	1	0.00
ksxr poll remote instances	130,022	68.87	1	0	0.16
enq: TX - row lock contention	146	0.00	1	9	0.00
control file parallel write	1,762	0.00	1	1	0.00
gc current split	56	0.00	1	18	0.00
gc cr grant congested	409	0.00	1	2	0.00
db file scattered read	205	0.00	1	5	0.00
latch: object queue header heap	856	0.00	1	1	0.00
library cache load lock	33	0.00	1	24	0.00
latch: gcs resource hash	738	0.00	1	1	0.00
latch: shared pool	268	0.00	1	3	0.00
latch: redo allocation	497	0.00	1	1	0.00
enq: SQ - contention	214	0.00	1	3	0.00
local write wait	992	0.00	1	1	0.00
reliable message	41	0.00	1	15	0.00
enq: WF - contention	13	7.69	1	46	0.00
enq: CF - contention	138	0.00	1	4	0.00
enq: PS - contention	108	0.00	0	4	0.00
gc current grant congested	161	0.00	0	3	0.00
direct path read	2,386	0.00	0	0	0.00
IPC send completion sync	180	97.78	0	2	0.00
PX Deq: reap credit	15,340	85.80	0	0	0.02
rdbms ipc reply	310	0.00	0	1	0.00
latch: messages	647	0.00	0	0	0.00
library cache pin	91	0.00	0	2	0.00
latch: enqueue hash chains	135	0.00	0	2	0.00
ges inquiry response	65	0.00	0	3	0.00
latch: KCL gc element parent latch	436	0.00	0	0	0.00
wait list latch free	73	0.00	0	3	0.00
gc current block unknown	51	0.00	0	4	0.00
buffer deadlock	296	99.66	0	1	0.00
enq: KO - fast object checkpoint	45	0.00	0	4	0.00
global enqueue expand wait	14	92.86	0	10	0.00
lock escalate retry	96	87.50	0	1	0.00
latch: redo writing	161	0.00	0	1	0.00
PX Deq: Signal ACK	41	29.27	0	3	0.00
latch: cache buffer handles	78	0.00	0	1	0.00
read by other session	54	0.00	0	2	0.00
enq: RO - fast object reuse	42	0.00	0	2	0.00
latch: checkpoint queue latch	53	0.00	0	1	0.00
kksfbc child completion	1	100.00	0	51	0.00
enq: TA - contention	83	0.00	0	1	0.00
enq: TD - KTF dump entries	36	0.00	0	1	0.00
enq: PI - contention	14	0.00	0	2	0.00
L1 validation	2	100.00	0	11	0.00
gc cr failure	37	0.00	0	1	0.00
enq: TX - allocate ITL entry	11	0.00	0	1	0.00
lock deadlock retry	1	100.00	0	6	0.00
KJC: Wait for msg sends to complete	78	0.00	0	0	0.00
enq: DR - contention	2	0.00	0	0	0.00
direct path write	5	0.00	0	0	0.00
enq: JQ - contention	1	0.00	0	0	0.00
enq: AF - task serialization	1	0.00	0	0	0.00
latch: parallel query alloc buffer	1	0.00	0	0	0.00
cursor: mutex S	8	0.00	0	0	0.00
cursor: mutex X	6	0.00	0	0	0.00
PX qref latch	1	100.00	0	0	0.00
SQL*Net message from client	39,467,410	0.00	9,284,815	235	49.64
Streams AQ: waiting for messages in the queue	6,298	99.75	30,663	4869	0.01
gcs remote message	2,670,639	77.37	14,364	5	3.36
PX Idle Wait	2,329	95.84	5,548	2382	0.00
Streams AQ: waiting for time management or cleanup tasks	1	100.00	3,997	3997399	0.00
Streams AQ: qmn slave idle wait	135	0.00	3,710	27480	0.00
Streams AQ: qmn coordinator idle wait	287	46.34	3,710	12926	0.00
DIAG idle wait	18,749	0.00	3,701	197	0.02
jobq slave wait	1,581	46.55	3,697	2338	0.00
ges remote message	435,754	84.62	3,652	8	0.55
PX Deq: Execution Msg	680	30.59	42	62	0.00
PX Deq: Msg Fragment	1,571	45.00	1	1	0.00
PX Deq: Table Q Normal	716	33.10	1	1	0.00
PX Deq: Join ACK	45	42.22	0	8	0.00
PX Deq: Execute Reply	42	28.57	0	4	0.00
PX Deq: Parse Reply	45	33.33	0	3	0.00
PX Deq Credit: need buffer	41	31.71	0	1	0.00
class slave wait	3	0.00	0	2	0.00
Streams AQ: RAC qmn coordinator idle wait	287	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
events in waitclass Other	1,533,028	48.46	443	0	1.93
log file parallel write	584,301	0.00	187	0	0.73
db file parallel write	136,882	0.00	44	0	0.17
enq: HW - contention	3,398	0.00	3	1	0.00
gc cr multi block request	11,826	0.00	3	0	0.01
os thread startup	30	0.00	3	87	0.00
library cache lock	913	0.00	2	3	0.00
control file sequential read	7,600	0.00	2	0	0.01
control file parallel write	1,762	0.00	1	1	0.00
row cache lock	255	0.00	1	2	0.00
latch: cache buffers chains	2,163	0.00	0	0	0.00
enq: KO - fast object checkpoint	45	0.00	0	4	0.00
gc current block 2-way	219	0.00	0	1	0.00
latch: redo writing	161	0.00	0	1	0.00
gc cr block 2-way	150	0.00	0	1	0.00
enq: RO - fast object reuse	42	0.00	0	2	0.00
enq: TM - contention	19	0.00	0	1	0.00
buffer busy waits	162	0.62	0	0	0.00
gc current grant busy	12	0.00	0	0	0.00
db file sequential read	2	0.00	0	2	0.00
gc cr block congested	1	0.00	0	2	0.00
latch: row cache objects	8	0.00	0	0	0.00
latch: library cache	2	0.00	0	0	0.00
gc cr grant 2-way	1	0.00	0	0	0.00
gc current grant 2-way	1	0.00	0	0	0.00
rdbms ipc message	1,729,024	3.42	39,771	23	2.17
gcs remote message	2,670,529	77.37	14,364	5	3.36
Streams AQ: waiting for time management or cleanup tasks	1	100.00	3,997	3997399	0.00
Streams AQ: qmn slave idle wait	135	0.00	3,710	27480	0.00
Streams AQ: qmn coordinator idle wait	287	46.34	3,710	12926	0.00
DIAG idle wait	18,749	0.00	3,701	197	0.02
pmon timer	2,053	99.81	3,684	1794	0.00
ges remote message	435,726	84.62	3,652	8	0.55
smon timer	132,526	0.00	3,648	28	0.17
PX Deq: Join ACK	27	44.44	0	5	0.00
PX Deq: Parse Reply	25	36.00	0	1	0.00
PX Deq: Execute Reply	23	26.09	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	287	100.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	34,782,626
IDLE_TIME	27,343,868
IOWAIT_TIME	770,749
NICE_TIME	0
SYS_TIME	3,562,143
USER_TIME	29,384,194
LOAD	9
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	25,661,440
NUM_CPUS	16
NUM_CPU_SOCKETS	8

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	33,337.80	28,719.30	200,132	647,530,309
SYS$USERS	8.20	5.30	132	28,900
SYS$BACKGROUND	0.00	0.00	333	4,369,627

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	202098	74754	476066	95876	43074627	21383
SYS$USERS	229	28	470	78	3940	1
SYS$BACKGROUND	434	60	3950	613	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
5,493	5,345	222,806	0.02	16.48	60t2tt1564j0k	? @o240-2 (TNS V1-V3)	SELECT SUBSTRB(MACHINE, 1, 60)...
4,494	4,285	7,600	0.59	13.48	fkxdmd0h7xg54	OEXOETEL	select item, item_id, item_d...
3,821	3,481	107,144	0.04	11.46	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,466	2,306	74,263	0.03	7.40	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
1,152	1,076	34,966	0.03	3.46	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
1,051	979	213,772	0.00	3.15	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
793	761	268,064	0.00	2.38	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
623	607	15,061	0.04	1.87	0c3a5qdmx2785	CSXSRISR	UPDATE CS_INCIDENTS_ALL_TL SET...
620	529	7,484	0.08	1.86	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
581	566	25,516	0.02	1.74	0t3fycvxv9xwb		INSERT INTO CTXSYS.DRV$PENDING...
573	558	16,959	0.03	1.72	7gtztzv329wg0		select c.name, u.name from co...
526	518	307,003	0.00	1.58	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
521	464	1,898	0.27	1.56	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
383	305	22,594	0.02	1.15	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...

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
5,345	5,493	222,806	0.02	16.48	60t2tt1564j0k	? @o240-2 (TNS V1-V3)	SELECT SUBSTRB(MACHINE, 1, 60)...
4,285	4,494	7,600	0.56	13.48	fkxdmd0h7xg54	OEXOETEL	select item, item_id, item_d...
3,481	3,821	107,144	0.03	11.46	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,306	2,466	74,263	0.03	7.40	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
1,076	1,152	34,966	0.03	3.46	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
979	1,051	213,772	0.00	3.15	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
761	793	268,064	0.00	2.38	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
607	623	15,061	0.04	1.87	0c3a5qdmx2785	CSXSRISR	UPDATE CS_INCIDENTS_ALL_TL SET...
566	581	25,516	0.02	1.74	0t3fycvxv9xwb		INSERT INTO CTXSYS.DRV$PENDING...
558	573	16,959	0.03	1.72	7gtztzv329wg0		select c.name, u.name from co...
529	620	7,484	0.07	1.86	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
518	526	307,003	0.00	1.58	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
464	521	1,898	0.24	1.56	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
305	383	22,594	0.01	1.15	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...

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: 651,822,751
Captured SQL account for 51.4% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
98,042,186	213,772	458.63	15.04	978.92	1050.95	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
96,507,647	268,064	360.02	14.81	760.71	793.01	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
43,308,799	31,683	1,366.94	6.64	166.99	176.31	5bv8zft2swgv2	OEXOETEL	SELECT 'x' FROM QP_LIST_HEADER...
34,902,878	5,023	6,948.61	5.35	184.33	189.91	47w6r5bh5h094	asn.lead.server.LeadUwqAM	SELECT * FROM (SELECT MethSt...
29,480,400	7,600	3,879.00	4.52	4284.76	4493.91	fkxdmd0h7xg54	OEXOETEL	select item, item_id, item_d...
21,358,815	15,177	1,407.31	3.28	205.25	211.84	7qvfkq8x46u23	CSCCCCRC	SELECT OBJECT_VERSION_NUMBER ...
15,866,973	307,003	51.68	2.43	518.49	526.13	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
14,172,666	107,144	132.28	2.17	3480.51	3821.38	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
12,266,449	15,085	813.16	1.88	144.25	186.17	c6sn6732c1cfr	CSCCCCRC	SELECT CMRO_FLAG, MAINTENANCE...
11,900,921	15,061	790.18	1.83	606.84	623.07	0c3a5qdmx2785	CSXSRISR