Description

It monitors the sessions like active sessions, inactive sessions, session waits, session cpu usage, session limit usage and it works for Oracle 11g database version onwards. It is applicable on all the on-premise Oracle databases.

Prerequisites

The database you want to monitor should connect from the Gateway. Gateway Management profile should be added to the device. Database type credentials should be added against the device in the portal. While applying the template, the database port, SID or Service Name, connection timeout need to be specified.

Metric Parameters

Metric Parameters
ParameterDescription
Frequency
  • Frequency is the interval in which you want to probe and collect metric data from the target device/resource
  • Frequency is defined in minutes (min).
  • Warning ThresholdIf the metric value satisfies the condition defined along with Warning Threshold value, then a notification is sent to the user.
    Critical ThresholdIf the metric value satisfies the condition defined along with Critical Threshold value, then a notification is sent to the user.
    AlertThe alert value can be set to either Yes or No. If it is Yes, then an alert message is sent to the user.

    Metrics

    oracle.session.cpu_used

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionIt monitors the session CPU usage in seconds.
    CategoryApplication
    Collector TypeGateway
    Monitor NameOracle Sessions
    Units

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    oracle.active.sessions

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionIt monitors the active sessions
    CategoryApplication
    Collector TypeGateway
    Monitor NameOracle Sessions
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    oracle.inactive.sessions

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionIt monitors the inactive sessions
    CategoryApplication
    Collector TypeGateway
    Monitor NameOracle Sessions
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    oracle.session.limit.usage

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionIt monitors the sessions utilization.
    CategoryApplication
    Collector TypeGateway
    Monitor NameOracle Sessions
    Unit%

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    oracle.session.waits

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionIt monitors the session waits.
    CategoryApplication
    Collector TypeGateway
    Monitor NameOracle Sessions
    Units

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph