December 22 2014

ora-00031

ora-00031:session marked for kill

00031, 00000, “session marked for kill”
// *Cause: The session specified in an ALTER SYSTEM KILL SESSION command
// cannot be killed immediately (because it is rolling back or blocked
// on a network operation), but it has been marked for kill. This
// means it will be killed as soon as possible after its current
// uninterruptable 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.

ALTER SYSTEM KILL SESSION ‘60,299’;

发现进程杀不掉

select spid, osuser, s.program
from v$session s,v$process p
where s.paddr=p.addr and s.sid=60(60是上面的sid)

在OS级别  kill -9 spid 就可以了

 



Copyright 2019. All rights reserved.

Posted 2014年12月22日 by ucjmh in category "oracle

Leave a Reply

Your email address will not be published. Required fields are marked *