Oracle SQL Developer Reviews

Database querying, curating scripts, and database tuning.

We have a QA team and we don't want to buy a special product for them just to query the database, so we use Oracle SQL Developer.

It's free.

If they had something on the Web then you wouldn't need to install it, just query, like Enterprise Manager.

It's stable. It's a little bit slower because of Java, but it's stable.

It's scalable.

We used to use SQL *Plus, but we needed something with more of a GUI for users who are not technical users.

When selecting a vendor the most important criterion is the price.

Setup is very easy.

This was the only free solution we evaluated. And it belongs to Oracle so that was good for us.

Toad is much faster to use. It's not Java which takes a lot of time to query and create things. You just install it on Windows and it works perfectly. Much better than the Java.

Just try it. It's very easy.

We use it for test queries, before implementing scripts for monitoring. Also, we use it for querying and getting data of the whole environment monitored with our products.

Helps us to test and to develop scripts for monitoring applications.

I only use it for connecting to instances and to do queries, I don't know details of the features.

Queries. 

No stability issues as of yet.

No scalability issues as of yet.

I have not used it.

No, I've always Oracle SQL Developer.

It's very easy to use.

The speed with which you can build SQL statements and PL/SQL code has been very valuable. In addition, it simplifies how we manage database objects and connections to different data sources.

It has reduced the time it takes to manage data. We use the product for data analysis, building SQL statements to construct reports, and analysis and optimization of SQL statements.

The interface could be friendlier for the DBA by having the dashboard show real-time statistics from the database engine. It could also give details from active sessions, details about PGA, information about background processes like DBWR, LGWR and RVWR, alerts when you pass thresholds, logical reads, physical reads, and direct physical leads.

We have used the product for about 2 years.

It has been stable.

There have been no issues with scalability.

Customer service is very good.

It has been excellent for us.

Initial setup is simple. Once you have a connection to the data source, you can begin working. We implemented in-house and there were no issues.

It is a very good investment for the benefits that it offers.

Download it, install it and never stop using it. I would give it a ten out of ten.

Among the most valuable features is the tight integration with database features/options.

• Being able to see all of the database objects.
• Being able to create objects.
• Being able to edit objects.
• Being able to open data models.
• Being able to review AWR and ASH reports.

Standardized tool.

The interface could be friendlier for the DBA by having dashboards, like Enterprise Manager.

Since 2015.

There are occasional run time issues.

I did not encounter any issues with scalability.

Technical support is great. They are extremely responsive and helpful with issues/questions.

Yes, Toad. I changed because my new company didn’t have a Toad license.

Initial setup is very easy. Download, unzip, and start using it.

A license is not needed for this product.

I did not evaluate other options. Invest some time on standardizing the preferences.

Invest some time in standardizing the preferences.

It's for monitoring the database and for PL/SQL Developer.

We can install it on each machine, every user can install it by himself. And we have a lot of support for the utility from Oracle, for free.

It's free and very user-friendly.

I would like to see it support NoSQL database.

Stability is very good.

Scalability is very good.

Technical support is helpful. We open an SR with Oracle and they answer us in the SR.

We used Toad. We move to this solution because it's free. Toad costs a lot of money.

The initial setup was straightforward.

We manage user databases and we see execution plans for performance. It's performing very well.

We can understand where everything is and we can we work with it very easily.

It's free, it's very easy to use, and has a nice GUI.

Although the GUI is nice, it could still use improvement, a better user interface.

It's a stable solution.

It's scalable. Everybody can install it on his or her machine.

Technical support is good.

It's easy to set up.