ORA_STMT_LONGRUNNING

Statement running for time > value (seconds) rule

Alert Message

Statement (sid=@sid@, user=@username@) has been running for @elapsed_time_s@ seconds (start=@START_TIME@).

Detail View

Current Executing Stmts

Default Rule Properties

Severity 20
Event Type SET / RESET
Refresh 30 seconds
Occurrence Window 1 / 1
Enabled Yes
Attributes None

Source Collection

CURRENTSTMT