RE: dbms_stats broken

[Jankovic, Djordje]

I haven't used it, but here is what we are doing: we created a simple package which loops through dba_tab_modifications and finds itself (the same way as oracle would) which tables are stale: where the sum of inserts, updates and deletes is more than 10% of the number of rows, and than run dbms_stats for those only.  That way you have a bit more flexibility (you can for example exclude some tables), make estimate or calculate decisions on the table basis, etc.   Djordje -----Original Message----- From: Koivu, Lisa [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 10:25 PM To: Multiple recipients of list ORACLE-L Subject: dbms_stats broken Hello everyone,   Is anyone using dbms_stats and gather stale or gather auto in 9.2?  I’m trying to use dbms_stats gather schema stats with the stale option and it just isn’t working in 8.1.7.4.  This is documented on Metalink.  I’d love to hear from someone else if this is fixed in 9.2 and if it can be reliably used.   Thank you Lisa Monkey.