RE: "log buffer space" event still there?

Hi Alex,

Yes, it is still there, it is just that you have not waited for it on your instance.

        SQL> select name from v$event_name where name like 'log%';

	NAME
	----------------------------------------------------------------
	log switch/archive
	log file sequential read
	log file single write
	log file parallel write
	log buffer space
	log file switch (checkpoint incomplete)
	log file switch (archiving needed)
	log file switch (clearing log file)
	log file switch completion
	log file sync

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
From: Al Glazunov [mailto:mcti_at_aicompro.com] Sent: Thursday, 23 November 2000 9:56
To: Multiple recipients of list ORACLE-L Subject: "log buffer space" event still there?

Hi gurus,
Oracle 8.1.6 Server on W2K:
The Oracle Guide say that you supposed to get an information about the "log buffer space" event if you query
the v$session_event view.

SELECT sid, event, seconds_in_wait, state FROM v$session_event
WHERE event = 'log buffer space';

I can't get any "log buffer" event does not matter how hard I try. Could it be that it was retired or it just did not show up on my system? Received on Sat Nov 25 2000 - 15:06:58 CST