--

--  Show details of SGA pools.

--

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET PAGESIZE 60

COLUMN name  FORMAT A30

COLUMN value FORMAT A20

SELECT name,

value

FROM   v$parameter

WHERE  name like '%_pool%'

ORDER BY name

/