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

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 <zhuchao_at_gmail.com> 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 <finn.oracledba_at_gmail.com> 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
> >
> >
> > ...
> >
>

-- 
Cheers,
-- Mark Brinsmead
  Senior DBA,
  The Pythian Group
  http://www.pythian.com/blogs

--
http://www.freelists.org/webpage/oracle-l