Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ASM disk free space report with more condition

user2017273Feb 4 2016 — edited Feb 4 2016

Hi,

I have query to check ASM free space. I want to add more condition like if free space percentage 90% then should check Free space <100G ,

SELECT name, type, ceil (total_mb/1024) TOTAL_GB , ceil (free_mb/1024) FREE_GB, ROUND((1- (free_mb / total_mb))*100) Percentage_used FROM V$ASM_DISKGROUP
/

NAME                           TYPE     TOTAL_GB    FREE_GB PERCENTAGE_USED
------------------------------ ------ ---------- ---------- ---------------
OCRVOTE                        NORMAL        34         33              2
DATA01                         EXTERN       945        160              83
DATA02                         EXTERN        135        130              10

if ASM_used percentage is > 90 then

should check FREE_GB

If free_GB < 100

then It should provide asm disk space report

Let me know how to accomplish this

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 3 2016

Added on Feb 4 2016

#automatic-storage-management, #performance-availability

6 comments

3,604 views