EM13c : Performance Issue Due To SQL_ID 10nf6gjrraqz5 Causing Database Hung
(Doc ID 2673154.1)
Last updated on MAY 22, 2020
Applies to:
Enterprise Manager Base Platform - Version 13.2.0.0.0 to 13.3.2.0.0 [Release 13c]Information in this document applies to any platform.
Symptoms
In Enterprise Manager (EM) Cloud Control, SQL_ID : 10nf6gjrraqz5 is causing performance issues. Query is consuming 100 % of temp tablespace and DB is going to Hung state.
SQL_ID : 10nf6gjrraqz5
SELECT a.METRIC_NAME,
a.METRIC_COLUMN,
a.ACTION_MESSAGE_NLSID,
RAWTOHEX(me.ENTITY_GUID),
me.ENTITY_TYPE,
me.ENTITY_NAME,
RAWTOHEX(me.PARENT_ME_GUID)
FROM MGMT$ALERT_CURRENT a,
MGMT$EVENTS e,
MGMT$INCIDENTS i,
MGMT$MANAGEABLE_ENTITIES me
WHERE a.EVENT_INSTANCE_ID = e.EVENT_ID
AND e.INCIDENT_ID = i.INCIDENT_ID
AND e.INCIDENT_ID = HEXTORAW(:1)
AND me.PARENT_ME_TYPE = :2
AND me.PARENT_ME_NAME = :3
AND me.ENTITY_TYPE = 'generic_service'
AND me.ENTITY_NAME = a.KEY_VALUE
AND i.SOURCE_OBJ_TYPE IS NULL;
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 |