To make more redo log available by adding more redo logs and bigger size.
To make the archiving faster, making log_archive_buffer parameter bigger.
>From: Michael Boligan <mboligan_at_healthvision.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: dbms_job question ??
>Date: Wed, 26 Apr 2000 07:26:19 -0800
>
>Increase the size of your redo logs.
>
>-----Original Message-----
>Sent: Wednesday, April 26, 2000 9:55 AM
>To: Multiple recipients of list ORACLE-L
>
>
>We are running Oracle 7.3.2.3 OPS on AIX 4.2.1
>
>Our database is 600G and extremely insert-intensive (330M per 15 minutes).
>
>During hot backup (which takes 10 hours) all 23 on-line redo logs usually
>fill
>and the database stops
>because they are filling faster than the archive process can copy them to
>the
>archive filesystem.
>
>Can anyone suggest any Oracle tuning that may help? I cant think of
>anything.
>Is there a way (in Unix) to give the archiver an exclusive lock on the
>archive
>filesystem during a redo log write?
>
>..tom
>--
>Author:
> INET: blair_at_pjm.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).
>--
>Author: Michael Boligan
> INET: mboligan_at_healthvision.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).
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com
Received on Wed Apr 26 2000 - 11:13:46 CDT
