This content has been marked as final. Show 4 replies
It is used to enable/disable sort-merge join method.
This is an internal Oracle parameter. Do NOT use it unless instructed to do so by Oracle Support.
MOS [ID 444609.1]
but don't set it without consulting with oracle support.
There is a query that is getting failed at client production environment because of huge amount of data in table. So someone suggested to use this.
Can it be set to true/false at runtime, I mean without restarting DB and how?
who said it? what reason? what version of the database? is it production? if you put it in and it makes the database performance worse will you lose your job or will the person who said it lose their job? think of it that way.
get explain plan for the query thats bad. post the plan here and we'll help.