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 numReleaseClusterHost
VIS127695557VIS110.1.0.5.0NOdb0

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:5421-May-06 06:56:003345 182.3
End Snap:5521-May-06 07:57:123360 227.9
Elapsed:  61.20 (mins)  
DB Time:  661.46 (mins)  

Report Summary

Cache Sizes (end)

Buffer Cache: 7,168MStd Block Size: 8K
Shared Pool Size: 3,072MLog Buffer: 16,384K

Load Profile

Per SecondPer Transaction
Redo size: 8,150,381.71 33,071.94
Logical reads: 469,857.47 1,906.55
Block changes: 50,335.31 204.25
Physical reads: 237.98 0.97
Physical writes: 710.41 2.88
User calls: 8,313.43 33.73
Parses: 2,126.75 8.63
Hard parses: 1.97 0.01
Sorts: 2,724.49 11.06
Logons: 1.83 0.01
Executes: 20,430.57 82.90
Transactions: 246.44 

% Blocks changed per Read: 10.71Recursive Call %: 80.62
Rollback per transaction %: 18.51Rows per Sort: 21.61

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97Redo NoWait %: 100.00
Buffer Hit %: 99.95In-memory Sort %: 100.00
Library Hit %: 99.99Soft Parse %: 99.91
Execute to Parse %: 89.59Latch Hit %: 98.88
Parse CPU to Parse Elapsd %: 54.15% Non-Parse CPU: 97.45

Shared Pool Statistics

BeginEnd
Memory Usage %: 63.89 86.31
% SQL with executions>1: 65.52 82.07
% Memory for SQL w/exec>1: 72.38 62.23

Top 5 Timed Events

EventWaitsTime(s)Percent Total DB TimeWait Class
CPU time  23,025 58.01 
db file sequential read 705,787 3,033 7.64User I/O
latch: cache buffers chains 85,508 873 2.20Concurrency
log file sync 325,885 844 2.13Commit
log file parallel write 1,282,131 793 2.00System I/O

Main Report


Back to Top

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)
EventWaitsTimeoutsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 705,787 0 3,033 4 0.78
latch: cache buffers chains 85,508 85,508 873 10 0.09
log file sync 325,885 0 844 3 0.36
log file parallel write 1,282,131 0 793 1 1.42
enq: UL - contention 4,301 35 557 129 0.00
enq: TX - row lock contention 544 114 353 648 0.00
db file parallel write 221,291 0 313 1 0.24
buffer busy waits 524,865 3 108 0 0.58
SQL*Net more data from client 1,656,247 0 96 0 1.83
read by other session 39,519 0 77 2 0.04
library cache pin 2,659 0 66 25 0.00
enq: TX - index contention 15,458 0 59 4 0.02
rdbms ipc reply 16,909 7 35 2 0.02
SQL*Net more data to client 1,499,819 0 34 0 1.66
db file scattered read 14,464 0 32 2 0.02
library cache load lock 755 0 28 37 0.00
SQL*Net message to client 31,780,159 0 24 0 35.12
latch free 2,037 1,981 24 12 0.00
latch: undo global data 2,735 0 21 8 0.00
direct path read temp 9,892 0 18 2 0.01
SQL*Net break/reset to client 48,044 0 18 0 0.05
latch: In memory undo latch 2,958 0 16 5 0.00
latch: library cache 5,352 0 10 2 0.01
direct path write temp 3,252 0 9 3 0.00
PX Deq Credit: send blkd 10,117 0 7 1 0.01
enq: RO - fast object reuse 35 0 7 200 0.00
enq: CI - contention 2,995 0 7 2 0.00
local write wait 885 0 6 6 0.00
LGWR wait for redo copy 41,157 18 4 0 0.05
enq: TX - contention 2,591 0 3 1 0.00
control file parallel write 1,632 0 3 2 0.00
enq: HW - contention 2,539 0 3 1 0.00
latch: library cache pin 849 0 2 3 0.00
enq: DV - contention 108 0 2 17 0.00
PX Deq: Signal ACK 139 48 2 12 0.00
enq: TM - contention 3 0 1 498 0.00
enq: SQ - contention 2,846 0 1 0 0.00
library cache lock 23 0 1 43 0.00
latch: redo allocation 387 0 1 2 0.00
enq: CU - contention 25 0 1 28 0.00
control file sequential read 948 0 1 1 0.00
log buffer space 10 0 1 52 0.00
process startup 17 0 0 26 0.00
latch: row cache objects 61 0 0 6 0.00
log file switch completion 23 0 0 15 0.00
latch: cache buffers lru chain 93 0 0 3 0.00
enq: FB - contention 795 0 0 0 0.00
latch: library cache lock 37 0 0 6 0.00
row cache lock 562 0 0 0 0.00
latch: session allocation 74 0 0 2 0.00
control file single write 133 0 0 1 0.00
latch: checkpoint queue latch 6 0 0 13 0.00
latch: object queue header operation 33 0 0 2 0.00
undo segment extension 11,055 11,020 0 0 0.01
latch: cache buffer handles 38 0 0 1 0.00
buffer deadlock 5,319 5,289 0 0 0.01
kksfbc child completion 1 1 0 49 0.00
enq: TX - allocate ITL entry 71 0 0 1 0.00
latch: enqueue hash chains 9 0 0 4 0.00
latch: shared pool 26 0 0 1 0.00
db file parallel read 1 0 0 27 0.00
direct path read 420 0 0 0 0.00
latch: redo writing 3 0 0 4 0.00
direct path write 2,686 0 0 0 0.00
L1 validation 1 1 0 10 0.00
log file sequential read 2 0 0 5 0.00
enq: PS - contention 21 0 0 0 0.00
latch: messages 4 0 0 1 0.00
log file single write 2 0 0 0 0.00
PX Deq: Table Q qref 8 0 0 0 0.00
SQL*Net message from client 31,780,110 0 6,849,482 216 35.12
queue messages 6,697 6,032 41,087 6,135 0.01
pipe get 16,461 5,127 21,501 1,306 0.02
PL/SQL lock timer 699 698 7,959 11,386 0.00
PX Idle Wait 2,737 2,553 5,028 1,837 0.00
Queue Monitor Wait 122 122 3,561 29,191 0.00
wakeup time manager 1,776 922 2,837 1,597 0.00
PX Deq: Execution Msg 6,646 16 69 10 0.01
jobq slave wait 22 21 63 2,885 0.00
PX Deq: Execute Reply 4,746 1 14 3 0.01
PX Deq Credit: need buffer 1,543 0 1 1 0.00
PX Deq: Table Q Normal 1,743 0 1 0 0.00
PX Deq: Msg Fragment 1,583 0 0 0 0.00
PX Deq: Table Q Sample 37 0 0 3 0.00
PX Deq: Parse Reply 120 0 0 1 0.00
PX Deq: Join ACK 131 0 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)
EventWaitsTimeoutsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 1,282,183 0 793 1 1.42
db file parallel write 221,291 0 313 1 0.24
LGWR wait for redo copy 41,157 18 4 0 0.05
control file parallel write 1,632 0 3 2 0.00
rdbms ipc reply 5,967 0 1 0 0.01
latch: cache buffers chains 133 133 1 10 0.00
latch free 129 126 1 10 0.00
db file sequential read 235 0 1 3 0.00
control file sequential read 690 0 0 1 0.00
latch: library cache 225 0 0 1 0.00
latch: redo allocation 161 0 0 1 0.00
buffer busy waits 492 0 0 0 0.00
control file single write 133 0 0 1 0.00
db file scattered read 12 0 0 6 0.00
latch: cache buffers lru chain 45 0 0 1 0.00
process startup 1 0 0 35 0.00
latch: undo global data 5 0 0 6 0.00
latch: library cache pin 18 0 0 1 0.00
latch: session allocation 7 0 0 2 0.00
direct path read 420 0 0 0 0.00
latch: redo writing 3 0 0 4 0.00
latch: In memory undo latch 8 0 0 1 0.00
log file sequential read 2 0 0 5 0.00
latch: shared pool 7 0 0 1 0.00
direct path write 220 0 0 0 0.00
latch: messages 4 0 0 1 0.00
latch: library cache lock 1 0 0 2 0.00
enq: CI - contention 3 0 0 1 0.00
log file single write 2 0 0 0 0.00
latch: object queue header operation 2 0 0 0 0.00
rdbms ipc message 649,025 9,595 25,728 40 0.72
Queue Monitor Wait 122 122 3,561 29,191 0.00
smon timer 47,771 0 3,561 75 0.05
wakeup time manager 1,776 922 2,837 1,597 0.00

Back to Wait Events Statistics
Back to Top

Time Model Statistics

  • ordered by Time (seconds) desc
Statistic NameTime (seconds)% Total DB Time
DB time 39,687.78 100.00
sql execute elapsed time 34,675.00 87.37
DB CPU 23,024.83 58.01
PL/SQL execution elapsed time 8,031.51 20.24
inbound PL/SQL rpc elapsed time 5,898.38 14.86
Java execution elapsed time 2,304.64 5.81
background elapsed time 2,011.99 5.07
parse time elapsed 1,037.08 2.61
hard parse elapsed time 714.84 1.80
background cpu time 559.70 1.41
sequence load elapsed time 19.03 0.05
connection management call elapsed time 12.97 0.03
PL/SQL compilation elapsed time 8.59 0.02
failed parse elapsed time 3.45 0.01
hard parse (sharing criteria) elapsed time 2.23 0.01
hard parse (bind mismatch) elapsed time 2.21 0.01
failed parse (out of shared memory) elapsed t 0.00 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic NameValue
AVG_BUSY_TICKS 4,330,136
AVG_IDLE_TICKS 148,087
AVG_IN_BYTES 212,224
AVG_IOWAIT_TICKS 10,506
AVG_OUT_BYTES 904,960
AVG_SYS_TICKS 14,448
AVG_USER_TICKS 204,271
BUSY_TICKS 69,284,146
IDLE_TICKS 2,371,252
IN_BYTES 3,395,584
IOWAIT_TICKS 170,062
OS_CPU_WAIT_TIME 3,939,700
OUT_BYTES 14,479,360
RSRC_MGR_CPU_WAIT_TIME 0
SYS_TICKS 233,134
USER_TICKS 3,270,101

Back to Wait Events Statistics
Back to Top

Service Statistics

  • ordered by DB Time
Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
VIS 30,769.60 17,719.00 372,850 1,555,582,945
SYS$USERS 8,918.30 5,306.70 500,561 152,710,601
SYS$BACKGROUND 0.00 0.00 698 16,927,167

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
VIS 344,048 115,003 631,018 113,454 0 0 15,368,858 12,932
SYS$USERS 432,593 202,364 7,133 2,656 0 0 19,555,528 2,381
SYS$BACKGROUND 887 88 878 184 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
4,767 2,671 8 595.85 12.01 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
3,494 1,756 10 349.38 8.80 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
2,541 1,145 274 9.27 6.40 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,342 728 10 134.15 3.38 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
990 683 8 123.75 2.49 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
820 425 8 102.53 2.07 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
694 15 1,467 0.47 1.75 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
683 428 54,355 0.01 1.72 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
678 401 49,986 0.01 1.71 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
668 101 1,467 0.46 1.68 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
541 115 164,446 0.00 1.36 6gnth2mfbs2nq WSHFRREL declare v_ret number := 0...
518 423 68,777 0.01 1.30 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
488 266 8 60.96 1.23 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
446 313 5,000 0.09 1.12 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
417 234 876 0.48 1.05 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
400 276 8 49.94 1.01 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
399 66 16 24.95 1.01 944u2vd2tkmff ARGLTP select 'lock' from ra_cust_tr...

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
2,671 4,767 8 333.87 12.01 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
1,756 3,494 10 175.56 8.80 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,145 2,541 274 4.18 6.40 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
728 1,342 10 72.76 3.38 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
683 990 8 85.42 2.49 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
428 683 54,355 0.01 1.72 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
425 820 8 53.10 2.07 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
423 518 68,777 0.01 1.30 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
401 678 49,986 0.01 1.71 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
326 358 154,329 0.00 0.90 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
313 446 5,000 0.06 1.12 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
276 400 8 34.47 1.01 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
266 488 8 33.21 1.23 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
234 417 876 0.27 1.05 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
115 541 164,446 0.00 1.36 6gnth2mfbs2nq WSHFRREL declare v_ret number := 0...
101 668 1,467 0.07 1.68 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
66 399 16 4.11 1.01 944u2vd2tkmff ARGLTP select 'lock' from ra_cust_tr...
15 694 1,467 0.01 1.75 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...

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,725,184,148
  • Captured SQL accounts for 34.2% of Total Buffer Gets
Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
232,512,615 8 29,064,076.88 13.48 2,670.98 4,766.80 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
168,668,036 10 16,866,803.60 9.78 1,755.60 3,493.76 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
115,418,764 8 14,427,345.50 6.69 424.77 820.24 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
107,928,555 49,986 2,159.18 6.26 401.17 678.39 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
106,783,458 8 13,347,932.25 6.19 683.39 989.96 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
81,427,352 10 8,142,735.20 4.72 727.64 1,341.54 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
61,129,282 154,329 396.10 3.54 326.29 357.58 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
46,688,601 274 170,396.35 2.71 1,144.92 2,540.79 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
45,938,345 8 5,742,293.13 2.66 275.77 399.51 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
45,499,601 8 5,687,450.13 2.64 172.73 316.06 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
40,489,998 54,355 744.92 2.35 427.52 683.28 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
36,445,096 63 578,493.59 2.11 129.73 214.57 3n8tvc1tsqua0 WSHINTERFACES SELECT DISTINCT WTS.STOP_ID FR...
35,711,013 5,000 7,142.20 2.07 312.62 445.65 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
35,003,498 164,410 212.90 2.03 283.25 366.44 gf1u933c95jb5 WSHFRREL DECLARE l_ret_stat varchar2...
35,001,792 164,431 212.87 2.03 300.09 384.75 3b3psftuyks81 WSHFRREL BEGIN INV_TXNSTUB_PUB.postTran...
34,793,181 984 35,358.92 2.02 151.37 226.15 0qcpgw43yqj5r WSHPSRS ( SELECT DISTINCT WDD.SOURCE_L...
32,599,425 8 4,074,928.13 1.89 188.17 263.16 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
27,116,417 1,868 14,516.28 1.57 157.77 268.49 4adc1zhg5cmx0 WSHINTERFACE UPDATE WSH_DELIVERY_DETAILS DD...
26,384,126 9,999 2,638.68 1.53 118.63 346.58 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
20,832,479 1,328,196 15.68 1.21 179.49 218.94 66tmsr3446uqn OEXOETEL SELECT WIAS.ACTIVITY_STATUS, ...
19,339,188 41,384 467.31 1.12 245.16 292.97 64z4pgdwwm6g2 WSHINTERFACE SELECT STOP_ID FROM WSH_TRIP_S...
18,118,125 8 2,264,765.63 1.05 265.71 487.68 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

  • Total Disk Reads: 873,799
  • Captured SQL accounts for 46.1% of Total Disk Reads
Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
147,360 1,467 100.45 16.86 15.37 693.76 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
110,456 1,467 75.29 12.64 101.37 667.97 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
54,465 9,999 5.45 6.23 118.63 346.58 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
53,615 2,496 21.48 6.14 9.47 269.27 72cqcsuq5wgh0 asn.dashboard.server.DashboardAM SELECT aslrt.meaning as rank_n...
18,348 10 1,834.80 2.10 1,755.60 3,493.76 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
13,937 246,158 0.06 1.59 73.28 132.77 ccprbqfuu8wb1 WSHINTERFACE SELECT NUMBER_VALUE FROM WF_IT...
13,805 13,201 1.05 1.58 80.14 248.22 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
9,554 1 9,554.00 1.09 30.25 38.01 gczkkgwgkyjh3 SQL*Plus select /*+ parallel(t, 8) para...
3,258 8 407.25 0.37 275.77 399.51 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
2,635 8 329.38 0.30 188.17 263.16 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

  • Total Executions: 75,015,278
  • Captured SQL accounts for 15.0% of Total Executions
Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
1,508,441 1,508,415 1.00 0.00 0.00 9dvfguzd15kpv JDBC Thin Client SELECT VALUE FROM V$NLS_PARAME...
1,328,196 688,762 0.52 0.00 0.00 66tmsr3446uqn OEXOETEL SELECT WIAS.ACTIVITY_STATUS, ...
812,250 812,250 1.00 0.00 0.00 cgb6kp2umq52a   select t.schema, t.name, t.f...
811,991 811,991 1.00 0.00 0.00 8bsm049u7thjd   select min(next_date) from "AP...
759,481 759,069 1.00 0.00 0.00 cd9mbmqyf4qhp OEXOETEL UPDATE WF_ITEM_ACTIVITY_STATUS...
707,497 706,859 1.00 0.00 0.00 gnhmcahkmrnzs OEXOETEL INSERT INTO WF_ITEM_ACTIVITY_S...
418,905 418,909 1.00 0.00 0.00 821fx90awyvj7 OEXOETEL SELECT ACCOUNTING_RULE_ID , A...
369,578 369,540 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
246,158 245,454 1.00 0.00 0.00 ccprbqfuu8wb1 WSHINTERFACE SELECT NUMBER_VALUE FROM WF_IT...
234,014 183,481 0.78 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

  • Total Parse Calls: 7,808,828
  • Captured SQL accounts for 57.6% of Total Parse Calls
Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
812,250 812,250 10.40 cgb6kp2umq52a   select t.schema, t.name, t.f...
811,991 1,280 10.40 20rc3cmapyvnz   select q_name, state, delay,...
811,991 811,991 10.40 8bsm049u7thjd   select min(next_date) from "AP...
369,591 369,578 4.73 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
234,040 234,014 3.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
164,396 164,446 2.11 6gnth2mfbs2nq WSHFRREL declare v_ret number := 0...
110,115 110,129 1.41 1c0b7sas42w2z WSHFRREL SELECT NVL(ITEM_COST, 0), ...
85,123 85,133 1.09 76sw2a4vnc89j ARXTWMAI begin FND_FLEX_WORKFLOW_APIS.S...
81,447 81,476 1.04 bf7uwg5pa3pj6 ARXTWMAI begin FND_FLEX_WORKFLOW_APIS.V...
81,446 81,498 1.04 608c0n36kaw62 ARXTWMAI begin FND_FLEX_WORKFLOW_APIS.C...
81,388 85,119 1.04 dcvv68fju01g4 ARXTWMAI begin FND_FLEX_WORKFLOW_APIS.E...

Back to SQL Statistics
Back to Top