Re: Does Anybody know this parameter: is_recur_flags

Thanks to all. Looks like I can ignore this "parameter". I was researching different settings in Parameter causing a high number of shard cursor.
I had to follow up on any difference in parameter settings.

Regards

Lothar

Am 04.11.2020 um 12:33 schrieb Jonathan Lewis:
>
> 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
> <mailto:l.flatz_at_bluewin.ch> <l.flatz_at_bluewin.ch
> <mailto: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 <mailto:jlewisoracle_at_gmail.com>
> Datum : 04/11/2020 - 11:49 (MN)
> An : oracle-l_at_freelists.org <mailto: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