Re: Scripts to monitor segments

OEM. (Oracle Enterprise Manager)

Does precisely this sort of thing. Easy(ish) to configure, it can send messages to your pager, SMS, or email whenever an alert (they call them 'events') is triggered -and you can define whatever alerts you fancy. It comes with pre-designed alerts for things like 'Tablespace more than x% full', 'Database down','Server down','Buffer Cache Hit Ratio drops to less than x%' and so on.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Ryan Gaffuri" <rkg100_at_erols.com> wrote in message
news:a6e86j$nru$1_at_bob.news.rcn.net...


> 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.

>

>