Oracle 9i Drivers Test

This test reports the performance metrics related to the JDBC Connection in an instance of the Oracle 9i 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
Threads creating connections	Indicates the current number of threads creating connections.	Number
Avg connection create time	Indicates the average time spent creating connections during the last measurement period.	Secs	An increase in this metric could indicate a bottleneck in the database/database connection points.
Max connection create time	Indicates the high water mark indicating the maximum time spent creating connections since the server was started.	Secs	A high value for this measure is indicative of a bottleneck during database access.
Connections open	Indicates the number of connections that have been opened per second in the last measurement period.	Conns/Sec	A very high value for this measure indicates a heavy load on database access.
Connections closed	Indicates the number of connections that have been closed per second.	Conns/Sec	The value of this measure must be equal to the Connections open. If this value is consistently less than Connections open, then it indicates a potential problem - that connections are hanging on to the database server.