Technology Stack - EBS (MOSC)

MOSC Banner

need to run 300k updates in large sql script

edited Jun 3, 2021 1:15PM in Technology Stack - EBS (MOSC) Question

I have a script that has around 300k update statements against a table with 500k rows. It seems to be taking about 1 second per update statement. So it might take 80 hours to run, 300k/60/60=83.3. I attempted to speed it up by putting around 10k rows within begin/end; and run as anonymous pl/sql block but it doesn't seem to be running any faster. Any ideas on how I might speed this up? This is an 18.14.0.0.0 database running on Solaris. I'm running sqlplus locally on the db server to avoid the network round

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