	\| 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 14:55:32 3055 213.4

End Snap: 4 08-Jan-08 16:00:57 1681 338.7

Elapsed: 65.42 (mins)

DB Time: 366.49 (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: 822,610.26 5,609.96

Logical reads: 111,033.73 757.22

Block changes: 5,623.74 38.35

Physical reads: 73.02 0.50

Physical writes: 110.82 0.76

User calls: 6,881.44 46.93

Parses: 1,019.27 6.95

Hard parses: 1.10 0.01

Sorts: 1,051.89 7.17

Logons: 1.03 0.01

Executes: 10,221.16 69.71

Transactions: 146.63

% Blocks changed per Read: 5.06 Recursive Call %: 70.12

Rollback per transaction %: 33.59 Rows per Sort: 10.52

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 100.01 Soft Parse %: 99.89

Execute to Parse %: 90.03 Latch Hit %: 99.79

Parse CPU to Parse Elapsd %: 89.26 % Non-Parse CPU: 98.42

Shared Pool Statistics

Begin End

Memory Usage %: 58.48 68.60

% SQL with executions>1: 95.90 97.66

% Memory for SQL w/exec>1: 95.80 98.18

Top 5 Timed Events

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

CPU time 19,298 87.8

gc buffer busy 7,815 604 77 2.7 Cluster

log file sync 291,766 505 2 2.3 Commit

db file sequential read 96,688 345 4 1.6 User I/O

wait for scn ack 399,094 171 0 .8 Other

RAC Statistics

Begin End

Number of Instances: 2 2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 67.57 0.46

Global Cache blocks served: 118.05 0.81

GCS/GES messages received: 697.99 4.76

GCS/GES messages sent: 565.31 3.86

DBWR Fusion writes: 5.92 0.04

Estd Interconnect traffic (KB) 1,731.70

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

Buffer access - local cache %: 99.91

Buffer access - remote cache %: 0.06

Buffer access - disk %: 0.03

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0

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

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

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

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

Global cache log flushes for cr blocks served %: 47.5

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

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

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1

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

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

% of indirect sent messages: 26.85

% of flow controlled messages: 44.59

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): 21989.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	19,297.69	87.76
sql execute elapsed time	18,633.85	84.74
inbound PL/SQL rpc elapsed time	6,010.06	27.33
PL/SQL execution elapsed time	4,124.72	18.76
parse time elapsed	376.99	1.71
repeated bind elapsed time	85.24	0.39
Java execution elapsed time	45.53	0.21
hard parse elapsed time	39.50	0.18
sequence load elapsed time	20.58	0.09
connection management call elapsed time	10.19	0.05
PL/SQL compilation elapsed time	3.25	0.01
failed parse elapsed time	3.08	0.01
hard parse (sharing criteria) elapsed time	1.53	0.01
hard parse (bind mismatch) elapsed time	0.10	0.00
DB time	21,989.25
background elapsed time	1,058.19
background cpu time	661.03

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	422,488	0.07	1,150	3	0.73
Commit	291,766	0.00	505	2	0.51
User I/O	124,853	0.00	460	4	0.22
Other	1,003,368	29.71	328	0	1.74
System I/O	565,669	0.00	131	0	0.98
Network	30,977,542	0.00	119	0	53.82
Concurrency	102,019	1.49	80	1	0.18
Application	61,454	0.00	27	0	0.11
Configuration	6,019	0.13	18	3	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
gc buffer busy	7,815	3.47	604	77	0.01
log file sync	291,766	0.00	505	2	0.51
db file sequential read	96,688	0.00	345	4	0.17
wait for scn ack	399,094	0.00	171	0	0.69
gc cr multi block request	54,313	0.00	133	2	0.09
gc cr block busy	32,815	0.00	125	4	0.06
db file scattered read	22,171	0.00	111	5	0.04
log file parallel write	461,906	0.00	110	0	0.80
gc cr block 2-way	103,260	0.00	86	1	0.18
SQL*Net more data from client	1,770,533	0.00	79	0	3.08
gcs log flush sync	221,966	4.57	76	0	0.39
gc current block 2-way	85,212	0.00	53	1	0.15
gc current multi block request	43,190	0.01	47	1	0.08
gc current grant busy	34,093	0.00	34	1	0.06
gc current block busy	2,048	0.00	29	14	0.00
SQL*Net message to client	28,363,481	0.00	27	0	49.28
SQL*Net break/reset to client	60,126	0.00	23	0	0.10
gc cr grant 2-way	40,831	0.00	19	0	0.07
db file parallel write	92,447	0.00	19	0	0.16
enq: HW - contention	5,843	0.14	17	3	0.01
cursor: pin S wait on X	1,524	99.48	17	11	0.00
enq: US - contention	9,027	0.07	17	2	0.02
row cache lock	20,749	0.00	16	1	0.04
latch: object queue header operation	16,319	0.00	14	1	0.03
SQL*Net more data to client	843,528	0.00	13	0	1.47
gcs drm freeze in enter server mode	41	26.83	12	294	0.00
latch: cache buffers chains	54,041	0.00	9	0	0.09
cr request retry	18	94.44	9	488	0.00
latch: library cache	8,427	0.00	8	1	0.01
library cache lock	5,153	0.00	8	2	0.01
gc current grant 2-way	17,635	0.00	8	0	0.03
enq: TX - index contention	430	0.47	6	14	0.00
latch: library cache pin	4,187	0.00	5	1	0.01
buffer busy waits	4,752	0.02	5	1	0.01
gc current retry	105	0.00	5	47	0.00
enq: FB - contention	1,668	0.18	5	3	0.00
enq: TX - contention	157	3.18	4	24	0.00
gc cr block congested	478	0.00	3	6	0.00
name-service call wait	47	0.00	3	57	0.00
latch free	4,386	0.00	2	1	0.01
gc remaster	48	0.00	2	44	0.00
db file parallel read	168	0.00	2	13	0.00
os thread startup	28	0.00	2	74	0.00
DFS lock handle	1,335	0.00	2	1	0.00
enq: TM - contention	95	2.11	2	19	0.00
control file sequential read	9,493	0.00	2	0	0.02
latch: row cache objects	1,810	0.00	2	1	0.00
local write wait	2,470	0.00	2	1	0.00
latch: cache buffers lru chain	1,103	0.00	1	1	0.00
CGS wait for IPC msg	203,126	99.82	1	0	0.35
LGWR wait for redo copy	7,910	0.05	1	0	0.01
enq: TX - row lock contention	198	0.00	1	6	0.00
enq: UL - contention	947	0.00	1	1	0.00
ksxr poll remote instances	100,153	67.33	1	0	0.17
gc current block congested	304	0.00	1	3	0.00
PX Deq Credit: send blkd	1,935	37.16	1	0	0.00
latch: session allocation	1,391	0.00	1	1	0.00
control file parallel write	1,823	0.00	1	0	0.00
latch: ges resource hash list	1,006	0.00	1	1	0.00
kjbdrmcvtq lmon drm quiesce: ping completion	37	8.11	1	19	0.00
latch: library cache lock	702	0.00	1	1	0.00
latch: gcs resource hash	788	0.00	1	1	0.00
reliable message	49	0.00	1	12	0.00
gc cr grant congested	202	0.00	1	3	0.00
cursor: pin S	9,759	0.00	0	0	0.02
PX Deq: reap credit	19,082	85.77	0	0	0.03
ges global resource directory to be frozen	37	100.00	0	11	0.00
rdbms ipc reply	397	0.00	0	1	0.00
enq: SQ - contention	105	0.00	0	3	0.00
kksfbc child completion	6	100.00	0	51	0.00
library cache load lock	28	0.00	0	10	0.00
enq: CF - contention	136	0.00	0	2	0.00
IPC send completion sync	192	98.44	0	1	0.00
enq: PS - contention	95	0.00	0	2	0.00
gc current grant congested	84	0.00	0	2	0.00
latch: object queue header heap	271	0.00	0	1	0.00
gc current split	20	0.00	0	8	0.00
latch: messages	377	0.00	0	0	0.00
latch: redo allocation	214	0.00	0	1	0.00
library cache pin	73	0.00	0	2	0.00
latch: undo global data	210	0.00	0	1	0.00
global enqueue expand wait	13	84.62	0	9	0.00
buffer deadlock	288	94.79	0	0	0.00
lock escalate retry	90	91.11	0	1	0.00
enq: TO - contention	73	0.00	0	1	0.00
ges inquiry response	59	0.00	0	1	0.00
latch: shared pool	88	0.00	0	1	0.00
enq: RO - fast object reuse	52	0.00	0	1	0.00
enq: WF - contention	21	0.00	0	3	0.00
read by other session	21	0.00	0	3	0.00
enq: KO - fast object checkpoint	36	0.00	0	2	0.00
wait list latch free	25	0.00	0	2	0.00
latch: KCL gc element parent latch	251	0.00	0	0	0.00
PX Deq: Signal ACK	45	28.89	0	1	0.00
gc current block unknown	17	0.00	0	2	0.00
latch: enqueue hash chains	38	0.00	0	1	0.00
latch: redo writing	68	0.00	0	0	0.00
direct path read	3,319	0.00	0	0	0.01
enq: TX - allocate ITL entry	3	0.00	0	3	0.00
latch: checkpoint queue latch	36	0.00	0	0	0.00
enq: TS - contention	9	0.00	0	1	0.00
enq: TA - contention	17	0.00	0	0	0.00
latch: cache buffer handles	20	0.00	0	0	0.00
gc cr failure	11	0.00	0	0	0.00
ges2 LMON to wake up LMD - mrcvr	14	14.29	0	0	0.00
latch: parallel query alloc buffer	8	0.00	0	0	0.00
lock deadlock retry	8	100.00	0	0	0.00
direct path write	16	0.00	0	0	0.00
KJC: Wait for msg sends to complete	20	0.00	0	0	0.00
cursor: mutex S	24	0.00	0	0	0.00
enq: IR - contention	1	0.00	0	0	0.00
gc current block lost	2	0.00	0	0	0.00
gc recovery quiesce	5	0.00	0	0	0.00
cursor: mutex X	3	0.00	0	0	0.00
SQL*Net message from client	28,364,109	0.00	6,880,802	243	49.28
Streams AQ: waiting for messages in the queue	6,539	99.54	31,764	4858	0.01
gcs remote message	2,356,344	79.63	14,993	6	4.09
PX Idle Wait	2,407	95.85	5,739	2384	0.00
Streams AQ: waiting for time management or cleanup tasks	1	100.00	4,164	4163523	0.00
DIAG idle wait	19,432	0.00	3,832	197	0.03
jobq slave wait	1,659	47.32	3,828	2308	0.00
Streams AQ: qmn coordinator idle wait	296	46.62	3,817	12896	0.00
Streams AQ: qmn slave idle wait	139	0.00	3,817	27461	0.00
ges remote message	203,818	90.13	3,816	19	0.35
PX Deq: Execution Msg	845	36.92	23	27	0.00
PX Deq: Table Q Normal	2,280	41.89	1	0	0.00
PX Deq: Msg Fragment	1,200	46.00	1	0	0.00
PX Deq: Join ACK	51	37.25	0	4	0.00
PX Deq: Execute Reply	48	31.25	0	4	0.00
PX Deq: Parse Reply	51	35.29	0	4	0.00
PX Deq Credit: need buffer	85	28.24	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	296	100.00	0	0	0.00
class slave wait	3	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	956,658	29.33	267	0	1.66
log file parallel write	461,881	0.00	110	0	0.80
db file parallel write	92,436	0.00	19	0	0.16
gc cr multi block request	9,288	0.00	2	0	0.02
control file sequential read	7,892	0.00	1	0	0.01
os thread startup	24	0.00	1	62	0.00
db file parallel read	124	0.00	1	11	0.00
db file scattered read	218	0.00	1	4	0.00
control file parallel write	1,823	0.00	1	0	0.00
enq: HW - contention	806	0.00	0	0	0.00
library cache lock	148	0.00	0	2	0.00
row cache lock	250	0.00	0	1	0.00
latch: cache buffers chains	1,946	0.00	0	0	0.00
db file sequential read	55	0.00	0	2	0.00
gc current block 2-way	194	0.00	0	0	0.00
gc cr block 2-way	194	0.00	0	0	0.00
enq: RO - fast object reuse	52	0.00	0	1	0.00
enq: KO - fast object checkpoint	36	0.00	0	2	0.00
latch: redo writing	68	0.00	0	0	0.00
gc cr grant 2-way	26	0.00	0	1	0.00
buffer busy waits	151	0.66	0	0	0.00
enq: TM - contention	20	0.00	0	0	0.00
gc current grant busy	20	0.00	0	0	0.00
gc current grant 2-way	19	0.00	0	0	0.00
gc current grant congested	1	0.00	0	2	0.00
log file sync	1	0.00	0	1	0.00
latch: row cache objects	4	0.00	0	0	0.00
rdbms ipc message	1,371,842	4.85	41,289	30	2.38
gcs remote message	2,356,182	79.63	14,993	6	4.09
Streams AQ: waiting for time management or cleanup tasks	1	100.00	4,164	4163523	0.00
DIAG idle wait	19,431	0.00	3,832	197	0.03
Streams AQ: qmn coordinator idle wait	296	46.62	3,817	12896	0.00
Streams AQ: qmn slave idle wait	139	0.00	3,817	27461	0.00
pmon timer	2,234	99.73	3,817	1709	0.00
ges remote message	203,798	90.13	3,816	19	0.35
smon timer	109,517	0.00	3,803	35	0.19
PX Deq: Parse Reply	29	37.93	0	2	0.00
PX Deq: Join ACK	28	39.29	0	2	0.00
PX Deq: Execute Reply	25	28.00	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	296	100.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	24,330,182
IDLE_TIME	39,968,197
IOWAIT_TIME	722,565
NICE_TIME	0
SYS_TIME	2,818,624
USER_TIME	20,291,049
LOAD	5
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	49,801,856
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	21,991.00	19,301.80	280,390	430,988,173
SYS$USERS	8.60	5.10	163	34,580
SYS$BACKGROUND	0.00	0.00	6,156	4,963,697

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	123549	45610	98689	7714	30949595	11926
SYS$USERS	224	38	420	94	4081	1
SYS$BACKGROUND	978	302	2905	240	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
3,807	3,725	161,060	0.02	17.31	60t2tt1564j0k	? @o240-2 (TNS V1-V3)	SELECT SUBSTRB(MACHINE, 1, 60)...
3,124	3,064	5,461	0.57	14.21	fkxdmd0h7xg54	OEXOETEL	select item, item_id, item_d...
2,471	2,366	76,558	0.03	11.24	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
1,639	1,598	53,704	0.03	7.45	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
785	768	26,039	0.03	3.57	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
701	665	154,689	0.00	3.19	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
525	513	193,212	0.00	2.39	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
432	368	5,436	0.08	1.96	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
413	407	10,937	0.04	1.88	0c3a5qdmx2785	CSXSRISR	UPDATE CS_INCIDENTS_ALL_TL SET...
385	379	18,474	0.02	1.75	0t3fycvxv9xwb		INSERT INTO CTXSYS.DRV$PENDING...
379	374	12,309	0.03	1.73	7gtztzv329wg0		select c.name, u.name from co...
364	319	1,372	0.27	1.66	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
361	355	220,023	0.00	1.64	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
267	212	16,173	0.02	1.21	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
231	180	1,803	0.13	1.05	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
229	207	6,860	0.03	1.04	bfbyqwbr4vwms	OEXOETEL	begin OE_OEOL_SCH.SCHEDULE_LIN...

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
3,725	3,807	161,060	0.02	17.31	60t2tt1564j0k	? @o240-2 (TNS V1-V3)	SELECT SUBSTRB(MACHINE, 1, 60)...
3,064	3,124	5,461	0.56	14.21	fkxdmd0h7xg54	OEXOETEL	select item, item_id, item_d...
2,366	2,471	76,558	0.03	11.24	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
1,598	1,639	53,704	0.03	7.45	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
768	785	26,039	0.03	3.57	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
665	701	154,689	0.00	3.19	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
513	525	193,212	0.00	2.39	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
407	413	10,937	0.04	1.88	0c3a5qdmx2785	CSXSRISR	UPDATE CS_INCIDENTS_ALL_TL SET...
379	385	18,474	0.02	1.75	0t3fycvxv9xwb		INSERT INTO CTXSYS.DRV$PENDING...
374	379	12,309	0.03	1.73	7gtztzv329wg0		select c.name, u.name from co...
368	432	5,436	0.07	1.96	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
355	361	220,023	0.00	1.64	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
319	364	1,372	0.23	1.66	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
212	267	16,173	0.01	1.21	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
207	229	6,860	0.03	1.04	bfbyqwbr4vwms	OEXOETEL	begin OE_OEOL_SCH.SCHEDULE_LIN...
180	231	1,803	0.10	1.05	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....

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: 435,838,140
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
70,897,021	154,689	458.32	16.27	664.93	700.74	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
69,697,640	193,212	360.73	15.99	512.53	525.42	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
31,049,691	22,707	1,367.41	7.12	112.19	115.42	5bv8zft2swgv2	OEXOETEL	SELECT 'x' FROM QP_LIST_HEADER...
21,194,856	5,461	3,881.13	4.86	3063.72	3123.60	fkxdmd0h7xg54	OEXOETEL	select item, item_id, item_d...
15,458,313	10,985	1,407.22	3.55	139.25	143.10	7qvfkq8x46u23