Re: ORACLE 10gr2 collect statistics on sys and system?
- From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 17 Jun 2006 12:31:03 +0300
And whenever it uses dynamic smaplying, its produces different
execution plan. A big pain.
On 6/16/06, Connor McDonald <mcdonald.connor@xxxxxxxxx> wrote:
On 6/16/06, Christian Antognini
<Christian.Antognini@xxxxxxxxxxxx> 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
>
> --
> //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@xxxxxxxxx
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."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
