Devart Forums

Hello,
I have a Delphi program that runs fine with Oracle 11G. When I run it with Oracle 12C it is much slower.
I found that the slowness is mainly where TOraTables are opened.
Similar result with ODAC Version 8.0.2 for Delphi 7 and with ODAC Version 11.3.2 For RAD Studio 10.3.
Can you advise me of recommended changes in ODAC configuration, Delphi code or maybe in ORACLE 12C setup?
Thanks in advance

I think found the problem. Some TOraTables had an empty KeyField.
I don't understand why this speed problem happens with Oracle 12C and not with Oracle 11G ?

Do Oracle 12c tables open slowly when you don't use our components? For example, when you run the query SELECT * FROM table_name using standard tool Oracle SQL*Plus. Please make sure the table has identical data in different versions of Oracle Database and let us know whether the execution times of the query differ across databases.

I have further improvement by setting the Oracle parameter OPTIMIZER_ADAPTIVE_FEATURES to FALSE.
I think this is the main problem.

We are glad that you found a necessary solution. Please don't hesitate to contact us with questions concerning ODAC usage.