Oracle

Description

Monitors performance and operational metrics for an Oracle database server, version 12c or higher.

database linux windows

Enterprise Connector

This connector requires the Enterprise edition of MetricsHub.

Target

Typical platform: Oracle Database

Operating systems: Microsoft Windows, Linux

Prerequisites

Leverages: Oracle Database

Technology and protocols: SQL/JDBC

Examples

CLI

metricshub HOSTNAME -t win -c +Oracle --jdbc -u USER --jdbc-url URL

metricshub.yaml

resourceGroups:
  <RESOURCE_GROUP>:
    resources:
      <HOSTNAME-ID>:
        attributes:
          host.name: <HOSTNAME> # Change with actual host name
          host.type: win
        connectors: [ +Oracle ] # Optional, to load only this connector
        protocols:
          jdbc:
            port: <PORT>
            database: <DB_NAME>
            type: <type>
            url: <URL>
            username: <USERNAME> # Change with actual credentials
            password: <PASSWORD> # Encrypted using metricshub-encrypt

Connector Activation Criteria

The Oracle connector will be automatically activated, and its status will be reported as OK if all the below criteria are met:

• The SQL query below succeeds:
  • Query: SELECT 1 AS is_oracle FROM v$version WHERE lower(banner) LIKE 'oracle%'
  • Result contains: 1 (regex)

Metrics

Type	Collected Metrics	Specific Attributes
oracle	db.server.cache.operations{db.io.direction="read", db.cache.state="hit", db.cache.type="buffer_cache"} db.server.cache.operations{db.io.direction="read", db.cache.state="hit", db.cache.type="library_cache"} db.server.cache.operations{db.io.direction="read", db.cache.state="miss", db.cache.type="buffer_cache"} db.server.cache.operations{db.io.direction="read", db.cache.state="miss", db.cache.type="library_cache"} db.server.cache.operations{db.io.direction="read_sort", db.cache.state="hit"} db.server.cache.operations{db.io.direction="read_sort", db.cache.state="miss"} db.server.cache.queries db.server.cpu.time db.server.current_connections{db.connection.state="active"} db.server.errors{error.type="exchange_deadlocks"} db.server.logons db.server.oracle.cache.io{db.cache.type="global_cache", db.io.direction="read_consistent"} db.server.oracle.cache.memory.limit{db.cache.type="shared_pool"} db.server.oracle.cache.memory.usage{db.memory.state="free", db.cache.type="shared_pool"} db.server.oracle.cache.memory.usage{db.memory.state="used", db.cache.type="shared_pool"} db.server.oracle.enqueue_timeouts db.server.oracle.hard_parses db.server.oracle.long_table_scans db.server.oracle.memory.limit{db.memory.type="pga"} db.server.oracle.memory.usage{db.memory.type="pga", db.memory.state="free"} db.server.oracle.memory.usage{db.memory.type="pga", db.memory.state="used"} db.server.oracle.sub_cache.buffers{db.sub_cache.name="default" db.cache.type="buffer_cache"} db.server.oracle.sub_cache.size{db.sub_cache.name="default" db.cache.type="buffer_cache"} db.server.storage.io{db.io.direction="read"} db.server.storage.io{db.io.direction="write"} db.server.tables db.server.uptime db.server.user.commits db.server.user.rollbacks	db.namespace db.server.name db.server.port db.system db.version id
oracle_resource	db.server.oracle.resource.limit{limit_type="hard"} db.server.oracle.resource.limit{limit_type="soft"} db.server.oracle.resource.usage	db.namespace db.server.name db.server.port db.system oracle.resource.name
oracle_tablespace	db.server.oracle.tablespace.limit db.server.oracle.tablespace.usage{db.space.state="free"} db.server.oracle.tablespace.usage{db.space.state="used"}	db.namespace db.server.name db.server.port db.system oracle.tablespace.name
table_query	db.server.queries	db.namespace db.operation.type db.server.name db.server.port db.system table.name