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@xxxxxxxxxx <mailto:l.flatz@xxxxxxxxxx> <l.flatz@xxxxxxxxxx <mailto:l.flatz@xxxxxxxxxx>> 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@xxxxxxxxx <mailto:jlewisoracle@xxxxxxxxx>
Datum : 04/11/2020 - 11:49 (MN)
An : oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxx> 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
-- //www.freelists.org/webpage/oracle-l
