oracle-database-example.yml

# NOTE: 'database' is an experimental API at this time
# ref: /~https://github.com/newrelic/nri-flex/blob/master/docs/experimental/db.md
# You can run multiple queries by adding queries in apis block, as below
# Below example has multiple nri-flex blocks to demonstrate multiple queries with different intervals.
---
integrations:
  - name: nri-flex
    interval: 60s
    config:
      name: OracleDbFlex
      secrets:
        login:
          kind: local # Use Flex local/internal decryption function
          key: N3wR3lic! # Your pass_phrase to encrypt/decrypt the database access credentials info
          data: <==YOUR ENCRYPTED LOGIN INFO from the command below==>
          # Run the following command to generate a encrypted login info, paste it to the above -> data
          # nri-flex -encrypt_pass 'username=<YOUR USERNAME>,password=<YOUR PASSWORD>' -pass_phrase 'N3wR3lic!'
          # The decrypted username and password will be used to exchange for access_token
          type: equal
      apis:
        - database: oracle
          db_conn: oracle://${secret.login:username}:${secret.login:password}@rds-name.region.rds.amazonaws.com:1521/db-name
          logging:
            open: true
          custom_attributes: # applies to all queries
            host: OracleDB
          db_async: true # process queries async
          db_queries:
            - name: OracleDBProcesses
              run: SELECT sess.process FROM v$session sess, v$sql sql WHERE sql.sql_id(+) = sess.sql_id AND sess.type = 'USER' # grab all processes from OracleDB
              custom_attributes: # can apply additional at a nested level
                attype: show processes
                host: OracleDB
        - database: oracle
          db_conn: oracle://${secret.login:username}:${secret.login:password}@rds-name.region.rds.amazonaws.com:1521/db-name
          logging:
            open: true
          custom_attributes: # applies to all queries
            host: OracleDB
          db_async: true # process queries async
          db_queries:
            - name: OracleDBProcessesTest2
              run: SELECT sess.process FROM v$session sess, v$sql sql WHERE sql.sql_id(+) = sess.sql_id AND sess.type = 'USER' # grab all processes related information from OracleDB
              custom_attributes: # can apply additional at a nested level
                attype: show processes
                host: OracleDB
  - name: nri-flex
    interval: 90s
    config:
      name: OracleDbFlex
      apis:
        - database: oracle
          db_conn: oracle://${secret.login:username}:${secret.login:password}@rds-name.region.rds.amazonaws.com:1521/db-name
          logging:
            open: true
          custom_attributes: # applies to all queries
            host: OracleDB
          db_async: true # process queries async
          db_queries:
            - name: OracleDBProcessesIds
              run: SELECT sess.process FROM v$session sess, v$sql sql WHERE sql.sql_id(+) = sess.sql_id AND sess.type = 'USER' # grab all processes ids from OracleDB
              custom_attributes: # can apply additional at a nested level
                attype: show processes
                host: OracleDB