OracleLoader with direct-path INSERTs

OracleLoader with direct-path INSERTs

Postby Dennis Wanke » Wed 14 May 2014 10:05

When performing table load using array binding, it would be nice to opt-in for direct-path INSERTs. It means:
  • the APPEND_VALUES hint will be placed in the generated INSERT statements (starting with Oracle 11g Release 2; for older versions the APPEND hint might be used with INSERT … SELECT FROM DUAL - not sure it's possible with array binding)
  • triggers and DRI constraints will be disabled during the load process and re-enabled afterwards
Instead of a simple boolean option (e.g. UseDirectPath), a DirectPathRowAmount threshold can be provided to avoid excessive database growth on small data chunks (e.g. direct path only if row amount > 10K).
Another option can control bypassing redo generation by altering the table (and probably its indexes) to NOLOGGING mode beforehand and then reverting it back to the original mode afterwards.
Dennis Wanke
Posts: 57
Joined: Tue 11 Mar 2014 07:49

Re: OracleLoader with direct-path INSERTs

Postby Pinturiccio » Mon 19 May 2014 11:44

Thank you for your suggestions. We will investigate them, but there is no timeframe at the moment.
Devart Team
Posts: 2062
Joined: Wed 02 Nov 2011 09:44

Return to dotConnect for Oracle