-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|