Note
This view is available starting with V4.0.0.
Purpose
This view displays the cumulative modification information of tables owned by the current user.
Applicability
This view is available only in Oracle mode of OceanBase Database.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table that was modified. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition that was modified. |
| SUBPARTITION_NAME | VARCHAR2(128) | NO | The name of the subpartition that was modified. |
| INSERTS | NUMBER | NO | The approximate number of inserts. |
| UPDATES | NUMBER | NO | The approximate number of updates. |
| DELETES | NUMBER | NO | The approximate number of deletes. |
| TIMESTAMP | DATE | NO | The time when the table was last modified. |
| TRUNCATED | VARCHAR2(3) | NO | This column has no actual meaning. The default value is NULL. |
| DROP_SEGMENTS | NUMBER | NO | This column has no actual meaning. The default value is NULL. |
Sample query
Query the cumulative modification information of the T_SUBPART table since the last statistics collection in the current user's schema.
obclient [SYS]> SELECT * FROM SYS.USER_TAB_MODIFICATIONS WHERE TABLE_NAME='T_SUBPART';
The return result is as follows:
+------------+----------------+-------------------+---------+---------+---------+-----------+-----------+---------------+
| TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | INSERTS | UPDATES | DELETES | TIMESTAMP | TRUNCATED | DROP_SEGMENTS |
+------------+----------------+-------------------+---------+---------+---------+-----------+-----------+---------------+
| T_SUBPART | NULL | P3SP2 | 40 | 40 | 0 | 25-MAR-25 | NULL | NULL |
| T_SUBPART | NULL | P1SP0 | 150 | 150 | 0 | 25-MAR-25 | NULL | NULL |
| T_SUBPART | NULL | P1SP1 | 150 | 150 | 0 | 25-MAR-25 | NULL | NULL |
| T_SUBPART | NULL | P1SP2 | 100 | 100 | 0 | 25-MAR-25 | NULL | NULL |
| T_SUBPART | NULL | P2SP3 | 60 | 60 | 0 | 25-MAR-25 | NULL | NULL |
| T_SUBPART | NULL | P1SP3 | 100 | 100 | 0 | 25-MAR-25 | NULL | NULL |
| T_SUBPART | NULL | P2SP1 | 90 | 90 | 0 | 25-MAR-25 | NULL | NULL |
| T_SUBPART | NULL | P2SP2 | 60 | 60 | 0 | 25-MAR-25 | NULL | NULL |
| T_SUBPART | NULL | P3SP1 | 61 | 60 | 0 | 08-APR-25 | NULL | NULL |
| T_SUBPART | NULL | P2SP0 | 90 | 90 | 0 | 25-MAR-25 | NULL | NULL |
| T_SUBPART | NULL | P3SP3 | 40 | 40 | 0 | 25-MAR-25 | NULL | NULL |
| T_SUBPART | NULL | P3SP0 | 60 | 60 | 0 | 25-MAR-25 | NULL | NULL |
+------------+----------------+-------------------+---------+---------+---------+-----------+-----------+---------------+
12 rows in set
References
Query the cumulative modification information of tables in the current tenant: DBA_TAB_MODIFICATIONS
Query the cumulative modification information of tables accessible to the current user: ALL_TAB_MODIFICATIONS