Originally posted by AJW_ID01

So, what would anyone else do in my position?


Does anyone have any opinion encompassing the bringing into play of "optimizer_index_cost_adj" (which is currently set to the default of 100)?
If I were in your position, I would run a quick test at the session level with optimizer_index_cost_adj around 25 or so. I'd run some of the queries that would obviously use the index and see if that helped (Make sure they are reparsed). I suspect you will get more bang for the buck with this setting.

If not, decrease the dbfmbrc to 8. Personally, I like knowing that IF a FTS has to happen it will happen 16 (or ever 32) blocks at a time.

Mileage may vary.