Note
- This view is available only for standalone instances. In a distributed cluster, the query result is empty.
- This view is available starting with V4.3.5 BP3.
Purpose
This view displays the license information that is loaded for the current user.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| END_USER | varchar(512) | NO | The username of the license. |
| LICENSE_ID | varchar(128) | NO | The ID of the license. |
| LICENSE_CODE | varchar(128) | NO | The contract number. |
| LICENSE_TYPE | varchar(128) | NO | The type of the license.
|
| PRODUCT_TYPE | varchar(128) | NO | The type of the product.
|
| ISSUANCE_DATE | timestamp(6) | NO | The issue time of the license. |
| ACTIVATION_TIME | timestamp(6) | NO | The activation time of the license. |
| EXPIRED_TIME | timestamp(6) | NO | The expiration time of the license. |
| OPTIONS | varchar(1024) | NO | The features of the license.
|
| CORE_NUM | bigint(20) unsigned | NO | The number of CPU cores that are authorized for use. |
| NODE_NUM | bigint(20) unsigned | NO | The number of nodes that are authorized for use. For a standalone instance, this value is fixed to 1. |
| CLUSTER_ULID | varchar(30) | NO | The unique identifier of the cluster, which is automatically generated when the cluster is started. |
Sample query
Query the license information that is loaded for the sys tenant.
obclient [oceanbase]> select * from oceanbase.DBA_OB_LICENSE;