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.
Host	The IP address of the target system that is being monitored.
Port	The port to which the specified Host listens.
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