Reputation: 21362
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
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