DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Hardware configuration to run Oracle 9i DB

  1. #1
    Join Date
    Feb 2007
    Posts
    1

    Hardware configuration to run Oracle 9i DB

    Greetings,

    Hi recently, i was tasked to upgrade our current Oracle 9i DB Server. I intend to configure the new server with the following specs,
    1) Running Win2003 Ent Server (32bit) & Oracle 9i DB Server
    2) Dual Processor
    3) 4GB RAM (or maybe more)
    4) Having 3 Raid Controller Cards with 3 Raid settings,
    i) Raid 1 -> For OS
    ii) Raid 1 -> For Log Files
    iii) Raid 0+1 (6 harddisks) -> For Oracle Datafiles
    Does this help to enhance performance if i separate the log files & OS to different raid controller card?

    Basically, this is what i plan to create for the new serve. Appreciate any advise whether this is workable or there is any modification that i need to make. THanks!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    This certainly sounds reasonable. Depending on the size of your logs and the physical disks you're getting, I'd consider having a mirrored pair for the OS and put 8 drives in the 0+1 and put the logfiles on it. I'd guess you're getting at least 72G drives. For a 210G or smaller db (3x72) I'd be surprised if you're using more than about 10G for online logfiles. Now you're wasting 62G of space. I'd rather use the extra physical spindles on my 0+1 for overall throughput and utilization of space. But that's just my .02, and the way you have it is fine.
    Jeff Hunter

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