48.6 CACHE_PURGE_STALE Procedure
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.
Syntax
APEX_UTIL.CACHE_PURGE_STALE (
p_application IN NUMBER);
Parameters
Table 48-6 CACHE_PURGE_STALE Parameters
Parameter | Description |
---|---|
|
The identification number (ID) of the application. |
Example
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;
Parent topic: APEX_UTIL