LongSqlMonitor

Task Type: Database Monitor
Configurable: Yes
Host Dependent: No
Schedule Dependent: Yes

Description

The LongSqlMonitor monitors the database for active sessions executing sql statements whose execution time exceeds a configurable threshold.

Configuration

The <LongSqlMonitor> may contain one <Default> element, which defines a default threshold. The <Default> element is configured with the following attribute:

Attribute Required Description
THRESHOLD Yes A threshold value expressed in seconds. TCAgent generates an alert when it detects a SQL statement running longer than the specified threshold. The value for this attribute must be a positive integer.

The default threshold may be overridden by using one or more <User> elements, which are configured with the following attributes:

Attribute Required Description
NAME Yes Specifies a username that will be monitored using an individual threshold or will be excluded from monitoring altogether.
THRESHOLD Depends A threshold value expressed in seconds. TCAgent generates an alert when it detects a SQL statement executed by the named user running longer than the specified threshold. This attribute is required when the EXCLUDE attribute is set to "NO" or is omitted.
EXCLUDE No May be used to indicate that the named user is excluded from monitoring. Valid values are "YES" and "NO".

Example

<LongSqlMonitor>
  <Default THRESHOLD="5"/>
  <User NAME="JSMITH" THRESHOLD="10"/>
</LongSqlMonitor>

In this example, TCAgent sends an when any JSMITH session runs a SQL statement that takes longer than 10 minutes to complete, or when any other session runs a SQL statement that takes longer than 5 minutes to complete.

Your Source for Oracle Expertise