Is Ok if you have enough space. Snapshoot always available for query.
I'm not sure how Oracle shrink your rbs, I think because of the size, oracle will take longer time to shrink it back to optimal.


-----Original Message-----
From: Narayan Vaidyanathan [mailto:v.[Email Address Removed] 30 April 2002 12:50
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