pscbo_stats - Improving Statistics in Oracle RDBMS for PeopleSoft Enterprise
(Doc ID 1322888.1)
Last updated on AUGUST 15, 2023
Oracle Database Cloud Service - Version N/A to N/A [Release 1.0] PeopleSoft Enterprise PT PeopleTools - Version 8.57 to 8.59 [Release 8.4] Information in this document applies to any platform.
Note: 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!