INSTALLATION DOCUMENTS BY RAVI

Saturday, April 15, 2017

SQL COMMANDS TO DISCONNECT USER FROM ORACLE DATABASE

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

Perfect order of ODI export and import

  Smart Export / Import is the recommended way to achieve such a migration. This is the easiest way to make sure all the dependencies are ta...