View the resource configurations of a tenant

You can view the resource configurations of a tenant as needed, such as the number of resource units in the resource pool and the specifications of each resource unit.

Procedure

1. Log on to the sys tenant as the root user.

2. Execute the following statement to go to the database named oceanbase:

   obclient> USE oceanbase;
   

3. Execute the following statement to view the information about the resources used by a tenant in the cluster.

   obclient> SELECT * FROM oceanbase.GV$OB_UNITS WHERE tenant_id='1002'\G
   *************************** 1. row ***************************
            SVR_IP: xx.xx.xx.xx
         SVR_PORT: 2882
            UNIT_ID: 1001
         TENANT_ID: 1002
               ZONE: zone1
            MAX_CPU: 1
            MIN_CPU: 1
      MEMORY_SIZE: 5798205850
         MAX_IOPS: 10000
         MIN_IOPS: 10000
      IOPS_WEIGHT: 1
      LOG_DISK_SIZE: 17394617549
   LOG_DISK_IN_USE: 156484869
   DATA_DISK_IN_USE: 121634816
            STATUS: NORMAL
      CREATE_TIME: 2022-07-19 13:48:36.308843
   1 row in set
   

   For more information about the oceanbase.GV$OB_UNITS view, see GV$OB_UNITS.