Re: Max SGA size in 32 bit Oracle

From: GC <assistant_madman_at_hotmail.com>
Date: Thu, 22 Feb 2001 01:59:00 GMT
Message-ID: <3A94737A.E18470E4@hotmail.com>

kipnukdog wrote:
>
> Sybrand, thanks.
> I understand the guidelines, but is it possible, say on a 16GB Memory machine
> would you be able to allocate more than 2.5 GB to the SGA? (we have some very
> large buffer_pool_keep requirements) I have read on a 32 bit Oracle
> installation, 1.74GB is max, unless you remap the SGA in the kernel, and then
> you are allowed up to 2.5GB.

If you are running 64-bit, then yes, you can have a larger SGA than 2.5GB (we have a db with about 8GB sga). If it's 32-bit, then no, you are stuck with the 2.5GB limitation.

Cheers,
GC Received on Wed Feb 21 2001 - 19:59:00 CST