EM 13c: Identifying the Enterprise Manager 13c Cloud Control Metric represented by the query with SQL ID: 4mcnxwa2v7803
(Doc ID 2216654.1)
Last updated on NOVEMBER 17, 2019
Applies to:
Enterprise Manager for Oracle Database - Version 13.1.1.0.0 and laterInformation in this document applies to any platform.
Goal
The following query represents an Enterprise Manager 13c Cloud Control metric:
SQL ID: 4mcnxwa2v7803
.
SELECT
:B7 TYPE_CON,
OFFR.RECID KEY_CON,
OFFR.RECID RECID_CON,
OFFR.STAMP STAMP_CON,
/* removed .....*/
FROM
V$OFFLINE_RANGE OFFR,
(
SELECT
FE.FENUM FILE#,TO_NUMBER ( FE.FECRC_SCN ) CREATION_CHANGE#,
FE.FEPDI FOREIGN_DBID,
DECODE (FE.FEFDB,1,'YES','NO'
) PLUGGED_READONLY,
FE.FEPLUS PLUGIN_CHANGE#, FE.FEPRLS
PLUGIN_RESETLOGS_CHANGE#,FE.FEPRLT PLUGIN_RESETLOGS_TIME
FROM
X$KCCFE FE
WHERE
FE.FEDUP != 0
) DF
WHERE (
:B5 = :B4
OR
DBMS_RCVMAN.ISTRANSLATEDFNO ( OFFR.FILE#
) = :B4
Solution
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
Goal |
Solution |