Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Statsitics information with DBMS_STATS
dbms_stats.gather_table_stats(NULL,'SL_ING_SL',estimate_percent=>15);
Wolfgang Breitling <breitliw_at_centrexcc.com> 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
-- http://www.freelists.org/webpage/oracle-l --------------------------------- Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more. -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 06 2005 - 02:22:42 CST
![]() |
![]() |