ASM空间使用情况
set line 400 pagesize 500
col name for a10
select name,
sector_size,
block_size,
allocation_unit_size,
type,
total_mb,
free_mb,
usable_file_mb
from v$asm_diskgroup;
NAME SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE TYPE TOTAL_MB FREE_MB USABLE_FILE_MB
---------- ----------- ---------- -------------------- ------ ---------- ---------- --------------
CRS 512 4096 1048576 EXTERN 30720 30282 30282
DATA 512 4096 1048576 EXTERN 81920 73538 73538
ARCH 512 4096 1048576 EXTERN 51200 50064 50064