explain plan creates a running/hung transaction
Brought to you by:
randolf_geist
Menu
▾
▴
#26 explain plan creates a running/hung transaction
When using SQLTools++ and using "explain plan" feature it seems that SQLTools++ creates a transaction that's not rolled back or committed. So if I leave SQLTools++ running for days the transaction will be open and at some point will be classified as hung.
Gennady,
your observation is correct. It's actually a long outstanding potential issue that the EXPLAIN PLAN transaction is left as it is. There is already a feature request "1912073 - Use SAVEPOINT when executing EXPLAIN PLAN" which covers this point, too.
Best Regards,
Randolf