Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

Home > Success Center > Database Performance Analyzer (DPA) > List of DPA out-of-the-box Alerts

List of DPA out-of-the-box Alerts

Table of contents

Updated August 24, 2016

Overview

This article provides a quick reference list of DPA out-of-the-box alerts.

Environment

  • DPA

Detail

Alert Category Alert Type Description
Wait Time Total Database Instance Wait Time Total wait time (in seconds) for entire database instance
Total SQL Wait TIme for a Single SQL Total execution time (in seconds) for the specified SQL
Average Wait Time for a Single SSQL Average execution time (in seconds) for the specified SQL
Total SQL Wait Time for Single Wait Wait time (in seconds) on the specified wait
Total SQL Wait Time - Program Execution time (in seconds) on the specified Program
Total SQL Wait Time - Database User Execution time (in seconds) on the specified Database User
Total SQL Wait Time - O/S User

Execution time (in seconds) on the specified O/S User

Total SQL Wait Time - Machine

Execution time (in seconds) on the specified Machine

Total SQL Wait Time - Database Execution time (in seconds) on the specified Database in the Instance
Total SQL Wait Time - Custom for Oracle

Execution time (in seconds) for a combination of factors

Total SQL Wait Time - Custom for SQL Server/Sybase Execution time (in seconds) for a combination of factors
Total SQL Wait Time - Custom for MySQL Execution time (in seconds) for a combination of factors
Total SQL Wait Time - Custom for DB2 Execution time (in seconds) for a combination of factors. The 'Database' field will be ignored when monitoring a single database.
RAC Overhead Wait Time

Wait time (in seconds) for RAC events

Total Blocking Wait Time This Oracle, SQL Server, Sybase and MySQL alert will report the amount of time that sessions waited due to blocking. Applies to wait time as seen on the DPA Blocking tab for Oracle, SQL Server, Sybase and MySQL monitored instances.
Resources Single Resource Metric Evaluates a specified resource metric's values over a period of time.
All Metrics in a Category Evaluates all resource metrics in a specified category over a period of time.
Administrative Database Instance Availability This alert determines if a monitored database instance is available by attempting to connect to the instance from DPA (Returns true if instance is not available).
Database Freespace This SQL Server, Sybase and DB2 alert determines the percent of free space in each database of the instance. For DB2 instances, only database managed tablespaces are evaluated.
Database Instance Parameter Changes This alert determines if any database instance parameter settings have changed.
Tablespace Freespace This Oracle and DB2 alert determines the percent of free space in each tablespace of the monitored database. For Oracle databases, only non-autoextensible online tablespaces are evaluated. For DB2, only database managed tablespaces (DMS) are evaluated.
Transaction Log Freespace This SQL Server, Sybase and DB2 alert determines the percent of free space in the transaction log of each database of the instance.
Oracle PDB Move This alert is triggered when a monitored PDB database instance is moved to or from a CDB container.
Oracle PDB Database Instance Availability This alert determines if a monitored PDB database instance is available by attempting to connect to the instance from DPA (Returns true if instance is not available).
Oracle Alert Log Entries This Oracle (11g and up) alert searches for the specified string in the alert log (from the x$dbgalertext table) and returns all unique matching entries and the count of each entry.
Oracle Long Running Transaction This Oracle alert queries the length of time that active transactions have been running. To limit the result set and reduce DPA Repository space, set the Minimum transaction run time.
Oracle Percent Redo Logs Unarchived This Oracle alert determines the current percentage of unarchived redo logs.
Oracle Redo Log Switching Frequency This Oracle alert will determine the number of log switches that occurred within the last X minutes (X = alert execution frequency). Specify the hours of the day the alert should include or ignore, and specify the time as 'Inclusive' or 'Exclusive' accordingly.
Oracle Session Limit This Oracle alert compares the number of active sessions to the maximum number of sessions as configured in the v$parameter 'sessions' row. The result is returned as a percentage.
Oracle Stale Statistics This Oracle (10g and up) alert will return a list of all tables and indexes that have stale or empty statistics. All tables and indexes meeting this criteria are reported each time this alert is run. To reduce repetitive results, it is recommended to configure this alert with an execution interval of at least one day.
Oracle Archiver Errors This Oracle alert indicates that the archiver process has received an error while trying to archive a redo log or the online log files aren’t being archived. If the problem is not resolved soon, the database will stop executing transactions. This alert is typically triggered when the destination device is out of space to store the redo log file.
Windows Service Not Running - SQL Server This SQL Server (2005 and up) alert runs against the SQL Server monitored instance, and triggers if the specified Windows service is not running.
SQL Server Abnormal Mirroring Status This SQL Server (2005 and up) alert will trigger if the SQL Server mirroring status is anything other than Synchronized.
SQL Server Deadlocks This SQL Server (2008 and later) alert will report the number of deadlocks that occurred on the SQL Server instance.
SQL Server Error Log Alert This SQL Server (2005 and up) alert will report error log entries containing a specified string or pair of strings.
SQL Server Ineffective Statistics This SQL Server (2005 and up) alert detects indexes with ineffective statistics. It uses criteria such as time since last stats update, percent of rows changes, and table size. All indexes meeting this criteria are reported each time this alert is run. To reduce repetitive results, it is recommended to configure this alert with an execution interval of at least one day.
Custom Custom SQL Alert - Single Numeric Return Executes a user-defined SQL statement that will return a single numeric value
Custom SQL Alert - Multiple Numeric Return Executes a user-defined SQL statement that will return one or more name/numeric value pairs
Custom SQL Alert - Single Boolean Return Executes a user-defined SQL statement that will return a single string value ('TRUE' or 'FALSE')
Custom SQL Alert - Single Alert Status Return Executes a user-defined SQL statement that will return a single string value that represents an alert status. Valid values are: NORMAL, INFO, LOW, MEDIUM, HIGH
Custom Procedure Alert - Single Numeric Return Executes a user-defined stored procedure that will return a single numeric value
Custom Procedure Alert - Single Boolean Return Executes a user-defined stored procedure that will return a single string value ('TRUE' or 'FALSE')
Custom Procedure Alert - Single Alert Status Return Executes a user-defined stored procedure that will return a single string value that represents an alert status. Valid values are: NORMAL, INFO, LOW, MEDIUM, HIGH

 

 

 

Last modified
19:20, 23 Aug 2016

Tags

Classifications

Public