Schedule Analyze using DBMS_STATS ???

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Tue, 03 Jun 2003 03:54:52 -0800
Message-ID: <F001.005A8B16.20030603035452@fatcity.com>

Guys,

I would like to scedule the process of analyzing tables/indexes using DBMS_STATS ?

Hope someone of u would have a script for the same. can u share with me please ?!

BTW,Which is advisable : ANALYZE or DBMS_STATS ? there was a discussion about the same on the list also. but not found any conclusion yet.
anu suggestions !!!

the ENV is oracle 9.2.0.1/Win2K.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Tue Jun 03 2003 - 06:54:52 CDT