[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 406
  • 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

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

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