SYS.SET_EVICTION_HEAP_PERCENTAGE

Sets the percentage threshold of Java heap memory usage that triggers a GemFire XD data store to perform LRU eviction on tables that are configured for LRU_HEAP eviction. This procedure executes only on the local GemFire XD data store member.

This procedure sets the percentage threshold for evicting table data from the Java heap for the local GemFire XD data store. When the used heap reaches the percentage, GemFire XD begins to evict rows, using a LRU algorithm, from tables that are configured with LRU_HEAP eviction. Create a Table with Eviction Settings describes the eviction process. The default eviction heap percentage is 80% of the critical heap percentage value.

Syntax

SYS.SET_EVICTION_HEAP_PERCENTAGE (
IN PERCENTAGE REAL NOT NULL
)
PERCENTAGE
The percentage of used heap space that triggers eviction on the local GemFire XD data store.

Example

This command triggers eviction on any GemFire XD member when the local member's heap usage reaches 90%:
call sys.set_eviction_heap_percentage (90);