Toad World® Forums

Cannot cancel "Explain plan"

I tried to display an execution plan using Ctrl+E, but since my DB had an “ORA-00257: Archiver error” at that moment, the statement froze and I could not cancel the execution.

Is there a way to add an option to cancel this action?

Yeah once the archiver stops, the DB will just hang any statement that does any kind of change to the database. That includes EP since EP involves inserting rows into the EP table.

EP normally happens very quickly - I don’t think we should make it cancellable (adding a cancel button, etc) because of this one rare event.

If you kill the session, or fix the archiver problem (which needs to be done anyway before you can do anything else), that ought to unstick Toad.

That’s fine with me, thanks for your answer!