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
VIS189702390VIS110.2.0.3.0NOoracle16.engr.sgi.com

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:114-Oct-07 14:45:184004 186.2
End Snap:214-Oct-07 15:46:034031 250.0
Elapsed:  60.75 (mins)  
DB Time:  860.71 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 8,000M 8,000MStd Block Size: 8K
Shared Pool Size: 3,008M 3,008MLog Buffer: 30,736K

Load Profile

Per SecondPer Transaction
Redo size: 8,191,858.91 30,409.63
Logical reads: 529,844.73 1,966.88
Block changes: 51,153.58 189.89
Physical reads: 382.32 1.42
Physical writes: 790.54 2.93
User calls: 9,026.13 33.51
Parses: 2,133.93 7.92
Hard parses: 2.20 0.01
Sorts: 2,441.03 9.06
Logons: 2.65 0.01
Executes: 23,373.85 86.77
Transactions: 269.38 

% Blocks changed per Read: 9.65Recursive Call %: 80.91
Rollback per transaction %: 19.57Rows per Sort: 11.04

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95Redo NoWait %: 100.00
Buffer Hit %: 99.95In-memory Sort %: 100.00
Library Hit %: 100.03Soft Parse %: 99.90
Execute to Parse %: 90.87Latch Hit %: 97.98
Parse CPU to Parse Elapsd %: 82.02% Non-Parse CPU: 98.29

Shared Pool Statistics

BeginEnd
Memory Usage %: 66.20 92.21
% SQL with executions>1: 76.08 84.69
% Memory for SQL w/exec>1: 74.00 59.43

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  46,860  90.7 
db file sequential read 747,948 2,449 3 4.7User I/O
log file sync 363,396 572 2 1.1Commit
log file parallel write 758,295 223 0 .4System I/O
enq: UL - contention 3,044 159 52 .3Application

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

  • Total time in database user-calls (DB Time): 51642.5s
  • 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 47,013.82 91.04
DB CPU 46,860.10 90.74
inbound PL/SQL rpc elapsed time 7,844.36 15.19
PL/SQL execution elapsed time 7,082.33 13.71
Java execution elapsed time 2,746.47 5.32
parse time elapsed 1,042.82 2.02
hard parse elapsed time 465.84 0.90
repeated bind elapsed time 101.56 0.20
sequence load elapsed time 31.13 0.06
connection management call elapsed time 30.17 0.06
PL/SQL compilation elapsed time 8.07 0.02
hard parse (sharing criteria) elapsed time 7.49 0.01
failed parse elapsed time 2.77 0.01
hard parse (bind mismatch) elapsed time 1.33 0.00
DB time 51,642.49  
background elapsed time 947.54  
background cpu time 621.50  

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 956,621 0.00 2,651 3 0.97
Commit 363,396 0.00 572 2 0.37
Concurrency 1,271,316 0.87 411 0 1.29
Application 66,228 0.13 353 5 0.07
System I/O 1,030,991 0.00 324 0 1.05
Network 38,172,264 0.00 191 0 38.88
Other 155,117 25.47 78 1 0.16
Configuration 22,825 0.00 11 1 0.02

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 747,948 0.00 2,449 3 0.76
log file sync 363,396 0.00 572 2 0.37
log file parallel write 758,295 0.00 223 0 0.77
enq: UL - contention 3,044 1.38 159 52 0.00
read by other session 182,625 0.00 158 1 0.19
cursor: pin S wait on X 11,595 95.18 118 10 0.01
db file parallel write 269,329 0.00 99 0 0.27
enq: TX - row lock contention 535 4.86 95 178 0.00
SQL*Net more data from client 1,917,085 0.00 75 0 1.95
latch: cache buffers chains 357,930 0.00 74 0 0.36
enq: TX - index contention 27,436 0.03 71 3 0.03
enq: KO - fast object checkpoint 42 42.86 70 1665 0.00
SQL*Net more data to client 1,666,010 0.00 69 0 1.70
buffer busy waits 825,277 0.00 67 0 0.84
SQL*Net message to client 34,589,169 0.00 47 0 35.23
db file scattered read 12,934 0.00 40 3 0.01
latch: undo global data 20,453 0.00 31 1 0.02
latch: library cache 13,130 0.00 29 2 0.01
SQL*Net break/reset to client 62,570 0.00 20 0 0.06
library cache load lock 683 0.00 19 28 0.00
latch: In memory undo latch 22,387 0.00 14 1 0.02
enq: HW - contention 10,649 0.00 7 1 0.01
latch: library cache pin 5,734 0.00 7 1 0.01
kksfbc child completion 184 66.85 6 33 0.00
enq: RO - fast object reuse 30 0.00 6 193 0.00
library cache lock 92 0.00 5 59 0.00
enq: TX - contention 9,642 0.00 5 1 0.01
latch: redo allocation 5,887 0.00 5 1 0.01
latch: cache buffers lru chain 3,343 0.00 4 1 0.00
LGWR wait for redo copy 29,402 0.21 4 0 0.03
enq: TM - contention 7 0.00 4 572 0.00
latch: session allocation 4,393 0.00 4 1 0.00
latch free 1,583 0.00 4 2 0.00
local write wait 3,636 0.00 3 1 0.00
enq: SQ - contention 11,892 0.00 3 0 0.01
latch: row cache objects 4,892 0.00 3 1 0.00
enq: DV - contention 160 0.00 3 16 0.00
PX Deq Credit: send blkd 1,500 0.00 2 1 0.00
buffer deadlock 39,786 97.65 2 0 0.04
enq: FB - contention 3,762 0.00 2 0 0.00
cursor: pin S 29,083 0.00 2 0 0.03
enq: US - contention 1,071 0.00 1 1 0.00
PX Deq: Signal ACK 98 38.78 1 13 0.00
latch: object queue header operation 2,439 0.00 1 1 0.00
os thread startup 13 0.00 1 93 0.00
control file parallel write 1,771 0.00 1 1 0.00
row cache lock 922 0.00 1 1 0.00
latch: library cache lock 445 0.00 1 2 0.00
log file switch completion 59 0.00 1 12 0.00
enq: TX - allocate ITL entry 202 0.00 1 3 0.00
control file sequential read 1,588 0.00 1 0 0.00
latch: shared pool 293 0.00 0 1 0.00
library cache pin 147 0.00 0 3 0.00
wait list latch free 173 0.00 0 2 0.00
latch: cache buffer handles 1,292 0.00 0 0 0.00
enq: CU - contention 8 0.00 0 16 0.00
direct path read 9,087 0.00 0 0 0.01
latch: enqueue hash chains 74 0.00 0 1 0.00
PX qref latch 461 93.28 0 0 0.00
reliable message 53 0.00 0 1 0.00
enq: TQ - TM contention 103 0.00 0 1 0.00
L1 validation 18 27.78 0 3 0.00
latch: checkpoint queue latch 23 0.00 0 2 0.00
enq: TQ - DDL contention 67 0.00 0 1 0.00
cursor: mutex S 217 0.00 0 0 0.00
latch: redo writing 17 0.00 0 2 0.00
db file parallel read 1 0.00 0 15 0.00
write complete waits 6 0.00 0 2 0.00
cursor: pin X 1 100.00 0 10 0.00
latch: messages 33 0.00 0 0 0.00
cursor: mutex X 123 0.00 0 0 0.00
log file sequential read 4 0.00 0 2 0.00
enq: PS - contention 14 0.00 0 0 0.00
latch: object queue header heap 8 0.00 0 0 0.00
direct path write 356 0.00 0 0 0.00
direct path write temp 28 0.00 0 0 0.00
log file single write 4 0.00 0 0 0.00
latch: parallel query alloc buffer 3 0.00 0 0 0.00
direct path read temp 6 0.00 0 0 0.00
SQL*Net message from client 34,589,166 0.00 8,469,223 245 35.23
pipe get 29,671 52.75 47,159 1589 0.03
Streams AQ: waiting for messages in the queue 7,257 99.99 35,411 4880 0.01
Streams AQ: waiting for time management or cleanup tasks 290 7.59 3,613 12459 0.00
jobq slave wait 1,216 95.31 3,557 2925 0.00
Streams AQ: qmn slave idle wait 130 0.00 3,529 27149 0.00
Streams AQ: qmn coordinator idle wait 260 50.00 3,529 13574 0.00
PL/SQL lock timer 310 100.00 3,333 10752 0.00
PX Idle Wait 1,418 90.83 2,600 1834 0.00
PX Deq: Execution Msg 1,760 0.23 37 21 0.00
PX Deq: Execute Reply 4,074 0.00 10 2 0.00
PX Deq: Parse Reply 97 0.00 2 17 0.00
PX Deq Credit: need buffer 1,617 0.00 1 1 0.00
PX Deq: Msg Fragment 1,600 0.00 1 0 0.00
PX Deq: Table Q Normal 2,123 0.00 0 0 0.00
PX Deq: Join ACK 88 0.00 0 1 0.00
class slave wait 1 0.00 0 2 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 758,297 0.00 223 0 0.77
db file parallel write 269,329 0.00 99 0 0.27
events in waitclass Other 32,780 0.19 6 0 0.03
db file scattered read 1,007 0.00 6 6 0.00
db file sequential read 499 0.00 1 3 0.00
control file parallel write 1,771 0.00 1 1 0.00
os thread startup 5 0.00 0 98 0.00
control file sequential read 854 0.00 0 0 0.00
direct path read 720 0.00 0 0 0.00
latch: redo writing 17 0.00 0 2 0.00
log file sequential read 4 0.00 0 2 0.00
latch: cache buffers chains 4 0.00 0 1 0.00
log file sync 1 0.00 0 2 0.00
direct path write 220 0.00 0 0 0.00
log file single write 4 0.00 0 0 0.00
buffer busy waits 6 0.00 0 0 0.00
latch: shared pool 2 0.00 0 0 0.00
rdbms ipc message 757,860 1.40 30,077 40 0.77
Streams AQ: waiting for time management or cleanup tasks 290 7.59 3,613 12459 0.00
Streams AQ: qmn slave idle wait 130 0.00 3,529 27149 0.00
Streams AQ: qmn coordinator idle wait 260 50.00 3,529 13574 0.00
pmon timer 2,265 96.91 3,529 1558 0.00
smon timer 124,093 0.00 3,529 28 0.13

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 53,015,356
IDLE_TIME 66,397,602
IOWAIT_TIME 1,591,224
NICE_TIME 0
SYS_TIME 3,430,755
USER_TIME 47,395,734
LOAD 13
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 453,792
NUM_CPUS 32
NUM_CPU_SOCKETS 16

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 51,486.70 46,728.10 1,291,416 1,923,946,534
SYS$USERS 163.80 142.60 80,915 7,368,392
SYS$BACKGROUND 0.00 0.00 20,763 418,061

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 930889 262455 1270748 41032 0 0 38149758 19085
SYS$USERS 23262 1871 538 4 0 0 139 0
SYS$BACKGROUND 2470 725 17 50 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
5,296 5,296 8 662.00 10.26 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
5,028 4,907 199,122 0.03 9.74 60t2tt1564j0k   SELECT SUBSTRB(MACHINE, 1, 60)...
3,015 2,886 5,120 0.59 5.84 fkxdmd0h7xg54 OEXOETEL select item, item_id, item_d...
2,740 2,619 78,823 0.03 5.31 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,171 2,104 279 7.78 4.20 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,955 1,923 14 139.66 3.79 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,778 1,757 10 177.77 3.44 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,679 1,629 51,441 0.03 3.25 3prk3vg9u0abb JDBC Thin Client BEGIN FND_GLOBAL.APPS_INITIA...
1,459 1,367 155,133 0.01 2.82 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
1,133 1,111 16 70.82 2.19 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
1,069 1,031 50,000 0.02 2.07 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
890 869 27,997 0.03 1.72 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
847 845 6 141.14 1.64 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
841 786 16 52.57 1.63 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
746 743 16 46.62 1.44 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
745 677 144,239 0.01 1.44 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
686 44 1,702 0.40 1.33 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
639 620 849 0.75 1.24 3cb7xm8ykx1qh icx.por.req.server.RequisitionAM begin :1 := POR_UTIL_PKG.subm...
624 620 10 62.39 1.21 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
602 596 55,082 0.01 1.16 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
600 185 1,702 0.35 1.16 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
592 588 166,876 0.00 1.15 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
577 573 166,874 0.00 1.12 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
570 529 182,112 0.00 1.10 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
554 541 15,184 0.04 1.07 8h16w67202y4g   begin fnd_global.initialize(:s...
546 545 8 68.26 1.06 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
536 507 61,410 0.01 1.04 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...

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
5,296 5,296 8 661.95 10.26 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
4,907 5,028 199,122 0.02 9.74 60t2tt1564j0k   SELECT SUBSTRB(MACHINE, 1, 60)...
2,886 3,015 5,120 0.56 5.84 fkxdmd0h7xg54 OEXOETEL select item, item_id, item_d...
2,619 2,740 78,823 0.03 5.31 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,104 2,171 279 7.54 4.20 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,923 1,955 14 137.34 3.79 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,757 1,778 10 175.72 3.44 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,629 1,679 51,441 0.03 3.25 3prk3vg9u0abb JDBC Thin Client BEGIN FND_GLOBAL.APPS_INITIA...
1,367 1,459 155,133 0.01 2.82 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
1,111 1,133 16 69.46 2.19 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
1,031 1,069 50,000 0.02 2.07 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
869 890 27,997 0.03 1.72 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
845 847 6 140.76 1.64 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
786 841 16 49.15 1.63 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
743 746 16 46.45 1.44 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
677 745 144,239 0.00 1.44 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
620 639 849 0.73 1.24 3cb7xm8ykx1qh icx.por.req.server.RequisitionAM begin :1 := POR_UTIL_PKG.subm...
620 624 10 61.98 1.21 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
596 602 55,082 0.01 1.16 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
588 592 166,876 0.00 1.15 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
573 577 166,874 0.00 1.12 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
545 546 8 68.07 1.06 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
541 554 15,184 0.04 1.07 8h16w67202y4g   begin fnd_global.initialize(:s...
529 570 182,112 0.00 1.10 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
507 536 61,410 0.01 1.04 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
185 600 1,702 0.11 1.16 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
44 686 1,702 0.03 1.33 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,931,300,454
  • Captured SQL account for 30.9% of Total
Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
252,773,571 8 31,596,696.38 13.09 5295.58 5295.98 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
127,939,617 14 9,138,544.07 6.62 1922.71 1955.24 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
102,720,701 155,133 662.15 5.32 1367.47 1458.69 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
94,151,320 6 15,691,886.67 4.88 844.53 846.85 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
92,214,948 16 5,763,434.25 4.77 1111.30 1133.19 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
88,953,484 50,000 1,779.07 4.61 1030.87 1068.54 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
78,161,856 10 7,816,185.60 4.05 1757.21 1777.65 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
74,086,819 16 4,630,426.19 3.84 743.14 745.97 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
66,108,035 144,239 458.32 3.42 676.66 744.79 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
65,230,154 182,112 358.19 3.38 528.88 570.03 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
54,443,358 10 5,444,335.80 2.82 619.79 623.95 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
52,826,333 16 3,301,645.81 2.74 786.34 841.19 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
46,484,160 279 166,609.89 2.41 2104.34 2171.36 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
44,921,906 1,451,009 30.96 2.33 448.01 450.75 66tmsr3446uqn   SELECT WIAS.ACTIVITY_STATUS, ...
43,738,755 5,000 8,747.75 2.26 444.33 448.31 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
37,705,669 166,874 225.95 1.95 573.41 577.47 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
37,705,012 166,876 225.95 1.95 588.14 592.46 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
34,066,157 55,082 618.46 1.76 596.48 601.61 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
30,975,847 849 36,485.10 1.60 620.08 638.80 3cb7xm8ykx1qh icx.por.req.server.RequisitionAM begin :1 := POR_UTIL_PKG.subm...
25,863,383 61,410 421.16 1.34 507.46 536.14 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
21,830,602 342,878 63.67 1.13 200.88 201.42 91hakq9n36htp   SELECT TEXT_VALUE FROM WF_ITEM...
20,822,914 55,130 377.71 1.08 495.81 508.45 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
19,860,480 5,120 3,879.00 1.03 2885.96 3015.41 fkxdmd0h7xg54 OEXOETEL select item, item_id, item_d...
19,722,336 8 2,465,292.00 1.02 544.58 546.05 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

  • Total Disk Reads: 1,393,573
  • Captured SQL account for 46.1% of Total
Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
209,763 8 26,220.38 15.05 11.60 46.65 4099q0gjjdwah RAXMTR select /*+ parallel(t, 8) para...
171,917 1,702 101.01 12.34 44.42 685.62 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
129,968 1,702 76.36 9.33 185.10 600.24 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
104,907 8 13,113.38 7.53 9.60 30.29 g6yx4z6m66xtq RAXMTR select /*+ parallel(t, 8) para...
12,841 10 1,284.10 0.92 1757.21 1777.65 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
11,568 144,239