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

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...