LOG_ARCHIVE_BUFFER

From: Veronica Levin <vlevin_at_victoria.com.ni>
Date: Fri, 30 Mar 2001 07:53:39 -0800
Message-ID: <F001.002DD116.20010330071731@fatcity.com>

Morning listers,
Yesterday I was reading the Oracle Performance Tuning book, by Gurry & Corringan, searching for info about how to tune the Archive process (ARCH) to avoid archive bottlenecks. I found a note where it said:

"Enlarge the INIT.ORA parameter LOG_ARCHIVE_BUFFER_SIZE to a value such as 256 or 512 kilobytes. The parameter has a default on must machines of about 150 operation system blocks, wich is often inadequate for a heavily used production system"

The value was set to 127 in my production database, so I decided to try 256.

The database did not started after it was shutdown for the nightly backup. The error says the value must be between 1 and 128.

Any comments abou this???

Thanks in advance!!

Saludos,

Verónica Levin Enríquez
Administrador AIX
Compañía Cervecera de Nicaragua
Teléfono: 505-2493779
Fax: 505-2443979
Email: vlevin_at_victoria.com.ni
http://www.victoria.com.ni

--

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

Author: Veronica Levin
INET: vlevin_at_victoria.com.ni

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). Received on Fri Mar 30 2001 - 09:53:39 CST