Why is there a second, inactive, Toad session running in Toad 11 called "TOAD background query session"?
Can it be disabled?
In Toad 11, it is persisting a query for highlighting object names in the Editor:
SELECT object_name nam, DECODE (object_type, 'TABLE', 1, 'VIEW', 2, 3) typ
FROM user_objects
WHERE object_type IN ('TABLE', 'PROCEDURE', 'PACKAGE', 'FUNCTION')
The extra session can be disabled by unticking the 3 syntax highlighting options that are running in the Editor.
To disable the session:
1. Go to: View | Toad Options | Editor | Display | Syntax Highlighting
2. Untick: 'Highlight table names', 'Highlight view names', 'Highlight stored procedure names' & press OK.
3. Disconnect from the database
4. Reconnect to the database
5. The session will no longer show in Session Browser
