Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!o13g2000cwo.googlegroups.com!not-for-mail
From: flavio@tin.it
Newsgroups: comp.databases.oracle.server
Subject: Re: dbms_stat.delete_schema_stats and gather_schema_stats ignore nested tables
Date: 6 Jun 2005 01:17:22 -0700
Organization: http://groups.google.com
Lines: 10
Message-ID: <1118045842.511998.71660@o13g2000cwo.googlegroups.com>
References: <1116856217.535409.47930@g43g2000cwa.googlegroups.com>
   <l33491lcqt5atpl6dd4p5tavpje5at7p6e@4ax.com>
   <Tprke.934387$b5.40879717@news3.tin.it>
NNTP-Posting-Host: 81.72.111.184
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1118045848 21286 127.0.0.1 (6 Jun 2005 08:17:28 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 6 Jun 2005 08:17:28 +0000 (UTC)
In-Reply-To: <Tprke.934387$b5.40879717@news3.tin.it>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: o13g2000cwo.googlegroups.com; posting-host=81.72.111.184;
   posting-account=P3MycgwAAACUWcPGkRbt1uJfgTXnvJ2p
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244304


Just to report that after upgrading the db to patch level 9.2.0.6.0,
the problem persists.

Indexes on nested tables are NOT computed by
dbms_stats.gather_schema_stats with cascade = true.

Bye,
Flavio