Script to Check ASM Disk Usage Details

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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;



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

_____________________________________________________________________________________________________________________

0 comments:

Post a comment

 

acehints.com Copyright 2011-20 All Rights Reserved | Site Map | Contact | Disclaimer