SQL Performance (MOSC)

MOSC Banner

300k updates in script running slow in sql*plus

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 trips. The update statements look like

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