SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE

The SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE stored procedure removes as many compiled statements (plans) as possible from the database statement cache. on your current region server.This procedure does not remove statements related to currently executing queries or to activations that are about to be garbage collected, so the cache is not guaranteed to be completely empty after it completes.

The related procedure SYSCS_UTIL.SYSCS_EMPTY_GLOBAL_STATEMENT_CACHE performs the same operation across the entire cluster.

Syntax

SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE()

Results

This procedure does not return a result.

Execute Privileges

If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this function by default. The database owner can grant access to other users.

JDBC Example

CallableStatement cs = conn.prepareCall
  ("CALL SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE()");
  cs.execute();
  cs.close();

SQL Example

splice> CALL SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE();
Statement executed.

See Also