Last updated on JANUARY 10, 2017
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.48 to 8.55 [Release 8.4]
Information in this document applies to any platform.
Many performance-related issues are caused by Oracle's Cost-Based Optimizer, or “optimizer,” generating poor execution plans simply because the statistics associated with the underlying tables and indexes are not accurate.
Having a reliable method for collecting accurate statistics will enable the optimizer to better anticipate the number of rows returned during each phase of the statement's execution, allowing it to make better decisions regarding execution plans. Naturally, these improved plans will result in processes that run faster with more consistent run times.
The pscbo_stats package was designed to be an effective tool to maintain statistics in a consistent, predictable, and robust fashion for PeopleSoft customers running on the Oracle RDBMS.
While the pscbo_stats package will not solve every performance issue, it does provide a solid foundation for additional tuning efforts.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms