Recommended RAM and disc space for Oracle 11g on Windows

Posted by Álvaro G. Vicario on Server Fault See other posts from Server Fault or by Álvaro G. Vicario
Published on 2012-06-07T09:07:32Z Indexed on 2012/06/07 10:42 UTC
Read the original article Hit count: 316

I need to provide the recommended amount of RAM and disc space (divided in two partitions) so the customer can create an appropriate virtual machine to run Oracle. All I could find in the documentation was a brief listing with minimum RAM and typical/advanced install types.

The virtual machine will run latest Oracle Standard Edition One (11g release 2 so far) under Windows Server 2008 x64 and will host a reasonably low traffic web application.

How much RAM and disc must I ask for in order to be safe?

(Feel free to ask for further details if I've omitted something relevant.)

Update:

Rough estimations:

  • Database size: 10 MB after installation
  • Growth rate: +3MB per day on average
  • Size of database 'active' data: (not sure of what this means, there's not actual archive so I guess all data is current)
  • Amount of data written per second in peak hours: a few KB
  • Number of client sessions: 3 or 4 at most
  • Frequency and response size of most heavy requests: some reports make heavy table JOINS that need up to 20 seconds to complete but they won't return more than a few thousand rows with plain text. The app also handles BLOBs (typical size from 50KB to 200KB)

© Server Fault or respective owner

Related posts about windows-server-2008

Related posts about oracle11g