Space calculation for Archive Logs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Space calculation for Archive Logs

  1. #1
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    I have an 8i database in No Archive Log mode and am planning to bring it in Archive Log mode.
    I am trying to calculate the need of disk storage based on how much Archive would be generated.

    One simple calculation for daily log generation will be --
    (size of the redo log) * (Log switches per day)

    I do wonder though that Archive log size may not be be actually same as the Redo log because Redo log can switch even without being filled.

    Do you guys have any suggestions ?

    Thanks,
    - Rajeev


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    (size of the redo log) * (Log switches per day) is the safe calculation. Although you can manually switch the logfile, it will be smaller than a full log file.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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