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