SQL Performance (MOSC)

MOSC Banner

Impact of updating these parameters as per 2266016.1

edited Mar 15, 2019 12:53PM in SQL Performance (MOSC) 2 commentsAnswered

Hi

We had the performance issue with viewing DDL of any object and that got resolved after making the changes for all the 3 parameters documented in 2266016.1. I went through couple of docs and seems like except for _optimizer_push_pred_cost_based we should be good to make these changes. But again, do we know of any consequences that we might face with these changes? Are there any parameters that are mutually exclusive with these (is there a way to know by a view) and/or would there be any consequences?

Just curious to know, so initiating this thread.

Regards

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