RE: How to kill a user active session?

I can usually compare the LOGON_TIME column of V$SESSION to a "ps -ef" Unix command to find the operating system process id. Then issue a kill -9 from Unix on the process.

Michael Armstead

> -----Original Message-----
> From: Maheshwara Rao, L., Teki [SMTP:teki01_at_mediaone.net]
> Sent: Wednesday, July 26, 2000 12:27 AM
> To: Multiple recipients of list ORACLE-L
> Subject: How to kill a user active session?
>
> 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>
Received on Wed Jul 26 2000 - 12:55:51 CDT