to trace tools like that, I typically use a trigger like this:


create or replace trigger logon_trigger
after logon on schema
begin
execute immediate
'alter session set events ''10046 trace name context forever, level 12'' ';
end;
/

(note: you have to have ALTER SESSION granted to you for this to work)

put that into the schema that is going to run the tool, start running the tool and then drop the trigger. There are other methods, but this gets the entire session (you could for example start the tool - query v$session for the sid, serial# and use dbms_system to set sql trace in session as well)


sqlldr - bulk loads by default, set bindsize to be the size of the bind buffer and it array inserts.

import does the same.


but array processing is *not* direct pathing - direct path operations are those that write directly to the Oracle datafiles. sqlldr can do it, imp cannot (but impdp = the data pump - can)