Oracle³£¼û´íÎó——ORA 00054
ÈçºÎ½â¾öORA-00054×ÊÔ´Õý棬ҪÇóÖ¸¶¨NOWAIT£¿
²éÔÄ´íÎó´úÂëÖ¸ÄϺóÓÐÈçÏÂÌáʾ£º
ORA-00054 resource busy and acquire with NOWAIT specified
Cause: The NOWAIT keyword forced a return to the command prompt because a resource was unavailable for a LOCK TABLE or SELECT FOR UPDATE command.
Action: Try the command after a few minutes or enter the command without the NOWAIT keyword.
Ò»¡¢Ïà¹Ø֪ʶ¼ò½é
V$LOCKED_OBJECTÖеÄÁÐ˵Ã÷£º
XIDUSN£º»Ø¹ö¶ÎºÅ
XIDSLOT£º²ÛºÅ
XIDSQN£ºÐòÁкÅ
OBJECT_ID£º±»Ëø¶ÔÏóID
SESSION_ID£º³ÖÓÐËøµÄsessionID
ORACLE_USERNAME£º³ÖÓÐËøµÄOracle Óû§Ãû
OS_USER_NAME£º³ÖÓÐËøµÄ²Ù×÷ϵͳ Óû§Ãû
PROCESS£º²Ù×÷ϵͳ½ø³ÌºÅ
LOCKED_MODE£ºËøģʽ
dba_objectsµÄÁÐ˵Ã÷£¨ÍøÉÏÕҵģ¬ÀÁµÃ·ÒëÁË^_^£©
OWNER
Username of the owner of the object
OBJECT_NAME
Name of the object
SUBOBJECT_NAME
Name of the sub-object (for example,partititon)
OBJECT_ID
Object number of the object
DATA_OBJECT_ID
Object number of the segment which contains the object
OBJECT_TYPE
Type of the object
CREATED
Timestamp for the creation of the object
LAST_DDL_TIME
Timestamp for the last DDL change (including GRANT and REVOKE) to the object
TIMESTAMP
Timestamp for the specification of the object
STATUS
Status of the object
TEMPORARY
Can the current session only see data that it place in this object itself?
GENERATED
Was the name of this object system generated?
SECONDARY
Is this a secondary object created as part of icreate for
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
delete ɾ³ýÒ»ÕÅ´ó±íʱ¿Õ¼ä²»ÊÍ·Å£¬·Ç³£ÂýÊÇÒòΪռÓôóÁ¿µÄϵͳ×ÊÔ´£¬Ö§³Ö»ØÍ˲Ù×÷£¬¿Õ¼ä»¹±»ÕâÕűíÕ¼ÓÃ×Å¡£
truncate table ±íÃû (ɾ³ý±íÖмǼʱÊͷűí¿Õ¼ä)
DML Óï¾ä£º
±í¼¶¹²ÏíËø£º ¶ÔÓÚ²Ù×÷Ò»ÕűíÖеIJ»Í¬¼Ç¼ʱ£¬»¥²»Ó°Ïì
Ðм¶ÅÅËüËø£º¶ÔÓÚÒ»ÐмǼ£¬oracle »áÖ»ÔÊÐíÖ»ÓÐÒ»¸öÓû§¶ÔËüÔÚͬһʱ¼ä½øÐÐÐ޸IJÙ×÷ ......
net use \\ip\ipc$ " " /user:" " ½¨Á¢IPC¿ÕÁ´½Ó
net use \\ip\ipc$ "ÃÜÂë" /user:"Óû§Ãû" ½¨Á¢IPC·Ç¿ÕÁ´½Ó
net use h: \\ip\c$ "ÃÜÂë" /user:"Óû§Ãû" Ö±½ÓµÇ½ºóÓ³Éä¶Ô·½C£ºµ½±¾µØΪH:
net use h: \\ip\c$ µÇ½ºóÓ³Éä¶Ô·½C£ºµ½±¾µØΪH:
net use \\ip\ipc$ /del ɾ³ýIPCÁ´½Ó
net use h: /del ɾ³ýÓ³Éä¶Ô·½µ½±¾µ ......
<Ò»>ʵÏÖɱËÀij¸öÓû§µÄ¿Í»§¶ËÁ¬½Ó½ø³Ì
1.ÒÔ¹ÜÀíÔ±Éí·ÝµÇ¼ºó²é¿´V$SESSIONµÄÊÓͼ½á¹¹
SQL> desc v$session;
Ãû³Æ &n ......
OracleÌṩÁË·ÖÇø¼¼ÊõÒÔÖ§³ÖVLDB(Very Large DataBase)¡£·ÖÇø±íͨ¹ý¶Ô·ÖÇøÁеÄÅжϣ¬°Ñ·ÖÇøÁв»Í¬µÄ¼Ç¼£¬·Åµ½²»Í¬µÄ·ÖÇøÖС£·ÖÇøÍêÈ«¶ÔÓ¦ÓÃ͸Ã÷¡£
OracleµÄ·ÖÇø±í¿ÉÒÔ°üÀ¨¶à¸ö·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶Î£¨SEGMENT£©£¬¿ÉÒÔ´æ·Åµ½²»Í¬µÄ±í¿Õ¼äÖС£²éѯʱ¿ÉÒÔͨ¹ý²éѯ±íÀ´·ÃÎʸ÷¸ö·ÖÇøÖеÄÊý¾Ý£¬Ò²¿ÉÒÔͨ¹ýÔÚ²éѯ ......