Controlling Sessions

The following walkthrough describes how to control user sessions. You will learn how to view session information, stop query execution and disconnect sessions.

Starting Session

Execute the following query.

SELECT * FROM 
SCOTT.EMP

Perform the following steps:

  1. Open an SQL editor by clicking the New SQL button on the Devart-Main toolbar.
  2. Type or paste this code to the document.
  3. Execute the document by clicking the exclamation mark icon on the Devart-SQL toolbar.

Managing Sessions

Viewing Session Information

To call Session Manager, on the Fusion menu, point to Oracle*, and then click **Session Manager.

If you have the global PROCESS privilege, you will see all user sessions for the current connection. Otherwise, you will see only your own sessions.

Click on the OS User column caption to order all data by host. Find your connections (from your host). Then click on the connection. In the bottom part of the Session Manager you can see the text of the executing queries. Find your connection executing the query above.

Session Manager

Killing and Disconnecting Session

Right-click the session with our query and choose Kill Session from the shortcut menu. Click Yes in the appeared dialog.