Is there a way to automate that monitoring? So it flashes you a warning if a
problem might arise? Is this a common procedure for DBAs?
"Brent" <bpathakis_at_yahoo.com> wrote in message
news:1736c3ae.0203091526.7293495c_at_posting.google.com...
> "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:08:12 CST
