Oracle

Home

Connectors directory^[1] Full listing of connectors^[2]

Description

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

database^[3] enterprise^[4] linux^[5] windows^[6]

Target

Typical platform: Oracle Database^[7]

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 on the monitored database:

Metrics

Type	Collected Metrics	Specific Attributes
oracle	`db.server.active_connections` `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.errors{error.type="exchange_deadlocks"}` `db.server.io{db.io.direction="read"}` `db.server.io{db.io.direction="write"}` `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.tables` `db.server.uptime` `db.server.user.commits` `db.server.user.rollbacks`	`db.namespace` `db.server.name` `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.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.system` `oracle.tablespace.name`
table_query	`db.server.queries`	`db.namespace` `db.operation.type` `db.server.name` `db.system` `table.name`

Search Results for {{siteSearch | truncate:'50'}}

No results.

MetricsHub MetricsHub Enterprise 1.2.00

Search Results for {{siteSearch | truncate:'50'}}

MetricsHub
MetricsHub Enterprise 1.2.00