Re: any possible replacement view for v$system_event/x$kslei
Date: Tue, 05 Feb 2008 10:37:03 +0100
Maybe simulated ASH (SASH) can help you? Kyle Haily built this.
Look at www.perfvision.com under tools.
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.
> -- 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.