RE: Log Buffer

yes, I think that does help. I am thinking I am going to make them larger? 21 requests

-----Original Message-----
Sent: Friday, March 23, 2001 2:46 PM
To: 'Kevin Kostyszyn '

Hi...

I don't think so...

you must adjust your LOG_BUFFER acoording to:

select substr(name,1,25) Name,

        substr(value,1,15) "VALUE (Near 0?)" from v$sysstat
where name = 'redo log space requests';

Hope this help!

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 3/23/01 8:35 AM

Hello DBA's

        You know, I read somewhere that you can make your log_buffer 10 percent of
your total sga. So if you had a 500mb sga you could have a 50 mb log_buffer? What do you guys think, the illustrious Ross doesn't like such
large log_buffers.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
kevin_at_dulcian.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
  INET: kevin_at_dulcian.com

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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  INET: kevin_at_dulcian.com

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).