##查看当前磁盘组和磁盘信息
set linesize 300
set pages 1000
col name for a15
col path for a60
select adg.name,adg.TOTAL_MB group_TOTAL_MB,adg.free_mb group_free_mb,ad.path,ad.TOTAL_MB disk_totle_mb,ad.free_mb disk_free_mb from v$asm_diskgroup adg,v$asm_disk ad where adg.GROUP_NUMBER=ad.GROUP_NUMBER;
NAME GROUP_TOTAL_MB GROUP_FREE_MB PATH DISK_TOTLE_MB DISK_FREE_MB
--------------- -------------- ------------- ------------------------------------------------------------ ------------- ------------
ARCH_DG01 2191124 1863341 /dev/rdsk/c12t50060E80103511A0d21s6 547781 0
ARCH_DG01 2191124 1863341 /dev/rdsk/c12t50060E80103511A0d19s6 547781 0
ARCH_DG01 2191124 1863341 /dev/rdsk/c12t50060E80103511A0d20s6 547781 0
ARCH_DG01 2191124 1863341 /dev/rdsk/c12t50060E80103511A0d18s6 547781 0
DATA_DG01 4930029 946612 /dev/rdsk/c12t50060E80103511A0d1s6 547781 0
DATA_DG01 4930029 946612 /dev/rdsk/c12t50060E80103511A0d6s6 547781 0
DATA_DG01 4930029 946612 /dev/rdsk/c12t50060E80103511A0d7s6 547781 0
DATA_DG01 4930029 946612 /dev/rdsk/c12t50060E80103511A0d22s6 547781 0
DATA_DG01 4930029 946612 /dev/rdsk/c12t50060E80103511A0d2s6 547781 0
DATA_DG01 4930029 946612 /dev/rdsk/c12t50060E80103511A0d3s6 547781 0
DATA_DG01 4930029 946612 /dev/rdsk/c12t50060E80103511A0d4s6 547781 0
DATA_DG01 4930029 946612 /dev/rdsk/c12t50060E80103511A0d5s6 547781 0
DATA_DG01 4930029 946612 /dev/rdsk/c12t50060E80103511A0d0s6 547781 0
DATA_DG02 4930029 952264 /dev/rdsk/c12t50060E80103511A0d23s6 547781 0
DATA_DG02 4930029 952264 /dev/rdsk/c12t50060E80103511A0d9s6 547781 0
DATA_DG02 4930029 952264 /dev/rdsk/c12t50060E80103511A0d8s6 547781 0
DATA_DG02 4930029 952264 /dev/rdsk/c12t50060E80103511A0d15s6 547781 0
DATA_DG02 4930029 952264 /dev/rdsk/c12t50060E80103511A0d14s6 547781 0
DATA_DG02 4930029 952264 /dev/rdsk/c12t50060E80103511A0d13s6 547781 0
DATA_DG02 4930029 952264 /dev/rdsk/c12t50060E80103511A0d12s6 547781 0
DATA_DG02 4930029 952264 /dev/rdsk/c12t50060E80103511A0d11s6 547781 0
DATA_DG02 4930029 952264 /dev/rdsk/c12t50060E80103511A0d10s6 547781 0
FLASH_DG01 1095562 273752 /dev/rdsk/c12t50060E80103511A0d16s6 547781 0
FLASH_DG01 1095562 273752 /dev/rdsk/c12t50060E80103511A0d17s6 547781 0