My Oracle Support Banner

EM13.4 :Install hangs at Repository Configuration at 50% due to Top SQL Running SQLID "6gbnqa7xtc85v". (Doc ID 2685281.1)

Last updated on MAY 25, 2022

Applies to:

Enterprise Manager Base Platform - Version 13.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

13.4 EM
12.2.0.1 Oracle DB

13.4 EM Install hangs at Repository Configuration due to Top SQL Running SQLID "6gbnqa7xtc85v".

AWR report shows

SQL ordered by CPU Time"

6gbnqa7xtc85v SELECT DISTINCT METRIC_GUID, METRIC_COLUMN, TYPE_META_VER FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND TYPE_META_VER = NVL(:B1 , TYPE_META_VER)

Top SQL Statements :

Recommendation 1: SQL Tuning
Estimated benefit is 1 active sessions, 100% of total activity.
---------------------------------------------------------------
Action
Run SQL Tuning Advisor on the SELECT statement with SQL_ID
"6gbnqa7xtc85v".
Related Object
SQL statement with SQL_ID 6gbnqa7xtc85v.
SELECT DISTINCT METRIC_GUID, METRIC_COLUMN, TYPE_META_VER FROM
MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND
TYPE_META_VER = NVL(:B1 , TYPE_META_VER)

 

 

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.