Re: [Q] what benefit I get from NOARCHIVELOG ???

MCC wrote:
>
> I knew it is very danger if I don't setup Archive redo log mode? My
> friend told me change from "Archivelog mode" to "Noarchivelog mode"
> performance will improve a lot. Is it true? What other benefit I can get
> from "noarchivelog" ? Thank you for help.
 

  The performance gain is to reduce the overhead in writing the redo log entries to archive when there is a log switch. Anyway, the disadvantage is the loss of data when there is a failure. You can only restore but not recover the data.

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841