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.
- Related Document: Managing Optimizer Statistics for PeopleSoft on Oracle 11g (or higher).