when to commit

when to commit

 

  

Is there a recommended time to do a commit when I am updating a table
with 100 million rows.

I am running Oracle 8.17 on WIN2K advanced server. (8GB RAM)

My tables is 25 columns wide (varchar (20))

I was thinking every 50,000 rows?

-Kevin
Oracle LazyDBA home page