Re: Cloud Control 13c & Oracle 11 Databases
From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Tue, 19 Feb 2019 13:52:21 -0600
Message-ID: <fb62f6262fed37e7c7a37dc172f40d92_at_society.servebeer.com>
/
Date: Tue, 19 Feb 2019 13:52:21 -0600
Message-ID: <fb62f6262fed37e7c7a37dc172f40d92_at_society.servebeer.com>
On 2019/02/19 13:26, Scott Canaan wrote:
Hey Scott,
MOS 2119607.1 should help you out. Collect fixed stats.
If it doesn't, I've had to use this script for similar V$RMAN_STATUS performance issues in 11.2:
BEGIN
dbms_stats.delete_table_stats('SYS', 'X$KRBMRST'); dbms_stats.delete_table_stats('SYS', 'X$KSFQP'); dbms_stats.delete_table_stats('SYS', 'X$KCCRSR'); dbms_stats.lock_table_stats('SYS', 'X$KRBMRST'); dbms_stats.lock_table_stats('SYS', 'X$KSFQP'); dbms_stats.lock_table_stats('SYS', 'X$KCCRSR');END;
/
...from MOS 1643339.1. This might be worth investigating since V$RMAN_STATUS is used in V$BACKUP_PIECE_DETAILS.
GL!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 19 2019 - 20:52:21 CET