My Oracle Support Banner

EM13c : A Recurring Query in Database targets has performance issues (SELECT MEDIA FROM V$BACKUP_PIECE_DETAILS) (Doc ID 2235163.1)

Last updated on MARCH 09, 2020

Applies to:

Enterprise Manager for Oracle Database - Version to [Release 13.2]
Information in this document applies to any platform.


Performance problem found after migration to Enterprise Manager (EM) Cloud Control 13.2 version, this 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?



To view full details, sign in with your My Oracle Support account.

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

In this Document

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