I have a question about which session is used to explain plan a query in TOAD.
I have the following options set for Oracle -> Transactions:
Execute queries in threads - checked
Use a separate connection when TOAD is generating transactions - unchecked
If I open a tab and execute a query I can see in the session browser that a background session is created.
If I then run an explain plan of the query it appears that it is run in the main TOAD session.
This causes a problem for me as I need the explain plan in the same session as some of my queries reply on session context attributes that affect the plan.
Is this the expected behaviour for the settings above? The separate connection option mentions Explain Plan specifically so I would have thought unchecking this would cause it to use the query’s session.
If this is behaving as designed could I then ask for an enhancement to ensure the plan is run in the same session?