Showing posts with label db console. Show all posts
Showing posts with label db console. Show all posts

Wednesday, June 24, 2009

High CPU after DB Console start in 11g

Hi,

If you have a problem with Oracle sessions taking a high CPU load in 11g after you start a DB Console check if any of these session is executing following query:

SELECT EXECUTION_ID, STATUS, STATUS_DETAIL FROM MGMT_JOB_EXEC_SUMMARY
WHERE JOB_ID = :B3 AND
TARGET_LIST_INDEX = :B2 AND EXPECTED_START_TIME = :B1

If yes, you can fix it using that steps:

  1. stop DB Console

    emctl stop dbconsole

  2. connect as sysman using SQL*Plus execute both procedures

    SQL> execute MGMT_PAF_UTL.STOP_DAEMON;
    SQL> execute MGMT_PAF_UTL.START_DAEMON;

  3. Start DB Console

    emctl start dbconsole
This is reported as bug number 7182962

Marcin