Re: any possible replacement view for v$system_event/x$kslei
Date: Fri, 1 Feb 2008 10:26:31 -0500
Message-ID: <74f79c6b0802010726t4bfebd2ble594c5e89ce58a22@mail.gmail.com>
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
On 2/1/08, Zhu,Chao <zhuchao_at_gmail.com> wrote:
>
> hi, all
> We have a homegrown script that pulls different views to log many
> different system level statistics for troubleshooting, and one of the view
> we query is v$system_event/x$kslei. As we does the pull of data every 10
> seconds, it is very CPU consuming. The target of querying the view, is to
> give a break down of system wide wait events in the past 10 seconds (that
> is, say, db-file-sequential-wait, 1000ms, 30%,, enqueue, 300ms, 20%...)
> Is there any possible replacement for this view? We want to reduce the
> CPU usage of this script;
>
> --
> Regards
> Zhu Chao
> www.cnoug.org
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 01 2008 - 09:26:31 CST