Skip to Main Content

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.

SQL Dev connection properties display very slow

user637881Feb 3 2021

Why does it take so long for connection properties to display? As recently as version 18.4, the connection properties would display instantly. In 19.4 and 20.4 it takes 20-30 seconds for the connection properties to display.
Other things are also slow. I exported my connection properties and it took about 20 seconds from the time I clicked Export Connections for the list of connections to display. Then when I selected the connections and clicked Next and clicked browse, it took another ~20 seconds for the Choose Export File dialogue to display. After selecting a file and clicking Save it took yet another ~20 seconds for the path and file to display in the dialogue.
Everything else I've done seems to work normally. These things are really slow. Is this a known issue? Is it me? I'm running SQL Developer on a Windows laptop with the included java option. I've monitored Task Manager while doing this and there's nothing unusual going on.
Thanks.
Jerry

Comments

Ashish Dave-Oracle
either there is Synchronization issue or
element which was there at time of recording is not there while playback ..could be defect
or name or id of elemet changed
647280
You should create a better custom dynamic variable to identify this element. Referencing a element by Index is not recommended or reliable. A recorded Index of 41 for the element inside form QUERYTEXTCOMPONENTS indicates that there are a lot of elements inside that recorded form, and that there is probably some dynamic nature to the page.

You should change the match to be i.e. formelement[INPUT](name="something" | id = "something")
1 - 2

Post Details

Added on Feb 3 2021
3 comments
2,327 views