Doubleclick = TOAD Freeze

Toad for Oracle
1

Hi.

I’ve used TOAD for years now, updateing regulary.
Last week, I was suddenly unable to “open a user” (doubleclick on a user to get a popup windows with the user information)
I have the same problem with roles.
The problem is not associated with one signle database - every database i connect to show the same problem.

Only out is to shutdown Toad fra the task manager.

I updated from 10.1.x.x to 10.5.1.3 - still same problem.
Yes … I have restartet my computer several times.

(running Windows 7)

Message was edited by: asj_859 (Typo - but I’m sure I did’nt find them all :slight_smile:

2

Still don’t know why the problem occured, but it works (for) now.

Completely uninstall / delete directories.
Then a reboot
… and a new install.

3

It sounds like a query taking a long time to execute.

To find out what the query is, launch Toad and get it ‘stuck’, then
go to another instance of Toad, connect to the same DB, find the first
Toad’s session in the 2nd Toad’s session browser, and go to the
‘current sql ’ tab. Let me know what the query is.

You probably need to collect statistics on your database.