quick question on direct-path insert
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 |