Note
This view was introduced in OceanBase Database V4.2.5.
Purpose
The V$OB_RES_MGR_SYSSTAT view displays the statistical items of resource groups on the current OBServer node in the current tenant.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| CON_ID | NUMBER | NO | The ID of the tenant. |
| GROUP_ID | NUMBER | NO | The ID of the consumer group. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | NUMBER(38) | NO | The port number of the OBServer node. |
| STATISTIC# | NUMBER | NO | The sequence number of the statistical item. |
| NAME | VARCHAR2(64) | NO | The name of the statistical item. |
| CLASS | NUMBER | NO | The class of the statistical item. |
| VALUE | NUMBER | NO | The value of the statistical item. |
| VALUE_TYPE | VARCHAR2(16) | NO | The type of the value, which can be a cumulative or assigned value. |
| STAT_ID | NUMBER | NO | The ID of the statistical item. |
Sample query
Query the statistical items of resource groups on the current OBServer node in the current tenant.
obclient [SYS]> SELECT * FROM SYS.V$OB_RES_MGR_SYSSTAT WHERE ROWNUM < 10;
The query result is as follows:
+--------+----------+----------------+----------+------------+-----------------------+-------+----------+------------+---------+
| CON_ID | GROUP_ID | SVR_IP | SVR_PORT | STATISTIC# | NAME | CLASS | VALUE | VALUE_TYPE | STAT_ID |
+--------+----------+----------------+----------+------------+-----------------------+-------+----------+------------+---------+
| 1004 | 0 | xx.xx.xx.xx | 2882 | 0 | rpc packet in | 1 | 179289 | ADD_VALUE | 10000 |
| 1004 | 0 | xx.xx.xx.xx | 2882 | 1 | rpc packet in bytes | 1 | 53809721 | ADD_VALUE | 10001 |
| 1004 | 0 | xx.xx.xx.xx | 2882 | 2 | rpc packet out | 1 | 183590 | ADD_VALUE | 10002 |
| 1004 | 0 | xx.xx.xx.xx | 2882 | 3 | rpc packet out bytes | 1 | 40636459 | ADD_VALUE | 10003 |
| 1004 | 0 | xx.xx.xx.xx | 2882 | 4 | rpc deliver fail | 1 | 0 | ADD_VALUE | 10004 |
| 1004 | 0 | xx.xx.xx.xx | 2882 | 5 | rpc net delay | 1 | 14490224 | ADD_VALUE | 10005 |
| 1004 | 0 | xx.xx.xx.xx | 2882 | 6 | rpc net frame delay | 1 | 146779 | ADD_VALUE | 10006 |
| 1004 | 0 | xx.xx.xx.xx | 2882 | 7 | mysql packet in | 1 | 783 | ADD_VALUE | 10007 |
| 1004 | 0 | xx.xx.xx.xx | 2882 | 8 | mysql packet in bytes | 1 | 25446 | ADD_VALUE | 10008 |
+--------+----------+----------------+----------+------------+-----------------------+-------+----------+------------+---------+
9 rows in set (0.007 sec)