All:
From reading the release notes for 9i it appears that ANALYZE table and
DBMS_UTILITY.ANALYZE_SCHEMA are desupported in 9i. The only supported way to
generate stats in 9i is DBMS_STATS.
In addition, DBMS_STATS can generate stats for tables in parallel and make
use of the new MONITORING
As far as I can work out, DBMS_STATS is purely for
optimizer decisions (presumably thats why they didn't
call it DBMS_ANALYZE).
(If you believe the doco) you can get faster and
better stats with DBMS_STATS (particularly in terms of
partition-wise stats).
I'm using both at the moment, in my
