Toad World® Forums

Run Explain Plan in Separate Thread


In prior versions of Toad, I was able to run explain plan on a query while it
was running, but not in my config of In the Transaction section of
options, I have:

Execute Queries in Threads: ON

Execute Scripts in Toad Session: ON

Commit After Every Statement: OFF

Use a separate connection when Toad itself is generating transactions: ON

Best regards,

Michael S. Zarzycki, MTS | Manager of Engineering IT | Sensata Technologies,
Inc. | voice: 508-236-1015 | fax: 508-236-3701 | | The World
Depends on Sensors and Controls