SYS.SET_EVICTION_HEAP_PERCENTAGE

Sets the default percentage of heap space that triggers a SQLFire data store to perform LRU eviction on tables that are configured for eviction. This procedure executes only on the local SQLFire data store member

This procedure sets the heap percentage for the local SQLFire data store. You can optionally set the heap percentage for one or more named server groups, or for all data stores, using SYS.SET_EVICTION_HEAP_PERCENTAGE_SG. When the used heap reaches the percentage, SQLFire begins to evict rows, using a LRU algorithm, from tables that are configured for eviction. Create a Table with Eviction Settings describes the eviction process.

Syntax

SYS.SET_EVICTION_HEAP_PERCENTAGE (
IN PERCENTAGE REAL NOT NULL
}
PERCENTAGE
The percentage of used heap space that triggers eviction for all SQLFire data stores.

Example

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