RE: Does anybody know this statement?

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