Quite a good script which provides a lot of information in one go clear columns set wrap off set lines 200 set pages 999 col "Group" form 999 col "Group Name" form a25 col "Disk Name" form a30 col "State" form a15 col "Type" form a7 prompt prompt ASM Disk Groups prompt =============== select group_number "Group" , name "Group Name" , state "State" , type "Type" , total_mb/1024 "Total GB" , free_mb/1024 "Free GB" from v$asm_diskgroup / prompt prompt ASM Disks prompt ========= col "Group" form 999 col "Disk" form 999 col "Header" form a9 col "Mode" form a8 col "Redundancy" form a10 col "Failure Group" form a30 col "Path" form a16 select group_number "Group" , disk_number "Disk" , header_status "Header" , mode_status "Mode" , state "State" , redundancy "Redundancy" , total_mb "Total MB" , free_mb "Free MB" , name "Disk Name" , failgroup "Failure Group" , path "Path" from v$asm_disk order by group_number , disk_number / prompt prompt Instances currently accessing these diskgroups prompt ============================================== col "Instance" form a8 select c.group_number "Group" , g.name "Group Name" , c.instance_name "Instance" from v$asm_client c , v$asm_diskgroup g where g.group_number=c.group_number / prompt prompt Current ASM disk operations prompt =========================== select * from v$asm_operation / clear columns -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Johan Eriksson Sent: Monday, October 30, 2006 9:20 AM To: shivaswamykr@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: List disk/disk partition of the diskgroup Hi Try this: $ /etc/init.d/oracleasm Usage: /etc/init.d/oracleasm {start|stop|restart|enable|disable|configure|createdisk|deletedisk|query disk|listdisks|scandisks|status} /johan On 10/30/06, Shivaswamy Raghunath <shivaswamykr@xxxxxxxxx> wrote: > 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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l