|
- select s.USERNAME,
- s.SID,
- s.SERIAL#,
- s.SADDR,
- s.PADDR,
- s.TADDR,
- s.STATUS,
- s.TERMINAL,
- s.BLOCKING_SESSION
- from v_$session s
- where s.USERNAME='HR' ;
-
- ----
- select * from v$transaction;
-
- ----
- select SID, SERIAL#, USERNAME
- from V$SESSION where SID in
- (select BLOCKING_SESSION from V$SESSION);
- ----
- alter system kill session '200,428' immediate;
-
复制代码
|
|