On Jul 25, 2008, at 9:11 AM, Michael Mraka wrote:
Thomas von Steiger wrote:
...
% >Looks like you may be hitting an oracle bug. See:
% >
% >https://bugzilla.redhat.com/show_bug.cgi?id=453176
% >
% >Looks like there may be a workaround as well..
%
% Great!
%
% SQL> alter system set "_optimizer_cost_based_transformation"=off
% scope=memory;
% System altered.
% SQL> commit;
% Commit complete.
Just for sure... do you know that you changed this option in memory
only?
If you want make this change permanent (i.e. survive database
restart) issue
SQL> alter system set "_optimizer_cost_based_transformation"=off
scope=spfile;
Now i know!
Thanks for this hint.
Thomas
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list