Overall Satisfaction with Oracle Database 12c
As a consultant, I support my customers on Oracle Database, with different solutions based on the requirements. Oracle Database is suitable for different kinds of purposes, from DWH to OLTP applications, no matter what (on-premise or in the cloud). Also, in our organization, Oracle Database is used as an RDBMS repository for production environments.
- Standardization: Oracle RDBMS software is the same on-premise (on standard hosts and on engineered systems) and in cloud.
- Maximum Performance: Oracle Database can support different workloads and the performance can be extremely high when using Oracle Exadata.
- Multitenancy: this is one of the best new features of 12c release. Oracle RDBMS can now support the possibility of creating a container database with several pluggable databases inside. Multitenancy can lead resource reduction and simple management of the databases.
- Far Sync: using Oracle Data Guard option, you can reduce the risk of unplanned outages even in case of disaster. You can syncronize a remote database with near-zero data loss suing far sync instances.
- Learning: you need a specialist to install/mantain Oracle Databases. There are sereral factors to take care: installation, tuning, backup & recovery and so on.
- Cost: it's expensive for small companies.
- High Availability of databases using Real-Application Cluster
- Consolidation of different applications in a single database
- Zero data-loss in case of disaster using Data Guard
The choice is not easy and it hardly depends on sereval factors, for example, certification of the applications, costs, features, performance and so on...