Custom Alert - Abnormal SQL Execution Time - Oracle
This alert will list SQL Statements that have recently executed outside their normal execution time. The previous 14 days are compared when calculating the average execution time for a SQL. The results are reported back in percentage above normal executions time, e.g. if 200 is returned that means the query executed twice as long on average withing the last hour than normal.
Warning: This alert is for Oracle repositories only.
Available Database Instances: All database platforms are supported as this alert executes against the Ignite repository.
To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert with values similar to these:
Alert Name: Abnormal SQL Execution Time
Execution Interval: 1 Hour
Notification Text: The following list of SQL statements have been running longer than normal.
select 'SQL '||sqlhashname||' recently averaged '||round(last_avg,5)||' which is more than twice the historical average of '||round(total_avg,5), 100* last_avg / total_avg
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.