Re: Does anybody know this statement?

Thanks.

Am 02.11.2020 um 18:07 schrieb dimensional.dba_at_comcast.net:
> This is part of the query set that is normally called at the CDB level,
> There are variety of internal functions that determine information relative to objects for cross container queries.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Lothar Flatz
> Sent: Monday, November 2, 2020 8:28 AM
> To: oracle-l_at_freelists.org
> Subject: Does anybody know this statement?
>
> Hi ,
>
> having issues with this statement. It is generating many shard cursors:
>
> SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=FALSE) OPT_PARAM('_ENABLE_VIEW_PDB', 'FALSE') */ "OWNER","OBJECT_NAME","OBJECT_TYPE#","PACKAGE_NAME","OBJECT_ID","ARGUMEN
> T_NAME","DATA_TYPE","DATA_LENGTH","DATA_PRECISION","DATA_SCALE","TYPE_OW
> NER","TYPE_NAME" FROM NO_CROSS_CONTAINER("SYS"."INT$DBA_ARGUMENTS")
> "INT$DBA_ARGUMENTS" WHERE "INT$DBA_ARGUMENTS".SHARING=1 AND ("INT$DBA_ARGUMENTS"."ARGUMENT_NAME" IS NOT NULL AND
> "INT$DBA_ARGUMENTS"."OWNER"=:1 AND "INT$DBA_ARGUMENTS"."OBJECT_NAME"=:2
> AND "INT$DBA_ARGUMENTS"."PACKAGE_NAME"=:3)
> ;
> Seems it is called from session that have different parameters set.
>
> Regards
>
> Lothar
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l