OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » to kill a session

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

to kill a session [message #328926]

Mon, 23 June 2008 07:06

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

Report message to a moderator

Re: to kill a session [message #328927 is a reply to message #328926]

Mon, 23 June 2008 07:07

Michel Cadot
Messages: 68667
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

Report message to a moderator

Re: to kill a session [message #328928 is a reply to message #328926]

Mon, 23 June 2008 07:08

Michel Cadot
Messages: 68667
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

Report message to a moderator

Re: to kill a session [message #328941 is a reply to message #328926]

Mon, 23 June 2008 08:16

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	enable constraint
Next Topic:	high wark mark

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 18 00:13:50 CDT 2024