Home » RDBMS Server » Server Administration » regarding dba_tables/user_tables
regarding dba_tables/user_tables [message #52281] Fri, 12 July 2002 02:24 Go to next message
jagdevi m halolli
Messages: 1
Registered: July 2002
Junior Member
How does one get the values for the columns num_rows,avg_row_len,empty_blocks of dba_tables/user_tables for particular tables?
Do they need to be updated by some option in the database?

Thanks in advance.

Report message to a moderator

Re: regarding dba_tables/user_tables [message #52284 is a reply to message #52281] Fri, 12 July 2002 02:34 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
the command analyze table update those tables, and YES should analyze tables and indexes at regular interval.

Report message to a moderator

Previous Topic: Sorry- My browser SUCKS !
Next Topic: Oracle 9I lite
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 13:32:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.