Hi=20 >As a DBA should I be embarrassed?... >...besides optimizer_mode, I have never set any of these! >Suggestions, articles, links, etc? At the last Hotsos Symposium my presentation was about this topic... Of = course in such a short time isn't possible to cover everything. Anyway, = in my opinion, it's a good starting point. If you are interested, just = click on the following link: http://www.trivadis.com/Images/CBOConfigurationRoadmap_tcm16-12738.pdf >Any "silver bullets" here? I hope you are joking ;-) HTH Chris -- //www.freelists.org/webpage/oracle-l