By Parnian Taidi-Oracle on Jan 08, 2016
Oracle and Informatica have a very close working relationship and one of the recent results of this collaboration is the joint project done by Informatica and our Oracle ISV Engineering team to test the performance of Informatica software with Oracle Database 12c In-memory on Oracle SPARC systems.
Informatica previously optimized their PowerCenter and Data Quality applications on Oracle Engineered Systems, achieving up-to five times faster performance with Oracle Exadata Database Machine and the SPARC-based Oracle SuperCluster (see announcement). They have been Oracle SuperCluster Optimized as well as Oracle Exadata and Exalytics Optimized since 2014. Now they have taken a step further by successfully testing PowerCenter with the Oracle Database 12c In-memory feature achieving extreme performance on SPARC.
A significant number of Informatica customers use Oracle as their main database platform. With the introduction of the Oracle Database 12c In-Memory Option, it is now possible to run real-time, ad-hoc, analytic queries on your business data as it exists right at this moment and receive results in sub-seconds. True real-time analytics! The Oracle SPARC big memory machines with up to 32 terabytes of memory are the perfect match, delivering extreme performance for in-memory databases and business analytics applications.
Informatica PowerCenter and Oracle Database 12c were both installed on the same machine and Informatica leveraged the In-memory feature really well and was able to scale very well on the Oracle SPARC machine.
The following are some of the test results showing the Oracle Database 12c in-memory advantage on SPARC for Informatica:
- TPC-H Q6 Performance: 9x in-memory over buffer cache for the workload tested
- TPC-H Q10 Performance: 1.5x in-memory over buffer cache for the workload tested
- Oracle Writer Throughput Performance: 2.5x performance improvement in Ram Disk to Ram Disk over Disk to Disk
- PDO Performance: Aggregator Tx Throughput: 1.5x in-memory over buffer cache for the workload tested
The tests were run with the following software/hardware stack:
- Informatica 9.6.1
- Oracle SPARC, 8 PROCESSOR, 12 core , 2TB RAM, 4.3 TB Disk
- Oracle Solaris 11.2
- Oracle DB 12c
- Network 10GBps
- Setup: Domain and DB on same machine
Oracle SPARC servers and Oracle SuperCluster with Oracle Database 12c In-memory prove to be a great platform for Informatica customers to run their analytic queries.
For more details you can contact email@example.com.