Slow select on wide table with 460 columns

[dwwallac]

I have a simple query (select count(*) from

) that returns a result of 16,833 within .31 of a second from sqlplus or via Oracle's sql developer gui. However when I attempt the same in plsql developer the query just locks up the sql window screen in executing mode with an hour glass and never returns a result.
Has anyone else had similar problems with wide tables ?

Regards,
David

 

[Marco Kalter]

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

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

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