1 Reply Latest reply on Oct 24, 2008 3:50 PM by 26741

    _optimizer_cost_based_transformation parameter


      After patching a development database to (from 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 ?