Re: dba_tables does not show num_rows

The table, dba_tables/user_tables/all_tables does not show values in the num_rows field because there is not an internal mechanism to automatically populate this table. To populate this field, you need to do this for every table:

analyze table table_name compute/estimate statistics;

That will populate that field and several others that contain statistical information about tables. Note, though, that these statistics are not automatically kept up to date.

Glenn Stauffer
DBA
Swarthmore College

In article <NNALLURI.96Feb12183523_at_fantasy.sdt.com>, nnalluri_at_fantasy.sdt.com (Naga Nalluri) wrote:

>the command:
>> select count(*) from tabx;
>does return the correct number of rows in tabx.
>and I am assuming this is what exists in
>the num_rows field in the dba_tables row for tabx.
>
>Am I incorrect in assuming the num_rows column in dba_tables
>shows the number of rows in that table.
>
>I am running Oracle 7.0.15.4.0 running on HP-UX 9.04.
>
>Please e-mail me if convenient.
>Thanks,
>Naga.
>nnalluri_at_sdt.com
>--
>-------------------
>Naga Nalluri
>nnalluri_at_sdt.com
 

-- 
Glenn Stauffer
DBA
Swarthmore College