How are you loading this table? Are you sure there is NO ROLLBACK?

Rick



"Sexton, Kevin"
<kevin.[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
cemed.com> cc:
Subject: RE: when to commit-no rollback
03/28/2002 02:55 PM






Sorry for all the mail. But I am not logging so there is NO ROLLBACK
segment.

-Kevin

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


rollback segment size, available space, should be the criteria.

Regards,
Alok Kumar

-----Original Message-----
From: Sexton, Kevin [mailto:kevin.[Email Address Removed] Thursday, March 28, 2002 2:47 PM
To: LazyDBA.com Discussion
Subject: 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 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 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