Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
18 lines (17 sloc) 301 Bytes
set lines 150
set pages 1000
col Diskgroup for a10
col Disk for a60
col "Size (MB)" for 999,999,999
select
g.name "Diskgroup",
d.path "Disk",
d.failgroup "Fail Group",
d.total_mb "Size (MB)"
from
v$asm_diskgroup g,
v$asm_disk d
where
d.GROUP_NUMBER=g.GROUP_NUMBER
order by 1,2
/
You can’t perform that action at this time.