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 126.96.36.199.0 to 188.8.131.52.0 [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:
184.108.40.206 (Base Release)
220.127.116.11 (Server Patch Set)
18.104.22.168 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