Large Oracle Process Memory Use
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Large Oracle Process Memory Use

  1. #1
    Join Date
    Apr 2000
    Location
    Charlotte, NC, USA
    Posts
    48

    Large Oracle Process Memory Use

    Hi,

    I am new to an Oracle system and I am noticing something that I have never seen before. Their user process use huge amounts of memory, ie each process may have 300M of RAM. The SGA size for the instance in question is only 300M itself. What could be causing such a high usage of memory. I am using top as my tool of reference. I heard a rumor about open_cursors. Please advise.
    "If you are going through hell, keep going...". -Churchill

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The user processes use shared memory.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2003
    Posts
    85
    you cant trust TOP for this matter, if you are in Solaris use pmap

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    What is your sort_area_size ?
    Last edited by SANJAY_G; 02-26-2003 at 03:37 AM.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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