Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Oracle.exe taking too much physical ram
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 ???
SQL> select * from v$sga
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,
Arslan Zaheer Dar
--
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,
NAME VALUE
-------------------- ----------
Fixed Size 75804
Variable Size 90701824
Database Buffers 655360000
Redo Buffers 77824
Thanks in Advance,
arslandar_at_skm.org.pk
Database Administrator
Shaukat Khanum Memorial Cancer Hospital & Research Centre
www.shaukatkhanum.org.pk
+ 92 (042) 5180725 - 34 Ext: 2323
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arslan Dar
INET: arslandar_at_skm.org.pk
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).
Received on Wed Mar 13 2002 - 09:33:42 CST
![]() |
![]() |