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?
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.
Click Here to Expand Forum to Full Width