Purpose
The oceanbase.CDB_OB_TABLET_REPLICAS view displays information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key string of <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| CREATE_TIME | timestamp(6) | NO | The time when the tablet was created. |
| MODIFY_TIME | timestamp(6) | NO | The time when the tablet was modified. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| TABLET_ID | bigint(20) | NO | The ID of the tablet. |
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| LS_ID | bigint(20) | NO | The ID of the log stream to which the tablet belongs. |
| COMPACTION_SCN | bigint(20) unsigned | NO | The version number of the data snapshot. |
| DATA_SIZE | bigint(20) | NO | The actual data size. |
| REQUIRED_SIZE | bigint(20) | NO | The size of the allocated space. Data storage is in the minimal unit of macroblocks (2 MB). Therefore, REQUIRED_SIZE >= DATA_SIZE. |