Re: rman backup slow

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 2 Feb 2009 10:12:56 -0800
Message-ID: <bf46380902021012r39298686j720c5ba2b963b825_at_mail.gmail.com>

On Mon, Feb 2, 2009 at 6:47 AM, kathy duret <katpopins21_at_yahoo.com> wrote:

> sql 'alter session set optimizer_mode=rule';
>
> You might need to clean out some old backups.
>
> We had this issue and we added the hint above to our scripts and did some
> cleaning of old backups and this put up back on tracke.
>
> K
>
>
>

I do this as well on some backups.

Unfortunately I neglected to comment in the scripts exactly why I did this.

ML note *247611.1 *lists a number of bugs for which the solution is to set the optimizer_mode = RULE.

Jared

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 02 2009 - 12:12:56 CST