Files
templates-default/Oracle_by_Zabbix_agent_2.yaml

2585 lines
112 KiB
YAML

zabbix_export:
version: '7.0'
template_groups:
- uuid: 748ad4d098d447d492bb935c907f652f
name: Templates/Databases
templates:
- uuid: d670c32f007d438c9dcd32db57d2b691
template: 'Oracle by Zabbix agent 2'
name: 'Oracle by Zabbix agent 2'
description: |
Get metrics from Oracle Database using Zabbix agent 2.
Generated by official Zabbix template tool "Templator"
vendor:
name: Zabbix
version: 7.0-2
groups:
- name: Templates/Databases
items:
- uuid: 9d24ae0f86d54b73a35d9c15d4e082cb
name: 'Active parallel sessions'
type: DEPENDENT
key: oracle.active_parallel_sessions
delay: '0'
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: 'Active serial sessions'
type: DEPENDENT
key: oracle.active_serial_sessions
delay: '0'
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: 'Average active sessions'
type: DEPENDENT
key: oracle.active_sessions
delay: '0'
value_type: FLOAT
description: 'The average number of active sessions at a point in time 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: 'Archiver state'
type: DEPENDENT
key: oracle.archiver_state
delay: '0'
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: 'Buffer cache hit ratio'
type: DEPENDENT
key: oracle.buffer_cache_hit_ratio
delay: '0'
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: 'Global cache blocks corrupted'
type: DEPENDENT
key: oracle.cache_blocks_corrupt
delay: '0'
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: 'Global cache blocks lost'
type: DEPENDENT
key: oracle.cache_blocks_lost
delay: '0'
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: 'Cursor cache hit ratio'
type: DEPENDENT
key: oracle.cursor_cache_hit_ratio
delay: '0'
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: 'Database CPU time ratio'
type: DEPENDENT
key: oracle.database_cpu_time_ratio
delay: '0'
value_type: FLOAT
units: '%'
description: 'The ratio 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: 'Database wait time ratio'
type: DEPENDENT
key: oracle.database_wait_time_ratio
delay: '0'
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: 'Datafiles count'
key: 'oracle.datafiles.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
description: 'The current number of datafiles.'
preprocessing:
- type: JSONPATH
parameters:
- $.datafile_num
tags:
- tag: component
value: datafiles
- uuid: cdd3d4f1baea4f2ea122e058704d43e9
name: 'Datafiles limit'
type: DEPENDENT
key: oracle.db_files_limit
delay: '0'
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: 'Disk sort per second'
type: DEPENDENT
key: oracle.disk_sorts
delay: '0'
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: 'Enqueue timeouts per second'
type: DEPENDENT
key: oracle.enqueue_timeouts_rate
delay: '0'
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: 'Get FRA stats'
key: 'oracle.fra.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
history: '0'
value_type: TEXT
trends: '0'
description: 'Get FRA statistics.'
tags:
- tag: component
value: raw
- uuid: 5e09413cb3a14a3a87e2ead6b838ce1f
name: 'FRA, Number of files'
type: DEPENDENT
key: oracle.fra_number_of_files
delay: '0'
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: 'FRA, Number of restore points'
type: DEPENDENT
key: oracle.fra_restore_point
delay: '0'
value_type: FLOAT
description: 'Number of restore points in the FRA.'
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: 'FRA, Space limit'
type: DEPENDENT
key: oracle.fra_space_limit
delay: '0'
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: 'FRA, Space reclaimable'
type: DEPENDENT
key: oracle.fra_space_reclaimable
delay: '0'
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: 'FRA, Used space'
type: DEPENDENT
key: oracle.fra_space_used
delay: '0'
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: 'FRA, Usable space in %'
type: DEPENDENT
key: oracle.fra_usable_pct
delay: '0'
value_type: FLOAT
units: '%'
description: 'Percentage of space usable in the FRA.'
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: 'GC CR block received per second'
type: DEPENDENT
key: oracle.gc_cr_block_received_rate
delay: '0'
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: 'Get instance state'
key: 'oracle.instance.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
history: '0'
value_type: TEXT
trends: '0'
description: 'Gets the state of the current instance.'
tags:
- tag: component
value: application
- uuid: 021a98326c8f402693e4fba9fb3c25de
name: 'Instance role'
type: DEPENDENT
key: oracle.instance.role
delay: '0'
description: '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: 'Instance hostname'
type: DEPENDENT
key: oracle.instance_hostname
delay: '0'
value_type: CHAR
trends: '0'
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: 'An Oracle Database instance hostname has changed. Acknowledge to close the problem manually.'
manual_close: 'YES'
tags:
- tag: scope
value: notice
- uuid: 0cc90c2554a7412eafe42c33dd1e9ede
name: 'Instance name'
type: DEPENDENT
key: oracle.instance_name
delay: '0'
value_type: CHAR
trends: '0'
description: 'The name of the 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: 'An Oracle Database instance name has changed. Acknowledge to close the problem manually.'
manual_close: 'YES'
tags:
- tag: scope
value: notice
- uuid: f51053d243ef41089b5e635fd1abb5f3
name: 'Instance status'
type: DEPENDENT
key: oracle.instance_status
delay: '0'
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: 'Library cache hit ratio'
type: DEPENDENT
key: oracle.library_cache_hit_ratio
delay: '0'
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: 'Logons per second'
type: DEPENDENT
key: oracle.logons_rate
delay: '0'
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: 'Long table scans per second'
type: DEPENDENT
key: oracle.long_table_scans_rate
delay: '0'
value_type: FLOAT
units: Rps
description: 'The number of long table scans per second. A table is considered long if it 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: 'Memory sorts ratio'
type: DEPENDENT
key: oracle.memory_sorts_ratio
delay: '0'
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: 'Get PGA stats'
key: 'oracle.pga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
history: '0'
value_type: TEXT
trends: '0'
description: 'Get PGA statistics.'
tags:
- tag: component
value: raw
- uuid: 749a1281ba84475193897a3362f6f873
name: 'PGA, Global memory bound'
type: DEPENDENT
key: oracle.pga_global_bound
delay: '0'
units: B
description: 'The maximum size of a 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: 'PGA, Aggregate target parameter'
type: DEPENDENT
key: oracle.pga_target
delay: '0'
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: 'Physical reads per second'
type: DEPENDENT
key: oracle.physical_reads_rate
delay: '0'
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: 'Physical reads bytes per second'
type: DEPENDENT
key: oracle.physical_read_bytes_rate
delay: '0'
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: 'Physical writes per second'
type: DEPENDENT
key: oracle.physical_writes_rate
delay: '0'
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: 'Physical writes bytes per second'
type: DEPENDENT
key: oracle.physical_write_bytes_rate
delay: '0'
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: Ping
key: 'oracle.ping["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
delay: 30s
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: 'Number of processes'
key: 'oracle.proc.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
description: 'The current number of user processes.'
preprocessing:
- type: JSONPATH
parameters:
- $.proc_num
tags:
- tag: component
value: system
- uuid: cdb59700d4a24fb3bea9d2b63d5d7938
name: 'Processes limit'
type: DEPENDENT
key: oracle.processes_limit
delay: '0'
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: 'Redo logs available to switch'
key: 'oracle.redolog.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
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 (risk of database downtime).'
tags:
- tag: scope
value: capacity
- uuid: e8aca0dfd1d74d3b9b042d3ed3070e42
name: 'Rows per sort'
type: DEPENDENT
key: oracle.rows_per_sort
delay: '0'
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: 'SQL service response time'
type: DEPENDENT
key: oracle.service_response_time
delay: '0'
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: 'Get sessions stats'
key: 'oracle.sessions.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{$ORACLE.SESSION.LOCK.MAX.TIME}"]'
history: '0'
value_type: TEXT
trends: '0'
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: 'Active background sessions'
type: DEPENDENT
key: oracle.session_active_background
delay: '0'
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: 'Active user sessions'
type: DEPENDENT
key: oracle.session_active_user
delay: '0'
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: 'Sessions concurrency'
type: DEPENDENT
key: oracle.session_concurrency_rate
delay: '0'
value_type: FLOAT
units: '%'
description: 'The percentage of concurrency. Concurrency is a database 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, and the rest of the transactions wait for access. When the access to a resource is locked for a long time, the concurrency grows (like the transaction queue), often leaving an extremely negative impact on 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 is a signal to review resource consumption (determine the "heaviest" queries in the database, trace sessions, etc.) This will help find the root cause and possible optimization points both in database configuration and the logic of building queries.'
tags:
- tag: scope
value: performance
- uuid: cfd7559ac25e4c0a837048e675f4d995
name: 'Session count'
type: DEPENDENT
key: oracle.session_count
delay: '0'
value_type: FLOAT
description: 'The session count.'
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: 'Inactive user sessions'
type: DEPENDENT
key: oracle.session_inactive_user
delay: '0'
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: 'Sessions limit'
type: DEPENDENT
key: oracle.session_limit
delay: '0'
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: 'Sessions lock rate'
type: DEPENDENT
key: oracle.session_lock_rate
delay: '0'
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: 'Sessions locked over {$ORACLE.SESSION.LOCK.MAX.TIME}s'
type: DEPENDENT
key: oracle.session_long_time_locked
delay: '0'
value_type: FLOAT
description: 'The count of the prolongedly locked sessions. (You can change the duration of the maximum session lock in seconds for a query using the `{$ORACLE.SESSION.LOCK.MAX.TIME}` macro. Default = 600 s).'
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: 'Get SGA stats'
key: 'oracle.sga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
history: '0'
value_type: TEXT
trends: '0'
description: 'Get SGA statistics.'
tags:
- tag: component
value: raw
- uuid: 7ad06a6ccb834c5c95f30c319a48446c
name: 'SGA, buffer cache'
type: DEPENDENT
key: oracle.sga_buffer_cache
delay: '0'
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: 'SGA, fixed'
type: DEPENDENT
key: oracle.sga_fixed
delay: '0'
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: 'SGA, java pool'
type: DEPENDENT
key: oracle.sga_java_pool
delay: '0'
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: 'SGA, large pool'
type: DEPENDENT
key: oracle.sga_large_pool
delay: '0'
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: 'SGA, log buffer'
type: DEPENDENT
key: oracle.sga_log_buffer
delay: '0'
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: 'SGA, shared pool'
type: DEPENDENT
key: oracle.sga_shared_pool
delay: '0'
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: 'Shared pool free %'
type: DEPENDENT
key: oracle.shared_pool_free
delay: '0'
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: 'Total sorts per user call'
type: DEPENDENT
key: oracle.sorts_per_user_call
delay: '0'
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: 'Get system metrics'
key: 'oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
delay: 0;m0-59
history: '0'
value_type: TEXT
trends: '0'
description: 'Gets the values of the system metrics.'
tags:
- tag: component
value: raw
- uuid: d59cca864e8044d89f9b4689ec712511
name: 'Get system parameters'
key: 'oracle.sys.params["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
history: '0'
value_type: TEXT
trends: '0'
description: 'Get a set of system parameter values.'
tags:
- tag: component
value: raw
- uuid: 48f54a0324a64e80aaf22d5cd26798cd
name: 'Temp space used'
type: DEPENDENT
key: oracle.temp_space_used
delay: '0'
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: 'PGA, Total allocated'
type: DEPENDENT
key: oracle.total_pga_allocated
delay: '0'
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: 'PGA, Total freeable'
type: DEPENDENT
key: oracle.total_pga_freeable
delay: '0'
units: B
description: 'The number of bytes of the PGA memory in all processes that could be freed back to the OS.'
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: 'PGA, Total inuse'
type: DEPENDENT
key: oracle.total_pga_used
delay: '0'
units: B
description: 'The amount of Program Global Area (PGA) memory 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: Uptime
type: DEPENDENT
key: oracle.uptime
delay: '0'
trends: '0'
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: 'Uptime is less than 10 minutes.'
manual_close: 'YES'
tags:
- tag: scope
value: notice
- uuid: 73ff311f3d5c4e93b5919f5633fc09f9
name: 'User''s expire password'
key: 'oracle.user.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
value_type: FLOAT
units: days
description: 'The number of days before the Zabbix account password 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 the Zabbix user in the database expires soon.'
tags:
- tag: scope
value: notice
- uuid: cec9a53d637e42c79e2a838588ceeaca
name: 'User rollbacks per second'
type: DEPENDENT
key: oracle.user_rollbacks_rate
delay: '0'
value_type: FLOAT
units: Rps
description: 'The number of times that users manually issued 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: Version
key: 'oracle.version["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
delay: 15m
value_type: CHAR
trends: '0'
description: 'The Oracle Server version.'
preprocessing:
- type: DISCARD_UNCHANGED_HEARTBEAT
parameters:
- 12h
tags:
- tag: component
value: application
triggers:
- uuid: 4a68bcb6149c4c839e263c949343add8
expression: 'last(/Oracle by Zabbix agent 2/oracle.version["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"],#1)<>last(/Oracle by Zabbix agent 2/oracle.version["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"],#2) and length(last(/Oracle by Zabbix agent 2/oracle.version["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]))>0'
name: 'Oracle: Version has changed'
event_name: 'Oracle: Version has changed (new version value received: {ITEM.VALUE})'
priority: INFO
description: 'The Oracle Database version has changed. Acknowledge to close the problem 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'
value_type: TEXT
trends: '0'
description: 'Gets the archive log 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'
value_type: TEXT
trends: '0'
description: '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'
description: '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'
description: |
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: 'Oracle: 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: 'Database ''{#DBNAME}'': Get CDB and No-CDB info'
key: 'oracle.cdb.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#DBNAME}"]'
history: '0'
value_type: TEXT
trends: '0'
description: 'Gets the information about the CDB and non-CDB database on an instance.'
tags:
- tag: component
value: cdb
- tag: component
value: raw
- uuid: d9d1575b767b46e0aefe65a270f2d01b
name: 'Database ''{#DBNAME}'': Force logging'
type: DEPENDENT
key: 'oracle.db_force_logging["{#DBNAME}"]'
delay: '0'
description: 'Indicates whether the database is under force logging mode (`YES`/`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: 'Database ''{#DBNAME}'': Log mode'
type: DEPENDENT
key: 'oracle.db_log_mode["{#DBNAME}"]'
delay: '0'
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: 'Database ''{#DBNAME}'': Open status'
type: DEPENDENT
key: 'oracle.db_open_mode["{#DBNAME}"]'
delay: '0'
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 Database open status has changed. Acknowledge to close the problem 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 Database is in a mounted state.'
tags:
- tag: scope
value: notice
- uuid: 560b010dcdfc445cbd4e266b88b60e24
name: 'Database ''{#DBNAME}'': Role'
type: DEPENDENT
key: 'oracle.db_role["{#DBNAME}"]'
delay: '0'
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 Database role has changed. Acknowledge to close the problem 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 is a very important metric for databases in `ARCHIVELOG`. This feature allows to forcibly write all the transactions to the redo log.'
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'
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'
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}'': Used size, percent'
type: DEPENDENT
key: 'oracle.asm_used_pct["{#DGNAME}"]'
delay: '0'
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: 'Oracle: ASM ''{#DGNAME}'': Disk group usage is too high'
event_name: 'Oracle: 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: 'Oracle: ASM ''{#DGNAME}'': Disk group usage is too high'
event_name: 'Oracle: 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: 'Oracle: 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'
value_type: TEXT
trends: '0'
description: '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: 199C0D
item:
host: 'Oracle by Zabbix agent 2'
key: 'oracle.asm_free_size["{#DGNAME}"]'
- sortorder: '1'
color: F63100
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: 'Database ''{#DBNAME}'': Get PDB info'
key: 'oracle.pdb.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#CON_ID}"]'
history: '0'
value_type: TEXT
trends: '0'
description: 'Gets the information about the PDB database on an instance.'
tags:
- tag: component
value: pdb
- tag: component
value: raw
- uuid: c52e96105cea45cea1b18201b325ba53
name: 'Database ''{#DBNAME}'': Open status'
type: DEPENDENT
key: 'oracle.pdb_open_mode["{#CON_ID}"]'
delay: '0'
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}","{#CON_ID}"]'
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["{#CON_ID}"],#1)<>last(/Oracle by Zabbix agent 2/oracle.pdb_open_mode["{#CON_ID}"],#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 Database open status has changed. Acknowledge to close the problem manually.'
manual_close: 'YES'
tags:
- tag: scope
value: notice
- uuid: a6921cc3b42843dcb5624b3bb172f996
expression: 'last(/Oracle by Zabbix agent 2/oracle.pdb_open_mode["{#CON_ID}"])=1'
name: 'Oracle: Database ''{#DBNAME}'': Open status in mount mode'
priority: WARNING
description: 'The Oracle Database 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: '{#CON_NAME}'
value: '{$ORACLE.TABLESPACE.CONTAINER.MATCHES}'
formulaid: A
- macro: '{#CON_NAME}'
value: '{$ORACLE.TABLESPACE.CONTAINER.NOT_MATCHES}'
operator: NOT_MATCHES_REGEX
formulaid: B
- macro: '{#TABLESPACE}'
value: '{$ORACLE.TABLESPACE.NAME.MATCHES}'
formulaid: C
- macro: '{#TABLESPACE}'
value: '{$ORACLE.TABLESPACE.NAME.NOT_MATCHES}'
operator: NOT_MATCHES_REGEX
formulaid: D
description: 'Scanning tablespaces in DBMS.'
item_prototypes:
- uuid: 14a26a84cfe947089843ed93cd7707c8
name: '''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace allocated, bytes'
type: DEPENDENT
key: 'oracle.tbs_alloc_bytes["{#CON_ID}","{#TABLESPACE}"]'
delay: '0'
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}","{#CON_ID}"]'
tags:
- tag: component
value: tablespaces
- tag: contents
value: '{#CONTENTS}'
- tag: database
value: '{#CON_NAME}'
- tag: tablespace
value: '{#TABLESPACE}'
- uuid: d7263b6da6c04c7798909a8448f526ab
name: '''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace free, bytes'
type: DEPENDENT
key: 'oracle.tbs_free_bytes["{#CON_ID}","{#TABLESPACE}"]'
delay: '0'
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}","{#CON_ID}"]'
tags:
- tag: component
value: tablespaces
- tag: contents
value: '{#CONTENTS}'
- tag: database
value: '{#CON_NAME}'
- tag: tablespace
value: '{#TABLESPACE}'
- uuid: d2d919d303b244829c797245e08c2fe5
name: '''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace MAX size, bytes'
type: DEPENDENT
key: 'oracle.tbs_max_bytes["{#CON_ID}","{#TABLESPACE}"]'
delay: '0'
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}","{#CON_ID}"]'
tags:
- tag: component
value: tablespaces
- tag: contents
value: '{#CONTENTS}'
- tag: database
value: '{#CON_NAME}'
- tag: tablespace
value: '{#TABLESPACE}'
- uuid: de6892ac5ca4499db01dd02c0444aafc
name: '''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Open status'
type: DEPENDENT
key: 'oracle.tbs_status["{#CON_ID}","{#TABLESPACE}"]'
delay: '0'
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}","{#CON_ID}"]'
tags:
- tag: component
value: tablespaces
- tag: contents
value: '{#CONTENTS}'
- tag: database
value: '{#CON_NAME}'
- tag: tablespace
value: '{#TABLESPACE}'
trigger_prototypes:
- uuid: 832f908ca3b84a3c9a030b5d33b96016
expression: 'last(/Oracle by Zabbix agent 2/oracle.tbs_status["{#CON_ID}","{#TABLESPACE}"])=2'
name: 'Oracle: ''{#CON_NAME}'' 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["{#CON_ID}","{#TABLESPACE}"],#1)<>last(/Oracle by Zabbix agent 2/oracle.tbs_status["{#CON_ID}","{#TABLESPACE}"],#2)'
name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace status has changed'
event_name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace status has changed (new value received: {ITEM.VALUE})'
priority: INFO
description: 'Oracle tablespace status has changed. Acknowledge to close the problem manually.'
manual_close: 'YES'
dependencies:
- name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace is OFFLINE'
expression: 'last(/Oracle by Zabbix agent 2/oracle.tbs_status["{#CON_ID}","{#TABLESPACE}"])=2'
tags:
- tag: scope
value: notice
- uuid: ab56fee407e143db912dffcf24fb0106
name: '''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace used, bytes'
type: DEPENDENT
key: 'oracle.tbs_used_bytes["{#CON_ID}","{#TABLESPACE}"]'
delay: '0'
units: B
description: 'Currently used bytes for the tablespace (current size of datafiles minus 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}","{#CON_ID}"]'
tags:
- tag: component
value: tablespaces
- tag: contents
value: '{#CONTENTS}'
- tag: database
value: '{#CON_NAME}'
- tag: tablespace
value: '{#TABLESPACE}'
- uuid: 358615a3e372462e9cec05df1df22743
name: '''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace usage, percent'
type: DEPENDENT
key: 'oracle.tbs_used_file_pct["{#CON_ID}","{#TABLESPACE}"]'
delay: '0'
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}","{#CON_ID}"]'
tags:
- tag: component
value: tablespaces
- tag: contents
value: '{#CONTENTS}'
- tag: database
value: '{#CON_NAME}'
- tag: tablespace
value: '{#TABLESPACE}'
trigger_prototypes:
- uuid: bbc86236064348ee9150dfdd07623061
expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_file_pct["{#CON_ID}","{#TABLESPACE}"],5m)>{$ORACLE.TBS.USED.PCT.MAX.HIGH}'
name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace usage is too high'
event_name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace usage is too high (over {$ORACLE.TBS.USED.PCT.MAX.HIGH}% for 5m).'
priority: HIGH
description: 'The usage of the tablespace `{#TABLESPACE}` exceeds `{$ORACLE.TBS.USED.PCT.MAX.HIGH}`%'
tags:
- tag: scope
value: capacity
- uuid: ba298d35aaaa4386b4f03914dcf1cb27
expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_file_pct["{#CON_ID}","{#TABLESPACE}"],5m)>{$ORACLE.TBS.USED.PCT.MAX.WARN}'
name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace usage is too high'
event_name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace usage is too high (over {$ORACLE.TBS.USED.PCT.MAX.WARN}% for 5m).'
priority: WARNING
description: 'The usage of the tablespace `{#TABLESPACE}` exceeds `{$ORACLE.TBS.USED.PCT.MAX.WARN}`%'
dependencies:
- name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace usage is too high'
expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_file_pct["{#CON_ID}","{#TABLESPACE}"],5m)>{$ORACLE.TBS.USED.PCT.MAX.HIGH}'
tags:
- tag: scope
value: capacity
- uuid: 93f6abb8363e4ee2ad2801090cf006b0
name: '''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace usage from MAX, percent'
type: DEPENDENT
key: 'oracle.tbs_used_from_max_pct["{#CON_ID}","{#TABLESPACE}"]'
delay: '0'
value_type: FLOAT
units: '%'
description: 'Used bytes/max bytes*100.'
preprocessing:
- type: JSONPATH
parameters:
- '$..[''{#TABLESPACE}''].used_from_max_pct.first()'
master_item:
key: 'oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#TABLESPACE}","{#CONTENTS}","{#CON_ID}"]'
tags:
- tag: component
value: tablespaces
- tag: contents
value: '{#CONTENTS}'
- tag: database
value: '{#CON_NAME}'
- tag: tablespace
value: '{#TABLESPACE}'
trigger_prototypes:
- uuid: dd246e51d0b343f0b18b18dc802dfbc2
expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_from_max_pct["{#CON_ID}","{#TABLESPACE}"],5m)>{$ORACLE.TBS.USED.PCT.FROM.MAX.WARN}'
name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace usage from MAX is too high'
event_name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace utilization from MAX is too high (over {$ORACLE.TBS.USED.PCT.FROM.MAX.WARN}% for 5m).'
priority: WARNING
description: 'The usage of the tablespace `{#TABLESPACE}` from MAX exceeds `{$ORACLE.TBS.USED.PCT.FROM.MAX.WARN}`%'
dependencies:
- name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace utilization from MAX is too high'
expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_from_max_pct["{#CON_ID}","{#TABLESPACE}"],5m)>{$ORACLE.TBS.USED.PCT.FROM.MAX.HIGH}'
tags:
- tag: scope
value: capacity
- uuid: a82c07893e04440ea9c0e5e7f8f79602
expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_from_max_pct["{#CON_ID}","{#TABLESPACE}"],5m)>{$ORACLE.TBS.USED.PCT.FROM.MAX.HIGH}'
name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace utilization from MAX is too high'
event_name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace utilization from MAX is too high (over {$ORACLE.TBS.USED.PCT.FROM.MAX.HIGH}% for 5m).'
priority: HIGH
description: 'The usage of the tablespace `{#TABLESPACE}` from MAX exceeds `{$ORACLE.TBS.USED.PCT.FROM.MAX.HIGH}`%'
tags:
- tag: scope
value: capacity
- uuid: 5d6293b33a46488c88a75dc898bf7059
name: '''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace allocated, percent'
type: DEPENDENT
key: 'oracle.tbs_used_pct["{#CON_ID}","{#TABLESPACE}"]'
delay: '0'
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}","{#CON_ID}"]'
tags:
- tag: component
value: tablespaces
- tag: contents
value: '{#CONTENTS}'
- tag: database
value: '{#CON_NAME}'
- tag: tablespace
value: '{#TABLESPACE}'
trigger_prototypes:
- uuid: 451108a2251848ea8719378d5c0abb42
expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_pct["{#CON_ID}","{#TABLESPACE}"],5m)>{$ORACLE.TBS.UTIL.PCT.MAX.HIGH}'
name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace utilization is too high'
event_name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace utilization is too high (over {$ORACLE.TBS.UTIL.PCT.MAX.HIGH}% for 5m).'
priority: HIGH
description: 'The utilization of the tablespace `{#TABLESPACE}` exceeds `{$ORACLE.TBS.UTIL.PCT.MAX.HIGH}`%'
tags:
- tag: scope
value: capacity
- uuid: 2530cb03fb4e4e728396834f0db89466
expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_pct["{#CON_ID}","{#TABLESPACE}"],5m)>{$ORACLE.TBS.UTIL.PCT.MAX.WARN}'
name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace utilization is too high'
event_name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace utilization is too high (over {$ORACLE.TBS.UTIL.PCT.MAX.WARN}% for 5m).'
priority: WARNING
description: 'The utilization of the tablespace `{#TABLESPACE}` exceeds `{$ORACLE.TBS.UTIL.PCT.MAX.WARN}`%'
dependencies:
- name: 'Oracle: ''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace utilization is too high'
expression: 'min(/Oracle by Zabbix agent 2/oracle.tbs_used_pct["{#CON_ID}","{#TABLESPACE}"],5m)>{$ORACLE.TBS.UTIL.PCT.MAX.HIGH}'
tags:
- tag: scope
value: capacity
- uuid: 97ac4acedcde465b8d004a8ac476dd99
name: '''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Get tablespaces stats'
key: 'oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#TABLESPACE}","{#CONTENTS}","{#CON_ID}"]'
history: '0'
value_type: TEXT
trends: '0'
description: 'Gets the statistics of the tablespace.'
tags:
- tag: component
value: raw
- tag: component
value: tablespaces
graph_prototypes:
- uuid: 4b20cce21abb453f9aab0dbce75ff060
name: '''{#CON_NAME}'' TBS ''{#TABLESPACE}'': Tablespace ''{#TABLESPACE}'''
graph_items:
- color: 199C0D
item:
host: 'Oracle by Zabbix agent 2'
key: 'oracle.tbs_alloc_bytes["{#CON_ID}","{#TABLESPACE}"]'
- sortorder: '1'
color: F63100
item:
host: 'Oracle by Zabbix agent 2'
key: 'oracle.tbs_max_bytes["{#CON_ID}","{#TABLESPACE}"]'
- sortorder: '2'
color: 00611C
item:
host: 'Oracle by Zabbix agent 2'
key: 'oracle.tbs_used_bytes["{#CON_ID}","{#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 space in the Automatic Storage Management (ASM) disk group for the High trigger expression.'
- macro: '{$ORACLE.ASM.USED.PCT.MAX.WARN}'
value: '90'
description: 'The maximum percentage of used space in the Automatic Storage Management (ASM) disk group for the Warning trigger expression.'
- macro: '{$ORACLE.CONCURRENCY.MAX.WARN}'
value: '80'
description: 'The maximum percentage of session concurrency for the Warning trigger expression.'
- macro: '{$ORACLE.CONNSTRING}'
value: 'tcp://localhost:1521'
description: 'Oracle URI or a session name.'
- macro: '{$ORACLE.DB.FILE.MAX.WARN}'
value: '80'
description: 'The maximum percentage of used database files for the Warning trigger expression.'
- macro: '{$ORACLE.DBNAME.MATCHES}'
value: '.*'
description: 'Used in database discovery. It can be overridden on the host or linked template level.'
- macro: '{$ORACLE.DBNAME.NOT_MATCHES}'
value: PDB\$SEED
description: 'Used in database discovery. It can be overridden on the host or linked template level.'
- macro: '{$ORACLE.EXPIRE.PASSWORD.MIN.WARN}'
value: '7'
description: 'The number of days before the password expires for the Warning trigger expression.'
- macro: '{$ORACLE.PASSWORD}'
value: zabbix_password
description: 'Oracle user''s password.'
- macro: '{$ORACLE.PGA.USE.MAX.WARN}'
value: '90'
description: 'Alert threshold for the maximum percentage of the Program Global Area (PGA) usage for the Warning trigger expression.'
- macro: '{$ORACLE.PROCESSES.MAX.WARN}'
value: '80'
description: 'Alert threshold for the maximum percentage of active processes for the Warning trigger expression.'
- macro: '{$ORACLE.REDO.MIN.WARN}'
value: '3'
description: 'Alert threshold for the minimum number of redo logs for the Warning 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 the Warning trigger expression.'
- macro: '{$ORACLE.SESSIONS.LOCK.MAX.WARN}'
value: '20'
description: 'Alert threshold for the maximum percentage of locked sessions for the Warning trigger expression.'
- macro: '{$ORACLE.SESSIONS.MAX.WARN}'
value: '80'
description: 'Alert threshold for the maximum percentage of active sessions for the Warning trigger expression.'
- macro: '{$ORACLE.SHARED.FREE.MIN.WARN}'
value: '5'
description: 'Alert threshold for the minimum percentage of free shared pool for the Warning trigger expression.'
- macro: '{$ORACLE.TABLESPACE.CONTAINER.MATCHES}'
value: '.*'
description: 'Used in tablespace discovery. It can be overridden on the host or linked template level.'
- macro: '{$ORACLE.TABLESPACE.CONTAINER.NOT_MATCHES}'
value: CHANGE_IF_NEEDED
description: 'Used in tablespace discovery. It can be overridden on the host or linked template level.'
- macro: '{$ORACLE.TABLESPACE.NAME.MATCHES}'
value: '.*'
description: 'Used in tablespace discovery. It can be overridden on the host or linked template level.'
- macro: '{$ORACLE.TABLESPACE.NAME.NOT_MATCHES}'
value: CHANGE_IF_NEEDED
description: 'Used in tablespace discovery. It can be overridden on the host or linked template level.'
- macro: '{$ORACLE.TBS.USED.PCT.FROM.MAX.HIGH}'
value: '95'
description: 'High severity alert threshold for the maximum percentage of tablespace usage (used bytes/max bytes) for the High trigger expression.'
- macro: '{$ORACLE.TBS.USED.PCT.FROM.MAX.WARN}'
value: '90'
description: 'Warning severity alert threshold for the maximum percentage of tablespace usage from maximum tablespace size (used bytes/max bytes) for the Warning trigger expression.'
- 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 the High 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 the Warning 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 the High 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 the High trigger expression.'
- macro: '{$ORACLE.USER}'
value: zabbix
description: 'Oracle username.'
dashboards:
- uuid: 60f2fa6384884e09a7c475e7c04b1515
name: 'Oracle Performance'
pages:
- widgets:
- type: graph
width: '36'
height: '5'
fields:
- type: GRAPH
name: graphid.0
value:
host: 'Oracle by Zabbix agent 2'
name: 'Oracle: Cache Hit Ratios'
- type: STRING
name: reference
value: AAAAA
- type: graph
'y': '5'
width: '36'
height: '5'
fields:
- type: GRAPH
name: graphid.0
value:
host: 'Oracle by Zabbix agent 2'
name: 'Oracle: Physical Read\Write Rate'
- type: STRING
name: reference
value: AAAAC
- type: graph
'y': '10'
width: '36'
height: '5'
fields:
- type: GRAPH
name: graphid.0
value:
host: 'Oracle by Zabbix agent 2'
name: 'Oracle: Datafiles'
- type: STRING
name: reference
value: AAAAE
- type: graph
'y': '15'
width: '36'
height: '5'
fields:
- type: GRAPH
name: graphid.0
value:
host: 'Oracle by Zabbix agent 2'
name: 'Oracle: Processes'
- type: STRING
name: reference
value: AAAAG
- type: graph
'y': '20'
width: '72'
height: '5'
fields:
- type: GRAPH
name: graphid.0
value:
host: 'Oracle by Zabbix agent 2'
name: 'Oracle: SGA Memory Usage'
- type: STRING
name: reference
value: AAAAI
- type: graph
x: '36'
width: '36'
height: '5'
fields:
- type: GRAPH
name: graphid.0
value:
host: 'Oracle by Zabbix agent 2'
name: 'Oracle: Sort Operations'
- type: STRING
name: reference
value: AAAAB
- type: graph
x: '36'
'y': '5'
width: '36'
height: '5'
fields:
- type: GRAPH
name: graphid.0
value:
host: 'Oracle by Zabbix agent 2'
name: 'Oracle: Physical Read\Write Rate, Bytes'
- type: STRING
name: reference
value: AAAAD
- type: graph
x: '36'
'y': '10'
width: '36'
height: '5'
fields:
- type: GRAPH
name: graphid.0
value:
host: 'Oracle by Zabbix agent 2'
name: 'Oracle: PGA'
- type: STRING
name: reference
value: AAAAF
- type: graph
x: '36'
'y': '15'
width: '36'
height: '5'
fields:
- type: GRAPH
name: graphid.0
value:
host: 'Oracle by Zabbix agent 2'
name: 'Oracle: Sessions'
- type: STRING
name: reference
value: AAAAH
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 datafile 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: 41d6905fa6654468b7e872973265c5b6
name: 'Oracle: Cache Hit Ratios'
graph_items:
- color: 199C0D
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.buffer_cache_hit_ratio
- sortorder: '1'
color: F63100
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.library_cache_hit_ratio
- uuid: 292f08d249d344db882a3447cc268ca6
name: 'Oracle: Datafiles'
graph_items:
- color: 199C0D
item:
host: 'Oracle by Zabbix agent 2'
key: 'oracle.datafiles.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
- sortorder: '1'
color: F63100
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.db_files_limit
- uuid: 4b4d2430750c4885b4764c3b602dc091
name: 'Oracle: PGA'
graph_items:
- color: 199C0D
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.total_pga_used
- sortorder: '1'
color: F63100
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.pga_target
- sortorder: '2'
color: 00611C
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.total_pga_allocated
- uuid: 4e02f667b98042f6ac538692a074a982
name: 'Oracle: Physical Read\Write Rate'
graph_items:
- color: 199C0D
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.physical_writes_rate
- sortorder: '1'
color: F63100
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.physical_reads_rate
- uuid: 2bfd6cda93da4201a73c3d16caea8284
name: 'Oracle: Physical Read\Write Rate, Bytes'
graph_items:
- color: 199C0D
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.physical_write_bytes_rate
- sortorder: '1'
color: F63100
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.physical_read_bytes_rate
- uuid: e51ad4ba7cca491faf7564a8d26bc1da
name: 'Oracle: Processes'
graph_items:
- color: 199C0D
item:
host: 'Oracle by Zabbix agent 2'
key: 'oracle.proc.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]'
- sortorder: '1'
color: F63100
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.processes_limit
- uuid: 3323be96dd454a92ade913ab6c2b589c
name: 'Oracle: Sessions'
graph_items:
- color: 199C0D
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.session_count
- sortorder: '1'
color: F63100
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.session_active_background
- sortorder: '2'
color: 00611C
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.session_inactive_user
- sortorder: '3'
color: F7941D
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: 199C0D
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.sga_java_pool
- sortorder: '1'
color: F63100
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.sga_large_pool
- sortorder: '2'
color: 00611C
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.sga_shared_pool
- sortorder: '3'
color: F7941D
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
- uuid: 3bbd3756a40d40f4b80851eb288d7822
name: 'Oracle: Sort Operations'
graph_items:
- color: 199C0D
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.memory_sorts_ratio
- sortorder: '1'
color: F63100
item:
host: 'Oracle by Zabbix agent 2'
key: oracle.disk_sorts