Home » RDBMS Server » Server Administration » DBA_Tables info is not accurate
DBA_Tables info is not accurate [message #369235] Sun, 23 July 2000 20:35 Go to next message
WCK
Messages: 4
Registered: July 2000
Junior Member
I did my weekly stats report and depend on dba_tables to extract the num_rows for the tables but I realized after 3 attempts each at different times, all yields the same results. I did a actual select count on the particular table and found the values to be otherwise. What is the discreprancies between these two? I am using oracle 7.3.
Re: DBA_Tables info is not accurate [message #369241 is a reply to message #369235] Tue, 25 July 2000 08:43 Go to previous message
Sean
Messages: 22
Registered: July 2000
Junior Member
num_rows is only updated when you analyze the table, not whenever rows are inserted or deleted.
Previous Topic: ORA-07445: exception encountered: core dump [11] [15] [0] [0] [] []
Next Topic: Database Problem
Goto Forum:
  


Current Time: Tue Oct 20 10:16:33 CDT 2020