Type to search.

Oracle sysmetric metricset

Serverless Beta

Elastic Cloud Serverless projects are autoscaled environments, fully managed by Elastic and available on Elastic Cloud.

Availability

  • Beta

    This functionality is in beta and is not ready for production usage. For beta features, the design and code is less mature than official GA features and is being provided as-is with no warranties. Beta features are not subject to the support SLA of official GA features. Specific Support terms apply.

Serverless interfaces and procedures might differ from classic Elastic Stack deployments.

Stack Beta

The Elastic Stack includes Elastic's core products such as Elasticsearch, Kibana, Logstash, and Beats.

Availability

  • Beta

    This functionality is in beta and is not ready for production usage. For beta features, the design and code is less mature than official GA features and is being provided as-is with no warranties. Beta features are not subject to the support SLA of official GA features. Specific Support terms apply.

Unless stated otherwise on the page, this functionality is available when your Elastic Stack is deployed on Elastic Cloud Hosted, Elastic Cloud Enterprise, Elastic Cloud on Kubernetes, and self-managed environments.

This documentation corresponds to the latest patch available for each minor version. If you're not using the latest patch, check the release notes for changes.

Warning

This functionality is in beta and is subject to change. The design and code is less mature than official GA features and is being provided as-is with no warranties. Beta features are not subject to the support SLA of official GA features.

sysmetric Metricset includes the system metric values captured for the most current time interval from Oracle System View.

This metricset dynamically filters metrics based on given input patterns. These patterns can be keywords or regular expressions. The sysmetric metricset uses the OR operator when forming the SQL query internally. Refer here for more details. V$SYSMETRIC table provides different metrics for a short duration (15 seconds, GROUP_ID 3) and a long duration (60 seconds, GROUP_ID 2). This metricset collects metrics which have GROUP_ID 2 i.e. the metrics that are queried for long-duration for DBAs to use the data for historical analysis.

Note: As the value of the metrics queried for long-duration in the V$SYSMETRIC table is updated every 60 seconds, it is recommended for the users to set the collection period in the configuration for sysmetric metricset as greater than or equal to 60 seconds so as to avoid duplication of the metrics in the ingested events.

Required database access

To ensure that the module has access to the appropriate metrics, the module requires that you configure a user with access to the following tables:

  • V$SYSMETRIC

Example event

Text 
{
  "@timestamp": "2022-05-27T02:18:55.112Z",
  "event": {
    "dataset": "oracle.sysmetric",
    "module": "oracle",
    "duration": 408974115
  },
  "metricset": {
    "name": "sysmetric",
    "period": 60000
  },
  "oracle": {
    "sysmetric": {
      "metrics": {
        "physical_write_total_bytes_per_sec": 15323.3127812031,
        "total_table_scans_per_txn": 40,
        "physical_read_total_bytes_per_sec": 40680.153307782,
        "total_pga_allocated": 2.364416e+08
      }
    }
  },
  "service": {
    "address": "oracle://localhost:1521/ORCLCDB.localdomain",
    "type": "oracle"
  }
}

Fields

For a description of each field in the metricset, see the exported fields section.

Here is an example document generated by this metricset:

JSON 
{
    "@timestamp": "2022-05-27T02:18:55.112Z",
    "event": {
        "dataset": "oracle.sysmetric",
        "module": "oracle",
        "duration": 408974115
    },
    "metricset": {
        "name": "sysmetric",
        "period": 60000
    },
    "oracle": {
        "sysmetric": {
            "physical_write_total_bytes_per_sec": 15323.3127812031,
            "total_table_scans_per_txn": 40,
            "physical_read_total_bytes_per_sec": 40680.153307782,
            "total_pga_allocated": 2.364416e+08
        }
    },
    "service": {
        "address": "oracle://localhost:1521/ORCLCDB.localdomain",
        "type": "oracle"
    }
}