ORA-00031 Error -> Session marked for kill
By Santhosh N
This explains the oracle error, ORA-00031 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
Oracle Error: ORA-00031
Description: Session marked for kill.
Reason(s) for this Oracle error: This error will be raised when you try to kill a session by using ALTER SYSTEM
KILL SESSION command, which is already marked for kill.
The delay in killing could be either because of a network operation or it
is rolling back and the session will be killed as soon as possible after the
current uninterruptable operation is finished.
Possible steps to solve this error:
1) If you want to kill the session sooner, issue ALTER SYSTEM KILL SESSION
command again.
2) No action is required in reality if you are not in hurry
to kill the session.
Related FAQs
This explains the oracle error, ORA-00030 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00029 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00028 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00027 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00026 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00025 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
ORA-00031 Error -> Session marked for kill (1485 Views)