Database Session Operations

This topic provides an overview of operations that can be performed over database sessions.

Based on the database type for which you have the session browser open, you can perform various operations on the DB sessions from the toolbar menu. Some common operations that you can perform on an open connection session are as follows:

Toolbar Options	Description
Search	Search for specific session information through matching text (case sensitive or whole words) or regex pattern
Reload	Reload the list of database sessions with updated session information and current state of the database
Auto-Refresh	Configure auto-refresh for the session and set the time durations (in seconds) to refresh the session, or set to never automatically refresh (No-Refresh) the session.
Sort Session	Filter to view database sessions by either or all of the following: Users having access to the session Session Host Current Status (Active/Inactive) of the database session
Disconnect Session	Disconnect a selected session from the server. Based on the Session Browser settings, the session is disconnected either: immediately, or after the ongoing transaction in the session are complete, or after you review the active and open transactions and confirm to disconnect
Kill Session	Kill or terminate the selected session or session instance. Based on the Session Browser settings, the session is terminated either: immediately, or, after the ongoing transaction are rolled back, session locks released, and session resources are recovered after you review the active and open transactions in the session and confirm to terminate
Settings	Access the Session Browser settings in the DB Navigator > Settings > Operations tab
Current SQL Statement	View the SQL script of the ongoing transaction on the selected session