High CPU utilization

[rufford]

PL\SQL Developer is causing High CPU utilization.

I am a DBA, I , myself use the software for some development and I have noticed that all Developers using the the software are having session utilizing the all the CPU and bring down the server.

I trace the sessions and all of them are executing the following:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

select s.synonym_name object_name, o.object_type
from sys.all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', user)
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')

 

[Ram Kumar (MICROS)]

We started seeing many pl/sql developer sessions taking an unusual amount of CPU time for long periods of time.

This tool seems to be doing some processing even if the users are not doing anything.

It looks like it is a setting that is causing this. Please do the following

 

[Marco Kalter]

This query is executed once in a background thread when you connect in PL/SQL Developer. It is related to the "Describe Context" option of the Code Assistant preferences. You can disable this to prevent the query.

 

[rufford]

All,

Thanks for your help!

Thanks a lot!!!