Masiar
Masiar

Reputation: 21362

sqldeveloper taking too long to load the content of a DB

I am working with Ubuntu 18.04. After installing sqldeveloper I correctly log in and get a list of databases. Upon doubleclicking on one database to show its content sqldeveloper becomes extremely slow. I receive the following message right after double clicking on a DB:

UsersCache.fillIn() time = 4 ret==null?: true

And then it takes approximately 10-15 minutes to load the database I clicked. After that time I can interact with the DB, but if I want to open another one I have to wait about the same time. The size of the DB is big, but on my colleague's machines it is a matter of seconds. I tried to uninstall and install it again but there is no way it speeds things up. Running it in verbose doesn't give more info than the one-liner I pasted above.

EDIT: top shows a CPU usage of approximately 180% on the sqldeveloper process.

Upvotes: 0

Views: 3301

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22467

Inspecting with top shows I'm using java-1.8.0-openjdk-amd64 to run sqldeveloper

That is likely your problem. We do not support OpenJDK (or IBM's either for that matter.)

For the best experience we recommend and ONLY support the Oracle JDK - specifically, version 8.

I noticed on our download pages we do not say this specifically, but do point folks to the Oracle downloads for Java. I'll add a note/disclaimer so it is more obvious.

You can control the Java Home used or SQL Developer in the .sqldeveloper directory in your $HOME. There is a product.conf file in there, put the path to Oracle JDK 8 there.

Upvotes: 3

Related Questions