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>



On 2019/02/19 13:26, Scott Canaan wrote:

> We are in the process of upgrading to Cloud Control 13c. In the process of testing the agent deployment, an issue has come up with Oracle 11g databases (11.2.0.4). Every 15 minutes the database runs out of temp space. I've increased temp from a maximum of 750M to 1G. The offending SQL is from Cloud Control. It is:

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-l
Received on Tue Feb 19 2019 - 20:52:21 CET

Original text of this message