Determining Memory Allocations - Dedicated/Shared Server

From: Dereck L. Dietz <>
Date: Thu, 24 Jan 2008 23:50:00 GMT
Message-ID: <Iu9mj.1361$>

I've found "formulas" for determining the SGA/PGA sizing for a dedicated server.

Using a formula from the Burleson Consulting web site I was able to come up with these figures:

  • 8 GB -- -- 16 GB -- -- 32 GB -- Total RAM on Windows Server 8,191.0 MB 16,384.0 MB 32,767.0 MB


 Total PGA regions for 100 users 3,980.0 MB 3,980.0 MB 3,980.0 MB

 RAM reserved for Windows (20%) 1,638.2 MB 3,276.8 MB 6,553.4 MB

 RAM for SGA & Buffers                   2,572.8 MB  9,127.2 MB 22,233.6 MB

What I've been trying to find out is how would I determine the memory allocations if both dedicated and shared connections would be in use? Is the memory allocated for a shared server configuration, a dedicated server configuration or is there a "hybrid" server configuration that's used? Received on Thu Jan 24 2008 - 17:50:00 CST

Original text of this message