Re: dbms_stat.delete_schema_stats and gather_schema_stats ignore nested tables

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:l33491lcqt5atpl6dd4p5tavpje5at7p6e_at_4ax.com...
> On 23 May 2005 06:50:17 -0700, flavio_at_tin.it wrote:
>
> >Hi,
> >I've made some attempts to find any information regarding this problem
> >with no success.
> >
> >Oracle EE 9.2.0.1.0, Windows 2000:
> >
> >dbms_stat.gather_schema_stats doesn't work for nested tables and their
> >associated indexes, no matter what the CASCADE option is set to. Also
> >specifying 'FOR ALL COLUMNS' for method_opt parameter doesn't help.
> >Also, dbms_stat.delete_schema_stats doesn't clear statistics collected
> >on nested table indexes.
> >
> >On the other hand, it is possible to collect statistics on nested
> >tables and their indexes, by directly calling
> >dbms_stats.gather_table_stats and passing the nested table name with
> >cascade => true. Likewise, it possible to delete the statistics by
> >issuing dbms_stat.delete_table_stats against the nested table name.
> >
> >I wonder why this doesn't happen automatically with
> >dbms_stat.gather_schema_stats though.
> >
> >Bye,
> >Flavio
>
> As you are running the 9.2 base release, Oracle will tell you to
> upgrade to 9.2.0.6. I didn't check it, but this very much looks like a
> typical issue for a base release.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Hi Sybrand,
I checked what's on Metalink using the keywords "dbms_stats.gather_schema_stats" and "dbms_stats.delete_schema_stats" but failed to find any specific references to this problem. At any rate, I am downloading patchset 9.2.0.6 and I shall see if the problem goes away.

Bye,
Flavio Received on Mon May 23 2005 - 15:54:11 CDT