PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

What level of OPTIMIZER_DYNAMIC_SAMPLING may be needed for Oracle Database EE version 11.2.0.3 with

edited Aug 29, 2012 8:58AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered
What level of OPTIMIZER_DYNAMIC_SAMPLING may be needed for Oracle Database EE version 11.2.0.3 with Peoplesoft tools 8.51?
And also how is this enforced?  Is this enforced when I execute the following for example?

execute dbms_stats.gather_schema_stats(ownname=>'SYSADM',cascade=>true,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,degree=>4);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center