Displays the values of the dynamically memory pools.

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