Multiple Connections x Explain Plan

[Gustavo]

I got a problem with the Explain Plan functionality:
1. Set main window to A
2. Open a SQL window and set its connection to B
3. Enter a query that is valid in B, but not in A (for instance, make it reference columns that were included only in B)
4a. Use you keyboard shortcut to Explain Plan
5a. You'll get an Explain Plan window connected to A. Columns that don't exist in A will be replaced by binding variables.
4b. Press Explain Plan in toolbar, popup menu or main menu;
5b. While the window opens, you can see it is connected to A. Same problem from step 5a will happen;
6b. The connection is then changed to B, but the binding variables will already be there.

Regards,
Gustavo

 

[Marco Kalter]

We'll check it out and will fix it.

 

[Gustavo]

Thx! Current workaround is changing main connection to B.

 

[Gustavo]

BTW, the flow described in 4a and 5a only happens when you use your keyboard shortcut from a SQL Window. From a Program Window, behavior is always like steps 4b, 5b and 6b.

Regards,
Gustavo