Re: any possible replacement view for v$system_event/x$kslei

From: Mark Brinsmead <>
Date: Mon, 4 Feb 2008 21:21:18 -0700
Message-ID: <>

ASH? Perhaps you mean AWR.

No matter. Either way, you require licenses for the Oracle Diagnostics Pack and/or Oracle Tuning Pack (both, probably) in order to access ASH / AWR views. Once you have these licenses, home-grown performance monitoring solutions might be kind of pointless. :-)

If you *really* need to sample this data that frequently, you might be able to find a way to do it by writing a (C) program that directly attaches to your SGA. This will be tough, though, if you have to support a variety of platforms and releases...

Is it really *necessary* to sample every 10 seconds? You could reduce the CPU cost for your monitoring by (perhaps much) more than 90% simply by sampling every 2 minutes instead.

On Feb 2, 2008 3:23 AM, Zhu,Chao <> wrote:

> ye's, now major of our database is running 10g.
> But to get the maximum capacity, we turned off all oracle automatic
> tuning/monitoring feature (statistics-level = basic) so ash is not avalible
> for us either.
> On Feb 1, 2008 11:26 PM, Finn Jorgensen <> wrote:
> > If you're in 10g, could you use the ASH data for this troubleshooting? I
> > can't remember the exact frequency, but it's very frequent as well and
> > stored at this raw level for an hour. Then rolled up and stored for 7 days.
> >
> > Thanks,
> > Finn
> >
> >
> > ...
> >

-- Mark Brinsmead
  Senior DBA,
  The Pythian Group

Received on Mon Feb 04 2008 - 22:21:18 CST

Original text of this message