When monitoring large numbers of Databases, the program runs out of memory and crashes
WORKAROUND
Disconnect All connections.
1. Increase the refresh rate further to a very high value like 5 mins from View|Options|Data Refresh Rates.
2. Reduce the History repository period to 1 hour from View|Options|History limits.
3. Right click on each connection profile and select Properties|Overhead tab and change the Overhead settings to "Lower impact". This will disable certain metric to reduce the load on the client as well as the database.
STATUS
Waiting for fix in a future release of Spotlight on Oracle