Script to Check ASM Disk Usage Details

_____________________________________________________________________________________________________________________

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

0 comments:

Post a Comment

 

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