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.
- Altibase
- AlloyDB
- Db2 for LUW
- Exasol
- Fujitsu Enterprise Postgres
- Greenplum
- MariaDB
- MongoDB
- MySQL
- MySQL on Google Cloud
- Netezza
- Oracle
- PostgreSQL
- PostgreSQL on Google Cloud
- Redshift
- Microsoft SQL Server
- Microsoft SQL Server on Google Cloud
To open the Session Manager:
-
In the Database Navigator, navigate to your desired database.
-
Go to the Administer section.
-
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:
Button | Image | Description |
---|---|---|
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. |
-
Views
-
Search
-
Projects
- Sample Database
-
Database Connections
- Edit Connection
- Invalidate/Reconnect to Database
- Disconnect from Database
- Change current user password
- Advanced settings
- Cloud configuration settings
- Local Client Configuration
- Connection Types
- Configure Connection Initialization Settings
- Tableau integration
- Transactions
- Drivers
- Tasks
- Cloud Explorer
- Cloud Storage
- Classic
- Cloud
- Changing interface language
- DBeaver extensions - Office, Debugger, SVG
- Installing extensions - Themes, version control, etc
- User Interface Themes
- Command Line
- Reset UI settings
- Reset workspace
- Troubleshooting system issues
- Posting issues
- Log files
- JDBC trace
- Thread dump
- Managing connections
- Managing variables
- Managing drivers
- Managing preferences
- Managing restrictions
- Windows Silent Install
- Snap installation