	\| 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 08-Jan-08 10:20:07 3908 213.6

End Snap: 4 08-Jan-08 11:23:21 3185 283.6

Elapsed: 63.23 (mins)

DB Time: 502.82 (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,072,258.90 5,658.53

Logical reads: 148,364.20 782.95

Block changes: 7,348.33 38.78

Physical reads: 73.54 0.39

Physical writes: 149.15 0.79

User calls: 8,885.59 46.89

Parses: 1,302.24 6.87

Hard parses: 1.31 0.01

Sorts: 1,356.31 7.16

Logons: 1.17 0.01

Executes: 13,227.84 69.81

Transactions: 189.49

% Blocks changed per Read: 4.95 Recursive Call %: 70.08

Rollback per transaction %: 33.37 Rows per Sort: 10.53

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 100.03 Soft Parse %: 99.90

Execute to Parse %: 90.16 Latch Hit %: 99.77

Parse CPU to Parse Elapsd %: 88.81 % Non-Parse CPU: 98.44

Shared Pool Statistics

Begin End

Memory Usage %: 64.17 76.42

% SQL with executions>1: 94.15 97.71

% Memory for SQL w/exec>1: 93.20 98.10

Top 5 Timed Events

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

CPU time 24,979 82.8

gc buffer busy 9,435 1,350 143 4.5 Cluster

log file sync 379,922 963 3 3.2 Commit

db file sequential read 148,892 544 4 1.8 User I/O

enq: US - contention 14,024 402 29 1.3 Other

RAC Statistics

Begin End

Number of Instances: 2 2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 76.62 0.40

Global Cache blocks served: 150.33 0.79

GCS/GES messages received: 768.88 4.06

GCS/GES messages sent: 643.84 3.40

DBWR Fusion writes: 7.20 0.04

Estd Interconnect traffic (KB) 2,091.53

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

Buffer access - local cache %: 99.93

Buffer access - remote cache %: 0.05

Buffer access - disk %: 0.02

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

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

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

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1

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

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

% of indirect sent messages: 26.33

% of flow controlled messages: 44.83

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): 30169.5s
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	25,517.28	84.58
DB CPU	24,979.44	82.80
inbound PL/SQL rpc elapsed time	8,504.15	28.19
PL/SQL execution elapsed time	5,374.79	17.82
parse time elapsed	483.60	1.60
repeated bind elapsed time	116.67	0.39
Java execution elapsed time	59.36	0.20
hard parse elapsed time	47.02	0.16
sequence load elapsed time	36.03	0.12
connection management call elapsed time	11.59	0.04
PL/SQL compilation elapsed time	4.04	0.01
failed parse elapsed time	3.95	0.01
hard parse (sharing criteria) elapsed time	0.30	0.00
hard parse (bind mismatch) elapsed time	0.00	0.00
DB time	30,169.48
background elapsed time	1,490.26
background cpu time	871.69

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	454,669	0.11	2,039	4	0.63
Other	1,263,094	31.88	982	1	1.76
Commit	379,922	0.00	963	3	0.53
User I/O	169,680	0.00	619	4	0.24
Concurrency	158,658	1.12	346	2	0.22
System I/O	698,052	0.00	200	0	0.97
Network	38,688,128	0.00	174	0	53.81
Application	71,852	0.00	35	0	0.10
Configuration	11,921	0.00	30	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
gc buffer busy	9,435	5.25	1,350	143	0.01
log file sync	379,922	0.00	963	3	0.53
db file sequential read	148,892	0.00	544	4	0.21
enq: US - contention	14,024	4.62	402	29	0.02
wait for scn ack	467,438	0.00	261	1	0.65
log file parallel write	566,192	0.00	164	0	0.79
gc cr multi block request	38,610	0.00	162	4	0.05
gc cr block busy	35,805	0.00	140	4	0.05
gcs log flush sync	289,681	6.95	132	0	0.40
buffer busy waits	5,698	1.47	130	23	0.01
gcs drm freeze in enter server mode	314	69.43	126	401	0.00
gc cr block 2-way	126,435	0.00	124	1	0.18
SQL*Net more data from client	2,218,415	0.00	121	0	3.09
gc current block 2-way	93,124	0.00	78	1	0.13
db file scattered read	14,401	0.00	71	5	0.02
row cache lock	25,301	0.00	64	3	0.04
gc current grant busy	41,621	0.00	48	1	0.06
gc current multi block request	37,092	0.00	41	1	0.05
gc current block busy	2,899	0.00	38	13	0.00
enq: TX - index contention	659	8.19	37	57	0.00
SQL*Net message to client	35,414,434	0.00	35	0	49.26
db file parallel write	120,983	0.00	33	0	0.17
SQL*Net break/reset to client	70,321	0.00	31	0	0.10
latch: library cache	16,937	0.00	30	2	0.02
latch: cache buffers chains	89,171	0.00	29	0	0.12
gc cr grant 2-way	42,602	0.00	28	1	0.06
enq: HW - contention	11,583	0.00	27	2	0.02
cursor: pin S wait on X	1,637	99.76	19	11	0.00
SQL*Net more data to client	1,055,279	0.00	18	0	1.47
gc current grant 2-way	25,240	0.00	16	1	0.04
latch: library cache pin	8,504	0.00	15	2	0.01
library cache lock	6,541	0.00	13	2	0.01
cr request retry	17	94.12	10	575	0.00
gc remaster	230	0.00	6	26	0.00
latch: object queue header operation	21,297	0.00	6	0	0.03
latch free	4,526	0.00	5	1	0.01
latch: row cache objects	2,877	0.00	5	2	0.00
enq: TX - contention	218	0.46	4	17	0.00
enq: FB - contention	2,120	0.00	4	2	0.00
kjbdrmcvtq lmon drm quiesce: ping completion	96	22.92	3	36	0.00
enq: SQ - contention	223	0.00	3	14	0.00
name-service call wait	52	0.00	3	60	0.00
os thread startup	34	0.00	3	78	0.00
DFS lock handle	1,583	0.00	3	2	0.00
latch: ges resource hash list	1,797	0.00	2	1	0.00
gc current retry	76	0.00	2	32	0.00
LGWR wait for redo copy	11,736	0.21	2	0	0.02
local write wait	3,063	0.00	2	1	0.00
latch: cache buffers lru chain	1,711	0.00	2	1	0.00
gc recovery quiesce	7	28.57	2	279	0.00
enq: UL - contention	1,229	0.00	2	2	0.00
control file sequential read	9,115	0.00	2	0	0.01
latch: session allocation	2,084	0.00	2	1	0.00
gc cr block congested	582	0.00	2	3	0.00
CGS wait for IPC msg	277,828	99.87	2	0	0.39
gc current block congested	426	0.00	2	4	0.00
ksxr poll remote instances	118,583	68.18	1	0	0.16
enq: TT - contention	528	0.00	1	3	0.00
control file parallel write	1,762	0.00	1	1	0.00
latch: library cache lock	1,018	0.00	1	1	0.00
ges global resource directory to be frozen	96	100.00	1	12	0.00
cursor: pin S	14,040	0.00	1	0	0.02
direct path read	3,277	0.00	1	0	0.00
PX Deq Credit: send blkd	1,662	30.57	1	1	0.00
enq: TM - contention	95	0.00	1	9	0.00
latch: gcs resource hash	883	0.00	1	1	0.00
reliable message	40	0.00	1	19	0.00
gc cr grant congested	264	0.00	1	3	0.00
enq: TX - row lock contention	112	0.00	1	6	0.00
rdbms ipc reply	448	0.00	1	1	0.00
latch: enqueue hash chains	132	0.00	1	5	0.00
latch: undo global data	464	0.00	1	1	0.00
latch: object queue header heap	568	0.00	1	1	0.00
PX Deq: reap credit	24,089	85.35	1	0	0.03
latch: redo allocation	423	0.00	0	1	0.00
gc current grant congested	134	0.00	0	3	0.00
gc current split	37	0.00	0	11	0.00
db file parallel read	31	0.00	0	12	0.00
enq: WF - contention	13	0.00	0	27	0.00
library cache load lock	16	0.00	0	22	0.00
latch: messages	557	0.00	0	1	0.00
buffer deadlock	305	99.02	0	1	0.00
IPC send completion sync	198	97.98	0	1	0.00
enq: CF - contention	136	0.00	0	2	0.00
enq: PS - contention	127	0.00	0	2	0.00
latch: KCL gc element parent latch	959	0.00	0	0	0.00
enq: TS - contention	54	0.00	0	4	0.00
latch: shared pool	196	0.00	0	1	0.00
enq: TO - contention	110	0.00	0	2	0.00
enq: RO - fast object reuse	55	0.00	0	3	0.00
wait list latch free	62	0.00	0	2	0.00
PX Deq: Signal ACK	45	31.11	0	3	0.00
ges inquiry response	64	0.00	0	2	0.00
kksfbc child completion	2	100.00	0	52	0.00
library cache pin	60	0.00	0	2	0.00
global enqueue expand wait	9	100.00	0	11	0.00
enq: KO - fast object checkpoint	40	0.00	0	2	0.00
latch: cache buffer handles	64	0.00	0	1	0.00
enq: TA - contention	76	0.00	0	1	0.00
enq: TX - allocate ITL entry	13	0.00	0	3	0.00
latch: redo writing	102	0.00	0	0	0.00
gc current block unknown	25	0.00	0	1	0.00
lock escalate retry	51	90.20	0	1	0.00
enq: TD - KTF dump entries	62	0.00	0	0	0.00
enq: PI - contention	15	0.00	0	2	0.00
gc cr failure	15	0.00	0	2	0.00
lock deadlock retry	15	100.00	0	1	0.00
L1 validation	2	100.00	0	10	0.00
gc cr disk read	8	0.00	0	2	0.00
latch: checkpoint queue latch	39	0.00	0	0	0.00
PX qref latch	1,609	99.75	0	0	0.00
enq: DR - contention	3	0.00	0	2	0.00
ges2 LMON to wake up LMD - mrcvr	24	12.50	0	0	0.00
read by other session	9	0.00	0	0	0.00
cursor: mutex S	8	0.00	0	0	0.00
gc current block lost	1	0.00	0	2	0.00
enq: IR - contention	1	0.00	0	1	0.00
gc cr block lost	1	0.00	0	1	0.00
enq: AF - task serialization	1	0.00	0	0	0.00
KJC: Wait for msg sends to complete	13	0.00	0	0	0.00
direct path write	7	0.00	0	0	0.00
cursor: mutex X	1	0.00	0	0	0.00
SQL*Net message from client	35,414,707	0.00	8,240,889	233	49.26
Streams AQ: waiting for messages in the queue	6,313	99.56	30,676	4859	0.01
gcs remote message	2,633,320	78.29	14,362	5	3.66
PX Idle Wait	2,574	96.00	6,133	2383	0.00
DIAG idle wait	18,775	0.00	3,703	197	0.03
jobq slave wait	1,594	47.49	3,701	2322	0.00
Streams AQ: qmn slave idle wait	134	0.00	3,692	27555	0.00
Streams AQ: qmn coordinator idle wait	282	47.16	3,692	13093	0.00
ges remote message	199,425	86.01	3,685	18	0.28
Streams AQ: waiting for time management or cleanup tasks	1	100.00	1,109	1108577	0.00
PX Deq: Execution Msg	828	34.54	26	31	0.00
PX Deq: Table Q Normal	5,015	39.32	2	0	0.01
PX Deq: Msg Fragment	1,096	45.71	0	0	0.00
PX Deq: Join ACK	50	40.00	0	3	0.00
PX Deq: Execute Reply	42	30.95	0	3	0.00
PX Deq: Parse Reply	47	38.30	0	1	0.00
PX Deq Credit: need buffer	127	9.45	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	282	100.00	0	0	0.00
class slave wait	2	0.00	0	1	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,200,324	31.64	419	0	1.67
log file parallel write	566,164	0.00	164	0	0.79
db file parallel write	120,976	0.00	33	0	0.17
gc cr multi block request	7,222	0.00	3	0	0.01
os thread startup	33	0.00	2	74	0.00
enq: HW - contention	2,812	0.00	2	1	0.00
db file scattered read	424	0.00	2	5	0.00
control file sequential read	7,540	0.00	2	0	0.01
control file parallel write	1,762	0.00	1	1	0.00
row cache lock	299	0.00	1	2	0.00
library cache lock	201	0.00	0	2	0.00
latch: cache buffers chains	2,559	0.00	0	0	0.00
gc cr block 2-way	322	0.00	0	1	0.00
enq: RO - fast object reuse	55	0.00	0	3	0.00
db file parallel read	14	0.00	0	11	0.00
gc current block 2-way	243	0.00	0	0	0.00
db file sequential read	38	0.00	0	2	0.00
enq: KO - fast object checkpoint	40	0.00	0	2	0.00
latch: redo writing	102	0.00	0	0	0.00
buffer busy waits	178	1.12	0	0	0.00
gc cr grant 2-way	28	0.00	0	0	0.00
enq: TM - contention	32	0.00	0	0	0.00
gc current grant busy	14	0.00	0	0	0.00
gc cr block congested	1	0.00	0	2	0.00
gc current grant 2-way	4	0.00	0	0	0.00
latch: row cache objects	4	0.00	0	0	0.00
rdbms ipc message	1,641,594	3.84	39,776	24	2.28
gcs remote message	2,633,189	78.29	14,361	5	3.66
DIAG idle wait	18,775	0.00	3,703	197	0.03
Streams AQ: qmn slave idle wait	134	0.00	3,692	27555	0.00
Streams AQ: qmn coordinator idle wait	282	47.16	3,692	13093	0.00
pmon timer	2,083	99.71	3,685	1769	0.00
ges remote message	199,424	86.01	3,685	18	0.28
smon timer	125,993	0.00	3,663	29	0.18
Streams AQ: waiting for time management or cleanup tasks	1	100.00	1,109	1108577	0.00
PX Deq: Join ACK	33	42.42	0	2	0.00
PX Deq: Parse Reply	31	38.71	0	2	0.00
PX Deq: Execute Reply	24	29.17	0	1	0.00
Streams AQ: RAC qmn coordinator idle wait	282	100.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	30,814,163
IDLE_TIME	31,323,071
IOWAIT_TIME	745,033
NICE_TIME	0
SYS_TIME	3,312,857
USER_TIME	25,902,318
LOAD	9
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	30,156,128
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	30,224.70	24,989.90	271,460	557,616,313
SYS$USERS	9.60	5.30	200	25,808
SYS$BACKGROUND	0.00	0.00	7,855	5,539,027

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	168548	61525	154722	34339	38677497	17432
SYS$USERS	290	54	287	67	3946	1
SYS$BACKGROUND	906	284	3654	413	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
4,847	4,725	199,977	0.02	16.07	60t2tt1564j0k	? @o240-2 (TNS V1-V3)	SELECT SUBSTRB(MACHINE, 1, 60)...
4,002	3,861	6,858	0.58	13.27	fkxdmd0h7xg54	OEXOETEL	select item, item_id, item_d...
3,400	3,071	96,784	0.04	11.27	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,139	2,019	66,199	0.03	7.09	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
965	937	31,093	0.03	3.20	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
921	49	20,401	0.05	3.05	b3mn796k1hszr	CSCCCCRC	SELECT END_DATE, ITEM_KEY FROM...
919	865	192,556	0.00	3.05	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
833	476	6,786	0.12	2.76	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
696	672	241,560	0.00	2.31	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
555	543	13,605	0.04	1.84	0c3a5qdmx2785	CSXSRISR	UPDATE CS_INCIDENTS_ALL_TL SET...
519	507	23,022	0.02	1.72	0t3fycvxv9xwb		INSERT INTO CTXSYS.DRV$PENDING...
511	500	15,330	0.03	1.69	7gtztzv329wg0		select c.name, u.name from co...
509	413	1,725	0.29	1.69	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
459	453	276,823	0.00	1.52	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
350	271	20,383	0.02	1.16	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
316	266	8,625	0.04	1.05	bfbyqwbr4vwms	OEXOETEL	begin OE_OEOL_SCH.SCHEDULE_LIN...
309	232	357	0.86	1.02	fumydqvpk1g21	qotSCopOverview.jsp	BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q...

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
4,725	4,847	199,977	0.02	16.07	60t2tt1564j0k	? @o240-2 (TNS V1-V3)	SELECT SUBSTRB(MACHINE, 1, 60)...
3,861	4,002	6,858	0.56	13.27	fkxdmd0h7xg54	OEXOETEL	select item, item_id, item_d...
3,071	3,400	96,784	0.03	11.27	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,019	2,139	66,199	0.03	7.09	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
937	965	31,093	0.03	3.20	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
865	919	192,556	0.00	3.05	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
672	696	241,560	0.00	2.31	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
543	555	13,605	0.04	1.84	0c3a5qdmx2785	CSXSRISR	UPDATE CS_INCIDENTS_ALL_TL SET...
507	519	23,022	0.02	1.72	0t3fycvxv9xwb		INSERT INTO CTXSYS.DRV$PENDING...
500	511	15,330	0.03	1.69	7gtztzv329wg0		select c.name, u.name from co...
476	833	6,786	0.07	2.76	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
453	459	276,823	0.00	1.52	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
413	509	1,725	0.24	1.69	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
271	350	20,383	0.01	1.16	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
266	316	8,625	0.03	1.05	bfbyqwbr4vwms	OEXOETEL	begin OE_OEOL_SCH.SCHEDULE_LIN...
232	309	357	0.65	1.02	fumydqvpk1g21	qotSCopOverview.jsp	BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q...
49	921	20,401	0.00	3.05	b3mn796k1hszr	CSCCCCRC	SELECT END_DATE, ITEM_KEY FROM...

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: 562,905,787