What users are saying about

1010data

5 Ratings

Oracle Database 12c

Top Rated
211 Ratings

1010data

5 Ratings
Score 4.7 out of 101

Oracle Database 12c

Top Rated
211 Ratings
Score 8.5 out of 101

Add comparison

Likelihood to Recommend

1010data

The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.

Oracle Database 12c

If you are tied into using Oracle for your business data storage needs, it will fully recommended you use the latest and greatest version of the software. And Oracle 12c is just that. It provides amazing support, new features and functionality, better security and ability to query, improved management of indexes by means of compression, and support for new data document standards like JSON.

Pros

  • Crunches huge datasets
  • Has versatility in functionality and grouping capabilities
  • Native XML macro language is easy to master
  • The platform has great visualization tools
  • Oracle12c Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. It is one of the oracle finest solution for disaster recovery and data corruption. In this setup - You have one Primary and one or more standby DB in two or more different geographical locations. So, if the database hosted in one location goes down due to planned or unplanned outages, you can easily operate business from remote location database.
  • Oracle12c RAC provides Scale-up architecture. Oracle RAC ensures High Availability. In RAC architecture you have at least two or more physical servers with same configuration connected thru interconnect network. So, if one server goes down, you still have database running from the other(surviving) nodes. In this architecture - You can have appropriate on-demand services. You can easily scale up Servers, CPU, Memory.
  • Oracle12c has amazing Performance Tuning framework. You can very easily fine-tune databases running on Oracle12c. Some of the great features are Oracle ADDM, AWR report, ASH report, SQL report, SQL Plan Management, Tuning Advisor - SQL Tuning Advisor, SQL Access Advisor.
  • Oracle12c has great Back and Recovery solution using Oracle RMAN(Recovery Manager). Without much intervention and work, you can easily restore the database backup whenever and whereever you want.
  • Oracle12c provides great security standards that meet fundamental data security requirements - Data Confidentiality, Data Integrity and Data Availability.
  • Oracle Label Security, Oracle Data Redaction, Oracle Data Masking and subsetting, Transparent data protection, database storage encryption, Unified Auditing, and Oracle fine-grained audit are some great oracle features.

Cons

  • The ten.do interface could use more detailed documentation
  • License costs for Oracle Database are pretty high and not affordable at all for some companies
  • Installation and maintenance of the database is quite difficult (not specifically in this release)

Likelihood to Renew

No score
No answers yet
No answers on this topic
Oracle Database 12c8.3
Based on 2 answers
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.

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
Oracle Database 12c8.2
Based on 1 answer
lack of mobile version of product, otherwise 10

Implementation

No score
No answers yet
No answers on this topic
Oracle Database 12c7.3
Based on 1 answer
easy database installation even for high availability environmentsreliable infrastructure if correctly installed

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
I personally have also supported both Microsoft SQL Server and PostgresSQL.We have used Microsoft SQL Server for some smaller projects where the vendor only supports that environment. But whenever there is a choice, we use Oracle Database 12c. Students access our systems at all hours of the day and night. Therefore we must be operational 24x7. Oracle's RAC evironment is a true cluster system. Microsoft SQL Server clustering does not allow the same fault tolerance, always up environment that we need.PostgreSQL is freeware. Because of that we do not feel like it is appropriate for large mission critical applications. There is no vendor to call for direct support, although some companies do sell support services. Patches, such as security fixes are not released on a regular basis.

Return on Investment

  • This has sped up the process of analysis.
  • We can now automate process which were performed manually.
  • Analysis can be performed more frequently.
  • As a 30+-year installed Oracle database customer, the original licenses, including required increases in CPU counts, have provided the requisite reliability, stability, scalability, and performance demanded of any such product. As you will always note from Oracle, buying once and bigger, will probably cost you less than buying often and more frequently (your contract terms tend to change with each change in packaging.) As a public utility, a five-9's product is the minimum consideration for anything running on our infrastructure which delivers to our customers. Oracle has delivered on that requirement, and keeps the water flowing every day. That's our primary ROI for any investment we make.
  • Because we are also on a very long and perpetually challenging budget cycle, the freedom other commercial organizations have to "Sell more, then Buy more," doesn't apply to our organization. While we'd like to standardize every database on 12c, cost limitations of upgrading many other applications to a certified combination level, prevents us from moving ahead with that objective. In that regard, sometimes staying on 11gR2 (which has a 2 year shorter lifespan at present), is a required strategic decision, which means we are back to managing multiple technology versions, with the associated challenges. Some of those old applications sitting on a 100MB 8i Oracle Home, would experience a 2000% increase in storage footprint if migrated to an equivalent 12c version (thus consolidation and retirement are always factors considered with such legacy upgrades.)
  • DBA's who have experience only with 12c and future releases are less likely to have any experience working with non-GUI managed environments (ones without Oracle Cloud Control, Database Express, ApEx, and such) and Oracle's policy on documentation and software cutoffs for "retired/end-of-support" releases can be frustrating. Your organization has a merger with another one that happens to run older applications on older releases (such as 9i or 10g.) They're on a different OS platform. Your task is to re-host, migrate, then consolidate the applications. Good luck finding the installers and patches for an old release. This is one of those "Hey, the document is on a floppy disk. Anyone still have a floppy drive around to read it?" challenges that tends to surface long after the solutions stop being delivered.

Pricing Details

1010data

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Oracle Database 12c

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details