Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g2DJm0l01482 for ; Wed, 13 Mar 2002 14:48:00 -0500 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id LAA13499; Wed, 13 Mar 2002 11:23:33 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 00427911; Wed, 13 Mar 2002 10:13:41 -0800 Message-ID: Date: Wed, 13 Mar 2002 10:13:41 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Chen, Brian" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Chen, Brian" Subject: RE: Oracle.exe taking too much physical ram Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C1CABB.18FF3C80" ------_=_NextPart_001_01C1CABB.18FF3C80 Content-Type: text/plain; charset="iso-8859-1" We experience the same problem in our production server. We contact Oracle support and upgrade the server from 8.1.6.3.7 to 8.1.6.3.8. The problem did not resolve. They suggest us to upgrade to 8.1.7.3. We have not upgraded yet. Brian Chen Database Administrator Bowne & Co. 345 Hudson Street NY 10014 (212)-931-1878 -----Original Message----- Sent: Wednesday, March 13, 2002 10:34 AM To: Multiple recipients of list ORACLE-L 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@skm.org.pk Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre www.shaukatkhanum.org.pk + 92 (042) 5180725 - 34 Ext: 2323 ------_=_NextPart_001_01C1CABB.18FF3C80 Content-Type: text/html; charset="iso-8859-1" Oracle.exe taking too much physical ram

We experience the same problem in our production server. We contact Oracle support and upgrade the server from 8.1.6.3.7 to 8.1.6.3.8. The problem did not resolve. They suggest us to upgrade to 8.1.7.3. We have not upgraded yet.

Brian Chen
Database Administrator
Bowne & Co.
345 Hudson Street
NY 10014
(212)-931-1878

-----Original Message-----
From: Arslan Dar [mailto:arslandar@skm.org.pk]
Sent: Wednesday, March 13, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L
Subject: 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 ???

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@skm.org.pk
Database Administrator
Shaukat Khanum Memorial Cancer Hospital & Research Centre
www.shaukatkhanum.org.pk
+ 92 (042) 5180725 - 34 Ext: 2323

------_=_NextPart_001_01C1CABB.18FF3C80-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chen, Brian INET: Brian.Chen@Bowne.com 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@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).