My Oracle Support Banner

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.