(Note: Pressing F1 will bring up the Help File page associated with your current location or window in TDP.)
“Use individual connection for each open editor”
Select this checkbox to create a separate database connection for each Editor (the first time you execute a statement) and a separate database connection for each Data tab in the Database Explorer (the first time you select the tab and data is queried). The database connection for each Editor and Data tab remain open until you close the associated window; however, the connections remain in an inactive state if a statement is not currently executing.
If cleared, all open Editors and Data tabs share the same database connection when the connection is inactive. See “Understand Toad Connections” (go to Help Menu | Toad Help) for more information.
Note: Although you can share a database connection, any commits apply to the selected window only.
Default: Selected
Note: When this setting is unchecked and you click the Apply button, it will also give a message box that states, “Not using separate connections for each Editor could cause problems if you run two scripts simultaneously from different Editors that modify connection properties.”
