FreeLists / oracle-l / Re: Tuning RMAN backup and recovery

["Don Seiler" <don@xxxxxxxxx>]

Taking away the following juicy nuggest:

1. "Statistics on the dictionary tables will be maintained via the
automatic statistics
gathering job run during the nightly maintance window."

2. "You only need to gather fixed objects statistics once for a
representative workload and they are not updated by the automatic statistics
gathering job."

Answers both my questions.

Thanks,
Don.

On Mon, Mar 3, 2008 at 1:05 PM, Greg Rahn <greg@xxxxxxxxxxxxxxxxxx> wrote:
>
> On 3/3/08, Don Seiler <don@xxxxxxxxx> wrote:
>  > 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?
>
>  I would recommend that you check out
>  Upgrading from Oracle Database 9i to 10g: What to expect from the
>  Optimizer
>  
> http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_bidw_optimizer_10gr2_0208.pdf
>  This is discussed on page 7 & 8 (Statistics on Dictionary Tables &
>  Statistics on Fixed Objects)
>
>
>
>  --
>  Regards,
>
>  Greg Rahn
>  http://structureddata.org
>



-- 
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l