Oh ya, I should have said we are a warehouse BUILDING shop. There is no
"production" time or "off hours" I need to be concerned about. And it is
a 1 time update.

-KEvin

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Thursday, March 28, 2002 2:52 PM
To: Sexton, Kevin
Subject: Re: when to commit



It depends on the size of your rollback segments. If it will commit
every
50,000 rows then sounds very reasonable. I am guessing this is one of
those
1 time loads. You would obviously want to do this at off hours.

Rick




"Sexton, Kevin"

<kevin.[Email Address Removed] To: "LazyDBA.com
Discussion" <[Email Address Removed]
cemed.com> cc:

Subject: when to
commit
03/28/2002 02:46 PM









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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html





Oracle LazyDBA home page