使用PlSQLDeveloper工具查询Oracle会话数

PlSQLDeveloper工具提供了会话管理功能。

能够查询会话内容、杀死会话、查看会话SQL等操作。

 

常用的会话查询SQL如下：

-- 查询所有会话
select * from v$session where username is not null order by logon_time, sid

-- 查询用户会话
select * from v$session where username = user order by logon_time, sid

-- 查询活动会话
select * from v$session where username is not null and status = 'ACTIVE' order by logon_time, sid