DB version: 11.2.0.4
OS: Oracle Linux 6.5
1. If Direct path load is used in expdp, it just means that the server process will fetch required blocks from the Disk and writes it directly to dumpfile bypassing the Buffer cache. Right ? This is what a layman like me has understood about direct path load when it comes to export/import. Is there anything more to 'Direct patch load' ?
2.
We have a table named MK_ORDER_DTL which is not partitioned. It only has the following data types. The table size is 200GB
It took 3 hours to generate an expdp dump of this table (Parallelism 2). In the AWR report, some stuff about External Table came up. This means that Direct path load was not used. Any idea why Direct path load was not used ?
SQL> select distinct DATA_TYPE from dba_tab_cols where table_name = 'MK_ORDER_DTL' and OWNER='LMOS';
DATA_TYPE
----------
CHAR
NUMBER
DATE
VARCHAR2