Re: Re: Does Anybody know this parameter: is_recur_flags

There are lots of "optimizer environment" parameters which aren't database parameters - I think there may be a few that can be set explicitly. I suspect that some of them are cursor specific, some session specific, and I don't know whether any of them are system-wide.

Running a quick query in 19.3 against the x$ under v$sys_optimizer_env and x$ksppi view I can see 47 "parameters" in the optimizer environment that don't appear as startup parameters:

select

        pname_qkscesyrow name
from

        x$qkscesys
minus
select

        ksppinm
from

        x$ksppi
/

And another example of the quirks of parameters: alter session set use_stored_outline = true;

use_stored_outlines isn't a startup parameter, nor does it appear as an optimizer environment parameter when it really looks as if it should.

Regards
Jonathan Lewis

On Wed, 4 Nov 2020 at 11:07, 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