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

Procedure

  1. In the left-side navigation pane, click Instance Sessions.
  2. On the page that appears, you can select Active Sessions or All Sessions in the Instance Sessions section to view information about sessions. You can also select sessions and click Kill Selected to close the selected sessions.
  3. In the Session Statistics section, you can view statistics by user, statistics by source, and statistics by database.
    Note You can view statistics such as the total number of sessions, the total number of active sessions, the maximum session runtime in seconds, the number of sessions that have a duration of more than three seconds, and the number of queries that do not use indexes.