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:5417-Apr-07 12:54:415324 190.6
End Snap:5517-Apr-07 13:55:525408 237.3
Elapsed:  61.18 (mins)  
DB Time:  601.40 (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,945,760.64 25,996.15
Logical reads: 649,549.63 1,887.57
Block changes: 55,909.18 162.47
Physical reads: 262.25 0.76
Physical writes: 740.93 2.15
User calls: 14,227.76 41.35
Parses: 2,380.73 6.92
Hard parses: 3.04 0.01
Sorts: 3,125.87 9.08
Logons: 2.85 0.01
Executes: 27,458.31 79.79
Transactions: 344.12 

% Blocks changed per Read: 8.61Recursive Call %: 75.98
Rollback per transaction %: 21.60Rows per Sort: 14.38

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.33Latch Hit %: 98.65
Parse CPU to Parse Elapsd %: 51.55% Non-Parse CPU: 97.11

Shared Pool Statistics

BeginEnd
Memory Usage %: 66.50 98.02
% SQL with executions>1: 78.10 75.53
% Memory for SQL w/exec>1: 67.47 52.70

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  20,779  57.6 
db file sequential read 844,377 3,303 4 9.2User I/O
log file sync 516,876 735 1 2.0Commit
latch: undo global data 60,220 601 10 1.7Other
log file parallel write 890,739 354 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): 36084.2s
  • 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 31,640.05 87.68
DB CPU 20,779.23 57.59
inbound PL/SQL rpc elapsed time 6,859.19 19.01
PL/SQL execution elapsed time 5,954.62 16.50
parse time elapsed 1,223.36 3.39
hard parse elapsed time 768.01 2.13
Java execution elapsed time 655.57 1.82
repeated bind elapsed time 64.85 0.18
sequence load elapsed time 17.31 0.05
connection management call elapsed time 11.34 0.03
PL/SQL compilation elapsed time 8.03 0.02
hard parse (sharing criteria) elapsed time 2.18 0.01
failed parse elapsed time 1.69 0.00
hard parse (bind mismatch) elapsed time 1.31 0.00
DB time 36,084.22  
background elapsed time 771.60  
background cpu time 182.13  

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,122,595 0.00 3,590 3 0.89
Concurrency 987,445 1.01 855 1 0.78
Commit 516,876 0.00 735 1 0.41
Other 213,558 28.58 656 3 0.17
System I/O 1,155,743 0.00 495 0 0.92
Application 75,621 0.05 384 5 0.06
Network 59,108,890 0.00 175 0 46.80
Configuration 10,025 0.01 6 1 0.01
Administrative 6 0.00 0 16 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 844,377 0.00 3,303 4 0.67
log file sync 516,876 0.00 735 1 0.41
latch: undo global data 60,220 0.00 601 10 0.05
log file parallel write 890,739 0.00 354 0 0.71
enq: UL - contention 5,012 0.70 344 69 0.00
latch: In memory undo latch 34,866 0.00 278 8 0.03
read by other session 264,949 0.00 258 1 0.21
latch: cache buffers chains 158,261 0.00 248 2 0.13
db file parallel write 261,461 0.00 139 1 0.21
buffer busy waits 748,957 0.00 128 0 0.59
SQL*Net more data from client 2,726,493 0.00 127 0 2.16
cursor: pin S wait on X 10,275 97.16 99 10 0.01
enq: TX - index contention 27,709 0.00 50 2 0.02
library cache load lock 909 0.00 29 31 0.00
db file scattered read 8,138 0.00 26 3 0.01
SQL*Net more data to client 2,099,437 0.00 25 0 1.66
SQL*Net message to client 54,282,960 0.00 24 0 42.98
enq: TX - row lock contention 842 0.12 19 22 0.00
SQL*Net break/reset to client 69,592 0.00 17 0 0.06
latch: library cache 3,237 0.00 14 4 0.00
latch: redo allocation 2,316 0.00 14 6 0.00
LGWR wait for redo copy 48,393 0.55 8 0 0.04
latch: library cache pin 1,129 0.00 6 5 0.00
kksfbc child completion 145 83.45 6 41 0.00
latch: session allocation 317 0.00 5 14 0.00
latch: cache buffers lru chain 619 0.00 3 5 0.00
PX Deq Credit: send blkd 6,663 0.00 3 0 0.01
enq: RO - fast object reuse 171 0.00 3 18 0.00
local write wait 3,960 0.00 3 1 0.00
enq: TX - contention 3,497 0.00 3 1 0.00
enq: DV - contention 207 0.00 3 13 0.00
enq: SQ - contention 5,732 0.00 2 0 0.00
library cache lock 137 0.00 2 17 0.00
enq: HW - contention 3,279 0.00 2 1 0.00
latch free 1,246 0.00 2 2 0.00
wait list latch free 182 0.00 2 11 0.00
latch: cache buffer handles 398 0.00 2 5 0.00
PX Deq: Signal ACK 95 35.79 2 19 0.00
control file parallel write 1,781 0.00 2 1 0.00
enq: TM - contention 4 0.00 2 383 0.00
latch: row cache objects 236 0.00 1 4 0.00
write complete waits 1 100.00 1 977 0.00
rdbms ipc reply 4,014 0.00 1 0 0.00
enq: CI - contention 35 0.00 1 20 0.00
buffer deadlock 21,071 99.27 1 0 0.02
enq: FB - contention 1,726 0.00 1 0 0.00
control file sequential read 1,754 0.00 1 0 0.00
os thread startup 18 0.00 0 21 0.00
row cache lock 1,128 0.00 0 0 0.00
enq: CU - contention 9 0.00 0 38 0.00
latch: object queue header operation 190 0.00 0 2 0.00
enq: TX - allocate ITL entry 973 0.00 0 0 0.00
latch: redo writing 17 0.00 0 15 0.00
library cache pin 107 0.00 0 2 0.00
log file switch (private strand flush incomplete) 23 0.00 0 10 0.00
latch: library cache lock 94 0.00 0 2 0.00
cursor: pin S 22,235 0.00 0 0 0.02
switch logfile command 6 0.00 0 16 0.00
latch: enqueue hash chains 31 0.00 0 2 0.00
reliable message 158 0.00 0 0 0.00
PX qref latch 39,737 99.90 0 0 0.03
direct path read 420 0.00 0 0 0.00
latch: shared pool 51 0.00 0 1 0.00
db file parallel read 2 0.00 0 7 0.00
direct path read temp 6 0.00 0 2 0.00
enq: US - contention 11 0.00 0 1 0.00
latch: checkpoint queue latch 8 0.00 0 1 0.00
direct path write temp 67 0.00 0 0 0.00
direct path write 676 0.00 0 0 0.00
cursor: mutex S 271 0.00 0 0 0.00
enq: PS - contention 17 0.00 0 0 0.00
latch: messages 3 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
cursor: mutex X 60 0.00 0 0 0.00
PX Deq: Table Q qref 14 0.00 0 0 0.00
latch: object queue header heap 1 0.00 0 0 0.00
SQL*Net message from client 54,282,874 0.00 11,229,255 207 42.98
Streams AQ: waiting for messages in the queue 3,650 100.00 17,823 4883 0.00
pipe get 20,929 5.80 7,196 344 0.02
PX Idle Wait 2,581 94.46 4,798 1859 0.00
Streams AQ: qmn slave idle wait 539 0.00 3,586 6652 0.00
Streams AQ: qmn coordinator idle wait 1,558 34.34 3,585 2301 0.00
Streams AQ: waiting for time management or cleanup tasks 3,776 42.08 3,534 936 0.00
PL/SQL lock timer 221 99.55 2,998 13566 0.00
jobq slave wait 20 100.00 59 2930 0.00
PX Deq: Execution Msg 2,348 0.34 48 20 0.00
PX Deq: Execute Reply 1,474 0.14 9 6 0.00
PX Deq: Table Q Normal 917 0.00 1 1 0.00
PX Deq Credit: need buffer 665 0.00 0 0 0.00
PX Deq: Msg Fragment 1,160 0.00 0 0 0.00
PX Deq: Parse Reply 92 0.00 0 1 0.00
PX Deq: Join ACK 75 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 0 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 890,737 0.00 354 0 0.71
db file parallel write 261,461 0.00 139 1 0.21
events in waitclass Other 49,771 0.53 10 0 0.04
db file scattered read 1,366 0.00 4 3 0.00
db file sequential read 1,263 0.00 3 2 0.00
control file parallel write 1,781 0.00 2 1 0.00
latch: cache buffers chains 92 0.00 1 6 0.00
control file sequential read 862 0.00 0 0 0.00
latch: redo writing 17 0.00 0 15 0.00
os thread startup 2 0.00 0 25 0.00
direct path read 420 0.00 0 0 0.00
latch: row cache objects 1 0.00 0 23 0.00
direct path write 220 0.00 0 0 0.00
log file sync 3 0.00 0 0 0.00
buffer busy waits 11 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: In memory undo latch 3 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
rdbms ipc message 882,290 1.23 30,603 35 0.70
Streams AQ: qmn slave idle wait 539 0.00 3,586 6652 0.00
Streams AQ: qmn coordinator idle wait 1,558 34.34 3,585 2301 0.00
pmon timer 1,221 100.00 3,577 2930 0.00
smon timer 91,514 0.00 3,551 39 0.07
Streams AQ: waiting for time management or cleanup tasks 3,776 42.08 3,534 936 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 195,123
AVG_IDLE_TIME 171,591
AVG_IOWAIT_TIME 12,507
AVG_SYS_TIME 21,044
AVG_USER_TIME 173,982
BUSY_TIME 3,123,934
IDLE_TIME 2,747,155
IOWAIT_TIME 201,986
SYS_TIME 338,429
USER_TIME 2,785,505
LOAD 0
OS_CPU_WAIT_TIME 3,792,800
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 27,337.10 15,259.40 383,721 2,132,065,388
VIS 8,746.80 5,520.80 565,938 245,679,515
SYS$BACKGROUND 0.00 0.00 13,129 6,368,973

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 563480 115500 974687 83739 0 0 23625427 15079
VIS 555852 242769 12648 1676 0 0 35466354 2485
SYS$BACKGROUND 3273 706 110 62 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,422 1,423 8 302.79 6.71 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
2,043 515 287 7.12 5.66 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,690 974 10 168.99 4.68 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,192 386 16 74.50 3.30 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
1,039 280 16 64.94 2.88 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
1,029 723 24,099 0.04 2.85 0vfguqskjkcc4 OEXOETEL SELECT RLTD.RELATED_LINE_INDEX...
976 374 49,998 0.02 2.70 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
779 448 10 77.88 2.16 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
765 17 2,458 0.31 2.12 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
681 543 206,858 0.00 1.89 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
648 456 157,372 0.00 1.79 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
611 93 2,458 0.25 1.69 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
559 490 114,948 0.00 1.55 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
553 442 6 92.20 1.53 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
543 470 260,487 0.00 1.50 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
443 294 1,466 0.30 1.23 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
415 358 57,319 0.01 1.15 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
404 133 12,942 0.03 1.12 by2f4fw8tac6r ARXTWMAI UPDATE RA_CUST_TRX_LINE_GL_DIS...
383 123 16 23.94 1.06 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...

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,423 2,422 8 177.86 6.71 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
974 1,690 10 97.44 4.68 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
723 1,029 24,099 0.03 2.85 0vfguqskjkcc4 OEXOETEL SELECT RLTD.RELATED_LINE_INDEX...
543 681 206,858 0.00 1.89 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
515 2,043 287 1.80 5.66 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
490 559 114,948 0.00 1.55 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
470 543 260,487 0.00 1.50 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
456 648 157,372 0.00 1.79 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
448 779 10 44.76 2.16 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
442 553 6 73.66 1.53 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
386 1,192 16 24.11 3.30 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
374 976 49,998 0.01 2.70 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
358 415 57,319 0.01 1.15 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
294 443 1,466 0.20 1.23 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
280 1,039 16 17.49 2.88 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
133 404 12,942 0.01 1.12 by2f4fw8tac6r ARXTWMAI UPDATE RA_CUST_TRX_LINE_GL_DIS...
123 383 16 7.68 1.06 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
93 611 2,458 0.04 1.69 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
17 765 2,458 0.01 2.12 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,384,188,161
  • Captured SQL account for 34.7% of Total
Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
246,861,747 8 30,857,718.38 10.35 1422.89 2422.31 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
160,570,035 10 16,057,003.50 6.73 974.37 1689.88 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
152,431,540 16 9,526,971.25 6.39 385.73 1192.07 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
141,187,880 49,998 2,823.87 5.92 373.91 975.82 gk43kd7q5mak4 RAXTRX update ra_customer_trx_lines l...
115,203,948 16 7,200,246.75 4.83 279.91 1039.03 5qyckzm5v1qmj RAXTRX begin :return_value:i_return_v...
99,403,145 157,372 631.64 4.17 456.16 647.57 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
91,079,961 6 15,179,993.50 3.82 441.93 553.21 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
85,187,838 206,858 411.82 3.57 542.54 680.76 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
84,673,531 10 8,467,353.10 3.55 447.59 778.80 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
83,159,555 260,487 319.25 3.49 469.51 542.61 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
79,437,037 24,099 3,296.28 3.33 722.93 1029.47 0vfguqskjkcc4 OEXOETEL SELECT RLTD.RELATED_LINE_INDEX...
63,766,340 287 222,182.37 2.67 515.36 2042.78 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
52,650,822 12,942 4,068.21 2.21 132.73 403.52 by2f4fw8tac6r ARXTWMAI UPDATE RA_CUST_TRX_LINE_GL_DIS...
50,267,154 16 3,141,697.13 2.11 122.93 383.12 815ygd4pc1bpd RAXTRX INSERT INTO RA_CUSTOMER_TRX_LI...
46,552,415 74 629,086.69 1.95 123.96 213.19 3n8tvc1tsqua0 WSHINTERFACES SELECT DISTINCT WTS.STOP_ID FR...
45,046,977 57,319 785.90 1.89 357.79 415.29 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
43,118,574 11 3,919,870.36 1.81 203.64 265.04 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
40,510,388 96 421,983.21 1.70 122.69 347.73 37f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
36,418,575 174,335 208.90 1.53 237.16 307.28 gf1u933c95jb5 WSHFRREL DECLARE l_ret_stat varchar2...
36,414,544 174,315 208.90 1.53 249.24 323.22 3b3psftuyks81 WSHFRREL BEGIN INV_TXNSTUB_PUB.postTran...
36,135,984 5,000 7,227.20 1.52 218.13 268.48 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
34,307,904 11,467 2,991.88 1.44 82.71 291.21 72874ayah33p7 ARXTWMAI UPDATE RA_CUST_TRX_LINE_GL_DIS...
30,355,239 11 2,759,567.18 1.27 135.44 175.87 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
27,107,241 1,608,319 16.85 1.14 137.30 140.69 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

  • Total Disk Reads: 962,585
  • Captured SQL account for 41.7% of Total
Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
183,397 2,458 74.61 19.05 17.10 765.22 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
119,349 2,458 48.56 12.40 93.25 610.78 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
60,267 4,151 14.52 6.26 13.91 286.27 72cqcsuq5wgh0 asn.dashboard.server.DashboardAM SELECT aslrt.meaning as rank_n...
28,440 21,984 1.29 2.95 154.43 292.79 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
18,314 260,487 0.07 1.90 469.51 542.61 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
16,113 206,858 0.08 1.67 542.54 680.76 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
9,558 1 9,558.00 0.99 18.36 24.81 fzbs29z0uccds SQL*Plus select /*+ parallel(t, 8) para...
7,341 10 734.10 0.76 974.37 1689.88 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
2,754 10 275.40 0.29 447.59 778.80 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
2,459 11 223.55 0.26 203.64 265.04 1du9v021t8m46 ARGLTP insert into gl_interface(creat...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

  • Total Executions: 100,786,408
  • Captured SQL account for 8.3% of Total
Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
1,608,319 831,264 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
608,216 608,122 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
410,592 326,423 0.80 0.00 0.00 fmfdkztk8vx23 FNDSCSGN SELECT CATEGORY, SEVERITY, F...
329,207 325,542 0.99 0.00 0.00 91hakq9n36htp ap.oie.server.WebExpensesAM SELECT TEXT_VALUE FROM WF_ITEM...
296,078 5,033,039 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
260,487 0 0.00 0.00 0.00 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE E