監視 OracleDB

本端

com.instana.plugin.oracledb:
  user: '<ORCL_USER>'   # default is 'sys as sysdba'
  password: '<ORCL_PASSWORD>'
  host: '<ORCL_HOST>'   # default is 127.0.0.1
  port: '<ORCL_PORT>'   # default is 1521
  databaseSID: '<ORCL_DB_SID>' # taken from process args or 'orcl' as default
  poll_rate: 1

輪詢率定義感應器輪詢 OracleDB 度量的頻率 (以秒為單位)。 預設值為 1 秒。

監視多個本端實例

若要監視多個本端實例，您必須在代理程式配置檔中使用下列配置:

• user 和 password: 在所有資料庫中建立一個具有密碼的使用者 (預設使用者為 sys as sysdba)。
• databaseSID: 不要指定它。 代理程式 自動探索 每一個處理程序的代理程式。
• host: 在 IP 位址上無法呼叫到實例之前，請不要指定它。
• port: 對所有資料庫使用相同的指定埠或預設 1521 。 如果您使用不同的埠，請參閱 主機代理程式配置指示。
• poll_rate: 指定輪詢率。 預設值為 1 秒。

附註: 將資料庫 SID 新增至代理程式配置檔時，該值會用於所有實例。

請參閱下列範例：

com.instana.plugin.oracledb:
  user: 'instana'
  password: 'passw0rd'
  port: '1521'

請參閱下列具有不同埠的範例。 每一個實例都會在 MY_ORACLE_PORT 環境變數中定義其埠。

com.instana.plugin.oracledb:
  user: 'instana'
  password: 'passw0rd'
  port:
    configuration_from:
      type: env
      env_name: MY_ORACLE_PORT
      default_value: 1521

遠端

com.instana.plugin.oracledb:
  remote: # we support listing multiple DBs here!
    - host: '<ORCL_HOST_1>'
      port: '<ORCL_PORT>'
      user: '<ORCL_USER>' # default is 'sys as sysdba'
      password: '<ORCL_PASSWORD>'
      databaseSID: '<ORCL_DB_SID>' # either databaseSID or databaseServiceName is allowed
      databaseServiceName: '<ORCL_DB_SERVICE_NAME>'
      availabilityZone: 'Remote Monitoring'
      poll_rate: 20
    - host: '<ORCL_HOST_2>'
      port: '<ORCL_PORT>'
      user: '<ORCL_USER>' # default is 'sys as sysdba'
      password: '<ORCL_PASSWORD>'
      databaseSID: '<INSERT_DB_SID>' # either databaseSID or databaseServiceName is allowed
      databaseServiceName: '<ORCL_DB_SERVICE_NAME>'
      availabilityZone: 'Remote Monitoring'
      poll_rate: 5

輪詢率定義感應器輪詢 OracleDB 度量的頻率 (以秒為單位)。 預設值: 1 秒。

在指定的 availabilityZone中，已配置的遠端 OracleDB 實例會顯示為個別方框。

自訂輪詢

下表顯示您可以配置最多三個非零自訂輪詢率的度量值。 依預設會停用輪詢率為零或小於零的度量值。 若要停用任何度量，請從配置檔 <instana-agent-dir>/etc/instana/configuration.yaml中移除該度量項目。

如需自訂輪詢的本端及遠端監視，請參閱下列配置:

com.instana.plugin.oracledb:
  user: '<ORCL_USER>'   # default is 'sys as sysdba'
  password: '<ORCL_PASSWORD>'
  host: '<ORCL_HOST>'   # default is 127.0.0.1
  port: '<ORCL_PORT>'   # default is 1521
  databaseSID: '<ORCL_DB_SID>' # taken from process args or 'orcl' as default
  poll_rate: 1
  customPolling: # Restricted to maximum 3 nonzero poll rates
    - poll_rate: 30 # in seconds
      metrics:
        - TOP_CPU_CONSUMING_SESSION_LAST_10_MIN
        - ACTIVE_SESSIONS_RUNNING_MORE_THAN_600_SECS
        - LIBRARY_CACHE_HIT_RATIO
        - CURRENT_BLOCKING_SESSIONS
    - poll_rate: 60 # in seconds
      metrics:
        - TOP_ELAPSED_TIME_QUERIES
        - TOP_TEN_CPU_CONSUMING_SESSION
        - SQL_ID_CONSUMING_MORE_CPU
        - USER_FOREGROUND_SESSIONS
        - TOP_10_SQL_HIGH_IO_LAST_1_HR
        - ACTIVE_SESSION_HISTORY
    - poll_rate: 3600 # in seconds
      metrics:
        - TOP_10_SQL_HIGH_IO_LAST_24_HR
        - TOP_CPU_QUERIES_LAST_24_HRS
        - QUERIES_NOT_USING_BINDING_VARIABLES

com.instana.plugin.oracledb:
  remote: # we support listing multiple DBs here!
    - host: '<ORCL_HOST_1>'
      port: '<ORCL_PORT>'
      user: '<ORCL_USER>' # default is 'sys as sysdba'
      password: '<ORCL_PASSWORD>'
      databaseSID: '<ORCL_DB_SID>' # either databaseSID or databaseServiceName is allowed
      databaseServiceName: '<ORCL_DB_SERVICE_NAME>'
      availabilityZone: 'Remote Monitoring'
      poll_rate: 20
      customPolling: # Restricted to maximum 3 nonzero poll rates
        - poll_rate: 30 # in seconds
          metrics:
            - TOP_CPU_CONSUMING_SESSION_LAST_10_MIN
            - ACTIVE_SESSIONS_RUNNING_MORE_THAN_600_SECS
            - LIBRARY_CACHE_HIT_RATIO
            - CURRENT_BLOCKING_SESSIONS
        - poll_rate: 60 # in seconds
          metrics:
            - TOP_ELAPSED_TIME_QUERIES
            - TOP_TEN_CPU_CONSUMING_SESSION
            - SQL_ID_CONSUMING_MORE_CPU
            - USER_FOREGROUND_SESSIONS
            - TOP_10_SQL_HIGH_IO_LAST_1_HR
            - ACTIVE_SESSION_HISTORY
        - poll_rate: 3600 # in seconds
          metrics:
            - TOP_10_SQL_HIGH_IO_LAST_24_HR
            - TOP_CPU_QUERIES_LAST_24_HRS
            - QUERIES_NOT_USING_BINDING_VARIABLES