|
|
|
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 | 06-May-09 05:37:49 | 4768 | 211.4 |
| End Snap: | 2 | 06-May-09 06:37:54 | 4783 | 234.1 |
| Elapsed: | | 60.08 (mins) | | |
| DB Time: | | 415.31 (mins) | | |
Report Summary
Cache Sizes
| Begin | End | | |
|---|
| Buffer Cache: | 17,984M | 17,824M | Std Block Size: | 8K |
| Shared Pool Size: | 2,400M | 2,560M | Log Buffer: | 14,320K |
Load Profile
| Per Second | Per Transaction |
|---|
| Redo size: | 8,752,977.49 | 27,282.24 |
| Logical reads: | 561,879.43 | 1,751.33 |
| Block changes: | 54,468.54 | 169.77 |
| Physical reads: | 121.84 | 0.38 |
| Physical writes: | 852.12 | 2.66 |
| User calls: | 12,467.11 | 38.86 |
| Parses: | 2,360.62 | 7.36 |
| Hard parses: | 2.46 | 0.01 |
| Sorts: | 2,867.43 | 8.94 |
| Logons: | 2.58 | 0.01 |
| Executes: | 27,142.69 | 84.60 |
| Transactions: | 320.83 | |
| % Blocks changed per Read: | 9.69 | Recursive Call %: | 77.91 |
| Rollback per transaction %: | 20.62 | Rows per Sort: | 12.39 |
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.77 | Soft Parse %: | 99.90 |
| Execute to Parse %: | 91.30 | Latch Hit %: | 99.05 |
| Parse CPU to Parse Elapsd %: | 92.53 | % Non-Parse CPU: | 97.79 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 86.49 | 86.54 |
| % SQL with executions>1: | 90.40 | 90.92 |
| % Memory for SQL w/exec>1: | 70.62 | 70.89 |
Top 5 Timed Events
| Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
|---|
| CPU time | | 19,651 | | 78.9 | |
| SQL*Net more data from client | 2,333,168 | 5,578 | 2 | 22.4 | Network |
| db file sequential read | 278,108 | 932 | 3 | 3.7 | User I/O |
| log file sync | 494,534 | 698 | 1 | 2.8 | Commit |
| log file parallel write | 813,691 | 337 | 0 | 1.4 | System I/O |
Main Report
Back to Top
Wait Events Statistics
Back to Top
Time Model Statistics
- Total time in database user-calls (DB Time): 24918.5s
- 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,650.53 | 78.86 |
| sql execute elapsed time | 19,005.47 | 76.27 |
| PL/SQL execution elapsed time | 7,062.42 | 28.34 |
| inbound PL/SQL rpc elapsed time | 6,847.17 | 27.48 |
| parse time elapsed | 533.56 | 2.14 |
| Java execution elapsed time | 498.39 | 2.00 |
| hard parse elapsed time | 282.76 | 1.13 |
| repeated bind elapsed time | 74.55 | 0.30 |
| sequence load elapsed time | 13.42 | 0.05 |
| connection management call elapsed time | 9.63 | 0.04 |
| PL/SQL compilation elapsed time | 6.27 | 0.03 |
| hard parse (sharing criteria) elapsed time | 3.62 | 0.01 |
| failed parse elapsed time | 1.43 | 0.01 |
| hard parse (bind mismatch) elapsed time | 1.18 | 0.00 |
| DB time | 24,918.49 | |
| background elapsed time | 1,002.45 | |
| background cpu time | 352.99 | |
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 |
|---|
| Network | 51,318,007 | 0.00 | 5,618 | 0 | 44.37 |
| User I/O | 329,343 | 0.00 | 1,050 | 3 | 0.28 |
| Commit | 494,534 | 0.00 | 698 | 1 | 0.43 |
| System I/O | 1,130,959 | 0.00 | 497 | 0 | 0.98 |
| Application | 63,077 | 0.06 | 177 | 3 | 0.05 |
| Concurrency | 1,926,552 | 0.19 | 126 | 0 | 1.67 |
| Other | 136,814 | 21.98 | 37 | 0 | 0.12 |
| Configuration | 6,932 | 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 |
|---|
| SQL*Net more data from client | 2,333,168 | 0.00 | 5,578 | 2 | 2.02 |
| db file sequential read | 278,108 | 0.00 | 932 | 3 | 0.24 |
| log file sync | 494,534 | 0.00 | 698 | 1 | 0.43 |
| log file parallel write | 813,691 | 0.00 | 337 | 0 | 0.70 |
| db file parallel write | 286,365 | 0.00 | 154 | 1 | 0.25 |
| enq: TX - row lock contention | 659 | 5.92 | 137 | 207 | 0.00 |
| db file scattered read | 11,990 | 0.00 | 58 | 5 | 0.01 |
| read by other session | 36,446 | 0.00 | 58 | 2 | 0.03 |
| cursor: pin S wait on X | 4,110 | 90.61 | 41 | 10 | 0.00 |
| latch: cache buffers chains | 1,201,589 | 0.00 | 29 | 0 | 1.04 |
| SQL*Net message to client | 47,083,483 | 0.00 | 23 | 0 | 40.71 |
| enq: UL - contention | 1,450 | 0.00 | 19 | 13 | 0.00 |
| SQL*Net more data to client | 1,901,356 | 0.00 | 18 | 0 | 1.64 |
| buffer busy waits | 651,468 | 0.00 | 18 | 0 | 0.56 |
| library cache load lock | 650 | 0.00 | 11 | 18 | 0.00 |
| SQL*Net break/reset to client | 60,930 | 0.00 | 11 | 0 | 0.05 |
| enq: TX - index contention | 26,204 | 0.00 | 11 | 0 | 0.02 |
| PX Deq Credit: send blkd | 23,600 | 0.00 | 9 | 0 | 0.02 |
| rdbms ipc reply | 6 | 50.00 | 7 | 1148 | 0.00 |
| latch: In memory undo latch | 24,440 | 0.00 | 6 | 0 | 0.02 |
| enq: RO - fast object reuse | 32 | 0.00 | 6 | 184 | 0.00 |
| control file sequential read | 29,164 | 0.00 | 5 | 0 | 0.03 |
| latch: library cache | 9,054 | 0.00 | 5 | 1 | 0.01 |
| latch: undo global data | 8,164 | 0.00 | 5 | 1 | 0.01 |
| enq: TM - contention | 6 | 0.00 | 4 | 634 | 0.00 |
| PX Deq: Signal ACK | 255 | 36.08 | 3 | 12 | 0.00 |
| kksfbc child completion | 60 | 83.33 | 2 | 42 | 0.00 |
| os thread startup | 70 | 0.00 | 2 | 31 | 0.00 |
| latch: object queue header operation | 20,566 | 0.00 | 2 | 0 | 0.02 |
| latch free | 2,786 | 0.00 | 2 | 1 | 0.00 |
| latch: library cache pin | 2,530 | 0.00 | 1 | 1 | 0.00 |
| LGWR wait for redo copy | 32,863 | 0.01 | 1 | 0 | 0.03 |
| enq: HW - contention | 2,528 | 0.00 | 1 | 0 | 0.00 |
| latch: cache buffers lru chain | 1,623 | 0.00 | 1 | 1 | 0.00 |
| local write wait | 1,570 | 0.00 | 1 | 1 | 0.00 |
| log buffer space | 136 | 0.00 | 1 | 8 | 0.00 |
| buffer exterminate | 2 | 50.00 | 1 | 489 | 0.00 |
| control file parallel write | 1,739 | 0.00 | 1 | 1 | 0.00 |
| enq: TX - contention | 2,748 | 0.00 | 1 | 0 | 0.00 |
| enq: DV - contention | 185 | 0.00 | 1 | 4 | 0.00 |
| row cache lock | 2,703 | 0.00 | 1 | 0 | 0.00 |
| latch: redo allocation | 1,047 | 0.00 | 1 | 0 | 0.00 |
| enq: SQ - contention | 3,999 | 0.00 | 0 | 0 | 0.00 |
| library cache pin | 2,064 | 0.00 | 0 | 0 | 0.00 |
| buffer deadlock | 27,301 | 98.78 | 0 | 0 | 0.02 |
| latch: row cache objects | 742 | 0.00 | 0 | 1 | 0.00 |
| wait list latch free | 29 | 0.00 | 0 | 11 | 0.00 |
| latch: session allocation | 563 | 0.00 | 0 | 0 | 0.00 |
| SGA: allocation forcing component growth | 24 | 41.67 | 0 | 10 | 0.00 |
| latch: shared pool | 660 | 0.00 | 0 | 0 | 0.00 |
| direct path read | 732 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache lock | 156 | 0.00 | 0 | 1 | 0.00 |
| latch: messages | 231 | 0.00 | 0 | 0 | 0.00 |
| latch: cache buffer handles | 194 | 0.00 | 0 | 0 | 0.00 |
| cursor: pin S | 10,542 | 0.00 | 0 | 0 | 0.01 |
| enq: FB - contention | 678 | 0.00 | 0 | 0 | 0.00 |
| enq: TX - allocate ITL entry | 154 | 0.00 | 0 | 0 | 0.00 |
| latch: object queue header heap | 192 | 0.00 | 0 | 0 | 0.00 |
| latch: redo writing | 108 | 0.00 | 0 | 0 | 0.00 |
| latch: checkpoint queue latch | 39 | 0.00 | 0 | 1 | 0.00 |
| library cache lock | 3 | 0.00 | 0 | 9 | 0.00 |
| reliable message | 35 | 0.00 | 0 | 1 | 0.00 |
| latch: enqueue hash chains | 26 | 0.00 | 0 | 1 | 0.00 |
| PX qref latch | 3,004 | 97.90 | 0 | 0 | 0.00 |
| cursor: mutex S | 97 | 0.00 | 0 | 0 | 0.00 |
| L1 validation | 1 | 100.00 | 0 | 10 | 0.00 |
| write complete waits | 7 | 0.00 | 0 | 1 | 0.00 |
| enq: PS - contention | 49 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 439 | 0.00 | 0 | 0 | 0.00 |
| direct path write temp | 45 | 0.00 | 0 | 0 | 0.00 |
| cursor: mutex X | 12 | 0.00 | 0 | 0 | 0.00 |
| kkdlgon | 1 | 0.00 | 0 | 0 | 0.00 |
| direct path read temp | 13 | 0.00 | 0 | 0 | 0.00 |
| SQL*Net message from client | 47,083,459 | 0.00 | 9,289,464 | 197 | 40.71 |
| pipe get | 26,893 | 16.74 | 21,083 | 784 | 0.02 |
| Streams AQ: waiting for time management or cleanup tasks | 2,790 | 39.53 | 3,492 | 1252 | 0.00 |
| Streams AQ: qmn slave idle wait | 128 | 0.00 | 3,473 | 27135 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 256 | 50.00 | 3,473 | 13568 | 0.00 |
| PX Idle Wait | 1,618 | 76.14 | 2,534 | 1566 | 0.00 |
| PL/SQL lock timer | 217 | 99.54 | 2,442 | 11253 | 0.00 |
| jobq slave wait | 618 | 99.35 | 1,808 | 2925 | 0.00 |
| PX Deq: Execution Msg | 5,148 | 0.00 | 39 | 8 | 0.00 |
| PX Deq: Execute Reply | 2,651 | 0.00 | 3 | 1 | 0.00 |
| PX Deq Credit: need buffer | 4,383 | 0.00 | 1 | 0 | 0.00 |
| PX Deq: Msg Fragment | 4,359 | 0.00 | 0 | 0 | 0.00 |
| PX Deq: Table Q Normal | 5,877 | 0.00 | 0 | 0 | 0.01 |
| PX Deq: Parse Reply | 242 | 0.00 | 0 | 1 | 0.00 |
| PX Deq: Join ACK | 280 | 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)
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| log file parallel write | 813,685 | 0.00 | 337 | 0 | 0.70 |
| db file parallel write | 286,365 | 0.00 | 154 | 1 | 0.25 |
| events in waitclass Other | 41,699 | 0.00 | 3 | 0 | 0.04 |
| control file sequential read | 827 | 0.00 | 2 | 2 | 0.00 |
| db file scattered read | 492 | 0.00 | 2 | 4 | 0.00 |
| os thread startup | 62 | 0.00 | 2 | 31 | 0.00 |
| control file parallel write | 1,739 | 0.00 | 1 | 1 | 0.00 |
| db file sequential read | 227 | 0.00 | 1 | 3 | 0.00 |
| direct path read | 732 | 0.00 | 0 | 0 | 0.00 |
| latch: cache buffers chains | 57 | 0.00 | 0 | 1 | 0.00 |
| latch: redo writing | 108 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 333 | 0.00 | 0 | 0 | 0.00 |
| log file sync | 1 | 0.00 | 0 | 2 | 0.00 |
| latch: library cache | 1 | 0.00 | 0 | 0 | 0.00 |
| buffer busy waits | 9 | 0.00 | 0 | 0 | 0.00 |
| rdbms ipc message | 1,686,824 | 0.72 | 37,581 | 22 | 1.46 |
| pmon timer | 1,361 | 89.42 | 3,511 | 2579 | 0.00 |
| smon timer | 133,293 | 0.00 | 3,503 | 26 | 0.12 |
| Streams AQ: waiting for time management or cleanup tasks | 2,790 | 39.53 | 3,492 | 1252 | 0.00 |
| Streams AQ: qmn slave idle wait | 128 | 0.00 | 3,473 | 27135 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 256 | 50.00 | 3,473 | 13568 | 0.00 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics
| Statistic | Total |
|---|
| BUSY_TIME | 2,104,482 |
| IDLE_TIME | 3,662,196 |
| IOWAIT_TIME | 107,016 |
| NICE_TIME | 17,999 |
| SYS_TIME | 99,103 |
| USER_TIME | 1,916,799 |
| LOAD | 3 |
| RSRC_MGR_CPU_WAIT_TIME | 0 |
| PHYSICAL_MEMORY_BYTES | 53,184,240 |
| 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 | 24,918.50 | 19,649.90 | 424,014 | 2,021,912,369 |
| SYS$BACKGROUND | 0.00 | 0.00 | 15,097 | 3,633,137 |
| 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 |
327540 | 104679 | 1926418 | 12416 | 0 | 0 | 51304426 | 561846 |
| SYS$BACKGROUND |
1786 | 282 | 129 | 197 | 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 |
|---|
| 725 | 721 | 305 | 2.38 | 2.91 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 411 | 11 | 20,008 | 0.02 | 1.65 | fw8fr3nddyd26 |
PYUSLV
|
insert into pay_run_balances(r... |
| 400 | 373 | 101,491 | 0.00 | 1.60 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 398 | 8 | 10,000 | 0.04 | 1.60 | 38kpqs2vdwfh9 |
PYUSLV
|
update pay_person_latest_balan... |
| 361 | 360 | 56,487 | 0.01 | 1.45 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 360 | 358 | 63,127 | 0.01 | 1.44 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 339 | 337 | 56,504 | 0.01 | 1.36 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 314 | 309 | 1,300 | 0.24 | 1.26 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 311 | 309 | 56,500 | 0.01 | 1.25 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 285 | 283 | 337,939 | 0.00 | 1.14 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
Back to SQL Statistics
Back to Top
SQL ordered by CPU Time
- Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
- % Total DB Time is the Elapsed Time of the SQL statement divided
into the Total Database Time multiplied by 100
| CPU Time (s) | Elapsed Time (s) | Executions | CPU per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL Text |
|---|
| 721 | 725 | 305 | 2.36 | 2.91 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 373 | 400 | 101,491 | 0.00 | 1.60 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 360 | 361 | 56,487 | 0.01 | 1.45 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 358 | 360 | 63,127 | 0.01 | 1.44 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 337 | 339 | 56,504 | 0.01 | 1.36 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 309 | 311 | 56,500 | 0.01 | 1.25 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 309 | 314 | 1,300 | 0.24 | 1.26 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 283 | 285 | 337,939 | 0.00 | 1.14 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 228 | 229 | 45,424 | 0.01 | 0.92 | 6ubqcscr1gk1b |
asnDispContainer.jsp
|
select name, value from icx_s... |
| 209 | 211 | 58,106 | 0.00 | 0.85 | bfbyqwbr4vwms |
OEXOETEL
|
begin OE_OEOL_SCH.SCHEDULE_LIN... |
| 11 | 411 | 20,008 | 0.00 | 1.65 | fw8fr3nddyd26 |
PYUSLV
|
insert into pay_run_balances(r... |
| 8 | 398 | 10,000 | 0.00 | 1.60 | 38kpqs2vdwfh9 |
PYUSLV
|
update pay_person_latest_balan... |
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,025,588,843
- Captured SQL account for 10.9% of Total
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 55,996,328 | 156,472 | 357.87 | 2.76 | 154.56 | 155.16 | 5kqw5535fjvw6 |
ARXTWMAI
|
SELECT NVL(RCTT.ATTRIBUTE10, ... |
| 44,238,706 | 56,487 | 783.17 | 2.18 | 359.55 | 361.41 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 43,268,870 | 305 | 141,865.15 | 2.14 | 721.13 | 724.68 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 38,913,527 | 63,127 | 616.43 | 1.92 | 357.51 | 360.03 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 37,252,817 | 56,500 | 659.34 | 1.84 | 309.36 | 311.30 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 31,000,965 | 171,664 | 180.59 | 1.53 | 173.28 | 174.96 | 3b3psftuyks81 |
INVTTMTX
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 30,993,222 | 171,646 | 180.56 | 1.53 | 162.56 | 164.19 | gf1u933c95jb5 |
INVTTMTX
|
DECLARE
l_ret_stat varchar2... |
| 30,235,981 | 1,515,467 | 19.95 | 1.49 | 110.82 | 111.61 | 66tmsr3446uqn |
ap.oie.server.WebExpensesAM
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 28,782,722 | 56,504 | 509.39 | 1.42 | 337.22 | 339.46 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 28,583,053 | 1,300 | 21,986.96 | 1.41 | 309.18 | 314.33 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 26,402,611 | 10,000 | 2,640.26 | 1.30 | 81.27 | 177.95 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 23,415,782 | 182,637 | 128.21 | 1.16 | 183.68 | 201.92 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 20,526,741 | 45,424 | 451.89 | 1.01 | 227.60 | 228.81 | 6ubqcscr1gk1b |
asnDispContainer.jsp
|
select name, value from icx_s... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- Total Disk Reads: 439,230
- Captured SQL account for 28.7% 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 | 10.30 | 81.27 | 177.95 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 36,755 | 2,160 | 17.02 | 8.37 | 13.11 | 144.27 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 31,688 | 2,160 | 14.67 | 7.21 | 93.02 | 200.95 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 23,156 | 19,462 | 1.19 | 5.27 | 146.87 | 212.12 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 9,084 | 6,484 | 1.40 | 2.07 | 104.11 | 134.61 | 8jb36w62w5hqf |
ibuSRDetailsActions.jsp
|
BEGIN IBU_REQ_PKG.UpdateServic... |
| 9,037 | 182,637 | 0.05 | 2.06 | 183.68 | 201.92 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 4,779 | 10,000 | 0.48 | 1.09 | 8.29 | 398.20 | 38kpqs2vdwfh9 |
PYUSLV
|
update pay_person_latest_balan... |
| 4,590 | 10,000 | 0.46 | 1.05 | 129.84 | 137.92 | csvvv0fmhr1yc |
PYUSLV
|
BEGIN
FFP1893_01010001.FORMULA... |
| 4,508 | 10,000 | 0.45 | 1.03 | 107.73 | 113.52 | 63t8zpm02skgh |
PYUSLV
|
SELECT DECODE(COUNT(PRR.RUN_RE... |
| 1,488 | 90,807 | 0.02 | 0.34 | 104.45 | 106.63 | 7dtkxnqpkqszw |
jtfavald.jsp
|
SELECT DISTINCT a.PERMISSION_... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 97,850,049
- Captured SQL account for 7.9% of Total
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 1,515,467 | 783,564 | 0.52 | 0.00 | 0.00 | 66tmsr3446uqn |
ap.oie.server.WebExpensesAM
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 859,336 | 859,335 | 1.00 | 0.00 | 0.00 | cd9mbmqyf4qhp |
ap.oie.server.WebExpensesAM
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 537,442 | 537,430 | 1.00 | 0.00 | 0.00 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 452,476 | 452,385 | 1.00 | 0.00 | 0.00 | 821fx90awyvj7 |
OEXOETEL
|
SELECT ACCOUNTING_RULE_ID , A... |
| 337,939 | 337,938 | 1.00 | 0.00 | 0.00 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 315,471 | 242,454 | 0.77 | 0.00 | 0.00 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 261,810 | 4,450,680 | 17.00 | 0.00 | 0.00 | cwyx16zn1hpfb |
JDBC Thin Client
|
select parameter, value from ... |
| 182,637 | 182,634 | 1.00 | 0.00 | 0.00 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 171,664 | 171,664 | 1.00 | 0.00 | 0.00 | 3b3psftuyks81 |
INVTTMTX
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 171,663 | 171,661 | 1.00 | 0.00 | 0.00 | 6gnth2mfbs2nq |
INVTTMTX
|
declare
v_ret number := 0... |
Back to SQL Statistics
Back to Top
SQL ordered by Parse Calls
- Total Parse Calls: 8,510,087
- Captured SQL account for 43.2% of Total
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 537,447 | 537,442 | 6.32 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 337,938 | 337,939 | 3.97 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 315,475 | 315,471 | 3.71 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 261,812 | 261,810 | 3.08 | cwyx16zn1hpfb |
JDBC Thin Client
|
select parameter, value from ... |
| 182,636 | 182,637 | 2.15 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 171,670 | 171,663 | 2.02 | 6gnth2mfbs2nq |
INVTTMTX
|
declare
v_ret number := 0... |
| 122,725 | 122,722 | 1.44 | fb13x9qx0ftks |
OEXOETEL
|
begin OE_STANDARD_WF.OEOL_SELE... |
| 115,180 | 115,176 | 1.35 | 1c0b7sas42w2z |
INVTTMTX
|
SELECT NVL(ITEM_COST, 0), ... |
| 108,307 | 108,306 | 1.27 | 162ttnv4ubqun |
OEXOETEL
|
begin OE_DS_PVT.Check_PO_Appr... |
| 100,197 | 100,194 | 1.18 | 8camsgjsr9zya |
OEXOETEL
|
begin OE_TRANSACTION_TYPES_PK... |
| 97,137 | 97,131 | 1.14 | 76sw2a4vnc89j |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.S... |
| 91,747 | 91,744 | 1.08 | 608c0n36kaw62 |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.C... |
| 91,747 | 91,741 | 1.08 | bf7uwg5pa3pj6 |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.V... |
| 91,747 | 97,134 | 1.08 | 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,361,340 | 3,901 | 0.05 | gz467g1c3hf9v |
qotSCopHdrUpd.jsp
|
SELECT /*+ ORDERED USE_NL(QPQ ... |
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; |
| 38kpqs2vdwfh9 | update pay_person_latest_balances set assignment_action_id=:b1, value=:b2, expired_assignment_action_id=:b3, expired_value=:b4, prev_assignment_action_id=:b5, prev_balance_value=:b6 where rowid=:b7 |
| 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 ) ) |
| 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; |
| 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; |
| bfbyqwbr4vwms | begin OE_OEOL_SCH.SCHEDULE_LINE (: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; |
| 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 |
| fw8fr3nddyd26 | insert into pay_run_balances(run_balance_id, assignment_action_id, assignment_id, action_sequence, defined_balance_id, balance_value, payroll_action_id, effective_date, tax_unit_id, jurisdiction_code, jurisdiction_comp1, jurisdiction_comp2, jurisdiction_comp3, source_id, source_text, tax_group, source_number, source_text2) values (:b1, :b2:b3, :b4:b5, :b6:b7, :b8, :b9, :b10:b11, to_date(:b12, :b13), :b14:b15, :b16:b17, :b18:b19, :b20:b21, :b22:b23, :b24:b25, :b26:b27, :b28:b29, :b30:b31, :b32:b33) |
| 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; |
| gz467g1c3hf9v |
SELECT /*+ ORDERED USE_NL(QPQ QPLAT_Q QPLAT_PROD QPA QPL QPH) INDEX(QPQ QP_QUALIFIERS_N1) INDEX(QPLAT_Q qp_preq_line_attrs_tmp_N2) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) l_list_qual_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, NULL PRICING_ATTRIBUTE_CONTEXT, NULL PRICING_ATTRIBUTE, NULL PRICING_ATTR_VALUE_FROM, NULL PRICING_SETUP_VALUE_FROM, NULL PRICING_SETUP_VALUE_TO, NULL PRICING_ATTRIBUTE_LEVEL, NULL PRICING_ATTRIBUTE_TYPE, NULL PRICING_OPERATOR_TYPE, QPLAT_Q.CONTEXT QUALIFIER_ATTRIBUTE_CONTEXT, QPLAT_Q.ATTRIBUTE QUALIFIER_ATTRIBUTE, QPLAT_Q.VALUE_FROM QUALIFIER_ATTR_VALUE_FROM, QPLAT_Q.PRICING_ATTR_FLAG QUALIFIER_PRICING_ATTR_FLAG, QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO, QPQ.QUALIFIER_PRECEDENCE QUALIFIER_PRECEDENCE, QPQ.QUALIFIER_DATATYPE QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VAL
UE SETUP_VALUE_FROM, QPQ.QUALIFIER_ATTR_VALUE_TO SETUP_VALUE_TO, QPQ.COMPARISON_OPERATOR_CODE QUALIFIER_OPERATOR_TYPE, NULL PRICING_ATTRIBUTE_DATATYPE, DECODE(QPQ.LIST_LINE_ID, -1, 'HQ', 'LQ') QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_QUALIFIERS QPQ, QP_NPREQ_LINE_ATTRS_TMP QPLAT_Q, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B14 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPL.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFF
ECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_Q.ATTRIBUTE_TYPE = :B6 AND (QPQ.QUALIFIER_CONTEXT <> :B5 OR QPQ.QUALIFIER_ATTRIBUTE <> :B4 ) AND QPLAT_Q.CONTEXT = QPQ.QUALIFIER_CONTEXT AND QPLAT_Q.ATTRIBUTE = QPQ.QUALIFIER_ATTRIBUTE AND QPQ.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPQ.ACTIVE_FLAG = :B3 AND ((QPLAT_Q.VALUE_FROM = QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = '=') OR (QPLAT_Q.VALUE_FROM <> QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = 'NOT =') OR QPQ.COMPARISON_OPERATOR_CODE = :B2 ) AND QPLAT_Q.LINE_INDEX = QPLINES.LINE_INDEX AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(QPQ.START_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(QPQ.END_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND QPLAT_PROD.LINE_INDEX = QPLAT_Q.LINE_INDEX AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPLAT_Q. PRICING_STATUS_CODE = :B1 AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) UNION ALL SELECT /*+ ORDERED USE_NL(QPLINES QPQ QPLAT_Q QPLAT_PROD QPA QPLAT_PRIC QPL QPH) INDEX(QPQ QP_QUALIFIERS_N1) INDEX(QPLAT_Q qp_preq_line_attrs_tmp_N2) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) INDEX(QPLAT_PRIC qp_preq_line
_attrs_tmp_N2) l_list_qual_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, QPLAT_PRIC.CONTEXT PRICING_ATTRIBUTE_CONTEXT, QPLAT_PRIC.ATTRIBUTE PRICING_ATTRIBUTE, QPLAT_PRIC.VALUE_FROM PRICING_ATTR_VALUE_FROM, QPA.PRICING_ATTR_VALUE_FROM PRICING_SETUP_VALUE_FROM, QPA.PRICING_ATTR_VALUE_TO PRICING_SETUP_VALUE_TO, QPLAT_PRIC.ATTRIBUTE_LEVEL PRICING_ATTRIBUTE_LEVEL, QPLAT_PRIC.ATTRIBUTE_TYPE PRICING_ATTRIBUTE_TYPE, QPA.COMPARISON_OPERATOR_CODE PRICING_OPERATOR_TYPE, QPLAT_Q.CONTEXT QUALIFIER_ATTRIBUTE_CONTEXT, QPLAT_Q.ATTRIBUTE QUALIFIER_ATTRIBUTE, QPLAT_Q.VALUE_FROM QUALIFIER_ATTR_VALUE_FROM, QPLAT_Q.PRICING_ATTR_FLAG QUALIFIER_PRICING_ATTR_FLAG, QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO, QPQ.QUALIFIER_PRECEDENCE QUALIFIER_PRECEDENCE, QPQ.QUALIFIER_DATATYPE QUALIFIER_DATATYPE, QPQ.QUALIFIER_AT
TR_VALUE SETUP_VALUE_FROM, QPQ.QUALIFIER_ATTR_VALUE_TO SETUP_VALUE_TO, QPQ.COMPARISON_OPERATOR_CODE QUALIFIER_OPERATOR_TYPE, QPA.PRICING_ATTRIBUTE_DATATYPE PRICING_ATTRIBUTE_DATATYPE, DECODE(QPQ.LIST_LINE_ID, -1, 'HQ', 'LQ') QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_QUALIFIERS QPQ, QP_NPREQ_LINE_ATTRS_TMP QPLAT_Q, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PRIC, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B17 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B3 AND QPLINES.PRICING_ATTRS_EXIST_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPLAT_PRIC.CONTEXT = QPA.PRICING_ATTRIBUTE_CONTEXT AND QPLAT_PRIC.ATTRIBUTE = QPA.PRICING_ATTRIBUTE AND (QPLAT_PRIC.VALUE_FROM = QPA.PRICING_ATTR_VALUE_FROM OR QPA.COMPARISON_OPERATOR_CODE IN ('NOT =', :B2 )) AND QPLAT_PRIC.ATTRIBUTE_TYPE = :B16 AND QPLAT_PRIC. PRICING_STATUS_CODE = :B1 AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX AND QPH.LIST_HEADER_ID = QPL.LIST_HEAD
ER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_Q.ATTRIBUTE_TYPE = :B6 AND (QPQ.QUALIFIER_CONTEXT <> :B5 OR QPQ.QUALIFIER_ATTRIBUTE <> :B4 ) AND QPLAT_Q.CONTEXT = QPQ.QUALIFIER_CONTEXT AND QPLAT_Q.ATTRIBUTE = QPQ.QUALIFIER_ATTRIBUTE AND QPQ.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPQ.ACTIVE_FLAG = :B3 AND ((QPLAT_Q.VALUE_FROM = QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = '=') OR (QPLAT_Q.VALUE_FROM <> QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = 'NOT =') OR QPQ.COMPARISON_OPERATOR_CODE = :B2 ) AND QPLAT_Q.LINE_INDEX = QPLINES.LINE_INDEX AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(QPQ.START_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(
QPQ.END_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPLAT_Q.PRICING_STATUS_CODE = :B1 AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) UNION ALL SELECT /*+ ORDERED USE_NL(QPLINES QPLAT_PROD QPA QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) l_list_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, NULL PRICING_ATTRIBUTE_CONTEXT, NULL PRICING_ATTRIBUTE, NULL PRICING_ATTR_VALUE_FROM, NULL PRICING_SETUP_VALUE_FROM, NULL PRICING_SETUP_VALUE_TO, NULL PRICING_ATTRIBUTE_LEVEL, NULL PRICING_ATTRIBUTE_TYPE, NULL PRICING_OPERATOR_TYPE, NULL QUALIFIER_ATTRIBUTE_CONTEXT, NULL QUALIFIER_ATTRIBUTE, NULL QUALIFIER_ATTR_VALUE_FROM, NULL QUALIFIER_PRICING_ATTR_FLAG, -9999 QUALIFIER_GROUPING_NO, 5000 QUALIFIER_PRECEDENCE, NULL
QUALIFIER_DATATYPE, NULL SETUP_VALUE_FROM, NULL SETUP_VALUE_TO, NULL QUALIFIER_OPERATOR_TYPE, NULL PRICING_ATTRIBUTE_DATATYPE, NULL QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B18 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B10 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFE
CTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) UNION ALL SELECT /*+ ORDERED USE_NL(QPLINES QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) INDEX(QPLAT_PRIC qp_preq_line_attrs_tmp_N2) l_list_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, QPLAT_PRIC.CONTEXT PRICING_ATTRIBUTE_CONTEXT, QPLAT_PRIC.ATTRIBUTE PRICING_ATTRIBUTE, QPLAT_PRIC.VALUE_FROM PRICING_ATTR_VALUE_FROM, QPA.PRICING_ATTR_VALUE_FROM PRICING_SETUP_VALUE_FROM, QPA.PRICING_ATTR_VALUE_
TO PRICING_SETUP_VALUE_TO, QPLAT_PRIC.ATTRIBUTE_LEVEL PRICING_ATTRIBUTE_LEVEL, QPLAT_PRIC.ATTRIBUTE_TYPE PRICING_ATTRIBUTE_TYPE, QPA.COMPARISON_OPERATOR_CODE PRICING_OPERATOR_TYPE, NULL QUALIFIER_ATTRIBUTE_CONTEXT, NULL QUALIFIER_ATTRIBUTE, NULL QUALIFIER_ATTR_VALUE_FROM, NULL QUALIFIER_PRICING_ATTR_FLAG, -9999 QUALIFIER_GROUPING_NO, 5000 QUALIFIER_PRECEDENCE, NULL QUALIFIER_DATATYPE, NULL SETUP_VALUE_FROM, NULL SETUP_VALUE_TO, NULL QUALIFIER_OPERATOR_TYPE, QPA.PRICING_ATTRIBUTE_DATATYPE PRICING_ATTRIBUTE_DATATYPE, NULL QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PRIC, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B19 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B10 AND QPLINES.PRICING_ATTRS_EXIST_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPLAT_PRIC.CONTEXT = QPA.PRICING_ATTRIBUTE_CONTEXT AND QPLAT_PRIC.ATTRIBUTE = QP
A.PRICING_ATTRIBUTE AND (QPLAT_PRIC.VALUE_FROM = QPA.PRICING_ATTR_VALUE_FROM OR QPA.COMPARISON_OPERATOR_CODE IN ('NOT =', :B2 )) AND QPLAT_PRIC.ATTRIBUTE_TYPE = :B16 AND QPLAT_PRIC. PRICING_STATUS_CODE = :B1 AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX AND QPH.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) ORDER BY 1, 2 |
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,937,287 | 537.39 | 1.67 |
| CPU used when call started | 1,932,842 | 536.15 | 1.67 |
| CR blocks created | 16,011,813 | 4,441.53 | 13.84 |
| Cached Commit SCN referenced | 47,654 | 13.22 | 0.04 |
| Commit SCN cached | 8 | 0.00 | 0.00 |
| DB time | 5,209,210 | 1,444.99 | 4.50 |
| DBWR checkpoint buffers written | 2,983,521 | 827.60 | 2.58 |
| DBWR checkpoints | 34 | 0.01 | 0.00 |
| DBWR object drop buffers written | 57,953 | 16.08 | 0.05 |
| DBWR revisited being-written buffer | 197 | 0.05 | 0.00 |
| DBWR thread checkpoint buffers written | 639,346 | 177.35 | 0.55 |
| DBWR transaction table writes | 2,288 | 0.63 | 0.00 |
| DBWR undo block writes | 1,585,108 | 439.69 | 1.37 |
| DFO trees parallelized | 48 | 0.01 | 0.00 |
| IMU CR rollbacks | 37,304,078 | 10,347.80 | 32.25 |
| IMU Flushes | 334,958 | 92.91 | 0.29 |
| IMU Redo allocation size | 2,288,521,852 | 634,814.60 | 1,978.66 |
| IMU commits | 601,811 | 166.94 | 0.52 |
| IMU contention | 36,074 | 10.01 | 0.03 |
| IMU ktichg flush | 10,508 | 2.91 | 0.01 |
| IMU pool not allocated | 0 | 0.00 | 0.00 |
| IMU recursive-transaction flush | 1,657 | 0.46 | 0.00 |
| IMU undo allocation size | 5,420,477,984 | 1,503,589.99 | 4,686.55 |
| IMU- failed to get a private strand | 0 | 0.00 | 0.00 |
| PX local messages recv'd | 52,836 | 14.66 | 0.05 |
| PX local messages sent | 52,836 | 14.66 | 0.05 |
| 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 | 47,073,853 | 13,057.85 | 40.70 |
| active txn count during cleanout | 104,830,494 | 29,079.00 | 90.64 |
| application wait time | 17,679 | 4.90 | 0.02 |
| background checkpoints completed | 3 | 0.00 | 0.00 |
| background checkpoints started | 2 | 0.00 | 0.00 |
| background timeouts | 13,901 | 3.86 | 0.01 |
| branch node splits | 1,052 | 0.29 | 0.00 |
| buffer is not pinned count | 568,695,930 | 157,750.94 | 491.70 |
| buffer is pinned count | 1,473,230,256 | 408,660.32 | 1,273.76 |
| bytes received via SQL*Net from client | 10,346,478,470 | 2,870,016.53 | 8,945.58 |
| bytes sent via SQL*Net to client | 9,458,274,336 | 2,623,637.00 | 8,177.64 |
| calls to get snapshot scn: kcmgss | 109,891,561 | 30,482.89 | 95.01 |
| calls to kcmgas | 20,036,121 | 5,557.83 | 17.32 |
| calls to kcmgcs | 11,013,488 | 3,055.04 | 9.52 |
| change write time | 44,960 | 12.47 | 0.04 |
| cleanout - number of ktugct calls | 25,265,595 | 7,008.44 | 21.84 |
| cleanouts and rollbacks - consistent read gets | 13,833,102 | 3,837.17 | 11.96 |
| cleanouts only - consistent read gets | 148,422 | 41.17 | 0.13 |
| cluster key scan block gets | 856,168 | 237.49 | 0.74 |
| cluster key scans | 237,412 | 65.86 | 0.21 |
| commit batch/immediate performed | 4,134 | 1.15 | 0.00 |
| commit batch/immediate requested | 4,134 | 1.15 | 0.00 |
| commit cleanout failures: block lost | 244,930 | 67.94 | 0.21 |
| commit cleanout failures: buffer being written | 558 | 0.15 | 0.00 |
| commit cleanout failures: callback failure | 107,015 | 29.68 | 0.09 |
| commit cleanout failures: cannot pin | 32,967 | 9.14 | 0.03 |
| commit cleanouts | 9,177,693 | 2,545.81 | 7.94 |
| commit cleanouts successfully completed | 8,792,223 | 2,438.88 | 7.60 |
| commit immediate performed | 4,134 | 1.15 | 0.00 |
| commit immediate requested | 4,134 | 1.15 | 0.00 |
| commit txn count during cleanout | 1,325,727 | 367.74 | 1.15 |
| concurrency wait time | 12,614 | 3.50 | 0.01 |
| consistent changes | 799,285,700 | 221,714.39 | 691.06 |
| consistent gets | 1,806,365,572 | 501,068.94 | 1,561.79 |
| consistent gets - examination | 1,278,942,261 | 354,766.64 | 1,105.78 |
| consistent gets from cache | 1,806,365,558 | 501,068.94 | 1,561.79 |
| cursor authentications | 2,120 | 0.59 | 0.00 |
| data blocks consistent reads - undo records applied | 795,360,272 | 220,625.51 | 687.67 |
| db block changes | 196,360,398 | 54,468.54 | 169.77 |
| db block gets | 219,222,733 | 60,810.34 | 189.54 |
| db block gets direct | 4,284 | 1.19 | 0.00 |
| db block gets from cache | 219,218,448 | 60,809.15 | 189.54 |
| deferred (CURRENT) block cleanout applications | 1,603,750 | 444.87 | 1.39 |
| dirty buffers inspected | 8,593 | 2.38 | 0.01 |
| enqueue conversions | 9,730 | 2.70 | 0.01 |
| enqueue releases | 4,344,191 | 1,205.04 | 3.76 |
| enqueue requests | 4,351,487 | 1,207.06 | 3.76 |
| enqueue timeouts | 7,210 | 2.00 | 0.01 |
| enqueue waits | 32,382 | 8.98 | 0.03 |
| exchange deadlocks | 27,303 | 7.57 | 0.02 |
| execute count | 97,850,049 | 27,142.69 | 84.60 |
| failed probes on index block reclamation | 12,621 | 3.50 | 0.01 |
| frame signature mismatch | 304 | 0.08 | 0.00 |
| free buffer inspected | 3,059,756 | 848.75 | 2.65 |
| free buffer requested | 20,391,855 | 5,656.51 | 17.63 |
| heap block compress | 32,980,869 | 9,148.59 | 28.52 |
| hot buffers moved to head of LRU | 1,309,365 | 363.21 | 1.13 |
| immediate (CR) block cleanout applications | 13,981,543 | 3,878.35 | 12.09 |
| immediate (CURRENT) block cleanout applications | 1,134,141 | 314.60 | 0.98 |
| index crx upgrade (found) | 22,160 | 6.15 | 0.02 |
| index crx upgrade (positioned) | 9,760,129 | 2,707.37 | 8.44 |
| index fast full scans (rowid ranges) | 824 | 0.23 | 0.00 |
| index fetch by key | 180,513,677 | 50,072.81 | 156.07 |
| index scans kdiixs1 | 133,939,271 | 37,153.50 | 115.80 |
| java call heap collected bytes | 1,414,009,736 | 392,233.10 | 1,222.56 |
| java call heap collected count | 17,326,790 | 4,806.29 | 14.98 |
| java call heap gc count | 4,645 | 1.29 | 0.00 |
| java call heap live object count | 1,544,144 | 428.33 | 1.34 |
| java call heap live object count max | 1,552,691 | 430.70 | 1.34 |
| java call heap live size | 375,651,440 | 104,202.20 | 324.79 |
| java call heap live size max | 377,623,320 | 104,749.18 | 326.49 |
| java call heap object count | 3,709,293 | 1,028.92 | 3.21 |
| java call heap object count max | 3,719,594 | 1,031.78 | 3.22 |
| java call heap total size | 485,097,472 | 134,561.51 | 419.42 |
| java call heap total size max | 487,201,792 | 135,145.23 | 421.24 |
| java call heap used size | 514,354,416 | 142,677.11 | 444.71 |
| java call heap used size max | 516,590,616 | 143,297.41 | 446.65 |
| leaf node 90-10 splits | 20,737 | 5.75 | 0.02 |
| leaf node splits | 241,665 | 67.04 | 0.21 |
| lob reads | 21,413 | 5.94 | 0.02 |
| lob writes | 37,206 | 10.32 | 0.03 |
| lob writes unaligned | 37,206 | 10.32 | 0.03 |
| logons cumulative | 9,312 | 2.58 | 0.01 |
| messages received | 2,303,677 | 639.02 | 1.99 |
| messages sent | 2,303,676 | 639.02 | 1.99 |
| no buffer to keep pinned count | 16 | 0.00 | 0.00 |
| no work - consistent read gets | 478,808,494 | 132,817.01 | 413.98 |
| opened cursors cumulative | 5,511,597 | 1,528.87 | 4.77 |
| parse count (failures) | 3,250 | 0.90 | 0.00 |
| parse count (hard) | 8,876 | 2.46 | 0.01 |
| parse count (total) | 8,510,087 | 2,360.62 | 7.36 |
| parse time cpu | 43,337 | 12.02 | 0.04 |
| parse time elapsed | 46,836 | 12.99 | 0.04 |
| physical read IO requests | 290,826 | 80.67 | 0.25 |
| physical read bytes | 3,598,172,160 | 998,099.36 | 3,110.99 |
| physical read total IO requests | 320,101 | 88.79 | 0.28 |
| physical read total bytes | 4,076,904,448 | 1,130,895.23 | 3,524.90 |
| physical read total multi block requests | 12,003 | 3.33 | 0.01 |
| physical reads | 439,230 | 121.84 | 0.38 |
| physical reads cache | 438,095 | 121.52 | 0.38 |
| physical reads cache prefetch | 148,006 | 41.06 | 0.13 |
| physical reads direct | 1,135 | 0.31 | 0.00 |
| physical reads direct temporary tablespace | 403 | 0.11 | 0.00 |
| physical reads prefetch warmup | 79,001 | 21.91 | 0.07 |
| physical write IO requests | 1,200,045 | 332.88 | 1.04 |
| physical write bytes | 25,165,127,680 | 6,980,571.47 | 21,757.81 |
| physical write total IO requests | 2,417,538 | 670.60 | 2.09 |
| physical write total bytes | 58,192,146,944 | 16,141,958.26 | 50,313.03 |
| physical write total multi block requests | 1,406,043 | 390.02 | 1.22 |
| physical writes | 3,071,915 | 852.12 | 2.66 |
| physical writes direct | 5,020 | 1.39 | 0.00 |
| physical writes direct (lob) | 219 | 0.06 | 0.00 |
| physical writes direct temporary tablespace | 4,400 | 1.22 | 0.00 |
| physical writes from cache | 3,066,895 | 850.73 | 2.65 |
| physical writes non checkpoint | 2,321,319 | 643.91 | 2.01 |
| pinned buffers inspected | 4,042 | 1.12 | 0.00 |
| prefetch warmup blocks aged out before use | 243,215 | 67.47 | 0.21 |
| prefetched blocks aged out before use | 116 | 0.03 | 0.00 |
| process last non-idle time | 3,605 | 1.00 | 0.00 |
| queries parallelized | 48 | 0.01 | 0.00 |
| recursive aborts on index block reclamation | 2 | 0.00 | 0.00 |
| recursive calls | 158,520,480 | 43,972.10 | 137.06 |
| recursive cpu usage | 1,089,715 | 302.28 | 0.94 |
| redo blocks written | 64,339,000 | 17,847.04 | 55.63 |
| redo buffer allocation retries | 211 | 0.06 | 0.00 |
| redo entries | 101,050,912 | 28,030.58 | 87.37 |
| redo log space requests | 0 | 0.00 | 0.00 |
| redo log space wait time | 0 | 0.00 | 0.00 |
| redo ordering marks | 1,277,047 | 354.24 | 1.10 |
| redo size | 31,554,693,908 | 8,752,977.49 | 27,282.24 |
| redo subscn max counts | 2,334,595 | 647.59 | 2.02 |
| redo synch time | 71,719 | 19.89 | 0.06 |
| redo synch writes | 2,186,220 | 606.44 | 1.89 |
| redo wastage | 309,193,776 | 85,767.47 | 267.33 |
| redo write time | 38,355 | 10.64 | 0.03 |
| redo writer latching time | 156 | 0.04 | 0.00 |
| redo writes | 813,759 | 225.73 | 0.70 |
| rollback changes - undo records applied | 220,158 | 61.07 | 0.19 |
| rollbacks only - consistent read gets | 2,330,479 | 646.45 | 2.01 |
| rows fetched via callback | 94,350,709 | 26,172.01 | 81.58 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 5,370,078 | 1,489.61 | 4.64 |
| session logical reads | 2,025,588,843 | 561,879.43 | 1,751.33 |
| session pga memory | 9,388,017,248 | 2,604,148.34 | 8,116.90 |
| session pga memory max | 10,344,395,776 | 2,869,438.81 | 8,943.78 |
| session uga memory | ############### | 74,879,256.30 | 233,391.88 |
| session uga memory max | 67,781,103,296 | 18,801,845.23 | 58,603.65 |
| shared hash latch upgrades - no wait | 31,618,527 | 8,770.68 | 27.34 |
| shared hash latch upgrades - wait | 36,941 | 10.25 | 0.03 |
| sorts (memory) | 10,337,154 | 2,867.43 | 8.94 |
| sorts (rows) | 128,116,585 | 35,538.34 | 110.77 |
| sql area evicted | 2,782 | 0.77 | 0.00 |
| sql area purged | 3,420 | 0.95 | 0.00 |
| summed dirty queue length | 458,784 | 127.26 | 0.40 |
| switch current to new buffer | 1,358,632 | 376.87 | 1.17 |
| table fetch by rowid | 872,213,891 | 241,943.99 | 754.12 |
| table fetch continued row | 30,276,008 | 8,398.28 | 26.18 |
| table scan blocks gotten | 94,007,611 | 26,076.83 | 81.28 |
| table scan rows gotten | 7,349,181,714 | 2,038,594.39 | 6,354.11 |
| table scans (long tables) | 2,058 | 0.57 | 0.00 |
| table scans (rowid ranges) | 2,056 | 0.57 | 0.00 |
| table scans (short tables) | 5,686,081 | 1,577.27 | 4.92 |
| total number of times SMON posted | 133,293 | 36.97 | 0.12 |
| transaction rollbacks | 4,134 | 1.15 | 0.00 |
| transaction tables consistent read rollbacks | 60 | 0.02 | 0.00 |
| transaction tables consistent reads - undo records applied | 5,426 | 1.51 | 0.00 |
| undo change vector size | 11,032,576,764 | 3,060,333.79 | 9,538.78 |
| user I/O wait time | 104,993 | 29.12 | 0.09 |
| user calls | 44,944,237 | 12,467.11 | 38.86 |
| user commits | 918,140 | 254.68 | 0.79 |
| user rollbacks | 238,462 | 66.15 | 0.21 |
| workarea executions - onepass | 2 | 0.00 | 0.00 |
| workarea executions - optimal | 6,070,521 | 1,683.91 | 5.25 |
| write clones created in background | 1,563 | 0.43 | 0.00 |
| write clones created in foreground | 4,609 | 1.28 | 0.00 |
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 | 508,690 | 1,160,615 |
| opened cursors current | 1,008,193 | 1,119,537 |
| workarea memory allocated | 2,562 | 160 |
| logons current | 4,768 | 4,783 |
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 |
32 | 0 | 9.06 | 1.00 | 529,391 | 147 | 250,812 | 0.02 |
| APPS_TS_TX_DATA |
171,477 | 48 | 3.50 | 1.28 | 170,904 | 47 | 119,598 | 0.19 |
| APPS_TS_TX_IDX |
94,094 | 26 | 3.51 | 1.32 | 194,488 | 54 | 50,935 | 0.32 |
| APPS_ASSM_DATA |
8,728 | 2 | 1.96 | 6.56 | 133,674 | 37 | 44,727 | 0.33 |
| APPS_ASSM_IDX |
6,589 | 2 | 1.95 | 1.04 | 112,190 | 31 | 184,854 | 0.09 |
| APPS_TS_TX_INTERFACE |
1,186 | 0 | 1.69 | 2.11 | 27,086 | 8 | 10,328 | 0.03 |
| TEMP |
478 | 0 | 3.49 | 10.07 | 9,496 | 3 | 33 | 1.82 |
| SYSTEM |
5,010 | 1 | 3.42 | 3.68 | 2,457 | 1 | 22,696 | 0.05 |
| APPS_TS_SEED |
2,179 | 1 | 4.47 | 1.61 | 4,914 | 1 | 726 | 1.98 |
| APPS_TS_SUMMARY |
56 | 0 | 7.50 | 1.00 | 6,954 | 2 | 2,667 | 0.01 |
| APPS_TS_QUEUES |
372 | 0 | 4.25 | 2.35 | 5,053 | 1 | 447 | 0.22 |
| APPS_TS_ARCHIVE |
66 | 0 | 4.70 | 1.17 | 1,991 | 1 | 88 | 4.20 |
| SYSAUX |
307 | 0 | 2.25 | 1.07 | 1,427 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING |
25 | 0 | 4.40 | 1.56 | 35 | 0 | 3 | 0.00 |
| CTXSYS |
24 | 0 | 4.17 | 1.00 | 6 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA |
12 | 0 | 5.83 | 1.00 | 9 | 0 | 0 | 0.00 |
| ODM |
12 | 0 | 5.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| OLAP |
12 | 0 | 3.33 | 1.00 | 3 | 0 | 0 | 0.00 |
| OWAPUB |
12 | 0 | 4.17 | 1.00 | 3 | 0 | 0 | 0.00 |
| PORTAL |
12 | 0 | 4.17 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYNCSERVER |
12 | 0 | 4.17 | 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,728 | 2 | 1.96 | 6.56 | 133,674 | 37 | 44,727 | 0.33 |
| APPS_ASSM_IDX | /DB/visdata/apps_assm_idx.dbf |
6,589 | 2 | 1.95 | 1.04 | 112,190 | 31 | 184,854 | 0.09 |
| APPS_TS_ARCHIVE | /DB/visdata/archive1.dbf |
35 | 0 | 5.14 | 1.00 | 1,741 | 0 | 86 | 4.30 |
| APPS_TS_ARCHIVE | /DB/visdata/archive2.dbf |
31 | 0 | 4.19 | 1.35 | 250 | 0 | 2 | 0.00 |
| APPS_TS_MEDIA | /DB/visdata/media1.dbf |
4 | 0 | 5.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /DB/visdata/media2.dbf |
4 | 0 | 5.00 | 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 | 5.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /DB/visdata/nologging2.dbf |
15 | 0 | 4.00 | 1.00 | 18 | 0 | 3 | 0.00 |
| APPS_TS_NOLOGGING | /DB/visdata/nologging3.dbf |
6 | 0 | 5.00 | 3.33 | 14 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues1.dbf |
49 | 0 | 4.08 | 2.18 | 643 | 0 | 216 | 0.23 |
| APPS_TS_QUEUES | /DB/visdata/queues2.dbf |
30 | 0 | 3.00 | 3.10 | 840 | 0 | 183 | 0.22 |
| APPS_TS_QUEUES | /DB/visdata/queues3.dbf |
36 | 0 | 4.44 | 2.58 | 756 | 0 | 1 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues4.dbf |
41 | 0 | 3.41 | 2.83 | 741 | 0 | 2 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues5.dbf |
40 | 0 | 3.50 | 2.05 | 630 | 0 | 4 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues6.dbf |
38 | 0 | 4.47 | 2.76 | 602 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues7.dbf |
138 | 0 | 4.93 | 2.02 | 841 | 0 | 41 | 0.24 |
| APPS_TS_SEED | /DB/visdata/reference1.dbf |
185 | 0 | 4.76 | 1.81 | 455 | 0 | 39 | 3.59 |
| APPS_TS_SEED | /DB/visdata/reference10.dbf |
184 | 0 | 4.78 | 1.67 | 531 | 0 | 43 | 0.93 |
| APPS_TS_SEED | /DB/visdata/reference2.dbf |
219 | 0 | 4.57 | 1.52 | 521 | 0 | 44 | 4.32 |
| APPS_TS_SEED | /DB/visdata/reference3.dbf |
337 | 0 | 4.36 | 1.54 | 547 | 0 | 418 | 1.89 |
| APPS_TS_SEED | /DB/visdata/reference4.dbf |
193 | 0 | 3.99 | 1.67 | 477 | 0 | 36 | 2.50 |
| APPS_TS_SEED | /DB/visdata/reference5.dbf |
243 | 0 | 4.20 | 1.50 | 466 | 0 | 10 | 1.00 |
| APPS_TS_SEED | /DB/visdata/reference6.dbf |
223 | 0 | 4.53 | 1.73 | 514 | 0 | 14 | 0.71 |
| APPS_TS_SEED | /DB/visdata/reference7.dbf |
223 | 0 | 4.84 | 1.52 | 439 | 0 | 20 | 1.00 |
| APPS_TS_SEED | /DB/visdata/reference8.dbf |
197 | 0 | 3.91 | 1.69 | 448 | 0 | 30 | 3.33 |
| APPS_TS_SEED | /DB/visdata/reference9.dbf |
175 | 0 | 4.86 | 1.54 | 516 | 0 | 72 | 0.69 |
| APPS_TS_SUMMARY | /DB/visdata/summary1.dbf |
5 | 0 | 8.00 | 1.00 | 849 | 0 | 296 | 0.03 |
| APPS_TS_SUMMARY | /DB/visdata/summary2.dbf |
5 | 0 | 6.00 | 1.00 | 765 | 0 | 292 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary3.dbf |
7 | 0 | 4.29 | 1.00 | 786 | 0 | 251 | 0.12 |
| APPS_TS_SUMMARY | /DB/visdata/summary4.dbf |
11 | 0 | 5.45 | 1.00 | 694 | 0 | 252 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary5.dbf |
7 | 0 | 8.57 | 1.00 | 889 | 0 | 370 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary6.dbf |
7 | 0 | 10.00 | 1.00 | 935 | 0 | 713 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary7.dbf |
7 | 0 | 10.00 | 1.00 | 988 | 0 | 254 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary8.dbf |
7 | 0 | 8.57 | 1.00 | 1,048 | 0 | 239 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data1.dbf |
3,090 | 1 | 3.97 | 1.18 | 333 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data10.dbf |
3,050 | 1 | 3.94 | 1.17 | 228 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data11.dbf |
3,055 | 1 | 3.93 | 1.22 | 190 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data12.dbf |
12,961 | 4 | 2.59 | 1.21 | 2,860 | 1 | 2,786 | 0.92 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data13.dbf |
17,292 | 5 | 3.75 | 1.43 | 4,608 | 1 | 1,806 | 0.91 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data14.dbf |
12,923 | 4 | 3.46 | 1.33 | 25,084 | 7 | 14,929 | 0.16 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data15.dbf |
9,170 | 3 | 3.21 | 1.39 | 23,947 | 7 | 16,046 | 0.21 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data16.dbf |
9,204 | 3 | 3.25 | 1.41 | 23,152 | 6 | 16,960 | 0.15 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data17.dbf |
9,108 | 3 | 3.22 | 1.40 | 22,215 | 6 | 16,464 | 0.13 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data18.dbf |
9,148 | 3 | 3.21 | 1.38 | 21,311 | 6 | 15,487 | 0.16 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data19.dbf |
9,041 | 3 | 3.27 | 1.40 | 21,364 | 6 | 16,369 | 0.14 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data2.dbf |
6,525 | 2 | 2.90 | 1.13 | 757 | 0 | 1,422 | 0.95 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data20.dbf |
9,134 | 3 | 3.37 | 1.42 | 21,325 | 6 | 15,733 | 0.13 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data21.dbf |
22,042 | 6 | 3.84 | 1.21 | 988 | 0 | 1,532 | 0.03 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data3.dbf |
3,564 | 1 | 4.27 | 1.30 | 420 | 0 | 9 | 5.56 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data4.dbf |
16,718 | 5 | 3.76 | 1.06 | 288 | 0 | 9 | 6.67 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data5.dbf |
3,072 | 1 | 3.99 | 1.17 | 390 | 0 | 8 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data6.dbf |
3,082 | 1 | 3.69 | 1.19 | 224 | 0 | 9 | 7.78 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data7.dbf |
3,035 | 1 | 3.78 | 1.20 | 482 | 0 | 14 | 0.71 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data8.dbf |
3,060 | 1 | 3.90 | 1.21 | 470 | 0 | 14 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data9.dbf |
3,203 | 1 | 4.03 | 1.23 | 268 | 0 | 1 | 0.00 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx1.dbf |
2,479 | 1 | 3.10 | 1.12 | 2,141 | 1 | 1,066 | 0.69 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx10.dbf |
2,450 | 1 | 3.03 | 1.13 | 1,394 | 0 | 1,173 | 0.60 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx11.dbf |
2,456 | 1 | 3.14 | 1.15 | 1,542 | 0 | 1,110 | 0.54 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx12.dbf |
11,000 | 3 | 3.89 | 1.55 | 20,558 | 6 | 1,293 | 0.39 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx13.dbf |
9,664 | 3 | 3.61 | 1.28 | 27,015 | 7 | 3,225 | 0.37 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx14.dbf |
5,812 | 2 | 3.75 | 1.35 | 19,561 | 5 | 3,095 | 0.12 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx15.dbf |
5,719 | 2 | 3.63 | 1.39 | 16,862 | 5 | 3,393 | 0.18 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx16.dbf |
5,686 | 2 | 3.74 | 1.40 | 15,729 | 4 | 3,598 | 0.12 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx17.dbf |
5,583 | 2 | 3.50 | 1.34 | 14,284 | 4 | 3,599 | 0.23 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx18.dbf |
5,813 | 2 | 3.68 | 1.36 | 14,873 | 4 | 5,036 | 0.14 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx19.dbf |
5,775 | 2 | 3.79 | 1.38 | 13,746 | 4 | 3,878 | 0.31 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx2.dbf |
3,065 | 1 | 3.43 | 1.23 | 1,893 | 1 | 1,150 | 0.41 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx20.dbf |
5,570 | 2 | 3.65 | 1.38 | 13,495 | 4 | 2,411 | 0.08 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx21.dbf |
3,364 | 1 | 3.92 | 1.51 | 13,987 | 4 | 2,078 | 0.50 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx3.dbf |
4,020 | 1 | 2.45 | 1.09 | 1,844 | 1 | 1,572 | 1.26 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx4.dbf |
2,667 | 1 | 3.27 | 1.09 | 3,108 | 1 | 1,365 | 0.87 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx5.dbf |
2,656 | 1 | 3.23 | 1.18 | 4,362 | 1 | 7,396 | 0.10 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx6.dbf |
2,674 | 1 | 3.26 | 1.17 | 2,411 | 1 | 1,175 | 0.66 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx7.dbf |
2,586 | 1 | 3.03 | 1.18 | 2,253 | 1 | 952 | 0.68 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx8.dbf |
2,520 | 1 | 3.21 | 1.12 | 1,752 | 0 | 1,225 | 0.59 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx9.dbf |
2,535 | 1 | 2.91 | 1.17 | 1,678 | 0 | 1,145 | 0.52 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte.dbf |
144 | 0 | 1.53 | 2.06 | 4,168 | 1 | 2,029 | 0.02 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte2.dbf |
399 | 0 | 1.38 | 1.81 | 5,533 | 2 | 2,227 | 0.04 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte3.dbf |
184 | 0 | 2.23 | 2.35 | 4,651 | 1 | 1,954 | 0.02 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte4.dbf |
155 | 0 | 1.81 | 2.36 | 4,370 | 1 | 1,483 | 0.04 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte5.dbf |
246 | 0 | 1.30 | 1.79 | 4,246 | 1 | 1,757 | 0.03 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte6.dbf |
58 | 0 | 3.97 | 4.24 | 4,118 | 1 | 878 | 0.02 |
| APPS_UNDOTS1 | /DB/visdata/undo01.dbf |
3 | 0 | 6.67 | 1.00 | 59,015 | 16 | 24,062 | 0.02 |
| APPS_UNDOTS1 | /DB/visdata/undo02.dbf |
4 | 0 | 5.00 | 1.00 | 54,787 | 15 | 23,159 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo03.dbf |
3 | 0 | 10.00 | 1.00 | 50,216 | 14 | 27,953 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo04.dbf |
4 | 0 | 10.00 | 1.00 | 48,907 | 14 | 25,905 | 0.02 |
| APPS_UNDOTS1 | /DB/visdata/undo05.dbf |
3 | 0 | 13.33 | 1.00 | 51,633 | 14 | 24,276 | 0.02 |
| APPS_UNDOTS1 | /DB/visdata/undo06.dbf |
3 | 0 | 6.67 | 1.00 | 50,170 | 14 | 22,161 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo07.dbf |
3 | 0 | 16.67 | 1.00 | 47,936 | 13 | 23,620 | 0.02 |
| APPS_UNDOTS1 | /DB/visdata/undo08.dbf |
3 | 0 | 3.33 | 1.00 | 51,459 | 14 | 23,462 | 0.02 |
| APPS_UNDOTS1 | /DB/visdata/undo09.dbf |
3 | 0 | 10.00 | 1.00 | 56,248 | 16 | 29,180 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo10.dbf |
3 | 0 | 10.00 | 1.00 | 59,020 | 16 | 27,034 | 0.02 |
| CTXSYS | /DB/visdata/ctx1.dbf |
12 | 0 | 5.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| CTXSYS | /DB/visdata/ctx2.dbf |
12 | 0 | 3.33 | 1.00 | 3 | 0 | 0 | 0.00 |
| ODM | /DB/visdata/odm.dbf |
12 | 0 | 5.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| OLAP | /DB/visdata/olap.dbf |
12 | 0 | 3.33 | 1.00 | 3 | 0 | 0 | 0.00 |
| OWAPUB | /DB/visdata/owa1.dbf |
12 | 0 | 4.17 | 1.00 | 3 | 0 | 0 | 0.00 |
| PORTAL | /DB/visdata/portal.dbf |
12 | 0 | 4.17 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYNCSERVER | /DB/visdata/mobile01.dbf |
12 | 0 | 4.17 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYSAUX | /DB/visdata/sysaux01.dbf |
6 | 0 | 6.67 | 1.33 | 552 | 0 | 0 | 0.00 |
| SYSAUX | /DB/visdata/sysaux02.dbf |
301 | 0 | 2.16 | 1.06 | 875 | 0 | 0 | 0.00 |
| SYSTEM | /DB/visdata/sys1.dbf |
534 | 0 | 3.15 | 4.14 | 105 | 0 | 53 | 0.00 |
| SYSTEM | /DB/visdata/sys2.dbf |
516 | 0 | 3.91 | 4.43 | 178 | 0 | 67 | 0.30 |
| SYSTEM | /DB/visdata/sys3.dbf |
692 | 0 | 2.93 | 3.46 | 241 | 0 | 0 | 0.00 |
| SYSTEM | /DB/visdata/sys4.dbf |
624 | 0 | 2.85 | 3.73 | 231 | 0 | 0 | 0.00 |
| SYSTEM | /DB/visdata/sys5.dbf |
808 | 0 | 3.61 | 3.10 | 627 | 0 | 1,784 | 0.06 |
| SYSTEM | /DB/visdata/sys6.dbf |
552 | 0 | 3.35 | 4.20 | 63 | 0 | 8 | 0.00 |
| SYSTEM | /DB/visdata/sys7.dbf |
443 | 0 | 3.81 | 4.31 | 156 | 0 | 110 | 0.82 |
| SYSTEM | /DB/visdata/sys8.dbf |
377 | 0 | 3.77 | 3.21 | 441 | 0 | 20,628 | 0.04 |
| SYSTEM | /DB/visdata/sys9.dbf |
464 | 0 | 3.71 | 2.69 | 415 | 0 | 46 | 1.09 |
| TEMP | /DB/visdata/temp1.dbf |
124 | 0 | 3.87 | 16.81 | 2,568 | 1 | 24 | 1.67 |
| TEMP | /DB/visdata/temp2.dbf |
150 | 0 | 3.47 | 16.84 | 2,508 | 1 | 0 | |
| TEMP | /DB/visdata/temp3.dbf |
116 | 0 | 3.02 | 1.00 | 1,950 | 1 | 0 | |
| TEMP | /DB/visdata/temp4.dbf |
88 | 0 | 3.64 | 1.00 | 2,470 | 1 | 9 | 2.22 |
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,204,606 | 100 | 2,025,349,202 | 438,073 | 3,066,895 | 0 | 0 | 687,916 |
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 | 90 | 43824 | 1061578 | 4138619 | 188743680 | 4138619 | |
| E | 180 | 91 | 47928 | 1068193 | 9681343 | 188743680 | 9681343 | |
Back to Advisory Statistics
Back to Top
|
