OraFAQ Forum: Performance Tuning » problems with updating big table by commit at end

Home » RDBMS Server » Performance Tuning » problems with updating big table by commit at end

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problems with updating big table by commit at end [message #192991]

Thu, 14 September 2006 09:05

coral_3
Messages: 2
Registered: September 2006

Junior Member

I need to update a huge table once a week, but data consistency is required(So I have to commit once).
I delete all records and insert all new data again to keep fresh data, and do commit at the end.
The code is running slowly gradually. Five times slower than using auto commit on.

Any better idea I can solve this problem? Or except commit , is there a better way to update huge table?

Thanks

Report message to a moderator

Re: problems with updating big table by commit at end [message #192993 is a reply to message #192991]

Thu, 14 September 2006 09:10

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please search the board.
There are too many related discussions on BIG commit.
After every major change (insert/delete/update), you are supposed to collect statistics on those tables/indexes.
Are you doing that?

Report message to a moderator