Re: Tuning RMAN backup and recovery

From: Don Seiler <don_at_seiler.us>
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-l
Received on Mon Mar 03 2008 - 11:21:18 CST

Original text of this message