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?

in Database Tuning (MOSC) 6 commentsAnswered

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.

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


New to My Oracle Support Community? Visit our Welcome Center