Recently I upgraded to Toad 184.108.40.206 and noticed when I log in I have two connections open by default rather than a single one as with the previous versions of Toad. Is there a way to turn this feature off? We have limitations on number of connections with certain Oracle database user accounts and this creates an issue. This can be seen in the Session Browser.
See screenshot Session Browser.png
The reason for the multiple sessions is that one of the sessions is a background Toad Session.
The “red” ACTIVE row always corresponds to the Session Browser itself.
One can filter the background Toad session by checking the Filter, “Exclude Background Toad Sessions”.
See screenshot: Sessions tab Filter.png
The background Toad session can be created by any of three Toad options being enabled.
1. Enabling the “Execute queries in threads” option
To disable this option, go to View | Toad Options | Oracle Transactions and uncheck “Execute queries in threads”.
2. Enabling the “Syntax Highlighting” option
To disable this option, go to View | Toad Options | Display and uncheck all the “Syntax Highlighting” options.
3. Enabling the “Session for Explain Plan” option.
If you choose “Separate Session” it causes a new session to be created right after connection.
To disable this option, drill to View | Toad Options | Oracle | Transactions and select “Main Toad Session”.