| Make an End to a user session [message #8895] |
Wed, 01 October 2003 13:33  |
Upperm
Messages: 95
Registered: July 2003
|
Member |
|
|
Hello,
I'm an oracle 8.1.7.0.0 Newbie :)
I want to make an end to a user session.
These are the steps I've done:
Step 1:
SELECT SID FROM V$SESSION;
==> this gives me the value of the Session Id.
Step 2:
ALTER SYSTEM KILL SESSION value;
==> I got the following message error:
ORA-00026: ID session non valide ou abscent
My Question= What is wrong?
Thanks a lot Folks :)
|
|
|
|
| Re: Make an End to a user session [message #8897 is a reply to message #8895] |
Wed, 01 October 2003 14:04  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
SQL> select sid,serial# from v$session where username='SCOTT';
SID SERIAL#
---------- ----------
15 784
SQL> alter system kill session '15,784';
System altered.
SQL> select sid,serial#,username,status from v$session where username='SCOTT';
SID SERIAL# USERNAME STATUS
---------- ---------- ------------------------------ --------
15 784 SCOTT KILLED
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
