	\| 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 VIS2 2 10.2.0.3.0 YES hprac2.ebs.hp.com

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1 10-Mar-08 11:35:57 2972 168.9

End Snap: 2 10-Mar-08 12:36:07 2974 175.4

Elapsed: 60.16 (mins)

DB Time: 185.95 (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: 536,337.30 3,218.63

Logical reads: 62,810.25 376.93

Block changes: 3,400.71 20.41

Physical reads: 67.45 0.40

Physical writes: 86.09 0.52

User calls: 8,512.12 51.08

Parses: 2,360.42 14.17

Hard parses: 1.27 0.01

Sorts: 1,128.05 6.77

Logons: 0.85 0.01

Executes: 11,852.51 71.13

Transactions: 166.64

% Blocks changed per Read: 5.41 Recursive Call %: 72.38

Rollback per transaction %: 33.27 Rows per Sort: 17.81

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.97 Soft Parse %: 99.95

Execute to Parse %: 80.09 Latch Hit %: 99.85

Parse CPU to Parse Elapsd %: 60.49 % Non-Parse CPU: 96.76

Shared Pool Statistics

Begin End

Memory Usage %: 71.06 79.80

% SQL with executions>1: 85.30 85.46

% Memory for SQL w/exec>1: 70.98 71.92

Top 5 Timed Events

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

CPU time 9,296 83.3

log file sync 333,676 576 2 5.2 Commit

db file scattered read 24,891 552 22 5.0 User I/O

gc buffer busy 5,236 325 62 2.9 Cluster

wait for scn ack 330,728 173 1 1.6 Other

RAC Statistics

Begin End

Number of Instances: 2 2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 109.06 0.65

Global Cache blocks served: 72.27 0.43

GCS/GES messages received: 645.94 3.88

GCS/GES messages sent: 636.01 3.82

DBWR Fusion writes: 3.70 0.02

Estd Interconnect traffic (KB) 1,701.05

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

Buffer access - local cache %: 99.72

Buffer access - remote cache %: 0.17

Buffer access - disk %: 0.11

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0

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

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

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.2

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

Avg global cache current block pin time (ms): 6,410.7

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 47.8

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

% of indirect sent messages: 11.67

% of flow controlled messages: 50.70

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): 11156.9s
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	9,309.28	83.44
DB CPU	9,296.37	83.32
PL/SQL execution elapsed time	2,843.14	25.48
inbound PL/SQL rpc elapsed time	1,542.72	13.83
parse time elapsed	551.19	4.94
repeated bind elapsed time	70.63	0.63
hard parse elapsed time	47.71	0.43
sequence load elapsed time	15.06	0.13
Java execution elapsed time	12.39	0.11
hard parse (sharing criteria) elapsed time	7.00	0.06
connection management call elapsed time	3.72	0.03
PL/SQL compilation elapsed time	3.30	0.03
failed parse elapsed time	1.90	0.02
hard parse (bind mismatch) elapsed time	0.01	0.00
DB time	11,156.88
background elapsed time	1,064.98
background cpu time	587.70

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	525,423	1.52	734	1	0.87
User I/O	47,520	0.00	668	14	0.08
Commit	333,676	0.00	576	2	0.55
Other	1,088,610	56.93	307	0	1.81
Concurrency	53,815	22.42	159	3	0.09
System I/O	541,732	0.00	158	0	0.90
Network	32,656,748	0.00	48	0	54.29
Application	60,170	0.00	14	0	0.10
Configuration	5,187	0.00	5	1	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
log file sync	333,676	0.00	576	2	0.55
db file scattered read	24,891	0.00	552	22	0.04
gc buffer busy	5,236	4.72	325	62	0.01
wait for scn ack	330,728	0.00	173	1	0.55
gc cr multi block request	125,387	4.21	136	1	0.21
cursor: pin S wait on X	12,064	100.00	132	11	0.02
db file sequential read	21,091	0.00	114	5	0.04
log file parallel write	410,494	0.00	99	0	0.68
gc cr block busy	40,594	0.00	80	2	0.07
gc cr block 2-way	169,886	1.19	73	0	0.28
gcs log flush sync	46,569	22.13	66	1	0.08
db file parallel write	119,564	0.00	41	0	0.20
SQL*Net message to client	32,268,790	0.00	30	0	53.65
gc current block 2-way	69,952	0.57	30	0	0.12
gc current multi block request	40,773	0.00	24	1	0.07
gc current grant busy	33,579	0.00	23	1	0.06
PX Deq Credit: send blkd	20,373	32.30	19	1	0.03
Streams AQ: qmn coordinator waiting for slave to start	3	100.00	17	5646	0.00
control file sequential read	9,473	0.00	16	2	0.02
gc current block busy	1,000	0.00	14	14	0.00
SQL*Net break/reset to client	58,704	0.00	13	0	0.10
SQL*Net more data from client	114,572	0.00	13	0	0.19
row cache lock	25,102	0.00	12	0	0.04
gc current grant 2-way	27,867	0.00	9	0	0.05
gc cr block lost	6	83.33	6	1069	0.00
gc current retry	93	0.00	5	58	0.00
latch: library cache	8,386	0.00	5	1	0.01
SQL*Net more data to client	273,386	0.00	5	0	0.45
enq: HW - contention	5,061	0.00	4	1	0.01
name-service call wait	67	0.00	4	56	0.00
gc cr grant 2-way	10,762	0.00	4	0	0.02
enq: TX - index contention	249	0.80	3	12	0.00
gc recovery quiesce	5	60.00	3	587	0.00
cr request retry	5	100.00	3	587	0.00
IPC send completion sync	2,399	99.42	3	1	0.00
DFS lock handle	6,565	0.00	3	0	0.01
control file parallel write	2,201	0.00	3	1	0.00
os thread startup	44	0.00	3	58	0.00
PX Deq: reap credit	134,011	92.81	2	0	0.22
enq: US - contention	7,214	0.00	2	0	0.01
CGS wait for IPC msg	414,204	99.92	2	0	0.69
kksfbc child completion	32	100.00	2	50	0.00
latch: library cache pin	2,107	0.00	1	1	0.00
kjbdrmcvtq lmon drm quiesce: ping completion	37	45.95	1	34	0.00
latch free	2,300	0.00	1	0	0.00
enq: WF - contention	8	12.50	1	135	0.00
enq: TX - contention	39	2.56	1	27	0.00
ksxr poll remote instances	100,425	58.66	1	0	0.17
latch: ges resource hash list	2,156	0.00	1	0	0.00
enq: UL - contention	1,217	0.00	1	1	0.00
enq: PS - contention	832	0.00	1	1	0.00
latch: object queue header operation	1,822	0.00	1	0	0.00
enq: FB - contention	1,090	0.00	1	1	0.00
latch: library cache lock	1,050	0.00	1	1	0.00
library cache load lock	106	0.00	1	5	0.00
LGWR wait for redo copy	4,822	0.00	0	0	0.01
enq: SQ - contention	122	0.00	0	4	0.00
local write wait	641	0.00	0	1	0.00
latch: cache buffers lru chain	697	0.00	0	1	0.00
db file parallel read	30	0.00	0	15	0.00
enq: TX - row lock contention	149	0.00	0	3	0.00
latch: cache buffers chains	1,863	0.00	0	0	0.00
latch: session allocation	524	0.00	0	1	0.00
ges global resource directory to be frozen	37	100.00	0	11	0.00
latch: row cache objects	711	0.00	0	1	0.00
gc cr block congested	182	18.13	0	2	0.00
read by other session	66	0.00	0	5	0.00
direct path read	475	0.00	0	1	0.00
latch: gcs resource hash	897	0.00	0	0	0.00
buffer busy waits	1,285	0.08	0	0	0.00
latch: KCL gc element parent latch	490	0.00	0	0	0.00
library cache lock	367	0.00	0	1	0.00
cursor: pin S	6,236	0.00	0	0	0.01
library cache pin	304	0.00	0	0	0.00
PX Deq: Signal ACK	26	26.92	0	5	0.00
enq: CF - contention	142	0.00	0	1	0.00
gc current block congested	56	17.86	0	1	0.00
rdbms ipc reply	217	0.00	0	0	0.00
latch: shared pool	112	0.00	0	1	0.00
enq: TM - contention	59	0.00	0	1	0.00
ges inquiry response	32	0.00	0	1	0.00
gc current split	3	0.00	0	15	0.00
global enqueue expand wait	5	80.00	0	9	0.00
latch: enqueue hash chains	60	0.00	0	1	0.00
gc current grant congested	22	0.00	0	1	0.00
latch: redo allocation	68	0.00	0	0	0.00
lock escalate retry	113	83.19	0	0	0.00
ges LMON to get to FTDONE	2	50.00	0	9	0.00
latch: messages	87	0.00	0	0	0.00
cursor: mutex S	18	0.00	0	1	0.00
gc cr grant congested	11	0.00	0	1	0.00
enq: RO - fast object reuse	41	0.00	0	0	0.00
enq: TD - KTF dump entries	40	0.00	0	0	0.00
enq: TT - contention	30	0.00	0	0	0.00
reliable message	25	0.00	0	1	0.00
latch: object queue header heap	23	0.00	0	1	0.00
PX qref latch	3,015	99.87	0	0	0.01
cursor: mutex X	47	0.00	0	0	0.00
latch: parallel query alloc buffer	9	0.00	0	1	0.00
enq: PI - contention	16	0.00	0	1	0.00
direct path write	325	0.00	0	0	0.00
enq: TO - contention	6	0.00	0	1	0.00
enq: TA - contention	21	0.00	0	0	0.00
buffer deadlock	52	100.00	0	0	0.00
latch: redo writing	4	0.00	0	1	0.00
latch: cache buffer handles	6	0.00	0	0	0.00
latch: undo global data	6	0.00	0	0	0.00
gc current block unknown	4	0.00	0	0	0.00
gc cr failure	5	0.00	0	0	0.00
enq: DR - contention	2	0.00	0	0	0.00
KJC: Wait for msg sends to complete	21	0.00	0	0	0.00
enq: IR - contention	1	0.00	0	0	0.00
db file single write	1	0.00	0	0	0.00
ges2 LMON to wake up LMD - mrcvr	2	0.00	0	0	0.00
lock deadlock retry	1	100.00	0	0	0.00
SQL*Net message from client	32,268,794	0.00	5,811,821	180	53.65
PX Idle Wait	4,127	80.20	8,595	2083	0.01
gcs remote message	1,833,246	77.45	6,777	4	3.05
Streams AQ: qmn slave idle wait	147	2.04	3,775	25678	0.00
Streams AQ: waiting for time management or cleanup tasks	67	52.24	3,547	52939	0.00
DIAG idle wait	17,882	0.00	3,523	197	0.03
ges remote message	226,532	86.28	3,509	15	0.38
Streams AQ: qmn coordinator idle wait	261	48.66	3,481	13339	0.00
PX Deq: Execution Msg	17,270	32.85	158	9	0.03
PX Deq: Msg Fragment	19,021	45.28	12	1	0.03
PX Deq: Table Q Normal	5,824	32.21	7	1	0.01
PX Deq Credit: need buffer	2,494	32.40	2	1	0.00
PX Deq: Parse Reply	33	39.39	0	2	0.00
PX Deq: Join ACK	32	40.63	0	1	0.00
PX Deq: Execute Reply	25	32.00	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	261	100.00	0	0	0.00
class slave wait	1	0.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	916,786	53.05	266	0	1.52
log file parallel write	410,501	0.00	99	0	0.68
db file parallel write	119,564	0.00	41	0	0.20
gc cr block busy	22,963	0.00	36	2	0.04
control file sequential read	8,146	0.00	15	2	0.01
gc cr multi block request	7,822	0.00	9	1	0.01
control file parallel write	2,201	0.00	3	1	0.00
os thread startup	43	0.00	2	57	0.00
gc cr block 2-way	1,403	0.00	1	0	0.00
direct path read	475	0.00	0	1	0.00
enq: HW - contention	618	0.00	0	0	0.00
gc current block 2-way	423	0.00	0	0	0.00
gc current multi block request	278	0.00	0	1	0.00
db file scattered read	1	0.00	0	111	0.00
gc current grant busy	257	0.00	0	0	0.00
enq: TM - contention	2	0.00	0	14	0.00
enq: RO - fast object reuse	41	0.00	0	0	0.00
db file parallel read	1	0.00	0	14	0.00
latch: cache buffers chains	194	0.00	0	0	0.00
direct path write	241	0.00	0	0	0.00
buffer busy waits	120	0.83	0	0	0.00
gc current block busy	2	0.00	0	2	0.00
latch: redo writing	4	0.00	0	1	0.00
latch: row cache objects	10	0.00	0	0	0.00
gc buffer busy	5	0.00	0	0	0.00
db file single write	1	0.00	0	0	0.00
latch: library cache	1	0.00	0	0	0.00
rdbms ipc message	787,692	8.25	38,052	48	1.31
gcs remote message	1,833,231	77.45	6,777	4	3.05
Streams AQ: waiting for time management or cleanup tasks	67	52.24	3,547	52939	0.00
DIAG idle wait	17,881	0.00	3,523	197	0.03
pmon timer	2,445	99.80	3,517	1438	0.00
ges remote message	226,476	86.28	3,509	15	0.38
smon timer	125,339	0.00	3,501	28	0.21
Streams AQ: qmn coordinator idle wait	261	48.66	3,481	13339	0.00
Streams AQ: qmn slave idle wait	18	0.00	476	26470	0.00
PX Deq: Parse Reply	30	40.00	0	2	0.00
PX Deq: Join ACK	29	41.38	0	1	0.00
PX Deq: Execute Reply	24	33.33	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	261	100.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	1,148,811
IDLE_TIME	1,734,691
IOWAIT_TIME	72,045
NICE_TIME	0
SYS_TIME	127,254
USER_TIME	957,698
LOAD	5
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	10,137,028
NUM_CPUS	8
NUM_CPU_SOCKETS	2

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	11,161.30	9,300.90	243,153	225,743,361
SYS$USERS	1.00	0.30	0	0
SYS$BACKGROUND	0.00	0.00	515	1,006,390

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	46585	66678	51451	15529	32649745	4768
SYS$USERS	0	0	2	0	3748	0
SYS$BACKGROUND	943	79	2372	334	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
1,065	1,035	131,511	0.01	9.55	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
604	559	82,196	0.01	5.41	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
496	487	80,965	0.01	4.45	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
355	205	328	1.08	3.18	fumydqvpk1g21	qotSCopOverview.jsp	BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q...
349	305	184,957	0.00	3.13	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
322	219	19,475	0.02	2.88	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
312	311	189,243	0.00	2.80	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
265	260	3,249	0.08	2.37	9auhvwk6aatuq	qotSCopProduct.jsp	BEGIN ASO_QUOTE_PUB_W.UPDATE_Q...
242	241	198,700	0.00	2.17	4dqasqjrvudqn	JDBC Thin Client	begin dbms_session.reset_packa...
227	167	6,491	0.03	2.03	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
200	198	4,278,705	0.00	1.79	6cjfxb1c4kx16	? @blade3.ebs.hp.com (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APP...
199	198	120,964	0.00	1.79	9jwgp69cmydgp	JDBC Thin Client	begin fnd_session_management.I...
186	159	10,542	0.02	1.67	00y09j4jtwps1	JDBC Thin Client	declare sid number; l_enc_ke...
181	136	648	0.28	1.62	dk0sqcvc2xjvs	qotSCopHdrUpd.jsp	BEGIN ASO_QUOTE_PUB_W.Create_Q...
180	165	2,164	0.08	1.61	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
173	172	6,114,529	0.00	1.55	c4y7jp0q2awbf	? @blade3.ebs.hp.com (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
162	105	240,065	0.00	1.45	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
158	158	74,960	0.00	1.41	gpbusp26z6qhc	qotSAppApvlInit.jsp	SELECT upgrade_tz_id, timezone...
155	155	240,072	0.00	1.39	b5jqxnpqu8624	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
145	142	90,874	0.00	1.30	7dtkxnqpkqszw	jtfavald.jsp	SELECT DISTINCT a.PERMISSION_...
117	117	108,730	0.00	1.05	7ujfmgb1j83a3	JDBC Thin Client	BEGIN FND_AOLJ_UTIL.SET_NLS_C...
114	9	6,598	0.02	1.03	auudu2jzbt9s0	CSCCCCRC	SELECT HD.ID CONTRACT_ID , HD....

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
1,035	1,065	131,511	0.01	9.55	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
559	604	82,196	0.01	5.41	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
487	496	80,965	0.01	4.45	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
311	312	189,243	0.00	2.80	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
305	349	184,957	0.00	3.13	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
260	265	3,249	0.08	2.37	9auhvwk6aatuq	qotSCopProduct.jsp	BEGIN ASO_QUOTE_PUB_W.UPDATE_Q...
241	242	198,700	0.00	2.17	4dqasqjrvudqn	JDBC Thin Client	begin dbms_session.reset_packa...
219	322	19,475	0.01	2.88	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
205	355	328	0.63	3.18	fumydqvpk1g21	qotSCopOverview.jsp	BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q...
198	199	120,964	0.00	1.79	9jwgp69cmydgp	JDBC Thin Client	begin fnd_session_management.I...
198	200	4,278,705	0.00	1.79	6cjfxb1c4kx16	? @blade3.ebs.hp.com (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APP...
172	173	6,114,529	0.00	1.55	c4y7jp0q2awbf	? @blade3.ebs.hp.com (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
167	227	6,491	0.03	2.03	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
165	180	2,164	0.08	1.61	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
159	186	10,542	0.02	1.67	00y09j4jtwps1	JDBC Thin Client	declare sid number; l_enc_ke...
158	158	74,960	0.00	1.41	gpbusp26z6qhc	qotSAppApvlInit.jsp	SELECT upgrade_tz_id, timezone...
155	155	240,072	0.00	1.39	b5jqxnpqu8624	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
142	145	90,874	0.00	1.30	7dtkxnqpkqszw	jtfavald.jsp	SELECT DISTINCT a.PERMISSION_...
136	181	648	0.21	1.62	dk0sqcvc2xjvs	qotSCopHdrUpd.jsp	BEGIN ASO_QUOTE_PUB_W.Create_Q...
117	117	108,730	0.00	1.05	7ujfmgb1j83a3