系统状态查询

看latch free等待的是哪些latch.sql
select addr,latch#,name,gets,spin_gets from v$latch
order by spin_gets desc

通过HASH值找出会话的SQL语句.sql
select * from v$sqlarea a where a.HASH_VALUE=2000517657

--获取打开的游标数
select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s
where user_name = 'WLOA' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs Desc

select *
from v$open_cursor Where user_name='WLOA'

----获取为游标执行的 SQL
select q.sql_text
from v$open_cursor o, v$sql q
where q.hash_value=o.hash_value and o.sid = 51

----会话查询
select username,sid,serial# from v$session a Where a.username='WLOA'

----查询系统进程等待事件.sql
select * from v$session_wait

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/54212/viewspace-976936/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/54212/viewspace-976936/