Hi,
I have a problem with query status of some TBS:
[Oracle] failed to handle metric "oracle.ts.stats": query execution timeout 45s exceeded: Cannot fetch data.: Next: ORA-03156: DPI-1067: call timeout of 44999 ms exceeded with
no matter if use Agent 2 or ODBC template, and no matter how timeout I set i oracle.conf in zabbix agent configuration..Oracle version is 19.xx and DB size is 40-120TB. Problematic TBS have several dozen TB. If I use query from ODBC template directly in oracle server its never end...I have manu query to getr TBS information and its took few seconds...So I think there query user in template/agent are not optimized. What you suggest to do with that problem??
I have a problem with query status of some TBS:
[Oracle] failed to handle metric "oracle.ts.stats": query execution timeout 45s exceeded: Cannot fetch data.: Next: ORA-03156: DPI-1067: call timeout of 44999 ms exceeded with
no matter if use Agent 2 or ODBC template, and no matter how timeout I set i oracle.conf in zabbix agent configuration..Oracle version is 19.xx and DB size is 40-120TB. Problematic TBS have several dozen TB. If I use query from ODBC template directly in oracle server its never end...I have manu query to getr TBS information and its took few seconds...So I think there query user in template/agent are not optimized. What you suggest to do with that problem??