Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How to kill a session
Hi,
I try to kill a session of a given user name with a procedure.
My procedur seems to be correct but when I try to read V$SESSION in my
procedure when I compile, I have error : This tble or this view doesn't
exist. So i tried to use the real name SYS.V_$SESSION but I've got the same
error! So how can I get the SID and Serial of the Session of an user to kill
his session. Becaus ALTER SYSTEM KILL SESSION needs those parameters.
Thx Received on Tue Oct 01 2002 - 05:14:54 CDT
![]() |
![]() |