Viewing disk group clients with V$ASM_CLIENT

 How do we see Viewing disk group clients with V$ASM_CLIENT ?

SQL> SELECT dg.name AS diskgroup, SUBSTR(c.instance_name,1,12) AS instance,

2 SUBSTR(c.db_name,1,12) AS dbname, SUBSTR(c.SOFTWARE_VERSION,1,12) AS software,

3 SUBSTR(c.COMPATIBLE_VERSION,1,12) AS compatible

4 FROM V$ASM_DISKGROUP dg, V$ASM_CLIENT c

5 WHERE dg.group_number = c.group_number;

Output

 

DISKGROUP INSTANCE DBNAME SOFTWARE COMPATIBLE

------------------------------ ------------------------------------ ------------------------ --------------

DATA +ASM ERPPROD 11.2.0.2.0 11.2.0.0.0

FRA +ASM ERPPROD 11.2.0.2.0 11.2.0.0.0

REDO1 +ASM ERPPROD 11.2.0.2.0 11.2.0.0.0

REDO2 +ASM ERPPROD 11.2.0.2.0 11.2.0.0.0