Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center