Database Tuning (MOSC)

MOSC Banner

Why does the SQl tuning advisor recommended SQL Profile only work for one set of values?

in Database Tuning (MOSC) 8 commentsAnswered

ORACLE 19c RAC database

We have a query that was running fine but started running slow , I am not sure what changed

Tuning the query with SQL Tuning Advisor results in a recommended SQL Profile

I run the dbms script supplied by SQL Tuning Advisor and the query performance improves greatly

BUT, any change to any of the values in the query (no changes to query) just the values requested results in terrible performance all over again

How do i get a SQL Profile to be used for all values requested for a given query?

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

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).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center