-- -----------------------------------------------------------------------------------
-- File Name    : dynamic_memory.sql
-- Author       : DBA Learning Hub
-- Description  : Displays the values of the dynamically memory pools.
-- Requirements : Access to the V$ views.
-- Call Syntax  : @dynamic_memory
-- Last Modified: 15/07/2025
-- -----------------------------------------------------------------------------------

COLUMN name  FORMAT A40
COLUMN value FORMAT A40

SELECT name,
       value
FROM   v$parameter
WHERE  SUBSTR(name, 1, 1) = '_'
ORDER BY name;

COLUMN FORMAT DEFAULT
