Note
This view is available starting with V4.0.0.
Purpose
This view displays the list of all tablets in the current tenant and the information about the log streams to which the tablets belong.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TABLET_ID | NUMBER | NO | The tablet ID. |
| LS_ID | NUMBER | NO | The ID of the log stream to which the tablet belongs. |
Sample query
Query the list of tablets in log stream 1001 of the current user tenant and display the first five entries.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_TABLET_TO_LS WHERE LS_ID=1001 AND ROWNUM <= 5;
The query result is as follows:
+-----------+-------+
| TABLET_ID | LS_ID |
+-----------+-------+
| 200004 | 1001 |
| 200005 | 1001 |
| 200006 | 1001 |
| 200007 | 1001 |
| 200008 | 1001 |
+-----------+-------+
5 rows in set