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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:114-Oct-07 12:08:045013 199.7
End Snap:214-Oct-07 13:09:035041 246.6
Elapsed:  60.99 (mins)  
DB Time:  1,021.50 (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,573,728.99 26,709.87
Logical reads: 583,772.42 1,818.64
Block changes: 53,880.37 167.85
Physical reads: 408.02 1.27
Physical writes: 829.84 2.59
User calls: 11,369.46 35.42
Parses: 2,563.73 7.99
Hard parses: 2.54 0.01
Sorts: 2,893.81 9.02
Logons: 3.13 0.01
Executes: 27,311.56 85.08
Transactions: 320.99 

% Blocks changed per Read: 9.23Recursive Call %: 79.68
Rollback per transaction %: 21.05Rows per Sort: 10.64

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95Redo NoWait %: 100.00
Buffer Hit %: 99.95In-memory Sort %: 100.00
Library Hit %: 100.05Soft Parse %: 99.90
Execute to Parse %: 90.61Latch Hit %: 98.19
Parse CPU to Parse Elapsd %: 85.17% Non-Parse CPU: 98.16

Shared Pool Statistics

BeginEnd
Memory Usage %: 75.01 97.80
% SQL with executions>1: 74.39 79.40
% Memory for SQL w/exec>1: 66.69 50.55

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  55,639  90.8 
db file sequential read 883,610 2,587 3 4.2User I/O
log file sync 463,185 805 2 1.3Commit
log file parallel write 860,185 271 0 .4System I/O
enq: HW - contention 64,681 209 3 .3Configuration

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

  • Total time in database user-calls (DB Time): 61289.9s
  • 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
DB CPU 55,639.49 90.78
sql execute elapsed time 55,155.19 89.99
inbound PL/SQL rpc elapsed time 10,319.46 16.84
PL/SQL execution elapsed time 8,683.82 14.17
Java execution elapsed time 2,867.44 4.68
parse time elapsed 1,279.70 2.09
hard parse elapsed time 594.97 0.97
repeated bind elapsed time 142.93 0.23
sequence load elapsed time 36.98 0.06
connection management call elapsed time 36.42 0.06
PL/SQL compilation elapsed time 9.04 0.01
hard parse (sharing criteria) elapsed time 3.93 0.01
failed parse elapsed time 3.61 0.01
hard parse (bind mismatch) elapsed time 1.28 0.00
DB time 61,289.92  
background elapsed time 1,079.91  
background cpu time 704.28  

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 1,082,755 0.00 2,792 3 0.92
Commit 463,185 0.00 805 2 0.39
Concurrency 1,327,157 0.75 426 0 1.13
System I/O 1,141,508 0.00 371 0 0.97
Application 79,990 0.09 315 4 0.07
Network 48,133,693 0.00 255 0 40.97
Configuration 83,406 0.00 218 3 0.07
Other 209,889 17.26 105 0 0.18

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 883,610 0.00 2,587 3 0.75
log file sync 463,185 0.00 805 2 0.39
log file parallel write 860,185 0.00 271 0 0.73
enq: HW - contention 64,681 0.00 209 3 0.06
read by other session 174,267 0.00 171 1 0.15
enq: UL - contention 3,173 1.32 166 52 0.00
SQL*Net more data from client 2,421,475 0.00 110 0 2.06
cursor: pin S wait on X 10,504 94.20 107 10 0.01
latch: cache buffers chains 335,062 0.00 106 0 0.29
db file parallel write 277,942 0.00 98 0 0.24
enq: TX - row lock contention 1,013 2.96 98 96 0.00
SQL*Net more data to client 1,964,465 0.00 84 0 1.67
buffer busy waits 876,203 0.00 77 0 0.75
SQL*Net message to client 43,747,753 0.00 61 0 37.24
latch: undo global data 47,282 0.00 52 1 0.04
enq: TX - index contention 30,749 0.00 38 1 0.03
latch: library cache 22,691 0.00 33 1 0.02
db file scattered read 11,859 0.00 30 3 0.01
SQL*Net break/reset to client 75,742 0.00 28 0 0.06
library cache load lock 806 0.00 20 25 0.00
latch: In memory undo latch 29,356 0.00 16 1 0.02
enq: KO - fast object checkpoint 26 7.69 16 609 0.00
latch: library cache pin 10,319 0.00 16 2 0.01
latch: redo allocation 8,697 0.00 8 1 0.01
latch: row cache objects 8,019 0.00 7 1 0.01
LGWR wait for redo copy 36,939 0.20 6 0 0.03
kksfbc child completion 141 81.56 6 41 0.00
enq: RO - fast object reuse 29 0.00 5 188 0.00
latch free 2,229 0.00 5 2 0.00
enq: SQ - contention 17,998 0.00 5 0 0.02
enq: TX - contention 7,705 0.00 5 1 0.01
latch: cache buffers lru chain 4,816 0.00 5 1 0.00
local write wait 3,909 0.00 4 1 0.00
latch: session allocation 6,250 0.00 4 1 0.01
buffer deadlock 36,456 98.27 3 0 0.03
enq: TM - contention 7 0.00 2 346 0.00
enq: DV - contention 180 0.00 2 13 0.00
enq: FB - contention 4,670 0.00 2 1 0.00
cursor: pin S 46,656 0.00 2 0 0.04
library cache lock 57 0.00 2 27 0.00
enq: TX - allocate ITL entry 608 0.00 1 2 0.00
control file parallel write 1,775 0.00 1 1 0.00
PX Deq Credit: send blkd 1,707 0.00 1 1 0.00
log file switch completion 84 0.00 1 16 0.00
latch: object queue header operation 2,558 0.00 1 0 0.00
os thread startup 11 0.00 1 101 0.00
latch: cache buffer handles 2,519 0.00 1 0 0.00
write complete waits 6 16.67 1 164 0.00
row cache lock 1,185 0.00 1 1 0.00
latch: library cache lock 827 0.00 1 1 0.00
PX Deq: Signal ACK 69 36.23 1 12 0.00
latch: shared pool 749 0.00 1 1 0.00
wait list latch free 273 0.00 1 2 0.00
control file sequential read 1,598 0.00 0 0 0.00
library cache pin 238 0.00 0 2 0.00
latch: enqueue hash chains 155 0.00 0 2 0.00
latch: redo writing 29 0.00 0 3 0.00
enq: TQ - TM contention 137 0.00 0 1 0.00
direct path read 8,714 0.00 0 0 0.01
enq: CU - contention 8 0.00 0 9 0.00
reliable message 53 0.00 0 1 0.00
cursor: mutex S 166 0.00 0 0 0.00
L1 validation 6 66.67 0 7 0.00
enq: TQ - DDL contention 72 0.00 0 0 0.00
PX qref latch 207 86.96 0 0 0.00
latch: checkpoint queue latch 40 0.00 0 0 0.00
latch: messages 41 0.00 0 0 0.00
cursor: mutex X 215 0.00 0 0 0.00
cursor: pin X 1 100.00 0 10 0.00
log file sequential read 4 0.00 0 1 0.00
enq: PS - contention 13 0.00 0 0 0.00
db file parallel read 1 0.00 0 4 0.00
latch: object queue header heap 9 0.00 0 0 0.00
direct path write 359 0.00 0 0 0.00
log file single write 4 0.00 0 0 0.00
direct path write temp 30 0.00 0 0 0.00
direct path read temp 6 0.00 0 0 0.00
SQL*Net message from client 43,747,776 0.00 10,236,348 234 37.24
pipe get 37,876 49.79 55,834 1474 0.03
Streams AQ: waiting for messages in the queue 7,284 99.97 35,545 4880 0.01
jobq slave wait 1,240 95.16 3,628 2926 0.00
Streams AQ: waiting for time management or cleanup tasks 270 5.56 3,602 13341 0.00
Streams AQ: qmn slave idle wait 130 0.00 3,532 27170 0.00
Streams AQ: qmn coordinator idle wait 260 50.00 3,532 13584 0.00
PL/SQL lock timer 315 98.73 3,494 11091 0.00
PX Idle Wait 1,296 92.59 2,384 1839 0.00
PX Deq: Execution Msg 1,365 0.29 30 22 0.00
PX Deq: Execute Reply 5,035 0.00 9 2 0.00
PX Deq: Parse Reply 67 0.00 1 16 0.00
PX Deq Credit: need buffer 1,859 0.00 1 0 0.00
PX Deq: Msg Fragment 1,268 0.00 0 0 0.00
PX Deq: Table Q Normal 1,236 0.00 0 0 0.00
PX Deq: Join ACK 74 0.00 0 1 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 860,158 0.00 271 0 0.73
db file parallel write 277,942 0.00 98 0 0.24
events in waitclass Other 41,683 0.18 9 0 0.04
db file scattered read 836 0.00 4 5 0.00
db file sequential read 738 0.00 2 2 0.00
control file parallel write 1,775 0.00 1 1 0.00
control file sequential read 854 0.00 0 0 0.00
os thread startup 3 0.00 0 85 0.00
latch: redo writing 29 0.00 0 3 0.00
direct path read 720 0.00 0 0 0.00
log file sequential read 4 0.00 0 1 0.00
direct path write 220 0.00 0 0 0.00
latch: cache buffers chains 4 0.00 0 0 0.00
log file single write 4 0.00 0 0 0.00
latch: shared pool 2 0.00 0 0 0.00
log file sync 1 0.00 0 0 0.00
buffer busy waits 4 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
latch: library cache lock 1 0.00 0 0 0.00
rdbms ipc message 854,238 1.23 30,736 36 0.73
Streams AQ: waiting for time management or cleanup tasks 270 5.56 3,602 13341 0.00
smon timer 155,884 0.00 3,537 23 0.13
pmon timer 2,360 96.31 3,535 1498 0.00
Streams AQ: qmn slave idle wait 130 0.00 3,532 27170 0.00
Streams AQ: qmn coordinator idle wait 260 50.00 3,532 13584 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 63,134,768
IDLE_TIME 56,770,957
IOWAIT_TIME 1,705,015
NICE_TIME 0
SYS_TIME 4,249,773
USER_TIME 55,938,692
LOAD 15
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 30,400
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 61,156.80 55,526.30 1,388,902 2,129,505,477
SYS$USERS 171.90 149.90 86,196 7,189,390
SYS$BACKGROUND 0.00 0.00 21,286 397,086

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 1058190 276683 1326674 42548 0 0 48110667 25503
SYS$USERS 22021 1939 459 7 0 0 89 0
SYS$BACKGROUND 2535 619 15 25 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
6,613 6,439 257,642 0.03 10.79 60t2tt1564j0k   SELECT SUBSTRB(MACHINE, 1, 60)...
4,863 4,859 8 607.91 7.93 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
3,910 3,730 6,593 0.59 6.38 fkxdmd0h7xg54 OEXOETEL select item, item_id, item_d...
3,601 3,438 101,935 0.04 5.87 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,265 2,178 285 7.95 3.70 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
2,256 2,185 67,795 0.03 3.68 3prk3vg9u0abb JDBC Thin Client BEGIN FND_GLOBAL.APPS_INITIA...
1,941 1,916 14 138.63 3.17 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,820 1,778 10 182.04 2.97 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,439 1,368 156,586 0.01 2.35 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
1,251 1,224 16 78.17 2.04 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
1,191 1,143 49,999 0.02 1.94 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
1,154 1,125 35,708 0.03 1.88 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
1,087 1,090 8 135.82 1.77 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
1,003 993 16 62.68 1.64 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
984 908 185,916 0.01 1.61 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
853 828 1,092 0.78 1.39 3cb7xm8ykx1qh icx.por.req.server.RequisitionAM begin :1 := POR_UTIL_PKG.subm...
831 799 16 51.94 1.36 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
753 711 233,835 0.00 1.23 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
720 702 19,185 0.04 1.17 8h16w67202y4g   begin fnd_global.initialize(:s...
718 232 2,196 0.33 1.17 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
715 56 2,196 0.33 1.17 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
686 658 63,257 0.01 1.12 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
641 633 10 64.07 1.05 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
640 630 56,594 0.01 1.04 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
614 601 327,760 0.00 1.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...

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
6,439 6,613 257,642 0.02 10.79 60t2tt1564j0k   SELECT SUBSTRB(MACHINE, 1, 60)...
4,859 4,863 8 607.35 7.93 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
3,730 3,910 6,593 0.57 6.38 fkxdmd0h7xg54 OEXOETEL select item, item_id, item_d...
3,438 3,601 101,935 0.03 5.87 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,185 2,256 67,795 0.03 3.68 3prk3vg9u0abb JDBC Thin Client BEGIN FND_GLOBAL.APPS_INITIA...
2,178 2,265 285 7.64 3.70 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,916 1,941 14 136.86 3.17 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,778 1,820 10 177.85 2.97 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,368 1,439 156,586 0.01 2.35 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
1,224 1,251 16 76.50 2.04 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
1,143 1,191 49,999 0.02 1.94 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
1,125 1,154 35,708 0.03 1.88 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
1,090 1,087 8 136.22 1.77 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
993 1,003 16 62.09 1.64 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
908 984 185,916 0.00 1.61 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
828 853 1,092 0.76 1.39 3cb7xm8ykx1qh icx.por.req.server.RequisitionAM begin :1 := POR_UTIL_PKG.subm...
799 831 16 49.91 1.36 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
711 753 233,835 0.00 1.23 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
702 720 19,185 0.04 1.17 8h16w67202y4g   begin fnd_global.initialize(:s...
658 686 63,257 0.01 1.12 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
633 641 10 63.34 1.05 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
630 640 56,594 0.01 1.04 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
601 614 327,760 0.00 1.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
232 718 2,196 0.11 1.17 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
56 715 2,196 0.03 1.17 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,136,414,396
  • Captured SQL account for 26.3% of Total
Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
226,563,038 8 28,320,379.75 10.60 4858.78 4863.24 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
123,929,819 14 8,852,129.93 5.80 1916.10 1940.86 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
105,681,309 8 13,210,163.63 4.95 1089.77 1086.60 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
96,080,096 16 6,005,006.00 4.50 1224.07 1250.67 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
95,826,404 156,586 611.97 4.49 1367.78 1439.32 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
93,025,308 49,999 1,860.54 4.35 1143.45 1190.57 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
86,492,971 16 5,405,810.69 4.05 993.45 1002.84 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
85,152,375 185,916 458.02 3.99 907.99 984.13 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
83,928,005 233,835 358.92 3.93 711.07 753.42 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
77,388,771 10 7,738,877.10 3.62 1778.50 1820.40 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
54,180,638 10 5,418,063.80 2.54 633.36 640.68 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
48,862,769 16 3,053,923.06 2.29 798.59 831.04 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
48,208,533 285 169,152.75 2.26 2178.10 2265.01 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
43,742,841 5,000 8,748.57 2.05 550.38 555.75 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
42,849,911 1,092 39,239.85 2.01 828.14 853.31 3cb7xm8ykx1qh icx.por.req.server.RequisitionAM begin :1 := POR_UTIL_PKG.subm...
41,053,487 96 427,640.49 1.92 578.99 596.31 37f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
37,676,993 171,893 219.19 1.76 541.56 546.56 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
37,676,142 171,891 219.19 1.76 524.69 529.41 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
36,859,758 56,594 651.30 1.73 630.20 640.31 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
33,014,938 63,257 521.92 1.55 658.12 686.38 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
25,566,489 6,593 3,877.82 1.20 3730.33 3909.50 fkxdmd0h7xg54 OEXOETEL select item, item_id, item_d...
24,611,612 418,114 58.86 1.15 224.74 226.26 91hakq9n36htp   SELECT TEXT_VALUE FROM WF_ITEM...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

  • Total Disk Reads: 1,493,210
  • Captured SQL account for 43.1% of Total
Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
212,964 8 26,620.50 14.26 9.00 32.30 4099q0gjjdwah RAXMTR select /*+ parallel(t, 8) para...
199,486 2,196 90.84 13.36 55.98 715.09 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
146,850 2,196 66.87 9.83 231.64 718.45 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
53,325 8 6,665.63 3.57 8.86 19.70 g6yx4z6m66xtq RAXMTR select /*+ parallel(t, 8) para...
20,930 10 2,093.00 1.40 1778.50 1820.40 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
16,636 123,265 0.13 1.11 49.53 54.68 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
16,455 285 57.74 1.10 2178.10 2265.01 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
14,778 185,916 0.08 0.99 907.99 984.13 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
14,446 233,835 0.06 0.97 711.07 753.42 <