What level of OPTIMIZER_DYNAMIC_SAMPLING may be needed for Oracle Database EE version 11.2.0.3 with
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);
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);
0