RE: List disk/disk partition of the diskgroup

  • From: "Lawie, Duncan" <duncan.lawie@xxxxxxxxxxxxxxxxx>
  • To: "'shivaswamykr@xxxxxxxxx'" <shivaswamykr@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 30 Oct 2006 10:54:11 -0000

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
==============================================================================

Other related posts: