Re: Re: Does Anybody know this parameter: is_recur_flags

There’s a bug in 12.2 where a dataguard switchover will lead to SQL that has this flag to use the rule based optimizer.

Very fun!

Thanks,
Andrew

On Wed, 4 Nov 2020 at 11:27, Andy Sayer <andysayer_at_gmail.com> wrote:

> Hi Lothar,
>
> It’s to do with sql called by plsql called by sql. Eg SQL with a function
> that does SQL or dbms_scheduler or call (rather than an anonymous block).
>
> Thanks,
> Andrew
>
> On Wed, 4 Nov 2020 at 11:08, l.flatz_at_bluewin.ch <l.flatz_at_bluewin.ch>
> wrote:
>
>> Hi Jonathan,
>>
>> i got it from v$sql_optimizer_env.
>> The query contains this hint: OPT_PARAM('_ENABLE_VIEW_PDB', 'FALSE').
>> I wonder if there is a connection.
>>
>> Regards
>>
>> Lothar
>>
>> ----Ursprüngliche Nachricht----
>>
>> Von : jlewisoracle_at_gmail.com
>> Datum : 04/11/2020 - 11:49 (MN)
>> An : oracle-l_at_freelists.org
>>
>>
>> Betreff : Re: Does Anybody know this parameter: is_recur_flags
>>
>> What's the context where it appears?
>> I don't think it's a parameter - it looks more like a flag reported by
>> the optimizer in a 10053 trace to describe the status of the current query.
>>
>> Regards
>> Jonathan Lewis
>>
>>
>> On Wed, 4 Nov 2020 at 10:30, Lothar Flatz < l.flatz_at_bluewin.ch> wrote:
>>
>>> Hi,
>>>
>>> looks like it can not be found in MOS or the documentation.
>>>
>>> When I try to change it:
>>>
>>> alter system set is_recur_flags=0 scope=both
>>> Error report -
>>> ORA-02065: illegal option for ALTER SYSTEM
>>> 02065. 00000 - "illegal option for ALTER SYSTEM"
>>> *Cause: The option specified for ALTER SYSTEM is not supported
>>> *Action: refer to the user manual for option supported
>>>
>>> Regards
>>>
>>> Lothar
>>> --
>>> http://www.freelists.org/webpage/oracle-l
>>>
>>>
>>>
>>
>>

--
http://www.freelists.org/webpage/oracle-l