Memory Usage by Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Memory Usage by Oracle

  1. #1
    Join Date
    May 2001
    Location
    Delhi
    Posts
    341
    Hi,

    I m running Oracle 816 on NT 4.0. / 2 GB RAM / SGA 1104

    On checking in Task Manager I can c that Oracle.exe is taking Memory to the tune of 1482704 KB.

    IS IT HIGH on a system with 2 GB RAM.

    What can i do other than adding more RAM to the system.

    How it affects the performance....

    Vijay

    --------------------------
    The Time has come ....

  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,591
    I think it's rather high. It's not the VM ,is it?
    Adding more ram will not help if you reactively keep increasing the shared memory,sga as on NT you can't have a process consuming more the 2 Gigs.
    So i guess if you find it worrisome try tuning your queries and containing your memory usage.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    May 2001
    Location
    Delhi
    Posts
    341
    Hi,

    I understand that is high.

    How can I find that all of that is in RAm or in PageFile (VM),

    I hv a pagefile of 10 Gig, As i m also running SAP CI on the same Server.

    My parameters which contributes towards a session are also not very high.

    What could be done.

    Vijay
    --------------------------
    The Time has come ....

  4. #4
    Join Date
    May 2002
    Posts
    193
    Try mailing the statspack report to me at diwakar_2001@lycos.com . I shall have a look at it and get back.

    Regards,

    K.Diwakar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width