E-DM: Can %UpdateStats Meta-SQL be Changed For Application Engine or Cobol Programs in Oracle
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***
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?
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