Oracle 12c - a PeopleSoft development perfect match
January 30, 2018

Oracle 12c - a PeopleSoft development perfect match

Bennett Walker | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Database 12c

Oracle 12c is used primarily as the database for our PeopleSoft systems - two installations one of PeopleSoft HCM and one of PeopleSoft FSCM. Oracle Database 12c allows for all of the transactional data to be retained and archived. Data replication, speed and disaster recovery are all addressed very easily with Oracle 12c.
  • Speed - Oracle 12c is incredibly fast over very large data sets, the Oracle optimizer allows for complex queries to have results returned very quickly.
  • Enterprise Dataset size - Oracle 12c is built to handle the needs of a large organization.
  • Disaster recovery - built-in replication methods and archival allows for easier maintenance for business-critical data.
  • Oracle 12c SQL Developer is included with the product for no additional licensing cost, but it is much more limited compared to query tools such as TOAD.
  • Oracle 12c stumbles on certain queries with the optimizer not catching simple methods to return queries very quickly. Often a scalar subquery is required to reduce the time by up to 99%.
  • On occasion, the optimizer can miss simple changes such as IN ('1','2','3') working but BETWEEN '1' AND '3' being stuck in an infinite loop.
  • Incredible support and data integrity have allowed for more reliable backend systems.
  • Robust utilities for database management and analysis allow for a greater visibility into usage.
  • The ability to quickly gather insights into data and compartmentalize using schemas has given a great return on investment.
Oracle 12c delivers a vastly superior and robust optimizer and thread management comparative to other database products that I have used. While other databases may be less costly, Oracle 12c gives the best enterprise data management solution by providing better data integrity, analysis tools and disaster recovery options as well as world class support.
Oracle 12c is appropriate for large-scale enterprise applications where data availability, integrity, disaster recovery and efficiency is important. It is not well suited to smaller organizations with small data sets and less need for immediate disaster cutover. The license cost for an Oracle 12c database installation makes it not relevant for small installations or smaller applications, while the support of Oracle and data archival and maintenance make a large installation well worth it.