background query on logon

[sdufour]

When you use pl/sql developer to log in to the database it runs the following query:

select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

Is there any way to disable this automatic querying?

 

[Marco Kalter]

If you go to Tools > Preferences > Code Assistant and disable the "Describe Context" option, this query will be prevented. In the upcoming 9.0 release you can change the query.

 

[sdufour]

You the man. Thanks.

 

[lparker]

Hi,
Could you please let me know how I can change the query in release 9. It is causing issues when we connect and I cannot disable the query from running anymore.

select s.synonym_name as object_name, o.object_type
from all_synonyms s, sys.all_objects o
where s.owner in ('PUBLIC', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

 

[Marco Kalter]

You can change or remove these queries by editing the CANames.sql file in the PL/SQL Developer installation directory. The file includes a description.

 

[lparker]

Thanks - I changed it to use DBA_ instead of ALL_ and all issues have been resolved.