SQL & PL/SQL

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!

Tips to improve the cursor performance

beec159b-3e15-47ba-a7c9-d1fd2c1d4eb4Mar 19 2015 — edited Mar 20 2015

Hi,

I'm facing issues with cursor performance,it takes 90 to 100 mins to process 170000 records. Fetching rows using bulk collect . Have used hints [append] to improve the inserts.

Inserting around 110 fields in 3 different table. Is there any way I can improve the speed.Kindly help. Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2015

Added on Mar 19 2015

5 comments

6,282 views