1 Reply Latest reply: Oct 24, 2008 10:50 AM by 26741 RSS

    _optimizer_cost_based_transformation parameter

    MatthiasHoys
      Hello,

      After patching a development database to 10.2.0.4 (from 10.2.0.3) and installing the recent CPUOCT2008 patches, we had ORA-00600 errors with some queries.
      Based on the feedback from Oracle support, I had to change the hidden system parameter "_optimizer_cost_based_transformation" to OFF. This solved the problem.
      Initial testing of some applications connecting to this database didn't show any problems.

      Is there anyone who did notice performance problems after setting "_optimizer_cost_based_transformation" to OFF ?


      Thanks
      Matthias