Hi,
My problem is that when you start any operation in Sqldeveloper, a select runs in the background, which is very annoying because it runs very slowly and that sqldevelopper freezes while that select is running. So I have to open another sqldeveloper and fire that session (so I can continue working in the previous sqldeveloper window).I turned off Tools -> Preferences -> Code Editor -> Completion Insight and both check boxes are un-checked. I did this but the error persists in the same way! I ask for your help
The select what running:
select object_type,owner,object_name,rank from ( select object_type,owner,object_name,0 rank from all_objects where object_name = :NAME and UPPER(owner) = nvl(:OWNER,:SCHEMA_CONTEXT) and object_type not in ( 'SYNONYM' ) union all select ao.object_type,ao.owner,ao.object_name,decode(UPPER(syn.owner), nvl(:OWNER,:SCHEMA_CONTEXT),10,20) from all_objects ao,all_synonyms syn where ao.owner = syn.table_owner and ao.object_name = syn.table_name and syn.synonym_name = :NAME and ( UPPER(syn.owner) = nvl(:OWNER,:SCHEMA_CONTEXT)
OR UPPER(syn.owner) = nvl(:OWNER,'PUBLIC') ) ) where ((:BODY_WHERE='Y') OR (object_type not in ('PACKAGE BODY'))) AND rownum < 100 order by rank, CASE object_type WHEN 'TABLE' THEN 0 WHEN 'VIEW' THEN 1 WHEN 'INDEX' THEN 2 WHEN 'PACKAGE' THEN 3 WHEN 'PACKAGE BODY' THEN 4 ELSE 5 END
More info:
Sqldeveloper version: Version 21.4.3.063
DB version: 19*