Use of customized SQL query

Use of customized SQL query

Hi,

we like to measure the time a special SQL statement related to an application takes on a oracle database. We like to have an alert when the statement exceeds n seconds.
Is there a way to apply handcrafed SQL statements to an monitor without wiritung an external script which needs database authentification etc...

AppMan 8.1 is our current version.

Best regards
Axel