SELECT 'SGA::' || INITCAP(pool) AS METRIC , SUM(bytes) AS VALUE FROM V$SGASTAT
WHERE pool IN ( 'java pool', 'large pool' ) GROUP BY pool
UNION
SELECT 'SGA::Shared Pool', SUM(bytes) FROM V$SGASTAT
WHERE pool = 'shared pool' AND name NOT IN ('library cache', 'dictionary cache', 'free memory', 'sql area')
UNION
SELECT 'SGA::' || INITCAP(name), bytes FROM V$SGASTAT
WHERE pool IS NULL AND name IN ('log_buffer', 'fixed_sga')
UNION
SELECT 'SGA::Buffer_Cache', SUM(bytes) FROM V$SGASTAT
WHERE pool IS NULL AND name IN ('buffer_cache', 'db_block_buffers')
UNION
SELECT 'REDO::Available', count(*) from v$log t where t.status in ('INACTIVE', 'UNUSED')
UNION
SELECT 'USER::Expire password', ROUND(DECODE(SIGN(NVL(u.expiry_date, SYSDATE + 999) - SYSDATE),-1, 0, NVL(u.expiry_date, SYSDATE + 999) - SYSDATE)) exp_passwd_days_before
FROM dba_users u WHERE username = UPPER('{$ORACLE.USER}')
UNION
 SELECT 'FRA::Space Limit', space_limit FROM V$RECOVERY_FILE_DEST
UNION
 SELECT 'FRA::Space Used', space_used FROM V$RECOVERY_FILE_DEST
UNION
 SELECT 'FRA::Space Reclaimable', space_reclaimable FROM V$RECOVERY_FILE_DEST
UNION
 SELECT 'FRA::Number Of Files', number_of_files FROM V$RECOVERY_FILE_DEST
UNION
 SELECT 'FRA::Usable Pct', DECODE(space_limit, 0, 0,(100-(100 *(space_used-space_reclaimable)/ space_limit))) AS VALUE FROM V$RECOVERY_FILE_DEST
UNION
 SELECT 'FRA::Restore Point', COUNT(*) FROM V$RESTORE_POINT;