Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORACLE 10gr2 collect statistics on sys and system?

Re: ORACLE 10gr2 collect statistics on sys and system?

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Sat, 17 Jun 2006 12:31:03 +0300
Message-ID: <97b7fd2f0606170231r5f07bca3pb429770877d4348a@mail.gmail.com>


And whenever it uses dynamic smaplying, its produces different execution plan. A big pain.

On 6/16/06, Connor McDonald <mcdonald.connor_at_gmail.com> wrote:
>
>
> On 6/16/06, Christian Antognini
> <Christian.Antognini_at_trivadis.com> wrote:
> > Hi
> >
> > >I just don't understand why 10Gr2 need collect
> > >statistics on "sys", but 9ir2 don't need.
> >
> > In 10g the RBO is no longer supported. Therefore Oracle had to switch to
> the CBO as well.
> >
> >
> > HTH
> > Chris
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
> You could always delete the statistics...but seeing as
> optimizer_dynamic_sampling defaults to 2 in v10, the first thing you'll see
> if lots of dynamic sampling queries against your dictionary....ugh!
>
> leave those stats on.
>
> hth
> connor
>
> --
> Connor McDonald
> ===========================
> email: connor_mcdonald_at_yahoo.com
> web: http://www.oracledba.co.uk
>
> "Semper in excremento, sole profundum qui variat"

-- 
Best Regards,
Syed Jaffar Hussain
8i,9i & 10g, OCP DBA
Banque Saudi Fransi,
Saudi Arabia
http://jaffardba.blogspot.com/
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jun 17 2006 - 04:31:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US