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 will no longer be used, thus removing those unusable pages or regions from the cache.

Syntax

APEX_UTIL.CACHE_PURGE_STALE (
    p_application  IN    NUMBER,

Parameters

Table: CACHE_PURGE_STALE Parameters describes the parameters available in the CACHE_PURGE_STALE procedure.

CACHE_PURGE_STALE Parameters

Parameter	Description
`p_application`	The identification number (ID) of the application.