Clarity 15.9.2 and oracle 12.2.0.1. Wich optimizer feature ?

[Stefano Lazzarotto]

Hi all.
We have a clarity 15.9.2 with oracle 12.2.0.1.
We set, as recommended, the fix_control 17800514:0 and the optimizer_feature_enable to 12.1.0.2

Dba administrator sees many ORA-600 errors and analizyng the errors says that problem come from the optimizer_feature_enable that should set to 12.2.0.1

Example of a query giving the error:
SELECT  A.*, C.PRVALUE       FROM    PRASSIGNMENT A, PRCALENDAR C, PRJ_RESOURCES RP
            WHERE   C.PRID = RP.PRCALENDARID AND RP.PRID = A.PRRESOURCEID  AND     A.PRTASKID =    :v0


Is there any problem to set the optimizer to 12.2.0.1?

Thanks and regards
Stefano

[Suman Pramanik]

Hi Stefano

When we ran the performance test the queries performed much better with optimizer_feature_enable to 12.1.0.2 and ORA-600 is not due to compatibility but some issue at database and you should engage the database vendor to find specifics. 

[Nika Hadzhikidi]

I have seen customers who did not set it and were fine. This said, this the config that we tested for performance so we recommend following it to avoid issues. Otherwise you have to do a performance testing to ensure there is no impact.

The ORA-00600 errors are internal errors and as Suman said DBA should engage Oracle Support to assist. They may have to patch this server.