Oracle 10g hardware sizing guide

[sheevm]

Hi All,

We are planning rp4410 server for our production Oracle server. Oracle version is 10g. I am looking some kind of hardware sizing and capacity planning document. Can anyone help?

Thanks.
Raji

[Wang,MinJie]

Hey here is some information
I hope it will help you:
Physical memory (RAM) 512 MB (524288 KB)
Swap space 1 GB (1048576 KB) or twice the size of RAM
On systems with 2 GB or more of RAM, the
swap space can be between one and two times
the size of RAM
Disk space in /tmp 400 MB (409600 KB)
Disk space for software
files
3.5 GB (3670016 KB)
This value includes 1 GB (1048576 KB) of disk
space required to install the Oracle Database 10g
Products from the Companion CD (optional, but
recommended).
Disk space for database
files
1.2 GB (1258290 KB)
System architecture 64-bit

[Steven E. Protter]

Shalom Raji,

It depends a lot on what the database will be doing.

If its OLTP,moderate size, I'd reccomment a 2 GB minimum. An rp4410 can handle a moderate database with moderate I/O most reasonably.

Take care about storage. If its OLTP online transaction processing and there are heavy writes, doing the writes on a RAID 5 disk array (most NFS ones) will impede performance. This is a lesser but evident problem with fiber connected disk.

If you want to run 10gAS, bump the memory up to 8 GB.

SEP

[sheevm]

Thanks for the input. Is there any whitepaper on this. The reason is I just want to support the sizing with some documentation for record keeping purposes and also to present to the management.

Thanks.
Raji