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: [EMAIL PROTECTED]
http://www.victoria.com.ni
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Veronica Levin
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
