Database DataWarehousing (MOSC)

MOSC Banner

quick question on direct-path insert

edited Jul 17, 2014 12:18PM in Database DataWarehousing (MOSC) 3 commentsAnswered ✓

Hi everyone, how may I confirm data is really loading as direct-path insert? I tried to load a table using direct path insert but looking at the plan used on v$sql it seems that I only have a regular insert, here is the plan:

select plan_table_output from table(dbms_xplan.display_cursor('3k35v36x1bbdg'));

PLAN_TABLE_OUTPUT

------------------------------------------------------------------------------------------------------------------------------------------------------

SQL_ID  3k35v36x1bbdg, child number 0

-------------------------------------

insert /*+ append */into target select * from source

Plan hash value: 2263300755

-------------------------------------------------------------------------------

| Id  | Operation          | Name     | Rows  | Bytes | Cost (%CPU)| Time     |

-------------------------------------------------------------------------------

|   0 | INSERT STATEMENT   |          |       |       |  1711K(100)|          |

|   1 |  LOAD AS SELECT    |          |       |       |            |          |

|   2 |   TABLE ACCESS FULL| SOURCE |   106M|    54G|  1711K  (1)| 05:42:17 |

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center