Discos candidatos ASM

--Discos candidatos

set lines 200

set pagesize 2000

col PATH format a100

select path,os_mb/1024,header_Status from v$asm_Disk where header_Status!='MEMBER';

 

--Que discos se tienen

set lines200

col PATH format a20

SELECT v.name "Group Name",

         a.group_number "Group",

         a.disk_number "Disk" ,

         a.header_status "Header",

         a.mode_status "Mode" ,

         a.total_mb "Total MB" ,

         a.free_mb "Free MB",

         a.name "Disk Name" ,

         a.path "Path"

  FROM v$asm_disk a,v$asm_diskgroup v

  where v.group_number=a.group_number

  ORDER BY v.name ,

           a.path;