Re: Oracle taking too much physical memory

From: <tday6_at_csc.com>
Date: Wed, 13 Mar 2002 08:38:29 -0800
Message-ID: <F001.004275CD.20020313083829@fatcity.com>

Reduce the number of DB_BUFFERS. Unless my eyes deceive me, if you have a 2k block size, then you're trying to allocate 1.2G of SGA just for the DB_BUFFERS. On an Intel system (I assume W2K), I wouldn't try to allocate more than 1/2 the physical RAM for the total SGA. Windows will still swap you out to the swap file, but if you make the swap file just slightly larger than your RAM, it will only swap out one copy of the RAM. BTW, if you do make the swap file that small, don't use the server for a workstation!!! Just let it sit there in a dark room.

                                                                                           
                    Arslan Dar                                                             
                    <arslandar           To:     Multiple recipients of list ORACLE-L      
                    @skm.org.pk>         <ORACLE-L_at_fatcity.com>                            
                    Sent by: root        cc:                                               
                                         Subject:     Oracle taking too much physical      
                                         memory                                            
                    03/13/2002                                                             
                    10:28 AM                                                               
                    Please                                                                 
                    respond to                                                             
                    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_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:
  INET: tday6_at_csc.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_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 - 10:38:29 CST