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:5422-May-06 12:19:492664 179.0
End Snap:5522-May-06 13:21:552693 233.3
Elapsed:  62.10 (mins)  
DB Time:  589.07 (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: 7,759,280.29 37,014.48
Logical reads: 476,323.34 2,272.23
Block changes: 47,706.99 227.58
Physical reads: 230.26 1.10
Physical writes: 685.99 3.27
User calls: 6,595.47 31.46
Parses: 1,739.46 8.30
Hard parses: 1.78 0.01
Sorts: 2,331.00 11.12
Logons: 1.47 0.01
Executes: 17,747.41 84.66
Transactions: 209.63 

% Blocks changed per Read: 10.02Recursive Call %: 82.03
Rollback per transaction %: 17.11Rows per Sort: 22.23

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.96Redo NoWait %: 100.00
Buffer Hit %: 99.96In-memory Sort %: 100.00
Library Hit %: 99.99Soft Parse %: 99.90
Execute to Parse %: 90.20Latch Hit %: 98.37
Parse CPU to Parse Elapsd %: 54.05% Non-Parse CPU: 97.75

Shared Pool Statistics

BeginEnd
Memory Usage %: 57.00 76.82
% SQL with executions>1: 70.09 83.18
% Memory for SQL w/exec>1: 77.25 64.59

Top 5 Timed Events

EventWaitsTime(s)Percent Total DB TimeWait Class
CPU time  20,727 58.64 
db file sequential read 649,344 2,619 7.41User I/O
latch: cache buffers chains 92,795 939 2.66Concurrency
log file parallel write 1,130,141 724 2.05System I/O
log file sync 261,302 666 1.88Commit

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 649,344 0 2,619 4 0.83
latch: cache buffers chains 92,795 92,795 939 10 0.12
log file parallel write 1,130,141 0 724 1 1.45
log file sync 261,302 0 666 3 0.33
enq: UL - contention 3,511 33 390 111 0.00
enq: TX - row lock contention 688 116 365 531 0.00
db file parallel write 198,983 0 300 2 0.25
read by other session 92,073 0 129 1 0.12
buffer busy waits 566,150 3 97 0 0.72
library cache pin 4,105 0 83 20 0.01
SQL*Net more data from client 1,333,912 0 67 0 1.71
db file scattered read 19,471 0 53 3 0.02
enq: TX - index contention 14,305 0 52 4 0.02
rdbms ipc reply 18,949 5 38 2 0.02
library cache load lock 928 0 32 34 0.00
latch: undo global data 4,153 0 29 7 0.01
latch: In memory undo latch 4,002 0 29 7 0.01
SQL*Net more data to client 1,313,890 0 23 0 1.68
SQL*Net message to client 25,594,967 0 17 0 32.77
direct path read temp 9,852 0 16 2 0.01
latch free 1,214 1,175 13 11 0.00
SQL*Net break/reset to client 39,644 0 11 0 0.05
control file parallel write 1,654 0 6 4 0.00
local write wait 885 0 5 6 0.00
latch: library cache 3,070 0 5 2 0.00
direct path write temp 3,200 0 5 1 0.00
enq: HW - contention 2,889 0 4 1 0.00
enq: RO - fast object reuse 36 0 4 111 0.00
control file sequential read 928 0 4 4 0.00
library cache lock 102 0 4 36 0.00
LGWR wait for redo copy 34,201 12 4 0 0.04
PX Deq Credit: send blkd 3,954 0 3 1 0.01
enq: DV - contention 181 0 3 16 0.00
enq: TX - contention 2,806 0 3 1 0.00
enq: TM - contention 3 0 3 838 0.00
enq: SQ - contention 4,588 0 2 0 0.01
enq: CI - contention 741 0 1 2 0.00
latch: library cache pin 460 0 1 2 0.00
PX Deq: Signal ACK 94 31 1 12 0.00
row cache lock 1,213 0 1 1 0.00
latch: redo allocation 279 0 1 3 0.00
control file single write 135 0 1 6 0.00
process startup 17 0 0 26 0.00
enq: CU - contention 33 0 0 11 0.00
log file switch completion 23 0 0 13 0.00
PX qref latch 14 14 0 15 0.00
enq: TX - allocate ITL entry 303 0 0 1 0.00
enq: FB - contention 1,103 0 0 0 0.00
latch: cache buffers lru chain 62 0 0 3 0.00
latch: row cache objects 36 0 0 4 0.00
latch: cache buffer handles 50 0 0 2 0.00
direct path read 420 0 0 0 0.00
undo segment extension 11,451 11,418 0 0 0.01
latch: session allocation 33 0 0 1 0.00
buffer deadlock 5,931 5,913 0 0 0.01
latch: library cache lock 16 0 0 2 0.00
direct path write 2,238 0 0 0 0.00
latch: object queue header operation 11 0 0 2 0.00
enq: PS - contention 14 0 0 1 0.00
db file parallel read 2 0 0 8 0.00
latch: shared pool 14 0 0 1 0.00
latch: redo writing 6 0 0 1 0.00
log file sequential read 2 0 0 3 0.00
log file single write 2 0 0 0 0.00
latch: checkpoint queue latch 1 0 0 0 0.00
latch: enqueue hash chains 1 0 0 0 0.00
PX Deq: Table Q qref 1 0 0 0 0.00
SQL*Net message from client 25,594,986 0 5,644,352 221 32.77
queue messages 6,628 6,153 41,515 6,264 0.01
pipe get 14,325 5,365 21,821 1,523 0.02
PL/SQL lock timer 699 699 7,871 11,260 0.00
PX Idle Wait 2,566 2,427 4,774 1,861 0.00
Queue Monitor Wait 124 124 3,626 29,245 0.00
wakeup time manager 1,262 671 3,085 2,444 0.00
PX Deq: Execution Msg 5,152 16 68 13 0.01
jobq slave wait 22 21 63 2,886 0.00
PX Deq: Execute Reply 3,867 1 13 3 0.00
PX Deq: Msg Fragment 931 0 1 1 0.00
PX Deq: Table Q Normal 1,745 0 1 0 0.00
PX Deq Credit: need buffer 579 0 0 1 0.00
PX Deq: Parse Reply 90 0 0 2 0.00
PX Deq: Table Q Sample 37 0 0 2 0.00
PX Deq: Join ACK 97 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,130,091 0 724 1 1.45
db file parallel write 198,983 0 300 2 0.25
control file parallel write 1,655 0 6 4 0.00
db file scattered read 2,130 0 6 3 0.00
control file sequential read 700 0 4 5 0.00
LGWR wait for redo copy 34,201 12 4 0 0.04
rdbms ipc reply 7,857 0 1 0 0.01
db file sequential read 813 0 1 1 0.00
latch: cache buffers chains 97 97 1 11 0.00
control file single write 135 0 1 6 0.00
latch free 67 66 1 10 0.00
enq: CI - contention 24 0 0 12 0.00
latch: redo allocation 139 0 0 2 0.00
buffer busy waits 530 0 0 0 0.00
latch: library cache 124 0 0 1 0.00
direct path read 420 0 0 0 0.00
latch: cache buffers lru chain 28 0 0 2 0.00
direct path write 220 0 0 0 0.00
process startup 1 0 0 26 0.00
latch: library cache pin 7 0 0 2 0.00
latch: redo writing 6 0 0 1 0.00
log file sequential read 2 0 0 3 0.00
latch: undo global data 5 0 0 1 0.00
latch: session allocation 5 0 0 1 0.00
latch: shared pool 3 0 0 1 0.00
latch: library cache lock 1 0 0 2 0.00
latch: In memory undo latch 2 0 0 1 0.00
log file single write 2 0 0 0 0.00
undo segment extension 385 385 0 0 0.00
latch: object queue header operation 2 0 0 0 0.00
latch: checkpoint queue latch 1 0 0 0 0.00
rdbms ipc message 584,126 9,818 27,215 47 0.75
Queue Monitor Wait 124 124 3,626 29,245 0.00
smon timer 37,115 0 3,610 97 0.05
wakeup time manager 1,262 671 3,085 2,444 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 35,344.36 100.00
sql execute elapsed time 31,584.90 89.36
DB CPU 20,726.73 58.64
PL/SQL execution elapsed time 6,461.14 18.28
inbound PL/SQL rpc elapsed time 4,334.54 12.26
Java execution elapsed time 2,291.88 6.48
background elapsed time 1,735.81 4.91
parse time elapsed 825.85 2.34
hard parse elapsed time 554.07 1.57
background cpu time 473.68 1.34
sequence load elapsed time 17.91 0.05
connection management call elapsed time 9.87 0.03
PL/SQL compilation elapsed time 8.12 0.02
failed parse elapsed time 2.59 0.01
hard parse (bind mismatch) elapsed time 2.09 0.01
hard parse (sharing criteria) elapsed time 2.09 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 3,636,607
AVG_IDLE_TICKS 176,660
AVG_IN_BYTES 75,264
AVG_IOWAIT_TICKS 10,613
AVG_OUT_BYTES 896,768
AVG_SYS_TICKS 11,699
AVG_USER_TICKS 183,880
BUSY_TICKS 58,187,535
IDLE_TICKS 2,828,374
IN_BYTES 1,204,224
IOWAIT_TICKS 171,707
OS_CPU_WAIT_TIME 3,366,700
OUT_BYTES 14,348,288
RSRC_MGR_CPU_WAIT_TIME 0
SYS_TICKS 188,919
USER_TICKS 2,943,877

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 28,659.90 16,741.80 383,227 1,642,978,149
SYS$USERS 6,683.00 3,984.10 457,235 118,154,527
SYS$BACKGROUND 0.00 0.00 17,764 13,687,811

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 406,616 114,355 681,758 122,036 0 0 12,783,308 9,045
SYS$USERS 367,792 167,594 4,627 2,093 0 0 15,449,697 1,685
SYS$BACKGROUND 3,583 742 761 125 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,659 2,705 8 582.33 13.18 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
2,921 1,754 10 292.07 8.26 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
2,494 1,081 268 9.30 7.06 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,289 762 10 128.95 3.65 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,280 616 8 160.02 3.62 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
1,102 558 49,985 0.02 3.12 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
871 675 8 108.94 2.47 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
655 566 153,427 0.00 1.85 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
622 418 53,437 0.01 1.76 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
545 12 1,157 0.47 1.54 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
509 71 1,157 0.44 1.44 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
460 262 8 57.46 1.30 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
438 217 8 54.75 1.24 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
411 315 161,243 0.00 1.16 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
394 299 161,299 0.00 1.11 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
393 311 5,000 0.08 1.11 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
389 284 8 48.64 1.10 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
382 109 161,282 0.00 1.08 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
378 67 16 23.64 1.07 944u2vd2tkmff ARGLTP select 'lock' from ra_cust_tr...
373 317 53,964 0.01 1.06 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
358 168 8 44.81 1.01 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...

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,705 4,659 8 338.19 13.18 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
1,754 2,921 10 175.42 8.26 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,081 2,494 268 4.03 7.06 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
762 1,289 10 76.20 3.65 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
675 871 8 84.35 2.47 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
616 1,280 8 77.00 3.62 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
566 655 153,427 0.00 1.85 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
558 1,102 49,985 0.01 3.12 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
418 622 53,437 0.01 1.76 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
317 373 53,964 0.01 1.06 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
315 411 161,243 0.00 1.16 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
311 393 5,000 0.06 1.11 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
299 394 161,299 0.00 1.11 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
284 389 8 35.55 1.10 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
262 460 8 32.76 1.30 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
217 438 8 27.06 1.24 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
168 358 8 21.00 1.01 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
109 382 161,282 0.00 1.08 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
71 509 1,157 0.06 1.44 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
67 378 16 4.20 1.07 944u2vd2tkmff ARGLTP select 'lock' from ra_cust_tr...
12 545 1,157 0.01 1.54 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,774,851,745
  • Captured SQL accounts for 41.0% of Total Buffer Gets
Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
248,579,773 8 31,072,471.63 14.01 2,705.49 4,658.60 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
174,382,049 8 21,797,756.13 9.83 615.96 1,280.20 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
169,694,966 10 16,969,496.60 9.56 1,754.16 2,920.73 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
166,578,090 49,985 3,332.56 9.39 557.86 1,102.24 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
104,066,814 8 13,008,351.75 5.86 674.78 871.50 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
99,256,038 153,427 646.93 5.59 566.02 654.90 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
86,910,649 10 8,691,064.90 4.90 762.02 1,289.46 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
59,935,359 8 7,491,919.88 3.38 216.50 438.02 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
49,945,335 8 6,243,166.88 2.81 168.00 358.45 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
46,382,835 8 5,797,854.38 2.61 284.37 389.09 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
46,155,034 268 172,220.28 2.60 1,080.83 2,493.71 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
38,957,413 161,299 241.52 2.19 298.87 393.73 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
38,943,332 161,243 241.52 2.19 315.06 411.32 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
38,783,229 53,437 725.77 2.19 417.89 622.05 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
38,487,710 71 542,080.42 2.17 136.64 201.28 3n8tvc1tsqua0 WSHINTERFACES SELECT DISTINCT WTS.STOP_ID FR...
35,525,770 5,000 7,105.15 2.00 311.05 393.43 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
34,785,669 984 35,351.29 1.96 149.51 218.90 0qcpgw43yqj5r WSHPSRS ( SELECT DISTINCT WDD.SOURCE_L...
33,237,712 8 4,154,714.00 1.87 189.10 263.72 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
32,309,685 48 673,118.44 1.82 161.82 313.38 37f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
26,371,452 10,000 2,637.15 1.49 116.05 330.47 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
25,794,108 1,500 17,196.07 1.45 151.17 226.98 4adc1zhg5cmx0 WSHINTERFACE UPDATE WSH_DELIVERY_DETAILS DD...
20,057,413 1,241,282 16.16 1.13 162.83 196.50 66tmsr3446uqn   SELECT WIAS.ACTIVITY_STATUS, ...
18,416,701 40,805 451.33 1.04 244.73 273.46 64z4pgdwwm6g2 WSHINTERFACE SELECT STOP_ID FROM WSH_TRIP_S...
18,086,038 8 2,260,754.75 1.02 262.05 459.67 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

  • Total Disk Reads: 857,997
  • Captured SQL accounts for 41.1% of Total Disk Reads
Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
126,743 1,157 109.54 14.77 11.78 545.27 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
88,934 1,157 76.87 10.37 70.76 509.49 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
54,462 10,000 5.45 6.35 116.05 330.47 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
49,452 1,994 24.80 5.76 7.61 225.46 72cqcsuq5wgh0 asn.dashboard.server.DashboardAM SELECT aslrt.meaning as rank_n...
10,907 10 1,090.70 1.27 1,754.16 2,920.73 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
9,554 1 9,554.00 1.11 29.72 37.50 gczkkgwgkyjh3 SQL*Plus select /*+ parallel(t, 8) para...
9,122 204,964 0.04 1.06 52.53 102.37 ccprbqfuu8wb1 WSHINTERFACE SELECT NUMBER_VALUE FROM WF_IT...
3,415 8 426.88 0.40 284.37 389.09 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
2,854 8 356.75 0.33 189.10 263.72 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
2,386 16 149.13 0.28 67.25 378.29 944u2vd2tkmff ARGLTP select 'lock' from ra_cust_tr...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

  • Total Executions: 66,129,504
  • Captured SQL accounts for 13.2% of Total Executions
Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
1,241,282 644,472 0.52 0.00 0.00 66tmsr3446uqn   SELECT WIAS.ACTIVITY_STATUS, ...
712,987 712,347 1.00 0.00 0.00 cd9mbmqyf4qhp   UPDATE WF_ITEM_ACTIVITY_STATUS...
662,478 661,293 1.00 0.00 0.00 gnhmcahkmrnzs hxc.selfservice.timecard.server.TimecardAM INSERT INTO WF_ITEM_ACTIVITY_S...
646,521 646,521 1.00 0.00 0.00 cgb6kp2umq52a   select t.schema, t.name, t.f...
646,282 646,282 1.00 0.00 0.00 8bsm049u7thjd   select min(next_date) from "AP...
403,976 404,046 1.00 0.00 0.00 821fx90awyvj7 OEXOETEL SELECT ACCOUNTING_RULE_ID , A...
294,415 294,407 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
204,964 204,412 1.00 0.00 0.00 ccprbqfuu8wb1 WSHINTERFACE SELECT NUMBER_VALUE FROM WF_IT...
198,122 158,137 0.80 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
191,528 191,391 1.00 0.00 0.00 9bbak9qpg1c7x hxc.selfservice.timecard.server.TimecardAM INSERT INTO WF_ITEM_ATTRIBUTE_...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

  • Total Parse Calls: 6,481,472
  • Captured SQL accounts for 58.3% of Total Parse Calls
Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
646,521 646,521 9.97 cgb6kp2umq52a   select t.schema, t.name, t.f...
646,282 1,013