Forum Stats

  • 3,812,620 Users
  • 513,050 Discussions
  • 1,634,209 Comments

Discussions

Does the use of STATISTICS_LEVEL = ALL require diagnostic or tuning pack license?

We have some databases with 12C Enterprise Edition about to upgrade to 19C and are reviewing parameters. In Non-prod we DO NOT have DIAGNOSTIC and TUNING pack license and have set control_management_pack_access =NONE.

It has been suggested we should set STATISTICS_LEVEL = ALL (as it is in Production) but I cannot do this if this would require DIAG or DIAG and TUNING pack license.

Can you advise?

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.

New to My Oracle Support Community? Visit our Welcome Center