Oracle 9i Transactions Test

This test reports the performance metrics related to the transactions occurring on the Oracle9i application server.

Target of the test : An Oracle 9i Application Server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for every instance of the Oracle 9i AS monitored.

Configurable parameters for the test
Parameter Description

Test period

How often should the test be executed.

Host

The host for which the test is to be configured.

Port

In the Port text box, it is recommended that you provide the port at which the OPMN (Oracle Process Manager and Notification) process of the Oracle application server instance listens. To know at which port OPMN listens, click on the Ports tab in the following URL: http://<oraHttpServerIP>:<OraHttpServerport>. This tab lists the port numbers that were assigned to the services executing on the Oracle application server. The port number displayed against the Oracle notification server request port entry is the OPMN port, and the same should be specified in the Port text box.

HomeDir

The absolute path of the directory in which the Oracle 9i application server has been installed.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Active transactions

Indicates the current number of open transactions.

Number

A high value of this measure may indicate a large number of active transactions. Alternatively, this may also indicate that due to some reasons the users are not able to complete the transactions.

Transactions commits

Indicates the rate at which the transactions were committed.

Trans/Sec

 

Transaction rollbacks

Indicates the rate at which transactions wee rolled back during the last measurement period.

Trans/Sec

A high value here would mean that more number of transactions are being rolled back.