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 AUGUST 24, 2018

Applies to:

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

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