My Oracle Support Banner

Diagnosing Slowness in SQL Developer When Using JDBC Drivers (Doc ID 2992117.1)

Last updated on JANUARY 05, 2024

Applies to:

Oracle SQL Developer - Version 23.1 and later
Information in this document applies to any platform.

Goal

In some occasions, SQL Developer is slow to resolve queries, but it can also be slow while performing other actions, like switching to a different tab or expanding a DB object.
Some of this tasks may trigger queries in the background, and some times, those queries might get extremely slow, rendering the tool frozen.

The procedure described here allows to determine if the problem is in SQLDeveloper side, or in other side, either the database or the network connection to reach to the database.

The idea is to mimic the behavior SQL Developer has to query the DB to perform its internal tasks using a Java+JDBC program. If the slowness is also seen in this program, then the culprit is outside of SQLDeveloper.

As the method described here uses JDBC Thin driver, not all DB connections can be diagnosed with this method, but only those using the JDBC Thin driver.

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.