GV$DML_STATS

2023-12-08 07:13:36  Updated

Purpose

The GV$DML_STATS view displays the information about the DML operations performed in the current user table.

Note

This view is introduced since OceanBase Database V4.0.0.

Columns

Column Type Nullable? Description
SVR_IP VARCHAR2(46) NO The IP address of the server.
SVR_PORT NUMBER NO The port number of the server.
INST_ID NUMBER NO The ID of the tenant.
OBJN NUMBER NO The object ID.
INS NUMBER NO The approximate number of insertions since the last statistic collection operation.
UPD NUMBER NO The approximate number of updates since the last statistic collection operation.
DEL NUMBER NO The approximate number of deletions since the last statistic collection operation.
DROPSEG NUMBER NO At present, this column is not supported and is NULL by default.
CURROWS NUMBER NO At present, this column is not supported and is NULL by default.
PAROBJN NUMBER NO At present, this column is not supported and is NULL by default.
LASTUSED NUMBER NO At present, this column is not supported and is NULL by default.
FLAGS NUMBER NO At present, this column is not supported and is NULL by default.
CON_ID NUMBER NO At present, this column is not supported and is NULL by default.

Contact Us