Wednesday, August 27, 2014

How to check memory usage detail in solaris

How to check memory usage detail in solaris


$ echo ::memstat |mdb -k


Script to monitor Flash Recovery Area Space

Script to monitor Flash Recovery Area Space


SELECT name,
       ceil(space_limit / 1024 / 1024) SIZE_M,
       ceil(space_used / 1024 / 1024) USED_M,
       ceil(space_reclaimable / 1024 / 1024) RECLAIMABLE_M,
       decode(nvl(space_used, 0),
              0,
              0,
              ceil(((space_used - space_reclaimable) / space_limit) * 100)) PCT_USED
  FROM v$recovery_file_dest
 ORDER BY name
/