When installing 10g, how do I determine sizing for ARCHIVELOG and REDO LOG?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Sep 2005
    Posts
    2

    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
    Location
    England
    Posts
    7,331
    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
    Location
    USA
    Posts
    32
    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