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