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

Thread: file system vs OFA standard

  1. 11-18-2002, 10:05 PM #1
    dba_admin
    dba_admin is offline Senior Member
    Join Date
    Mar 2001
    Posts
    287

    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?
    Reply With Quote Reply With Quote
  2. 11-19-2002, 12:52 AM #2
    alapps
    alapps is offline Member
    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)
    Reply With Quote Reply With Quote
  3. 11-19-2002, 01:05 AM #3
    Calvin_Qiu's Avatar
    Calvin_Qiu
    Calvin_Qiu is offline Senior Member
    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
    Reply With Quote Reply With Quote
  4. 11-19-2002, 01:06 AM #4
    nnigam
    nnigam is offline Junior Member
    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
    Reply With Quote Reply With Quote
  5. 11-19-2002, 12:42 PM #5
    dba_admin
    dba_admin is offline Senior Member
    Join Date
    Mar 2001
    Posts
    287
    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!
    Reply With Quote Reply With Quote
  6. 11-19-2002, 06:37 PM #6
    grjohnson's Avatar
    grjohnson
    grjohnson is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width