Updated on 2024-06-03 GMT+08:00

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.