Session Manager Guide
The Session Manager in DBeaver provides you with control and visibility into your sessions, allowing you to terminate, disconnect, view and search for sessions, as well as perform several other actions.
To open the Session Manager:
1) In the Database Navigator, navigate to your desired database.
2) Go to the Administer section.
3) Double-click on Session Manager or right-click and select View Session Manager.
Once you have opened the Session Manager, you will have access to a variety of functionalities based on your database type. To access these functionalities, you must right-click on the desired session, or select the session and use the buttons in the bottom toolbar of the Editor. Here is a rundown of the buttons and their functionalities:
|Kill Session||Terminates the selected session forcefully.|
|Disconnect Session||Disconnects the selected session from the server.|
|Show Active/All Connections||Toggles between displaying only the active sessions and all sessions in your database.|
|Show Background||Reveals background processes that are running in the session.|
|Show Inactive||Shows the sessions that are currently inactive in your database.|
|Refresh||Updates the session list to reflect the current state of the database.|
|Configure Auto-Refresh||Allows you to set up automatic refreshing of the session list.|
|SQL Script||Calls a SQL script that will display sessions in a table format.|