Oracle, The World's Largest Enterprise Software Company
  |  WorldwideChange Country, Oracle Worldwide Web SitesSitefinder
Secure Search
PRODUCTS AND SERVICES INDUSTRIES SUPPORT PARTNERS COMMUNITIES ABOUT

AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
VIS187584551VIS110.2.0.3.0NOhpdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:115-Feb-08 17:33:372621 201.7
End Snap:215-Feb-08 18:33:432632 241.7
Elapsed:  60.08 (mins)  
DB Time:  385.09 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 18,384M 18,304MStd Block Size: 8K
Shared Pool Size: 2,000M 2,080MLog Buffer: 14,320K

Load Profile

Per SecondPer Transaction
Redo size: 7,943,529.02 38,191.53
Logical reads: 465,426.27 2,237.71
Block changes: 48,587.92 233.60
Physical reads: 111.45 0.54
Physical writes: 771.38 3.71
User calls: 6,765.27 32.53
Parses: 1,476.18 7.10
Hard parses: 1.65 0.01
Sorts: 1,888.60 9.08
Logons: 1.65 0.01
Executes: 18,621.11 89.53
Transactions: 207.99 

% Blocks changed per Read: 10.44Recursive Call %: 81.83
Rollback per transaction %: 16.63Rows per Sort: 13.20

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95Redo NoWait %: 100.00
Buffer Hit %: 99.98In-memory Sort %: 100.00
Library Hit %: 99.77Soft Parse %: 99.89
Execute to Parse %: 92.07Latch Hit %: 98.45
Parse CPU to Parse Elapsd %: 82.49% Non-Parse CPU: 98.06

Shared Pool Statistics

BeginEnd
Memory Usage %: 80.55 85.90
% SQL with executions>1: 87.02 89.58
% Memory for SQL w/exec>1: 73.57 67.54

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  19,163  82.9 
db file sequential read 225,225 1,905 8 8.2User I/O
log file sync 271,997 405 1 1.8Commit
db file scattered read 15,052 396 26 1.7User I/O
enq: RO - fast object reuse 151 363 2,405 1.6Application

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

  • Total time in database user-calls (DB Time): 23105.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 NameTime (s)% of DB Time
sql execute elapsed time 20,529.51 88.85
DB CPU 19,162.81 82.94
PL/SQL execution elapsed time 4,186.32 18.12
inbound PL/SQL rpc elapsed time 3,560.49 15.41
Java execution elapsed time 579.79 2.51
parse time elapsed 503.83 2.18
hard parse elapsed time 228.04 0.99
repeated bind elapsed time 57.88 0.25
sequence load elapsed time 14.80 0.06
connection management call elapsed time 8.59 0.04
PL/SQL compilation elapsed time 8.23 0.04
hard parse (sharing criteria) elapsed time 3.61 0.02
hard parse (bind mismatch) elapsed time 0.93 0.00
failed parse elapsed time 0.91 0.00
DB time 23,105.24  
background elapsed time 1,179.35  
background cpu time 413.31  

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 ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
User I/O 286,114 0.02 2,602 9 0.38
Application 39,996 0.42 559 14 0.05
Commit 271,997 0.00 405 1 0.36
Network 28,134,141 0.00 351 0 37.52
Concurrency 2,360,002 0.22 328 0 3.15
System I/O 602,985 0.00 284 0 0.80
Other 119,062 38.26 85 1 0.16
Configuration 8,069 0.40 15 2 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)
EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 225,225 0.00 1,905 8 0.30
log file sync 271,997 0.00 405 1 0.36
db file scattered read 15,052 0.00 396 26 0.02
enq: RO - fast object reuse 151 78.81 363 2405 0.00
SQL*Net more data from client 1,291,919 0.00 294 0 1.72
log file parallel write 571,839 0.00 278 0 0.76
read by other session 42,265 0.00 168 4 0.06
buffer busy waits 777,495 0.01 160 0 1.04
local write wait 1,399 4.50 133 95 0.00
enq: UL - contention 2,346 1.45 119 51 0.00
enq: TX - row lock contention 330 4.24 62 189 0.00
cursor: pin S wait on X 5,577 92.43 56 10 0.01
rdbms ipc reply 25 88.00 45 1798 0.00
latch: cache buffers chains 1,520,002 0.00 41 0 2.03
enq: TX - index contention 28,005 0.00 34 1 0.04
SQL*Net message to client 25,548,492 0.00 32 0 34.07
library cache load lock 773 0.00 27 35 0.00
SQL*Net more data to client 1,293,730 0.00 25 0 1.73
PX Deq Credit: send blkd 21,129 0.00 21 1 0.03
enq: HW - contention 3,238 0.00 10 3 0.00
enq: TM - contention 7 28.57 7 1071 0.00
SQL*Net break/reset to client 37,162 0.00 7 0 0.05
control file parallel write 1,829 0.00 6 3 0.00
kksfbc child completion 139 83.45 6 42 0.00
write complete waits 37 86.49 3 89 0.00
os thread startup 78 0.00 3 37 0.00
wait list latch free 237 0.00 3 11 0.00
latch: library cache 5,625 0.00 2 0 0.01
row cache lock 1,075 0.00 2 2 0.00
latch: In memory undo latch 17,199 0.00 2 0 0.02
PX Deq: Signal ACK 210 30.48 1 7 0.00
latch: undo global data 7,303 0.00 1 0 0.01
enq: TX - contention 2,717 0.00 1 0 0.00
latch free 2,537 0.00 1 0 0.00
enq: DV - contention 183 0.00 1 5 0.00
LGWR wait for redo copy 23,022 0.00 1 0 0.03
enq: SQ - contention 4,222 0.00 1 0 0.01
latch: library cache pin 1,659 0.00 1 0 0.00
latch: session allocation 1,314 0.00 1 0 0.00
latch: object queue header operation 7,237 0.00 1 0 0.01
PX qref latch 983 95.93 1 1 0.00
buffer deadlock 45,106 98.43 1 0 0.06
latch: redo allocation 2,057 0.00 1 0 0.00
log file switch completion 40 0.00 0 11 0.00
enq: TX - allocate ITL entry 132 0.00 0 2 0.00
enq: FB - contention 920 0.00 0 0 0.00
control file sequential read 29,305 0.00 0 0 0.04
SGA: allocation forcing component growth 21 66.67 0 10 0.00
latch: row cache objects 508 0.00 0 0 0.00
latch: cache buffers lru chain 427 0.00 0 0 0.00
latch: messages 55 0.00 0 3 0.00
latch: redo writing 400 0.00 0 0 0.00
library cache pin 1,159 0.00 0 0 0.00
latch: shared pool 274 0.00 0 0 0.00
latch: cache buffer handles 214 0.00 0 0 0.00
latch: object queue header heap 166 0.00 0 0 0.00
latch: library cache lock 100 0.00 0 1 0.00
cursor: pin S 2,920 0.00 0 0 0.00
library cache lock 2 0.00 0 17 0.00
cursor: mutex S 201 0.00 0 0 0.00
reliable message 35 0.00 0 0 0.00
latch: enqueue hash chains 28 0.00 0 0 0.00
enq: CU - contention 2 0.00 0 1 0.00
enq: PS - contention 48 0.00 0 0 0.00
direct path read 1,464 0.00 0 0 0.00
latch: parallel query alloc buffer 6 0.00 0 0 0.00
cursor: mutex X 270 0.00 0 0 0.00
log file single write 6 0.00 0 0 0.00
direct path write 665 0.00 0 0 0.00
kkdlgon 3 0.00 0 0 0.00
log file sequential read 6 0.00 0 0 0.00
latch: checkpoint queue latch 18 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 25,548,488 0.00 5,052,173 198 34.07
pipe get 16,884 28.71 21,092 1249 0.02
Streams AQ: waiting for messages in the queue 2,390 100.00 11,664 4880 0.00
PX Idle Wait 3,279 76.61 5,167 1576 0.00
Streams AQ: waiting for time management or cleanup tasks 1,772 37.58 3,507 1979 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,500 27346 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,500 13673 0.00
PL/SQL lock timer 247 99.19 2,721 11018 0.00
jobq slave wait 616 99.51 1,803 2927 0.00
PX Deq: Execution Msg 11,908 0.00 56 5 0.02
PX Deq: Execute Reply 4,587 0.00 2 1 0.01
PX Deq Credit: need buffer 3,589 0.00 2 1 0.00
PX Deq: Msg Fragment 9,333 0.00 2 0 0.01
PX Deq: Table Q Normal 8,065 0.00 1 0 0.01
PX Deq: Parse Reply 340 0.00 0 1 0.00
PX Deq: Join ACK 240 0.00 0 0 0.00
class slave wait 1 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)
EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 571,838 0.00 278 0 0.76
control file parallel write 1,829 0.00 6 3 0.00
db file sequential read 1,041 0.00 2 2 0.00
os thread startup 62 0.00 2 37 0.00
events in waitclass Other 27,763 0.00 2 0 0.04
db file scattered read 68 0.00 0 3 0.00
latch: redo writing 400 0.00 0 0 0.00
control file sequential read 968 0.00 0 0 0.00
latch: cache buffers chains 34 0.00 0 0 0.00
direct path read 1,464 0.00 0 0 0.00
buffer busy waits 12 0.00 0 0 0.00
log file single write 6 0.00 0 0 0.00
log file sequential read 6 0.00 0 0 0.00
direct path write 555 0.00 0 0 0.00
log file sync 1 0.00 0 1 0.00
latch: shared pool 2 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
latch: In memory undo latch 1 0.00 0 0 0.00
rdbms ipc message 917,595 1.12 29,885 33 1.22
pmon timer 1,251 97.28 3,512 2807 0.00
smon timer 72,971 0.00 3,509 48 0.10
Streams AQ: waiting for time management or cleanup tasks 1,772 37.58 3,507 1979 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,500 27346 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,500 13673 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 2,095,131
IDLE_TIME 3,664,295
IOWAIT_TIME 146,130
NICE_TIME 19,424
SYS_TIME 123,525
USER_TIME 1,889,740
LOAD 4
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 27,792
NUM_CPUS 16
NUM_CPU_SOCKETS 4

Back to Wait Events Statistics
Back to Top

Service Statistics

  • ordered by DB Time
Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 23,101.10 19,159.20 398,669 1,675,585,569
SYS$BACKGROUND 0.00 0.00 3,034 2,165,127
VIS 0.00 0.00 0 0

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 NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS 282982 259898 2359859 32541 0 0 28120093 35087
SYS$BACKGROUND 3130 254 112 231 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

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 IdSQL ModuleSQL Text
1,785 1,783 10 178.46 7.72 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
826 826 299 2.76 3.58 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
645 610 16 40.29 2.79 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
462 458 53,349 0.01 2.00 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
446 147 9,999 0.04 1.93 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
418 417 53,334 0.01 1.81 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
411 4 56 7.34 1.78 9k7t8q4kfcb7y SQL*Plus begin GL.apps_ddl.apps_ddl(:dd...
406 2 8 50.81 1.76 0smgkw5kuqj00 GLLEZL begin ad_ddl.do_ddl(:schema, ...
393 392 53,338 0.01 1.70 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
389 75 1,120 0.35 1.68 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
332 11 1,120 0.30 1.44 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
328 306 5,000 0.07 1.42 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
314 296 52,308 0.01 1.36 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
313 265 94,752 0.00 1.35 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
297 297 8 37.09 1.28 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
270 269 44,196 0.01 1.17 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
263 262 172,413 0.00 1.14 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
245 239 161,219 0.00 1.06 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
240 181 124,481 0.00 1.04 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
233 102 10,086 0.02 1.01 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...

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 IdSQL ModuleSQL Text
1,783 1,785 10 178.27 7.72 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
826 826 299 2.76 3.58 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
610 645 16 38.10 2.79 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
458 462 53,349 0.01 2.00 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
417 418 53,334 0.01 1.81 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
392 393 53,338 0.01 1.70 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
306 328 5,000 0.06 1.42 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
297 297 8 37.08 1.28 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
296 314 52,308 0.01 1.36 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
269 270 44,196 0.01 1.17 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
265 313 94,752 0.00 1.35 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
262 263 172,413 0.00 1.14 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
239 245 161,219 0.00 1.06 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
181 240 124,481 0.00 1.04 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
147 446 9,999 0.01 1.93 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
102 233 10,086 0.01 1.01 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
75 389 1,120 0.07 1.68 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
11 332 1,120 0.01 1.44 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
4 411 56 0.06 1.78 9k7t8q4kfcb7y SQL*Plus begin GL.apps_ddl.apps_ddl(:dd...
2 406 8 0.23 1.76 0smgkw5kuqj00 GLLEZL begin ad_ddl.do_ddl(:schema, ...

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,677,900,325
  • Captured SQL account for 23.2% of Total
Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
150,878,984 10 15,087,898.40 8.99 1782.70 1784.65 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
107,328,966 44,196 2,428.48 6.40 268.67 269.70 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
99,157,718 16 6,197,357.38 5.91 609.67 644.68 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
73,651,467 8 9,206,433.38 4.39 296.62 296.73 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
50,075,499 153,363 326.52 2.98 188.44 189.09 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
45,664,423 53,349 855.96 2.72 458.17 461.80 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
40,740,264 299 136,255.06 2.43 826.19 826.23 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
39,303,830 11 3,573,075.45 2.34 187.35 188.36 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
36,485,627 5,000 7,297.13 2.17 306.07 328.39 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
35,651,731 94,752 376.26 2.12 264.89 312.57 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
34,608,551 124,481 278.02 2.06 181.43 240.40 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
32,279,300 53,338 605.18 1.92 392.29 393.46 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
31,330,523 161,219 194.34 1.87 238.65 244.60 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
31,321,042 161,208 194.29 1.87 224.11 230.04 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
26,396,650 9,999 2,639.93 1.57 147.39 445.56 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
25,237,182 11 2,294,289.27 1.50 125.88 125.96 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
23,549,746 1,234,017 19.08 1.40 126.32 126.82 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
23,140,818 53,334 433.88 1.38 416.69 417.79 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
20,363,655 3,368 6,046.22 1.21 121.59 168.68 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

  • Total Disk Reads: 401,782
  • Captured SQL account for 32.8% of Total
Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
45,240 9,999 4.52 11.26 147.39 445.56 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
40,661 1,120 36.30 10.12 10.53 331.92 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
29,930 1,120 26.72 7.45 74.51 388.97 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
16,224 10,086 1.61 4.04 102.48 232.93 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
10,288 124,481 0.08 2.56 181.43 240.40 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
8,127 3,368 2.41 2.02 121.59 168.68 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
8,089 94,752 0.09 2.01 264.89 312.57 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,600 10,000 0.46 1.14 183.18 214.85 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,510 10,000 0.45 1.12 152.28 180.31 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...
670 9,942 0.07 0.17 131.89 141.22 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....

Back to SQL Statistics
Back to Top

SQL ordered by Executions

  • Total Executions: 67,130,659
  • Captured SQL account for 8.7% of Total
Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
1,234,017 639,979 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
708,213 708,147 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
282,568 282,562 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
194,356 155,670 0.80 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
172,413 172,406 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
161,220 161,206 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
161,219 161,205 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
161,208 161,206 1.00 0.00 0.00 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
153,363 153,356 1.00 0.00 0.00 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
138,366 2,352,126 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

  • Total Parse Calls: 5,321,765
  • Captured SQL account for 47.9% of Total
Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
282,566 282,568 5.31 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
194,355 194,356 3.65 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
172,415 172,413 3.24 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
161,010 161,220 3.03 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
138,365 138,366 2.60 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
111,595 111,764