SQL Performance (MOSC)

MOSC Banner

need help in tuning this process

edited Nov 29, 2016 6:52AM in SQL Performance (MOSC) 8 commentsAnswered
Hi All, 
we have a process which is suddenly taking long time to execute,we found that some of the deletes/inserts are taking longer to run. below Delete is taking  about 3 mins  and the Insert taking about 6 mins to process 300k rows. these Delete/Insert stmts gets executed once for each process group, and we have 300+ such groups processed in the schedule run of this process. Many of these Delete/Insert stmts fly in very few seconds, but if the data is more than 150k rows to Delete/Insert then those appears to be taking longer to run. 

Out of total 300+ process groups, we have about 30 such groups process above 150k rows. Is there way to make these deletes/inserts faster?

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