Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Statsitics information with DBMS_STATS

Re: Statsitics information with DBMS_STATS

From: Ravi B <ravi4ora_at_yahoo.com>
Date: Thu, 6 Jan 2005 00:24:38 -0800 (PST)
Message-ID: <20050106082438.98554.qmail@web80906.mail.scd.yahoo.com>


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-l
Received on Thu Jan 06 2005 - 02:22:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US