Pages

Monday, March 1, 2010

100% CPU Usage Overhead running EM DBConsole 11g on Windows 7 64bit

I think am starting to like Oracle DB, Not that i hated the damn thing. I just never thought i would be using anything other than MSSQL, and object databases. But lets face it, Oracle 10g Express was a big milestone for oracle especially with the introduction of APEX.

I just fell in love with this simple to use technology that allowed me to build exceptional, high end online application using only plsql and some java script (my kind of thing)
Nway i finally got the nerve to do the whole installation on my hp dv5 pavilion laptop with intel core 2 duo processor and 4 gb of ram. (a killer machine......i guess). So after a normal restart all hell breaks loose...Oracle RDBMS kernel service consumes upto 1.5 gb of ram and the cup clocks 100

At that moment, i hated Oracle...I finally decided to do some digging on the net and realized that the problem is universal, affecting even linux machines.
100% CPU Usage Overhead running EM DBConsole 11g

Nway according to this blog this is how you solve the problem


emctl stop dbconsole (or stop the OracleDBConsoleSID Windows service)

create table mgmt_job_bad as select * from sysman.mgmt_job where job_name = 'PROVISIONING DAEMON';
delete from sysman.mgmt_job where job_name = 'PROVISIONING DAEMON';
commit;

emctl start dbconsole (or start the service)


You can still check this link and this one for additional details..But what makes me made is that oracle is aware of this and they have released a patch but it is only available to meta-link users

Nway my focus is set the oracle platform......i think its going to be really interesting
.....

1 comments:

Anonymous said...

For 11.2.0.3 on RHEL 6

Enterprise Manager Management Agent or OMS CPU Use Is Excessive on or around July 1, 2012 (Doc ID 1472651.1)
Leap Second Hang - CPU Can Be Seen at 100% (Doc ID 1472421.1) This affects Java processes.

According to these notes issue should be fixed by either restarting host or running the following commands:

# /etc/init.d/ntpd stop
# date -s "`date`" (reset the system clock)
# /etc/init.d/ntpd start

example
/etc/init.d/ntpd stop
date -s "2012-07-10 14:42:42"
/etc/init.d/ntpd start

Post a Comment