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

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.

Goal

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms