When connecting to the database with an Oracle user that has basic permissions, CONNECT, RESOURCE, CREATE SESSION - if you then expand the 'Other Schemas' node in the DB Explorer, the amount of time it takes to display data is very long, depending on number of objects. (This doesn't happen if the user has a DBA role, or is SYSTEM)
The session waits for the sql below upon first access to Other Schemas:
SELECT u.username
FROM sys.all_users u
WHERE u.username <> USER
AND EXISTS
(SELECT 'x'
FROM sys.all_objects o
WHERE o.owner = u.username)
With a SYSTEM user, it's fast as it uses a different query:
SELECT DISTINCT (owner)
FROM sys.dba_objects
WHERE owner < > 'PUBLIC' AND owner < > USER.
WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of SQL Navigator.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center