Connection Management

Starting with release 24.1.1, opening a new SQL Worksheet creates a new, dedicated connection to the database. This means that long-running queries in your SQL Worksheet do not block other database requests.

You can control this behaviour using the Session per attached worksheet setting in Preferences.

1. From the File menu, go to Preferences and then select Settings from the sub-menu.

2. Under User, expand Extensions and then expand Oracle SQL Developer Extension for VS Code.

3. In the right panel, under Database Connections, in the Session per attached worksheet field, select off from the drop-down list to remove this setting.

   The default setting is on.