Re: missing system event counter??

Hi Ed,

V$SYSTEM_EVENT only shows rows for wait types that have actually been waited for in the life of the instance. You have not had any 'free buffer waits' or 'buffer busy waits', and so there are no rows about them.

Regards,
Steve Adams

http://www.ixora.com.au/

http://www.oreilly.com/catalog/orinternals/

http://www.christianity.net.au/

On Thu, 03 Feb 2000 20:16:30 GMT, Ed Stevens <Ed.Stevens_at_nmm.nissan-usa.com> wrote:

>Subject: missing system event counter??
>
>In reviewing materials from the Oracle Performance Tuning Workshop, I
>came across this query:
>
>SELECT event, total_waits
>FROM v$system_event
>WHERE event in
> ('free buffer waits', 'buffer busy waits');
>
>When I tried it, it returned zero rows, which seemed odd. Thinking the
>book or I had a typo, I tried
>
>SELECT event
>FROM v$system_event
>ORDER BY event;
>
>Lo and behold, there were no events even remotely like 'free buffer
>waits' or 'buffer busy waits'. Is there some additional script
>(besides CATALOG and CATPROC) that need to be run. A quick search of
>the on-line docs turned up nothing.
>
>- Ed Stevens
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Feb 03 2000 - 19:24:22 CST