ORACLE许可使用信息V$LICENSE

最新推荐文章于 2023-03-29 14:18:54 发布

allway2

最新推荐文章于 2023-03-29 14:18:54 发布

阅读量1.4k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/allway2/article/details/95064172

本文详细介绍了Oracle数据库中V$LICENSE视图的各列数据类型及描述，包括并发用户会话限制、系统CPU信息等关键指标，为数据库管理员提供监控和优化数据库资源的重要依据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

V$LICENSE

This view contains information about license limits.

Column	Datatype	Description
`SESSIONS_MAX`	`NUMBER`	Maximum number of concurrent user sessions allowed for the instance
`SESSIONS_WARNING`	`NUMBER`	Warning limit for concurrent user sessions for the instance
`SESSIONS_CURRENT`	`NUMBER`	Current number of concurrent user sessions
`SESSIONS_HIGHWATER`	`NUMBER`	Highest number of concurrent user sessions since the instance started
`USERS_MAX`	`NUMBER`	Maximum number of named users allowed for the database
`CPU_COUNT_CURRENT`	`NUMBER`	Current number of logical CPUs or processors on the system
`CPU_CORE_COUNT_CURRENT`	`NUMBER`	Current number of CPU cores on the system (includes subcores of multicore CPUs, as well as single-core CPUs)
`CPU_SOCKET_COUNT_CURRENT`	`NUMBER`	Current number of CPU sockets on the system (represents an absolute count of CPU chips on the system, regardless of multithreading or multicore architectures)
`CPU_COUNT_HIGHWATER`	`NUMBER`	Highest number of logical CPUs or processors on the system since the instance started
`CPU_CORE_COUNT_HIGHWATER`	`NUMBER`	Highest number of CPU cores on the system since the instance started (includes subcores of multicore CPUs, as well as single-core CPUs)
`CPU_SOCKET_COUNT_HIGHWATER`	`NUMBER`	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)