PL/SQL Developer code complete hang

[sasha2020]

Hello
We experience strange behavior while using PL/SQL Developer , code completion hangs while when we connected with DB User with 'Create session' privilege and grant one DB role with select grant on about 1000 tables

 

[sasha2020]

This query is running in DB while user type the query
just 'select * from usr1.'

++++++++++++++++++++++++++++++++++++
select object_name synonym_name, object_name, owner object_owner, status, object_type
from sys.all_objects o
where o.owner = bject_owner
and o.object_type in ('TABLE', 'VIEW', 'MATERIALIZED VIEW', 'SEQUENCE', 'SYNONYM', 'FUNCTION', 'PROCEDURE', 'PACKAGE', 'TYPE')
and o.object_name not like 'BIN$%'
order by o.object_name, o.object_type

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.06 0.06 0 0 0 0
Fetch 56 245.47 248.05 12687 8779130 0 1377
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 58 245.54 248.12 12687 8779130 0 1377
++++++++++++++++++++++++++++++++++++

 

[Marco Kalter]

Can you check if the query is unusually slow in this database? If it is very slow, perhaps your database administrator can check why it is slow and fix it?

To prevent this query you can go to Preferences > User Interface > Code Assistant, and disable the "Describe Users" option.

To prevent this query to specific object type you can go to Preferences > User Interface > Code Assistant, and disable object types under the "Describe Users" option.

 

[sasha2020]

Thank you a lot I'll try to implement this solution and update this thread