Oracle Database Reviews

It is a very powerful database from the point of view of storage and development, I have used oracle in many aspects, as a database engine and for a large amount of data it is perfect because it handles high volume data efficiently, as well It provides the advantage of being able to develop with SQL ansi standard procedures and tasks that automate the management of data, the advantage of being able to run on any platform and with any development tool allows development projects to be carried out in the expected time, compatibility It is your biggest advantage

As a disadvantage I think that the way to handle the downloads of the connection drivers for the different platforms is a bit tedious since other databases do not require so much protocol to download the drivers. it may be necessary in some cases to document about the new functionalities because the examples provided by the provider are not so clear and / or non-existent

Being a oracle database administrator I like to manage and work on unique technologies that are available, like Real application cluster,Golden gate,RMAN, Datapump and its is really challenging at times when we receive performance related issues. It provides high level security on data where we can recover lost data or corrupt data using various technologies like RMAN,DATAPUMP,DATAGUARD,RAC.
ASM makes the database maintenance even more simple while adding new disks into storage or adding datafiles. Goldengate can be used to configure data replication between different vender databases and OEM 12C and above can be used to monitor other vendor databases and OS alerts too.The Cloud enviornment makes it look cooler.

I don't find any cons as such as but the ORACLE-SUPPORT response is slow sometimes even on high priority issues and we need to raise a call to the manager

Very fast for all the SQL transaction. The performance is good which in turns increases the performance/response time of the application I build on top of it.

Disaster recovery, Master/slave replication and high availability feature which is built besides are very helpful

RAC and clustering is complex for the beginners. But the practicality of these feature are really useful.

Accurate information collected and grouped into meaning full tables. Highly customizable database with ability to connect with other DB with APIs.

Compared to the other DB in the market the Oracle DB is little user friendly and less sophisticated. Tools and icons in the DB itself must be remembered for fluent use. Limited analytics is available unless you want to pay more for the additional analytics and BI.

Oracle DBMS is the best when you talk about large data manipulation SQL/PL-SQL runtime is way beyond its counterparts such as MySQL and MS SQL. Another feature is the availability of support (API) for different programming languages. Programmers can easily develop applications using whether it be mobile apps, web based or other server based applications, Oracle is a sure bet. Oracle's availability, recoverability, performance feature is also an added advantage. The new feature that removes human error of patching and upgrading by automating the process is another key benefit.

Oracle DBMS may not be the right choice for a small organization just starting if they do not have enough money to purchase its license. Oracle license is really expensive. One other thing is that you will need a highly skilled oracle professional to harness all the benefits Oracle truly provides.

I have been using Oracle Database since the version 10g. I have had a chance to work on several other database platforms like Sybase, MS SQL and MySQL. Oracle database comes with tons of features which many of the other databases don't have. I am not sure if i can say that other way round for other databases i have used.
It's quite complicated to learn and definitely complicated to master, but it provides you with enough tools to do complicated tasks quite easily.
You can also code your application programming languages using it's native PL/SQL language. Oracle Database also let's you make calls to Java programs and embed some Java inside the PL/SQL.

It's costly! It's quite costly if you are using it for small businesses. Some of the very sophisticated features are only available for enterprise version of Oracle Database which is quite costly. Oracle is very price oriented, so be careful about the budget when you chose Oracle Database.

As a Java programmer, for me personally, Oracle database is one of the most important platforms that I use. The overwhelming features of the platform, its history, scalabillity and the overall usability is almost breathtaking. Java and Oracle, connected with Hibernate are a really powerful triumvirate of technology.
As a user, I use oracle database every single day for dispatching customer engineers, managing the work orders, pulling data and creating reports.

So far I can only say good things about Oracle DB.

Data retrieval is fast.
Data organisation is good... especially in a RDBMS environment
Good fit for OLTP systems
Lots of great functions out of the box
Data management, data integrity, meta data usage is pretty good...
Interfaces for SQL creation and PL/SQL development are readily available....
User security and access management is very good

Licensing cost.
Ease of use
Hardware compatibility

I have been working on database technologies since more than a decade now. Oracle database is the most powerful relational database in market with tonnes of features. If you buy enterprise edition of the software, you get features like data guard, Oracle Enterprise Manager for free.

Oracle database can be overly complicated for someone who has worked with other database vendors like Microsoft or SAP. Also, Oracle database is costly in terms of license price compared to other database options.

-oracle database comes in 4 editions: standard,enterprise,personal,express. we have flexibility to use one of the edition on specific needs.
-cloud ready architecture
-strong user community

- expensive pricing models
- extremely complicated architecture , not easy to acquire complete
- separate costs for additional features like partitioning and performance tuning