Purpose
The DBA_OB_TABLET_REPLICAS view provides information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key string of <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) WITH LOCAL TIME ZONE | NO | The time when the replica was created. |
| MODIFY_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the replica was modified. |
| TABLET_ID | NUMBER | NO | The ID of the tablet. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER | NO | The port number of the server. |
| LS_ID | NUMBER | NO | The ID of the log stream to which the tablet belongs. |
| COMPACTION_SCN | NUMBER | NO | The version number of the data snapshot. |
| DATA_SIZE | NUMBER | NO | The actual data size. |
| REQUIRED_SIZE | NUMBER | NO | The size of the allocated space. Data storage is in the minimal unit of macroblocks (2 MB). Therefore, REQUIRED_SIZE >= DATA_SIZE. |