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; 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
No comments yet