Managing Cost-Based Optimizer Statistics for PeopleSoft

PeopleSoft presents some special challenges when it comes to collecting and maintaining the object statistics used by the cost-based optimizer. This session focuses on the Oracle database and will draw together the various concepts into a single consistent picture and make clear recommendations to help you work with the Oracle optimizer, rather than continually fight against it. It looks at collecting stats for permanent and temporary working storage tables, and considers other factors that can affect optimizer statistics. It also discusses PSCBO_STATS package that is shipped with PeopleTools.