PeerSpot user
Ingeniero Especialista at a comms service provider with 10,001+ employees
Real User
​Helps us to test and to develop scripts for monitoring applications

What is our primary use case?

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.

How has it helped my organization?

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

What is most valuable?

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

What needs improvement?

Queries. 

Buyer's Guide
Oracle SQL Developer
April 2024
Learn what your peers think about Oracle SQL Developer. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
770,292 professionals have used our research since 2012.

For how long have I used the solution?

Three to five years.

What do I think about the stability of the solution?

No stability issues as of yet.

What do I think about the scalability of the solution?

No scalability issues as of yet.

How are customer service and support?

I have not used it.

Which solution did I use previously and why did I switch?

No, I've always Oracle SQL Developer.

What other advice do I have?

It's very easy to use.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user477966 - PeerSpot reviewer
DBA at a aerospace/defense firm with 1,001-5,000 employees
Real User
The speed with which you can build SQL statements and PL/SQL code has been very valuable.

Valuable Features

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.

Improvements to My Organization

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.

Room for Improvement

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.

Use of Solution

We have used the product for about 2 years.

Stability Issues

It has been stable.

Scalability Issues

There have been no issues with scalability.

Customer Service and Technical Support

Customer Service:

Customer service is very good.

Technical Support:

It has been excellent for us.

Initial Setup

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.

ROI

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

Other Advice

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

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user498708 - PeerSpot reviewer
it_user498708Senior Principal Product Manager at a tech company with 10,001+ employees
Real User

On the room for improvement area, we agree. That's why we introduced the Instance Viewer to the DBA panel. You'll need to upgrade to v4.1 to take advantage of this feature.

Buyer's Guide
Oracle SQL Developer
April 2024
Learn what your peers think about Oracle SQL Developer. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
770,292 professionals have used our research since 2012.
it_user729174 - PeerSpot reviewer
Cloud Transf & Migr Innov Sr Principal at a tech services company with 10,001+ employees
Real User
Facilitates very good integration with database features/options

What is most valuable?

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.

How has it helped my organization?

Standardized tool.

What needs improvement?

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

For how long have I used the solution?

Since 2015.

What do I think about the stability of the solution?

There are occasional run time issues.

What do I think about the scalability of the solution?

I did not encounter any issues with scalability.

How are customer service and technical support?

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

Which solution did I use previously and why did I switch?

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

How was the initial setup?

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

What's my experience with pricing, setup cost, and licensing?

A license is not needed for this product.

Which other solutions did I evaluate?

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

What other advice do I have?

Invest some time in standardizing the preferences.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user809577 - PeerSpot reviewer
DBA at a tech vendor with 1,001-5,000 employees
Real User
Very user-friendly and free, with good support

What is our primary use case?

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

How has it helped my organization?

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.

What is most valuable?

It's free and very user-friendly.

What needs improvement?

I would like to see it support NoSQL database.

What do I think about the stability of the solution?

Stability is very good.

What do I think about the scalability of the solution?

Scalability is very good.

How are customer service and technical support?

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

Which solution did I use previously and why did I switch?

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

How was the initial setup?

The initial setup was straightforward.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Real User
Enables us to manage user databases but user interface could be nicer

What is our primary use case?

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

How has it helped my organization?

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

What is most valuable?

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

What needs improvement?

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

What do I think about the stability of the solution?

It's a stable solution.

What do I think about the scalability of the solution?

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

How is customer service and technical support?

Technical support is good.

How was the initial setup?

It's easy to set up.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user809580 - PeerSpot reviewer
DBA at a tech services company with 51-200 employees
Consultant
The solution is free but it needs a conventional installer rather than a .zip file
Pros and Cons
    • "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."

    What is our primary use case?

    We use it to support developers. Its main use is for developers to connect to a database.

    How has it helped my organization?

    The main benefit of SQL Developer is that it is free.

    What is most valuable?

    The possibility to connect.

    What needs improvement?

    There are many additional features I would like to see. The main one would be installation with an installer.

    What do I think about the stability of the solution?

    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.

    What do I think about the scalability of the solution?

    No problem with scalability.

    How are customer service and technical support?

    I used technical support twice. They were not supportive. I didn't get a solution. During the support session, we simply upgraded to the next version. The bug was then gone.

    Which solution did I use previously and why did I switch?

    We didn't have a previous solution but, in parallel, we use Toad; its license is expensive.

    The important criteria for me when selecting a vendor are good support and an affordable price.

    How was the initial setup?

    I think a conventional installation, with an installer, would work better. Now, it is a zipped .exe.

    What other advice do I have?

    Using this solution depends on budget and on the number of developers. The more developers you have, the less you will want SQL Developer.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Buyer's Guide
    Download our free Oracle SQL Developer Report and get advice and tips from experienced pros sharing their opinions.
    Updated: April 2024
    Product Categories
    IDE
    Buyer's Guide
    Download our free Oracle SQL Developer Report and get advice and tips from experienced pros sharing their opinions.