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 DECEMBER 23, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 13.1.1.0.0 and later
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms