当前位置:Gxlcms > mysql > OracleinternalqueriestakingmoreCPUtime

OracleinternalqueriestakingmoreCPUtime

时间:2021-07-01 10:21:17 帮助过:35人阅读

经查,该问题应该为oracle OEMbug,metalink参考文章ID:330383.1

早上,省社保项目组反应,,数据库上有一个系统类的sql,占用资源很大,严重影响数据库性能。具体的sql为:

SELECT COUNT(*) FROM MGMT_METRIC_DEPENDENCY_DETAILS DEP, MGMT_SEVERITY SEV WHERE DEP.TARGET_GUID = :B5 AND DEP.METRIC_GUID = :B4 AND DEP.KEY_VALUE = :B3 AND DEP.EDEP_TARGET_GUID = SEV.TARGET_GUID AND DEP.EDEP_METRIC_GUID = SEV.METRIC_GUID AND DEP.DEP_KEY_VALUE = SEV.KEY_VALUE AND SEV.COLLECTION_TIMESTAMP BETWEEN :B2 AND :B1

经查,该问题应该为Oracle OEMbug,metalink参考文章ID:330383.1

解决办法为:

1. As part of your weekly maintenance jobs for the Oracle Management Repository, run the following

procedure to analyze all of the objects in the SYSMAN schema:

exec dbms_stats.gather_schema_stats('SYSMAN');

linux

人气教程排行