Archivelog and performance ... Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Archivelog and performance ...

  1. #1
    Join Date
    Dec 2001

    Archivelog and performance ...

    Hi all !
    We have a strategic OLTP application which use an 8.1.7 database on Solaris 2.8.
    This database is not in archivelog mode and the only backup performed on it is a simple daily export full (that's for real !).
    There is no physical backup (copy of the datafiles).

    I know that it would be very necessary to implement a secure backup strategy ...
    But I'm just wondering if the archivelog mode will not cause slowdown performance problem ...

    Does anybody could share his experience on the implementation of the archivelog mode and performance problem on Solaris with 8.1.7 databases ?

    Thanks a lot in advance !

  2. #2
    Join Date
    May 2001
    I don't think that u will have any problem in setting your database in Arhcive log mode.Its solely depends on how well u know about it.They will say so who afraid of maintaining it.

  3. #3
    Join Date
    Sep 2001

    If this is a production database then it should definatly be in archivelog mode. I have an OLTP system runnig 8.1.7 on solaris 2.8 and it runs in archive log mode. There has not been a great impact on performance. Having said this it all depends on your specific database setup e.g. datafile configuration, disk layout etc. In general as long as the LGWR & ARC0 processes
    are not experiencing contention and you have enough online redo logs
    you should be ok. The only way to really find out is to implement archive log mode
    and see what happens. You can then correct any araes that experiance a performance hit.

    hope this helps


  4. #4
    Join Date
    Dec 2001
    Thanks a lot !

  5. #5
    Join Date
    Jan 2000
    Chester, England.
    Originally posted by sazzadur

    If this is a production database then it should definatly be in archivelog mode.
    You'd think so wouldn't you.
    I maintain 2 Ora8i db's and when I asked the system owners about their backup and recovery requirements, they said "Last night's network backup will be fine.".
    So thats what they got - on the understanding of what it implied. If it all goes wrong - I did tell them but they didn't listen.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width