zabbix_export:
  version: '6.4'
  template_groups:
    - uuid: 748ad4d098d447d492bb935c907f652f
      name: Templates/Databases
  templates:
    - uuid: d670c32f007d438c9dcd32db57d2b691
      template: 'Oracle by Zabbix agent 2'
      name: 'Oracle by Zabbix agent 2'
      description: 'Template tooling version used: 0.42'
      vendor:
        name: Zabbix
        version: 6.4-0
      groups:
        - name: Templates/Databases
      items:
        - uuid: 9d24ae0f86d54b73a35d9c15d4e082cb
          name: 'Oracle: Active parallel sessions'
          type: DEPENDENT
          key: oracle.active_parallel_sessions
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The number of active parallel sessions.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Active Parallel Sessions'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: sessions
        - uuid: 7e4eb79b9b674c5ba57e790fae0fb410
          name: 'Oracle: Active serial sessions'
          type: DEPENDENT
          key: oracle.active_serial_sessions
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The number of active serial sessions.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Active Serial Sessions'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: sessions
        - uuid: 9763dd0b223540e4820fd3b8f3281ec3
          name: 'Oracle: Average active sessions'
          type: DEPENDENT
          key: oracle.active_sessions
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The average active sessions at a point in time. The number of sessions that are either working or waiting.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Average Active Sessions'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: sessions
        - uuid: a5533a1c354a4c8dbfec39c9b0637ba2
          name: 'Oracle: Archiver state'
          type: DEPENDENT
          key: oracle.archiver_state
          delay: '0'
          history: 7d
          description: 'The status of automatic archiving.'
          valuemap:
            name: 'Oracle archiver state'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $..archiver.first()
          master_item:
            key: 'oracle.instance.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
        - uuid: a5f5251364a44a90a66bb2096f53a48a
          name: 'Oracle: Buffer cache hit ratio'
          type: DEPENDENT
          key: oracle.buffer_cache_hit_ratio
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The ratio of buffer cache hits ((LogRead - PhyRead)/LogRead).'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Buffer Cache Hit Ratio'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: cache
        - uuid: 1483e7a312154438a9b09d0b696568f0
          name: 'Oracle: Global cache blocks corrupted'
          type: DEPENDENT
          key: oracle.cache_blocks_corrupt
          delay: '0'
          history: 7d
          units: Rps
          description: 'The number of blocks that encountered corruption or checksum failure during the interconnect.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Global Cache Blocks Corrupted'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: cache
        - uuid: 3589d4b2b9114f9cabb027f85f5349ab
          name: 'Oracle: Global cache blocks lost'
          type: DEPENDENT
          key: oracle.cache_blocks_lost
          delay: '0'
          history: 7d
          units: Rps
          description: 'The number of lost global cache blocks.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Global Cache Blocks Lost'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: cache
        - uuid: fd1ea13484984d0baffc45ea02a33a7c
          name: 'Oracle: Cursor cache hit ratio'
          type: DEPENDENT
          key: oracle.cursor_cache_hit_ratio
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The ratio of cursor cache hits (CursorCacheHit/SoftParse).'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Cursor Cache Hit Ratio'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: cache
        - uuid: 9fd6475d1b824c74b2b3dad1db4f494a
          name: 'Oracle: Database CPU time ratio'
          type: DEPENDENT
          key: oracle.database_cpu_time_ratio
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'It is calculated by dividing the total CPU (used by the database) by the Oracle time model statistic DB time.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Database CPU Time Ratio'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: cpu
        - uuid: 9fc7f2e986cd4c97ad8778f06dd04822
          name: 'Oracle: Database wait time ratio'
          type: DEPENDENT
          key: oracle.database_wait_time_ratio
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'Wait time - the time that the server process spends waiting for available shared resources to be released by other server processes, such as latches, locks, data buffers, etc.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Database Wait Time Ratio'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
        - uuid: 12efa23a53eb468ea7b0713b8f610542
          name: 'Oracle: Datafiles count'
          key: 'oracle.datafiles.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          history: 7d
          description: 'The current number of datafiles.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.datafile_num
          tags:
            - tag: component
              value: datafiles
        - uuid: cdd3d4f1baea4f2ea122e058704d43e9
          name: 'Oracle: Datafiles limit'
          type: DEPENDENT
          key: oracle.db_files_limit
          delay: '0'
          history: 7d
          description: 'The maximum allowable number of datafiles.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.db_files
          master_item:
            key: 'oracle.sys.params["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: datafiles
        - uuid: 9692f4f771844438a3f9224455c504b6
          name: 'Oracle: Disk sort per second'
          type: DEPENDENT
          key: oracle.disk_sorts
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Rps
          description: 'The number of sorts going to disk per second.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Disk Sort Per Sec'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
        - uuid: 7dc5745f2a124119b058d23195ba5058
          name: 'Oracle: Enqueue timeouts per second'
          type: DEPENDENT
          key: oracle.enqueue_timeouts_rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Rps
          description: 'Enqueue timeouts per second.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Enqueue Timeouts Per Sec'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
        - uuid: 1aa391bbd2484793a31dc9f0dce51b46
          name: 'Oracle: Get FRA stats'
          key: 'oracle.fra.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          history: '0'
          trends: '0'
          value_type: TEXT
          description: 'Get FRA statistics.'
          tags:
            - tag: component
              value: raw
        - uuid: 5e09413cb3a14a3a87e2ead6b838ce1f
          name: 'Oracle: FRA, Number of files'
          type: DEPENDENT
          key: oracle.fra_number_of_files
          delay: '0'
          history: 7d
          description: 'The number of files in the FRA.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.number_of_files
          master_item:
            key: 'oracle.fra.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: fra
        - uuid: 68f50e7513d642f789a27dfce03ca1b8
          name: 'Oracle: FRA, Number of restore points'
          type: DEPENDENT
          key: oracle.fra_restore_point
          delay: '0'
          history: 7d
          value_type: FLOAT
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.restore_point
          master_item:
            key: 'oracle.fra.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: fra
        - uuid: f7f16828d46a4054a30a22e955542d6a
          name: 'Oracle: FRA, Space limit'
          type: DEPENDENT
          key: oracle.fra_space_limit
          delay: '0'
          history: 7d
          units: B
          description: 'The maximum amount of disk space (in bytes) that the database can use for the Fast Recovery Area (FRA).'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.space_limit
          master_item:
            key: 'oracle.fra.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: fra
        - uuid: 92d7abac10dc47a7bec1bd420a41c78c
          name: 'Oracle: FRA, Space reclaimable'
          type: DEPENDENT
          key: oracle.fra_space_reclaimable
          delay: '0'
          history: 7d
          units: B
          description: 'The total amount of disk space (in bytes) that can be created by deleting obsolete, redundant, and other low priority files from the FRA.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.space_reclaimable
          master_item:
            key: 'oracle.fra.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: fra
        - uuid: 1e02a10018124f4db85ef9822a605b61
          name: 'Oracle: FRA, Used space'
          type: DEPENDENT
          key: oracle.fra_space_used
          delay: '0'
          history: 7d
          units: B
          description: 'The amount of disk space (in bytes) used by FRA files created in the current and all the previous FRAs.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.space_used
          master_item:
            key: 'oracle.fra.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: fra
        - uuid: 887c56e1b9f1415db5def1e1f502a6ae
          name: 'Oracle: FRA, Usable space in %'
          type: DEPENDENT
          key: oracle.fra_usable_pct
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.usable_pct
          master_item:
            key: 'oracle.fra.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: fra
        - uuid: e8725c1d79e34fbc8331677fe3d4459e
          name: 'Oracle: GC CR block received per second'
          type: DEPENDENT
          key: oracle.gc_cr_block_received_rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Rps
          description: 'The global cache (GC) and the consistent read (CR) block received per second.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''GC CR Block Received Per Second'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: cache
        - uuid: 2c7dd0c162b742d08a2432c8bdde4ce2
          name: 'Oracle: Get instance state'
          key: 'oracle.instance.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          history: '0'
          trends: '0'
          value_type: TEXT
          description: 'The item gets its state of the current instance.'
          tags:
            - tag: component
              value: application
        - uuid: 021a98326c8f402693e4fba9fb3c25de
          name: 'Oracle: Instance role'
          type: DEPENDENT
          key: oracle.instance.role
          delay: '0'
          history: 7d
          description: 'It indicates whether the instance is an active instance or an inactive secondary instance.'
          valuemap:
            name: 'Oracle instance role'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.role
          master_item:
            key: 'oracle.instance.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
        - uuid: cd0e2c8f164443588ad19647506c0eea
          name: 'Oracle: Instance hostname'
          type: DEPENDENT
          key: oracle.instance_hostname
          delay: '0'
          history: 7d
          trends: '0'
          value_type: CHAR
          description: 'The name of the host machine.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $..hostname.first()
          master_item:
            key: 'oracle.instance.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
          triggers:
            - uuid: 346ef7cacf534988892970d699ef4028
              expression: 'last(/Oracle by Zabbix agent 2/oracle.instance_hostname,#1)<>last(/Oracle by Zabbix agent 2/oracle.instance_hostname,#2) and length(last(/Oracle by Zabbix agent 2/oracle.instance_hostname))>0'
              name: 'Oracle: Instance hostname has changed'
              event_name: 'Oracle: Instance hostname has changed (new hostname received: {ITEM.VALUE})'
              priority: INFO
              description: 'Oracle DB Instance hostname has changed. Ack to close.'
              manual_close: 'YES'
              tags:
                - tag: scope
                  value: notice
        - uuid: 0cc90c2554a7412eafe42c33dd1e9ede
          name: 'Oracle: Instance name'
          type: DEPENDENT
          key: oracle.instance_name
          delay: '0'
          history: 7d
          trends: '0'
          value_type: CHAR
          description: 'The name of an instance.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.instance
          master_item:
            key: 'oracle.instance.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
          triggers:
            - uuid: ed394860378642d5b9f220327ead6766
              expression: 'last(/Oracle by Zabbix agent 2/oracle.instance_name,#1)<>last(/Oracle by Zabbix agent 2/oracle.instance_name,#2) and length(last(/Oracle by Zabbix agent 2/oracle.instance_name))>0'
              name: 'Oracle: Instance name has changed'
              event_name: 'Oracle: Instance name has changed (new name received: {ITEM.VALUE})'
              priority: INFO
              description: 'Oracle DB Instance name has changed. Ack to close manually.'
              manual_close: 'YES'
              tags:
                - tag: scope
                  value: notice
        - uuid: f51053d243ef41089b5e635fd1abb5f3
          name: 'Oracle: Instance status'
          type: DEPENDENT
          key: oracle.instance_status
          delay: '0'
          history: 7d
          description: 'The status of the instance.'
          valuemap:
            name: 'Oracle instance status'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.status
          master_item:
            key: 'oracle.instance.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
        - uuid: b2551269bf4541dfae378b9e48d1f5da
          name: 'Oracle: Library cache hit ratio'
          type: DEPENDENT
          key: oracle.library_cache_hit_ratio
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The ratio of library cache hits (Hits/Pins).'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Library Cache Hit Ratio'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: cache
        - uuid: 13a938f495ee464a8ed3f2575cd191b9
          name: 'Oracle: Logons per second'
          type: DEPENDENT
          key: oracle.logons_rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Rps
          description: 'The number of logon attempts.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Logons Per Sec'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
        - uuid: 440f42943ebc436fb75bd5d8397fe876
          name: 'Oracle: Long table scans per second'
          type: DEPENDENT
          key: oracle.long_table_scans_rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Rps
          description: 'The number of long table scans per second. A table is considered ''long'' if the table is not cached and if its high-water mark is greater than five blocks.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Long Table Scans Per Sec'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
        - uuid: 4769432ae04641758daabd5b27deaa01
          name: 'Oracle: Memory sorts ratio'
          type: DEPENDENT
          key: oracle.memory_sorts_ratio
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The percentage of sorts (from ORDER BY clauses or index building) that are done to disk vs in-memory.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Memory Sorts Ratio'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
        - uuid: 4926809f2c244b33b1a0650510a30fa4
          name: 'Oracle: Get PGA stats'
          key: 'oracle.pga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          history: '0'
          trends: '0'
          value_type: TEXT
          description: 'Get PGA statistics.'
          tags:
            - tag: component
              value: raw
        - uuid: 749a1281ba84475193897a3362f6f873
          name: 'Oracle: PGA, Global memory bound'
          type: DEPENDENT
          key: oracle.pga_global_bound
          delay: '0'
          history: 7d
          units: B
          description: 'The maximum size of work area executed in automatic mode.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''global memory bound'']'
          master_item:
            key: 'oracle.pga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: memory
            - tag: component
              value: pga
        - uuid: 2b5797f046434125b65daf31121fdd81
          name: 'Oracle: PGA, Aggregate target parameter'
          type: DEPENDENT
          key: oracle.pga_target
          delay: '0'
          history: 7d
          units: B
          description: 'The current value of the PGA_AGGREGATE_TARGET initialization parameter. If this parameter is not set, then its value is 0 and automatic management of the PGA memory is disabled.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''aggregate PGA target parameter'']'
          master_item:
            key: 'oracle.pga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: memory
            - tag: component
              value: pga
        - uuid: e96ff6a018dc4553b9ad7f2dc87f4d99
          name: 'Oracle: Physical reads per second'
          type: DEPENDENT
          key: oracle.physical_reads_rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Rps
          description: 'Reads per second.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Physical Reads Per Sec'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: disk
        - uuid: 92bf88b7b07048b785ca37d9b97cd78b
          name: 'Oracle: Physical reads bytes per second'
          type: DEPENDENT
          key: oracle.physical_read_bytes_rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Read bytes per second.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Physical Read Bytes Per Sec'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: disk
        - uuid: b71df51181c1464486ced05c95bdc938
          name: 'Oracle: Physical writes per second'
          type: DEPENDENT
          key: oracle.physical_writes_rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Rps
          description: 'Writes per second.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Physical Writes Per Sec'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: disk
        - uuid: e34abb4139fe43ae8b27edbe6ad12c8d
          name: 'Oracle: Physical writes bytes per second'
          type: DEPENDENT
          key: oracle.physical_write_bytes_rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Write bytes per second.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Physical Write Bytes Per Sec'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: disk
        - uuid: 7f4d8ea4912944ec8bf32edff9e3b5ae
          name: 'Oracle: Ping'
          key: 'oracle.ping["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          delay: 30s
          history: 7d
          description: 'Test the connection to Oracle Database state.'
          valuemap:
            name: 'Service state'
          preprocessing:
            - type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 10m
          tags:
            - tag: component
              value: application
            - tag: component
              value: health
          triggers:
            - uuid: df6b0f5dd50848cc8c2e67947df0a5e1
              expression: 'last(/Oracle by Zabbix agent 2/oracle.ping["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"])=0'
              name: 'Oracle: Connection to database is unavailable'
              priority: DISASTER
              description: 'Connection to Oracle Database is currently unavailable.'
              tags:
                - tag: scope
                  value: availability
        - uuid: ce9dabcce58d408d8188fe7caa71e666
          name: 'Oracle: Number of processes'
          key: 'oracle.proc.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          history: 7d
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.proc_num
          tags:
            - tag: component
              value: system
        - uuid: cdb59700d4a24fb3bea9d2b63d5d7938
          name: 'Oracle: Processes limit'
          type: DEPENDENT
          key: oracle.processes_limit
          delay: '0'
          history: 7d
          description: 'The maximum number of user processes.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.processes
          master_item:
            key: 'oracle.sys.params["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: system
        - uuid: 898a5325c2a2469dabb6a2356107dd66
          name: 'Oracle: Redo logs available to switch'
          key: 'oracle.redolog.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          history: 7d
          description: 'The number of inactive/unused redo logs available for log switching.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.available
          tags:
            - tag: component
              value: application
          triggers:
            - uuid: 18dba6067a254bdd99a363c3d7b9bdb2
              expression: 'max(/Oracle by Zabbix agent 2/oracle.redolog.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"],5m) < {$ORACLE.REDO.MIN.WARN}'
              name: 'Oracle: Number of REDO logs available for switching is too low'
              event_name: 'Oracle: Number of REDO logs available for switching is too low (less {$ORACLE.REDO.MIN.WARN} for 5 min)'
              priority: WARNING
              description: 'The number of inactive/unused REDOs available for log switching is low (database down risk).'
              tags:
                - tag: scope
                  value: capacity
        - uuid: e8aca0dfd1d74d3b9b042d3ed3070e42
          name: 'Oracle: Rows per sort'
          type: DEPENDENT
          key: oracle.rows_per_sort
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The average number of rows per sort for all types of sorts performed.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Rows Per Sort'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
        - uuid: 0458d6dd9bde4f2aa51319e3c23f5eae
          name: 'Oracle: SQL service response time'
          type: DEPENDENT
          key: oracle.service_response_time
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: s
          description: 'The Structured Query Language (SQL) service response time expressed in seconds.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''SQL Service Response Time'']'
            - type: MULTIPLIER
              parameters:
                - '0.01'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
        - uuid: 41d61d167bf044fe9f0d9815b4fd27e6
          name: 'Oracle: Get sessions stats'
          key: 'oracle.sessions.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{$ORACLE.SESSION.LOCK.MAX.TIME}"]'
          history: '0'
          trends: '0'
          value_type: TEXT
          description: 'Get sessions statistics. {$ORACLE.SESSION.LOCK.MAX.TIME} -- maximum seconds in the current wait condition for counting long time locked sessions. Default: 600 seconds.'
          tags:
            - tag: component
              value: raw
        - uuid: 89811a05632c478d97165f629dadd5b9
          name: 'Oracle: Active background sessions'
          type: DEPENDENT
          key: oracle.session_active_background
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The number of active background sessions.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.active_background
              error_handler: CUSTOM_VALUE
              error_handler_params: '0'
          master_item:
            key: 'oracle.sessions.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{$ORACLE.SESSION.LOCK.MAX.TIME}"]'
          tags:
            - tag: component
              value: sessions
        - uuid: a7ef5969fff545968d7c133bc67baaac
          name: 'Oracle: Active user sessions'
          type: DEPENDENT
          key: oracle.session_active_user
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The number of active user sessions.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.active_user
              error_handler: CUSTOM_VALUE
              error_handler_params: '0'
          master_item:
            key: 'oracle.sessions.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{$ORACLE.SESSION.LOCK.MAX.TIME}"]'
          tags:
            - tag: component
              value: sessions
        - uuid: d91119f30b95418bab67f929737e6bf8
          name: 'Oracle: Sessions concurrency'
          type: DEPENDENT
          key: oracle.session_concurrency_rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The percentage of concurrency. Concurrency is a DB behavior when different transactions request to change the same resource. In the case of modifying data transactions, it sequentially temporarily blocks the right to change the data, the rest of the transactions are waiting for the access. In the case when the access for the resource is locked for a long time, then the concurrency grows (like the transaction queue) and this often has an extremely negative impact on the performance. A high contention value does not indicate the root cause of the problem but is a signal to search for it.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.concurrency_rate
          master_item:
            key: 'oracle.sessions.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{$ORACLE.SESSION.LOCK.MAX.TIME}"]'
          tags:
            - tag: component
              value: sessions
          triggers:
            - uuid: ff16c7bbeaa5439f98ffe12ce7deff71
              expression: 'min(/Oracle by Zabbix agent 2/oracle.session_concurrency_rate,5m) > {$ORACLE.CONCURRENCY.MAX.WARN}'
              name: 'Oracle: Too high database concurrency'
              event_name: 'Oracle: Too high database concurrency (over {$ORACLE.CONCURRENCY.MAX.WARN}% for 5 min)'
              priority: WARNING
              description: 'The concurrency rate exceeds {$ORACLE.CONCURRENCY.MAX.WARN}%. A high contention value does not indicate the root cause of the problem, but it is a signal to search for it. In the case of high competition, the analysis of resource consumption should be carried out. Which are the most "heavy" queries made in the database? Possibly, also session tracing. All this will help to determine the root cause and possible optimization points both in the database configuration and in the logic of building queries of the application itself.'
              tags:
                - tag: scope
                  value: performance
        - uuid: cfd7559ac25e4c0a837048e675f4d995
          name: 'Oracle: Session count'
          type: DEPENDENT
          key: oracle.session_count
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The count of sessions.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.total
          master_item:
            key: 'oracle.sessions.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{$ORACLE.SESSION.LOCK.MAX.TIME}"]'
          tags:
            - tag: component
              value: sessions
        - uuid: 2222705798fd464492c6f692dd9a0392
          name: 'Oracle: Inactive user sessions'
          type: DEPENDENT
          key: oracle.session_inactive_user
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The number of inactive user sessions.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.inactive_user
              error_handler: CUSTOM_VALUE
              error_handler_params: '0'
          master_item:
            key: 'oracle.sessions.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{$ORACLE.SESSION.LOCK.MAX.TIME}"]'
          tags:
            - tag: component
              value: sessions
        - uuid: 381c97858785442389cd6ab74d0ee285
          name: 'Oracle: Sessions limit'
          type: DEPENDENT
          key: oracle.session_limit
          delay: '0'
          history: 7d
          description: 'The user and system sessions.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.sessions
          master_item:
            key: 'oracle.sys.params["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: sessions
        - uuid: c1717acc82784151b5afc6ad08ce3145
          name: 'Oracle: Sessions lock rate'
          type: DEPENDENT
          key: oracle.session_lock_rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The percentage of locked sessions. Locks are mechanisms that prevent destructive interaction between transactions accessing the same resource — either user objects, such as tables and rows or system objects not visible to users, such as shared data structures in memory and data dictionary rows.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.lock_rate
          master_item:
            key: 'oracle.sessions.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{$ORACLE.SESSION.LOCK.MAX.TIME}"]'
          tags:
            - tag: component
              value: sessions
          triggers:
            - uuid: 504e5d964de645679ce448165dadd027
              expression: 'min(/Oracle by Zabbix agent 2/oracle.session_lock_rate,5m) > {$ORACLE.SESSIONS.LOCK.MAX.WARN}'
              name: 'Oracle: Too many locked sessions'
              event_name: 'Oracle: Too many locked sessions (over {$ORACLE.SESSIONS.LOCK.MAX.WARN}% for 5 min)'
              priority: WARNING
              description: 'The number of locked sessions exceeds {$ORACLE.SESSIONS.LOCK.MAX.WARN}% of the running sessions.'
              tags:
                - tag: scope
                  value: performance
        - uuid: c279df21264642369d65a6c72a11698d
          name: 'Oracle: Sessions locked over {$ORACLE.SESSION.LOCK.MAX.TIME}s'
          type: DEPENDENT
          key: oracle.session_long_time_locked
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The count of the prolongedly locked sessions. (You can change the duration of maximum session lock in seconds for a query by {$ORACLE.SESSION.LOCK.MAX.TIME} macro. Default is 600 sec).'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.long_time_locked
          master_item:
            key: 'oracle.sessions.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{$ORACLE.SESSION.LOCK.MAX.TIME}"]'
          tags:
            - tag: component
              value: sessions
          triggers:
            - uuid: 5abc07cd48514a0dac90ce946ce6bc3a
              expression: 'min(/Oracle by Zabbix agent 2/oracle.session_long_time_locked,5m) > {$ORACLE.SESSION.LONG.LOCK.MAX.WARN}'
              name: 'Oracle: Too many sessions locked'
              event_name: 'Oracle: Too many sessions locked over {$ORACLE.SESSION.LOCK.MAX.TIME}s (over {$ORACLE.SESSION.LONG.LOCK.MAX.WARN} for 5 min)'
              priority: WARNING
              description: 'The number of locked sessions exceeding {$ORACLE.SESSION.LOCK.MAX.TIME} seconds is too high. Long-term locks can negatively affect the database performance. Therefore, if they are detected, you should first find the most difficult queries from the database point of view and then analyze possible resource leaks.'
              tags:
                - tag: scope
                  value: performance
        - uuid: 1bafc80a94fb454785362593b8a73be3
          name: 'Oracle: Get SGA stats'
          key: 'oracle.sga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          history: '0'
          trends: '0'
          value_type: TEXT
          description: 'Get SGA statistics.'
          tags:
            - tag: component
              value: raw
        - uuid: 7ad06a6ccb834c5c95f30c319a48446c
          name: 'Oracle: SGA, buffer cache'
          type: DEPENDENT
          key: oracle.sga_buffer_cache
          delay: '0'
          history: 7d
          units: B
          description: 'The size of standard block cache.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.buffer_cache
          master_item:
            key: 'oracle.sga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: cache
            - tag: component
              value: sga
        - uuid: 39dc67c29cce4742acf832949dc57760
          name: 'Oracle: SGA, fixed'
          type: DEPENDENT
          key: oracle.sga_fixed
          delay: '0'
          history: 7d
          units: B
          description: 'The fixed System Global Area (SGA) is an internal housekeeping area.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.fixed_sga
          master_item:
            key: 'oracle.sga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: memory
            - tag: component
              value: sga
        - uuid: 562c02f282974020add8f98e9865fb9d
          name: 'Oracle: SGA, java pool'
          type: DEPENDENT
          key: oracle.sga_java_pool
          delay: '0'
          history: 7d
          units: B
          description: 'The memory is allocated from the Java pool.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.java_pool
          master_item:
            key: 'oracle.sga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: memory
            - tag: component
              value: sga
        - uuid: 35e3346e273a46339e7b5d3721584d3a
          name: 'Oracle: SGA, large pool'
          type: DEPENDENT
          key: oracle.sga_large_pool
          delay: '0'
          history: 7d
          units: B
          description: 'The memory is allocated from a large pool.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.large_pool
          master_item:
            key: 'oracle.sga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: memory
            - tag: component
              value: sga
        - uuid: 77c17fc1056745c4949b3476c3b920d4
          name: 'Oracle: SGA, log buffer'
          type: DEPENDENT
          key: oracle.sga_log_buffer
          delay: '0'
          history: 7d
          units: B
          description: 'The number of bytes allocated for the redo log buffer.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.log_buffer
          master_item:
            key: 'oracle.sga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: memory
            - tag: component
              value: sga
        - uuid: b64f3cad53814e989c576d3ce51bf42d
          name: 'Oracle: SGA, shared pool'
          type: DEPENDENT
          key: oracle.sga_shared_pool
          delay: '0'
          history: 7d
          units: B
          description: 'The memory is allocated from a shared pool.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.shared_pool
          master_item:
            key: 'oracle.sga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: memory
            - tag: component
              value: sga
        - uuid: 517c7b3bbf8d40988e6a8289319eaec9
          name: 'Oracle: Shared pool free %'
          type: DEPENDENT
          key: oracle.shared_pool_free
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'Free memory of a shared pool expressed in %.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Shared Pool Free %'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: memory
          triggers:
            - uuid: 80dbf89c86764cf09d2c5ec834e8940c
              expression: 'max(/Oracle by Zabbix agent 2/oracle.shared_pool_free,5m)<{$ORACLE.SHARED.FREE.MIN.WARN}'
              name: 'Oracle: Shared pool free is too low'
              event_name: 'Oracle: Shared pool free is too low (less {$ORACLE.SHARED.FREE.MIN.WARN}% for 5m)'
              priority: WARNING
              description: 'The free memory percent of the shared pool has been less than {$ORACLE.SHARED.FREE.MIN.WARN}% for the last 5 minutes.'
              tags:
                - tag: scope
                  value: capacity
        - uuid: 28c7030b02714d5ea402fe6f2a3d769a
          name: 'Oracle: Total sorts per user call'
          type: DEPENDENT
          key: oracle.sorts_per_user_call
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The total sorts per user call.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Total Sorts Per User Call'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
        - uuid: eccce1efc85d46199b3147ec586e1cd5
          name: 'Oracle: Get system metrics'
          key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          delay: 0;m0-59
          history: '0'
          trends: '0'
          value_type: TEXT
          description: 'The item gets the values of the system metrics.'
          tags:
            - tag: component
              value: raw
        - uuid: d59cca864e8044d89f9b4689ec712511
          name: 'Oracle: Get system parameters'
          key: 'oracle.sys.params["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          history: '0'
          trends: '0'
          value_type: TEXT
          description: 'Get a set of system parameter values.'
          tags:
            - tag: component
              value: raw
        - uuid: 48f54a0324a64e80aaf22d5cd26798cd
          name: 'Oracle: Temp space used'
          type: DEPENDENT
          key: oracle.temp_space_used
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'Used temporary space.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''Temp Space Used'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
        - uuid: 1a4efb793cff4224b0ae02272be2fe85
          name: 'Oracle: PGA, Total allocated'
          type: DEPENDENT
          key: oracle.total_pga_allocated
          delay: '0'
          history: 7d
          units: B
          description: 'The current amount of the PGA memory allocated by the instance. The Oracle Database attempts to keep this number below the value of the PGA_AGGREGATE_TARGET initialization parameter. However, it is possible for the PGA allocated to exceed that value by a small percentage and for a short period of time when the work area workload is increasing very rapidly or when PGA_AGGREGATE_TARGET is set to a small value.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''total PGA allocated'']'
          master_item:
            key: 'oracle.pga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: memory
            - tag: component
              value: pga
        - uuid: 264b73d153694b52a47ac0219a8de66c
          name: 'Oracle: PGA, Total freeable'
          type: DEPENDENT
          key: oracle.total_pga_freeable
          delay: '0'
          history: 7d
          units: B
          description: 'The number of bytes of the PGA memory in all processes that could be freed back to the operating system.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''total freeable PGA memory'']'
          master_item:
            key: 'oracle.pga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: memory
            - tag: component
              value: pga
        - uuid: 3f3083748a4f42998b135b1b4f88d11a
          name: 'Oracle: PGA, Total inuse'
          type: DEPENDENT
          key: oracle.total_pga_used
          delay: '0'
          history: 7d
          units: B
          description: 'It indicates how much the Program Global Area (PGA) memory is currently consumed by work areas. This number can be used to determine how much memory is consumed by other consumers of the PGA memory (for example, PL/SQL or Java).'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''total PGA inuse'']'
          master_item:
            key: 'oracle.pga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: memory
            - tag: component
              value: pga
        - uuid: 4f1a9efea8594486b226307a52e35474
          name: 'Oracle: Uptime'
          type: DEPENDENT
          key: oracle.uptime
          delay: '0'
          history: 7d
          trends: 0d
          units: s
          description: 'The Oracle instance uptime expressed in seconds.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.uptime
          master_item:
            key: 'oracle.instance.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
          triggers:
            - uuid: bcdaf519783f453e81d7064207f8bd30
              expression: 'nodata(/Oracle by Zabbix agent 2/oracle.uptime,30m)=1'
              name: 'Oracle: Failed to fetch info data'
              event_name: 'Oracle: Failed to fetch info data (or no data for 30m)'
              priority: INFO
              description: 'Zabbix has not received any data for the items for the last 5 minutes. The database might be unavailable for connecting.'
              tags:
                - tag: scope
                  value: availability
            - uuid: 5eae478e85834eee91b94680d529dcdb
              expression: 'last(/Oracle by Zabbix agent 2/oracle.uptime)<10m'
              name: 'Oracle: Host has been restarted'
              event_name: 'Oracle: {HOST.NAME} has been restarted (uptime < 10m)'
              priority: INFO
              description: 'The host uptime is less than 10 minutes.'
              manual_close: 'YES'
              tags:
                - tag: scope
                  value: notice
        - uuid: 73ff311f3d5c4e93b5919f5633fc09f9
          name: 'Oracle: User''s expire password'
          key: 'oracle.user.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          history: 7d
          value_type: FLOAT
          units: days
          description: 'The number of days before the password of Zabbix account expires.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.exp_passwd_days_before
          tags:
            - tag: component
              value: application
          triggers:
            - uuid: 5eaa700c3bb74399ad2d26c382397415
              expression: 'last(/Oracle by Zabbix agent 2/oracle.user.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"])  < {$ORACLE.EXPIRE.PASSWORD.MIN.WARN}'
              name: 'Oracle: Zabbix account will expire soon'
              event_name: 'Oracle: Zabbix account will expire soon (under {$ORACLE.EXPIRE.PASSWORD.MIN.WARN} days)'
              priority: WARNING
              description: 'The password for Zabbix user in the database expires soon.'
              tags:
                - tag: scope
                  value: notice
        - uuid: cec9a53d637e42c79e2a838588ceeaca
          name: 'Oracle: User rollbacks per second'
          type: DEPENDENT
          key: oracle.user_rollbacks_rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Rps
          description: 'The number of times that users manually issue the ROLLBACK statement or an error occurred during the users'' transactions.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - '$.[''User Rollbacks Per Sec'']'
          master_item:
            key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
        - uuid: 04c0b90a0a7c4d6a95f51d006a65a530
          name: 'Oracle: Version'
          type: DEPENDENT
          key: oracle.version
          delay: '0'
          history: 7d
          trends: '0'
          value_type: CHAR
          description: 'The Oracle Server version.'
          preprocessing:
            - type: JSONPATH
              parameters:
                - $.version
            - type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1d
          master_item:
            key: 'oracle.instance.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          tags:
            - tag: component
              value: application
          triggers:
            - uuid: 4a68bcb6149c4c839e263c949343add8
              expression: 'last(/Oracle by Zabbix agent 2/oracle.version,#1)<>last(/Oracle by Zabbix agent 2/oracle.version,#2) and length(last(/Oracle by Zabbix agent 2/oracle.version))>0'
              name: 'Oracle: Version has changed'
              event_name: 'Oracle: Version has changed (new version value received: {ITEM.VALUE})'
              priority: INFO
              description: 'The Oracle DB version has changed. Acknowledge (Ack) to close manually.'
              manual_close: 'YES'
              tags:
                - tag: scope
                  value: notice
      discovery_rules:
        - uuid: e2f1ce8c037f4efa9bdb98166d344be6
          name: 'Archive log discovery'
          key: 'oracle.archive.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          delay: 1h
          description: 'Destinations of the log archive.'
          item_prototypes:
            - uuid: 1ad93880e4314d68b9e1aa4e00f03b6e
              name: 'Archivelog ''{#DEST_NAME}'': Get archive log info'
              key: 'oracle.archive.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DEST_NAME}"]'
              delay: 5m
              history: '0'
              trends: '0'
              value_type: TEXT
              description: 'It gets the archivelog statistics.'
              tags:
                - tag: component
                  value: archive-log
                - tag: component
                  value: raw
            - uuid: 46ae0ac79493430a94ac50f79dc053ba
              name: 'Archivelog ''{#DEST_NAME}'': Error'
              type: DEPENDENT
              key: 'oracle.archivelog_error["{#DEST_NAME}"]'
              delay: '0'
              history: 7d
              trends: '0'
              value_type: TEXT
              description: 'It displays the error message.'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..[''{#DEST_NAME}''].error.first()'
                - type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 1h
              master_item:
                key: 'oracle.archive.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DEST_NAME}"]'
              tags:
                - tag: component
                  value: archive-log
                - tag: destination
                  value: '{#DEST_NAME}'
            - uuid: ce76a8ece06f4a17bfaf08b4351346d5
              name: 'Archivelog ''{#DEST_NAME}'': Last sequence'
              type: DEPENDENT
              key: 'oracle.archivelog_log_sequence["{#DEST_NAME}"]'
              delay: '0'
              history: 7d
              description: 'It identifies the sequence number of the last archived redo log to be archived.'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..[''{#DEST_NAME}''].log_sequence.first()'
              master_item:
                key: 'oracle.archive.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DEST_NAME}"]'
              tags:
                - tag: component
                  value: archive-log
                - tag: destination
                  value: '{#DEST_NAME}'
            - uuid: a411a4e1c8ca4ea2a1ece92075cd0325
              name: 'Archivelog ''{#DEST_NAME}'': Status'
              type: DEPENDENT
              key: 'oracle.archivelog_log_status["{#DEST_NAME}"]'
              delay: '0'
              history: 7d
              description: |
                It identifies the current status of the destination where:
                1 - 'VALID';
                2 - 'DEFERRED';
                3 - 'ERROR';
                0 - 'UNKNOWN'.
              valuemap:
                name: 'Oracle Archivelog status'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..[''{#DEST_NAME}''].status.first()'
                - type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 1h
              master_item:
                key: 'oracle.archive.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DEST_NAME}"]'
              tags:
                - tag: component
                  value: archive-log
                - tag: destination
                  value: '{#DEST_NAME}'
              trigger_prototypes:
                - uuid: e2d393c0ff2f420097e19890bcbe215c
                  expression: 'last(/Oracle by Zabbix agent 2/oracle.archivelog_log_status["{#DEST_NAME}"])<2'
                  name: 'Archivelog ''{#DEST_NAME}'': Log Archive is not valid'
                  priority: HIGH
                  description: |
                    The trigger will launch if the archive log destination is not in one of these states:
                    2 - 'DEFERRED';
                    3 - 'VALID'.
                  tags:
                    - tag: scope
                      value: availability
        - uuid: 59840e68757644afbcf6ec49a6f5e95d
          name: 'Database discovery'
          key: 'oracle.db.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          delay: 1h
          filter:
            evaltype: AND
            conditions:
              - macro: '{#DBNAME}'
                value: '{$ORACLE.DBNAME.MATCHES}'
                formulaid: A
              - macro: '{#DBNAME}'
                value: '{$ORACLE.DBNAME.NOT_MATCHES}'
                operator: NOT_MATCHES_REGEX
                formulaid: B
          description: 'Scanning databases in the database management system (DBMS).'
          item_prototypes:
            - uuid: 1bad65e85d8b482d9cd83b1d202f8d8c
              name: 'Oracle Database ''{#DBNAME}'': Get CDB and No-CDB info'
              key: 'oracle.cdb.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DBNAME}"]'
              history: '0'
              trends: '0'
              value_type: TEXT
              description: 'It gets the information about the container database (CDB) and non-CDB database on an instance.'
              tags:
                - tag: component
                  value: cdb
                - tag: component
                  value: raw
            - uuid: d9d1575b767b46e0aefe65a270f2d01b
              name: 'Oracle Database ''{#DBNAME}'': Force logging'
              type: DEPENDENT
              key: 'oracle.db_force_logging["{#DBNAME}"]'
              delay: '0'
              history: 7d
              description: 'It indicates whether the database is under force logging mode ''YES'' or ''NO''.'
              valuemap:
                name: 'Oracle force log status'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..{#DBNAME}.force_logging.first()'
                - type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 15m
              master_item:
                key: 'oracle.cdb.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DBNAME}"]'
              tags:
                - tag: component
                  value: database
                - tag: database
                  value: '{#DBNAME}'
                - tag: type
                  value: '{#TYPE}'
            - uuid: a499423d6e8d44f2bc11beceb30c5fc1
              name: 'Oracle Database ''{#DBNAME}'': Log mode'
              type: DEPENDENT
              key: 'oracle.db_log_mode["{#DBNAME}"]'
              delay: '0'
              history: 7d
              description: |
                The archive log mode where:
                0 - 'NOARCHIVELOG';
                1 - 'ARCHIVELOG';
                2 - 'MANUAL'.
              valuemap:
                name: 'Oracle log mode'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..{#DBNAME}.log_mode.first()'
                - type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 15m
              master_item:
                key: 'oracle.cdb.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DBNAME}"]'
              tags:
                - tag: component
                  value: database
                - tag: database
                  value: '{#DBNAME}'
                - tag: type
                  value: '{#TYPE}'
            - uuid: 0b0cfebb30aa4d21b8ff91f887fdffde
              name: 'Oracle Database ''{#DBNAME}'': Open status'
              type: DEPENDENT
              key: 'oracle.db_open_mode["{#DBNAME}"]'
              delay: '0'
              history: 7d
              description: |
                1 - 'MOUNTED';
                2 - 'READ WRITE';
                3 - 'READ ONLY';
                4 - 'READ ONLY WITH APPLY' (a physical standby database is open in real-time query mode).
              valuemap:
                name: 'Oracle DB open status'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..{#DBNAME}.open_mode.first()'
                - type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 15m
              master_item:
                key: 'oracle.cdb.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DBNAME}"]'
              tags:
                - tag: component
                  value: database
                - tag: database
                  value: '{#DBNAME}'
                - tag: type
                  value: '{#TYPE}'
              trigger_prototypes:
                - uuid: fb642c2cfeb142409c67a7755d1047cc
                  expression: 'last(/Oracle by Zabbix agent 2/oracle.db_open_mode["{#DBNAME}"],#1)<>last(/Oracle by Zabbix agent 2/oracle.db_open_mode["{#DBNAME}"],#2)'
                  name: 'Oracle Database ''{#DBNAME}'': Open status has changed'
                  event_name: 'Oracle Database ''{#DBNAME}'': Open status has changed (new value received: {ITEM.VALUE})'
                  priority: INFO
                  description: 'The Oracle DB open status has changed. Ack to close manually.'
                  manual_close: 'YES'
                  dependencies:
                    - name: 'Oracle Database ''{#DBNAME}'': Open status in mount mode'
                      expression: 'last(/Oracle by Zabbix agent 2/oracle.db_open_mode["{#DBNAME}"])=1'
                  tags:
                    - tag: scope
                      value: notice
                - uuid: ef1c57d8f7d34c02bf0b7347d9fddf54
                  expression: 'last(/Oracle by Zabbix agent 2/oracle.db_open_mode["{#DBNAME}"])=1'
                  name: 'Oracle Database ''{#DBNAME}'': Open status in mount mode'
                  priority: WARNING
                  description: 'The Oracle DB is in a mounted state.'
                  tags:
                    - tag: scope
                      value: notice
            - uuid: 560b010dcdfc445cbd4e266b88b60e24
              name: 'Oracle Database ''{#DBNAME}'': Role'
              type: DEPENDENT
              key: 'oracle.db_role["{#DBNAME}"]'
              delay: '0'
              history: 7d
              description: |
                The current role of the database where:
                1 - 'SNAPSHOT STANDBY';
                2 - 'LOGICAL STANDBY';
                3 - 'PHYSICAL STANDBY';
                4 - 'PRIMARY ';
                5 - 'FAR SYNC'.
              valuemap:
                name: 'Oracle DB role'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..{#DBNAME}.role.first()'
                - type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 15m
              master_item:
                key: 'oracle.cdb.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DBNAME}"]'
              tags:
                - tag: component
                  value: database
                - tag: database
                  value: '{#DBNAME}'
                - tag: type
                  value: '{#TYPE}'
              trigger_prototypes:
                - uuid: 24fef0b751fd4d089eced3c210954b4f
                  expression: 'last(/Oracle by Zabbix agent 2/oracle.db_role["{#DBNAME}"],#1)<>last(/Oracle by Zabbix agent 2/oracle.db_role["{#DBNAME}"],#2)'
                  name: 'Oracle Database ''{#DBNAME}'': Role has changed'
                  event_name: 'Oracle Database ''{#DBNAME}'': Role has changed (new value received: {ITEM.VALUE})'
                  priority: INFO
                  description: 'The Oracle DB role has changed. Ack to close manually.'
                  manual_close: 'YES'
                  tags:
                    - tag: scope
                      value: notice
          trigger_prototypes:
            - uuid: 049473f763d84700b62abf5c914390fe
              expression: 'last(/Oracle by Zabbix agent 2/oracle.db_force_logging["{#DBNAME}"]) = 0 and last(/Oracle by Zabbix agent 2/oracle.db_log_mode["{#DBNAME}"]) = 1'
              name: 'Oracle Database ''{#DBNAME}'': Force logging is deactivated for DB with active Archivelog'
              priority: WARNING
              description: 'Force Logging mode - it is very important metric for Databases in ''ARCHIVELOG''. This feature allows to forcibly write all the transactions to the REDO.'
              tags:
                - tag: scope
                  value: performance
        - uuid: 8d31eea973a7408abf0eb25ca7ba70c6
          name: 'ASM disk groups discovery'
          key: 'oracle.diskgroups.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          delay: 1h
          description: 'The ASM disk groups.'
          item_prototypes:
            - uuid: 8b4e5c9385d04a39b2187e093ffca213
              name: 'ASM ''{#DGNAME}'': Free size'
              type: DEPENDENT
              key: 'oracle.asm_free_size["{#DGNAME}"]'
              delay: '0'
              history: 7d
              units: B
              description: 'The free size of the ASM disk group.'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..[''{#DGNAME}''].free_bytes.first()'
              master_item:
                key: 'oracle.diskgroups.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DGNAME}"]'
              tags:
                - tag: component
                  value: asm
                - tag: disk-group
                  value: '{#DGNAME}'
            - uuid: b80f69f44dd24eae82a301dbefb0c60f
              name: 'ASM ''{#DGNAME}'': Total size'
              type: DEPENDENT
              key: 'oracle.asm_total_size["{#DGNAME}"]'
              delay: '0'
              history: 7d
              units: B
              description: 'The total size of the ASM disk group.'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..[''{#DGNAME}''].total_bytes.first()'
              master_item:
                key: 'oracle.diskgroups.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DGNAME}"]'
              tags:
                - tag: component
                  value: asm
                - tag: disk-group
                  value: '{#DGNAME}'
            - uuid: e2a0ac73040f401bb05ff88140f6665b
              name: 'ASM ''{#DGNAME}'': Free size'
              type: DEPENDENT
              key: 'oracle.asm_used_pct["{#DGNAME}"]'
              delay: '0'
              history: 7d
              value_type: FLOAT
              units: '%'
              description: 'Usage of the ASM disk group expressed in %.'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..[''{#DGNAME}''].used_pct.first()'
              master_item:
                key: 'oracle.diskgroups.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DGNAME}"]'
              tags:
                - tag: component
                  value: asm
                - tag: disk-group
                  value: '{#DGNAME}'
              trigger_prototypes:
                - uuid: b8aa1b00e2574e35bf71554cabfffcfc
                  expression: 'min(/Oracle by Zabbix agent 2/oracle.asm_used_pct["{#DGNAME}"],5m)>{$ORACLE.ASM.USED.PCT.MAX.HIGH}'
                  name: 'ASM ''{#DGNAME}'': Disk group usage is too high'
                  event_name: 'ASM ''{#DGNAME}'': Disk group usage is too high (over {$ORACLE.ASM.USED.PCT.MAX.HIGH}% for 5m)'
                  priority: HIGH
                  description: 'The usage of the ASM disk group expressed in % exceeds {$ORACLE.ASM.USED.PCT.MAX.HIGH}'
                  tags:
                    - tag: scope
                      value: capacity
                - uuid: af6ff1d099524209b2806b1257e9a8e3
                  expression: 'min(/Oracle by Zabbix agent 2/oracle.asm_used_pct["{#DGNAME}"],5m)>{$ORACLE.ASM.USED.PCT.MAX.WARN}'
                  name: 'ASM ''{#DGNAME}'': Disk group usage is too high'
                  event_name: 'ASM ''{#DGNAME}'': Disk group usage is too high (over {$ORACLE.ASM.USED.PCT.MAX.WARN}% for 5m)'
                  priority: WARNING
                  description: 'The usage of the ASM disk group expressed in % exceeds {$ORACLE.ASM.USED.PCT.MAX.WARN}'
                  dependencies:
                    - name: 'ASM ''{#DGNAME}'': Disk group usage is too high'
                      expression: 'min(/Oracle by Zabbix agent 2/oracle.asm_used_pct["{#DGNAME}"],5m)>{$ORACLE.ASM.USED.PCT.MAX.HIGH}'
                  tags:
                    - tag: scope
                      value: capacity
            - uuid: cb703b07fc514ce5aedc561896bcd53f
              name: 'ASM ''{#DGNAME}'': Get ASM stats'
              key: 'oracle.diskgroups.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DGNAME}"]'
              history: '0'
              trends: '0'
              value_type: TEXT
              description: 'It gets the ASM disk group statistics.'
              tags:
                - tag: component
                  value: asm
                - tag: component
                  value: raw
          graph_prototypes:
            - uuid: f42e49e6743f4b08b5bdc3ab284b26f3
              name: 'ASM ''{#DGNAME}'': ASM disk group ''{#DGNAME}'''
              graph_items:
                - color: 1A7C11
                  item:
                    host: 'Oracle by Zabbix agent 2'
                    key: 'oracle.asm_free_size["{#DGNAME}"]'
                - sortorder: '1'
                  color: 2774A4
                  item:
                    host: 'Oracle by Zabbix agent 2'
                    key: 'oracle.asm_total_size["{#DGNAME}"]'
        - uuid: 479a56fe538f46c094cc4b595d070776
          name: 'PDB discovery'
          key: 'oracle.pdb.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          delay: 1h
          filter:
            evaltype: AND
            conditions:
              - macro: '{#DBNAME}'
                value: '{$ORACLE.DBNAME.MATCHES}'
                formulaid: A
              - macro: '{#DBNAME}'
                value: '{$ORACLE.DBNAME.NOT_MATCHES}'
                operator: NOT_MATCHES_REGEX
                formulaid: B
          description: 'Scanning a pluggable database (PDB) in DBMS.'
          item_prototypes:
            - uuid: ca4452418d2641bd87fa75e946c2bf98
              name: 'Oracle Database ''{#DBNAME}'': Get PDB info'
              key: 'oracle.pdb.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DBNAME}"]'
              history: '0'
              trends: '0'
              value_type: TEXT
              description: 'It gets the information about the PDB database on an instance.'
              tags:
                - tag: component
                  value: pdb
                - tag: component
                  value: raw
            - uuid: c52e96105cea45cea1b18201b325ba53
              name: 'Oracle Database ''{#DBNAME}'': Open status'
              type: DEPENDENT
              key: 'oracle.pdb_open_mode["{#DBNAME}"]'
              delay: '0'
              history: 7d
              description: |
                1 - 'MOUNTED';
                2 - 'READ WRITE';
                3 - 'READ ONLY';
                4 - 'READ ONLY WITH APPLY' (a physical standby database is open in real-time query mode).
              valuemap:
                name: 'Oracle DB open status'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..{#DBNAME}.open_mode.first()'
                - type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 15m
              master_item:
                key: 'oracle.pdb.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DBNAME}"]'
              tags:
                - tag: component
                  value: database
                - tag: database
                  value: '{#DBNAME}'
                - tag: type
                  value: pdb
              trigger_prototypes:
                - uuid: 61f48e1d858f4e95a603b32ee1c409dc
                  expression: 'last(/Oracle by Zabbix agent 2/oracle.pdb_open_mode["{#DBNAME}"],#1)<>last(/Oracle by Zabbix agent 2/oracle.pdb_open_mode["{#DBNAME}"],#2)'
                  name: 'Oracle Database ''{#DBNAME}'': Open status has changed'
                  event_name: 'Oracle Database ''{#DBNAME}'': Open status has changed (new value received: {ITEM.VALUE})'
                  priority: INFO
                  description: 'The Oracle DB open status has changed. Ack to close manually.'
                  manual_close: 'YES'
                  tags:
                    - tag: scope
                      value: notice
                - uuid: a6921cc3b42843dcb5624b3bb172f996
                  expression: 'last(/Oracle by Zabbix agent 2/oracle.pdb_open_mode["{#DBNAME}"])=1'
                  name: 'Oracle Database ''{#DBNAME}'': Open status in mount mode'
                  priority: WARNING
                  description: 'The Oracle DB is in a mounted state.'
                  tags:
                    - tag: scope
                      value: notice
        - uuid: 46ee5f42a15b43a58f7ef0ce5e3638d3
          name: 'Tablespace discovery'
          key: 'oracle.ts.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
          delay: 1h
          filter:
            evaltype: AND
            conditions:
              - macro: '{#TABLESPACE}'
                value: '{$ORACLE.TABLESPACE.NAME.MATCHES}'
                formulaid: A
              - macro: '{#TABLESPACE}'
                value: '{$ORACLE.TABLESPACE.NAME.NOT_MATCHES}'
                operator: NOT_MATCHES_REGEX
                formulaid: B
          description: 'Scanning tablespaces in DBMS.'
          item_prototypes:
            - uuid: 14a26a84cfe947089843ed93cd7707c8
              name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace allocated, bytes'
              type: DEPENDENT
              key: 'oracle.tbs_alloc_bytes["{#TABLESPACE}"]'
              delay: '0'
              history: 7d
              units: B
              description: 'Currently allocated bytes for the tablespace (sum of the current size of datafiles).'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..[''{#TABLESPACE}''].file_bytes.first()'
              master_item:
                key: 'oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#TABLESPACE}","{#CONTENTS}"]'
              tags:
                - tag: component
                  value: tablespaces
                - tag: contents
                  value: '{#CONTENTS}'
                - tag: tablespace
                  value: '{#TABLESPACE}'
            - uuid: d7263b6da6c04c7798909a8448f526ab
              name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace free, bytes'
              type: DEPENDENT
              key: 'oracle.tbs_free_bytes["{#TABLESPACE}"]'
              delay: '0'
              history: 7d
              units: B
              description: 'Free bytes of the allocated space.'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..[''{#TABLESPACE}''].free_bytes.first()'
              master_item:
                key: 'oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#TABLESPACE}","{#CONTENTS}"]'
              tags:
                - tag: component
                  value: tablespaces
                - tag: contents
                  value: '{#CONTENTS}'
                - tag: tablespace
                  value: '{#TABLESPACE}'
            - uuid: d2d919d303b244829c797245e08c2fe5
              name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace MAX size, bytes'
              type: DEPENDENT
              key: 'oracle.tbs_max_bytes["{#TABLESPACE}"]'
              delay: '0'
              history: 7d
              units: B
              description: 'The maximum size of the tablespace.'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..[''{#TABLESPACE}''].max_bytes.first()'
              master_item:
                key: 'oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#TABLESPACE}","{#CONTENTS}"]'
              tags:
                - tag: component
                  value: tablespaces
                - tag: contents
                  value: '{#CONTENTS}'
                - tag: tablespace
                  value: '{#TABLESPACE}'
            - uuid: de6892ac5ca4499db01dd02c0444aafc
              name: 'Oracle TBS ''{#TABLESPACE}'': Open status'
              type: DEPENDENT
              key: 'oracle.tbs_status["{#TABLESPACE}"]'
              delay: '0'
              history: 7d
              description: |
                The tablespace status where:
                1 - 'ONLINE';
                2 - 'OFFLINE';
                3 - 'READ ONLY'.
              valuemap:
                name: 'Oracle tablespace status'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..[''{#TABLESPACE}''].status.first()'
              master_item:
                key: 'oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#TABLESPACE}","{#CONTENTS}"]'
              tags:
                - tag: component
                  value: tablespaces
                - tag: contents
                  value: '{#CONTENTS}'
                - tag: tablespace
                  value: '{#TABLESPACE}'
              trigger_prototypes:
                - uuid: 832f908ca3b84a3c9a030b5d33b96016
                  expression: 'last(/Oracle by Zabbix agent 2/oracle.tbs_status["{#TABLESPACE}"])=2'
                  name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace is OFFLINE'
                  priority: WARNING
                  description: 'The tablespace is in the offline state.'
                  tags:
                    - tag: scope
                      value: availability
                - uuid: 2e84836974b340b5b916eed08e1fcdf4
                  expression: 'last(/Oracle by Zabbix agent 2/oracle.tbs_status["{#TABLESPACE}"],#1)<>last(/Oracle by Zabbix agent 2/oracle.tbs_status["{#TABLESPACE}"],#2)'
                  name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace status has changed'
                  event_name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace status has changed (new value received: {ITEM.VALUE})'
                  priority: INFO
                  description: 'Oracle tablespace status has changed. Ack to close.'
                  manual_close: 'YES'
                  dependencies:
                    - name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace is OFFLINE'
                      expression: 'last(/Oracle by Zabbix agent 2/oracle.tbs_status["{#TABLESPACE}"])=2'
                  tags:
                    - tag: scope
                      value: notice
            - uuid: ab56fee407e143db912dffcf24fb0106
              name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace used, bytes'
              type: DEPENDENT
              key: 'oracle.tbs_used_bytes["{#TABLESPACE}"]'
              delay: '0'
              history: 7d
              units: B
              description: 'Currently used bytes for the tablespace (current size of datafiles - the free space).'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..[''{#TABLESPACE}''].used_bytes.first()'
              master_item:
                key: 'oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#TABLESPACE}","{#CONTENTS}"]'
              tags:
                - tag: component
                  value: tablespaces
                - tag: contents
                  value: '{#CONTENTS}'
                - tag: tablespace
                  value: '{#TABLESPACE}'
            - uuid: 358615a3e372462e9cec05df1df22743
              name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace usage, percent'
              type: DEPENDENT
              key: 'oracle.tbs_used_file_pct["{#TABLESPACE}"]'
              delay: '0'
              history: 7d
              value_type: FLOAT
              units: '%'
              description: 'Used bytes/allocated bytes*100.'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..[''{#TABLESPACE}''].used_file_pct.first()'
              master_item:
                key: 'oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#TABLESPACE}","{#CONTENTS}"]'
              tags:
                - tag: component
                  value: tablespaces
                - tag: contents
                  value: '{#CONTENTS}'
                - tag: tablespace
                  value: '{#TABLESPACE}'
              trigger_prototypes:
                - uuid: bbc86236064348ee9150dfdd07623061
                  expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_file_pct["{#TABLESPACE}"],5m)>{$ORACLE.TBS.USED.PCT.MAX.HIGH}'
                  name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace usage is too high'
                  event_name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace usage is too high (over {$ORACLE.TBS.USED.PCT.MAX.HIGH}% for 5m).'
                  priority: HIGH
                  tags:
                    - tag: scope
                      value: capacity
                - uuid: ba298d35aaaa4386b4f03914dcf1cb27
                  expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_file_pct["{#TABLESPACE}"],5m)>{$ORACLE.TBS.USED.PCT.MAX.WARN}'
                  name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace usage is too high'
                  event_name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace usage is too high (over {$ORACLE.TBS.USED.PCT.MAX.WARN}% for 5m).'
                  priority: WARNING
                  dependencies:
                    - name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace usage is too high'
                      expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_file_pct["{#TABLESPACE}"],5m)>{$ORACLE.TBS.USED.PCT.MAX.HIGH}'
                  tags:
                    - tag: scope
                      value: capacity
            - uuid: 5d6293b33a46488c88a75dc898bf7059
              name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace allocated, percent'
              type: DEPENDENT
              key: 'oracle.tbs_used_pct["{#TABLESPACE}"]'
              delay: '0'
              history: 7d
              value_type: FLOAT
              units: '%'
              description: 'Allocated bytes/max bytes*100.'
              preprocessing:
                - type: JSONPATH
                  parameters:
                    - '$..[''{#TABLESPACE}''].used_pct_max.first()'
              master_item:
                key: 'oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#TABLESPACE}","{#CONTENTS}"]'
              tags:
                - tag: component
                  value: tablespaces
                - tag: contents
                  value: '{#CONTENTS}'
                - tag: tablespace
                  value: '{#TABLESPACE}'
              trigger_prototypes:
                - uuid: 2530cb03fb4e4e728396834f0db89466
                  expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_pct["{#TABLESPACE}"],5m)>{$ORACLE.TBS.USED.PCT.MAX.WARN}'
                  name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace utilization is too high'
                  event_name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace utilization is too high (over {$ORACLE.TBS.USED.PCT.MAX.WARN}% for 5m).'
                  priority: WARNING
                  dependencies:
                    - name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace utilization is too high'
                      expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_pct["{#TABLESPACE}"],5m)>{$ORACLE.TBS.UTIL.PCT.MAX.HIGH}'
                  tags:
                    - tag: scope
                      value: capacity
                - uuid: 451108a2251848ea8719378d5c0abb42
                  expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_pct["{#TABLESPACE}"],5m)>{$ORACLE.TBS.UTIL.PCT.MAX.HIGH}'
                  name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace utilization is too high'
                  event_name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace utilization is too high (over {$ORACLE.TBS.UTIL.PCT.MAX.HIGH}% for 5m).'
                  priority: HIGH
                  tags:
                    - tag: scope
                      value: capacity
            - uuid: 97ac4acedcde465b8d004a8ac476dd99
              name: 'Oracle TBS ''{#TABLESPACE}'': Get tablespaces stats'
              key: 'oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#TABLESPACE}","{#CONTENTS}"]'
              history: '0'
              trends: '0'
              value_type: TEXT
              description: 'It gets the statistics of the tablespace.'
              tags:
                - tag: component
                  value: raw
                - tag: component
                  value: tablespaces
          graph_prototypes:
            - uuid: 4b20cce21abb453f9aab0dbce75ff060
              name: 'Oracle TBS ''{#TABLESPACE}'': Tablespace ''{#TABLESPACE}'''
              graph_items:
                - color: 1A7C11
                  item:
                    host: 'Oracle by Zabbix agent 2'
                    key: 'oracle.tbs_alloc_bytes["{#TABLESPACE}"]'
                - sortorder: '1'
                  color: 2774A4
                  item:
                    host: 'Oracle by Zabbix agent 2'
                    key: 'oracle.tbs_max_bytes["{#TABLESPACE}"]'
                - sortorder: '2'
                  color: F63100
                  item:
                    host: 'Oracle by Zabbix agent 2'
                    key: 'oracle.tbs_used_bytes["{#TABLESPACE}"]'
      tags:
        - tag: class
          value: database
        - tag: target
          value: oracle
      macros:
        - macro: '{$ORACLE.ASM.USED.PCT.MAX.HIGH}'
          value: '95'
          description: 'The maximum percentage of used Automatic Storage Management (ASM) disk group for a high trigger expression.'
        - macro: '{$ORACLE.ASM.USED.PCT.MAX.WARN}'
          value: '90'
          description: 'The maximum percentage of used ASM disk group for a warning trigger expression.'
        - macro: '{$ORACLE.CONCURRENCY.MAX.WARN}'
          value: '80'
          description: 'The maximum percentage of sessions concurrency usage for a trigger expression.'
        - macro: '{$ORACLE.CONNSTRING}'
          value: 'tcp://localhost:1521'
        - macro: '{$ORACLE.DB.FILE.MAX.WARN}'
          value: '80'
          description: 'The maximum percentage of used database files for a trigger expression.'
        - macro: '{$ORACLE.DBNAME.MATCHES}'
          value: '.*'
          description: 'This macro is used in discovery of the database. It can be overridden on host level or its linked template level.'
        - macro: '{$ORACLE.DBNAME.NOT_MATCHES}'
          value: PDB\$SEED
          description: 'This macro is used in discovery of the database. It can be overridden on host level or its linked template level.'
        - macro: '{$ORACLE.EXPIRE.PASSWORD.MIN.WARN}'
          value: '7'
          description: 'The number of warning days before the password expires for a trigger expression.'
        - macro: '{$ORACLE.PASSWORD}'
          value: zabbix_password
          description: 'The Oracle user''s password.'
        - macro: '{$ORACLE.PGA.USE.MAX.WARN}'
          value: '90'
          description: 'The maximum percentage of the Program Global Area (PGA) usage that alerts the threshold for a trigger expression.'
        - macro: '{$ORACLE.PROCESSES.MAX.WARN}'
          value: '80'
          description: 'Alert threshold for the maximum percentage of active processes for a trigger expression.'
        - macro: '{$ORACLE.REDO.MIN.WARN}'
          value: '3'
          description: 'Alert threshold for the minimum number of REDO logs for a trigger expression.'
        - macro: '{$ORACLE.SERVICE}'
          value: ORA
          description: 'Oracle Service Name.'
        - macro: '{$ORACLE.SESSION.LOCK.MAX.TIME}'
          value: '600'
          description: 'The maximum duration of the session lock in seconds to count the session as a prolongedly locked query.'
        - macro: '{$ORACLE.SESSION.LONG.LOCK.MAX.WARN}'
          value: '3'
          description: 'Alert threshold for the maximum number of the prolongedly locked sessions for a trigger expression.'
        - macro: '{$ORACLE.SESSIONS.LOCK.MAX.WARN}'
          value: '20'
          description: 'Alert threshold for the maximum percentage of locked sessions for a trigger expression.'
        - macro: '{$ORACLE.SESSIONS.MAX.WARN}'
          value: '80'
          description: 'Alert threshold for the maximum percentage of active sessions for a trigger expression.'
        - macro: '{$ORACLE.SHARED.FREE.MIN.WARN}'
          value: '5'
          description: 'Alert threshold for the minimum percentage of free shared pool for a trigger expression.'
        - macro: '{$ORACLE.TABLESPACE.NAME.MATCHES}'
          value: '.*'
          description: 'This macro is used in tablespace discovery. It can be overridden on host level or its linked template level.'
        - macro: '{$ORACLE.TABLESPACE.NAME.NOT_MATCHES}'
          value: CHANGE_IF_NEEDED
          description: 'This macro is used in tablespace discovery. It can be overridden on host level or its linked template level.'
        - macro: '{$ORACLE.TBS.USED.PCT.MAX.HIGH}'
          value: '95'
          description: 'High severity alert threshold for the maximum percentage of tablespace usage (used bytes/allocated bytes) for a trigger expression.'
        - macro: '{$ORACLE.TBS.USED.PCT.MAX.WARN}'
          value: '90'
          description: 'Warning severity alert threshold for the maximum percentage of tablespace usage (used bytes/allocated bytes) for a trigger expression.'
        - macro: '{$ORACLE.TBS.UTIL.PCT.MAX.HIGH}'
          value: '90'
          description: 'High severity alert threshold for the maximum percentage of tablespace utilization (allocated bytes/max bytes) for a trigger expression.'
        - macro: '{$ORACLE.TBS.UTIL.PCT.MAX.WARN}'
          value: '80'
          description: 'Warning severity alert threshold for the maximum percentage of tablespace utilization (allocated bytes/max bytes) for a trigger expression.'
        - macro: '{$ORACLE.USER}'
          value: zabbix
          description: 'Oracle username.'
      valuemaps:
        - uuid: 5a90da8dd6124159a7f82a7a996f0a53
          name: 'Oracle Archivelog status'
          mappings:
            - value: '0'
              newvalue: Unknown
            - value: '1'
              newvalue: Error
            - value: '2'
              newvalue: Deferred
            - value: '3'
              newvalue: Valid
        - uuid: f39e64058fef423bb858ba45834a3455
          name: 'Oracle archiver state'
          mappings:
            - value: '0'
              newvalue: Unknown
            - value: '1'
              newvalue: Stopped
            - value: '2'
              newvalue: Started
            - value: '3'
              newvalue: Failed
        - uuid: 015a0c94ba2644c6aa343d3f792a4072
          name: 'Oracle DB open status'
          mappings:
            - value: '0'
              newvalue: Unknown
            - value: '1'
              newvalue: Mounted
            - value: '2'
              newvalue: 'Read Only'
            - value: '3'
              newvalue: Read-Write
            - value: '4'
              newvalue: 'Read Only with Apply'
        - uuid: afade10cda4e453982355342ba9d8d9f
          name: 'Oracle DB role'
          mappings:
            - value: '0'
              newvalue: Unknown
            - value: '1'
              newvalue: 'Snapshot standby'
            - value: '2'
              newvalue: 'Logical standby'
            - value: '3'
              newvalue: 'Physical standby'
            - value: '4'
              newvalue: Primary
            - value: '5'
              newvalue: 'Far sync'
        - uuid: 1d9f4a44f2f94a799768f147cb712331
          name: 'Oracle force log status'
          mappings:
            - value: '0'
              newvalue: 'No'
            - value: '1'
              newvalue: 'Yes'
        - uuid: 53d97b73db8449959420e03114d345c3
          name: 'Oracle instance role'
          mappings:
            - value: '0'
              newvalue: Unknown
            - value: '1'
              newvalue: Primary
            - value: '2'
              newvalue: Secondary
        - uuid: 4893318c780f47719e12e839c9a846c2
          name: 'Oracle instance status'
          mappings:
            - value: '0'
              newvalue: Unknown
            - value: '1'
              newvalue: Started
            - value: '2'
              newvalue: Mounted
            - value: '3'
              newvalue: Open
            - value: '4'
              newvalue: 'Open migrate'
        - uuid: 910dd4a87f75434289fa2e345778d18d
          name: 'Oracle log mode'
          mappings:
            - value: '0'
              newvalue: NOARCHIVELOG
            - value: '1'
              newvalue: ARCHIVELOG
            - value: '2'
              newvalue: MANUAL
        - uuid: f14ed94cf12740a19e221ddaa4855c54
          name: 'Oracle tablespace status'
          mappings:
            - value: '0'
              newvalue: Unknown
            - value: '1'
              newvalue: Online
            - value: '2'
              newvalue: Offline
            - value: '3'
              newvalue: Read-Only
        - uuid: 31c489581d8b4246942c663b88fbaf9f
          name: 'Service state'
          mappings:
            - value: '0'
              newvalue: Down
            - value: '1'
              newvalue: Up
  triggers:
    - uuid: 3f265c15b3d042d79b1aa598f7249738
      expression: 'min(/Oracle by Zabbix agent 2/oracle.proc.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"],5m) * 100 / last(/Oracle by Zabbix agent 2/oracle.processes_limit) > {$ORACLE.PROCESSES.MAX.WARN}'
      name: 'Oracle: Too many active processes'
      event_name: 'Oracle: Too many active processes (over {$ORACLE.PROCESSES.MAX.WARN}% for 5 min)'
      priority: WARNING
      description: 'Active processes are using more than {$ORACLE.PROCESSES.MAX.WARN}% of the available number of processes.'
      tags:
        - tag: scope
          value: capacity
    - uuid: d9977c48c6e7435eafde4cabc43bb5fc
      expression: 'min(/Oracle by Zabbix agent 2/oracle.session_count,5m) * 100 / last(/Oracle by Zabbix agent 2/oracle.session_limit) > {$ORACLE.SESSIONS.MAX.WARN}'
      name: 'Oracle: Too many active sessions'
      event_name: 'Oracle: Too many active sessions (over {$ORACLE.SESSIONS.MAX.WARN}% for 5 min)'
      priority: WARNING
      description: 'Active sessions are using more than {$ORACLE.SESSIONS.MAX.WARN}% of the available sessions.'
      tags:
        - tag: scope
          value: capacity
    - uuid: 362882973d0b45d1a09a687353734032
      expression: 'min(/Oracle by Zabbix agent 2/oracle.datafiles.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"],5m) * 100 / last(/Oracle by Zabbix agent 2/oracle.db_files_limit) > {$ORACLE.DB.FILE.MAX.WARN}'
      name: 'Oracle: Too many database files'
      event_name: 'Oracle: Too many database files (over {$ORACLE.DB.FILE.MAX.WARN}% for 5 min)'
      priority: WARNING
      description: 'The number of datafiles is higher than {$ORACLE.DB.FILE.MAX.WARN}% of the available datafiles limit.'
      tags:
        - tag: scope
          value: capacity
    - uuid: aecb78fc9a7549f2b8e68325530bcd99
      expression: 'min(/Oracle by Zabbix agent 2/oracle.total_pga_used,5m) * 100 / last(/Oracle by Zabbix agent 2/oracle.pga_target) > {$ORACLE.PGA.USE.MAX.WARN}'
      name: 'Oracle: Total PGA inuse is too high'
      event_name: 'Oracle: Total PGA inuse is too high (over {$ORACLE.PGA.USE.MAX.WARN}% for 5 min)'
      priority: WARNING
      description: 'The total PGA in use is more than {$ORACLE.PGA.USE.MAX.WARN}% of PGA_AGGREGATE_TARGET.'
      tags:
        - tag: scope
          value: capacity
  graphs:
    - uuid: 292f08d249d344db882a3447cc268ca6
      name: 'Oracle: Datafiles'
      graph_items:
        - color: 1A7C11
          item:
            host: 'Oracle by Zabbix agent 2'
            key: 'oracle.datafiles.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
        - sortorder: '1'
          color: 2774A4
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.db_files_limit
    - uuid: 4b4d2430750c4885b4764c3b602dc091
      name: 'Oracle: PGA'
      graph_items:
        - color: 1A7C11
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.total_pga_used
        - sortorder: '1'
          color: 2774A4
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.pga_target
        - sortorder: '2'
          color: F63100
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.total_pga_allocated
    - uuid: 4e02f667b98042f6ac538692a074a982
      name: 'Oracle: Physical Read\Write Rate'
      graph_items:
        - color: 1A7C11
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.physical_writes_rate
        - sortorder: '1'
          color: 2774A4
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.physical_reads_rate
    - uuid: 2bfd6cda93da4201a73c3d16caea8284
      name: 'Oracle: Physical Read\Write Rate, Bytes'
      graph_items:
        - color: 1A7C11
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.physical_write_bytes_rate
        - sortorder: '1'
          color: 2774A4
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.physical_read_bytes_rate
    - uuid: e51ad4ba7cca491faf7564a8d26bc1da
      name: 'Oracle: Processes'
      graph_items:
        - color: 1A7C11
          item:
            host: 'Oracle by Zabbix agent 2'
            key: 'oracle.proc.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
        - sortorder: '1'
          color: 2774A4
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.processes_limit
    - uuid: 3323be96dd454a92ade913ab6c2b589c
      name: 'Oracle: Sessions'
      graph_items:
        - color: 1A7C11
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.session_count
        - sortorder: '1'
          color: 2774A4
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.session_active_background
        - sortorder: '2'
          color: F63100
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.session_inactive_user
        - sortorder: '3'
          color: A54F10
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.session_active_user
        - sortorder: '4'
          color: FC6EA3
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.session_limit
    - uuid: ad7c9a7b4c7a4b4885cb1e91e7e79d3d
      name: 'Oracle: SGA Memory Usage'
      type: STACKED
      graph_items:
        - color: 1A7C11
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.sga_java_pool
        - sortorder: '1'
          color: 2774A4
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.sga_large_pool
        - sortorder: '2'
          color: F63100
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.sga_shared_pool
        - sortorder: '3'
          color: A54F10
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.sga_log_buffer
        - sortorder: '4'
          color: FC6EA3
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.sga_fixed
        - sortorder: '5'
          color: 6C59DC
          item:
            host: 'Oracle by Zabbix agent 2'
            key: oracle.sga_buffer_cache
