Oracle Direct Seminar <Insert Picture Here> IT
Agenda 1. Oracle RAC on Oracle VM 2. Oracle Database 11gR2 3. Oracle Exadata <Insert Picture Here> Oracle Direct Concierge SQL Server MySQL PostgreSQL Access Oracle Database Oracle Developer/2000 Web Oracle Oracle Database http://www.oracle.com/lang/jp/direct/services.html Copyright Oracle Corporation Japan, 2009. All rights reserved. 2
Copyright Oracle Corporation Japan, 2009. All rights reserved. 3
C/S MVS, OS/390 Server : Unix, RDBMS Client : Windows, Excel, VB Web Java Web ASP SaaS PaaS IaaS IBM Oracle Microsoft Informix Sybase IBM Oracle BEA Systems IBM Microsoft Oracle IBM Microsoft Google Salesforce.com Amazon DB Requirement Oracle Oracle Database 7 Copyright Oracle Corporation Japan, 2009. All rights reserved. 4
Private Cloud Private Cloud 1 2 3 Copyright Oracle Corporation Japan, 2009. All rights reserved. 5
Tokyo Osaka Sydney China Data Warehouse Sales Application Financial Application SCM Application Custom Application Application Server Grid Scale Out Database Grid Storage Grid DB Copyright Oracle Corporation Japan, 2009. All rights reserved. 6
Tokyo Osaka Sydney China Data Warehouse Sales Application Financial Application SCM Application Custom Application Application Server Grid Scale Out Database Grid Storage Grid DB Copyright Oracle Corporation Japan, 2009. All rights reserved. 7
Copyright Oracle Corporation Japan, 2009. All rights reserved. 8
DB DB Copyright Oracle Corporation Japan, 2009. All rights reserved. 9
Data Warehouse Sales Application Financial Application SCM Application Custom Application Application Server Grid Database Grid Enterprise Manager Storage Grid Copyright Oracle Corporation Japan, 2009. All rights reserved. 10
Oracle Corporation Global Single Instance 1. IT 2. 3. Copyright Oracle Corporation Japan, 2009. All rights reserved. 11
/ 2006 / DB AP 50 RAC RAC RAC RAC RAC RAC RAC RAC 100 100 8 Oracle GRID 1 1 / 1000 Oracle Enterprise manager Copyright Oracle Corporation Japan, 2009. All rights reserved. 12
Oracle Database 11g Oracle Database 11g Oracle Clusterware Oracle Automatic Storage Management 1 / Oracle Real Application Clusters 11g I/O Automatic Storage Management (ASM) Copyright Oracle Corporation Japan, 2009. All rights reserved. 13
IT http://www.itmedia.co.jp/enterprise/articles/0907/24/news010.html Copyright Oracle Corporation Japan, 2009. All rights reserved. 14
1. Oracle RAC on Oracle VM Copyright Oracle Corporation Japan, 2009. All rights reserved. 15
Copyright Oracle Corporation Japan, 2009. All rights reserved. 16
Oracle Real Application Clusters RAC RAC RAC RAC RAC RAC RAC RAC RAC 1 DB Copyright Oracle Corporation Japan, 2009. All rights reserved. 17
RAC / GRID 2.0 Copyright Oracle Corporation Japan, 2009. All rights reserved. 18
Oracle VM Oracle Oracle Fusion Oracle Non-Oracle Non-Oracle Database Middleware Applications Applications Applications Oracle Enterprise Linux Oracle Enterprise Linux Oracle Enterprise Linux Oracle or Red Hat Enterprise Linux Microsoft Windows Oracle VM Xen Oracle Xen Oracle Copyright Oracle Corporation Japan, 2009. All rights reserved. 19
Oracle VM Oracle Linux WindowsOS OS 3264 64CPU SMP 1OS 32CPU PV HV VM Copyright Oracle Corporation Japan, 2009. All rights reserved. 20
Oracle VM Oracle Database Oracle Application Server Oracle Enterprise Manager Oracle Berkeley DB Oracle TimesTen Oracle E-Business Suite Oracle PeopleSoft Oracle Siebel Oracle Hyperion Note#464754.1 Copyright Oracle Corporation Japan, 2009. All rights reserved. 21
Oracle VM HW / TCO Oracle Database Fusion Middleware Oracle Applications Non-Oracle Applications Non-Oracle Applications Oracle Enterprise Linux Oracle Enterprise Linux Oracle Enterprise Linux Oracle or Red Hat Enterprise Linux Microsoft Windows Oracle VM Resource: 75% Copyright Oracle Corporation Japan, 2009. All rights reserved. 22
VM OS H/W OS OS / OS RAC DB Oracle DB OS RACH/W IT Copyright Oracle Corporation Japan, 2009. All rights reserved. 23
Oracle Real Application Clusters on Oracle VM 2 ex) Oracle Real Application Clusters ex) Oracle VM, VMware, Hyper-V Copyright Oracle Corporation Japan, 2009. All rights reserved. 24
Oracle Real Application Clusters on Oracle VM 22RAC Copyright Oracle Corporation Japan, 2009. All rights reserved. 25
DB-3 RAC 3 DB-3 DB-3 DB-3 DB-2 RAC 2 DB-2 DB-2 DB-2 DB-1 RAC 1 DB-1 DB-1 DB-1 VM Oracle VM Oracle VM Oracle VM 1 2 3 1 Copyright Oracle Corporation Japan, 2009. All rights reserved. 26
DB-3 DB-3 RAC 3 DB-3 DB-3 DB-2 DB-2 RAC 2 DB-2 DB-2 DB-1 DB-1 RAC 1 DB-1 DB-1 VM Oracle VM Oracle VM Oracle VM 1 2 3 1 1 Copyright Oracle Corporation Japan, 2009. All rights reserved. 27
2. Oracle Database 11gR2 Copyright Oracle Corporation Japan, 2009. All rights reserved. 28
Oracle Database Oracle Database 11g 1992 Oracle7 1997 Oracle8 1999 Oracle8i Built in Messaging Object Relational Support Multimedia Support Data Warehousing Optimizations Parallel Operations Distributed SQL & Transaction Support Cluster and MPP Support Multi-version Read Consistency Client/Server Support Platform Portability Commercial SQL Implementation 2001 Oracle9i 2007 2004 Oracle Database 10g XML Database Oracle Data Guard Real Application Clusters Flashback Query Virtual Private Database Built in Java VM Partitioning Support In-Memory DB Cache Total Recall Real Application Testing Active Data Guard Advanced Compression Database Vault Grid Computing Automatic Storage Management Self Managing Database 1977 2009 Copyright Oracle Corporation Japan, 2009. All rights reserved. 29
Oracle Database 11g R2 Lowering IT Costs IT 5 1 2 Copyright Oracle Corporation Japan, 2009. All rights reserved. 30
Oracle Database 11g R2 Oracle Database 11g R2 Copyright Oracle Corporation Japan, 2009. All rights reserved. 31
Oracle Database 11g R2 5 1. 2. 3. 4. 5. Real Application Clusters Oracle Grid Infrastructure RAC One Node Automatic Storage Management In-Memory Parallel Query Online Application Upgrade Copyright Oracle Corporation Japan, 2009. All rights reserved. 32
DB RAC Clusterware RAC RAC Clusterware Oracle Grid Infrastructure ASM RAC RAC Clusterware ASM Copyright Oracle Corporation Japan, 2009. All rights reserved. 33
1. Real Application Clusters Oracle Grid Infrastructure Server Pool CRM DWH DWH Server Server Pool Pool Server Server Pool Pool Server Pool Real Application Real Application Clusters Clusters Real Application Real Application Clusters Clusters Oracle Clusterware Oracle Grid Infrastructure Automatic Storage Management Real Application Clusters Copyright Oracle Corporation Japan, 2009. All rights reserved. 34
2. RAC One Node RAC One Node RAC One Node 1 RAC Oracle Grid Infrastructure RAC 2 Copyright Oracle Corporation Japan, 2009. All rights reserved. 35
2. RAC One Node DB RAC One Node DB DB1 OS VM DB2 OS VM DB3 OS VM DB RAC One Node 3 RAC One Node DB1 DB2 DB3 Oracle Grid Infrastructure A Hypervisor B OS A OS B Copyright Oracle Corporation Japan, 2009. All rights reserved. 36
3. ASM Automatic Storage Management ASM ASM ASM DB DB ( A) ( A) REDO ( B) ( A) REDO ( B) ( A) Automatic Storage Management ASM ASM ASM Stripe & Mirror Copyright Oracle Corporation Japan, 2009. All rights reserved. 37
3. ASM ASM Cluster File System(ACFS) 11g R1ASM ASM Cluster Files System (ACFS) ASM Automatic Storage Management ASM Oracle DB Automatic Storage Management ACFS Oracle DB Copyright Oracle Corporation Japan, 2009. All rights reserved. 38
4. In-Memory Parallel Query CPU UNIXSMP IA IA CPU IACPU Copyright Oracle Corporation Japan, 2009. All rights reserved. 39
4. In-Memory Parallel Query 3 CPU In-Memory Parallel Query + + RAC 3 IA1TB In-Memory Parallel Query Real Application Clusters 2CPU 2CPU 2CPU 8 8CPU 2GB >100GB 400GB 100GB >100GB 1.2TB >100GB 4 1 400GB 1.2TB Copyright Oracle Corporation Japan, 2009. All rights reserved. 40
5. Online Application Upgrade DB V11.0.1 V11.0.2 () V11.0.2 DB V11.0.1 V11.0.2 (DB ) DB V11.0.2 DB DB DB V11.0.1 DB V11.0.2 DB () V11.0.1 V11.0.1 DB DB DB V11.0.2 V11.0.2 Copyright Oracle Corporation Japan, 2009. All rights reserved. 41
3. Oracle Exadata Copyright Oracle Corporation Japan, 2009. All rights reserved. 42
Oracle Exadata Oracle Database Smart Scan-I/O Storage Index I/O InfiniBand I/O Grid Infrastructure RAC, ASM Smart flash cacherandom I/O 1/50 DBMAA Maximum Availability Architecture RAC, Data Guard DB, AP Copyright Oracle Corporation Japan, 2009. All rights reserved. 43
Oracle Exadata Oracle Exadata 30DB Oracle Database IT I/O Oracle Exadata DB i g DB 11gR2 6 I/O 92 97 99 01 03 06 08 Copyright Oracle Corporation Japan, 2009. All rights reserved. 44
Oracle Exadata I/O Oracle Exadata / DB CPU / IO IO I/O I/O DB InfiniBand Smart Scan DB InfiniBand (40Gb/s) V2 New Hybrid Columnar Compression V2 New Storage Index I/O V2 New Smart Flash Cache I/O Copyright Oracle Corporation Japan, 2009. All rights reserved. 45
Oracle Exadata Exadata Oracle Exadata Exadata Oracle Exadata XML XBRL) EDINET, TDNET DWH Exadata Copyright Oracle Corporation Japan, 2009. All rights reserved. 46
Best Consolidation Machine DB ERP CRM Warehouse Data Mart HR 11gR2 New DWH OLTP Oracle Exadata And predictable response times GRID Infrastructure Copyright Oracle Corporation Japan, 2009. All rights reserved. 47
Oracle Exadata Quarter Rack Half Rack Full Rack Database Server Sun Fire X4170 Oracle Database server 2 (Xeon 2.53GHz x4 16 ) 4 (Xeon 2.53GHz x8 32 ) 8 (Xeon 2.53GHz x16 64 ) Storage Server Exadata Storage Server (SAS) 3 (600GB SAS Disks x12)x3 7 (600GB SAS Disks x12)x7 14 (600GB SAS Disks x12)x14 InfiniBand Switch Sun Datacenter InfiniBand Switch 36 2 (36port QDR(40Gb/sec)x2) 2 (36port QDR(40Gb/sec)x2) 3 (36port QDR(40Gb/sec)x3) Storage Server (SAS) 21TB 50TB 100TB Copyright Oracle Corporation Japan, 2009. All rights reserved. 48
Copyright Oracle Corporation Japan, 2009. All rights reserved. 49
Oracle Database DB SQL OLTP DWH Copyright Oracle Corporation Japan, 2009. All rights reserved. 50
DB 3rd Party S/W SQL H/W DB OLTP DB DB DWH Oracle Copyright Oracle Corporation Japan, 2009. All rights reserved. 51
Oracle Direct Oracle Direct IT / Web 0120 155 096 ~9:00~12:00 13:00~18:00 Copyright Oracle Corporation Japan, 2009. All rights reserved. 52
Oracle Direct Seminar 100Wendy2010 11 12 2!! a.b.c.d. a,b,c,d http://www.oracle.com/technology/global/jp/membership/index.html ORD_SEMINAR_JP@ORACLE.COM 2009 11 12 Oracle Direct Copyright Oracle Corporation Japan, 2009. All rights reserved. 53
OTN!! Oracle Technology Network(OTN) http://otn.oracle.co.jp/forum/index.jspa?categoryid=2 OTN OTN Oracle100% Copyright Oracle Corporation Japan, 2009. All rights reserved. 54
IT Oracle Direct Concierge BI IT BI Access / SQL Server MySQL / PostgreSQL Oracle Database Oracle Developer Web RFP BI Oracle Oracle Database Copyright Oracle Corporation Japan, 2009. All rights reserved. 55
Oracle PeopleSoft JD EdwardsSiebel Copyright Oracle Corporation Japan, 2009. All rights reserved. 56