Home » RDBMS Server » Server Administration » to kill a session
to kill a session [message #328926] Mon, 23 June 2008 07:06 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


hi to all,

I have killed a session. the response i got is

ORA-00031 session marked for kill.

I have tried it many times to kill that particular session then too i receive the same error. Any solutions to solve this.

Thanks in Advance,

Seenu

Re: to kill a session [message #328927 is a reply to message #328926] Mon, 23 June 2008 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Any solutions to solve this.

There is nothing to solve, just wait Oracle makes the clean-up.

It is NOT an error, just an informative message.

Regards
Michel
Re: to kill a session [message #328928 is a reply to message #328926] Mon, 23 June 2008 07:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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.

Regards
Michel
Re: to kill a session [message #328941 is a reply to message #328926] Mon, 23 June 2008 08:16 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above

in some/many/most cases, oracle will not clean out session until after OS process is terminated.
Previous Topic: enable constraint
Next Topic: high wark mark
Goto Forum:
  


Current Time: Sun Dec 11 04:24:58 CST 2016

Total time taken to generate the page: 0.12082 seconds