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 10.6.1.3. 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,
Mike
Michael S. Zarzycki, MTS | Manager of Engineering IT | Sensata Technologies,
Inc. | voice: 508-236-1015 | fax: 508-236-3701 | www.sensata.com | The World
Depends on Sensors and Controls