TKPROF: Release 11.2.0.3.0 - Development on Fri Aug 9 22:52:50 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Trace file: /tmp/import.trc Sort options: default ******************************************************************************** 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 statements encountered a error during parse: ALTER SESSION SET TRACE OFF WAIT #14019091 Error encountered: ORA-02248 -------------------------------------------------------------------------------- ALTER SESSION SET TRACE=OFF WAIT #14019091 Error encountered: ORA-02248 -------------------------------------------------------------------------------- ALTER SESSION TRACE_ENABLED=FALSE WAIT #14019091 Error encountered: ORA-00922 -------------------------------------------------------------------------------- ALTER SESSION SET TRACE_ENABLED=FALSE WAIT #14019091 Error encountered: ORA-02096 -------------------------------------------------------------------------------- ALTER SESSION SET TRACE_ENABLED = FALSE WAIT #14019091 Error encountered: ORA-02096 -------------------------------------------------------------------------------- ALTER SESSION SET trace_enabled = FALSE WAIT #14019091 Error encountered: ORA-02096 ******************************************************************************** SQL ID: 9m7787camwh4m Plan Hash: 0 begin :id := sys.dbms_transaction.local_transaction_id; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 20 0.00 0.00 0 0 0 0 Execute 20 0.00 0.00 0 0 0 20 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 40 0.00 0.00 0 0 0 20 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 35 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 20 0.00 0.00 SQL*Net message from client 20 0.12 0.74 ******************************************************************************** begin sys.dbms_output.get_line(line => :line, status => :status); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 10 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 20 0.00 0.00 0 0 0 10 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 35 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 10 0.00 0.00 SQL*Net message from client 10 56.70 179.24 ******************************************************************************** SQL ID: cf06fwacdmgfk Plan Hash: 1388734953 select 'x' from dual call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.00 0 0 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 30 0.00 0.00 0 0 0 10 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 Number of plan statistics captured: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=2 us cost=2 size=0 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 24 0.00 0.00 SQL*Net message from client 24 1.89 6.95 SQL*Net break/reset to client 4 0.02 0.10 ******************************************************************************** begin if :enable = 0 then sys.dbms_output.disable; else sys.dbms_output.enable(:size); end if; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 9 0.00 0.00 0 0 0 0 Execute 9 0.00 0.00 0 0 0 9 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 0 0 9 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 35 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 9 0.00 0.00 SQL*Net message from client 9 0.23 1.75 ******************************************************************************** BEGIN copy_user.import_files(p_directory => 'FOR_TEST', p_use_jobs => FALSE); 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 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: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net break/reset to client 1 0.00 0.00 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 8.00 8.00 ******************************************************************************** SQL ID: 70uhjny9u33m7 Plan Hash: 330613147 SELECT * FROM USER_MIGRATION_LOG WHERE ACTION = :B1 AND BEGIN_TS IS 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 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS FULL USER_MIGRATION_LOG (cr=4 pr=0 pw=0 time=50 us cost=2 size=6092 card=1) ******************************************************************************** SQL ID: 5f2b1kj9h2xub Plan Hash: 92805317 SELECT OBJECT_ID FROM USER_OBJECTS WHERE OBJECT_NAME = UPPER(:B1 ) 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: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 VIEW USER_OBJECTS (cr=6 pr=0 pw=0 time=100 us cost=5 size=180 card=2) 1 1 1 UNION-ALL (cr=6 pr=0 pw=0 time=97 us) 0 0 0 TABLE ACCESS BY INDEX ROWID SUM$ (cr=0 pr=0 pw=0 time=0 us cost=0 size=26 card=1) 0 0 0 INDEX UNIQUE SCAN I_SUM$_1 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 956) 1 1 1 FILTER (cr=5 pr=0 pw=0 time=82 us) 1 1 1 FILTER (cr=5 pr=0 pw=0 time=80 us) 1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=74 us cost=4 size=98 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=0 pw=0 time=56 us cost=3 size=77 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ5 (cr=3 pr=0 pw=0 time=32 us cost=2 size=0 card=1)(object id 40) 1 1 1 INDEX RANGE SCAN I_USER2 (cr=1 pr=0 pw=0 time=14 us cost=1 size=21 card=1)(object id 47) 0 0 0 TABLE ACCESS BY INDEX ROWID IND$ (cr=0 pr=0 pw=0 time=0 us cost=2 size=8 card=1) 0 0 0 INDEX UNIQUE SCAN I_IND1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 41) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=2 size=28 card=1) 0 0 0 INDEX SKIP SCAN I_USER2 (cr=0 pr=0 pw=0 time=0 us cost=1 size=19 card=1)(object id 47) 0 0 0 INDEX RANGE SCAN I_OBJ4 (cr=0 pr=0 pw=0 time=0 us cost=1 size=9 card=1)(object id 39) 0 0 0 INDEX RANGE SCAN I_LINK1 (cr=1 pr=0 pw=0 time=7 us cost=1 size=79 card=1)(object id 137) ******************************************************************************** SQL ID: grwydz59pu6mc Plan Hash: 3684871272 select text from view$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 9 0.00 0.00 0 0 0 0 Execute 9 0.00 0.00 0 0 0 0 Fetch 9 0.00 0.00 0 18 0 9 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 27 0.00 0.00 0 18 0 9 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=10 us cost=1 size=15 card=1) ******************************************************************************** BEGIN copy_user.import_file(p_user_id => 3400, p_table_name => 'ACCOUNT_ORA_GTT', p_directory => 'FOR_TEST', p_parallel => NULL); 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 1 1 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 1 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ utl_file I/O 6 0.00 0.00 ******************************************************************************** SQL ID: g0gzd1b4xjuwu Plan Hash: 434646221 UPDATE USER_MIGRATION_LOG SET BEGIN_TS = SYSTIMESTAMP WHERE USER_ID = :B3 AND TABLE_NAME = :B2 AND ACTION = :B1 AND BEGIN_TS IS 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 131 4 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 131 4 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE USER_MIGRATION_LOG (cr=131 pr=0 pw=0 time=1696 us) 1 1 1 TABLE ACCESS FULL USER_MIGRATION_LOG (cr=131 pr=0 pw=0 time=1442 us cost=2 size=60 card=1) ******************************************************************************** SQL ID: 8ggw94h7mvxd7 Plan Hash: 0 COMMIT 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 1 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 1 0 Misses in library cache during parse: 0 Parsing user id: 35 (recursive depth: 2) ******************************************************************************** SQL ID: 3yjt74r87mxqy Plan Hash: 1922127190 SELECT MAX(TABLE_NAME) FROM USER_TABLES WHERE TABLE_NAME = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.01 0 0 0 0 Fetch 1 0.00 0.00 0 14 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 0 14 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=14 pr=0 pw=0 time=3836 us) 1 1 1 NESTED LOOPS OUTER (cr=14 pr=0 pw=0 time=3808 us cost=9 size=156 card=1) 1 1 1 NESTED LOOPS OUTER (cr=14 pr=0 pw=0 time=3803 us cost=8 size=153 card=1) 1 1 1 NESTED LOOPS OUTER (cr=12 pr=0 pw=0 time=3790 us cost=7 size=145 card=1) 1 1 1 NESTED LOOPS OUTER (cr=12 pr=0 pw=0 time=3787 us cost=6 size=140 card=1) 1 1 1 NESTED LOOPS (cr=9 pr=0 pw=0 time=3764 us cost=5 size=129 card=1) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=3755 us cost=4 size=126 card=1) 1 1 1 MERGE JOIN CARTESIAN (cr=4 pr=0 pw=0 time=3722 us cost=3 size=98 card=1) 1 1 1 HASH JOIN (cr=0 pr=0 pw=0 time=3676 us cost=1 size=68 card=1) 1 1 1 FIXED TABLE FULL X$KSPPI (cr=0 pr=0 pw=0 time=1453 us cost=0 size=55 card=1) 2752 2752 2752 FIXED TABLE FULL X$KSPPCV (cr=0 pr=0 pw=0 time=1757 us cost=0 size=1300 card=100) 1 1 1 BUFFER SORT (cr=4 pr=0 pw=0 time=42 us cost=3 size=30 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=0 pw=0 time=23 us cost=2 size=30 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=18 us cost=1 size=0 card=1)(object id 37) 1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=32 us cost=1 size=28 card=1) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=10 us cost=0 size=0 card=1)(object id 3) 1 1 1 TABLE ACCESS CLUSTER TS$ (cr=2 pr=0 pw=0 time=8 us cost=1 size=3 card=1) 1 1 1 INDEX UNIQUE SCAN I_TS# (cr=1 pr=0 pw=0 time=3 us cost=0 size=0 card=1)(object id 7) 1 1 1 TABLE ACCESS CLUSTER SEG$ (cr=3 pr=0 pw=0 time=17 us cost=1 size=11 card=1) 1 1 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=0 pw=0 time=8 us cost=0 size=0 card=1)(object id 9) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=1 us cost=1 size=5 card=1)(object id 36) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=12 us cost=1 size=8 card=1)(object id 36) 0 0 0 INDEX RANGE SCAN I_USER2 (cr=0 pr=0 pw=0 time=1 us cost=1 size=3 card=1)(object id 47) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ asynch descriptor resize 1 0.00 0.00 ******************************************************************************** SQL ID: 1v717nvrhgbn9 Plan Hash: 1388734953 SELECT USER FROM SYS.DUAL 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 0 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 0 0 2 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1) ******************************************************************************** SELECT u7.column_name remote_column_name, data_type || CASE WHEN data_type IN ('VARCHAR2') THEN '(' || data_length || ')' END data_type, u.column_name local_column_name FROM (SELECT COLUMN_VALUE column_name, ROWNUM column_id FROM TABLE(varchar2_array('PARTITION_DATE','USER_ID','ACCOUNT_ID','SID','IMPS','CLICKS','TOTAL_COST'))) u7 FULL JOIN (SELECT column_name, column_id, data_type, data_length FROM user_tab_cols WHERE table_name = UPPER(:table_name) AND column_id IS NOT NULL AND virtual_column = 'NO' AND hidden_column = 'NO') u ON u.column_name = u7.column_name ORDER BY nvl(u7.column_id, u.column_id) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.02 0 0 0 0 Fetch 1 0.00 0.00 0 40 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.03 0.02 0 40 0 7 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=3 size=24 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 36) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=3 size=24 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 36) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=3 size=24 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 36) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=3 size=24 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 36) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=3 size=24 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 36) 7 7 7 SORT ORDER BY (cr=40 pr=0 pw=0 time=1175 us cost=4561 size=34575019 card=16363) 7 7 7 VIEW VW_FOJ_0 (cr=40 pr=0 pw=0 time=1130 us cost=50 size=34575019 card=16363) 7 7 7 HASH JOIN FULL OUTER (cr=40 pr=0 pw=0 time=1129 us cost=50 size=34493204 card=16363) 7 7 7 VIEW (cr=40 pr=0 pw=0 time=319 us cost=10 size=93 card=1) 7 7 7 FILTER (cr=40 pr=0 pw=0 time=305 us) 7 7 7 NESTED LOOPS OUTER (cr=37 pr=0 pw=0 time=236 us cost=10 size=169 card=1) 7 7 7 NESTED LOOPS (cr=37 pr=0 pw=0 time=223 us cost=9 size=166 card=1) 7 7 7 NESTED LOOPS OUTER (cr=34 pr=0 pw=0 time=196 us cost=8 size=145 card=1) 7 7 7 NESTED LOOPS OUTER (cr=21 pr=0 pw=0 time=100 us cost=7 size=137 card=1) 7 7 7 NESTED LOOPS OUTER (cr=21 pr=0 pw=0 time=86 us cost=5 size=107 card=1) 7 7 7 NESTED LOOPS (cr=7 pr=0 pw=0 time=47 us cost=4 size=79 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=0 pw=0 time=19 us cost=3 size=37 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ5 (cr=3 pr=0 pw=0 time=14 us cost=2 size=0 card=1)(object id 40) 7 7 7 TABLE ACCESS CLUSTER COL$ (cr=3 pr=0 pw=0 time=23 us cost=1 size=42 card=1) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=3 us cost=0 size=0 card=1)(object id 3) 0 0 0 TABLE ACCESS CLUSTER COLTYPE$ (cr=14 pr=0 pw=0 time=35 us cost=1 size=28 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=7 us cost=2 size=30 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ3 (cr=0 pr=0 pw=0 time=3 us cost=1 size=0 card=1)(object id 38) 0 0 0 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=13 pr=0 pw=0 time=37 us cost=1 size=8 card=1)(object id 426) 7 7 7 INDEX RANGE SCAN I_USER2 (cr=3 pr=0 pw=0 time=15 us cost=1 size=21 card=1)(object id 47) 0 0 0 INDEX RANGE SCAN I_USER2 (cr=0 pr=0 pw=0 time=3 us cost=1 size=3 card=1)(object id 47) 0 0 0 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=11 us cost=2 size=12 card=1) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=4 us cost=1 size=0 card=1)(object id 3) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=2 size=28 card=1) 0 0 0 INDEX SKIP SCAN I_USER2 (cr=0 pr=0 pw=0 time=0 us cost=1 size=19 card=1)(object id 47) 0 0 0 INDEX RANGE SCAN I_OBJ4 (cr=0 pr=0 pw=0 time=0 us cost=1 size=9 card=1)(object id 39) 7 7 7 VIEW (cr=0 pr=0 pw=0 time=23 us cost=39 size=32965400 card=16360) 7 7 7 COUNT (cr=0 pr=0 pw=0 time=15 us) 7 7 7 COLLECTION ITERATOR CONSTRUCTOR FETCH (cr=0 pr=0 pw=0 time=13 us cost=39 size=32720 card=16360) ******************************************************************************** SQL ID: cb21bacyh3c7d Plan Hash: 3452538079 select metadata from kopm$ where name='DB_FDO' 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: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID KOPM$ (cr=2 pr=0 pw=0 time=14 us cost=1 size=108 card=1) 1 1 1 INDEX UNIQUE SCAN I_KOPM1 (cr=1 pr=0 pw=0 time=6 us cost=0 size=0 card=1)(object id 553) ******************************************************************************** SQL ID: 3nkd3g3ju5ph1 Plan Hash: 2853959010 select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 13 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 13 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=0 pw=0 time=13 us cost=3 size=77 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=9 us cost=2 size=0 card=1)(object id 37) ******************************************************************************** SELECT NVL(MAX(1), 0) FROM ACCOUNT_ORA_GTT t WHERE USER_ID = 3400 AND rownum = 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 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=3 pr=0 pw=0 time=19 us) 0 0 0 COUNT STOPKEY (cr=3 pr=0 pw=0 time=16 us) 0 0 0 TABLE ACCESS FULL ACCOUNT_ORA_GTT (cr=3 pr=0 pw=0 time=14 us cost=2 size=26 card=2) ******************************************************************************** SQL ID: fcnkt7c1mh2xv Plan Hash: 3565207118 SELECT 1 FROM USER_EXTERNAL_TABLES T WHERE T.TABLE_NAME = UPPER(:B1 ) 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 128 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 128 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=128 pr=0 pw=0 time=1428 us) 439 439 439 NESTED LOOPS (cr=100 pr=0 pw=0 time=1454 us cost=1 size=40 card=1) 442 442 442 INDEX FULL SCAN I_EXTERNAL_TAB1$ (cr=1 pr=0 pw=0 time=9 us cost=0 size=13 card=1)(object id 1040) 439 439 439 INDEX RANGE SCAN I_OBJ1 (cr=99 pr=0 pw=0 time=851 us cost=1 size=0 card=1)(object id 36) 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=28 pr=0 pw=0 time=323 us cost=1 size=27 card=1) ******************************************************************************** SQL ID: 66m94g5tnbwgr Plan Hash: 0 DROP TABLE IMP_3251037_3400 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.01 0 0 2 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.01 0 0 2 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 2) ******************************************************************************** SQL ID: 8w4c8u9udsuyy Plan Hash: 4268705711 select count(*) from ( select u.name from registry$ r, user$ u where r.status in (1,3,5) and r.namespace = 'SERVER' and r.schema# = u.user# and u.name = :1 union all select u.name from registry$ r, registry$schemas s, user$ u where r.status in (1,3,5) and r.namespace = 'SERVER' and r.cid = s.cid and s.schema# = u.user# and u.name = :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 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 7 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=7 pr=0 pw=0 time=53 us) 0 0 0 VIEW (cr=7 pr=0 pw=0 time=50 us cost=6 size=0 card=4) 0 0 0 UNION-ALL (cr=7 pr=0 pw=0 time=49 us) 0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=31 us cost=3 size=93 card=3) 1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=9 us cost=1 size=19 card=1) 1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=5 us cost=0 size=0 card=1)(object id 46) 0 0 0 TABLE ACCESS FULL REGISTRY$ (cr=2 pr=0 pw=0 time=19 us cost=2 size=36 card=3) 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=14 us) 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=14 us cost=3 size=47 card=1) 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=14 us cost=2 size=30 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=6 us cost=1 size=19 card=1) 1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=2 us cost=0 size=0 card=1)(object id 46) 0 0 0 INDEX FULL SCAN REGISTRY_SCHEMA_PK (cr=1 pr=0 pw=0 time=8 us cost=1 size=11 card=1)(object id 1226) 0 0 0 INDEX UNIQUE SCAN REGISTRY_PK (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 1224) 0 0 0 TABLE ACCESS BY INDEX ROWID REGISTRY$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=17 card=1) ******************************************************************************** SQL ID: a9u0s3g93f47z Plan Hash: 515562855 select decode(u.type#, 2, u.ext_username, u.name), o.name, t.update$, t.insert$, t.delete$, t.enabled, decode(bitand(t.property, 8192), 8192, 1, 0), decode(bitand(t.property, 65536), 65536, 1, 0), decode(bitand(t.property, 131072), 131072, 1, 0), (select o.name from obj$ o where o.obj# = u.spare2 and o.type# =57) from sys.obj$ o, sys.user$ u, sys.trigger$ t, sys.obj$ bo where t.baseobject=bo.obj# and bo.name = :1 and bo.spare3 = :2 and bo.namespace = 1 and t.obj#=o.obj# and o.owner#=u.user# and o.type# = 12 and bitand(property,16)=0 and bitand(property,8)=0 order by o.obj# 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 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=3 size=28 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 36) 0 0 0 SORT ORDER BY (cr=4 pr=0 pw=0 time=179 us cost=7 size=177 card=1) 0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=172 us cost=6 size=177 card=1) 0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=171 us cost=5 size=85 card=1) 0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=170 us cost=3 size=54 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ5 (cr=3 pr=0 pw=0 time=14 us cost=2 size=30 card=1)(object id 40) 0 0 0 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=1 pr=0 pw=0 time=155 us cost=1 size=48 card=2) 0 0 0 INDEX RANGE SCAN I_TRIGGER1 (cr=1 pr=0 pw=0 time=152 us cost=0 size=0 card=2)(object id 161) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=2 size=31 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 36) 0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=92 card=1) 0 0 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 11) ******************************************************************************** SQL ID: 9gkq7rruycsjp Plan Hash: 3362549386 select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags, mod(spare3, 256) interval_dty, rowid, defmaxsize from partobj$ where obj# = :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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID PARTOBJ$ (cr=1 pr=0 pw=0 time=7 us cost=1 size=44 card=1) 0 0 0 INDEX UNIQUE SCAN I_PARTOBJ$ (cr=1 pr=0 pw=0 time=6 us cost=0 size=0 card=1)(object id 573) ******************************************************************************** SQL ID: cby6bd1gwb17f Plan Hash: 6194948 select FLAGS from SYS_FBA_TRACKEDTABLES where OBJ# = 3566059 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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID SYS_FBA_TRACKEDTABLES (cr=1 pr=0 pw=0 time=6 us cost=1 size=7 card=1) 0 0 0 INDEX UNIQUE SCAN SYS_C001432 (cr=1 pr=0 pw=0 time=4 us cost=0 size=0 card=1)(object id 1214) ******************************************************************************** SQL ID: 0a7q9v9nd2qc1 Plan Hash: 3747789477 select count(*) from association$ where obj# = :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 1 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=1 pr=0 pw=0 time=12 us) 0 0 0 INDEX RANGE SCAN ASSOC1 (cr=1 pr=0 pw=0 time=7 us cost=0 size=13 card=1)(object id 440) ******************************************************************************** SQL ID: ck9067jjt5ht5 Plan Hash: 4286179339 select intcol# from ustats$ where obj# = :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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 INDEX RANGE SCAN USTATS1 (cr=1 pr=0 pw=0 time=8 us cost=0 size=26 card=1)(object id 443) ******************************************************************************** SQL ID: 7frp5qgh6jpjn Plan Hash: 3574499837 SELECT redef_id FROM sys.redef_object$ WHERE obj_type = :1 AND ((obj_owner = :2 AND obj_name = :3) OR (int_obj_owner = :2 AND int_obj_name = :3)) AND rownum = 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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 COUNT STOPKEY (cr=1 pr=0 pw=0 time=16 us) 0 0 0 TABLE ACCESS BY INDEX ROWID REDEF_OBJECT$ (cr=1 pr=0 pw=0 time=14 us cost=1 size=94 card=1) 0 0 0 INDEX SKIP SCAN I_REDEF_OBJECT$ (cr=1 pr=0 pw=0 time=12 us cost=1 size=0 card=1)(object id 810) ******************************************************************************** SQL ID: 6aj9g0vnstbq8 Plan Hash: 793903315 delete from object_usage where obj# in (select a.obj# from object_usage a, ind$ b where a.obj# = b.obj# and b.bo# = :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 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE OBJECT_USAGE (cr=1 pr=0 pw=0 time=43 us) 0 0 0 HASH JOIN SEMI (cr=1 pr=0 pw=0 time=39 us cost=1 size=26 card=1) 0 0 0 INDEX FULL SCAN I_STATS_OBJ# (cr=1 pr=0 pw=0 time=7 us cost=0 size=13 card=1)(object id 219) 0 0 0 VIEW VW_NSO_1 (cr=0 pr=0 pw=0 time=0 us cost=0 size=13 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=0 size=23 card=1) 0 0 0 INDEX FULL SCAN I_STATS_OBJ# (cr=0 pr=0 pw=0 time=0 us cost=0 size=13 card=1)(object id 219) 0 0 0 INDEX UNIQUE SCAN I_IND1 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 41) 0 0 0 TABLE ACCESS BY INDEX ROWID IND$ (cr=0 pr=0 pw=0 time=0 us cost=0 size=10 card=1) ******************************************************************************** SQL ID: a8qprtnrvn836 Plan Hash: 2295705027 select c.owner#,c.name,c.con# from con$ c,cdef$ d where d.obj#=:1 and d.con#=c.con# 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=10 us) 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=10 us cost=5 size=120 card=4) 0 0 0 TABLE ACCESS CLUSTER CDEF$ (cr=2 pr=0 pw=0 time=9 us cost=1 size=36 card=4) 0 0 0 INDEX UNIQUE SCAN I_COBJ# (cr=2 pr=0 pw=0 time=8 us cost=0 size=0 card=1)(object id 30) 0 0 0 INDEX UNIQUE SCAN I_CON2 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 52) 0 0 0 TABLE ACCESS BY INDEX ROWID CON$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=21 card=1) ******************************************************************************** SQL ID: 28kp9tmbfdqba Plan Hash: 4020275457 delete com$ where obj#=: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 2 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE COM$ (cr=2 pr=0 pw=0 time=12 us) 0 0 0 INDEX RANGE SCAN I_COM1 (cr=2 pr=0 pw=0 time=10 us cost=2 size=72 card=9)(object id 138) ******************************************************************************** SQL ID: as3uq6ggb3gx6 Plan Hash: 3379420282 delete from hist_head$ where obj# = :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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE HIST_HEAD$ (cr=3 pr=0 pw=0 time=102 us) 0 0 0 INDEX RANGE SCAN I_HH_OBJ#_COL# (cr=3 pr=0 pw=0 time=101 us cost=2 size=121 card=11)(object id 425) ******************************************************************************** SQL ID: 74anujtt8zw4h Plan Hash: 3014793611 select o.owner#, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property,0), o.type#, o.subname, d.d_attrs from dependency$ d, obj$ o where d.p_obj#=:1 and (d.p_timestamp=nvl(:2, d.p_timestamp) or d.property=2) and o.owner#=nvl(:3,o.owner#) and d.d_obj#=o.obj# order by o.obj# 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 SORT ORDER BY (cr=2 pr=0 pw=0 time=101 us cost=17 size=284 card=4) 0 0 0 CONCATENATION (cr=2 pr=0 pw=0 time=17 us) 0 0 0 FILTER (cr=2 pr=0 pw=0 time=14 us) 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=13 us) 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=12 us cost=8 size=142 card=2) 0 0 0 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (cr=2 pr=0 pw=0 time=11 us cost=4 size=70 card=2) 0 0 0 INDEX RANGE SCAN I_DEPENDENCY2 (cr=2 pr=0 pw=0 time=11 us cost=2 size=0 card=4)(object id 107) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 36) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=2 size=36 card=1) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=8 size=142 card=2) 0 0 0 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (cr=0 pr=0 pw=0 time=0 us cost=4 size=70 card=2) 0 0 0 INDEX RANGE SCAN I_DEPENDENCY2 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=4)(object id 107) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 36) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=2 size=36 card=1) ******************************************************************************** SQL ID: 1gfaj4z5hn1kf Plan Hash: 0 delete from dependency$ where d_obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 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 1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) ******************************************************************************** SQL ID: 5t480bb4uh8hw Plan Hash: 0 delete from source$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 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 1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) ******************************************************************************** SQL ID: dadv22a1xru1y Plan Hash: 1000871750 delete from compression$ where obj#=: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 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE COMPRESSION$ (cr=1 pr=0 pw=0 time=7 us) 0 0 0 INDEX RANGE SCAN I_COMPRESSION1 (cr=1 pr=0 pw=0 time=7 us cost=0 size=35 card=1)(object id 184) ******************************************************************************** SQL ID: 4308cqrzmnd79 Plan Hash: 2970138452 select nvl(spare3,0), property, flags, nvl(spare5,'NN0') from tab$ where obj# = :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: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=20 us cost=2 size=130 card=1) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=9 us cost=1 size=0 card=1)(object id 3) ******************************************************************************** SQL ID: awv6c9bw059s7 Plan Hash: 1126510831 select 1 from sys.streams$_prepare_object po, sys.obj$ o where po.obj#= :1 and po.obj#= o.obj# and bitand(o.flags,128) = 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 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 MERGE JOIN CARTESIAN (cr=1 pr=0 pw=0 time=8 us cost=2 size=21 card=1) 0 0 0 INDEX RANGE SCAN I_STREAMS_PREPARE1 (cr=1 pr=0 pw=0 time=7 us cost=0 size=13 card=1)(object id 715) 0 0 0 BUFFER SORT (cr=0 pr=0 pw=0 time=0 us cost=2 size=8 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=2 size=8 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 36) ******************************************************************************** SQL ID: gv8qpm1gz3gcm Plan Hash: 2024304382 select o.name, u.name from sys.obj$ o, sys.user$ u where u.user#=o.owner# and o.obj# = :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 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 5 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=26 us cost=4 size=46 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 pr=0 pw=0 time=12 us cost=3 size=27 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=10 us cost=2 size=0 card=1)(object id 36) 1 1 1 TABLE ACCESS CLUSTER USER$ (cr=2 pr=0 pw=0 time=10 us cost=1 size=19 card=1) 1 1 1 INDEX UNIQUE SCAN I_USER# (cr=1 pr=0 pw=0 time=4 us cost=0 size=0 card=1)(object id 11) ******************************************************************************** SQL ID: cjaa80k1hvpc1 Plan Hash: 626680409 select 1 from sys.cdc_change_tables$ where source_schema_name = :1 and source_table_name = :2 and bitand(mvl_flag, 128)=128 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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS FULL CDC_CHANGE_TABLES$ (cr=1 pr=0 pw=0 time=13 us cost=2 size=47 card=1) ******************************************************************************** SQL ID: atqqshdutvcz7 Plan Hash: 3625463896 select master from sys.mlog$ where master = :2 and mowner = :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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS CLUSTER MLOG$ (cr=1 pr=0 pw=0 time=5 us cost=0 size=34 card=1) 0 0 0 INDEX UNIQUE SCAN I_MLOG# (cr=1 pr=0 pw=0 time=5 us cost=0 size=0 card=1)(object id 634) ******************************************************************************** SQL ID: c68zcykp5x303 Plan Hash: 4164700817 DELETE FROM sys.sumdelta$ sd WHERE sd.tableobj# = :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 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE SUMDELTA$ (cr=1 pr=0 pw=0 time=8 us) 0 0 0 INDEX RANGE SCAN I_SUMDELTA$ (cr=1 pr=0 pw=0 time=7 us)(object id 628) ******************************************************************************** SQL ID: ab69tffpad6w2 Plan Hash: 3773292461 DELETE FROM sys.sumpartlog$ sp WHERE sp.bo# = :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 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE SUMPARTLOG$ (cr=1 pr=0 pw=0 time=9 us) 0 0 0 INDEX RANGE SCAN I_SUMPARTLOG$ (cr=1 pr=0 pw=0 time=8 us cost=0 size=39 card=1)(object id 625) ******************************************************************************** SQL ID: cgh0uha8d3386 Plan Hash: 3250312342 DELETE FROM sys.snap_loadertime$ sd WHERE sd.tableobj# = :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 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE SNAP_LOADERTIME$ (cr=1 pr=0 pw=0 time=5 us) 0 0 0 INDEX UNIQUE SCAN I_SNAP_LOADERTIME1 (cr=1 pr=0 pw=0 time=5 us cost=0 size=13 card=1)(object id 632) ******************************************************************************** SQL ID: 03tuga43v3xkg Plan Hash: 0 BEGIN aw_drop_proc(ora_dict_obj_type, ora_dict_obj_name, ora_dict_obj_owner) ; 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 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 3) ******************************************************************************** SQL ID: 33cmj01uf5zfb Plan Hash: 1332168437 delete from col$ where obj#=:1 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 4 50 7 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 50 7 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE COL$ (cr=2 pr=0 pw=0 time=2445 us) 7 7 7 INDEX RANGE SCAN I_COL1 (cr=2 pr=0 pw=0 time=21 us cost=2 size=288 card=12)(object id 48) ******************************************************************************** SQL ID: 7x55strr8u10b Plan Hash: 619949725 delete from icol$ where bo#=: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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE ICOL$ (cr=3 pr=0 pw=0 time=12 us) 0 0 0 TABLE ACCESS CLUSTER ICOL$ (cr=3 pr=0 pw=0 time=11 us cost=2 size=30 card=3) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=5 us cost=1 size=0 card=1)(object id 3) ******************************************************************************** SQL ID: 7b9wk23u2x3yg Plan Hash: 2778939878 delete from icoldep$ where obj# in (select obj# from ind$ where bo#=: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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE ICOLDEP$ (cr=3 pr=0 pw=0 time=14 us) 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=13 us cost=2 size=28 card=2) 0 0 0 TABLE ACCESS CLUSTER IND$ (cr=3 pr=0 pw=0 time=12 us cost=2 size=20 card=2) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=6 us cost=1 size=0 card=1)(object id 3) 0 0 0 INDEX RANGE SCAN I_ICOLDEP$_OBJ (cr=0 pr=0 pw=0 time=0 us cost=0 size=8 card=2)(object id 115) ******************************************************************************** SQL ID: g2s1gpvyan3cj Plan Hash: 3684188268 delete from jijoin$ where obj# in ( select obj# from jijoin$ where tab1obj# = :1 or tab2obj# = :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 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE JIJOIN$ (cr=1 pr=0 pw=0 time=38 us) 0 0 0 HASH JOIN SEMI (cr=1 pr=0 pw=0 time=36 us cost=1 size=78 card=1) 0 0 0 INDEX FULL SCAN I_JIJOIN$ (cr=1 pr=0 pw=0 time=7 us cost=0 size=65 card=1)(object id 151) 0 0 0 VIEW VW_NSO_1 (cr=0 pr=0 pw=0 time=0 us cost=0 size=26 card=2) 0 0 0 CONCATENATION (cr=0 pr=0 pw=0 time=0 us) 0 0 0 TABLE ACCESS BY INDEX ROWID JIJOIN$ (cr=0 pr=0 pw=0 time=0 us cost=0 size=39 card=1) 0 0 0 INDEX RANGE SCAN I3_JIJOIN$ (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 153) 0 0 0 TABLE ACCESS BY INDEX ROWID JIJOIN$ (cr=0 pr=0 pw=0 time=0 us cost=0 size=39 card=1) 0 0 0 INDEX RANGE SCAN I2_JIJOIN$ (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 152) ******************************************************************************** SQL ID: fndr8b2vxtvfr Plan Hash: 2641771672 delete from jirefreshsql$ where iobj# in ( select iobj# from jirefreshsql$ where tobj# = :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 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE JIREFRESHSQL$ (cr=1 pr=0 pw=0 time=9 us) 0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=7 us) 0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=7 us cost=0 size=52 card=1) 0 0 0 INDEX FULL SCAN I1_JIREFRESHSQL$ (cr=1 pr=0 pw=0 time=6 us cost=0 size=26 card=1)(object id 157) 0 0 0 INDEX RANGE SCAN I2_JIREFRESHSQL$ (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 158) 0 0 0 TABLE ACCESS BY INDEX ROWID JIREFRESHSQL$ (cr=0 pr=0 pw=0 time=0 us cost=0 size=26 card=1) ******************************************************************************** SQL ID: a44jdqsy96zpc Plan Hash: 3878043462 delete from ccol$ where obj#=: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 2 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE CCOL$ (cr=2 pr=0 pw=0 time=6 us) 0 0 0 TABLE ACCESS CLUSTER CCOL$ (cr=2 pr=0 pw=0 time=6 us cost=1 size=80 card=5) 0 0 0 INDEX UNIQUE SCAN I_COBJ# (cr=2 pr=0 pw=0 time=4 us cost=0 size=0 card=1)(object id 30) ******************************************************************************** SQL ID: 5n0t3uxw307bd Plan Hash: 3511996411 delete from ind$ where bo#=: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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE IND$ (cr=3 pr=0 pw=0 time=12 us) 0 0 0 TABLE ACCESS CLUSTER IND$ (cr=3 pr=0 pw=0 time=11 us cost=2 size=20 card=2) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=6 us cost=1 size=0 card=1)(object id 3) ******************************************************************************** SQL ID: 2wdrw5tqputaq Plan Hash: 2991353695 delete from cdef$ where obj#=: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 4 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 4 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE CDEF$ (cr=2 pr=0 pw=0 time=46 us) 0 0 0 INDEX RANGE SCAN I_CDEF2 (cr=2 pr=0 pw=0 time=46 us cost=1 size=60 card=4)(object id 54) ******************************************************************************** SQL ID: gawwr67493r4z Plan Hash: 2559922080 delete ecol$ where tabobj# = :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 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE ECOL$ (cr=1 pr=0 pw=0 time=8 us) 0 0 0 INDEX RANGE SCAN ECOL_IX1 (cr=1 pr=0 pw=0 time=7 us cost=0 size=26 card=1)(object id 126) ******************************************************************************** SQL ID: gjmsb4xv4zsux Plan Hash: 1862499086 delete external_location$ where obj#=: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 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: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE EXTERNAL_LOCATION$ (cr=1 pr=0 pw=0 time=168 us) 1 1 1 INDEX RANGE SCAN I_EXTERNAL_LOCATION1$ (cr=1 pr=0 pw=0 time=8 us cost=0 size=26 card=1)(object id 1042) ******************************************************************************** SQL ID: ffct6k03881gn Plan Hash: 2554317398 delete external_tab$ where obj#=: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 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: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE EXTERNAL_TAB$ (cr=1 pr=0 pw=0 time=142 us) 1 1 1 INDEX UNIQUE SCAN I_EXTERNAL_TAB1$ (cr=1 pr=0 pw=0 time=4 us cost=0 size=13 card=1)(object id 1040) ******************************************************************************** SQL ID: b62q7nc33gzwx Plan Hash: 2015032476 delete from tab$ where obj#=: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 3 1 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 1 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE TAB$ (cr=3 pr=0 pw=0 time=112 us) 1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=14 us cost=2 size=7 card=1) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=6 us cost=1 size=0 card=1)(object id 3) ******************************************************************************** SQL ID: gsqxm6zz3w2by Plan Hash: 1314400858 delete from idl_ub1$ where obj#=:1 and part=: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 6 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 6 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE IDL_UB1$ (cr=2 pr=0 pw=0 time=10 us) 0 0 0 INDEX RANGE SCAN I_IDL_UB11 (cr=2 pr=0 pw=0 time=8 us cost=2 size=38 card=2)(object id 235) ******************************************************************************** SQL ID: d5jd9b2xct7xz Plan Hash: 2807568952 delete from idl_char$ where obj#=:1 and part=: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 6 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 6 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE IDL_CHAR$ (cr=2 pr=0 pw=0 time=9 us) 0 0 0 INDEX RANGE SCAN I_IDL_CHAR1 (cr=2 pr=0 pw=0 time=8 us cost=2 size=17 card=1)(object id 236) ******************************************************************************** SQL ID: 9y7s2afnkqs9d Plan Hash: 2238151678 delete from idl_ub2$ where obj#=:1 and part=: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 6 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 6 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE IDL_UB2$ (cr=2 pr=0 pw=0 time=9 us) 0 0 0 INDEX RANGE SCAN I_IDL_UB21 (cr=2 pr=0 pw=0 time=7 us cost=2 size=34 card=2)(object id 237) ******************************************************************************** SQL ID: dvpfc386d6dmm Plan Hash: 1017615457 delete from idl_sb4$ where obj#=:1 and part=: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 6 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 6 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE IDL_SB4$ (cr=2 pr=0 pw=0 time=32 us) 0 0 0 INDEX RANGE SCAN I_IDL_SB41 (cr=2 pr=0 pw=0 time=32 us cost=2 size=18 card=1)(object id 238) ******************************************************************************** SQL ID: gdhz78y24tvnz Plan Hash: 3403092214 delete from ncomp_dll$ where obj#=:1 returning dllname into :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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 3 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 DELETE NCOMP_DLL$ (cr=1 pr=0 pw=0 time=7 us) 1 1 1 INDEX RANGE SCAN I_NCOMP_DLL1 (cr=1 pr=0 pw=0 time=7 us cost=0 size=540 card=1)(object id 244) ******************************************************************************** SQL ID: d3awq1p0f84rc Plan Hash: 3466459821 delete coltype$ where obj#=: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 2 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE COLTYPE$ (cr=2 pr=0 pw=0 time=11 us) 0 0 0 INDEX RANGE SCAN I_COLTYPE1 (cr=2 pr=0 pw=0 time=11 us cost=2 size=48 card=4)(object id 84) ******************************************************************************** SQL ID: 2cngw9d1r43cd Plan Hash: 298860934 delete from subcoltype$ where obj#=: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 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE SUBCOLTYPE$ (cr=1 pr=0 pw=0 time=9 us) 0 0 0 INDEX RANGE SCAN I_SUBCOLTYPE1 (cr=1 pr=0 pw=0 time=8 us cost=1 size=168 card=21)(object id 87) ******************************************************************************** SQL ID: dmqb1hzrf5uxh Plan Hash: 2145170089 delete ntab$ where obj#=: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 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE NTAB$ (cr=1 pr=0 pw=0 time=10 us) 0 0 0 INDEX RANGE SCAN I_NTAB1 (cr=1 pr=0 pw=0 time=7 us cost=1 size=30 card=2)(object id 89) ******************************************************************************** SQL ID: 8d3cj1rnkaj9t Plan Hash: 2740357267 delete lob$ where obj#=: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 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE LOB$ (cr=1 pr=0 pw=0 time=9 us) 0 0 0 INDEX RANGE SCAN I_LOB1 (cr=1 pr=0 pw=0 time=9 us cost=1 size=14 card=1)(object id 81) ******************************************************************************** SQL ID: 3tdf1gw7qs5su Plan Hash: 3574105756 select o.name from obj$ o, refcon$ r where o.oid$ = r.expctoid and r.obj# = :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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=10 us) 0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=8 us cost=2 size=46 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID REFCON$ (cr=1 pr=0 pw=0 time=8 us cost=0 size=23 card=1) 0 0 0 INDEX RANGE SCAN I_REFCON1 (cr=1 pr=0 pw=0 time=7 us cost=0 size=0 card=1)(object id 93) 0 0 0 INDEX RANGE SCAN I_OBJ3 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 38) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=2 size=23 card=1) ******************************************************************************** SQL ID: f0dyzv5ppbm47 Plan Hash: 1446580413 delete refcon$ where obj#=: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 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE REFCON$ (cr=1 pr=0 pw=0 time=7 us) 0 0 0 INDEX RANGE SCAN I_REFCON1 (cr=1 pr=0 pw=0 time=5 us cost=0 size=39 card=1)(object id 93) ******************************************************************************** SQL ID: 4rbnpkpntsxvu Plan Hash: 2501549617 delete from opqtype$ where obj#=: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 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE OPQTYPE$ (cr=1 pr=0 pw=0 time=9 us) 0 0 0 INDEX RANGE SCAN I_OPQTYPE1 (cr=1 pr=0 pw=0 time=9 us cost=1 size=9 card=1)(object id 96) ******************************************************************************** SQL ID: av0kjjbhc642q Plan Hash: 1713136565 delete from objauth$ where obj#=: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 2 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE OBJAUTH$ (cr=2 pr=0 pw=0 time=11 us) 0 0 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=9 us cost=2 size=16 card=1)(object id 62) ******************************************************************************** SQL ID: 59vjj34vugaav Plan Hash: 225269600 delete from obj$ where obj# = :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 2 11 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 11 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE OBJ$ (cr=2 pr=0 pw=0 time=563 us) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=11 us cost=2 size=77 card=1)(object id 36) ******************************************************************************** CREATE TABLE IMP_3251037_3400( PARTITION_DATE DATE,USER_ID NUMBER,ACCOUNT_ID NUMBER,SID NUMBER,IMPS NUMBER,CLICKS NUMBER,TOTAL_COST NUMBER) ORGANIZATION EXTERNAL ( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY "FOR_TEST" ACCESS PARAMETERS (NOLOGFILE) LOCATION("FOR_TEST":'aggs_account_ora_gtt_3400') ) 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 23 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 23 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 2) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 1 0.00 0.00 ******************************************************************************** SQL ID: 87gaftwrm2h68 Plan Hash: 1218588913 select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname from obj$ o where o.obj#=: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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=2 pr=0 pw=0 time=8 us cost=3 size=77 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=8 us cost=2 size=0 card=1)(object id 36) ******************************************************************************** SQL ID: 77mtwmnd4c4pk Plan Hash: 1589386835 select obj# from objerror$ 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS FULL OBJERROR$ (cr=2 pr=0 pw=0 time=100 us cost=2 size=13 card=1) ******************************************************************************** SQL ID: 9k43zr1uannr6 Plan Hash: 1900104449 select obj#, owner, node from syn$ where name=: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 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID SYN$ (cr=4 pr=0 pw=0 time=50 us cost=6 size=27 card=1) 0 0 0 INDEX SKIP SCAN I_SYN2 (cr=4 pr=0 pw=0 time=49 us cost=5 size=0 card=1)(object id 78) ******************************************************************************** SQL ID: 4bjwv5sp99589 Plan Hash: 0 insert into obj$(owner#,name,namespace,obj#,type#,ctime,mtime,stime,status, remoteowner,linkname,subname,dataobj#,flags,oid$,spare1,spare2,spare3) values (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18) 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 12 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 12 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=0 pw=0 time=512 us) ******************************************************************************** SQL ID: asnhcg241fr2y Plan Hash: 0 insert into tab$(obj#,ts#,file#,block#,bobj#,tab#,intcols,kernelcols,clucols, audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt, avgspc,chncnt,avgrln,analyzetime,samplesize,cols,property,degree,instances, dataobj#,avgspc_flb,flbcnt,trigflag,spare1,spare6) values (:1,:2,:3,:4,decode(:5,0,null,:5),decode(:6,0,null,:6),:7,:8,decode(:9,0,null, :9),:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25, decode(:26,1,null,:26),decode(:27,1,null,:27),:28,:29,:30,:31,:32,:33) 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 3 7 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 7 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=3 pr=0 pw=0 time=996 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 1 0.00 0.00 ******************************************************************************** SQL ID: 60uw2vh6q9vn2 Plan Hash: 0 insert into col$(obj#,name,intcol#,segcol#,type#,length,precision#,scale, null$,offset,fixedstorage,segcollength,deflength,default$,col#,property, charsetid,charsetform,spare1,spare2,spare3) values (:1,:2,:3,:4,:5,:6,decode(:5,182/*DTYIYM*/,:7,183/*DTYIDS*/,:7,decode(:7,0, null,:7)),decode(:5,2,decode(:8,-127/*MAXSB1MINAL*/,null,:8),178,:8,179,:8, 180,:8,181,:8,182,:8,183,:8,231,:8,null),:9,0,:10,:11,decode(:12,0,null,:12) ,:13,:14,:15,:16,:17,:18,:19,:20) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 7 0.00 0.00 0 14 49 7 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.00 0.00 0 14 49 7 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=2 pr=0 pw=0 time=302 us) ******************************************************************************** SQL ID: 5uyfwyyc3zszz Plan Hash: 0 insert into external_tab$ (obj#, default_dir, type$, nr_locations, reject_limit, par_type, param_clob, param_blob, property) values (:1, :2, :3, :4, :5, :6, :7, :8, :9) 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: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=2 pr=0 pw=0 time=257 us) ******************************************************************************** SQL ID: 15999t5byf40b Plan Hash: 409139402 select param_clob, param_blob from external_tab$ where obj#=: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: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID EXTERNAL_TAB$ (cr=2 pr=0 pw=0 time=17 us cost=0 size=4017 card=1) 1 1 1 INDEX UNIQUE SCAN I_EXTERNAL_TAB1$ (cr=1 pr=0 pw=0 time=4 us cost=0 size=0 card=1)(object id 1040) ******************************************************************************** SQL ID: 8z8svdhrwqrjh Plan Hash: 0 insert into external_location$ (obj#, position, dir, name) values (:1, :2, :3, :4) 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: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=0 pw=0 time=189 us) ******************************************************************************** SQL ID: 14fy467qw1j7t Plan Hash: 190265630 select 1 from sys.streams$_prepare_ddl p where ((p.global_flag = 1 and :1 is null) or (p.global_flag = 0 and p.usrid = :2)) and rownum = 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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 COUNT STOPKEY (cr=1 pr=0 pw=0 time=11 us) 0 0 0 INDEX FULL SCAN I_STREAMS_PREPARE_DDL (cr=1 pr=0 pw=0 time=8 us cost=0 size=26 card=1)(object id 717) ******************************************************************************** SQL ID: 1qkw3pu3qv2t1 Plan Hash: 2006267889 SELECT COUNT(*) FROM USER_PART_KEY_COLUMNS PC WHERE PC.NAME = :B2 AND PC.COLUMN_NAME = :B1 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 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 7 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=7 pr=0 pw=0 time=55 us) 0 0 0 VIEW USER_PART_KEY_COLUMNS (cr=7 pr=0 pw=0 time=50 us cost=13 size=4038 card=2) 0 0 0 SORT UNIQUE (cr=7 pr=0 pw=0 time=50 us cost=13 size=320 card=2) 0 0 0 UNION-ALL (cr=7 pr=0 pw=0 time=43 us) 0 0 0 FILTER (cr=4 pr=0 pw=0 time=29 us) 0 0 0 NESTED LOOPS OUTER (cr=4 pr=0 pw=0 time=28 us cost=5 size=155 card=1) 0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=27 us cost=4 size=112 card=1) 0 0 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=26 us cost=3 size=88 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=15 us cost=2 size=77 card=1)(object id 37) 0 0 0 TABLE ACCESS BY INDEX ROWID PARTCOL$ (cr=1 pr=0 pw=0 time=9 us cost=1 size=11 card=1) 0 0 0 INDEX RANGE SCAN I_PARTCOL$ (cr=1 pr=0 pw=0 time=7 us cost=0 size=0 card=1)(object id 575) 0 0 0 TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=24 card=1) 0 0 0 INDEX UNIQUE SCAN I_COL3 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 50) 0 0 0 TABLE ACCESS CLUSTER ATTRCOL$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=43 card=1) 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=9 us) 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=8 us cost=6 size=165 card=1) 0 0 0 FILTER (cr=3 pr=0 pw=0 time=7 us) 0 0 0 NESTED LOOPS OUTER (cr=3 pr=0 pw=0 time=7 us cost=5 size=154 card=1) 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=7 us cost=4 size=111 card=1) 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=7 us cost=3 size=87 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=5 us cost=2 size=77 card=1)(object id 37) 0 0 0 TABLE ACCESS BY INDEX ROWID IND$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=10 card=1) 0 0 0 INDEX UNIQUE SCAN I_IND1 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 41) 0 0 0 TABLE ACCESS CLUSTER COL$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=288 card=12) 0 0 0 TABLE ACCESS CLUSTER ATTRCOL$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=43 card=1) 0 0 0 INDEX RANGE SCAN I_PARTCOL$ (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 575) 0 0 0 TABLE ACCESS BY INDEX ROWID PARTCOL$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=11 card=1) ******************************************************************************** SQL ID: 96g93hntrzjtr Plan Hash: 2239883476 select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 7 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.00 0 21 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 15 0.00 0.00 0 21 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=3 pr=0 pw=0 time=10 us) 0 0 0 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=3 pr=0 pw=0 time=9 us)(object id 426) ******************************************************************************** declare iflist SYS.ODCIOBJECTLIST; begin :1 := "SYS"."ORACLE_DATAPUMP"."ODCIGETINTERFACES"(iflist); :2 := iflist; 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 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 3) ******************************************************************************** INSERT /*+ APPEND */ INTO ACCOUNT_ORA_GTT (PARTITION_DATE,USER_ID,ACCOUNT_ID,SID,IMPS,CLICKS,TOTAL_COST) SELECT PARTITION_DATE,USER_ID,ACCOUNT_ID,SID,IMPS,CLICKS,TOTAL_COST FROM IMP_3251037_3400 t call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 603 0 0 Execute 1 0.93 1801.65 0 0 3 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.94 1801.66 0 603 3 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD AS SELECT (cr=0 pr=0 pw=0 time=58 us) 0 0 0 EXTERNAL TABLE ACCESS FULL IMP_3251037_3400 (cr=0 pr=0 pw=0 time=1 us cost=39 size=1423320 card=16360) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Datapump dump file I/O 6 0.00 0.00 Disk file operations I/O 3 0.00 0.00 ******************************************************************************** SQL ID: fz9xwpt2cvt0k Plan Hash: 409139402 SELECT par_type, param_clob, param_blob from external_tab$ where obj#=: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: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID EXTERNAL_TAB$ (cr=2 pr=0 pw=0 time=9 us cost=0 size=4030 card=1) 1 1 1 INDEX UNIQUE SCAN I_EXTERNAL_TAB1$ (cr=1 pr=0 pw=0 time=4 us cost=0 size=0 card=1)(object id 1040) ******************************************************************************** SQL ID: f5ra7dru5fk5n Plan Hash: 3642656162 SELECT NAME, PATH, READ, WRITE, EXECUTE FROM SYS.LOADER_DIR_OBJS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 13 0.00 0.00 0 61 0 12 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 15 0.01 0.01 0 61 0 12 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 12 12 12 VIEW LOADER_DIR_OBJS (cr=61 pr=0 pw=0 time=71 us cost=15 size=8124 card=4) 12 12 12 UNION-ALL (cr=61 pr=0 pw=0 time=69 us) 12 12 12 NESTED LOOPS (cr=61 pr=0 pw=0 time=66 us) 12 12 12 NESTED LOOPS (cr=49 pr=0 pw=0 time=240 us cost=6 size=124 card=2) 12 12 12 TABLE ACCESS FULL DIR$ (cr=13 pr=0 pw=0 time=76 us cost=2 size=70 card=2) 12 12 12 INDEX RANGE SCAN I_OBJ1 (cr=36 pr=0 pw=0 time=89 us cost=1 size=0 card=1)(object id 36) 12 12 12 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=12 pr=0 pw=0 time=152 us cost=2 size=27 card=1) 1 1 1 FIXED TABLE FULL X$KZSPR (cr=0 pr=0 pw=0 time=28 us cost=0 size=26 card=1) 0 0 0 HASH GROUP BY (cr=0 pr=0 pw=0 time=78 us cost=9 size=146 card=2) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=17 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=8 size=73 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us cost=6 size=124 card=2) 0 0 0 TABLE ACCESS FULL DIR$ (cr=0 pr=0 pw=0 time=0 us cost=2 size=70 card=2) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=2 size=27 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 36) 0 0 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=11 card=1)(object id 62) 0 0 0 FIXED TABLE FULL X$KZSRO (cr=0 pr=0 pw=0 time=0 us cost=0 size=13 card=1) 1 1 1 FIXED TABLE FULL X$KZSPR (cr=0 pr=0 pw=0 time=15 us cost=0 size=26 card=1) ******************************************************************************** SQL ID: 30tsghxughv2d Plan Hash: 0 ALTER SESSION SET SQL_TRACE = FALSE 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: 1 Optimizer mode: ALL_ROWS Parsing user id: 35 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net break/reset to client 3 0.02 0.07 SQL*Net message to client 4 0.00 0.00 SQL*Net message from client 4 4.31 8.69 ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 51 0.00 0.00 0 0 0 0 Execute 51 0.00 0.00 0 0 0 39 Fetch 10 0.00 0.00 0 0 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 112 0.00 0.01 0 0 0 49 Misses in library cache during parse: 3 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 69 0.00 0.00 SQL*Net message from client 69 56.70 205.47 SQL*Net break/reset to client 8 0.02 0.18 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 101 0.04 0.05 0 603 0 0 Execute 117 1.07 1801.79 0 228 176 25 Fetch 66 0.00 0.00 0 369 0 45 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 284 1.13 1801.85 0 1200 176 70 Misses in library cache during parse: 76 Misses in library cache during execute: 65 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ asynch descriptor resize 1 0.00 0.00 utl_file I/O 6 0.00 0.00 Disk file operations I/O 5 0.00 0.00 Datapump dump file I/O 6 0.00 0.00 24 user SQL statements in session. 79 internal SQL statements in session. 103 SQL statements in session. ******************************************************************************** Trace file: /tmp/import.trc Trace file compatibility: 11.1.0.7 Sort options: default 1 session in tracefile. 24 user SQL statements in trace file. 79 internal SQL statements in trace file. 103 SQL statements in trace file. 87 unique SQL statements in trace file. 40020 lines in trace file. 2007 elapsed seconds in trace file.