Re: 3GB RAM usage by Oracle

On Mon, 23 Aug 2004 11:27:48 +0530, "DGK" <Ganesh.Kamath_at_in.bosch.com> wrote:

>Hello,
>
>I have the following configuration:
>
>O/S: W2K
>RAM: 3GB
>Pagefile: 4GB
>Oracle version: 8.1.7
>SGA: 1,290,397,724
>Current usage of RAM: 1.5GB
>
>Since this server is dedicated only to Oracle database, I want it to utilise
>the full available RAM of 3GB. I tried to increase the sga size by by
>changing the DB_BLOCK_BUFFERS. But during database startup, I receive the
>following messages;
>
>ORA-27101 shared memory realm does not exist and ORA-27102 out of memory.
>
>Could anybody help me to solve this problem?
>
>thanks,
>GK
>

If you really want to end up in hell and use that much memory, consider swapping W2K for a real O/S

--
Sybrand Bakker, Senior Oracle DBA