We have a requirement to monitor blocked sessions on a database but do not have the right metric which can be used.
We did try the blocked processes metric but that is giving the blocked processes count at a point in time, not exactly what we need.
The database team needs an alert to be fired when a database or a database server has a blocked process persisting for more than 15 mins.
Please let me know if there is a metric which can help us achieve this monitoring.