--

-- List ASM Diskgroups and Files

--

SET PAUSE ON

SET PAUSE 'Press return to Continue'

SET LINESIZE 300

SET PAGESIZE 60

SELECT

   c.name dname, a.name fname,

   ( b.bytes / ( 1024*1024 ) ) gbyte, b.type ftype

FROM

   v$asm_alias a, v$asm_file b, v$asm_diskgroup c

WHERE

   b.file_number = a.file_number

AND

   b.group_number = c.group_number

ORDER BY

  c.name, a.name

/