Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APPEND_VALUES hint in place of SYS_DL_CURSOR for OCI direct path load

3207976Oct 5 2017

Hi,

While using OCI direct path load SYS_DL_CURSOR hint is implicitly getting added Is there a way to add APPEND_VALUES hint to for OCI direct path load? Note that we are not not passing the query in Direct Path context , we only pass the table name and the data stream.SYS_DL_CURSOR stream seems to be getting added by default. It has been found that SYS_DL_CURSOR takes up more space and less performant than APPEND_VALUES hint for direct path load.Please attach a sample program to  use APPEND_VALUES hint through OCI dpl LIBRARIES

Thanks & regards,

Debargha

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2017
Added on Oct 5 2017
0 comments
1,258 views