Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
- Posts: 57
- Joined: Tue 11 Mar 2014 07:49
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.
- Devart Team
- Posts: 2101
- Joined: Wed 02 Nov 2011 09:44
Thank you for your suggestions. We will investigate them, but there is no timeframe at the moment.