oracleËÀËøÎÊÌâÒ»Ö±À§ÈÅ×ÅÎÒÃÇ£¬ÏÂÃæ¾Í½ÌÄúÒ»¸öoracleËÀËøµÄ¼ì²é·½·¨£¬Èç¹ûÄú֮ǰÓöµ½¹ýoracleËÀËø·½ÃæµÄÎÊÌ⣬²»·ÁÒ»¿´¡¡
oracleËÀËøÎÊÌâÒ»Ö±À§ÈÅ×ÅÎÒÃÇ£¬ÏÂÃæ¾Í½ÌÄúÒ»¸öoracleËÀËøµÄ¼ì²é·½·¨£¬Èç¹ûÄú֮ǰÓöµ½¹ýoracleËÀËø·½ÃæµÄÎÊÌ⣬²»·ÁÒ»¿´¡£
Ò»¡¢Êý¾Ý¿âËÀËøµÄÏÖÏó
³ÌÐòÔÚÖ´ÐеĹý³ÌÖУ¬µã»÷È·¶¨»ò±£´æ°´Å¥£¬³ÌÐòûÓÐÏìÓ¦£¬Ò²Ã»ÓгöÏÖ±¨´í¡£
¶þ¡¢oracleËÀËøµÄÔÀí
µ±¶ÔÓÚÊý¾Ý¿âij¸ö±íµÄijһÁÐ×ö¸üлòɾ³ýµÈ²Ù×÷£¬Ö´ÐÐÍê±Ïºó¸ÃÌõÓï¾ä²»Ìá½»£¬ÁíÒ»Ìõ¶ÔÓÚÕâÒ»ÁÐÊý¾Ý×ö¸üвÙ×÷µÄÓï¾äÔÚÖ´ÐеÄʱºò¾Í»á´¦Óڵȴý״̬£¬´ËʱµÄÏÖÏóÊÇÕâÌõÓï¾äÒ»Ö±ÔÚÖ´ÐУ¬µ«Ò»Ö±Ã»ÓÐÖ´Ðгɹ¦£¬Ò²Ã»Óб¨´í¡£
Èý¡¢oracleËÀËøµÄ¶¨Î»·½·¨
ͨ¹ý¼ì²éÊý¾Ý¿â±í£¬Äܹ»¼ì²é³öÊÇÄÄÒ»ÌõÓï¾ä±»ËÀËø£¬²úÉúËÀËøµÄ»úÆ÷ÊÇÄÄһ̨¡£
1)ÓÃdbaÓû§Ö´ÐÐÒÔÏÂÓï¾ä
ÒÔÏÂÊÇ´úÂëƬ¶Î£º
select username,lockwait,status,machine,program from v$session where sid in
(select session_id from v$locked_object)
Èç¹ûÓÐÊä³öµÄ½á¹û£¬Ôò˵Ã÷ÓÐËÀËø£¬ÇÒÄÜ¿´µ½ËÀËøµÄ»úÆ÷ÊÇÄÄһ̨¡£×Ö¶Î˵Ã÷£º
Username£ºËÀËøÓï¾äËùÓõÄÊý¾Ý¿âÓû§;
Lockwait£ºËÀËøµÄ״̬£¬Èç¹ûÓÐÄÚÈݱíʾ±»ËÀËø¡£
Status£º ״̬£¬active±íʾ±»ËÀËø
Machine£º ËÀËøÓï¾äËùÔڵĻúÆ÷¡£
Program£º ²úÉúËÀËøµÄÓï¾äÖ÷ÒªÀ´×ÔÄĸöÓ¦ÓóÌÐò¡£
2)ÓÃdbaÓû§Ö´ÐÐÒÔÏÂÓï¾ä£¬¿ÉÒԲ鿴µ½±»ËÀËøµÄÓï¾ä¡£
ÒÔÏÂÊÇ´úÂëƬ¶Î£º
select sql_text from v$sql where hash_value in
(select sql_hash_value from v$session where sid in
(select session_id from v$locked_object))