slowness for certain tool functions

[gopi]

Two power-users are reporting to me that 6.0.3 is slower than the previous 5.x version in certain tool functions.

Here are two examples that I witnessed:
1. hi-lighting a result set (just a few rows) takes 2 seconds.
2. after an sql query with a FOR UPDATE clause completes, we click the lock icon and it takes 2 seconds for the tool to come back. Then we paste a few rows (copied from another query) into the results of this for update and it takes seconds.

These guys 'message' data under very stressful conditions and need the instant response from the tool.

This did not happen in 5.x and they want to rollback to the previous version. Have you heard of this and do have anything that we should look at?

thank you kindly,
frank

 

[Marco Kalter]

I have never heard of this problem before. Does this happen for any result set? If, for example, you query the emp demo table and select all 14 rows this takes a few seconds?

 

[gopi]

It is very consistent but not 100% of the time.

SELECT tie_back, edit_dt FROM elogex_log WHERE tie_back = 1 for update; There are no rows returned (intentionally) and then we click the lock icon and the "+" and hi-light the row. It just took me 3 seconds to get into the columns to add data.

 

[Marco Kalter]

Maybe it's an Oracle Dictionary view performance problem. What happens if you go to Tools > Preferences > SQL Window and disable the "Show dictionary info in result grid" option?

 

[gopi]

Thanks Marco ... that was it and all the developers are happy.