Hi guys,
My DBA said OTRS Oracle database is consuming too much shared memory. He told me OTRS queries is using a lot of literals instead of bind variables. So he proposed set "CURSOR_SHARING=FORCE". After research a little I found some articles saying that is a horrible thing that could cause a lot of problems.
https://docs.oracle.com/database/121/TG ... TGSQL94750
https://asktom.oracle.com/pls/apex/f?p= ... 0346512056
So I'm wondering if someone has already tested this.
Thanks,
[SOLVED] Does OTRS works with Oracle CURSOR_SHARING=FORCE?
Moderator: crythias
-
- Znuny expert
- Posts: 167
- Joined: 26 Nov 2014, 20:34
- Znuny Version: 6.3.4
- Real Name: Samuel Casimiro
- Company: Câmara dos Deputados
- Contact:
[SOLVED] Does OTRS works with Oracle CURSOR_SHARING=FORCE?
Last edited by nedmaj on 11 Oct 2017, 15:32, edited 1 time in total.
Samuel
Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
Re: Does OTRS works with Oracle CURSOR_SHARING=FORCE?
give OTRS the resources it needs, switch to another database (e.g. MySQL) or to a fully managed system. I really advice not to change any parameters without the knowledge what will happen or if OTRS would work with them
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com