Oracle Database Appliance Stand alone DB App server

Oracle Database Appliance Stand alone DB / App server & High availability solution Andrei Czompa ODA - Solution Consultant EMEA – OD Systems 28 th of July 2017 Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

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 © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

Agenda 1 Overview 2 Hardware S/M/L and HA 3 Software and Templates 4 Management

Typical Database Deployment Options Today Converged/ Hyperconverged Commodity Build Your Own: • Many choices, customizable • Multiple vendors • No unified management • No end-to-end support Not Optimized for Database • Generic workload consolidation • Integration stops at hypervisor • Multiple vendors Not Optimized for Database Engineered Systems • Fully integrated SW & HW • Engineered, purpose built for optimization, value • Appliances for simplicity • Single vendor • Public cloud integration Optimized for Database Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

Oracle Database Appliance X 6 -2 Hardware Single Node and Clustered Platform Choice 10 Gb. E Compute Node Infini. Band Compute Node SAS Compute Node Disk Array Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

1 Overview 2 Hardware S/M/L and HA 3 Software 4 Management 5 Q &

Oracle Database Appliance X 6 -2 S Entry Front View Component Details Database Single Instance SE/SE 1/SE 2 and EE Deployment Bare Metal with KVM integration CPU 1 x 10 -core 2. 2 GHz Intel Xeon E 5 -2630 V 4 Memory 128 GB (4 x 32 GB) Main Memory Expandable to 384 GB Storage 6. 4 TB (2 x 3. 2 TB) NVMe Expandable to 12. 8 TB raw Boot Disk 2 x 480 GB SSD (Mirrored) Ethernet 2 x 10 GBase-T Fiber 2 x 10 Gb. E SFP+ Back View Up to 2. 6 TB – 5. 2 TB usable database storage based on Normal redundancy Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

Oracle Database Appliance X 6 -2 M Performance Front View Component Details Database Single Instance SE/SE 1/SE 2 and EE Deployment Bare Metal with KVM integration CPU 2 x 10 -core 2. 2 GHz Intel Xeon E 5 -2630 V 4 Memory 256 GB (8 x 32 GB) Main Memory Expandable to 768 GB Storage 6. 4 TB (2 x 3. 2 TB) NVMe Expandable to 12. 8 TB Boot Disk 2 x 480 GB SSD (Mirrored) Ethernet 4 x 10 GBase-T Fiber 2 x 10 Gb. E SFP+ Back View Up to 2. 6 TB – 5. 2 TB usable database storage based on Normal redundancy Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

Oracle Database Appliance X 6 -2 L Consolidation Component Details Database Single Instance SE/SE 1/SE 2 and EE Deployment Bare Metal with KVM integration CPU 2 x 10 -core 2. 2 GHz Intel Xeon E 5 -2630 V 4 Memory 256 GB (8 x 32 GB) Main Memory Expandable to 768 GB Storage 19. 2 TB (6 x 3. 2 TB) NVMe Expandable to 28. 8 TB Boot Disk 2 x 480 GB SSD (Mirrored) Ethernet 4 x 10 GBase-T Fiber 2 x 10 Gb. E SFP+ Front View Back View Up to 6. 5 TB – 10. 4 TB usable database storage based on Normal redundancy Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

NVM Express Bandwidth Breakthrough Bandwidth to Each SSD Increased by 2. 6 x Conventional SSDs • Flash data is first transformed to SAS protocol • Bandwidth to each SSD limited by SAS-3 bandwidth NVM Express SSDs • Eliminates the protocol transformation to SAS • Interfaces with root complex over a four-lane PCIe Gen 3 interface Memory PCIe Gen 3 PCIe Root Complex PCIe SAS 12 Gb/sec SAS-3 Controller SAS-3 to Flash Controller Oracle’s x 86 Servers Memory PCIe Root Complex Flash Flash Standard SSD 32 Gb/sec PCIe Gen 3 PCIe to Flash Controller Oracle’s x 86 Servers Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public Flash Flash NVM Express SSD

KVM on ODA X 6 -2 S/X 6 -2 M/X 6 -2 L Does Oracle Linux include support for KVM? • Yes it does! KVM is a feature of Oracle Linux today. Please refer to My Oracle Support Doc ID 417770. 1. And more importantly, Oracle Linux Premier Support is included with Oracle Premier Support for Systems and Engineering Systems, such as ODA hardware support. • Oracle Database Appliance models X 6 -2 S/X 6 -2 M/X 6 -2 L are including the KVM libraries in the software stack that is deployed on ODA starting with release 12. 11. Available today on My Oracle Support. • In this initial role out of KVM on ODA, you will easily be able to startup the KVM service to create guest VMs to deploy applications. By deploying applications in a guest VM, you can run both databases and applications with isolation capabilities; essentially creating a Solution-in-a-Box with ODA platform. Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

Results Model ODA X 6 -2 M ODA X 6 -2 L Model ODA X 6 -2 S ODA X 6 -2 M ODA X 6 -2 L IOPS (8 K Block Size) Response Time (m. S) MPS (1 MB Block) Read (2 disks) 500 K 0. 2 6. 8 GB/sec Write (2 disks) 125 K 0. 5 1. 2 GB/sec Read (6 disks) 1. 4 M 0. 2 20 GB/sec Write (6 disks) 374 K 0. 5 3 GB/sec Configuration Average Transactions Per Second Average Response Time 4 cores : 3250 users 3400 2. 5 m. S 10 cores : 7400 users 7700 2. 8 m. S 4 cores : 3250 users 3400 2. 9 m. S 20 cores : 13500 users 14000 5. 8 m. S Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

Oracle Database Appliance X 6 -2 -HA High Availability Component Details Database RAC, RAC One, Single Instance EE Deployment Bare Metal or Virtualization System 2 x Servers, 1 x Storage Shelf Optional Second Storage Shelf CPU 4 x 10 -core 2. 2 GHz Intel Xeon E 5 -2630 V 4 Memory 512 GB (16 x 32 GB) Main Memory Expandable to 1. 5 TB ODA X 6 -2 -HA Storage Expansion Shelf Storage 800 GB SSD for Redo Logs, 12 TB SSD for Data Expandable to 24 TB SSD in Single Shelf Boot Disk 2 x 480 GB SSD (Mirrored) per server Interconnect Redundant Infini. Band or 10 GBase-T Interconnect Public Network 10 GBase-T and optional 10 Gb. E SFP+ Storage 800 GB SSD for Redo Logs 24 TB SSD for Data Up to 3. 9 TB – 17. 2 TB usable database storage based on Normal redundancy Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

Results Model ODA X 6 -2 -HA IOPS (8 K Block Size) Response Time (m. S) MPS (1 MB Block Size) Read (10 disks) 725 K 0. 8 7. 6 GB/sec Write (10 disks) 325 K 0. 8 3. 1 GB/sec Model Configuration Average Transactions Per Second Average Response Time ODA X 6— 2 -HA 4 cores : 4250 users 4456 4. 0 m. S 20 cores : 19000 users 19900 5. 9 m. S Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

ODA X 6 -2 -HA – Virtualized Platform Option • Partition cores to VMs to isolate workloads • Creation of shared repositories for VM and VDisk storage • High Availability of Guest VMs with automatic restart and failover • VDisk Management • Support VLANs to provide additional networks and security • Start/Stop VMs Node 1 Node 0 Guest Domain DOM 0 ODA_Base VM Storage • Oracle Database Repository • Grid Infrastructure • Clusterware • ASM • ACFS • Appliance Manager Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

Storage Architecture Configuration Oracle Database Appliance X 6 -2 S/X 6 -2 M/X 6 -2 L ASM Cluster File System (ACFS) data reco ASM Disk Groups • Tracks the layout, configuration and status of storage • Monitors the disks for hard and soft failures • Proactively off lines disks that: – Failed, predicted to fail, performing poorly +DATA, +RECO • Performs corrective actions if possible NVMe • These actions ensure highest level availability and performance at all times Oracle Database Appliance X 6 -2 -HA ASM Cluster File System (ACFS) data reco redo repo 1. . N ASM Disk Groups +DATA, +RECO, +REDO Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public SSDs Log SSDs

Shared Repository and VM High Availability Storage for VMs on Shared Disks • Shared Repository – Provides additional storage capacity for VMs – Enables VM auto restart and failover – Full OAKCLI integration to create and size VM Auto Restart • VM Auto Restart – Unplanned VM failure – Auto restarts VM on same node with no manual intervention Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

VDisk Additional Guest VM Storage Node-0 Guest VM VDisk-1 Node-1 ODA_BASE VDisk-2 Guest VM VDisk-3 ODA_BASE VM Template • Allows dynamic addition of storage to existing VM • Support for VM exclusive and shared VDISK • Full OAKCLI integration Shared Repository Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

ODA X 6 -2 S/X 6 -2 M/X 6 -2 L Network Details Supports Both 10 GBase-T and 10 Gb. E SFP+ Network Interfaces Type Interfaces Bonds 10 GBase-T em 1 em 2 btbond 1 em 3 em 4 P 2 p 1 p 2 p 2 priv 1 btbond 2 10 Gb. E SFP+ Priv / ILOM IP Addresses Not available on ODA X 6 -2 S sfpbond 1 priv 1 Private Interface 192. 168. 16. 24 Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

VLAN Support Provide Network Security Isolation for Multiple Workloads Sharing Common Network • Servers have finite number of networks – ODA X 6 -2 -HA has 2 bonded public network interfaces • When multiple networks are required, there needs to be a way to share the network interfaces provided • Support for VLANs enable the sharing of a common network interface, but still provide security isolation (cannot sniff packets of a different workload) – Application, backup, management networks • Requires a switch that supports tagged VLANs Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

1 Overview 2 Hardware 3 Software and Templates 4 Management 5 Q & A

Support of Both Oracle Database Editions • Enterprise Edition – 11. 2. 0. 4, 12. 1. 0. 2 – Supported on all ODA X 6 -2 models • Standard Edition (SE, SE 1, SE 2) – 11. 2. 0. 4, 12. 1. 0. 2 – Supported on ODA X 6 -2 S/X 6 -2 M/X 6 -2 L • Oracle SE, SE 1, SE 2 and EE database editions are the SAME software stack • Database Options only supported on EE – http: //docs. oracle. com/database/121/DBLIC/options. htm#CIHDDBCG – Advanced Security Option, In-Memory, Mutitenant, …. . Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

OLTP Database Templates Sized for Performance Database Class CPU Cores SGA (GB) PGA (GB) REDO Log File Size (GB) Odb-01 s 1 2 1 1 Odb-01 1 4 2 1 Odb-02 2 8 4 1 Odb-04 4 16 8 1 Odb-06 6 24 12 2 Odb-10 10 40 20 2 Odb-12 12 48 24 4 Odb-16 16 64 32 4 Odb-20 20 80 40 4 • Provides well defined database configuration templates … – Sizing for CPU and Memory • Out of the box allocation for SGA and PGA – Incorporates all best practice database init parameters – Advise on the storage characteristics – Multiple sizes to satisfy various workloads – Three REDO logs are created in appropriate disk group Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

Simplified Deployment Faster Time To Value Benefits • Download latest ODA software bundle • No need to install or configure the OS • Gather configuration info through a Wizard • No knowledge required to install Oracle Clusterware, RAC and Database • Deploys Oracle Database Appliance with Single Instance in 30 minute and with Oracle RAC in 90 minutes • Completely tested and validated by Oracle 1 Create ASR Create Cluster Configure Networking 2 Configure Storage 3 4 5 Create Database Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public Complete

Deployment and Management tools • ODA X 6 -2 S/X 6 -2 M/X 6 -2 L – ODACLI Command Line – Web Console • ODA X 6 -2 -HA – OAKCLI Command Line – GUI Configurator Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

Manage Performance with Integrated Qo. S Management • EM Cloud Control dashboard of all ODA database workloads – Easily monitor performance and health of ODA-hosted DB applications – Receive alerts and notifications of performance issues • Built-in autonomic ODA resource trade-off expert system – Optimizes ODA resource trade-offs between workloads to maintain SLAs – Provides action audit trail and performance history Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

Enterprise Manager Plug-In • Streamlined enterprise-grade monitoring – Centralized console to monitor multiple ODAs along with other data center assets using Enterprise Manager – New ODA target and system page to provide system view, status, etc. • Simple tag-based approach to create ODA groups • Aggregated component level analytics across ODA groups • Hierarchical viewer to show relationships • Full support for both Bare Metal and Virtualized Platform deployments • Full support for all ODA hardware versions Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public

Patching Patched with current Patchset, DB Bundle / PSU and all critical one-offs • No need to research the required patches -- From firmware to database • No need to test end-to-end inter-operability -- Oracle thoroughly tests the entire stack • No need to have the knowledge to patch the components -- Automated patching process does it for you Download Bundle Patch 1 Update OS, GI, ILOM, BIOS 2 3 Update software repository Update Database(s) 4 5 Update Firmware Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Public Complete