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 feature to only generate stats on tables with
stale statistics.
In addition, do not mix calls. Use one or the other. According to the Docs,
ANALYZE can not delete and does not overwrite some stats generated by
DBMS_STATS and vise versa. I have run into the situation where calls where
mixed and got really strange results until stats were deleted using both
methods and regenerated.
Kevin
-----Original Message-----
Sent: Wednesday, June 06, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.7
AIX 4.3.3
I looked at the docs and it appears Oracle wants you to use dbms_stats to
generate statistics for cbo. I am currently using
dbms_utility.analyze_schema.
Should I change to dbms_stats (i know it doesnt give you chained rows, avg
free space, # of unused blocks)? Are there any advantages over
dbms_utility.analyze_schema?
What does everyone here use to generate their stats?
Thanks.
Gene
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Toepke, Kevin M
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
