What users are saying about
Top Rated
1162 Ratings
Top Rated
487 Ratings
Top Rated
1162 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.5 out of 100
Top Rated
487 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.5 out of 100

Attribute Ratings

  • Oracle Database is rated higher in 3 areas: Likelihood to Recommend, Support Rating, Implementation Rating
  • Oracle SQL Developer is rated higher in 2 areas: Likelihood to Renew, Usability

Likelihood to Recommend

8.0

Oracle Database

80%
176 Ratings
7.8

SQL Developer

78%
72 Ratings

Likelihood to Renew

8.2

Oracle Database

82%
5 Ratings
8.7

SQL Developer

87%
3 Ratings

Usability

7.4

Oracle Database

74%
5 Ratings
8.1

SQL Developer

81%
2 Ratings

Support Rating

10.0

Oracle Database

100%
7 Ratings
7.0

SQL Developer

70%
3 Ratings

Implementation Rating

9.6

Oracle Database

96%
6 Ratings
9.1

SQL Developer

91%
2 Ratings

Likelihood to Recommend

Oracle

I believe Oracle Database is still the best RDBMS database which is the database to consider for OLTP applications and for Adhoc requests. They are good in Datawarehousing in certain aspects but not the best. Oracle is also a great database for scaling up with their Clusterware solution which also makes the database highly available with services moving to the live instance without much trouble.
Read full review

Oracle

Almost all development activities (the tool is called "SQL Developer", not "DBA Toolset") can be done easily and quick with [Oracle] SQL Developer. From data model creation (tables, views) to development (creation of procedures, functions, packages) and then testing (SQL Developer includes an easy to use debugger), all tasks can be performed in a single tool.
It may not be as complete as other solutions for DBA tasks like instance monitoring, but it is usually OK for development and testing environments if you want to do some basic troubleshooting.
Read full review

Pros

Oracle

  • Best thing about it is that it supports PL/SQL which is helpful in writing complex quarries easily.
  • Its storage capacity , backup and recovery features make it the best database storage tool available.
  • Other thing I like about this software is its interface is so good.
Read full review

Oracle

  • Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
  • The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
  • DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.
Read full review

Cons

Oracle

  • The memory demand and management makes it impossible to run it in a container.
  • It is hard to perform local unit testing with Oracle even using the personal edition (aggressive all the available memory grab for itself).
  • Lack of built in database migrations (e.g. as Flyway).
  • The need to install the Oracle client in addition to its drivers.
  • The cost of running it, especially in the Cloud.
  • Comes with very spartan community grade client/management tools whereas the commercial offerings tend to demand a premium price.
Read full review

Oracle

  • Inability to run multiple queries on the same database. You can only run one query on a given database.
  • Analytical models created from complex tables isn't accurate, and needs work.
  • Inability to view multiple tables of a database side-by-side. When trying to find correlations between tables, it would help to be able to see them at once on the same page.
Read full review

Pricing Details

Oracle Database

Starting Price

Editions & Modules

Oracle Database editions and modules pricing
EditionModules

Footnotes

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    SQL Developer

    Starting Price

    Editions & Modules

    SQL Developer editions and modules pricing
    EditionModules

    Footnotes

      Offerings

      Free Trial
      Free/Freemium Version
      Premium Consulting/Integration Services

      Entry-level set up fee?

      No setup fee

      Additional Details

      Likelihood to Renew

      Oracle

      There is a lot of sunk cost in a product like Oracle 12c. It is doing a great job, it would not provide us much benefit to switch to another product even if it did the same thing due to the work involved in making such a switch. It would not be cost effective.
      Read full review

      Oracle

      It allows most users to perform daily activities in a simple way, with no cost since the tool is free.
      Read full review

      Usability

      Oracle

      Many of the powerful options can be auto-configured but there are still many things to take into account at the moment of installing and configuring an Oracle Database, compared with SQL Server or other databases. At the same time, that extra complexity allows for detailed configuration and guarantees performance, scalability, availability and security.
      Read full review

      Oracle

      It has lot of features that are required in SQL editor. It does the job well and is reliable. It is user friendly, integrates with different databases, and can be used for advanced database management activities.
      Read full review

      Support Rating

      Oracle

      1. I have very good experience with Oracle Database support team. Oracle support team has pool of talented Oracle Analyst resources in different regions. To name a few regions - EMEA, Asia, USA(EST, MST, PST), Australia. Their support staffs are very supportive, well trained, and customer focused. Whenever I open Oracle Sev1 SR(service request), I always get prompt update on my case timely. 2. Oracle has zoom call and chat session option linked to Oracle SR. Whenever you are in Oracle portal - you can chat with the Oracle Analyst who is working on your case. You can request for Oracle zoom call thru which you can share the your problem server screen in no time. This is very nice as it saves lot of time and energy in case you have to follow up with oracle support for your case. 3.Oracle has excellent knowledge base in which all the customer databases critical problems and their solutions are well documented. It is very easy to follow without consulting to support team at first.
      Read full review

      Oracle

      Oracle support is good. In general a get good and quick answers to my questions.
      Read full review

      Implementation Rating

      Oracle

      Overall the implementation went very well and after that everything came out as expected - in terms of performance and scalability. People should always install and upgrade a stable version for production with the latest patch set updates, test properly as much as possible, and should have a backup plan if anything unexpected happens
      Read full review

      Oracle

      Just download and uncompress!
      Read full review

      Alternatives Considered

      Oracle

      Oracle is more of an enterprise-level database than Access and SAP Adaptive Server Enterprise isn't getting developed much (some people wonder how close it is to end of life) but SQL Server is miles ahead of Oracle IMO in terms of user experience and comparable in terms of performance AFAIK. As stated, a vendor forced our hand to use Oracle so we did not have a choice. If you are looking for help with an issue you are having, there are lots of SQL Server articles, etc. on the web and the community of SQL Server developers and DBA's is very strong and supportive. Oracle's help on the web is much more limited and often has an attitude that goes with it of superiority and lacking in compassion, IMO. For instance, check out the Ask Tom Oracle blog - a world of difference. If you choose Oracle, go into it with eyes wide open.
      Read full review

      Oracle

      I have started to use Toad for Oracle recently because it is easier to sort and filter results, due to their memory sort feature that puts the results from your query in memory so that you don't have to rerun your query. I have used SQL Developer to easily update records in tables that I need to fix. I haven't found an easy way to do this in Toad other than writing SQL insert statements.
      Read full review

      Return on Investment

      Oracle

      • Oracle Database 12c has had a very positive impact on our ability to build strong and robust custom applications in house without the need to come up with our own methods of data storage and management.
      • Oracle Database 12c has the strongest user interface of any database I have worked with and continuously is improving its strength with the addition of support for JSON and XML type objects in the database.
      • Oracle Database 12c is sometimes very heavy and DBA intensive, but the benefits far outweigh the costs, which we need to spend on DBA support for enabling security and access features.
      Read full review

      Oracle

      • It gives 100% return on investment as it is free of cost.
      • No need to have multiple tools for each database
      • Considering the employee training, so one can save money on training, as it is not very hard to use so still savings.
      Read full review

      Add comparison