My Oracle Support Banner

Script to Report the Percentage of Imbalance in all Mounted Diskgroups- Non Exadata/ODA (Doc ID 367445.1)

Last updated on JUNE 25, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


SQL*Plus script to be run while connected to an ASM instance.  It will report the percentage of imbalance in all mounted diskgroups, and the symmetry of failure groups for any normal or high redundancy diskgroups.  If the imbalance is too high then it would be wise to do a manual rebalance.  It can also be used to track the progress of a long running rebalance.  It is only two select statements so it should be safe to run at any time. 

It runs as is on 10gR2. For 10gR1 there are two lines near the top that must be uncommented.  This will make it run slower as there will be unnecessary disk header reads. 

IMPORTANT: If the diskgroup is very large, and the used space is very low, then use False Disk Group Imbalance Status Resulting In Excessive Paging in Grid Control (Doc ID 1271089.1)


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Script #1
 Script #2
 Sample Output

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.