sys@psdb> select SESSIONS_HIGHWATER from v$license;

SESSIONS_HIGHWATER
------------------
494

在结合process参数的设置来判断是否有必要适当的加大允许系统并发的数量。

Oracle官方文档中关于视图V$LICENSE的描述：

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)

-- The End --

ITPub博客

【SQL】使用v$license视图获得自启动以来数据库曾经达到的最大 session 数

V$LICENSE

最新文章

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)