APEX and the Result Cache in Oracle 11gR2 EE
May 11, 2012 Leave a comment
Environment: Oracle database 18.104.22.168 EE, APEX 4.1.1.00.23
I was exploring the Result Cache features of Oracle 11g, when I noticed that APEX is already using it:
SELECT NAME FROM V$RESULT_CACHE_OBJECTS WHERE rownum < 20;
Apparently, the result cache for APEX is not enabled at the table level, but by using the hint /*+ result_cache */ in the SQL queries.
This could be one of the reasons why we see a better performance of APEX on 11g compared to 10g.
However, I now wonder if this requires any performance tuning of the Result Cache initialization parameters of the database? For example, by setting result_cache_max_size to a higher value than the default value (which depends on the memory settings) ? I don’t remember reading anything about this in the APEX documentation, and I also couldn’t find anything relevant on OTN. Did anyone do this kind of tuning?
Note: Result cache is not available on Oracle 11g XE (Express Edition)…