Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
22 lines (21 sloc) 405 Bytes
set lines 250
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.state "State",
d.mount_status "Mount",
d.mode_status "Mode",
d.total_mb "Size (MB)",
d.SECTOR_SIZE "Sector Size"
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.