DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: RAID Gurus - Help!! Urgent!!

  1. #1
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178

    RAID Gurus - Help!! Urgent!!

    I have to tune an 1TB oracle 9i database on Linux that has 1 - 400GB hard disk for OS, system, temp, redo, undo and controlfiles and 3 - 400GB RAID 0 with one SCSI controller for all the other datafiles (tables, indexes etc.,).

    I need some info on how the raid controller works when reading and writing to 3 disks in a RAID 0 configuration and how to best to distribute various oracle files in this configuration. For example, if I distribute control/undo/redo/temp between 1 Non-RAID OS disk and 3-RAID 0 disks, does that help or create more contention when writing data to datafiles?

    Thanks.
    Last edited by newbie5; 07-29-2006 at 03:33 PM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    sorry, but you cant do much with 3 disks

    what are you trying to tune here exactly - what are the wait events in your database

  3. #3
    Join Date
    Apr 2006
    Posts
    377
    RAID 0 ?? You don't have any redundancy for any of your data on your system? You really need to reconsider that configuration.

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Quote Originally Posted by ebrian
    RAID 0 ?? You don't have any redundancy for any of your data on your system? You really need to reconsider that configuration.
    What to re-consider with 3 disks..?
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Apr 2006
    Posts
    377
    If I were the OP, I would reconsider reconfiguring all the drives to RAID 1+0. Having the ability to recover my data after a media crash would be more important than the "potential" for better performance. Admittedly, it depends on the ultimate use of the system.

    Doesn't matter how marginal the performance difference may be, the performance will be ZERO if a drive fails without some form of redundancy.

    Nevertheless, a 1TB database on 4-drives is just asking for trouble. Drives are cheap !!! That's one thing that seems impossible to convince management of. In the long run, it would be cheaper to buy the hardware than it would to incur the labor costs and the inevitable data loss associated with restoring the system from a media failure.

    As the saying goes, "Never enough money to do it right the FIRST time, but ALWAYS enough money to do it the SECOND, THIRD or FOURTH time."

  6. #6
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    A bit of background on why this config used - This database collects network sniffing info, which is not considered mission cricital. Hence they went for a closed box RAID 0 configuration. The customer is reponsible for any backups. All the datafiles on bunched up on 3 disk RAID 0. OS/redo/control/temp/undo and bunched together on 1 - non RAID disk. Here are the wait event for 7 million inserts:

    Here are the top 5 wait events based on the statspack report:
    Event Waits Time (s) Ela Time
    ------------------------------------- ------------ ----------- --
    log file sync 44,342 21,530 52.61
    log file parallel write 75,561 10,885 26.60
    db file sequential read 4,609,459 2,982 7.29
    db file parallel write 15,473 2,847 6.96
    control file parallel write 7,220 802 1.96
    ----------------------------------------------------------------------

    Can someone point any info on how a single SCSI raid controller works on a disk array? Are the disk reads/writes asychronous and parallel with just one controller? Or are they queued? Does it help if we have 3 controllers for 3 disk RAID?

    The closed box can not accomodate more disks unless the whole box is changed.

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    look at where your waita are - 75% writing to redo logs - which ar on local disks

  8. #8
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    ... which is not considered mission cricital.
    Then why do you worry about performance.

    For 1 TB DB, I could not imagine 1 disk controller configuration.

    As long as end users are not complaining about performance, no company would buy additional HW. This is my experience.

    Some tablespaces are RAID and others on Non-RAID disks.
    What is backup mechanism you have?

    Tamil

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Quote Originally Posted by tamilselvan
    What is backup mechanism you have?
    Tamil
    anyone wanna place bets on exports?

  10. #10
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    How about upgrading to 10gR2 and using the asynchronous commit feature?

    http://download-east.oracle.com/docs....htm#ADFNS1018
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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