Oracle-L: RE: Oracle taking too much physical memory

From: <tday6_at_csc.com>
Date: Wed, 13 Mar 2002 10:03:43 -0800
Message-ID: <F001.004278B7.20020313100343@fatcity.com>

My bad. I didn't notice that he was doing a select * from v$sga and thought that it was the init.ora parameters.

My comments on the SGA size were based on WinNT 4.0. I assume, from your comments, that W2K is better about not swapping the RAM out to disk.

                                                                                           
                    "MacGregor,                                                            
                    Ian A." <ian         To:     Multiple recipients of list ORACLE-L      
                    @SLAC.Stanfor        <ORACLE-L_at_fatcity.com>                            
                    d.EDU>               cc:                                               
                    Sent by: root        Subject:     RE: Oracle taking too much physical  
                                         memory                                            
                                                                                           
                    03/13/2002                                                             
                    11:53 AM                                                               
                    Please                                                                 
                    respond to                                                             
                    ORACLE-L

You have one gigabyte of memory on your machine and your SGA is over 700 MB. That seems excessive I doubt you need 640 megabytes' worth of block buffers. There is nothing wrong by the way with nearly exhausting physical memory. However improperly assigning it is a problem, as is excessive paging.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu
-----Original Message-----
Sent: Wednesday, March 13, 2002 7:29 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_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 - 12:03:43 CST