Oracle Database Installation Estimating Disk and Memory Requirements Consideration

Oracle Database Installation  Estimating Disk and Memory Requirements Consideration

•  Make sure the storage vendor is listed in the Oracle Storage Compatibility Program (OSCP).

•  Allocate swap space that is about two to three times your Oracle RAM allocation.

•  On Estimating the RAM:

  o OS RAM: 20 percent of total RAM for MS-Windows, 10% of RAM for UNIX

  o Each Oracle connection consumes two megabytes of RAM + sort_area_size + hash_area_size

   

   If dynamic memory sizing is not used:

•  Shared_pool_size: If all the SQL statements that sent to ORACLE are using bind variable adequately, then 300M is enough in most cases

•  Large_pool_size: For dedicated Oracle server: 20-30M

• Java_pool_size=10M

•  Data buffer: All the rest RAM should be allocated to Data buffer.