Re: Dual table analyzed

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 30 Jul 2002 18:13:44 +1000
Message-ID: <xNr19.47256$Hj3.144418@newsfeeds.bigpond.com>

Hi Jay,

The problem with stats in sys is that Oracle's own recursive code can go nuts with CBO potentially kicking in inappropriately. Any stats on any referenced sys tables can have this effect and I would strongly recommend deleting them even from dual as Oracle may reference this (in)directly.

Better safe than sorry and with any statistics in sys you're likely to be sorry.

Cheers

Richard
"Jayaraman Ashok" <ashok_jayaraman_at_yahoo.com> wrote in message news:7ca2852.0207292200.a37089c_at_posting.google.com...
> Hi
> I am currently in a site that has 8.1.6 on solaris8. The dual table
> owner by sys user has been analyzed here. I believe that this should
> not be the case as it might have adverse impacts. Am i right? What are
> the possible implications? Deleting statistics can be done any
> time.But having this scenario i would like to know the impact of
> this.Please help.
>
> cheers,
> Ashok
Received on Tue Jul 30 2002 - 03:13:44 CDT