zabbix_export: version: '6.2' date: '2022-04-06T19:59:19Z' 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.41' 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. It is 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: 1ad93880e4314d68b9e1aa4e00f03b6e name: 'Oracle: Get archive log info' key: 'oracle.archive.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]' delay: 5m history: '0' trends: '0' value_type: TEXT tags: - tag: component value: archive-log - tag: component value: raw - uuid: a5533a1c354a4c8dbfec39c9b0637ba2 name: 'Oracle: Archiver state' type: DEPENDENT key: oracle.archiver_state delay: '0' history: 7d description: 'Automatic archiving status.' 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: '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 a corruption or checksum failure during 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 global cache blocks lost' 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: 1bad65e85d8b482d9cd83b1d202f8d8c name: 'Oracle: Get CDB and No-CDB info' key: 'oracle.cdb.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]' history: '0' trends: '0' value_type: TEXT description: 'Get info about CDB and No-CDB databases on instansce.' tags: - tag: component value: cdb - tag: component value: raw - 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: '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: '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, and so on' 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: 'Current number of datafile.' 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: 'Max allowable number of datafile.' 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: cb703b07fc514ce5aedc561896bcd53f name: 'Oracle: Get ASM stats' key: 'oracle.diskgroups.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]' history: '0' trends: '0' value_type: TEXT description: 'Get ASM disk groups stats.' tags: - tag: component value: asm - tag: component value: raw - 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: 'Number of files in the fast recovery area' 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: 'Maximum amount of disk space (in bytes) that the database can use for the fast recovery area.' 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: 'Total amount of disk space (in bytes) that can be created by deleting obsolete, redundant, and other low priority files from the fast recovery area.' 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: 'Amount of disk space (in bytes) used by fast recovery area files created in current and all previous fast recovery areas.' 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: 'GC 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 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: '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: '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: '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: 'Oracle DB Instance name has changed. Ack to close.' 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: '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: '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 5 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: ca4452418d2641bd87fa75e946c2bf98 name: 'Oracle: Get PDB info' key: 'oracle.pdb.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]' history: '0' trends: '0' value_type: TEXT description: 'Get info about PDB databases on instansce.' tags: - tag: component value: pdb - tag: component value: raw - 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: '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: 'Oracle: PGA, Aggregate target parameter' type: DEPENDENT key: oracle.pga_target delay: '0' history: 7d units: B description: 'Current value of the PGA_AGGREGATE_TARGET initialization parameter. If this parameter is not set, then its value is 0 and automatic management of 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: 'Max 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: 'Number of available for log switching inactive/unused REDO logs.' 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: 'Number of available for log switching inactive/unused REDOs 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: 'SQL service response time 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 case of modifying data transactions sequentially block temporarily the right to change data, the rest of the transactions are waiting for access. In the case when access for resource is locked for a long time, then the concurrency grows (like the transaction queue) and this often has 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: 'Concurrency rate is over {$ORACLE.CONCURRENCY.MAX.WARN}%. A high contention value does not indicate the root cause of the problem, but is a signal to search for it. In the case of high competition, an analysis of resource consumption should be carried out, the most "heavy" queries made in the database, possibly - session tracing. All this will help 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: '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: '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: '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: 'Number of locked sessions is over {$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: 'Count of the prolongedly locked sessions. (You can change maximum session lock duration in seconds for query by {$ORACLE.SESSION.LOCK.MAX.TIME} macro. Default 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: 'Number of sessions locked over {$ORACLE.SESSION.LOCK.MAX.TIME} seconds is too high. Long-term locks can negatively affect database performance, therefore, if they are detected, you should first find the most difficult queries from the database point of view and 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 the cache of standard blocks.' 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 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: '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: 'Memory is allocated from the 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: 'Memory is allocated from the 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: 'Shared pool free memory percent. Free/Total' 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 shared pool free memory percent has been less than {$ORACLE.SHARED.FREE.MIN.WARN}% in 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: '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 system metric values.' 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: 'Temp space used.' 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: 'Current amount of 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: 'Number of bytes of 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: 'Indicates how much 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: 97ac4acedcde465b8d004a8ac476dd99 name: 'Oracle: Get tablespaces stats' key: 'oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]' history: '0' trends: '0' value_type: TEXT description: 'Get tablespaces stats.' tags: - tag: component value: raw - tag: component value: tablespaces - uuid: 4f1a9efea8594486b226307a52e35474 name: 'Oracle: Uptime' type: DEPENDENT key: oracle.uptime delay: '0' history: 7d trends: 0d units: s description: 'Oracle instance uptime 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 data for 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: has been restarted' event_name: 'Oracle: 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: '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 zabbix account password expired.' 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: 'Password for zabbix user in the database will expire 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 a user''s 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: '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: 'Oracle DB version has changed. Ack to close.' 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: 'Log archive destinations.' item_prototypes: - 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: 'Displays the error text' 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}"]' 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: '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}"]' 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: 'Identifies the current status of the destination: 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}"]' 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: 'ARL destination not in 3 - Valid or 2 - Deferred.' 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 DBMS.' item_prototypes: - uuid: d9d1575b767b46e0aefe65a270f2d01b name: 'Oracle Database ''{#DBNAME}'': Force logging' type: DEPENDENT key: 'oracle.db_force_logging["{#DBNAME}"]' delay: '0' history: 7d description: 'Indicates whether the database is under force logging mode (YES) or not (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}"]' 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: 'Archive log mode, 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}"]' 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}"]' 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: 'Oracle DB open status has changed. Ack to close.' 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 has 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: 'Current role of the database, 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}"]' 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: 'Oracle DB role has changed. Ack to close.' 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 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: 'ASM disk groups' item_prototypes: - uuid: 8b4e5c9385d04a39b2187e093ffca213 name: 'ASM ''{#DG_NAME}'': Free size' type: DEPENDENT key: 'oracle.asm_free_size["{#DG_NAME}"]' delay: '0' history: 7d units: B description: 'Free size of ASM disk group.' preprocessing: - type: JSONPATH parameters: - '$..[''{#DG_NAME}''].free_size_byte.first()' master_item: key: 'oracle.diskgroups.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]' tags: - tag: component value: asm - tag: disk-group value: '{#DG_NAME}' - uuid: b80f69f44dd24eae82a301dbefb0c60f name: 'ASM ''{#DG_NAME}'': Total size' type: DEPENDENT key: 'oracle.asm_total_size["{#DG_NAME}"]' delay: '0' history: 7d units: B description: 'Total size of ASM disk group.' preprocessing: - type: JSONPATH parameters: - '$..[''{#DG_NAME}''].size_byte.first()' master_item: key: 'oracle.diskgroups.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]' tags: - tag: component value: asm - tag: disk-group value: '{#DG_NAME}' - uuid: e2a0ac73040f401bb05ff88140f6665b name: 'ASM ''{#DG_NAME}'': Free size' type: DEPENDENT key: 'oracle.asm_used_pct["{#DG_NAME}"]' delay: '0' history: 7d value_type: FLOAT units: '%' description: 'Usage percent of ASM disk group.' preprocessing: - type: JSONPATH parameters: - '$..[''{#DG_NAME}''].used_percent.first()' master_item: key: 'oracle.diskgroups.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]' tags: - tag: component value: asm - tag: disk-group value: '{#DG_NAME}' trigger_prototypes: - uuid: b8aa1b00e2574e35bf71554cabfffcfc expression: 'min(/Oracle by Zabbix agent 2/oracle.asm_used_pct["{#DG_NAME}"],5m)>{$ORACLE.ASM.USED.PCT.MAX.HIGH}' name: 'ASM ''{#DG_NAME}'': Disk group usage is too high' event_name: 'ASM ''{#DG_NAME}'': Disk group usage is too high (over {$ORACLE.ASM.USED.PCT.MAX.HIGH}% for 5m)' priority: HIGH description: 'Usage percent of ASM disk group is over {$ORACLE.ASM.USED.PCT.MAX.WARN}' tags: - tag: scope value: capacity - uuid: af6ff1d099524209b2806b1257e9a8e3 expression: 'min(/Oracle by Zabbix agent 2/oracle.asm_used_pct["{#DG_NAME}"],5m)>{$ORACLE.ASM.USED.PCT.MAX.WARN}' name: 'ASM ''{#DG_NAME}'': Disk group usage is too high' event_name: 'ASM ''{#DG_NAME}'': Disk group usage is too high (over {$ORACLE.ASM.USED.PCT.MAX.WARN}% for 5m)' priority: WARNING description: 'Usage percent of ASM disk group is over {$ORACLE.ASM.USED.PCT.MAX.WARN}' dependencies: - name: 'ASM ''{#DG_NAME}'': Disk group usage is too high' expression: 'min(/Oracle by Zabbix agent 2/oracle.asm_used_pct["{#DG_NAME}"],5m)>{$ORACLE.ASM.USED.PCT.MAX.HIGH}' tags: - tag: scope value: capacity graph_prototypes: - uuid: f42e49e6743f4b08b5bdc3ab284b26f3 name: 'ASM ''{#DG_NAME}'': ASM disk group ''{#DG_NAME}''' graph_items: - color: 1A7C11 item: host: 'Oracle by Zabbix agent 2' key: 'oracle.asm_free_size["{#DG_NAME}"]' - sortorder: '1' color: 2774A4 item: host: 'Oracle by Zabbix agent 2' key: 'oracle.asm_total_size["{#DG_NAME}"]' - 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 PDB in DBMS.' item_prototypes: - 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}"]' 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: 'Oracle DB open status has changed. Ack to close.' 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 has 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 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}"]' 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 allocated space.' preprocessing: - type: JSONPATH parameters: - '$..[''{#TABLESPACE}''].free_bytes.first()' master_item: key: 'oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]' 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: 'Maximum size of tablespace.' preprocessing: - type: JSONPATH parameters: - '$..[''{#TABLESPACE}''].max_bytes.first()' master_item: key: 'oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]' 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: 'Tablespace status. 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}"]' 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 tablespace (current size of datafiles-free space).' preprocessing: - type: JSONPATH parameters: - '$..[''{#TABLESPACE}''].used_bytes.first()' master_item: key: 'oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]' 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}"]' 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}"]' 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 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: 'Maximum percentage of used ASM disk group for high trigger expression.' - macro: '{$ORACLE.ASM.USED.PCT.MAX.WARN}' value: '90' description: 'Maximum percentage of used ASM disk group for warning trigger expression.' - macro: '{$ORACLE.CONCURRENCY.MAX.WARN}' value: '80' description: 'Maximum percentage of sessions concurrency usage for trigger expression.' - macro: '{$ORACLE.CONNSTRING}' value: 'tcp://localhost:1521' - macro: '{$ORACLE.DB.FILE.MAX.WARN}' value: '80' description: 'Maximum percentage of database files for trigger expression.' - macro: '{$ORACLE.DBNAME.MATCHES}' value: '.*' description: 'This macro is used in database discovery. It can be overridden on the host or linked template level.' - macro: '{$ORACLE.DBNAME.NOT_MATCHES}' value: PDB\$SEED description: 'This macro is used in database discovery. It can be overridden on a host or linked template level.' - macro: '{$ORACLE.EXPIRE.PASSWORD.MIN.WARN}' value: '7' description: 'Number of days of warning before password expires (for trigger expression).' - macro: '{$ORACLE.PASSWORD}' value: zabbix_password description: 'Oracle user password.' - macro: '{$ORACLE.PGA.USE.MAX.WARN}' value: '90' description: 'Maximum percentage of PGA usage alert threshold (for trigger expression).' - macro: '{$ORACLE.PROCESSES.MAX.WARN}' value: '80' description: 'Maximum percentage of active processes alert threshold (for trigger expression).' - macro: '{$ORACLE.REDO.MIN.WARN}' value: '3' description: 'Minimum number of REDO logs alert threshold (for trigger expression).' - macro: '{$ORACLE.SERVICE}' value: ORA description: 'Oracle Service Name' - macro: '{$ORACLE.SESSION.LOCK.MAX.TIME}' value: '600' description: 'Maximum session lock duration in seconds for count the session as a prolongedly locked query.' - macro: '{$ORACLE.SESSION.LONG.LOCK.MAX.WARN}' value: '3' description: 'Maximum number of the prolongedly locked sessions alert threshold (for trigger expression).' - macro: '{$ORACLE.SESSIONS.LOCK.MAX.WARN}' value: '20' description: 'Maximum percentage of locked sessions alert threshold (for trigger expression).' - macro: '{$ORACLE.SESSIONS.MAX.WARN}' value: '80' description: 'Maximum percentage of active sessions alert threshold (for trigger expression).' - macro: '{$ORACLE.SHARED.FREE.MIN.WARN}' value: '5' description: 'Minimum percentage of free shared pool alert threshold (for trigger expression).' - macro: '{$ORACLE.TABLESPACE.NAME.MATCHES}' value: '.*' description: 'This macro is used in tablespace discovery. It can be overridden on a host or 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 a host or linked template level.' - macro: '{$ORACLE.TBS.USED.PCT.MAX.HIGH}' value: '95' description: 'Maximum percentage of used (Used bytes/Allocated bytes) tablespace high severity alert threshold (for trigger expression).' - macro: '{$ORACLE.TBS.USED.PCT.MAX.WARN}' value: '90' description: 'Maximum percentage of used (Used bytes/Allocated bytes) tablespace warning severity alert threshold (for trigger expression).' - macro: '{$ORACLE.TBS.UTIL.PCT.MAX.HIGH}' value: '90' description: 'Maximum percentage of utilization (Allocated bytes/Max bytes) tablespace high severity alert threshold (for trigger expression).' - macro: '{$ORACLE.TBS.UTIL.PCT.MAX.WARN}' value: '80' description: 'Maximum percentage of utilization (Allocated bytes/Max bytes) tablespace warning severity alert threshold (for 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: 'Number of datafiles is higher than {$ORACLE.DB.FILE.MAX.WARN}% of the available datafile files 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: '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