Jump to content
OYE

DISTINCT DATABASE STORAGE USAGE IN ASM

Recommended Posts


Hey Guys,

I am working in a RAC environment and have been struggling to get a perfect query to view ASM Storage usage based on specific and each databases in the ASM. Simply, i want a result that shows a database  and how much size that database is using (in total) in my ASM

I tried out some query out, but they don't return what i want.

My desired outcome looks like the below table

GNAME      DBNAME         MB               GB            #FILES
---------- ---------- -------------- ---------------- ---------------- 
DATAC1     MISU2         5,867,345          5,867         1,245
RECOC1     MISU2         5,901,360          5,763         1,119

Thanks Guys!!!!!
 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×