RE: SGA question

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 16 Jul 2003 20:46:42 +0100
Message-Id: <25937.338121@fatcity.com>

> surely i will not do it. but my question is whether it
> is possible at all to do it.
>
> will oracle when allocating shared memory space take
> virtual memory into consideration or only real memory
> into consideration.
>
> thanks
> sai

I believe that the answer is, as of 9i, it depends.

Generally speaking yes you can over allocate memory and kill your instance performance.
As of 9i the parameter LOCK_SGA enforces that the SGA is kept in real memory, presumably killing startup if sufficient real memory is unavailable. Received on Wed Jul 16 2003 - 14:46:42 CDT