Db Sessions Test

To work with a database instance, to make data queries or to manage the database instance, you have to open a database session. This can happen as follows:

  • The user logs on to the database instance with a user name and password, thus opening a database session. Later, the database session is terminated explicitly by the user or closed implicitly when the timeout value is exceeded.
  • A database tool implicitly opens a database session and then closes it again later.

This test reveals the level of activity on the MaxDB server by reporting the number of active database sessions.

Target of the test : A MaxDB server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for the MaxDB server being monitored.

Configurable parameters for the test
Parameter Description

Test Period

How often should the test be executed.

Host

The host name of the server for which the test is to be configured.

Port

The port number to which the server is listening.

DatabaseName

The test connects to a database on MaxDB and extracts performance statistics from the system tables in the database. Therefore, provide the name of a database in the DatabaseName text box.

Username

Since users with the SYSDBA privilege alone are allowed access to system tables, specify the name of such a user against Username.

Password

Provide the Password that corresponds to the specified Username.

Confirm Password

Confirm the password by retyping it here.

Measurements made by the test

Measurement

Description

Measurement Unit

Interpretation

Number of sessions

Indicates the number of currently active database sessions.

Number

This measure is a good indicator of the workload on the database server.