--

-- ASM Diskgroups Attached to a Database

--

SET PAUSE ON

SET PAUSE 'Press return to Continue'

SET LINESIZE 300

SET PAGESIZE 60

SELECT

   a.instance_name, a.db_name, b.name dname,

   a.status, a.software_version

FROM

   v$asm_client a, v$asm_diskgroup b

WHERE

   a.group_number = b.group_number

ORDER BY

   a.instance_name, a.db_name, b.name

/