DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005

    When installing 10g, how do I determine sizing for ARCHIVELOG and REDO LOG?

    Hi, we have a 800 GB SQL Server database that we're migrating to Oracle 10g. We'll allocate 2 TB for the current database and future growth, but what is the method for determining the amount of space for ARCHIVE LOGS and ONLINE REDO LOGS? This is an OLTP system not OLAP or datawarehousing. Thanks for your help!

  2. #2
    Join Date
    Sep 2002
    you have to benchmark and work it out, calculate how much redo you generate. it is nothing to do with the size of the datasbase but the amount of work you do

  3. #3
    Join Date
    Nov 2005
    As you are saying it is OLTP system and 800 GB, I wud have created online redologs sizing around 500-800 MB each with total no. of groups 6. Later, you can check how many switches happening per hour using v$archived_log and decide if you need to resize the logs.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.