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
VIS127695557VIS110.2.0.2.0NOel9-94-48

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:5408-Apr-07 20:26:463906 188.9
End Snap:5508-Apr-07 21:28:063927 242.1
Elapsed:  61.34 (mins)  
DB Time:  435.49 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 8,192M 8,192MStd Block Size: 8K
Shared Pool Size: 3,072M 3,072MLog Buffer: 30,724K

Load Profile

Per SecondPer Transaction
Redo size: 8,334,521.39 31,281.65
Logical reads: 543,610.22 2,040.31
Block changes: 51,600.53 193.67
Physical reads: 211.02 0.79
Physical writes: 677.24 2.54
User calls: 10,167.60 38.16
Parses: 1,793.08 6.73
Hard parses: 2.48 0.01
Sorts: 2,456.03 9.22
Logons: 2.11 0.01
Executes: 21,935.02 82.33
Transactions: 266.43 

% Blocks changed per Read: 9.49Recursive Call %: 78.02
Rollback per transaction %: 19.69Rows per Sort: 15.32

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95Redo NoWait %: 100.00
Buffer Hit %: 99.96In-memory Sort %: 100.00
Library Hit %: 99.96Soft Parse %: 99.86
Execute to Parse %: 91.83Latch Hit %: 98.48
Parse CPU to Parse Elapsd %: 55.63% Non-Parse CPU: 97.28

Shared Pool Statistics

BeginEnd
Memory Usage %: 57.03 81.88
% SQL with executions>1: 79.61 79.89
% Memory for SQL w/exec>1: 72.42 58.21

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  16,457  63.0 
db file sequential read 671,050 2,537 4 9.7User I/O
log file sync 371,284 464 1 1.8Commit
log file parallel write 711,924 285 0 1.1System I/O
enq: UL - contention 4,948 248 50 .9Application

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

  • Total time in database user-calls (DB Time): 26129.4s
  • 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 23,234.58 88.92
DB CPU 16,456.81 62.98
inbound PL/SQL rpc elapsed time 4,379.84 16.76
PL/SQL execution elapsed time 4,344.20 16.63
parse time elapsed 845.21 3.23
Java execution elapsed time 535.46 2.05
hard parse elapsed time 523.48 2.00
repeated bind elapsed time 42.61 0.16
sequence load elapsed time 13.24 0.05
connection management call elapsed time 7.47 0.03
PL/SQL compilation elapsed time 7.04 0.03
hard parse (sharing criteria) elapsed time 3.73 0.01
hard parse (bind mismatch) elapsed time 1.28 0.00
failed parse elapsed time 1.13 0.00
DB time 26,129.35  
background elapsed time 618.88  
background cpu time 155.78  

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 864,581 0.00 2,731 3 0.88
Commit 371,284 0.00 464 1 0.38
System I/O 946,456 0.00 409 0 0.97
Concurrency 918,872 0.97 406 0 0.94
Application 57,353 0.06 276 5 0.06
Other 206,965 54.38 126 1 0.21
Network 42,551,713 0.00 112 0 43.40
Configuration 7,763 0.00 4 0 0.01
Administrative 6 0.00 0 15 0.00

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 671,050 0.00 2,537 4 0.68
log file sync 371,284 0.00 464 1 0.38
log file parallel write 711,924 0.00 285 0 0.73
enq: UL - contention 4,948 0.71 248 50 0.01
read by other session 182,759 0.00 167 1 0.19
db file parallel write 230,959 0.00 122 1 0.24
latch: undo global data 23,022 0.00 97 4 0.02
cursor: pin S wait on X 9,101 97.60 88 10 0.01
buffer busy waits 747,533 0.00 88 0 0.76
latch: cache buffers chains 112,185 0.00 83 1 0.11
SQL*Net more data from client 1,985,109 0.00 79 0 2.02
latch: In memory undo latch 18,047 0.00 71 4 0.02
enq: TX - index contention 26,928 0.00 39 1 0.03
library cache load lock 1,028 0.00 27 26 0.00
db file scattered read 6,938 0.00 24 3 0.01
SQL*Net more data to client 1,666,292 0.00 17 0 1.70
SQL*Net message to client 38,900,312 0.00 16 0 39.67
enq: TX - row lock contention 890 0.00 15 17 0.00
SQL*Net break/reset to client 51,356 0.00 11 0 0.05
kksfbc child completion 168 85.12 7 42 0.00
latch: library cache 1,609 0.00 6 4 0.00
PX Deq Credit: send blkd 8,113 0.00 4 0 0.01
enq: DV - contention 255 0.00 4 14 0.00
LGWR wait for redo copy 39,361 0.17 3 0 0.04
local write wait 2,643 0.00 3 1 0.00
latch: redo allocation 1,436 0.00 3 2 0.00
enq: RO - fast object reuse 157 0.00 3 17 0.00
latch: library cache pin 622 0.00 2 4 0.00
PX Deq: Signal ACK 124 36.29 2 15 0.00
enq: TX - contention 3,255 0.00 2 1 0.00
enq: SQ - contention 3,872 0.00 1 0 0.00
control file parallel write 1,790 0.00 1 1 0.00
enq: HW - contention 3,159 0.00 1 0 0.00
library cache lock 53 0.00 1 21 0.00
latch free 1,317 0.00 1 1 0.00
latch: cache buffers lru chain 288 0.00 1 2 0.00
enq: TX - allocate ITL entry 704 0.00 1 1 0.00
control file sequential read 1,775 0.00 1 0 0.00
latch: session allocation 169 0.00 0 3 0.00
row cache lock 1,152 0.00 0 0 0.00
latch: cache buffer handles 148 0.00 0 3 0.00
os thread startup 18 0.00 0 20 0.00
enq: FB - contention 1,640 0.00 0 0 0.00
buffer deadlock 20,217 99.52 0 0 0.02
enq: TM - contention 2 0.00 0 144 0.00
enq: CU - contention 20 0.00 0 14 0.00
wait list latch free 24 0.00 0 11 0.00
log file switch (private strand flush incomplete) 17 0.00 0 14 0.00
cursor: pin S 13,498 0.00 0 0 0.01
library cache pin 92 0.00 0 1 0.00
rdbms ipc reply 1,400 0.00 0 0 0.00
latch: row cache objects 79 0.00 0 1 0.00
switch logfile command 6 0.00 0 15 0.00
PX qref latch 92,223 99.94 0 0 0.09
latch: object queue header operation 59 0.00 0 1 0.00
reliable message 145 0.00 0 0 0.00
latch: enqueue hash chains 23 0.00 0 2 0.00
direct path read 420 0.00 0 0 0.00
latch: shared pool 19 0.00 0 1 0.00
latch: redo writing 6 0.00 0 2 0.00
latch: library cache lock 33 0.00 0 0 0.00
cursor: pin X 1 100.00 0 10 0.00
L1 validation 1 100.00 0 10 0.00
latch: checkpoint queue latch 5 0.00 0 2 0.00
direct path read temp 6 0.00 0 1 0.00
log buffer space 5 0.00 0 1 0.00
db file parallel read 3 0.00 0 1 0.00
direct path write 675 0.00 0 0 0.00
direct path write temp 87 0.00 0 0 0.00
enq: CI - contention 17 0.00 0 0 0.00
enq: PS - contention 23 0.00 0 0 0.00
cursor: mutex S 271 0.00 0 0 0.00
cursor: mutex X 102 0.00 0 0 0.00
log file single write 4 0.00 0 0 0.00
log file sequential read 4 0.00 0 0 0.00
PX Deq: Table Q qref 12 0.00 0 0 0.00
latch: messages 1 0.00 0 0 0.00
SQL*Net message from client 38,900,269 0.00 8,201,444 211 39.67
Streams AQ: waiting for messages in the queue 3,659 100.00 17,852 4879 0.00
Streams AQ: qmn slave idle wait 1,146 0.00 7,177 6263 0.00
pipe get 14,990 10.42 7,175 479 0.02
PX Idle Wait 2,725 93.83 5,035 1848 0.00
Streams AQ: qmn coordinator idle wait 1,459 36.81 3,588 2459 0.00
Streams AQ: waiting for time management or cleanup tasks 2,189 49.70 3,551 1622 0.00
PL/SQL lock timer 199 99.50 2,667 13401 0.00
jobq slave wait 20 100.00 59 2930 0.00
PX Deq: Execution Msg 2,687 0.30 48 18 0.00
PX Deq: Execute Reply 1,624 0.00 9 5 0.00
PX Deq: Parse Reply 117 0.00 1 6 0.00
PX Deq Credit: need buffer 1,351 0.00 0 0 0.00
PX Deq: Msg Fragment 1,483 0.00 0 0 0.00
PX Deq: Table Q Normal 1,052 0.00 0 0 0.00
PX Deq: Join ACK 97 0.00 0 0 0.00
PX Deq: Table Q Sample 40 0.00 0 0 0.00
class slave wait 1 0.00 0 4 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 711,914 0.00 285 0 0.73
db file parallel write 230,848 0.00 122 1 0.24
db file scattered read 1,392 0.00 5 3 0.00
events in waitclass Other 40,701 0.16 4 0 0.04
db file sequential read 808 0.00 2 3 0.00
control file parallel write 1,790 0.00 1 1 0.00
control file sequential read 868 0.00 0 0 0.00
latch: cache buffers chains 42 0.00 0 4 0.00
os thread startup 2 0.00 0 31 0.00
direct path read 420 0.00 0 0 0.00
latch: redo writing 6 0.00 0 2 0.00
direct path write 220 0.00 0 0 0.00
log file sync 5 0.00 0 0 0.00
log file single write 4 0.00 0 0 0.00
log file sequential read 4 0.00 0 0 0.00
buffer busy waits 6 0.00 0 0 0.00
enq: HW - contention 1 0.00 0 0 0.00
rdbms ipc message 703,162 1.57 30,076 43 0.72
Streams AQ: qmn slave idle wait 1,146 0.00 7,177 6263 0.00
Streams AQ: qmn coordinator idle wait 1,459 36.81 3,588 2459 0.00
pmon timer 1,225 100.00 3,587 2928 0.00
smon timer 59,545 0.00 3,567 60 0.06
Streams AQ: waiting for time management or cleanup tasks 2,189 49.70 3,551 1622 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 150,948
AVG_IDLE_TIME 216,751
AVG_IOWAIT_TIME 11,444
AVG_SYS_TIME 15,602
AVG_USER_TIME 135,228
BUSY_TIME 2,417,059
IDLE_TIME 3,469,860
IOWAIT_TIME 185,086
SYS_TIME 251,498
USER_TIME 2,165,561
LOAD 0
OS_CPU_WAIT_TIME 2,617,000
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES ###############
NUM_CPUS 16
NUM_CPU_CORES 8

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 20,257.50 12,839.10 331,128 1,828,603,692
VIS 5,872.60 3,618.70 433,513 167,455,744
SYS$BACKGROUND 0.00 0.00 12,091 4,524,724

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 436251 84053 912130 40117 0 0 17626744 9622
VIS 425486 188304 6691 456 0 0 24912547 1578
SYS$BACKGROUND 2844 709 50 23 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
2,240 1,470 8 280.00 8.57 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
1,495 984 10 149.53 5.72 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,449 500 279 5.19 5.55 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
776 305 16 48.51 2.97 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
714 457 10 71.40 2.73 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
681 527 17,121 0.04 2.61 0vfguqskjkcc4 OEXOETEL SELECT RLTD.RELATED_LINE_INDEX...
629 14 1,710 0.37 2.41 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
613 292 49,998 0.01 2.34 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
606 449 6 100.94 2.32 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
476 77 1,710 0.28 1.82 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
445 369 144,834 0.00 1.70 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
415 188 16 25.92 1.59 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
384 347 55,156 0.01 1.47 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
382 338 155,089 0.00 1.46 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
358 309 182,356 0.00 1.37 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
351 315 79,554 0.00 1.34 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
289 215 5,000 0.06 1.10 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
285 213 1,037 0.27 1.09 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
271 178 8 33.86 1.04 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
268 229 167,045 0.00 1.03 3b3psftuyks81 WSHFRREL BEGIN INV_TXNSTUB_PUB.postTran...

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,470 2,240 8 183.74 8.57 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
984 1,495 10 98.37 5.72 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
527 681 17,121 0.03 2.61 0vfguqskjkcc4 OEXOETEL SELECT RLTD.RELATED_LINE_INDEX...
500 1,449 279 1.79 5.55 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
457 714 10 45.71 2.73 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
449 606 6 74.85 2.32 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
369 445 144,834 0.00 1.70 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
347 384 55,156 0.01 1.47 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
338 382 155,089 0.00 1.46 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
315 351 79,554 0.00 1.34 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
309 358 182,356 0.00 1.37 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
305 776 16 19.04 2.97 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
292 613 49,998 0.01 2.34 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
229 268 167,045 0.00 1.03 3b3psftuyks81 WSHFRREL BEGIN INV_TXNSTUB_PUB.postTran...
215 289 5,000 0.04 1.10 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
213 285 1,037 0.21 1.09 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
188 415 16 11.75 1.59 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
178 271 8 22.20 1.04 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
77 476 1,710 0.05 1.82 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
14 629 1,710 0.01 2.41 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: 2,000,631,839
  • Captured SQL account for 35.3% of Total
Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
241,527,619 8 30,190,952.38 12.07 1469.94 2240.02 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
152,919,115 10 15,291,911.50 7.64 983.65 1495.31 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
120,895,535 16 7,555,970.94 6.04 304.56 776.11 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
109,864,773 49,998 2,197.38 5.49 292.42 612.55 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
94,495,472 6 15,749,245.33 4.72 449.12 605.63 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
84,872,488 10 8,487,248.80 4.24 457.14 714.03 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
75,065,753 155,089 484.02 3.75 337.66 381.55 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
74,970,433 16 4,685,652.06 3.75 187.96 414.64 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
61,690,363 279 221,112.41 3.08 499.55 1449.34 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
59,628,982 144,834 411.71 2.98 369.11 445.13 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
58,206,977 182,356 319.19 2.91 309.42 357.94 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
55,902,466 17,121 3,265.14 2.79 526.75 681.17 0vfguqskjkcc4 OEXOETEL SELECT RLTD.RELATED_LINE_INDEX...
46,086,818 55,156 835.57 2.30 347.50 383.68 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
44,685,569 63 709,294.75 2.23 124.60 188.02 3n8tvc1tsqua0 WSHINTERFACES SELECT DISTINCT WTS.STOP_ID FR...
42,866,231 11 3,896,930.09 2.14 212.84 245.44 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
38,765,300 12,065 3,213.04 1.94 101.69 184.86 by2f4fw8tac6r ARXTWMAI UPDATE RA_CUST_TRX_LINE_GL_DIS...
38,549,488 16 2,409,343.00 1.93 94.43 230.12 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
36,262,607 5,000 7,252.52 1.81 215.12 288.61 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
35,788,988 167,065 214.22 1.79 218.72 255.28 gf1u933c95jb5 WSHFRREL DECLARE l_ret_stat varchar2...
35,779,614 167,045 214.19 1.79 229.38 268.11 3b3psftuyks81 WSHFRREL BEGIN INV_TXNSTUB_PUB.postTran...
34,791,044 984 35,356.75 1.74 106.14 160.01 0qcpgw43yqj5r WSHPSRS ( SELECT DISTINCT WDD.SOURCE_L...
30,352,128 11 2,759,284.36 1.52 139.50 166.07 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
29,105,378 96 303,181.02 1.45 93.79 225.49 37f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
26,369,102 9,998 2,637.44 1.32 78.99 248.36 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
24,082,968 1,406,503 17.12 1.20 117.12 119.38 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

  • Total Disk Reads: 776,593
  • Captured SQL account for 48.8% of Total
Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
147,777 1,710 86.42 19.03 14.38 628.78 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
97,222 1,710 56.85 12.52 76.99 475.97 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
54,443 9,998 5.45 7.01 78.99 248.36 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
48,677 2,915 16.70 6.27 10.08 228.37 72cqcsuq5wgh0 asn.dashboard.server.DashboardAM SELECT aslrt.meaning as rank_n...
19,699 15,448 1.28 2.54 103.13 202.56 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
12,262 182,356 0.07 1.58 309.42 357.94 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
10,384 144,834 0.07 1.34 369.11 445.13 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
9,554 1 9,554.00 1.23 19.56 24.03 fzbs29z0uccds SQL*Plus select /*+ parallel(t, 8) para...
4,637 9,998 0.46 0.60 88.66 169.66 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
2,775 10 277.50 0.36 457.14 714.03 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

  • Total Executions: 80,726,776
  • Captured SQL account for 9.1% of Total
Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
1,406,503 728,143 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
801,161 801,106 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
429,916 429,864 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
322,677 263,424 0.82 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
232,468 229,875 0.99 0.00</