Database Autonomy Service (DAS) provides the session management feature that allows you to view or terminate the sessions of a database instance. You can also export statistics of the sessions. This topic describes how to use the session management feature.

Prerequisites

A database instance is connected to DAS and is in the Accessed state.

Procedure

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Instance Monitoring.
  3. Find the database instance that you want to manage and click the instance ID. The instance details page appears.
  4. In the left-side navigation pane, click Instance Sessions.
  5. On the Session Management page, you can perform the following operations in the Instance Sessions and Session Statistics sections:p2022010502
    • Kill sessions.
    • View the statistics of sessions: You can view the total number of sessions, the number of active sessions, the longest session runtime, the number of sessions longer than 3 seconds, and queries that did not use indexes. You can also view the number of sessions and active sessions categorized by namespaces or clients.
    • Export the statistics of sessions: You can export summary session statistics or session statistics categorized by clients or namespaces.