I checked the rollback segments using storage manager and I got something like this:
NAME SIZE HIGH WATER MARK (M)
R01 1.018 1.010
R02 1.018 1.010
R03 1.018 1.010
R04 1.018 1.010
R05 1.018 1.010
R06 1.018 1.000
The system rollback segmnet is okay.
Does this mean I have to resize the storage parameters for the rollback segs since they are getting closer to the high water mark?
Any other advice for a rookie me like regarding rollback segs will be highly appreciated.
[Edited by learn on 12-17-2000 at 10:59 AM]
Rollback segments reuse storage as long as your transactions are commiting. You may want to check and see if they have the shrink parameter set so that they will shrink and free up space when they are not in use
Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic
How do I find out if the roll back segments have shrink parameter set?
You must seee if the OPTIMAL SIZE is set to a non 0 value.
If you decide to set it remember that it CAN NOT be minor than the size allocated by the MINEXTENTS paramenter form that rollback segment.
if you want to tune your rollback segment you have to check wraps & shrinks in v$rollstat.
keep wraps as near to zero as possible
keep shrinks as few as possible
Click Here to Expand Forum to Full Width