RE: How to kill a user active session?

yes... it's right, I ever did it.
I kill the session from both EOM and unix command, then when I shutdown my database using 'shutdown immediate', it take a very very a long time and it means there is hanging in the database.... so I decide to shutdown it using 'shutdown abort' (I know this isn't recommended). o ya... that session have run deleting for 6 million rows in one table without condition.

anyone know how to kill the session better ?

Anies.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Djordje Jankovic
Sent: Wednesday, July 26, 2000 10:01 PM
To: Multiple recipients of list ORACLE-L Subject: RE: How to kill a user active session?

My experience is that it is better to kill first the process on the unix side, and if it is not killed after some time than you also kill it on oracle side (enterprise manager, alter system kill/disconnect session). If you kill it on oracle side first you may be left with a zombie process on os side, that you do not know where it came from (once you kill it from oracle, if it is still there you do not sid spid from v$process).

A note of caution: Ault in the "Oracle8 Administration and Management" warns that killing a process on both os and oracle side may result in database hang situations. I have never experienced that. Somebody else from the list did ?

Djordje

-----Original Message-----
Sent: July 26, 2000 9:03 AM
To: Multiple recipients of list ORACLE-L

You can also kill the o/s pid if alter system kill session is not working and you are absolutely sure this is a runaway process.

-----Original Message-----
Sent: Wednesday, July 26, 2000 3:34 AM
To: Multiple recipients of list ORACLE-L

> 1. Can any body please explain, why this above error came even when
I can see the username, sid and status as active in v$session.

when you see the session_id in v$session, you could kill that session

> 2. Also, please, is there any other way to kill an active user
session?

use the instance manager (the one of utilities in enterprise manager).

HTH, Anies.

 -----Original Message-----
L., Teki
Sent: Wednesday, July 26, 2000 11:27 AM
To: Multiple recipients of list ORACLE-L

Hi All,

Environment : Solaris 2.6 : db version : 8.0.4

One of my developers was accessing the database thru SQL*NET. He was doing simple commands (like descry. Table structures, etc) in SQL PLUS. After some time his screen hung. He could not close the screen. He ended sql task through task manager on PC. After this, I queried the table v$session and the following are the details of v$session table query.

Username - hall :::: sid -- 13 :::: serial# --5555 ::: status - active

  I gave the following command.

         ALTER SYSTEM KILL SESSION '13,5555'; Now, I got error ---- ORA - 00030 : user session ID does not exist

I repeated the above sequence of actions after 5 minutes, i.e., querying the v$session and then giving the command --- alter system kill session.

I got same error message as above. (while the above activity is going on, other developers were accessing db through SQL NET).

QUESTIONS :

1. Can any body please explain, why this above error came even when I can see the username, sid and status as active in v$session.
2. Also, please, is there any other way to kill an active user session?

 Thanks in advance,

Rao

teki01_at_mediaone.net <mailto:teki01_at_mediaone.net>

--
Author: Djordje Jankovic
  INET: djankovic_at_corp.attcanada.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L