How Works Dba_Tab_Modifications
I Wonder How Works the Dba_Tab_Modifications. How Long Is Kept the Data for a Table? I Have Tables with Timestamp on Dec/2019 What Does It Mean When a Table Is...
I wonder how works the DBA_TAB_MODIFICATIONS.
How long is kept the data for a table? I have tables with timestamp on Dec/2019
What does it mean when a table is not in DBA_TAB_MODIFICATIONS? do it mean the table hasn't had (delete, insert, update) in a period? if yes, for how long?
I have a Schema with around 1000 tables, only around 300 appear in DBA_TAB_MODIFICATIONS
1 Answer
DBA_TAB_MODIFICATIONS is used by Oracle internally to track how many inserts, updates and deletes have been done to a table or table partition since the stats had been gathered on it with dbms_stats.
What version of Oracle are you using because after Oracle 9 it is automatically inserted into the DBA_TAB_MODIFICATIONS table, before oracle 9 you have to register a table as MONITORED.
Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.
