striping is better or seperate disks
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: striping is better or seperate disks

  1. #1
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Hi

    I was wondering which metod would yiled better perfomance, striping or seperating index in a disk and data to another disk?

  2. #2
    Join Date
    Sep 2000
    Posts
    43
    As far as I know just striping. Differentmajor tablespaces should go on different disks but I don't think you should go that far as separating tables and index on different disks. :-)
    Alla S. Pfauntsch
    Oracle DBA
    ========================================
    "Life is what happens while you are planning something else".

  3. #3
    Join Date
    Jul 2000
    Posts
    50
    You should do both for better performance. Put index and table in different tablespaces. Also, do strip @ operating level.

    Regards,

    abhijit

  4. #4
    Join Date
    Jan 2000
    Posts
    21
    abhijit is right, separating the tables from indexes will lead to better performance. I've read that placing them in different OS mount point is advisable.

    vidhya

  5. #5
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    Cary Milsap who used to be with Oracle's Advanced Performace Group wrote an excellent whitepaper on this subject along with a paper on OFA. I'll see if I can locate a link to it and post it here.

    Joe
    _________________________
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.
    (877)687-3227

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