Re: Can't access SOME table's statistics.

From: Peter L <news_at_abc.co.uk>
Date: 2000/07/31
Message-ID: <3985ee4c.52897537@news.freeserve.net>#1/1

On Mon, 31 Jul 2000 15:11:48 -0400, "Robert Wagner" <RobertWagner_at_alum.mit.edu> wrote:

>I presently have 8 tables in a schema. When I do a SELECT on USER_TABLES I
>see all
>of them, but I don't get anything in statistical columns like NUM_ROWS,
>BLOCKS,
>EMPTY_BLOCKS, and AVG_SPACE for three of the tables. Is there something like
>(this is pure speculation):
>
>ENABLE STATISTICS_COLLECTION ON mytable
>
>that would be required to for this data to be collected?
>

You need to analyze the tables to collect the stats. Do something like:

analyze table your_table_name estimate statistics;

and you should see some figures. There are options to compute stats or estimate sampling different percentages etc. Received on Mon Jul 31 2000 - 00:00:00 CDT