OracleLoader with direct-path INSERTs

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Dennis Wanke
Posts: 57
Joined: Tue 11 Mar 2014 07:49

OracleLoader with direct-path INSERTs

Post by 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.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: OracleLoader with direct-path INSERTs

Post by Pinturiccio » Mon 19 May 2014 11:44

Thank you for your suggestions. We will investigate them, but there is no timeframe at the moment.

Post Reply