[SOLVED] Does OTRS works with Oracle CURSOR_SHARING=FORCE?

Moderator: crythias

Post Reply
nedmaj
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?

Post by nedmaj »

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,
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
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Does OTRS works with Oracle CURSOR_SHARING=FORCE?

Post by jojo »

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
Post Reply