From JBECKSTROM@gcrta.org Fri, 01 Jun 2001 09:34:34 -0700 From: "Jeffrey Beckstrom" Date: Fri, 01 Jun 2001 09:34:34 -0700 Subject: RE: how determine chaining if using gather_stats Message-ID: MIME-Version: 1.0 Content-Type: text/plain from the docs, it states it does not compute chained row count.>>> EShevtsov@flagship.ru 6/1/01 10:00:26 AM >>>Hi Jeffrey,If you've decided to use dbms_stats, I don't know the reasons to use analyzeanymore.In terms of stored statistics DBMS_STATS will give you the same and a littlemore.I mean for example integral statistics for your partition tables. And youcan analyze tables in parallelRegards,Ed-----Original Message-----Sent: 1 ???? 2001 ?. 16:55To: Multiple recipients of list ORACLE-LSince oracle seems to be pushing the dbms_stats.gather_stats procedure forgetting table statistics.  Do you run a separate analyze command to find thenumber of chained rows since gather stats does not get this value.  Or areyou still using "analyze".Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Shevtsov, Eduard  INET: EShevtsov@flagship.ruFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).