Oracle Content Cache Test

To improve performance of PL/SQL web applications, you can leverage the caching feature provided by the PL/SQL Gateway. This feature allows caching of PL/SQL procedure Web content in the middle-tier. Subsequent requests for the content may be retrieved from the cache, with or without validation from the database, thereby decreasing the database workload.

This test reports the performance metrics pertaining to the mod_plsql gateway's content 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 content cache during the last measurement period.

Reqs/Sec

A very high value for this measure indicates that the content 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 directly 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