pscbo_stats - Improving Statistics in Oracle RDBMS for PeopleSoft Enterprise
Last updated on MARCH 06, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.48 to 8.55 [Release 8.4]
Oracle Database as a Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.
Oracle does not certify or test the pscbo_stats utility for support purposes. Its use is considered to be a customization.
If there is a problem or question with pscbo_stats, the Global Support Center will not be handling service requests regarding its use.
The best approach would be to post to the Lifecycle Management PSFT Community, reaching out to other customers for information and assistance.
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