You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DBMS_CLOUD.COPY_DATA performance Issue

in Database 1 comment

Summary:

I am loading the data from CSV file on OIC object storage to ATP using DBMS_CLOUD.COPY_DATA The execution time of this approach is not Consistent. For some run it is taking more that 4 min thus causing timeout error, in some run it is completing within 7 sec even though the data volume is same.
we have tried with the same data at each run.
We know we can use use DBMS_SCHEDULER to cope with this, but the issue with this approach is that using DBMS_SCHEDULER makes it asynchronous.
We have a need to run the procedure in synchronous so that we can implement in OIC.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!