Re: Scripts to monitor segments

You can also code in the same functionality if you do not have or use OEM. We currently have several jobs (dbms_job) that monitor various criteria (on a scheduled basis) for irregularities and spikes. If the event surpasses a threshold, a procedure is called to do something to warn us -- in most cases it is to insert an alert into the db about what happened (values etc.), and generate an informative email (sent to whichever email address is appropriate to the situation, from a table that is used for that purpose).

Cheers,

Brick

"Howard J. Rogers" wrote:
>
> 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.
> >
> >
Received on Sat Mar 09 2002 - 18:31:35 CST