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@xxxxxxxxxx <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
Datum : 04/11/2020 - 11:49 (MN)
An : 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