Script to Check ASM Disk Usage Details

advertisements

_____________________________________________________________________________________________________________________

This script provides you ASM disk usage details for the ASM database. 

SQL Query

set lines 250 
set pages 9999 
column path format a50 
select  path, group_number group_#, disk_number disk_#, 
 mount_status,  header_status, state, total_mb, free_mb 
from  v$asm_disk 
order by group_number;

advertisements

 

Output

PATH                                                  GROUP_#     DISK_# MOUNT_S HEADER_STATU STATE      TOTAL_MB    FREE_MB
-------------------------------------------------- ---------- ---------- ------- ------------ -------- ---------- ----------
o/xx.xxx.x.xx;xx.xxx.x.xx/DATA_08                           1         64 CACHED  MEMBER       NORMAL      4479008     917040
o/xx.xxx.x.xx;xx.xxx.x.xx/DATA_06                           1         65 CACHED  MEMBER       NORMAL      4479008     917108
o/xx.xxx.x.xx;xx.xxx.x.xx/DATA_09                           1         66 CACHED  MEMBER       NORMAL      4479008     917392
o/xx.xxx.x.xx;xx.xxx.x.xx/DATA_05                           1         67 CACHED  MEMBER       NORMAL      4479008     917168
o/xx.xxx.x.xx;xx.xxx.x.xx/DATA_02                           1         68 CACHED  MEMBER       NORMAL      4479008     917236
o/xx.xxx.x.xx;xx.xxx.x.xx/DATA_00                           1         69 CACHED  MEMBER       NORMAL      4479008     917372

_____________________________________________________________________________________________________________________

Website Stats