My Oracle Support Banner

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 MAY 16, 2018

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.0.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

To view full details, 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 a vibrant support community of peers and Oracle experts.