oracle数据库性能查询相关指令
需要重新连接用户
数据库连接数查询指令
当前的连接数
select count(*) from v$session ;
某个用户并发连接数
Select count(*) from v$session where status='ACTIVE' and username='WX_PROVINCE_1';
数据库允许的最大连接数
select value from v$parameter where name = 'processes';
查看不同用户的连接数
select username,count(username) from v$session where username is not null group by username;
查询锁定数指令
select count(*)
from v$process p,v$session a, v$locked_object b,all_objects c
where p.addr=a.paddr and a.process=b.process and c.object_id=b.object_id ;
查询具体那张表的锁定数量
select count(*),t.object_name from (
select c.object_name
from v$process p,v$session a, v$locked_object b,all_objects c
where p.addr=a.paddr and a.process=b.process and c.object_id=b.object_id
) t group by t.object_name
查询详细信息
select p.spid,a.serial#, c.object_name,b.session_id,b.oracle_username,b.os_user_name
from v$process p,v$session a, v$locked_object b,all_objects c
where p.addr=a.paddr and a.process=b.process and c.object_id=b.object_id ;