Memory Status

Submitted by dave on Tue, 11/10/2009 - 18:09

Current Memory Status

-- Comparison of Configured Pools
SELECT 'DB1', 
       V$MEMORY_DYNAMIC_COMPONENTS.* 
  FROM V$MEMORY_DYNAMIC_COMPONENTS@DATABASE1
 WHERE CURRENT_SIZE>0
UNION ALL
SELECT 'DB2', 
       V$MEMORY_DYNAMIC_COMPONENTS.* 
  FROM V$MEMORY_DYNAMIC_COMPONENTS@DATABASE2
 WHERE CURRENT_SIZE>0 ORDER BY 2,1;