RELEASE_ALL_JVM_MEMORY
Forces all sessions to release the memory consumed by their Java Virtual Machines (JVM).
Syntax
RELEASE_ALL_JVM_MEMORY();
Privileges
Must be a superuser.
Example
The following example demonstrates viewing the JVM memory use in all open sessions, then calling RELEASE_ALL_JVM_MEMORY() to release the memory:
=> select user_name,external_memory_kb FROM V_MONITOR.SESSIONS; user_name | external_memory_kb -----------+--------------- dbadmin | 79705 (1 row) => SELECT RELEASE_ALL_JVM_MEMORY(); RELEASE_ALL_JVM_MEMORY ----------------------------------------------------------------------------- Close all JVM sessions command sent. Check v_monitor.sessions for progress. (1 row) => SELECT user_name,external_memory_kb FROM V_MONITOR.SESSIONS; user_name | external_memory_kb -----------+--------------- dbadmin | 0 (1 row)