Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 408
  • Last Modified:

Disk Group automated script

Hello all,
I want to create a script that show me all of my disk groups and their space usage (Total, Used, Free) all in MB.
Please help me sql gurus...
0
k3vsmith
Asked:
k3vsmith
1 Solution
 
k3vsmithAuthor Commented:
Nevermind, Found this which works for what I need.

SELECT name, free_mb, total_mb, free_mb/total_mb*100 "%" FROM v$asm_diskgroup;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now