2585 lines
112 KiB
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
|