Yes, the DBMS_STATS package is very quirky in 8i, IMHO. Knowing the bug in DATABASE_STATS, I've written a procedure to iteratively use SCHEMA_STATS instead. Of course, this too has a bug that will report ORA-1403 on the "first" table in the schema, so I needed to code around that.
And for all this trouble Oracle still recommends using DBMS_STATS over ANALYZE. Then fix it! <sigh> Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: Post, Ethan [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 04, 2002 5:09 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM > inde > > > Arrgggg... > > So anyway, I am thinking, hey it's high time I start using DBMS_STATS > instead of my own procedure so I kick of the following > (Oracle 8.1.7.4). > After the first run I have SYS and SYSTEM stats on indexes > and on other > schemas with NO STATS it just ignored those tables even > though you can see I > have GATHER EMPTY below. So I kick it off again and guess > what, it starts > analyzing the tables it missed the first time, including SYS > and SYSTEM. > Guess I am going to use DBMS_STATS.GATHER_TABLE_STATS and be > a bit more > specific about what I get. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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).