SQL Developer Hangs and Throws GC Overhead Limit Exceeded Error (Doc ID 2237489.1)

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.

Symptoms

Environment
SQL Developer 4.0, 4.1.3, 4.1.5
Solaris Sparc 64-bit 2.10

Problem
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.

Error

java.lang.OutOfMemoryError: GC overhead limit exceeded

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms