Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Version SQL Developer 21.4 is very slow

lagerlofmDec 15 2021 — edited Dec 15 2021

Any query will take at least 8 seconds,even "Select * from Dual". Using previous version any test query execute below 1 second.
Are there any new settings that has to be performed to get reasonable performance in 21.4?

Comments

270337
I have tora 1.3.21 with Postgres and Oracle connections on Debian. I think that you should compile from tora source for Oracle connection. For this, you should download instant client from OTN and specify the instant client path in the parameters:

./configure with-instant-client with-oracle-includes=/usr/local/instantclient_10_2/sdk/include/ with-oracle-libraries=/usr/local/instantclient_10_2/lib with-oci-version=10G

You should review configure parameters file for new features or customize this for your platform
Billy Verreynne
Assuming that you've downloaded TOra with OCI support, this could mean that TOra is not seeing the OCI client drivers and therefore not presenting you with an option to connect via an Oracle client driver.

Check you LD_LIBRARY_PATH and make sure that it includes $ORACLE_HOME/lib - or download Instant Client and point the path there.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 14 2022
Added on Dec 15 2021
#sql-developer
46 comments
21,130 views
2 mentions