	\| 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 08-Mar-08 07:49:59 1900 149.3

End Snap: 2 08-Mar-08 08:50:08 1877 157.4

Elapsed: 60.16 (mins)

DB Time: 398.18 (mins)

Report Summary

Cache Sizes

Begin End

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

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

Load Profile

Per Second Per Transaction

Redo size: 8,410,885.89 51,046.05

Logical reads: 398,665.10 2,419.52

Block changes: 51,136.22 310.35

Physical reads: 46.07 0.28

Physical writes: 834.30 5.06

User calls: 4,409.64 26.76

Parses: 2,361.66 14.33

Hard parses: 1.20 0.01

Sorts: 2,445.26 14.84

Logons: 2.30 0.01

Executes: 20,348.34 123.50

Transactions: 164.77

% Blocks changed per Read: 12.83 Recursive Call %: 89.05

Rollback per transaction %: 8.51 Rows per Sort: 8.95

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.80 Soft Parse %: 99.95

Execute to Parse %: 88.39 Latch Hit %: 98.90

Parse CPU to Parse Elapsd %: 87.37 % Non-Parse CPU: 97.19

Shared Pool Statistics

Begin End

Memory Usage %: 71.13 78.64

% SQL with executions>1: 82.02 79.70

% Memory for SQL w/exec>1: 54.48 44.85

Top 5 Timed Events

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

CPU time 21,366 89.4

gc buffer busy 30,512 500 16 2.1 Cluster

log file sync 184,651 409 2 1.7 Commit

log file parallel write 529,127 281 1 1.2 System I/O

db file sequential read 76,685 254 3 1.1 User I/O

RAC Statistics

Begin End

Number of Instances: 2 2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 81.89 0.50

Global Cache blocks served: 116.16 0.70

GCS/GES messages received: 651.44 3.95

GCS/GES messages sent: 695.37 4.22

DBWR Fusion writes: 9.34 0.06

Estd Interconnect traffic (KB) 1,847.45

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

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

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

Avg global cache current block pin time (ms): 4,267.9

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

Global cache log flushes for current blocks served %: 1.4

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): -1,852.5

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

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 24.84

% of indirect sent messages: 32.67

% of flow controlled messages: 42.49

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): 23891s
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	21,365.87	89.43
sql execute elapsed time	20,556.77	86.04
PL/SQL execution elapsed time	5,397.21	22.59
inbound PL/SQL rpc elapsed time	5,310.42	22.23
parse time elapsed	742.41	3.11
Java execution elapsed time	665.41	2.79
hard parse elapsed time	452.10	1.89
sequence load elapsed time	43.21	0.18
repeated bind elapsed time	38.84	0.16
connection management call elapsed time	15.23	0.06
PL/SQL compilation elapsed time	4.84	0.02
hard parse (sharing criteria) elapsed time	4.42	0.02
hard parse (bind mismatch) elapsed time	1.16	0.00
DB time	23,890.99
background elapsed time	1,381.12
background cpu time	759.41

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	687,623	0.06	810	1	1.16
Commit	184,651	0.00	409	2	0.31
System I/O	762,367	0.00	396	1	1.28
Other	1,263,149	47.53	387	0	2.12
User I/O	101,412	0.00	368	4	0.17
Concurrency	1,899,307	0.29	326	0	3.19
Application	43,198	1.03	268	6	0.07
Network	20,238,432	0.00	106	0	34.03
Configuration	48,133	12.99	60	1	0.08

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	30,512	1.35	500	16	0.05
log file sync	184,651	0.00	409	2	0.31
log file parallel write	529,127	0.00	281	1	0.89
db file sequential read	76,685	0.00	254	3	0.13
enq: TX - row lock contention	1,111	24.21	135	122	0.00
enq: UL - contention	33,561	0.49	122	4	0.06
db file parallel write	222,170	0.00	107	0	0.37
wait for scn ack	329,129	0.00	95	0	0.55
gc cr block busy	31,663	0.00	80	3	0.05
gc cr block 2-way	146,774	0.00	72	0	0.25
db file scattered read	11,427	0.00	71	6	0.02
latch: cache buffers chains	1,058,740	0.00	69	0	1.78
enq: TX - index contention	31,315	0.05	69	2	0.05
gcs log flush sync	67,040	16.51	62	1	0.11
cursor: pin S wait on X	5,796	94.81	60	10	0.01
buffer busy waits	693,019	0.00	59	0	1.17
SQL*Net more data from client	1,945,167	0.00	56	0	3.27
enq: HW - contention	34,057	0.00	55	2	0.06
read by other session	12,258	0.00	40	3	0.02
DFS lock handle	14,320	0.46	40	3	0.02
gc current block 2-way	75,781	0.00	36	0	0.13
row cache lock	86,224	0.00	35	0	0.14
cr request retry	54	83.33	34	634	0.00
enq: FB - contention	20,946	0.08	33	2	0.04
enq: TX - contention	3,357	0.39	30	9	0.01
gc current multi block request	254,266	0.00	30	0	0.43
gc current grant busy	34,252	0.00	28	1	0.06
SQL*Net more data to client	1,539,385	0.00	27	0	2.59
global enqueue expand wait	2,543	84.00	24	9	0.00
SQL*Net message to client	16,753,880	0.00	24	0	28.17
gc cr multi block request	45,772	0.00	17	0	0.08
library cache load lock	732	0.00	15	21	0.00
gc current block busy	1,356	0.00	15	11	0.00
gc current grant 2-way	33,586	0.00	12	0	0.06
gc cr grant 2-way	33,203	0.00	11	0	0.06
enq: RO - fast object reuse	100	11.00	8	80	0.00
gcs drm freeze in enter server mode	31	12.90	8	254	0.00
enq: US - contention	10,440	0.00	7	1	0.02
control file sequential read	9,355	0.00	7	1	0.02
latch: library cache	10,305	0.00	7	1	0.02
latch: object queue header operation	14,735	0.00	6	0	0.02
gc recovery quiesce	12	50.00	6	489	0.00
library cache lock	4,354	0.02	5	1	0.01
kksfbc child completion	103	84.47	4	42	0.00
enq: SQ - contention	7,567	0.00	4	1	0.01
PX Deq Credit: send blkd	13,689	40.02	4	0	0.02
name-service call wait	68	0.00	4	59	0.00
SQL*Net break/reset to client	8,332	0.00	3	0	0.01
ksxr poll remote instances	273,781	58.91	3	0	0.46
latch: undo global data	7,595	0.00	3	0	0.01
enq: DV - contention	1,170	0.00	3	2	0.00
PX Deq: Signal ACK	587	39.18	3	5	0.00
PX Deq: reap credit	151,357	81.91	3	0	0.25
LGWR wait for redo copy	35,329	0.00	3	0	0.06
wait list latch free	228	0.00	3	11	0.00
reliable message	637	0.00	2	4	0.00
library cache pin	3,838	0.00	2	1	0.01
latch: library cache pin	3,515	0.00	2	1	0.01
control file parallel write	1,715	0.00	2	1	0.00
os thread startup	22	0.00	2	102	0.00
buffer deadlock	38,835	98.66	2	0	0.07
gc quiesce wait	3	66.67	2	652	0.00
direct path read	426	0.00	2	4	0.00
latch: redo allocation	3,151	0.00	2	1	0.01
latch: cache buffers lru chain	1,102	0.00	2	1	0.00
latch free	2,757	0.00	1	0	0.00
enq: WF - contention	11	18.18	1	104	0.00
PX qref latch	170,692	99.89	1	0	0.29
latch: session allocation	1,319	0.00	1	1	0.00
CGS wait for IPC msg	87,206	99.83	1	0	0.15
enq: TX - allocate ITL entry	148	0.00	1	5	0.00
enq: PS - contention	1,192	0.00	1	1	0.00
latch: ges resource hash list	1,970	0.00	1	0	0.00
gc remaster	11	0.00	1	53	0.00
local write wait	216	0.00	1	2	0.00
rdbms ipc reply	1,177	0.00	0	0	0.00
gc cr block congested	203	0.00	0	2	0.00
latch: row cache objects	709	0.00	0	0	0.00
gc current retry	23	0.00	0	11	0.00
gc current split	9	0.00	0	29	0.00
latch: library cache lock	347	0.00	0	1	0.00
latch: gcs resource hash	452	0.00	0	0	0.00
db file parallel read	12	0.00	0	11	0.00
enq: TT - contention	175	0.00	0	1	0.00
enq: CF - contention	144	0.00	0	1	0.00
cursor: pin S	4,143	0.00	0	0	0.01
latch: redo writing	94	0.00	0	1	0.00
latch: messages	452	0.00	0	0	0.00
latch: object queue header heap	119	0.00	0	1	0.00
latch: enqueue hash chains	100	0.00	0	1	0.00
gc current block congested	55	0.00	0	2	0.00
ges global resource directory to be frozen	7	100.00	0	11	0.00
latch: KCL gc element parent latch	217	0.00	0	0	0.00
gc cr grant congested	45	0.00	0	1	0.00
enq: TO - contention	88	0.00	0	1	0.00
latch: shared pool	166	0.00	0	0	0.00
gc current grant congested	39	0.00	0	1	0.00
latch: cache buffer handles	255	0.00	0	0	0.00
write complete waits	5	0.00	0	10	0.00
IPC send completion sync	242	28.51	0	0	0.00
enq: TM - contention	94	0.00	0	1	0.00
enq: TS - contention	15	0.00	0	2	0.00
kjbdrmcvtq lmon drm quiesce: ping completion	7	42.86	0	4	0.00
latch: checkpoint queue latch	49	0.00	0	1	0.00
gc cr failure	55	0.00	0	0	0.00
SGA: allocation forcing component growth	2	50.00	0	11	0.00
latch: parallel query alloc buffer	10	0.00	0	2	0.00
undo segment extension	6,256	99.92	0	0	0.01
enq: TA - contention	25	0.00	0	0	0.00
enq: KM - contention	11	0.00	0	1	0.00
enq: MD - contention	10	0.00	0	1	0.00
cursor: mutex S	129	0.00	0	0	0.00
cursor: mutex X	96	0.00	0	0	0.00
enq: MW - contention	2	0.00	0	4	0.00
enq: CU - contention	3	0.00	0	2	0.00
lock deadlock retry	8	100.00	0	1	0.00
enq: ST - contention	6	0.00	0	1	0.00
KJC: Wait for msg sends to complete	35	0.00	0	0	0.00
direct path write	344	0.00	0	0	0.00
ges2 LMON to wake up LMD - mrcvr	9	0.00	0	0	0.00
lock escalate retry	13	61.54	0	0	0.00
gc cr disk read	3	0.00	0	0	0.00
enq: DR - contention	2	0.00	0	0	0.00
enq: DL - contention	3	0.00	0	0	0.00
direct path write temp	38	0.00	0	0	0.00
direct path read temp	6	0.00	0	0	0.00
SQL*Net message from client	16,753,905	0.00	3,494,303	209	28.17
pipe get	29,507	14.40	21,078	714	0.05
Streams AQ: waiting for messages in the queue	2,806	98.08	15,187	5412	0.00
gcs remote message	2,347,746	73.23	13,792	6	3.95
PX Idle Wait	3,907	82.19	8,291	2122	0.01
Streams AQ: qmn coordinator idle wait	268	47.76	3,531	13175	0.00
DIAG idle wait	17,866	0.00	3,523	197	0.03
Streams AQ: qmn slave idle wait	140	0.00	3,519	25138	0.00
ges remote message	284,709	57.95	3,503	12	0.48
Streams AQ: waiting for time management or cleanup tasks	1	100.00	2,936	2935724	0.00
PL/SQL lock timer	228	96.49	2,476	10858	0.00
PX Deq: Execution Msg	15,953	8.88	304	19	0.03
PX Deq: Parse Reply	1,018	16.60	13	13	0.00
PX Deq: Msg Fragment	8,959	0.12	12	1	0.02
PX Deq: Execute Reply	11,678	29.49	11	1	0.02
PX Deq: Table Q Normal	8,589	30.12	5	1	0.01
PX Deq: Join ACK	1,251	38.85	1	0	0.00
PX Deq Credit: need buffer	1,301	36.74	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	268	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	529,129	0.00	281	1	0.89
events in waitclass Other	816,323	31.81	172	0	1.37
db file parallel write	222,143	0.00	107	0	0.37
control file sequential read	7,394	0.00	6	1	0.01
control file parallel write	1,715	0.00	2	1	0.00
direct path read	426	0.00	2	4	0.00
enq: HW - contention	1,224	0.00	1	0	0.00
row cache lock	265	0.00	0	1	0.00
latch: redo writing	94	0.00	0	1	0.00
gc current block 2-way	154	0.00	0	0	0.00
gc cr block 2-way	171	0.00	0	0	0.00
buffer busy waits	102	0.98	0	0	0.00
library cache lock	86	0.00	0	1	0.00
latch: cache buffers chains	189	0.00	0	0	0.00
gc current grant busy	27	0.00	0	1	0.00
enq: RO - fast object reuse	17	0.00	0	1	0.00
db file sequential read	2	0.00	0	4	0.00
enq: TM - contention	12	0.00	0	0	0.00
latch: row cache objects	17	0.00	0	0	0.00
direct path write	242	0.00	0	0	0.00
enq: ST - contention	1	0.00	0	2	0.00
gc cr multi block request	6	0.00	0	0	0.00
gc current grant 2-way	7	0.00	0	0	0.00
latch: shared pool	7	0.00	0	0	0.00
rdbms ipc message	1,342,845	4.63	37,486	28	2.26
gcs remote message	2,347,698	73.23	13,792	6	3.95
Streams AQ: qmn coordinator idle wait	268	47.76	3,531	13175	0.00
DIAG idle wait	17,865	0.00	3,523	197	0.03
Streams AQ: qmn slave idle wait	140	0.00	3,519	25138	0.00
pmon timer	2,596	98.65	3,518	1355	0.00
ges remote message	284,700	57.94	3,503	12	0.48
smon timer	152,857	0.00	3,494	23	0.26
Streams AQ: waiting for time management or cleanup tasks	1	100.00	2,936	2935724	0.00
PX Deq: Parse Reply	30	40.00	0	1	0.00
PX Deq: Join ACK	28	42.86	0	1	0.00
PX Deq: Execute Reply	24	25.00	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	268	100.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	2,356,136
IDLE_TIME	3,275,525
IOWAIT_TIME	60,003
NICE_TIME	0
SYS_TIME	162,470
USER_TIME	2,144,559
LOAD	4
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	19,811,724
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	23,775.50	21,304.20	125,974	1,434,120,789
SYS$USERS	114.30	60.50	39,992	3,734,084
SYS$BACKGROUND	0.00	0.00	428	1,041,240

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	94361	35301	1889250	32324	20219039	10590
SYS$USERS	6385	1295	9353	212	5699	2
SYS$BACKGROUND	670	173	711	35	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,011	1,942	10	201.06	8.42	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,104	1,050	302	3.65	4.62	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
740	649	16	46.28	3.10	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
660	594	1,441	0.46	2.76	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
487	481	6,015	0.08	2.04	a957tvxz9w038	icx.por.req.server.RequisitionAM	BEGIN :1 := por_util_pkg.inter...
471	459	57,198	0.01	1.97	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
424	409	57,207	0.01	1.77	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
407	356	5,000	0.08	1.70	2fjd6cndjby9p	ARTERRPW	INSERT INTO RA_CUST_TRX_LINE_G...
381	355	63,648	0.01	1.59	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
372	359	57,182	0.01	1.56	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
360	356	64,368	0.01	1.51	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
326	318	8	40.73	1.36	8vmj377jqyqwq	WSHASCSRS	BEGIN WSH_BATCH_PROCESS.CONFIR...
318	159	10,000	0.03	1.33	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
292	285	9	32.47	1.22	1du9v021t8m46	ARGLTP	insert into gl_interface(creat...
241	240	157,435	0.00	1.01	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...

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,942	2,011	10	194.22	8.42	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,050	1,104	302	3.48	4.62	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
649	740	16	40.57	3.10	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
594	660	1,441	0.41	2.76	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
481	487	6,015	0.08	2.04	a957tvxz9w038	icx.por.req.server.RequisitionAM	BEGIN :1 := por_util_pkg.inter...
459	471	57,198	0.01	1.97	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
409	424	57,207	0.01	1.77	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
359	372	57,182	0.01	1.56	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
356	407	5,000	0.07	1.70	2fjd6cndjby9p	ARTERRPW	INSERT INTO RA_CUST_TRX_LINE_G...
356	360	64,368	0.01	1.51	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
355	381	63,648	0.01	1.59	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
318	326	8	39.73	1.36	8vmj377jqyqwq	WSHASCSRS	BEGIN WSH_BATCH_PROCESS.CONFIR...
285	292	9	31.67	1.22	1du9v021t8m46	ARGLTP	insert into gl_interface(creat...
240	241	157,435	0.00	1.01	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
159	318	10,000	0.02	1.33	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...

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: 1,438,983,277
Captured SQL account for 22.4% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
173,123,758	10	17,312,375.80	12.03	1942.16	2010.55	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
81,343,316	16	5,083,957.25	5.65	649.19	740.47	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run