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

  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...