He will be too busy rewriting his resume and responding to the
help wanted ads to have any time to worry about the performance
degradation.
regards
Jerry Gitomer
Van Messner wrote in message ...
>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 Fri Apr 23 1999 - 11:35:35 CDT
