Using Toad 10.1.1.8 on Oracle 10.2.0.3
I received the “Query From H*ll” from one of my developers that he insisted I
help him to optimize. (very long, and very complex)
When I stuck it into the editor, and hit the little ambulance (never could
figure out the meaning of that icon!), it chugged for a few seconds, then TOAD
disappeared. (tried 3-4 times)
I brought up my memory/CPU monitors to see if it ran out of memory or something
like that, but it only popped up a little before dying.
Is there some diagnostic trace/log file I can send to youse guys to see what’s
Incidentally, my co-worker could bring up an explain plan. He is still using
David A. Hicken
UtahToad at gmail dot com
If you can’t get a compliment any other way, pay yourself one.
– Mark Twain