Possible to check if ASM disks are evenly balanced or not
Hi
Oracle 19c
While doing datafile online move, I ran into:
ORA-15041: diskgroup "DATA" space exhausted
However, enough space was left (500G)
Then I realized the error was actually pointing something else
Cause: At least one disk in the diskgroup is out of space.
So I had 2 disks in diskgroup DATA. Probably one got full.
I did asm rebalance, and this fixed the issue.
But can I check this with some queries perhaps..?
While checking MOSC note Doc ID 2372651.1
There seems like somehow this output has to come from somewhere, some query perhaps.
Anyway, looking a way to achieve this somehow, since at the moment seems like ASM itself does not rebalance the disks regularly, and I need to know when to run rebalance operation.