October 26, 2018
Score 7 out of 10
Overall Satisfaction with Oracle Database 12c
Oracle Database is used by our organization, mainly as our shopping site backend. Many of our internal apps leverage Oracle database today. Speed and load are the main problems it addresses for us.
- Oracle database is very fast and efficient, battle tested and has been in the industry for a long time, meaning they have a good understanding of the markets demands.
- Security plays a major role. It ensures that data is not tampered with through prompt updates.
- It is hard to administrate and critical for the business if it does get down, works perfectly with AIX and can be boosted with powerha or Oracle Rac. It's important to be with Oracle because you have big support and the liability that the database will always improving their performance.
- Oracle is one of the biggest and more stable databases, but it's a kind hard to learn how to use it and administrate it. It becomes involved with many library's and files on the operating systems so you will have to have a good knowledge of Oracle and the OS.
- 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 queries and security of your data.
- 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.
- 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, you really need an expert in your organization to work on it.
- Technically I do not like the price of the 12c other than Price feature. Oracle is one of the biggest and most stable databases, but it's kind of hard to learn how to use it and administrate it. It becomes involved with many libraries and files on the operating systems so you will have to know a good knowledge of Oracle and the OS.
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 optimize 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. 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.