Note
- This view is only applicable to the standalone edition. In distributed mode, queries against this view return empty results.
- This view is available starting with V4.2.5 BP3.
Overview
Displays the information about the license currently loaded by the user.
Columns
Column |
Type |
Is NULL |
Description |
|---|---|---|---|
| END_USER | varchar(512) | NO | Authorized username. |
| LICENSE_ID | varchar(128) | NO | The ID of the license. |
| LICENSE_CODE | varchar(128) | NO | Contract number. |
| LICENSE_TYPE | varchar(128) | NO | License type.
|
| PRODUCT_TYPE | varchar(128) | NO | Product type.
|
| ISSUANCE_DATE | timestamp(6) | NO | The license issuance date. |
| ACTIVATION_TIME | timestamp(6) | NO | The activation time of the license. |
| EXPIRED_TIME | varchar(128) | NO | License expiration time. |
| OPTIONS | varchar(1024) | NO | The feature options included in the license.
|
| NODE_NUM | bigint(20) unsigned | NO | Number of authorized nodes. For the standalone edition, it is fixed as 1. |
| CLUSTER_ULID | varchar(30) | NO | It is automatically generated when the cluster starts. |
Sample query
The system tenant displays the information about the loaded license.
obclient [oceanbase]> select * from oceanbase.DBA_OB_LICENSE;