slow when table alias insert

[Kishu]

Whenever i try to give table alias before column name, PLSQL dev will go to "Not responding" for 5 to 10 seconds before leting me to type

Example:

select a.col1, a.col2
from transaction a
where a.Acc_number = 10000;

In the above example, whenever i insert alias "a" before column, screen of plsql dev will go to "Not Responding"(or freezes) for 5 to 10 seconds.

Kindly help

 

[Jens Naumann]

Hi, please check "Use DBA Views if available" in Configure/Preferences/Options. This may help if it's not selected.
Regards

 

[Kishu]

It's already enabled

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 12\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 12 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 12).