Re: Re: Does Anybody know this parameter: is_recur_flags

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