Re: Optimal setting for RBS

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Tue, 25 Jan 2000 15:44:53 GMT
Message-ID: <388DC4F5.7FE23B2@edcmail.cr.usgs.gov>

Look at v$rollstat and see if your rollback segments have been extending or shrinking. Also look at the high water mark size (HWMSIZE). What was the biggest size the rollback segment extended to? You then have to ask if there was a big transaction that caused the rbs to extend to such a big size, or is it a "normal" size. If you have the disk space, you might want to consider setting OPTIMAL to HWMSIZE or slightly lower. It all depends on the transactional nature of your db.

HTH,
Brian

Christopher Herold wrote:
>
> To the rollback wizards.
>
> I am hoping to find out how to go about determining the correct value to
> use for OPTIMAL when creating or altering rollback segments. Can anyone
> help me out?
>
> Thanks,
> CVH
Received on Tue Jan 25 2000 - 09:44:53 CST