Monday, June 2, 2014

Script to find dynamic_memory in Oracle 10g

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

No comments:

Post a Comment