尊龙凯时人生就是博

OracleÅÌÎʱíËø״̬µÄÊÊÓü¼ÇÉ

OracleÊÇÒ»¿îÇ¿Ê¢µÄ¹ØϵÐÍÊý¾Ý¿âÖÎÀíϵͳ £¬ËüÌṩÁ˸»ºñµÄ¹¦Ð§ÒÔ¼°ÎÞаµÄÅÌÎÊÓïÑÔ¡£ÔÚÈÕ³£¿ª·¢ºÍÔËάÀú³ÌÖÐ £¬ÎÒÃǾ­³£»áÓöµ½ÅÌÎʱíËø״̬µÄÐèÇó¡£±¾ÎĽ«ÏÈÈÝÔõÑùʹÓÃOracleµÄϵͳÊÓͼÀ´ÅÌÎʱíËø״̬ £¬²¢¸ø³öÏêϸµÄ´úÂëʾÀý¡£

ÔÚOracleÖÐ £¬±íËøÊÇÓÃÀ´¿ØÖƲ¢·¢»á¼ûµÄÖ÷Òª»úÖÆ¡£µ±Ò»¸ö»á»°¶Ô±í¾ÙÐиüвÙ×÷ʱ £¬ÏµÍ³»á×Ô¶¯ÔڸñíÉϼÓËø £¬±ÜÃâÆäËû»á»°¶ÔͳһÐоÙÐв¢·¢¸üР£¬´Ó¶øÈ·±£Êý¾ÝµÄÒ»ÖÂÐÔºÍÍêÕûÐÔ¡£

ÒªÅÌÎʱíËø״̬ £¬¿ÉÒÔͨ¹ýOracleÌṩµÄϵͳÊÓͼÀ´ÊµÏÖ¡£ÆäÖÐ £¬×î³£ÓõÄÊÇV$LOCKºÍV$LOCKED_OBJECT¡£

V$LOCKÊÓͼ°üÀ¨ÁËÄ¿½ñÊý¾Ý¿âÖеÄËùÓÐËøÐÅÏ¢ £¬°üÀ¨ËøÀàÐÍ¡¢Ëø¶¨¹¤¾ß¡¢ËøµÄ³ÖÓÐÕߵȡ£¿ÉÒÔͨ¹ýÅÌÎʸÃÊÓͼÀ´»ñÈ¡Ä¿½ñÊý¾Ý¿âÖеÄËùÓбíËøÐÅÏ¢¡£

V$LOCKED_OBJECTÊÓͼÔò°üÀ¨ÁËÄ¿½ñÕýÔÚ±»Ëø¶¨µÄ¹¤¾ßÐÅÏ¢ £¬°üÀ¨±»ËøµÄ¹¤¾ßID¡¢±íÃû¡¢Ä£Ê½ÃûµÈ¡£¿ÉÒÔͨ¹ýÅÌÎʸÃÊÓͼÀ´»ñÈ¡Ä¿½ñÕýÔÚ±»Ëø¶¨µÄ±íÐÅÏ¢¡£

ÏÂÃæÊÇÒ»¸ö¼òÆӵĴúÂëʾÀý £¬ÑÝʾÔõÑùÅÌÎʱíËø״̬£º

-- ÅÌÎÊÄ¿½ñÊý¾Ý¿âÖеÄËùÓбíËøÐÅÏ¢
SELECT
    l.session_id,
    l.locked_mode,
    l.lock_type,
    l.block,
    o.object_name,
    s.os_user_name
FROM
    v$lock l,
    dba_objects o,
    v$session s
WHERE
    l.type = 'TM'
    AND l.id1 = o.object_id
    AND l.sid = s.sid;

-- ÅÌÎÊÄ¿½ñÕýÔÚ±»Ëø¶¨µÄ±íÐÅÏ¢
SELECT
    lo.session_id,
    lo.object_id,
    lo.object_name,
    o.owner,
    s.os_user_name
FROM
    v$locked_object lo,
    dba_objects o,
    v$session s
WHERE
    lo.object_id = o.object_id
    AND lo.session_id = s.sid;

µÇ¼ºó¸´ÖÆ

ͨ¹ýÒÔÉÏ´úÂëʾÀý £¬ÎÒÃÇ¿ÉÒÔÇåÎúµØÏàʶĿ½ñÊý¾Ý¿âÖеıíËø״̬ £¬°üÀ¨ÄÄЩ±í±»Ëø¶¨¡¢±»ÄÄЩ»á»°³ÖÓеÈÐÅÏ¢¡£ÕâЩÐÅÏ¢¿ÉÒÔ×ÊÖúÎÒÃǸüºÃµØ¶¨Î»²¢·¢»á¼ûµÄÎÊÌâ £¬Ìá¸ßϵͳµÄÐÔÄܺÍÎȹÌÐÔ¡£

×ܵÄÀ´Ëµ £¬ÅÌÎÊOracle±íËø״̬µÄ¼¼Çɲ¢²»ÖØ´ó £¬Í¨¹ýϵͳÊÓͼºÍSQLÅÌÎÊ £¬ÎÒÃÇ¿ÉÒÔÇáËɵػñÈ¡µ½ËùÐèµÄÐÅÏ¢¡£Ï£Íû±¾ÎÄÄܹ»×ÊÖú¶ÁÕ߸üºÃµØÃ÷È·ºÍÓ¦ÓÃOracleÊý¾Ý¿âÖеıíËø»úÖÆ¡£

ÒÔÉϾÍÊÇOracleÅÌÎʱíËø״̬µÄÊÊÓü¼ÇɵÄÏêϸÄÚÈÝ £¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡

ÃâÔð˵Ã÷£ºÒÔÉÏչʾÄÚÈÝȪԴÓÚÏàÖúýÌå¡¢ÆóÒµ»ú¹¹¡¢ÍøÓÑÌṩ»òÍøÂçÍøÂçÕûÀí £¬°æȨÕùÒéÓë±¾Õ¾ÎÞ¹Ø £¬ÎÄÕÂÉæ¼°¿´·¨Óë¿´·¨²»´ú±í尊龙凯时人生就是博ÂËÓÍ»úÍø¹Ù·½Ì¬¶È £¬Çë¶ÁÕß½ö×ö²Î¿¼¡£±¾ÎĽӴýתÔØ £¬×ªÔØÇë˵Ã÷À´ÓÉ¡£ÈôÄúÒÔΪ±¾ÎÄÇÖÕ¼ÁËÄúµÄ°æȨÐÅÏ¢ £¬»òÄú·¢Ã÷¸ÃÄÚÈÝÓÐÈκÎÉæ¼°ÓÐÎ¥¹«µÂ¡¢Ã°·¸Ö´·¨µÈÎ¥·¨ÐÅÏ¢ £¬ÇëÄúÁ¬Ã¦ÁªÏµ尊龙凯时人生就是博ʵʱÐÞÕý»òɾ³ý¡£

Ïà¹ØÐÂÎÅ

ÁªÏµ尊龙凯时人生就是博

18523999891

¿É΢ÐÅÔÚÏß×Éѯ

ÊÂÇéʱ¼ä£ºÖÜÒ»ÖÁÖÜÎå £¬9:30-18:30 £¬½ÚãåÈÕÐÝÏ¢

QR code
sitemap¡¢ÍøÕ¾µØͼ