Re: Oracle.exe taking too much physical ram

Hi Arslan,

Without know anything else it would be difficult to diagnose exactly what to do. But from the size of the allocated SGA it appears that you need to reduce some of these parameters.

 From v$sga you have
640 MB of database buffer cache
80 MB of shared pool and other things

What else is running on this machine?
Is it only a db server?

It appears to me that you need to reduce the db_block_buffers parameter. To reduce paging and swapping at the os level. As I said at the beginning, this is only a guess based on very limited information.

John

arslandar_at_skm.org.pk wrote:

>
>
> Hi gurus,
>
>
>
> My Production Box has 1Gb Ram with single 933Mhz PIII processor ,
> though the db is not that big (4 GB), the oracle process is taking too
> much of memory, causing server to slow down on peak times of the day,
> and even after words, tonight, I looked up the memory which ORACLE.EXE
> has taken, its almost 900 MB, why is that so ???
>
> The last restart was a month ago as far as I remember, is this an
> OPERATING SYSTEM tuning problem or database tuning is required?
>
> MY pagefile size is almost 2 GB, but the STATISTICS show that only 4-5
> MB of physical memory is free, means the most of the physical memory
> is used in ORACLE processes,
>
> The sga size is following,
>
>
>
> SQL> select * from v$sga
>
>
>
> NAME VALUE
>
> -------------------- ----------
>
> Fixed Size 75804
>
> Variable Size 90701824
>
> Database Buffers 655360000
>
> Redo Buffers 77824
>
>
>
>
>
> If db tuning is needed, from what point I should start,
>
> Also, I haven't analyzed the schemas from long, The occasion DEAD
> LOCK problems also show up,
>
>
>
> Can anybody shed some light, where the choke point is ???
>
>
>
> Help and suggestions welcomed,
>
> Thanks in Advance,
>
>
>
>
>
> Arslan Zaheer Dar
>
> arslandar_at_skm.org.pk
>
> Database Administrator
>
> Shaukat KhanumMemorial CancerHospital & Research Centre
>
> www.shaukatkhanum.org.pk
>
> + 92 (042) 5180725 - 34 Ext: 2323
>
>
>
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ora NT DBA
  INET: orantdba_at_netscape.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).