Three Patch on Zabbix Oracle: open cursor, TX lock, share pool

[frankymryao]

1. There is a place that curosr open in DB will not be closed in some logic. I read the code and fix it.

2. get-id-method is very low performance in zabbix-1.8.8. As we use oracle, we remove the function in source code and use Sequence of oracle to get id.

It will solve the TX lock problem in oracle in large scalability.

3. For oracle, zabbix made a method to compose sql into a large sql, and add 'begin' & 'end'. This will make oracle can not share cursors so that oracle will crash.

We split the big sql into sql-in-sentence and solve this problem

I'm sorry I do not have version control. So perhaps you can use 'diff' to find where I've modified.

[zalex_ua]

Would be optimal to report this case in Zabbix issues tracker https://support.zabbix.com/browse/ZBX

[frankymryao]

Would be optimal to report this case in Zabbix issues tracker https://support.zabbix.com/browse/ZBX

I'll do that this weekend

[olgierd]

did you submit the changes/patches to main Zabbix issues tracker?
What is ID?

I maintain Zabbix implementation with Oracle and wonder if patch is included in Zabbix 2.0.2. I have stability/performance issues with Zabbix + Oracle.

Do you have any tutorial how to tune Oracle 11g RAC for Zabbix?

[frankymryao]

did you submit the changes/patches to main Zabbix issues tracker?
What is ID?

I maintain Zabbix implementation with Oracle and wonder if patch is included in Zabbix 2.0.2. I have stability/performance issues with Zabbix + Oracle.

Do you have any tutorial how to tune Oracle 11g RAC for Zabbix?

My Code is on GitHub now:https://github.com/baniuyao/Zabbix_PPTV

issue tracker: https://support.zabbix.com/browse/ZBX-5051

[nik]

Hi!
It's only for 1.8.8?
Can I use it for 2.0.3?