This content has been marked as final. Show 3 replies
I am running the query to get the table counts from sys table ALL_TABLES, I am not getting the latest counts. Meaning , if I insert a row into a table in one of the schema table, it supposed to updated ALL_TABLES to number of rows column. But it is not doing so. I really appreciate any help.
You'll get the best help if you post in the correct forum - please post the question in the Database General forum.
General Database Discussions
When you post provide your 4 digit Oracle version.
The system views are only updated when statistics are collected; they are NOT updated when DML is performed on a table.
Please mark this thread ANSWERED. If you need more help then repost the question in the proper forum.
Thanks and I really appreciate your reply. When will and who (which job) will ( only updated when statistics are collected) collect the statistics? (Once in when DB is created? or once in a day? or once in every 12 hours? or do we need to set something to do this?)
The version of oracle is 11g release2 (I assume 10g release2 should have same)
Anyways I will post this again in forum you mentioned above.
Edited by: user7690206 on Apr 7, 2013 2:23 PM