ORA Errors

ORA-00031: session marked for kill.

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 uninterruptible operation is done.

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.

Solution

Find the thread in OS level

select vs.sid,vs.username,vs.osuser, vs.process,vp.spid from v$session vs, v$process vp where vs.paddr = vp.addr and vs.username='<User_name>’ and vs.osuser='<applmgr>’;

Will get output like this

SID    USERNAME     OSUSER   PROCESS   SPID

123        AP              applmgr     456          8765

Kill the session from OS level

kill –9 spid

Login database server

[oracle@san ~]$ ps -ef |grep 8765

oracle 87651 64 03:00 ? 02:03:43 oracleeraps1p (LOCAL=NO)

oracle 62744 62411 0 06:11 pts/4 00:00:00 grep 8765


Go to Source of this post
Author Of this post:
Title Of post: ORA Errors
Author Link: {authorlink}