PL/SQL Developer Taking 100% of Database CPU

When using PL/SQL Developer (Allround Automations), a internal query is taking a lot of cpu cycles on database server (100% of a CPU).
Is this your problem? Please check if the query is like this:

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')

It’s caused by the Describe Context Option of Code Assistant. To disable it:
Tools > Preferences > Code Assistant and disable the “Describe Context” option.

desc_context.jpg

PL/SQL Developer is a commercial tool of Allround Automations.

By tool documentation:
“Describe context context to determine if the Code Assistant should describe the context of the current user, editor and program unit.
The minimum number of characters identified in the context described can be called before the word of how many characters need to be typed. Note that you can always manually invoke code assist, even if the characters have not been typed.
Description of standard functions in the case of default, Code Assist will describe the function of the standard the to_char, add_months. If you are familiar with these functions, you can disable this option.”

I hope it helped you.
See ya!
Matheus.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s