DB_TAB_MODIFICATIONS

DB_TAB_MODIFICATIONS displays statistics about modifications to tables accessible to the current user since the last statistics collection on the tables. Currently, this view displays only the statistics data of tables on which INSERT, DELETE, and UPDATE operations have been performed. All users can access this view. This view exists in both PG_CATALOG and SYS schema.

**Table 1** DB_TAB_MODIFICATIONS columns
Name	Type	Description
table_owner	character varying(128)	Table owner.
table_name	character varying(128)	Table name.
partition_name	character varying(128)	Partition name.
subpartition_name	character varying(128)	Subpartition name.
inserts	numeric	Approximate number of insertions since the last statistics collection.
updates	numeric	Approximate number of updates since the last statistics collection.
deletes	numeric	Approximate number of deletions since the last statistics collection.
timestamp	timestamp(0) without time zone	Last modification time. Currently, the modification time of a partitioned table is not supported. The value is NULL.
truncated	character varying(3)	Not supported. Its value is NULL.
drop_segments	numeric	Not supported. Its value is NULL.
schema_name	character varying(128)	Name of the schema to which the table belongs.