Re: Re: Does Anybody know this parameter: is_recur_flags

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