Oracle Database 機能概要

3115a782126be714b5f94d24073c957d?s=47 oracle4engineer
March 13, 2020
130

Oracle Database 機能概要

Oracle Databaseのオプション機能を中心に、各機能の概要をまとめています。

3115a782126be714b5f94d24073c957d?s=128

oracle4engineer

March 13, 2020
Tweet

Transcript

  1. 2020/03/11 Oracle Database 19c Oracle Database 19c

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

    2
  3. Oracle Database

  4. 5 Copyright © 2020, Oracle and/or its affiliates (CPU/ )

    1 2 4
  5. 6 Copyright © 2020, Oracle and/or its affiliates Exadata X8M-2

    (2019 ) 1RU Intel Xeon 2 CPU • Intel Xeon 8260 Cascade Lake (24 ) • 24 2 = 48 DRAM (DDR4) • 32GB DIMM 12 = 384GB • 32GB DIMM 24 = 768GB • 64GB DIMM 24 = 1536GB 2019 CPU 1RU 2
  6. 7 Copyright © 2020, Oracle and/or its affiliates Oracle Database

    • SELECT • DML (INSERT/UPDATE/DELETE/MERGE) • PL/SQL • / • DDL (CREATE TABLE AS SELECT) • CREATE/ALTER INDEX / • Data Pump • RMAN BACKUP/RESTORE ( ) • RMAN RECOVER (REDO ) • ( ) • Data Guard REDO Apply
  7. 8 Copyright © 2020, Oracle and/or its affiliates / •

    SELECT • DML (INSERT/UPDATE/DELETE/MERGE) • PL/SQL / Oracle (PX) / 1 SQL PX PX PX / PX
  8. 9 Copyright © 2020, Oracle and/or its affiliates / •

    SQL • DDL • CREATE TABLE AS SELECT B* • • CREATE INDEX • ALTER INDEX REBUILD B*
  9. 10 Copyright © 2020, Oracle and/or its affiliates RMAN •

    - BACKUP - RESTORE • REDO - RECOVER Data Pump • / • REDO / BACKUP RESTORE REDO REDO RECOVER REDO
  10. 11 Copyright © 2020, Oracle and/or its affiliates • Oracle

    • (REDO ) • Data Guard REDO Apply • REDO (REDO ) REDO RECOVER
  11. Oracle Partitioning

  12. Copyright © 2020, Oracle and/or its affiliates 17 B* →

    SQL B* SELECT * FROM t1 WHERE primary_key = value1
  13. Copyright © 2020, Oracle and/or its affiliates 18 → SQL

    B* SELECT * FROM t1 WHERE column1 BETWEEN value1 AND value2
  14. Copyright © 2020, Oracle and/or its affiliates 19 ( )

    SQL WHERE ( ) 1 SELECT * FROM t1 WHERE column1 BETWEEN value1 AND value2 2 3
  15. Copyright © 2020, Oracle and/or its affiliates 20 → SQL

    1 2 3 B*
  16. Copyright © 2020, Oracle and/or its affiliates 21 2020/01/01 2020/02/01

    2020/03/01 2020/02/01 2020/01/01 2020/01/01 1 1 SQL 1
  17. Copyright © 2020, Oracle and/or its affiliates 22 ( )

    SQL WHERE SQL 1 2
  18. Copyright © 2020, Oracle and/or its affiliates 23 2 2

    1 2 (1) (2)
  19. Copyright © 2020, Oracle and/or its affiliates 24 • DROP

    PARTITION • TRUNCATE • • 1 2
  20. Advanced Compression

  21. • 1/2 1/4 • • I/O • (ADO) • Oracle

    Advanced Compression Copyright © 2020, Oracle and/or its affiliates 30 CPU I/O CPU I/O OLTP
  22. Copyright © 2020, Oracle and/or its affiliates Oracle Database 31

    LOB DWH OLTP REDO Data Guard RMAN (ADO)/ – – Advanced Compression Option Oracle Storage, Exadata
  23. Copyright © 2020, Oracle and/or its affiliates 32 • DML

    • • OLTP - 2 4 • DML • • I/O
  24. Copyright © 2020, Oracle and/or its affiliates 33 LOB •

    SecureFiles LOB - ◦ LOB - ◦ SecureFiles LOB • - • SecureFiles - - LOB
  25. Copyright © 2020, Oracle and/or its affiliates 34 • (Low)

    • CPU - 2 (HIGH) • CPU - 4 5
  26. Copyright © 2020, Oracle and/or its affiliates 35 • Oracle

    Recovery Manager(RMAN) • • RMAN Advanced Compression BASIC (SE2 ) MEDIUM CPU LOW MEDIUM CPU HIGH CPU
  27. Copyright © 2020, Oracle and/or its affiliates 36 • –

    ADO (ADO) • ADO • ADO = ( ) ( ) ADO
  28. Copyright © 2020, Oracle and/or its affiliates 37

  29. Copyright © 2020, Oracle and/or its affiliates 38 / (ADO)

    ADO Policy1: 90 ADO Policy2: 180 ALTER TABLE sales ILM ADD POLICY ROW STORE COMPRESS ADVANCED SEGMENT AFTER 90 days of creation; ALTER TABLE sales ILM ADD POLICY COLUMN STORE COMPRESS FOR ARCHIVE HIGH SEGMENT AFTER 180 days of no modification;
  30. Copyright © 2020, Oracle and/or its affiliates 39 : :

    • • • : • • I/O
  31. Oracle Database In-Memory

  32. Copyright © 2020, Oracle and/or its affiliates 44 ▪ –

    – ▪ – –
  33. Copyright © 2020, Oracle and/or its affiliates 45 2 Oracle

    Database In-Memory (DBIM) IM SALES SALES SALES 1 SALES 2 • • : • : (IM ) • • • •
  34. Copyright © 2020, Oracle and/or its affiliates 46 DBIM

  35. Copyright © 2020, Oracle and/or its affiliates 47 DBIM 1.

    IM inmemory_size = XXX GB 2. IM alter table | partition … inmemory; 3.
  36. Copyright © 2020, Oracle and/or its affiliates 48 DBIM SQL

    select * from SALES where order_id = ‘ABC123’; select region, sum(amount) from SALES group by region; Oracle Database
  37. Copyright © 2020, Oracle and/or its affiliates 49 DBIM •

    • • •
  38. Copyright © 2020, Oracle and/or its affiliates 50 DBIM (

    Elapsed Time) • • • • •
  39. Oracle Diagnostics Pack Oracle Tuning Pack

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

    • Oracle Diagnostics Pack Oracle Tuning Pack I/O SQL
  41. Copyright © 2020, Oracle and/or its affiliates 53 (AWR) •

    • • (ASH) • • (ADDM) • AWR • Oracle Diagnostics Pack
  42. Copyright © 2020, Oracle and/or its affiliates 54 • •

    AWR (AWR) AWR • • • 10 • (%) • SQL • • IO • • SQL 1 * SGA AWR 8 * * ID id=100 id=101 id=102 100-101 AWR 101-102 AWR
  43. Copyright © 2020, Oracle and/or its affiliates 55 • (SGA)

    • SGA • ASH (ASH) CPU Session ACTIVE 1 2 1 1/10
  44. Copyright © 2020, Oracle and/or its affiliates 56 AWR •

    AWR / • (ADDM)
  45. Copyright © 2020, Oracle and/or its affiliates 57 SQL •

    SQL • ( SQL ) SQL • SQL • SQL Oracle Tuning Pack
  46. SQL ( SQL ) SQL SQL SQL SQL (*) SQL

    DBA SQL SQL (*) SQL SQL Copyright © 2020, Oracle and/or its affiliates 58
  47. 59 SQL SQL ( ) SQL Copyright © 2020, Oracle

    and/or its affiliates
  48. 60 SQL (*) SQL SQL (*) SQL 5 CPU I/O

    SQL SQL Status: Executing( ) DONE SQL I/O Copyright © 2020, Oracle and/or its affiliates
  49. Oracle Recovery Manager (RMAN)

  50. Copyright © 2020, Oracle and/or its affiliates 62 Oracle Database

    ( ) ( ) ( REDO ) REDO
  51. Copyright © 2020, Oracle and/or its affiliates 63 • •

    • • • • • • Oracle Oracle Recovery Manager (RMAN) oracle rman RMAN Oracle
  52. 64 Copyright © 2020, Oracle and/or its affiliates • RMAN

    • Oracle • OS • • Oracle • Oracle • Oracle RMAN Oracle Database 2 oracle rman Recovery Manager (RMAN) RMAN Oracle
  53. 65 Copyright © 2020, Oracle and/or its affiliates • I/O

    • SQL SQL I/O RMAN SQL I/O oracle rman Recovery Manager (RMAN) RMAN Oracle
  54. 66 Copyright © 2020, Oracle and/or its affiliates • •

    • • "Recovery" Manager oracle rman Recovery Manager (RMAN) RMAN Oracle
  55. 67 Copyright © 2020, Oracle and/or its affiliates • •

    • Oracle ( ) • "Recovery" Manager oracle rman Recovery Manager (RMAN) RMAN Oracle
  56. Copyright © 2020, Oracle and/or its affiliates 68 RMAN 1

    BACKUP RESTORE RECOVER
  57. Copyright © 2020, Oracle and/or its affiliates 69 Oracle Database

    2 • • • • ( )
  58. Database Lifecycle Management Pack

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

    Database Lifecycle Management Pack • • • • • • • DB • • DB • DB OS • • Enterprise Data Governance •
  60. Copyright © 2020, Oracle and/or its affiliates 72 • (PCIDSS

    ) • Enterprise Data Governance • • DB DB • DB OS • • DB DB DB • Database Lifecycle Management Pack
  61. Copyright © 2020, Oracle and/or its affiliates 73 • DB

    DB • • Oracle Database • Oracle Real Application Clusters • Oracle Real Application Clusters • Oracle Database • • Oracle Database Client
  62. Copyright © 2020, Oracle and/or its affiliates 74 • •

    • • • • • •
  63. Copyright © 2020, Oracle and/or its affiliates 75 DB DB

    DB Ver 0.1 Ver 0.2 Ver 1.0 DDL EMPLOYEES EMAIL 25 30
  64. Copyright © 2020, Oracle and/or its affiliates 76

  65. Copyright © 2020, Oracle and/or its affiliates 77 (PCIDSS )

    • • • • • • • • • My Oracle Support
  66. Copyright © 2020, Oracle and/or its affiliates 78 • :

    • : Enterprise Data Governance
  67. Oracle Multitenant

  68. 80 Oracle Multitenant PDB Copyright © 2020, Oracle and/or its

    affiliates Multitenant
  69. Copyright © 2020, Oracle and/or its affiliates PDB( ) •

    • ( ) • / CDB( ) • ( HA ) • • Oracle Multitenant 81
  70. Copyright © 2020, Oracle and/or its affiliates 82 Multitenant Multitenant

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

  72. 84 Multitenant • • Copyright © 2020, Oracle and/or its

    affiliates
  73. 85 Multitenant • • • • Copyright © 2020, Oracle

    and/or its affiliates
  74. Copyright © 2020, Oracle and/or its affiliates 86 B) Unplug

    & Plug A) Multitenant Unplug & Plug
  75. Copyright © 2020, Oracle and/or its affiliates 87 • -

    PDB - • - PDB • - PDB • 1 CDB 4,096 PDB • PDB • PDB • I/O CPU • - • - PDB • PDB - CDB • - PDB Multitenant
  76. Copyright © 2020, Oracle and/or its affiliates 88 PDB Real

    Application Testing • PDB (19c ) • PDB PDB • PDB PDB PDB • PDB • • 8 • 9 PDB • PDB read/write PDB Multitenant AP DB SQL/ワークロードを取得 取得したSQL/ワークロード 本番環境 テスト環境 Client Replay Client DB
  77. Copyright © 2020, Oracle and/or its affiliates 89 Multitenant (

    2) ( 1) A B C ( )
  78. Oracle Real Application Clusters

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

    • • (CPU ) - : - : • Oracle • 1 Oracle • / Oracle Real Application Clusters (RAC)
  80. 95 Copyright © 2020, Oracle and/or its affiliates Oracle •

    1 Oracle • (Cache Fusion) • / • / • / Oracle Oracle
  81. Copyright © 2020, Oracle and/or its affiliates • • /

    • 1 SQL • 1 SQL Oracle QC PX PX PX PX PX PX PX PX 96 Oracle
  82. Copyright © 2020, Oracle and/or its affiliates RAC (CPU )

    RAC https://jpn.nec.com/soft/oracle/files/gc_1SSDB-MAT-03-09002_NEC_GRIDCenter_16nodeRAC_external_ver2.pdf 97
  83. 98 Copyright © 2020, Oracle and/or its affiliates Oracle •

    Oracle Grid Infrastructure • Oracle Oracle • 1 Oracle OS • OS Oracle Grid Infrastructure : GI GI GI GI GI: Oracle Grid Infrastructure
  84. 99 Copyright © 2020, Oracle and/or its affiliates • RAC

    1 Oracle ( ) • Oracle → → : GI GI GI 1 2 3 GI: Oracle Grid Infrastructure
  85. 100 Copyright © 2020, Oracle and/or its affiliates • •

    • Oracle RAC RAC Oracle
  86. Copyright © 2020, Oracle and/or its affiliates (CPU ) /

    Oracle / 1 Oracle Oracle Real Application Clusters 101
  87. Oracle Automatic Storage Management

  88. • Oracle Database - Oracle Database - - ASM •

    I/O - - • - ( / ) - - - Oracle Automatic Storage Management (ASM) 1 2 3 4 1 2 3 4 4 3 1 2 Copyright © 2020, Oracle and/or its affiliates 103
  89. Copyright © 2020, Oracle and/or its affiliates 104 • ASM

    - ASM ( ) • ASM - ASM LUN • ASM - - • - - • ASM - ASM - • AU( ) - ASM ASM Oracle Automatic Storage Management (ASM) ASM ASM ASM ASM AU( )
  90. Copyright © 2020, Oracle and/or its affiliates 105 ) -

    - - SQL - - ) - INSERT - :
  91. Copyright © 2020, Oracle and/or its affiliates 106 Disk Disk

    • I/O I/O • • Stripe And Mirror Everything (S. A. M. E) ASM
  92. Copyright © 2020, Oracle and/or its affiliates 107 • /

    • IOPS • • (2 /3 ) • • Oracle Automatic Storage Management 1 2 3 4 Disk Disk Disk Disk File 1 2 3 4 Disk Disk Disk Disk 4 3 1 2 #1 Primary Secondary #2 Disk Disk Disk Disk Disk
  93. 108 ASM Oracle DB Oracle DB H/W DB H/W DB

    ASM ASM ASM Copyright © 2020, Oracle and/or its affiliates
  94. Copyright © 2020, Oracle and/or its affiliates 109 - -

    Oracle - - - HDD/ - - / : Oracle Database OS multipath driver device driver Host Bus Adapter storage controller network CPU/memory
  95. Copyright © 2020, Oracle and/or its affiliates 110 • -

    OS - - OS I/O 60 - Exadata - • - Oracle ... - - ASM Oracle Client ASM Database Instance ASM Instance 1 2 3 2 3 1
  96. 111 • Oracle Automatic Storage Management (ASM) • I/O •

    - S.A.M.E:= Disk Disk Oracle Automatic Storage Management : Simple is the BEST Copyright © 2020, Oracle and/or its affiliates
  97. Oracle Data Guard / Active Data Guard

  98. 24 US 91% $10M $350K Source: Gartner, Data Center Knowledge,

    IT Process Institute, Forrester Research 87 → Copyright © 2020, Oracle and/or its affiliates 114
  99. Oracle Database + ROI Oracle Active Data Guard / Data

    Guard DB DB (※) (※) (※) ※Active Data Guard REDO / Copyright © 2020, Oracle and/or its affiliates 115
  100. • • Oracle Database • REDO( ) • • Oracle

    Active Data Guard : Recovery File Recovery File ( ) ( ) ( ) Recovery File Recovery File Copyright © 2020, Oracle and/or its affiliates 116
  101. • - 2 ◦ ( ) ◦ ( ) -

    2 ◦ ( ) ◦ ( ) • / - ( ) - - - - ( )* Data Guard DB DB *Active Data Guard Copyright © 2020, Oracle and/or its affiliates 117
  102. Data Guard Data Guard DB DB NSS/ TT LGWR RFS

    ※ LGWR : NSS : SYNC TT : REDO RFS : MRP : REDO REDO REDO REDO REDO REDO REDO ( ) ( ) MRP Copyright © 2020, Oracle and/or its affiliates 118
  103. ◼ • ◼ • ◼ • ◼ • Data Guard

    (SYNC) (ASYNC) 3. 2. 4. 1. 1. 2. 2. Copyright © 2020, Oracle and/or its affiliates 119
  104. Data Guard • REDO RMAN • REDO SQL • •

    • • • • DB / • Standby-First Patch Apply • • • • ( GoldenGate ) Copyright © 2020, Oracle and/or its affiliates 120
  105. • • Oracle Data Guard • • • • :

    → Copyright © 2020, Oracle and/or its affiliates 121
  106. Data Guard • - SQL - Data Guard Broker(Data Guard

    ) 1 ◦ (FAN) - Enterprise Manger Cloud Control 1 • - : ◦ ( ) ◦ - : ◦ ( ) ◦ ◦ (Fast Start Failover) → → → Copyright © 2020, Oracle and/or its affiliates 122
  107. • • • Oracle Data Guard • (19c DML )

    • • • : Copyright © 2020, Oracle and/or its affiliates 123
  108. ROI Data Guard * * • (READ ONLY) - Active

    Data Guard - 19c DML ( ) - • - - • - - *Active Data Guard Copyright © 2020, Oracle and/or its affiliates 124
  109. Data Guard DR HA / Copyright © 2020, Oracle and/or

    its affiliates 125
  110. FarSync( ) Copyright © 2020, Oracle and/or its affiliates 126

  111. • • Oracle Data Guard/Active Data Guard • • REDO

    • • / • • Copyright © 2020, Oracle and/or its affiliates 127
  112. Oracle GoldenGate

  113. Oracle GoldenGate Copyright © 2020, Oracle and/or its affiliates 132

    • Trail • • • •
  114. Oracle GoldenGate Copyright © 2020, Oracle and/or its affiliates 133

    Data Lake Stream Analytics Data Pipelines Database HA/DR DB OLTP Replication OLTP Data Warehouse
  115. Oracle GoldenGate Copyright © 2020, Oracle and/or its affiliates 134

    Oracle Stream Analytics ETL &ML DBMS Cloud Big Data NoSQL Streams MySQL Database Server Oracle Database IBM Db2 Microsoft SQL Server Cassandra Java Message Service HPE NonStop(Guardian) SAP Sybase ASE IBM Informix SAP Sybase ASE Netezza TERADATA IBM Db2 HPE NonStop (Guardian) Oracle Database MySQL Database Server Microsoft SQL Server IBM Informix Greenplum SAP HANA Elasticsearch MongoDB JDBC JDBC Cloudera Hortonworks Cassandra Oracle NoSQL Java Message Service Oracle Cloud Object Storage MapR Google BigQuery Amazon S3 Amazon Qurora Amazon Kinesis Amazon RedShift Oracle Database Cloud Oracle Autonomous Database Confluent Oracle Autonomous Database Kafka Spark Kafka Kafka Kafka HBase HDFS Snowflake Microsoft Azure Ecosystem HIVE Flink
  116. Oracle GoldenGate – Data Guard Active Data Guard Copyright ©

    2020, Oracle and/or its affiliates 135 • • Data Guard Active Data Guard Oracle GoldenGate OS DB • •
  117. Copyright © 2020, Oracle and/or its affiliates 136 Oracle GoldenGate

    – Data Guard Active Data Guard  REDO     DB (Active Data Guard)  (Active Data Guard)  REDO Trail SQL   OS DB   Active – Active Oracle Active Data Guard (ADG) Oracle GoldenGate (GG) ※Oracle GoldenGate Oracle Active Data Guard
  118. Oracle Advanced Security

  119. 138 Data Redaction • ( ) • • • Oracle

    Advanced Security Redacted Applications Data Redaction XXXX-XXXX-4368 Disks Exports Backups Transparent Data Encryption Encrypted Storage d$f8#;!90Wz@Yg#3 Copyright © 2020, Oracle and/or its affiliates
  120. Copyright © 2020, Oracle and/or its affiliates 139 • •

    • • • (TDE) Disks Exports Backups Transparent Data Encryption Encrypted Storage d$f8#;!90Wz@Yg#3
  121. (TDE) DB ID Name Salary 1 John $100,000 2 Bill

    $200,000 3 Kevin $50,000 4 Susan $300,000 ID Name Salary Ko W(KS -7j_ Nu u/eED l=.d9 A9 k7<: “gxjm F) Lc<= ‘a}41 Copyright © 2020, Oracle and/or its affiliates 140
  122. 141 Data Redaction DB AP 2172-9841-4368 XXXX-XXXX-4368 DB 2172-9841-4368 XXXX-XXXX-4368

    2172-9841-4368 6342-4881-5211 3311-0090-5055 DB Copyright © 2020, Oracle and/or its affiliates
  123. Oracle Database Vault

  124. Oracle Database Vault Copyright © 2020, Oracle and/or its affiliates

    144 (SYS, DBA ) Multitenant Architecture (IP ) SELECT * FROM customers ( )
  125. Copyright © 2020, Oracle and/or its affiliates 145 Oracle Database

    Vault DB =8:00 19:00 = IP = xxxxx • • DB • • • IP •
  126. Copyright © 2020, Oracle and/or its affiliates 146 Multitenant Architecture

    Database Vault Oracle Database SYS SYS PDB2 PDB1 SYS SYSTEM CDB Database Vault PDB CDB SYS Database Vault ON Database Vault OFF CDB PDB PDB PDB CDB SYS PDB
  127. Copyright © 2020, Oracle and/or its affiliates 147 Database Vault

    • (DBA_DV_SIMULATION_LOG ) HR HR APP BI tool
  128. Oracle Audit Vault and Database Firewall

  129. Copyright © 2020, Oracle and/or its affiliates 149 ? NAMES

    ADDRESSES CREDIT CARDS HEALTH RECORD OTHER PII SECRETS / / Test Dev
  130. Copyright © 2020, Oracle and/or its affiliates 150 Maximum Security

    Architecture Audit Data & Event Logs Centrally Managed Users Enterprise User Security Audit Vault Alerts Reports Policies Network Encryption Oracle Key Vault Transparent Data Encryption DF11233 U*1 $5Ha1qui %H1 HSKQ112 A14 FASqw34 £$1 DF@£!1ah HH! DA45S& DD1 Privilege Analysis Discover Sensitive Data Identify Users and their Entitlements Database Security Assessment Tool Assess Overall Security Data Masking and Subsetting Test Dev Data Redaction Database Vault Users Applications Database Firewall Virtual Private Database Label Security Real Application Security Strong Authentication Events Database Security Controls Data Driven Security Detect Prevent Evaluate
  131. 151 Copyright © 2020, Oracle and/or its affiliates SQL Oracle

    Audit Vault and Database Firewall • Oracle Solaris • Oracle Linux • Red Hat Enterprise Linux • IBM AIX on Power Systems • Microsoft Windows Server Database Firewall Operating Systems Databases Audit Vault Server • Oracle Database • MySQL • IBM DB2 • Microsoft SQL Server • SAP Sybase ASE SQL SQL SQL
  132. 152 Copyright © 2020, Oracle and/or its affiliates • OS

    • • • • Audit Vault Server Operating Systems Databases Audit Vault Server
  133. 153 Copyright © 2020, Oracle and/or its affiliates • OS

    • OS • Database Firewall Server Audit Vault Agent • Audit Vault Agent • CSV HTML PDF Excel • Syslog SNMP S/W, H/W • Enterprise Manager Plug-in • Active-Standby Audit Vault Server Audit Vault Server
  134. 154 Copyright © 2020, Oracle and/or its affiliates • •

    • SQL • / SQL Database Firewall Server Database Firewall Server Databases Audit Vault Server
  135. 155 Copyright © 2020, Oracle and/or its affiliates • OS

    • OS • • - • - • Out-of-band - SQL Database Firewall Server Database Firewall Server Out-of-band
  136. Oracle Real Application Testing

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

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

    • • DBA Real Application Testing (RAT) DBA
  139. Copyright © 2020, Oracle and/or its affiliates 159 Real Application

    Testing (RAT) SPA SPA SPA = SQL Performance Analyzer ▪ ▪ • SQL • SQL • Oracle Cloud • DBA
  140. Copyright © 2020, Oracle and/or its affiliates 160 SQL SQL

    • • SQL SQL SQL • SQL SQL SQL • Oracle Enterprise Manager SQL (SPA)
  141. Copyright © 2020, Oracle and/or its affiliates 161 SQL :

    AP DB / SQL SQL SQL ( ) ( ) SQL Tuning Set: SQL ( ) ( ) STS STS
  142. Copyright © 2020, Oracle and/or its affiliates 162 • -

    DB - OS HW DB - - - SQL SQL - (PDB) SQL :
  143. Copyright © 2020, Oracle and/or its affiliates 163 SPA •

    • 1 SQL DBA • Oracle Enterprise Manager Cloud Control SPA DBA SPA … … • HW • • … • • • •
  144. Copyright © 2020, Oracle and/or its affiliates 164 • •

    alter session • SQL • SQL ( SQL ) SQL SPA :
  145. Copyright © 2020, Oracle and/or its affiliates 165 • •

    • ( Exadata)
  146. Copyright © 2020, Oracle and/or its affiliates 166 : CPU

    3 ~ 5% DB / AP DB /
  147. Copyright © 2020, Oracle and/or its affiliates 167 • •

    - - - • - DML - SELECT • • AWR • ASH :
  148. Copyright © 2020, Oracle and/or its affiliates 168 : =

    DB AP AP + DB DB DB
  149. Copyright © 2020, Oracle and/or its affiliates 169 • AWR

    • EM • • ( ) • • Exadata Oracle Cloud
  150. Copyright © 2020, Oracle and/or its affiliates 170 CRM DB1

    HCM DB2 DWH DB3 Windows DB 11gR2 AIX DB 11gR2 HP-UX DB 12cR2 Capture 1 Capture 2 Capture 3 5 31 6 15 6 18 ETL Capture 1 Capture 2 Capture 3
  151. Oracle Data Masking and Subsetting

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

    • • • • Oracle Data Masking and Subsetting Pack 01001011001010100100100100100100 10010010010010001001010100100100 10011100100100100100100100001001 00101110010010101001001010101001 10101001010100100000011111111000 SSN 463-62-9832 3715-4691-3277-8399 SSN 463-62-9832 576-40-7056 518-12-6157 281-50-3106 3715-4691-3277-8399 5136-6247-3878-3201 3599-4570-2897-4452 5331-3219-2331-9437 / 555-12-1234 5555-5555-5555-4444
  153. Copyright © 2020, Oracle and/or its affiliates 173 Data Masking

    • Oracle Database •
  154. Copyright © 2020, Oracle and/or its affiliates 174 • •

    • PL/SQL E-Business Suite Fusion Applications Data Masking
  155. Copyright © 2020, Oracle and/or its affiliates 175 Data Masking

    Country Identifier CA 226-956-324 US 610-02-9191 UK JX 75 67 44 C Country Identifier CA 368-132-576 US 829-37-4729 UK AI 80 56 31 D Emp ID First Name 324 Albert 986 Hussain Emp ID First Name 324 Charlie 986 Murali Emp ID First Name 324 Charlie 986 Murali Company Closing Price IBFG $36.92 XKJU ¥789.8 Company Closing Price IBFG $89.57 XKJU ¥341.9 BLOB 3178973456 6509876745 Search : [0-9]{10} Replace : * BLOB ********** ********** BLOB ID COUNTRY 1 US 2 JP 3 US 4 UK 5 FR ID COUNTRY 1 US 2 FR 3 UK 4 JP 5 US Country (Country UK [ ][ ][6 ][ ])
  156. Copyright © 2020, Oracle and/or its affiliates 176 • :

    ( 1TB 100GB ) • : Where Data Subsetting 100% 100M Rows 20% 20M Rows 2% 2M Rows 条件: DepartmentID=10 Where
  157. Oracle Advanced Analytics

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

    Database DB • • ( / ) • • ML DB • DB • • • / Oracle Advanced Analytics Oracle Data Mining (Oracle Machine Learning for SQL) Oracle R Enterprise (Oracle Machine Learning for R)
  159. RDBMS 分析 分析 180 Copyright © 2020, Oracle and/or its

    affiliates
  160. Oracle Advanced Analytics Model “Scoring” Embedded Data Prep Data Preparation

    Model Building Oracle Advanced Analytics Secs, Mins or Hours Traditional Analytics Hours, Days or Weeks Data Extraction Data Prep & Transformation Data Mining Model Building Data Mining Model “Scoring” Data Prep. & Transformation Data Import TCO 削減 • • Oracle Database • GUI TCO • • • Oracle Database 181 Copyright © 2020, Oracle and/or its affiliates
  161. 182 Copyright © 2020, Oracle and/or its affiliates

  162. Oracle Advanced Analytics (Classification) (Decision Tree) (2 ) (GLM) (Naïve

    Bayes) (Random Forest) (SVM) (ESA) (Clustering) (EM) k (k-means) (O-Cluster) (Time Series) ( , 2 Holt-Winters Regular & Irregular, with and w/o trends & seasonal ) (Regression) (LM) (GLM) (SVM) (Abnormally Detection) 1 SVM (Association Rules) Apriori/ (Attribute Importance) (Minimum Description Length) CUR KL (Feature Extraction) (ESA) Non-Negative Matrix Factorization (NMF) (SVD) (PCA) Pair-wise KL Div (Predictive Queries) (Statistical Functions) t F (ANOVA) SQL A1 A2 A3 A4 A5 A6 A7 183 Copyright © 2020, Oracle and/or its affiliates
  163. Copyright © 2020, Oracle and/or its affiliates 184 Oracle Machine

    Learning Notebook Notebook WebUI • Oracle Autonomous Database Notebook SQL • • • SQL PL/SQL Oracle Data Miner GUI • Oracle Database Oracle SQL Developer • GUI • • • ETL GUI Oracle Advanced Analytics
  164. • / • • • R • • R(CRAN) •

    Oracle Database • 12 • • Oracle Data Miner(SQL Developer ) GUI • PL/SQL API Java API • Oracle Database Oracle Advanced Analytics Oracle Data Mining(Oracle Machine Learning for SQL) Oracle R Enterprise(Oracle Machine Learning for R) 185 Copyright © 2020, Oracle and/or its affiliates
  165. Copyright © 2020, Oracle and/or its affiliates 186 • •

    • • • Oracle Data Mining : DBMS Oracle Data Mining (Oracle Machine Learning for SQL)
  166. Copyright © 2020, Oracle and/or its affiliates 187 R •

    R - Oracle Database R - DB • R • R R • • R • Oracle R Enterprise (Oracle Machine Learning for R)
  167. Copyright © 2020, Oracle and/or its affiliates 188 Oracle R

    Oracle R Distribution (ORD) R • Oracle R • - R Oracle • Linux Intel Math Kernel Library (SPARC Sun Performance Library) ORD https://www.oracle.com/database/technologies/r-distribution.html Oracle R Distribution (ORD) Oracle R
  168. Copyright © 2020, Oracle and/or its affiliates 189 Oracle R

    Enterprise(Oracle Machine Learning for R) R Engine R Engine R Engine Other R packages R DB Oracle R Enterprise packages R Engine Oracle R Enterprise packages SQL R DB R Other R packages R • R Oracle Database • R Oracle Database • R SQL • Oracle Database • Oracle Database Oracle Database R • R • SQL PL/SQL R DB Oracle DB ✓ DB ✓ DB DB
  169. • • OSS R 40 1 • ( ) https://blogs.oracle.com/dbjp/oracle-advanced-analytics-v2

    • http://www.nssol.nssmc.com/press/2014/20140529_110000.html ORE Oracle Advanced Analytics 190 Copyright © 2020, Oracle and/or its affiliates
  170. Oracle Spatial

  171. Copyright © 2020, Oracle and/or its affiliates 195 Oracle Spatial

    Oracle DB • • SQL • Partition Oracle DB • • • • • Raster D KML • Oracle 12c GIS • Autodeck : MapGuide/OnSite • ESRI ArcGIS/ArcView • GE Smallworld
  172. 196 • • / • .. • R-Tree • Oracle

    / • Spatial Vector Acceleration(SVA) • SQL • DB SQL Spatial Features 250 • • • D TIN GeoDatabase • • • • SVA SQL • • 190 • • ( ) Copyright © 2020, Oracle and/or its affiliates
  173. SQL Oracle Database Spatial features Topologies 3D / LiDAR Raster

    Networks Polygons Lines Points Location Tracking (Geofencing) SELECT a.customer_name, a.phone_number FROM policy_holders a WHERE sdo_within_distance( a.geom, hurricane_path_geom, ‘distance = 10 unit = mile’) = ‘TRUE’; Spatial Analysis Through SQL Copyright © 2020, Oracle and/or its affiliates 197
  174. Big Data SQL

  175. Oracle SQL Oracle Big Data SQL Oracle Database Kafka NoSQL

    Hadoop Object Storage Oracle Big Data SQL Any SQL Client HDFS NoSQL Kafka Object Storage Oracle SQL Smart Scan Copyright © 2020, Oracle and/or its affiliates 202
  176. 203 HDFS Big Data SQL Oracle Database • SQL Java

    • OracleDB • HDFS NoSQL Read • Oracle SQL - - - Hadoop Cluster Data Node BDSQL Data Node BDSQL Data Node BDSQL Data Node BDSQL Hive Metadata Object Stores Kafka NoSQL Python Graph R node.js Java REST SQL Oracle Database + Big Data SQL Copyright © 2020, Oracle and/or its affiliates
  177. Copyright © 2020, Oracle and/or its affiliates 204 Oracle Database

    Big Data SQL Security Features Hadoop Security ACL’s | Sentry | HDFS Encryption | Encryption in Motion • •
  178. Copyright © 2020, Oracle and/or its affiliates 205 Big Data

    SQL Oracle Big Data Appliance Oracle Exadata DIY Cloudera or Hortonworks Oracle Database 18c Object Store Autonomous Database Oracle Coming soon! Big Data Service Engineered Systems IA * Big Data SQL 4.0 = Oracle Database 18c * Big Data SQL 3.2.x = Oracle Database 12.1 , 12.2 * Oracle Big Data SQL Master Compatibility Matrix ( ID 2119369.1)
  179. 206 Oracle Database HDFS SQL Query Server Query Server •

    Oracle Database • • HDFS Kafka Object Storage , NoSQL BDS SQL • • Cloudera Manager , Ambari Hadoop Cluster Data Node BDSQL Data Node BDSQL Data Node BDSQL Data Node BDSQL Hive Metadata Edge Node BDSQL Query Server Object Stores Kafka NoSQL Python Graph R node.js Java REST SQL Copyright © 2020, Oracle and/or its affiliates
  180. 207 Query Server Oracle Database 18c + Big Data SQL

    Query Server SQL Support Oracle SQL Oracle SQL Oracle Database 4.0: 18c 3.2.x: 12.1, 12.2 N/A (database included) Oracle Database Supported Not supported Hive Metadata (+ tooling) HDFS + Sentry + Oracle DB Advanced Policies HDFS + Sentry Data Nodes + Oracle DB 18c Data Nodes + Edge Node Hadoop OracleDB Hadoop DB Query Server) Copyright © 2020, Oracle and/or its affiliates
  181. None