Need a decent documentation on Oracle Physical Database Layouts
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Need a decent documentation on Oracle Physical Database Layouts

  1. #1
    Join Date
    Oct 2001
    Location
    Lexington
    Posts
    11
    Where can I find a decent documentation on Oracle Physical Database Layouts for the best performance ? I mean answers for questions like: --
    Where should the datafiles be ? Where should the index datafiles be ? Where should the redologs be ? Should it be multiplexed ? Control Files ? Multiplex control files ?
    Thanks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well that comes with Oracle documentation, serach on OFA

  3. #3
    Join Date
    Oct 2001
    Location
    Lexington
    Posts
    11
    Thank you Pando...What I am searching for is " Tips for Disk I/O load balancing" precisely.

  4. #4
    Join Date
    Oct 2001
    Location
    Buffalo, NY
    Posts
    46
    "Oracle 8i DBA Handbook" by Oracle Press has a 60-page chapter on physical layouts. Try that one.
    Tim Hussar

  5. #5
    Join Date
    Oct 2001
    Location
    Lexington
    Posts
    11
    Thank you.

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