Is there an alarm for a long running SQL Server or Oracle query (4294922)

Is there a rule to alarm for a long running Oracle or SQL Server query, for example if the query exceeds 30 mins then alert? 

There is no specific alarm for long running queries however beginning with the 5.9.7.10 SQL Server and Oracle cartridges, the following rules & alarms have been added to alert on long running sessions.

• DBSS - Long Running Session
• DBO - Long Running Session

This alarm is disabled by default and it requires SQL PI to be enabled.

Please see KB article 4227479 for more details on these new rules.