Database Tuning (MOSC)

MOSC Banner

Large commit interval

edited May 21, 2010 5:53AM in Database Tuning (MOSC) 8 commentsAnswered
 I have a partitioned table with an average row length of 100 bytes and am looking to add 10 million rows to it in one shot.  Is there any reason why I shouldn't insert all 10 million with one commit at the end, set the commit frequency to one million or even lower?

This operation will be taking place during production hours where many other tables (including this one) will be updated.

Thanks

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