Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00031: session marked for kill

532815Sep 5 2008 — edited Sep 5 2008

Hi All,

While I am using the below command

alter system kill session '2656,8073' immediate;

Sometimes i get the error message "*ORA-00031:session marked for kill*" and actually never killed. I have waited for 1-2 hours for this. So I have to find the process from v$process and kill the session by "kill / orakill" OS command.

But what i am searching for is that, even though i have given immediate, why its not killed and waiting for the transaction to complete? Is there any other option to abort the transaction for that session and kill it IMMEDIATELY?
Please share your views regarding this with me.

DKar

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 3 2008

Added on Sep 5 2008

#general-database-discussions

6 comments

29,189 views