Oracle Session Cache Test

This test reports the performance metrics pertaining to the mod_plsql gateway's session cache.

Target of the test : An Oracle Web server

Agent deploying the test : An internal Agent

Outputs of the test : One set of results for every Oracle Web server monitored

Configurable parameters for the test
  1. TEST PERIOD - How often should the test be executed
  2. Host - The host for which the test is to be configured.
  3. Port - The port to which the specified host listens.
  4. homedir – The path to the directory in which the Oracle 9i application server has been installed
Measurements made by the test
Measurement Description Measurement Unit Interpretation

Request rate:

Indicates the rate of requests to the session cache during the last measurement period.

Reqs/Sec

A very high value for this measure indicates that the session cache is handling many requests.

Cache hits:

Indicates the rate of content cache hits.

Conns/Sec

Reading from the cache is less expensive than reading from the database. Therefore, the higher this value, the better. Remember that caching increases the scalability of a web application.

Cache misses:

Indicates the rate of content cache misses.

Conns/Sec