Home » SQL & PL/SQL » SQL & PL/SQL » Kill the Session
Kill the Session [message #564] Wed, 20 February 2002 22:53 Go to next message
Dinesh
Messages: 31
Registered: October 2001
Member
How can Get sid and serial# of current session
Re: Kill the Session [message #566 is a reply to message #564] Wed, 20 February 2002 23:46 Go to previous message
Pramod
Messages: 18
Registered: April 1999
Junior Member
By querying the V$SESSION view , we can determine who is logged on ,as well as information such as the time of logon .

Kill a session - ALTER system kill session '&sid,&serial'
Select sid,serial#,status from V$session where username='name';

I have got these stuff from these message list only please refer to it.
Message is Posted by Satish Shrikhande on February 11, 2002 In Reply to: Interview Questions(SQL, PL/SQL, SQL Plus, Developer, Database, anything dealing with Oracle) posted by pranavi on February 10, 2002

Pramod Karanjkar
Previous Topic: Querry about the name of table and no of records
Next Topic: Re: How to insert pictures in a table
Goto Forum:
  


Current Time: Fri Sep 24 06:57:35 CDT 2021