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:5410-Apr-07 06:39:434853 189.4
End Snap:5510-Apr-07 07:41:254939 240.1
Elapsed:  61.71 (mins)  
DB Time:  544.25 (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,674,702.15 27,304.92
Logical reads: 572,927.99 1,803.38
Block changes: 54,094.17 170.27
Physical reads: 242.67 0.76
Physical writes: 713.95 2.25
User calls: 12,870.27 40.51
Parses: 2,189.50 6.89
Hard parses: 2.81 0.01
Sorts: 2,897.21 9.12
Logons: 2.61 0.01
Executes: 25,538.61 80.39
Transactions: 317.70 

% Blocks changed per Read: 9.44Recursive Call %: 76.50
Rollback per transaction %: 21.18Rows per Sort: 14.64

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.96Redo NoWait %: 100.00
Buffer Hit %: 99.96In-memory Sort %: 100.00
Library Hit %: 99.96Soft Parse %: 99.87
Execute to Parse %: 91.43Latch Hit %: 98.78
Parse CPU to Parse Elapsd %: 53.97% Non-Parse CPU: 97.03

Shared Pool Statistics

BeginEnd
Memory Usage %: 63.06 93.65
% SQL with executions>1: 78.82 77.56
% Memory for SQL w/exec>1: 68.71 54.33

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  19,044  58.3 
db file sequential read 773,808 3,036 4 9.3User I/O
latch: undo global data 33,549 666 20 2.0Other
log file sync 470,593 652 1 2.0Commit
log file parallel write 835,791 336 0 1.0System I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

  • Total time in database user-calls (DB Time): 32655s
  • 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 28,745.71 88.03
DB CPU 19,044.46 58.32
inbound PL/SQL rpc elapsed time 5,976.34 18.30
PL/SQL execution elapsed time 5,354.58 16.40
parse time elapsed 1,103.79 3.38
hard parse elapsed time 692.30 2.12
Java execution elapsed time 668.86 2.05
repeated bind elapsed time 56.33 0.17
sequence load elapsed time 18.70 0.06
connection management call elapsed time 9.77 0.03
PL/SQL compilation elapsed time 7.84 0.02
hard parse (sharing criteria) elapsed time 4.22 0.01
failed parse elapsed time 1.53 0.00
hard parse (bind mismatch) elapsed time 1.50 0.00
DB time 32,655.02  
background elapsed time 733.35  
background cpu time 175.90  

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 899,251 0.00 3,190 4 0.76
Concurrency 931,282 0.93 938 1 0.79
Other 183,394 31.76 723 4 0.16
Commit 470,593 0.00 652 1 0.40
System I/O 1,088,270 0.00 470 0 0.93
Application 68,872 0.05 285 4 0.06
Network 53,980,368 0.00 151 0 45.89
Configuration 7,899 0.01 9 1 0.01
Administrative 6 0.00 0 14 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 773,808 0.00 3,036 4 0.66
latch: undo global data 33,549 0.00 666 20 0.03
log file sync 470,593 0.00 652 1 0.40
log file parallel write 835,791 0.00 336 0 0.71
latch: In memory undo latch 22,260 0.00 323 15 0.02
latch: cache buffers chains 110,627 0.00 257 2 0.09
enq: UL - contention 3,826 0.86 246 64 0.00
buffer busy waits 754,801 0.00 144 0 0.64
db file parallel write 248,889 0.00 132 1 0.21
read by other session 113,268 0.00 123 1 0.10
SQL*Net more data from client 2,485,903 0.00 108 0 2.11
cursor: pin S wait on X 8,924 97.22 86 10 0.01
enq: TX - index contention 27,357 0.00 46 2 0.02
latch: library cache 2,612 0.00 34 13 0.00
library cache load lock 1,215 0.00 33 27 0.00
db file scattered read 7,580 0.00 28 4 0.01
SQL*Net more data to client 1,958,122 0.00 22 0 1.66
enq: TX - row lock contention 858 0.23 22 26 0.00
SQL*Net message to client 49,536,343 0.00 21 0 42.11
latch: redo allocation 2,127 0.00 19 9 0.00
SQL*Net break/reset to client 64,032 0.00 14 0 0.05
LGWR wait for redo copy 42,703 0.93 10 0 0.04
latch: library cache pin 734 0.00 9 12 0.00
kksfbc child completion 161 83.23 7 41 0.00
enq: SQ - contention 3,935 0.00 4 1 0.00
enq: DV - contention 254 0.00 4 16 0.00
latch: cache buffers lru chain 626 0.00 4 7 0.00
local write wait 3,370 0.00 3 1 0.00
enq: RO - fast object reuse 155 0.00 3 19 0.00
PX Deq Credit: send blkd 6,660 0.00 3 0 0.01
enq: TX - contention 3,043 0.00 2 1 0.00
library cache lock 68 0.00 2 29 0.00
enq: HW - contention 3,133 0.00 2 1 0.00
latch: row cache objects 218 0.00 2 8 0.00
PX Deq: Signal ACK 117 31.62 2 15 0.00
latch: session allocation 212 0.00 2 8 0.00
latch free 1,023 0.00 2 1 0.00
control file parallel write 1,801 0.00 1 1 0.00
row cache lock 1,900 0.00 1 1 0.00
enq: FB - contention 1,949 0.00 1 1 0.00
write complete waits 2 50.00 1 488 0.00
enq: TX - allocate ITL entry 778 0.00 1 1 0.00
latch: cache buffer handles 127 0.00 1 4 0.00
control file sequential read 1,781 0.00 0 0 0.00
buffer deadlock 18,163 99.53 0 0 0.02
rdbms ipc reply 2,581 0.00 0 0 0.00
os thread startup 18 0.00 0 20 0.00
latch: object queue header operation 136 0.00 0 2 0.00
cursor: pin S 30,048 0.00 0 0 0.03
log buffer space 23 0.00 0 9 0.00
library cache pin 116 0.00 0 2 0.00
wait list latch free 9 0.00 0 19 0.00
log file switch (private strand flush incomplete) 10 0.00 0 15 0.00
latch: library cache lock 49 0.00 0 3 0.00
latch: redo writing 18 0.00 0 7 0.00
latch: enqueue hash chains 27 0.00 0 4 0.00
enq: TM - contention 1 0.00 0 94 0.00
switch logfile command 6 0.00 0 14 0.00
enq: CU - contention 5 0.00 0 12 0.00
latch: checkpoint queue latch 7 0.00 0 7 0.00
reliable message 144 0.00 0 0 0.00
PX qref latch 39,649 99.88 0 0 0.03
direct path read 420 0.00 0 0 0.00
L1 validation 4 50.00 0 5 0.00
db file parallel read 2 0.00 0 8 0.00
latch: shared pool 24 0.00 0 0 0.00
direct path read temp 6 0.00 0 2 0.00
direct path write temp 91 0.00 0 0 0.00
enq: US - contention 21 0.00 0 0 0.00
direct path write 706 0.00 0 0 0.00
enq: PS - contention 21 0.00 0 0 0.00
cursor: mutex S 271 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
enq: CI - contention 10 0.00 0 0 0.00
cursor: mutex X 88 0.00 0 0 0.00
PX Deq: Table Q qref 15 0.00 0 0 0.00
latch: object queue header heap 1 0.00 0 0 0.00
latch: messages 2 0.00 0 0 0.00
SQL*Net message from client 49,536,231 0.00 10,208,463 206 42.11
Streams AQ: waiting for messages in the queue 3,682 100.00 17,967 4880 0.00
pipe get 18,589 6.91 7,215 388 0.02
PX Idle Wait 2,704 94.08 5,029 1860 0.00
Streams AQ: qmn slave idle wait 541 0.00 3,605 6664 0.00
Streams AQ: qmn coordinator idle wait 1,582 34.01 3,605 2279 0.00
Streams AQ: waiting for time management or cleanup tasks 3,095 49.79 3,570 1153 0.00
PL/SQL lock timer 209 99.04 2,802 13406 0.00
jobq slave wait 20 100.00 59 2930 0.00
PX Deq: Execution Msg 2,620 0.31 49 19 0.00
PX Deq: Execute Reply 1,698 0.06 9 5 0.00
PX Deq: Parse Reply 107 0.00 1 10 0.00
PX Deq: Msg Fragment 1,504 0.00 0 0 0.00
PX Deq Credit: need buffer 1,127 0.00 0 0 0.00
PX Deq: Table Q Normal 603 0.00 0 0 0.00
PX Deq: Join ACK 88 0.00 0 0 0.00
PX Deq: Table Q Sample 41 0.00 0 0 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 835,764 0.00 336 0 0.71
db file parallel write 248,889 0.00 132 1 0.21
events in waitclass Other 43,984 0.90 13 0 0.04
db file scattered read 1,394 0.00 6 4 0.00
db file sequential read 1,736 0.00 4 3 0.00
control file parallel write 1,801 0.00 1 1 0.00
latch: cache buffers chains 90 0.00 1 10 0.00
control file sequential read 874 0.00 0 0 0.00
latch: redo writing 18 0.00 0 7 0.00
os thread startup 2 0.00 0 25 0.00
direct path read 420 0.00 0 0 0.00
buffer busy waits 25 0.00 0 1 0.00
log file sync 4 0.00 0 1 0.00
direct path write 220 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
latch: library cache 2 0.00 0 0 0.00
rdbms ipc message 828,909 1.32 30,176 36 0.70
pmon timer 1,233 100.00 3,610 2928 0.00
Streams AQ: qmn slave idle wait 541 0.00 3,605 6664 0.00
Streams AQ: qmn coordinator idle wait 1,582 34.01 3,605 2279 0.00
smon timer 76,842 0.00 3,582 47 0.07
Streams AQ: waiting for time management or cleanup tasks 3,095 49.79 3,570 1153 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 176,250
AVG_IDLE_TIME 193,657
AVG_IOWAIT_TIME 12,577
AVG_SYS_TIME 19,348
AVG_USER_TIME 156,788
BUSY_TIME 2,821,833
IDLE_TIME 3,100,376
IOWAIT_TIME 202,968
SYS_TIME 311,414
USER_TIME 2,510,419
LOAD 0
OS_CPU_WAIT_TIME 3,299,600
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 24,909.30 14,187.00 364,786 1,895,260,703
VIS 7,748.00 4,859.40 520,828 220,091,101
SYS$BACKGROUND 0.00 0.00 13,043 5,795,591

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 385299 92250 921647 91631 0 0 21727398 12897
VIS 510177 225719 9515 2018 0 0 32237797 2181
SYS$BACKGROUND 3774 1006 119 102 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,344 1,437 8 293.02 7.18 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
2,043 488 286 7.14 6.26 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,620 971 10 162.02 4.96 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
933 263 16 58.30 2.86 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
914 663 21,938 0.04 2.80 0vfguqskjkcc4 OEXOETEL SELECT RLTD.RELATED_LINE_INDEX...
742 444 10 74.24 2.27 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
731 16 2,212 0.33 2.24 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
675 293 49,999 0.01 2.07 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
598 488 187,186 0.00 1.83 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
562 88 2,211 0.25 1.72 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
558 456 6 93.04 1.71 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
488 428 103,864 0.00 1.50 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
479 414 236,065 0.00 1.47 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
479 191 16 29.91 1.47 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
457 275 156,651 0.00 1.40 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
394 272 1,335 0.30 1.21 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
391 346 56,550 0.01 1.20 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
351 180 56,445 0.01 1.08 gzkhp7cph992f INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...

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,437 2,344 8 179.56 7.18 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
971 1,620 10 97.09 4.96 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
663 914 21,938 0.03 2.80 0vfguqskjkcc4 OEXOETEL SELECT RLTD.RELATED_LINE_INDEX...
488 2,043 286 1.71 6.26 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
488 598 187,186 0.00 1.83 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
456 558 6 75.93 1.71 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
444 742 10 44.39 2.27 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
428 488 103,864 0.00 1.50 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
414 479 236,065 0.00 1.47 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
346 391 56,550 0.01 1.20 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
293 675 49,999 0.01 2.07 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
275 457 156,651 0.00 1.40 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
272 394 1,335 0.20 1.21 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
263 933 16 16.41 2.86 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
191 479 16 11.94 1.47 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
180 351 56,445 0.00 1.08 gzkhp7cph992f INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...
88 562 2,211 0.04 1.72 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
16 731 2,212 0.01 2.24 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,121,167,354
  • Captured SQL account for 28.7% of Total
Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
244,121,384 8 30,515,173.00 11.51 1436.50 2344.18 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
158,216,243 10 15,821,624.30 7.46 970.87 1620.16 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
101,352,269 16 6,334,516.81 4.78 262.50 932.85 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
95,719,009 6 15,953,168.17 4.51 455.59 558.26 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
91,148,943 49,999 1,823.02 4.30 292.63 674.57 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
81,761,857 10 8,176,185.70 3.85 443.94 742.36 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
77,005,692 187,186 411.39 3.63 487.56 598.14 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
75,232,452 236,065 318.69 3.55 414.48 478.71 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
74,340,411 16 4,646,275.69 3.50 191.05 478.57 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
71,735,197 21,938 3,269.91 3.38 663.34 913.99 0vfguqskjkcc4 OEXOETEL SELECT RLTD.RELATED_LINE_INDEX...
59,892,264 156,651 382.33 2.82 275.27 456.77 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
58,242,840 286 203,646.29 2.75 487.64 2042.71 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
44,897,231 58 774,090.19 2.12 120.26 203.72 3n8tvc1tsqua0 WSHINTERFACES SELECT DISTINCT WTS.STOP_ID FR...
43,909,823 11 3,991,802.09 2.07 213.12 262.63 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
43,500,706 56,550 769.24 2.05 346.42 390.89 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
36,220,046 5,000 7,244.01 1.71 219.25 264.64 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
34,869,393 171,788 202.98 1.64 232.40 305.73 3b3psftuyks81 WSHFRREL BEGIN INV_TXNSTUB_PUB.postTran...
34,869,035 171,793 202.97 1.64 220.90 289.94 gf1u933c95jb5 WSHFRREL DECLARE l_ret_stat varchar2...
30,940,474 16 1,933,779.63 1.46 78.58 321.12 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
29,050,557 11 2,640,959.73 1.37 133.13 168.07 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
26,370,876 9,998 2,637.62 1.24 78.92 263.32 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
21,786,573 1,545,827 14.09 1.03 112.48 114.06 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

  • Total Disk Reads: 898,430
  • Captured SQL account for 47.3% of Total
Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
170,045 2,212 76.87 18.93 16.43 731.36 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
111,380 2,211 50.38 12.40 88.30 562.36 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
55,848 3,807 14.67 6.22 12.66 264.19 72cqcsuq5wgh0 asn.dashboard.server.DashboardAM SELECT aslrt.meaning as rank_n...
54,467 9,998 5.45 6.06 78.92 263.32 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
25,521 19,984 1.28 2.84 138.22 265.06 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
15,978 236,065 0.07 1.78 414.48 478.71 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
13,797 187,186 0.07 1.54 487.56 598.14 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
9,554 1 9,554.00 1.06 18.73 24.51 fzbs29z0uccds SQL*Plus select /*+ parallel(t, 8) para...
2,753 10 275.30 0.31 443.94 742.36 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
2,480 10 248.00 0.28 970.87 1620.16 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

  • Total Executions: 94,552,325
  • Captured SQL account for 7.9% of Total
Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
1,545,827 799,255 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
555,033 554,967 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
382,193 305,863 0.80 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
299,724 296,388 0.99 0.00 0.00 91hakq9n36htp ap.oie.server.WebExpensesAM SELECT TEXT_VALUE FROM WF_ITEM...
269,551 4,582,158 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
236,076 78,693 0.33 0.00 0.00 b5jqxnpqu8624 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
236,065 0 0.00 0.00 0.00 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
217,294 217,286 1.00 0.00 0.00 9bbak9qpg1c7x OEXOETEL INSERT INTO WF_ITEM_ATTRIBUTE_...
213,802 210,179 0.98 0.00 0.00 0b85w9vv0hbt1 ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ATTRIBUTE_VALUE...
187,186 187,154 1.00 0.00 0.00 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...

Back to SQL Statistics