dbms_stats.gather_table_stats(NULL,'SL_ING_SL',estimate_percent=>15); Wolfgang Breitling <breitliw@xxxxxxxxxxxxx> wrote:Then you're doing something wrong. What is the exact dbms_stats procedure call you are using? At 04:50 AM 12/31/2004, Ravi B wrote: >Which data dictionary table will get updated after the generation of >statistics with DBMS_STATS package in Oracle 9i. The column last_analyzed in > >dba_tables is not getting updated after generating statistics with >dbms_stats. Where do I check this information. Regards Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- //www.freelists.org/webpage/oracle-l --------------------------------- Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more. -- //www.freelists.org/webpage/oracle-l