Oracle 9.2 on HP/UX 11.i
Database size 35 Gig.
Users about 120.

We are going through the process of trying to move from RULE based
optimizer to CHOOSE optimizer. I have set the instance in CHOOSE mode,
but when I did that and there were statistics we had a huge load problem.
This problem does not show up in our development system. I have tried
adjusting the two optimizer parameters as shown. I did a analyze using the
dbms_stats of all tables and indexes and we still have load issues when
statistics are available and also if these are set.

optimizer_index_caching=90
optimizer_index_cost_adj=50

The load on our systems goes from 50% to 100% and users slow down and stop
working.
Any ideas?/


Oracle LazyDBA home page