ÇóÒ»²éѯoracleÊý¾Ý¿âËÀËøµÄSQLÓï¾ä

ÇóÒ»²éѯoracleÊý¾Ý¿âËÀËøµÄSQLÓï¾ä
лл

---

°Ú¶Éһϣ¬É¶¶¼ÓÐÁË¡£¡£¡£
select C.sid,C.serial#,B.object_name,C.username,C.machine,C.terminal,C.program
from v$locked_object A,all_objects B,v$session C
where A.session_id = C.sid and A.object_id = B.object_id;

---

select object_id,session_id,locked_mode from v$locked_object;
 
  select t2.username,t2.sid,t2.serial#,t2.logon_time 
  from v$locked_object t1,v$session t2 
  where t1.session_id=t2.sid order by t2.logon_time;

---

ºÃÏñÒª¹ÜÀíԱȨÏ޲ſÉÒÔÓÃÉÏÃæµÄSQL

---

select object_id,session_id,locked_mode from v$locked_object;
 
  select t2.username,t2.sid,t2.serial#,t2.logon_time 
  from v$locked_object t1,v$session t2 
  where t1.session_id=t2.sid order by t2.logon_time;

---

ÒýÓÃ

°Ú¶Éһϣ¬É¶¶¼ÓÐÁË¡£¡£¡£
select C.sid,C.serial#,B.object_name,C.username,C.machine,C.terminal,C.program
from v$locked_object A,all_objects B,v$session C
where A.session_id = C.sid and A.object_id = B.object_id;

ÕâÌõÓï¾äÎÒÑéÖ¤ÁË£¬¶ÔÓÚ×èÈûµÄÇé¿ö²»ÄÜÅųý¡£

---

SQL code:

1¡¢ÏȲéѯ³öÀ´
select b.sid,b.machine,c.object_name,a.oracle_username,
a.locked_mode,b.osuser,
'alter system kill