Managing Cost-Based Optimizer Statistics for PeopleSoft

(19.6.2018)

PeopleSoft presents some special challenges when it comes to collecting and maintaining the object statistics use 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 consider other factors that can affect optimizer statistics. It also discusses PSCBO_STATS package that is now shipped with PeopleTools.