This procedure deletes all cached pages and regions for a specified application that have passed the defined active time period. When you cache a page or region, you specify an active time period (or Cache Timeout). Once that period has passed, the cache is no longer used, thus removing those unusable pages or regions from the cache.
APEX_UTIL.CACHE_PURGE_STALE ( p_application IN NUMBER);
Table 28-5 CACHE_PURGE_STALE Parameters
The identification number (ID) of the application.
The following example demonstrates how to use the CACHE_PURGE_STALE procedure to purge all the stale pages and regions in the application currently executing.
BEGIN APEX_UTIL.CACHE_PURGE_STALE(p_application => :APP_ID); END;