TKPROF: Release 10.2.0.4.0 - Production on Tue Apr 23 10:59:38 2013 Copyright (c) 1982, 2007, Oracle. All rights reserved. Trace file: pobom2_ora_23794.trc Sort options: prsela fchela exeela ******************************************************************************** count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ******************************************************************************** BEGIN tidyUp8DayMessagePackage.processTidyUp8DayForPlant(:1); END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 2295.94 2702.94 880892 230072037 35338030 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 2295.95 2702.94 880892 230072037 35338030 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 77 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 log file sync 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** INSERT INTO SCS_HISTORY_ORDER_CMDTY_PART ( ORDER_NUMBER, ORDER_CMDTY_ID, PART_NUMBER, ORD_PART_QTY, PLANT_CODE) SELECT DISTINCT OBOM_ORDER_COMMODITY_PART.ORDER_NUMBER, OBOM_ORDER_COMMODITY_PART.ORDER_CMDTY_ID, OBOM_ORDER_COMMODITY_PART.PART_NUMBER, OBOM_ORDER_COMMODITY_PART.ORD_PART_QTY, OBOM_ORDER_COMMODITY_PART.PLANT_CODE FROM OBOM_ORDER_COMMODITY_PART INNER JOIN OBOM_ORDER ON OBOM_ORDER_COMMODITY_PART.ORDER_NUMBER = OBOM_ORDER.ORDER_NUMBER INNER JOIN MODEL ON OBOM_ORDER.MODEL_CODE = MODEL.MODEL_CODE WHERE MODEL.FK_PLANT_CODE= :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 170.26 201.88 280919 155199 20319733 6619203 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 170.26 201.88 280919 155199 20319733 6619203 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file scattered read 2862 0.00 0.74 direct path write temp 2438 0.00 0.00 db file sequential read 199217 6.48 31.60 direct path read temp 2438 0.00 0.00 log file switch completion 23 0.12 1.35 log buffer space 8 0.48 1.40 ******************************************************************************** insert /*+ RELATIONAL(OBOM_ORDER_COMMODITY_PART) PARALLEL(OBOM_ORDER_COMMODITY_PART,1) APPEND */ into "SCS_OWNER"."OBOM_ORDER_COMMODITY_PART" partition ("PLANT_CODE_S") select /*+ RELATIONAL(OBOM_ORDER_COMMODITY_PART) PARALLEL(OBOM_ORDER_COMMODITY_PART,1) */ * from "SCS_OWNER"."OBOM_ORDER_COMMODITY_PART" partition ("PLANT_CODE_S") delete global indexes call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 57.61 187.28 240462 49673 367539 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 57.62 187.29 240462 49673 367539 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 LOAD AS SELECT (cr=49750 pr=240462 pw=93686 time=187290056 us) 6619203 PARTITION LIST SINGLE PARTITION: KEY KEY (cr=45197 pr=45173 pw=0 time=6619260 us) 6619203 TABLE ACCESS FULL OBOM_ORDER_COMMODITY_PART PARTITION: 4 4 (cr=45197 pr=45173 pw=0 time=49 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 101592 5.47 122.02 control file sequential read 10 0.00 0.00 db file scattered read 2848 0.00 0.71 direct path read temp 93344 0.00 0.17 log file switch completion 2 0.13 0.19 ******************************************************************************** INSERT INTO PART_DETAILS ( SELECT ORD_DIFF_PARTS_WITHOUT_DETAILS.PART_NUM, PART.PART_DESC FROM SCS_OWNER.ORD_DIFF_PARTS_WITHOUT_DETAILS INNER JOIN OBOMSO.PART ON ORD_DIFF_PARTS_WITHOUT_DETAILS.PART_NUM = PART.PART_NUM WHERE ORD_DIFF_PARTS_WITHOUT_DETAILS.PLANT_CODE = :B1 AND OBOMSO.PART.PART_PLANT = :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 2.29 112.26 26235 48624 12 25 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 2.29 112.27 26235 48624 12 25 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 26235 0.58 110.42 free buffer waits 67 0.01 0.69 ******************************************************************************** insert /*+ RELATIONAL(SCS_HISTORY_ORDER_CMDTY_PART) PARALLEL(SCS_HISTORY_ORDER_CMDTY_PART,1) APPEND */ into "SCS_OWNER"."SCS_HISTORY_ORDER_CMDTY_PART" partition ("PLANT_CODE_S") select /*+ RELATIONAL(SCS_HISTORY_ORDER_CMDTY_PART) PARALLEL(SCS_HISTORY_ORDER_CMDTY_PART,1) */ * from "SCS_OWNER"."SCS_HISTORY_ORDER_CMDTY_PART" partition ("PLANT_CODE_S") delete global indexes call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 54.22 98.54 209240 53007 281003 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 54.23 98.55 209240 53007 281003 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 LOAD AS SELECT (cr=53832 pr=209240 pw=93648 time=98564355 us) 6617850 PARTITION LIST SINGLE PARTITION: KEY KEY (cr=34868 pr=34850 pw=0 time=13235773 us) 6617850 TABLE ACCESS FULL SCS_HISTORY_ORDER_CMDTY_PART PARTITION: 4 4 (cr=34868 pr=34850 pw=0 time=6617913 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ control file sequential read 10 0.00 0.00 db file scattered read 2201 0.00 0.70 db file sequential read 80584 4.34 38.46 direct path read temp 93523 0.00 0.16 log buffer space 3 0.28 0.33 log file switch completion 3 0.21 0.31 ******************************************************************************** UPDATE PART_DETAILS SET PART_DETAILS.PART_DESC = ( SELECT PART.PART_DESC FROM ORD_DIFF_PARTS_WITH_DETAILS INNER JOIN PART ON ORD_DIFF_PARTS_WITH_DETAILS.PART_NUM = PART.PART_NUM AND ORD_DIFF_PARTS_WITH_DETAILS.PLANT_CODE = PART.PART_PLANT AND ORD_DIFF_PARTS_WITH_DETAILS.PLANT_CODE = :B1 WHERE PART_DETAILS.PART_NUMBER = ORD_DIFF_PARTS_WITH_DETAILS.PART_NUM) WHERE EXISTS ( SELECT PART.PART_DESC FROM ORD_DIFF_PARTS_WITH_DETAILS INNER JOIN PART ON ORD_DIFF_PARTS_WITH_DETAILS.PART_NUM = PART.PART_NUM AND ORD_DIFF_PARTS_WITH_DETAILS.PLANT_CODE = PART.PART_PLANT AND ORD_DIFF_PARTS_WITH_DETAILS.PLANT_CODE = :B1 WHERE PART_DETAILS.PART_NUMBER = ORD_DIFF_PARTS_WITH_DETAILS.PART_NUM) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 1.69 69.06 12863 30171 1513 719 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 1.69 69.06 12863 30171 1513 719 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 10047 0.57 67.35 db file scattered read 284 0.04 0.52 ******************************************************************************** DELETE OBOM_ORDER_COMMODITY /*+ index( obom_order_commodity obom_order_commodity_pk)*/ WHERE OBOM_ORDER_COMMODITY.ORDER_NUMBER IN ( SELECT OBOM_ORDER.ORDER_NUMBER FROM OBOM_ORDER INNER JOIN MODEL ON OBOM_ORDER.MODEL_CODE = MODEL.MODEL_CODE WHERE MODEL.FK_PLANT_CODE = :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 43.22 67.36 36955 5826 4287835 1047175 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 43.22 67.36 36955 5826 4287835 1047175 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file scattered read 332 0.00 0.07 db file sequential read 32212 4.44 24.25 log file switch completion 5 0.42 0.96 log buffer space 4 0.23 0.53 ******************************************************************************** DELETE SCS_HISTORY_ORDER_COMMODITY /*+ index( scs_history_order_commodity scs_history_order_commodity_pk)*/ WHERE SCS_HISTORY_ORDER_COMMODITY.ORDER_NUMBER IN ( SELECT SCS_HISTORY_ORDER.ORDER_NUMBER FROM SCS_HISTORY_ORDER INNER JOIN MODEL ON SCS_HISTORY_ORDER.MODEL_CODE = MODEL.MODEL_CODE WHERE MODEL.FK_PLANT_CODE = :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 40.14 52.90 35414 4629 4282482 1046348 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 40.14 52.90 35414 4629 4282482 1046348 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE SCS_HISTORY_ORDER_COMMODITY (cr=4819 pr=35416 pw=0 time=52928214 us) 1046348 HASH JOIN RIGHT SEMI (cr=4481 pr=4074 pw=0 time=3184603 us) 14520 VIEW VW_NSO_1 (cr=392 pr=0 pw=0 time=30241 us) 14520 HASH JOIN (cr=392 pr=0 pw=0 time=15718 us) 6 TABLE ACCESS FULL MODEL (cr=7 pr=0 pw=0 time=64 us) 31910 TABLE ACCESS FULL SCS_HISTORY_ORDER (cr=385 pr=0 pw=0 time=85 us) 1280986 INDEX FULL SCAN SCS_HISTORY_ORDER_COMMODITY_PK (cr=4089 pr=4074 pw=0 time=2583413 us)(object id 32706) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 35414 0.72 12.06 log buffer space 8 0.67 2.06 log file switch completion 4 0.20 0.41 ******************************************************************************** INSERT INTO SCS_HISTORY_ORDER_COMMODITY ( ORDER_NUMBER, COMMODITY_ID ) SELECT OBOM_ORDER_COMMODITY.ORDER_NUMBER, OBOM_ORDER_COMMODITY.COMMODITY_ID FROM OBOM_ORDER_COMMODITY INNER JOIN OBOM_ORDER ON OBOM_ORDER_COMMODITY.ORDER_NUMBER = OBOM_ORDER.ORDER_NUMBER INNER JOIN MODEL ON OBOM_ORDER.MODEL_CODE = MODEL.MODEL_CODE WHERE MODEL.FK_PLANT_CODE= :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 28.57 29.02 14423 23470 5414015 1047175 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 28.57 29.02 14423 23470 5414015 1047175 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file scattered read 139 0.00 0.04 db file sequential read 12575 0.33 1.05 log file switch completion 2 0.14 0.18 log buffer space 1 0.13 0.13 ******************************************************************************** DELETE ORDER_DIFFERENCE_COMMODITY WHERE ORDER_DIFFERENCE_COMMODITY.PLANT_CODE = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 15.97 20.66 5641 2140 197393 31905 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 15.97 20.66 5641 2140 197393 31905 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE ORDER_DIFFERENCE_COMMODITY (cr=216167991 pr=15949 pw=0 time=1700737573 us) 31905 TABLE ACCESS FULL ORDER_DIFFERENCE_COMMODITY (cr=2140 pr=2121 pw=0 time=389555 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file scattered read 147 0.01 0.06 db file sequential read 3532 0.42 2.65 latch: library cache lock 1 0.04 0.04 log file switch completion 9 0.16 0.72 log buffer space 4 0.83 1.14 latch: row cache objects 1 0.00 0.00 ******************************************************************************** SELECT /* DS_SVC */ /*+ cursor_sharing_exact dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) */ SUM(C1) FROM (SELECT /*+ qb_name("innerQuery") NO_INDEX_FFS( "ORDER_DIFFERENCE_CMDTY_PART") */ 1 AS C1 FROM SCS_OWNER."ORDER_DIFFERENCE_CMDTY_PART" "ORDER_DIFFERENCE_CMDTY_PART") innerQuery call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.21 11.75 2157 2219 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.21 11.76 2157 2219 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT AGGREGATE (cr=0 pr=0 pw=0 time=26 us) 67 INDEX FULL SCAN SYS_C003496 (cr=2212 pr=2150 pw=0 time=23424990 us)(object id 34928) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2157 0.28 11.67 ******************************************************************************** alter table OBOM_ORDER_COMMODITY_PART truncate partition PLANT_CODE_S update global indexes call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.03 0.03 5 4 1 0 Execute 1 0.13 8.58 575 0 1699 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.16 8.62 580 4 1700 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 575 0.96 6.66 reliable message 1 0.00 0.00 enq: RO - fast object reuse 1 0.50 0.50 local write wait 283 0.01 1.27 ******************************************************************************** DELETE FROM SCS_HISTORY_ORDER WHERE SCS_HISTORY_ORDER.MODEL_CODE IN ( SELECT MODEL.MODEL_CODE FROM MODEL WHERE MODEL.FK_PLANT_CODE = :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 3.20 3.26 463 381 74371 14520 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 3.20 3.26 463 381 74371 14520 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE SCS_HISTORY_ORDER (cr=7697860 pr=766 pw=0 time=102200484 us) 14520 HASH JOIN (cr=381 pr=0 pw=0 time=102874 us) 6 TABLE ACCESS FULL MODEL (cr=7 pr=0 pw=0 time=87 us) 31910 TABLE ACCESS FULL SCS_HISTORY_ORDER (cr=374 pr=0 pw=0 time=63978 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 463 0.11 0.18 ******************************************************************************** DELETE FROM OBOM_ORDER WHERE OBOM_ORDER.MODEL_CODE IN ( SELECT MODEL.MODEL_CODE FROM MODEL WHERE MODEL.FK_PLANT_CODE = :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 2.61 2.70 484 381 74434 14523 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 2.61 2.70 484 381 74434 14523 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE OBOM_ORDER (cr=5821414 pr=991 pw=0 time=55597446 us) 14523 HASH JOIN (cr=381 pr=0 pw=0 time=117084 us) 6 TABLE ACCESS FULL MODEL (cr=7 pr=0 pw=0 time=40 us) 14523 TABLE ACCESS FULL OBOM_ORDER (cr=374 pr=0 pw=0 time=43741 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 484 0.02 0.13 ******************************************************************************** alter table SCS_HISTORY_ORDER_CMDTY_PART truncate partition PLANT_CODE_S update global indexes call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 5 4 0 0 Execute 1 0.10 2.36 502 0 1503 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.11 2.36 507 4 1503 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 502 0.06 1.17 reliable message 1 0.00 0.00 enq: RO - fast object reuse 1 0.14 0.14 local write wait 243 0.03 0.88 ******************************************************************************** insert /*+ RELATIONAL(ORDER_DIFFERENCE_CMDTY_PART) PARALLEL(ORDER_DIFFERENCE_CMDTY_PART,1) APPEND */ into "SCS_OWNER"."ORDER_DIFFERENCE_CMDTY_PART" partition ("PLANT_CODE_S") select /*+ RELATIONAL(ORDER_DIFFERENCE_CMDTY_PART) PARALLEL(ORDER_DIFFERENCE_CMDTY_PART,1) */ * from "SCS_OWNER"."ORDER_DIFFERENCE_CMDTY_PART" partition ("PLANT_CODE_S") delete global indexes call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.07 0.70 208 23 3227 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.07 0.71 208 23 3227 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 LOAD AS SELECT (cr=26 pr=208 pw=0 time=706426 us) 3419 PARTITION LIST SINGLE PARTITION: KEY KEY (cr=23 pr=17 pw=0 time=6878 us) 3419 TABLE ACCESS FULL ORDER_DIFFERENCE_CMDTY_PART PARTITION: 4 4 (cr=23 pr=17 pw=0 time=3451 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ control file sequential read 10 0.00 0.00 db file scattered read 3 0.00 0.00 db file sequential read 191 0.03 0.64 ******************************************************************************** INSERT INTO process_event (event_seq_no, event_code, process_name, date_time, process_id, plant_code, event_text) VALUES (process_event_seq.nextval, :1, :2, :3, :4, :5, :6) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 31 0.01 0.67 19 47 243 31 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 31 0.01 0.67 19 47 243 31 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 77 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 31 0.00 0.00 SQL*Net message from client 31 0.00 0.03 db file sequential read 17 0.05 0.14 ******************************************************************************** INSERT INTO SCS_HISTORY_ORDER ( ORDER_NUMBER, ORD_OFFLINE_DATE, ORD_STATUS_ID, ORDER_PROCESSED, MODEL_CODE, ORD_LAUNCH_SEQ, ORD_BLEND_SEQ, BLEND_DATE, ACTUAL_OFFLINE_DATE, K_SPEC_BATCH_NO) SELECT OBOM_ORDER.ORDER_NUMBER, OBOM_ORDER.ORD_OFFLINE_DATE, OBOM_ORDER.ORD_STATUS_ID, 'N', OBOM_ORDER.MODEL_CODE, OBOM_ORDER.ORD_LAUNCH_SEQ, OBOM_ORDER.ORD_BLEND_SEQ, OBOM_ORDER.BLEND_DATE, OBOM_ORDER.ACTUAL_OFFLINE_DATE, OBOM_ORDER.K_SPEC_BATCH_NO FROM OBOM_ORDER INNER JOIN MODEL ON OBOM_ORDER.MODEL_CODE = MODEL.MODEL_CODE WHERE MODEL.FK_PLANT_CODE=:B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.30 0.36 173 633 30736 14523 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.30 0.36 173 633 30736 14523 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 173 0.04 0.05 ******************************************************************************** SELECT order_header_archive.order_number, order_header_archive.model_code, order_header_archive.tls_number, order_header_archive.plant_code, order_header_archive.build_date, order_header_archive.order_status_id, order_header_archive.blend_date, order_header_archive.short_tls, order_header_archive.blend_number, ord.ord_launch_seq, ord.ord_tls_date, ord.ord_off_line_date, ord.ord_stat_id FROM ord INNER JOIN order_header_archive ON order_header_archive.order_number = ord.ord_num WHERE order_header_archive.plant_code = :1 AND order_header_archive.order_status_id < 6 AND ord.ord_stat_id <> order_header_archive.order_status_id AND ord.ord_plant = :2 ORDER BY order_header_archive.order_number call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 4 0.27 0.26 669 7076 0 13 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.28 0.27 669 7076 0 13 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 77 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 4 0.00 0.00 db file sequential read 46 0.00 0.00 db file scattered read 69 0.00 0.01 SQL*Net message from client 4 0.00 0.00 ******************************************************************************** SELECT event_seq_no, event_code, event_type, date_time, supplier_id, plant_code, event_text FROM supplier_event WHERE event_seq_no IN ( SELECT MAX(event_seq_no) FROM supplier_event WHERE supplier_id = :1 AND plant_code = :2 AND event_type = :3 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 23 0.00 0.00 0 0 0 0 Execute 23 0.03 0.24 183 4268 0 0 Fetch 23 0.00 0.00 0 69 0 23 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 69 0.03 0.24 183 4337 0 23 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 77 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID SUPPLIER_EVENT (cr=187 pr=0 pw=0 time=2019 us) 1 INDEX UNIQUE SCAN SYS_C002785 (cr=186 pr=0 pw=0 time=2007 us)(object id 32678) 1 SORT AGGREGATE (cr=184 pr=0 pw=0 time=1992 us) 78 TABLE ACCESS FULL SUPPLIER_EVENT (cr=184 pr=0 pw=0 time=1808 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 46 0.00 0.00 SQL*Net message from client 46 0.01 0.07 db file scattered read 21 0.05 0.19 ******************************************************************************** SELECT /* DS_SVC */ /*+ cursor_sharing_exact dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) */ SUM(C1) FROM (SELECT /*+ qb_name("innerQuery") NO_INDEX_FFS( "ORDER_DIFFERENCE_COMMODITY") */ 1 AS C1 FROM SCS_OWNER."ORDER_DIFFERENCE_COMMODITY" SAMPLE BLOCK(37.4883, 8) SEED(1) "ORDER_DIFFERENCE_COMMODITY") innerQuery call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.15 0.22 2738 3347 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.15 0.22 2738 3347 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=3347 pr=2738 pw=0 time=220244 us) 12019 INDEX FULL SCAN SYS_C002813 (cr=3347 pr=2738 pw=0 time=120222 us)(object id 32694) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2738 0.01 0.11 ******************************************************************************** SELECT COUNT(*) FROM ALL_TABLES WHERE OWNER = 'MDSYS' AND TABLE_NAME = 'RDF_MODEL$' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.17 6 12 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.17 6 12 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 32 (recursive depth: 3) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 6 0.16 0.17 ******************************************************************************** INSERT INTO supplier_event (event_seq_no, event_code, event_type, date_time, supplier_id, plant_code, event_text) VALUES (supplier_event_seq.nextval, :1, :2, :3, :4, :5, :6) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 23 0.02 0.14 19 46 161 23 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 24 0.02 0.14 19 46 161 23 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 77 Rows Row Source Operation ------- --------------------------------------------------- 23 SEQUENCE SUPPLIER_EVENT_SEQ (cr=3 pr=1 pw=0 time=3961 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 16 0.01 0.10 SQL*Net message to client 23 0.00 0.00 SQL*Net message from client 23 0.00 0.02 log file sync 1 0.00 0.00 ******************************************************************************** alter table ORDER_DIFFERENCE_CMDTY_PART truncate partition PLANT_CODE_S update global indexes call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 1 4 1 0 Execute 1 0.01 0.08 10 0 75 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.09 11 4 76 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 10 0.00 0.00 reliable message 1 0.00 0.00 enq: RO - fast object reuse 1 0.06 0.06 local write wait 4 0.00 0.01 ******************************************************************************** SELECT /*+ ALL_ROWS */ COUNT(*) FROM ALL_POLICIES V WHERE V.OBJECT_OWNER = :B3 AND V.OBJECT_NAME = :B2 AND (POLICY_NAME LIKE '%xdbrls%' OR POLICY_NAME LIKE '%$xd_%') AND V.FUNCTION = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.06 23 510 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13 0.02 0.07 23 510 0 6 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 3) Rows Row Source Operation ------- --------------------------------------------------- 6 SORT AGGREGATE (cr=510 pr=23 pw=0 time=61590 us) 0 VIEW ALL_POLICIES (cr=510 pr=23 pw=0 time=61480 us) 0 UNION-ALL (cr=510 pr=23 pw=0 time=61463 us) 0 FILTER (cr=234 pr=15 pw=0 time=54472 us) 0 HASH JOIN (cr=234 pr=15 pw=0 time=54455 us) 0 MERGE JOIN CARTESIAN (cr=234 pr=15 pw=0 time=53362 us) 0 NESTED LOOPS OUTER (cr=234 pr=15 pw=0 time=53332 us) 0 NESTED LOOPS OUTER (cr=234 pr=15 pw=0 time=53313 us) 0 NESTED LOOPS OUTER (cr=234 pr=15 pw=0 time=53290 us) 0 NESTED LOOPS (cr=234 pr=15 pw=0 time=53271 us) 48 NESTED LOOPS (cr=222 pr=12 pw=0 time=44811 us) 6 NESTED LOOPS OUTER (cr=174 pr=12 pw=0 time=44388 us) 6 NESTED LOOPS (cr=162 pr=9 pw=0 time=1994 us) 6 NESTED LOOPS (cr=144 pr=8 pw=0 time=1789 us) 48 NESTED LOOPS (cr=72 pr=6 pw=0 time=753 us) 6 NESTED LOOPS (cr=24 pr=0 pw=0 time=228 us) 6 TABLE ACCESS BY INDEX ROWID USER$ (cr=12 pr=0 pw=0 time=106 us) 6 INDEX UNIQUE SCAN I_USER1 (cr=6 pr=0 pw=0 time=56 us)(object id 44) 6 TABLE ACCESS BY INDEX ROWID USER$ (cr=12 pr=0 pw=0 time=90 us) 6 INDEX UNIQUE SCAN I_USER1 (cr=6 pr=0 pw=0 time=55 us)(object id 44) 48 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=48 pr=6 pw=0 time=492 us) 48 INDEX RANGE SCAN I_OBJ2 (cr=12 pr=0 pw=0 time=108 us)(object id 37) 6 TABLE ACCESS CLUSTER TAB$ (cr=72 pr=2 pw=0 time=645 us) 6 INDEX UNIQUE SCAN I_OBJ# (cr=60 pr=2 pw=0 time=400 us)(object id 3) 6 TABLE ACCESS CLUSTER TS$ (cr=18 pr=1 pw=0 time=167 us) 6 INDEX UNIQUE SCAN I_TS# (cr=6 pr=0 pw=0 time=37 us)(object id 7) 0 TABLE ACCESS CLUSTER SEG$ (cr=12 pr=3 pw=0 time=42363 us) 0 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=12 pr=3 pw=0 time=42345 us)(object id 9) 48 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=48 pr=0 pw=0 time=495 us) 48 INDEX RANGE SCAN I_OBJ2 (cr=12 pr=0 pw=0 time=110 us)(object id 37) 0 TABLE ACCESS BY INDEX ROWID RLS$ (cr=12 pr=3 pw=0 time=8363 us) 0 INDEX RANGE SCAN I_RLS2 (cr=12 pr=3 pw=0 time=8226 us)(object id 426) 0 INDEX UNIQUE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us)(object id 36) 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us)(object id 36) 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us)(object id 11) 0 BUFFER SORT (cr=0 pr=0 pw=0 time=0 us) 0 FIXED TABLE FULL X$KSPPI (cr=0 pr=0 pw=0 time=0 us) 0 FIXED TABLE FULL X$KSPPCV (cr=0 pr=0 pw=0 time=0 us) 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=0 pr=0 pw=0 time=0 us)(object id 108) 0 FIXED TABLE FULL X$KZSRO (cr=0 pr=0 pw=0 time=0 us) 0 FIXED TABLE FULL X$KZSPR (cr=0 pr=0 pw=0 time=0 us) 0 FILTER (cr=144 pr=8 pw=0 time=4776 us) 0 TABLE ACCESS BY INDEX ROWID RLS$ (cr=144 pr=8 pw=0 time=4749 us) 6 NESTED LOOPS (cr=144 pr=8 pw=0 time=4700 us) 0 NESTED LOOPS (cr=144 pr=8 pw=0 time=4678 us) 0 NESTED LOOPS (cr=144 pr=8 pw=0 time=4659 us) 48 NESTED LOOPS OUTER (cr=84 pr=3 pw=0 time=3474 us) 48 NESTED LOOPS (cr=72 pr=0 pw=0 time=555 us) 6 NESTED LOOPS (cr=24 pr=0 pw=0 time=199 us) 6 TABLE ACCESS BY INDEX ROWID USER$ (cr=12 pr=0 pw=0 time=99 us) 6 INDEX UNIQUE SCAN I_USER1 (cr=6 pr=0 pw=0 time=53 us)(object id 44) 6 TABLE ACCESS BY INDEX ROWID USER$ (cr=12 pr=0 pw=0 time=70 us) 6 INDEX UNIQUE SCAN I_USER1 (cr=6 pr=0 pw=0 time=39 us)(object id 44) 48 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=48 pr=0 pw=0 time=316 us) 48 INDEX RANGE SCAN I_OBJ2 (cr=12 pr=0 pw=0 time=70 us)(object id 37) 0 INDEX UNIQUE SCAN I_TYPED_VIEW1 (cr=12 pr=3 pw=0 time=2713 us)(object id 105) 0 INDEX UNIQUE SCAN I_VIEW1 (cr=60 pr=5 pw=0 time=1229 us)(object id 104) 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX RANGE SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us)(object id 37) 0 INDEX RANGE SCAN I_RLS2 (cr=0 pr=0 pw=0 time=0 us)(object id 426) 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=0 pr=0 pw=0 time=0 us)(object id 108) 0 FIXED TABLE FULL X$KZSRO (cr=0 pr=0 pw=0 time=0 us) 0 FIXED TABLE FULL X$KZSPR (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS BY INDEX ROWID RLS$ (cr=132 pr=0 pw=0 time=2066 us) 6 NESTED LOOPS (cr=132 pr=0 pw=0 time=2017 us) 0 NESTED LOOPS (cr=132 pr=0 pw=0 time=1994 us) 0 NESTED LOOPS (cr=132 pr=0 pw=0 time=1976 us) 6 TABLE ACCESS BY INDEX ROWID USER$ (cr=12 pr=0 pw=0 time=84 us) 6 INDEX UNIQUE SCAN I_USER1 (cr=6 pr=0 pw=0 time=44 us)(object id 44) 0 VIEW ALL_SYNONYMS (cr=120 pr=0 pw=0 time=1871 us) 0 SORT UNIQUE (cr=120 pr=0 pw=0 time=1853 us) 0 UNION-ALL (cr=120 pr=0 pw=0 time=1753 us) 0 FILTER (cr=60 pr=0 pw=0 time=444 us) 0 NESTED LOOPS (cr=60 pr=0 pw=0 time=425 us) 0 NESTED LOOPS (cr=60 pr=0 pw=0 time=412 us) 6 TABLE ACCESS BY INDEX ROWID USER$ (cr=12 pr=0 pw=0 time=106 us) 6 INDEX UNIQUE SCAN I_USER1 (cr=6 pr=0 pw=0 time=44 us)(object id 44) 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=48 pr=0 pw=0 time=262 us) 48 INDEX RANGE SCAN I_OBJ2 (cr=12 pr=0 pw=0 time=67 us)(object id 37) 0 TABLE ACCESS BY INDEX ROWID SYN$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_SYN1 (cr=0 pr=0 pw=0 time=0 us)(object id 106) 0 FILTER (cr=0 pr=0 pw=0 time=0 us) 0 FILTER (cr=0 pr=0 pw=0 time=0 us) 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS BY INDEX ROWID USER$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_USER1 (cr=0 pr=0 pw=0 time=0 us)(object id 44) 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX RANGE SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us)(object id 37) 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=0 pr=0 pw=0 time=0 us)(object id 108) 0 FIXED TABLE FULL X$KZSRO (cr=0 pr=0 pw=0 time=0 us) 0 FIXED TABLE FULL X$KZSPR (cr=0 pr=0 pw=0 time=0 us) 0 NESTED LOOPS (cr=60 pr=0 pw=0 time=1248 us) 0 HASH JOIN (cr=60 pr=0 pw=0 time=1230 us) 0 NESTED LOOPS (cr=60 pr=0 pw=0 time=355 us) 6 TABLE ACCESS BY INDEX ROWID USER$ (cr=12 pr=0 pw=0 time=83 us) 6 INDEX UNIQUE SCAN I_USER1 (cr=6 pr=0 pw=0 time=40 us)(object id 44) 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=48 pr=0 pw=0 time=247 us) 48 INDEX RANGE SCAN I_OBJ2 (cr=12 pr=0 pw=0 time=65 us)(object id 37) 0 VIEW _ALL_SYNONYMS_TREE (cr=0 pr=0 pw=0 time=0 us) 0 CONNECT BY WITH FILTERING (cr=0 pr=0 pw=0 time=0 us) 0 FILTER (cr=0 pr=0 pw=0 time=0 us) 0 COUNT (cr=0 pr=0 pw=0 time=0 us) 0 HASH JOIN (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS FULL USER$ (cr=0 pr=0 pw=0 time=0 us) 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 HASH JOIN (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS FULL SYN$ (cr=0 pr=0 pw=0 time=0 us) 0 HASH JOIN (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS FULL USER$ (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS FULL OBJ$ (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us)(object id 36) 0 FILTER (cr=0 pr=0 pw=0 time=0 us) 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS BY INDEX ROWID SYN$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_SYN1 (cr=0 pr=0 pw=0 time=0 us)(object id 106) 0 TABLE ACCESS BY INDEX ROWID USER$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_USER1 (cr=0 pr=0 pw=0 time=0 us)(object id 44) 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX RANGE SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us)(object id 37) 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=0 pr=0 pw=0 time=0 us)(object id 108) 0 FIXED TABLE FULL X$KZSRO (cr=0 pr=0 pw=0 time=0 us) 0 HASH JOIN (cr=0 pr=0 pw=0 time=0 us) 0 CONNECT BY PUMP (cr=0 pr=0 pw=0 time=0 us) 0 COUNT (cr=0 pr=0 pw=0 time=0 us) 0 HASH JOIN (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS FULL USER$ (cr=0 pr=0 pw=0 time=0 us) 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 HASH JOIN (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS FULL SYN$ (cr=0 pr=0 pw=0 time=0 us) 0 HASH JOIN (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS FULL USER$ (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS FULL OBJ$ (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us)(object id 36) 0 TABLE ACCESS BY INDEX ROWID SYN$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_SYN1 (cr=0 pr=0 pw=0 time=0 us)(object id 106) 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX RANGE SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us)(object id 37) 0 INDEX RANGE SCAN I_RLS2 (cr=0 pr=0 pw=0 time=0 us)(object id 426) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 23 0.04 0.05 ******************************************************************************** INSERT INTO order_event_archive (order_number,event,event_details,event_date) VALUES (:1,:2,:3,:4) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 13 0.00 0.04 11 5 88 13 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.00 0.04 11 5 88 13 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 77 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 11 0.02 0.04 SQL*Net message to client 13 0.00 0.00 SQL*Net message from client 13 0.00 0.01 ******************************************************************************** SELECT last_version FROM obom_data_version WHERE plant_code = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.03 2 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.03 2 2 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 77 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID PLANT (cr=2 pr=2 pw=0 time=32646 us) 1 INDEX UNIQUE SCAN PLANT_PK (cr=1 pr=1 pw=0 time=16853 us)(object id 31597) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 db file sequential read 2 0.01 0.03 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** ALTER TABLE OBOM_ORDER_COMMODITY_PART MODIFY CONSTRAINT FK_OO_CMDTY_PART_OO_CMDTY ENABLE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 1 0 Execute 1 0.00 0.00 1 0 3 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.02 0.02 1 0 4 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.00 0.00 ******************************************************************************** SELECT count(obom_order.order_number) FROM model INNER JOIN obom_order ON model.model_code = obom_order.model_code WHERE model.fk_plant_code = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.01 0.01 0 381 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.01 0 381 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 77 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT DISTINCT supplier_id FROM commodity INNER JOIN model_commodity ON commodity.commodity_id = model_commodity.commodity_id INNER JOIN model ON model.model_code = model_commodity.model_code WHERE model.fk_plant_code = :1 AND commodity.dr_rpt_include_flag = 'Y' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 6 40 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.01 0.01 6 40 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 77 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 db file sequential read 1 0.00 0.00 db file scattered read 1 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT scs_sys_text, scs_sys_date, scs_sys_numeric FROM scs_system WHERE scs_sys_key = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 43 0.00 0.00 0 0 0 0 Fetch 43 0.00 0.00 2 84 0 41 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 86 0.00 0.01 2 84 0 41 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 77 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 43 0.00 0.00 SQL*Net message from client 43 3.43 5.00 db file sequential read 2 0.00 0.00 ******************************************************************************** SELECT COUNT(*) FROM SDO_GEOR_SYSDATA_TABLE WHERE SDO_OWNER = :1 AND GEORASTER_TABLE_NAME = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 3 3 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 3 3 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 32 (recursive depth: 3) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.00 0.00 ******************************************************************************** BEGIN BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner)) THEN xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 3 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 0 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 2) ******************************************************************************** SELECT supplier_id, plant_code, email_address, email_type FROM supplier_plant_email WHERE supplier_id = :1 AND plant_code = :2 AND email_type=:3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 23 0.00 0.00 0 0 0 0 Execute 23 0.00 0.00 0 0 0 0 Fetch 46 0.00 0.00 4 70 0 96 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 92 0.00 0.00 4 70 0 96 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 77 Rows Row Source Operation ------- --------------------------------------------------- 4 INDEX RANGE SCAN SUPPLIER_PLANT_EMAIL_PK (cr=3 pr=1 pw=0 time=66 us)(object id 38873) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 46 0.00 0.00 db file sequential read 4 0.00 0.00 SQL*Net message from client 46 0.00 0.05 ******************************************************************************** UPDATE commodity SET dr_rpt_last_launch_seq = dr_rpt_wip_launch_seq, dr_rpt_wip_launch_seq = null, dr_rpt_last_run_date_time = sysdate WHERE commodity_id in (SELECT commodity.commodity_id FROM commodity INNER JOIN model_commodity ON model_commodity.commodity_id = commodity.commodity_id INNER JOIN model ON model.model_code = model_commodity.model_code WHERE model.fk_plant_code = :1 AND commodity.dr_rpt_include_flag = 'Y'AND dr_rpt_wip_launch_seq is not null) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 7 1 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 7 1 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 77 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ log file sync 1 0.00 0.00 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SELECT USER_ID FROM ALL_USERS WHERE USERNAME = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 8 42 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13 0.00 0.00 8 42 0 6 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 3) Rows Row Source Operation ------- --------------------------------------------------- 6 NESTED LOOPS (cr=42 pr=8 pw=0 time=844 us) 6 NESTED LOOPS (cr=30 pr=8 pw=0 time=717 us) 6 TABLE ACCESS BY INDEX ROWID USER$ (cr=12 pr=4 pw=0 time=358 us) 6 INDEX UNIQUE SCAN I_USER1 (cr=6 pr=2 pw=0 time=179 us)(object id 44) 6 TABLE ACCESS CLUSTER TS$ (cr=18 pr=4 pw=0 time=322 us) 6 INDEX UNIQUE SCAN I_TS# (cr=6 pr=3 pw=0 time=198 us)(object id 7) 6 TABLE ACCESS CLUSTER TS$ (cr=12 pr=0 pw=0 time=91 us) 6 INDEX UNIQUE SCAN I_TS# (cr=6 pr=0 pw=0 time=33 us)(object id 7) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 8 0.00 0.00 ******************************************************************************** UPDATE scs_history_order SET ord_status_id = :1 WHERE order_number = :2 AND ord_status_id <= :3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 13 0.00 0.00 0 39 26 13 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.00 0.00 0 39 26 13 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 77 Rows Row Source Operation ------- --------------------------------------------------- 13 UPDATE SCS_HISTORY_ORDER (cr=39 pr=0 pw=0 time=867 us) 13 TABLE ACCESS BY INDEX ROWID SCS_HISTORY_ORDER (cr=39 pr=0 pw=0 time=329 us) 13 INDEX UNIQUE SCAN SYS_C002826 (cr=26 pr=0 pw=0 time=158 us)(object id 32698) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 13 0.00 0.00 SQL*Net message from client 13 0.00 0.01 ******************************************************************************** ALTER TABLE OBOM_ORDER_COMMODITY_PART MODIFY CONSTRAINT FK_OO_CMDTY_PART_OO_CMDTY DISABLE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 1 0 3 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 1 0 3 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.00 0.00 ******************************************************************************** UPDATE order_header_archive SET ORDER_STATUS_ID = :1, BUILD_DATE = :2, TLS_NUMBER = :3, SHORT_TLS = :4, OFFLINE_DATE = :5 WHERE order_number = :6 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 13 0.00 0.00 8 30 35 13 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.00 0.00 8 30 35 13 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 77 Rows Row Source Operation ------- --------------------------------------------------- 13 UPDATE ORDER_HEADER_ARCHIVE (cr=26 pr=7 pw=0 time=1624 us) 13 INDEX UNIQUE SCAN ORDER_HEADER_ARCHIVE_PK (cr=26 pr=6 pw=0 time=868 us)(object id 33495) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 7 0.00 0.00 SQL*Net message to client 13 0.00 0.00 SQL*Net message from client 13 0.00 0.01 ******************************************************************************** SELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function= 'CHECKPRIVRLS_SELECTPF' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 36 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 36 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 3) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=12 pr=0 pw=0 time=184 us) 0 TABLE ACCESS BY INDEX ROWID RLS$ (cr=12 pr=0 pw=0 time=169 us) 9 NESTED LOOPS (cr=12 pr=0 pw=0 time=424 us) 8 NESTED LOOPS (cr=10 pr=0 pw=0 time=108 us) 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=38 us) 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=26 us)(object id 44) 8 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=8 pr=0 pw=0 time=54 us) 8 INDEX RANGE SCAN I_OBJ2 (cr=2 pr=0 pw=0 time=15 us)(object id 37) 0 INDEX RANGE SCAN I_RLS2 (cr=2 pr=0 pw=0 time=40 us)(object id 426) ******************************************************************************** UPDATE scs_plant SET last_version = :1 WHERE plant_code = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 1 3 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 3 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 77 Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE SCS_PLANT (cr=1 pr=0 pw=0 time=113 us) 1 INDEX UNIQUE SCAN SYS_C002790 (cr=1 pr=0 pw=0 time=12 us)(object id 32682) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** DECLARE type vcurType is REF CURSOR; vcur vcurType; stmt VARCHAR2(1000); stm2 VARCHAR2(250); rdt VARCHAR2(80); rsid number; cnt number; m_id number; model varchar2(100); BEGIN IF dictionary_obj_type <> 'TABLE' THEN return; END IF; stmt := 'SELECT COUNT(*) FROM SDO_GEOR_SYSDATA_TABLE ' || ' WHERE SDO_OWNER = :1 AND GEORASTER_TABLE_NAME = :2'; EXECUTE IMMEDIATE stmt INTO cnt USING dictionary_obj_owner, dictionary_obj_name; IF cnt > 0 THEN stmt := 'SELECT RDT_TABLE_NAME, RASTER_ID FROM SDO_GEOR_SYSDATA_TABLE' || ' WHERE SDO_OWNER = :1 AND GEORASTER_TABLE_NAME = :2'; open vcur for stmt using dictionary_obj_owner, dictionary_obj_name; loop fetch vcur into rdt, rsid; exit when vcur%NOTFOUND; if instr(rdt, '.') = 0 then rdt := dictionary_obj_owner || '.' || rdt; end if; stm2 := 'DELETE FROM ' ||DBMS_ASSERT.QUALIFIED_SQL_NAME(rdt) || ' WHERE rasterid=:1'; begin execute immediate stm2 using rsid; exception when others then if SQLCODE <> -942 then raise; end if; end; end loop; stmt := 'DELETE FROM SDO_GEOR_SYSDATA_TABLE ' || ' WHERE SDO_OWNER = :name AND GEORASTER_TABLE_NAME = :2'; EXECUTE IMMEDIATE stmt USING dictionary_obj_owner, dictionary_obj_name; END IF; stmt := 'SELECT COUNT(*) FROM ALL_TABLES ' || ' WHERE OWNER = ''MDSYS'' AND TABLE_NAME = ''RDF_MODEL$'' '; EXECUTE IMMEDIATE stmt INTO cnt; if (cnt = 1) then begin cnt := 0; stmt := 'SELECT count(*) FROM MDSYS.RDF_MODEL$ ' || ' WHERE OWNER = :1 AND TABLE_NAME = :2'; EXECUTE IMMEDIATE stmt INTO cnt USING dictionary_obj_owner, dictionary_obj_name; if (cnt > 0) then stmt := 'SELECT model_name, model_id FROM MDSYS.RDF_MODEL$ ' || ' WHERE OWNER = :1 AND TABLE_NAME = :2'; EXECUTE IMMEDIATE stmt INTO model, m_id USING dictionary_obj_owner, dictionary_obj_name; begin EXECUTE IMMEDIATE 'BEGIN MDSYS.RDF_APIS_INTERNAL.NOTIFY_MODEL_DML(:1, ''DEL''); END;' using model; exception when others then NULL; end; stmt := ' DELETE MDSYS.RDF_LINK$ WHERE model_id = '||to_char(m_id) ; EXECUTE IMMEDIATE stmt; end if; exception when others then NULL; end; end if; END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 3 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 0 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 32 (recursive depth: 2) ******************************************************************************** UPDATE scs_system SET scs_sys_text = :1, scs_sys_numeric = null, scs_sys_date = null, scs_encrypted = :2 WHERE scs_sys_key = :3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 10 21 6 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 10 21 6 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 77 Rows Row Source Operation ------- --------------------------------------------------- 6 UPDATE SCS_SYSTEM (cr=6 pr=0 pw=0 time=496 us) 6 INDEX UNIQUE SCAN SYS_C002776 (cr=6 pr=0 pw=0 time=53 us)(object id 32672) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6 0.00 0.00 SQL*Net message from client 6 0.00 0.00 ******************************************************************************** SELECT plant_code, plant_desc, last_version FROM scs_plant WHERE plant_code = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 16 0.00 0.00 0 0 0 0 Fetch 16 0.00 0.00 1 32 0 16 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 32 0.00 0.00 1 32 0 16 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 77 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 16 0.00 0.00 SQL*Net message from client 16 0.00 0.02 db file sequential read 1 0.00 0.00 ******************************************************************************** SELECT COUNT(*) FROM ALL_USERS WHERE USER_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 2 48 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13 0.00 0.00 2 48 0 6 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 3) Rows Row Source Operation ------- --------------------------------------------------- 6 SORT AGGREGATE (cr=48 pr=2 pw=0 time=556 us) 6 NESTED LOOPS (cr=48 pr=2 pw=0 time=480 us) 6 NESTED LOOPS (cr=36 pr=2 pw=0 time=376 us) 6 TABLE ACCESS CLUSTER USER$ (cr=18 pr=2 pw=0 time=241 us) 6 INDEX UNIQUE SCAN I_USER# (cr=6 pr=2 pw=0 time=157 us)(object id 11) 6 TABLE ACCESS CLUSTER TS$ (cr=18 pr=0 pw=0 time=102 us) 6 INDEX UNIQUE SCAN I_TS# (cr=6 pr=0 pw=0 time=41 us)(object id 7) 6 TABLE ACCESS CLUSTER TS$ (cr=12 pr=0 pw=0 time=67 us) 6 INDEX UNIQUE SCAN I_TS# (cr=6 pr=0 pw=0 time=25 us)(object id 7) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 ******************************************************************************** SELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function= 'CHECKPRIVRLS_SELECTPROPF' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 36 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 36 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 73 (recursive depth: 3) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=12 pr=0 pw=0 time=183 us) 0 TABLE ACCESS BY INDEX ROWID RLS$ (cr=12 pr=0 pw=0 time=166 us) 9 NESTED LOOPS (cr=12 pr=0 pw=0 time=379 us) 8 NESTED LOOPS (cr=10 pr=0 pw=0 time=87 us) 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=24 us) 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=16 us)(object id 44) 8 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=8 pr=0 pw=0 time=59 us) 8 INDEX RANGE SCAN I_OBJ2 (cr=2 pr=0 pw=0 time=15 us)(object id 37) 0 INDEX RANGE SCAN I_RLS2 (cr=2 pr=0 pw=0 time=51 us)(object id 426) ******************************************************************************** UPDATE scs_system SET scs_sys_date = :1 , scs_sys_numeric = null , scs_sys_text = null WHERE scs_sys_key = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 10 12 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 10 12 2 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 77 Rows Row Source Operation ------- --------------------------------------------------- 2 UPDATE SCS_SYSTEM (cr=2 pr=0 pw=0 time=140 us) 2 INDEX UNIQUE SCAN SYS_C002776 (cr=2 pr=0 pw=0 time=21 us)(object id 32672) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT supplier_id, message_type FROM supplier_plant WHERE plant_code = :1 AND active_ind = 'Y' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 10 0 23 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 10 0 23 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 77 Rows Row Source Operation ------- --------------------------------------------------- 23 TABLE ACCESS FULL SUPPLIER_PLANT (cr=10 pr=0 pw=0 time=60 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 4 0.00 0.00 SQL*Net message from client 4 0.00 0.00 ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 60 0.01 0.00 0 0 0 0 Execute 216 2296.06 2704.09 881132 230076500 35338620 103 Fetch 142 0.29 0.32 684 7764 0 214 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 418 2296.36 2704.43 881816 230084264 35338620 317 Misses in library cache during parse: 9 Misses in library cache during execute: 9 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 108 0.05 0.33 SQL*Net message to client 389 0.00 0.00 SQL*Net message from client 389 195.63 345.93 log file sync 69 0.01 0.24 db file scattered read 91 0.05 0.20 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 974 0.15 0.14 11 12 3 0 Execute 62309 424.60 861.60 864622 376344 35338369 9836595 Fetch 63998 1871.20 1841.79 16283 229696394 1 64621 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 127281 2295.97 2703.54 880916 230072750 35338373 9901216 Misses in library cache during parse: 32 Misses in library cache during execute: 21 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 520144 6.48 433.81 db file scattered read 8817 0.04 2.86 control file sequential read 30 0.00 0.00 direct path read temp 189305 0.00 0.34 log buffer space 28 0.83 5.62 log file switch completion 48 0.42 4.15 reliable message 3 0.00 0.00 enq: RO - fast object reuse 3 0.50 0.71 local write wait 530 0.03 2.16 direct path write temp 2438 0.00 0.00 free buffer waits 67 0.01 0.69 latch: library cache lock 1 0.04 0.04 latch: cache buffers chains 4 0.00 0.00 latch: shared pool 1 0.00 0.00 latch: row cache objects 1 0.00 0.00 104 user SQL statements in session. 1175 internal SQL statements in session. 1279 SQL statements in session. ******************************************************************************** Trace file: pobom2_ora_23794.trc Trace file compatibility: 10.01.00 Sort options: prsela fchela exeela 1 session in tracefile. 104 user SQL statements in trace file. 1175 internal SQL statements in trace file. 1279 SQL statements in trace file. 126 unique SQL statements in trace file. 859280 lines in trace file. 3050 elapsed seconds in trace file.