"Ryan Gaffuri" <rkg100_at_erols.com> wrote in message news:<a6bo0d$orh$1_at_bob.news.rcn.net>...
> Our rollback and index segments fill up frequently and we have to add space
> once the error happens. Are there any scripts out there to monitor it and
> flash an alert or how would you do it? Id assume there are ways to check the
> V$ views to do this, then automate it, then have it let you know when they
> close.
>
> What else should we be monitoring this way?
>
> Im a developer and my DBA skills are lacking so please bare with my
> questions.
>
> Ryan Gaffuri
For the rollback segments, what I've done is create the rollback
segments using 1 mb extents, relatively small size (10-15 extetns)...I
leave out the optimal parameter and make sure tablespace it's in has
room to grow. Then I keep an eye on them, and manually shrink them
as needed.
Received on Sat Mar 09 2002 - 17:26:35 CST
