Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Tuesday, July 19, 2011

oraagent.bin consuming more or leaking memory

The below process is taking up almost 27g memory on the database server.

it's 11gR2 ---11.2.0.1

PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND

18583 oracle 46 59 0 27250M 26740M sleep 74.8H 0.27% oraagent.bin


According to the below notes:

ORAAGENT or ORAROOTAGENT High Resource Usage [ID 1062676.1]

Bug 10168006 - oraagent process memory growth periodically [ID 10168006.8]

confirms it is a known bug and as a work around just the kill the process and oracle will re spawn the process.

3 comments:

Anonymous said...

Dear Sameer,

I am facing this problem with 11g2RAC on Windows. When oraagent consume memory too much, kill process or restart server may temporarily solve. But the problem will comeback again after a couple days. Do you have any suggest in this case.

Any help will be very appreciate.
Ch

Gaurav Dutt said...

my topas command show lots of pgsp for orarootagent.bin. What is the first command you used to see the process consuming lots of memory.

sameer said...

use this:

prstat -s size

prstat usage is explained here.

http://www.shaiksameer.com/2011/08/unix-prstat-vs-top.html