首页 » ORACLE » 查看oracle 最大并发值

查看oracle 最大并发值

如何查看ORACLE的并发值,也就是说在某一秒同时在线的人数

可是查看v$license视图

v$license视图:

里面记录了Oracle最大的并发数以及当前用户的连接数,

SQL> select SESSIONS_CURRENT,SESSIONS_HIGHWATER from v$license;

SESSIONS_CURRENT SESSIONS_HIGHWATER
—————- ——————
299                826

SQL> select count(*) from v$session where type=’USER’;

COUNT(*)
———-
299

该试图中的SESSIONS_CURRENT就等于select count(*) from v$session where TYPE = ‘USER’

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
打赏

目前这篇文章有1条评论(Rss)评论关闭。

  1. Riley Baskette | #1
    2011-12-21 at 07:19

    Outstanding post, you have pointed out some good details , I also think this s a very wonderful website.