Identification of Long Running Queries
Trace point SC925 logs queries to II_DBMS_LOG that run longer than n seconds but less than m seconds. For example:
This statement logs all queries that take longer than 5 seconds:
SET TRACE POINT SC925 5
This statement logs all queries that take longer than 5 but less than 10 seconds:
SET TRACE POINT SC925 5 10