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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: ORA-07445: exception encountered: core dump [11] [15] [0] [0] [] []
Next Topic: Database Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Oct 25 14:56:00 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.