Correct calculation of used and free space of ASM Disk groups
Hello All
We are on oracle 19.26.0.0.0 and our database is running on ODA X10 -L
odacli list-dgstorage is showing as below
But when we run the following query it is showing different numbers
SELECT
name group_name
, sector_size sector_size
, block_size block_size
, allocation_unit_size allocation_unit_size
, state state
, type type
, total_mb/1024 total_gb
, (total_mb/1024) - (free_mb/1024) used_gb
,usable_file_mb/1024 available_gb
,case
when TYPE='HIGH' then ROUND((1- ((free_mb/3)/1024) / ((total_mb/3)/1024))*100, 2)
when TYPE='NORMAL' then ROUND((1- ((free_mb/2)/1024) / ((total_mb/2)/1024))*100, 2)
end as pct_used
FROM v$asm_diskgroup