Why oracle.exe using so much "Mem Usage" and "VM Size"?

Posted on 2006-04-28
Last Modified: 2013-12-11
I have been noticing this recently in my computer: Eventhough I'm not running any application or program related to ORACLE, oracle.exe gives me high number of memory and virtual memory size.

The last time I checked the task manager right after I restarted my computer:
The "Mem Usage" is 97, 488
and the "VM Size" is 169, 888 K

I'm pretty new with using ORACLE. Is the mem usage and the VM size this big supposed to be normal?

Thanks in advance for the help.
Question by:rnicholus
    LVL 3

    Expert Comment

    Dear rnicholus,
     On windows environment Oracle.exe is the process having many subprocesses inside it (background processes and parallel thread processes) which responsible for user query response,  if you will shutdown oracle database the its service using shutdown command this will disappear.

    Moreover its used memory size can be limited by decreasing database parameter sga_max_size and pga_aggregate_target.

    Haider Ali Syed
    Sr. IT Exective Databases

    Author Comment

    Hello Haider,

    Thanks for the lead.
    I'll get back to this asap.
    LVL 47

    Expert Comment

    970 MB memory.
    This depends of the SGA the DBA has assigned to this instance.
    To see the real size of the SGA components either use OEM or
    SQL> show sga

    Total System Global Area  289406976 bytes
    Fixed Size                  1260420 bytes
    Variable Size             109053052 bytes
    Database Buffers          171966464 bytes
    Redo Buffers                7127040 bytes

    Author Comment


    I have two questions now:
    1. Is restarting the computer should actually help? Because it seems that it doesn't in my case.
    2. Haider: I have tried to restart the OracleServiceSTARTDB and OracleOraHome92TNSListener a number of times but it doesn't help also. Is this what you mean?

    Thanks for the help.
    LVL 47

    Assisted Solution

    There is a famous old respectable expert here - Mark Geerlings. He also mentioned that they reboot the machine (not Oracle) once weekly. I also suffer on Windows 2000 2 years  (9i) this phenoma and couldn't find resolution. From November 2005 we have Windows XP Professional and Oracle and we have no complains. Oracle runs smoothly ...
    LVL 2

    Expert Comment

    What you are seeing is normal, restarting oracle or the box will have no effect.
    Oracle will grab the amount of SGA you have configured, (whether you run any programs or not, this gets pre-allocated) and the server processes will use this memory.

    There would be some more memory requirements (PGA) once you start some programs that access the database.

    If your other applications are suffering because of low memory you might want to reduce the SGA by changing init.ora parameters, but this might adversely affect your database performance.
    LVL 47

    Expert Comment

    Investigate the size of the SGA. In Windows it should not be greater
    the the half of the physical RAM.

    Please publish the size of the SGA, number of instances on the box and the size of the RAM.

    As said (I suffer 2 years) W2000 is not the best for Oracle servers (i met often 100% CPU usage).
    LVL 3

    Accepted Solution

    Ok after logging in as DBA user system or sys

    give command
    sql> Sho sga

    smaple output is

    Total System Global Area 1702363268 bytes
    Fixed Size                   458116 bytes
    Variable Size             654311424 bytes
    Database Buffers         1056964608 bytes
    Redo Buffers               10629120 bytes

    sho parameter db_cache_size

    (if oracle 9i is there)
    for 8i

    sho parameter db_buffer

    This database sga is about 1.6 GB (from tatal global area size 1702363268 )

    Now you can change it to any less value by

    1- please backup your dbs and database folder to some location

    for oracle 9i

    2- log in as SYSDBA

    3- Alter system set sga_max_size=1400M scope=spfile;
    4- Alter system set db_cache_size= (any value less then returen from db_cahce_size ) scope=spfile

    sql> shutdown immediate
    sql > startup


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Oracle Pivot 8 56
    Sql to get orphans 7 47
    Update table using multiple table qualifications 12 30
    percentage remaining 6 30
    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now