Re: Performance of Archive log mode

From: James Dickson <James.Dickson_at_mail.esrin.esa.it>
Date: Thu, 22 Apr 1999 13:57:57 +0200
Message-ID: <371F0EC5.6901@mail.esrin.esa.it>

CHO, HYON-HYOK wrote:
>
> Hi everybody!!
> I engaged in large database.(over 700G - data)
> So I have a headache because of backup policy.
> Oracle recommended archive log mode, but I
> think archive log mode downgrade the performance seriously,
> through pilot test (especially data warehouse).
> Furthermore,
> Our system has some OLTP features.
> Is there any body who has experience on archive log mode?
> We will use storage-tec archive machine and ORCL RMAN.

Hi Cho,

Try reducing the parameter log_archive_buffers and see if performance improves.

James
--
james_at_valhall.esrin.esa.it.NOSPAM Received on Thu Apr 22 1999 - 06:57:57 CDT