OracleDB

Sensor (Data Collection)

Tracked Configuration

  • Version
  • SID
  • Started At
  • CPU Count
  • Max Sessions
  • DB Block Size

Metrics

  • DB Time per Second
  • Time Waited per Second
  • SQL Execution
  • SQL Parse
  • User Calls Commit Rollbacks
  • Buffer Cache
  • Sessions
  • Tablespace Usage

Health Signatures

Health Description
OracleSessionsUsage Total amount of sessions at maximum
CpuTimeDBTimeRatio Ratio between DB CPU Time and DB Time is low
TablespaceUsage Tablespace space usage is high

Configuration

Oracle Driver Instana can not provide automatic Oracle monitoring for licensing reasons, because the driver jar may not be distributed by anybody except Oracle.

When the agent starts and discovers an OracleDB where the driver has not been supplied, the Instana agent will log this message:

2016-12-12T09:30:28.527+0100 | ERROR | heduler-thread-1 | OracleDB | 86 - com.instana.discovery-oracledb - 1.1.2 | Cannot monitor OracleDB without the driver ojdbc7-12.1.0.2.jar
2016-12-12T09:30:28.527+0100 | ERROR | heduler-thread-1 | OracleDB | 86 - com.instana.discovery-oracledb - 1.1.2 | For license reasons it cannot be provided by Instana and needs to be manually obtained and added to the agent

To add the driver to the agent, add it to this location: <agent_install_dir>/system/com/oracle/jdbc/ojdbc7/12.1.0.2/ojdbc7-12.1.0.2.jar

You can obtain the mentioned driver at http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html

Required DB Permissions

For the sensor to be able to connect to Oracle and monitor the metrics and configuration, the user needs to have read permissions for the following tables:

V$PARAMETER, V$SYSSTAT, V$VERSION, V$SYS_TIME_MODEL, V$SESSION, V$SYSTEM_WAIT_CLASS, V$INSTANCE, DBA_TABLESPACE_USAGE_METRICS, DBA_DATA_FILES

Sensor configuration (local & remote)

Please supply the credentials to the Instana agent in order to monitor OracleDB in it’s Configuration file:

Local:

com.instana.plugin.oracledb:
  password: ''
  user: '' # default 'sys as sysdba'
  port: '' # default '1521'
  databaseSID: '' # default 'orcl'

Remote:

com.instana.plugin.oracledb:
  remote: # we support listing multiple DBs here!
    - host: ''
      port: '' # default '1521'
      user: '' # default is 'sys as sysdba'
      password: ''
      databaseSID: ''
      availabilityZone: '' # default is 'Remote Monitoring'

The configured remote OracleDB instance will then be shown as a separate box in the specified availabilityZone.