Re: Num_rows in user_tables
Date: Thu, 22 Dec 1994 22:44:48
Message-ID: <singerap.53.0016BFCF_at_powergrid.electriciti.com>
In article <3daops$r7g_at_news.cais.com> sarek_at_cais2.cais.com (Scott T Johnson) writes:
>From: sarek_at_cais2.cais.com (Scott T Johnson)
>Subject: Num_rows in user_tables
>Date: 22 Dec 1994 02:37:48 GMT
>Why does the column user_tables.num_rows
>never have the number of rows in it?
>Scott
>--
>------------------------------------------------------------------------
>Scott T. Johnson Internet: sarek_at_cais.com
>SHL Systemhouse, Inc. CIS: 73052,2500
>+1 703 438-7300
Run the ANALYZE command against your tables. This will evaluat your database objects for size, number of keys etc and fill in the statistics. Check out the Oracle 7 SQL Language Reference Manual aroud 4-89. You dba should be able to analyze all your object in one fell swop by executing the stored procedure (providing you have the procedural option) dbms_util.analyze_schema ( 'SCHEMA', 'COMPUTE | ESTIMATE'). If you have run analyze and computed the statistics you should have the resulting statistics in your catalog views. If not contact support you have identified an undocumented feature (BUG). Received on Thu Dec 22 1994 - 22:44:48 CET