Oracle 9i Connection Cache Test
This test reports the performance metrics related to the connection cache of an instance of 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.
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. |
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Free cache size |
Indicates the number of free slots in the connection cache. |
Number |
|
Cache size |
Indicates the total size of the connection cache. |
Number |
|
Cache hits |
Indicates the number of times a request for connection has been fulfilled by the cache. |
Conns/Sec |
Reading from the cache is less expensive than reading from disk. Therefore, the higher this value, the better. |
Cache misses |
Indicates the rate at which the cache failed to fulfill a request for connection. |
Conns/Sec |
Reading from the cache is less expensive than reading from disk. Therefore, the lower this value, the better. |