Purpose
The GV$DML_STATS view displays 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 OBServer node. |
| SVR_PORT | NUMBER | NO | The port number of the OBServer node. |
| 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. |