E-DM: Can %UpdateStats Meta-SQL be Changed For Application Engine or Cobol Programs in Oracle (Doc ID 650817.1)

Last updated on JANUARY 06, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.1 to 8.55 [Release 8.1 to 8.4]
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201025158

***Checked for relevance on 07-APR-2015***

Goal

When Application Engine runs the %UpdateStats translates into 'Analyze Table xxxx' in an Oracle database environment

Customer prefers to use 'dbms_stats.gather_table_stats' instead of the 'analyze table ' command.

How would we change what command %UpdateStats runs for a given DB Platform?

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