What is Oracle Exadata 1

Oracle Exadata Database Machine Next Generation X7-2

Transcript

1

2 Oracle Exadata Database Machine Next Generation X7-2 Frank Schneede Senior System Consultant Oracle BU Core & Cloud Technologies Copyright 2018, Oracle and / or its affiliates. All rights reserved.

3 Abstract The new Exadata X7 is rather inconspicuous, but it contains some new functions that are important and of great benefit to users. On the one hand, the benefit lies in new, faster hardware, but also in new individual components that significantly improve the handling and expandability of the Exadata and its availability. This lecture briefly introduces the new generation, but the focus should be on showing the effects of the innovations and their possibilities for the user. Of course, the current version of the database 18c is checked, which is available on Exadata from the start. 3

4 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. 4th

5 Agenda Introduction Exadata Database Machine X7-2 Hardware Exadata X7-2 Configuration Alternatives Guide to Upgrade or Renewal Exadata Database Machine Software Conclusion 5

6 Introduction Copyright 2018, Oracle and / or its affiliates. All rights reserved. 6th

7 Oracle Engineered Systems ZFS Backup Appliance Zero Data Loss Recovery Appliance Exadata Database Machine Big Data Appliance Exalogic Elastic Cloud Private Cloud Appliance Exalytics Oracle Database Appliance Data Protection Database Big Data Big Data SQL Middleware / Apps Analytics Dept 7

8 Exadata Database Machine Performance, availability and security Most powerful platform for Oracle databases on-prem and in the cloud This is only made possible by: Oracle is responsible for the entire stack Optimized for the operation of databases Extensive HW and SW integration Unique storage architecture 8

9 History: Exadata models and key functions Main new features V1 V2 X2-2 X3-2 X4-2 X5-2 X6-2 X7-2 Smart Scan IORM Smart Flash Cache Storage Index HCC Write-Back Flash Cache Active Bonding OVM Network Exadata Snapshots Automatic Flash Exafusion Protocol Caching Smart Fusion Block Transfer In-Memory Columnar in Flash Exadata Topics HP HW Full Rack Sun HW Quarter Rack Half Rack Storage Server Sales X2-8 ASR SAP Certified X3-8 KVM Abolition Eighth Rack Additional Equipment Platinum Service Support Elastic Configuration EF Model, HP discontinued Capacity on Demand X4-8 X5-8 X6-8 X7-8 Related product Exalogic Exalytics SPARC Super Cluster Storage Expansion HP Storage Expansion HC Big Data Appliance Recovery Appliance Exadata Cloud Service Exadata 9

10 Exadata Database Machine X7-2 Hardware Copyright 2018, Oracle and / or its affiliates. All rights reserved. 10

11 Exadata X7 Hardware: A Big Technological Leap! Intel Xeon Platinum 8160 processor (Skylake) 50% more memory channel and faster memory 50% more standard memory, factory expansion 150% faster 25Gb / sec Ethernet, more network options 100% more capacity, faster, hot swappable NVME PCIe Flash New M.2 hot swappable boot drives New Ethernet Management Switch 25% larger hard drives & New Disk Controller HBA 11

12 Exadata Hardware Architecture Fully Optimized Standardized Hardened New! Database Grid 2-socket X86 server 48 cores, up to 1536GB DRAM 8-socket X86 server 192 cores, up to 6TB DRAM InfiniBand network 40 Gb InfiniBand uniform for storage and server 25, 10 Gb or 1 Gb Ethernet connection to the customer network Redundant components Storage Grid Extreme Flash Storage Server 51.2 TB NVMe Flash High Capacity Storage Server 25.6 TB NVMe Flash TB SAS hard drives 192GB DRAM, expandable! 2-socket server 20 cores per server 12

13 Oracle Flash Accelerator F640 PCIe Card Increase in server and application efficiency 6400 GB capacity Up to 778K / 195K random read / write IOPS (8K) 120/30 microseconds random read / write latency Up to 6.550 / 3.100 MB / sec sequential Read / write (1M) 79/14 microseconds sequential read / write latency (4) F640s Per Storage Server 25.6 TB of Flash per Storage Server High read and write IOPS Consistent low-latency High reliability and endurance New Long service life: 2 million hours. MTBF Non-Volatile Memory Express (NVMe) Standard Industry Standard (March 01, 2011) Increase in IOPS & throughput, low latency, high reliability

14 X7-2 Database Server plus InfiniBand Infrastructure New 24-core Skylake-EP CPUs, DDR Memory expandable to 1536 GB Processors DDR Memory Local Disks Disk Controller Network Remote Management Power Supplies 2 Twenty-four-Core Intel Xeon 8160 Processors (2.1GHz) 384 GB (12 x 32GB) Expandable to 1536 GB (24 x 64GB) via memory kits 4 x 600GB 10K RPM SAS Disks (Hot-Swappable) Expandable to 8 x Disk Controller HBA with 1GB Cache No More batteries 2 x 1G / 10G Base -T Ethernet Ports OR 2 x 10G / 25G Ethernet SFP28 Ports LAN on Motherboard (LOM) based on the Broadcom Limited BCM57417 NetXtreme- E 10G / 25G RDMA Ethernet Controller 2 x 10G / 25G Ethernet SFP28 Ports Add in Card (AIC) based on the Broadcom Limited BCM57414 NetXtreme-E 10G / 25G RDMA Ethernet Controller Click for Port Details 1 Ethernet port (ILOM) 1 Ethernet Port (HOST) Redundant Hot-Swappable power supplies and fans 14

15 Exadata X7-2 Storage Server HC plus InfiniBand Infrastructure New 10-core Skylake CPUs, Larger NVMe Flash Cards Processors DDR4 Memory Drives Flash Disk Controller Network Remote Management Power Supplies 2 Ten-Core Intel Xeon 4114 Processors (2.2GHz) 192 GB (12 x 16GB) Expandable to 1536 GB (24 x 64GB) via memory kits 12 x 10 TB 7.2K RPM High Capacity SAS (hot-swap) 3.5 disk size 2x 150 GB M.2 Drives performing Boot and Rescue Functions No More USBs 4 x 6.4 TB Flash Accelerator F640 PCIe Card Non Volatile Memory Express (NVMe) protocol Disk Controller HBA with 2 GB Cache - No more batteries 2 InfiniBand 4X QDR (40Gb / s) Ports (PCIe 3.0) All Ports Active Embedded Gigabit Ethernet Ports for management connectivity 1 Ethernet port (ILOM) 1 Ethernet port (HOST) Redundant Hot-Swappable power supplies and fans 15

16 Exadata X7-2 Eighth Rack Storage Server HC plus InfiniBand Infrastructure Granular upgrade for Exadata X7-2 HC Eight Rack Processors 2 Ten-Core Intel Xeon 4114 Processors (2.2GHz), 10 cores enabled New! DDR4 Memory Drives Flash Disk Controller Network Remote Management Power Supplies 192 GB (12 x 16GB) 6 x 10 TB 7.2K RPM High Capacity SAS (hot-swap) 3.5 disk size 2x 150 GB M.2 Drives performing Boot and Rescue Functions No More USBs 2 x 6.4 TB Flash Accelerator F640 PCIe Card Non Volatile Memory Express (NVMe) protocol Disk Controller HBA with 2 GB Cache - No more batteries 2 InfiniBand 4X QDR (40Gb / s) Ports (PCIe 3.0) All Ports Active Embedded Gigabit Ethernet Ports for management connectivity 1 Ethernet port (ILOM) 1 Ethernet port (HOST) Redundant Hot-Swappable power supplies and fans 16

17 Exadata X7-2 Do-Not-Service LED on storage servers Application controls indicator Detailed view In order to avoid accidentally switching off the wrong storage server, there is a new LED that shows whether the server is e.g. B. can be safely switched off for maintenance purposes LED is switched on automatically and in real-time if the redundancy is reduced and the server should NOT be switched off See Exadata SW What s New for further information 17

18 New options for client connection State-of-the-art 25 Gigabit Ethernet connection from the database server to the clients Dual Port 25 Gigabit Ethernet Fiber Card Optional Quad-Port 10 Gigabit Ethernet Copper Card All ports can be connected to the OEDA (Oracle Exadata Deployment Assistant) 18

19 Connection options X7-2 DB Server Refer to OEDA Documentation on How to Configure these Ports 2x SFP28 10G / 25G BCM x QSFP + QDR HCA Infiniband X-Option PN x RJ45 10G Ports Add in Intel X710 X557-AT NIC eth4 eth3 ib1 ib0 eth8 eth7 eth6 eth5 KEY eth0 eth1 eth2 10G RJ45 or 25G SFP28 Client or Backup but not all 4 ports at once Client or Backup 10G or 25G SFP28 ILOM (1G NET MGT) HOST admin (1G NET 0) RJ45 (Net 3/4) OR SFP28 (Net1 / 2) BCM57417 LOM Client 1 / 10G RJ45 Backup 1 / 10G RJ45 Return to X7-2 Overview 19

20 New Management Switch Cisco Nexus 93108TC-EX-1G Ports 48 x 10/25 Gbps and 6 x 40/100 Gbps QSFP28 Downlink 100Mbps and 1 / 10Gbps CPU 4 Cores System Memory 24GB SSD Drive 64GB System Buffer 40MB Management Ports 1 RJ -45 and 1 SFP USB ports 1 RS-232 serial ports 1 Typical / Maximum Power 290W / 499W MTBF 366,130 hours Source: 20

21 Exadata X7-2 configuration alternatives Copyright 2018, Oracle and / or its affiliates. All rights reserved. 21

22 Capacity on Demand (CoD) extended for X7-2 Requirements New! At least 40% of the DB server cores must be activated during installation 1,2 Customer must use Platinum Services 3, EM or OCM 4 (Oracle Configuration Mgr) Cores can only be added, never reduced! Available for all Exadata X7-2, Release (October, 2017) Not possible for IaaS, or Storage Server Cores 1 For X7-2 with 48 cores per db server, at least 14 cores (7 processor licenses) must be enabled, for X7 -2 Eighth Rack minimum is 8 per database server. For X7-8 with 192 cores per db server, at least 56 cores (28 processor licenses) must be enabled. 2 This rule only applies to db servers that are turned on. Customers may still turn off a db server as before. 3 Platinum or OCM installation must occur within 3 months after Exadata installation. Customer must remain connected and in compliance in order for Capacity- On-Demand licensing to remain valid. 4 If using OCM instead of Platinum support, OCM must be in connected mode. 22nd

23 Exadata Memory Expansion Options DB consolidation DDR LRDIMM optional expansion for X7-2 DB Server and X7-2 EF and HC Server X7-2 DB Server available from the factory with 384GB (12x32GB) or 768GB (12x64GB) Subsequent expansion of the main memory of the X7- 2 database servers from 384 GB to 768 GB or to 1536 GB with 64GB DIMMs all 32GB DIMMs must be removed when 64GB DIMMs are configured X7-2 EF & HC Expansion of the main memory of the X7-2 EF & HC servers from 192 GB to 768 GB or on 1536 GB with 64GB DIMMs all 16GB DIMMs must be removed when 64GB DIMMs are configured New! Tip: Order from the factory with 768GB main memory! NO expansion necessary when upgrading DIMMs! Cost savings! 23

24 Exadata Database Machine X7-2 (Base) Eighth Rack HC entry-level configuration 2 Xeon-based dual-processor database servers 48 cores (one processor, 24 cores per server) 768 GB memory expandable to 1536GB (384 GB per server expandable to 768 GB) 10/25 Gig E-connectivity to Data Center 8 x 10/25 Gb E-ports (4 per server) 3 Exadata Storage Server X7-2L consists of 6x 10 TB SAS disks and 2x 6.4 TB Flash Accelerator F640 PCIe Cards 2x Sun Datacenter InfiniBand Switch port Managed QDR (40Gb / s) switch 1 Admin Ethernet switch Redundant Power Distribution Units (PDUs) Two upgrade alternatives 1. Full Quarter Rack DB Servers 2. Add Exadata Eighth Rack Storage Server HC New upgrade path! 24

25 Scalable configuration offers investment protection Elastic hardware configurations Eighth to Qtr upgrade * Add servers as required * Add racks for further scaling * * Expand old racks with new servers or connect old and new racks X7-2 Eighth Rack Quarter Rack Full Rack X7-8 Elastic Configuration Capacity-on-Demand software licensing Activate DB server cores as required Oracle software license only for active cores * 14 cores minimum per DB server (max 48 cores) * 8 cores minimum per eighth rack DB server (max 24 cores) 25

26 Exadata Database Machine X7-2 HC Eighth Rack Expansion options Basic configuration Eighth Rack 2x X7-2 database server (2 sockets) 3x X7-2 High Capacity Storage Server alternatives Storage upgrade Adding Exadata Eighth Rack Storage Server HC Adding (min 3) Exadata Storage Server HC Advantages: Only approx. 10% of the eighth racks were expanded to quarter racks. No problem when changing the hardware generation. Granular expansion of the storage (6 storage licenses instead of 18 or 12). Also large expansion with 3 storage servers is possible (36 licenses) 26

27 Exadata Database Machine Eighth Rack Extension in real life Output configuration (06/2016): 3 * X6-2 ER HC 2 machines production (MAA architecture) 1 machine test extension (2017): ER to QR Upgrade of a machine Task: Standby must be extended standby should be configured identically to prod challenge: no X6-2 ER to QR upgrade available no standard procedure possible prod standby test 27

28 Exadata Database Machine Eighth Rack extension in real life Initial configuration (06/2016): 3 * X6-2 ER HC 2 machine production (MAA architecture) 1 machine test extension (2017): ER to QR upgrade of a machine solution approach (Approval required!): Bring DB Server (Standby) to QR Prod Standby Test 28

29 Exadata Database Machine Eighth Rack extension in real life Initial configuration (06/2016): 3 * X6-2 ER HC 2 machine production (MAA architecture) 1 machine test extension (2017): ER to QR upgrade of a machine solution approach (Approval required!): Bring DB server (standby) to QR Manual ER to QR upgrade by test HW Prod standby test 29

30 Exadata Database Machine Eighth Rack extension in real life Initial configuration (06/2016): 3 * X6-2 ER HC 2 machine production (MAA architecture) 1 machine test extension (2017): ER to QR upgrade of a machine solution approach (Approval required!): Bring DB server (standby) to QR Manual ER to QR upgrade through test HW installation 3 * X7-2 Storage Server in test technical details in coordination, approval running.! Turned off Prod Standby Test 30

31 Upgrade or Renewal Guide Copyright 2018, Oracle and / or its affiliates. All rights reserved. 31

32 Exadata Database Servers V1 V2 X2 X3 X4 X5 X X7 Harpertown 8 cores per server Nahelam 8 cores per server Westmere 12 cores per server Sandy Bridge 16 cores per server Ivy Bridge 24 cores per server Haswell 36 cores per server Broadwell 44 cores per server Skylake 48 cores per server Full Rack (8 servers) 192 cores 288 cores 352 cores 384 cores Qtr Rack (2 servers) 48 cores 72 cores 88 cores 96 cores Eighth Rack (2 servers x.5) 24 cores 36 cores 44 cores 48 cores 32

33 Exadata Disk Storage V1 V2 X2 X3 X4 X5 X X7 1 TB 2 TB 3 TB 4 TB 8 TB 10 TB Helium Helium Full Rack (14 storage) Qtr Rack (3 storage) 200 TB 400 TB 400 TB 500 TB 43 TB 85 TB 85 TB 107 TB Usable Capacity with HIGH Redundancy before Compression 33

34 Exadata Flash Storage V1 V2 X2 X3 X4 X5 X X7 96 GB per card 96 GB per card 384 GB per card 768 GB per card 1.6 TB per card 3.2 TB per card 6.4 TB per card Full Rack HC Flash Cache /% of Disk Qtr Rack HC Flash Cache /% of Disk 45 TB / TB / TB / TB / .72 9 TB / TB / TB / TB / .69 Usable Capacity with HIGH Redundancy before Compression Full Rack EF (All Flash) Qtr Rack EF (All Flash ) 50 TB 102 TB 204 TB 10 TB 22 TB 44 TB 34

35 Exadata Flash Performance V1 V2 X2 X3 X4 X5 X X7 1.8 GB / sec 2.5 GB / sec 5.4 GB / sec 5.5 GB / sec Full Rack Scan Throughput Qtr Rack Scan Throughput Full Rack OLTP Read IOPS Qtr Rack OLTP Read IOPS 100 GB / sec 180 GB / sec 301 GB / sec 350 GB / sec 22 TB / sec 30 GB / sec 64 GB / sec 75 GB / sec 2.8 M 4.1 M 5.6 M 5.97 M 570 K 1 M 1.1 M 1.2 M 35

36 Exadata Hardware Comparison of the Generations * V1 V2 X2 X3 X4 X5 X6 X7 2008/09 Xeon E5430 Harpertown 2009/09 Xeon E5540 Nehalem 2010/09 Xeon X5670 Westmere 2012/09 Xeon E Sandy Bridge 2013/11 Xeon E5-2697v2 Ivy Bridge 2014 / 12 Xeon E v3 Haswell 2016/04 Xeon E v4 Broadwell 2017/10 Xeon 8160 Skylake Growth V1 X7 Storage (TB) Flash (TB) CPU (Cores) Memory (GB) Ethernet (Gb / s) Scan Rate (GB / s ) Read IOPS (M) 10 X 64 X 6 X 48 X 100 X 25 X 120 X * Based on a full rack configuration with 8 DB servers and 14 storage servers 36

37 Exadata Hardware Comparison of the generations Capacity: standardized to Exadata X4-2 HC Full Rack X X6 Storage Flash CPU Cores Memory 200 X5 100 V1 V2 X2 X3 X

38 Exadata Hardware Comparison of the Generation Performance: Standardized to Exadata X4-2 HC Full Rack X7 300 X X5 Flash Bandwidth Flash IOPS 150 X4 CPU Performance CPU Cores 100 X3 50 V1 V2 X

39 Comparison Exadata X4-2 ER and Exadata X7-2 ER Hardware specification Exadata X4-2 Eighth HC Exadata X7-2 Eighth HC Improve Ratio DB Server x Number X4-2 x2 X7-2 x2 Per DB Server CPU model X7 1 socket! Max core Number times Memory 256GB (Upgrade to 512GB) 384GB (Upgrade to 768GB) 1.5 times Hard Disk 4x 600GB SAS2 4x 600GB SAS2 (Upgrade to 8x) 2 times RAID Card Cache Capacity 512MB 1024MB 2 times Network 4x 1 / 10G onboard 1x Dual 10GbE SFP + NIC 1x Dual QDR Infiniband HCA 2x 10 / 25G onboard 1x Dual 10 / 25GbE SFP + NIC 1x Dual QDR Infiniband HCA Storage Server x Number X4-2 HC x3 X7-2 HC x3 Per Storage Server CPU model core Number times Memory 96GB 192GB (Upgrade to 1536GB) 2 times Hard Disk 6x 6x 2x 150GB M times Flash 2x 800GB Flash Card 2x 6.4TB NVMe Flash Card 8 times Network 2x 1G onboard 2x 1G onboard 1x Dual QDR Infiniband HCA 1x Dual QDR Infiniband HCA 39

40 Comparison Exadata X4-2 QR and Exadata X7-2 ER Hardware specification Exadata X4-2 Quarter HC Exadata X7-2 Eighth HC Improve Ratio DB Server x Number X4-2 x2 X7-2 x2 Per DB Server CPU model X7 1 socket! Max core Number times Memory 256GB (Upgrade to 512GB) 384GB (Upgrade to 768GB) 1.5 times Hard Disk 4x 600GB SAS2 4x 600GB SAS2 (Upgrade to 8x) 2 times RAID Card Cache Capacity 512MB 1024MB 2 times Network 4x 1 / 10G onboard 1x Dual 10GbE SFP + NIC 1x Dual QDR Infiniband HCA 2x 10 / 25G onboard 1x Dual 10 / 25GbE SFP + NIC 1x Dual QDR Infiniband HCA Storage Server x Number X4-2 HC x3 X7-2 HC x3 Per Storage Server CPU model core Number times Memory 96GB 192GB (Upgrade to 1536GB) 2 times Hard Disk 12x 6x 2x 150GB M times Flash 4x 800GB Flash Card 2x 6.4TB NVMe Flash Card 4 times Network 2x 1G onboard 2x 1G onboard 1x Dual QDR Infiniband HCA 1x Dual QDR Infiniband HCA 40

41 Comparison of Exadata X4-2 ER and Exadata X7-2 ER Performance indicators X4-2 Eighth HC X7-2 Eighth HC Performance Ratio Disk Data Bandwidth HC 2.25 GB / s 2.7GB / s 1.2 times Flash Cache Data Bandwidth HC 10.7 GB / s 32GB / s 2.9 times Disk IOPS HC 3,500 3, times 8K Reads 285,, times Flash IOPS 8K Writes 210,, times Data Load Rate 2.5 TB / hr 2.5TB / hr 1.0 times Source: Datasheets 41

42 Comparison of Exadata X4-2 QR and Exadata X7-2 ER Performance indicators X4-2 Quarter HC X7-2 Eighth HC Performance Ratio Disk Data Bandwidth HC 4.5 GB / s 2.7GB / s 0.6 times Flash Cache Data Bandwidth HC 21.5 GB / s 32GB / s 1.5 times Disk IOPS HC 7,000 3, times 8K Reads 570,, 000 1 times Flash IOPS 8K Writes 420,, times Data Load Rate 5 TB / hr 2.5TB / hr 0.5 times Source: Datasheets 42

43 Exadata Database Machine X7-2 Quo vadis Eighth Rack? (1) Initial procurement of Eighth Rack for test and development environments Eighth Rack for production environments with clearly defined requirements (growth?) Quarter Rack (with CoD) for growing environments (2) Upgrade Eighth Rack Storage with Eighth Rack Storage Server X7-2 HC expand DB Server upgrade by installing a second CPU complex (new installation?) (3) Renewal Eighth Rack with Eighth Rack X7-2 (with CoD) replace Quarter Rack with Quarter Rack X7-2 (with CoD) NO downsizing! If necessary, check virtualization to optimize license costs 43

44 Exadata Database Machine Software Copyright 2018, Oracle and / or its affiliates. All rights reserved. 44

45 Exadata and Oracle Database 18c Extension of Tuning Advisor Execution Plan depending on I / O search times, I / O throughput and multiblock read count. If the statistics are not accurate, the Tuning Advisor recommends a SQL Profile ASM Improvements in data reliability Default for DISK_REPAIR_TIME increased from 3.6 to 12 hours New disk group attribute CONTENT_HARDCHECK.ENABLED for activating / deactivating HARD checks Patching the Exadata infrastructure (DB Server, Storage Server, IB Switches) via Rapid Home Provisioning Possibility of centralized monitoring via RHP Service Inventory Source: Oracle Database Release 18c New Features Guide 45

46 Exadata is relocating more and more operations to Flash Exadata DB Servers InfiniBand Query Offload Storage Arrays can share flash capacity due to the architecture, but not the performance. The bottleneck is not even with new technologies of the next generation, PCIe networks, or NVMe over fabric network! Approach: bring operations to the data in order to exploit flash potential! This is only possible if you control the entire stack - impossible to implement only in the storage. Exadata Smart Storage Exadata X7 delivers 350 GB / s flash bandwidth for each server Achieves 800 GB / s aggregated DRAM bandwidth of the DB server 46

47 Exadata software extensions More in-memory functionalities In-memory analytics in storage In-memory OLTP in storage In-memory columnar scans Up to 1.5 TB DRAM per server Automatic conversion of data in in-memory columnar format and up to 4x more performance in Exadata Flash Cache In-Flash Columnar Scans Up to 25.6 TB Flash per server Compute Server DRAM cache in storage delivers OLTP blocks 2.5x faster than Flash Cache Storage Server DB Blocks DRAM Cache (HOT) Flash Cache Disks 47

48 NEW: Automatic Storage Index Set Membership Storage Index avoids superfluous I / Os Currently contains up to 8 columns with min / max values ​​Automatically created and kept in main memory How do queries run on columns with low cardinality? select name, address from travels where origin = Sierra Leone and dest = CA Conventional min / max is not sufficient Database calculates statistics and determines fewer than 400 distinct values ​​Database requires calculation of Bloom Filter Storage calculates distinct values ​​and generates Bloom Filter Smart Scan Checks value CA against Bloom filter and avoids superfluous I / O Supports database and newer 48

49 NEW: Automatic Write Bursts and Temp IO in Flash Cache Write throughput of four flash cards is now greater than that of 12 hard disks Smart Flash Cache cached write operations if the write throughput exceeds the hard disk throughput If a query generates a lot of Temp I / O, the Smart Flash Cache the Temp I / O intelligently writing the temp overflow in Flash reduces execution time Reading temp from Flash further reduces execution time Smart Flash Cache prioritizes OLTP data and does not remove hot OLTP data from the cache Smart Flash wear management for large writes Supported Database and new Write Bursts and Temp IO in Flash Cache Improvement for large joins and sorts and high-volume load operations 49

50 NEW: Efficient Rebalance and Restore Flexibles set the power for rebalance ASM_POWER_LIMIT change dynamically ASM Rebalance first creates redundancy Reduce risk of second error in critical time window Monitoring with REBUILD phase in v $ asm_operation Exadata uses Flash Cache for rebalance reads Restoration of redundancy runs until 30% faster 50

51 NEW: Automated cloud scale software updates Automation of updates of the entire Exadata infrastructure SW of the entire fleet More than 600 components in the full rack storage server downloads new SW in the background (18.1 release or newer) User plans time slot for the SW update Storage server upgrade takes place automatically either rolling online or offline in parallel Oracle Cloud updates hundreds of racks in one weekend PARALLEL update tool FLEET UPDATES ROLLING Time requirement for server update is reduced 5x faster storage server update 40% faster database server update More parallelism, fewer reboots 51

52 Conclusion Copyright 2018, Oracle and / or its affiliates. All rights reserved. 52

53 Exadata Database Machine All database and Exadata innovations available Multitenant Offload SQL to Storage In-Memory DB InfiniBand Fabric Real Application Clusters Smart Flash Cache, Log PCI Flash Active Data Guard Partitioning Advanced Compression Advanced Security, Label Security, DB Vault Real Application Testing All Oracle Database Innovations All Exadata DB Machine Innovations Storage Indexes Columnar Flash Cache Hybrid Columnar Compression I / O Resource Management Network Resource Management 10: 1 HCC I / OI / OI / O Advanced Analytics, Spatial and Graph Management Packs for Oracle Database In-Memory Fault Tolerance Exafusion Direct-to-Wire Protocol 53

54 Uniform Exadata Deployment The choice is yours! On-Premises X7-2 X7-8 Cloud at Customer Public Cloud Service Customers Data Center Purchase Model Customer Manages Customers Data Center Rental Model Oracle Manages Oracle Cloud Rental Model Oracle Manages 54

55 Exadata Brief comparison of the alternatives Exadata On-Premises Cloud at Customer Cloud Service Commercial Licensing CAPEX: HW & SW (Processor = 2 cores) OPEX: Subscription (OCPU = 1 core), BYOL / UCM Ownership Customer Oracle Oracle Data Center Customer Customer Oracle OPEX: Subscription (OCPU = 1 core), BYOL / UCM Upgrades New purchase New subscription New subscription Min. Term None 4 years, less with fee 1 month DB, Exa Software License separately included, DB BYOL Included, DB BYOL Premier Support License separately Included Included Lifecycle Infra Updates Customer Oracle Oracle DB Updates Customer / Platinum Customer Customer Deploy Requirement Advanced Support Gateway reqd with Platinum Services OCC, Advanced Support Gateway Recommended: VPN, FastConnect, Compute Oracle Homes Shareable * One Home per DB One Home per DB Non- CDB Supported CDB-only in DB 12c CDB-only in DB 12c Exa Admin ExaCLI, CellCLI, EM Self-service UI Self-service UI Scale up Capacity on Demand Subscription, Bursting Add OCPUs / hr Elastic Expansion Supported Not yet * Not yet * Exadata On-Premises Cloud at Customer Cloud Service Hardware Processor 2-socket & 8-socket 2-socket 2-socket X7 Support Yes Yes Not yet * Storage Server HC, EF HC HC Default Memory 384 GB / server (X7) Base: 240 GB / server, Others: 720 GB / server X5: 240 GB / server X6: 720 GB / server Memory Expansion Up to 1.5 TB / server Not supported Not supported Configuration RAC / Single Instance * Configurations Sub-clusters & single instance 1/8, 1/4, ½, Full, Elastic RAC spans all nodes, no single instance Base, 1/4, 1/2, Full; Elastic in roadmap * RAC Node subsets & single instance possible 1/4, 1/2, Full; Elastic in roadmap * No. of Storage Servers ¼: 3, Half: 7, Full: 14 Base, ¼: 3, Half: 6, Full: 12 ¼: 3, Half: 6, Full: 12 ASM Redundancy Normal, High High High VM Bare Metal or VM VM, multi VM in roadmap * VM, multi VM in roadmap * Backup Customer backup infra, backup to cloud Customer backup infra, incl. Backup to cloud Database Backup Cloud Service Database Encryption Customer choice Encrypted by default Encrypted by default Network Isolation VLANs SDN in roadmap * SDN in roadmap * External IB connectivity Supported Not supported Not supported Re-racking / Addn Equip Allowed Not supported N / A * Cloud roadmap item 55

56 Exadata vs. Generic Hardware The utility gap is growing and will continue to grow! In-Memory Fault Tolerance Direct-to-wire Protocol JSON and XML offload Instant failure detection Network Resource Management Multitenant Aware Resource Mgmt IO Priorities Prioritized File Recovery Software-in-Data Mining Offload Silicon Offload Decrypt on Scans Tiered Disk / Flash Database Aware Flash Cache PCIe NVMe Flash Storage Indexes Unified InfiniBand Columnar Compression Smart Scan DB Processors in Storage InfiniBand Scale-Out Scale-Out Storage Scale-Out Servers Exadata Cloud at Customer In-Memory OLTP Acceleration In-Memory Columnar in Flash Exadata Cloud Service Smart Fusion Block Transfer Hot Swappable Flash 25 GigE Client Network 3D V-NAND Flash 56

57 57

58 Safe Harbor Statement The preceding 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. 58

59 59

60