Oracle 11g has a new hint telling data to persist in cache for x number of minutes. The syntax is:

  select /*+ result_cache */ * from test.customer

This could be interesting for tables that do not change much, since any change to the table can invalidate the cache. One simple way would be for a token in the INT file marking if the file changes seldom.

Recommendation: Investigate further. This could though have some unforeseen impacts. I am leaning towards recommending that we instead look at tuning servers for more memory (which also caches) and client side cache.

Tags: Performance Tips

This entry was posted on Monday, February 25th, 2008 at 3:41 pm and is filed under Oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.