Does anybody know this statement?

From: Lothar Flatz <l.flatz_at_bluewin.ch>
Date: Mon, 2 Nov 2020 17:27:51 +0100
Message-ID: <9fa5d856-4c42-fc9a-2da9-ef5e803b897e_at_bluewin.ch>



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
Received on Mon Nov 02 2020 - 17:27:51 CET

Original text of this message