Last updated on FEBRUARY 26, 2017
Applies to:Oracle SQL Developer - Version 4.1.3 and later
Information in this document applies to any platform.
SQL Developer 4.0, 4.1.3, 4.1.5
Solaris Sparc 64-bit 2.10
SQL Developer Hangs due to GC (Garbage Collector) overhead limit exceeded error.
Using SQL Developer to pull back 650k rows. Run the query in a single tab, the query returns all 650k rows. When open another tab and run the query, SQL Developer starts to hang and eventually comes back with a GC overhead limit exceeded error. When open a new SQL Developer instance/application and run the query, it runs the query successfully and returns all 650k rows. This also occurs when running the query under a user ID with DBA privileges.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms