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

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

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

Transcript

1. Oracle Cloud Infrastructure Database Services Oracle Database OCI DB 2021 10 26
2. Safe harbor statement Copyright © 2021, Oracle and/or its affiliates 2
3. Copyright © 2021, Oracle and/or its affiliates 7
4. Oracle Database – Most Manual Most Autonomous Database Exadata Database IaaS Database Autonomous Database Database Cloud Service - BM/VM Exadata Cloud Service /Exadata Cloud@Custo mer Oracle Cloud Infrastructure On Premise Copyright © 2021, Oracle and/or its affiliates 8
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 13
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 14
7. Copyright © 2021, Oracle and/or its affiliates 15
8. Copyright © 2021, 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 21c 11.2/12.1/12.2/18/19 11.2/12.1/12.2/18/19 19 19 H/W X7 X7 Exadata X8M/X9M(ExaCC) Exadata Exadata X8M/X9M 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 16 (※) 2022/12/31 EOSL Oracle Database Cloud Service DBCS-BM X7 SKUs EOSL Change Notification (Doc ID 2781994.1)
9. Copyright © 2021, Oracle and/or its affiliates • OCI Database • OCI Database(VM/BM) Extreme Performance OCI Exadata • Autonomous Database(ADW/ATP) xx → 17
10. Copyright © 2021, 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 21c 11.2/12.1/12.2/18/19 11.2/12.1/12.2/18/19 19 19 H/W X7 X7 Exadata X8M/X9M Exadata Exadata X8M/X9M 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 18
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 19
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 Copyright © 2021, Oracle and/or its affiliates 20 CPU
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 21
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 22
15. • Database Licensing Information User Manual - Licensing Information • Restrictions for Database Features Autonomous Database : • Oracle Real Application Testing (Database Replay) • SPA • 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 • Oracle LogMiner • Oracle Sharding • Java in DB • Oracle Workspace Manager ※2021/10 Copyright © 2021, Oracle and/or its affiliates 23
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 24
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 25
18. ADW ATP (Columnar) (Row) I/O RDMA I/O IT :ADW ATP Copyright © 2021, Oracle and/or its affiliates 26
19. Copyright © 2021, Oracle and/or its affiliates 27
20. Copyright © 2021, Oracle and/or its affiliates Oracle Database : / Database Autonomous Database Virtual Machines Bare Metal ExaCS ExaCC Shared Dedicated Compute 1 (RAC :2) 1 2 – 32 2 – 8 - - OCPU 1 – 24 (RAC : 4-48) 2 – 52 (SE :2-8) 4 – 1600 4 – 496 1- 128 (※128 ) 1 – 400 Memory 15GB – 320GB ( ) 768GB 720GB – 44480GB 656GB – 11120GB OCPU OCPU Storage 712GB – 50 TB (Block Storage: ) 51.2TB (Local NVMe: ) 74.6TB – 3.1PB (Local Storage: ) 74TB – 769TB (Local Storage: ) 1 TB – 128TB 1 TB – 598 TB 256GB – 40 TB 4.6TB/9TB 8TB/16TB 26.2TB – 2.5PB 74TB – 769TB 1 TB – 128TB 1 TB – 598 TB 1-25GbE ( ) 2x25GbE 2x25 GbE 2x 25 GbE / 10GbE - - ( ) OCPU/Memory: Storage: OCPU: Memory/Storage: OCPU: Memory/Storage: OCPU/ Memory/Storage : OCPU/Storage : Memory: OCPU OCPU/Storage : Memory: OCPU 28
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 29
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 30
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
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(ExaCS) x Storage Servers VM VM VM Clusterware dom0 または KVM host Database Home Database dom0 または KVM host dom0 または KVM host • • • • • • • • • • • • • •
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(ExaCS) 3 64(ExaCS)/12(ExaCC) x Storage Servers VM VM VM Clusterware dom0 または KVM host Database Home Database dom0 または KVM host dom0 または KVM host • • • • • • •
26. Copyright © 2021, Oracle and/or its affiliates 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 34
27. Copyright © 2021, Oracle and/or its affiliates • xxGB / • • Block Storage/Object Storage → 35
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 36
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 Copyright © 2021, Oracle and/or its affiliates 37 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
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 Copyright © 2021, Oracle and/or its affiliates 38 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
31. Copyright © 2021, 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 ≠ 39
32. Copyright © 2021, 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 40
33. Copyright © 2021, 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 41
34. Copyright © 2021, 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) )= 42
35. Copyright © 2021, 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 43
36. Copyright © 2021, Oracle and/or its affiliates (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 44
37. Copyright © 2021, Oracle and/or its affiliates 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 (※ ) 45
38. Copyright © 2021, 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 46
39. Copyright © 2021, 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 ※ 47
40. Copyright © 2021, 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 ※ 48
41. Copyright © 2021, Oracle and/or its affiliates • OCI Database-BM Exadata Cloud ( ) • RECO (FRA ) DATA ( ) - RECO FRA ( ) (REDO ) ◦ FRA ◦ REDO - → RECO = DATA 49
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
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
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
45. Copyright © 2021, 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 Database Storage Server OCPU( ) OCPU( ) Auto Scaling - - - OCPU DB ( ) DB ( ) 53
46. Copyright © 2021, 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 Database Storage Server OCPU( ) OCPU( ) Auto Scaling - - - OCPU DB ( ) DB ( ) 54
47. • - • - - OCPU ( ) • H/W • • • • • Copyright © 2021, Oracle and/or its affiliates 55
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 56
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 57
50. / • • 1VM 1DB(PDB ) • =DB • DB 2 OCPU 4 OCPU • • • 1VM DB ( PDB ) • DB / • OS • H/W • • RAC 4 OCPU x2 Copyright © 2021, Oracle and/or its affiliates 58 DBCS BM/ExaCS/ADB-Dedicated DBCS VM/ADB-Shared
51. Copyright © 2021, Oracle and/or its affiliates • (Autonomous OCPU) • OCPU • • • • • : Database Cloud Service VM Autonomous Database - Shared Database ASM DBCS - VM 59
52. Copyright © 2021, 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 60
53. Copyright © 2021, Oracle and/or its affiliates • • H/W • OCPU • • • ( ) • • - CDB PDB 1 : Database Cloud Service - BM Exadata Cloud Service Database CPU 61 ASM
54. Copyright © 2021, Oracle and/or its affiliates • • OCPU : • / : • • - CDB PDB • (ORACLE_HOME ) : Database Cloud Service - BM Exadata Cloud Service Database CPU Database Database 62 ASM
55. Copyright © 2021, 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 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 63
56. Copyright © 2021, 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 64
57. Copyright © 2021, Oracle and/or its affiliates • • → → 65
58. Copyright © 2021, Oracle and/or its affiliates • OCPU=0 OCPU • OCPU • / → / • 1. : (Object Storage )) - 2. : + or - - 66
59. Copyright © 2021, Oracle and/or its affiliates Oracle Database : Database Autonomous Database Virtual Machines Bare Metal Exadata Shared Dedicated ※ 60-80 ( 15 ) 60-80 Base/Quarter : 4 Half : 6 Full : 8 (1OCPU/1TB) 2 Quarter : 60 DB ( ) N/A 20 1-2 N/A ( ) (OS/GI/DB/ ) (OS/GI/DB/ ) (OS/GI/DB ) (PDB Open) ( ) ( DB ) INTENRAL ONLY 67
60. Copyright © 2021, Oracle and/or its affiliates • • • → 68
61. Copyright © 2021, 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 Compute/Storage OCPU/ OCPU/ Auto Scaling - - - OCPU: Storage: OCPU: Infrastructure: OCPU: Storage: OCPU: Infrastructure: 69
62. Copyright © 2021, Oracle and/or its affiliates OCI Oracle Database • (2020/06 )DBCS-BM/ExaCS/Autonomous Database • - DBCS-BM/ExaCS : H/W OS Active - Autonomous Database : DB • - • - Oracle Database ◦ 70
63. Copyright © 2021, Oracle and/or its affiliates 71
64. Copyright © 2021, 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 72
65. Copyright © 2021, Oracle and/or its affiliates • Automated Full-Managed • OS →User-Managed Full-Managed 73
66. Copyright © 2021, 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 74
67. Copyright © 2021, Oracle and/or its affiliates 75 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構築 スケーリング
68. Copyright © 2021, 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 76
69. Copyright © 2021, Oracle and/or its affiliates  DB • - Full-Managed PaaS / - Oracle Database ◦ ◦ ◦ OS  OS • / - - • OS - ( ) User-Managed Full-Managed Autonomous Database 77
70. Copyright © 2021, Oracle and/or its affiliates 78
71. Copyright © 2021, 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) ✔ ✔ ✔ ✔ ✔ ✔ ( ) ✔ ( ) 79
72. Copyright © 2021, Oracle and/or its affiliates • Compute • Fault Domain • • Data Guard → 80
73. Copyright © 2021, 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 81
74. Copyright © 2021, 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 ) 82
75. Copyright © 2021, 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 83
76. Copyright © 2021, 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 84
77. Copyright © 2021, 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 85
78. • 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 86
79. Copyright © 2021, 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 60 ✔ (LVM ) ✔ (SPARSE SNAPSHOT) ✔ ( ) ✔ ( ) ✔ ✔ ✔ ✔ ✔ 87
80. Copyright © 2021, Oracle and/or its affiliates • • → 88
81. 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 89
82. • -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 90
83. Copyright © 2021, 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 ( / ) 91
84. 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 92
85. Appendix
86. Oracle Database PaaS [ ] DBCS vs Autonomous Database Copyright © 2021, 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 / ( ) SSL VM PDB BM DB 1 1DB 2 Data Guard Fault Domain RMAN 2 Data Guard RMAN / RAC Grid Infrastructure RMAN Exadata RMAN 94
87. Oracle Database PaaS [ ] DBCS vs ExaCS Copyright © 2021, Oracle and/or its affiliates 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 95
88. Oracle Database PaaS [ ] ExaCS vs Autonomous Database Copyright © 2021, 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 / ( ) SSL DB 1 1DB 2 Data Guard RMAN 2 Data Guard RMAN / Exadata RMAN Exadata RMAN 96
90. Our mission is to help people see data in new ways, discover insights, unlock endless possibilities.