USABLE_FILE_MB is showing negative values in V$ASM_DISK View
USABLE_FILE_MB in v$asm_diskgroup can be negative for a number of reasons. The most common reason is that the disk group does not have enough free space to meet the redundancy requirements of its files. For example, if a disk group is configured with NORMAL redundancy, then each file in the disk group must have two […]