Re: SGA size limited to 1GB?

From: Neilc <neilc-olops_at_btinternet.com>
Date: Wed, 1 Sep 1999 14:00:07 +0100
Message-ID: <7qj83r$8db$1@pheidippides.axion.bt.co.uk>

The SGA size is typically limited by the size of a shared memory segment supported by your Unix system. this value usually configurable via the kernel parameter SHMMAX and is the size in bytes of the largest shared memory segment allowed.

hope this helps

Robert Chung wrote in message <37cc5b54.351147890_at_news.mindspring.com>...
>
>We have a Unix machine with 16 giga bytes of physical memory running a
>huge Oracle database. Problem is, since maximum Oracle SGA size is
>only 1 giga bytes, most of physical memory sits idle, not being used.
snip Received on Wed Sep 01 1999 - 08:00:07 CDT