|
|
|
AWR Report
WORKLOAD REPOSITORY report for
| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|
| VIS | 187584551 | VIS | 1 | 10.2.0.3.0 | NO | hpdb1.zko.hp |
| Snap Id | Snap Time | Sessions | Cursors/Session |
|---|
| Begin Snap: | 1 | 17-Apr-09 12:03:50 | 5268 | 210.3 |
| End Snap: | 2 | 17-Apr-09 13:03:54 | 5294 | 235.3 |
| Elapsed: | | 60.07 (mins) | | |
| DB Time: | | 369.01 (mins) | | |
Report Summary
Cache Sizes
| Begin | End | | |
|---|
| Buffer Cache: | 17,840M | 17,648M | Std Block Size: | 8K |
| Shared Pool Size: | 2,544M | 2,736M | Log Buffer: | 14,320K |
Load Profile
| Per Second | Per Transaction |
|---|
| Redo size: | 8,970,575.12 | 25,845.15 |
| Logical reads: | 578,414.73 | 1,666.47 |
| Block changes: | 55,995.82 | 161.33 |
| Physical reads: | 127.67 | 0.37 |
| Physical writes: | 868.27 | 2.50 |
| User calls: | 13,799.82 | 39.76 |
| Parses: | 2,572.39 | 7.41 |
| Hard parses: | 2.61 | 0.01 |
| Sorts: | 3,063.47 | 8.83 |
| Logons: | 2.83 | 0.01 |
| Executes: | 29,118.89 | 83.89 |
| Transactions: | 347.09 | |
| % Blocks changed per Read: | 9.68 | Recursive Call %: | 77.33 |
| Rollback per transaction %: | 21.19 | Rows per Sort: | 12.36 |
Instance Efficiency Percentages (Target 100%)
| Buffer Nowait %: | 99.97 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 99.98 | In-memory Sort %: | 100.00 |
| Library Hit %: | 99.78 | Soft Parse %: | 99.90 |
| Execute to Parse %: | 91.17 | Latch Hit %: | 99.08 |
| Parse CPU to Parse Elapsd %: | 91.08 | % Non-Parse CPU: | 97.77 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 86.68 | 86.85 |
| % SQL with executions>1: | 88.80 | 89.52 |
| % Memory for SQL w/exec>1: | 64.34 | 65.02 |
Top 5 Timed Events
| Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
|---|
| CPU time | | 19,953 | | 90.1 | |
| db file sequential read | 295,831 | 1,176 | 4 | 5.3 | User I/O |
| log file sync | 556,025 | 947 | 2 | 4.3 | Commit |
| log file parallel write | 866,325 | 540 | 1 | 2.4 | System I/O |
| SQL*Net more data from client | 2,573,113 | 212 | 0 | 1.0 | Network |
Main Report
Back to Top
Wait Events Statistics
Back to Top
Time Model Statistics
- Total time in database user-calls (DB Time): 22140.7s
- 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 Name | Time (s) | % of DB Time |
|---|
| DB CPU | 19,953.03 | 90.12 |
| sql execute elapsed time | 18,608.44 | 84.05 |
| PL/SQL execution elapsed time | 4,513.11 | 20.38 |
| inbound PL/SQL rpc elapsed time | 4,378.59 | 19.78 |
| parse time elapsed | 555.23 | 2.51 |
| Java execution elapsed time | 487.66 | 2.20 |
| hard parse elapsed time | 289.99 | 1.31 |
| repeated bind elapsed time | 88.35 | 0.40 |
| sequence load elapsed time | 13.33 | 0.06 |
| connection management call elapsed time | 10.05 | 0.05 |
| PL/SQL compilation elapsed time | 6.55 | 0.03 |
| hard parse (sharing criteria) elapsed time | 3.42 | 0.02 |
| failed parse elapsed time | 1.46 | 0.01 |
| hard parse (bind mismatch) elapsed time | 0.93 | 0.00 |
| DB time | 22,140.75 | |
| background elapsed time | 1,170.46 | |
| background cpu time | 333.56 | |
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 Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| User I/O | 350,784 | 0.00 | 1,318 | 4 | 0.28 |
| Commit | 556,025 | 0.00 | 947 | 2 | 0.44 |
| System I/O | 1,143,990 | 0.00 | 750 | 1 | 0.91 |
| Network | 56,709,685 | 0.00 | 280 | 0 | 45.33 |
| Concurrency | 2,031,397 | 0.17 | 170 | 0 | 1.62 |
| Application | 70,504 | 0.02 | 112 | 2 | 0.06 |
| Other | 130,873 | 19.81 | 38 | 0 | 0.10 |
| Configuration | 7,165 | 0.00 | 3 | 0 | 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)
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| db file sequential read | 295,831 | 0.00 | 1,176 | 4 | 0.24 |
| log file sync | 556,025 | 0.00 | 947 | 2 | 0.44 |
| log file parallel write | 866,325 | 0.00 | 540 | 1 | 0.69 |
| SQL*Net more data from client | 2,573,113 | 0.00 | 212 | 0 | 2.06 |
| db file parallel write | 246,771 | 0.00 | 199 | 1 | 0.20 |
| db file scattered read | 12,429 | 0.00 | 76 | 6 | 0.01 |
| read by other session | 39,515 | 0.00 | 64 | 2 | 0.03 |
| SQL*Net message to client | 52,095,478 | 0.00 | 52 | 0 | 41.64 |
| enq: UL - contention | 2,108 | 0.62 | 49 | 23 | 0.00 |
| latch: cache buffers chains | 1,300,031 | 0.00 | 48 | 0 | 1.04 |
| cursor: pin S wait on X | 3,829 | 90.36 | 38 | 10 | 0.00 |
| enq: TX - row lock contention | 687 | 0.44 | 37 | 54 | 0.00 |
| buffer busy waits | 643,254 | 0.00 | 28 | 0 | 0.51 |
| enq: TX - index contention | 27,817 | 0.00 | 22 | 1 | 0.02 |
| SQL*Net more data to client | 2,041,094 | 0.00 | 17 | 0 | 1.63 |
| SQL*Net break/reset to client | 67,672 | 0.00 | 14 | 0 | 0.05 |
| latch: In memory undo latch | 35,100 | 0.00 | 11 | 0 | 0.03 |
| library cache load lock | 539 | 0.00 | 10 | 18 | 0.00 |
| control file sequential read | 29,155 | 0.00 | 9 | 0 | 0.02 |
| PX Deq Credit: send blkd | 21,172 | 0.00 | 8 | 0 | 0.02 |
| latch: library cache | 11,556 | 0.00 | 8 | 1 | 0.01 |
| rdbms ipc reply | 5 | 60.00 | 7 | 1433 | 0.00 |
| enq: RO - fast object reuse | 32 | 0.00 | 6 | 186 | 0.00 |
| enq: TM - contention | 5 | 0.00 | 5 | 1074 | 0.00 |
| latch: undo global data | 9,378 | 0.00 | 4 | 0 | 0.01 |
| latch: object queue header operation | 21,468 | 0.00 | 3 | 0 | 0.02 |
| kksfbc child completion | 71 | 84.51 | 3 | 42 | 0.00 |
| PX Deq: Signal ACK | 253 | 37.15 | 3 | 10 | 0.00 |
| latch: library cache pin | 3,051 | 0.00 | 2 | 1 | 0.00 |
| LGWR wait for redo copy | 32,110 | 0.02 | 2 | 0 | 0.03 |
| os thread startup | 70 | 0.00 | 2 | 29 | 0.00 |
| latch: cache buffers lru chain | 2,121 | 0.00 | 2 | 1 | 0.00 |
| enq: HW - contention | 2,587 | 0.00 | 1 | 1 | 0.00 |
| local write wait | 1,773 | 0.00 | 1 | 1 | 0.00 |
| control file parallel write | 1,739 | 0.00 | 1 | 1 | 0.00 |
| latch: row cache objects | 1,064 | 0.00 | 1 | 1 | 0.00 |
| enq: TX - contention | 2,827 | 0.00 | 1 | 0 | 0.00 |
| log buffer space | 127 | 0.00 | 1 | 6 | 0.00 |
| latch free | 999 | 0.00 | 1 | 1 | 0.00 |
| buffer deadlock | 25,785 | 98.73 | 1 | 0 | 0.02 |
| library cache pin | 2,107 | 0.00 | 1 | 0 | 0.00 |
| enq: SQ - contention | 4,335 | 0.00 | 1 | 0 | 0.00 |
| latch: redo allocation | 1,071 | 0.00 | 1 | 0 | 0.00 |
| latch: session allocation | 875 | 0.00 | 0 | 1 | 0.00 |
| wait list latch free | 40 | 0.00 | 0 | 11 | 0.00 |
| row cache lock | 2,067 | 0.00 | 0 | 0 | 0.00 |
| SGA: allocation forcing component growth | 28 | 42.86 | 0 | 10 | 0.00 |
| direct path read | 732 | 0.00 | 0 | 0 | 0.00 |
| enq: DV - contention | 87 | 0.00 | 0 | 3 | 0.00 |
| latch: shared pool | 598 | 0.00 | 0 | 0 | 0.00 |
| cursor: pin S | 10,766 | 0.00 | 0 | 0 | 0.01 |
| latch: library cache lock | 193 | 0.00 | 0 | 1 | 0.00 |
| latch: object queue header heap | 291 | 0.00 | 0 | 0 | 0.00 |
| latch: cache buffer handles | 243 | 0.00 | 0 | 0 | 0.00 |
| enq: FB - contention | 650 | 0.00 | 0 | 0 | 0.00 |
| enq: TX - allocate ITL entry | 86 | 0.00 | 0 | 1 | 0.00 |
| PX qref latch | 350 | 83.43 | 0 | 0 | 0.00 |
| latch: enqueue hash chains | 20 | 0.00 | 0 | 3 | 0.00 |
| latch: messages | 143 | 0.00 | 0 | 0 | 0.00 |
| enq: CU - contention | 1 | 0.00 | 0 | 38 | 0.00 |
| library cache lock | 3 | 0.00 | 0 | 11 | 0.00 |
| L1 validation | 2 | 100.00 | 0 | 12 | 0.00 |
| reliable message | 32 | 0.00 | 0 | 1 | 0.00 |
| cursor: mutex S | 111 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 432 | 0.00 | 0 | 0 | 0.00 |
| enq: PS - contention | 51 | 0.00 | 0 | 0 | 0.00 |
| latch: checkpoint queue latch | 34 | 0.00 | 0 | 0 | 0.00 |
| latch: redo writing | 25 | 0.00 | 0 | 0 | 0.00 |
| write complete waits | 5 | 0.00 | 0 | 0 | 0.00 |
| direct path write temp | 52 | 0.00 | 0 | 0 | 0.00 |
| direct path read temp | 20 | 0.00 | 0 | 0 | 0.00 |
| cursor: mutex X | 7 | 0.00 | 0 | 0 | 0.00 |
| SQL*Net message from client | 52,095,463 | 0.00 | 10,248,458 | 197 | 41.64 |
| pipe get | 29,351 | 14.94 | 21,071 | 718 | 0.02 |
| Streams AQ: waiting for time management or cleanup tasks | 2,904 | 40.05 | 3,505 | 1207 | 0.00 |
| Streams AQ: qmn slave idle wait | 129 | 0.00 | 3,505 | 27167 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 258 | 50.00 | 3,505 | 13584 | 0.00 |
| PX Idle Wait | 1,596 | 75.69 | 2,517 | 1577 | 0.00 |
| PL/SQL lock timer | 201 | 100.00 | 2,295 | 11419 | 0.00 |
| jobq slave wait | 616 | 99.51 | 1,801 | 2923 | 0.00 |
| PX Deq: Execution Msg | 5,111 | 0.00 | 34 | 7 | 0.00 |
| PX Deq: Execute Reply | 2,779 | 0.00 | 3 | 1 | 0.00 |
| PX Deq Credit: need buffer | 5,463 | 0.00 | 1 | 0 | 0.00 |
| PX Deq: Msg Fragment | 4,424 | 0.00 | 1 | 0 | 0.00 |
| PX Deq: Table Q Normal | 6,542 | 0.00 | 0 | 0 | 0.01 |
| PX Deq: Parse Reply | 236 | 0.00 | 0 | 0 | 0.00 |
| PX Deq: Join ACK | 253 | 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)
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| log file parallel write | 866,334 | 0.00 | 540 | 1 | 0.69 |
| db file parallel write | 246,771 | 0.00 | 199 | 1 | 0.20 |
| events in waitclass Other | 41,022 | 0.01 | 4 | 0 | 0.03 |
| control file sequential read | 827 | 0.00 | 2 | 3 | 0.00 |
| db file scattered read | 525 | 0.00 | 2 | 4 | 0.00 |
| os thread startup | 62 | 0.00 | 2 | 29 | 0.00 |
| control file parallel write | 1,739 | 0.00 | 1 | 1 | 0.00 |
| db file sequential read | 209 | 0.00 | 1 | 3 | 0.00 |
| direct path read | 732 | 0.00 | 0 | 0 | 0.00 |
| latch: cache buffers chains | 92 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 333 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache | 2 | 0.00 | 0 | 2 | 0.00 |
| latch: redo writing | 25 | 0.00 | 0 | 0 | 0.00 |
| log file sync | 1 | 0.00 | 0 | 0 | 0.00 |
| latch: row cache objects | 1 | 0.00 | 0 | 0 | 0.00 |
| buffer busy waits | 8 | 0.00 | 0 | 0 | 0.00 |
| rdbms ipc message | 1,564,206 | 0.78 | 37,068 | 24 | 1.25 |
| pmon timer | 1,359 | 89.33 | 3,510 | 2583 | 0.00 |
| Streams AQ: waiting for time management or cleanup tasks | 2,904 | 40.05 | 3,505 | 1207 | 0.00 |
| Streams AQ: qmn slave idle wait | 129 | 0.00 | 3,505 | 27167 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 258 | 50.00 | 3,505 | 13584 | 0.00 |
| smon timer | 161,229 | 0.00 | 3,502 | 22 | 0.13 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics
| Statistic | Total |
|---|
| BUSY_TIME | 2,141,670 |
| IDLE_TIME | 3,625,294 |
| IOWAIT_TIME | 92,020 |
| NICE_TIME | 0 |
| SYS_TIME | 97,206 |
| USER_TIME | 1,980,807 |
| LOAD | 4 |
| RSRC_MGR_CPU_WAIT_TIME | 0 |
| PHYSICAL_MEMORY_BYTES | 46,593,552 |
| NUM_CPUS | 16 |
| NUM_CPU_SOCKETS | 4 |
Back to Wait Events Statistics
Back to Top
Service Statistics
| Service Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical Reads |
|---|
| SYS$USERS | 22,135.00 | 19,948.00 | 445,019 | 2,080,730,187 |
| SYS$BACKGROUND | 0.00 | 0.00 | 15,051 | 3,813,076 |
| 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 Name | User I/O Total Wts | User I/O Wt Time | Concurcy Total Wts | Concurcy Wt Time | Admin Total Wts | Admin Wt Time | Network Total Wts | Network Wt Time |
|---|
| SYS$USERS |
348982 | 131537 | 2031226 | 16835 | 0 | 0 | 56694236 | 28018 |
| SYS$BACKGROUND |
1801 | 289 | 165 | 183 | 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 Id | SQL Module | SQL Text |
|---|
| 708 | 694 | 305 | 2.32 | 3.20 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 446 | 404 | 112,871 | 0.00 | 2.01 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 378 | 374 | 64,056 | 0.01 | 1.71 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 372 | 366 | 57,199 | 0.01 | 1.68 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 363 | 353 | 1,451 | 0.25 | 1.64 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 347 | 342 | 57,253 | 0.01 | 1.57 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 317 | 313 | 57,253 | 0.01 | 1.43 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 316 | 314 | 375,999 | 0.00 | 1.43 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 248 | 247 | 50,456 | 0.00 | 1.12 | 6ubqcscr1gk1b |
asnDispContainer.jsp
|
select name, value from icx_s... |
| 243 | 155 | 21,638 | 0.01 | 1.10 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 228 | 95 | 2,400 | 0.10 | 1.03 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 226 | 216 | 81,155 | 0.00 | 1.02 | 3prk3vg9u0abb |
FNDOAMCOL
|
BEGIN FND_GLOBAL.APPS_INITIA... |
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 Id | SQL Module | SQL Text |
|---|
| 694 | 708 | 305 | 2.28 | 3.20 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 404 | 446 | 112,871 | 0.00 | 2.01 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 374 | 378 | 64,056 | 0.01 | 1.71 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 366 | 372 | 57,199 | 0.01 | 1.68 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 353 | 363 | 1,451 | 0.24 | 1.64 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 342 | 347 | 57,253 | 0.01 | 1.57 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 314 | 316 | 375,999 | 0.00 | 1.43 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 313 | 317 | 57,253 | 0.01 | 1.43 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 247 | 248 | 50,456 | 0.00 | 1.12 | 6ubqcscr1gk1b |
asnDispContainer.jsp
|
select name, value from icx_s... |
| 216 | 226 | 81,155 | 0.00 | 1.02 | 3prk3vg9u0abb |
FNDOAMCOL
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 155 | 243 | 21,638 | 0.01 | 1.10 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 95 | 228 | 2,400 | 0.04 | 1.03 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
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,084,681,865
- Captured SQL account for 10.8% of Total
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 51,621,475 | 157,197 | 328.39 | 2.48 | 144.61 | 146.13 | 5kqw5535fjvw6 |
ARXTWMAI
|
SELECT NVL(RCTT.ATTRIBUTE10, ... |
| 47,417,249 | 57,199 | 828.99 | 2.27 | 365.73 | 371.57 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 44,828,497 | 64,056 | 699.83 | 2.15 | 373.62 | 378.48 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 44,346,595 | 305 | 145,398.67 | 2.13 | 693.90 | 707.77 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 41,083,538 | 1,451 | 28,313.95 | 1.97 | 352.67 | 362.53 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 38,288,263 | 57,253 | 668.76 | 1.84 | 313.41 | 316.59 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 31,798,640 | 1,583,829 | 20.08 | 1.53 | 111.73 | 113.20 | 66tmsr3446uqn |
ap.oie.server.WebExpensesAM
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 30,368,144 | 57,253 | 530.42 | 1.46 | 342.47 | 346.87 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 30,072,957 | 174,003 | 172.83 | 1.44 | 160.78 | 164.61 | 3b3psftuyks81 |
INVTTMTX
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 30,068,228 | 173,998 | 172.81 | 1.44 | 149.70 | 153.47 | gf1u933c95jb5 |
INVTTMTX
|
DECLARE
l_ret_stat varchar2... |
| 26,397,356 | 10,000 | 2,639.74 | 1.27 | 75.64 | 168.31 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 25,942,712 | 202,488 | 128.12 | 1.24 | 190.71 | 220.41 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 24,624,453 | 50,456 | 488.04 | 1.18 | 246.58 | 247.63 | 6ubqcscr1gk1b |
asnDispContainer.jsp
|
select name, value from icx_s... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- Total Disk Reads: 460,138
- Captured SQL account for 27.9% of Total
| Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 45,240 | 10,000 | 4.52 | 9.83 | 75.64 | 168.31 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 39,413 | 2,400 | 16.42 | 8.57 | 13.42 | 177.61 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 37,227 | 2,400 | 15.51 | 8.09 | 95.45 | 228.20 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 23,413 | 21,638 | 1.08 | 5.09 | 154.71 | 243.26 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 11,883 | 722 | 16.46 | 2.58 | 81.22 | 125.64 | dk0sqcvc2xjvs |
qotSCopHdrUpd.jsp
|
BEGIN ASO_QUOTE_PUB_W.Create_Q... |
| 9,770 | 7,210 | 1.36 | 2.12 | 110.18 | 154.92 | 8jb36w62w5hqf |
ibuSRDetailsActions.jsp
|
BEGIN IBU_REQ_PKG.UpdateServic... |
| 9,739 | 202,488 | 0.05 | 2.12 | 190.71 | 220.41 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 4,594 | 10,000 | 0.46 | 1.00 | 119.24 | 131.22 | csvvv0fmhr1yc |
PYUSLV
|
BEGIN
FFP1893_01010001.FORMULA... |
| 4,512 | 10,000 | 0.45 | 0.98 | 98.03 | 107.48 | 63t8zpm02skgh |
PYUSLV
|
SELECT DECODE(COUNT(PRR.RUN_RE... |
| 1,497 | 100,946 | 0.01 | 0.33 | 113.47 | 117.64 | 7dtkxnqpkqszw |
jtfavald.jsp
|
SELECT DISTINCT a.PERMISSION_... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 104,948,247
- Captured SQL account for 7.7% of Total
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 1,583,829 | 818,530 | 0.52 | 0.00 | 0.00 | 66tmsr3446uqn |
ap.oie.server.WebExpensesAM
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 895,548 | 895,548 | 1.00 | 0.00 | 0.00 | cd9mbmqyf4qhp |
ap.oie.server.WebExpensesAM
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 596,391 | 596,384 | 1.00 | 0.00 | 0.00 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 464,100 | 464,047 | 1.00 | 0.00 | 0.00 | 821fx90awyvj7 |
OEXOETEL
|
SELECT ACCOUNTING_RULE_ID , A... |
| 375,999 | 375,998 | 1.00 | 0.00 | 0.00 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 344,477 | 263,219 | 0.76 | 0.00 | 0.00 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 291,050 | 4,947,762 | 17.00 | 0.00 | 0.00 | cwyx16zn1hpfb |
JDBC Thin Client
|
select parameter, value from ... |
| 202,488 | 202,483 | 1.00 | 0.00 | 0.00 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 174,004 | 174,004 | 1.00 | 0.00 | 0.00 | 6gnth2mfbs2nq |
INVTTMTX
|
declare
v_ret number := 0... |
| 174,003 | 174,003 | 1.00 | 0.00 | 0.00 | 3b3psftuyks81 |
INVTTMTX
|
BEGIN INV_TXNSTUB_PUB.postTran... |
Back to SQL Statistics
Back to Top
SQL ordered by Parse Calls
- Total Parse Calls: 9,271,216
- Captured SQL account for 42.3% of Total
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 596,391 | 596,391 | 6.43 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 375,989 | 375,999 | 4.06 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 344,486 | 344,477 | 3.72 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 291,050 | 291,050 | 3.14 | cwyx16zn1hpfb |
JDBC Thin Client
|
select parameter, value from ... |
| 202,492 | 202,488 | 2.18 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 174,005 | 174,004 | 1.88 | 6gnth2mfbs2nq |
INVTTMTX
|
declare
v_ret number := 0... |
| 125,263 | 125,262 | 1.35 | fb13x9qx0ftks |
OEXOETEL
|
begin OE_STANDARD_WF.OEOL_SELE... |
| 120,370 | 120,370 | 1.30 | 162ttnv4ubqun |
OEXOETEL
|
begin OE_DS_PVT.Check_PO_Appr... |
| 116,805 | 116,805 | 1.26 | 1c0b7sas42w2z |
INVTTMTX
|
SELECT NVL(ITEM_COST, 0), ... |
| 111,365 | 111,365 | 1.20 | 8camsgjsr9zya |
OEXOETEL
|
begin OE_TRANSACTION_TYPES_PK... |
| 101,455 | 101,455 | 1.09 | 76sw2a4vnc89j |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.S... |
| 95,425 | 95,423 | 1.03 | 608c0n36kaw62 |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.C... |
| 95,425 | 95,419 | 1.03 | bf7uwg5pa3pj6 |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.V... |
| 95,425 | 101,452 | 1.03 | dcvv68fju01g4 |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.E... |
Back to SQL Statistics
Back to Top
SQL ordered by Sharable Memory
- Only Statements with Sharable Memory greater than 1048576 are displayed
| Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
|---|
| 1,260,735 | 20,915 | 0.04 | 8q8zmrwmrccz4 |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(adj ... |
Back to SQL Statistics
Back to Top
|
SQL ordered by Version Count
No data exists for this section of the report.
Back to SQL Statistics
Back to Top
Complete List of SQL Text
| SQL Id | SQL Text |
|---|
| 0z318y6g3uagc | declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ; |
| 162ttnv4ubqun | begin OE_DS_PVT.Check_PO_Approved( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end; |
| 1c0b7sas42w2z | SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3 |
| 1q78dwnrrkf6c | BEGIN ASN_SALES_PVT.Lead_Process_After_Update( P_Api_Version_Number => 2.0, P_Init_Msg_List => FND_API.G_TRUE, p_Commit => FND_API.G_FALSE, p_Validation_Level => FND_API.G_VALID_LEVEL_NONE, P_Identity_Salesforce_Id => :1, P_Salesgroup_id => :2, P_Sales_Lead_Id => :3, X_Return_Status => :4, X_Msg_Count => :5, X_Msg_Data => :6); END; |
| 3b3psftuyks81 | BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END; |
| 3dssuqfjsynrk |
SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_
id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) ) |
| 3prk3vg9u0abb | BEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END; |
| 4yak7x2zqz0dh | BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END; |
| 5kqw5535fjvw6 | SELECT NVL(RCTT.ATTRIBUTE10, ' ') FROM RA_CUST_TRX_TYPES_ALL RCTT, RA_CUSTOMER_TRX_ALL RCT WHERE RCT.CUSTOMER_TRX_ID = :B1 AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID |
| 608c0n36kaw62 | begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end; |
| 63t8zpm02skgh | SELECT DECODE(COUNT(PRR.RUN_RESULT_ID), 0, 'N', 'Y') FROM PAY_RUN_RESULTS PRR, PAY_ASSIGNMENT_ACTIONS ASA, PAY_PAYROLL_ACTIONS PPA WHERE PRR.SOURCE_ID = :B3 AND PRR.SOURCE_TYPE IN ('E', 'I') AND PRR.STATUS IN ('P', 'PA', 'R', 'O') AND ASA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PPA.PAYROLL_ACTION_ID = ASA.PAYROLL_ACTION_ID AND NOT EXISTS (SELECT NULL FROM PAY_RUN_RESULTS PRR2 WHERE PRR2.SOURCE_ID = PRR.RUN_RESULT_ID AND PRR2.SOURCE_TYPE IN ('R', 'V')) AND PPA.DATE_EARNED BETWEEN :B2 AND :B1 |
| 64qc329wgjv39 |
select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char
(PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc |
| 66tmsr3446uqn | SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1 |
| 6gnth2mfbs2nq | declare
v_ret number := 0;
begin
if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) )
then
v_ret := 1;
end if;
:8 := v_ret;
end;
|
| 6h2tpcxpymqu7 | BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END; |
| 6ubqcscr1gk1b | select name, value from icx_session_attributes where session_id = :1 |
| 76sw2a4vnc89j | begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end; |
| 7dtkxnqpkqszw | SELECT DISTINCT a.PERMISSION_NAME, dom.DOMAIN_NAME, a.MAINTENANCE_MODE_FLAG FROM JTF_AUTH_PERMISSIONS_B A, JTF_AUTH_PRINCIPAL_MAPS B, JTF_AUTH_ROLE_PERMS C, JTF_AUTH_PRINCIPALS_B D, JTF_AUTH_PRINCIPALS_B E, JTF_AUTH_DOMAINS_B dom WHERE D.PRINCIPAL_NAME = :1 AND D.IS_USER_FLAG = 1 AND D.JTF_AUTH_PRINCIPAL_ID = B.JTF_AUTH_PRINCIPAL_ID AND B.JTF_AUTH_PARENT_PRINCIPAL_ID=E.JTF_AUTH_PRINCIPAL_ID AND E.IS_USER_FLAG = 0 AND E.JTF_AUTH_PRINCIPAL_ID = C.JTF_AUTH_PRINCIPAL_ID AND C.JTF_AUTH_PERMISSION_ID = A.JTF_AUTH_PERMISSION_ID AND C.POSITIVE_FLAG=1 AND B.JTF_AUTH_DOMAIN_ID = dom.JTF_AUTH_DOMAIN_ID ORDER BY A.PERMISSION_NAME |
| 821fx90awyvj7 |
SELECT ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOOKED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOB
AL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LAT
EST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST_CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , REFERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHED
ULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE_TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRIBUTE8 , TP_ATTRIBUTE9 ,
TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , ORDER_SOURCE_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , CHANGE_SEQUENCE , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1 |
| 827gtfny5uagb | begin :con := FND_GENERIC_POLICY.GET_PREDICATE(:sn, :on); end; |
| 8c8cf4vtv4tx2 |
SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_id = hp.party_id (+)
AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) |
| 8camsgjsr9zya | begin OE_TRANSACTION_TYPES_PKG.Val_Ord_Change( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end; |
| 8jb36w62w5hqf | BEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END; |
| 8q8zmrwmrccz4 |
SELECT /*+ ORDERED USE_NL(adj qplh) */ ADJ.LIST_LINE_ID CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , ADJ.PRICE_ADJUSTMENT_ID LINE_DETAIL_INDEX , ADJ.LIST_LINE_TYPE_CODE CREATED_FROM_LIST_LINE_TYPE , ADJ.LIST_HEADER_ID CREATED_FROM_LIST_HEADER_ID , ADJ.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , ADJ.RANGE_BREAK_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , ADJ.AUTOMATIC_FLAG , ADJ.UPDATE_ALLOWED OVERRIDE_FLAG , ADJ.PRICING_GROUP_SEQUENCE , ADJ.ARITHMETIC_OPERATOR OPERAND_CALCULATION_CODE , NVL(ADJ.OPERAND_PER_PQTY, ADJ.OPERAND) OPERAND_VALUE , ADJ.ADJUSTED_AMOUNT_PER_PQTY ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , ADJ.ACCRUAL_FLAG , NVL(ADJ.UPDATED_FLAG, :B16 ) , 'N' PROCESS_CODE , 'N' PRICING_STATUS_CODE , ' ' PRICING_STATUS_TEXT , ADJ.PRICE_BREAK_TYPE_CODE , ADJ.CHARGE_TYPE_CODE , ADJ.CHARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , ADJ.PRICING_PHASE_ID , '' CREATED_FROM_LIST_TYPE_CODE , '' LIMIT_CODE , '' LIMIT_TEXT , ADJ.LIST_LINE_NO , ADJ.MODIFIER_LEVEL_CODE , ADJ.RANGE_BREAK_QUANTITY GROUP_QUANTITY , ADJ.RANGE_BREAK_QUANTITY GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B15 IS_LDET_REC , LINE.LINE_TYPE_CODE , NULL NET_AMOUNT_FLAG , NULL CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LI
NE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , NULL LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE, OE_PRICE_ADJUSTMENTS ADJ, QP_LIST_HEADERS_B QPLH WHERE :B14 = :B7 AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND ADJ.LINE_ID = LINE.LINE_ID AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LINE.LINE_TYPE_CODE = :B4 AND LINE.UNIT_PRICE IS NOT NULL AND (ADJ.UPDATED_FLAG = :B7 OR LINE.PRICE_FLAG = :B6 OR (:B5 IS NULL AND ADJ.UPDATED_FLAG IS NULL) OR ADJ.PRICING_PHASE_ID NOT IN (SELECT PH.PRICING_PHASE_ID FROM QP_EVENT_PHASES EV, QP_PRICING_PHASES PH WHERE PH.PRICING_PHASE_ID = EV.PRICING_PHASE_ID AND (EV.END_DATE_ACTIVE IS NULL OR (EV.END_DATE_ACTIVE IS NOT NULL AND EV.END_DATE_ACTIVE > LINE.PRICING_EFFECTIVE_DATE)) AND ((:B17 = :B7 AND PH.FREIGHT_EXISTS = :B7 ) OR (:B17 = :B16 )) AND INSTR(:B5 , EV.PRICING_EVENT_CODE||', ') > 0 AND (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(ADJ.LIST_LINE_ID, LINE.LINE_INDEX), LINE.PRICE_FLAG) = :B7 OR (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(ADJ.LIST_LINE_ID, LINE.LINE_INDEX), LINE.PRICE_FLAG) = :B9 AND NVL(PH.USER_FREEZE_OVERRIDE_FLAG, PH.FREEZE_OVERRIDE_FLAG) = :B7 )))) AND ADJ.MODIFIER_LEVEL_CODE IN (:B4 , :B3 ) AND QPLH.LIST_HEADER_ID = ADJ.LIST_HEADER_ID AND QPLH.LIST_TYPE_CODE NOT IN (:B2 , :B1 ) AND NOT EXISTS (SELECT 'x' FROM OE_PRICE_ADJ_ASSOCS A, O
E_PRICE_ADJUSTMENTS B WHERE A.RLTD_PRICE_ADJ_ID = ADJ.PRICE_ADJUSTMENT_ID AND B.PRICE_ADJUSTMENT_ID = A.PRICE_ADJUSTMENT_ID AND B.LIST_LINE_TYPE_CODE = :B18 ) UNION SELECT /*+ ORDERED USE_NL(adj line qplh) */ ADJ.LIST_LINE_ID CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , ADJ.PRICE_ADJUSTMENT_ID LINE_DETAIL_INDEX , ADJ.LIST_LINE_TYPE_CODE CREATED_FROM_LIST_LINE_TYPE , ADJ.LIST_HEADER_ID CREATED_FROM_LIST_HEADER_ID , ADJ.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , ADJ.RANGE_BREAK_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , ADJ.AUTOMATIC_FLAG , ADJ.UPDATE_ALLOWED OVERRIDE_FLAG , ADJ.PRICING_GROUP_SEQUENCE , ADJ.ARITHMETIC_OPERATOR OPERAND_CALCULATION_CODE , NVL(ADJ.OPERAND_PER_PQTY, ADJ.OPERAND) OPERAND_VALUE , ADJ.ADJUSTED_AMOUNT_PER_PQTY ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , ADJ.ACCRUAL_FLAG , NVL(ADJ.UPDATED_FLAG, :B16 ) , 'N' PROCESS_CODE , 'N' PRICING_STATUS_CODE , ' ' PRICING_STATUS_TEXT , ADJ.PRICE_BREAK_TYPE_CODE , ADJ.CHARGE_TYPE_CODE , ADJ.CHARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , ADJ.PRICING_PHASE_ID , '' CREATED_FROM_LIST_TYPE_CODE , '' LIMIT_CODE , '' LIMIT_TEXT , ADJ.LIST_LINE_NO , ADJ.MODIFIER_LEVEL_CODE , ADJ.RANGE_BREAK_QUANTITY GROUP_QUANTITY , ADJ.RANGE_BREAK_QUANTITY GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICI
NG_STATUS_CODE , :B20 IS_LDET_REC , LINE.LINE_TYPE_CODE , NULL NET_AMOUNT_FLAG , NULL CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , NULL LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE1, OE_PRICE_ADJUSTMENTS ADJ , QP_NPREQ_LINES_TMP LINE, QP_LIST_HEADERS_B QPLH WHERE :B14 = :B7 AND LINE1.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE1.LINE_ID = ADJ.HEADER_ID AND LINE1.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE1.LINE_TYPE_CODE = :B19 AND (LINE1.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE1.PROCESSED_CODE, '0') = :B8 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND (LINE.UNIT_PRICE IS NOT NULL OR LINE.LINE_TYPE_CODE = :B19 ) AND (ADJ.UPDATED_FLAG = :B7 OR LINE.PRICE_FLAG = :B6 OR (:B5 IS NULL AND ADJ.UPDATED_FLAG IS NULL) OR ADJ.PRICING_PHASE_ID NOT IN (SELECT PH.PRICING_PHASE_ID FROM QP_EVENT_PHASES EV, QP_PRICING_PHASES PH WHERE PH.PRICING_PHASE_ID = EV.PRICING_PHASE_ID AND (EV.END_DATE_ACTIVE IS NULL OR (EV.END_DATE_ACTIVE IS NOT NULL AND EV.END_DATE_ACTIVE > LINE.PRICING_EFFECTIVE_DATE)) AND ((:B17 = :B7 AND PH.FREIGHT_EXISTS = :B7 ) OR (:B17 = :B16 )) AND INSTR(:B5 , EV.PRICING_EVENT_CODE||', ') > 0 AND (NVL(QP_
PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(ADJ.LIST_LINE_ID, LINE1.LINE_INDEX), LINE1.PRICE_FLAG) = :B7 OR (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(ADJ.LIST_LINE_ID, LINE1.LINE_INDEX), LINE1.PRICE_FLAG) = :B9 AND NVL(PH.USER_FREEZE_OVERRIDE_FLAG, PH.FREEZE_OVERRIDE_FLAG) = :B7 )))) AND ADJ.MODIFIER_LEVEL_CODE = :B19 AND ADJ.LINE_ID IS NULL AND QPLH.LIST_HEADER_ID = ADJ.LIST_HEADER_ID AND QPLH.LIST_TYPE_CODE NOT IN (:B2 , :B1 ) UNION SELECT /*+ ORDERED USE_NL(ldet) */ LDET.CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , LDET.LINE_DETAIL_INDEX , LDET.CREATED_FROM_LIST_LINE_TYPE , LDET.CREATED_FROM_LIST_HEADER_ID , LDET.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , LDET.LINE_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , LDET.AUTOMATIC_FLAG , LDET.OVERRIDE_FLAG , LDET.PRICING_GROUP_SEQUENCE , LDET.OPERAND_CALCULATION_CODE , LDET.OPERAND_VALUE , LDET.ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , LDET.ACCRUAL_FLAG , NVL(LDET.UPDATED_FLAG, :B16 ) , LDET.PROCESS_CODE , LDET.PRICING_STATUS_CODE , LDET.PRICING_STATUS_TEXT , LDET.PRICE_BREAK_TYPE_CODE , LDET.CHARGE_TYPE_CODE , LDET.CHARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , LDET.PRICING_PHASE_ID , LDET.CREATED_FROM_LIST_TYPE_CODE , LDET.LIMIT_CODE , SUBSTR(LDET.LIMIT_TEXT, 1, 240) , LDET.LIST_LINE_NO , LDET.MODIFIER_LE
VEL_CODE , LDET.GROUP_QUANTITY GROUP_QUANTITY , LDET.GROUP_AMOUNT GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B23 IS_LDET_REC , LINE.LINE_TYPE_CODE , LDET.NET_AMOUNT_FLAG NET_AMOUNT_FLAG , LDET.CALCULATION_CODE CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , LDET.LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE, QP_NPREQ_LDETS_TMP LDET WHERE LINE.LINE_INDEX = LDET.LINE_INDEX AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LINE.LINE_TYPE_CODE = :B4 AND LINE.UNIT_PRICE IS NOT NULL AND LDET.PRICING_STATUS_CODE IN (:B13 , :B12 ) AND (LDET.APPLIED_FLAG = :B7 OR (LDET.APPLIED_FLAG = :B16 AND LDET.CREATED_FROM_LIST_LINE_TYPE = :B22 AND LDET.AUTOMATIC_FLAG = :B16 )) AND LDET.CREATED_FROM_LIST_TYPE_CODE NOT IN (:B2 , :B1 ) AND LDET.MODIFIER_LEVEL_CODE IN (:B4 , :B3 ) AND NVL(LDET.LINE_DETAIL_TYPE_CODE, 'NULL') <> :B21 UNION SELECT /*+ ORDERED USE_NL(ldet line) */ LDET.CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , LDET.LINE_DETAIL_INDEX , LDET.CREATED_FROM_LIST_LINE_TYPE , LDET.CREATED_FROM_LIST_HEADER_ID , LDET.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE -
LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , LDET.LINE_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , LDET.AUTOMATIC_FLAG , LDET.OVERRIDE_FLAG , LDET.PRICING_GROUP_SEQUENCE , LDET.OPERAND_CALCULATION_CODE , LDET.OPERAND_VALUE , LDET.ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , LDET.ACCRUAL_FLAG , NVL(LDET.UPDATED_FLAG, :B16 ) , LDET.PROCESS_CODE , LDET.PRICING_STATUS_CODE , LDET.PRICING_STATUS_TEXT , LDET.PRICE_BREAK_TYPE_CODE , LDET.CHARGE_TYPE_CODE , LDET.CHARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , LDET.PRICING_PHASE_ID , LDET.CREATED_FROM_LIST_TYPE_CODE , LDET.LIMIT_CODE , SUBSTR(LDET.LIMIT_TEXT, 1, 240) , LDET.LIST_LINE_NO , LDET.MODIFIER_LEVEL_CODE , LDET.GROUP_QUANTITY GROUP_QUANTITY , LDET.GROUP_AMOUNT GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B24 IS_LDET_REC , LINE.LINE_TYPE_CODE , LDET.NET_AMOUNT_FLAG NET_AMOUNT_FLAG , LDET.CALCULATION_CODE CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , LDET.LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE1, QP_NPREQ_LDETS_TMP LDET , QP_NPREQ_LINES_TMP LINE WHERE LDET.LINE_INDEX = LINE1.LINE_INDEX AND LINE1.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD
'||:B10 ) AND LINE1.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE1.PRICE_FLAG IN (:B7 , :B9 ) AND LINE1.LINE_TYPE_CODE = :B19 AND (LINE.UNIT_PRICE IS NOT NULL OR LINE.LINE_TYPE_CODE = :B19 ) AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LDET.PRICING_STATUS_CODE IN (:B13 , :B12 ) AND (LDET.APPLIED_FLAG = :B7 OR (LDET.APPLIED_FLAG = :B16 AND LDET.CREATED_FROM_LIST_LINE_TYPE = :B22 AND LDET.AUTOMATIC_FLAG = :B16 )) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LDET.MODIFIER_LEVEL_CODE = :B19 AND LDET.CREATED_FROM_LIST_TYPE_CODE NOT IN (:B2 , :B1 ) UNION SELECT /*+ ORDERED USE_NL(ldet qplh) */ LDET.CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , LDET.LINE_DETAIL_INDEX , LDET.CREATED_FROM_LIST_LINE_TYPE , LDET.CREATED_FROM_LIST_HEADER_ID , LDET.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , LDET.LINE_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , LDET.AUTOMATIC_FLAG , LDET.OVERRIDE_FLAG , LDET.PRICING_GROUP_SEQUENCE , LDET.OPERAND_CALCULATION_CODE , LDET.OPERAND_VALUE , LDET.ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , LDET.ACCRUAL_FLAG , NVL(LDET.UPDATED_FLAG, :B16 ) , LDET.PROCESS_CODE , LDET.PRICING_STATUS_CODE , LDET.PRICING_STATUS_TEXT , LDET.PRICE_BREAK_TYPE_CODE , LDET.CHARGE_TYPE_CODE , LDET.CH
ARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , LDET.PRICING_PHASE_ID , LDET.CREATED_FROM_LIST_TYPE_CODE , LDET.LIMIT_CODE , SUBSTR(LDET.LIMIT_TEXT, 1, 240) , LDET.LIST_LINE_NO , LDET.MODIFIER_LEVEL_CODE , LDET.GROUP_QUANTITY GROUP_QUANTITY , LDET.GROUP_AMOUNT GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B25 IS_LDET_REC , LINE.LINE_TYPE_CODE , LDET.NET_AMOUNT_FLAG NET_AMOUNT_FLAG , LDET.CALCULATION_CODE CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , LDET.LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE, QP_NPREQ_LDETS_TMP LDET, QP_LIST_HEADERS_B QPLH WHERE NVL(:B14 , :B16 ) <> :B7 AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LINE.LINE_TYPE_CODE = :B4 AND LINE.UNIT_PRICE IS NOT NULL AND LDET.LINE_INDEX = LINE.LINE_INDEX AND LDET.PRICING_STATUS_CODE = :B10 AND (LDET.UPDATED_FLAG = :B7 OR LINE.PRICE_FLAG = :B6 OR LDET.PRICING_PHASE_ID NOT IN (SELECT PH.PRICING_PHASE_ID FROM QP_EVENT_PHASES EV, QP_PRICING_PHASES PH WHERE PH.PRICING_PHASE_ID = EV.PRICING_PHASE_ID AND (EV.END_DATE_ACTIVE IS NULL OR (EV.END_DATE_ACTIVE IS NOT NULL AND EV.END_DATE_ACTIVE > LINE.PRICING_EFFECTIVE_DATE)) AND ((:B17 = :B7 AND PH.FREIGHT
_EXISTS = :B7 ) OR (:B17 = :B16 )) AND INSTR(:B5 , EV.PRICING_EVENT_CODE||', ') > 0 AND (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(LDET.CREATED_FROM_LIST_LINE_ID, LINE.LINE_INDEX), LINE.PRICE_FLAG) = :B7 OR (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(LDET.CREATED_FROM_LIST_LINE_ID, LINE.LINE_INDEX), LINE.PRICE_FLAG) = :B9 AND NVL(PH.USER_FREEZE_OVERRIDE_FLAG, PH.FREEZE_OVERRIDE_FLAG) = :B7 )))) AND LDET.MODIFIER_LEVEL_CODE IN (:B4 , :B3 ) AND QPLH.LIST_HEADER_ID = LDET.CREATED_FROM_LIST_HEADER_ID AND QPLH.LIST_TYPE_CODE NOT IN (:B2 , :B1 ) AND NVL(LDET.LINE_DETAIL_TYPE_CODE, 'NULL') <> :B21 UNION SELECT /*+ ORDERED USE_NL(ldet line qplh) */ LDET.CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , LDET.LINE_DETAIL_INDEX , LDET.CREATED_FROM_LIST_LINE_TYPE , LDET.CREATED_FROM_LIST_HEADER_ID , LDET.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , LDET.LINE_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , LDET.AUTOMATIC_FLAG , LDET.OVERRIDE_FLAG , LDET.PRICING_GROUP_SEQUENCE , LDET.OPERAND_CALCULATION_CODE , LDET.OPERAND_VALUE , LDET.ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , LDET.ACCRUAL_FLAG , NVL(LDET.UPDATED_FLAG, :B16 ) , LDET.PROCESS_CODE , LDET.PRICING_STATUS_CODE , LDET.PRICING_STATUS_TEXT , LDET.PRICE_BREAK_TYPE_CODE , LDET.CHARGE_TYPE_CODE , LDET.CHARGE_SU
BTYPE_CODE , LINE.ROUNDING_FACTOR , LDET.PRICING_PHASE_ID , LDET.CREATED_FROM_LIST_TYPE_CODE , LDET.LIMIT_CODE , SUBSTR(LDET.LIMIT_TEXT, 1, 240) , LDET.LIST_LINE_NO , LDET.MODIFIER_LEVEL_CODE , LDET.GROUP_QUANTITY GROUP_QUANTITY , LDET.GROUP_AMOUNT GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B26 IS_LDET_REC , LINE.LINE_TYPE_CODE , LDET.NET_AMOUNT_FLAG NET_AMOUNT_FLAG , LDET.CALCULATION_CODE CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , LDET.LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE1, QP_NPREQ_LDETS_TMP LDET , QP_NPREQ_LINES_TMP LINE, QP_LIST_HEADERS_B QPLH WHERE NVL(:B14 , :B16 ) <> :B7 AND LINE1.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE1.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE1.LINE_TYPE_CODE = :B19 AND (LINE1.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE1.PROCESSED_CODE, '0') = :B8 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND (LINE.UNIT_PRICE IS NOT NULL OR LINE.LINE_TYPE_CODE = :B19 ) AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE1.LINE_INDEX = LDET.LINE_INDEX AND LDET.PRICING_STATUS_CODE = :B10 AND (LDET.UPDATED_FLAG = :B7 OR LINE.PRICE_FLAG = :B6 OR LDET.PRICING_PHASE_ID NOT I
N (SELECT PH.PRICING_PHASE_ID FROM QP_EVENT_PHASES EV, QP_PRICING_PHASES PH WHERE PH.PRICING_PHASE_ID = EV.PRICING_PHASE_ID AND (EV.END_DATE_ACTIVE IS NULL OR (EV.END_DATE_ACTIVE IS NOT NULL AND EV.END_DATE_ACTIVE > LINE.PRICING_EFFECTIVE_DATE)) AND ((:B17 = :B7 AND PH.FREIGHT_EXISTS = :B7 ) OR (:B17 = :B16 )) AND INSTR(:B5 , EV.PRICING_EVENT_CODE||', ') > 0 AND (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(LDET.CREATED_FROM_LIST_LINE_ID, LINE1.LINE_INDEX), LINE1.PRICE_FLAG) = :B7 OR (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(LDET.CREATED_FROM_LIST_LINE_ID, LINE1.LINE_INDEX), LINE1.PRICE_FLAG) = :B9 AND NVL(PH.USER_FREEZE_OVERRIDE_FLAG, PH.FREEZE_OVERRIDE_FLAG) = :B7 )))) AND LDET.MODIFIER_LEVEL_CODE = :B19 AND QPLH.LIST_HEADER_ID = LDET.CREATED_FROM_LIST_HEADER_ID AND QPLH.LIST_TYPE_CODE NOT IN (:B2 , :B1 ) ORDER BY PRICING_GROUP_SEQUENCE, LINE_IND, IS_LDET_REC |
| 9wdrypwkpf607 | begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end; |
| a29grr748ghc4 | BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END; |
| avc1jqzz04wpr | SELECT 'x' FROM DUAL |
| bf7uwg5pa3pj6 | begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end; |
| bt0w082dfrm8v | BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END; |
| cd9mbmqyf4qhp | UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1 |
| csvvv0fmhr1yc | BEGIN
FFP1893_01010001.FORMULA(
:N1,
:N4,
:T1,
:I1,
:D1,
:T2,
:I2,
:T7,
:I7,
:T8,
:I8,
:T5,
:I5,
:N3,
:T4,
:I4,
:N2,
:N5,
:T3,
:I3,
:T6,
:I6,
:FFERLN, :FFERCD, :FFERMT);
END; |
| cwyx16zn1hpfb | select parameter, value from nls_session_parameters |
| dcvv68fju01g4 | begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end; |
| dk0sqcvc2xjvs | BEGIN ASO_QUOTE_PUB_W.Create_Qte_Opportunity(:1, :2, :3, :4, :5, :6, p_c_auto_version_flag => :7, p_c_pricing_request_type => :8, p_c_header_pricing_event => :9, p_c_cal_tax_flag => :10, p_c_cal_freight_charge_flag => :11, p_c_copy_task_flag => :12, p_c_copy_notes_flag => :13, p_c_copy_att_flag => :14, p_c_deactivate_all => :15, p_c_price_mode => :16, p_source_code => :17, p_op_opportunity_id => :18, p_op_quote_name => :19, p_op_cust_account_id => :20, p_op_resource_id => :21, p_op_sold_to_contact_id => :22, p_op_sold_to_party_site_id => :23, p_op_price_list_id => :24, p_op_resource_grp_id => :25, p_op_channel_code => :26, p_op_order_type_id => :27, p_op_agreement_id => :28, p_op_currency_code => :29, p_op_marketing_source_code_id => :30, p_op_quote_expiration_date => :31, p_op_cust_party_id => :32, p_op_pricing_status_indicator => :33, p_op_tax_status_indicator => :34, x_return_status => :35, x_msg_count => :36, x_msg_data => :37 ); END; |
| fb13x9qx0ftks | begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end; |
| fmfdkztk8vx23 | SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1 |
| g8102j8yynbwz | begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end; |
| gf1u933c95jb5 | DECLARE
l_ret_stat varchar2(56);
BEGIN
CSI_INV_TXN_HOOK_PKG.postTransaction(
p_header_id => :1 ,
p_transaction_id => :2 ,
x_return_status => l_ret_stat );
INV_TXNSTUB_PUB.g_ret_status := l_ret_stat;
END; |
| gksvm8wmzk8w0 | begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end; |
Back to SQL Statistics
Back to Top
Instance Activity Statistics
Back to Top
Instance Activity Stats
| Statistic | Total | per Second | per Trans |
|---|
| CPU used by this session | 1,965,757 | 545.42 | 1.57 |
| CPU used when call started | 1,961,370 | 544.20 | 1.57 |
| CR blocks created | 16,728,253 | 4,641.41 | 13.37 |
| Cached Commit SCN referenced | 47,660 | 13.22 | 0.04 |
| Commit SCN cached | 8 | 0.00 | 0.00 |
| DB time | 4,933,746 | 1,368.91 | 3.94 |
| DBWR checkpoint buffers written | 3,039,276 | 843.28 | 2.43 |
| DBWR checkpoints | 34 | 0.01 | 0.00 |
| DBWR object drop buffers written | 57,852 | 16.05 | 0.05 |
| DBWR revisited being-written buffer | 193 | 0.05 | 0.00 |
| DBWR thread checkpoint buffers written | 546,983 | 151.77 | 0.44 |
| DBWR transaction table writes | 2,465 | 0.68 | 0.00 |
| DBWR undo block writes | 1,624,318 | 450.68 | 1.30 |
| DFO trees parallelized | 48 | 0.01 | 0.00 |
| IMU CR rollbacks | 43,897,258 | 12,179.71 | 35.09 |
| IMU Flushes | 358,822 | 99.56 | 0.29 |
| IMU Redo allocation size | 2,416,474,080 | 670,473.62 | 1,931.70 |
| IMU commits | 647,513 | 179.66 | 0.52 |
| IMU contention | 38,799 | 10.77 | 0.03 |
| IMU ktichg flush | 11,553 | 3.21 | 0.01 |
| IMU pool not allocated | 0 | 0.00 | 0.00 |
| IMU recursive-transaction flush | 1,788 | 0.50 | 0.00 |
| IMU undo allocation size | 5,804,228,536 | 1,610,438.17 | 4,639.84 |
| IMU- failed to get a private strand | 0 | 0.00 | 0.00 |
| PX local messages recv'd | 52,797 | 14.65 | 0.04 |
| PX local messages sent | 52,797 | 14.65 | 0.04 |
| Parallel operations downgraded 25 to 50 pct | 40 | 0.01 | 0.00 |
| Parallel operations not downgraded | 8 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 52,091,032 | 14,453.15 | 41.64 |
| active txn count during cleanout | 121,654,618 | 33,754.23 | 97.25 |
| application wait time | 11,154 | 3.09 | 0.01 |
| background checkpoints completed | 3 | 0.00 | 0.00 |
| background checkpoints started | 2 | 0.00 | 0.00 |
| background timeouts | 13,898 | 3.86 | 0.01 |
| branch node splits | 1,084 | 0.30 | 0.00 |
| buffer is not pinned count | 595,248,621 | 165,157.37 | 475.84 |
| buffer is pinned count | 1,551,143,441 | 430,379.44 | 1,239.97 |
| bytes received via SQL*Net from client | 11,414,410,765 | 3,167,036.36 | 9,124.56 |
| bytes sent via SQL*Net to client | 10,334,536,855 | 2,867,415.12 | 8,261.32 |
| calls to get snapshot scn: kcmgss | 117,898,306 | 32,712.00 | 94.25 |
| calls to kcmgas | 20,999,599 | 5,826.54 | 16.79 |
| calls to kcmgcs | 12,133,043 | 3,366.43 | 9.70 |
| change write time | 42,460 | 11.78 | 0.03 |
| cleanout - number of ktugct calls | 27,274,937 | 7,567.69 | 21.80 |
| cleanouts and rollbacks - consistent read gets | 14,673,989 | 4,071.44 | 11.73 |
| cleanouts only - consistent read gets | 156,507 | 43.42 | 0.13 |
| cluster key scan block gets | 873,648 | 242.40 | 0.70 |
| cluster key scans | 239,898 | 66.56 | 0.19 |
| commit batch/immediate performed | 4,397 | 1.22 | 0.00 |
| commit batch/immediate requested | 4,397 | 1.22 | 0.00 |
| commit cleanout failures: block lost | 260,132 | 72.18 | 0.21 |
| commit cleanout failures: buffer being written | 1,749 | 0.49 | 0.00 |
| commit cleanout failures: callback failure | 111,231 | 30.86 | 0.09 |
| commit cleanout failures: cannot pin | 31,547 | 8.75 | 0.03 |
| commit cleanouts | 9,735,625 | 2,701.24 | 7.78 |
| commit cleanouts successfully completed | 9,330,966 | 2,588.96 | 7.46 |
| commit immediate performed | 4,397 | 1.22 | 0.00 |
| commit immediate requested | 4,397 | 1.22 | 0.00 |
| commit txn count during cleanout | 1,436,269 | 398.51 | 1.15 |
| concurrency wait time | 17,018 | 4.72 | 0.01 |
| consistent changes | 788,945,923 | 218,900.52 | 630.67 |
| consistent gets | 1,858,645,143 | 515,698.70 | 1,485.78 |
| consistent gets - examination | 1,299,575,843 | 360,579.62 | 1,038.87 |
| consistent gets from cache | 1,858,645,389 | 515,698.76 | 1,485.78 |
| cursor authentications | 2,104 | 0.58 | 0.00 |
| data blocks consistent reads - undo records applied | 784,628,877 | 217,702.71 | 627.22 |
| db block changes | 201,816,212 | 55,995.82 | 161.33 |
| db block gets | 226,044,840 | 62,718.28 | 180.70 |
| db block gets direct | 4,284 | 1.19 | 0.00 |
| db block gets from cache | 226,040,588 | 62,717.10 | 180.69 |
| deferred (CURRENT) block cleanout applications | 1,679,933 | 466.11 | 1.34 |
| dirty buffers inspected | 10,175 | 2.82 | 0.01 |
| enqueue conversions | 10,440 | 2.90 | 0.01 |
| enqueue releases | 4,688,842 | 1,300.96 | 3.75 |
| enqueue requests | 4,694,242 | 1,302.46 | 3.75 |
| enqueue timeouts | 5,263 | 1.46 | 0.00 |
| enqueue waits | 34,832 | 9.66 | 0.03 |
| exchange deadlocks | 25,786 | 7.15 | 0.02 |
| execute count | 104,948,247 | 29,118.89 | 83.89 |
| failed probes on index block reclamation | 9,605 | 2.66 | 0.01 |
| frame signature mismatch | 322 | 0.09 | 0.00 |
| free buffer inspected | 2,983,409 | 827.78 | 2.38 |
| free buffer requested | 21,344,406 | 5,922.21 | 17.06 |
| heap block compress | 32,498,211 | 9,016.94 | 25.98 |
| hot buffers moved to head of LRU | 1,318,254 | 365.76 | 1.05 |
| immediate (CR) block cleanout applications | 14,830,524 | 4,114.87 | 11.86 |
| immediate (CURRENT) block cleanout applications | 1,164,817 | 323.19 | 0.93 |
| index crx upgrade (found) | 13,118 | 3.64 | 0.01 |
| index crx upgrade (positioned) | 10,530,148 | 2,921.69 | 8.42 |
| index fast full scans (rowid ranges) | 784 | 0.22 | 0.00 |
| index fetch by key | 189,511,462 | 52,581.75 | 151.49 |
| index scans kdiixs1 | 141,870,547 | 39,363.33 | 113.41 |
| java call heap collected bytes | 1,507,954,616 | 418,396.29 | 1,205.44 |
| java call heap collected count | 18,428,090 | 5,113.05 | 14.73 |
| java call heap gc count | 4,871 | 1.35 | 0.00 |
| java call heap live object count | 1,550,438 | 430.18 | 1.24 |
| java call heap live object count max | 1,561,909 | 433.37 | 1.25 |
| java call heap live size | 391,774,248 | 108,701.48 | 313.18 |
| java call heap live size max | 394,279,568 | 109,396.60 | 315.18 |
| java call heap object count | 3,826,350 | 1,061.66 | 3.06 |
| java call heap object count max | 3,836,689 | 1,064.53 | 3.07 |
| java call heap total size | 508,164,096 | 140,994.94 | 406.22 |
| java call heap total size max | 511,068,160 | 141,800.70 | 408.54 |
| java call heap used size | 537,467,448 | 149,125.43 | 429.65 |
| java call heap used size max | 539,977,720 | 149,821.93 | 431.65 |
| leaf node 90-10 splits | 21,427 | 5.95 | 0.02 |
| leaf node splits | 248,217 | 68.87 | 0.20 |
| lob reads | 23,657 | 6.56 | 0.02 |
| lob writes | 41,321 | 11.46 | 0.03 |
| lob writes unaligned | 41,321 | 11.46 | 0.03 |
| logons cumulative | 10,192 | 2.83 | 0.01 |
| messages received | 2,100,831 | 582.90 | 1.68 |
| messages sent | 2,100,831 | 582.90 | 1.68 |
| no buffer to keep pinned count | 16 | 0.00 | 0.00 |
| no work - consistent read gets | 507,672,973 | 140,858.67 | 405.83 |
| opened cursors cumulative | 6,044,214 | 1,677.02 | 4.83 |
| parse count (failures) | 3,613 | 1.00 | 0.00 |
| parse count (hard) | 9,396 | 2.61 | 0.01 |
| parse count (total) | 9,271,216 | 2,572.39 | 7.41 |
| parse time cpu | 44,460 | 12.34 | 0.04 |
| parse time elapsed | 48,812 | 13.54 | 0.04 |
| physical read IO requests | 308,995 | 85.73 | 0.25 |
| physical read bytes | 3,769,450,496 | 1,045,869.74 | 3,013.26 |
| physical read total IO requests | 338,261 | 93.85 | 0.27 |
| physical read total bytes | 4,248,035,328 | 1,178,657.63 | 3,395.83 |
| physical read total multi block requests | 12,444 | 3.45 | 0.01 |
| physical reads | 460,138 | 127.67 | 0.37 |
| physical reads cache | 458,786 | 127.29 | 0.37 |
| physical reads cache prefetch | 150,543 | 41.77 | 0.12 |
| physical reads direct | 1,352 | 0.38 | 0.00 |
| physical reads direct temporary tablespace | 620 | 0.17 | 0.00 |
| physical reads prefetch warmup | 81,599 | 22.64 | 0.07 |
| physical write IO requests | 1,672,487 | 464.05 | 1.34 |
| physical write bytes | 25,635,725,312 | 7,112,874.76 | 20,492.92 |
| physical write total IO requests | 2,934,033 | 814.08 | 2.35 |
| physical write total bytes | 59,481,654,784 | 16,503,748.42 | 47,549.00 |
| physical write total multi block requests | 1,445,832 | 401.16 | 1.16 |
| physical writes | 3,129,361 | 868.27 | 2.50 |
| physical writes direct | 5,237 | 1.45 | 0.00 |
| physical writes direct (lob) | 226 | 0.06 | 0.00 |
| physical writes direct temporary tablespace | 4,619 | 1.28 | 0.00 |
| physical writes from cache | 3,124,124 | 866.82 | 2.50 |
| physical writes non checkpoint | 2,378,689 | 659.99 | 1.90 |
| pinned buffers inspected | 3,918 | 1.09 | 0.00 |
| prefetch clients - default | 1 | 0.00 | 0.00 |
| prefetch warmup blocks aged out before use | 251,992 | 69.92 | 0.20 |
| prefetched blocks aged out before use | 120 | 0.03 | 0.00 |
| process last non-idle time | 3,606 | 1.00 | 0.00 |
| queries parallelized | 48 | 0.01 | 0.00 |
| recursive calls | 169,694,471 | 47,083.34 | 135.65 |
| recursive cpu usage | 1,093,059 | 303.28 | 0.87 |
| redo blocks written | 65,938,561 | 18,295.28 | 52.71 |
| redo buffer allocation retries | 129 | 0.04 | 0.00 |
| redo entries | 103,825,670 | 28,807.42 | 83.00 |
| redo log space requests | 0 | 0.00 | 0.00 |
| redo log space wait time | 0 | 0.00 | 0.00 |
| redo ordering marks | 1,310,107 | 363.50 | 1.05 |
| redo size | 32,331,118,924 | 8,970,575.12 | 25,845.15 |
| redo subscn max counts | 2,385,923 | 662.00 | 1.91 |
| redo synch time | 97,807 | 27.14 | 0.08 |
| redo synch writes | 2,427,619 | 673.57 | 1.94 |
| redo wastage | 324,867,208 | 90,137.48 | 259.70 |
| redo write time | 58,140 | 16.13 | 0.05 |
| redo writer latching time | 271 | 0.08 | 0.00 |
| redo writes | 866,456 | 240.41 | 0.69 |
| rollback changes - undo records applied | 305,664 | 84.81 | 0.24 |
| rollbacks only - consistent read gets | 2,191,829 | 608.14 | 1.75 |
| rows fetched via callback | 100,080,793 | 27,768.36 | 80.00 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 5,783,211 | 1,604.61 | 4.62 |
| session logical reads | 2,084,681,865 | 578,414.73 | 1,666.47 |
| session pga memory | 10,759,551,672 | 2,985,339.51 | 8,601.07 |
| session pga memory max | 12,069,220,408 | 3,348,719.50 | 9,648.01 |
| session uga memory | ############### | 75,250,177.69 | 216,803.50 |
| session uga memory max | 74,822,908,984 | 20,760,324.68 | 59,812.63 |
| shared hash latch upgrades - no wait | 32,911,272 | 9,131.54 | 26.31 |
| shared hash latch upgrades - wait | 28,167 | 7.82 | 0.02 |
| sorts (memory) | 11,041,133 | 3,063.47 | 8.83 |
| sorts (rows) | 136,434,643 | 37,855.08 | 109.06 |
| sql area evicted | 2,427 | 0.67 | 0.00 |
| sql area purged | 3,783 | 1.05 | 0.00 |
| summed dirty queue length | 578,307 | 160.46 | 0.46 |
| switch current to new buffer | 1,474,448 | 409.10 | 1.18 |
| table fetch by rowid | 919,141,453 | 255,024.50 | 734.75 |
| table fetch continued row | 29,252,219 | 8,116.31 | 23.38 |
| table scan blocks gotten | 105,481,150 | 29,266.74 | 84.32 |
| table scan rows gotten | 8,617,192,613 | 2,390,921.70 | 6,888.49 |
| table scans (long tables) | 2,041 | 0.57 | 0.00 |
| table scans (rowid ranges) | 2,039 | 0.57 | 0.00 |
| table scans (short tables) | 6,247,979 | 1,733.56 | 4.99 |
| total number of times SMON posted | 161,241 | 44.74 | 0.13 |
| transaction rollbacks | 4,397 | 1.22 | 0.00 |
| transaction tables consistent read rollbacks | 89 | 0.02 | 0.00 |
| transaction tables consistent reads - undo records applied | 5,143 | 1.43 | 0.00 |
| undo change vector size | 11,309,067,032 | 3,137,807.75 | 9,040.35 |
| user I/O wait time | 131,877 | 36.59 | 0.11 |
| user calls | 49,736,331 | 13,799.82 | 39.76 |
| user commits | 985,913 | 273.55 | 0.79 |
| user rollbacks | 265,042 | 73.54 | 0.21 |
| workarea executions - onepass | 4 | 0.00 | 0.00 |
| workarea executions - optimal | 6,632,795 | 1,840.33 | 5.30 |
| write clones created in background | 1,767 | 0.49 | 0.00 |
| write clones created in foreground | 9,859 | 2.74 | 0.01 |
Back to Instance Activity Statistics
Back to Top
Instance Activity Stats - Absolute Values
- Statistics with absolute values (should not be diffed)
| Statistic | Begin Value | End Value |
|---|
| session cursor cache count | 542,823 | 1,262,942 |
| opened cursors current | 1,107,931 | 1,245,423 |
| workarea memory allocated | 254 | 160 |
| logons current | 5,268 | 5,294 |
Back to Instance Activity Statistics
Back to Top
Instance Activity Stats - Thread Activity
- Statistics identified by '(derived)' come from sources other than SYSSTAT
| Statistic | Total | per Hour |
|---|
| log switches (derived) | 0 | 0.00 |
Back to Instance Activity Statistics
Back to Top
IO Stats
Back to Top
Tablespace IO Stats
- ordered by IOs (Reads + Writes) desc
| Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
|---|
| APPS_UNDOTS1 |
30 | 0 | 12.00 | 1.00 | 793,842 | 220 | 250,790 | 0.03 |
| APPS_TS_TX_DATA |
184,780 | 51 | 4.13 | 1.29 | 194,438 | 54 | 112,731 | 0.21 |
| APPS_TS_TX_IDX |
98,648 | 27 | 4.24 | 1.29 | 227,620 | 63 | 58,817 | 0.40 |
| APPS_ASSM_DATA |
8,811 | 2 | 2.11 | 6.51 | 233,788 | 65 | 41,268 | 0.44 |
| APPS_ASSM_IDX |
6,840 | 2 | 2.29 | 1.04 | 154,043 | 43 | 178,930 | 0.10 |
| APPS_TS_TX_INTERFACE |
1,254 | 0 | 4.50 | 2.05 | 32,571 | 9 | 16,030 | 0.04 |
| TEMP |
599 | 0 | 4.24 | 8.60 | 10,072 | 3 | 53 | 1.13 |
| APPS_TS_SUMMARY |
57 | 0 | 11.23 | 1.00 | 7,975 | 2 | 2,096 | 0.04 |
| APPS_TS_SEED |
2,185 | 1 | 5.62 | 1.33 | 5,694 | 2 | 765 | 2.22 |
| SYSTEM |
4,850 | 1 | 3.56 | 3.73 | 2,775 | 1 | 20,771 | 0.07 |
| APPS_TS_QUEUES |
385 | 0 | 5.84 | 2.66 | 5,570 | 2 | 418 | 0.33 |
| APPS_TS_ARCHIVE |
65 | 0 | 4.00 | 1.37 | 2,503 | 1 | 100 | 5.10 |
| SYSAUX |
285 | 0 | 2.25 | 1.09 | 1,579 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING |
25 | 0 | 7.20 | 1.56 | 39 | 0 | 0 | 0.00 |
| CTXSYS |
24 | 0 | 5.00 | 1.00 | 6 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA |
12 | 0 | 8.33 | 1.00 | 9 | 0 | 0 | 0.00 |
| ODM |
12 | 0 | 5.83 | 1.00 | 3 | 0 | 0 | 0.00 |
| OLAP |
12 | 0 | 10.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| OWAPUB |
12 | 0 | 5.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| PORTAL |
12 | 0 | 7.50 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYNCSERVER |
12 | 0 | 7.50 | 1.00 | 3 | 0 | 0 | 0.00 |
Back to IO Stats
Back to Top
File IO Stats
- ordered by Tablespace, File
| Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
|---|
| APPS_ASSM_DATA | /DB/visdata/apps_assm_data.dbf |
8,811 | 2 | 2.11 | 6.51 | 233,788 | 65 | 41,268 | 0.44 |
| APPS_ASSM_IDX | /DB/visdata/apps_assm_idx.dbf |
6,840 | 2 | 2.29 | 1.04 | 154,043 | 43 | 178,930 | 0.10 |
| APPS_TS_ARCHIVE | /DB/visdata/archive1.dbf |
35 | 0 | 3.71 | 1.37 | 2,235 | 1 | 87 | 2.18 |
| APPS_TS_ARCHIVE | /DB/visdata/archive2.dbf |
30 | 0 | 4.33 | 1.37 | 268 | 0 | 13 | 24.62 |
| APPS_TS_MEDIA | /DB/visdata/media1.dbf |
4 | 0 | 10.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /DB/visdata/media2.dbf |
4 | 0 | 7.50 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /DB/visdata/media3.dbf |
4 | 0 | 7.50 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /DB/visdata/nologging1.dbf |
4 | 0 | 10.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /DB/visdata/nologging2.dbf |
15 | 0 | 5.33 | 1.00 | 22 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /DB/visdata/nologging3.dbf |
6 | 0 | 10.00 | 3.33 | 14 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues1.dbf |
44 | 0 | 5.68 | 2.43 | 768 | 0 | 106 | 0.38 |
| APPS_TS_QUEUES | /DB/visdata/queues2.dbf |
37 | 0 | 3.78 | 3.24 | 897 | 0 | 261 | 0.27 |
| APPS_TS_QUEUES | /DB/visdata/queues3.dbf |
48 | 0 | 5.00 | 2.88 | 820 | 0 | 6 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues4.dbf |
37 | 0 | 5.95 | 3.30 | 656 | 0 | 2 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues5.dbf |
41 | 0 | 6.59 | 3.95 | 844 | 0 | 1 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues6.dbf |
46 | 0 | 5.65 | 2.48 | 597 | 0 | 2 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues7.dbf |
132 | 0 | 6.59 | 1.98 | 988 | 0 | 40 | 0.75 |
| APPS_TS_SEED | /DB/visdata/reference1.dbf |
190 | 0 | 5.63 | 1.35 | 484 | 0 | 51 | 1.76 |
| APPS_TS_SEED | /DB/visdata/reference10.dbf |
181 | 0 | 6.30 | 1.27 | 558 | 0 | 51 | 1.18 |
| APPS_TS_SEED | /DB/visdata/reference2.dbf |
205 | 0 | 5.71 | 1.26 | 587 | 0 | 39 | 5.90 |
| APPS_TS_SEED | /DB/visdata/reference3.dbf |
331 | 0 | 4.71 | 1.33 | 637 | 0 | 380 | 2.03 |
| APPS_TS_SEED | /DB/visdata/reference4.dbf |
211 | 0 | 5.78 | 1.39 | 619 | 0 | 30 | 1.67 |
| APPS_TS_SEED | /DB/visdata/reference5.dbf |
255 | 0 | 5.41 | 1.26 | 588 | 0 | 67 | 3.43 |
| APPS_TS_SEED | /DB/visdata/reference6.dbf |
242 | 0 | 5.62 | 1.42 | 632 | 0 | 21 | 2.38 |
| APPS_TS_SEED | /DB/visdata/reference7.dbf |
220 | 0 | 5.95 | 1.33 | 497 | 0 | 19 | 2.11 |
| APPS_TS_SEED | /DB/visdata/reference8.dbf |
184 | 0 | 6.09 | 1.43 | 521 | 0 | 32 | 5.00 |
| APPS_TS_SEED | /DB/visdata/reference9.dbf |
166 | 0 | 5.78 | 1.28 | 571 | 0 | 75 | 0.27 |
| APPS_TS_SUMMARY | /DB/visdata/summary1.dbf |
5 | 0 | 6.00 | 1.00 | 934 | 0 | 354 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary2.dbf |
5 | 0 | 8.00 | 1.00 | 908 | 0 | 159 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary3.dbf |
9 | 0 | 11.11 | 1.00 | 962 | 0 | 200 | 0.05 |
| APPS_TS_SUMMARY | /DB/visdata/summary4.dbf |
10 | 0 | 12.00 | 1.00 | 924 | 0 | 209 | 0.05 |
| APPS_TS_SUMMARY | /DB/visdata/summary5.dbf |
7 | 0 | 11.43 | 1.00 | 1,003 | 0 | 262 | 0.08 |
| APPS_TS_SUMMARY | /DB/visdata/summary6.dbf |
7 | 0 | 14.29 | 1.00 | 1,085 | 0 | 548 | 0.02 |
| APPS_TS_SUMMARY | /DB/visdata/summary7.dbf |
7 | 0 | 10.00 | 1.00 | 986 | 0 | 197 | 0.10 |
| APPS_TS_SUMMARY | /DB/visdata/summary8.dbf |
7 | 0 | 14.29 | 1.00 | 1,173 | 0 | 167 | 0.12 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data1.dbf |
3,466 | 1 | 4.98 | 1.24 | 361 | 0 | 7 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data10.dbf |
3,427 | 1 | 4.60 | 1.22 | 242 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data11.dbf |
3,388 | 1 | 4.45 | 1.26 | 259 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data12.dbf |
13,544 | 4 | 3.08 | 1.20 | 4,404 | 1 | 3,493 | 1.06 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data13.dbf |
18,758 | 5 | 4.56 | 1.44 | 6,040 | 2 | 2,445 | 0.65 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data14.dbf |
13,427 | 4 | 4.00 | 1.33 | 27,927 | 8 | 14,900 | 0.12 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data15.dbf |
9,671 | 3 | 3.75 | 1.40 | 27,396 | 8 | 13,879 | 0.18 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data16.dbf |
9,679 | 3 | 3.82 | 1.41 | 26,093 | 7 | 15,045 | 0.19 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data17.dbf |
9,538 | 3 | 3.71 | 1.41 | 25,067 | 7 | 14,634 | 0.19 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data18.dbf |
9,619 | 3 | 3.69 | 1.39 | 23,940 | 7 | 14,320 | 0.13 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data19.dbf |
9,472 | 3 | 3.86 | 1.40 | 23,967 | 7 | 15,597 | 0.19 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data2.dbf |
6,981 | 2 | 3.29 | 1.16 | 1,180 | 0 | 2,074 | 0.64 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data20.dbf |
9,590 | 3 | 3.92 | 1.43 | 23,592 | 7 | 14,932 | 0.14 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data21.dbf |
24,122 | 7 | 4.60 | 1.17 | 1,113 | 0 | 1,344 | 0.10 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data3.dbf |
4,217 | 1 | 5.25 | 1.39 | 492 | 0 | 8 | 1.25 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data4.dbf |
18,559 | 5 | 4.31 | 1.07 | 324 | 0 | 4 | 7.50 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data5.dbf |
3,512 | 1 | 4.45 | 1.20 | 438 | 0 | 4 | 7.50 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data6.dbf |
3,505 | 1 | 4.64 | 1.22 | 248 | 0 | 16 | 8.75 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data7.dbf |
3,426 | 1 | 4.92 | 1.24 | 528 | 0 | 21 | 3.33 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data8.dbf |
3,348 | 1 | 4.43 | 1.23 | 523 | 0 | 7 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data9.dbf |
3,531 | 1 | 4.55 | 1.26 | 304 | 0 | 1 | 10.00 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx1.dbf |
2,646 | 1 | 3.25 | 1.12 | 2,560 | 1 | 1,186 | 0.74 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx10.dbf |
2,585 | 1 | 3.54 | 1.15 | 1,804 | 1 | 1,073 | 0.67 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx11.dbf |
2,618 | 1 | 3.41 | 1.15 | 2,012 | 1 | 1,173 | 0.55 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx12.dbf |
12,005 | 3 | 4.95 | 1.51 | 24,319 | 7 | 1,163 | 0.17 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx13.dbf |
9,872 | 3 | 4.34 | 1.22 | 31,472 | 9 | 3,579 | 0.20 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx14.dbf |
5,953 | 2 | 4.83 | 1.33 | 23,094 | 6 | 3,356 | 0.22 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx15.dbf |
6,018 | 2 | 4.49 | 1.32 | 19,521 | 5 | 3,801 | 0.21 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx16.dbf |
5,877 | 2 | 4.66 | 1.32 | 18,015 | 5 | 3,771 | 0.14 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx17.dbf |
5,881 | 2 | 4.66 | 1.33 | 16,958 | 5 | 3,651 | 0.19 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx18.dbf |
5,975 | 2 | 4.63 | 1.32 | 16,777 | 5 | 5,068 | 0.21 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx19.dbf |
5,885 | 2 | 4.47 | 1.32 | 15,789 | 4 | 3,446 | 0.17 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx2.dbf |
3,237 | 1 | 3.86 | 1.27 | 2,319 | 1 | 1,380 | 0.36 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx20.dbf |
5,776 | 2 | 4.57 | 1.31 | 15,335 | 4 | 3,845 | 0.07 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx21.dbf |
3,780 | 1 | 5.06 | 1.47 | 16,253 | 5 | 2,938 | 1.77 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx3.dbf |
4,131 | 1 | 2.75 | 1.10 | 2,124 | 1 | 3,250 | 0.59 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx4.dbf |
2,822 | 1 | 3.26 | 1.13 | 3,923 | 1 | 3,432 | 0.40 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx5.dbf |
2,825 | 1 | 3.59 | 1.18 | 5,235 | 1 | 8,004 | 0.23 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx6.dbf |
2,760 | 1 | 3.56 | 1.17 | 2,996 | 1 | 1,494 | 1.06 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx7.dbf |
2,686 | 1 | 3.36 | 1.14 | 2,938 | 1 | 1,095 | 0.91 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx8.dbf |
2,690 | 1 | 3.28 | 1.17 | 2,171 | 1 | 1,033 | 1.18 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx9.dbf |
2,626 | 1 | 3.26 | 1.18 | 2,005 | 1 | 1,079 | 0.77 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte.dbf |
240 | 0 | 3.63 | 1.64 | 5,273 | 1 | 4,715 | 0.05 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte2.dbf |
418 | 0 | 3.83 | 1.77 | 6,530 | 2 | 3,783 | 0.04 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte3.dbf |
109 | 0 | 5.78 | 3.28 | 5,541 | 2 | 3,075 | 0.02 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte4.dbf |
81 | 0 | 6.30 | 3.62 | 5,235 | 1 | 1,522 | 0.03 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte5.dbf |
258 | 0 | 5.16 | 1.75 | 5,028 | 1 | 1,791 | 0.02 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte6.dbf |
148 | 0 | 4.73 | 2.27 | 4,964 | 1 | 1,144 | 0.06 |
| APPS_UNDOTS1 | /DB/visdata/undo01.dbf |
3 | 0 | 16.67 | 1.00 | 80,109 | 22 | 25,352 | 0.04 |
| APPS_UNDOTS1 | /DB/visdata/undo02.dbf |
3 | 0 | 13.33 | 1.00 | 79,724 | 22 | 28,207 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo03.dbf |
3 | 0 | 13.33 | 1.00 | 79,102 | 22 | 28,725 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo04.dbf |
3 | 0 | 10.00 | 1.00 | 72,739 | 20 | 22,694 | 0.04 |
| APPS_UNDOTS1 | /DB/visdata/undo05.dbf |
3 | 0 | 13.33 | 1.00 | 77,658 | 22 | 27,608 | 0.04 |
| APPS_UNDOTS1 | /DB/visdata/undo06.dbf |
3 | 0 | 13.33 | 1.00 | 78,791 | 22 | 25,186 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo07.dbf |
3 | 0 | 10.00 | 1.00 | 77,842 | 22 | 25,064 | 0.02 |
| APPS_UNDOTS1 | /DB/visdata/undo08.dbf |
3 | 0 | 10.00 | 1.00 | 83,902 | 23 | 20,902 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo09.dbf |
3 | 0 | 10.00 | 1.00 | 82,922 | 23 | 26,227 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo10.dbf |
3 | 0 | 10.00 | 1.00 | 81,053 | 22 | 20,825 | 0.03 |
| CTXSYS | /DB/visdata/ctx1.dbf |
12 | 0 | 5.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| CTXSYS | /DB/visdata/ctx2.dbf |
12 | 0 | 5.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| ODM | /DB/visdata/odm.dbf |
12 | 0 | 5.83 | 1.00 | 3 | 0 | 0 | 0.00 |
| OLAP | /DB/visdata/olap.dbf |
12 | 0 | 10.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| OWAPUB | /DB/visdata/owa1.dbf |
12 | 0 | 5.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| PORTAL | /DB/visdata/portal.dbf |
12 | 0 | 7.50 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYNCSERVER | /DB/visdata/mobile01.dbf |
12 | 0 | 7.50 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYSAUX | /DB/visdata/sysaux01.dbf |
5 | 0 | 10.00 | 1.40 | 533 | 0 | 0 | 0.00 |
| SYSAUX | /DB/visdata/sysaux02.dbf |
280 | 0 | 2.11 | 1.08 | 1,046 | 0 | 0 | 0.00 |
| SYSTEM | /DB/visdata/sys1.dbf |
529 | 0 | 3.67 | 4.10 | 107 | 0 | 62 | 1.13 |
| SYSTEM | /DB/visdata/sys2.dbf |
541 | 0 | 3.31 | 4.24 | 198 | 0 | 103 | 0.00 |
| SYSTEM | /DB/visdata/sys3.dbf |
636 | 0 | 3.32 | 3.68 | 261 | 0 | 41 | 0.00 |
| SYSTEM | /DB/visdata/sys4.dbf |
613 | 0 | 2.53 | 3.75 | 272 | 0 | 34 | 0.00 |
| SYSTEM | /DB/visdata/sys5.dbf |
778 | 0 | 3.87 | 3.12 | 685 | 0 | 446 | 0.02 |
| SYSTEM | /DB/visdata/sys6.dbf |
534 | 0 | 3.75 | 4.29 | 68 | 0 | 2 | 0.00 |
| SYSTEM | /DB/visdata/sys7.dbf |
425 | 0 | 4.64 | 4.38 | 191 | 0 | 70 | 0.00 |
| SYSTEM | /DB/visdata/sys8.dbf |
336 | 0 | 4.02 | 3.49 | 538 | 0 | 19,876 | 0.07 |
| SYSTEM | /DB/visdata/sys9.dbf |
458 | 0 | 3.43 | 2.71 | 455 | 0 | 137 | 0.29 |
| TEMP | /DB/visdata/temp1.dbf |
158 | 0 | 4.62 | 10.42 | 2,689 | 1 | 0 | |
| TEMP | /DB/visdata/temp2.dbf |
112 | 0 | 3.57 | 1.00 | 2,294 | 1 | 6 | 1.67 |
| TEMP | /DB/visdata/temp3.dbf |
208 | 0 | 4.47 | 15.72 | 2,467 | 1 | 0 | |
| TEMP | /DB/visdata/temp4.dbf |
121 | 0 | 3.97 | 1.00 | 2,622 | 1 | 47 | 1.06 |
Back to IO Stats
Back to Top
Buffer Pool Statistics
- Standard block size Pools D: default, K: keep, R: recycle
- Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
| P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
|---|
| D | 2,182,837 | 100 | 2,084,427,219 | 458,751 | 3,124,124 | 0 | 0 | 682,769 |
Back to Top
Advisory Statistics
Back to Top
Instance Recovery Stats
- B: Begin snapshot, E: End snapshot
| Targt MTTR (s) | Estd MTTR (s) | Recovery Estd IOs | Actual Redo Blks | Target Redo Blks | Log File Size Redo Blks | Log Ckpt Timeout Redo Blks | Log Ckpt Interval Redo Blks |
|---|
| B | 180 | 95 | 48495 | 1186277 | 4567642 | 188743680 | 4567642 | |
| E | 180 | 99 | 54325 | 1192525 | 10180644 | 188743680 | 10180644 | |
Back to Advisory Statistics
Back to Top
|
