TKPROF: Release 10.2.0.4.0 - Production on Ven. Sept. 16 08:21:12 2011 Copyright (c) 1982, 2007, Oracle. All rights reserved. Trace file: D:\DATABASE\GPAO\bdump\gpao_dw01_2844.trc Sort options: execpu fchcpu ******************************************************************************** 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 ******************************************************************************** The following statement encountered a error during parse: SELECT COUNT(*) FROM ALL_USERS WHERE USERNAME = :B1 Error encountered: ORA-00904 ******************************************************************************** BEGIN SYS.KUPW$WORKER.MAIN('SYS_IMPORT_SCHEMA_29', 'DATAPUMP'); END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.43 0.95 6 13342 17282 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.45 0.95 6 13342 17282 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 55 (DATAPUMP) (recursive depth: 1) ******************************************************************************** UPDATE "DATAPUMP"."SYS_IMPORT_SCHEMA_29" SET completed_rows = 0, error_count = 0, elapsed_time = 0, granules = 0, flags = 0 WHERE process_order > 0 AND duplicate <> 0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.09 2.32 0 23 1755 857 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.09 2.32 0 23 1755 857 Misses in library cache during parse: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE SYS_IMPORT_SCHEMA_29 (cr=23 pr=0 pw=0 time=2321547 us) 857 INDEX RANGE SCAN SYS_C0017208 (cr=23 pr=0 pw=0 time=5170 us)(object id 52756) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT MODE: RULE 0 UPDATE OF 'SYS_IMPORT_SCHEMA_29' 857 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT COUNT(*) 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 5 0.00 0.00 0 0 0 0 Fetch 5 0.01 0.00 0 35 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 0.01 0.00 0 35 0 5 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 SORT (AGGREGATE) 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'USER$' (CLUSTER) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'I_USER1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (CLUSTER) OF 'TS$' (CLUSTER) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'I_TS#' (INDEX (CLUSTER)) 0 TABLE ACCESS MODE: ANALYZED (CLUSTER) OF 'TS$' (CLUSTER) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'I_TS#' (INDEX (CLUSTER)) ******************************************************************************** SELECT NVL((SELECT 1 FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND duplicate = :2 AND completion_time IS NOT NULL), 0), NVL((SELECT 1 FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :3 AND duplicate = :4 AND completion_time IS NULL), 0), NVL((SELECT 1 FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order > 0 AND duplicate = 0 AND object_type = :5 AND processing_state != :6 AND ROWNUM = 1), 0), NVL((SELECT 1 FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order > 0 AND duplicate = 0 AND object_path_seqno = :7 AND ROWNUM = 1), 0) FROM DUAL 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.01 0.01 1 1079 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 1 1079 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=2 pr=0 pw=0 time=35 us) 0 INDEX UNIQUE SCAN SYS_C0017208 (cr=2 pr=0 pw=0 time=21 us)(object id 52756) 0 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=2 pr=0 pw=0 time=24 us) 0 INDEX UNIQUE SCAN SYS_C0017208 (cr=2 pr=0 pw=0 time=12 us)(object id 52756) 0 COUNT STOPKEY (cr=1070 pr=0 pw=0 time=11851 us) 0 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=1070 pr=0 pw=0 time=11836 us) 8353 INDEX RANGE SCAN SYS_C0017208 (cr=23 pr=0 pw=0 time=41778 us)(object id 52756) 1 COUNT STOPKEY (cr=5 pr=1 pw=0 time=433 us) 1 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=5 pr=1 pw=0 time=408 us) 8 INDEX RANGE SCAN SYS_MTABLE_00000CE03_IND_3 (cr=2 pr=1 pw=0 time=397 us)(object id 52759) 1 FAST DUAL (cr=0 pr=0 pw=0 time=14 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) 0 COUNT (STOPKEY) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 8353 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) 1 COUNT (STOPKEY) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 8 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_MTABLE_00000CE03_IND_3' (INDEX) 1 FAST DUAL ******************************************************************************** UPDATE "DATAPUMP"."SYS_IMPORT_SCHEMA_29" SET in_progress = :1, processing_state = :2 WHERE process_order = :3 AND duplicate = 0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 11 19 9 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 11 19 9 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 9 UPDATE SYS_IMPORT_SCHEMA_29 (cr=11 pr=0 pw=0 time=1206 us) 9 INDEX UNIQUE SCAN SYS_C0017208 (cr=11 pr=0 pw=0 time=127 us)(object id 52756) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT MODE: RULE 9 UPDATE OF 'SYS_IMPORT_SCHEMA_29' 9 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** alter session set NLS_LANGUAGE='FRENCH' NLS_TERRITORY='FRANCE' NLS_CURRENCY= '€' NLS_ISO_CURRENCY='FRANCE' NLS_NUMERIC_CHARACTERS=', ' NLS_DATE_FORMAT= 'DD/MM/RR' NLS_DATE_LANGUAGE='FRENCH' NLS_SORT='FRENCH' 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 55 (DATAPUMP) (recursive depth: 1) ******************************************************************************** ALTER SESSION SET optimizer_mode = rule call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 55 (DATAPUMP) (recursive depth: 2) ******************************************************************************** ALTER SESSION SET NLS_NUMERIC_CHARACTERS= '.,' 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 55 (DATAPUMP) (recursive depth: 2) ******************************************************************************** ALTER SESSION ENABLE PARALLEL DML 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 55 (DATAPUMP) (recursive depth: 2) ******************************************************************************** ALTER SESSION ENABLE RESUMABLE NAME 'DATAPUMP.SYS_IMPORT_SCHEMA_29.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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 55 (DATAPUMP) (recursive depth: 2) ******************************************************************************** ALTER SESSION SET SKIP_UNUSABLE_INDEXES = TRUE 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 55 (DATAPUMP) (recursive depth: 2) ******************************************************************************** SELECT name, value_n, value_t, object_long_name, is_default FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND name IN (:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) ORDER BY duplicate 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 6 0.00 0.00 0 3 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.00 0.00 0 3 0 5 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 5 SORT ORDER BY (cr=3 pr=0 pw=0 time=113 us) 5 TABLE ACCESS FULL SYS_IMPORT_SCHEMA_29 (cr=3 pr=0 pw=0 time=81 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 5 SORT (ORDER BY) 5 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT name, value_t, object_type_path FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND name NOT LIKE :2 ORDER BY duplicate 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 3 0.00 0.00 0 3 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 3 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 2 SORT ORDER BY (cr=3 pr=0 pw=0 time=75 us) 2 TABLE ACCESS FULL SYS_IMPORT_SCHEMA_29 (cr=3 pr=0 pw=0 time=38 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 2 SORT (ORDER BY) 2 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT name, old_value, value_t, value_n, flags, object_type FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 ORDER BY duplicate 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 3 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 3 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT ORDER BY (cr=3 pr=0 pw=0 time=64 us) 3 TABLE ACCESS FULL SYS_IMPORT_SCHEMA_29 (cr=3 pr=0 pw=0 time=36 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 3 SORT (ORDER BY) 3 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT name, value_t, value_n, object_schema, object_name FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 ORDER BY duplicate 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.00 0.00 0 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY (cr=3 pr=0 pw=0 time=45 us) 0 TABLE ACCESS FULL SYS_IMPORT_SCHEMA_29 (cr=3 pr=0 pw=0 time=25 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 SORT (ORDER BY) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** ALTER SESSION SET optimizer_mode = choose 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 55 (DATAPUMP) (recursive depth: 2) ******************************************************************************** SELECT NVL(operation, ''), NVL(job_mode, ''), NVL(guid,HEXTORAW(0)) FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = DECODE((SELECT COUNT(*) FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 ), 1, :2, :3 ) 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.00 0.00 0 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 6 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 FILTER (cr=6 pr=0 pw=0 time=193 us) 28 TABLE ACCESS FULL SYS_IMPORT_SCHEMA_29 (cr=3 pr=0 pw=0 time=217 us) 1 SORT AGGREGATE (cr=3 pr=0 pw=0 time=88 us) 1 TABLE ACCESS FULL SYS_IMPORT_SCHEMA_29 (cr=3 pr=0 pw=0 time=49 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) 1 SORT (AGGREGATE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** UPDATE "DATAPUMP"."SYS_IMPORT_SCHEMA_29" SET work_item = :1, state = :2, metadata_io = :3, data_io = :4, size_estimate = :5, cumulative_time = :6, last_update = sysdate, object_number = NULL, object_schema = NULL, object_name = NULL, object_long_name = NULL, partition_name = NULL, subpartition_name = NULL, total_bytes = NULL, object_type_path = NULL, completed_rows = NULL, parallelization = NULL WHERE process_order = :7 AND duplicate = :8 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 1 322 24 8 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.00 0.00 1 322 24 8 Misses in library cache during parse: 4 Misses in library cache during execute: 4 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT MODE: RULE 0 UPDATE OF 'SYS_IMPORT_SCHEMA_29' 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT old_value FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 6 0 1 Misses in library cache during parse: 2 Misses in library cache during execute: 2 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT process_order, object_schema, NVL(name, object_long_name), partition_name, subpartition_name, completed_rows, dump_length FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order BETWEEN :1 AND :2 AND duplicate = 0 AND processing_status = :3 AND processing_state <> :4 ORDER BY process_order 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.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 FILTER 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** ALTER SESSION SET TIME_ZONE = '+01:00' 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 55 (DATAPUMP) (recursive depth: 2) ******************************************************************************** SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1),0), NVL(SUM(C2),0), NVL(SUM(C3),0) FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("SYS_IMPORT_SCHEMA_29") FULL("SYS_IMPORT_SCHEMA_29") NO_PARALLEL_INDEX("SYS_IMPORT_SCHEMA_29") */ 1 AS C1, CASE WHEN "SYS_IMPORT_SCHEMA_29"."PROCESS_ORDER"=:B1 AND "SYS_IMPORT_SCHEMA_29"."NAME"=:B2 AND "SYS_IMPORT_SCHEMA_29"."VALUE_N"=0 AND "SYS_IMPORT_SCHEMA_29"."OBJECT_NAME" IS NULL AND "SYS_IMPORT_SCHEMA_29"."OBJECT_SCHEMA" IS NULL THEN 1 ELSE 0 END AS C2, CASE WHEN "SYS_IMPORT_SCHEMA_29"."PROCESS_ORDER"=:B1 THEN 1 ELSE 0 END AS C3 FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" SAMPLE BLOCK (20.930233 , 1) SEED (1) "SYS_IMPORT_SCHEMA_29") SAMPLESUB call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 116 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 116 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 55 (DATAPUMP) (recursive depth: 3) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=58 pr=0 pw=0 time=2085 us) 1738 TABLE ACCESS SAMPLE SYS_IMPORT_SCHEMA_29 (cr=58 pr=0 pw=0 time=8735 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: HINT: ALL_ROWS 1 SORT (AGGREGATE) 1738 TABLE ACCESS MODE: ANALYZED (SAMPLE) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) ******************************************************************************** SELECT object_number, (object_number + completed_rows -1), duplicate, object_type_path, object_type FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND object_type != :2 AND object_number BETWEEN (SELECT MAX(object_number) FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = -5 AND object_number <= 0 AND object_type != 'TABLE_DATA') AND (SELECT MIN(object_number) FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = -5 AND object_number + completed_rows - 1 >= 0 AND object_type != 'TABLE_DATA') ORDER BY duplicate 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.00 0.00 0 56 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 56 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY (cr=56 pr=0 pw=0 time=423 us) 0 FILTER (cr=56 pr=0 pw=0 time=395 us) 52 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=28 pr=0 pw=0 time=722 us) 53 INDEX RANGE SCAN SYS_C0017208 (cr=2 pr=0 pw=0 time=293 us)(object id 52756) 1 SORT AGGREGATE (cr=28 pr=0 pw=0 time=205 us) 0 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=28 pr=0 pw=0 time=177 us) 53 INDEX RANGE SCAN SYS_C0017208 (cr=2 pr=0 pw=0 time=274 us)(object id 52756) 0 SORT AGGREGATE (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=0 pr=0 pw=0 time=0 us) 0 INDEX RANGE SCAN SYS_C0017208 (cr=0 pr=0 pw=0 time=0 us)(object id 52756) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 SORT (ORDER BY) 0 FILTER 52 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 53 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) 1 SORT (AGGREGATE) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 53 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) 0 SORT (AGGREGATE) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT process_order, object_schema, NVL(name, object_long_name), partition_name, subpartition_name, NVL(dump_length, 0), processing_status, flags FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order > 0 AND duplicate = 0 AND object_path_seqno = :1 AND processing_state != :2ORDER BY process_order 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.00 0.01 4 89 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 4 89 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY (cr=89 pr=4 pw=0 time=10645 us) 0 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=89 pr=4 pw=0 time=10613 us) 1998 INDEX RANGE SCAN SYS_MTABLE_00000CE03_IND_3 (cr=6 pr=4 pw=0 time=10059 us)(object id 52759) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 SORT (ORDER BY) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 1998 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_MTABLE_00000CE03_IND_3' (INDEX) ******************************************************************************** INSERT INTO "DATAPUMP"."SYS_IMPORT_SCHEMA_29" (process_order, duplicate, object_path_seqno, object_type_path, object_number, start_time, completed_rows) values (:1, :2, :3, :4, :5, :6, 0) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 1 2 13 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 1 2 13 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 INSERT STATEMENT MODE: RULE ******************************************************************************** SELECT object_number, (object_number + completed_rows -1), duplicate, object_type_path, object_type FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND object_type != :2 AND object_number BETWEEN (SELECT MAX(object_number) FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = -5 AND object_number <= 6850 AND object_type != 'TABLE_DATA') AND (SELECT MIN(object_number) FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = -5 AND object_number + completed_rows - 1 >= 6886 AND object_type != 'TABLE_DATA') ORDER BY duplicate call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 84 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 84 0 4 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 4 SORT ORDER BY (cr=84 pr=0 pw=0 time=682 us) 4 FILTER (cr=84 pr=0 pw=0 time=606 us) 52 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=28 pr=0 pw=0 time=722 us) 53 INDEX RANGE SCAN SYS_C0017208 (cr=2 pr=0 pw=0 time=291 us)(object id 52756) 1 SORT AGGREGATE (cr=28 pr=0 pw=0 time=224 us) 33 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=28 pr=0 pw=0 time=449 us) 53 INDEX RANGE SCAN SYS_C0017208 (cr=2 pr=0 pw=0 time=274 us)(object id 52756) 1 SORT AGGREGATE (cr=28 pr=0 pw=0 time=186 us) 17 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=28 pr=0 pw=0 time=237 us) 53 INDEX RANGE SCAN SYS_C0017208 (cr=2 pr=0 pw=0 time=274 us)(object id 52756) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 4 SORT (ORDER BY) 4 FILTER 52 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 53 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) 1 SORT (AGGREGATE) 33 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 53 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) 1 SORT (AGGREGATE) 17 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 53 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** ALTER SESSION SET "_LOAD_WITHOUT_COMPILE" = PLSQL 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 55 (DATAPUMP) (recursive depth: 2) ******************************************************************************** SELECT COUNT(*) FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND duplicate = 0 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.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 SORT (AGGREGATE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT (SELECT t.value_n FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" t WHERE t.process_order = :1 AND t.name = :2), (SELECT i.value_t FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" i WHERE i.process_order = :3 AND i.name = :4) FROM DUAL 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.00 0.00 0 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 6 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) 0 FAST DUAL ******************************************************************************** SELECT NVL(MAX(duplicate),:1) FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :2 AND object_row = :3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 SORT (AGGREGATE) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT operation, job_mode, start_time, SUBSTR(remote_link,0,128),abort_step, state, db_version FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND duplicate = 0 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.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** ALTER SESSION SET CURRENT_SCHEMA = "GCOM" 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 55 (DATAPUMP) (recursive depth: 2) ******************************************************************************** CREATE PROCEDURE "GCOM"."INSERT_TMP_TOTEM" is BEGIN DELETE TOTEM_INTEGRATION ; INSERT INTO TOTEM_INTEGRATION (ENT_CODE, ETA_CODE, JOU_CODE, ANNEE, PERIODE , PIE_PIECE, ECG_LIGNE, PIE_DATE, DATEORIG, ORIGINE, LIBELLE, LIBELLE01, COL_CODEP, GEN_CODE, DEV_CODE, STATUS, MODULE, TIE_CODE, A01_CODE,A03_CODE, A01_QTE, MRG_CODE,ECHEANCE,IMMO_BS, DEBITPIE, CREDITPIE) SELECT DECODE(CODE_SOCIETE,'GOUB','GBR','GPL') ENT_CODE, 'SIE' ETA_CODE, 'VI' JOU_CODE, SUBSTR(DATE_COMPTABLE,0,4) ANNEE, SUBSTR(DATE_COMPTABLE,5,2) || 'C' PERIODE, NUM_PIECE PIE_PIECE, NUM_LIGNE ECG_LIGNE, DATE_COMPTABLE PIE_DATE, DATE_COMPTABLE DATEORIG, 'FVT' || NUM_PIECE ORIGINE, UPPER(LIBELLE_GENERAL) LIBELLE, LIBELLE_GENERAL|| ' LIGNE: '||NUM_LIGNE LIBELLE01, 'CLI' COL_CODEP, COLLETIF GEN_CODE, 'EUR' DEV_CODE, 'V' STATUS, 'GESTCOM' MODULE, COMPTE_TIERS TIE_CODE, AXE_ANALYTIQUE A01_CODE, SUBSTR(DATE_COMPTABLE,0,6) A03_CODE, QUANTITE A01_QTE, MODE_REGLEMENT MRG_CODE, DATE_ECHEANCE ECHEANCE, 'B' IMMO_BS , TO_CHAR(DECODE(SENS,'D',MONTANT,0),'99999999999990.00') DEBITPIE, TO_CHAR(DECODE(SENS,'C',MONTANT,0),'99999999999990.00') CREDITPIE FROM GCECRITURE2 WHERE TO_CHAR(DATE_CLOTURE,'DDMMYYYY') = TO_CHAR(SYSDATE,'DDMMYYYY') AND CODE_JOURNAL = '01'; UPDATE TOTEM_INTEGRATION A SET GEN_CODE = (SELECT COMPTE_GENERAL_NEW FROM TOTEM_COMPTE_GEN WHERE COMPTE_GENERAL_ANC = TRIM(GEN_CODE)) WHERE TRIM(GEN_CODE) IN(SELECT COMPTE_GENERAL_ANC FROM TOTEM_COMPTE_GEN); UPDATE TOTEM_INTEGRATION A SET TIE_CODE = (SELECT CODE_CLIENT_NEW FROM TOTEM_CLIENTS WHERE CODE_CLIENT_ANC= TRIM(TIE_CODE)) WHERE TRIM(TIE_CODE) IN(SELECT CODE_CLIENT_ANC FROM TOTEM_CLIENTS); UPDATE TOTEM_INTEGRATION A SET COLCODE ='CLI' WHERE TIE_CODE IS NOT NULL; UPDATE TOTEM_INTEGRATION A SET MRG_CODE = (SELECT MODE_REGLEMENT_NEW FROM TOTEM_REGLEMENT WHERE MODE_REGLEMENT_ANC = A.MRG_CODE); UPDATE TOTEM_INTEGRATION A SET (TIE_CODEP, MRG_CODE) = (SELECT DISTINCT TIE_CODE,MRG_CODE FROM TOTEM_INTEGRATION B WHERE A.PIE_PIECE = B.PIE_PIECE AND Trim(B.TIE_CODE) IS NOT NULL); UPDATE TOTEM_INTEGRATION A SET A01_CODE = (SELECT AXE_ANA_NEW FROM TOTEM_ANA WHERE AXE_ANA_ANC = TRIM(A.A01_CODE)) WHERE Trim(A01_CODE) IN (SELECT AXE_ANA_ANC FROM TOTEM_ANA); UPDATE TOTEM_INTEGRATION A SET A02_CODE = (SELECT AXE_ANA2_NEW FROM TOTEM_ANA2 WHERE COMPTE_GEN_ANC = TRIM(A.GEN_CODE)); UPDATE TOTEM_INTEGRATION A SET A03_CODE = NULL, A01_QTE = NULL WHERE Trim(A01_CODE) IS NULL; UPDATE TOTEM_INTEGRATION A SET TVA_CODE = (SELECT DISTINCT DECODE(LIGNE_TVA,'3','TTC','2','TVA', DECODE(CODE_TVA,'1','1','9','2','0','5',0)) TVA_CODE FROM GCECRITURE2 B WHERE B.NUM_PIECE = A.PIE_PIECE AND B.NUM_LIGNE = A.ECG_LIGNE); UPDATE TOTEM_INTEGRATION A SET MTTVA = (SELECT ABS(ROUND( DECODE(SENS,'D',-1,1) * DECODE(CODE_TVA,'1',0.055,'9',0.196,0)* MONTANT,2)) MTVA FROM GCECRITURE2 B WHERE B.LIGNE_TVA= 1 AND B.NUM_PIECE = A.PIE_PIECE AND B.NUM_LIGNE = A.ECG_LIGNE); UPDATE TOTEM_INTEGRATION A SET MTTVA = (SELECT ABS(SUM(DECODE(SENS,'D',-1,1) * MONTANT)) FROM GCECRITURE2 B WHERE LIGNE_TVA = 2 AND B.NUM_PIECE = A.PIE_PIECE GROUP BY NUM_PIECE ) WHERE TIE_CODE IS NOT NULL; UPDATE TOTEM_INTEGRATION A SET MTTVA = 0 WHERE MTTVA IS NULL; BEGIN FOR I IN (SELECT PIE_PIECE, SUM(DECODE(COLCODE,'CLI',TO_NUMBER(MTTVA),0) )- SUM(DECODE(COLCODE,'CLI',0,TO_NUMBER(MTTVA))) DIFF FROM TOTEM_INTEGRATION B GROUP BY PIE_PIECE) LOOP UPDATE TOTEM_INTEGRATION SET MTTVA = MTTVA + I.DIFF WHERE PIE_PIECE = I.PIE_PIECE AND ECG_LIGNE = 2; END LOOP; END; UPDATE TOTEM_INTEGRATION SET MTTVA = TO_CHAR(TO_NUMBER(MTTVA),'99999999999990.00'); UPDATE TOTEM_INTEGRATION SET ENT_CODE =RPAD(NVL(ENT_CODE ,' '),3), ETA_CODE =RPAD(NVL(ETA_CODE ,' '),3), JOU_CODE =RPAD(NVL(JOU_CODE ,' '),4), ANNEE =RPAD(NVL(ANNEE ,' '),4), PERIODE =RPAD(NVL(PERIODE ,' '),5), PIE_PIECE =RPAD(NVL(PIE_PIECE ,' '),10), ECG_LIGNE =RPAD(NVL(ECG_LIGNE ,' '),10), PIE_DATE =RPAD(NVL(PIE_DATE ,' '),8), DATEORIG =RPAD(NVL(DATEORIG ,' '),8), ORIGINE =RPAD(NVL(ORIGINE ,' '),20), LIBELLE =RPAD(NVL(LIBELLE ,' '),40), COL_CODEP =RPAD(NVL(COL_CODEP ,' '),3), TIE_CODEP =RPAD(NVL(TIE_CODEP ,' '),10), TIE_CODEPE =RPAD(NVL(TIE_CODEPE ,' '),10), TIE_CODER =RPAD(NVL(TIE_CODER ,' '),10), TIE_CODERE =RPAD(NVL(TIE_CODERE ,' '),10), MRG_CODE =RPAD(NVL(MRG_CODE ,' '),6), ECHEANCE =RPAD(NVL(ECHEANCE ,' '),8), DEV_CODE =RPAD(NVL(DEV_CODE ,' '),3), TAUX =RPAD(NVL(TAUX ,' '),16), STATUS =RPAD(NVL(STATUS ,' '),1), DOSSIER =RPAD(NVL(DOSSIER ,' '),10), MODULE =RPAD(NVL(MODULE ,' '),10), TYPE_TRAIT =RPAD(NVL(TYPE_TRAIT ,' '),1), GEN_CODE =RPAD(NVL(GEN_CODE ,' '),10), COLCODE =RPAD(NVL(COLCODE ,' '),3), TIE_CODE =RPAD(NVL(TIE_CODE ,' '),10), TIECODEEX =RPAD(NVL(TIECODEEX ,' '),10), A01_CODE =RPAD(NVL(A01_CODE ,' '),10), A02_CODE =RPAD(NVL(A02_CODE ,' '),10), A03_CODE =RPAD(NVL(A03_CODE ,' '),10), A04_CODE =RPAD(NVL(A04_CODE ,' '),10), A05_CODE =RPAD(NVL(A05_CODE ,' '),10), A06_CODE =RPAD(NVL(A06_CODE ,' '),10), A07_CODE =RPAD(NVL(A07_CODE ,' '),10), A08_CODE =RPAD(NVL(A08_CODE ,' '),10), A09_CODE =RPAD(NVL(A09_CODE ,' '),10), A10_CODE =RPAD(NVL(A10_CODE ,' '),10), A01_QTE =RPAD(NVL(A01_QTE ,' '),15), A02_QTE =RPAD(NVL(A02_QTE ,' '),15), A03_QTE =RPAD(NVL(A03_QTE ,' '),15), A04_QTE =RPAD(NVL(A04_QTE ,' '),15), A05_QTE =RPAD(NVL(A05_QTE ,' '),15), A06_QTE =RPAD(NVL(A06_QTE ,' '),15), A07_QTE =RPAD(NVL(A07_QTE ,' '),15), A08_QTE =RPAD(NVL(A08_QTE ,' '),15), A09_QTE =RPAD(NVL(A09_QTE ,' '),15), A10_QTE =RPAD(NVL(A10_QTE ,' '),15), DEBITPIE =RPAD(NVL(DEBITPIE ,' '),18), CREDITPIE =RPAD(NVL(CREDITPIE ,' '),18), DEBITETA =RPAD(NVL(DEBITETA ,' '),18), CREDITETA =RPAD(NVL(CREDITETA ,' '),18), DEBITSIE =RPAD(NVL(DEBITSIE ,' '),18), CREDITSIE =RPAD(NVL(CREDITSIE ,' '),18), DEBITEUR =RPAD(NVL(DEBITEUR ,' '),18), CREDITEUR =RPAD(NVL(CREDITEUR ,' '),18), LIBELLE01 =RPAD(NVL(LIBELLE01 ,' '),40), LIBELLE02 =RPAD(NVL(LIBELLE02 ,' '),40), LIBELLE01A =RPAD(NVL(LIBELLE01A ,' '),40), LIBELLE02A =RPAD(NVL(LIBELLE02A ,' '),40), TVA_CODE =RPAD(NVL(TVA_CODE ,' '),3), MTTVA =RPAD(NVL(MTTVA ,' '),18), FAITGEN =RPAD(NVL(FAITGEN ,' '),1), IMMO_BS =RPAD(NVL(IMMO_BS ,' '),1), RENT_CODE =RPAD(NVL(RENT_CODE ,' '),3), RETA_CODE =RPAD(NVL(RETA_CODE ,' '),3), RJOU_CODE =RPAD(NVL(RJOU_CODE ,' '),4), RANNEE =RPAD(NVL(RANNEE ,' '),4), RPERIODE =RPAD(NVL(RPERIODE ,' '),5), RPIECE =RPAD(NVL(RPIECE ,' '),10), RPIE_DATE =RPAD(NVL(RPIE_DATE ,' '),8), RMRG_CODE =RPAD(NVL(RMRG_CODE ,' '),6), RECHEANCE =RPAD(NVL(RECHEANCE ,' '),8), LETTRAGE =RPAD(NVL(LETTRAGE ,' '),3), ECH_LIGNE =RPAD(NVL(ECH_LIGNE ,' '),8), MDRE_LIGNE =RPAD(NVL(MDRE_LIGNE ,' '),6), BAP_LIGNE =RPAD(NVL(BAP_LIGNE ,' '),1), TYP_CONV =RPAD(NVL(TYP_CONV ,' '),1), ENTA01_CODE =RPAD(NVL(ENTA01_CODE ,' '),10), COMMANDE =RPAD(NVL(COMMANDE ,' '),15), FILESCAN =RPAD(NVL(FILESCAN ,' '),50); COMMIT; END; 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 2 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 2 0 Misses in library cache during parse: 1 Optimizer mode: RULE Parsing user id: 57 (GCOM) (recursive depth: 2) ******************************************************************************** SELECT start_time FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND duplicate = 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 1 0.00 0.00 0 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT COUNT(*) FROM sys.session_roles WHERE role = :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 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=2 pr=0 pw=0 time=310 us) 1 MERGE JOIN (cr=2 pr=0 pw=0 time=251 us) 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=58 us) 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=27 us)(object id 44) 1 FILTER (cr=0 pr=0 pw=0 time=55 us) 14 FIXED TABLE FULL X$KZSRO (cr=0 pr=0 pw=0 time=90 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 1 SORT (AGGREGATE) 1 MERGE JOIN 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'USER$' (CLUSTER) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'I_USER1' (INDEX (UNIQUE)) 1 FILTER 14 FIXED TABLE (FULL) OF 'X$KZSRO' (TABLE (FIXED)) ******************************************************************************** SELECT object_row, value_n, granules, original_object_schema, flags FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND duplicate = 0 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.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT BITAND(flags,:1)/:2, timezone FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :3 AND duplicate = 0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 6 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=3 pr=0 pw=0 time=248 us) 1 INDEX UNIQUE SCAN SYS_C0017208 (cr=2 pr=0 pw=0 time=219 us)(object id 52756) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** UPDATE "DATAPUMP"."SYS_IMPORT_SCHEMA_29" SET last_update = sysdate, object_number = :1, object_schema = :2,object_name = :3, object_long_name = :4, object_type_path = :5, partition_name = DECODE (partition_name, NULL, NULL, :6), subpartition_name = DECODE (subpartition_name, NULL, NULL, :7), total_bytes = :8, completed_rows = :9, metadata_io = :10, cumulative_time = :11, parallelization = :12 WHERE process_order = :13 AND duplicate = :14 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 1 5 7 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 1 5 7 2 Misses in library cache during parse: 2 Misses in library cache during execute: 2 Optimizer mode: CHOOSE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT MODE: CHOOSE 0 UPDATE OF 'SYS_IMPORT_SCHEMA_29' 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT db_version FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 and duplicate = 0 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.00 0.00 0 305 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 305 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT NVL((SELECT 1 FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND name = :2 AND value_n = 0 AND object_name IS NULL AND object_schema IS NULL), 0) FROM DUAL 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 4 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 6 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=2 pr=0 pw=0 time=38 us) 0 INDEX RANGE SCAN SYS_C0017208 (cr=2 pr=0 pw=0 time=24 us)(object id 52756) 1 FAST DUAL (cr=0 pr=0 pw=0 time=14 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) 1 FAST DUAL ******************************************************************************** SELECT UNIQUE object_type_path, object_path_seqno FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND object_type_path like :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 58 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 58 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT UNIQUE (cr=29 pr=0 pw=0 time=1028 us) 4 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=29 pr=0 pw=0 time=332 us) 1278 INDEX RANGE SCAN SYS_C0017208 (cr=6 pr=0 pw=0 time=5126 us)(object id 52756) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: CHOOSE 1 HASH (UNIQUE) 4 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 1278 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, grantor, object_row, object_schema, object_long_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, property, size_estimate, in_progress FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order between :3 AND :4 AND processing_state <> :5 AND duplicate = 0 ORDER BY process_order 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.00 0.00 0 3 0 9 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 9 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 9 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=3 pr=0 pw=0 time=157 us) 11 INDEX RANGE SCAN SYS_C0017208 (cr=2 pr=0 pw=0 time=71 us)(object id 52756) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 9 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 11 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** UPDATE "DATAPUMP"."SYS_IMPORT_SCHEMA_29" SET completed_rows = completed_rows + :1, object_type = :2, completion_time = sysdate WHERE process_order = :3 AND duplicate = :4 RETURNING start_time, completion_time INTO :5, :6 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 2 3 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 3 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE SYS_IMPORT_SCHEMA_29 (cr=2 pr=0 pw=0 time=194 us) 1 INDEX UNIQUE SCAN SYS_C0017208 (cr=2 pr=0 pw=0 time=20 us)(object id 52756) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT MODE: RULE 1 UPDATE OF 'SYS_IMPORT_SCHEMA_29' 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT state FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND duplicate = 0 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.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID SYS_IMPORT_SCHEMA_29 (cr=3 pr=0 pw=0 time=51 us) 1 INDEX UNIQUE SCAN SYS_C0017208 (cr=2 pr=0 pw=0 time=21 us)(object id 52756) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT connect_type, need_execute, parallel_load FROM DATAPUMP_OBJECT_CONNECT WHERE object_type = :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 1 0.00 0.00 3 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 3 3 0 1 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 VIEW DATAPUMP_OBJECT_CONNECT (cr=3 pr=3 pw=0 time=6217 us) 1 SORT UNIQUE (cr=3 pr=3 pw=0 time=6193 us) 1 TABLE ACCESS BY INDEX ROWID METAVIEW$ (cr=3 pr=3 pw=0 time=6134 us) 1 INDEX RANGE SCAN I_METAVIEW$ (cr=2 pr=2 pw=0 time=5128 us)(object id 488) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 1 VIEW OF 'DATAPUMP_OBJECT_CONNECT' (VIEW) 1 SORT (UNIQUE) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'METAVIEW$' (TABLE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_METAVIEW$' (INDEX (UNIQUE)) ******************************************************************************** SELECT NVL((SELECT 1 FROM sys.datapump_remap_objects WHERE param = :1 AND object_type = :2), 0) FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 2 6 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 2 6 0 3 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 INDEX UNIQUE SCAN I_METAXSLPARAM$ (cr=6 pr=2 pw=0 time=2108 us)(object id 493) 3 FAST DUAL (cr=0 pr=0 pw=0 time=41 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'I_METAXSLPARAM$' (INDEX (UNIQUE)) 3 FAST DUAL ******************************************************************************** UPDATE "DATAPUMP"."SYS_IMPORT_SCHEMA_29" SET packet_number = :1 WHERE process_order = :2 and duplicate = :3 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 2 3 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 3 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 57 (GCOM) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE SYS_IMPORT_SCHEMA_29 (cr=2 pr=0 pw=0 time=212 us) 1 INDEX UNIQUE SCAN SYS_C0017208 (cr=2 pr=0 pw=0 time=19 us)(object id 52756) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT MODE: RULE 1 UPDATE OF 'SYS_IMPORT_SCHEMA_29' 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** ROLLBACK 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 57 (GCOM) (recursive depth: 2) ******************************************************************************** SELECT NVL((SELECT 1 FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND rownum = 1), 0) FROM DUAL 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.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 COUNT (STOPKEY) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) 0 FAST DUAL ******************************************************************************** SELECT COUNT(*) FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND duplicate = 0 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 0 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 6 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 3) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 SORT (AGGREGATE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT block_size, data_buffer_size, metadata_buffer_size, guid, instance, flags, db_version FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = DECODE(:imp, 0, :po_expjob, 1, :po_impjob) 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 0 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 6 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 3) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT OBJECT_ID FROM ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJECT_TYPE = 'TABLE' 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 0 12 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 12 0 2 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 3) Rows Row Source Operation ------- --------------------------------------------------- 2 FILTER (cr=12 pr=0 pw=0 time=692 us) 2 FILTER (cr=10 pr=0 pw=0 time=398 us) 2 NESTED LOOPS (cr=10 pr=0 pw=0 time=308 us) 2 TABLE ACCESS BY INDEX ROWID USER$ (cr=4 pr=0 pw=0 time=143 us) 2 INDEX UNIQUE SCAN I_USER1 (cr=2 pr=0 pw=0 time=41 us)(object id 44) 2 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=6 pr=0 pw=0 time=139 us) 2 INDEX RANGE SCAN I_OBJ2 (cr=4 pr=0 pw=0 time=54 us)(object id 37) 0 TABLE ACCESS BY INDEX ROWID IND$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_IND1 (cr=0 pr=0 pw=0 time=0 us)(object id 39) 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=76 us) 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=63 us)(object id 103) 0 FIXED TABLE FULL X$KZSRO (cr=0 pr=0 pw=0 time=0 us) 1 FIXED TABLE FULL X$KZSPR (cr=0 pr=0 pw=0 time=89 us) 1 FIXED TABLE FULL X$KZSPR (cr=0 pr=0 pw=0 time=43 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 103) 0 FIXED TABLE FULL X$KZSRO (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 103) 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 HASH JOIN (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (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 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 103) 0 INDEX RANGE SCAN I_DEPENDENCY1 (cr=0 pr=0 pw=0 time=0 us)(object id 122) 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 HASH JOIN (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (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 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 103) 0 INDEX RANGE SCAN I_DEPENDENCY1 (cr=0 pr=0 pw=0 time=0 us)(object id 122) 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 FIXED TABLE FULL X$KZSPR (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 TRIGGER$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_TRIGGER2 (cr=0 pr=0 pw=0 time=0 us)(object id 126) 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=0 pr=0 pw=0 time=0 us)(object id 103) 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 FIXED TABLE FULL X$KZSPR (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 FIXED TABLE FULL X$KZSPR (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 FIXED TABLE FULL X$KZSPR (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 FIXED TABLE FULL X$KZSPR (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 FIXED TABLE FULL X$KZSPR (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 FIXED TABLE FULL X$KZSPR (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 FIXED TABLE FULL X$KZSPR (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 VIEW (cr=0 pr=0 pw=0 time=0 us) 0 FAST DUAL (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS BY INDEX ROWID SUM$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_SUM$_1 (cr=0 pr=0 pw=0 time=0 us)(object id 398) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 2 FILTER 2 FILTER 2 NESTED LOOPS 2 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'USER$' (CLUSTER) 2 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'I_USER1' (INDEX (UNIQUE)) 2 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'OBJ$' (TABLE) 2 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_OBJ2' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'IND$' (CLUSTER) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'I_IND1' (INDEX (UNIQUE)) 0 NESTED LOOPS 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_OBJAUTH1' (INDEX (UNIQUE)) 0 FIXED TABLE (FULL) OF 'X$KZSRO' (TABLE (FIXED)) 1 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 1 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 NESTED LOOPS 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_OBJAUTH1' (INDEX (UNIQUE)) 0 FIXED TABLE (FULL) OF 'X$KZSRO' (TABLE (FIXED)) 0 NESTED LOOPS 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_OBJAUTH1' (INDEX (UNIQUE)) 0 FIXED TABLE (FULL) OF 'X$KZSRO' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 HASH JOIN 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'DEPENDENCY$' (TABLE) 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'OBJ$' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_OBJ2' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_OBJAUTH1' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_DEPENDENCY1' (INDEX (UNIQUE)) 0 FIXED TABLE (FULL) OF 'X$KZSRO' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 HASH JOIN 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'DEPENDENCY$' (TABLE) 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'OBJ$' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_OBJ2' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_OBJAUTH1' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_DEPENDENCY1' (INDEX (UNIQUE)) 0 FIXED TABLE (FULL) OF 'X$KZSRO' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'TRIGGER$' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'I_TRIGGER2' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_OBJAUTH1' (INDEX (UNIQUE)) 0 FIXED TABLE (FULL) OF 'X$KZSRO' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 FIXED TABLE (FULL) OF 'X$KZSPR' (TABLE (FIXED)) 0 VIEW 0 FAST DUAL 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SUM$' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'I_SUM$_1' (INDEX (UNIQUE)) ******************************************************************************** SELECT MAX(duplicate) FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :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 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 SORT (AGGREGATE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** SELECT user_directory FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :1 AND duplicate = :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 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: RULE 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** UPDATE "DATAPUMP"."SYS_IMPORT_SCHEMA_29" SET completed_rows = NVL(:1, (SELECT NVL(SUM(completed_rows), 0) FROM "DATAPUMP"."SYS_IMPORT_SCHEMA_29" WHERE process_order = :2 AND duplicate != 0 AND flags = 1)) WHERE process_order = :3 AND duplicate = 0 RETURNING completed_rows INTO :4 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.01 300 613 4 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.01 300 613 4 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 55 (DATAPUMP) (recursive depth: 2) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT MODE: CHOOSE 0 UPDATE OF 'SYS_IMPORT_SCHEMA_29' 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) 0 SORT (AGGREGATE) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SYS_IMPORT_SCHEMA_29' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'SYS_C0017208' (INDEX (UNIQUE)) ******************************************************************************** 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 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 578 0.09 0.05 0 0 6 0 Execute 607 0.67 10.36 380 15213 19560 1306 Fetch 452 0.17 0.33 82 15177 0 948 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1637 0.93 10.75 462 30390 19566 2254 Misses in library cache during parse: 63 Misses in library cache during execute: 56 80 user SQL statements in session. 500 internal SQL statements in session. 580 SQL statements in session. 42 statements EXPLAINed in this session. ******************************************************************************** Trace file: D:\DATABASE\GPAO\bdump\gpao_dw01_2844.trc Trace file compatibility: 10.01.00 Sort options: execpu fchcpu 1 session in tracefile. 80 user SQL statements in trace file. 500 internal SQL statements in trace file. 580 SQL statements in trace file. 200 unique SQL statements in trace file. 42 SQL statements EXPLAINed using schema: DATAPUMP.prof$plan_table Default table was used. Table was created. Table was dropped. 5611 lines in trace file. 10 elapsed seconds in trace file.