Database Administration (MOSC)

MOSC Banner

Optimizer aparameters

Hi,

On 19c on AIX

Are the follwing commandes valide/correct to change optimzer parameters:

alter system set "optimizer_adaptive_statistics"=false scope=both;

alter system set "optimizer_adaptive_plans"=true scope=both;

alter system set "_disable_actualization_for_grant"=true scope=both;

Thanks.

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