SQL Tuning Advisor Running DS_SVC Internal Recursive SQL Statements
(Doc ID 2686026.1)
Last updated on JULY 14, 2020
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
- DS_SVC (dynamic sampling) internal queries are running as part of SQL Tuning Advisor(Auto/Manual) with default dynamic sampling level (OPTIMIZER_DYNAMIC_SAMPLING=2)
- Following parameters are set but still the DS_SVC queries run from SQL tuning advisor.
- Dropped all the directives from dba_sql_plan_directives.
Upgrade to 12.2 or higher.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document