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

Loading xml file data to oracle table using python

Sample xml file (test.xml): <?xml version="1.0"?> <data>     <customer name="Ravi" >     ...