DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=O+HETZ9EXQxLOw1dzwcJpYT4LSdCMv0iJeHR8MQYrDbhVuyCI4mSdbZmE4ab0Yx10n6Jwms2lb5tJYdGQ9tHKO/STNEB/9Gak1zwowWk+dlVLAlgIal8JxjSf6UUwNkFnq/ZvNZKZfLAaYy0bMremG2jNM+moL1waCBYucVa4lI=
Message-ID: <962cf44b0802020223va89187ega31f458edb9b8d16@mail.gmail.com>
Date: Sat, 2 Feb 2008 18:23:16 +0800
From: "Zhu,Chao" <zhuchao@gmail.com>
To: "Finn Jorgensen" <finn.oracledba@gmail.com>
Subject: Re: any possible replacement view for v$system_event/x$kslei
Cc: "Oracle Discussion List" <oracle-l@freelists.org>
In-Reply-To: <74f79c6b0802010726t4bfebd2ble594c5e89ce58a22@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_270_26921497.1201947796905"
References: <962cf44b0802010021n2961a0c7sf13f3a860ff3a072@mail.gmail.com>
	 <74f79c6b0802010726t4bfebd2ble594c5e89ce58a22@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: zhuchao@gmail.com
------=_Part_270_26921497.1201947796905
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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@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
>
>
> On 2/1/08, Zhu,Chao <zhuchao@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
> >
>
>


-- 
Regards
Zhu Chao
www.cnoug.org

------=_Part_270_26921497.1201947796905
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

ye&#39;s, now major of our database is running 10g. <br>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. <br><br>
<div class="gmail_quote">On Feb 1, 2008 11:26 PM, Finn Jorgensen &lt;<a href="mailto:finn.oracledba@gmail.com">finn.oracledba@gmail.com</a>&gt; wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>If you&#39;re in 10g, could you use the ASH data for this troubleshooting? I can&#39;t remember the exact frequency, but it&#39;s very frequent as well and stored at this raw level for an hour. Then rolled up and stored for 7 days.</div>


<div>&nbsp;</div>
<div>Thanks,</div><font color="#888888">
<div>Finn<br><br>&nbsp;</div></font><div><div></div><div class="Wj3C7c">
<div><span class="gmail_quote">On 2/1/08, <b class="gmail_sendername">Zhu,Chao</b> &lt;<a href="mailto:zhuchao@gmail.com" target="_blank">zhuchao@gmail.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">hi, all<br>&nbsp;&nbsp; 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.&nbsp; 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%...)<br>

&nbsp; Is there any possible replacement for this view? We want to reduce the CPU usage of this script; <br clear="all"><span><br>-- <br>Regards<br>Zhu Chao<br><a href="http://www.cnoug.org/" target="_blank">www.cnoug.org</a><br>

</span></blockquote></div><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Regards<br>Zhu Chao<br><a href="http://www.cnoug.org">www.cnoug.org</a><br>

------=_Part_270_26921497.1201947796905--
--
http://www.freelists.org/webpage/oracle-l