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

Maybe simulated ASH (SASH) can help you? Kyle Haily built this.

Look at www.perfvision.com under tools.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Mon, 2008-02-04 at 21:21 -0700, Mark Brinsmead wrote:

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

<snip>

> --
> Cheers,
> -- Mark Brinsmead
> Senior DBA,
> The Pythian Group
> http://www.pythian.com/blogs
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.

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