查看ASM 使用率

有两种方法：


1.查看v$asm_diskgroup视图


SQL> select group_number,name,total_mb,free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME                             TOTAL_MB    FREE_MB
------------ ------------------------------ ---------- ----------
           1 DATA                                 5114       2685


2.进入asmcmd查看

rac2:oracle:rac2 > export ORACLE_SID=+ASM2
rac2:oracle:rac2 > asmcmd

ASMCMD> lsdg
State    Type    Rebal  Unbal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Name
MOUNTED  EXTERN  N      N         512   4096  1048576      5114     2685                0            2685              0  DATA/