#26 explain plan creates a running/hung transaction

V1.21RC3
open
nobody
General (41)
5
2009-01-23
2009-01-23
Gennady Feldman
No

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.

Discussion

  • randolf_geist
    randolf_geist
    2009-01-23

    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