Oracle Ëø±í

ͨ¹ýPLSQL Developer½øÐÐÊý¾Ý²Ù×÷
1,select * from table1                  ¼ìË÷Õý³£
2,select * from table1 for update      ±íÖ±½ÓËÀËø,ÎÞÊý¾Ý±»¼ìË÷³öÀ´

ÇëÎÊÕâÊÇΪʲô,ÓкÎÔ­ÒòΪÔì³ÉÕâÑùµÄÇé¿ö,
ÔÚÖ´Ðв½Öè2Ç°,²éѯsessions²¢Î´·¢ÏÖÓÐËø±íÏÖÏó.

---

ûÈËÖ§³Ö???

---

Ó¦¸ÃÓбðµÄsessionËø¶¨Á˸ñíÉÐδÌá½»
select a.oracle_username,b.object_name,a.PROCESS,c.TYPE
from v$locked_object a,all_objects b,v$session c
where a.object_id=b.object_id
  and a.session_id=c.sid
  and b.object_type='TABLE'

²é¿´Ò»ÏÂ

---

ÒýÓÃ

ͨ¹ýPLSQL Developer½øÐÐÊý¾Ý²Ù×÷
1,select * from table1                  ¼ìË÷Õý³£
2,select * from table1 for update       ±íÖ±½ÓËÀËø,ÎÞÊý¾Ý±»¼ìË÷³öÀ´

ÇëÎÊÕâÊÇΪʲô,ÓкÎÔ­ÒòΪÔì³ÉÕâÑùµÄÇé¿ö,
ÔÚÖ´Ðв½Öè2Ç°,²éѯsessions²¢Î´·¢ÏÖÓÐËø±íÏÖÏó.

»ù±¾ÉÏÊǼǼ±»ËøÁË¡£

ÄãÕâÀï˵µÄ ÔÚÖ´Ðв½Öè2Ç°,²éѯsessions²¢Î´·¢ÏÖÓÐËø±íÏÖÏó.

ÄãÕâÀïµÄÊÇÔõô²éµÄ£¬·¢ÉúÄãÕâÀïµÄÇé¿ö£¬Ó¦¸ÃÓÐÖÁÉÙÒ»¸öTMËøºÍTXËø

---

ͨ¹ýPLSQLÖеÄTools sessions ²éѯµÄ

---

ÒýÓÃ

ͨ¹ýPLSQLÖеÄTools sessions ²éѯµÄ

ÎÒÊÔÁËһϣ¬Ò²¿´²»µ½½á¹û
ÓÃÓï¾ä²é

select a.oracle_username,b.object_na