If you think some degradation in performance is a problem, wait until your
data warehouse crashes when you have been running in NOARCHIVELOG mode.
James Dickson wrote in message <371F0EC5.6901_at_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 - 19:04:32 CDT
