Re: 3GB RAM usage by Oracle

DGK 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

Not going to happen. And if it does ... it will be one of the worst configurations possible.

What makes you think Oracle using more RAM is a good thing? In your specific situation?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)