Overall Satisfaction with Oracle Database 12c
The Oracle 12C Database is used as a core business backbone for modeling the process of selling products in more than 25 countries in one of the biggest retailers in the world. The database not only deposit the data but also contains the business logic in PL/SQL packages.
- high performance
- mature and reliable
- rich in features
- can be expensive
- big footprint
- stability
- security
it was not my choice for Oracle 12C, but during the years I've learned on the advantages. If I would choose the Oracle 12C, I'll take it for the possibility to start from Standard and to go to enterprise based on a business case of use. I really like the possibility to have the logic in the database (triggers/ procedures/functions/packages)
Using Oracle Database 12c
80 - Application Users
Developers
Business Analysts
Developers
Business Analysts
10 - Oracle Database Administration Users
- store/retrieve data
- store business logic
- transfer data
- devops processes with no downtime via EBR
- running Oracle database on docker
- using database for feeding and consuming web services via JSON
- document store
Evaluating Oracle Database 12c and Competitors
Not Sure
- Product Features
- Product Usability
- Product Reputation
I would choose hard on the edition of the database. Sometimes even the express edition offers all you need for an internal application and if it scales up you can easily change to a standard or even an enterprise edition.
Oracle Database 12c Implementation
- Implemented in-house
- Professional services company
I can't disclose the company
Change management was a minor issue with the implementation
- understanding the business needs and implementing them in database
- human factors
- time compression
Using Oracle Database 12c
Pros | Cons |
---|---|
Relatively simple Well integrated Consistent Feel confident using | Requires technical support |
- administration via EM
- database development via SQL Developer with revers engineering on models
- reporting with APEX
- reading logs
- administering without proper options installed