Oracle Utilities Application Framework Caching Overview

One of the features of all the versions of the Oracle Utilities Application Framework is its implementation of caching to improve performance.
The idea is simple enough, load data or function into a faster media (e.g. memory) to minimize calls for the data or function on slower media.
Caches are typically in a number of places in an architecture and this is the case for the Oracle Utilities Application Framework based products.

Here is a summary of the various caches and their typical usage in the Oracle Utilities Application Framework:

  • Database Level "Most Used Data" Cache - When data is loaded or maniplated by SQL it is loaded into a memory cache from the database data files. It will remain in this cache until the cache needs to make room or after a certain amount of time (to prevent the data becoming "stale"). This cache is automatic and maintained by the Database Management System. There are commands to check the cache contents and even manage the cache manually. Check with the database documentation for details.

  • Database level table cache - it is possible to load common "static" data into memory at database startup. Effectively this makes the data memory resident and can be used for high traffic static tables if required. Some DBA's call this "pinning" tables into memory. The database management system manages this information for you but you still have to tell it which data to cache (you usually cache static reference data not transaction data). Check with your database documentation to understand details of commands.

  • SQL Cache - When SQL is executed, the SQL statement is cached for the database management system to reuse the statement for future executions. It may be removed from cache on a least reused basis when necessary. In the case of the Framework, we also have a cache of SQL statements within the framework (controlled by spl.runtime.cobol.sql.cache.maxTotalEntries in

  • Data Cache on Web Application Server - Common static data, such as metadata, is cached on the Web Application Server. This saves calls to the Business Objects and Database for common reference data. The contents of the cache are controlled via metadata. The cache itself can be controlled using the flush jsp's or JMX client (in OUAF 4). This is controlled using the fieldValuesAge parameter in the web.xml for the Web Application Server.

  • Browser Cache - As part of the HTTP 1.1 protocol, an expiry date is placed on all objects that are sent to the browser from the Web Application Server. This is commonly used for HTML and graphics files to keep thm on local cache on the client. New versions of screens and graphics are only transmitted when they expire. This is controlled using the maxAge (text) and maxAageI (images) parameters in the web.xml for the Web Application Server.

Caching is quite important and most of the caches listed here are on by default in the default installation for the product. In development environments, some developers choose to turn off caching to see the extent of changes instantly but most sites tend to limit the number of development setups so the majority of environments are utilizing caching of data.

While you can tweak the cache settings, most sites use the ones provided as default with the installation of the product with no issue.


It's quite hard to find a good post. And It seems like I am have best of luck to came here.

Posted by Żaluzje on November 05, 2010 at 07:32 PM EST #

Hey Every one how are you doing. hope you are haveing a wonderful day

Posted by Fantastic007 on December 27, 2010 at 01:28 AM EST #

Took me moment toward explore every single one of the commentary, except I in reality loved the commentary. It proved being really cooperative to me plus I am optimistic to every one of the commenters here! It’s in general kind whenever you can not just be informed, but in adding entertained! I am constructive you had pleasant writing this write-up.

Posted by backpacks for laptops on December 31, 2010 at 02:10 AM EST #

I added your blog to bookmarks. And i’ll read your articles more often! Before this, it would be possible for the government to arrest you just based on whatever you were saying, if they didn't like it.

Posted by generic pills online on January 25, 2011 at 09:06 PM EST #

I've got a little blog and I was wondering if I can I use some of the information from this post if I provide a link back to your site? If you would rather not, that's okay, but this was a good post.

Posted by Alison Ruffin on February 03, 2011 at 08:40 AM EST #

Cant get enough of this blog. Your opinion and facts truly let people know what its all about.

Posted by Hans Corp on February 04, 2011 at 10:13 AM EST #

When I stumble upon a great blog post I do one of three thing:1.Share it with the close it in all my popular social sharing sites.3.Be sure to come back to the website where I read the article.After reading this article I’m really concidering doing all of them.

Posted by April Landers on March 13, 2011 at 12:02 PM EST #

Unfortunately,I couldn't see the image for this post. It seemed like the HTML code was mistyped.

Posted by Wilson Reid on March 14, 2011 at 03:43 AM EST #

Post a Comment:
  • HTML Syntax: NOT allowed

Anthony Shorten
Hi, I am Anthony Shorten, I am the Principal Product Manager for the Oracle Utilities Application Framework. I have been working for over 20+ years in the IT Business and am the author of many a technical whitepaper, manual and training material. I am one of the product managers working on strategy and designs for the next generation of the technology used for the Utilities and Tax markets. This blog is provided to announce new features, document tips and techniques and also outline features of the Oracle Utilities Application Framework based products. These products include Oracle Utilities Customer Care and Billing, Oracle Utilities Meter Data Management, Oracle Utilities Mobile Workforce Management and Oracle Public Service Revenue Management. I am the product manager for the Management Pack for these products.


« July 2016