layout for datafiles
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: layout for datafiles

  1. #1
    Join Date
    Apr 2001
    Posts
    257
    Hi,

    If I have /ora01,/ora02, /ora03, /ora04 partitions on my Solaris system and two databases ( in additon to the standard datafiles for SYSTEM, RBS, TEMP, INDEX, etc, each database has only one datafile/tablespace for user data), are there any recommended guidelines on how to spread all these datafiles around? We currently have both databases' user tablespace/datafiles on the same partition and I thought it is a bad idea.

    Also, any guideline for maximum size of a datafile in general?

    Thanks,

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Hi

    To decrease disk contention and thereby increase performance...

    Separate 'user' and 'index' on separate file systems.
    So also, 'SYSTEM' on separate file system.
    As you have 4 file systems only, can keep 'RBS' and 'TEMP' on the same file system.

    Hope you have independent disks and not all file systems on one disk.

    Cheers.






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