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
Parameter Description

Test period

How often should the test be executed.


The IP address of the target system that is being monitored.


The port to which the specified Host listens.


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.


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.


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