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.