Show Details of SGA Pools
--
--  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
/

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License