There will be Rollback. There is no other way. I think you are talking about
No Logging feature, which has nothing to do in this update case.

Sandeep

-----Original Message-----
From: Sexton, Kevin [mailto:kevin.[Email Address Removed] Thursday, March 28, 2002 2:56 PM
To: LazyDBA.com Discussion
Subject: RE: when to commit-no rollback


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