WIXLIB

SAPOracleOracle SAP forfor T E C H N O L O G YU P D A T ET E C H N O L O G YU P D A T EDATABASE IN-MEMORYNo. 25 Oracle for SAP, May 2016www.oracle.com/sap

Hardware and Software Engineered to Work TogetherDEAR SAP CUSTOMER,Oracle provides the world’s most complete, open, and integrated technology stackincluding database, business software, operating systems, servers, and storage.Oracle technologies make SAP applications run better.The relationship of Oracle Corporation and SAP SE has been based on our long history,a rich heritage of joint developments and a bright future – for the benefit of mutualcustomers.Oracle will support SAP Business Suite and SAP BW as long as SAP will be supportingthem. As per SAP Note 1951491, with SAP NetWeaver 7.4 SP08, SAP is introducing innovation to take advantage of new technical capabilities of the Oracle Database platform(i.e. Core Data Services) and Oracle Database In-Memory (SAP Note 2178980), and SAP BW optimized InfoCubes/Flat Cubes.Both companies have had an ongoing commitment to our tens of thousands of joint customers for over 28 years.Our longstanding reseller and support agreements provide enhanced access to Oracle Database technology and world classcustomer support. The Oracle product strategy provides flexibility and choice across the IT infrastructure. A growing majorityof mid-size to the largest SAP enterprise customers, in every industry, entrust their application deployments to the OracleDatabase.By choosing the Oracle Database and Database options, SAP customers significantly benefit through the ongoing innovations without disruption. By taking a closer look, at least eight differentiators have been identified which will explain indetail why the Oracle Database is the first choice for running SAP applications. They bring best performance and scalability, deployment flexibility, availability, reliability, disaster recovery, security, manageability, self management, support forvery large databases, support for database consolidation and the integration of hardware and software. All SAP customerscan enjoy the benefits of the features and functions of the Oracle Database to cost optimize their SAP deployments.The following Oracle Database 12c options are SAP certified and available:- Oracle Database In-Memory- Information Lifecycle Management (ILM) /Automatic Data Optimization (ADO)- Hybrid Columnar Compression (HCC) for Oracle Exadata and Oracle SuperCluster in conjunction with ILM- Oracle Multitenant option (CY 2016)The Oracle Exadata Database Machine is engineered to consolidate all of your SAP and non-SAP Databases into a privateDatabase Cloud environment. It delivers the highest performance and most available platform for running the privateOracle Database Cloud for all types of database workloads; including both Online Transaction Processing (e.g. SAP ECC 6.0),and Data Warehousing (e.g. SAP BW 7.0 and higher). The Exadata Database Machine is ready to tackle your largest andmost important database workload – and often run them up to 10 times faster or more – deployed by a large number ofSAP customers today.Oracle SuperCluster is the first general-purpose engineered system that combines the computing power of thenew SPARC processor, the performance and scalability of Oracle Solaris 11, the optimized database performanceof Oracle Exadata storage, and the optimized runtime for SAP kernel 6.40 and higher.Oracle redefines the economics of enterprise computing with a complete refresh and expansion of its SPARC M7and T7 server portfolio providing customers the industry’s best value with leading price/performance.

Hardware and Software Engineered to Work TogetherOracle Exalogic Elastic Cloud delivers virtually unlimited scalability, unbeatable performance, and previously unimagined management simplicity to SAP and non-SAP applications in combination with Oracle Exadata DatabaseMachine.Oracle Private Cloud Appliance is an engineered system that radically simplifies the way customers install, deploy,and manage converged infrastructures, which can be used as virtualization platform for database and application.The Oracle Database Appliance is a new way to take advantage of the world’s most popular Oracle Database, in asingle, easy-to-deploy and -manage system. It’s a complete package of software, server, storage, HA and networkingthat’s engineered for simplicity; saving time and money by simplifying deployment, maintenance, and support ofdatabase workloads.Oracle Linux 7 is the latest Linux version of Oracle for your SAP infrastructure computing needs. It is fast –delivers best performance for SAP – is up to date – brings the latest innovations to customers; is reliable –provides data integrity, better security, and improved application uptime; and is optimized for Oracle Databasesunderneath SAP.Oracle VM Server for x86 is a free server virtualization solution that makes SAP and other enterprise applicationseasier to deploy, manage, and support.The Oracle development teams on site at SAP SE in Walldorf, Germany continue to work together with SAP developers to ensure that SAP customers will always have access to the latest optimized Oracle technologies ensuringperformance, reliability and innovation.The Oracle for SAP Service & Support team offers Advanced Customer Services (ACS) that include health checks,workshops, database migrations, performance, tuning and ACS Oracle Solaris Services for SAP environments,including Assisted Services Engagements (Analysis/Enhancement and SAP Readiness Service for IT Infrastructure).For more information or to see current and previous editions go to: www.oracle.com/sapWe welcome your comments and questions. Please contact us at: frontdesk-walldorf de@oracle.comSincerely,Gerhard KupplerVice President SAP AlliancesOracle CorporationOracle Corporation: With more than 420,000 customers – including 100 of the Fortune 100 – andwith deployments across a wide variety of industries in more than 145 countries, Oracle offers a comprehensive and fully integrated stack of cloud applications, platform services, and engineered systems,more than 25,000 partners worldwide, more than 130,000 employees, including 37,000 developersand engineers, 18,000 support personnel and 17,000 consulting experts.

Oracle Database In-Memory at Villeroy & BochRenowned ceramics manufacturer Villeroy & Boch AG and hosting partner Rödl IT Operation GmbHtest Oracle Database In-Memory for SAP NetWeaver BWHUGE PERFORMANCE BOOST CONFIRMED,M I N I M A L I M P L E M E N TAT I O N E F F O R T C O M E S A S S U R P R I S EWith an annual revenue of approximately 800 millionand over 7,300 employees, Villeroy & Boch AG is one ofthe world‘s leading manufacturers in the ceramics industry.The family business, which was founded in 1748 and isheadquartered in Mettlach/Germany, stands for innovation,tradition and exceptional style. As a renowned lifestylebrand, Villeroy & Boch offers products from the sectorsBathroom, Wellness and Tableware, and is active in 125countries.Both business areas use an SAP ERP and an SAP BW systemas well as other SAP solutions. Villeroy & Boch has beenusing Oracle‘s proven, reliable database to great advantagefor around 20 years. Over the years the use and importanceof BW/BI has steadily increased. The company has approximately 2,500 SAP users worldwide, including around 1,700in the SAP BW environment. Certified SAP hosting partnerRödl IT Operation GmbH (with offices in Mettlach, Selb,and Frankfurt) operates and manages a range of systems including all SAP systems on behalf of Villeroy & Boch AG.As Villeroy & Boch CIO and IT Director Thomas Ochsexplains, „It was at an event organized by German-speakingSAP user group DSAG in early 2015 that we learned aboutthe new Oracle Database 12c for SAP and the Oracle Database In-Memory technology, mainly from the standpointof potential performance improvements for our SAP NetWeaver BW systems. Some time later our hosting partnerRödl IT Operation GmbH suggested performing a jointtest of the Oracle 12c technology as part of a transparentproof of concept (PoC), and we agreed. The questions thatinterested us most were: What potential performanceimprovements could we achieve by using Oracle DatabaseIn-Memory for SAP BW? And how much implementationwork would be involved?”Tests on an SAP BW sandboxFor the tests with Oracle Database In-Memory, fact tables(E and F tables) from the largest COPA cube at Villeroy &Boch AG were used, with around 94 million rows. “Obviously, we wanted to perform the tests with real productiondata to produce results and an actual comparison of theoutcome with and without In-Memory. With these kindsof tests it was mainly about read times for data and queriesboth with and without database aggregation. We also wantedto evaluate how this Oracle 12c technology works withidentical hardware configurations and the addition of morememory,” says Harald Wolf, Senior Consultant BI atVilleroy & Boch within the corporate IT team, who carriedout the PoC in close collaboration with Klaus Lehnen, headof the competence center for SAP-based technology at RödlIT Operation GmbH.For the PoC the partners constructed an SAP BW sandboxwhich was an exact copy of the productive SAP BW system,with a total of 64GB of In-Memory storage being earmarkedfor the database. The Oracle database for the SAP BW systemwas then upgraded from 11g to 12c. Lehnen explains, “Theaim was to test Oracle Database In-Memory on comparablestandard hardware. For both the BW sandbox with 128GB ofRAM and the BW PROD system with 96GB of RAM weused an X86 RedHat Linux-based system environmentvirtualized with VMware on two CPUs with a total of 16cores.”He goes on to explain how the Oracle 12c upgrade and theactivation of Oracle Database In-Memory was completed inaround five hours. The entire PoC was carried out in 1.5 dayswith very reasonable resource utilization. After an initial brieftest, only two database parameters were adjusted as a recommended tuning measure.The LISTCUBE transaction was used for all the tests performed by the partners. The database response times werecalculated with SQL traces using SAP transaction ST05(performance analysis). All data was compressed beforehandutilizing Oracle Advanced Compression.Exceeding expectationsIn total, Villeroy & Boch and Rödl IT Operation GmbHcarried out four different test scenarios on the SAP BWsandbox with Oracle Database In-Memory. Each wasfollowed by an evaluation of the results from the SAPapplication.In the first test, 1 million records were selected withoutdatabase aggregation and processed with In-Memory,several times over. The database processing time wasmeasured with preparation and transfer times being measured separately. For the PROD system, the data showedthat the entire process took 24 seconds. The equivalentprocess in the SAP BW sandbox with Oracle DatabaseIn-Memory yielded a significant reduction in processingtime as it was reduced to 160 milliseconds and as little as5 milliseconds in some cases.After the successful testing Villeroy & Boch is now adopting Oracle Database In-Memory for their SAP installation.Please read more of the Villeroy & Boch success story uction/newsletter/index.html