Shell Script for ASM Recovery File Dest Usage.

 Hi All,

I have 10 Database Instances on One Node of the Cluster and storage we are using is ASM. I am looking for a Shell Script to monitor the Usage of amount of allocated memory to an instance.

I am using this sql to monitor usage. I wrote my own shell script to monitor it automatically. But am still looking if somebody in the community have better ideas or shell script to monitor ASM Recovery File Dest Usage per Instance.

SELECT name

,       ceil( space_limit / 1024 / 1024) SIZE_M

,       ceil( space_used  / 1024 / 1024) USED_M

,       decode( nvl( space_used, 0),

        0, 0

        , ceil ( ( space_used / space_limit) * 100) ) PCT_USED