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

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_stat.delete_schema_stats and gather_schema_stats ignore nested tables

Re: dbms_stat.delete_schema_stats and gather_schema_stats ignore nested tables

From: <flavio_at_tin.it>
Date: 6 Jun 2005 01:17:22 -0700
Message-ID: <1118045842.511998.71660@o13g2000cwo.googlegroups.com>

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 Received on Mon Jun 06 2005 - 03:17:22 CDT

Original text of this message

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