Table Locks

[prem]

Hi,


I would like to send an alert message to a client when a data row is locked for more than a certain period of time. For this can I write triggers on the system tables. If so on which table should I write a trigger to retrieve the table lock information. Are there any implications on writing triggers on the system tables.

The alert message should be sent automatically in the sense, can I write an alert and signal it from a trigger written on some system table where the lock information is available?


Any thoughts here...

thanks