Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: High Cpu Usage After 9i Migration
What are your settings for the optimizer_max_permutations and
optimizer_mode parameters? Are they very different now from before the
migration? If so, you might consider setting them back to the 8i
values. If you're having problems with some views, experiment with
setting _complex_view_merging=false. BTW, these parameters are session
modifiable. You can test them without having to change them at the
system level.
Received on Wed Nov 24 2004 - 14:35:30 CST