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

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

****************Got the opportunity to pen a Book on Database Cloud Services.......More details to follow.***************

Title : Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2020

**********************************************************************************


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Azure Certified Architect

Azure Certified Administrator

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

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