There are too many sessions open when using Toad Data Point. Why are there so many sessions open at the same time?
Toad Data Point pools its connections. It does not close and re-open when executing. It keeps them open and if one is busy, when another is needed, it creates a new one.
In Options, under Editor | General, there is the option "Use individual connection for each open editor". That option can be unchecked to conserve on some connections.
However, the application will still have one connection for the Object Explorer and open a new one for other utilities, such as Export or the Data tab of the explorer. So, Toad Data Point cannot really be used without at least three connections.
Toad Data Point can also be configured to not open the Object Explorer by default. To do this, select Tools | Configuration Wizard and choose the Toad for Oracle layout.
