查看oracle 最大并发值

首页 » ORACLE 9i-23ai » 查看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

打赏

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.

ANBOB™