Oracle一些常用查看数据库状态SQL
--查看当前连接客户端使用连接数
select machine, count(machine) from sys.v_$session group by machine
--查看当前总游标数
select count(*) from sys.v_$open_cursor
--总会话连接数
select count(*) from v$session
--查看连接的状态
select username,machine,status from v$session
SELECT * FROM V$PARAMETER WHERE NAME='processes'
select * from v$lock ,dba_objects,v$session where object_id=v$lock.id1 and v$lock.sid=v$session.sid
select * from v$lock
--关闭某一连接
alter system kill session '153,21604';
--统计连接用户及客户端使用情况
select username,machine,count(*) from v$session group by username,machine
--根据游标排列
select sql_text, count(*) aa from sys.v_$open_cursor group by sql_text order by aa desc