Re: rman backup slow
Date: Mon, 2 Feb 2009 10:12:56 -0800
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.
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.
JaredReceived on Mon Feb 02 2009 - 12:12:56 CST