layout for datafiles

[a128]

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,

[ggnanaraj]

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.