Re: OPTIMAL value for SYSTEM rollback segment

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Tue, 25 Jan 2000 15:42:21 GMT
Message-ID: <388DC45D.C4D5B3D1@edcmail.cr.usgs.gov>

> OK. The question is : which bad things could happen because of no OPTIMAL
> value at system rollback segment ? Or in other words, should i anytime worry
> about this ?

If you have not OPTIMAL setting for your rollback segments and the segment extends, it will not shrink automatically. You'll have to issue "ALTER ROLLBACK SEGMENT rbs SHRINK;" to get the rbs to it's "normal" size. This isn't a problem if you have the disk space, or you have your rbs properly sized.

HTH,
Brian Received on Tue Jan 25 2000 - 09:42:21 CST