Devart Forums

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.

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