Re: Statsitics information with DBMS_STATS
- From: Ravi B <ravi4ora@xxxxxxxxx>
- To: breitliw@xxxxxxxxxxxxx
- Date: Thu, 6 Jan 2005 00:24:38 -0800 (PST)
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
--
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-l
Other related posts: