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 EM 優化Oracle優化
- Tuning CPU 100% in Oracle 11g rac-20220215Oracle
- Oracle 19C EMOracle
- Oracle效能優化-資料庫CPU使用率100%Oracle優化資料庫
- CPU100%排查總結
- Oracle 19c Database Configure the HTTPS Port for EM ExpressOracleDatabaseHTTPExpress
- dnsjava usageDNSJava
- ORACLE 11G OCM備考之建立EM與EM登陸異常的處理Oracle
- mysql cpu 100% 滿 優化方案MySql優化
- crontab usage guideGUIIDE
- CPU持續100%分析並解決
- se://error/ Oracle 19c EM Exporess無法登陸ErrorOracle
- EM
- 一次OutOfMemoryError: GC overhead limit exceededErrorGCMIT
- cpu佔用率100%怎麼解決 cpu佔用率高怎麼辦
- 1002 Running Median
- MySQL, Incorrect usage of UNION and ORDER BYMySql
- SAP QM Auto Usage Decision
- Inspection Points: Key settings and Usage
- docker執行容器後agetty程式cpu佔用率100%Docker
- JAVA CPU100%與執行緒死鎖定位Java執行緒
- em 和 remREM
- Win10絕地求生CPU佔用100%怎麼回事 Win10絕地求生CPU佔用100%的解決教程Win10
- 【DB寶49】Oracle如何設定DB、監聽和EM開機啟動Oracle
- 執行sed命令卡死CPU消耗100%一例分析
- mysql資料庫Cpu利用率100%問題排查MySql資料庫
- rem與em的區別||結合使用rem與emREM
- IDEA中Usage提示功能設定Idea
- Oracle11g新增檢視查詢表空間使用率DBA_TABLESPACE_USAGE_METRICSOracle
- Oracle查詢前100萬條資料Oracle
- 百度學術改版與 CPU 100% 有關係麼?
- 一次生產 CPU 100% 排查優化實踐優化
- 記錄一次 PHP-fpm 佔 CPU 100% 修復PHP
- Google Chrome發現新Bug CPU使用率飆升至100%GoChrome
- win10開個遊戲就佔用100的CPU怎麼辦 win10玩遊戲就佔用100的CPU解決方法Win10遊戲
- 04EM演算法-EM演算法收斂證明演算法
- px em rem 探討REM
- EM演算法1演算法