Background information
A session is a connection between an application and a database. On the Session Management page of ODC, you can view details about all sessions of a database under the current data source. ODC provides a visual interface that allows you to query session variables supported by the current database on the Session Management page.
Query sessions
Assume that you want to query all sessions of theodc_test database under the data sourcemysql420in the SQL development window.
Parameter | Example |
Data Source | mysql420 |
Database Name | odc_test |
In the left-side navigation pane, choose O&M Management > Session Management.
Select the data source
mysql420and click OK.
On the Session Management page, you can query all sessions under the data source
mysql420.
Parameter
Description
Session ID
The ID that uniquely identifies the current session.
User
The username used to log on to the database in the current session.
Source
The address from which the session is initiated.
Database Name
The name of the database accessed in the session.
Status
The status of the session. Valid values: SLEEP and ACTIVE.
Command
The type of the command being executed in the session.
Execution Duration (s)
The time in seconds spent on executing the current SQL query.
SQL
The actual SQL query being executed in the session.
ODP
The address of the proxy used for the session.
Search for the odc_test database in the search field to query all sessions established with the database.
Select a session. Then, you may close the session or close the query.
Close Session: closes the current session. You must recreate the connection before you can execute a statement.
Close Query: closes the current query for the target session. You can continue to execute other statements.
Click Refresh to refresh the list of sessions.