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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:114-Oct-07 17:13:195521 202.2
End Snap:214-Oct-07 18:14:175523 245.2
Elapsed:  60.96 (mins)  
DB Time:  1,148.40 (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,771,198.34 25,345.28
Logical reads: 632,303.36 1,827.11
Block changes: 55,279.85 159.74
Physical reads: 400.26 1.16
Physical writes: 841.77 2.43
User calls: 12,531.64 36.21
Parses: 2,774.27 8.02
Hard parses: 2.69 0.01
Sorts: 3,077.10 8.89
Logons: 3.37 0.01
Executes: 29,268.95 84.58
Transactions: 346.07 

% Blocks changed per Read: 8.74Recursive Call %: 79.20
Rollback per transaction %: 21.56Rows per Sort: 10.63

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.96Redo NoWait %: 100.00
Buffer Hit %: 99.95In-memory Sort %: 100.00
Library Hit %: 100.06Soft Parse %: 99.90
Execute to Parse %: 90.52Latch Hit %: 98.14
Parse CPU to Parse Elapsd %: 84.27% Non-Parse CPU: 98.12

Shared Pool Statistics

BeginEnd
Memory Usage %: 79.25 98.05
% SQL with executions>1: 73.79 82.95
% Memory for SQL w/exec>1: 64.08 57.01

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  61,227  88.9 
db file sequential read 913,724 2,736 3 4.0User I/O
log file sync 514,377 1,188 2 1.7Commit
log file parallel write 897,603 316 0 .5System I/O
latch: cache buffers chains 373,107 235 1 .3Concurrency

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

  • Total time in database user-calls (DB Time): 68904.1s
  • 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 61,635.03 89.45
DB CPU 61,226.62 88.86
inbound PL/SQL rpc elapsed time 12,210.39 17.72
PL/SQL execution elapsed time 9,695.60 14.07
Java execution elapsed time 3,013.42 4.37
parse time elapsed 1,451.19 2.11
hard parse elapsed time 674.92 0.98
repeated bind elapsed time 160.55 0.23
connection management call elapsed time 40.82 0.06
sequence load elapsed time 39.94 0.06
PL/SQL compilation elapsed time 9.89 0.01
hard parse (sharing criteria) elapsed time 8.81 0.01
failed parse elapsed time 4.15 0.01
hard parse (bind mismatch) elapsed time 1.39 0.00
DB time 68,904.11  
background elapsed time 1,176.47  
background cpu time 729.76  

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,113,123 0.00 2,941 3 0.88
Commit 514,377 0.00 1,188 2 0.41
Concurrency 1,389,922 0.77 888 1 1.10
System I/O 1,193,641 0.00 430 0 0.94
Application 85,998 0.08 312 4 0.07
Network 52,985,827 0.00 301 0 41.86
Other 224,536 16.89 277 1 0.18
Configuration 85,981 0.00 214 2 0.07

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 913,724 0.00 2,736 3 0.72
log file sync 514,377 0.00 1,188 2 0.41
log file parallel write 897,603 0.00 316 0 0.71
latch: cache buffers chains 373,107 0.00 235 1 0.29
latch: In memory undo latch 60,285 0.00 204 3 0.05
enq: HW - contention 66,188 0.00 204 3 0.05
latch: undo global data 41,676 0.00 189 5 0.03
read by other session 176,465 0.00 175 1 0.14
enq: UL - contention 3,025 1.39 167 55 0.00
SQL*Net more data from client 2,666,614 0.00 140 0 2.11
cursor: pin S wait on X 11,316 95.03 116 10 0.01
db file parallel write 292,640 0.00 112 0 0.23
buffer busy waits 854,086 0.00 97 0 0.67
SQL*Net more data to client 2,105,298 0.00 93 0 1.66
enq: TX - row lock contention 1,255 2.07 90 72 0.00
latch: library cache 31,260 0.00 82 3 0.02
SQL*Net message to client 48,213,915 0.00 69 0 38.09
latch: library cache pin 15,009 0.00 50 3 0.01
enq: TX - index contention 30,128 0.00 44 1 0.02
SQL*Net break/reset to client 81,656 0.00 35 0 0.06
db file scattered read 10,619 0.00 25 2 0.01
library cache load lock 776 0.00 20 26 0.00
latch: row cache objects 9,725 0.00 18 2 0.01
latch: redo allocation 11,234 0.00 16 1 0.01
enq: KO - fast object checkpoint 26 3.85 15 570 0.00
latch free 2,896 0.00 12 4 0.00
library cache lock 332 0.00 10 32 0.00
LGWR wait for redo copy 38,718 0.49 10 0 0.03
latch: session allocation 8,055 0.00 10 1 0.01
latch: cache buffers lru chain 5,070 0.00 7 1 0.00
kksfbc child completion 156 78.21 6 39 0.00
enq: SQ - contention 18,702 0.00 6 0 0.01
enq: TX - contention 9,281 0.00 6 1 0.01
enq: RO - fast object reuse 32 0.00 6 177 0.00
cursor: pin S 55,857 0.00 5 0 0.04
local write wait 3,998 0.00 5 1 0.00
library cache pin 739 0.00 5 6 0.00
buffer deadlock 38,193 98.27 3 0 0.03
enq: FB - contention 5,158 0.00 3 1 0.00
enq: TX - allocate ITL entry 943 0.00 3 3 0.00
latch: library cache lock 1,052 0.00 3 2 0.00
enq: DV - contention 167 0.00 2 15 0.00
latch: cache buffer handles 3,317 0.00 2 1 0.00
wait list latch free 523 0.00 2 3 0.00
latch: object queue header operation 2,608 0.00 2 1 0.00
control file parallel write 1,773 0.00 1 1 0.00
latch: shared pool 935 0.00 1 2 0.00
os thread startup 10 0.00 1 107 0.00
log file switch completion 77 0.00 1 13 0.00
row cache lock 913 0.00 1 1 0.00
PX Deq Credit: send blkd 863 0.00 1 1 0.00
latch: enqueue hash chains 166 0.00 1 3 0.00
PX Deq: Signal ACK 51 29.41 1 10 0.00
control file sequential read 1,617 0.00 0 0 0.00
latch: redo writing 66 0.00 0 3 0.00
enq: US - contention 67 0.00 0 2 0.00
L1 validation 12 66.67 0 7 0.00
latch: checkpoint queue latch 59 0.00 0 1 0.00
enq: TQ - TM contention 121 0.00 0 1 0.00
direct path read 7,917 0.00 0 0 0.01
enq: TM - contention 4 0.00 0 16 0.00
enq: TQ - DDL contention 72 0.00 0 1 0.00
reliable message 56 0.00 0 1 0.00
cursor: mutex S 168 0.00 0 0 0.00
PX qref latch 83 72.29 0 1 0.00
db file parallel read 2 0.00 0 15 0.00
latch: messages 44 0.00 0 1 0.00
cursor: mutex X 81 0.00 0 0 0.00
latch: object queue header heap 18 0.00 0 1 0.00
enq: PS - contention 12 0.00 0 1 0.00
write complete waits 5 0.00 0 2 0.00
log file sequential read 4 0.00 0 1 0.00
direct path write 349 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 write temp 37 0.00 0 0 0.00
direct path read temp 12 0.00 0 0 0.00
SQL*Net message from client 48,213,849 0.00 11,379,224 236 38.09
pipe get 43,343 47.36 60,436 1394 0.03
Streams AQ: waiting for messages in the queue 7,278 100.00 35,555 4885 0.01
PL/SQL lock timer 322 99.69 3,595 11164 0.00
jobq slave wait 1,218 94.99 3,564 2926 0.00
Streams AQ: qmn slave idle wait 130 0.00 3,555 27349 0.00
Streams AQ: qmn coordinator idle wait 260 50.00 3,555 13674 0.00
Streams AQ: waiting for time management or cleanup tasks 271 5.54 3,529 13023 0.00
PX Idle Wait 1,274 94.19 2,390 1876 0.00
PX Deq: Execution Msg 1,111 0.72 37 33 0.00
PX Deq: Execute Reply 3,575 0.00 8 2 0.00
PX Deq: Parse Reply 60 0.00 3 58 0.00
PX Deq: Msg Fragment 995 0.00 0 0 0.00
PX Deq Credit: need buffer 1,182 0.00 0 0 0.00
PX Deq: Table Q Normal 476 0.00 0 0 0.00
PX Deq: Join ACK 61 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 897,553 0.00 316 0 0.71
db file parallel write 292,640 0.00 112 0 0.23
events in waitclass Other 44,625 0.42 15 0 0.04
db file scattered read 959 0.00 5 5 0.00
db file sequential read 662 0.00 2 3 0.00
control file parallel write 1,773 0.00 1 1 0.00
os thread startup 2 0.00 0 155 0.00
control file sequential read 854 0.00 0 0 0.00
latch: redo writing 59 0.00 0 3 0.00
direct path read 720 0.00 0 0 0.00
latch: cache buffers chains 3 0.00 0 8 0.00
latch: library cache 3 0.00 0 2 0.00
log file sequential read 4 0.00 0 1 0.00
log file sync 2 0.00 0 1 0.00
direct path write 220 0.00 0 0 0.00
latch: shared pool 3 0.00 0 0 0.00
log file single write 4 0.00 0 0 0.00
latch: In memory undo latch 2 0.00 0 0 0.00
buffer busy waits 4 0.00 0 0 0.00
rdbms ipc message 888,768 1.18 30,917 35 0.70
Streams AQ: qmn slave idle wait 130 0.00 3,555 27349 0.00
Streams AQ: qmn coordinator idle wait 260 50.00 3,555 13674 0.00
pmon timer 2,336 95.80 3,530 1511 0.00
smon timer 166,366 0.00 3,530 21 0.13
Streams AQ: waiting for time management or cleanup tasks 271 5.54 3,529 13023 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 69,331,850
IDLE_TIME 50,499,022
IOWAIT_TIME 1,696,903
NICE_TIME 0
SYS_TIME 4,658,568
USER_TIME 61,354,019
LOAD 16
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 296,736
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 68,782.50 61,130.10 1,359,648 2,306,902,017
SYS$USERS 160.70 138.90 81,626 6,687,579
SYS$BACKGROUND 0.00 0.00 21,054 373,822

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 1088199 291421 1389523 88736 0 0 52966472 30091
SYS$USERS 22350 1938 389 4 0 0 89 0
SYS$BACKGROUND 2582 745 17 34 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
7,468 7,243 285,451 0.03 10.84 60t2tt1564j0k   SELECT SUBSTRB(MACHINE, 1, 60)...
4,445 4,169 7,308 0.61 6.45 fkxdmd0h7xg54 OEXOETEL select item, item_id, item_d...
4,101 3,868 112,799 0.04 5.95 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,558 2,461 75,104 0.03 3.71 3prk3vg9u0abb JDBC Thin Client BEGIN FND_GLOBAL.APPS_INITIA...
2,513 2,272 289 8.69 3.65 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,941 1,915 14 138.66 2.82 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,856 1,803 10 185.64 2.69 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,726 1,460 16 107.88 2.51 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
1,683 1,458 157,307 0.01 2.44 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
1,655 1,374 49,999 0.03 2.40 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
1,292 1,255 39,339 0.03 1.87 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
1,138 1,028 16 71.13 1.65 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
1,126 1,032 205,828 0.01 1.63 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
1,073 1,069 8 134.16 1.56 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
982 940 1,224 0.80 1.42 3cb7xm8ykx1qh icx.por.req.server.RequisitionAM begin :1 := POR_UTIL_PKG.subm...
928 845 16 58.01 1.35 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
862 809 258,868 0.00 1.25 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
813 788 21,227 0.04 1.18 8h16w67202y4g   begin fnd_global.initialize(:s...
795 750 64,146 0.01 1.15 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
745 61 2,427 0.31 1.08 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
742 252 2,427 0.31 1.08 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
730 599 96 7.61 1.06 37f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
697 679 363,954 0.00 1.01 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
7,243 7,468 285,451 0.03 10.84 60t2tt1564j0k   SELECT SUBSTRB(MACHINE, 1, 60)...
4,169 4,445 7,308 0.57 6.45 fkxdmd0h7xg54 OEXOETEL select item, item_id, item_d...
3,868 4,101 112,799 0.03 5.95 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,461 2,558 75,104 0.03 3.71 3prk3vg9u0abb JDBC Thin Client BEGIN FND_GLOBAL.APPS_INITIA...
2,272 2,513 289 7.86 3.65 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,915 1,941 14 136.78 2.82 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,803 1,856 10 180.32 2.69 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,460 1,726 16 91.28 2.51 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
1,458 1,683 157,307 0.01 2.44 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
1,374 1,655 49,999 0.03 2.40 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
1,255 1,292 39,339 0.03 1.87 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
1,069 1,073 8 133.57 1.56 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
1,032 1,126 205,828 0.01 1.63 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
1,028 1,138 16 64.23 1.65 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
940 982 1,224 0.77 1.42 3cb7xm8ykx1qh icx.por.req.server.RequisitionAM begin :1 := POR_UTIL_PKG.subm...
845 928 16 52.81 1.35 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
809 862 258,868 0.00 1.25 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
788 813 21,227 0.04 1.18 8h16w67202y4g   begin fnd_global.initialize(:s...
750 795 64,146 0.01 1.15 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
679 697 363,954 0.00 1.01 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
599 730 96 6.24 1.06 37f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
252 742 2,427 0.10 1.08 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
61 745 2,427 0.03 1.08 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,312,580,606
  • Captured SQL account for 25.9% of Total
Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
125,576,284 14 8,969,734.57 5.43 1914.98 1941.28 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
116,783,535 16 7,298,970.94 5.05 1460.42 1726.15 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
113,712,884 49,999 2,274.30 4.92 1373.84 1655.16 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
106,134,860 157,307 674.70 4.59 1458.01 1683.02 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
104,205,151 8 13,025,643.88 4.51 1068.55 1073.32 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
94,278,241 205,828 458.04 4.08 1032.31 1125.91 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
93,493,150 16 5,843,321.88 4.04 1027.71 1138.09 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
92,916,462 258,868 358.93 4.02 809.50 862.25 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
76,069,608 10 7,606,960.80 3.29 1803.19 1856.38 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
54,726,072 10 5,472,607.20 2.37 642.39 653.90 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
53,839,267 16 3,364,954.19 2.33 844.95 928.24 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
48,331,076 289 167,235.56 2.09 2271.58 2512.63 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
47,464,972 1,224 38,778.57 2.05 939.59 981.76 3cb7xm8ykx1qh icx.por.req.server.RequisitionAM begin :1 := POR_UTIL_PKG.subm...
40,772,482 96 424,713.35 1.76 598.85 730.43 37f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
39,062,787 174,381 224.01 1.69 613.05 625.85 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
39,037,834 174,377 223.87 1.69 594.95 606.80 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
37,754,729 64,146 588.57 1.63 749.96 794.63 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
34,942,016 57,314 609.66 1.51 631.93 644.41 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
28,343,853 7,308 3,878.47 1.23 4169.16 4445.14 fkxdmd0h7xg54 OEXOETEL select item, item_id, item_d...
26,380,148 458,962 57.48 1.14 239.83 242.41 91hakq9n36htp   SELECT TEXT_VALUE FROM WF_ITEM...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

  • Total Disk Reads: 1,463,914
  • Captured SQL account for 44.8% of Total
Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
209,126 2,427 86.17 14.29 61.11 745.02 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
161,625 8 20,203.13 11.04 12.69 35.98 g6yx4z6m66xtq RAXMTR select /*+ parallel(t, 8) para...
147,938 2,427 60.96 10.11 252.32 742.10 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
107,705 6 17,950.83 7.36 7.40 28.97 4099q0gjjdwah RAXMTR select /*+ parallel(t, 8) para...
24,824 10 2,482.40 1.70 1803.19 1856.38 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
19,045 125,714 0.15 1.30 56.26 63.57 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
16,871 7,314 2.31 1.15 523.56 594.56 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
15,860 205,828 0.08 1.08 1032.31 1125.91 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
15,445 258,868 0.06 1.06 809.50 862.25 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
14,636 289 50.64 1.00 2271.58 2512.63 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

  • Total Executions: 107,048,010
  • Captured SQL account for 6.9% of Total
Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
610,679 610,635 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
458,962 439,146 0.96 0.00 0.00 91hakq9n36htp   SELECT TEXT_VALUE FROM WF_ITEM...
400,390 315,720 0.79 0.00 0.00 fmfdkztk8vx23