APEX and the Result Cache in Oracle 11gR2 EE

Environment: Oracle database 11.2.0.3 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;

NAME
APEX_040100.WWV_FLOW_MENUS
APEX_040100.WWV_FLOW_WORKSHEET_COLUMNS
APEX_040100.WWV_FLOW_WORKSHEETS
APEX_040100.WWV_FLOW_REGION_REPORT_COLUMN
APEX_040100.WWV_FLOW_STEP_BRANCHES
APEX_040100.WWV_FLOW_STEP_COMPUTATIONS
APEX_040100.WWV_FLOW_JAVASCRIPT_EVENTS
APEX_040100.WWV_FLOW_NATIVE_PLUGINS
APEX_040100.WWV_FLOW_PAGE_DA_EVENTS
APEX_040100.WWV_FLOW_STANDARD_EVENTS
APEX_040100.WWV_FLOW_PLUGIN_EVENTS
APEX_040100.WWV_FLOW_LANG
APEX_040100.WWV_FLOW_LISTS_OF_VALUES$
APEX_040100.WWV_FLOW_FLASH_CHARTS_5
APEX_040100.WWV_FLOW_PLUGIN_ATTR_VALUES
APEX_040100.WWV_FLOW
APEX_040100.APEX_APPLICATION_PAGE_ITEMS
APEX_040100.WWV_FLOW_STEP_ITEM_HELP

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

 

Matthias

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: