Re: Tuning RMAN backup and recovery
Date: Mon, 3 Mar 2008 11:21:18 -0600
Message-ID: <716f7a630803030921p5579cd4foc9eec858a11a082a@mail.gmail.com>
I've read a couple blog posts that say to gather fixed object stats
weekly, during normal business hours. Another page [0] also suggested
gathering dictionary stats as part of the same weekly process.
Anyone have any thoughts?
Don.
[0] http://www.toadworld.com/Community/ExpertsBlog/tabid/67/EntryID/135/Default.aspx
On Mon, Mar 3, 2008 at 9:39 AM, Don Seiler <don_at_seiler.us> wrote:
> I did have some follow-up questions regarding
> DBMS_STATS.GATHER_FIXED_OBJECT_STATS().
>
> 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