Are you after something like this ? select g.name, d.name, d.path from v$asm_diskgroup g, v$asm_disk d where g.group_number = d.group_number / _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Shivaswamy Raghunath Sent: 30 October 2006 00:29 To: oracle-l@xxxxxxxxxxxxx Subject: List disk/disk partition of the diskgroup Hello. I could not find a way to list the disk or disk partition underlying the disk group in any of the ASM views. Can you help me? Thanks, Shiva ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ==============================================================================