RE: Does anybody know this statement?

  • From: <dimensional.dba@xxxxxxxxxxx>
  • To: <l.flatz@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 2 Nov 2020 09:07:01 -0800

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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf 
Of Lothar Flatz
Sent: Monday, November 2, 2020 8:28 AM
To: oracle-l@xxxxxxxxxxxxx
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



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



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


Other related posts: