Query to View ASM DiskGroup Spaces

Published by Alessandro Caredda on 5 March 20195 March 2019

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 – Total size of the ASM Disk Group FREE_MB – Free space size of the ASM Disk Group PERC_USED – Percentage of space used by the ASM Disk Group

The information is retrieved from the V$ASM_DISKGROUP table.

col name for a25
set lines 200
select name, total_mb, free_mb,
100 - ROUND(100 * free_mb / decode(nvl(total_mb,0),0,1,total_mb)) as perc_used
from V$asm_diskgroup;

Stay tuned! Non solo Query spazi DiskGroup ASM

To view my guides on CRS Commands click here!
At this LINK, instead, you’ll find the SQL queries.

Stay updated on our activities by joining our community (make sure to like our pages, let’s connect, and stay updated on each of our new guides!):
Facebook
Youtube
Linkedin

For those who haven’t done so yet, we recommend saving this site among your bookmarks, so you’ll always have our solutions to the most common database problems at your fingertips, especially Oracle databases.

Thank you for reading this article; we hope it was helpful to you! Additionally, we suggest bookmarking this site to find our guides more quickly, which we remind you are completely open and public.

Thanks to our “open-source” mentality, we strongly believe that knowledge should be shared to make it always accessible.

As Linus Torvalds has always explained, sharing represents progress and technological advancement, and his Linux operating system is a shining example of this!

• Query to view the remaining time of REBALANCE
• Query to View ASM DiskGroup Spaces
• ASM LUN CANDIDATE Query