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

  • From: Carel-Jan Engel <careljan@xxxxxxxxxx>
  • To: pythianbrinsmead@xxxxxxxxx
  • 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.

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.


Other related posts: