EM 13C: SQL ID "0pmx2m3fdc45r" Part Of The MOS_PA_PATCH_RECOM Patch Recommendation Causing High Amount Of Disk Opetations And Blocking Session
(Doc ID 3016555.1)
Last updated on APRIL 16, 2024
Applies to:
Enterprise Manager Base Platform - Version 13.5.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Observed slowness issue on SQL_ID "0pmx2m3fdc45r" in OEM repository and This query is part of the MOS_PA_PATCH_RECOM for patch recommendations.
The SQL was taking high amount of disk operations, execution was more than 1 minutes and Observed blocking sessions created during SQL execution.
SQL statemen for SQL_ID : 0pmx2m3fdc45r
SELECT FR.TARGET_GUID AS TARGET_GUID , FR.PATCH_UID AS PATCH_UID, TG.TARGET_NAME AS TARGET_NAME
FROM MOS_PA_FINAL_RECOM FR,MGMT_ARU_PATCH_RECOM_MD MD, MGMT_TARGETS TG
WHERE MD.PATCH_UID = FR.PATCH_UID AND NVL(EXTRACTVALUE(XMLTYPE(MD.TEXT_CONTENT), '/patch/@is_system_patch'),'n') = 'y' AND TG.TARGET_GUID = FR.TARGET_GUID AND TG.TARGET_TYPE = 'oracle_database'
FROM MOS_PA_FINAL_RECOM FR,MGMT_ARU_PATCH_RECOM_MD MD, MGMT_TARGETS TG
WHERE MD.PATCH_UID = FR.PATCH_UID AND NVL(EXTRACTVALUE(XMLTYPE(MD.TEXT_CONTENT), '/patch/@is_system_patch'),'n') = 'y' AND TG.TARGET_GUID = FR.TARGET_GUID AND TG.TARGET_TYPE = 'oracle_database'
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |