Once we upgraded our database to 10.2.0.4. If we login as schema owner , the list of objects are duplicated into thousands. This is only happening for procedures , packages , functions. Other objects are just fine. The issue is when connecting as the schema owner, not as DBA roles viewing other schemas.
The issue looks like it is coming from this query which seems to populate the list of objects (tracing):
select o.*, NVL(d.debuginfo, 'F') DEBUGINFO, nvl(p.AUTHID, 'CURRENT_USER') authid
from (
Select object_name, object_type, decode(status, 'VALID', 'V', 'I') status, last_ddl_time, object_id, created
from sys.user_objects
where 1=1
and object_type in ('PACKAGE', 'PACKAGE BODY')
) o, sys.all_probe_objects d
,(SELECT object_name, AUTHID
FROM sys.user_procedures
where 1=1
GROUP BY object_name, AUTHID) p
where p.object_name (+) = o.object_name
and o.OBJECT_ID = d.object_id (+)
And D.Owner (+) = :own
And O.Object_Name = D.Object_Name (+)
And ((d.object_type is null) or (d.object_type in ('PACKAGE', 'PACKAGE BODY')))
order by 2, 1
Is Toad compatible with 10.2.0.4?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center