missing system event counter??

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 - 14:16:30 CST