Purpose
The oceanbase.DBA_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 replica was created. |
| MODIFY_TIME | timestamp(6) | NO | The time when the tablet replica was modified. |
| 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. |