Friday, July 8, 2016

Oracle Query / Kill Sessions


DBAs have great power over the Database, this gist will give us a taste of that.

And This is becuase with the above sql queries you will be able to find out how many sessions are running against your DB, who is using it, to which schema ar connected and more..

And even better if you need to kill a session for some maintaincance is as easy as just Kill  the sessions that won't let you do it.

Note: Be kind to ask whom ever is connected to disconnect before killing sessions.

Source: 
https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2088.htm#REFRN30223
http://stackoverflow.com/questions/55342/how-can-i-kill-all-sessions-connecting-to-my-oracle-database

Post a Comment