www.oradev.com
  Database   Sql   Functions   Packages   Performance   Books   Oracle   Other   About   XML   ORA-messages
  ORA-00031

Common error messages

TNS connection closed
IO error writing block
Resource busy
Invalid character
Invalid datatype
Syntax error
Looping chain synonyms
Resolve connect identifier
number too large for buffer
ORA-01487
ORA-04031
ORA-12545
ORA-06550
ORA-01650
All error messages



  OraDev.com

ORA-00031: 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.