Safe Harbor Statement

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Copyright © 2011, Oracle Corporation and/or its affiliates

Oracle Advanced Customer Support Services Exadata for SAP ein Kundenbeispiel

Uwe Kirchhoff ACS Support Senior Principal Service Delivery Engineer ORACLE Deutschland GmbH

Agenda Vorstellung ACS Support Exadata Hardware Exadata Einführung

ACS Support

Oracle Premier Support - Kundenwünsche Dedizierter Ansprechpartner im Oracle Support Weiterentwicklung Management und Updates von von Produkten kritischen Service Requests

Kundenumgebung Globale Supportbekannt Infrastruktur Proaktiver automatisierter Support

Proaktive Leistungen Lifetime zur Support Vermeidung Ecosystem von kritischen Support Problemen

ACS / Premier Support Premier Support - globale Support Organisation - rein reaktiver Support - SR orientierte Leistungserbringung - Skill-basierte Orientierung - 24x7 für Prio 1 SRs “follow the sun” - Englisch als Standardsprache - Oracle Support System als Basis - anonyme Kundenbetreuung

Advanced Support - lokale Support Organisation - proaktiver und reaktiver Support - Kundenorientierte Leistungserbringung - 24x7 für Prio 1 oder abgestimmte Prio 2 SRs mit zugeordnetem Support Team - Deutsch als Standardsprache - Support Anforderungen des Kunden als Basis - individuelle Kundenbetreuung

Advanced Customer Services - Module Account Review Meetings Production Assessments Migrations Planning Assessment Performance Reviews Configuration Reviews Backup/Recovery Reviews Knowledge Transfer Presentations Customer Portal, Planned Standby Patch Management Alerts, Notification, Best Practise

8

Proaktive Komponenten

Dedicated HotLine Database Recovery Data Extraction (DUL) Reproduction of Testcases SR Monitoring, Escalation Mgt.

Reaktive Komponenten

Local Focused Engineering Team

Dediziertes Support Team

ACS – Kunden Modell Lokales Technikerteam

ACS Support Team EMEA

Service Delivery Manager und Engineer Oracle Premier Support

Kunde

Exadata Hardware

Oracle Exadata Database Machine Hardware Architektur

Database Grid • X2-2 up to 8 Dual-processor x64 * 6 Cores database servers or • X2-8 2 Eight-Socket * 10 Cores x64 database servers

Intelligent Storage Grid • up to 14 High-performance low-cost storage servers

•

up to 100 TB High Performance disk, or up to 504 TB High Capacity disk

InfiniBand Network • Redundant 40Gb/s switches • Unified server & storage network

• up to 5.3 TB PCI Flash (384GByte/StorageServer)

• Data mirrored across storage servers

Copyright © 2011, Oracle Corporation and/or its affiliates

Exadata Storage Server Hardware (Sun Fire X4270 M2) • 2 Six-Core Intel® Xeon® L5640 Processors • 24 GB DRAM (6 x 4GB) • 12 x 3.5” Disk Drives (600GB SAS or 2TB SAS) • 4 x 96GB Flash PCIe Cards • Dual-port InfiniBand QDR (40Gb/s) HCA • Disk Controller SAS2 HBA with 512MB BBWC • Redundant Power Supplies, Fans • ILOM

Software: • Oracle Exadata Storage Server Software • Oracle Linux

X2-2 Database Servers (Sun Fire X4170 M2) • 2 Six-Core Intel® Xeon® X5675 Processors • Up to 144 GB DRAM (16 x 8GB) • Dual-port 10GbE PCIe card • Dual-port InfiniBand QDR (40 Gb/s) HCA • 4 x 2.5” 300GB Disk Drives • Disk Controller HBA with 512 MB BBWC • Redundant Power Supplies, Fans • ILOM

Software: • Oracle Database 11.2 • Oracle Linux or Solaris

Oracle Exadata Database Machine Vorteil : Ready to run

€$

OPTIMIERT !

• für Oracle Datenbank – – – – – – – –

Copyright © 2011, Oracle Corporation and/or its affiliates

hochverfügbar (RAC , ASM) skalierbar (RAC , ASM) extreme Performance Daten-Komprimierung Resourcenmanagement Flash Cache vereinfachtes Patching Automatic Service Request

Oracle Exadata Database Machine Vorteil : Auswahl Models

Multi Rack X2-8 Full Rack

X2-2 Full Rack

2 x64 Eight-Socket x 10 Core Database Servers 160 cores (80 per server) 2 TB memory (1 TB per server) 14 Storage Server 100 TB HP / 504 TB HC SAS Disk

8 x64 2-Socket x 6 Cores Database Servers 96 cores (12 per server) 768 GB memory (96GB per server) 14 Storage Server 100 TB HP / 504 TB HC SAS Disk

X2-2 Half Rack

X2-2 Quarter Rack

4 x64 2-Socket x 6 Cores Database Servers 48 cores (12 per server) 384 GB memory (96GB per server) 7 Storage Server 50 TB HP / 252 TB HC SAS Disk

2 x64 2-Socket x 6 Cores Database Servers 24 cores (12 per server) 192 GB memory (96GB per server) 3 Storage Server 21 TB HP / 36 TB HC SAS Disk

Copyright © 2011, Oracle Corporation and/or its affiliates

Oracle Exadata Database Machine Vorteil : Hochverfügbarkeit und Skalierbarkeit • Hochverfügbarkeit mit Real Application Cluster (RAC)

• Skalierbarkeit Datenbankserver (RAC)

• Automatic Storage Management

• Skalierbarkeit Hardware
quarter-half-full-multi-rack

• geprüfte Konfiguration • Bundle Patches vereinfachen Aktualisierungen

Copyright © 2011, Oracle Corporation and/or its affiliates

• Skalierbarkeit Storageserver

Oracle Exadata Database Machine Vorteil : Intelligente Software Klassische DB Lösung

Oracle Exadata Lösung

Datenbank Server

Datenbank Server

SQL und Datenanalyse

SQL und Datenanalyse

SQL und Datenanalyse

Copyright © 2011, Oracle Corporation and/or its affiliates

Oracle Exadata Database Machine für SAP Voraussetzungen SAP • SAP Applikationen unverändert lauffähig auf Exadata • SAP NetWeaver 7.x (x>=0)

SAP ERP (ECC) 6.0 SAP BW 7.x

SAP SRM 2005 / 2007 / 7.x SAP SCM 2005 / 2007 / 7.x

Copyright © 2011, Oracle Corporation and/or its affiliates

SAP CRM 2005 / 2007 / 7.x SAP PLM 6.0 / 7.0x

SAP Oil&Gas 2005 / 6.x SAP Banking Services 5.0 / 6.0 / 7.0 / 8.0

Exadata Einführung

Einführung SAP NW BI, SAP CRM auf Exadata

Copyright © 2011, Oracle Corporation and/or its affiliates

Oracle Exadata Database Machine Projekt Einführung 29.01.2012 goLive mit SAP NW BI + SAP CRM auf Exadata

goLive in

25

04.01.2012 Installation SAP BI Standby Database ca. 4TByte auf Exadata

Tagen

19.12.2011 Exadata Database Installation 12.12.2011 Hardware Check 25.11.2011 Auslieferung 2x Exadata Database Maschine 20.10.2011 Unterschrift Vertrag 2x Exadata Database Maschine QuarterRack 06.07.2011 Präsentation Exadata Database Maschine

Copyright © 2011, Oracle Corporation and/or its affiliates

Kunden Umgebung Ausgangs Infrastruktur SAP NW BI SAP CRM SAP (BI/CRM) SUSE Linux

Network

Database

SAN

1 GBit

SUSE Linux

4 GBit

Enterasys 4x HP DL360 2x 4C Intel Xeon 5640 2,6 GHz 48 GB RAM

1x HP DL580 4x 6C Xeon E7530 1,86 GHz 64 GB RAM

Storage

Brocade HP DL580 4x 6C (24 Cores) Xeon E7530 1,86 GHz 64 GB RAM Oracle 11.2.0.2 noCompress SGA Target Database Buffers

Copyright © 2011, Oracle Corporation and/or its affiliates

25.165.824.000 20.199.768.064

HP EVA8100

Kunden Umgebung Infrastruktur mit Exadata SAP NW BI SAP CRM SAP (BW/CRM) Netzwork SUSE Linux

10 GBit

Database Network Storage Oracle Enterprise Linux Oracle 11.2.0.2 noCompress 2x 6C (12 Cores) Intel Xeon 5675 3.07GHz 96 GB RAM

Enterasys 4x HP DL360 2x 4C Intel Xeon 5640 2,6 GHz 48 GB RAM

1x HP DL580 4x 6C Xeon E7530 1,86 GHz 64 GB RAM

Copyright © 2011, Oracle Corporation and/or its affiliates

SGA Target Database Buffers SAP BW Database SAP CRM Database

17.179.869.184 14.495.514.624 4 Tbyte 500GByte

Performance “out-of-the-box” Disc und Flash

Copyright © 2011, Oracle Corporation and/or its affiliates

Performance Ergebnisse Copyright © 2011, Oracle Corporation and/or its affiliates

Oracle Exadata Database Machine Ergebnisse – Queries

7.000

Alt System

6.000

5.000

Zeit Faktor:

4.000

EXADATA

13X Zeit Faktor:

3.000

2.000

1.000

0 1

SAP BI Query 1

Copyright © 2011, Oracle Corporation and/or its affiliates

2

SAP BI Query 2

14X

Oracle Exadata Database Machine Ergebnisse – Queries

Query

ZPCA_M0 2/ZCO_PC AM02_100 ZPCA_M0 2/ZCO_PC AM02_100

Time alt System (sec)

Time EXA (sec)

2.206

164

37Min

2Min40Sec

6.261

433

1h44Min

7Min

Factor

CPU Time alt

CPU Time EXA

Physical Reads alt

Physical reads EXA

13

602

146

22.669.277

22.669.225

14

1577

313

65.636.143

63.786.358

Copyright © 2011, Oracle Corporation and/or its affiliates

Oracle Exadata Database Machine Ergebnisse Zeit Faktor: 1,6X Zeit Faktor: 1,7X

4.000 3.000

1.500

Zeit Faktor:

2.000 1.000 0

Statistic

1 Calculation

3X

1.000 500 0

150

1 IMPDP vom Filesystem

100 50 0

EXPDP to1 ASM

Zeit Faktor:

160 140 120 100 80 60 40 20 0

5X

Zeit Faktor. 100 80 60 40 20 0

DROP

Table1

Copyright © 2011, Oracle Corporation and/or its affiliates

CREATE BITMAP INDEX 1

4X

Oracle Exadata Database Machine Ergebnisse Time alt System (sec)

Time EXA (sec)

Brconnect –f stats

3412

2.005

1,7

IMPDP von Filesystem

1.457

904

1,6

EXPDP zu ASM

116

43

2,7

CREATE BITMAP INDEX

93

22

4,3

DROP TABLE

152

29

5,2

Query

Faktor

Copyright © 2011, Oracle Corporation and/or its affiliates

CPU Time alt

CPU Time EXA

Physical Reads alt

Physical reads EXA

521

225

19.078.432

19.061.375

Oracle Exadata Database Machine Ergebnis SGEN

300

Alt-System 5 Stunden

250

200

EXADATA 43 Minuten

150

100

50

0 1 Zeit SGEN

Zeit Reduzierung

Copyright © 2011, Oracle Corporation and/or its affiliates

7X

Einführung SAP ERP auf Exadata

Copyright © 2011, Oracle Corporation and/or its affiliates

Kunden Umgebung Historie ERP Umgebung • 2005

Oracle RDBMS 9.2 Single Instance mit Lifekeeper + Dataguard

• 2008

Oracle RAC RDBMS 10.2 + OCFS2 Dataguard

• 2012

Oracle RAC RDBMS 11.2 Exadata + Dataguard

Kunden Umgebung Migration zu Exadata • Ausgangsumgebung Oracle RAC RDBMS/CRS 10.2.0.4 mit OCFS2 SLES 10 • Step 1 Via Standby zu SLES 11 mit CRS 11.2 • Step 2 Upgrade der Datenbank auf 11.2 • Step 3 Aufbau Standby Database auf der Exadata im ASM • Step 4 Switch zur Standby auf der Exadata

• Ziel erreicht

Performance Ergebnisse Copyright © 2011, Oracle Corporation and/or its affiliates

Performance Assessment Alt-System / Exadata Alt-System Hardware Intel® Xeon® CPU X7350/2 @ 2.93GHz CPU# 32 64 GB DRAM Dual-port 1GbE Ethernet Exadata Hardware Intel® Xeon® X5675 Processors @ 3.07GHz CPU# 24 96 GB DRAM Dual-port 10GbE Ethernet Dual-port InfiniBand QDR (40 Gb/s) HCA

Copyright © 2011, Oracle Corporation and/or its affiliates

Performance Assessment Alt-System / Exadata

Faktor: 4.3

Faktor: 9.3

Performance Assessment Alt-System / Exadata Einige Beispiele von Nachtjobs:

Jobname

Startzeit

Startdatum

Dauer(sec.)

ZFI_I_BUCHHALTUNGSSICHT_MAT PP

01:20:05

17.04.2012

17.203,00

ZFI_I_BUCHHALTUNGSSICHT_MAT PP

01:20:17

18.04.2012

15.439,00

ZFI_I_BUCHHALTUNGSSICHT_MAT PP

01:20:17

19.04.2012

14.544,00

ZFI_I_BUCHHALTUNGSSICHT_MAT PP

01:20:15

20.04.2012

15.576,00

ZFI_I_BUCHHALTUNGSSICHT_MAT PP

01:20:14

23.04.2012

10.524,00

ZFI_I_BUCHHALTUNGSSICHT_MAT PP

01:20:08

24.04.2012

10.044,00

ZFI_I_BUCHHALTUNGSSICHT_MAT PP

01:20:25

25.04.2012

10.728,00

ZFI_I_BUCHHALTUNGSSICHT_MAT PP

01:20:01

26.04.2012

10.959,00

Performance Assessment Alt System / Exadata

Jobname

Startzeit

Startdatum

Dauer(sec.)

ZFIMAT_CHECK BU KORRPLM PLM 1000

00:15:09

17.04.2012

14.451,00

ZFIMAT_CHECK BU KORRPLM PLM 1000

00:15:52

18.04.2012

17.106,00

ZFIMAT_CHECK BU KORRPLM PLM 1000

00:15:10

19.04.2012

23.923,00

ZFIMAT_CHECK BU KORRPLM PLM 1000

00:15:17

20.04.2012

26.655,00

ZFIMAT_CHECK BU KORRPLM PLM 1000

00:15:06

23.04.2012

5.352,00

ZFIMAT_CHECK BU KORRPLM PLM 1000

00:15:18

24.04.2012

4.634,00

ZFIMAT_CHECK BU KORRPLM PLM 1000

00:15:04

25.04.2012

4.745,00

ZFIMAT_CHECK BU KORRPLM PLM 1000

00:15:14

26.04.2012

4.630,00

Performance Assessment Alt System / Exadata Jobname

Startzeit

Startdatum

Dauer(sec.)

ZCOPA-BERICHT 1000

23:55:03

16.04.2012

27.577,00

ZCOPA-BERICHT 1000

23:55:03

20.04.2012

23.190,00

ZCOPA-BERICHT 1000

23:55:06

17.04.2012

26.332,00

ZCOPA-BERICHT 1000

23:55:10

18.04.2012

28.236,00

ZCOPA-BERICHT 1000

23:55:14

19.04.2012

28.551,00

ZCOPA-BERICHT 1000

23:55:14

24.04.2012

2.720,00

ZCOPA-BERICHT 1000

23:55:24

23.04.2012

5.461,00

ZCOPA-BERICHT 1000

23:55:29

25.04.2012

2.531,00

Zusammenfassung

Exadata liefert bessere Performance „out-of-the-box“






SAP läuft ohne Änderungen Sofort ergibt sich eine bessere Leistung keine Exadata- oder DB spezifischen Tunings nötig keine Oracle init.ora Parameter Änderungen keine „bottlenecks“ in der Hardware / Infrastructure erkennbar

Copyright © 2011, Oracle Corporation and/or its affiliates

Oracle Engineered Systems Simplify I.T.

Conventional Systems

Copyright © 2011, Oracle Corporation and/or its affiliates

Engineered Systems

Weitere Informationen http://www.oracle.com/sap http://www.oracle.com/exadata http://www.sdn.sap.com/irj/sdn/ora

Copyright © 2011, Oracle Corporation and/or its affiliates

Copyright © 2011, Oracle Corporation and/or its affiliates