Toad hangs

All,

This relates to Toad for Oracle, Beta 13.0.0.10

My session went into a hang :frowning:
I had to close the session from Windows (close button in upper right-hand corner)
Luckily, Toad responded to the close command.

Too bad no error log was written.

If it happens again, what steps should I take in order to provide you with relevant diagnostic information?

Kind regards,
Abe Kornelis

Hi Abe,

When there is a hang, it is usually one of two things - Toad is either using all your CPU, trying to get something done, or waiting on Oracle to finish a query.

If the former, you should be able to see that in task manager on the “performance” tab. It will be easiest to see if task manager shows one graph per CPU. (View -> CPU History -> One Graph per CPU).

If the latter, CPU usage will be zero (at least due to Toad) and if you look in the database (using another Toad or sql*plus, you’ll find that in the Session Browser or in v$session, the query belonging to the “hung” copy of Toad will have session stuck on “ACTIVE”. If this is the case, go to the “Current Statement” tab and tell us what the query is. Maybe we can rewrite it.

The info above + a description of what you were doing in Toad is enough to get us started at least.

-John

John,

thanks for the info. I’m aware that a problem description such as the one I gave above contains insufficient info for further problem analysis.

It’s good to know where to look for additional clues in case the issue recurs.

Kind regards,
Abe