Oracle Database 12c

4.2
(540)

Helps customers lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Work for Oracle Database 12c?

Learning about Oracle?

We can help you find the solution that fits you best.

Oracle Database 12c Reviews

Chat with a G2 Advisor
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 540 Oracle reviews
LinkedIn Connections
Oracle review by Mehmet James B.
Mehmet James B.
Validated Reviewer
Review Source
Sign in to G2 to see what your connections have to say about Oracle Database 12c
Oracle review by Steve M.
Steve M.
Validated Reviewer
Verified Current User
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Oracle 12c in AWS Cloud"

What do you like best?

The ease of setup in Amazon Web Services makes Oracle 12c a solid choice for Relational Database needs, along with tools that we are used to having like Oracle SQL Developer. The clustering of 12c gives us reliability, failover and confidence that our data is in good shape.

What do you dislike?

Was a bit difficult to get security group rules in place from Amazon Elastic Beanstalk after we had setup Oracle RDS with public access. We had thought that meant public within AWS as well, but that's not the case. It didn't take too long to find the security group which needed changed though, and after that we got to focus on our implementation.

Recommendations to others considering the product

It's a powerful and reliable relational database system that brings many features to the table and maturity of Oracle's well-developed product.

What business problems are you solving with the product? What benefits have you realized?

Storage of a mission critical product we are delivering and benefits of having a team thats used Oracle Database for many years and a code base to integrate easily with 12c.

What Relational Databases solution do you use?

Thanks for letting us know!
Oracle review by Aman S.
Aman S.
Validated Reviewer
Verified Current User
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Powerful RDBMS database management software"

What do you like best?

1. As a user i never found this kind of power full relational database management system software.

2. With the new features and functions it is easy for developers to develop their projects in more secure and in more easy way.

3. The export/import functionality of oracle 12c is damn good even you can export your database or even one table in multiple format and even as a structure or as a text.

What do you dislike?

1. The one thing i wanna say that the installation of oracle 12c is not so much familiar.

Recommendations to others considering the product

I recommend to every one to use Oracle 12c at least for once it will full fill all of your requirements..

What business problems are you solving with the product? What benefits have you realized?

To meet the client requirement it helps developer to meet client needs.

Oracle review by Jose Alejandro  C.
Jose Alejandro C.
Validated Reviewer
Verified Current User
Review Source
content

"Oracle 12c works perfect for and stable big company with hard database structure"

What do you like best?

I like this software because i been using it for years, since oracle 10 and i'm experimented on it, for me its easy to use. It have been improving each version, right now is on top of database, fiable, good enterprise support and has strong security, easy way to do querys.

What do you dislike?

Oracle is one of the biggest and more stable database, but it's a kind hard to learn how to use it and administrate it. its becomes involved with many librarys and files on the operating systems so you will have to know a good knowlodge of oracle and the os.

Recommendations to others considering the product

The new oracle 12c is always getting updates and patches for improve their functionality and security, it can be used for little, middle, big and very big databases, if you are looking for a new implementation or migrating to oracle is worth it, it is a little hard to understand and get knowledge, but after you got it, you will have speed on the querys and security of your data.

What business problems are you solving with the product? What benefits have you realized?

I'm actually working in a big company that has an Oracle 12c database of 12 terabytes, it is hard to administrate and critical for the business if it does get down, works perfectly with aix and can be boost with powerha or oracle rac, its important to be with oracle because you have big support and the fiability that the database will always improving their performance.

Oracle review by David L.
David L.
Validated Reviewer
Verified Current User
Review Source
content

"Best and Most Versatile Database"

What do you like best?

I love the quick and easy SQL. I know its not 100% standard, but outer joins with (+) are so much easier to read than "left join ... on ...". It is also easy to optimise and there are loads of parameters for all types of circumstances. I also like that I can set up DBLinks to for example SQL Server and write Oracle SQL that works against SQL Server. And I like the PL/SQL. One can write detailed and complex programs inside the Oracle database and its amazing how quickly they run.

What do you dislike?

Oracle has got very big and it is difficult to keep up to date with all the different developments. I focus on the Oracle PL/SQL programming and I use Delphi for the front end. At the moment I am learning how to do REST inside the Oracle database, and the documentation and set up is rather complex and it is time consuming to set up something that shouldn't be so complex. Oracle SQL Developer, the free DML and DDL tool that comes with Oracle is good, but slightly buggy and I much prefer Toad.

Recommendations to others considering the product

A great database. Easy to use, tune, debug, work with. Might seem a bit pricey, but IMHO it is worth it. And everything is free at development time, for as long as you need, which is important for me.

What business problems are you solving with the product? What benefits have you realized?

Accounting, Incentive and Loyalty, Call Centre, ERP, Everything ...

Quick development, easy to work inside the database easy to debug with Toad.

Oracle review by Luke T.
Luke T.
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Automatic optimization, security and availability in the cloud."

What do you like best?

One of the aspects of this version of Oracle is the automation of databases, through an intelligent compression which causes the most recent data with respect in the old ones. In relation to security, the redaction function protects the integrity of the data in the case of private data such as credit cards that are displayed in applications that are the same during the time of operation, the analysis of the data is more accurate in the case of Big Data than through SQL Pattern Matching can be analyzed as soon as the business requirements are for business strategies, user registries or financial type triangulations.

What do you dislike?

One of the big disadvantages is that your configuration should be in a very good condition and an error can be a big problem that only reduces the loss of time and productivity while another aspect is its price should be taken in consideration as far as its implementation and analyze if it is necessary in as soon as to the power and the requirements of the company so as to determine if it is the most appropriate

Recommendations to others considering the product

Highly recommended for the efficiency in service, diversity of advanced functions, the analysis of large volumes of data, cloud computing, security and quality in services this version as well as later always guarantee a strong service experience as well as end user in the majority In These cases, the expected results are obtained in terms of their implementation.

What business problems are you solving with the product? What benefits have you realized?

It is of great advantage in terms of database administration, as well as the use of Big Data in obtaining detailed analysis in which it can be used in many utilities in four business strategies that can satisfy customers from a reliable and safe service.

Oracle review by Madhukiran k.
Madhukiran k.
Validated Reviewer
Review Source
content

"Working on Oracle plsql from last 3 years "

What do you like best?

I like the reliability and functionality of Oracle database especially when it comes to performance .

Whenever I am using most of the instances in Oracle 12c I used to feel very comfortable by the performance and easy access of huge amount of data and it's ability to maintain integrity of data are making Oracle 12c software as best database option to most of the banking industries.

What do you dislike?

Sometimes...when ever I used sorting option in plsql while fetching data it will get stuck in the middle .This is the only thing I have felt uncomfortable with this software.

Recommendations to others considering the product

I can suggest Oracle 12c to everyone as one can feel comfortable while using this software in terms of performance and ease of access of huge data at a very fast rate.

What business problems are you solving with the product? What benefits have you realized?

I used to deal with plsql procedures, functions ,cursors , packages , triggers in Oracle 12c to process my business needs like making some financial transactions through these objects . I have realized that Oracle 12c has much simple and some automated things in it compared to 11g.

Oracle review by Haresh S.
Haresh S.
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Good for clustering and full database caching"

What do you like best?

I have dabbled with many databases for the enterprise and organization over a period of time and i strongly feel this is the best database one could ever get because of its scalability and aggregation, and surely the best relational database for large scale application servers and performs well under a heavy load and cheap,store retrieval options are easy and more flexible to create triggers and also create partitions and also in terms of backup and recovery it stands out all the time

What do you dislike?

There are some issues which i really hate one being the restricted PGA size ,table level recovery in recovery manager (RMAN),multiple indexes on the same column which takes quite a bit of a time inorder to get there and also fetch the data effectively and temporary undo in and outs and online migration of an active data file which takes quite a bit of a time and also sometimes session logging and tracking is a hassle here

Recommendations to others considering the product

I would prefer it just for the uniqueness and robustness this database has to offer and also the temporary cache storage tables all the time

What business problems are you solving with the product? What benefits have you realized?

For creating synonyms,ddl logging like create update delete statements it works faster and quite efficiently most of the times and temporary undo information takes a lot of steps to get it done but i felt that is effective for the business needs and we were able to save a lot of time in the process

Oracle review by Edward A.
Edward A.
Validated Reviewer
Review Source
content

"An excellent database management system for a large enterprise"

What do you like best?

This DBMS is robust enough to support our enterprise's HR/Benefits/Payroll/Requisitions/AP system with flexibility when we need to add custom tables. It's easy to use and comes with a well-thought-out set of developer's utilities that enable us to inquire and test as needed to respond to the needs of our internal customers.

What do you dislike?

Navigating through a large database can be troublesome and at times counter-intuitive. If there's a way, using the Oracle-supplied tools to force an inquiry to use a specific index, I have not yet found it. Although the user area of the Developer's workbench is a tabbed interface, it does not appear to be possible to have several different tables open at the same time, and follow keys from one to the next. Of course, I can do a join and get the relationship information I need, but there are times when I'd prefer to pull up one table, identify a foreign key in the data, double-click it, and have the program display the data associated with that key.

What business problems are you solving with the product? What benefits have you realized?

As I mentioned, we use Oracle to host our HR/Benefits/Payroll/Requisitions/AP system. This is the vendor-specified choice, and we have found it to be remarkably useful for hosting our own customized data as well. It's generally fast and very reliable.

Oracle review by Ajith H.
Ajith H.
Validated Reviewer
Review Source
content

"Robust Database for any kind of projects"

What do you like best?

Oracle Database 12c introduced many important capabilities, database consolidation, performance tuning, partitioning, query optimization, high availability, backup and recovery etc. Oracle 12c provide great support and features that are efficient in terms of memory management as well as performance making it one of the best database tools in the market to manage our data. This adds to our overall ROI by making it maintainable.

What do you dislike?

I think the biggest drawback is perhaps its price. While we know that we can download much of the developments of the company, it is also true that we can not access the services of My Oracle Support or have available all the programs and updates

Recommendations to others considering the product

For creating synonyms,ddl logging like create update delete statements it works faster and quite efficiently most of the times and temporary undo information takes a lot of steps to get it done but i felt that is effective for the business needs and we were able to save a lot of time in the process

What business problems are you solving with the product? What benefits have you realized?

For creating synonyms,ddl logging like create update delete statements it works faster and quite efficiently most of the times and temporary undo information takes a lot of steps to get it done but i felt that is effective for the business needs and we were able to save a lot of time in the process.

Oracle review by Jaya Krishna T.
Jaya Krishna T.
Validated Reviewer
Verified Current User
Review Source
content

"Sr. Oracle Database Engineer"

What do you like best?

Oracle software provides great granularity in setting up the environment as per our needs and requirements. Customizing the solutions based on the problem areas comes with great ease and performance.

Performance issues could be easily found out using the tools like OEM and profiler options. Crontab allows us to make sure that all the jobs are properly schedule.

What do you dislike?

There isn't much that I dislike with Oracle. It would have been great to have the GUI on the Oracle similar to SQL Server management studio to manage the databases much efficiently and automate lots of stuff more efficiently and faster. Re-inventing the wheel kind of scenarios are some of the examples that we could have eliminated if we would have had a comfortable GUI tool to run on.

Recommendations to others considering the product

It's a great product and perfect fit for the Production environment for Mission-Critical databases.

What business problems are you solving with the product? What benefits have you realized?

We are utilizing the Oracle databases as a backend to Support Linkedin.com customer facing website. We have one of the largest GoldenGate implementations at LinkedIn having multi-colo setup. This is setup across 4 Datacenters across the Globe to provide high availability. We also have Active DataGuard setup across all the databases on all the colos to provide read traffic their dedicated instance. Also, having the nodes used for the Database backup and recovery purpose in times of disaster.

We also have the downstream functionality and support to our downstream customers like Teradata, Hadoop and Reporting environments to do near-live analytics of the data and run business critical reporting which goes to the Senior Leadership and Board level for analyzing the company's performance, objectives and goals.

We also have the custom scripting and Audit on top of our existing configuration to support what we already been provided by Oracle.

Automation using shell, perl and python scripts have been of a great deal using Oracle to setup lot of jobs which perform routine DBA tasks.

Oracle review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source
content

"Good solid database just a bit complex"

What do you like best?

Oracle is great for being used with certain products. The setup is fairly straight forward and creating your database is really simple. Once the database is in place there's nothing you really need to do as the system jsut works. There are a few extra tweaks you can do such as enable the Oracle Web Console, this is really useful as it will allow you to update any dbf files and associate them correctly. You can also tweak the memory usage to make your oracle system perform much better.

What do you dislike?

I really dislike how you have 2 zip files and within those zip files there are other zip files. you then need to move files from one extracted folder to the other extracted folder, this just makes things complicated. The backing up of the system is not very straight forward, you can use rman but you can't do this on a schedule, it is also not clear if spf files have to be created each time. The Oracle Web Client should also be enabled by default, its straight forward enough to enable yourself however if this was something that was done via installation it would make life just that little bit easier.

Recommendations to others considering the product

If anyone is considering this for use within the business make sure that you read the installation guides and help guides prior to putting this in your environment, especially if you're a newbie!

What business problems are you solving with the product? What benefits have you realized?

We use oracle for a DLP system, we are seeing benefits when it comes to storage, and it is actually doing a good job.

Oracle review by manikanta t.
manikanta t.
Validated Reviewer
Review Source
content

"experance with oracle "

What do you like best?

compare with other old versions of oracle like 11g etc. 12c is some what different and present business world is expecting every thing should be could based because it will helps a lot to manage space before could we have to give physical space for storage now with could all gone oracle database helps us to achieve that

What do you dislike?

most of the company databases are using 11g in order to shift from 11g to 12c some migration is needed the have to make things more use to shift from version to version

Recommendations to others considering the product

oracle 12c version is more advanced compared to old versions having technology on cloud will help you grow in IT field

What business problems are you solving with the product? What benefits have you realized?

now not needed to have physical storage to store data cloud technology we store at remote place accordingly oracle updated now with less investment we can store

Oracle review by Saad Ahmed P.
Saad Ahmed P.
Validated Reviewer
Review Source
content

"Oracle Database Review"

What do you like best?

Working With This vendor on product oracle database 11g, my working experience is very good with oracle due to its amazing features. they provide us security in term of data and backup both and its fulfill our company requirement as per large databases. when we use large oracle database its performance feature are very good and we don't face any ambiguity in this regards. recovery manager feature provide us the complete backup/recovery solution against the unforeseen situation for data loss. recovery manager incremental backup feature provide us zero data loss protection in case of any disaster. tablespace features like: compression,partitioning,logging/nologging are the awesome features for huge database tables.

What do you dislike?

Oracle Support Is Too Complicated To Handle

Recommendations to others considering the product

Its a Very Good Tool For Database

What business problems are you solving with the product? What benefits have you realized?

We Can Resolved Oracle Jobs Queuing And Auto Purge Scheduler QTAB Table Using Oracle Database 12c

Oracle review by Florence Z.
Florence Z.
Validated Reviewer
Verified Current User
Review Source
content

"The best relational database"

What do you like best?

Hands-down the best relational database on the market, if not considering the price part. Stable relational database since version 9i. With 12c you get lots of features for free, lots of work done specially in optimizor so that only Oracle can handle queries of that complexity.

What do you dislike?

With more automation or artificial intelligence as they named it, there is obvious overhead. To make things easy, evaluate what your application really need and disabled things you don't need. The license model is very complicated, really need an expert in your organization to work on it.

Recommendations to others considering the product

Hands down the best relational database on market, if cost is not a concern.

What business problems are you solving with the product? What benefits have you realized?

Money related transactional database systems. A stable system that just does what it's programmed to do, high available, low latency, no data loss, no corruption, no custom complaints.

Oracle review by Administrator in Executive Office
Administrator in Executive Office
Validated Reviewer
Verified Current User
Review Source
content

"Oracle Database 12c for Business that Supports Clientele"

What do you like best?

I like all the features of Oracle 12c. Its performance, flexibility.,Advanced Index Compression, Full Database Caching

What do you dislike?

Technically I do not like the price of the 12c other than Price feature. Oracle is one of the biggest and more stable database, but it's a kind hard to learn how to use it and administrate it. its becomes involved with many library and files on the operating systems so you will have to know a good knowledge of oracle and the OS.

Recommendations to others considering the product

The new oracle 12c is always getting updates and patches for improve their functionality and security, it can be used for little, middle, big and very big databases, if you are looking for a new implementation or migrating to oracle is worth it, it is a little hard to understand and get knowledge, but after you got it, you will have speed on the querys and security of your data.

What business problems are you solving with the product? What benefits have you realized?

I'm actually working in a big company that has an Oracle 12c database of 12 terabytes, it is hard to administrate and critical for the business if it does get down, works perfectly with aix and can be boost with powerha or oracle rac, its important to be with oracle because you have big support and the fiability that the database will always improving their performance.

Oracle review by Gurminder S.
Gurminder S.
Validated Reviewer
Review Source
content

"very modern and advance "

What do you like best?

.It has all the tools and features you expect from world class company like oracle. I have never been dissatisfied with there products.It is very easy to integrate with other services.It has one of the best enterprise support and has great security features which makes it a go to software.If you run into problem documentations are in very brief and easy to understand.

What do you dislike?

It is not for beginners. You need to spend time and sometimes money to master this powerhouse. Luckily you can get training in how to use it anywhere nowadays.i wish they would make the code open source that would be awesome.It has very high cost of ownership.

Recommendations to others considering the product

dont have second thoughts about it. its the best in industry. you will not regret it.

What business problems are you solving with the product? What benefits have you realized?

I mostly prepared databases for our clients and helped them to expand to millions of users and visitors on there products. i prepared data-warehouse from scratch with it.when iw as working as database administrator used to perform cloud migrations for clients across different industries.although i used the earlier version. i have not worked on it for couple of years now.

Oracle review by Internal Consultant
Internal Consultant
Validated Reviewer
Verified Current User
Review Source
content

"Oracle Database 12C review"

What do you like best?

I could say that there are lot of things in oracle 12c which I likes the most, but one of the quick thing comes to my mind is the Enhanced DDL Operations feature of 12C, which no longer require blocking lock operations and thus allow us to drop the index online and thus saving a lot of time and efforts of a technical person. Another key feature with 12C is their Multitenant Architecture, which introduces container databases (CDB) thus allowing zero, one or many pluggable databases. With this feature, it would be really easy for a Database administrator to have a CDB, with all necessary information , instead of having multiple DB’s architected differently and thus managing them a piece of cake of them.

What do you dislike?

one of the most irritating thing about using oracle product is their support levels. It is really easy to log a call with Oracle, but very hard to get a solution. In my personnel experience, I have seen that once the service request is open , it is a pain in ass to make the level 1 engineer to understand our problem, as the solutions they recommend is generally already applied by the user and he needs some priority and senior person to work on his issue, but they follow strict protocol, which sucks the users experience.

Another pain area is that with everybody getting in virtualization solutions for their business, Oracle will offer very limited guidance on how to properly apply database licensing metrics for non-Oracle virtualization software.

Recommendations to others considering the product

From my experience, I would recommend every database administrator to use this product, as apart from his robustness, it is very easy to use and configure as per our applications requirement. Moreover, its fine tuning is easy and thus it could be customized as per your requirements, especially while in cloud native applications.

What business problems are you solving with the product? What benefits have you realized?

the oracle 12C provides a lot of enhanced features which allow us to realize our business goals, like I said earlier, one of the key feature of container databases are extensively used by us for a seamless aligning our business cloud native applications with oracle databases. Another simple feature of 12C, where they have increased variable character size limit from 4,000 to 32,767 bytes is used by us in our new big data applications, where large character size is a common norm these days.

Oracle review by Alessandro R.
Alessandro R.
Validated Reviewer
Review Source
content

"Max reliability for transactional tasks"

What do you like best?

Oracle 12c has reached the maximum reliability and availability thanks to the chance to deploy a cluster environment by shared cached. Keep in mind that previous version , as all relational database, suffered from scalability and availability.It is clear that it can't replace a NoSQL database as soon as data are from different sources as unstructured or semi-structured data.

What do you dislike?

Learning curve,especially for those are approaching to Oracle for a short time is a bit long. In fact there are many aspects to care about ,such as policy management, security, administration and auditing.

Recommendations to others considering the product

My recommendation is : If your business requires high availability , efficiency , professional support needed to guarantee a high quality of service .Then you have to go straight Oracle 12c, otherwise you can save money go for much less expensive solutions in terms of license.

What business problems are you solving with the product? What benefits have you realized?

Querying data horizontal partitioned over several nodes in my local data center

Oracle review by Jhampiert B.
Jhampiert B.
Validated Reviewer
Review Source
content

" Analysis and development of information systems with database management"

What do you like best?

I use Oracle Database as part of my work, since, I support an administrative management system that uses to store Oracle 12C data. What I like about 12C is the option or "Invisible Columns" mode, which allows you to hide the change until we want to publish it, the mytable option that allows you to create a table in two steps and the addition of a field in invisible mode are of the options that I like.

What do you dislike?

As a specialist and consultant in the area of ​​IT and with experience in Oracle Database, the biggest drawback is perhaps its price. Even the personal licenses of Oracle 12c are excessively expensive, in my opinion. While we know that we can download much of the developments of the company, it is also true that we can not access the services of My Oracle Support or have available all the programs and updates

Recommendations to others considering the product

As part of the support team of a software development company, he was able to highly recommend Oracle Data Base 12c for the analysis and development of information systems due to its high quality and a large number of new functions

What business problems are you solving with the product? What benefits have you realized?

Oracle is by excellence the best relational database manager in the market. It has allowed, in my experience, to develop the Kerux application as part of the administrative management process of more than 50 large institutions in Latin America

Oracle review by Jesus P.
Jesus P.
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Motor de base de datos muy potente"

What do you like best?

Las bases de datos de Oracle son muy potentes permitiendo un gran poder de computación, haciendo que gran parte de la lógica de computación sobre los datos del sistema sean derivados al motor de la base de datos y que este sea quien tenga que hacer el tratamiento de los datos, permitiendo liberar a tus aplicaciones.

What do you dislike?

El entorno o instalación pueden llegar a dar problemas en ciertos entornos, por problemas de puertos o que después de bastante uso se corrompan los datos, algo fácilmente solucionable mediante la realización de copias de seguridad diarias.

Recommendations to others considering the product

La gran capacidad de su motor para el tratamiento de los datos, el tratamiento en lenguaje SQL es bastante más efectiva.

What business problems are you solving with the product? What benefits have you realized?

El tratamiento de datos, la carga de los mismos, trabajar con millones y millones de registros en un sistema de Business Intelligence, permitiendo la carga masiva o el tratamiento masivo de muchos datos.

Oracle review by Jayash J.
Jayash J.
Validated Reviewer
Review Source
content

"Great database for production use."

What do you like best?

Oracle database is full of administration and management features.

It is very reliable and scalable on production.

Oracle DB is very much secure as compared to other databases.

It is really good for business critical applications.

What do you dislike?

It is very heavy application from memory consumption perspective.

It is very expensive as well. If organisation is small, then they can try other database.

Recommendations to others considering the product

Consider pricing while choosing Oracle database.

If your application and user count is small and application is not business critical or does not include any financial or secure data then any other cheaper database will be good.

What business problems are you solving with the product? What benefits have you realized?

We are managing our structured data storage with Oracle database.

We are greatly benefited with our production data reliability.

Oracle review by Administrator in Banking
Administrator in Banking
Validated Reviewer
Verified Current User
Review Source
content

"Pluggable Database Very useful"

What do you like best?

One of the most novel features I have observed from 12c is the plug-in database (PDB) usage characteristics which works as a portable collection of one or more schemas, objects, etc., and in turn as a separate database. This offers great utility to the DBAs in their planning, management and maintenance activities saving costs and time to the client. The added improvements in this version such as memory management, Increase in data volume management, Friendliness of Enterprise Manager Cloud Control, management of database in the cloud, and other attributes for administration, Planning and control and management Database

What do you dislike?

I have observed with concern the deterioration in Oracle with the support in MOS. Throughout the time in several years, I have seen and received diverse opinions of colleagues in relation to a significant decrease in the quality of service and the responsiveness of their support team to their clients.

Recommendations to others considering the product

The innovation, versatility and robustness of the product combining the number of added improvements in this version such as memory management, increased handling of data volume, friendliness of the Enterprise Manager Cloud Control, management of the database in the cloud, and other database attributes that justify its positioning in the marke

What business problems are you solving with the product? What benefits have you realized?

The innovation, versatility and robustness of the product product of its positioning in the market seems to me that the best functional version developed by Oracle

Oracle review by Rajan S.
Rajan S.
Validated Reviewer
Review Source
content

"One Of the best RDBMS software to manage your data."

What do you like best?

1. The best thing I like the best in Oracle 12c is his query system.

2. With the version above Oracle 10g, there are new functions introduced in Oracle 12c like LISTAG, Pivot, etc function which helps developers to develop his projects in less time with accuracy.

3. If you are going to handle a big amount of data then Oracle 12c is the best database to use.

What do you dislike?

1. The installation of Oracle 12c is not that much easy.

Recommendations to others considering the product

If anyone is reading then at least use it for once you will find that why should you use it.

What business problems are you solving with the product? What benefits have you realized?

1. As a developer, I used this database to manage my project data and to develop my project.

Oracle review by Administrator
Administrator
Validated Reviewer
Verified Current User
Review Source
content

"The first database designed for Cloud Computing"

What do you like best?

I started in the world of SMBD using Oracle in version 9i and then started as administrator in version 11g, it was very easy to adapt, in version 12c drastic changes were made but they are great especially the multitenant architecture and pluggable databases data that allows you to consolidate databases on a single server at the same time and keeps them separated from each other. This new architecture allows the sharing of SGA, CPU and other resources, greatly reducing the amount of memory and CPU required.

In our organization where there are variety of versions of oracle for different applications, this version 12c and pluggable databases will facilitate the administration and update of patches

What do you dislike?

Technically I have not dislike, alone the price, but it is worth the investment

Recommendations to others considering the product

I would recommend it for companies that want a secure database, quite robust, reliable and if they think about using database services in the cloud it would be great.

What business problems are you solving with the product? What benefits have you realized?

Since we have a variety of applications in different versions of Oracle, we are evaluating the impact of migrating to version 12c and using the pluggable databases with the version of Oracle that are required

Oracle review by Guneet S.
Guneet S.
Validated Reviewer
Review Source
content

"Great and traditional Relational Database"

What do you like best?

I have started using Oracle DB since its 9i version. It loved this alot. A great tool for Database management and its scalable as well. It has very great feature of timely backup which I like most. Security is always the first priority for them. I really had a great experience with this tool.

What do you dislike?

It is very heavy load tool. It requires more system specification to operate. If we talk about pricing, it is bit costlier than other competitors like google or AWS. These are the only disadvantages I noticed so far.

Recommendations to others considering the product

I will surely recommend this to others and our colleagues as well to use this as their primary db for application. The effort which Oracle made to develop this great tool obviously it should reach to everyone.

As per the client application model, I could not share the screen shot of the application due to security reasons.

What business problems are you solving with the product? What benefits have you realized?

If we talk about the huge client application which has large number of customer records, there needs a db which can handle large number of records with its scalable behaviour, Oracle comes first in mind. Oracle is the king in database management with full of security. It is a great tool by Oracle to work on.

Oracle review by Manjeet K.
Manjeet K.
Validated Reviewer
Review Source
content

"12c: Clustered beast of cloud."

What do you like best?

Oracle 12c has helped us lot by cutting down limitations that we were fetching currently in traditional RDBMS.

12c has functionality of plugging databases (PDBs), where we can form master slave architecture and run multiple DB from single master. Cool isn't it?

Second cool thing, it supports JSON. which is quite helpful if you have application with REST architecture.

What do you dislike?

I don't see there is something to dislike about 12c. Yes, cost is definitely one of the factor where any organization needs to evaluate if it's helping them go positive or not. Because cost of 12c itself and device on which it runs are relative. Which definitely is high. But, again as i said, it would be totally organizations call.

Like is said above 12c has pluggable feature. But, again in order to use it effectively, you need lot of preparation. For ex:

All cluster DB must be configured to handle the resource requirements in accordance with PDBs that you are going to manage, else you will have to shutdown to reconfigure and restart the Cluster DB and all the PDBs. Additionally, you need to keep in mind small things, e.g. container, and all PDBs, should be running on same character set. Hence, it's better to switch to Unicode.

12c is definitely a beast which needs proper care to keep running smoothly. Of course, all the beast do. ;)

Recommendations to others considering the product

Definitely go ahead and opt it. PDBs & CDB will overwhelm you.

What business problems are you solving with the product? What benefits have you realized?

I would sum benefits to 3's. Scalability, Security and Stability. Pluggable database of course has helped lot. It's quite a state of art. It has helped lot in managing & reducing time and effort for database upgrades, backup, recovery, etc.

Oracle review by User
User
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Oracle Database 12c-"The sturdy core of data""

What do you like best?

Oracle 12c does an excellent job in data storage, retrieval and processing. Easy to upgrade and maintain in combination with the new features and security delivered for Oracle's most up-to-date version.

OEM 12C permits cloud monitoring.

I can have installed OEM on one server and monitor each one of my databases (11G R2 or more) henceforth I have to oversee only one connection.

It additionally permits heterogeneous database monitoring and host monitoring.

In 12c Database, We can now recover tables from RMAN Backup as well.

Moving datafiles online is one of the great features of 12c Database which reduces the need of downtime.

What do you dislike?

I see no such disadvantages, but the multi-tenant structure seems to be somewhat complicated and the same thing should be presented in a simpler way.

Recommendations to others considering the product

For large organizations that like to use the RAC environment or cloud environment, Oracle Database 12C is well suited as we get too many features of availability, scalability, performance and who can afford the cost.

What business problems are you solving with the product? What benefits have you realized?

Oracle 12c is our company-level database that is used together with PeopleSoft to support ERP needs such as payroll, benefits, recruitment, supply chain management, etc.

Because both PeopleSoft and 12c are Oracle products, they integrate well with each other and we get great support for them. It is used for data storage, recovery and management needs throughout our organization and across other departments

Oracle review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source
content

"A powerful relational database with tonnes of features"

What do you like best?

If you have an enterprise version of Oracle, you get to use Oracle Enterprise Manager base version for free use. I have worked on multiple relational database but Oracle has been a great RDBMS. Oracle keeps adding awesome features and is truly the most sophisticated RDBMS in market right now.

What do you dislike?

I am not a fan of known issues caused by applying bundle patches released every quarter. It will be great if Oracle can make sure that we don't have to run into issues after applying patches and then having to rollback them. Although this is a very rare situation, but makes me a bit uncomfortable while doing quarterly patching.

What business problems are you solving with the product? What benefits have you realized?

We are using this to migrate a people soft legacy ERP to a more modern ERP using Oracle as relational database.

Oracle review by Administrator in Education Management
Administrator in Education Management
Validated Reviewer
Review Source
content

"Most sophisticated and reliable RDBMS in market"

What do you like best?

Oracle Database 12c is a cloud ready database that supports multi-tenancy. Although it still supports using single instance databases as in previous versions.

It is suitable for small sized to large sized industries and can be used for OLTP, data warehousing and custom databases.

I am a fan of it's performance tuning features and table/index partitioning features.

What do you dislike?

No one however long has worked on Oracle Database can say they know the product end to end. It's highly sophisticated and complex to learn it all.

Also, you need a specialized administrator to perform administrative tasks. Although that is changing with the new Autonomous Databases that Oracle is working on.

Recommendations to others considering the product

It's expensive but the best :)

What business problems are you solving with the product? What benefits have you realized?

We are using Oracle Database to support an ERP solution which is transforming a legacy system (peoplesoft, mainframes and DB2). We are not using multi-tenancy feature of Oracle Database 12c but have plans to make the move.

Oracle review by Chris D.
Chris D.
Validated Reviewer
Review Source
content

"Oracle is very difficult to work with"

What do you like best?

Oracle packages are a nice way of bundling functionality, much like classes. They make it a lot easier to organize stored procedures and functions.

What do you dislike?

Everything of Oracle's is insanely expensive and more difficult to setup and administer. The Oracle databases require a lot more manual maintenance, and a lot more effort to setup initially. Additionally, we've been going through an upgrade from 11g to 12c, and it has been incredibly challenging. A number of legacy stored procs have stopped working. All of Oracle's products are very expensive and they never work well together. Oracle's support is terrible as well. At a previous employer, we had Oracle direct one of their customers to us for help, since we were an Oracle customer as well. The first customer called Oracle for help and their support just forwarded the call to us because we were working on something similar, instead of trying to support them.

Recommendations to others considering the product

Oracle is incredibly clunky and expensive. It's impossible to recommend it, even for core enterprise systems. Depending on the complexity of your database, you're going to need to get Oracle consultant time to help set it up, which is also insanely expensive. Oracle has mastered convincing non-technical people to choose Oracle.

What business problems are you solving with the product? What benefits have you realized?

It's our primary legacy database provider.

Oracle review by Rajat S.
Rajat S.
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Best RDBMS(Oracle) software. I heve ever Used."

What do you like best?

1. In Oracle 12c there is some more function introduce which helps developers to develop their project in less time. and in easy way.

2. It is best to manage your database with high performance.

3. Data optimization is easy.

What do you dislike?

1. The only thing is not better is installation. The installation is not that much easy as compare to oracle 10g.

Recommendations to others considering the product

Use it for once and then you will never like to use another RDBMS software.

What business problems are you solving with the product? What benefits have you realized?

I working as software developer and since 2016 i am using oracle 12c for the developing projects i am working on. In oracle 12c its not take much time to full fill client requirement with new functions.

Oracle review by Al S.
Al S.
Validated Reviewer
Review Source
content

"Smoother experience coding vs. SQL Server"

What do you like best?

What i liked best about oracle database 12c is that it always felt more streamlined and made more sense than sql server from a UI perspective.

What do you dislike?

I disliked that there were less features and abilities to manipulate the tables as you can in sql server.

Recommendations to others considering the product

I would use oracle as a supplement to other data bases within your companies various other data base tools and not just as a stand alone application as it will be very hard to complete all the work that you might have to do if you need the data base to do other things besides load data.

What business problems are you solving with the product? What benefits have you realized?

Organizing data into tables and extracting from the tables to the cloud

Oracle review by Administrator in Higher Education
Administrator in Higher Education
Validated Reviewer
Verified Current User
Review Source
content

"Oracle, still the database engine that can't be beat!"

What do you like best?

Robustness. It truly handles relational databases well, as well as all of the ancillary services you need for a fault-tolerant database environment.

What do you dislike?

Cost and marketing. Oracle has a high turnover in technical sales folks, or they move them around a lot. It seems I get a call from each new person and they are always trying to sell us something. We would prefer them to be more "on our side" helping us get our money's worth out of their product.

Recommendations to others considering the product

I have used Microsoft SQL Server and PostgreSQL. If your company needs performance and fault-tolerance that is proven, Oracle is the best choice.

What business problems are you solving with the product? What benefits have you realized?

Oracle is our back-end database that runs our mission-critical systems. We use Oracle RAC to provide fault tolerance because we really are a 24 hour shop. We have incredible amounts of data and Oracle has the performance we need.

Oracle review by User in Financial Services
User in Financial Services
Validated Reviewer
Review Source
content

"A solid database that can handle large amounts of data with ease"

What do you like best?

The ease of use, the UI is great, it allows the repair and access into the databases so easy. It is very flexible and I love the caching functions it performs.

What do you dislike?

The cost is pretty high, BUT if you have a large amount of data then it will pay for itself in the long-run over and over again.

Recommendations to others considering the product

I have been using this since version 10 and I have used other database software and this is by far the best, easiest to work with one I have ever used, yes it is pricey, but so worth it in the long run.

What business problems are you solving with the product? What benefits have you realized?

Mainly use this for customer data storage and archiving. With such a large company this makes for going in and repairing data very easy and straight forward. I recommend this to anyone who deals with large amounts of data that needs to be kept secure and accessed.

Oracle review by User
User
Validated Reviewer
Review Source
content

"Oracle Db"

What do you like best?

Grouping Transactions

The ability to group several transactions into the same batch for processing sets Oracle apart from its competitors.

Microsoft's version of SQL is limited to executing each transaction individually in a sequential order. This gives Oracle SQL far greater scalability over sequential versions of SQL, which are limited to only expanding vertically. Vertical expansion can be significantly more expensive than horizontal expansion. Expanding vertically requires the addition of server memory, hard drive capacity and ventilation equipment. Oracle can expand horizontally by clustering transactions for more efficient processing.

Improved Performance

In addition to batch processing of transactions, Oracle offers other methods of improving your database's performance. You can use multiple servers to work on the same database with the Real Application Cluster feature. This can significantly increase your processing power for only the price of an additional server. Oracle SQL also gives you more options to fine-tune the operation of your database to suit the capabilities of your server.

Versatility

Oracle SQL gives you the flexibility of choosing to run your database in any operating system. Dedicated languages are only compatible with operating systems from the same manufacturer. For example, you can only run Microsoft SQL Server on a Windows-based machine. In comparison, you can install Oracle SQL on a Unix server and benefit from the reliability of Unix while keeping the standardization of SQL. Unix is less vulnerable to many common computer viruses, which keeps your information secure. Oracle SQL is also backward-compatible, so you have the option of upgrading in the future without losing any data.

What do you dislike?

Cost

The cost of operating Oracle SQL puts it at a disadvantage in comparison to other versions of SQL. The cost difference starts with the licensing fees, which may be up to ten times as high for Oracle. Because Oracle SQL is such a complex and highly specialized language, it can be difficult to find qualified database administrators to run your system. When you do find a suitable candidate, expect to pay two or three times more in salary than you would pay a comparable Microsoft or PostgreSQL administrator.

Difficulty

Oracle SQL is also more difficult to learn and operate than its competitors. A user-friendly version such as SQL Server is easy to install and set up with a minimum of customization. It includes five sample databases you can use as a framework for your own company's information. Microsoft also provides Visual Studio-based SQL Server management tools to help you modify the database's design, change the data it contains and execute queries.

What business problems are you solving with the product? What benefits have you realized?

We use Oracle to store our data. Grouping transactions, versatility and improved performance are some of the advantages of the Oracle db.

Oracle review by User in Government Administration
User in Government Administration
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Oracle Database 12 c Review"

What do you like best?

Ease of updating from ongoing forms (10g/11g) to empower expanded help application lifecycles. This is extremely basic to most establishments, since client re-testing will be limited, and existing authoritative aptitudes are utilized in the new form without a lofty expectation to learn and adapt. 12c is an entirely steady discharge. As far back as support in the early Beta cycles, we stressed to Prophet, our need to not return to stretched out bugfix cycles endeavoring to inspire an early discharge variant to work underway situations experienced in numerous past releases.12c's inner programmed execution the executives highlights have enhanced over 11g, with fewer re-modifications always happening enabling the database to adjust to changing interest prerequisites, (for example, OLTP amid the day, however, overwhelming OLAP around evening time) and not agonizing over the overhead of empowering highlights, for example, AMM (programmed memory the executives) or ASM (the capacity related proportionately) and viewing the database will in general battle with itself attempting to upgrade the settings.

What do you dislike?

12c is a feature-laden installation. The impression of the product (Prophet Home) alone is about 4+GB, with no information stockpiling included, which deciphers, as most new items appear to underline, into you're getting everything in one box. While the underlying Prophet All inclusive Installer experience can be as basic as picking one of 2 pre-characterized database layouts and navigating 5 [Next] catches, the hop to picking the third alternative (a Propelled Establishment) goes from those 5 screens to more than 35, which may overpower another client needing to simply introduce a database to help an acquired application. I'd by and by prefer to see Prophet transport pre-designed formats with its own applications to give new installers a choice of picking an application-improved adaptation layout to additionally accelerate the underlying setup process.

Recommendations to others considering the product

An incredible stage for any adv application, that must be versatile, multi-stage, and surely supporting a large number of data related innovations, regardless of whether Java, XML, advanced analytics, or high-accessibility.

What business problems are you solving with the product? What benefits have you realized?

the Oracle 12C gives a ton of upgraded highlights which enable us to understand our business objectives, as I said prior, one of the key highlights of compartment databases are widely utilized by us for a consistent adjusting our business cloud-local applications with Oracle databases. Another basic component of 12C, where they have expanded variable character estimate limit from 4,000 to 32,767 bytes is utilized by us in our new enormous information applications, where substantial character measure is a typical standard nowadays.

Oracle review by Consultant in Computer Software
Consultant in Computer Software
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Oracle Database Review"

What do you like best?

Oracle is a well known player in the database space. I enjoy the reliability of the database so I know about the consistency of the data being stored in each transaction. The SQLdeveloper software is relatively easy to use as well.

What do you dislike?

I think the interface could be designed a bit better such that the specific tools to generate SQL, commit and rollback changes were better described and usable. Besides that, I wish the Oracle database was as fast as some massively parallel databases because a lot of our backend operations end up occuring in a different Postgres data warehouse.

Recommendations to others considering the product

You need to seriously look at the scalability of this product versus other products. Most of the world seems to use Oracle database and things haven't really changed over the years with SQL. Oracle seems to have a new secure cloud that is available for use nowadays so that's something that should be considered for deploying this database. I think the recommendations is such that users should try to run parallel 8 on the queries and ensure that any ETL jobs that exist in the workflow are threaded so that you don't have a big issue with running a specific query (DML or DDL) that takes a long time.

What business problems are you solving with the product? What benefits have you realized?

I am solving data quality problems with the oracle database. I write SQL and then test the SQL in the development environment. Then the SQL is run on the production environment to ensure data consistency for our client.

Oracle review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Review Source
content

"Oracle: Still the best?"

What do you like best?

One of the best features of oracle lies in its use of Java. with its reliance on this platform, it provides the user with the ability to work on windows, OSX or linux. coupled with its configurability, Oracle positions itself to be a one shop stop for many businesses.

What do you dislike?

One of its benefits, at times can be one of its worse features. with its dependance on java, older operating systems take a hit both performance and security wise as the platform constantly evolves to meet changing needs

Recommendations to others considering the product

While Oracle offers a wide suite of services and applications, this comes at a premium. before choosing, ensure your data needs require such a hefty application. Also note that with each upgrade, existing OS's may need to be updated accordingly for proper functioning of the aplication

What business problems are you solving with the product? What benefits have you realized?

Data storage and manipulation, Data integration and frontend interface

Oracle review by Administrator in Insurance
Administrator in Insurance
Validated Reviewer
Verified Current User
Review Source
content

"Works well"

What do you like best?

Once you get it set up. Oracle Database almost (but not quite) runs itself. The only tim you need to mess with it is if you hit a bug or performance changes.

What do you dislike?

It is expensive, no doubt. SQL plan management is a moving target, but if you can get a decent plan locked in, you should good to go.

Recommendations to others considering the product

You get what you pay for. Don't let cost drive you away of another solution can't do the work that Oracle can. It does the work and does it well, for the most part.

What business problems are you solving with the product? What benefits have you realized?

Third party and custom internal apps are built on Oracle. Data warehouses (internal and 3rd party) are also built on Oracle. Disaster recovery using Oracle is a breeze. Leveraged our DR solution for clones for test and dev and works great.

Oracle review by Rubén L.
Rubén L.
Validated Reviewer
Review Source
content

"Excelente base de datos relacional para su uso empresarial"

What do you like best?

Con esta base de datos relacional se consigue un gran grado de seguridad a la hora de almacenar los datos de un aplicación debido a su gran poder de configuración y gestión de seguridad.

What do you dislike?

La gran baza de esta base de datos relacional es también su gran inconveniente ya que debido a su gran grado de configuración, aveces hace muy difícil su uso, sobre todo si no se esta acostumbrado a su uso.

Recommendations to others considering the product

Sin lugar a duda recomiendo el uso de esta base de datos relacional debido a su robustez.

What business problems are you solving with the product? What benefits have you realized?

Con este motor de base de datos hemos conseguido el almacenamiento de datos de la empresa consiguiendo un alto grado de seguridad en la integridad de los mismos.

Oracle review by Consultant
Consultant
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Oracle 12c designed for cloud solution and its multitenant feature."

What do you like best?

Multitenant and multiple pluggable database. Here, instance is shared with multiple databases.Clones PDB from another PDB with in the same CDB. This multiple databases are self contained and pluggable from one database to another database. The databases can be created on fly and drop or attach and detach from one server to another server

What do you dislike?

this is one of the biggest and more stable database, but little tricky to learn it and implement it which involved with many library and files on the operating systems.

Recommendations to others considering the product

Its a great product to use but please go through the installation guides and help guides prior to putting this in your environment, especially if you're a newbie!

What business problems are you solving with the product? What benefits have you realized?

Storage of a mission critical product we are delivering and benefits of having a team thats used Oracle Database for many years and a code base to integrate easily with 12c.

Oracle review by Momataj B.
Momataj B.
Validated Reviewer
Review Source
content

"Production database management system"

What do you like best?

Oracle 12c is the first database designed for the cloud. Therefore, I found it uncomplicated to implement in the cloud system. Oracle is the most secure database system compare to the other databases engine. I like the multi-tenancy architecture of Oracle 12C because It helped use to drop workload significantly. Another feature, Data-in-memory increase the OLTP transaction performance.

What do you dislike?

Oracle is an expensive product and Mostly preferable for the larger organization such as Bank and telecom.

Recommendations to others considering the product

Yes, When the central point is data security and the usage amount of online transactions such as bank and telecom sector.

What business problems are you solving with the product? What benefits have you realized?

A production Database system for Banking management

Oracle review by Maria  Z.
Maria Z.
Validated Reviewer
Review Source
content

"Enterprise database storage"

What do you like best?

Oracle Database 12C it's a databse software that provides you a great system at level of stability and performance, with a good options to tune up the settings to meet with your needs or requirements.

The main thing of Oracle database, is the stability and their reliability.

What do you dislike?

By default there aren't a graphical user interface to work with the tables and insert and remove rows in a easy way like there are in MySQL and and its versions

Recommendations to others considering the product

It's the business database environment of reference. The support is the best.

What business problems are you solving with the product? What benefits have you realized?

I'm testing Oracle Database 12C in our company to test the performance of some applications running with this environment instead of the original Mysql.

Oracle review by Sukesh  N.
Sukesh N.
Validated Reviewer
Review Source
content

"Trending database version with wide range of features like cloud,multitenant database etc etc"

What do you like best?

Being a oracle database administrator I like to work on new features that are introduced in oracle 12c like multi tenant database,flex cluster,flex asm,cloud,recover table using rman,out off line patching and many more

What do you dislike?

I dont have any such points to dislike about this product from oracle as this version is filled with many new features which are useful in securing our database data in a proper way

What business problems are you solving with the product? What benefits have you realized?

Out off line patching allows me to patch my oracle version with minimum downtime,multi tenant database which allows me to create many pluggable databases bound to single container database,recovering table from Rman backup,Cloud enviornment,Flex asm,Flex cluster

Oracle review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Review Source
content

"Oracle 12C is a great product"

What do you like best?

During our application development for different interfaces, we used to save the request data in Oracle DB whatever we are receiving from the source application. & also for logging the requests which we received. Also, performance wise its too good to call any stored procedure or any select, update queries from different applications.

What do you dislike?

Nothing to say wrong about this product, I highly recommend this product for any Database related stuff. Even performance wise its too good. While comparing to old Databases lot changes came in this & its very lightweight while executing any kind of complex queries.

Recommendations to others considering the product

I highly recommend this product during any application development purpose in any company.

What business problems are you solving with the product? What benefits have you realized?

For logging any kind of data, instead of creating multiple log files we used to update the Oracle 12C database & retrieve from it whenever it's required.

Oracle review by Consultant
Consultant
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Great for many use cases"

What do you like best?

bullet proof - it is resilient to many failures, from hardware to different software pieces, which makes it an easy choice for an ACID database supporting large scale workloads

What do you dislike?

its costs - it includes a lot of features that you buy all together, but is possible that you don't need all that for your use case. Many people end doing a wrong comparison of their requirements against common open source databases and Oracle, when in reality they are just looking for the minimal covering solution for their needs at the minimun price.

Recommendations to others considering the product

It has a wide set of features, which could be much more of what a simple transactional DB requirement could need. So better to spend some time initially to weight how much the features you can use are needed and make sense for your budget.

What business problems are you solving with the product? What benefits have you realized?

Highly transactional needs over large datasets and concurrency, HA support, strong resistance against hardware failures.

Oracle review by Consultant
Consultant
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Performant, Powerful and Flexible"

What do you like best?

Scalable, fast and Feature rich. Works well for most workloads and SQL is fairly conformant. Includes new and modern constructs to support complex recursive SQL and partitions. Stable and has decent characteristics for replication, fault-tolerance and failure detection. Good security support and integrates with our software well

What do you dislike?

Occasional Performance issues about bad query plans when statistics get stale, Too many IO issues when managing clustered DB instances, etc.

Recommendations to others considering the product

Powerful DB with several rea ltime and near real time capabilities, which is a mammoth. Powerful indexing, partitioning and optimizing capabilities. Generally performant, but needs adequate care for the cost-based-optimizer to work properly. Significant DBA costs to be expected to maintain this beast. Generally support is good, sometimes Oracle can delay in responding to issues though.

What business problems are you solving with the product? What benefits have you realized?

OLTP, OLAP and High volume transactions of our Financial systems

Oracle review by Greg R.
Greg R.
Validated Reviewer
Review Source
content

"Too complicated"

What do you like best?

Oracle seems to be extremely secure and built with quality. I think it does database well.

What do you dislike?

The downside to being extremely secure is that it is extremely hard to integrate with it. It took me over a year of trial and error to get Oracle to work with a Linux machine and PHP.

Recommendations to others considering the product

If all you are going to use is Oracle for a database then I think you will be fine. If you are going to try and implement with it you may be heading down a painful path.

What business problems are you solving with the product? What benefits have you realized?

Data storage and querying that data.

Oracle review by Claudia A.
Claudia A.
Validated Reviewer
Verified Current User
Review Source
content

"Simplicity in Databases"

What do you like best?

Oracle Database 12c is extremely simple to use. Once you find your shortcuts it becomes second nature to maneuver the database.

What do you dislike?

Oracle Database 12c has an issue with using the back button. You have to remember that you have to use the back button within the database and not the web browser.

Recommendations to others considering the product

I recommend that they fix the back browser button issue. Sometimes it slips the mind and it erases all work and information entered.

What business problems are you solving with the product? What benefits have you realized?

We are solving how to best reach all of our constituents within our database. As long as you create the proper queries, we are able to pull out important information.

Kate from G2

Learning about Oracle Database 12c?

I can help.
* We monitor all Oracle Database 12c reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.