Use the Instance Sessions feature in Database Autonomy Service (DAS) to view, export, and terminate current sessions on a target instance.
Prerequisites
The target database instance must be connected to DAS and have a status of Normal Access.
Procedure
Log on to the DAS console.
In the navigation pane on the left, click .
Find the target instance and click the instance ID to open the instance details page.
In the left-side navigation pane, click Instance Sessions.
-
On the Instance Sessions page, you can manage the current sessions of the instance in the Instance Sessions and Session Statistics sections. In the Instance Sessions section, you can click Refresh to obtain the latest session data, enable Auto-refresh to automatically update the data, and turn on the Active Sessions switch to filter for active sessions. You can also use the search box to find specific sessions. To terminate sessions, select the desired sessions and click Kill Selected Sessions. In the Session Statistics section, you can view summary statistics for the sessions.
-
Terminate sessions.
-
View detailed session information, including anomalies, active sessions, and metrics like maximum execution time and CPU utilization.
-
View session statistics, including an overview with metrics like total sessions, running sessions, and max session runtime. These statistics can also be grouped by user, access source, and database.
-
Export session statistics, including the session overview and data grouped by user, access source, and database.
-