Database Query Monitor Alarm

Database Query Monitor Alarm

Hi ,

I am trying to adding database query monitor and checking percent space used attribute. I added query and selected primary key. Succesfully I can see query result but I can not configure alarm because row is continually refreshing and alarm is disappearing.

My query is:

select percent_space_used from v$flash_recovery_area_usage where file_type='ARCHIVED LOG

How can I check space area and generate alarm?

Thanks for helps,
      • Topic Participants

      • Gobi

                New to ADManager Plus?

                  New to ADSelfService Plus?