RE: dbms_utility.analyze_schema OR dbms_stats ?

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: Gsais_at_co.palm-beach.fl.us

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: ListGuru_at_fatcity.com (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: ktoepke_at_cms.cendant.com

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: ListGuru_at_fatcity.com (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).