Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: LOG_ARCHIVE_BUFFER_SIZE
There is nothing much to comment. The max value is platform (OS) dependent.
I think the book should have mentioned that. Error from svrmgrl, reports the
available range for your platform. Anything larger than the max value, won't
be accepted.
Looks like you were at the max value for this parameter for your platform.
> -----Original Message-----
> From: Veronica Levin [SMTP:vlevin_at_victoria.com.ni]
> Sent: Friday, March 30, 2001 9:18 AM
> To: Multiple recipients of list ORACLE-L
> Subject: LOG_ARCHIVE_BUFFER_SIZE
>
> 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: kirti.deshpande_at_verizon.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).Received on Fri Mar 30 2001 - 10:36:11 CST
![]() |
![]() |