Why does putting cursor in results window take so long?

[SunDog]

If I execute a query for the first time, when I click in any of the cells of the results it there's a few seconds delay. If I re-execute the query, as long as I don't change the columns, there is no delay.

I'm assuming it's retrieving some meta data about the columns or something? Is there a way to turn it off without taking away functionality somewhere else?

 

[Marco van der Linden]

This would be the 'infamous' 'Show dictionary info in result grid' option in 'Preferences/SQL Window'. You will probably have that option checked. If you uncheck it this problem should be resolved.

 

[SunDog]

Yes, that was it. Thanks.

 

[Rajkiran Bingi]

Thanks Marco,
This was a problem for we all developers in the company for last 3-4 months until i got to this forum.

The delay is more only in 10g database, 9i database seems to query the dictionary pretty fast. Does this anything to do with 10g ?

Rajkiran.

 

[Marco Kalter]

This is indeed related to a 10g problem with the all_synonyms view. See also this topic .