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

Last updated on MARCH 10, 2017

Applies to:

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

Goal

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:

 

12.2.0.1 (Base Release)
12.1.0.2 (Server Patch Set)
12.1.0.1 Patch 14 on Windows Platforms

11.2.0.3

11.2.0.4 

 

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?

 

 

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