My thought on Oracle Database 12C
April 11, 2018

My thought on Oracle Database 12C

Ciprian Onofreiciuc | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

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)
OLTP Enterprise Application
High Availability
Ready to run on different operating systems (Windows/Linux/AIX/Solaris)


Using Oracle Database 12c

80 - Application Users
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
I invested a lot in learning this piece of art, and beside the fact that is very powerful it is quite easy to administer via enterprise managed

Evaluating Oracle Database 12c and Competitors

  • 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

easy database installation even for high availability environments
reliable infrastructure if correctly installed
  • 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

lack of mobile version of product, otherwise 10
ProsCons
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