Oracle 视图 V$LICENSE 官方解释，作用，如何使用详细说明
本站中文解释
V$LICENSE视图用于查看当前实例的Oracle许可证和许可条款信息，其中包括客户，suid，组件和可用最大并发用户会话数等，以及对应的Oracle许可证和许可条款版本、其有效期等信息。
使用方法：可以直接执行select * from v$license查看许可证和许可条款的详细信息，或根据客户，suid，组件，有效期，可使用的最大并发用户会话数，以及Oracle许可证和许可条款版本等指定信息对v$license进行筛选操作。
官方英文解释
V$LICENSE displays information about license limits.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Maximum number of concurrent user sessions allowed for the instance |
|
|
|
Warning limit for concurrent user sessions for the instance |
|
|
|
Current number of concurrent user sessions |
|
|
|
Highest number of concurrent user sessions since the instance started |
|
|
|
Maximum number of named users allowed for the database |
|
|
|
Current number of logical CPUs or processors on the system |
|
|
|
Current number of CPU cores on the system (includes subcores of multicore CPUs, as well as single-core CPUs) |
|
|
|
Current number of CPU sockets on the system (represents an absolute count of CPU chips on the system, regardless of multithreading or multicore architectures) |
|
|
|
Highest number of logical CPUs or processors on the system since the instance started |
|
|
|
Highest number of CPU cores on the system since the instance started (includes subcores of multicore CPUs, as well as single-core CPUs) |
|
|
|
Highest number of CPU sockets on the system since the instance started (represents an absolute count of CPU chips on the system, regardless of multithreading or multicore architectures) |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
Note:
The availability of the CPU core count and CPU socket count statistics is subject to the operating system platform on which the Oracle Database is running. If a statistic is unavailable, the view will return NULL for the statistic value.
