Worldwide Secure Search All Blogs CRM On Demand Discussion Forums Documentation Education Oracle.com PartnerNetwork Technology Network Video and Multimedia Home Products and Services Industries Support Store Partners Communities About

TECHNOLOGY PRODUCTS APPLICATION PRODUCTS FUSION APPLICATIONS ORACLE SERVICES CUSTOMERS | PARTNERS ORACLE CORPORATION Legal | Privacy Worldwide Sites Africa Operation Argentina Australia Austria Bahrain Bangladesh Belgium & Luxembourg Belize Bhutan Bolivia Bosnia & Herzegovina Brasil Brunei Bulgaria Cambodia Canada - English Canada - French Chile China Colombia Costa Rica Croatia Czech Republic Denmark Ecuador Egypt Estonia Finland France Germany Greece Guatemala Honduras Hong Kong Hungary India Indonesia Iraq Ireland Israel Italy Japan Jordan Kazakhstan Korea Kuwait Laos Latvia Lebanon Lithuania Malaysia Maldives Malta Mexico Moldova Nepal Netherlands New Zealand Nicaragua Norway Oman Pakistan Panama Paraguay Peru Philippines Poland Portugal Puerto Rico Qatar Romania Russia Saudi Arabia Serbia & Montenegro Singapore Slovakia Slovenia South Africa Spain Sri Lanka Sweden Switzerland -- French Switzerland -- German Taiwan Thailand Turkey Ukraine United Arab Emirates United Kingdom United States Uraguay Venezuela Vietnam Yemen

WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst num Release RAC Host VIS 193532335 VIS 1 10.2.0.3.0 NO db Snap Id Snap Time Sessions Cursors/Session Begin Snap: 2578 19-Mar-09 09:55:51 68 22.9 End Snap: 2579 19-Mar-09 10:40:35 69 23.3 Elapsed:   44.74 (mins)     DB Time:   291.50 (mins)     Report Summary Cache Sizes Begin End Buffer Cache: 8,192M 8,192M Std Block Size: 8K Shared Pool Size: 2,048M 2,048M Log Buffer: 14,340K Load Profile Per Second Per Transaction Redo size: 7,656,751.59 33,518.62 Logical reads: 513,391.72 2,247.45 Block changes: 47,037.78 205.92 Physical reads: 21.59 0.09 Physical writes: 550.45 2.41 User calls: 63.78 0.28 Parses: 734.07 3.21 Hard parses: 0.27 0.00 Sorts: 1,758.79 7.70 Logons: 0.17 0.00 Executes: 17,031.93 74.56 Transactions: 228.43   % Blocks changed per Read: 9.16 Recursive Call %: 99.79 Rollback per transaction %: 0.10 Rows per Sort: 3.22 Instance Efficiency Percentages (Target 100%) Buffer Nowait %: 99.93 Redo NoWait %: 100.00 Buffer Hit %: 100.00 In-memory Sort %: 100.00 Library Hit %: 99.98 Soft Parse %: 99.96 Execute to Parse %: 95.69 Latch Hit %: 97.25 Parse CPU to Parse Elapsd %: 25.27 % Non-Parse CPU: 99.88 Shared Pool Statistics Begin End Memory Usage %: 25.24 25.90 % SQL with executions>1: 95.22 92.65 % Memory for SQL w/exec>1: 95.84 95.49 Top 5 Timed Events Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class CPU time   8,053   46.0   log file parallel write 405,082 661 2 3.8 System I/O log file sync 135,303 493 4 2.8 Commit buffer busy waits 965,901 319 0 1.8 Concurrency db file parallel write 103,382 193 2 1.1 System I/O Main Report Report Summary Wait Events Statistics SQL Statistics Instance Activity Statistics IO Stats Buffer Pool Statistics Advisory Statistics Wait Statistics Undo Statistics Latch Statistics Segment Statistics Dictionary Cache Statistics Library Cache Statistics Memory Statistics Streams Statistics Resource Limit Statistics init.ora Parameters Back to Top Wait Events Statistics Time Model Statistics Wait Class Wait Events Background Wait Events Operating System Statistics Service Statistics Service Wait Class Stats Back to Top Time Model Statistics Total time in database user-calls (DB Time): 17490s 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 sql execute elapsed time 17,476.53 99.92 DB CPU 8,053.11 46.04 PL/SQL execution elapsed time 3,492.10 19.97 Java execution elapsed time 404.59 2.31 parse time elapsed 53.72 0.31 sequence load elapsed time 8.63 0.05 hard parse elapsed time 6.63 0.04 repeated bind elapsed time 4.05 0.02 connection management call elapsed time 0.67 0.00 hard parse (sharing criteria) elapsed time 0.19 0.00 PL/SQL compilation elapsed time 0.16 0.00 hard parse (bind mismatch) elapsed time 0.02 0.00 inbound PL/SQL rpc elapsed time 0.01 0.00 DB time 17,490.02   background elapsed time 960.63   background cpu time 53.70   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 System I/O 512,110 0.00 857 2 0.84 Concurrency 1,066,160 0.02 515 0 1.74 Commit 135,303 0.00 493 4 0.22 User I/O 53,958 0.00 162 3 0.09 Application 16,605 0.00 147 9 0.03 Other 171,599 42.90 71 0 0.28 Configuration 24,578 64.25 12 0 0.04 Network 305,146 0.00 3 0 0.50 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 log file parallel write 405,082 0.00 661 2 0.66 log file sync 135,303 0.00 493 4 0.22 buffer busy waits 965,901 0.00 319 0 1.58 db file parallel write 103,382 0.00 193 2 0.17 db file sequential read 42,674 0.00 146 3 0.07 enq: TX - row lock contention 16,292 0.00 146 9 0.03 latch: cache buffers chains 75,464 0.00 62 1 0.12 latch: library cache 2,764 0.00 48 17 0.00 enq: TX - index contention 16,606 0.00 36 2 0.03 latch free 1,681 0.00 19 11 0.00 latch: library cache pin 1,021 0.00 18 17 0.00 enq: TX - contention 8,814 0.00 14 2 0.01 read by other session 7,985 0.01 12 2 0.01 enq: HW - contention 5,798 0.00 11 2 0.01 latch: In memory undo latch 2,222 0.00 9 4 0.00 latch: row cache objects 621 0.00 8 13 0.00 LGWR wait for redo copy 21,269 0.62 8 0 0.03 latch: redo allocation 1,314 0.00 8 6 0.00 latch: undo global data 1,655 0.00 7 4 0.00 latch: shared pool 546 0.00 6 11 0.00 latch: library cache lock 215 0.00 5 25 0.00 cursor: pin S wait on X 282 89.36 3 12 0.00 db file scattered read 1,908 0.00 3 2 0.00 SQL*Net more data to client 152,124 0.00 3 0 0.25 buffer deadlock 18,592 99.60 3 0 0.03 latch: enqueue hash chains 155 0.00 2 16 0.00 latch: session allocation 224 0.00 2 11 0.00 control file parallel write 1,313 0.00 2 2 0.00 enq: FB - contention 1,627 0.00 2 1 0.00 latch: cache buffers lru chain 261 0.00 2 7 0.00 rdbms ipc reply 1,842 0.00 2 1 0.00 PX Deq Credit: send blkd 2,582 0.00 1 0 0.00 cursor: pin S 56,429 0.00 1 0 0.09 control file sequential read 2,333 0.00 1 0 0.00 kksfbc child completion 16 81.25 1 40 0.00 enq: SQ - contention 2,833 0.00 1 0 0.00 SQL*Net break/reset to client 276 0.00 0 1 0.00 os thread startup 15 0.00 0 21 0.00 PX Deq: Signal ACK 25 40.00 0 12 0.00 wait list latch free 13 0.00 0 20 0.00 enq: RO - fast object reuse 37 0.00 0 4 0.00 latch: object queue header operation 50 0.00 0 2 0.00 local write wait 66 0.00 0 2 0.00 SQL*Net message to client 145,588 0.00 0 0 0.24 latch: redo writing 19 0.00 0 4 0.00 row cache lock 500 0.00 0 0 0.00 PX qref latch 54,997 99.92 0 0 0.09 SQL*Net more data from client 7,434 0.00 0 0 0.01 direct path read 1,050 0.00 0 0 0.00 undo segment extension 15,825 99.79 0 0 0.03 latch: checkpoint queue latch 6 0.00 0 4 0.00 direct path write 271 0.00 0 0 0.00 enq: TX - allocate ITL entry 102 0.00 0 0 0.00 log buffer space 1 0.00 0 10 0.00 direct path write temp 4 0.00 0 1 0.00 reliable message 35 0.00 0 0 0.00 latch: messages 2 0.00 0 0 0.00 enq: PS - contention 6 0.00 0 0 0.00 latch: cache buffer handles 4 0.00 0 0 0.00 cursor: mutex X 3 0.00 0 0 0.00 SQL*Net message from client 145,587 0.00 57,358 394 0.24 Streams AQ: waiting for messages in the queue 836 97.97 5,325 6370 0.00 PL/SQL lock timer 267 100.00 2,933 10984 0.00 PX Idle Wait 1,376 97.09 2,622 1906 0.00 pipe get 1,073 100.00 2,619 2441 0.00 Streams AQ: qmn coordinator idle wait 969 42.41 2,616 2699 0.00 Streams AQ: qmn slave idle wait 470 0.00 2,616 5565 0.00 Streams AQ: waiting for time management or cleanup tasks 75 41.33 2,076 27674 0.00 jobq slave wait 140 100.00 410 2930 0.00 PX Deq: Execution Msg 497 0.00 5 10 0.00 PX Deq: Execute Reply 250 0.00 1 2 0.00 PX Deq: Msg Fragment 306 0.00 0 0 0.00 PX Deq Credit: need buffer 394 0.00 0 0 0.00 PX Deq: Parse Reply 21 0.00 0 1 0.00 PX Deq: Table Q Normal 808 0.00 0 0 0.00 PX Deq: Join ACK 27 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 405,082 0.00 661 2 0.66 db file parallel write 103,382 0.00 193 2 0.17 events in waitclass Other 23,715 0.55 11 0 0.04 control file parallel write 1,313 0.00 2 2 0.00 control file sequential read 638 0.00 1 1 0.00 db file sequential read 47 0.00 0 5 0.00 os thread startup 7 0.00 0 26 0.00 latch: redo writing 19 0.00 0 4 0.00 buffer busy waits 145 0.00 0 0 0.00 direct path write 258 0.00 0 0 0.00 latch: library cache 2 0.00 0 11 0.00 log buffer space 1 0.00 0 10 0.00 latch: row cache objects 1 0.00 0 6 0.00 latch: In memory undo latch 3 0.00 0 1 0.00 direct path read 1,038 0.00 0 0 0.00 undo segment extension 776 99.48 0 0 0.00 latch: cache buffers chains 2 0.00 0 0 0.00 rdbms ipc message 395,212 2.03 20,758 53 0.64 smon timer 2,569 0.00 2,676 1042 0.00 pmon timer 946 100.00 2,619 2769 0.00 Streams AQ: qmn coordinator idle wait 969 42.41 2,616 2699 0.00 Streams AQ: qmn slave idle wait 470 0.00 2,616 5565 0.00 Streams AQ: waiting for time management or cleanup tasks 75 41.33 2,076 27674 0.00 Back to Wait Events Statistics Back to Top Operating System Statistics Statistic Total NUM_LCPUS 0 NUM_VCPUS 0 AVG_BUSY_TIME 94,445 AVG_IDLE_TIME 39,760 AVG_IOWAIT_TIME 679 AVG_SYS_TIME 2,948 AVG_USER_TIME 91,406 BUSY_TIME 1,512,419 IDLE_TIME 637,440 IOWAIT_TIME 11,875 SYS_TIME 48,555 USER_TIME 1,463,864 LOAD 0 OS_CPU_WAIT_TIME 1,814,200 RSRC_MGR_CPU_WAIT_TIME 0 PHYSICAL_MEMORY_BYTES 66,303,557,632 NUM_CPUS 16 NUM_CPU_CORES 4 Back to Wait Events Statistics Back to Top Service Statistics ordered by DB Time Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads VIS 17,464.40 8,039.80 56,705 1,368,772,196 SYS$USERS 25.70 13.30 141 6,820,243 SYS$BACKGROUND 0.00 0.00 1,085 2,488,980 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 VIS 52199 16128 1065992 51449 0 0 303919 336 SYS$USERS 416 52 5 1 0 0 48 0 SYS$BACKGROUND 1343 24 160 24 0 0 0 0 Back to Wait Events Statistics Back to Top SQL Statistics SQL ordered by Elapsed Time SQL ordered by CPU Time SQL ordered by Gets SQL ordered by Reads SQL ordered by Executions SQL ordered by Parse Calls SQL ordered by Sharable Memory SQL ordered by Version Count Complete List of SQL Text 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 5,948 3,027 16 371.77 34.01 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA... 5,630 2,144 8 703.77 32.19 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC... 2,246 609 100 22.46 12.84 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3... 2,040 986 49,865 0.04 11.67 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN... 1,986 1,052 50,000 0.04 11.35 1mr538jsgzb45 WSHPSGL_SUB SELECT DISTINCT WDD.SOURCE_LIN... 1,720 884 10 171.95 9.83 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT... 1,356 352 50,000 0.03 7.75 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF... 590 300 10 58.95 3.37 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS... 579 411 149,995 0.00 3.31 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran... 541 356 50,000 0.01 3.09 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f... 493 410 204,893 0.00 2.82 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F... 387 386 399,995 0.00 2.21 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS... 374 373 354,946 0.00 2.14 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ... 356 347 49,926 0.01 2.03 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (... 337 182 50,000 0.01 1.93 assndb4wqnd6r INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_... 316 300 2,819,752 0.00 1.81 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ... 273 240 1,689,899 0.00 1.56 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS... 179 166 1,344,886 0.00 1.02 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_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 3,027 5,948 16 189.18 34.01 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA... 2,144 5,630 8 267.94 32.19 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC... 1,052 1,986 50,000 0.02 11.35 1mr538jsgzb45 WSHPSGL_SUB SELECT DISTINCT WDD.SOURCE_LIN... 986 2,040 49,865 0.02 11.67 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN... 884 1,720 10 88.41 9.83 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT... 609 2,246 100 6.09 12.84 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3... 411 579 149,995 0.00 3.31 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran... 410 493 204,893 0.00 2.82 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F... 386 387 399,995 0.00 2.21 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS... 373 374 354,946 0.00 2.14 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ... 356 541 50,000 0.01 3.09 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f... 352 1,356 50,000 0.01 7.75 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF... 347 356 49,926 0.01 2.03 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (... 300 316 2,819,752 0.00 1.81 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ... 300 590 10 29.96 3.37 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS... 240 273 1,689,899 0.00 1.56 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS... 182 337 50,000 0.00 1.93 assndb4wqnd6r INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_... 166 179 1,344,886 0.00 1.02 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S... Back to SQL Statistics Back to Top SQL ordered by Gets Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. Total Buffer Gets: 1,378,081,470 Captured SQL account for 43.4% of Total Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text 637,364,586 16 39,835,286.63 46.25 3026.81 5948.29 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA... 227,037,073 8 28,379,634.13 16.47 2143.53 5630.16 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC... 223,335,719 10 22,333,571.90 16.21 884.11 1719.51 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT... 121,564,102 50,000 2,431.28 8.82 1052.11 1985.55 1mr538jsgzb45 WSHPSGL_SUB SELECT DISTINCT WDD.SOURCE_LIN... 111,682,696 399,995 279.21 8.10 386.27 386.50 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS... 102,943,590 354,946 290.03 7.47 373.06 374.44 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ... 83,993,408 100 839,934.08 6.09 608.54 2245.63 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3... 63,640,554 49,865 1,276.26 4.62 986.21 2040.35 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN... 60,485,391 50,000 1,209.71 4.39 356.24 541.22 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f... 58,011,237 2,819,752 20.57 4.21 300.22 316.50 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ... 50,913,979 10 5,091,397.90 3.69 299.62 589.54 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS... 49,321,813 149,995 328.82 3.58 411.42 578.93 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran... 43,584,254 1,689,899 25.79 3.16 240.34 273.50 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS... 25,382,009 309,967 81.89 1.84 122.40 128.40 b73h3md2wvs09 OEHVIMP SELECT C.INSTANCE_ID FROM WF_P... 24,076,515 50,000 481.53 1.75 352.18 1355.81 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF... 23,147,949 1,344,886 17.21 1.68 166.07 178.62 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S... 20,383,540 4 5,095,885.00 1.48 119.36 132.12 7ptvbaycjtbg4 ARTERRPW BEGIN arp_run.revenue_recognit... 19,302,531 54,984 351.06 1.40 131.45 147.46 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW... 15,823,978 29,965 528.08 1.15 68.37 68.39 6uwctg1cdb25v WSHPSGL_SUB SELECT DG.DELIVERY_LEG_ID LEG_... 14,481,837 16 905,114.81 1.05 111.67 149.20 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_... 14,450,872 3 4,816,957.33 1.05 153.52 154.13 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA... Back to SQL Statistics Back to Top SQL ordered by Reads Total Disk Reads: 57,953 Captured SQL account for 1.7% of Total Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text 32,368 8 4,046.00 55.85 2143.53 5630.16 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC... 31,007 49,865 0.62 53.50 986.21 2040.35 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN... 11,467 16 716.69 19.79 111.67 149.20 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_... 2,901 16 181.31 5.01 3026.81 5948.29 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA... 2,118 10 211.80 3.65 299.62 589.54 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS... 758 10 75.80 1.31 884.11 1719.51 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT... 741 54,984 0.01 1.28 131.45 147.46 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW... 480 3 160.00 0.83 153.52 154.13 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA... 357 100 3.57 0.62 608.54 2245.63 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3... 307 49,926 0.01 0.53 346.70 355.69 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (... Back to SQL Statistics Back to Top SQL ordered by Executions Total Executions: 45,718,295 Captured SQL account for 24.2% of Total Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text 2,819,752 1,528,273 0.54 0.00 0.00 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ... 1,689,899 1,689,666 1.00 0.00 0.00 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS... 1,344,886 1,344,791 1.00 0.00 0.00 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S... 399,995 49,978 0.12 0.00 0.00 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS... 399,471 398,361 1.00 0.00 0.00 7bdg2fscmus2h WSHINTERFACES SELECT ACCOUNTING_RULE_ID , A... 354,946 0 0.00 0.00 0.00 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ... 309,967 309,011 1.00 0.00 0.00 b73h3md2wvs09 OEHVIMP SELECT C.INSTANCE_ID FROM WF_P... 204,893 204,819 1.00 0.00 0.00 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F... 199,947 199,826 1.00 0.00 0.00 fb13x9qx0ftks OEHVIMP begin OE_STANDARD_WF.OEOL_SELE... 199,904 199,697 1.00 0.00 0.00 ghmx8n7wgqvfr WSHINTERFACES begin WF_STANDARD.DEFER (:v1, ... Back to SQL Statistics Back to Top SQL ordered by Parse Calls Total Parse Calls: 1,970,434 Captured SQL account for 93.7% of Total Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text 199,988 199,947 10.15 fb13x9qx0ftks OEHVIMP begin OE_STANDARD_WF.OEOL_SELE... 199,978 199,904 10.15 ghmx8n7wgqvfr WSHINTERFACES begin WF_STANDARD.DEFER (:v1, ... 149,970 149,997 7.61 0mdnts20d60yr WSHPSGL_SUB declare v_ret number := 0... 100,014 100,021 5.08 1v818hwxjxy58 WSHINTERFACES select FND_FLEX_VALUES_VL.FLEX... 99,902 99,954 5.07 1c0b7sas42w2z WSHPSGL_SUB SELECT NVL(ITEM_COST, 0), ... 60,001 59,987 3.05 bf7uwg5pa3pj6 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.V... 60,000 59,994 3.05 76sw2a4vnc89j WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.S... 59,999 59,999 3.04 608c0n36kaw62 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.C... 59,999 59,996 3.04 dcvv68fju01g4 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.E... 54,992 54,984 2.79 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW... 50,012 50,018 2.54 g2qs4xk48vcwy WSHINTERFACES select to_char(CODE_COMBINATIO... 50,000 50,000 2.54 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF... 49,998 49,994 2.54 bfbyqwbr4vwms OEHVIMP begin OE_OEOL_SCH.SCHEDULE_LIN... 49,998 50,000 2.54 fvcbstf9s6a5r OEHVIMP begin WF_STANDARD.WAITFORFLOW ... 49,997 49,992 2.54 7mrs575bj7a41 OEHVIMP begin OE_OEOL_SCH.BRANCH_ON_SO... 49,994 49,865 2.54 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN... 49,992 49,998 2.54 cw171rvngr1w9 WSHINTERFACES begin OE_FLEX_COGS_PUB.GET_COS... 49,991 49,978 2.54 gdnwgx9fcxggr OEHVIMP begin OE_SHIPPING_WF.START_SHI... 49,964 49,975 2.54 bsuw7pmwrufpy INCTCW SELECT reservation_... 49,957 49,981 2.54 a40f9h91scg23 WSHINTERFACES select to_char(CODE_COMBINATIO... 49,941 49,987 2.53 7mz96k4qtxrzr WSHPSGL_SUB SELECT BASE.REVISION , BASE.LO... 49,932 49,926 2.53 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (... 44,998 45,000 2.28 7gtztzv329wg0   select c.name, u.name from co... 44,997 44,997 2.28 2skwhauh2cwky   select o.name, u.name from ob... 41,756 41,756 2.12 4m7m0t6fjcs5x   update seq$ set increment$=:2,... 21,301 21,302 1.08 bsa0wjtftg3uw   select file# from file$ where ... 21,022 21,023 1.07 9qgtwh66xg6nz   update seg$ set type#=:4, bloc... Back to SQL Statistics Back to Top SQL ordered by Sharable Memory No data exists for this section of the report. 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
0074pdmwb7fmv	BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
0mdnts20d60yr	declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7, :8)) then v_ret := 1; end if; :9 := v_ret; end;
0r0gvtarcjwzz	insert into "ASO"."ASO_ORDER_FEEDBACK_T" (q_name, msgid, corrid, priority, state, delay, expiration, time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid, enq_tid, retry_count, exception_qschema, exception_queue, recipient_key, dequeue_msgid, user_data, sender_name, sender_address, sender_protocol, user_prop, cscn, dscn) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)
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 ;
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
1mr538jsgzb45	SELECT DISTINCT WDD.SOURCE_LINE_ID, WDD.SOURCE_HEADER_ID, WDD.ORGANIZATION_ID, WDD.INVENTORY_ITEM_ID, WDD.MOVE_ORDER_LINE_ID, WDD.DELIVERY_DETAIL_ID, WDD.SHIP_MODEL_COMPLETE_FLAG, WDD.TOP_MODEL_LINE_ID, WDD.SHIP_FROM_LOCATION_ID, NULL SHIP_METHOD_CODE, WDD.SHIPMENT_PRIORITY_CODE, WDD.DATE_SCHEDULED DATE_SCHEDULED, WDD.REQUESTED_QUANTITY, WDD.REQUESTED_QUANTITY_UOM, WDD.PREFERRED_GRADE, WDD.REQUESTED_QUANTITY2, WDD.REQUESTED_QUANTITY_UOM2, WDD.PROJECT_ID, WDD.TASK_ID, WDD.SUBINVENTORY FROM_SUBINVENTORY_CODE, WDD.SUBINVENTORY TO_SUBINVENTORY_CODE, WDD.RELEASED_STATUS RELEASED_STATUS, WDD.SHIP_SET_ID SHIP_SET_ID, WDD.SOURCE_CODE SOURCE_CODE, WDD.SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER, NULL PLANNED_DEPARTURE_DATE, WDA.DELIVERY_ID, OL.END_ITEM_UNIT_NUMBER, OL.SOURCE_DOCUMENT_TYPE_ID, MSI.RESERVABLE_TYPE, WDD.LAST_UPDATE_DATE, -1 DEMAND_SOURCE_HEADER_ID, -1 OUTSTANDING_ORDER_VALUE, WDD.CUSTOMER_ID FROM WSH_DELIVERY_DETAILS WDD, wsh_delivery_assignments_v WDA, OE_ORDER_LINES_ALL OL, MTL_SYSTEM_ITEMS MSI , MTL_CATEGORY_SETS MCS, MTL_ITEM_CATEGORIES MIC WHERE WDD.DATE_SCHEDULED IS NOT NULL AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND NVL(WDD.REQUESTED_QUANTITY, 0) > 0 AND WDD.SOURCE_LINE_ID = OL.LINE_ID AND WDD.SOURCE_CODE = 'OE' AND WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND WDD.ORGA NIZATION_ID = MSI.ORGANIZATION_ID AND WDD.RELEASED_STATUS IN ( 'R', 'X') AND WDD.SHIP_FROM_LOCATION_ID = :X_ship_from_loc_id AND WDD.ORGANIZATION_ID = :X_org_id AND WDD.INVENTORY_ITEM_ID = :X_inventory_item_id AND (WDA.DELIVERY_ID IS NULL ) AND (NVL(WDD.DEP_PLAN_REQUIRED_FLAG, 'N') = 'N' OR (NVL(WDD.DEP_PLAN_REQUIRED_FLAG, 'N') = 'Y' AND EXISTS ( SELECT 1 FROM WSH_NEW_DELIVERIES WDE1 WHERE WDE1.DELIVERY_ID = WDA.DELIVERY_ID AND ( NVL(WDE1.PLANNED_FLAG, 'N') IN ('Y', 'F' ) )) )) AND MCS.category_set_id = MIC.category_set_id AND MCS.category_set_id = :x_CategorySetID AND MIC.category_id = :x_CategoryID AND MIC.organization_id = WDD.organization_id AND MIC.inventory_item_id = WDD.inventory_item_id ORDER BY WDD.INVENTORY_ITEM_ID, DATE_SCHEDULED ASC, SHIPMENT_PRIORITY_CODE ASC, to_number(SOURCE_HEADER_NUMBER) ASC, SHIP_FROM_LOCATION_ID
1v818hwxjxy58	select FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.DESCRIPTION, FND_FLEX_VALUES_VL.ENABLED_FLAG, to_char(FND_FLEX_VALUES_VL.START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(FND_FLEX_VALUES_VL.END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), FND_FLEX_VALUES_VL.SUMMARY_FLAG, FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES from FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL where (( FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :FND_BIND1) AND ( ((1=1) AND /* GL_COA_BS_TAG */ (GL_AFF_AWC_API_PKG.gl_valid_flex_values(:FND_BIND2, FND_FLEX_VALUES_VL.Flex_Value) = 'Y') ) )) and FND_FLEX_VALUES_VL.FLEX_VALUE = :FND_BIND3
1wnq9qthbb54q	BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5); END;
2skwhauh2cwky	select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
3b3psftuyks81	BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4y08a52989vfk	BEGIN WSH_PICK_LIST.RELEASE_BATCH_SUB(:errbuf, :rc, :A0, :A1, :A2, :A3); END;
4yak7x2zqz0dh	BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
52zwqr7xyrc2m	SELECT 'Y' FROM WSH_PR_WORKERS WHERE BATCH_ID = :B3 AND ORGANIZATION_ID = :B2 AND NVL(INVENTORY_ITEM_ID, -99) = NVL(:B1 , -99) AND TYPE = 'PICK' AND PROCESSED = 'N' FOR UPDATE NOWAIT
5t39uchjqpyfm	BEGIN xla_accounting_pkg.unit_processor_batch(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14); END;
608c0n36kaw62	begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
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
6uwctg1cdb25v	SELECT DG.DELIVERY_LEG_ID LEG_ID, ST1.STOP_LOCATION_ID PICKUP, ST2.STOP_LOCATION_ID DROPOFF FROM WSH_DELIVERY_LEGS DG, WSH_TRIP_STOPS ST1, WSH_TRIP_STOPS ST2 WHERE DG.DELIVERY_ID = :B2 AND ST1.STOP_ID = DG.PICK_UP_STOP_ID AND ST2.STOP_ID = DG.DROP_OFF_STOP_ID AND ST1.STOP_LOCATION_ID = :B1
72yyswsqkzkrm	BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10); END;
76sw2a4vnc89j	begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7bdg2fscmus2h	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 , SHIPPING_QUANTITY_UOM2 , 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_ATTRI BUTE8 , 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 , CHARGE_PERIODICITY_CODE , CANCELLED_QUANTITY2 , FULFILLED_QUANTITY2 , CONTINGENCY_ID , REVREC_EVENT_CODE , REVREC_EXPIRATION_DAYS , ACCEPTED_QUANTITY , REVREC_COMMENTS , REVREC_SIGNATURE , REVREC_SIGNATURE_DATE , ACCEPTED_BY , REVREC_REFERENCE_DOCUMENT , REVREC_IMPLICIT_FLAG FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
7gtztzv329wg0	select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
7mrs575bj7a41	begin OE_OEOL_SCH.BRANCH_ON_SOURCE_TYPE (:v1, :v2, :v3, :v4, :v5); end;
7mz96k4qtxrzr	SELECT BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.UOM_CODE , DECODE(:B7 , -9999, NULL, :B7 ) LPN_ID , NULL SERIAL_NUMBER , SUM(BASE.PRIMARY_QUANTITY) , SUM(BASE.SECONDARY_QUANTITY) , BASE.GRADE_CODE , NULL CONSIST_STRING , MSEI.PICKING_ORDER ORDER_BY_STRING FROM OE_ORDER_LINES_ALL OOL , MTL_SECONDARY_INVENTORIES MSEI , MTL_LOT_NUMBERS MLN , WMS_TRX_DETAILS_TMP_V MPTDTV , ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , X.LOT_NUMBER LOT_NUMBER , X.LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , X.COST_GROUP_ID COST_GROUP_ID , NULL SERIAL_NUMBER , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , X.GRADE_CODE GRADE_CODE , X.RESERVABLE_TYPE RESERVABLE_TYPE , NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) UOM_CODE , WMS_RULE_PVT.GETCONVERSIONRATE( NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) , X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID) CONVERSION_RATE , NULL LOCATOR_INVENTORY_ITEM_ID , NULL EMPTY_FLAG , NULL LOCATION_CURRENT_UNITS FROM ( SELECT X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , X.LOT_NUMBER , LOT.EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE , X.LOCATOR_ID , X.COST_GROUP_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , LOT.GRADE_CODE GRADE_CODE , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID FROM (SELECT MOQ.ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID , MOQ.REVISION , MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE , MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID , MIN(NVL(MOQ.ORIG_DATE_RECEIVED, MOQ.DATE_RECEIVED)) DATE_RECEIVED , SUM(MOQ.PRIMARY_TRANSACTION_QUANTITY) PRIMARY_QUANTITY , SUM(MOQ.SECONDARY_TRANSACTION_QUANTITY) SECONDARY_QUANTITY , MOQ.LPN_ID LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) PROJECT_ID , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) TASK_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ, MTL_ITEM_LOCATIONS MILS WHERE MOQ.ORGANIZATION_ID = :B2 AND MOQ.INVENTORY_ITEM_ID = :B1 AND MOQ.ORGANIZATION_ID = MILS.ORGANIZATION_ID (+) AND MOQ.SUBINVENTORY_CODE = MILS.SUBINVENTORY_CODE (+) AND MOQ.LOCATOR_ID = MILS.INVENTORY_LOCATION_ID (+) GROUP BY MOQ.ORGANIZATION_ID, MOQ.INVENTORY_ITEM_ID , MOQ.REVISION, MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE, MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID, MOQ.LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_LOT_NUMBERS LOT WHERE X.PRIMARY_QUANTITY > 0 AND X.ORGANIZATION_ID = SUB.ORGANIZATION_ID AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME AND X.ORGANIZATION_ID = LOT.ORGANIZATION_ID (+) AND X.INVENTORY_ITEM_ID = LOT.INVENTORY_ITEM_I D (+) AND X.LOT_NUMBER = LOT.LOT_NUMBER (+) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_ITEM_LOCATIONS LOC WHERE X.ORGANIZATION_ID = LOC.ORGANIZATION_ID (+) AND X.LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+) AND SUB.ORGANIZATION_ID = X.ORGANIZATION_ID AND SUB.SECONDARY_INVENTORY_NAME = X.SUBINVENTORY_CODE ) BASE WHERE BASE.ORGANIZATION_ID = :B2 AND BASE.INVENTORY_ITEM_ID = :B1 AND DECODE(:B11 , '-9999', 'a', BASE.SUBINVENTORY_CODE) = DECODE(:B11 , '-9999', 'a', :B11 ) AND DECODE(:B11 , '-9999', BASE.RESERVABLE_TYPE, 1) = 1 AND DECODE(:B10 , -9999, 1, BASE.LOCATOR_ID) = DECODE(:B10 , -9999, 1, :B10 ) AND DECODE(:B9 , '-99', 'a', BASE.REVISION) = DECODE(:B9 , '-99', 'a', :B9 ) AND DECODE(:B8 , '-9999', 'a', BASE.LOT_NUMBER) = DECODE(:B8 , '-9999', 'a', :B8 ) AND DECODE(:B7 , -9999, 1, BASE.LPN_ID) = DECODE(:B7 , -9999, 1, :B7 ) AND DECODE(:B6 , -9999, 1, BASE.COST_GROUP_ID) = DECODE(:B6 , -9999, 1, :B6 ) AND (DECODE(:B5 , -9999, -1, BASE.PROJECT_ID) = DECODE(:B5 , -9999, -1, :B5 ) OR ( :B5 = -7777 AND BASE.PROJECT_ID IS NULL)) AND (:B5 = -9999 OR NVL(BASE.TASK_ID, -9999) = :B4 OR (:B4 = -7777 AND BASE.TASK_ID IS NULL)) AND MPTDTV.PP_TRANSACTION_TEMP_ID = :B3 AND MLN.ORGANIZATION_ID (+) = BASE.ORGANIZATION_ID AND MLN.INVENTORY_ITEM_ID (+) = BASE.INVENTORY_ITEM_ID AND MLN.LOT_NUMBER (+) = BASE.LOT_NUMBER AND MSEI.ORGANIZATION_ID = BASE.ORGANIZATION_ID AND MSEI.SECONDARY_INVENTORY_NAME = BASE.SUBINVENTORY_CODE AND OOL.LINE_ID = WMS_PARAMETE R_PVT.GETSOHEADERLINEID(MPTDTV.LINE_ID, MPTDTV.TRANSACTION_SOURCE_TYPE_ID, MPTDTV.REFERENCE, MPTDTV.REFERENCE_ID, 'N', 'Y' ) AND ( (( OOL.PREFERRED_GRADE = MLN.GRADE_CODE AND OOL.PREFERRED_GRADE IS NOT NULL ) OR OOL.PREFERRED_GRADE IS NULL ) ) GROUP BY BASE.ORGANIZATION_ID , BASE.INVENTORY_ITEM_ID , BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.PROJECT_ID , BASE.TASK_ID , BASE.UOM_CODE , BASE.GRADE_CODE , MSEI.PICKING_ORDER, BASE.CONVERSION_RATE , MSEI.PICKING_ORDER ORDER BY MSEI.PICKING_ORDER ASC , BASE.CONVERSION_RATE DESC
7ptvbaycjtbg4	BEGIN arp_run.revenue_recognition(:errbuf, :rc, :A0, :A1, :A2); END;
8zfgv4ck11dw9	BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END;
9qgtwh66xg6nz	update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
9wdrypwkpf607	begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a40f9h91scg23	select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and CODE_COMBINATION_ID = :FND_BIND2
assndb4wqnd6r	BEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END;
b73h3md2wvs09	SELECT C.INSTANCE_ID FROM WF_PROCESS_ACTIVITIES P, WF_PROCESS_ACTIVITIES C, WF_ACTIVITIES A WHERE P.INSTANCE_ID = :B3 AND P.ACTIVITY_ITEM_TYPE = C.PROCESS_ITEM_TYPE AND P.ACTIVITY_NAME = C.PROCESS_NAME AND C.PROCESS_VERSION = A.VERSION AND A.NAME = C.PROCESS_NAME AND A.ITEM_TYPE = C.PROCESS_ITEM_TYPE AND :B2 >= A.BEGIN_DATE AND :B2 < NVL(A.END_DATE, :B2 +1) AND C.START_END = :B1 AND NOT EXISTS ( SELECT NULL FROM WF_ACTIVITY_TRANSITIONS WAT WHERE WAT.TO_PROCESS_ACTIVITY = C.INSTANCE_ID)
bf7uwg5pa3pj6	begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bfbyqwbr4vwms	begin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end;
bsa0wjtftg3uw	select file# from file$ where ts#=:1
bsuw7pmwrufpy	SELECT reservation_id , primary_reservation_quantity - NVL(detailed_quantity, 0) , NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- INVCONV FROM mtl_reservations WHERE demand_source_header_id = :demand_source_header_id AND demand_source_line_id = :demand_source_line_id AND demand_source_type_id = :demand_source_type_id AND supply_source_type_id = :supply_source_type_id AND (:demand_source_delivery = :l_miss_num OR :demand_source_delivery IS NULL AND demand_source_delivery IS NULL OR :demand_source_delivery = demand_source_delivery) AND (:organization_id = :l_miss_num OR :organization_id IS NULL AND organization_id IS NULL OR :organization_id = organization_id) AND (:inventory_item_id = :l_miss_num OR :inventory_item_id IS NULL AND inventory_item_id IS NULL OR :inventory_item_id = inventory_item_id) AND (:subinventory_code = :l_miss_char OR :subinventory_code IS NULL AND subinventory_code IS NULL OR :subinventory_code = subinventory_code) AND (:locator_id = :l_miss_num OR :locator_id IS NULL AND locator_id IS NULL OR :locator_id = locator_id) AND (:lot_number = :l_miss_char OR :lot_number IS NULL AND lot_number IS NULL OR :lot_number = lot_number) AND (:revision = :l_miss_char OR :revision IS NULL AND revision IS NULL OR :revision = revision) AND (:lpn_id = :l_miss_num OR ((lpn_id IS NULL) OR (:lpn_id = lpn_id))) AND (:demand_source_name = :l_miss_char OR :demand_source_name IS NULL AND demand_source_name IS NULL OR :demand_source_name = demand_source_name) AND (primary_reservation_quantity - NVL(detailed_quantity, 0)) > 0 ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE
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
cdjud36xbtuu5	SELECT WIAS.PROCESS_ACTIVITY, WIAS.ACTIVITY_STATUS FROM WF_PROCESS_ACTIVITIES PA, WF_PROCESS_ACTIVITIES PA1, WF_ACTIVITIES A1, WF_ITEM_ACTIVITY_STATUSES WIAS WHERE PA.INSTANCE_ID = :B4 AND PA.ACTIVITY_ITEM_TYPE = PA1.PROCESS_ITEM_TYPE AND PA.ACTIVITY_NAME = PA1.PROCESS_NAME AND PA1.PROCESS_VERSION = A1.VERSION AND PA1.PROCESS_ITEM_TYPE = A1.ITEM_TYPE AND PA1.PROCESS_NAME = A1.NAME AND :B3 >= A1.BEGIN_DATE AND :B3 < NVL(A1.END_DATE, :B3 +1) AND PA1.INSTANCE_ID = WIAS.PROCESS_ACTIVITY AND WIAS.ITEM_TYPE = :B2 AND WIAS.ITEM_KEY = :B1 AND WIAS.ACTIVITY_STATUS <> 'COMPLETE'
cw171rvngr1w9	begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end;
dcvv68fju01g4	begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
fb13x9qx0ftks	begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fvcbstf9s6a5r	begin WF_STANDARD.WAITFORFLOW (:v1, :v2, :v3, :v4, :v5); end;
g2qs4xk48vcwy	select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and (SEGMENT1 = :FND_BIND2) and (SEGMENT2 = :FND_BIND3) and (SEGMENT3 = :FND_BIND4) and (SEGMENT4 = :FND_BIND5) and (SEGMENT5 = :FND_BIND6)
g8102j8yynbwz	begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gdnwgx9fcxggr	begin OE_SHIPPING_WF.START_SHIPPING (:v1, :v2, :v3, :v4, :v5); end;
ghmx8n7wgqvfr	begin WF_STANDARD.DEFER (:v1, :v2, :v3, :v4, :v5); end;
gksvm8wmzk8w0	begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;
gnhmcahkmrnzs	INSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 )
gnng1rmpjxzsx	begin OE_CLOSE_WF.CLOSE_LINE (:v1, :v2, :v3, :v4, :v5); end;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Instance Activity Stats
• Instance Activity Stats - Absolute Values
• Instance Activity Stats - Thread Activity

Instance Activity Stats

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

• Statistics identified by '(derived)' come from sources other than SYSSTAT

Back to Instance Activity Statistics
Back to Top

IO Stats

• Tablespace IO Stats
• File IO Stats

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

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

Back to Top

Advisory Statistics

• Instance Recovery Stats
• Buffer Pool Advisory
• PGA Aggr Summary
• PGA Aggr Target Stats
• PGA Aggr Target Histogram
• PGA Memory Advisory
• Shared Pool Advisory
• SGA Target Advisory
• Streams Pool Advisory
• Java Pool Advisory

Instance Recovery Stats

• B: Begin snapshot, E: End snapshot

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

• Only rows with estimated physical reads >0 are displayed
• ordered by Block Size, Buffers For Estimate

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

• B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
• Auto PGA Target - actual workarea memory target
• W/A PGA Used - amount of memory used for all Workareas (manual + auto)
• %PGA W/A Mem - percentage of PGA memory allocated to workareas
• %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
• %Man W/A Mem - percentage of workarea memory under manual control

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations