Script to Check Disk group Freespace & Mount Status

advertisements

_____________________________________________________________________________________________________________________

SQL Script

set pages 1000 lines 120
col NAME for a16
select GROUP_NUMBER DG#, name, ALLOCATION_UNIT_SIZE AU_SZ, STATE,
TYPE, TOTAL_MB, FREE_MB, OFFLINE_DISKS from v$asm_diskgroup; 

Sample Output

SQL> set pages 40000 lines 120
col NAME for a15
select GROUP_NUMBER DG#, name, ALLOCATION_UNIT_SIZE AU_SZ, STATE,
TYPE, TOTAL_MB, FREE_MB, OFFLINE_DISKS from v$asm_diskgroup; 

       DG# NAME                 AU_SZ STATE       TYPE     TOTAL_MB    FREE_MB OFFLINE_DISKS
---------- --------------- ---------- ----------- ------ ---------- ---------- -------------
         1 DATA               4194304 CONNECTED   HIGH    254091264  195057868             0
         2 INDEX              4194304 MOUNTED     NORMAL    4845120    4723180             0
         3 RECO               4194304 CONNECTED   HIGH    380954112  341118252             0

_____________________________________________________________________________________________________________________

Website Stats