Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2006

    Unanswered: Monitoring oracle process

    I'm monitoring the memory used by oracle process.
    I have a process which make a lot of connections to oracle in order to execute sql sentences.
    I think that my oracle process are spending much memory. Using unix comands to watch it, i can see:

    user 2064598 15,3 1,0 55056 25684 oracleTW9
    user 2105482 0,0 1,0 54392 25752 oracleTW9
    user 1876164 0,0 1,0 54364 25720 oracleTW9
    user 1867888 0,0 1,0 54364 25596 oracleTW9
    user 1884370 0,0 1,0 54364 25712 oracleTW9
    user 1859738 0,0 1,0 54364 25720 oracleTW9

    I'm not sure but i thinks that data about memory (%MEM, SZ , RSS) are high because the oracle process are sql sentences with low volume of data (not heavy sql)

    Is there any way to reduce this memory used???, can I modify my connection to oracle in order to change a memory parameter??

    Any advice will be greatly apreciatted

  2. #2
    Join Date
    May 2004
    Dominican Republic
    No Unix flavor to start with, makes things difficult. Are you running low on memory ? what has vmstat to say ? I woulnd't worry too much about it myself, unless I know I have some non-oracle processes leaking memory here and there. Oracle will use and release memory as it believes it need it. If you want to change 'the memory parameter' you should look under the Oracle documentation under your especific unix version to change kernel parameters that affect memory management.

  3. #3
    Join Date
    Jan 2004
    the question you have to ask yourself is why is the process using more memory? intial steps to take is to start investigating what is going on within the what SQL statements are being executed? what is the impact? full table scans? concurreny? what wait events exist in the database..that should shed more light..whether there is a genuinue problem.

  4. #4
    Join Date
    Jun 2003
    West Palm Beach, FL


    Best way to monitor Oracle is to use OEM>Tools>Performance Overview {or Performance Manager}

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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