Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Oracle Cloud Infrastructure 上で利用可能なOracle Databaseのサービスの比較

Oracle Cloud Infrastructure 上で利用可能なOracle Databaseのサービスの比較

Oracle Cloud Infrastructure 上で利用可能なOracle Databaseのサービスの比較
最終更新 2021/02
Oracle Database / OCI / DBCS / ExaCS / Autonomous Database / ADB / ADW / ATP

2019/3/29(金)「Oracle Technology Night 日本データセンター開設前に知っておくべきこと ~ Oracle Databaseのサービス比較編 ~」の内容を更新したものになります。
最新情報は、マニュアル等をご確認の上ご利用ください。

3115a782126be714b5f94d24073c957d?s=128

oracle4engineer

June 23, 2020
Tweet

Transcript

  1. Oracle Cloud Infrastructure Database Services Oracle Database OCI DB 2021

    2
  2. Safe harbor statement Copyright © 2021, Oracle and/or its affiliates

    2
  3. Copyright © 2021, Oracle and/or its affiliates 3

  4. Oracle Database – Most Manual Most Autonomous Database Exadata Database

    IaaS Database Autonomous Database Database Cloud Service - BM/VM Exadata Cloud Service /Exadata Cloud at Customer Oracle Cloud Infrastructure On Premise Copyright © 2021, Oracle and/or its affiliates 4
  5. 1 RAC Exadata Oracle Cloud Infrastructure : Database Database Cloud

    Service(DBCS) – BM Exadata Cloud Service (ExaCS) Autonomous Database (ADB) • (VM) • 4 Oracle Real Application Clusters(RAC) • • • 4 • • Exadata • 3 Enterprise Edition • Oracle Database • Exadata • DWH Autonomous Data Warehouse OLTP Autonomous Transaction Processing 2 Database Cloud Service (DBCS) – VM Copyright © 2021, Oracle and/or its affiliates 5
  6. Q: Q: Q: → • Full-Managed or User-Managed? • OS

    OS/DB or ? → • → CPU Storage DB → DB → CPU Storage DB DB or or → DB DB → Object Storage Exadata → Copyright © 2021, Oracle and/or its affiliates 6
  7. None
  8. Oracle Database Database Autonomous Database Virtual Machines Bare Metal Exadata

    Shared Dedicated User-Managed User-Managed User-Managed Full-Managed Full-Managed Standard Edition Enterprise Edition High Performance Extreme Performance Standard Edition Enterprise Edition High Performance Extreme Performance Extreme Performance N/A N/A DB 11.2/12.1/12.2/ 18/19/21 11.2/12.1/12.2/ 18/19/21 11.2/12.1/12.2/18/19 19 19 H/W X7 X7 Exadata X7/X8/X8M Exadata Exadata X7/X8 OCPU + Storage OCPU + Infrastructure OCPU + Infrastructure OCPU + Storage OCPU + Infrastructure OCPU/Storage:1 OCPU/Storage:1 OCPU:1 Infrastructure:48 OCPU/Storage:1 OCPU:1 Infrastructure:48 Copyright © 2021, Oracle and/or its affiliates 8
  9. • OCI Database • OCI Database(VM/BM) Extreme Performance OCI Exadata

    • Autonomous Database(ADW/ATP) xx → Copyright © 2021, Oracle and/or its affiliates 9
  10. Oracle Database Database Autonomous Database Virtual Machines Bare Metal Exadata

    Shared Dedicated User-Managed User-Managed User-Managed Full-Managed Full-Managed Standard Edition Enterprise Edition High Performance Extreme Performance Standard Edition Enterprise Edition High Performance Extreme Performance Extreme Performance N/A N/A DB 11.2/12.1/12.2/ 18/19/21 11.2/12.1/12.2/ 18/19/21 11.2/12.1/12.2/18/19 19 19 H/W X7 X7 Exadata X7/X8/X8M Exadata Exadata X7/X8 OCPU + Storage OCPU + Infrastructure OCPU + Infrastructure OCPU + Storage OCPU + Infrastructure OCPU/Storage:1 OCPU/Storage:1 OCPU:1 Infrastructure:48 OCPU/Storage:1 OCPU:1 Infrastructure:48 Copyright © 2021, Oracle and/or its affiliates 10
  11. DB-SE Exadata DB-HP Autonomous Database DB-EE DB EP Advanced Security

    Label Security Database Vault OLAP Bare Metal VM Exadata Infiniband Offload SQL to Storage Smart Flash Cache/log Storage Index IORM/Network RM In-Memory Fault -Tolerance ExaFusion Columnar Flash Cache Real Application Clusters EP Active Data Guard Database In-Memory Advanced Analytics Spatial & Graph Database Lifecycle Management Pack Cloud Management Pack for Oracle Database Bare Metal VM Bare Metal VM Bare Metal VM HP Multitenant Partitioning Advanced Compression EE Oracle Database Enterprise Edition, Data Masking and Subsetting Pack , Diagnostics and Tuning Packs , Real Application Testing SE Oracle Database Standard Edition 2, Transparent Data Encryption Advanced Security, Label Security, Database Vault OLAP Database Lifecycle Management Pack Cloud Management Pack for Oracle Database Copyright © 2021, Oracle and/or its affiliates 11
  12. DB-SE Exadata DB-HP Autonomous Database DB-EE DB EP Advanced Security

    Label Security Database Vault OLAP Bare Metal VM Exadata Infiniband Offload SQL to Storage Smart Flash Cache/log Storage Index IORM/Network RM In-Memory Fault -Tolerance ExaFusion Columnar Flash Cache Real Application Clusters EP Active Data Guard Database In-Memory Advanced Analytics Spatial & Graph Database Lifecycle Management Pack Cloud Management Pack for Oracle Database Bare Metal VM Bare Metal VM Bare Metal VM HP Multitenant Partitioning Advanced Compression EE Oracle Database Enterprise Edition, Data Masking and Subsetting Pack , Diagnostics and Tuning Packs , Real Application Testing SE Oracle Database Standard Edition 2, Transparent Data Encryption Advanced Security, Label Security, Database Vault OLAP Database Lifecycle Management Pack Cloud Management Pack for Oracle Database Real Application Clusters Database VM(EP)/Exadata/Autonomous DB Exadata/Autonomous DB Exdata CPU Copyright © 2021, Oracle and/or its affiliates 12
  13. Database Cloud Service : (BYOL to PaaS ) Extreme Performance

    High Performance Enterprise Edition Multitenant Partitioning Advanced Compression Advanced Security, Label Security, Database Vault Real Application Clusters DB In-Memory Active Data Guard • • Standard Edition • EE - Data Guard - Hybrid Columnar Compression(HCC) - etc Real Application Testing OLAP Management Packs (Data Masking and Subsetting Pack, Diagnostics and Tuning Packs) Oracle Database Cloud Management Packs (Database Lifecycle Management Pack, Cloud Management Pack for Oracle Database) ¥26/h ¥107/h ¥52/h ¥162/h * : CPU /Annual Flex / Copyright © 2021, Oracle and/or its affiliates 13
  14. Exadata Cloud Service: Extreme Performance Extreme Performance High Performance Enterprise

    Edition Multitenant Partitioning Advanced Compression Advanced Security, Label Security, Database Vault Real Application Clusters DB In-Memory Active Data Guard • • Standard Edition • EE - Data Guard - Hybrid Columnar Compression(HCC) - etc Real Application Testing OLAP Management Packs (Data Masking and Subsetting Pack, Diagnostics and Tuning Packs) Oracle Database Cloud Management Packs (Database Lifecycle Management Pack, Cloud Management Pack for Oracle Database) ¥26/h ¥107/h ¥52/h ¥162/h * : CPU /Annual Flex / Copyright © 2021, Oracle and/or its affiliates 14
  15. • Database Licensing Information User Manual - Licensing Information •

    Using Oracle Autonomous Data Warehouse - Restrictions for Database Features • Using Oracle Autonomous Transaction Processing - Restrictions for Database Features Autonomous Database : • Oracle Real Application Testing • Oracle OLAP • Oracle R capabilities of Oracle Advanced Analytics • Oracle Industry Data Models • Oracle Tuning Pack • Oracle Database Lifecycle Management Pack • Oracle Data Masking and Subsetting Pack • Oracle Cloud Management Pack for Oracle Database • Oracle Multimedia • Java in DB • Oracle Workspace Manager ※2020/06 Copyright © 2021, Oracle and/or its affiliates 15
  16. Oracle Database 30 / Database Standard Edition2 Enterprise Edition RAC

    Option Partitioning Option Standard Edition Enterprise Edition * Annual Flex https://cloud.oracle.com/ja_JP/database/pricing Enterprise Edition High Performance Enterprise Edition Extreme Performance Oracle Database Transparent Data Encryption • Oracle Database Standard Edition 2 • Oracle Database Enterprise Edition • Data Masking and Subsetting Pack • Diagnostics and Tuning Packs • Real Application Testing Enterprise Edition • Multitenant • Partitioning • Advanced Compression • Advanced Security • Label Security • Database Vault • OLAP • Database Lifecycle Management Pack • Cloud Management Pack for Oracle Database High Performance • RAC • In-Memory Database • Active Data Guard ¥25.80/OCPU/ ¥51.612/OCPU/ ¥106.452/OCPU/ ¥161.292/OCPU/ BYOL to PaaS ¥23.224/OCPU/ • Exadata Cloud Service • Autonomous Database (ADW, ATP, AJD) Copyright © 2021, Oracle and/or its affiliates 16
  17. 40 YEARS OF ORACLE DATABASE INOVATIONS Oracle Database + Oracle

    Exadata + Oracle Autonomous Database Scalability Raw Level Locking, Read Consistency, PX, Real Application Clusters, Automatic Storage Management, Advanced Compression, In- Memory Column Store, Database Sharding Smart Flash Cache Technologies, InfiniBand Fabric, Exafusion Direct-to-Wire Protocol, Smart Fusion Block Transfer, In-Memory OLTP Acceleration, Remote Direct Memory Access Online Scaling → Auto-Scaling Automatic Indexing Availability Transactions, Referential Integrity, Recovery Manager, Clusterware, Active Data Guard, Online Redefinition, Application Continuity In-Memory Fault Tolerance, Prioritized File Recovery, Instant Failure Detection, HARD, Hot Swappable Flash, Appliance mode Auto Configuration (RAC & Data Guard) Automated Backup, Restore Automatically Failure Detection Analytics Partitioning, Analytic Functions, Parallel SQL, Optimizer, Data Mining and Native R, SPM Transparent Materialized Views, Result Cache Offload SQL to Storage(Smart Scan, Data mining), Storage Indexes, In-Memory Columnar Flash Cache, Hybrid Columnar Compression Automated SQL Plan Management Security Privileges and Roles, Auditing and Audit Vault, Data Encryption, Data Masking, Database Vault and Key Vault, Real Application Security Offload Decrypt on Scans, FIPS 140-2 certification, PCI-DSS compliant, Encryption via hardware, Live Kernel patching Clustered Networking Automatically all Data Encryption Automatically applies security updates online Developers SQL, PL/SQL, Triggers, LOBs, Application Express, SQL Developer, Spatial and Graph, JSON, REST… Exadata Snapshot Notebook, Rest API, Schema Advisor Management V$Views and Wait Events, Enterprise Manager, SQL Monitor, Diagnostics and Tuning, Real Application Testing, Multitenant Database I/O Resource Management, Network Resource Management, Exachk full stack health check with critical issues alerts Automatically upgrades & patches online Automatic Statistics Management Remove Admin Privileges (Lockdown profile) Integration DB Links, XA Transactions, Direct Load, External Tables, Data Pump, GoldenGate, Big Data SQL JSON and XML offload DBMS_CLOUD Package Copyright © 2021, Oracle and/or its affiliates 17
  18. ADW ATP (Columnar) (Row) I/O RDMA I/O IT :ADW ATP

    Copyright © 2021, Oracle and/or its affiliates 18
  19. None
  20. Oracle Database : / Database Autonomous Database Virtual Machines Bare

    Metal Exadata Shared Dedicated Compute 1 (RAC :2) 1 2 – 32 - - OCPU 1 – 24 (RAC : 4-48) 2 – 52 (SE :2-8) 4 – 1600 1- 128 (※128 ) 1 – 400 Memory 15GB – 320GB ( ) 768GB 720GB – 44480GB OCPU OCPU Storage 712GB – 50 TB (Block Storage: ) 51.2TB (Local NVMe: ) 74.6TB – 3.1PB (Local Storage: ) 1 TB – 128TB 1 TB – 598 TB 256GB – 40 TB 4.6TB/9TB 8TB/16TB 26.2TB – 2.5PB 1 TB – 128TB 1 TB – 598 TB 1-25GbE ( ) 2x25GbE 2x25 GbE - - ( ) OCPU/Memory: Storage: OCPU: Memory/Storage: OCPU: Memory/Storage: OCPU/Storage : Memory: OCPU OCPU/Storage : Memory: OCPU Copyright © 2021, Oracle and/or its affiliates 20
  21. Block Storage • - 1 ( ) 2 (RAC )

    - 1 ◦ 12c CDB ( 1PDB on CDB) ◦ CDB PDB ◦ - Oracle Grid Infrastructure ◦ /RAC ◦ GI • - NVMe (Block Storage) - DB Oracle Automatic Storage Management(ASM) ◦ Block Volume ◦ ASM LVM Database Cloud Service – Virtual Machine DB VM Compute S/W (Remote NVMe) Block Volume Database System ( ) Clusterware Database DATA RECO ASM Object Storage DB VM Compute S/W (Remote NVMe) VM Compute S/W (Remote NVMe) Database System RAC Clusterware Database DATA RECO ASM Block Volume Object Storage Copyright © 2021, Oracle and/or its affiliates 21
  22. • - ( ) - Oracle Grid Infrastructure - ◦

    12c CDB ( 1PDB on CDB) ◦ CDB PDB ◦ • - Local NVMe ( ) - DB Oracle Automatic Storage Management(ASM) ◦ / DATA/RECO Database Cloud Service – Bare Metal Database System DB (Local NVMe) BM Compute Clusterware Database Database … DATA RECO ASM Object Storage Copyright © 2021, Oracle and/or its affiliates 22
  23. Exadata Infrastructure Exadata VM Exadata Cloud Service … … クライアント・ネットワーク

    バックアップ・ネットワーク DATA RECO SPARSE ASM Database Servers Storage Servers VM VM VM Clusterware dom0 または KVM host* ExaCS Database Home Database dom0 または KVM host* dom0 または KVM host* • • • * X8M KVM KVM host X8/X7/Base System Xen dom0 Copyright © 2021, Oracle and/or its affiliates 23
  24. VM ( ) Exadata Cloud Service ) OCI Documentation Exadata

    Cloud Service > Creating an Exadata Cloud Service Instance … … クライアント・ネットワーク バックアップ・ネットワーク DATA RECO SPARSE ASM 2 32 x Database Servers 3 64 x Storage Servers VM VM VM Clusterware dom0 または KVM host Database Home Database dom0 または KVM host dom0 または KVM host • • • • • • • • • • • • • • Copyright © 2021, Oracle and/or its affiliates 24
  25. Exadata Cloud Service 構成 DATA Disk Group RECO Disk Group

    SPARSE Disk Group Exadata ストレージ上のDBバックアップ :なし SPARSE ディスク・グループ : なし 80% 20% - Exadata ストレージ上のDBバックアップ :あり SPARSE ディスク・グループ : なし 40% 60% - Exadata ストレージ上のDBバックアップ :なし SPARSE ディスク・グループ : あり 60% 20% 20% Exadata ストレージ上のDBバックアップ :あり SPARSE ディスク・グループ : あり 35% 50% 15% ) OCI Documentation Exadata Cloud Service > Storage Configuration … … クライアント・ネットワーク バックアップ・ネットワーク DATA RECO SPARSE ASM 2 32 x Database Servers 3 64 x Storage Servers VM VM VM Clusterware dom0 または KVM host Database Home Database dom0 または KVM host dom0 または KVM host • • • • • • • Copyright © 2021, Oracle and/or its affiliates 25
  26. Oracle Database : / Database Autonomous Database Virtual Machines Bare

    Metal Exadata Shared Dedicated Compute 1 (RAC :2) 1 2 – 32 - - OCPU 1 – 24 (RAC : 4-48) 2 – 52 (SE :2-8) 4 – 1600 1- 128 (※128 ) 1 – 400 Memory 15GB – 320GB ( ) 768GB 720GB – 44480GB OCPU OCPU Storage 712GB – 50 TB (Block Storage: ) 51.2TB (Local NVMe: ) 74.6TB – 3.1PB (Local Storage: ) 1 TB – 128TB 1 TB – 598 TB 256GB – 40 TB 4.6TB/9TB 8TB/16TB 26.2TB – 2.5PB 1 TB – 128TB 1 TB – 598 TB 1-25GbE ( ) 2x25GbE 2x25 GbE - - ( ) OCPU/Memory: Storage: OCPU: Memory/Storage: OCPU: Memory/Storage: OCPU/Storage : Memory: OCPU OCPU/Storage : Memory: OCPU Copyright © 2021, Oracle and/or its affiliates 26
  27. • xxGB / • • Block Storage/Object Storage → Copyright

    © 2021, Oracle and/or its affiliates 27
  28. • ≠ DB ≠ - : - DB : (SYSTEM/SYSAUX/TEMP

    ) ( ) - : ASM (DBCS- BM ExaCS) • - ( ) RMAN - RMAN RECO (DATA) OS S/W (RECO) Compute Local Storage Remote Storage Copyright © 2021, Oracle and/or its affiliates 28
  29. Database Cloud Service : OCI Database – VM Compute Block

    Storage or Real Application Clusters(RAC) DB - CDB PDB (※ EE-High Performance ) Automatic Storage Management(ASM) Block Volume OCI Database – BM DB - CDB PDB (※ EE-High Perfomance ) Automatic Storage Management(ASM) ASM / Database System DB (Local NVMe) BM Compute Clusterware Database Database … DATA RECO ASM Object Storage DB VM Compute S/W (Remote NVMe) Block Volume Database System ( ) Clusterware Database DATA RECO ASM Object Storage DB VM Compute S/W (Remote NVMe) VM Compute S/W (Remote NVMe) Database System RAC Clusterware Database DATA RECO ASM Block Volume Object Storage Copyright © 2021, Oracle and/or its affiliates 29
  30. Database Cloud Service : OCI Database – VM Compute Block

    Storage or Real Application Clusters(RAC) DB - CDB PDB (※ EE-High Performance ) Automatic Storage Management(ASM) Block Volume OCI Database – BM DB - CDB PDB (※ EE-High Perfomance ) Automatic Storage Management(ASM) ASM / Database System DB (Local NVMe) BM Compute Clusterware Database Database … DATA RECO ASM Object Storage DB VM Compute S/W (Remote NVMe) Block Volume Database System ( ) Clusterware Database DATA RECO ASM Object Storage DB VM Compute S/W (Remote NVMe) VM Compute S/W (Remote NVMe) Database System RAC Clusterware Database DATA RECO ASM Block Volume Object Storage Oracle Cloud Infrastructure - Database Dense I/O - X7 Oracle Cloud Infrastructure – Object Storage Oracle Cloud Infrastructure - Database Cloud Service Oracle Cloud Infrastructure - Database Additional Capacity Oracle Cloud Infrastructure - Block Volume Oracle Cloud Infrastructure – Object Storage Oracle Cloud Infrastructure - Database Cloud Service Oracle Cloud Infrastructure - Block Volume Oracle Cloud Infrastructure – Object Storage - Storage PaaS SKU IaaS SKU Copyright © 2021, Oracle and/or its affiliates 30
  31. • • CPU (2 52 OCPU) • 2 VM RAC

    Database Cloud Service : Type Shape OCPU Memory Storage Network Bare Metal BM.DenseIO2.52 2 - 52 768 GB 51.2 TB NVMe 2 x 25 GbE Virtual Machine VM.Standard.2.1 1 15 GB Block Storage (-40TB) 1 GbE VM.Standard.2.2 2 30 GB Block Storage (-40TB) 2 GbE VM.Standard.2.4 4 60 GB Block Storage (-40TB) 4 GbE VM.Standard.2.8 8 120 GB Block Storage (-40TB) 8 GbE VM.Standard.2.8 16 240 GB Block Storage (-40TB) 16 GbE VM.Standard.2.8 24 320 GB Block Storage (-40TB) 25 GbE https://docs.us-phoenix-1.oraclecloud.com/Content/Database/Concepts/overview.htm ≠ Copyright © 2021, Oracle and/or its affiliates 31
  32. • • CPU (2 52 OCPU) • 2 VM RAC

    Database Cloud Service : Type Shape OCPU Memory Storage Network Bare Metal BM.DenseIO2.52 2 - 52 768 GB 51.2 TB NVMe 2 x 25 GbE Virtual Machine VM.Standard.2.1 1 15 GB Block Storage (-40TB) 1 GbE VM.Standard.2.2 2 30 GB Block Storage (-40TB) 2 GbE VM.Standard.2.4 4 60 GB Block Storage (-40TB) 4 GbE VM.Standard.2.8 8 120 GB Block Storage (-40TB) 8 GbE VM.Standard.2.8 16 240 GB Block Storage (-40TB) 16 GbE VM.Standard.2.8 24 320 GB Block Storage (-40TB) 25 GbE https://docs.us-phoenix-1.oraclecloud.com/Content/Database/Concepts/overview.htm Copyright © 2021, Oracle and/or its affiliates 32
  33. • (GB) • DATA (DATA ) • DATA (DATA(GB) )

    RECO (RECO(GB) ) → Block Volume (Total(GB) )= (Block Volume) Database Cloud Service – Virtual Machines DATA RECO S/W DATA TOTAL DATA (GB) RECO (GB) S/W (GB) Total (GB) 256 256 200 712 512 256 200 968 1,024 256 200 1,480 2,048 408 200 2,656 4,096 820 200 5,116 …. 38,912 7,784 200 46,896 40,960 8,192 200 49,352 Copyright © 2021, Oracle and/or its affiliates 33
  34. (Block Volume) – Database Cloud Service – Virtual Machines DATA

    (GB) RECO (GB) S/W (GB) Total (GB) 256 256 200 712 512 256 200 968 1,024 256 200 1,480 2,048 408 200 2,656 4,096 820 200 5,116 6,144 1,228 200 7,572 8,192 1,640 200 10,032 10,240 2,048 200 12,488 12,288 2,456 200 14,944 14,336 2,868 200 17,404 16,384 3,276 200 19,860 DATA (GB) RECO (GB) S/W (GB) Total (GB) 18,432 3,688 200 22,320 20,480 4,096 200 24,776 22,528 4,504 200 27,232 24,576 4,916 200 29,692 26,624 5,324 200 32,148 28,672 5,736 200 34,608 30,720 6,144 200 37,064 32,768 6,552 200 39,520 34,816 6,964 200 41,980 36,864 7,372 200 44,436 38,912 7,784 200 46,896 40,960 8,192 200 49,352 ) OCI Database Virtual Machine DB Systems • (GB) DATA (DATA ) • DATA (DATA(GB) ) RECO (RECO(GB) ) → Block Volume (Total(GB) )= Copyright © 2021, Oracle and/or its affiliates 34
  35. (Block Volume) – RAC Database Cloud Service – Virtual Machines

    DATA (GB) RECO (GB) S/W (GB) Total (GB) 256 256 200*2 912 512 256 200*2 1,168 1,024 256 200*2 1,680 2,048 408 200*2 2,856 4,096 820 200*2 5,316 6,144 1,228 200*2 7,772 8,192 1,640 200*2 10,232 10,240 2,048 200*2 12,688 12,288 2,456 200*2 15,144 14,336 2,868 200*2 17,604 16,384 3,276 200*2 20,060 DATA (GB) RECO (GB) S/W (GB) Total (GB) 18,432 3,688 200*2 22,520 20,480 4,096 200*2 24,976 22,528 4,504 200*2 27,432 24,576 4,916 200*2 29,892 26,624 5,324 200*2 32,348 28,672 5,736 200*2 34,808 30,720 6,144 200*2 37,264 32,768 6,552 200*2 39,720 34,816 6,964 200*2 42,180 36,864 7,372 200*2 44,636 38,912 7,784 200*2 47,096 40,960 8,192 200*2 49,552 ) OCI Database Virtual Machine DB Systems • (GB) DATA (DATA ) • DATA (DATA(GB) ) RECO (RECO(GB) ) → Block Volume (Total(GB) )= • RAC S/W Copyright © 2021, Oracle and/or its affiliates 35
  36. (Block Volume) – Database Cloud Service – Virtual Machines )

    OCI Database Virtual Machine DB Systems DATA(GB) RECO (GB) S/W (GB) Total (GB) Total Disk Size *Num Total Disk Size *Num 256 64*4 256 64*4 200 712 512 128*4 256 64*4 200 968 1,024 256*4 256 64*4 200 1,480 2,048 512*4 408 102*4 200 2,656 4,096 1,024*4 820 205*4 200 5,116 6,144 1,536*4 1,228 307*4 200 7,572 8,192 2,048*4 1,640 410*4 200 10,032 10,240 2,048*5 2,048 512*4 200 12,488 12,288 2,048*6 2,456 614*4 200 14,944 14,336 2,048*7 2,868 717*4 200 17,404 16,384 2,048*8 3,276 819*4 200 19,860 DATA(GB) RECO (GB) S/W (GB) Total (GB) Total Disk Size *Num Total Disk Size *Num 18,432 2,048*9 3,688 922*4 200 22,320 20,480 2,048*10 4,096 1,024*4 200 24,776 22,528 2,048*11 4,504 1,126*4 200 27,232 24,576 2,048*12 4,916 1,229*4 200 29,692 26,624 2,048*13 5,324 1,331*4 200 32,148 28,672 2,048*14 5,736 1,434*4 200 34,608 30,720 2,048*15 6,144 1,536*4 200 37,064 32,768 2,048*16 6,552 1,638*4 200 39,520 34,816 2,048*17 6,964 1,741*4 200 41,980 36,864 2,048*18 7,372 1,834*4 200 44,436 38,912 2,048*19 7,784 1,946*4 200 46,896 40,960 2,048*20 8,192 2,048*4 200 49,352 Copyright © 2021, Oracle and/or its affiliates 36
  37. Database Cloud Service – Virtual Machines / OS files 35GB

    swap Swap space /boot OS Kernel 1.4GB /u01 Oracle Database software 197GB Disk Group DATA RECO DATA (※ ) Copyright © 2021, Oracle and/or its affiliates 37
  38. • OCPU • 1 OCPU - Shared Infrastructure : 1

    128 OCPU - Dedicated Infrastructure : 1 400TB • • 1TB - Shared Infrastructure : 1 128TB - Dedicated Infrastructure: 1 598 TB(1) • - - ( ) - - Object Storage Autonomous Database (DATA) OS S/W (RECO) Compute Local Storage Remote Storage Exadata Storage Copyright © 2021, Oracle and/or its affiliates 38
  39. 51.2TB • Automatic Storage Management(ASM) - ◦ DATA RECO ◦

    (High( )or Normal( )) DATA (80% or 40%) - Block Volume Database Cloud Service – Bare Metal DATA % Disk Group ( ) ( ) BM.DenseIO2.52 51.2 TB 80% ( ) DATA 16 TB 9 TB RECO 4 TB 2.3 TB 40% DATA 8 TB 4.6 TB RECO 12 TB 6.9 TB BM ※ Copyright © 2021, Oracle and/or its affiliates 39
  40. 51.2TB • Automatic Storage Management(ASM) - ◦ DATA RECO ◦

    (High( )or Normal( )) DATA (80% or 40%) - Block Volume Database Cloud Service – Bare Metal DATA % Disk Group ( ) ( ) BM.DenseIO2.52 51.2 TB 80% ( ) DATA 16 TB 9 TB RECO 4 TB 2.3 TB 40% DATA 8 TB 4.6 TB RECO 12 TB 6.9 TB BM ※ Copyright © 2021, Oracle and/or its affiliates 40
  41. • OCI Database-BM Exadata Cloud ( ) • RECO (FRA

    ) DATA ( ) - RECO FRA ( ) (REDO ) ◦ FRA ◦ REDO - → RECO = DATA Copyright © 2021, Oracle and/or its affiliates 41
  42. Exadata Infrastructure Exadata VM Exadata Cloud Service … … クライアント・ネットワーク

    バックアップ・ネットワーク DATA RECO SPARSE ASM Database Servers Storage Servers VM VM VM Clusterware dom0 または KVM host* ExaCS Database Home Database dom0 または KVM host* dom0 または KVM host* • • • * X8M KVM KVM host X8/X7/Base System Xen dom0 Copyright © 2021, Oracle and/or its affiliates 42
  43. • VM クラスタ作成の際にディスク・グループの構成を指定 • ローカル・バックアップ/SPARSE ディスク・グループ 有無により、ディスク割り当ての割合が異なる • 初期構築の割合から変更・SPARSE ディスク・グループ有無の変更は、VM

    クラスタの再作成が必要となる点に注意 )Exadata Cloud Service Disk Group % Base X8M/X8 X7 Quarter Half Full Quarter Half Full Exadata DB : SPARSE : DATA 80 59.2 TB 119.2 TB 239.2 TB 478.4 TB 84.8 TB 169.6 TB 339.2 TB RECO 20 14.8 TB 29.8 TB 59.8 TB 119.6 TB 21.2 TB 42.4 TB 84.8 TB Exadata DB : SPARSE : DATA 40 29.6 TB 59.6 TB 119.6 TB 239.2 TB 42.4 TB 84.8 TB 169.6 TB RECO 60 44.4 TB 89.4 TB 179.4 TB 358.8 TB 63.6 TB 127.2 TB 254.4 TB Exadata DB : SPARSE : DATA 60 44.4 TB 89.4 TB 179.4 TB 358.8 TB 63.6 TB 127.2 TB 254.4 TB RECO 20 14.8 TB 29.8 TB 59.8 TB 119.6 TB 21.2 TB 42.4 TB 84.8 TB SPARSE 20 14.8 TB 29.8 TB 59.8 TB 119.6 TB 21.2 TB 42.4 TB 84.8 TB Exadata DB : SPARSE : DATA 35 25.9 TB 52.2 TB 104.7 TB 209.3 TB 37.1 TB 74.2 TB 148.4 TB RECO 50 37.0 TB 74.5 TB 149.5 TB 299.0 TB 53.0 TB 106.0 TB 212.0 TB SPARSE 15 11.1 TB 22.4 TB 44.9 TB 89.7 TB 15.9 TB 31.8 TB 63.6 TB Exadata VM ) OCI Documentation Exadata Cloud Service > Storage Configuration Copyright © 2021, Oracle and/or its affiliates 43
  44. • VM クラスタ作成の際にディスク・グループの構成を指定 • ローカル・バックアップ/SPARSE ディスク・グループ 有無により、ディスク割り当ての割合が異なる • 初期構築の割合から変更・SPARSE ディスク・グループ有無の変更は、VM

    クラスタの再作成が必要となる点に注意 )Exadata Cloud Service Disk Group % Base X8M/X8 X7 Quarter Half Full Quarter Half Full Exadata DB : SPARSE : DATA 80 59.2 TB 119.2 TB 239.2 TB 478.4 TB 84.8 TB 169.6 TB 339.2 TB RECO 20 14.8 TB 29.8 TB 59.8 TB 119.6 TB 21.2 TB 42.4 TB 84.8 TB Exadata DB : SPARSE : DATA 40 29.6 TB 59.6 TB 119.6 TB 239.2 TB 42.4 TB 84.8 TB 169.6 TB RECO 60 44.4 TB 89.4 TB 179.4 TB 358.8 TB 63.6 TB 127.2 TB 254.4 TB Exadata DB : SPARSE : DATA 60 44.4 TB 89.4 TB 179.4 TB 358.8 TB 63.6 TB 127.2 TB 254.4 TB RECO 20 14.8 TB 29.8 TB 59.8 TB 119.6 TB 21.2 TB 42.4 TB 84.8 TB SPARSE 20 14.8 TB 29.8 TB 59.8 TB 119.6 TB 21.2 TB 42.4 TB 84.8 TB Exadata DB : SPARSE : DATA 35 25.9 TB 52.2 TB 104.7 TB 209.3 TB 37.1 TB 74.2 TB 148.4 TB RECO 50 37.0 TB 74.5 TB 149.5 TB 299.0 TB 53.0 TB 106.0 TB 212.0 TB SPARSE 15 11.1 TB 22.4 TB 44.9 TB 89.7 TB 15.9 TB 31.8 TB 63.6 TB Exadata VM ) OCI Documentation Exadata Cloud Service > Storage Configuration (FRA ) SPARSE DG Copyright © 2021, Oracle and/or its affiliates 44
  45. Oracle Database : Database Autonomous Database Virtual Machines Bare Metal

    Exadata Shared Dedicated H/W 1 DB 1 1 1 1 1 ( ) (OCPU/ ) OCPU OCPU Database Storage Server OCPU( ) OCPU( ) Auto Scaling - - - OCPU DB ( ) DB ( ) Copyright © 2021, Oracle and/or its affiliates 45
  46. Oracle Database : Database Autonomous Database Virtual Machines Bare Metal

    Exadata Shared Dedicated H/W 1 DB 1 1 1 1 1 ( ) (OCPU/ ) OCPU OCPU Database Storage Server OCPU( ) OCPU( ) Auto Scaling - - - OCPU DB ( ) DB ( ) Copyright © 2021, Oracle and/or its affiliates 46
  47. • - • - - OCPU ( ) • H/W

    • • • • • Copyright © 2021, Oracle and/or its affiliates 47
  48. ) Oracle Cloud Infrastructure • • • • H/W •

    • Oracle Cloud Infrastructure SLA 10 IT Oracle Oracle RAC Exadata Oracle Applications 50% Copyright © 2021, Oracle and/or its affiliates 48
  49. Oracle Database : DBCS VM/ADB-Shared DBCS BM/ExaCS/ADB-Dedicated (OCPU ) :OC3

    OC7 :OC1M OC5M Rack Rack ( OCPU/ / / ) OCPU OCPU ✓ OCPU ✓ OCPU ✓ OCPU ✓ ( ) / Copyright © 2021, Oracle and/or its affiliates 49
  50. / • • 1VM 1DB(PDB ) • =DB • DB

    2 OCPU 4 OCPU • • • 1VM DB ( PDB ) • DB / • OS • H/W • • RAC 4 OCPU x2 DBCS BM/ExaCS/ADB-Dedicated DBCS VM/ADB-Shared Copyright © 2021, Oracle and/or its affiliates 50
  51. • (Autonomous OCPU) • OCPU • • • • •

    : Database Cloud Service VM Autonomous Database - Shared Database ASM DBCS - VM Copyright © 2021, Oracle and/or its affiliates 51
  52. • • OCPU/ / - DBCS-VM ◦ OCPU - Autonomous

    Database OCPU ◦ OCPU • - DBCS-VM - Autonomous Database - Automatic Storage Management(ASM) ( ) : Database Cloud Service VM Autonomous Database - Shared Database DBCS - VM ASM Copyright © 2021, Oracle and/or its affiliates 52
  53. • • H/W • OCPU • • • ( )

    • • - CDB PDB 1 : Database Cloud Service - BM Exadata Cloud Service Database CPU ASM Copyright © 2021, Oracle and/or its affiliates 53
  54. • • OCPU : • / : • • -

    CDB PDB • (ORACLE_HOME ) : Database Cloud Service - BM Exadata Cloud Service Database CPU Database Database ASM Copyright © 2021, Oracle and/or its affiliates 54
  55. Oracle Database : Database Autonomous Database Virtual Machines Bare Metal

    Exadata Shared Infrastructure Dedicated Infrastructure OCPU + Storage OCPU + Infrastructure OCPU + Infrastructure OCPU + Storage OCPU + Infrastructure OCPU/Storage: 1 OCPU/Infrastructure : 1 OCPU: 1 Infrastructure:48 OCPU/Storage: 1 OCPU: 1 Infrastructure:48 OCPU: Storage: OCPU: OCPU Infrastructure: OCPU: Storage: OCPU: OCPU Infrastructure: OCPU OCPU OCPU OCPU OCPU OCPU OCPU OCPU DB ( ) DB ( ) OCPU OCPU 0 OCPU 0 Copyright © 2021, Oracle and/or its affiliates 55
  56. Database Cloud – Bare Metal Block Storage Bare Metal Dense

    I/O(2OCPU+Storage) Additional OCPUs DBCS-VM Shape OCPU Scale up OCPU Scale down VM OCPU Block Storage ( ) Scale up OCPU ( ) Infrastructure ( ) OCPU Scale up Database Cloud – Virtual Machine Autonomous Database Exadata Cloud Exadata Infrastructure Additional OCPUs 48h OCPU Scale up OCPU down to 0 OCPU ( ) Infrastructure ( ) 48 48 OCPU Scale up OCPU Exadata Storage OCPU Scale up OCPU Scale down Scale down OCPU (Dedicated Infrastructure )Infrastructure 48 48 Scale up Copyright © 2021, Oracle and/or its affiliates 56
  57. • • → → Copyright © 2021, Oracle and/or its

    affiliates 57
  58. • OCPU=0 OCPU • OCPU • / → / •

    1. : (Object Storage )) - 2. : + or - - Copyright © 2021, Oracle and/or its affiliates 58
  59. • • • → Copyright © 2021, Oracle and/or its

    affiliates 59
  60. Oracle Database : Database Autonomous Database Virtual Machines Bare Metal

    Exadata Shared Dedicated H/W 1 DB 1 1 1 1 1 ( ) OCPU/ OCPU OCPU Compute/Storage OCPU/ OCPU/ Auto Scaling - - - OCPU: Storage: OCPU: Infrastructure: OCPU: Storage: OCPU: Infrastructure: Copyright © 2021, Oracle and/or its affiliates 60
  61. OCI Oracle Database • (2020/06 )DBCS-BM/ExaCS/Autonomous Database • - DBCS-BM/ExaCS

    : H/W OS Active - Autonomous Database : DB • - • - Oracle Database ◦ Copyright © 2021, Oracle and/or its affiliates 61
  62. None
  63. Oracle Database : Database Autonomous Database Virtual Machines Bare Metal

    Exadata Shared Dedicated User-Managed Full-Managed OS ( DB ) OS OS Copyright © 2021, Oracle and/or its affiliates 63
  64. • Automated Full-Managed • OS →User-Managed Full-Managed Copyright © 2021,

    Oracle and/or its affiliates 64
  65. Oracle Database : Database Autonomous Database Virtual Machines Bare Metal

    Exadata Shared Dedicated User-Managed Full-Managed OS ( DB ) OS OS Copyright © 2021, Oracle and/or its affiliates 65
  66. Oracle Database ファシリティ管理 サーバー管理 パッチ適用 リソース監視 バックアップ/リストア HA/DR DB最適化 お客様管理

    OSインストール DBインストール DB構築 スケーリング DB on IaaS DBCS/ExaCS User-Managed Autonomous DB Full-Managed AP管理/最適化 ファシリティ管理 サーバー管理 パッチ適用 リソース監視 バックアップ/リストア HA/DR DB最適化 OSインストール DBインストール DB構築 AP管理/最適化 ファシリティ管理 サーバー管理 パッチ適用 リソース監視 バックアップ/リストア HA/DR DB最適化 OSインストール DBインストール スケーリング AP管理/最適化 ファシリティ管理 サーバー管理 パッチ適用 リソース監視 バックアップ/リストア HA/DR DB最適化 OSインストール DBインストール DB構築 スケーリング AP管理/最適化 + ( ) DB構築 スケーリング Copyright © 2021, Oracle and/or its affiliates 66
  67. Oracle) / • User Managed PaaS = User-Managed – –

    root OS – – – Database Cloud Service VM/BM, Exadata Cloud Service • Oracle Managed PaaS = Full-Managed – Oracle – Oracle – – Autonomous Database OS User Managed PaaS Oracle Managed PaaS Copyright © 2021, Oracle and/or its affiliates 67
  68. ✓ DB • - Full-Managed PaaS / - Oracle Database

    ◦ ◦ ◦ OS ✓ OS • / - - • OS - ( ) User-Managed Full-Managed Autonomous Database Copyright © 2021, Oracle and/or its affiliates 68
  69. None
  70. Oracle Database : Database Autonomous Database Virtual Machines Bare Metal

    Exadata Shared Dedicated Fault Domain ✔ ✔ - - - DB ✔ ✔ ✔ ✔ ✔ ✔ - ✔ - - Real Application Clusters ✔ - ✔ ✔ ✔ Data Guard ✔ ✔ ✔ ✔ ✔ Storage ✔ ✔ ASM 2 or 3 ✔ ASM 3 ✔ ASM 3 ✔ ASM 3 DB ✔ (Object Storage) ✔ (Object Storage) ✔ (Object Storage) ✔ ✔ ✔ ✔ ✔ ✔ ( ) ✔ ( ) Copyright © 2021, Oracle and/or its affiliates 70
  71. • Compute • Fault Domain • • Data Guard →

    Copyright © 2021, Oracle and/or its affiliates 71
  72. (AD) • 1 • AD AD 1 FD • AD

    AD (>=1Tb/sec) (< 0.5ms *) • AD Oracle MAA HA – (*) One-way latency AD1 AD2 AD3 Rack Rack Rack FD1 FD2 FD3 AD Copyright © 2021, Oracle and/or its affiliates 72
  73. 2 Web • : RPO <30 / RTO <30 •

    : RPO 0 / RTO 0 • ( ) • Active-Active Active-Passive • • • Web/AP DB DNS FD1 FD2 Database (RAC) WebAP FD1 FD2 Database (RAC) WebAP Backup Backup or Data Guard Replication (rsync ) Copyright © 2021, Oracle and/or its affiliates 73
  74. Database Cloud Service – Virtual Machine Availability Domain Virtual Cloud

    Network Region Database System Block Storage Object Storage (FD) Block Storage Object Storage Fault Domain Availability Domain Virtual Cloud Network Region Database System Block Storage Object Storage Fault Domain Database System Fault Domain Availability Domain Virtual Cloud Network Region Database System Block Storage Object Storage Fault Domain Database System Block Storage Fault Domain Data Guard RAC Active-Active Extreme Performance FD FD VM Block Storage Object Storage Extreme Performance Edition Data Guard / DB VCN / AD FD DB RAC Data Guard ※ Data Guard Enterprise Edition Active Data Guard Extreme Performance Copyright © 2021, Oracle and/or its affiliates 74
  75. Oracle Database Exadata • • • Real Application Cluster &

    Oracle Clusterware : DB • Service : • SCAN Listener : • Automatic Storage Management : Exadata Cloud Service Autonomous Database Oracle Clusterware Real Application Clusters Service Automatic Storage Management SCAN Listener OCI Copyright © 2021, Oracle and/or its affiliates 75
  76. Exadata Cloud Service Availability Domain 1 Client Subnet Virtual Cloud

    Network Region Object Storage Backup Subnet Exadata System ExaCS Active-Active Real Application Clusters FD VM Object Storage Client Backup 2 Data Guard ExaCS Data Guard / DB Real Application Clusters FD VM VCN / ※ Data Guard Availability Domain 1 Client Subnet Virtual Cloud Network Region Object Storage Backup Subnet Exadata System Client Subnet Data Guard Backup Subnet Exadata System Copyright © 2021, Oracle and/or its affiliates 76
  77. • Oracle Real Application Clusters(RAC) Oracle Cloud PaaS • Oracle

    Cloud IaaS BYOL • 3rd party RAC • Oracle Real Application Clusters (RAC) Support on Third-Party Clouds https://www.oracle.com/technetwork/database/options/clustering/overview/rac- cloud-support-2843861.pdf Real Application Clusters Copyright © 2021, Oracle and/or its affiliates 77
  78. Oracle Database : Database Autonomous Database Virtual Machines Bare Metal

    Exadata Shared Dedicated ( ) ✔ (Object Storage) ✔ (Object Storage) ✔ (Object Storage CLI / ) ( ) (Object Storage) (Object Storage) UI/CLI UI/CLI UI/CLI UI/CLI UI/CLI 7 15 30 45 60 7 15 30 45 60 7 15 30 45 60 60 7 15 30 60 ✔ (LVM ) ✔ (SPARSE SNAPSHOT) ✔ ( ) ✔ ( ) ✔ ✔ ✔ ✔ ✔ Copyright © 2021, Oracle and/or its affiliates 78
  79. • • → Copyright © 2021, Oracle and/or its affiliates

    79
  80. 30 ( ) Oracle Cloud Infrastructure : Database (DBCS/ExaCS/ADB) DATA

    Object Storage Day 31..37 Day 0~37 BKUP BKUP BKUP BKUP BKUP BKUP Copyright © 2021, Oracle and/or its affiliates 80
  81. • - DBCS/ExaCS 7 15 30 45 60 - Autonomous

    Database- Dedicated 7 15 30 60 - Autonomous Database – Shared 60 • = ≠ - 30 30 30 - ) 10% 9.1 ( 6 + 31 x0.1) ) Copyright © 2021, Oracle and/or its affiliates 81
  82. Oracle Database : Database Autonomous Database Virtual Machines Bare Metal

    Exadata Shared Dedicated DB Audit Service Oracle DB Audit Service Oracle DB Audit Service Oracle DB Audit Service Oracle DB Audit Service Oracle DB Data Safe IPsec VPN FastConnect ( / ) Copyright © 2021, Oracle and/or its affiliates 82
  83. Oracle Database Security Data Redaction SSO Identity Could Service /

    Identity Management DB Data Masking DB Security Assessment Tool Label Security Virtual Private DB Privilege Analysis DB Database Vault SQL Audit Vault and Database Firewall Audit Vault and Database Firewall Transparent Data Encryption Key Vault DF11233 U*1 $5Ha1qui %H1 HSKQ112 A14 FASqw34 £$1 DF@£!1ah HH! Copyright © 2021, Oracle and/or its affiliates 83
  84. Appendix

  85. Oracle Database PaaS [ ] DBCS vs Autonomous Database DBCS

    Autonomous Database Oracle Database (PaaS) Oracle Database (PaaS) H/W Exadata (H/W ) OS DB OS Root DBA SSH Root DBA OS DB OS DBA DB / ( ) NW IP VM PDB BM DB 1 1DB 2 Data Guard Fault Domain RMAN RMAN / RAC Grid Infrastructure RMAN Exadata RMAN Copyright © 2021, Oracle and/or its affiliates 85
  86. Oracle Database PaaS [ ] DBCS vs ExaCS DBCS ExaCS

    Oracle Database (PaaS) Oracle Database (PaaS) H/W Exadata OS OS 1 2(RAC) Base/Quarter: 2(Quarter 1 ) OCPU 1-24(RAC 4-48)/ 712GB – 50TB OCPU 4-1600 / 74TB – 3.1PB VM PDB BM DB DB 2 Data Guard Fault Domain RMAN 2 Data Guard RMAN / RAC Grid Infrastructure RMAN Exadata RMAN Copyright © 2021, Oracle and/or its affiliates 86
  87. Oracle Database PaaS [ ] ExaCS vs Autonomous Database ExaCS

    Autonomous Database Oracle Database (PaaS) Oracle Database (PaaS) Exadata Exadata (H/W ) OS DB OS Root DBA SSH Root DBA OS DB OS DBA DB / ( ) NW IP DB 1 1DB 2 Data Guard RMAN RMAN / Exadata RMAN Exadata RMAN Copyright © 2021, Oracle and/or its affiliates 87
  88. None
  89. Our mission is to help people see data in new

    ways, discover insights, unlock endless possibilities.