EM13.2 Cloud Control: A Recurring Query In 220.127.116.11 Database has performance issues ( (SELECT MEDIA FROM V$BACKUP_PIECE_DETAILS)
Last updated on MAY 16, 2018
Applies to:Enterprise Manager for Oracle Database - Version 18.104.22.168.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:
22.214.171.124 (Base Release)
126.96.36.199 (Server Patch Set)
188.8.131.52 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?
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