|
|
|
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 | 01-May-09 19:39:49 | 5240 | 208.7 |
| End Snap: | 4 | 01-May-09 20:39:54 | 5282 | 234.8 |
| Elapsed: | | 60.08 (mins) | | |
| DB Time: | | 449.10 (mins) | | |
Report Summary
Cache Sizes
| Begin | End | | |
|---|
| Buffer Cache: | 17,808M | 17,616M | Std Block Size: | 8K |
| Shared Pool Size: | 2,576M | 2,768M | Log Buffer: | 14,320K |
Load Profile
| Per Second | Per Transaction |
|---|
| Redo size: | 8,950,340.81 | 25,808.93 |
| Logical reads: | 581,183.59 | 1,675.88 |
| Block changes: | 55,892.08 | 161.17 |
| Physical reads: | 123.64 | 0.36 |
| Physical writes: | 875.62 | 2.52 |
| User calls: | 13,786.55 | 39.75 |
| Parses: | 2,573.35 | 7.42 |
| Hard parses: | 2.67 | 0.01 |
| Sorts: | 3,060.42 | 8.82 |
| Logons: | 2.83 | 0.01 |
| Executes: | 29,106.05 | 83.93 |
| Transactions: | 346.79 | |
| % Blocks changed per Read: | 9.62 | Recursive Call %: | 77.35 |
| Rollback per transaction %: | 21.19 | Rows per Sort: | 12.43 |
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.16 | Latch Hit %: | 99.01 |
| Parse CPU to Parse Elapsd %: | 94.35 | % Non-Parse CPU: | 97.71 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 86.40 | 86.78 |
| % SQL with executions>1: | 87.95 | 93.82 |
| % Memory for SQL w/exec>1: | 65.25 | 85.98 |
Top 5 Timed Events
| Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
|---|
| CPU time | | 21,152 | | 78.5 | |
| SQL*Net more data from client | 2,572,653 | 6,118 | 2 | 22.7 | Network |
| db file sequential read | 286,011 | 981 | 3 | 3.6 | User I/O |
| log file sync | 546,213 | 786 | 1 | 2.9 | Commit |
| log file parallel write | 862,622 | 352 | 0 | 1.3 | 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): 26946s
- 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 | 21,152.48 | 78.50 |
| sql execute elapsed time | 20,339.37 | 75.48 |
| PL/SQL execution elapsed time | 7,797.45 | 28.94 |
| inbound PL/SQL rpc elapsed time | 7,648.51 | 28.38 |
| parse time elapsed | 586.57 | 2.18 |
| Java execution elapsed time | 506.25 | 1.88 |
| hard parse elapsed time | 312.13 | 1.16 |
| repeated bind elapsed time | 85.44 | 0.32 |
| sequence load elapsed time | 14.26 | 0.05 |
| connection management call elapsed time | 10.92 | 0.04 |
| PL/SQL compilation elapsed time | 6.56 | 0.02 |
| hard parse (sharing criteria) elapsed time | 4.96 | 0.02 |
| failed parse elapsed time | 1.62 | 0.01 |
| hard parse (bind mismatch) elapsed time | 1.03 | 0.00 |
| DB time | 26,946.02 | |
| background elapsed time | 1,061.64 | |
| background cpu time | 371.37 | |
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 | 56,683,829 | 0.00 | 6,162 | 0 | 45.34 |
| User I/O | 343,228 | 0.00 | 1,103 | 3 | 0.27 |
| Commit | 546,213 | 0.00 | 786 | 1 | 0.44 |
| System I/O | 1,175,731 | 0.00 | 506 | 0 | 0.94 |
| Application | 70,342 | 0.09 | 233 | 3 | 0.06 |
| Concurrency | 2,577,882 | 0.15 | 171 | 0 | 2.06 |
| Other | 163,541 | 17.74 | 43 | 0 | 0.13 |
| Configuration | 6,781 | 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,572,653 | 0.00 | 6,118 | 2 | 2.06 |
| db file sequential read | 286,011 | 0.00 | 981 | 3 | 0.23 |
| log file sync | 546,213 | 0.00 | 786 | 1 | 0.44 |
| log file parallel write | 862,622 | 0.00 | 352 | 0 | 0.69 |
| enq: TX - row lock contention | 762 | 6.30 | 157 | 207 | 0.00 |
| db file parallel write | 281,239 | 0.00 | 147 | 1 | 0.22 |
| latch: cache buffers chains | 1,818,560 | 0.00 | 65 | 0 | 1.45 |
| read by other session | 42,379 | 0.00 | 63 | 1 | 0.03 |
| db file scattered read | 11,975 | 0.00 | 58 | 5 | 0.01 |
| enq: UL - contention | 2,080 | 0.72 | 55 | 26 | 0.00 |
| cursor: pin S wait on X | 4,132 | 90.51 | 41 | 10 | 0.00 |
| SQL*Net message to client | 52,070,964 | 0.00 | 25 | 0 | 41.65 |
| buffer busy waits | 686,819 | 0.00 | 23 | 0 | 0.55 |
| SQL*Net more data to client | 2,040,212 | 0.00 | 19 | 0 | 1.63 |
| enq: TX - index contention | 27,962 | 0.00 | 12 | 0 | 0.02 |
| library cache load lock | 580 | 0.00 | 11 | 19 | 0.00 |
| SQL*Net break/reset to client | 67,466 | 0.00 | 11 | 0 | 0.05 |
| latch: undo global data | 31,700 | 0.00 | 10 | 0 | 0.03 |
| PX Deq Credit: send blkd | 22,603 | 0.00 | 9 | 0 | 0.02 |
| latch: library cache | 11,027 | 0.00 | 7 | 1 | 0.01 |
| enq: RO - fast object reuse | 29 | 0.00 | 7 | 237 | 0.00 |
| rdbms ipc reply | 5 | 60.00 | 7 | 1350 | 0.00 |
| control file sequential read | 30,131 | 0.00 | 6 | 0 | 0.02 |
| latch: In memory undo latch | 19,272 | 0.00 | 6 | 0 | 0.02 |
| enq: TM - contention | 5 | 0.00 | 3 | 626 | 0.00 |
| PX Deq: Signal ACK | 246 | 41.06 | 3 | 12 | 0.00 |
| latch: object queue header operation | 23,581 | 0.00 | 3 | 0 | 0.02 |
| kksfbc child completion | 61 | 81.97 | 2 | 41 | 0.00 |
| os thread startup | 71 | 0.00 | 2 | 32 | 0.00 |
| latch: library cache pin | 2,974 | 0.00 | 2 | 1 | 0.00 |
| latch free | 3,168 | 0.00 | 2 | 1 | 0.00 |
| LGWR wait for redo copy | 34,486 | 0.00 | 1 | 0 | 0.03 |
| local write wait | 1,593 | 0.00 | 1 | 1 | 0.00 |
| latch: cache buffers lru chain | 1,764 | 0.00 | 1 | 1 | 0.00 |
| enq: HW - contention | 2,431 | 0.00 | 1 | 1 | 0.00 |
| log buffer space | 219 | 0.00 | 1 | 5 | 0.00 |
| control file parallel write | 1,739 | 0.00 | 1 | 1 | 0.00 |
| enq: TX - contention | 2,751 | 0.00 | 1 | 0 | 0.00 |
| latch: row cache objects | 968 | 0.00 | 1 | 1 | 0.00 |
| latch: redo allocation | 1,141 | 0.00 | 1 | 1 | 0.00 |
| enq: DV - contention | 146 | 0.00 | 1 | 4 | 0.00 |
| enq: SQ - contention | 3,960 | 0.00 | 1 | 0 | 0.00 |
| library cache pin | 2,324 | 0.00 | 1 | 0 | 0.00 |
| wait list latch free | 41 | 0.00 | 0 | 12 | 0.00 |
| buffer deadlock | 28,799 | 99.09 | 0 | 0 | 0.02 |
| latch: session allocation | 693 | 0.00 | 0 | 1 | 0.00 |
| SGA: allocation forcing component growth | 24 | 37.50 | 0 | 11 | 0.00 |
| row cache lock | 2,275 | 0.00 | 0 | 0 | 0.00 |
| enq: CU - contention | 14 | 0.00 | 0 | 18 | 0.00 |
| latch: library cache lock | 218 | 0.00 | 0 | 1 | 0.00 |
| direct path read | 735 | 0.00 | 0 | 0 | 0.00 |
| cursor: pin S | 10,438 | 0.00 | 0 | 0 | 0.01 |
| latch: shared pool | 617 | 0.00 | 0 | 0 | 0.00 |
| enq: FB - contention | 676 | 0.00 | 0 | 0 | 0.00 |
| latch: object queue header heap | 258 | 0.00 | 0 | 0 | 0.00 |
| enq: US - contention | 16 | 0.00 | 0 | 6 | 0.00 |
| latch: cache buffer handles | 266 | 0.00 | 0 | 0 | 0.00 |
| latch: messages | 161 | 0.00 | 0 | 0 | 0.00 |
| PX qref latch | 370 | 83.24 | 0 | 0 | 0.00 |
| latch: enqueue hash chains | 32 | 0.00 | 0 | 1 | 0.00 |
| enq: TX - allocate ITL entry | 75 | 0.00 | 0 | 0 | 0.00 |
| latch: redo writing | 91 | 0.00 | 0 | 0 | 0.00 |
| reliable message | 38 | 0.00 | 0 | 1 | 0.00 |
| cursor: pin X | 2 | 100.00 | 0 | 11 | 0.00 |
| library cache lock | 1 | 0.00 | 0 | 19 | 0.00 |
| cursor: mutex S | 65 | 0.00 | 0 | 0 | 0.00 |
| latch: checkpoint queue latch | 15 | 0.00 | 0 | 0 | 0.00 |
| enq: PS - contention | 43 | 0.00 | 0 | 0 | 0.00 |
| write complete waits | 5 | 0.00 | 0 | 1 | 0.00 |
| direct path write | 463 | 0.00 | 0 | 0 | 0.00 |
| latch: parallel query alloc buffer | 1 | 0.00 | 0 | 2 | 0.00 |
| direct path write temp | 52 | 0.00 | 0 | 0 | 0.00 |
| cursor: mutex X | 17 | 0.00 | 0 | 0 | 0.00 |
| direct path read temp | 20 | 0.00 | 0 | 0 | 0.00 |
| L1 validation | 2 | 0.00 | 0 | 0 | 0.00 |
| SQL*Net message from client | 52,070,915 | 0.00 | 10,075,701 | 193 | 41.65 |
| pipe get | 29,289 | 14.80 | 21,072 | 719 | 0.02 |
| Streams AQ: qmn slave idle wait | 129 | 0.00 | 3,526 | 27332 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 258 | 50.00 | 3,526 | 13666 | 0.00 |
| Streams AQ: waiting for time management or cleanup tasks | 2,999 | 39.58 | 3,509 | 1170 | 0.00 |
| PX Idle Wait | 1,619 | 76.10 | 2,540 | 1569 | 0.00 |
| PL/SQL lock timer | 216 | 99.07 | 2,423 | 11215 | 0.00 |
| jobq slave wait | 612 | 99.84 | 1,793 | 2930 | 0.00 |
| PX Deq: Execution Msg | 5,095 | 0.00 | 39 | 8 | 0.00 |
| PX Deq: Execute Reply | 2,674 | 0.00 | 3 | 1 | 0.00 |
| PX Deq Credit: need buffer | 4,760 | 0.00 | 1 | 0 | 0.00 |
| PX Deq: Msg Fragment | 4,415 | 0.00 | 1 | 0 | 0.00 |
| PX Deq: Table Q Normal | 7,117 | 0.00 | 0 | 0 | 0.01 |
| PX Deq: Parse Reply | 235 | 0.00 | 0 | 1 | 0.00 |
| PX Deq: Join ACK | 257 | 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 | 862,616 | 0.00 | 352 | 0 | 0.69 |
| db file parallel write | 281,239 | 0.00 | 147 | 1 | 0.22 |
| events in waitclass Other | 44,044 | 0.00 | 3 | 0 | 0.04 |
| control file sequential read | 827 | 0.00 | 2 | 3 | 0.00 |
| os thread startup | 62 | 0.00 | 2 | 33 | 0.00 |
| db file scattered read | 525 | 0.00 | 2 | 3 | 0.00 |
| control file parallel write | 1,739 | 0.00 | 1 | 1 | 0.00 |
| db file sequential read | 208 | 0.00 | 1 | 3 | 0.00 |
| direct path read | 732 | 0.00 | 0 | 0 | 0.00 |
| latch: redo writing | 91 | 0.00 | 0 | 0 | 0.00 |
| latch: cache buffers chains | 71 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 333 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache pin | 1 | 0.00 | 0 | 1 | 0.00 |
| buffer busy waits | 8 | 0.00 | 0 | 0 | 0.00 |
| log file sync | 1 | 0.00 | 0 | 1 | 0.00 |
| latch: library cache | 1 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache lock | 1 | 0.00 | 0 | 0 | 0.00 |
| latch: shared pool | 1 | 0.00 | 0 | 0 | 0.00 |
| latch: In memory undo latch | 1 | 0.00 | 0 | 0 | 0.00 |
| rdbms ipc message | 1,663,126 | 0.73 | 35,987 | 22 | 1.33 |
| Streams AQ: qmn slave idle wait | 129 | 0.00 | 3,526 | 27332 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 258 | 50.00 | 3,526 | 13666 | 0.00 |
| pmon timer | 1,401 | 86.65 | 3,509 | 2505 | 0.00 |
| Streams AQ: waiting for time management or cleanup tasks | 2,999 | 39.58 | 3,509 | 1170 | 0.00 |
| smon timer | 151,246 | 0.00 | 3,501 | 23 | 0.12 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics
| Statistic | Total |
|---|
| BUSY_TIME | 2,265,081 |
| IDLE_TIME | 3,499,991 |
| IOWAIT_TIME | 108,687 |
| NICE_TIME | 19,043 |
| SYS_TIME | 108,525 |
| USER_TIME | 2,060,438 |
| LOAD | 5 |
| RSRC_MGR_CPU_WAIT_TIME | 0 |
| PHYSICAL_MEMORY_BYTES | 46,997,120 |
| 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 | 26,947.40 | 21,153.60 | 430,656 | 2,091,274,779 |
| SYS$BACKGROUND | 0.00 | 0.00 | 15,095 | 3,885,409 |
| 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 |
341434 | 110083 | 2577733 | 16891 | 0 | 0 | 56668144 | 616197 |
| SYS$BACKGROUND |
1798 | 258 | 146 | 207 | 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 |
|---|
| 728 | 722 | 298 | 2.44 | 2.70 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 474 | 469 | 16 | 29.59 | 1.76 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 449 | 421 | 112,644 | 0.00 | 1.67 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 412 | 11 | 20,008 | 0.02 | 1.53 | fw8fr3nddyd26 |
PYUSLV
|
insert into pay_run_balances(r... |
| 406 | 403 | 64,006 | 0.01 | 1.51 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 399 | 8 | 10,000 | 0.04 | 1.48 | 38kpqs2vdwfh9 |
PYUSLV
|
update pay_person_latest_balan... |
| 382 | 372 | 1,441 | 0.27 | 1.42 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 380 | 377 | 55,654 | 0.01 | 1.41 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 337 | 335 | 55,673 | 0.01 | 1.25 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 317 | 315 | 374,992 | 0.00 | 1.18 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 310 | 308 | 55,673 | 0.01 | 1.15 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 275 | 273 | 50,440 | 0.01 | 1.02 | 6ubqcscr1gk1b |
asnDispContainer.jsp
|
select name, value from icx_s... |
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 |
|---|
| 722 | 728 | 298 | 2.42 | 2.70 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 469 | 474 | 16 | 29.34 | 1.76 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 421 | 449 | 112,644 | 0.00 | 1.67 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 403 | 406 | 64,006 | 0.01 | 1.51 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 377 | 380 | 55,654 | 0.01 | 1.41 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 372 | 382 | 1,441 | 0.26 | 1.42 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 335 | 337 | 55,673 | 0.01 | 1.25 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 315 | 317 | 374,992 | 0.00 | 1.18 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 308 | 310 | 55,673 | 0.01 | 1.15 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 273 | 275 | 50,440 | 0.01 | 1.02 | 6ubqcscr1gk1b |
asnDispContainer.jsp
|
select name, value from icx_s... |
| 11 | 412 | 20,008 | 0.00 | 1.53 | fw8fr3nddyd26 |
PYUSLV
|
insert into pay_run_balances(r... |
| 8 | 399 | 10,000 | 0.00 | 1.48 | 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,095,123,845
- Captured SQL account for 14.9% of Total
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 99,666,226 | 16 | 6,229,139.13 | 4.76 | 469.37 | 473.50 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 62,706,998 | 155,643 | 402.89 | 2.99 | 182.44 | 184.07 | 5kqw5535fjvw6 |
ARXTWMAI
|
SELECT NVL(RCTT.ATTRIBUTE10, ... |
| 49,501,570 | 55,654 | 889.45 | 2.36 | 376.59 | 379.88 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 44,827,529 | 64,006 | 700.36 | 2.14 | 402.59 | 406.10 | g8102j8yynbwz |
OEXOETEL
|
begin WF_STANDARD.CONTINUEFLOW... |
| 44,009,678 | 298 | 147,683.48 | 2.10 | 721.90 | 727.86 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 40,961,650 | 1,441 | 28,425.85 | 1.96 | 372.11 | 382.31 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 37,181,699 | 55,673 | 667.86 | 1.77 | 307.80 | 309.89 | 9wdrypwkpf607 |
WSHINTERFACE
|
begin OE_FULFILL_WF.START_FULF... |
| 31,368,700 | 1,439,443 | 21.79 | 1.50 | 115.76 | 117.03 | 66tmsr3446uqn |
ap.oie.server.WebExpensesAM
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 29,080,402 | 168,752 | 172.33 | 1.39 | 153.40 | 155.30 | 3b3psftuyks81 |
INVTTMTX
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 29,073,199 | 168,733 | 172.30 | 1.39 | 142.63 | 144.42 | gf1u933c95jb5 |
INVTTMTX
|
DECLARE
l_ret_stat varchar2... |
| 28,755,561 | 55,673 | 516.51 | 1.37 | 335.00 | 337.34 | gksvm8wmzk8w0 |
WSHINTERFACE
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 26,401,162 | 10,000 | 2,640.12 | 1.26 | 81.24 | 183.23 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 25,935,158 | 202,396 | 128.14 | 1.24 | 205.26 | 225.80 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 24,788,036 | 9 | 2,754,226.22 | 1.18 | 101.74 | 101.74 | bp8crdjba8zgt |
ARGLTP
|
update ra_cust_trx_line_gl_dis... |
| 24,622,589 | 50,440 | 488.16 | 1.18 | 272.98 | 274.87 | 6ubqcscr1gk1b |
asnDispContainer.jsp
|
select name, value from icx_s... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- Total Disk Reads: 445,697
- Captured SQL account for 32.7% of Total
| Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 45,237 | 10,000 | 4.52 | 10.15 | 81.24 | 183.23 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 38,134 | 2,400 | 15.89 | 8.56 | 14.45 | 153.23 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 37,265 | 2,400 | 15.53 | 8.36 | 99.69 | 220.90 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 19,886 | 21,625 | 0.92 | 4.46 | 165.38 | 227.77 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 9,735 | 7,212 | 1.35 | 2.18 | 116.23 | 150.24 | 8jb36w62w5hqf |
ibuSRDetailsActions.jsp
|
BEGIN IBU_REQ_PKG.UpdateServic... |
| 9,705 | 202,396 | 0.05 | 2.18 | 205.26 | 225.80 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 5,462 | 10,000 | 0.55 | 1.23 | 15.29 | 25.86 | 4sqqnd7uvn7xg |
PYUSLV
|
select /*+ ORDERED USE_NL(AC... |
| 4,779 | 10,000 | 0.48 | 1.07 | 8.37 | 398.52 | 38kpqs2vdwfh9 |
PYUSLV
|
update pay_person_latest_balan... |
| 4,596 | 9,999 | 0.46 | 1.03 | 130.17 | 138.56 | csvvv0fmhr1yc |
PYUSLV
|
BEGIN
FFP1893_01010001.FORMULA... |
| 4,515 | 10,000 | 0.45 | 1.01 | 107.34 | 113.15 | 63t8zpm02skgh |
PYUSLV
|
SELECT DECODE(COUNT(PRR.RUN_RE... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 104,925,160
- Captured SQL account for 9.3% of Total
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 1,439,443 | 744,934 | 0.52 | 0.00 | 0.00 | 66tmsr3446uqn |
ap.oie.server.WebExpensesAM
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 818,479 | 818,480 | 1.00 | 0.00 | 0.00 | cd9mbmqyf4qhp |
ap.oie.server.WebExpensesAM
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 596,502 | 596,493 | 1.00 | 0.00 | 0.00 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 513,506 | 168,801 | 0.33 | 0.00 | 0.00 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 501,392 | 447,332 | 0.89 | 0.00 | 0.00 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 439,207 | 439,105 | 1.00 | 0.00 | 0.00 | 821fx90awyvj7 |
OEXOETEL
|
SELECT ACCOUNTING_RULE_ID , A... |
| 374,992 | 374,986 | 1.00 | 0.00 | 0.00 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 343,946 | 262,588 | 0.76 | 0.00 | 0.00 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 290,767 | 4,942,945 | 17.00 | 0.00 | 0.00 | cwyx16zn1hpfb |
JDBC Thin Client
|
select parameter, value from ... |
| 202,396 | 202,396 | 1.00 | 0.00 | 0.00 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
Back to SQL Statistics
Back to Top
SQL ordered by Parse Calls
- Total Parse Calls: 9,276,727
- Captured SQL account for 43.7% of Total
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 596,517 | 596,502 | 6.43 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 374,990 | 374,992 | 4.04 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 343,959 | 343,946 | 3.71 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 290,769 | 290,767 | 3.13 | cwyx16zn1hpfb |
JDBC Thin Client
|
select parameter, value from ... |
| 202,395 | 202,396 | 2.18 | 827gtfny5uagb |
CSCCCCRC
|
begin :con := FND_GENERIC_POLI... |
| 173,990 | 173,981 | 1.88 | 6gnth2mfbs2nq |
INVTTMTX
|
declare
v_ret number := 0... |
| 125,225 | 125,219 | 1.35 | fb13x9qx0ftks |
OEXOETEL
|
begin OE_STANDARD_WF.OEOL_SELE... |
| 120,301 | 120,301 | 1.30 | 162ttnv4ubqun |
OEXOETEL
|
begin OE_DS_PVT.Check_PO_Appr... |
| 113,100 | 113,097 | 1.22 | 1c0b7sas42w2z |
INVTTMTX
|
SELECT NVL(ITEM_COST, 0), ... |
| 111,293 | 111,293 | 1.20 | 8camsgjsr9zya |
OEXOETEL
|
begin OE_TRANSACTION_TYPES_PK... |
| 101,265 | 101,250 | 1.09 | 76sw2a4vnc89j |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.S... |
| 95,270 | 95,266 | 1.03 | 608c0n36kaw62 |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.C... |
| 95,270 | 95,260 | 1.03 | bf7uwg5pa3pj6 |
icx.por.req.server.RequisitionAM
|
begin FND_FLEX_WORKFLOW_APIS.V... |
| 95,270 | 101,262 | 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,752,544 | 1,198 | 0.06 | 2nfc4vng01c8t |
POXPOVPO
|
SELECT END_DATE, START_DATE, R... |
| 1,260,735 | 20,887 | 0.04 | 8q8zmrwmrccz4 |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(adj ... |
| 1,077,898 | 28,787 | 0.04 | dzt4ys8ynkyrj |
CSCCCCRC
|
INSERT INTO CS_INCIDENTS_AUDIT... |
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; |
| 2nfc4vng01c8t |
SELECT END_DATE, START_DATE, ROW_ID, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, PO_NUM, RELEASE_NUM, RELEASE_TYPE, REVISED_DATE, APPROVED_DATE, BILL_TO_LOCATION_ID, BILL_TO_LOCATION, AGENT_ID, VENDOR_SITE_ID, VENDOR_SITE_CODE, VENDOR_ID, VENDOR_NAME, VENDOR_CONTACT, AUTHORIZATION_STATUS, NEED_BY_DATE, REVISION_NUM, DOC_TYPE_NAME, GLOBAL_AGREEMENT_FLAG, OWNING_ORG_ID, TYPE_LOOKUP_CODE, ORDER_DATE, CURRENCY_CODE, TERMS_NAME, SHIP_VIA_LOOKUP_CODE, HEADER_FOB_LOOKUP_CODE, HEADER_FREIGHT_TERMS_LC, RATE_TYPE, RATE_DATE, RATE, PLL_NOTE_TO_RECEIVER, CONFIRMING_ORDER_FLAG, LINE_NUM, LINE_TYPE_ID, LINE_TYPE, ORDER_TYPE_LOOKUP_CODE, PURCHASE_BASIS, ITEM_ID, ITEM_REVISION, JOB_ID, CATEGORY_ID, ITEM_DESCRIPTION, UNIT_MEAS_LOOKUP_CODE, ALLOW_PRICE_OVERRIDE_FLAG, NOT_TO_EXCEED_PRICE, UN_NUMBER, HAZARD_CLASS, FROM_HEADER_ID, FROM_LINE_ID, FROM_LINE_LOCATION_ID, NOTE_TO_VENDOR, UNORDERED_FLAG, VENDOR_PRODUCT_NUM, CONTRACT_ID, MIN_RELEASE_AMOUNT, PO_HEADER_ID, PO_RELEASE_ID, CLOSED_BY, CANCELLED_BY, PO_LINE_ID, LINE_LOCATION_ID, SHIPMENT_NUM, CREATION_DATE, QUANTITY, QUANTITY_RECEIVED, QUANTITY_ACCEPTED, QUANTITY_REJECTED, QUANTITY_BILLED, QUANTITY_CANCELLED, AMOUNT, AMOUNT_RECEIVED, AMOUNT_BILLED, AMOUNT_CANCELLED, SHIP_TO_LOCATION_ID, SHIP_TO_LOCATION, PROMISED_DATE, LAST_ACCEPT_DATE, PRICE_OVERRIDE, ENCUMBERED_FLAG, TAXABLE_FLAG, TAX_NAME, CANCEL_FLAG, CANCEL_DATE, CANCEL_REASON, FIRM_STATUS_LOOKUP_CODE, MATCHING_TYPE, MATCH_OPTION, COUNTRY_OF_ORIGIN, QTY_RCV_TOLERANC
E, QTY_RCV_EXCEPTION_CODE, ENFORCE_SHIP_TO_LOCATION_CODE, ALLOW_SUBSTITUTE_RECEIPTS_FLAG, DAYS_EARLY_RECEIPT_ALLOWED, DAYS_LATE_RECEIPT_ALLOWED, RECEIPT_DAYS_EXCEPTION_CODE, INVOICE_CLOSE_TOLERANCE, RECEIVE_CLOSE_TOLERANCE, SHIP_TO_ORGANIZATION_ID, SHIP_TO_ORGANIZATION, SOURCE_SHIPMENT_ID, SHIPMENT_TYPE, CLOSED_CODE, RECEIVING_ROUTING_ID, ROUTING_NAME, ACCRUE_ON_RECEIPT_FLAG, CLOSED_REASON, CLOSED_DATE, SOURCE_SHIPMENT_NUM, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE_CATEGORY, USSGL_TRANSACTION_CODE, ACCEPTANCE_DUE_DATE, SECONDARY_UNIT_OF_MEASURE, SECONDARY_QUANTITY, PREFERRED_GRADE, SECONDARY_QUANTITY_RECEIVED, SECONDARY_QUANTITY_ACCEPTED, SECONDARY_QUANTITY_REJECTED, SECONDARY_QUANTITY_CANCELLED, VMI_FLAG, CONSIGNED_FLAG, CONSIGNED_CONSUMPTION_FLAG, AUTO_PRICED_FLAG FROM PO_LINE_LOCATIONS_INQ_V WHERE (:1 = agent_id OR EXISTS ( SELECT 'This employee is in approval path of this doc' FROM PO_ACTION_HISTORY POAH2 WHERE POAH2.employee_id + 0 = :2 AND POAH2.object_type_code in ('PO', 'PA') AND POAH2.object_id = po_header_id) OR( ((type_lookup_code = 'STANDARD') AND (release_num is null)) AND ( ( :3 = 'PUBLIC') OR ( :4 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id =:5 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :6
= 'HIERARCHY' AND :7 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :8 , -1) )) ) ) OR( ((type_lookup_code = 'PLANNED') AND (release_num is null)) AND ( ( :9 = 'PUBLIC') OR ( :10 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :11 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :12 = 'HIERARCHY' AND :13 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :14 , -1) )) ) ) OR( ((type_lookup_code = 'BLANKET') AND (release_num is null)) AND ( ( :15 = 'PUBLIC') OR ( :16 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :17 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :18 = 'HIERARCHY' AND :19 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :20 , -1) )) ) )OR( release_type = 'BLANKET' AND ( ( :21 = 'PUBLIC') OR ( :22 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :23 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :24 = 'HIERARCHY' AND :25 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIE
S POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :26 , -1) )) ) )OR( release_type = 'SCHEDULED' AND ( ( :27 = 'PUBLIC') OR ( :28 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :29 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :30 = 'HIERARCHY' AND :31 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :32 , -1) )) ) )OR (:33 = 'Y')) AND -1=-1 and (po_line_locations_inq_v.owning_org_id = decode(po_line_locations_inq_v.global_agreement_flag, 'Y', po_line_locations_inq_v.owning_org_id, 204) ) and (RELEASE_TYPE IS NULL) and (PO_HEADER_ID=:34) and (PO_LINE_ID=:35) order by po_header_id desc, release_num desc, line_num, shipment_num |
| 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 ) ) |
| 4sqqnd7uvn7xg |
select /*+ ORDERED USE_NL(ACT EE ET EEV) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK, EE PAY_ELEMENT_ENTRIES_F_N50, ET PAY_ELEMENT_TYPES_F_PK, EEV PAY_ELEMENT_ENTRY_VALUES_F_N50) +*/ EE.entry_type , to_char(EE.element_entry_id) , decode(:b0, 'T', decode(EE.entry_type, 'R', to_char(EE.target_entry_id), 'A', to_char(EE.target_entry_id), to_char(EE.original_entry_id)), to_char(EE.original_entry_id)) , EE.element_link_id , to_char(EE.target_entry_id) , EE.subpriority , ET.element_type_id , ET.processing_priority , ET.processing_type , EEV.input_value_id , EEV.screen_entry_value , to_char(null ) , to_char(null ) , 0 , to_char(null ) , to_char(null ) , decode(EE.entry_type, 'S', 1, 'E', 2, 'R', 2, 'A', 2, 'D', 3) , nvl(EE.target_entry_id, EE.element_entry_id) , decode(EE.entry_type, 'E', 2, 1) , to_char(EE.effective_start_date, :b1) , to_char(EE.effective_end_date, :b1) , ET.proration_group_id , pay_retro_pkg.is_retro_entry(EE.creator_type) , to_char(null ) , 'RECALC_NON_RETRO' , 'E' , PEPD.tax_unit_id from pay_assignment_actions ACT , pay_element_entries_f EE , pay_element_types_f ET , pay_element_entry_values_f EEV , pay_entry_process_details PEPD where ((((((((((((((((ACT.assignment_action_id=:b3 and EE.assignment_id=:b4) and ((:b5='N' and to_date(:b6, :b1) between EE.effective_start_date and EE.effective_end_date) or ((:b5='Y' and EE.effective_start_date<=to_date(:b6, :b1)) and EE.effective_end_date>=decode(ET.proration_group_id, null , to_date(:b6, :b1), pay_interprete
r_pkg.prorate_start_date(:b3, ET.proration_group_id))))) and EE.element_type_id=ET.element_type_id) and EE.element_entry_id=PEPD.element_entry_id(+)) and to_date(:b6, :b1) between ET.effective_start_date and ET.effective_end_date) and EEV.element_entry_id(+)=EE.element_entry_id) and EEV.screen_entry_value(+) is not null ) and EE.effective_start_date=EEV.effective_start_date(+)) and EE.effective_end_date=EEV.effective_end_date(+)) and EE.entry_type<>'B') and ET.process_in_run_flag<>'N') and ((:b5='N' or ET.proration_group_id is null ) or (:b5='Y' and exists (select '' from pay_payroll_actions ppa , per_time_periods ptp , pay_element_entries_f pee where (((((pee.element_entry_id=EE.element_entry_id and ppa.payroll_action_id=ACT.payroll_action_id) and ppa.payroll_id=ptp.payroll_id) and to_date(:b6, :b1) between ptp.start_date and ptp.end_date) and pee.effective_start_date<=ptp.end_date) and pee.effective_end_date>=ptp.start_date))))) and not (ACT.action_status='B' and EE.creator_type='P')) and not (ACT.action_status='B' and EE.creator_type='R')) and ( not (ACT.action_status='B' and EE.creator_type in ('RR', 'EE')) or (((ACT.action_status='B' and EE.creator_type in ('RR', 'EE')) and pay_retro_pkg.process_retro_value(EE.element_entry_id, ET.element_type_id, :b20:b21, :b22:b23)='Y') and exists (select '' from pay_assignment_actions paa where (paa.assignment_action_id=EE.creator_id and paa.action_sequence<ACT.action_sequence))))) and ((((ET.processing_type=
'N' or EE.entry_type='D') and nvl(EE.date_earned, to_date('01/01/0001', 'DD/MM/YYYY'))<=to_date(:b6, :b1)) and not exists (select '' from pay_run_results prr where (((prr.source_id=EE.element_entry_id and prr.source_type='E') and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or ((ET.processing_type<>'N' and EE.entry_type<>'D') and ((nvl(ET.once_each_period_flag, 'N')='Y' and not exists (select '' from pay_run_results prr , pay_assignment_actions paa , pay_payroll_actions ppa , per_time_periods ptp , per_time_periods ptp1 , pay_payroll_actions ppa1 where (((((((((((prr.source_id=EE.element_entry_id and prr.source_type='E') and paa.assignment_action_id=prr.assignment_action_id) and ppa.payroll_action_id=paa.payroll_action_id) and ptp.payroll_id=ppa.payroll_id) and ppa.date_earned between ptp.start_date and ptp.end_date) and ppa1.payroll_action_id=ACT.payroll_action_id) and ptp1.payroll_id=ppa1.payroll_id) and ppa1.date_earned between ptp1.start_date and ptp1.end_date) and ptp.time_period_id=ptp1.time_period_id) and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or nvl(ET.once_each_period_flag, 'N')='N')))) order by 8 asc , 6 asc , 7 asc , 17 asc , 18 asc , 19 asc , 20 asc
|
| 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 |
| 6cjfxb1c4kx16 | SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, HIERARCHY_TYPE FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = UPPER(:B1 ) AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE |
| 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; |
| 7g05xfvc5vp74 | BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END; |
| 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; |
| bp8crdjba8zgt | update ra_cust_trx_line_gl_dist set gl_posted_date=:b0, posting_control_id=:b1, last_update_date=sysdate , last_updated_by=:b2 where (cust_trx_line_gl_dist_id in (select to_number(reference23) from gl_interface where ((((user_je_source_name=:b3 and set_of_books_id=:b4) and group_id=:b1) and (reference30||'')='RA_CUST_TRX_LINE_GL_DIST') and accounting_date between to_date((:b6||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b7||' 23:59:59'), 'DD-MON-RR HH24:MI:SS'))) and set_of_books_id=:b4) |
| bt0w082dfrm8v | BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END; |
| c4y7jp0q2awbf | SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 |
| 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; |
| dzt4ys8ynkyrj |
INSERT INTO CS_INCIDENTS_AUDIT_B ( INCIDENT_AUDIT_ID , INCIDENT_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , CREATION_TIME , INCIDENT_STATUS_ID , OLD_INCIDENT_STATUS_ID , CHANGE_INCIDENT_STATUS_FLAG , INCIDENT_TYPE_ID , OLD_INCIDENT_TYPE_ID , CHANGE_INCIDENT_TYPE_FLAG , INCIDENT_URGENCY_ID , OLD_INCIDENT_URGENCY_ID , CHANGE_INCIDENT_URGENCY_FLAG , INCIDENT_SEVERITY_ID , OLD_INCIDENT_SEVERITY_ID , CHANGE_INCIDENT_SEVERITY_FLAG, INCIDENT_OWNER_ID , OLD_INCIDENT_OWNER_ID , CHANGE_INCIDENT_OWNER_FLAG , CREATE_MANUAL_ACTION , ACTION_ID , EXPECTED_RESOLUTION_DATE , OLD_EXPECTED_RESOLUTION_DATE , CHANGE_RESOLUTION_FLAG , NEW_WORKFLOW_FLAG , WORKFLOW_PROCESS_NAME , WORKFLOW_PROCESS_ITEMKEY , GROUP_ID, OLD_GROUP_ID, CHANGE_GROUP_FLAG, GROUP_TYPE, OLD_GROUP_TYPE, CHANGE_GROUP_TYPE_FLAG, INV_PLATFORM_ORG_ID, OLD_INV_PLATFORM_ORG_ID, CHANGE_PLATFORM_ORG_ID_FLAG, OWNER_ASSIGNED_TIME, OLD_OWNER_ASSIGNED_TIME, CHANGE_ASSIGNED_TIME_FLAG, OBLIGATION_DATE, OLD_OBLIGATION_DATE, CHANGE_OBLIGATION_FLAG, SITE_ID, OLD_SITE_ID, CHANGE_SITE_FLAG, BILL_TO_CONTACT_ID, OLD_BILL_TO_CONTACT_ID, CHANGE_BILL_TO_FLAG, SHIP_TO_CONTACT_ID, OLD_SHIP_TO_CONTACT_ID, CHANGE_SHIP_TO_FLAG, CLOSE_DATE, OLD_CLOSE_DATE, CHANGE_CLOSE_DATE_FLAG, CUSTOMER_PRODUCT_ID, OLD_CUSTOMER_PRODUCT_ID, CHANGE_CUSTOMER_PRODUCT_FLAG, PLATFORM_ID, OLD_PLATFORM_ID, CHANGE_PLATFORM_ID_FLAG, PRODUCT_REVISION, OLD_PRODUCT_REVISION
, CHANGE_PRODUCT_REVISION_FLAG, COMPONENT_VERSION, OLD_COMPONENT_VERSION, CHANGE_COMP_VER_FLAG, SUBCOMPONENT_VERSION, OLD_SUBCOMPONENT_VERSION, CHANGE_SUBCOMP_VER_FLAG, CP_COMPONENT_ID, OLD_CP_COMPONENT_ID, CHANGE_CP_COMPONENT_ID_FLAG, CP_COMPONENT_VERSION_ID, OLD_CP_COMPONENT_VERSION_ID, CHANGE_CP_COMP_VER_ID_FLAG, CP_SUBCOMPONENT_ID, OLD_CP_SUBCOMPONENT_ID, CHANGE_CP_SUBCOMPONENT_ID_FLAG, CP_SUBCOMPONENT_VERSION_ID, OLD_CP_SUBCOMPONENT_VERSION_ID, CHANGE_CP_SUBCOMP_VER_ID_FLAG, CP_REVISION_ID, OLD_CP_REVISION_ID, CHANGE_CP_REVISION_ID_FLAG, INV_ITEM_REVISION, OLD_INV_ITEM_REVISION, CHANGE_INV_ITEM_REVISION, INV_COMPONENT_ID, OLD_INV_COMPONENT_ID, CHANGE_INV_COMPONENT_ID, INV_COMPONENT_VERSION, OLD_INV_COMPONENT_VERSION, CHANGE_INV_COMPONENT_VERSION, INV_SUBCOMPONENT_ID, OLD_INV_SUBCOMPONENT_ID, CHANGE_INV_SUBCOMPONENT_ID, INV_SUBCOMPONENT_VERSION, OLD_INV_SUBCOMPONENT_VERSION, CHANGE_INV_SUBCOMP_VERSION, TERRITORY_ID, OLD_TERRITORY_ID, CHANGE_TERRITORY_ID_FLAG, RESOURCE_TYPE, OLD_RESOURCE_TYPE, CHANGE_RESOURCE_TYPE_FLAG, OBJECT_VERSION_NUMBER, AUDIT_FIELD, INVENTORY_ITEM_ID , OLD_INVENTORY_ITEM_ID, CHANGE_INVENTORY_ITEM_FLAG, INV_ORGANIZATION_ID, OLD_INV_ORGANIZATION_ID, CHANGE_INV_ORGANIZATION_FLAG, STATUS_FLAG , OLD_STATUS_FLAG , CHANGE_STATUS_FLAG , INCIDENT_DATE, OLD_INCIDENT_DATE, CHANGE_INCIDENT_DATE_FLAG, PLATFORM_VERSION_ID, OLD_PLATFORM_VERSION_ID, CHANGE_PLAT_VER_ID_FLAG, LANGUAGE_ID, OLD_LANGUAGE_ID,
CHANGE_LANGUAGE_ID_FLAG, UPGRADE_FLAG_FOR_CREATE , OLD_INCIDENT_NUMBER , INCIDENT_NUMBER , OLD_CUSTOMER_ID , CUSTOMER_ID , OLD_BILL_TO_SITE_USE_ID , BILL_TO_SITE_USE_ID , OLD_EMPLOYEE_ID , EMPLOYEE_ID , OLD_SHIP_TO_SITE_USE_ID , SHIP_TO_SITE_USE_ID , OLD_PROBLEM_CODE , PROBLEM_CODE , OLD_ACTUAL_RESOLUTION_DATE , ACTUAL_RESOLUTION_DATE , OLD_INSTALL_SITE_USE_ID , INSTALL_SITE_USE_ID , OLD_CURRENT_SERIAL_NUMBER , CURRENT_SERIAL_NUMBER , OLD_SYSTEM_ID , SYSTEM_ID , OLD_INCIDENT_ATTRIBUTE_1 , INCIDENT_ATTRIBUTE_1 , OLD_INCIDENT_ATTRIBUTE_2 , INCIDENT_ATTRIBUTE_2 , OLD_INCIDENT_ATTRIBUTE_3 , INCIDENT_ATTRIBUTE_3 , OLD_INCIDENT_ATTRIBUTE_4 , INCIDENT_ATTRIBUTE_4 , OLD_INCIDENT_ATTRIBUTE_5 , INCIDENT_ATTRIBUTE_5 , OLD_INCIDENT_ATTRIBUTE_6 , INCIDENT_ATTRIBUTE_6 , OLD_INCIDENT_ATTRIBUTE_7 , INCIDENT_ATTRIBUTE_7 , OLD_INCIDENT_ATTRIBUTE_8 , INCIDENT_ATTRIBUTE_8 , OLD_INCIDENT_ATTRIBUTE_9 , INCIDENT_ATTRIBUTE_9 , OLD_INCIDENT_ATTRIBUTE_10 , INCIDENT_ATTRIBUTE_10 , OLD_INCIDENT_ATTRIBUTE_11 , INCIDENT_ATTRIBUTE_11 , OLD_INCIDENT_ATTRIBUTE_12 , INCIDENT_ATTRIBUTE_12 , OLD_INCIDENT_ATTRIBUTE_13 , INCIDENT_ATTRIBUTE_13 , OLD_INCIDENT_ATTRIBUTE_14 , INCIDENT_ATTRIBUTE_14 , OLD_INCIDENT_ATTRIBUTE_15 , INCIDENT_ATTRIBUTE_15 , OLD_INCIDENT_CONTEXT , INCIDENT_CONTEXT , OLD_RESOLUTION_CODE , RESOLUTION_CODE , OLD_ORIGINAL_ORDER_NUMBER , ORIGINAL_ORDER_NUMBER , OLD_ORG_ID , ORG_ID , OLD_PURCHASE_ORDER_NUMBER , PURCHASE_ORDER_NUMBER , O
LD_PUBLISH_FLAG , PUBLISH_FLAG , OLD_QA_COLLECTION_ID , QA_COLLECTION_ID , OLD_CONTRACT_ID , CONTRACT_ID , OLD_CONTRACT_NUMBER , CONTRACT_NUMBER , OLD_CONTRACT_SERVICE_ID , CONTRACT_SERVICE_ID , OLD_TIME_ZONE_ID , TIME_ZONE_ID , OLD_ACCOUNT_ID , ACCOUNT_ID , OLD_TIME_DIFFERENCE , TIME_DIFFERENCE , OLD_CUSTOMER_PO_NUMBER , CUSTOMER_PO_NUMBER , OLD_CUSTOMER_TICKET_NUMBER , CUSTOMER_TICKET_NUMBER , OLD_CUSTOMER_SITE_ID , CUSTOMER_SITE_ID , OLD_CALLER_TYPE , CALLER_TYPE , OLD_SECURITY_GROUP_ID , OLD_ORIG_SYSTEM_REFERENCE , ORIG_SYSTEM_REFERENCE , OLD_ORIG_SYSTEM_REFERENCE_ID , ORIG_SYSTEM_REFERENCE_ID , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , OLD_PROJECT_NUMBER , PROJECT_NUMBER , OLD_PLATFORM_VERSION , PLATFORM_VERSION , OLD_DB_VERSION , DB_VERSION , OLD_CUST_PREF_LANG_ID , CUST_PREF_LANG_ID , OLD_TIER , TIER , OLD_CATEGORY_ID , CATEGORY_ID , OLD_OPERATING_SYSTEM , OPERATING_SYSTEM , OLD_OPERATING_SYSTEM_VERSION , OPERATING_SYSTEM_VERSION , OLD_DATABASE , DATABASE , OLD_GROUP_TERRITORY_ID , GROUP_TERRITORY_ID , OLD_COMM_PREF_CODE , COMM_PREF_CODE , OLD_LAST_UPDATE_CHANNEL , LAST_UPDATE_CHANNEL , OLD_CUST_PREF_LANG_CODE , CUST_PREF_LANG_CODE , OLD_ERROR_CODE , ERROR_CODE , OLD_CATEGORY_SET_ID , CATEGORY_SET_ID , OLD_EXTERNAL_REFERENCE , EXTERNAL_REFERENCE , OLD_INCIDENT_OCCURRED_DATE , INCIDENT_OCCURRED_DATE , OLD_INCIDENT_RESOLVED_DATE , INCIDENT_RESOLVED_DATE , OLD_INC_RESPONDED
_BY_DATE , INC_RESPONDED_BY_DATE , OLD_INCIDENT_LOCATION_ID , INCIDENT_LOCATION_ID , OLD_INCIDENT_ADDRESS , INCIDENT_ADDRESS , OLD_INCIDENT_CITY , INCIDENT_CITY , OLD_INCIDENT_STATE , INCIDENT_STATE , OLD_INCIDENT_COUNTRY , INCIDENT_COUNTRY , OLD_INCIDENT_PROVINCE , INCIDENT_PROVINCE , OLD_INCIDENT_POSTAL_CODE , INCIDENT_POSTAL_CODE , OLD_INCIDENT_COUNTY , INCIDENT_COUNTY , OLD_SR_CREATION_CHANNEL , SR_CREATION_CHANNEL , OLD_DEF_DEFECT_ID , DEF_DEFECT_ID , OLD_DEF_DEFECT_ID2 , DEF_DEFECT_ID2 , OLD_EXTERNAL_ATTRIBUTE_1 , EXTERNAL_ATTRIBUTE_1 , OLD_EXTERNAL_ATTRIBUTE_2 , EXTERNAL_ATTRIBUTE_2 , OLD_EXTERNAL_ATTRIBUTE_3 , EXTERNAL_ATTRIBUTE_3 , OLD_EXTERNAL_ATTRIBUTE_4 , EXTERNAL_ATTRIBUTE_4 , OLD_EXTERNAL_ATTRIBUTE_5 , EXTERNAL_ATTRIBUTE_5 , OLD_EXTERNAL_ATTRIBUTE_6 , EXTERNAL_ATTRIBUTE_6 , OLD_EXTERNAL_ATTRIBUTE_7 , EXTERNAL_ATTRIBUTE_7 , OLD_EXTERNAL_ATTRIBUTE_8 , EXTERNAL_ATTRIBUTE_8 , OLD_EXTERNAL_ATTRIBUTE_9 , EXTERNAL_ATTRIBUTE_9 , OLD_EXTERNAL_ATTRIBUTE_10 , EXTERNAL_ATTRIBUTE_10 , OLD_EXTERNAL_ATTRIBUTE_11 , EXTERNAL_ATTRIBUTE_11 , OLD_EXTERNAL_ATTRIBUTE_12 , EXTERNAL_ATTRIBUTE_12 , OLD_EXTERNAL_ATTRIBUTE_13 , EXTERNAL_ATTRIBUTE_13 , OLD_EXTERNAL_ATTRIBUTE_14 , EXTERNAL_ATTRIBUTE_14 , OLD_EXTERNAL_ATTRIBUTE_15 , EXTERNAL_ATTRIBUTE_15 , OLD_EXTERNAL_CONTEXT , EXTERNAL_CONTEXT , OLD_LAST_UPDATE_PROGRAM_CODE , LAST_UPDATE_PROGRAM_CODE , OLD_CREATION_PROGRAM_CODE , CREATION_PROGRAM_CODE , OLD_COVERAGE_TYPE , COVERA
GE_TYPE , OLD_BILL_TO_ACCOUNT_ID , BILL_TO_ACCOUNT_ID , OLD_SHIP_TO_ACCOUNT_ID , SHIP_TO_ACCOUNT_ID , OLD_CUSTOMER_EMAIL_ID , CUSTOMER_EMAIL_ID , OLD_CUSTOMER_PHONE_ID , CUSTOMER_PHONE_ID , OLD_BILL_TO_PARTY_ID , BILL_TO_PARTY_ID , OLD_SHIP_TO_PARTY_ID , SHIP_TO_PARTY_ID , OLD_BILL_TO_SITE_ID , BILL_TO_SITE_ID , OLD_SHIP_TO_SITE_ID , SHIP_TO_SITE_ID , OLD_PROGRAM_LOGIN_ID , PROGRAM_LOGIN_ID , OLD_INCIDENT_POINT_OF_INTEREST , INCIDENT_POINT_OF_INTEREST , OLD_INCIDENT_CROSS_STREET , INCIDENT_CROSS_STREET , OLD_INCIDENT_DIRECTION_QUALIF , INCIDENT_DIRECTION_QUALIF , OLD_INCIDENT_DISTANCE_QUALIF , INCIDENT_DISTANCE_QUALIF , OLD_INCIDENT_DISTANCE_QUAL_UOM , INCIDENT_DISTANCE_QUAL_UOM , OLD_INCIDENT_ADDRESS2 , INCIDENT_ADDRESS2 , OLD_INCIDENT_ADDRESS3 , INCIDENT_ADDRESS3 , OLD_INCIDENT_ADDRESS4 , INCIDENT_ADDRESS4 , OLD_INCIDENT_ADDRESS_STYLE , INCIDENT_ADDRESS_STYLE , OLD_INCIDENT_ADDR_LNS_PHONETIC , INCIDENT_ADDR_LNS_PHONETIC , OLD_INCIDENT_PO_BOX_NUMBER , INCIDENT_PO_BOX_NUMBER , OLD_INCIDENT_HOUSE_NUMBER , INCIDENT_HOUSE_NUMBER , OLD_INCIDENT_STREET_SUFFIX , INCIDENT_STREET_SUFFIX , OLD_INCIDENT_STREET , INCIDENT_STREET , OLD_INCIDENT_STREET_NUMBER , INCIDENT_STREET_NUMBER , OLD_INCIDENT_FLOOR , INCIDENT_FLOOR , OLD_INCIDENT_SUITE , INCIDENT_SUITE , OLD_INCIDENT_POSTAL_PLUS4_CODE , INCIDENT_POSTAL_PLUS4_CODE , OLD_INCIDENT_POSITION , INCIDENT_POSITION , OLD_INCIDENT_LOC_DIRECTIONS , INCIDENT_LOC_DIRECTIONS , OLD_INCIDEN
T_LOC_DESCRIPTION , INCIDENT_LOC_DESCRIPTION , OLD_INSTALL_SITE_ID , INSTALL_SITE_ID , INCIDENT_LAST_MODIFIED_DATE , UPDATED_ENTITY_CODE , UPDATED_ENTITY_ID , ENTITY_ACTIVITY_CODE , OLD_TIER_VERSION , TIER_VERSION , OLD_INC_OBJECT_VERSION_NUMBER , INC_OBJECT_VERSION_NUMBER , OLD_INC_REQUEST_ID , INC_REQUEST_ID , OLD_INC_PROGRAM_APPLICATION_ID , INC_PROGRAM_APPLICATION_ID , OLD_INC_PROGRAM_ID , INC_PROGRAM_ID , OLD_INC_PROGRAM_UPDATE_DATE , INC_PROGRAM_UPDATE_DATE , OLD_OWNING_DEPARTMENT_ID , OWNING_DEPARTMENT_ID , OLD_ITEM_SERIAL_NUMBER , ITEM_SERIAL_NUMBER , OLD_INCIDENT_LOCATION_TYPE , INCIDENT_LOCATION_TYPE , OLD_UNASSIGNED_INDICATOR , UNASSIGNED_INDICATOR ) VALUES( :B403 , :B402 , :B401 , :B400 , :B401 , :B400 , :B399 , TO_CHAR(:B398 , 'HH24:MI:SS'), :B397 , :B396 , :B395 , :B394 , :B393 , :B392 , :B391 , :B390 , :B389 , :B388 , :B387 , :B386 , :B385 , :B384 , :B383 , :B382 , :B381 , :B380 , :B379 , :B378 , :B377 , :B376 , :B375 , :B374 , :B373 , :B372 , :B371 , :B370 , :B369 , :B368 , :B367 , :B366 , :B365 , :B364 , :B363 , :B362 , :B361 , :B360 , :B359 , :B358 , :B357 , :B356 , :B355 , :B354 , :B353 , :B352 , :B351 , :B350 , :B349 , :B348 , :B347 , :B346 , :B345 , :B344 , :B343 , :B342 , :B341 , :B340 , :B339 , :B338 , :B337 , :B336 , :B335 , :B334 , :B333 , :B332 , :B331 , :B330 , :B329 , :B328 , :B327 , :B326 , :B325 , :B324 , :B323 , :B322 , :B321 , :B320 ,
:B319 , :B318 , :B317 , :B316 , :B315 , :B314 , :B313 , :B312 , :B311 , :B310 , :B309 , :B308 , :B307 , :B306 , :B305 , :B304 , :B303 , :B302 , :B301 , :B300 , :B299 , :B298 , :B297 , 1, '', :B296 , :B295 , :B294 , :B293 , :B292 , :B291 , :B290 , :B289 , :B288 , :B287 , :B286 , :B285 , :B284 , :B283 , :B282 , :B281 , :B280 , :B279 , :B278 , :B277 , :B276 , :B275 , :B274 , :B273 , :B272 , :B271 , :B270 , :B269 , :B268 , :B267 , :B266 , :B265 , :B264 , :B263 , :B262 , :B261 , :B260 , :B259 , :B258 , :B257 , :B256 , :B255 , :B254 , :B253 , :B252 , :B251 , :B250 , :B249 , :B248 , :B247 , :B246 , :B245 , :B244 , :B243 , :B242 , :B241 , :B240 , :B239 , :B238 , :B237 , :B236 , :B235 , :B234 , :B233 , :B232 , :B231 , :B230 , :B229 , :B228 , :B227 , :B226 , :B225 , :B224 , :B223 , :B222 , :B221 , :B220 , :B219 , :B218 , :B217 , :B216 , :B215 , :B214 , :B213 , :B212 , :B211 , :B210 , :B209 , :B208 , :B207 , :B206 , :B205 , :B204 , :B203 , :B202 , :B201 , :B200 , :B199 , :B198 , :B197 , :B196 , :B195 , :B194 , :B193 , :B192 , :B191 , :B190 , :B189 , :B188 , :B187 , :B186 , :B185 , :B184 , :B183 , :B182 , :B181 , :B180 , :B179 , :B178 , :B177 , :B176 , :B175 , :B174 , :B173 , :B172 , :B171 , :B170 , :B169 , :B168 , :B167 , :B166 , :B165 , :B164 , :B163 , :B162 , :B161 , :B160 , :B159 , :B158 , :B157 , :B156 , :B155 , :B15
4 , :B153 , :B152 , :B151 , :B150 , :B149 , :B148 , :B147 , :B146 , :B145 , :B144 , :B143 , :B142 , :B141 , :B140 , :B139 , :B138 , :B137 , :B136 , :B135 , :B134 , :B133 , :B132 , :B131 , :B130 , :B129 , :B128 , :B127 , :B126 , :B125 , :B124 , :B123 , :B122 , :B121 , :B120 , :B119 , :B118 , :B117 , :B116 , :B115 , :B114 , :B113 , :B112 , :B111 , :B110 , :B109 , :B108 , :B107 , :B106 , :B105 , :B104 , :B103 , :B102 , :B101 , :B100 , :B99 , :B98 , :B97 , :B96 , :B95 , :B94 , :B93 , :B92 , :B91 , :B90 , :B89 , :B88 , :B87 , :B86 , :B85 , :B84 , :B83 , :B82 , :B81 , :B80 , :B79 , :B78 , :B77 , :B76 , :B75 , :B74 , :B73 , :B72 , :B71 , :B70 , :B69 , :B68 , :B67 , :B66 , :B65 , :B64 , :B63 , :B62 , :B61 , :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) RETURNING INCIDENT_AUDIT_ID INTO :O0
|
| 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; |
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 | 2,083,207 | 577.88 | 1.67 |
| CPU used when call started | 2,077,917 | 576.41 | 1.66 |
| CR blocks created | 16,974,543 | 4,708.71 | 13.58 |
| Cached Commit SCN referenced | 50,187 | 13.92 | 0.04 |
| Commit SCN cached | 10 | 0.00 | 0.00 |
| DB time | 5,423,110 | 1,504.36 | 4.34 |
| DBWR checkpoint buffers written | 3,068,168 | 851.10 | 2.45 |
| DBWR checkpoints | 34 | 0.01 | 0.00 |
| DBWR object drop buffers written | 55,511 | 15.40 | 0.04 |
| DBWR revisited being-written buffer | 264 | 0.07 | 0.00 |
| DBWR thread checkpoint buffers written | 533,397 | 147.96 | 0.43 |
| DBWR transaction table writes | 2,536 | 0.70 | 0.00 |
| DBWR undo block writes | 1,621,801 | 449.88 | 1.30 |
| DFO trees parallelized | 48 | 0.01 | 0.00 |
| IMU CR rollbacks | 42,203,930 | 11,707.29 | 33.76 |
| IMU Flushes | 358,480 | 99.44 | 0.29 |
| IMU Redo allocation size | 2,379,145,636 | 659,970.73 | 1,903.07 |
| IMU commits | 647,588 | 179.64 | 0.52 |
| IMU contention | 39,183 | 10.87 | 0.03 |
| IMU ktichg flush | 11,521 | 3.20 | 0.01 |
| IMU pool not allocated | 0 | 0.00 | 0.00 |
| IMU recursive-transaction flush | 1,729 | 0.48 | 0.00 |
| IMU undo allocation size | 5,738,120,424 | 1,591,744.30 | 4,589.91 |
| IMU- failed to get a private strand | 0 | 0.00 | 0.00 |
| PX local messages recv'd | 53,122 | 14.74 | 0.04 |
| PX local messages sent | 53,122 | 14.74 | 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,051,557 | 14,439.01 | 41.64 |
| active txn count during cleanout | 127,049,683 | 35,243.35 | 101.63 |
| application wait time | 23,303 | 6.46 | 0.02 |
| background checkpoints completed | 3 | 0.00 | 0.00 |
| background checkpoints started | 2 | 0.00 | 0.00 |
| background timeouts | 13,896 | 3.85 | 0.01 |
| branch node splits | 1,068 | 0.30 | 0.00 |
| buffer is not pinned count | 596,300,641 | 165,412.73 | 476.98 |
| buffer is pinned count | 1,500,435,645 | 416,218.15 | 1,200.19 |
| bytes received via SQL*Net from client | 11,408,818,410 | 3,164,785.74 | 9,125.88 |
| bytes sent via SQL*Net to client | 10,329,378,108 | 2,865,350.94 | 8,262.44 |
| calls to get snapshot scn: kcmgss | 117,961,659 | 32,722.35 | 94.36 |
| calls to kcmgas | 21,144,780 | 5,865.52 | 16.91 |
| calls to kcmgcs | 13,758,469 | 3,816.57 | 11.01 |
| change write time | 46,464 | 12.89 | 0.04 |
| cleanout - number of ktugct calls | 29,064,350 | 8,062.40 | 23.25 |
| cleanouts and rollbacks - consistent read gets | 14,796,269 | 4,104.46 | 11.84 |
| cleanouts only - consistent read gets | 158,387 | 43.94 | 0.13 |
| cluster key scan block gets | 873,569 | 242.33 | 0.70 |
| cluster key scans | 241,281 | 66.93 | 0.19 |
| commit batch/immediate performed | 4,485 | 1.24 | 0.00 |
| commit batch/immediate requested | 4,485 | 1.24 | 0.00 |
| commit cleanout failures: block lost | 260,455 | 72.25 | 0.21 |
| commit cleanout failures: buffer being written | 1,807 | 0.50 | 0.00 |
| commit cleanout failures: callback failure | 113,047 | 31.36 | 0.09 |
| commit cleanout failures: cannot pin | 33,293 | 9.24 | 0.03 |
| commit cleanouts | 9,647,157 | 2,676.10 | 7.72 |
| commit cleanouts successfully completed | 9,238,555 | 2,562.76 | 7.39 |
| commit immediate performed | 4,485 | 1.24 | 0.00 |
| commit immediate requested | 4,485 | 1.24 | 0.00 |
| commit txn count during cleanout | 1,400,279 | 388.43 | 1.12 |
| concurrency wait time | 17,097 | 4.74 | 0.01 |
| consistent changes | 798,316,966 | 221,451.69 | 638.57 |
| consistent gets | 1,867,858,458 | 518,140.58 | 1,494.09 |
| consistent gets - examination | 1,314,378,806 | 364,606.32 | 1,051.37 |
| consistent gets direct | 3 | 0.00 | 0.00 |
| consistent gets from cache | 1,867,858,418 | 518,140.57 | 1,494.09 |
| current blocks converted for CR | 11 | 0.00 | 0.00 |
| cursor authentications | 2,344 | 0.65 | 0.00 |
| data blocks consistent reads - undo records applied | 793,987,614 | 220,250.74 | 635.11 |
| db block changes | 201,486,808 | 55,892.08 | 161.17 |
| db block gets | 227,264,973 | 63,042.90 | 181.79 |
| db block gets direct | 4,365 | 1.21 | 0.00 |
| db block gets from cache | 227,260,620 | 63,041.69 | 181.79 |
| deferred (CURRENT) block cleanout applications | 1,668,740 | 462.91 | 1.33 |
| dirty buffers inspected | 9,423 | 2.61 | 0.01 |
| enqueue conversions | 10,427 | 2.89 | 0.01 |
| enqueue releases | 4,691,348 | 1,301.37 | 3.75 |
| enqueue requests | 4,698,879 | 1,303.46 | 3.76 |
| enqueue timeouts | 7,363 | 2.04 | 0.01 |
| enqueue waits | 34,550 | 9.58 | 0.03 |
| exchange deadlocks | 28,800 | 7.99 | 0.02 |
| execute count | 104,925,160 | 29,106.05 | 83.93 |
| failed probes on index block reclamation | 8,456 | 2.35 | 0.01 |
| frame signature mismatch | 356 | 0.10 | 0.00 |
| free buffer inspected | 3,232,820 | 896.78 | 2.59 |
| free buffer requested | 21,488,215 | 5,960.79 | 17.19 |
| heap block compress | 35,635,330 | 9,885.18 | 28.50 |
| hot buffers moved to head of LRU | 1,353,197 | 375.37 | 1.08 |
| immediate (CR) block cleanout applications | 14,954,660 | 4,148.40 | 11.96 |
| immediate (CURRENT) block cleanout applications | 1,158,246 | 321.30 | 0.93 |
| index crx upgrade (found) | 27,411 | 7.60 | 0.02 |
| index crx upgrade (positioned) | 10,520,751 | 2,918.44 | 8.42 |
| index fast full scans (full) | 0 | 0.00 | 0.00 |
| index fast full scans (rowid ranges) | 784 | 0.22 | 0.00 |
| index fetch by key | 189,050,850 | 52,442.37 | 151.22 |
| index scans kdiixs1 | 130,886,939 | 36,307.80 | 104.70 |
| java call heap collected bytes | 1,495,042,272 | 414,722.04 | 1,195.88 |
| java call heap collected count | 18,232,657 | 5,057.71 | 14.58 |
| java call heap gc count | 4,837 | 1.34 | 0.00 |
| java call heap live object count | 1,537,727 | 426.56 | 1.23 |
| java call heap live object count max | 1,536,707 | 426.28 | 1.23 |
| java call heap live size | 373,321,688 | 103,558.77 | 298.62 |
| java call heap live size max | 372,984,408 | 103,465.21 | 298.35 |
| java call heap object count | 3,774,169 | 1,046.95 | 3.02 |
| java call heap object count max | 3,780,904 | 1,048.82 | 3.02 |
| java call heap total size | 482,345,984 | 133,801.91 | 385.83 |
| java call heap total size max | 481,565,696 | 133,585.46 | 385.20 |
| java call heap used size | 516,451,688 | 143,262.77 | 413.11 |
| java call heap used size max | 516,772,664 | 143,351.81 | 413.36 |
| leaf node 90-10 splits | 21,709 | 6.02 | 0.02 |
| leaf node splits | 247,925 | 68.77 | 0.20 |
| lob reads | 23,718 | 6.58 | 0.02 |
| lob writes | 41,532 | 11.52 | 0.03 |
| lob writes unaligned | 41,532 | 11.52 | 0.03 |
| logons cumulative | 10,197 | 2.83 | 0.01 |
| messages received | 2,166,268 | 600.92 | 1.73 |
| messages sent | 2,166,268 | 600.92 | 1.73 |
| no buffer to keep pinned count | 16 | 0.00 | 0.00 |
| no work - consistent read gets | 501,722,499 | 139,176.92 | 401.33 |
| opened cursors cumulative | 6,055,637 | 1,679.82 | 4.84 |
| parse count (failures) | 3,616 | 1.00 | 0.00 |
| parse count (hard) | 9,619 | 2.67 | 0.01 |
| parse count (total) | 9,276,727 | 2,573.35 | 7.42 |
| parse time cpu | 48,466 | 13.44 | 0.04 |
| parse time elapsed | 51,370 | 14.25 | 0.04 |
| physical read IO requests | 298,414 | 82.78 | 0.24 |
| physical read bytes | 3,651,149,824 | 1,012,822.41 | 2,920.54 |
| physical read total IO requests | 328,877 | 91.23 | 0.26 |
| physical read total bytes | 4,147,535,872 | 1,150,519.00 | 3,317.60 |
| physical read total multi block requests | 11,988 | 3.33 | 0.01 |
| physical reads | 445,697 | 123.64 | 0.36 |
| physical reads cache | 444,342 | 123.26 | 0.36 |
| physical reads cache prefetch | 146,683 | 40.69 | 0.12 |
| physical reads direct | 1,355 | 0.38 | 0.00 |
| physical reads direct (lob) | 3 | 0.00 | 0.00 |
| physical reads direct temporary tablespace | 620 | 0.17 | 0.00 |
| physical reads prefetch warmup | 77,633 | 21.54 | 0.06 |
| physical write IO requests | 1,383,928 | 383.90 | 1.11 |
| physical write bytes | 25,858,392,064 | 7,173,071.53 | 20,684.05 |
| physical write total IO requests | 2,675,175 | 742.09 | 2.14 |
| physical write total bytes | 59,640,054,272 | 16,544,043.98 | 47,705.90 |
| physical write total multi block requests | 1,475,244 | 409.23 | 1.18 |
| physical writes | 3,156,542 | 875.62 | 2.52 |
| physical writes direct | 5,318 | 1.48 | 0.00 |
| physical writes direct (lob) | 247 | 0.07 | 0.00 |
| physical writes direct temporary tablespace | 4,662 | 1.29 | 0.00 |
| physical writes from cache | 3,151,224 | 874.14 | 2.52 |
| physical writes non checkpoint | 2,370,004 | 657.43 | 1.90 |
| pinned buffers inspected | 4,198 | 1.16 | 0.00 |
| prefetch warmup blocks aged out before use | 239,409 | 66.41 | 0.19 |
| prefetched blocks aged out before use | 3,289 | 0.91 | 0.00 |
| process last non-idle time | 3,603 | 1.00 | 0.00 |
| queries parallelized | 48 | 0.01 | 0.00 |
| recursive calls | 169,726,771 | 47,081.90 | 135.76 |
| recursive cpu usage | 1,162,061 | 322.35 | 0.93 |
| redo blocks written | 65,812,958 | 18,256.40 | 52.64 |
| redo buffer allocation retries | 223 | 0.06 | 0.00 |
| redo entries | 103,793,112 | 28,792.02 | 83.02 |
| redo log space requests | 0 | 0.00 | 0.00 |
| redo log space wait time | 0 | 0.00 | 0.00 |
| redo ordering marks | 1,295,291 | 359.31 | 1.04 |
| redo size | 32,265,316,292 | 8,950,340.81 | 25,808.93 |
| redo subscn max counts | 2,414,014 | 669.64 | 1.93 |
| redo synch time | 80,660 | 22.37 | 0.06 |
| redo synch writes | 2,426,730 | 673.17 | 1.94 |
| redo wastage | 328,490,680 | 91,122.72 | 262.76 |
| redo write time | 40,513 | 11.24 | 0.03 |
| redo writer latching time | 159 | 0.04 | 0.00 |
| redo writes | 862,545 | 239.27 | 0.69 |
| rollback changes - undo records applied | 189,191 | 52.48 | 0.15 |
| rollbacks only - consistent read gets | 2,347,569 | 651.21 | 1.88 |
| rows fetched via callback | 99,689,111 | 27,653.58 | 79.74 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 5,785,912 | 1,605.00 | 4.63 |
| session logical reads | 2,095,123,845 | 581,183.59 | 1,675.88 |
| session pga memory | 11,071,607,096 | 3,071,243.93 | 8,856.15 |
| session pga memory max | 12,272,403,480 | 3,404,342.69 | 9,816.66 |
| session uga memory | ############### | 75,302,983.54 | 217,141.38 |
| session uga memory max | 75,086,978,064 | 20,828,992.90 | 60,061.85 |
| shared hash latch upgrades - no wait | 32,849,094 | 9,112.28 | 26.28 |
| shared hash latch upgrades - wait | 42,480 | 11.78 | 0.03 |
| sorts (memory) | 11,032,598 | 3,060.42 | 8.82 |
| sorts (rows) | 137,167,670 | 38,050.07 | 109.72 |
| sql area evicted | 2,527 | 0.70 | 0.00 |
| sql area purged | 3,786 | 1.05 | 0.00 |
| summed dirty queue length | 629,350 | 174.58 | 0.50 |
| switch current to new buffer | 1,392,986 | 386.41 | 1.11 |
| table fetch by rowid | 897,988,993 | 249,100.53 | 718.30 |
| table fetch continued row | 33,582,156 | 9,315.63 | 26.86 |
| table scan blocks gotten | 108,820,107 | 30,186.50 | 87.04 |
| table scan rows gotten | 8,686,380,095 | 2,409,586.24 | 6,948.21 |
| table scans (long tables) | 2,047 | 0.57 | 0.00 |
| table scans (rowid ranges) | 2,045 | 0.57 | 0.00 |
| table scans (short tables) | 6,226,240 | 1,727.15 | 4.98 |
| total number of times SMON posted | 151,233 | 41.95 | 0.12 |
| transaction rollbacks | 4,485 | 1.24 | 0.00 |
| transaction tables consistent read rollbacks | 73 | 0.02 | 0.00 |
| transaction tables consistent reads - undo records applied | 6,802 | 1.89 | 0.01 |
| undo change vector size | 11,290,665,180 | 3,132,010.25 | 9,031.37 |
| user I/O wait time | 110,364 | 30.61 | 0.09 |
| user calls | 49,699,495 | 13,786.55 | 39.75 |
| user commits | 985,231 | 273.30 | 0.79 |
| user rollbacks | 264,930 | 73.49 | 0.21 |
| workarea executions - onepass | 4 | 0.00 | 0.00 |
| workarea executions - optimal | 6,626,786 | 1,838.26 | 5.30 |
| write clones created in background | 1,598 | 0.44 | 0.00 |
| write clones created in foreground | 6,956 | 1.93 | 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 | 551,108 | 1,273,065 |
| opened cursors current | 1,093,824 | 1,240,119 |
| workarea memory allocated | 254 | 859 |
| logons current | 5,240 | 5,282 |
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 |
31 | 0 | 9.68 | 1.00 | 622,624 | 173 | 268,939 | 0.03 |
| APPS_TS_TX_DATA |
180,253 | 50 | 3.61 | 1.29 | 190,143 | 53 | 133,016 | 0.19 |
| APPS_TS_TX_IDX |
92,735 | 26 | 3.54 | 1.27 | 216,970 | 60 | 61,522 | 0.28 |
| APPS_ASSM_DATA |
8,791 | 2 | 1.80 | 6.52 | 157,554 | 44 | 41,857 | 0.45 |
| APPS_ASSM_IDX |
6,738 | 2 | 2.15 | 1.04 | 126,362 | 35 | 185,160 | 0.09 |
| APPS_TS_TX_INTERFACE |
1,260 | 0 | 1.94 | 2.05 | 34,783 | 10 | 15,178 | 0.05 |
| TEMP |
550 | 0 | 4.29 | 9.35 | 9,883 | 3 | 67 | 3.13 |
| APPS_TS_SEED |
2,134 | 1 | 4.87 | 1.34 | 5,609 | 2 | 831 | 2.44 |
| APPS_TS_SUMMARY |
54 | 0 | 10.37 | 1.00 | 7,393 | 2 | 2,665 | 0.04 |
| SYSTEM |
4,404 | 1 | 3.47 | 4.03 | 2,797 | 1 | 19,557 | 0.06 |
| APPS_TS_QUEUES |
392 | 0 | 4.77 | 2.17 | 5,350 | 1 | 309 | 0.36 |
| SYSAUX |
912 | 0 | 2.02 | 1.04 | 1,930 | 1 | 0 | 0.00 |
| APPS_TS_ARCHIVE |
64 | 0 | 4.84 | 1.38 | 2,261 | 1 | 97 | 2.58 |
| APPS_TS_NOLOGGING |
25 | 0 | 9.20 | 1.56 | 30 | 0 | 0 | 0.00 |
| CTXSYS |
24 | 0 | 4.58 | 1.00 | 6 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA |
12 | 0 | 10.83 | 1.00 | 9 | 0 | 0 | 0.00 |
| ODM |
12 | 0 | 4.17 | 1.00 | 3 | 0 | 0 | 0.00 |
| OLAP |
12 | 0 | 5.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| OWAPUB |
12 | 0 | 5.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| PORTAL |
12 | 0 | 3.33 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYNCSERVER |
12 | 0 | 3.33 | 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,791 | 2 | 1.80 | 6.52 | 157,554 | 44 | 41,857 | 0.45 |
| APPS_ASSM_IDX | /DB/visdata/apps_assm_idx.dbf |
6,738 | 2 | 2.15 | 1.04 | 126,362 | 35 | 185,160 | 0.09 |
| APPS_TS_ARCHIVE | /DB/visdata/archive1.dbf |
35 | 0 | 4.86 | 1.37 | 1,982 | 1 | 94 | 2.66 |
| APPS_TS_ARCHIVE | /DB/visdata/archive2.dbf |
29 | 0 | 4.83 | 1.38 | 279 | 0 | 3 | 0.00 |
| 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 | 12.50 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /DB/visdata/media3.dbf |
4 | 0 | 10.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /DB/visdata/nologging1.dbf |
4 | 0 | 15.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /DB/visdata/nologging2.dbf |
15 | 0 | 6.67 | 1.00 | 17 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /DB/visdata/nologging3.dbf |
6 | 0 | 11.67 | 3.33 | 10 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues1.dbf |
38 | 0 | 4.74 | 2.50 | 664 | 0 | 134 | 0.37 |
| APPS_TS_QUEUES | /DB/visdata/queues2.dbf |
39 | 0 | 3.85 | 2.82 | 839 | 0 | 123 | 0.33 |
| APPS_TS_QUEUES | /DB/visdata/queues3.dbf |
39 | 0 | 5.38 | 2.59 | 922 | 0 | 2 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues4.dbf |
47 | 0 | 5.11 | 2.23 | 779 | 0 | 1 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues5.dbf |
41 | 0 | 4.63 | 1.85 | 725 | 0 | 0 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues6.dbf |
49 | 0 | 5.31 | 2.20 | 436 | 0 | 2 | 0.00 |
| APPS_TS_QUEUES | /DB/visdata/queues7.dbf |
139 | 0 | 4.60 | 1.84 | 985 | 0 | 47 | 0.43 |
| APPS_TS_SEED | /DB/visdata/reference1.dbf |
182 | 0 | 5.16 | 1.37 | 470 | 0 | 56 | 4.46 |
| APPS_TS_SEED | /DB/visdata/reference10.dbf |
173 | 0 | 5.14 | 1.24 | 552 | 0 | 68 | 3.38 |
| APPS_TS_SEED | /DB/visdata/reference2.dbf |
199 | 0 | 4.97 | 1.27 | 575 | 0 | 50 | 0.00 |
| APPS_TS_SEED | /DB/visdata/reference3.dbf |
329 | 0 | 4.44 | 1.34 | 630 | 0 | 387 | 2.07 |
| APPS_TS_SEED | /DB/visdata/reference4.dbf |
208 | 0 | 4.38 | 1.35 | 629 | 0 | 28 | 2.14 |
| APPS_TS_SEED | /DB/visdata/reference5.dbf |
247 | 0 | 5.63 | 1.31 | 569 | 0 | 45 | 5.11 |
| APPS_TS_SEED | /DB/visdata/reference6.dbf |
233 | 0 | 4.89 | 1.39 | 629 | 0 | 33 | 0.91 |
| APPS_TS_SEED | /DB/visdata/reference7.dbf |
218 | 0 | 4.36 | 1.33 | 489 | 0 | 35 | 4.00 |
| APPS_TS_SEED | /DB/visdata/reference8.dbf |
182 | 0 | 5.82 | 1.49 | 499 | 0 | 54 | 4.26 |
| APPS_TS_SEED | /DB/visdata/reference9.dbf |
163 | 0 | 4.05 | 1.31 | 567 | 0 | 75 | 0.80 |
| APPS_TS_SUMMARY | /DB/visdata/summary1.dbf |
5 | 0 | 8.00 | 1.00 | 918 | 0 | 391 | 0.05 |
| APPS_TS_SUMMARY | /DB/visdata/summary2.dbf |
5 | 0 | 8.00 | 1.00 | 755 | 0 | 203 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary3.dbf |
9 | 0 | 12.22 | 1.00 | 842 | 0 | 276 | 0.04 |
| APPS_TS_SUMMARY | /DB/visdata/summary4.dbf |
7 | 0 | 8.57 | 1.00 | 896 | 0 | 302 | 0.00 |
| APPS_TS_SUMMARY | /DB/visdata/summary5.dbf |
7 | 0 | 8.57 | 1.00 | 913 | 0 | 353 | 0.03 |
| APPS_TS_SUMMARY | /DB/visdata/summary6.dbf |
7 | 0 | 12.86 | 1.00 | 934 | 0 | 659 | 0.05 |
| APPS_TS_SUMMARY | /DB/visdata/summary7.dbf |
7 | 0 | 14.29 | 1.00 | 1,014 | 0 | 200 | 0.10 |
| APPS_TS_SUMMARY | /DB/visdata/summary8.dbf |
7 | 0 | 8.57 | 1.00 | 1,121 | 0 | 281 | 0.04 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data1.dbf |
3,345 | 1 | 3.93 | 1.23 | 357 | 0 | 7 | 5.71 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data10.dbf |
3,314 | 1 | 4.03 | 1.27 | 254 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data11.dbf |
3,304 | 1 | 4.10 | 1.30 | 221 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data12.dbf |
13,483 | 4 | 2.66 | 1.21 | 4,099 | 1 | 3,176 | 0.65 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data13.dbf |
17,679 | 5 | 3.81 | 1.41 | 5,556 | 2 | 2,495 | 0.71 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data14.dbf |
13,189 | 4 | 3.53 | 1.34 | 27,634 | 8 | 18,527 | 0.15 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data15.dbf |
9,377 | 3 | 3.38 | 1.41 | 26,182 | 7 | 16,843 | 0.22 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data16.dbf |
9,453 | 3 | 3.39 | 1.39 | 25,555 | 7 | 18,074 | 0.18 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data17.dbf |
9,337 | 3 | 3.45 | 1.40 | 24,825 | 7 | 18,553 | 0.13 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data18.dbf |
9,496 | 3 | 3.44 | 1.38 | 23,550 | 7 | 18,091 | 0.14 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data19.dbf |
9,290 | 3 | 3.47 | 1.41 | 23,425 | 6 | 16,516 | 0.12 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data2.dbf |
6,920 | 2 | 3.13 | 1.15 | 1,101 | 0 | 2,157 | 0.80 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data20.dbf |
9,284 | 3 | 3.47 | 1.41 | 23,556 | 7 | 17,114 | 0.17 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data21.dbf |
23,761 | 7 | 4.02 | 1.22 | 1,088 | 0 | 1,398 | 0.04 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data3.dbf |
4,159 | 1 | 4.23 | 1.40 | 488 | 0 | 4 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data4.dbf |
17,903 | 5 | 3.67 | 1.08 | 329 | 0 | 3 | 6.67 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data5.dbf |
3,438 | 1 | 3.98 | 1.22 | 386 | 0 | 4 | 7.50 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data6.dbf |
3,411 | 1 | 3.92 | 1.25 | 253 | 0 | 12 | 2.50 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data7.dbf |
3,339 | 1 | 4.22 | 1.26 | 518 | 0 | 33 | 2.42 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data8.dbf |
3,303 | 1 | 3.78 | 1.26 | 479 | 0 | 7 | 0.00 |
| APPS_TS_TX_DATA | /DB/visdata/tx_data9.dbf |
3,468 | 1 | 3.77 | 1.30 | 287 | 0 | 2 | 5.00 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx1.dbf |
2,669 | 1 | 3.36 | 1.12 | 2,319 | 1 | 1,008 | 0.72 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx10.dbf |
2,537 | 1 | 3.07 | 1.11 | 1,649 | 0 | 1,252 | 0.56 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx11.dbf |
2,556 | 1 | 3.17 | 1.16 | 1,760 | 0 | 1,115 | 0.19 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx12.dbf |
11,618 | 3 | 3.86 | 1.47 | 24,876 | 7 | 1,328 | 0.38 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx13.dbf |
9,208 | 3 | 3.62 | 1.21 | 29,204 | 8 | 3,663 | 0.25 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx14.dbf |
5,387 | 1 | 3.73 | 1.31 | 21,592 | 6 | 3,685 | 0.14 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx15.dbf |
5,352 | 1 | 3.75 | 1.30 | 18,778 | 5 | 4,257 | 0.18 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx16.dbf |
5,310 | 1 | 3.73 | 1.30 | 17,401 | 5 | 4,414 | 0.15 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx17.dbf |
5,299 | 1 | 3.66 | 1.28 | 16,132 | 4 | 3,793 | 0.22 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx18.dbf |
5,339 | 1 | 3.54 | 1.32 | 15,966 | 4 | 6,024 | 0.13 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx19.dbf |
5,343 | 1 | 3.61 | 1.26 | 15,527 | 4 | 4,722 | 0.16 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx2.dbf |
3,163 | 1 | 3.64 | 1.27 | 2,193 | 1 | 1,861 | 0.20 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx20.dbf |
5,131 | 1 | 3.69 | 1.31 | 14,864 | 4 | 3,609 | 0.08 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx21.dbf |
3,625 | 1 | 3.88 | 1.47 | 15,283 | 4 | 2,503 | 0.34 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx3.dbf |
4,087 | 1 | 2.58 | 1.11 | 1,900 | 1 | 2,258 | 0.84 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx4.dbf |
2,727 | 1 | 3.41 | 1.12 | 3,523 | 1 | 2,053 | 0.77 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx5.dbf |
2,777 | 1 | 3.09 | 1.16 | 4,873 | 1 | 8,221 | 0.16 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx6.dbf |
2,704 | 1 | 3.29 | 1.21 | 2,755 | 1 | 1,813 | 0.71 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx7.dbf |
2,647 | 1 | 3.14 | 1.14 | 2,549 | 1 | 1,424 | 0.51 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx8.dbf |
2,654 | 1 | 3.27 | 1.15 | 2,038 | 1 | 1,339 | 0.67 |
| APPS_TS_TX_IDX | /DB/visdata/tx_idx9.dbf |
2,602 | 1 | 3.27 | 1.15 | 1,788 | 0 | 1,180 | 0.64 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte.dbf |
155 | 0 | 1.68 | 1.99 | 5,501 | 2 | 2,039 | 0.10 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte2.dbf |
326 | 0 | 1.78 | 2.00 | 6,764 | 2 | 3,459 | 0.03 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte3.dbf |
201 | 0 | 1.84 | 2.23 | 6,000 | 2 | 3,213 | 0.02 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte4.dbf |
158 | 0 | 2.22 | 2.34 | 5,578 | 2 | 2,049 | 0.07 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte5.dbf |
259 | 0 | 1.89 | 1.75 | 5,459 | 2 | 2,667 | 0.04 |
| APPS_TS_TX_INTERFACE | /DB/visdata/ts_tx_inte6.dbf |
161 | 0 | 2.48 | 2.17 | 5,481 | 2 | 1,751 | 0.05 |
| APPS_UNDOTS1 | /DB/visdata/undo01.dbf |
3 | 0 | 10.00 | 1.00 | 64,410 | 18 | 23,471 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo02.dbf |
3 | 0 | 10.00 | 1.00 | 62,759 | 17 | 25,227 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo03.dbf |
3 | 0 | 10.00 | 1.00 | 62,478 | 17 | 26,710 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo04.dbf |
3 | 0 | 10.00 | 1.00 | 63,508 | 18 | 24,112 | 0.02 |
| APPS_UNDOTS1 | /DB/visdata/undo05.dbf |
3 | 0 | 6.67 | 1.00 | 60,962 | 17 | 29,541 | 0.04 |
| APPS_UNDOTS1 | /DB/visdata/undo06.dbf |
3 | 0 | 6.67 | 1.00 | 60,884 | 17 | 25,085 | 0.02 |
| APPS_UNDOTS1 | /DB/visdata/undo07.dbf |
3 | 0 | 10.00 | 1.00 | 60,657 | 17 | 29,588 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo08.dbf |
4 | 0 | 10.00 | 1.00 | 60,003 | 17 | 31,736 | 0.02 |
| APPS_UNDOTS1 | /DB/visdata/undo09.dbf |
3 | 0 | 6.67 | 1.00 | 61,649 | 17 | 28,744 | 0.03 |
| APPS_UNDOTS1 | /DB/visdata/undo10.dbf |
3 | 0 | 16.67 | 1.00 | 65,314 | 18 | 24,725 | 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 | 4.17 | 1.00 | 3 | 0 | 0 | 0.00 |
| ODM | /DB/visdata/odm.dbf |
12 | 0 | 4.17 | 1.00 | 3 | 0 | 0 | 0.00 |
| OLAP | /DB/visdata/olap.dbf |
12 | 0 | 5.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 | 3.33 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYNCSERVER | /DB/visdata/mobile01.dbf |
12 | 0 | 3.33 | 1.00 | 3 | 0 | 0 | 0.00 |
| SYSAUX | /DB/visdata/sysaux01.dbf |
116 | 0 | 1.72 | 1.02 | 585 | 0 | 0 | 0.00 |
| SYSAUX | /DB/visdata/sysaux02.dbf |
796 | 0 | 2.06 | 1.05 | 1,345 | 0 | 0 | 0.00 |
| SYSTEM | /DB/visdata/sys1.dbf |
498 | 0 | 3.05 | 4.35 | 114 | 0 | 16 | 0.00 |
| SYSTEM | /DB/visdata/sys2.dbf |
462 | 0 | 3.51 | 4.84 | 208 | 0 | 7 | 1.43 |
| SYSTEM | /DB/visdata/sys3.dbf |
536 | 0 | 3.02 | 4.18 | 245 | 0 | 1 | 0.00 |
| SYSTEM | /DB/visdata/sys4.dbf |
519 | 0 | 2.89 | 4.29 | 264 | 0 | 1 | 0.00 |
| SYSTEM | /DB/visdata/sys5.dbf |
735 | 0 | 3.82 | 3.29 | 700 | 0 | 442 | 0.02 |
| SYSTEM | /DB/visdata/sys6.dbf |
560 | 0 | 3.46 | 4.15 | 77 | 0 | 1 | 0.00 |
| SYSTEM | /DB/visdata/sys7.dbf |
402 | 0 | 3.91 | 4.61 | 180 | 0 | 25 | 1.20 |
| SYSTEM | /DB/visdata/sys8.dbf |
292 | 0 | 3.87 | 3.85 | 520 | 0 | 19,054 | 0.06 |
| SYSTEM | /DB/visdata/sys9.dbf |
400 | 0 | 3.88 | 2.94 | 489 | 0 | 10 | 0.00 |
| TEMP | /DB/visdata/temp1.dbf |
127 | 0 | 3.78 | 2.00 | 2,262 | 1 | 10 | 5.00 |
| TEMP | /DB/visdata/temp2.dbf |
137 | 0 | 3.94 | 2.76 | 2,675 | 1 | 39 | 3.33 |
| TEMP | /DB/visdata/temp3.dbf |
128 | 0 | 5.08 | 12.65 | 2,496 | 1 | 2 | 10.00 |
| TEMP | /DB/visdata/temp4.dbf |
158 | 0 | 4.37 | 18.30 | 2,450 | 1 | 16 | 0.63 |
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,178,888 | 100 | 2,094,899,594 | 444,396 | 3,151,224 | 0 | 0 | 729,201 |
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 | 96 | 48403 | 1186404 | 4582462 | 188743680 | 4582462 | |
| E | 180 | 99 | 52580 | 1195632 | 10195460 | 188743680 | 10195460 | |
Back to Advisory Statistics
Back to Top
|
