	\| 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 08-Mar-08 07:49:59 3259 167.9

End Snap: 2 08-Mar-08 08:50:08 3253 174.6

Elapsed: 60.15 (mins)

DB Time: 211.57 (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: 595,945.38 3,234.48

Logical reads: 70,071.43 380.31

Block changes: 3,776.66 20.50

Physical reads: 67.96 0.37

Physical writes: 93.89 0.51

User calls: 9,478.70 51.45

Parses: 2,615.08 14.19

Hard parses: 1.40 0.01

Sorts: 1,256.26 6.82

Logons: 0.90 0.00

Executes: 13,169.02 71.47

Transactions: 184.25

% Blocks changed per Read: 5.39 Recursive Call %: 72.32

Rollback per transaction %: 33.27 Rows per Sort: 17.75

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.98 Soft Parse %: 99.95

Execute to Parse %: 80.14 Latch Hit %: 99.83

Parse CPU to Parse Elapsd %: 57.51 % Non-Parse CPU: 96.80

Shared Pool Statistics

Begin End

Memory Usage %: 72.44 81.89

% SQL with executions>1: 84.62 84.41

% Memory for SQL w/exec>1: 69.66 70.26

Top 5 Timed Events

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

CPU time 10,504 82.7

log file sync 375,854 696 2 5.5 Commit

db file scattered read 25,306 573 23 4.5 User I/O

gc buffer busy 8,039 430 53 3.4 Cluster

wait for scn ack 353,502 207 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: 116.13 0.63

Global Cache blocks served: 81.83 0.44

GCS/GES messages received: 695.02 3.77

GCS/GES messages sent: 651.14 3.53

DBWR Fusion writes: 3.99 0.02

Estd Interconnect traffic (KB) 1,846.63

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

Buffer access - local cache %: 99.74

Buffer access - remote cache %: 0.17

Buffer access - disk %: 0.10

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

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 %: 16.7

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

Avg global cache current block pin time (ms): 7,121.0

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

Global cache log flushes for current blocks served %: 1.3

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): -4,314.0

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

% of indirect sent messages: 12.41

% 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): 12694.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
sql execute elapsed time	10,515.53	82.84
DB CPU	10,504.03	82.75
PL/SQL execution elapsed time	3,184.91	25.09
inbound PL/SQL rpc elapsed time	1,819.39	14.33
parse time elapsed	641.81	5.06
repeated bind elapsed time	85.54	0.67
hard parse elapsed time	54.22	0.43
sequence load elapsed time	17.37	0.14
Java execution elapsed time	13.47	0.11
hard parse (sharing criteria) elapsed time	6.35	0.05
connection management call elapsed time	4.45	0.04
PL/SQL compilation elapsed time	3.66	0.03
failed parse elapsed time	2.17	0.02
hard parse (bind mismatch) elapsed time	0.00	0.00
DB time	12,694.24
background elapsed time	1,180.00
background cpu time	665.62

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	558,143	1.38	881	2	0.84
Commit	375,854	0.00	696	2	0.57
User I/O	48,118	0.00	695	14	0.07
Other	892,870	42.87	345	0	1.34
Concurrency	66,996	24.86	220	3	0.10
System I/O	585,567	0.00	167	0	0.88
Network	36,358,035	0.00	60	0	54.67
Application	66,704	0.00	20	0	0.10
Configuration	5,800	0.00	6	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	375,854	0.00	696	2	0.57
db file scattered read	25,306	0.00	573	23	0.04
gc buffer busy	8,039	2.35	430	53	0.01
wait for scn ack	353,502	0.00	207	1	0.53
cursor: pin S wait on X	16,654	99.98	182	11	0.03
gc cr multi block request	114,626	4.49	149	1	0.17
db file sequential read	21,226	0.00	121	6	0.03
log file parallel write	447,611	0.00	109	0	0.67
gc cr block 2-way	197,001	0.84	94	0	0.30
gc cr block busy	35,339	0.80	71	2	0.05
gcs log flush sync	54,121	24.30	64	1	0.08
db file parallel write	127,050	0.00	49	0	0.19
gc current block 2-way	74,976	0.46	37	0	0.11
SQL*Net message to client	35,930,156	0.00	34	0	54.03
gc current grant busy	35,739	0.00	32	1	0.05
gc current multi block request	50,657	0.00	31	1	0.08
PX Deq Credit: send blkd	19,743	30.49	20	1	0.03
SQL*Net more data from client	124,753	0.00	19	0	0.19
row cache lock	26,802	0.00	18	1	0.04
SQL*Net break/reset to client	65,128	0.00	17	0	0.10
gc current block busy	1,034	0.00	17	16	0.00
Streams AQ: qmn coordinator waiting for slave to start	2	100.00	13	6538	0.00
gc current grant 2-way	29,960	0.00	11	0	0.05
latch: library cache	12,277	0.00	10	1	0.02
control file sequential read	9,007	0.00	7	1	0.01
SQL*Net more data to client	303,126	0.00	6	0	0.46
enq: HW - contention	5,650	0.00	6	1	0.01
cr request retry	8	100.00	6	733	0.00
gc cr grant 2-way	10,243	0.00	4	0	0.02
enq: US - contention	10,202	0.00	4	0	0.02
gc current retry	93	0.00	4	41	0.00
name-service call wait	66	0.00	3	51	0.00
DFS lock handle	7,303	0.00	3	0	0.01
IPC send completion sync	2,408	98.92	3	1	0.00
os thread startup	49	0.00	3	51	0.00
latch: library cache pin	3,184	0.00	2	1	0.00
PX Deq: reap credit	131,212	93.10	2	0	0.20
control file parallel write	1,899	0.00	2	1	0.00
latch free	3,366	0.00	2	1	0.01
enq: WF - contention	11	18.18	2	151	0.00
enq: TX - index contention	260	0.38	2	6	0.00
kksfbc child completion	32	100.00	2	50	0.00
latch: ges resource hash list	2,616	0.00	1	1	0.00
enq: TX - contention	103	0.00	1	13	0.00
gcs drm freeze in enter server mode	4	25.00	1	335	0.00
enq: UL - contention	1,273	0.00	1	1	0.00
latch: object queue header operation	2,478	0.00	1	0	0.00
ksxr poll remote instances	106,696	59.07	1	0	0.16
enq: FB - contention	1,252	0.00	1	1	0.00
enq: PS - contention	832	0.00	1	1	0.00
gc recovery quiesce	5	20.00	1	196	0.00
kjbdrmcvtq lmon drm quiesce: ping completion	19	31.58	1	49	0.00
latch: library cache lock	1,296	0.00	1	1	0.00
latch: cache buffers lru chain	758	0.00	1	1	0.00
CGS wait for IPC msg	174,388	99.93	1	0	0.26
latch: cache buffers chains	2,529	0.00	1	0	0.00
latch: session allocation	740	0.00	1	1	0.00
enq: TM - contention	85	0.00	1	9	0.00
latch: row cache objects	999	0.00	1	1	0.00
local write wait	691	0.00	1	1	0.00
LGWR wait for redo copy	5,676	0.00	1	0	0.01
read by other session	76	0.00	1	8	0.00
library cache lock	756	0.00	1	1	0.00
gc cr block congested	276	17.75	0	2	0.00
buffer busy waits	1,695	0.18	0	0	0.00
gc remaster	2	0.00	0	194	0.00
enq: TX - row lock contention	163	0.00	0	2	0.00
latch: gcs resource hash	778	0.00	0	0	0.00
library cache load lock	58	0.00	0	5	0.00
db file parallel read	17	0.00	0	16	0.00
cursor: pin S	11,456	0.00	0	0	0.02
ges global resource directory to be frozen	19	100.00	0	11	0.00
enq: SQ - contention	140	0.00	0	1	0.00
latch: KCL gc element parent latch	404	0.00	0	0	0.00
library cache pin	278	0.00	0	1	0.00
gc current block congested	90	10.00	0	2	0.00
enq: CF - contention	138	0.00	0	1	0.00
latch: enqueue hash chains	76	0.00	0	1	0.00
enq: TT - contention	114	0.00	0	1	0.00
gc current split	8	0.00	0	11	0.00
latch: shared pool	127	0.00	0	1	0.00
rdbms ipc reply	210	0.00	0	0	0.00
gc current grant congested	35	0.00	0	2	0.00
global enqueue expand wait	5	100.00	0	11	0.00
latch: redo allocation	71	0.00	0	1	0.00
wait list latch free	4	0.00	0	12	0.00
ges inquiry response	34	0.00	0	1	0.00
enq: RO - fast object reuse	55	0.00	0	1	0.00
buffer deadlock	112	98.21	0	0	0.00
enq: TO - contention	32	0.00	0	1	0.00
latch: cache buffer handles	7	0.00	0	3	0.00
PX qref latch	1,476	99.53	0	0	0.00
reliable message	24	0.00	0	1	0.00
enq: PI - contention	26	0.00	0	1	0.00
direct path read	475	0.00	0	0	0.00
lock escalate retry	93	87.10	0	0	0.00
gc cr grant congested	11	0.00	0	2	0.00
latch: messages	99	0.00	0	0	0.00
latch: object queue header heap	26	0.00	0	1	0.00
cursor: mutex S	19	0.00	0	1	0.00
cursor: mutex X	13	0.00	0	1	0.00
enq: TD - KTF dump entries	51	0.00	0	0	0.00
latch: redo writing	7	0.00	0	1	0.00
PX Deq: Signal ACK	22	22.73	0	0	0.00
enq: TA - contention	21	0.00	0	0	0.00
latch: parallel query alloc buffer	9	0.00	0	0	0.00
lock deadlock retry	1	100.00	0	3	0.00
gc current block unknown	2	0.00	0	1	0.00
direct path write	326	0.00	0	0	0.00
gc cr failure	7	0.00	0	0	0.00
enq: DR - contention	2	0.00	0	1	0.00
enq: TX - allocate ITL entry	3	0.00	0	0	0.00
latch: undo global data	5	0.00	0	0	0.00
ges2 LMON to wake up LMD - mrcvr	5	20.00	0	0	0.00
db file single write	1	0.00	0	0	0.00
enq: IR - contention	1	0.00	0	0	0.00
KJC: Wait for msg sends to complete	9	0.00	0	0	0.00
latch: checkpoint queue latch	2	0.00	0	0	0.00
SQL*Net message from client	35,930,172	0.00	6,343,106	177	54.03
PX Idle Wait	3,920	79.01	8,104	2067	0.01
gcs remote message	1,966,884	77.18	6,728	3	2.96
Streams AQ: qmn slave idle wait	145	2.07	3,716	25628	0.00
DIAG idle wait	17,881	0.00	3,522	197	0.03
ges remote message	225,321	86.26	3,503	16	0.34
Streams AQ: qmn coordinator idle wait	262	48.85	3,499	13354	0.00
Streams AQ: waiting for time management or cleanup tasks	63	49.21	3,350	53181	0.00
PX Deq: Execution Msg	16,343	31.36	219	13	0.02
PX Deq: Msg Fragment	19,139	45.60	13	1	0.03
PX Deq: Table Q Normal	4,958	30.60	7	1	0.01
PX Deq Credit: need buffer	2,453	28.41	2	1	0.00
PX Deq: Parse Reply	30	43.33	0	2	0.00
PX Deq: Join ACK	28	46.43	0	1	0.00
PX Deq: Execute Reply	30	33.33	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	262	100.00	0	0	0.00
class slave wait	2	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	715,455	35.04	296	0	1.08
log file parallel write	447,611	0.00	109	0	0.67
db file parallel write	127,047	0.00	49	0	0.19
gc cr block busy	17,101	0.00	24	1	0.03
gc cr multi block request	5,154	0.00	6	1	0.01
control file sequential read	7,679	0.00	6	1	0.01
os thread startup	49	0.00	3	51	0.00
control file parallel write	1,899	0.00	2	1	0.00
gc cr block 2-way	1,190	0.00	0	0	0.00
gc current multi block request	231	0.00	0	2	0.00
enq: HW - contention	735	0.00	0	0	0.00
gc current block 2-way	390	0.00	0	0	0.00
gc current grant busy	301	0.00	0	0	0.00
enq: TM - contention	29	0.00	0	3	0.00
enq: RO - fast object reuse	55	0.00	0	1	0.00
gc current block busy	1	0.00	0	31	0.00
db file scattered read	2	0.00	0	9	0.00
direct path read	475	0.00	0	0	0.00
buffer busy waits	145	2.07	0	0	0.00
latch: cache buffers chains	168	0.00	0	0	0.00
latch: redo writing	7	0.00	0	1	0.00
db file parallel read	1	0.00	0	9	0.00
latch: row cache objects	6	0.00	0	0	0.00
direct path write	241	0.00	0	0	0.00
db file single write	1	0.00	0	0	0.00
latch: library cache pin	1	0.00	0	0	0.00
enq: TX - index contention	1	0.00	0	0	0.00
library cache lock	2	0.00	-0	-6	0.00
rdbms ipc message	841,556	7.79	38,000	45	1.27
gcs remote message	1,966,898	77.18	6,728	3	2.96
DIAG idle wait	17,882	0.00	3,522	197	0.03
pmon timer	2,386	99.83	3,515	1473	0.00
ges remote message	225,343	86.26	3,503	16	0.34
Streams AQ: qmn coordinator idle wait	262	48.85	3,499	13354	0.00
smon timer	134,753	0.00	3,493	26	0.20
Streams AQ: waiting for time management or cleanup tasks	63	49.21	3,350	53181	0.00
PX Deq: Parse Reply	27	44.44	0	2	0.00
PX Deq: Join ACK	26	46.15	0	1	0.00
PX Deq: Execute Reply	28	35.71	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	262	100.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	1,282,064
IDLE_TIME	1,600,996
IOWAIT_TIME	66,699
NICE_TIME	0
SYS_TIME	140,373
USER_TIME	1,067,377
LOAD	4
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	8,043,612
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	12,697.60	10,507.80	244,895	251,986,958
SYS$USERS	1.30	0.40	0	0
SYS$BACKGROUND	0.00	0.00	520	992,520

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	47186	69482	64577	21664	36351768	5969
SYS$USERS	0	0	1	0	3748	0
SYS$BACKGROUND	948	41	2428	352	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,185	1,150	146,039	0.01	9.34	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
678	624	91,423	0.01	5.34	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
553	542	89,787	0.01	4.36	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
452	231	359	1.26	3.56	fumydqvpk1g21	qotSCopOverview.jsp	BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q...
374	339	205,468	0.00	2.94	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
363	243	21,627	0.02	2.86	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
350	349	211,642	0.00	2.76	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
293	289	3,596	0.08	2.31	9auhvwk6aatuq	qotSCopProduct.jsp	BEGIN ASO_QUOTE_PUB_W.UPDATE_Q...
276	274	220,523	0.00	2.17	4dqasqjrvudqn	JDBC Thin Client	begin dbms_session.reset_packa...
239	153	724	0.33	1.88	dk0sqcvc2xjvs	qotSCopHdrUpd.jsp	BEGIN ASO_QUOTE_PUB_W.Create_Q...
233	184	7,204	0.03	1.83	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
227	225	134,325	0.00	1.78	9jwgp69cmydgp	JDBC Thin Client	begin fnd_session_management.I...
221	220	4,753,431	0.00	1.74	6cjfxb1c4kx16	? @blade3.ebs.hp.com (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APP...
209	176	11,712	0.02	1.65	00y09j4jtwps1	JDBC Thin Client	declare sid number; l_enc_ke...
192	190	6,785,964	0.00	1.51	c4y7jp0q2awbf	? @blade3.ebs.hp.com (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
183	172	2,403	0.08	1.44	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
181	181	83,159	0.00	1.43	gpbusp26z6qhc	qotSAppApvlInit.jsp	SELECT upgrade_tz_id, timezone...
171	171	266,691	0.00	1.35	b5jqxnpqu8624	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
163	161	100,874	0.00	1.28	7dtkxnqpkqszw	jtfavald.jsp	SELECT DISTINCT a.PERMISSION_...
161	116	266,696	0.00	1.27	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
133	85	357	0.37	1.05	g8102j8yynbwz	qotSCopOverview.jsp	begin WF_STANDARD.CONTINUEFLOW...
132	132	121,698	0.00	1.04	7ujfmgb1j83a3	JDBC Thin Client	BEGIN FND_AOLJ_UTIL.SET_NLS_C...

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,150	1,185	146,039	0.01	9.34	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
624	678	91,423	0.01	5.34	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
542	553	89,787	0.01	4.36	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
349	350	211,642	0.00	2.76	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
339	374	205,468	0.00	2.94	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
289	293	3,596	0.08	2.31	9auhvwk6aatuq	qotSCopProduct.jsp	BEGIN ASO_QUOTE_PUB_W.UPDATE_Q...
274	276	220,523	0.00	2.17	4dqasqjrvudqn	JDBC Thin Client	begin dbms_session.reset_packa...
243	363	21,627	0.01	2.86	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
231	452	359	0.64	3.56	fumydqvpk1g21	qotSCopOverview.jsp	BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q...
225	227	134,325	0.00	1.78	9jwgp69cmydgp	JDBC Thin Client	begin fnd_session_management.I...
220	221	4,753,431	0.00	1.74	6cjfxb1c4kx16	? @blade3.ebs.hp.com (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APP...
190	192	6,785,964	0.00	1.51	c4y7jp0q2awbf	? @blade3.ebs.hp.com (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
184	233	7,204	0.03	1.83	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
181	181	83,159	0.00	1.43	gpbusp26z6qhc	qotSAppApvlInit.jsp	SELECT upgrade_tz_id, timezone...
176	209	11,712	0.02	1.65	00y09j4jtwps1	JDBC Thin Client	declare sid number; l_enc_ke...
172	183	2,403	0.07	1.44	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM