Deep-Dive into the Oracle Database Appliance Architecture

1 Copyright 2015, Oracle and/or its affiliates. All rights reserved. | Deep-Dive into the Oracle Database Appliance Architecture Tammy Bednar Oracle Database Appliance Product Development November 17, 2015 Oracle ConfidenJal Internal/Restricted/Highly Restricted @OracleODA @TammyBednar UserGroup-4348075/about Copyright 2015, Oracle and/or its affiliates. All rights reserved. | Safe Harbor Statement The following is intended to outline our general product direcJon. It is intended for informaJon purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or funcJonality, and should not be relied upon in making purchasing decisions. The development, release, and Jming of any features or funcJonality described for Oracle s products remains at the sole discreJon of Oracle . Oracle ConfidenJal Internal/Restricted/Highly Restricted 3 Copyright 2015, Oracle and/or its affiliates. All rights reserved.

2 | Program Agenda Oracle Database Appliance Overview ODA Technical Deep Dives (ODA Storage, Security, Monitoring, Patching, etc.) Q&A 1 2 3 Oracle ConfidenJal Internal/Restricted/Highly Restricted 4 Copyright 2015, Oracle and/or its affiliates. All rights reserved. | Oracle Database Appliance Engineered System opJmized to run the Oracle Database and Database -centric applicaJons Complete high availability Database soluJon in a single Appliance Simple to deploy and manage both databases and applicaJons to improve Jme to value and reduce operaJonal expense Reliable system to ensure Database and applicaJon availability Affordable Capacity on Demand (CoD) licensing to manage capital expense 5 Complete, Simple, Reliable, Affordable Copyright 2015, Oracle and/or its affiliates. All rights reserved. | Simple to Install, Manage, and Maintain Automated Deployment Automated Patching Zero-Admin Storage Integrated VM Management Single Vendor Support Copyright 2015, Oracle and/or its affiliates.

3 All rights reserved. | Two dual-socket Oracle Linux servers Redundant private interconnect Redundant public networks Double-mirroring or triple-mirroring storage redundancy Redundant hot-swappable power, cooling, and fans Oracle Database 12c & 11g R2 Enterprise EdiJon Real ApplicaJon Clusters RAC One Node Single Instance Oracle Grid Infrastructure AutomaJc Storage Management Oracle Clusterware Oracle Linux and Oracle VM Oracle Appliance Manager Reliable Hardware So@ware Highly Available Copyright 2015, Oracle and/or its affiliates. All rights reserved. | Affordable Manage CapEx using Capacity On-Demand 8 Build Your Own OpJon 1: License 72 Cores for An/cipated Growth Buy Oracle Database Appliance OpJon 2: License as You Grow and Save Significantly 72 Cores 60 Cores 48 Cores 36 Cores 24 Cores 12 Cores 6 Cores Year 1 Year 2 Year 3 Year 1 Year 2 Year 3 or Manage OpEx Saving 2000 Hours The Oracle Database Appliance simplifies Jme-consuming DBA tasks and saves: 828 hours in first year 637 hours each subsequent year Copyright 2015, Oracle and/or its affiliates.

4 All rights reserved. | Database PlaMorm Business criJcal databases OLTP and data warehouses Runs Oracle s high availability sojware suite including Oracle Real ApplicaJon Clusters Consolidated databases Supports MulJtenant and In-Memory Database opJons Test and development databases Quickly and efficiently provision Database snapshots ApplicaNon PlaMorm Integrated virtualizaJon supports hosJng all Jers on a single system SoluJon-in-a-Box automaJon and best pracJces for Oracle products Oracle E-Business Suite, JD Edwards, PeopleSoj Oracle WebLogic Server Oracle Enterprise Manager CerJfied with hundreds of ISV applicaJons Oracle Database Appliance Copyright 2015, Oracle and/or its affiliates. All rights reserved. | Oracle Database Appliance X5-2 2 x 1RU x86 Servers. Each Server Contains: 2 x 18-core GHz Intel Xeon Processors E5-2699 v3 256 GB Memory (8 x 32 GB), expandable up to 768 GB Mirrored 600 GB local storage Redundant InfiniBand Interconnect OpJonal 10 GBase-T or 10 GbE SFP+ Public Network 1 x 4RU Storage Shelf Direct-Arached: 800 GB raw SSD storage for redo logs TB raw SSD storage for Database cache, tablespaces, temporary files 128 TB raw HDD storage for data, archive logs, backups Support Storage Expansion Shelf Also Direct-Arached (double storage capacity and performance) Hardware SpecificaNons Copyright 2015, Oracle and/or its affiliates.

5 All rights reserved. | Technical Deep Dive Oracle Database Appliance X5-2 Enhancements ACFS IntegraJon Shared Flash Cache In-memory Fault Tolerant opJon Infiniband and Exafusion Security Enhancements Monitoring ODA Patching enhancements Rolling Upgrade Backup and Recovery Oracle ConfidenJal Internal/Restricted/Highly Restricted 11 Copyright 2015, Oracle and/or its affiliates. All rights reserved. | Storage Architecture Each Server Node 2x HBA In case of HBA failure MulJpath sojware transparently manages both paths for the Database Storage Shelf 2x IO Modules (Controllers) Each connects to all 24 disks to protect against failure Redundant HDDs and SSDs ASM stripes data across disks to protect against failure Node 0 HBA HBA HBA HBA IO Module Node 1 P0 P1 IO Module Slot 20 Slot 16 Slot 12 Slot 8 Slot 4 Slot 0 Slot 21 Slot 17 Slot 13 Slot 9 Slot 5 Slot 1 Slot 22 Slot 18 Slot 14 Slot 10 Slot 6 Slot 2 Slot 23 Slot 19 Slot 15 Slot 11 Slot 7 Slot 3 Copyright 2015, Oracle and/or its affiliates.

6 All rights reserved. | Provide an integrated volume manager and file system Stripe and mirror files across disks in a ASM Disk Group Online Rebalance ajer storage configuraJon changes Built on the Oracle instance Architecture I/O operaJons DO NOT go through the ASM instance! Manage storage as a cluster of shared Disk Groups Oracle ConfidenJal Internal/Restricted/Highly Restricted 13 ASM and ODA Operating System DiskGroups Oracle Database ASM File System & Volume Management Operating System Disks Logical Volume Manager File System Oracle Database Copyright 2015, Oracle and/or its affiliates. All rights reserved. | ASM Stripes & Mirror data across all disks Help realize full bandwidth and IOPS of all the disks Oracle ConfidenJal Internal/Restricted/Highly Restricted 14 Disk 1 Disk 2 Disk 3 Disk 4 Disk 5 Disk 6 Disk 7 DATA DG RECO DG File 1 File 2 File 3 File 4 ASM Cluster Pool of Storage Copyright 2015, Oracle and/or its affiliates.

7 All rights reserved. | ASM on ODA New disk group arribute: Possible values: data, recovery Disk Group Primary/Secondary allocaJon changes with Decreases likelihood that mulJple failures cause data loss across mulJple disk groups Content Type Copyright 2015, Oracle and/or its affiliates. All rights reserved. | Preserves all the benefits of ASM Adds Cluster Filesystem layer to provide Space efficient snapshots ReplicaJon Advanced security and encrypJon Database aware DirectIO support Fully integrated - Grid Infrastructure Supports Cached non- Database files Supports Sparse files Oracle ConfidenJal Internal/Restricted/Highly Restricted 16 ASM - ACFS Operating System DiskGroups Oracle Database ASM File System & Volume Management Operating System Disks Logical Volume Manager File System Oracle Database ACFS Copyright 2015, Oracle and/or its affiliates. All rights reserved. | ACFS ConfiguraJon for ODA StarJng version of Appliance Manager Database storage default is in ACFS AutomaJcally creates the proper filesystems for DATA, REDO, RECO and FLASH No space management or tuning to be done Auto extents the Filesystem as it grows Correctly tuned for Database usage Implements space efficient snapshots for the Database & Non CDB Database snapshots PDB Snapshots Oracle ConfidenJal Internal/Restricted/Highly Restricted 17 Copyright 2015, Oracle and/or its affiliates.

8 All rights reserved. | Oracle Database Appliance X5-2 Storage Architecture Disk Disk Group Volumes Used For HDD Outer Rings +DATA data Database data files HDD Outer Rings +DATA repoN Shared Repository for VMs, VDisk HDD Inner Rings +RECO reco Database archive logs, RMAN backups (Fast Recovery Area) HDD Inner Rings +RECO repoN Shared Repository for VMs, VDisk HDD Inner Rings +RECO cloudfs Clustered file system files that need to be accessed by either server node SSD +REDO redo Database redo logs SSD +FLASH flash Frequently accessed data ASM Disk Groups +DATA, +RECO, +REDO, +FLASH ASM Cluster File System (ACFS) data reco redo HDDs Log SSDs Cache SSDs flash Out of the box configuraNon Copyright 2015, Oracle and/or its affiliates. All rights reserved. | Appliance Manager Deployment ACFS Filesystems are created with 50% available storage in DATA,REDO,RECO Diskgroups AutomaJcally extends with Database growth For each Database following directory structures are created for Oracle ConfidenJal Internal/Restricted/Highly Restricted 19 Non CDB Database Structure ASM Disk Group ACFS File System +DATA (Datafiles) /u02/app/ Oracle /oradata/datastore/.

9 ACFS/snaps/<db unique name> +RECO (backup/archivelog) /u01/app/ Oracle /fast_recovery_area/< db unique name > +REDO(online redo logs) /u01/app/ Oracle /oradata/datastore/< db unique name > +FLASH(shared flash cache) /u01/app/ Oracle /oradata/datastore/< db unique name > Copyright 2015, Oracle and/or its affiliates. All rights reserved. | Appliance Manager Deployment For each CDB an ACFS Filesystem is created in DATA,REDO,RECO, FLASH Diskgroups All PDB s and it s snapshots are contained in same Filesystem CDB directory structure Oracle ConfidenJal Internal/Restricted/Highly Restricted 20 CDB Database Structure ASM Disk Group ACFS File System +DATA (Datafiles) /u02/app/ Oracle /oradata/<db unique name> +RECO (backup/archivelog) /u01/app/ Oracle /fast_recovery_area/< db unique name > +REDO(online redo logs) /u01/app/ Oracle /oradata/datastore/< db unique name > +FLASH(shared flash cache) /u01/app/ Oracle /oradata/datastore/< db unique name > Copyright 2015, Oracle and/or its affiliates.

10 All rights reserved. | ODA Shared Flash ODA Flash Cache Flash Cache shared across nodes Increases cache hit rate for your applicaJons Up to 6x faster than no cache ODA OLTP Database will automaJcally configure Shared Flash cache 4x the size of SGA Oracle ConfidenJal Internal/Restricted/Highly Restricted 21 Improves Read IO performance No Cache Local Cache ODA Flash Cache Access Time Copyright 2015, Oracle and/or its affiliates. All rights reserved. | Oracle Database In-Memory OpJon Real Time AnalyJcs Which: Products with high margin Who: Top 10 sales persons What if: Give 10% discount In same Database OLTP & AnalyJcs TransacJonally consistent OLTP data in row format AnalyJcs in-memory column format No ApplicaJon change and Easy to Implement Init Param: inmemory_size = XXX GB Alter table ! ParJJon <tab_name> inmemory; Drop analyJc indexes Benefits Copyright 2015, Oracle and/or its affiliates. All rights reserved.