WASH MEMORY FRAGMENTATION

Description

When a memory allocation fails due to memory fragmentation, the system actively clears the memory fragmentation and retries. You can also use the ALTER SYSTEM WASH MEMORY FRAGMENTATION statement to manually clear memory fragmentation. This statement releases all idle blocks on the server.

Privilege requirements

Only the root user can execute the ALTER SYSTEM WASH MEMORY FRAGMENTATION statement.

Syntax

ALTER SYSTEM WASH MEMORY FRAGMENTATION server;

server_or_zone：
    SERVER [=] 'ip:port'

Parameters

Parameter	Description
server	Specifies the scope of the cleanup.
ip:port	Specifies the IP address and RPC port number of the seekdb instance to be cleaned.

Examples

Clear memory fragmentation on the seekdb instance.

ALTER SYSTEM WASH MEMORY FRAGMENTATION SERVER = '10.10.10.1:2882';