Oracle SQL Developer Pros and Cons

Oracle SQL Developer Pros

Martin Klier
Senior Database Consultant at Performing Databases
I like it because it's very similar in output to SQL *Plus, and it has many convenience features that make it easier to read the data and use the basic reporting features it provides.
It's easy to deploy, I can copy it onto the system and run it without having to install it and this makes it a very good solution for quick use.
View full review »
Carlos Thomas
Senior Partner at a manufacturing company with 1-10 employees
You can install it on every platform. It just works. The other thing is that it's free. And Oracle is committed to the development of the tool, so it has been improving.
View full review »
Peter Silwinski
Senior Consultant at Contracted by Siemens
I have a lot of flexibility with it.
The newer version has a lot of new features. It generates output and scripts for your Ultrix. It can generate JSON, XML, etc.
You do not have to install it, just dump it on the OS, then use it.
View full review »
Find out what your peers are saying about Eclipse Luna vs. Oracle SQL Developer and other solutions. Updated: November 2019.
383,725 professionals have used our research since 2012.
sciodire530439
Sócio Diretor at a tech services company with 201-500 employees
Using execution plan, I am able to do lots of query tuning.
View full review »
Eugene Kats
Data Architect / Data Modeler - Contract at a consultancy with 1,001-5,000 employees
Ability to analyze performance, using Explain Plan statement.
View full review »

Oracle SQL Developer Cons

Martin Klier
Senior Database Consultant at Performing Databases
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.
Scalability has room for improvement. Often if you have to do a heavy load of queries or are getting large result sets you have to be careful not to overload the Java virtual machine that's running.
View full review »
Carlos Thomas
Senior Partner at a manufacturing company with 1-10 employees
There is room for improvement in the Real Time SQL Monitoring.
It's more stable sometimes and less stable other times. I have used it in Windows, Mac, and Linux. It's variable, it's not the same stability. I think that can be improved on.
View full review »
Peter Silwinski
Senior Consultant at Contracted by Siemens
The competing products have more features.
View full review »
Find out what your peers are saying about Eclipse Luna vs. Oracle SQL Developer and other solutions. Updated: November 2019.
383,725 professionals have used our research since 2012.
DBA22cf
DBA at a tech services company with 51-200 employees
The stability depends on what version you're using. There are more successful versions and are less successful versions. For example, 17.3 is less successful. There were many bugs. Now, we are trying to pull all the developers to upgrade to 17.4.
View full review »
sciodire530439
Sócio Diretor at a tech services company with 201-500 employees
The initial setup is always a problem, it cannot find the Java SDK.
View full review »
Daniel Grosovoi
DBA at Yediot
If they had something on the Web then you wouldn't need to install it, just query, like Enterprise Manager.
View full review »
Eugene Kats
Data Architect / Data Modeler - Contract at a consultancy with 1,001-5,000 employees
It would be nice to have the ability to access DBs than Oracle.
View full review »
Dror Azar
CEO at ITFS
I would like it to support background processes better.
View full review »
Find out what your peers are saying about Eclipse Luna vs. Oracle SQL Developer and other solutions. Updated: November 2019.
383,725 professionals have used our research since 2012.
Sign Up with Email