Empties the system cache, or the given cache ID.

Syntax


CLEAR CACHE [ cacheID ] ;

Arguments

  • cacheID: The ID of the cache from the SYS.SYSCACHEDRESULTSET table. If this value is omitted, all cached data will be emptied.

Examples

CALL CACHE 8722;
--empties cache 8722