=>cat external_ora_10672.prof TKPROF: Release 9.2.0.8.0 - Production on Thu Jan 22 16:55:49 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Trace file: external_ora_10672.trc Sort options: prsela exeela fchela ******************************************************************************** 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 ******************************************************************************** UPDATE /*+ APPEND PARALLEL(S_AUDIT_ITEM, DEFAULT, DEFAULT) */ "S_AUDIT_ITEM" SET "CREATED" = :B17 , "CREATED_BY" = :B16 , "LAST_UPD" = :B15 , "LAST_UPD_BY" = :B14 , "MODIFICATION_NUM" = :B13 , "CONFLICT_ID" = :B12 , "BUSCOMP_NAME" = :B11 , "FIELD_NAME" = :B10 , "OPERATION_CD" = :B9 , "RECORD_ID" = :B8 , "USER_ID" = :B7 , "OPERATION_DT" = :B6 , "NEW_VAL" = :B5 , "OLD_VAL" = :B4 , "ODS_LAST_UPD_DTM" = :B3 , "ODS_LAST_UPD_BY" = :B2 WHERE "ROW_ID" = :B1 RETURNING ROWID INTO :B0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 147 72.29 344.20 525456 1337584 159 147 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 147 72.29 344.20 525456 1337584 159 147 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 110 (ODS_SBL_SPRINT) (recursive depth: 1) error during execute of EXPLAIN PLAN statement ORA-00942: table or view does not exist parse error offset: 138 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file scattered read 61194 0.19 151.31 db file sequential read 55506 0.04 56.10 latch free 525 0.01 0.22 rdbms ipc reply 1855 0.01 0.19 enqueue 249 0.40 12.08 PX Deq: Join ACK 105 0.00 0.05 PX Deq: Parse Reply 99 0.00 0.02 PX Deq: Execute Reply 1964 0.19 25.36 PX Deq: Signal ACK 200 0.00 0.02 buffer busy waits 22126 0.20 22.16 ******************************************************************************** SELECT WB_RT_ROWKEY_SEQ.NEXTVAL FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 147 0.01 0.01 0 0 0 0 Fetch 147 0.02 0.03 0 441 8 147 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 294 0.03 0.04 0 441 8 147 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 72 (OWB_RUNREP) (recursive depth: 1) error during execute of EXPLAIN PLAN statement ORA-02289: sequence does not exist parse error offset: 83 ******************************************************************************** SELECT /*+ NO_MERGE */ "STG_SIEBEL_S_AUDIT_I4678089"."ROW_ID" "ROW_ID", "STG_SIEBEL_S_AUDIT_I4678089"."CREATED" "CREATED", "STG_SIEBEL_S_AUDIT_I4678089"."CREATED_BY" "CREATED_BY", "STG_SIEBEL_S_AUDIT_I4678089"."LAST_UPD" "LAST_UPD", "STG_SIEBEL_S_AUDIT_I4678089"."LAST_UPD_BY" "LAST_UPD_BY", "STG_SIEBEL_S_AUDIT_I4678089"."MODIFICATION_NUM" "MODIFICATION_NUM", "STG_SIEBEL_S_AUDIT_I4678089"."CONFLICT_ID" "CONFLICT_ID", "STG_SIEBEL_S_AUDIT_I4678089"."BUSCOMP_NAME" "BUSCOMP_NAME", "STG_SIEBEL_S_AUDIT_I4678089"."FIELD_NAME" "FIELD_NAME", "STG_SIEBEL_S_AUDIT_I4678089"."OPERATION_CD" "OPERATION_CD", "STG_SIEBEL_S_AUDIT_I4678089"."RECORD_ID" "RECORD_ID", "STG_SIEBEL_S_AUDIT_I4678089"."USER_ID" "USER_ID", "STG_SIEBEL_S_AUDIT_I4678089"."OPERATION_DT" "OPERATION_DT", "STG_SIEBEL_S_AUDIT_I4678089"."NEW_VAL" "NEW_VAL", "STG_SIEBEL_S_AUDIT_I4678089"."OLD_VAL" "OLD_VAL", "S_CONTACT"."ROW_ID" "ROW_ID_1", "S_CONTACT"."BU_ID" "BU_ID" FROM "STG_SIEBEL"."S_AUDIT_ITEM"@"db_stg_siebel" "STG_SIEBEL_S_AUDIT_I4678089", "S_CONTACT" "S_CONTACT" WHERE ( "STG_SIEBEL_S_AUDIT_I4678089"."CREATED_BY" = "S_CONTACT"."ROW_ID" ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch 147 0.02 0.03 0 846 0 147 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 147 0.02 0.03 0 846 0 147 Misses in library cache during parse: 0 Parsing user id: 110 (???) (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to dblink 3 0.00 0.00 SQL*Net message from dblink 3 0.01 0.01 SQL*Net more data from dblink 8 0.00 0.00 ******************************************************************************** SELECT user from sys.dual call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 147 0.02 0.00 0 0 0 0 Fetch 147 0.01 0.00 0 441 0 147 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 294 0.03 0.01 0 441 0 147 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 110 (ODS_SBL_SPRINT) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 TABLE ACCESS (FULL) OF 'DUAL' ******************************************************************************** update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6, cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.00 0.00 0 0 0 0 Execute 8 0.01 0.01 0 8 16 8 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.01 0.01 0 8 16 8 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE 1 INDEX UNIQUE SCAN I_SEQ1 (object id 107) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 0 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file scattered read 693 0.03 1.87 db file sequential read 311 0.00 0.40 latch free 1 0.00 0.00 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.00 0.00 0 0 0 0 Execute 449 72.33 344.23 525456 1337592 175 155 Fetch 441 0.05 0.07 0 1728 8 441 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 898 72.38 344.31 525456 1339320 183 596 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file scattered read 60501 0.19 149.44 db file sequential read 55195 0.04 55.70 latch free 524 0.01 0.22 rdbms ipc reply 1855 0.01 0.19 enqueue 249 0.40 12.08 PX Deq: Join ACK 105 0.00 0.05 PX Deq: Parse Reply 99 0.00 0.02 PX Deq: Execute Reply 1964 0.19 25.36 PX Deq: Signal ACK 200 0.00 0.02 buffer busy waits 22126 0.20 22.16 SQL*Net message to dblink 3 0.00 0.00 SQL*Net message from dblink 3 0.01 0.01 SQL*Net more data from dblink 8 0.00 0.00 4 user SQL statements in session. 8 internal SQL statements in session. 12 SQL statements in session. 1 statement EXPLAINed in this session. ******************************************************************************** Trace file: external_ora_10672.trc Trace file compatibility: 9.02.00 Sort options: prsela exeela fchela 1 session in tracefile. 4 user SQL statements in trace file. 8 internal SQL statements in trace file. 12 SQL statements in trace file. 5 unique SQL statements in trace file. 1 SQL statements EXPLAINed using schema: OPS$ORACLE.prof$plan_table Default table was used. Table was created. Table was dropped. 153357 lines in trace file.