What do you like best?
Oracle Team is continuosly working on its products and improving them. Oracle 12C has come up with lots of feature which enhanced it reliability,availability and robustness.Oracle database is well suited for DW and OLTP applications. Its is very secured due to its high security standards and good encrytion algorithm. It has great feature like Dataguard,ASM and Real Application Clusters.
What do you dislike?
-Management of tablespace fragmentation should be provided.
-It is little expensive where compared to other products in the market.
-There is a limitation of 25 characters in naming of trigger,sequence,etc.
-Auto-complete works very poorly in Oracle SQL Developer.
Recommendations to others considering the product:
Oracle Database is a perfect choice for the developers who are building OLTP and OLAP application. It has high performance and security and it is very good in scaling large datasets.
What problems are you solving with the product? What benefits have you realized?
I having been using Oracle Database since 1.6 years. We use Oracle Database in our organization which stores and handle OLTP transactions of around 5.4-6 lakhs records per day. In Oracle Database we have created jobs to run stored procedures which has helped in automating few processes. Creation of indexes,triggers and sequence are very easy