EM13.2 Cloud Control: A Recurring Query In Database has performance issues ( (SELECT MEDIA FROM V$BACKUP_PIECE_DETAILS)

(Doc ID 2235163.1)

Last updated on MAY 16, 2018

Applies to:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.


Performance problem found after migration to EM 13.2 which points to a query running on the target which takes up more than  10Gigs of temp space.

The issue is identified as a database bug: <Bug 14078947> - Select from V$RMAN_STATUS very slow when database is open and it has an available patch for the following DB versions: (Base Release) (Server Patch Set) Patch 14 on Windows Platforms 


Is there a way to avoid applying the patch and simply disable the metric collection?  Applying the patch specially on a production DB will require a maintenance window approval. 

How to stop this metric from being collected? What is the metric name that collects it?




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