SQL Performance (MOSC)

MOSC Banner

A question about how to code a procedure to use dbms_parallel_execute package for a huge insert

edited Oct 31, 2018 5:01PM in SQL Performance (MOSC) 7 commentsAnswered ✓

Hi Experts,

I am on Oracle 11.2.0.4 on Linux. I have a query to tune and  a scenario in which the query executes fine for smaller data sets and takes more time for huge data set - when it inserts more than one million rows. Our application timeout is 60 seconds and when the data inserts is more than 1 million we are getting timeout.  I want to try out dbms_parallel_execute package for this - to change that query to use this package. This question is specifically about this requirement. I am asking this question to specifically know about how to use DBMS_PARALLEL_EXECUTE package to make an insert go in parallel. (Please do not spend your time on other aspects of tuning as I will raise a new question for it if I need help on that.)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center