-
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,
-
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.
