Oracle SQL Developer Pros and Cons
Oracle SQL Developer Pros
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 »
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 »
Oracle SQL Developer Cons
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 »
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 »