Database Autonomy Service (DAS) provides the session management feature. This feature collects the information about sessions. You can view the session statistics of a database instance on the Session Management tab.

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. In the Instance Sessions section, you can view the information about sessions. You can also select sessions and click Kill Selected to close the selected sessions.
    ss
  6. In the Session Statistics section, you can view statistics by user, statistics by source, and statistics by database.
    Note You can view summary statistics about sessions. This includes the total number of sessions, the total number of active sessions, the maximum session duration in seconds, the number of sessions that last more than 3 seconds, and the number of queries that do not use indexes.