Re: Tuning RMAN backup and recovery
- From: "Don Seiler" <don@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- 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 [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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
