ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 如何得知生产系统高峰时期的最大连接数

如何得知生产系统高峰时期的最大连接数

原创 Linux操作系统 作者:fjmingyang 时间:2019-05-01 15:39:05 0 删除 编辑

SQL> select * from v$license
2 ;

SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MAX
------------ ---------------- ---------------- ------------------ ----------
0 0 27 48 0

SQL> select * from v$resource_limit where resource_name='sessions';

RESOURCE_NAME CURRENT_UTILIZATION
------------------------------------------------------------ -------------------
MAX_UTILIZATION
---------------
INITIAL_ALLOCATION
--------------------------------------------------------------------------------
LIMIT_VALUE
--------------------------------------------------------------------------------
sessions 39
60
170
170


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

V$RESOURCE_LIMIT

RESOURCE_NAME
VARCHAR2(30)
Name of the resource (see Table 3-2)

CURRENT_UTILIZATION
NUMBER
Number of (resources, locks, or processes) currently being used

MAX_UTILIZATION
NUMBER
Maximum consumption of this resource since the last instance start-up

INITIAL_ALLOCATION
VARCHAR2(10)
Initial allocation. This will be equal to the value specified for the resource in the initialization parameter file (UNLIMITED for infinite allocation).

LIMIT_VALUE
VARCHAR2(10)
Unlimited for resources and locks. This can be greater than the initial allocation value (UNLIMITED for infinite limit).

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/1698901/viewspace-103247/,如需转载,请注明出处,否则将追究法律责任。

下一篇: == 和=的区别
请登录后发表评论 登录
全部评论

注册时间:2006-04-03

  • 博文量
    62
  • 访问量
    44954