Very annoying delay when selecting cell value for the 1st time

[developeris]

Do a simple query like select t.* from table in the SQL window
Then try to select any value in the resulting table. When I do it for the 1st time, there's very annoying delay after I double click the cell to select the value. I monitored what pl/sql developer does in the background and it is doing those queries (maybe even some more). Not sure why, but would be nice to disable this, so that there's no delay. It's been issue since version 10 I guess. My current version is 12.

SELECT col.*, com.Comments
FROM sys.dba_tab_columns col, sys.dba_col_comments com
WHERE col.owner =
AND col.table_name =

AND com.Owner(+) =
AND com.Table_Name(+) =

AND com.Column_Name(+) = col.Column_Name
ORDER BY col.column_id

SELECT comments
FROM sys.dba_tab_comments
WHERE owner = bject_owner AND table_name = bject_name

 

[Marco Kalter]

The performance issue may to be caused by poor dictionary performance when resolving the table/view name and fetching column information. To verify, go to Preferences > SQL Window and disable the "Show dictionary information in result grid" option.

 

[developeris]

Thank you, so much better now.