SAP Knowledge Base Article - Preview

3435163 - ORA-00031: session marked for kill

Symptom

To find out <pid> for error ORA-00031 explained in SAP note 20071 - Permanent lock after connection termination:

ALTER SYSTEM KILL SESSION '<sid>,<serial#>';

              If this command returns after some time with the message

ORA-00031: session marked for kill

              , this means that the session cannot yet be terminated. In this case, you can try to hard terminate the corresponding shadow process (UNIX: "kill -9 <pid>", WINDOWS: "orakill <sid> <thread>").


Read more...

Product

SAP NetWeaver all versions

Keywords

ORA-00031, killed, v$process, v$session, "ALTER SYSTEM KILL SESSION" , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.