Finding the running user session:
select sid,serial# from v$session where username = 'SH';
It will give the running session id if the specified user.
Killing the user session:
alter system kill session '807,3186' immediate;
It will disconnect the user from the database.
No comments:
Post a Comment