Archivelog Overload... - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 23 of 23

Thread: Archivelog Overload...

  1. #21
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    I used to be a big proponent of gzipping archived logs. 9i changed my opinion and compressed (archivelog) backups using rman pushed this idea further away.

    When gzipping archived logs, I'd be concerned about recovery involving an unzip and the cpu gzip uses to compress/decompress (even though you can gzip -1 and sacrofice a little compression for less CPU drain.)

    -Ken

  2. #22
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    We got slammed with millions of updates in a period of 1 hr 15 min again last night. It put this theory of on-demand archive log flushing via rman to the ultimate test.

    And it turned out much better than expected!

    At peak times we were creating a 100mb archive every 7.5 seconds.

    We maintained under ~2.5 gb used by archived logs on the diskgroup at any given time. So much for needing to add more disks, this process just used them more efficiently.

    The process archived & flushed a total of 43 GB during the 1 hr 15 min

    I/O was spread evenly across devices. ASM worked flawlessly.

    -Ken
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #23
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Nice to hear some feedbacks

    Thanx,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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