sys@psdb> select SESSIONS_HIGHWATER from v$license;
SESSIONS_HIGHWATER
------------------
494
在结合process参数的设置来判断是否有必要适当的加大允许系统并发的数量。
Oracle官方文档中关于视图V$LICENSE的描述:
-- The End --
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博客 ” ,链接:http://blog.itpub.net/519536/viewspace-598142/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/519536/viewspace-598142/