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