Purpose
The GV$DML_STATS view provides 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 | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| INST_ID | bigint(20) | NO | The ID of the tenant. |
| OBJN | bigint(20) | NO | The object ID. |
| INS | bigint(20) | NO | The approximate number of insertions since the last statistic collection operation. |
| UPD | bigint(20) | NO | The approximate number of updates since the last statistic collection operation. |
| DEL | bigint(20) | NO | The approximate number of deletions since the last statistic collection operation. |
| DROPSEG | bigint(0) | NO | At present, this column is not supported and is NULL by default. |
| CURROWS | bigint(0) | NO | At present, this column is not supported and is NULL by default. |
| PAROBJN | bigint(20) | NO | At present, this column is not supported and is NULL by default. |
| LASTUSED | bigint(0) | NO | At present, this column is not supported and is NULL by default. |
| FLAGS | bigint(0) | NO | At present, this column is not supported and is NULL by default. |
| CON_ID | bigint(0) | NO | At present, this column is not supported and is NULL by default. |
