RE: "log buffer space" event still there?

From: <nlzanen1_at_ey.nl>
Date: Thu, 23 Nov 2000 12:18:56 +0100
Message-Id: <10689.122805@fatcity.com>

Hi Mark

That will show you the parameter value only,

The real value can be obtained from show SGA

Jack

"Mark Leith" <mark_at_cool-tools.co.uk>@fatcity.com on 23-11-2000 11:25:26

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: RE: "log buffer space" event still there?

Alex

I too am on 8.1.6 on W2K:

SQL> desc v$session_event

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------
 SID                                                NUMBER
 EVENT                                              VARCHAR2(64)
 TOTAL_WAITS                                        NUMBER
 TOTAL_TIMEOUTS                                     NUMBER
 TIME_WAITED                                        NUMBER
 AVERAGE_WAIT                                       NUMBER
 MAX_WAIT                                           NUMBER

First thing I notice is that there are no columns called seconds_in_wait or state:

SQL> select * from v$session_event
2 where event like 'log%';

SID EVENT
---------- -----------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT MAX_WAIT
----------- -------------- ----------- ------------ ----------

         3 log file sequential read
         10              0           0            0          0

         3 log file single write
         16              0           0            0          0

         3 log file parallel write
       1452              1           0            0          0

So it doesn't show up on mine either. You are not alone.. I'm guessing that you want to see how big the log buffer is? If so, under NT the LOG_BUFFER parameter will show the value set for it:

SQL> show parameter log_buffer

NAME                                 TYPE    VALUE


------------------------------------ ------- -----------

log_buffer                           integer 32768

HTH Mark

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?

Any entries welcome.
Alex

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.

The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its Received on Thu Nov 23 2000 - 05:18:56 CST