SYSCS_UTIL.SYSCS_EMPTY_GLOBAL_STATEMENT_CACHE stored procedure
removes as many compiled statements (plans) as possible from the
database-wide statement cache (across all region servers).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
the same operation on a single region server.
This procedure does not return a result.
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.
CallableStatement cs = conn.prepareCall ("CALL SYSCS_UTIL.SYSCS_EMPTY_GLOBAL_STATEMENT_CACHE()"); cs.execute(); cs.close();
splice> CALL SYSCS_UTIL.SYSCS_EMPTY_GLOBAL_STATEMENT_CACHE(); Statement executed.