RE: NO ANALYZE STATS FOR TABLE

You will see statistics only after the ANALYZE is completed. 8 million records certainly shouldn't take 24hours, though.

Try doing an ANALYZE with a SAMPLE or ESTIMATE. Better, use DBMS_STATS.

At 06:49 AM 15-10-02 -0800, you wrote:
>I don't get any results when I run the query provided. I have done this but
>all I get are results for other tables otherthan table A. The analyze has
>gone on for 24 hours.
>
>-----Original Message-----
>Sent: Tuesday, October 15, 2002 4:39 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Moses - What were you expecting? ANALYZE will produce nothing at the
>terminal, when it completes it just returns the cursor. Try this:
> select last_analyzed from user_tables where table_name = 'A';
>You should see the date that you performed the analysis. The main reason you
>analyze tables is to provide information for the CBO.
>Oh, and you don't need to turn on tracing or timed statistics.
>
>
>
>Dennis Williams
>DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
>
>-----Original Message-----
>Sent: Tuesday, October 15, 2002 7:19 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>Hi gurus,
>
>I have analyzed my table A but I get no stats for the table. What could be
>the problem? I set TIMED_STATISTICS = TRUE and SQL_TRACE=TRUE before issuing
>the ANALYZE TABLE A COMPUTE STATISTICS command.
>
>This table has over 8 million records.
>
>
>Moses Ngati
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: moyam_at_mtn.co.ug
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Hemant K Chitale
My web site page is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).