|
-
How to keep DBA_TABLES view up-to-date
I've 7.3.4.5 Oracle Database.
DBA_TABLES columns are all empty except for table_name and owner columns. I changed timed_statistics parameter to true and restarted the instance but it still empty.
Only some columns get populated when I run analyze table command for a specific table.
How do I populate num_rows and cain_cnt for example for all the database tables and keep them always up-to-date.
I've seen that before in a different databse but I thought all what have to be done is timed_statistics prameter.
Please advise,
Thanx
[Edited by db_lover on 02-18-2001 at 10:42 PM]
DB_Lover
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|