select event,count(*) from gv$session_wait group by event order by count(*) desc;
SELECT s.sid,s.serial#,p.spid, t.sql_text FROM v$session s, v$sql t, v$process p
WHERE s.event LIKE 'row cache lock' AND t.sql_id = s.sql_id AND s.PADDR = p.ADDR ;
WHERE s.event LIKE 'row cache lock' AND t.sql_id = s.sql_id AND s.PADDR = p.ADDR ;
Alter system kill session 'SID,SERIAL#' ;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/35489/viewspace-734574/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
