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

Thread: Space calculation for Archive Logs

  1. #1
    Join Date
    Oct 2000
    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 ?

    - Rajeev

  2. #2
    Join Date
    Nov 2000
    (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
    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