Menu Sessions - Active Sessions history

The module presents the history of sessions performed in the database at the indicated time. The data is presented in three basic groups:

• Sessions - active sessions.
• Transactions - sessions with transactions.
• Threads - information about the threads of the session

Session information is collected using a procedure executed at 60-second intervals (default module setting according to the parameter available in the Settings menu SESSION HISTORY SETTINGS section).

Clicking on the table record presents details for the selected snap in the tabs:

Sessions

Transactions

Threads

On the screen, it is possible to search the user session information with additional filters. When the [Refresh] button is pressed, only those sessions that met the search results in the given period will be presented. On the main screen, it is possible to search sessions using filters:

• Statement hash
• Username
• Connection id

In addition, when you select Show addtional filters, you can use additional filters such as:

• Application
• Application user

Chart view

Session history information is also available in the form of charts. To do this, switch to the chart view on the page, as in the example below.

There are several possible charts to choose from that contain session information:

• Active sessions - active sessions
• Transactions - sessions with transactions
• Threads - information about session threads
• All statistics - the option presents all collections on a common chart.

Clicking on any point on the chart will display session information for that point.