Hello. Using 23.1.4 and Oracle 19.
We have an application in which we need that search in IR-IG works independent of accents, so I've changed
Character Value Comparison to BINARY_AI
Character Value Comparison Behavior to Linguistic
but now executing my IR has changed from around 1 second to more than 50 seconds (around 200 rows).
In debug window I can see that this line takes more than 10 seconds:
2.5106010.02853
set_nls_parameter p_parameter=>NLS_COMP,p_value=>LINGUISTIC,p_default=>BINARY
and many lines that need more than 1 second like this:
... Dialog init code: javascript:apex.theme42.dialog('\u002Fpls\…
and the execution ends with;
Cursor leak: difference in "opened cursors current" is 1:1
191.221290.00041- user=APEX_230100, type=OPEN-RECURSIVE, sql_id=7sg1vrjgxfgqm, sql_text=select count(1) from sys.idnseq$ where seqobj# = :1
Why is it so slow? How can we solve it?
(we've already tried other alternatives like changing parameters in logon triggers, but APEX got totally screwed when we did)
Thanks.