WebCache: Large PLSQL Cachable Objects are Showing Size N/A, 0, or -1 in Popular Requests (Doc ID 1550245.1)

Last updated on OCTOBER 17, 2023

Applies to:

Symptoms

When caching mod_plsql requests in webcache it has been see that large payloads (810KB in this case) do not report the size accurately in Popular Requests.
The request is reporting as N/A in Fusion Middleware Control or WebCache Manager.
When exported to the log it shows 0 or -1 depending on whether or not the object is cached in webcache.

The environment this was reproduced in is as follows:
User --http--> WebCache --http--> OHS --mod_plsql--> Database

Where do I find Popular Requests? There are two ways.
1) Through Enterprise Manager Fusion Middleware Control (FMWC)
FMWC -> WebTier -> WebCache (right click) -> Monitoring -> Popular Request
You can then export the entries to a file using the export button. An example of this exported file is below.

2) If FMWC is not used Popular Requests can be accessed though WebCache Manager.
If you do not know what port WebCache Manager is running on check opmnctl status -l
webcache1 | WebCache-admin | xxxx | Alive | xx | xxxxx | 1:06:30 | http_admin:<port>
The user for login will be ias_admin and the password will have been set at configuration or can be set using FMWC.
Once you are in WebCache Manager, one left under Monitoring click Popular Requests.
Use the Export to File button to write the entries to a file.

Here are two examples of what the exported file looks like:

When 100KB is the object limit size in webcache and the object is not cached because it is too large.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.