file system vs OFA standard
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: file system vs OFA standard

  1. #1
    Join Date
    Mar 2001
    Posts
    286

    file system vs OFA standard

    Oralce has an OFA standard. Question: With modern RAID's stripping technology, do you still follow OFA to separate your tablespaces?

    For us, we are going to create one single huge file system with 1TB inside. All table, index datafiles will be created inside the same file system. The jumbo file system is supported by EMC's stripping technology. Any PROs and CONs?

  2. #2
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    Thie answer depends upon the number of disks in your stripe set. If there are enough disks in the stripe set, you will not experience performance degredation due to data and index tablespaces located on the same volume set. Striping may actually increase performance.

    However, the remaining components of OFA still apply
    (Naming conventions, Tablespace sizing/growth rates, backup strategies, etc...)
    Last edited by alapps; 11-19-2002 at 01:15 AM.
    alapps

    Fast, Cheap, Reliable... Pick Two(2)

  3. #3
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    In fact, Oracle recommend Stripe and Mirror Everything (SAME) method.

    By the way, pay attention to your file system for support of Direct I/O and Asynchronous I/O.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  4. #4
    Join Date
    Oct 2001
    Posts
    11
    One more factor would be no of disk controllers, whatever level of stripping you do, if the database is high activity you might still find disk controller becoming a bottleneck.

    I would recommend spreading high activity tablespaces across disk and disk controller for higher performance. However irrespective of disk stripping going by OFA standard still helps as mentioned in previous reply.

    Regards,

    - Niranjan

  5. #5
    Join Date
    Mar 2001
    Posts
    286
    Thank you guys for comments! Yes, I agree with OFA's advantage of naming convention and "directory structure" (not necessary the file system structure).

    By the way, could somebody direct me to documentation discussing disk stripping, RAID ......? Thank you!

  6. #6
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    There is a white paper at

    www.Quest.com - "Implementing RAID on Oracle" by Gaja Krishna Vaidyanatha
    OCP 8i, 9i DBA
    Brisbane Australia

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