Database striping !!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Database striping !!!

  1. #1
    Join Date
    Oct 2000
    Posts
    28

    Wink Database striping !!!

    Hello,
    When it comes to DB performances ,DISK I/O can become easily bottleneck . One of the solution may
    be DATA STRIPING or striping of USER DATA TABLE SPACE .This can be done by striping manually tables across the disks or RAID 0/1 .
    Can you add some words of your configuration or HOW you can tackle DISK I/O contetion ?

    Pl. note that I am assuming that other considerations like sufficient MEMORY allocation and separate TABLESPACES and separate DISKS ( for TEMPORARY , INDEX , UNDO LOGS, REDO LOGS , SYSTEM , TOOLS , ARCHIEVE data ) is available .

    The problem is only with users DATA performance because of disk I/O contetion and seeking for any HARDWARE solutions /configurations like SAN , RAID etc. you tried.

    Thanks,

    Sunil

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Here's a good resource.
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Here's another take on I/O and Oracle... http://technet.oracle.com/deploy/per...orage_conf.pdf
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    one of my personal favorites, be prepared to do some reading here but the opinions/ffedback in the thread warrant a careful read.


    groups.google.com/groups?hl=en&lr=&ie=UTF 8&threadm=ue4sg0gm4fdbdc%40corp.supernews.com&rnum=191&prev=/groups%3Fq%3Dseparate%2Bindex%2Bdata%2Btablespace%26start%3D190%26hl%3Den%26lr%3D%26ie%3DUTF-8%26selm%3Due4sg0gm4fdbdc%2540corp.supernews.com%26rnum%3D19

    steve
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    Oct 2000
    Posts
    28
    The LINKS given by Jeff Hunter and slimdave are pretty good to focus on I/O sub-system and RAID 0/1 .

    Any links about I/O and SAN will be appreciated.




    Sunil

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Conceptually, a SAN is no different than a SCSI device except you can pump your data much faster. The limiting factor (as far as I/O is concerned anyway) will be the speed of the physical disk.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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