Database DataWarehousing (MOSC)

MOSC Banner

Slow on update

edited Feb 10, 2011 7:01AM in Database DataWarehousing (MOSC) 5 commentsAnswered ✓
Hi,

I'm using DB version 11.1.0.7, recently I try to update a 10GB table, below is my statement:

update TEST_TAB set empid=empno;

There is 30mil rows in the table, this update take 1 hours to complete.

I try update by enable session parallel dml and adding parallel hints to the statement but it couldn't help, I seen parallel processes are sevicing this update, but just that it bring no benefit to the response time of the update, sometime I see it is running slower in parallel as compare to serial.

Any option or way that I have to get the update process more 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