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

From: Carel-Jan Engel <>
Date: Tue, 05 Feb 2008 10:37:03 +0100
Message-Id: <>

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

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


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

Received on Tue Feb 05 2008 - 03:37:03 CST

Original text of this message