Re: Tuning RMAN backup and recovery
Date: Mon, 3 Mar 2008 11:21:18 -0600
I've read a couple blog posts that say to gather fixed object stats weekly, during normal business hours. Another page  also suggested gathering dictionary stats as part of the same weekly process.
Anyone have any thoughts?
On Mon, Mar 3, 2008 at 9:39 AM, Don Seiler <don_at_seiler.us> wrote:
> I did have some follow-up questions regarding
> 1. We had noticed that, since gathering the fixed object stats, the
> time needed to perform a level 0 incremental backup dropped by around
> 40%. Is this not a coincidence?
> 2. Is there any schedule or milestone upon which one should re-gather
> fixed object statistics?
-- Don Seiler http://seilerwerks.wordpress.com ultimate: http://www.mufc.us -- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 03 2008 - 11:21:18 CST