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

Hi Robert,

Analyze table <table_name> compute|estimate statistics; (also will analyze indexes)
or dbms_utility.analyze_schema('<schemaname>','COMPUTE') to analyze all tables.

Hth,

Sybrand Bakker, Oracle DBA

"Robert Wagner" <RobertWagner_at_alum.mit.edu> wrote in message news:adkh5.28385$9E6.161474_at_newsr1.maine.rr.com...
> 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?
>
> When I do an export from the schema, the CREATE TABLE statements don't
 seem
> different in any
> way that could explain this.
>
> TIA >>> Robert (still being surprised by Oracle)
>
>
>
>
Received on Mon Jul 31 2000 - 00:00:00 CDT