RE: Disadvantage of Having Large Rollback Segments

RE: Disadvantage of Having Large Rollback Segments

 

  

My $0.02...

Have Many Small RBS Instead of having a Few Large RBS.

This will ensure that the RBS is storing Consitent image for a Longer time
for Other Processes. And this will also ensure that your RBS does not extend
or wrap very frequently.

HTH

Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
============================================
Live to learn... forget... and learn again.
============================================



-----Original Message-----
From: Narayan Vaidyanathan [mailto:v.[Email Address Removed]
Sent: Tuesday, April 30, 2002 8:50 AM
To: LazyDBA.com Discussion
Subject: Disadvantage of Having Large Rollback Segments


Hi All,

Can anyone tell me if there is any disadvantage of having large rollback
segments in an OLTP Application.Will there be any effect on the performance.

TIA

Narayan


--------
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