Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle Database Error: ORA-00031      [Return To Oracle Error Index] Jump to:  
Oracle Error: ORA-00031

Error Description:
Session marked for kill

Error 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.


Add a comment 
daniel nangahFeb 13th, 2019 3:50pm
Alter system kill session stays for hours without killing the session. Even disconnect states session is marked for kill but its not gone.
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 99 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?