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
VIS187584551VIS110.2.0.3.0NOhpdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:115-Feb-08 12:50:243240 203.4
End Snap:215-Feb-08 13:50:303253 237.5
Elapsed:  60.11 (mins)  
DB Time:  466.98 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 18,320M 18,176MStd Block Size: 8K
Shared Pool Size: 2,064M 2,208MLog Buffer: 14,320K

Load Profile

Per SecondPer Transaction
Redo size: 8,198,784.81 33,765.02
Logical reads: 511,878.27 2,108.07
Block changes: 50,337.86 207.31
Physical reads: 121.99 0.50
Physical writes: 799.12 3.29
User calls: 8,520.96 35.09
Parses: 1,747.17 7.20
Hard parses: 1.90 0.01
Sorts: 2,174.61 8.96
Logons: 1.97 0.01
Executes: 21,262.63 87.57
Transactions: 242.82 

% Blocks changed per Read: 9.83Recursive Call %: 80.27
Rollback per transaction %: 18.28Rows per Sort: 12.86

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95Redo NoWait %: 100.00
Buffer Hit %: 99.98In-memory Sort %: 100.00
Library Hit %: 99.80Soft Parse %: 99.89
Execute to Parse %: 91.78Latch Hit %: 98.52
Parse CPU to Parse Elapsd %: 82.41% Non-Parse CPU: 97.92

Shared Pool Statistics

BeginEnd
Memory Usage %: 84.59 83.31
% SQL with executions>1: 88.15 90.06
% Memory for SQL w/exec>1: 69.15 68.45

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  22,317  79.6 
db file sequential read 257,975 3,020 12 10.8User I/O
log file sync 342,934 640 2 2.3Commit
db file scattered read 14,800 424 29 1.5User I/O
buffer busy waits 781,923 410 1 1.5Concurrency

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

  • Total time in database user-calls (DB Time): 28019s
  • 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 24,616.49 87.86
DB CPU 22,316.97 79.65
PL/SQL execution elapsed time 4,950.45 17.67
inbound PL/SQL rpc elapsed time 4,814.91 17.18
parse time elapsed 627.83 2.24
Java execution elapsed time 607.14 2.17
hard parse elapsed time 283.04 1.01
repeated bind elapsed time 74.86 0.27
sequence load elapsed time 16.96 0.06
connection management call elapsed time 10.60 0.04
PL/SQL compilation elapsed time 10.53 0.04
hard parse (sharing criteria) elapsed time 3.73 0.01
failed parse elapsed time 1.15 0.00
hard parse (bind mismatch) elapsed time 1.11 0.00
DB time 28,018.99  
background elapsed time 1,348.57  
background cpu time 470.15  

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 330,262 0.02 3,882 12 0.38
Commit 342,934 0.00 640 2 0.39
Concurrency 2,703,160 0.23 619 0 3.09
Application 48,441 0.34 546 11 0.06
Network 35,299,875 0.00 416 0 40.31
System I/O 657,143 0.00 313 0 0.75
Other 133,060 35.87 96 1 0.15
Configuration 10,724 22.76 15 1 0.01

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 257,975 0.00 3,020 12 0.29
log file sync 342,934 0.00 640 2 0.39
db file scattered read 14,800 0.00 424 29 0.02
buffer busy waits 781,923 0.04 410 1 0.89
enq: RO - fast object reuse 159 76.10 368 2316 0.00
SQL*Net more data from client 1,617,302 0.00 346 0 1.85
log file parallel write 625,925 0.00 308 0 0.71
read by other session 53,184 0.00 280 5 0.06
local write wait 1,655 4.95 158 95 0.00
enq: UL - contention 2,467 1.50 128 52 0.00
cursor: pin S wait on X 6,419 92.62 65 10 0.01
latch: cache buffers chains 1,852,480 0.00 61 0 2.12
rdbms ipc reply 69 36.23 51 741 0.00
SQL*Net message to client 32,199,630 0.00 41 0 36.77
enq: TX - index contention 27,780 0.00 37 1 0.03
library cache load lock 845 0.00 32 38 0.00
enq: TX - row lock contention 388 1.55 32 82 0.00
SQL*Net more data to client 1,482,943 0.00 30 0 1.69
PX Deq Credit: send blkd 20,646 0.00 21 1 0.02
enq: HW - contention 3,013 0.00 10 3 0.00
SQL*Net break/reset to client 45,418 0.00 9 0 0.05
enq: TM - contention 9 22.22 8 901 0.00
control file parallel write 1,859 0.00 5 3 0.00
latch: library cache 8,630 0.00 5 1 0.01
kksfbc child completion 106 82.08 4 41 0.00
wait list latch free 353 0.00 4 11 0.00
os thread startup 77 0.00 3 38 0.00
write complete waits 30 80.00 2 83 0.00
latch: In memory undo latch 17,801 0.00 2 0 0.02
latch: undo global data 7,251 0.00 2 0 0.01
PX Deq: Signal ACK 290 28.28 2 6 0.00
latch: library cache pin 2,746 0.00 2 1 0.00
latch free 3,752 0.00 2 0 0.00
latch: object queue header operation 12,041 0.00 1 0 0.01
LGWR wait for redo copy 25,111 0.00 1 0 0.03
buffer deadlock 46,947 98.42 1 0 0.05
enq: DV - contention 201 0.00 1 6 0.00
enq: TX - contention 2,574 0.00 1 0 0.00
enq: SQ - contention 4,649 0.00 1 0 0.01
latch: session allocation 1,476 0.00 1 1 0.00
row cache lock 1,137 0.00 1 1 0.00
latch: redo allocation 2,008 0.00 1 0 0.00
log file switch completion 46 0.00 1 18 0.00
latch: row cache objects 842 0.00 0 1 0.00
PX qref latch 1,367 96.05 0 0 0.00
latch: cache buffers lru chain 837 0.00 0 1 0.00
SGA: allocation forcing component growth 33 60.61 0 11 0.00
enq: TX - allocate ITL entry 102 0.00 0 3 0.00
library cache pin 1,360 0.00 0 0 0.00
enq: FB - contention 903 0.00 0 0 0.00
control file sequential read 29,347 0.00 0 0 0.03
cursor: pin S 6,354 0.00 0 0 0.01
latch: library cache lock 158 0.00 0 1 0.00
latch: shared pool 418 0.00 0 0 0.00
enq: CU - contention 1 0.00 0 83 0.00
library cache lock 8 0.00 0 10 0.00
latch: object queue header heap 334 0.00 0 0 0.00
latch: messages 72 0.00 0 1 0.00
latch: redo writing 463 0.00 0 0 0.00
log file sequential read 6 0.00 0 7 0.00
latch: cache buffer handles 220 0.00 0 0 0.00
cursor: mutex S 122 0.00 0 0 0.00
L1 validation 3 33.33 0 4 0.00
enq: US - contention 7 0.00 0 1 0.00
latch: enqueue hash chains 16 0.00 0 0 0.00
latch: checkpoint queue latch 11 0.00 0 0 0.00
reliable message 28 0.00 0 0 0.00
enq: PS - contention 47 0.00 0 0 0.00
undo segment extension 2,421 99.83 0 0 0.00
direct path read 1,830 0.00 0 0 0.00
cursor: mutex X 414 0.00 0 0 0.00
direct path write 774 0.00 0 0 0.00
log file single write 6 0.00 0 0 0.00
latch: parallel query alloc buffer 2 0.00 0 0 0.00
direct path write temp 38 0.00 0 0 0.00
direct path read temp 6 0.00 0 0 0.00
SQL*Net message from client 32,199,613 0.00 6,227,509 193 36.77
pipe get 20,137 23.17 21,072 1046 0.02
Streams AQ: waiting for messages in the queue 2,390 100.00 11,667 4882 0.00
PX Idle Wait 3,281 76.56 5,160 1573 0.00
Streams AQ: waiting for time management or cleanup tasks 2,140 37.94 3,508 1639 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,486 27232 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,486 13616 0.00
PL/SQL lock timer 262 99.24 2,866 10939 0.00
jobq slave wait 607 99.67 1,776 2926 0.00
PX Deq: Execution Msg 12,249 0.00 67 5 0.01
PX Deq: Msg Fragment 9,368 0.00 3 0 0.01
PX Deq: Execute Reply 4,296 0.00 3 1 0.00
PX Deq Credit: need buffer 4,188 0.00 3 1 0.00
PX Deq: Table Q Normal 8,290 0.00 1 0 0.01
PX Deq: Parse Reply 307 0.00 0 1 0.00
PX Deq: Join ACK 210 0.00 0 0 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 625,912 0.00 308 0 0.71
control file parallel write 1,859 0.00 5 3 0.00
events in waitclass Other 32,977 0.00 2 0 0.04
db file sequential read 774 0.00 2 3 0.00
os thread startup 61 0.00 2 38 0.00
db file scattered read 165 0.00 0 1 0.00
latch: cache buffers chains 31 0.00 0 1 0.00
latch: redo writing 463 0.00 0 0 0.00
log file sequential read 6 0.00 0 7 0.00
control file sequential read 1,019 0.00 0 0 0.00
log file sync 1 0.00 0 5 0.00
direct path read 1,830 0.00 0 0 0.00
buffer busy waits 21 0.00 0 0 0.00
log file single write 6 0.00 0 0 0.00
direct path write 666 0.00 0 0 0.00
latch: shared pool 2 0.00 0 0 0.00
latch: In memory undo latch 2 0.00 0 0 0.00
rdbms ipc message 983,237 1.03 28,779 29 1.12
pmon timer 1,262 96.43 3,518 2787 0.00
Streams AQ: waiting for time management or cleanup tasks 2,140 37.94 3,508 1639 0.00
smon timer 98,650 0.00 3,505 36 0.11
Streams AQ: qmn slave idle wait 128 0.00 3,486 27232 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,486 13616 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 2,447,825
IDLE_TIME 3,311,957
IOWAIT_TIME 185,087
NICE_TIME 22,464
SYS_TIME 151,365
USER_TIME 2,193,293
LOAD 5
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 42,492
NUM_CPUS 16
NUM_CPU_SOCKETS 4

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 28,017.50 22,315.00 430,780 1,843,455,016
SYS$BACKGROUND 0.00 0.00 9,246 2,606,281
VIS 0.00 0.00 0 0

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 326828 387983 2703034 61674 0 0 35289729 41633
SYS$BACKGROUND 3437 255 117 238 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
891 880 301 2.96 3.18 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
499 151 10,000 0.05 1.78 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
460 456 54,232 0.01 1.64 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
459 91 1,444 0.32 1.64 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
446 13 1,444 0.31 1.59 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
424 340 121,824 0.00 1.51 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
420 387 67,708 0.01 1.50 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
420 419 54,277 0.01 1.50 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
410 4 56 7.32 1.46 9k7t8q4kfcb7y SQL*Plus begin GL.apps_ddl.apps_ddl(:dd...
401 399 54,308 0.01 1.43 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
352 350 57,184 0.01 1.26 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
351 349 154,274 0.00 1.25 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
348 346 224,449 0.00 1.24 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
342 135 12,985 0.03 1.22 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
331 232 160,146 0.00 1.18 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
311 14 2,453 0.13 1.11 72cqcsuq5wgh0 asn.dashboard.server.DashboardAM SELECT aslrt.meaning as rank_n...
289 286 60,401 0.00 1.03 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
281 263 864 0.33 1.00 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...

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
880 891 301 2.92 3.18 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
456 460 54,232 0.01 1.64 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
419 420 54,277 0.01 1.50 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
399 401 54,308 0.01 1.43 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
387 420 67,708 0.01 1.50 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
350 352 57,184 0.01 1.26 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
349 351 154,274 0.00 1.25 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
346 348 224,449 0.00 1.24 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
340 424 121,824 0.00 1.51 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
286 289 60,401 0.00 1.03 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
263 281 864 0.30 1.00 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
232 331 160,146 0.00 1.18 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
151 499 10,000 0.02 1.78 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
135 342 12,985 0.01 1.22 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
91 459 1,444 0.06 1.64 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
14 311 2,453 0.01 1.11 72cqcsuq5wgh0 asn.dashboard.server.DashboardAM SELECT aslrt.meaning as rank_n...
13 446 1,444 0.01 1.59 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
4 410 56 0.06 1.46 9k7t8q4kfcb7y SQL*Plus begin GL.apps_ddl.apps_ddl(:dd...

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,846,045,969
  • Captured SQL account for 22.0% of Total
Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
138,939,609 57,184 2,429.69 7.53 350.07 351.88 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
80,624,114 154,274 522.60 4.37 348.88 350.57 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
45,854,441 121,824 376.40 2.48 340.06 423.85 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
44,519,497 160,146 277.99 2.41 231.91 330.52 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
43,324,163 54,232 798.87 2.35 455.96 460.04 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
41,763,327 301 138,748.59 2.26 879.97 890.64 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
33,667,002 54,308 619.93 1.82 399.11 401.14 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
31,719,004 164,445 192.89 1.72 253.41 261.24 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
31,640,741 164,325 192.55 1.71 237.96 245.67 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
26,396,111 10,000 2,639.61 1.43 150.73 498.70 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
26,145,786 4,324 6,046.67 1.42 157.72 241.36 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
25,826,717 1,323,289 19.52 1.40 146.97 147.92 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
24,444,951 11 2,222,268.27 1.32 130.52 130.52 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
22,346,261 54,277 411.71 1.21 418.56 420.28 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
20,263,440 60,401 335.48 1.10 285.71 289.09 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

  • Total Disk Reads: 439,958
  • Captured SQL account for 39.7% of Total
Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
45,238 10,000 4.52 10.28 150.73 498.70 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
41,593 1,444 28.80 9.45 13.37 445.85 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
30,402 1,444 21.05 6.91 91.20 459.12 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
19,960 4,212 4.74 4.54 4.39 209.55 auudu2jzbt9s0 CSCCCCRC SELECT HD.ID CONTRACT_ID , HD....
18,955 12,985 1.46 4.31 135.29 341.81 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
18,777 2,453 7.65 4.27 13.65 310.75 72cqcsuq5wgh0 asn.dashboard.server.DashboardAM SELECT aslrt.meaning as rank_n...
12,808 160,146 0.08 2.91 231.91 330.52 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
11,232 432 26.00 2.55 107.85 221.07 dk0sqcvc2xjvs qotSCopHdrUpd.jsp BEGIN ASO_QUOTE_PUB_W.Create_Q...
10,004 4,324 2.31 2.27 157.72 241.36 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
9,945 121,824 0.08 2.26 340.06 423.85 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,596 9,999 0.46 1.04 194.34 233.94 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,509 9,999 0.45 1.02 161.64 196.93 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

  • Total Executions: 76,681,894
  • Captured SQL account for 9.6% of Total
Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
1,323,289 685,801 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
756,198 755,885 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
704,684 704,668 1.00 0.00 0.00 gnhmcahkmrnzs ap.oie.server.WebExpensesAM INSERT INTO WF_ITEM_ACTIVITY_S...
362,019 362,007 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
232,889 183,206 0.79 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
224,449 224,448 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
177,389 3,015,426 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
164,445 164,408 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
164,397 164,385 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
164,325 164,291 1.00 0.00 0.00 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

  • Total Parse Calls: 6,301,009
  • Captured SQL account for 45.0% of Total
Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
362,016 362,019 5.75 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
232,908 232,889 3.70 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
224,449 224,449 3.56 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
177,386 177,389 2.82 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
163,707 164,397 2.60 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
121,820 121,824 1.93 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
114,817 115,138 1.82 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
110,024 110,129 1.75 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
84,721 84,785 1.34 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
81,116 81,187 1.29 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
81,096 84,806 1.29 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...
81,094 81,178 1.29 bf7uwg5pa3pj6 icx.por.req.server.Requisition