Description

It monitors the system statistics like User Commits, User Rollbacks, Table Scan Blocks, Redo Log Space Requests, Cache Blocks Lost, IO Wait Time, 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.user.commits

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThis metric represents the number of user commits performed per second in last two monitoring polls.
    CategoryApplication
    Collector TypeGateway
    Monitor NameOracle System Stats
    Unitpsec

    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.redo.log.space.requests

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionIt represents the active log file is full and Oracle is waiting for disk space to be allocated for the redo log entries.
    CategoryApplication
    Collector TypeGateway
    Monitor NameOracle System Stats
    UnitReq per Sec

    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.user.rollbacks.persec

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThis metric represents the number of times, per second , that users manually issue the ROLLBACK statement or an error occurred during a user's transactions.
    CategoryApplication
    Collector TypeGateway
    Monitor NameOracle System Stats
    Unitpsec

    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.cache.blocks.lost

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThis metric represents the number of global cache blocks lost over the user-defined observation period.
    CategoryApplication
    Collector TypeGateway
    Monitor NameOracle System Stats
    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.table.scan.blocks.persec

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionNumber of blocks received via table scans.
    CategoryApplication
    Collector TypeGateway
    Monitor NameOracle System Stats
    Unitpsec

    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.io.wait.time

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionHow much time the application was blocked, waiting for all I/O operation to complete
    CategoryApplication
    Collector TypeGateway
    Monitor NameOracle System Stats
    Unitms

    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.logons.per.sec

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThis metric represents the number of logons per second during the sample period.
    CategoryApplication
    Collector TypeGateway
    Monitor NameOracle System Stats
    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.db.instance.uptime

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionIt represents db instance uptime since start up.
    CategoryApplication
    Collector TypeGateway
    Monitor NameOracle System Stats
    UnitDays

    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.check.db.alive

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionMonitors connectivity to the database instance.
    CategoryApplication
    Collector TypeGateway
    Monitor NameOracle System Stats
    UnitNULL

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning OperatorNOT_EQUALS_IGNORE_CASEEnds with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with
    Warning ThresholdACTIVE[{"ACTIVE":"0"},{"SUSPENDED":"1"},{"INSTANCE RECOVERY":"2"}]
    Warning Repeat Count11-12
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertYesYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph