Performances are really bad when navigating on dmu gui running sql_id 42n51tg3sdmpn checking type in source$ (thousands executions!) as per below statement
SELECT
COUNT (*)
FROM
sys.source$ s
,sys.obj$ o
WHERE
s.obj# = o.obj#
AND o.type# = 13 /* TYPE */
AND s.rowid IN (
SELECT
decode (
substr (
CAST (
e.row_id AS varchar2 (4000)
)
,1
,1
)
,'*'
,NULL
,e.row_id
)
FROM
sys.dum$exceptions e
WHERE
e.obj# = (
SELECT
o.obj#
FROM
sys.obj$ o
,sys.user$ u
WHERE
o.owner# = u.user#
AND o.name = 'SOURCE$'
AND u.name = 'SYS'
)
)
tried many options, including sql_profile (with better performance but not working when PDB is started in upgrade mode.
Any reason why the statement is being executed so often (looks like recursive execution) ?