ora-00054 and ora-00031

×ݺáËĺ£

ora-00054 and ora-00031


½ñÌìÔÚ´´½¨Ë÷ÒýµÄʱºò£¬Å׳öÁËORA-00054 Õâ¸ö´íÎ󣬼ìË÷ÁËһϠhttp://ora-00054.ora-code.com/ µÃµ½ÈçÏÂÐÅÏ¢£º£ £ 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. £ £  ¿´À´Ó¦¸ÃÊÇËøµÄÎÊÌ⣬¼ì²éËøÐÅÏ¢£º£ £ £ £ select object_name ¶ÔÏóÃû³Æ,machine as Ö÷»ú,s.program ³ÌÐò,s.sid,s.serial#,p.spid as OS½ø³ÌºÅ from v$locked_object l,dba_objects o ,v$session s ,v$process pwhere l.object_id=o.object_id and l.session_id=s.sidand s.paddr=p.addr;
Ö´ÐÐalter system kill session 'sid,serial#';
Å׳öora-00031£¬¼ìË÷http://ora-00031.ora-code.com/µÃµ½ÈçÏÂÐÅÏ¢£º




ORA-00031:
session marked for kill

Cause:
The session specified in an ALTER SYSTEM KILL SESSION command cannot be killed immediately because the session is involved in a non-interruptible operation (for example, rolling back a transaction or being blocked by a network operation). The session has been marked to be killed as soon as possible after the current operation is done.

Action:
No action is required for the session to be killed, but further executions of the ALTER SYSTEM KILL SESSION command on this session may cause the session to be killed sooner.
±íʾ´Ë»á»°ÒѾ­±ê¼ÇΪ±»É¾³ýµ«ÊÇÈÔÈ»ÔÚ×÷һЩrollbackµÄ¹¤×÷×ÊÔ´ÔÝʱ²»»á±»ÊÍ·Å
Ö´ÐУº
select object_name ¶ÔÏóÃû³Æ,machine as Ö÷»ú,s.program ³ÌÐò,s.sid,s.serial#,p.spid as OS½ø³ÌºÅ from v$locked_object l,dba_objects o ,v$session s ,v$process pwhere l.object_id=o.object_id and l.session_id=s.sidand s.paddr=p.addr;
µÃµ½SID£¬È»ºóÖ´ÐÐ
select spid from v$process p,v$session vwhere p.addr=v.paddrand v.sid=£¿
×îºóÓÃOSÀ´KILL
cmdÏÂ orakill db_name SPID