Hi all...

I have a plan to install Oracle 10g on a server, on (240*2) hard disk, ( 2 hard disks each of 240GB )

Also only Oracle Database server sits in this Machine on RHEL 5.4 AS, There are around 15 support users who will have access to the server.

The data files of database will be on SAN...

My partitioning plan is
Also I am planing to utilize rest of the disk spaces to future use. In future under what circumstances can i use rest of the disk space ?

Will the above partitioning plan is OK...

Can anyone please suggest....

Awaiting for Positive responses...Any help will be greatly appreciated..Thanks in advance.....

Which file system will the Oracle files go on? How big are they?

The old rule-of-thumb to make swap twice the size of real memory does not have a rational basis. This being a database server, presumably you have no plans to use suspend (that removes an important factor in deciding swap size) so you swap size can be calculated based on expected memory usage. An Oracle DBA, with knowledge of your database and how it will be used, is best placed to advise on expected memory usage.

Alternatively, if you have more than enough disk space, you can make swap big and see how much of it is actually used when you start using the database; if you then need more disk space for file systems (or can Oracle better use raw partitions without file systems?) it's easy to reduce the swap space and you wil know how muuch this particular system actually needs.

Thank you very much catkin,


Oracle files will go to SAN, Which has almost 1000 GB size, it will be ext3 filesystem

Will the above mentioned partitions are OK ? Also how i can best utilize the rest of local disk free space in future..?

Thanks in advance....

Those sizes look plenty big enough (IDK how big the Oracle software is, though) but you have lots to spare. You might like to have a separate /home to facilitate alternative or upgrade OS installation. You might like to leave free space between your partitions to facilitate enlarging them if needs must -- a very small performance penalty and a great convenience.