Hello fellow orabrains,
Although Oracle has made it clear that DBMS_STATS is
the future and that ANALYZE will be desupported, and
it seems to work well in 9i, here are some things that
I uncovered in my research of it during our initial
stats process implementation (we were on 8.1.6 during
this
Jack,
7) GATHER_STALE
We just discussed this, is the MONITOR option set for all your tables? So
that DBA_TAB_MODIFICATIONS is populated and then DBMS_STATS can determine if
stats are stale. I know there is an article in Metalink that speaks to
this.
-Original Message-
Sent:
.
Jared
Jack Silvey [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/22/2002 10:57 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:dbms_stats issues on 8i
Hello fellow orabrains,
Although Oracle has made