Saturday, September 24, 2016

Script to check the ASM Disks and Diskgroup SIZE details(Total / Free ) & status of the disks and location

 set pagesize 250 linesize 250 lines 250
  SET ECHO        OFF
 SET FEEDBACK    6
  SET HEADING     ON
 SET LINESIZE    180
 SET PAGESIZE    50000
SET TERMOUT     ON
SET TIMING      OFF
  SET TRIMOUT     ON
  SET TRIMSPOOL   ON
  SET VERIFY      OFF
  CLEAR COLUMNS
 columns cleared
  CLEAR BREAKS
 breaks cleared
  CLEAR COMPUTES
 computes cleared

  COLUMN disk_group_name        FORMAT a25           HEAD 'Disk Group Name'
   COLUMN disk_file_path         FORMAT a20           HEAD 'Path'
   COLUMN disk_file_name         FORMAT a20           HEAD 'File Name'
   COLUMN disk_file_fail_group   FORMAT a20           HEAD 'Fail Group'
   COLUMN total_mb               FORMAT 999,999,999   HEAD 'File Size (MB)'
   COLUMN used_mb                FORMAT 999,999,999   HEAD 'Used Size (MB)'
   COLUMN pct_used               FORMAT 999.99        HEAD 'Pct. Used'
 
  BREAK ON report ON disk_group_name SKIP 1
 COMPUTE sum LABEL ""              OF total_mb used_mb ON disk_group_name
 COMPUTE sum LABEL "Grand Total: " OF total_mb used_mb ON report

  SELECT  NVL(a.name, '[CANDIDATE]')    disk_group_name
    , b.path   disk_file_path
    , b.name    disk_file_name
    , b.failgroup   disk_file_fail_group
   , b.total_mb  total_mb,
  (b.total_mb - b.free_mb)   used_mb
  FROM
   v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number)
  ORDER BY
    b.failgroup   ;



No comments:

Post a Comment