Re: any possible replacement view for v$system_event/x$kslei
Date: Mon, 4 Feb 2008 21:21:18 -0700
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-lReceived on Mon Feb 04 2008 - 22:21:18 CST