Is there a way for a metric extension to upload if it returns an empty set?
In my use case I am selecting all restore points from v$restore_point and storing that as a metric so I can report on all restore points in our environment and their FRA impact. The issue is when the restore point is dropped the select then returns an empty set which does not upload, so mgmt$metric_current is never updated because an upload does not occur. Is there some way to configure the metric extension to upload so mgmt$metric_current is updated to reflect that the restore point no longer exists?