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. 11-09-2005, 06:52 PM #1
    cford44
    cford44 is offline Junior Member
    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!
    Reply With Quote Reply With Quote
  2. 11-09-2005, 07:10 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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
    Reply With Quote Reply With Quote
  3. 11-11-2005, 02:46 AM #3
    sunil_kandi
    sunil_kandi is offline Junior Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width