|
Re: Kill the Session [message #566 is a reply to message #564] |
Wed, 20 February 2002 23:46 |
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
|
|
|