Issue - want to spawn windows with the same session

[ashish_mistry]

Hi,

The issue I am facing is that I would want to spawn new windows in an existing session of my editor

this is why :
1) Explain plan shown by plsql developer is mostly never correct if there are underlying materlized views as the explain window opens in a new session and I cannot execute any other commands/sql/alter session statements in the explain plan window itself

I set query rewrite enabled , query rewrite integrity values for the session, the query uses an underlying Materialized views but when I press F5 to see the plan it shows a plan that does not use Materlized views

2) Debug and Test windows
Wouldn

 

[Marco Kalter]

You can enable "Dual Session" mode. This way all SQL Windows, Test Windows, Command Windows, and so on will use the same session.

This will not allow you to access a debug session though. This is always a secondary session.

 

[ashish_mistry]

Thanks Marco,
I was aware of the feature but that is exactly what i do not want to do as it may be too risky with 20-30 windows/editors open

It would be good to have this feature for Explain plan windows, and maybe debug test windows too
esp. explain plan, would be good to have say an explain plan tab in the same editor window to get the plan for a current query when the tab is accessed

Thanks,
Ashish