Toad gobbles up memory when querying synonyms and then crashes (4214515)

WORKAROUND 1:

The issue happens when public synonyms are loaded. To reset it, follow the below steps:

1. Close Toad
2. Go to your User Files folder
3. In it are files named (logon schema name).SBFLT
4. Delete the files that correspond with whatever schema you were logged in as when the problem occurred. OR...edit the file and replace True with False

WORKAROUND 2:

To limit the number of synonyms to load, follow the below steps:

1. Start Toad but don't open Schema Browser yet
2. Go to main menu | Session | Schema Browser Filters. In this dialog you can set the default filters in the Schema Browser
3. Select Synonyms on the left
4. Change settings any way you want to limit the results so that you'll get less than 500 of them. Maybe you want to do "starts with A", or only get synonyms for a certain object type. Whatever works for you is fine
5. Hit OK, then open the Schema Browser and go to synonyms. It will be filtered however you configured it for step 4. You can change the filter from the schema browser if you want to

STATUS:

To be resolved in Toad for Oracle version 16.0