Message-Id: <25937.338121@fatcity.com> From: "Niall Litchfield" Date: Wed, 16 Jul 2003 20:46:42 +0100 Subject: RE: SGA question > 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.