oracle asm 磁盘组信息查询相关sql

COL NAME FORMAT a20;
col path format a50;
select name,path,STATE,free_mb,total_mb from v$asm_disk;
NAME                 PATH                                               STATE       FREE_MB   TOTAL_MB
-------------------- -------------------------------------------------- -------- ---------- ----------
                     /dev/rhdisk22                                      NORMAL            0          0
                     /dev/rhdisk23                                      NORMAL            0          0
                     /dev/rhdisk24                                      NORMAL            0          0
                     /dev/rhdisk19                                      NORMAL            0          0
                     /dev/rhdisk20                                      NORMAL            0          0
                     /dev/rhdisk21                                      NORMAL            0          0
                     /dev/rhdisk26                                      NORMAL            0          0
                     /dev/rhdisk25                                      NORMAL            0          0
OCRVOTE_0002         /dev/rhdisk10                                      NORMAL         4870       5120
OCRVOTE_0003         /dev/rhdisk11                                      NORMAL         4870       5120
OCRVOTE_0004         /dev/rhdisk12                                      NORMAL         4868       5120
ARCH_0000            /dev/rhdisk13                                      NORMAL       392072     614400
REDO01_0000          /dev/rhdisk2                                       NORMAL       102305     102400
REDO02_0000          /dev/rhdisk3                                       NORMAL       102305     102400
DATA_0000            /dev/rhdisk4                                       NORMAL       466740     614400
DATA_0001            /dev/rhdisk5                                       NORMAL       466741     614400
DATA_0002            /dev/rhdisk6                                       NORMAL       466741     614400
DATA_0003            /dev/rhdisk7                                       NORMAL       466741     614400
OCRVOTE_0000         /dev/rhdisk8                                       NORMAL         4868       5120
OCRVOTE_0001         /dev/rhdisk9                                       NORMAL         4868       5120
DATA_0008            /dev/rhdisk15                                      DROPPING     502091     614400
DATA_0009            /dev/rhdisk16                                      DROPPING     502089     614400
DATA_0010            /dev/rhdisk17                                      DROPPING     502090     614400
DATA_0011            /dev/rhdisk18                                      DROPPING     502088     614400

set linesize 1000;
set pagesize 5000;
col name format a15;
col path format a30;
col  failgroup format a20;

select dg.name,d.STATE,d.path, d.failgroup, d.failgroup_type
from v$asm_diskgroup dg, v$asm_disk d
where dg.group_number = d.group_number
order by dg.name, d.path, d.failgroup;

NAME            STATE    PATH                           FAILGROUP            FAILGRO
--------------- -------- ------------------------------ -------------------- -------
ARCH            NORMAL   /dev/rhdisk13                  ARCH_0000            REGULAR
DATA            DROPPING /dev/rhdisk15                  DATA_0008            REGULAR
DATA            DROPPING /dev/rhdisk16                  DATA_0009            REGULAR
DATA            DROPPING /dev/rhdisk17                  DATA_0010            REGULAR
DATA            DROPPING /dev/rhdisk18                  DATA_0011            REGULAR
DATA            NORMAL   /dev/rhdisk4                   DATA_0000            REGULAR
DATA            NORMAL   /dev/rhdisk5                   DATA_0001            REGULAR
DATA            NORMAL   /dev/rhdisk6                   DATA_0002            REGULAR
DATA            NORMAL   /dev/rhdisk7                   DATA_0003            REGULAR
OCRVOTE         NORMAL   /dev/rhdisk10                  OCRVOTE_0002         REGULAR
OCRVOTE         NORMAL   /dev/rhdisk11                  OCRVOTE_0003         REGULAR
OCRVOTE         NORMAL   /dev/rhdisk12                  OCRVOTE_0004         REGULAR
OCRVOTE         NORMAL   /dev/rhdisk8                   OCRVOTE_0000         REGULAR
OCRVOTE         NORMAL   /dev/rhdisk9                   OCRVOTE_0001         REGULAR
REDO01          NORMAL   /dev/rhdisk2                   REDO01_0000          REGULAR
REDO02          NORMAL   /dev/rhdisk3                   REDO02_0000          REGULAR