EM13.2 Cloud Control: A Recurring Query In 22.214.171.124 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 126.96.36.199.0 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:
188.8.131.52 (Base Release)
184.108.40.206 (Server Patch Set)
220.127.116.11 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!