Re: 3GB RAM usage by Oracle

Thanks for all the replies.

The application was having very bad response time. As a first step, I found that the RAM usage as follows:

• Oracle: around 1.3GB
• Other Windows processes around: 0.2GB

So I was thinking rest of the RAM (1.5GB) is not being utilised. Hence I posted the question.

Now I have tuned few of the SQL statements and found that response time has increased.

best regards,
DGK "DGK" <Ganesh.Kamath_at_in.bosch.com> wrote in message news:cgc11a$m3q$1_at_ns1.fe.internet.bosch.com...
> 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
>
>
Received on Tue Aug 24 2004 - 01:06:45 CDT