Oracle 11gR1 100% CPU Usage Overhead running EM DBConsole
EM shows SQL that eats up CPU:
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
Any ideas what could be locked or stuck?
SQL> select count(*) from mgmt_job_exec_summary;
COUNT(*)
53398
- One session is consuming a lot of CPU (about 70% of 1 CPU and 55% of 2 CPU) in a sustained way. It also holds several locks on SYSMAN objetcs. That's session MODULE is OEM.CacheModeWaitPool. It seems to be looping with the following queries:
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;
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;
INSERT INTO mgmt_job_exec_summary
(job_id, job_type_id, execution_id, expected_start_time,
start_time, end_time, source_execution_id, target_list_index,
status, status_detail, triggering_severity
)
VALUES (:b11, :b10, :b6, :b9,
:b8, :b7, DECODE (:b5, NULL, :b6, :b5), :b4,
:b3, :b2, :b1
);
Essentially for the linux platform:
./emctl stop dbconsole
./sqlplus SYSMAN
SQL> execute MGMT_PAF_UTL.STOP_DAEMON
SQL> execute MGMT_PAF_UTL.START_DAEMON
./emctl start dbconsole
FROM:
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22036495/viewspace-1052505/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 11g rac配置em dbconsole ORA-12514Oracle
- 配置Oracle DBconsoleOracle
- 1002 Running Median
- [Oracle Script] Temporary Sort UsageOracle
- [Oracle Script] Rollback Segment UsageOracle
- Oracle runInstaller 's UsageOracle
- Oracle NUMA usage recommendationOracle
- Oracle DBConsole重新配置Oracle
- Oracle dbconsole can't startOracle
- 關於oracle的dbconsoleOracle
- ORACLE EM recreateOracle
- 重建oracle EMOracle
- Check the transaction running in oracleOracle
- Long running Operations in OracleOracle
- [Oracle Script] check tablespace usage infoOracle
- [Oracle Script] check temp tablespace usageOracle
- [Oracle Script] Undo Usage Per statusOracle
- [Oracle Script] Undo Usage Per sessionOracleSession
- Oracle 11g tablespace usageOracle
- Oracle程式導致CPU 100%解決步驟(轉)Oracle
- oracle EM 優化Oracle優化
- oracle 重建EM databaseOracleDatabase
- oracle em 修改埠Oracle
- Oracle 11gR1中的SecureFileOracle
- Oracle NUMA Usage Recommendation [ID 759565.1]Oracle
- Oracle效能優化-資料庫CPU使用率100%Oracle優化資料庫
- Oracle 19C EMOracle
- oracle EM配置命令解析Oracle
- oracle重新配置emOracle
- Oracle中EM的配置Oracle
- 重灌 ORACLE 10.2.0.1.0 EMOracle
- V$TEMPSEG_USAGE與Oracle排序Oracle排序
- CPU100%排查總結
- OMF (Oracle Managed Files) Usage for Datafiles [ID 137482.1]Oracle
- Oracle 11G EM建立Oracle
- ORACLE 12C EM ExpressOracleExpress
- Oracle 12C配置EMOracle
- oracle 11g em recreateOracle