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

Transcript

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

   07

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

   2

3. Oracle Cloud Infrastructure Database Services Copyright © 2020, Oracle and/or

   its affiliates 3

4. 4 Copyright © 2020, Oracle and/or its affiliates Oracle Cloud

   2 Autonomous Database PaaS, SaaS IaaS PaaS コンピュート ストレージ コンテナ ネットワーク セキュリティ Autonomous Transaction Processing Autonomous Data Warehouse Autonomous Database (自律型データベースクラウド) Cloud at Customer (顧客DC) データ管理 アプリケーション開発 インテグレーション アナリティクス コンテンツ管理 セキュリティ・IT管理 SaaS ERP/EPM SCM HCM CX Oracle Cloud Infrastructure (第2世代インフラ) Cloud Applications Oracle Cloud Infrastructure

5. 5 Oracle Cloud Infrastructure: Compute and OS Bare Metal Virtual

   Machines GPU shapes High frequency CPUs Storage Block Object Object Archive File Import Appliance Storage Gateway Networking VCN Load Balancer Service Gateway FastConnect DNS Security KMS Policy Identity CASB WAF DDoS Governance and Management Compartments & Tags Monitoring Audit & Events Credential Manager Cost Management Next Layer Services Dev Ops Big Data & Analytics Container Ecosystem Hybrid Services Migration / Hybrid Dev Tools/IaC CI/CD/Deployment Streaming Data Integration / ETL Kubernetes/Container Registry Functions Partner Integrations Exadata Cloud@Customer Identity (AD, SSO, LDAP) VM/Data Migration Database Database Cloud ATP Autonomous Transaction Processing ADW Autonomous Data Warehouse ExaCS Exadata Cloud Other Data NoSQL Data Services Core Services Regions Tokyo Seoul Phoenix Ashburn London Frankfurt Toronto Zurich Mumbai Sydney Sao Paolo Linux Autonomous Linux Osaka Copyright © 2020, Oracle and/or its affiliates

6. 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 © 2020, Oracle and/or its affiliates 6

7. 1 RAC Exadata Oracle Cloud Infrastructure : Database OCI Exadata

   4-400 OCPUs OCI Database Bare Metal 2-52 OCPUs NVMe OCI Database Machines 1-24 OCPUs OCI Database Virtual Machines RAC 4-48 OCPUs Exadata Autonomous Autonomous Transaction Processing 1-128 OCPUs Autonomous Data Warehouse 1-128 OCPUs 1 RAC * CPU IO Exadata AI/ *Public Cloud RAC Oracle Cloud Copyright © 2020, Oracle and/or its affiliates 7

8. 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 • Oracle Exadata Database Machine(Exadata) • 3 Enterprise Edition • Oracle Database • Oracle Exadata Database Machine(Exadata) • DWH Autonomous Data Warehouse OLTP Autonomous Transaction Processing 2 Database Cloud Service (DBCS) – VM Copyright © 2020, Oracle and/or its affiliates 8

9. Copyright © 2020, Oracle and/or its affiliates 9

10. Oracle Cloud Infrastructure Database Services Copyright © 2020, Oracle and/or

    its affiliates 10

11. Copyright © 2020, Oracle and/or its affiliates 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 20c Preview 11.2/12.1/12.2/18/19 11.2/12.1/12.2/18/19 18/19 ( ) 19 H/W X7 X7 Exadata X7/X8 Exadata Exadata X7/8 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 11

12. Copyright © 2020, Oracle and/or its affiliates 12

13. 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 © 2020, Oracle and/or its affiliates 13

14. 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) ¥48/h ¥200/h ¥97/h ¥302/h * : CPU /PAYG Copyright © 2020, Oracle and/or its affiliates 14

15. 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) ¥48/h ¥200/h ¥97/h ¥302/h * : CPU /PAYG Copyright © 2020, Oracle and/or its affiliates 15

16. • 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 © 2020, Oracle and/or its affiliates 16

17. Oracle Database 30 / Database Standard Edition2 Enterprise Edition RAC

    Option Partitioning Option Standard Edition Enterprise Edition * Monthly 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 ¥32.256/OCPU/ ¥64.512/OCPU/ ¥133.072/OCPU/ ¥201.616/OCPU/ BYOL to PaaS ¥23.224/OCPU/ • Exadata Cloud Service • Autonomous Database (ADW, ATP) Copyright © 2020, Oracle and/or its affiliates 17

18. 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 © 2020, Oracle and/or its affiliates 18

19. ADW ATP (Colummar) (Row) I/O RDMA I/O IT :ADW ATP

    Copyright © 2020, Oracle and/or its affiliates 19

20. Oracle Cloud Infrastructure Database Services Copyright © 2020, Oracle and/or

    its affiliates 20

21. Copyright © 2020, Oracle and/or its affiliates 21

22. Copyright © 2020, Oracle and/or its affiliates Oracle Database :

    / Database Autonomous Database Virtual Machines Bare Metal Exadata Shared Dedicated Compute 1 (RAC :2) 1 2 / 4 / 8 - - OCPU 1 – 24 (RAC : 4-48) 2 – 52 (SE :2-8) 8 – 400 1- 128 (※128 ) 1 – 400 Memory 15GB – 320GB ( ) 768GB 720GB – 5,760GB OCPU OCPU Storage 712GB – 50 TB (Block Storage: ) 51.2TB (Local NVMe: ) 74.6 TB – 598 TB (Local Storage: ) 1 TB – 128TB 1 TB – 598 TB 256GB – 40 TB 4.6TB/9TB 8TB/16TB 26.2 – 478.4 TB 1 TB – 128TB 1 TB – 598 TB 1-25GbE ( ) 2x25GbE 2x25 GbE ( :InfiniBand) - - ( ) OCPU/Memory: Storage: OCPU: Memory/Storage: OCPU: Memory/Storage: OCPU/Storage : Memory: OCPU OCPU/Storage : Memory: OCPU 22

23. 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 © 2020, Oracle and/or its affiliates 23

24. • - ( ) - 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 © 2020, Oracle and/or its affiliates 24

25. Exadata • - ◦ Base,Quarter : 2 / Half :

    4 / Full : 8 - (OCPU/ ) - - Oracle Grid Infrastructure - ◦ Oracle Real Application Clusters (RAC) ◦ 12c CDB(1PDB) ◦ • - ◦ Base,Quarter :3 / Half : 6 / Full : 12 - Oracle Automatic Storage Management(ASM) ◦ DATA/RECO/SPARSE 3 Exadata Cloud Service : VM (domU) VM (domU) VM (domU) Exadata System Clusterware Database … … Database Client Subnet Backup Subnet DATA RECO SPARSE ASM Object Storage 2,4,8 Compute Nodes 3,6,12 Storage Servers Copyright © 2020, Oracle and/or its affiliates 25

26. Copyright © 2020, Oracle and/or its affiliates Oracle Database :

    Database Autonomous Database Virtual Machines Bare Metal Exadata Shared Dedicated H/W 1 DB 1 1 1 1 1 ( ) (OCPU/ ) OCPU OCPU OCPU( ) OCPU( ) Auto Scaling - - - OCPU DB ( ) DB ( ) 26

27. Copyright © 2020, Oracle and/or its affiliates 27

28. 28 Copyright © 2020, Oracle and/or its affiliates Oracle Cloud

    Infrastructure • • • Oracle Cloud Infrastructure IT Performance SLA Autonomous DB, RAC, Exadata IT • • •

29. 29 • - • - - OCPU ( ) •

    H/W • • • • • Copyright © 2020, Oracle and/or its affiliates

30. 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 © 2020, Oracle and/or its affiliates 30

31. / • • 1VM 1DB(PDB ) • =DB • DB

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

32. Copyright © 2020, Oracle and/or its affiliates • (Autonomous OCPU)

    • OCPU • • • • • : Database Cloud Service VM Autonomous Database - Shared Database ASM DBCS - VM 32

33. Copyright © 2020, Oracle and/or its affiliates • • 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 33

34. • ≠ DB ≠ - : - DB : (SYSTEM/SYSAUX/TEMP

    ) ( ) - : ASM (DBCS- BM ExaCS) • - ( ) RMAN - RMAN RECO (DATA) OS S/W (RECO) Compute Local Storage Remote Storage Copyright © 2020, Oracle and/or its affiliates 34

35. Copyright © 2020, Oracle and/or its affiliates • • 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 35

36. Copyright © 2020, Oracle and/or its affiliates • (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 36

37. Copyright © 2020, Oracle and/or its affiliates (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) )= 37

38. Copyright © 2020, Oracle and/or its affiliates (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 38

39. Copyright © 2020, Oracle and/or its affiliates • 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 39

40. Copyright © 2020, Oracle and/or its affiliates • • H/W

    • OCPU • • • ( ) • • - CDB PDB 1 : Database Cloud Service - BM Exadata Cloud Service Database CPU 40 ASM

41. Copyright © 2020, Oracle and/or its affiliates • • OCPU

    : • / : • • - CDB PDB • (ORACLE_HOME ) : Database Cloud Service - BM Exadata Cloud Service Database CPU Database Database 41 ASM

42. Copyright © 2020, Oracle and/or its affiliates 42 • OCI

    Database-BM Exadata Cloud ( ) • RECO (FRA ) DATA ( ) - RECO FRA ( ) (REDO ) ◦ FRA ◦ REDO - → RECO = DATA

43. Copyright © 2020, Oracle and/or its affiliates 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 ※ 43

44. • - Base,Quarter :3 / Half : 6 / Full

    : 12 • Automatic Storage Management(ASM) - DATA/RECO/SPARSE 3 - (RECO) SPARSE 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% VM (domU) VM (domU) VM (domU) Clusterware Database … … Database Client Subnet Backup Subnet DATA RECO SPARSE ASM Object Storage 2,4,8 Compute Nodes 3,6,12 Storage Servers Copyright © 2020, Oracle and/or its affiliates 44

45. Copyright © 2020, Oracle and/or its affiliates 45

46. Copyright © 2020, Oracle and/or its affiliates 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 Storage Infrastructure Infrastructure: OCPU DB ( ) DB ( ) OCPU OCPU 0 OCPU 0 46

47. Copyright © 2020, Oracle and/or its affiliates 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 47

48. Oracle Cloud Infrastructure Database Services Copyright © 2020, Oracle and/or

    its affiliates 48

49. Copyright © 2020, Oracle and/or its affiliates Oracle Database :

    Database Autonomous Database Virtual Machines Bare Metal Exadata Shared Dedicated User-Managed Full-Managed OS ( DB ) OS OS 49

50. Copyright © 2020, Oracle and/or its affiliates 50 User-Managed Full-Managed

51. Copyright © 2020, Oracle and/or its affiliates 51 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構築 スケーリング

52. Copyright © 2020, Oracle and/or its affiliates 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 52

53. Copyright © 2020, Oracle and/or its affiliates  DB •

    - Full-Managed PaaS / - Oracle Database ◦ ◦ ◦ OS  OS • / - - • OS - ( ) User-Managed Full-Managed Autonomous Database 53

54. Oracle Cloud Infrastructure Database Services ( ) Copyright © 2020,

    Oracle and/or its affiliates 54

55. Copyright © 2020, Oracle and/or its affiliates 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) ✔ ✔ ✔ ✔ ✔ ✔ ( ) - 55

56. Copyright © 2020, Oracle and/or its affiliates 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 45 60 ✔ (SPARSE SNAPSHOT) ✔ ( ) ✔ ( ) ✔ ✔ ✔ ✔ - 56

57. Copyright © 2020, Oracle and/or its affiliates (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 57

58. Copyright © 2020, Oracle and/or its affiliates 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 ) 58

59. Copyright © 2020, Oracle and/or its affiliates 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 59

60. Copyright © 2020, Oracle and/or its affiliates 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 60

61. Copyright © 2020, Oracle and/or its affiliates 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 61

62. • 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 © 2020, Oracle and/or its affiliates 62

63. Copyright © 2020, Oracle and/or its affiliates 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 ( / ) 63

64. 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 © 2020, Oracle and/or its affiliates 64

65. Copyright © 2020, Oracle and/or its affiliates 65

66. 66 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 • Oracle Exadata Database Machine(Exadata) • 3 Enterprise Edition • Oracle Database • Oracle Exadata Database Machine(Exadata) • DWH Autonomous Data Warehouse OLTP Autonomous Transaction Processing 2 Database Cloud Service (DBCS) – VM Copyright © 2020, Oracle and/or its affiliates

67. Appendix

68. 68 Copyright © 2020, Oracle and/or its affiliates • •

    BI • • CPU (PAYG) • Oracle Autonomous Data Warehouse: ¥302.424 [OCPU/Hour] • Oracle Autonomous Data Warehouse Cloud - Exadata Storage: ¥26,640 [TB/Month] / • 3 • Oracle Database Oracle Exadata Autonomous Data Warehouse

69. 69 Copyright © 2020, Oracle and/or its affiliates • •

    • (PAYG) • Oracle Autonomous Transaction Processing: ¥302.424 [OCPU/Hour] • Oracle Autonomous Transaction Processing - Exadata Storage: ¥26,640 [TB/Month] / • 3 • Oracle Database Oracle Exadata Autonomous Transaction Processing DB DB

70. 70 Copyright © 2020, Oracle and/or its affiliates • •

    • DB (Database/ ) • Exadata (Exadata) (PAYG) [Database Service] • Standard Edition: ¥48.38 [OCPU/Hour] • Enterprise Edition: ¥96.77 [OCPU/Hour] / • Database Service RAC Data Guard Database Service • Exadata Service Exadata Oracle Cloud Infrastructure - Database Database Exadata

71. 71 Copyright © 2020, Oracle and/or its affiliates • •

    • • Base System: ¥1,200,000 ( ) / • Exadata Cloud at Customer Exadata Cloud Service Exadata Cloud at Customer Oracle Cloud DC

72. Oracle Database PaaS [ ] DBCS vs Autonomous Database Copyright

    © 2020, Oracle and/or its affiliates 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 72

73. Oracle Database PaaS [ ] DBCS vs ExaCS Copyright ©

    2020, Oracle and/or its affiliates DBCS ExaCS Oracle Database (PaaS) Oracle Database (PaaS) H/W Exadata OS OS 1 2(RAC) Base/Quarter: 2, Half: 4 , Full: 8 OCPU 1-24(RAC 4-48)/ 712GB – 50TB OCPU 8-400 / 720 – 5,760GB VM PDB BM DB DB 2 Data Guard Fault Domain RMAN 2 Data Guard RMAN / RAC Grid Infrastructure RMAN Exadata RMAN 73

74. Oracle Database PaaS [ ] ExaCS vs Autonomous Database Copyright

    © 2020, Oracle and/or its affiliates 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 74
75. None

76. Our mission is to help people see data in new

    ways, discover insights, unlock endless possibilities.