Re: rman backup slow
- From: Jared Still <jkstill@xxxxxxxxx>
- To: katpopins21@xxxxxxxxx
- Date: Mon, 2 Feb 2009 10:12:56 -0800
On Mon, Feb 2, 2009 at 6:47 AM, kathy duret <katpopins21@xxxxxxxxx> 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
Other related posts:
