I tried using SQL Developer once, when I was still working as an employee, using one of the older versions. It worked nicely, and I liked that I didn't need an installation, it was very convenient. But after many years, when I tried to use it again, against the more advanced Oracle Database, it did not work. Something in the Java was not compatible. I would have had to install it again, and I didn't do so. But now I am properly studying the issue of installing a database of my own, versus installing a virtual box with an Oracle appliance inside. I will have to see which one works best for me because each one has pros and cons. I am not a DBA. So if I get involved in an installation problem, I don't know how to get out of it.
I would like to see better tuning modules. It could also be more intuitive, easier to use, not so complicated finding the things you need to do, and support background processes better.
Senior Database Consultant at Performing Databases
Consultant
2018-01-28T13:15:00Z
Jan 28, 2018
I think it would be great to have an overview over the sessions it opens so that we could easily see and control which connections to the database we want to keep open, which ones are hanging; and it would be great to make them independent from each other.
Oracle SQL Developer could improve the speed, it is a bit slow.
There is room for improvement in the Real Time SQL Monitoring.
The competing products have more features.
I tried using SQL Developer once, when I was still working as an employee, using one of the older versions. It worked nicely, and I liked that I didn't need an installation, it was very convenient. But after many years, when I tried to use it again, against the more advanced Oracle Database, it did not work. Something in the Java was not compatible. I would have had to install it again, and I didn't do so. But now I am properly studying the issue of installing a database of my own, versus installing a virtual box with an Oracle appliance inside. I will have to see which one works best for me because each one has pros and cons. I am not a DBA. So if I get involved in an installation problem, I don't know how to get out of it.
I would like to see better tuning modules. It could also be more intuitive, easier to use, not so complicated finding the things you need to do, and support background processes better.
If they had something on the Web then you wouldn't need to install it, just query, like Enterprise Manager.
Although the GUI is nice, it could still use improvement, a better user interface.
I would like to see it support NoSQL database.
There are many additional features I would like to see. The main one would be installation with an installer.
I think it would be great to have an overview over the sessions it opens so that we could easily see and control which connections to the database we want to keep open, which ones are hanging; and it would be great to make them independent from each other.