-- -- 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 /