[ZBXNEXT-7731] Oracle Tablespaces with autoextend feature Created: 2022 May 19 Updated: 2025 Apr 11 |
|
Status: | Open |
Project: | ZABBIX FEATURE REQUESTS |
Component/s: | Templates (T) |
Affects Version/s: | 5.0.23, 6.0.4 |
Fix Version/s: | None |
Type: | New Feature Request | Priority: | Low |
Reporter: | Igor Gorbach (Inactive) | Assignee: | Zabbix Integration Team |
Resolution: | Unresolved | Votes: | 5 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Issue Links: |
|
Description |
Please, add the possibility of tablespaces autodiscovery disabled in the Oracle template if autoextend feature is enabled for the tablespace (no reason to monitor, because tablespace will be extended automatically) to avoid false alarms |
Comments |
Comment by Gaël MONDON [ 2022 Oct 05 ] |
Instead of disabling the monitoring, we could take in account the autoextend option in the usage calculation, if not the case (other issues are opened about this at this time)
|
Comment by Edoardo [ 2024 May 30 ] |
Hello, are there any plans to calculate available tablespace space taking into account autoextend feature ? It seems to be a common source of false alarms problem |
Comment by Antons Sincovs [ 2025 Mar 27 ] |
Indeed, currently the "Oracle by Zabbix agent 2" monitoring template makes no sense for tablespace "Tablespace usage, percent" item value when "AUTOEXTENSIBLE" value is set to "YES" and the tablespace file automatically grows to "Tablespace MAX size, bytes" item value. Thus for the "Tablespace usage, percent" item instead of current Used bytes/Allocated bytes*100 for "AUTOEXTENSIBLE" set to "YES" tablespaces there should be Used bytes/MAX bytest*100 It would be nice if some if/else logic would be added to respect the "AUTOEXTENSIBLE" value for the tablespace.
when autoextensible = 'YES' then maxbytes
knaglis it would be nice if the official Zabbix template had the same logic built in
|
Comment by Antons Sincovs [ 2025 Apr 11 ] |
asebiskveradze - could you, please, consider adding the corresponding logic to the "Oracle by Zabbix agent 2" monitoring template so it would take into consideration "autoextend" feature and would not produce false positives on tablespace running out of free space while the actual usage is still far from the "Tablespace MAX size, bytes" ( as Mugugnu also mentioned) ? Here is the community template, which already has this logic implemented. |