Session management
Background information
A connection between an application and a database is called a session. The Session Management page in ODC displays detailed information about all sessions connected to the current data source. This page also provides a visual interface for querying the session variables that the current database supports.
Query sessions
This example shows how to query all session information for the `odc_test` database in the `obmysql4.2.0` data source.
Item |
Example value |
Data source |
obmysql4.2.0 |
Database name |
odc_test |
In the SQL Developer window, click Operations Management > Session Management.
Select the obmysql4.2.0 data source and click the OK button.
The Session Management page displays all session information for the obmysql4.2.0 data source.
Session information
Description
Session ID
The ID of the current session. This is the unique identifier for the session.
User
The database username used for the session logon.
Source
The address that initiated the session.
Database name
The name of the database that the current session is accessing.
Status
The status of the current session. The status can be SLEEP or ACTIVE. ODC V4.2.3 and later versions let you filter sessions by status.
Command
The type of command that the session is currently executing.
Running time (s)
The time spent executing the current SQL statement.
SQL
The content of the SQL statement that the session is currently executing.
OBProxy
The address of the proxy that the session is accessing.
In the search box, search for the `odc_test` database to view all its session information.
Select a session to shut it down or kill its query.
Shut down session: Shuts down the session. You must reconnect to execute statements.
Kill query: Kills the current query of the target session. You can still execute other statements in the session.
Click the refresh button to update the session list.