My Oracle Support Banner

pscbo_stats - Improving Statistics in Oracle RDBMS for PeopleSoft Enterprise (Doc ID 1322888.1)

Last updated on FEBRUARY 25, 2024

Applies to:

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.

Goal

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.

Introduction

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.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
 Introduction
Solution
 Current Version
 Why pscbo_stats?
 Key Concepts
 Where PeopleTools and Oracle Database Statistics “Overlap”
 Considerations Used by pscbo_stats When Gathering Statistics
 Flexibility to Adapt the pscbo_stats Package
 Supported Versions and Configurations
 Support Questions
 New Features/fixes
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.