In the ASM space management section, you can find valuable queries to control Oracle storage.
The queries retrieve data related to Disk Group names, physical disk names, sizes, and [CANDIDATE] disks.
ASM Automatic Storage Management is, in fact, a database designed for disk management through DiskGroups.
The data is balanced and redistributed across all disks in a Disk Group whenever one is added or removed.
This allows for high performance compared to an operating system file system.
In the ASM Space Management section, you can find valuable queries to control Disk Group names, physical disk names, sizes, and [CANDIDATE] disks.
Encountering problems with the queries?
Don’t hesitate to contact us!
With the article “Query to view the remaining time of REBALANCE,” we have the opportunity to see the status of the REBALANCE, the minutes remaining until the balancing of disks in an ASM Disk Group is completed, and the assigned parallelism. When we add or remove a new LUN to Read more…
With the article “Query to View ASM DiskGroup Spaces,” we provide a query to identify ASM Disk Groups and their sizes. Now let’s dive straight into the article regarding the queries to view ASM DiskGroup spaces. The selected fields are: NAME – Name of the ASM Disk Group TOTAL_MB – Read more…
With the article “ASM LUN CANDIDATE Query,” we can identify ASM Disk Groups along with their respective disks composing the DG and their sizes. Moreover, it’s possible to see the disks that compose them along with their sizes. Finally, if present, it’s possible to identify the LUN CANDIDATES, ready to Read more…