RE: Oracle.exe taking too much physical ram

Because shared_pool_size, db_block_buffers, log_buffer, java_pool_size, and perhaps other memory-related init.ora parameters, are set too high. Cut them down to size. Allow enough memory for user sessions.  

db_block_buffers x db_block_size = memory for the database buffer cache.
(this is the v7 formula anyway)
 

Read the Concepts Manual and the Administration Manual.  

Oracle doesn't get paged out because it regularly updates its data block headers. More often than the OS can swap to disk. You can have a 300G pagefile and it won't help you.  

Only user sessions sometimes get swapped to disk, if they remain idle for a period of time.  

Don't plug in values generated by the OEM Oracle Expert tool, if you used that to determine values for init.ora parameters. Always do your own calculations to double-check .  

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes 
Technology Services        | Services technologiques 
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO 

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

-----Original Message-----
Sent: Wednesday, March 13, 2002 11: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_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: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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).