创新的数据库技术OracleDatabase12c

1、Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted1创新的数据库技术创新的数据库技术Oracle Database 12c 齐琨()资深解决方案咨询顾问Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted2Safe Harbor StatementThe following is inte

2、nded to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, a

3、nd timing of any features or functionality described for Oracles products remain at the sole discretion of Oracle.Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted3日程日程介绍Oracle Database 12c创新助力合作伙伴与合作伙伴一同创新Copyright 2013, Oracle and/or its affili

4、ates. All rights reserved.Oracle Confidential Highly Restricted4介绍介绍Oracle Database 12cCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted5Oracle历年持续创新历年持续创新Self-Service ProvisioningMetering and ChargebackConsolidation PlanningApplication Continuit

5、yMultitenant DatabaseCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted6今天的私有数据库架构今天的私有数据库架构使用Oracle Database 11g集群共享服务器和OS虚拟机共享服务器Schema整合共享服务器、OS和数据库Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Res

6、tricted7传统的非传统的非CDB架构架构每个数据库需要独立的内存和进程ERP数据数据库库文件文件内存使用内存使用后台后台进进程程CRM数据数据库库文件文件后台后台进进程程内存使用内存使用DW数据数据库库文件文件后台后台进进程程内存使用内存使用Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted8全新全新 DB12c 多租期数据库架构多租期数据库架构内存和进程仅在容器级使用ERPCRMDW后台进程后台进程内存使用内存使用容器数据库容器数据

7、库CDBCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted9全新全新 DB12c 私有数据库架构私有数据库架构专用数据库共享服务器和操作系统虚拟机共享服务器多租期数据库共享服务器、OS和数据库整合度提高整合度提高使用 Oracle Database 12cCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly R

8、estricted10架构对比架构对比业务价值业务价值虚拟机虚拟机专用专用多租期多租期实施容易容易容易适用的应用范围一些场景所有场景所有场景隔离程度最高高高可用性高最高最高扩展性受限优秀优秀性能受限全部全部整合密度低高最高ROI投资回报率投资回报率低低高高最高最高Oracle 多租期: 最好的整合度, 最大的ROICopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted11Database 12c中的新特性中的新特性提供的价提供的价值值新特性新特

9、性/功能功能适用适用场场景景管理新的数据源数据库内部Map Reduce / 模式匹配大数据和分析存储优化处理爆发性数据热图,自动数据优化 (ADO) 确保业务持续性应用持续,远程同步,全局数据服务高可用性阻止数据泄漏数据遮蔽,权限分析,数据掩码数据安全提高操作效率整合重放, DaaS, 快照克隆管理性更低的成本和灵活的收益多租期选件数据整合/私有云Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted12数据库整合和数据库云服数据库整合和数据

10、库云服务务DBaaSv与您一同创新与您一同创新 #1Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted13新特性新特性? 真正的数据库虚拟化 下一代数据库 整合和云的最佳平台数据库选件数据库选件: Oracle多租期(全新) 业务机会业务机会: 数据库整合 Database-as-a-Service 企业云的主动提供客户收益客户收益: 每个服务器支持更多的应用 更少的硬件需求 更大的灵活性 易于管理DW数据库整合和数据库整合和DBaaSCo

11、pyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted14操作系统级服务器池(server pool)数据库级Schema ERPDWCRM PDB PDB PDBCCOAHCMOSOSOSOSPDBSchemaSchemaSchemaSchemaSchemaOracle Database CloudOracle 数据库云架构 12c可插拔、多租户架构 CDB SchemaSchemaSchemaSchema数据库级虚拟化Pluggable Dat

12、abaseCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted15多租户-可插拔数据库创建可插拔数据库RootEmptyERPEmptyDWEmptyCRMPDB SEED 可以快速为每个需整合的数据库创建一个空PDBCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted16SQL SET T

13、IMING ONSQL create pluggable database c01p01p2 admin user app_Admin identified by pwd3 file_name_convert = (/pdbseed/, /c01p01p/)4 /Pluggable database created.Elapsed: 00:00:57.11SQL alter pluggable database c01p01p open;Pluggable database altered.SQL alter pluggable database all open;Pluggable data

14、base altered.多租户-可插拔数据库 创建Pluggable Database举例Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted17SQL alter pluggable database c01p01p close;Pluggable database altered.SQL drop pluggable database c01p01p including datafiles;Pluggable database drop

15、ped.多租户-可插拔数据库 删除Pluggable Database举例Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted18多租户-可插拔数据库Fast Cloning和SnapshotsRootERPPDB COPY1 PDB SEED 在单个容器数据库(CDB)内克隆PDB非常简单 在克隆PDB过程中擦除或掩盖数据非常容易 克隆PDB过程甚至快于文件系统拷贝ERPPDB COPY2 ERP PDBCopyright 2013, Or

16、acle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted19SQL alter pluggable database C01P01P close ;Pluggable database altered.SQL alter pluggable database C01P01P open read only ;Pluggable database altered.SQL SET TIMING ONSQL create pluggable database C01P02P2 from C

17、01P01P3 file_name_convert = (/c01p01p, /c01p02p)4 /Pluggable database created.Elapsed: 00:00:31.90SQL alter pluggable database C01P02P open ;多租户-可插拔数据库Fast Cloning举例Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted20大数据大数据, 数据仓库数据仓库, 分析分析v与您一同创新与

18、您一同创新 #2Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted21新特性新特性? 数据库内的MapReduce能力 Java 和SQL 接口 行级模式匹配 R 统计分析数据库选件和产品数据库选件和产品: 高级分析 Oracle NoSQL Oracle Big Data Appliance业务机会业务机会: 客户细分 客户业务增长 威胁检测 语义分析 客户收益客户收益: 从数据获取业务价值 预测 (更好的计划)大数据大数据, 数据仓库和

19、分析数据仓库和分析191319日股票价格数据存储数据存储表对象视图外部表ReducerTable ReaderTable WriterOracle JVMMapperTable ReaderTable WriterOracle 数据库数据库SQLSQL 结果SQL 查询Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted22高级分析选件的使用场景高级分析选件的使用场景为正确的客户提供正确的目标发现隐藏的客户细分发现最合适的销售机会预计客户的变

20、动360度全方位客户机会发现安全和可疑活动检测理解客户调查中的语义减少医疗差错 ，改善健康质量理解社交网络的影响力Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted23存储优化存储优化v与您一同创新与您一同创新 #3Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted24新特性新特性? 数

21、据访问跟踪 自动化, 基于策略的压缩和数据分层数据库选件数据库选件: 高级压缩业务机会业务机会: 大型数据库 数据增长带来的成本,性能等存储问题 存储分层 客户收益客户收益: 高效管理增长的数据 实时和交互处理数据存储优化存储优化活动数据活动数据频繁访问数据频繁访问数据偶尔访问偶尔访问休眠数据休眠数据ORDERSCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted25Oracle 存存储储厂商厂商磁磁盘节盘节省省大量大量节节省省部分部分性能性

22、能加速加速查询查询增加支出增加支出数据数据库库集成集成深度集成深度集成排除排除维护维护任任务务包括内存包括内存访问访问集成集成RMAN 和和Active DataGuard零集成零集成维护维护任任务务要考要考虑虑数据的数据的实时访问实时访问自动数据优化的优势Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted26信息生命周期管理命令举例ALTER TABLE sales_ado ILM ADD POLICY ROW STORE COMPRES

23、S ADVANCED ROW AFTER 30 DAYS OF NO MODIFICATION;ALTER TABLE salesILM ADD Move PolicyTIER Partitions TO Archive_TBSON OrdersClosedPolicy;Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted27高可用性和数据保护高可用性和数据保护v与您一同创新与您一同创新 #4Copyright 2013, Oracle an

24、d/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted28PrimaryStandbyASYNCSYNCFar sync standby远距离Data guard保证零数据丢失 Far Sync Standby 当Standby距离很远，可以在Primary本地启用轻量级redo复制 同样将redo压缩和redo多地址服务传输压力卸载到本地 透明Switch over和FailoverCopyright 2013, Oracle and/or its affiliates. All right

25、s reserved.Oracle Confidential Highly Restricted29新特性新特性? 远程standby数据库0数据丢失 负载均衡 复制DB的Failover数据库选件数据库选件: Active Data Guard GoldenGate业务机会业务机会: 关键任务应用 客户分布在全球 数据中心分布在全球 MAA扩展客户收益客户收益: 业务持续性 数据保护 高可用和数据保护高可用和数据保护PrimaryFar SyncInstance(Active)Far SyncInstance(Idle)syncasyncGlobal Data ServicesCopyrig

26、ht 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted30需求需求Oracle MAA其他其他数据丢失0数据丢失 Data Guard有限的0数据丢失(例如，同步镜像，有限保护)恢复时间秒级 RAC, Data Guard, GoldenGate小时级成本 (ROI)不需要额外空闲冗余设备 RAC, Data Guard, Golden Gate空闲冗余总结总结高可用性和数据保护Copyright 2013, Oracle and/or its affili

27、ates. All rights reserved.Oracle Confidential Highly Restricted31数据安全数据安全v与您一同创新与您一同创新 #5Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted32新特性新特性? 动态遮蔽数据 敏感数据发现 为测试系统提供安全 数据库选件数据库选件: Data Masking Advanced Security业务机会业务机会: 呼叫中心 决策支持 PII, PHI, PC

28、I Data客户收益客户收益: 符合法律合规性要求 阻止数据威胁和滥用 移动数据上提供数据安全数据安全数据安全Soc. Sec. #115-69-3428DOB11/06/71PIN5623敏感数据遮蔽敏感数据遮蔽策略策略Call Center OperatorPayroll ProcessingCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted33数据掩码数据掩码在源端进行掩码最小化敏感数据导出测试系统安全化010010110010101

29、001001001001001001001001001001000100101010010010010011100100100100100100100001001001011100100101010010010101010011010100101010010数据泵文件进行子集和掩码12.1生产测试在源端掩码首先在生产段数据进行子集操作单独对敏感数据进行掩码0100101100101010010010010010010010010010010010001001010100100100100111001001001001001001000010010010111001001010100100101

30、01010011010100101010010生产数据子集克隆和掩码11.2测试Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted34数据库管理数据库管理v与您一同创新与您一同创新 #6Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted35新特性新特性? 云管理 主动性能管理 数据库整合

31、管理 数据库选件数据库选件: Enterprise Manager 12c Real Application Testing 业务机会业务机会: 数据库整合 Database-as-a-Service 云管理, 自服务, 收费 大量数据库的管理客户收益客户收益: 用更少的成本更高效的管理IT基础设施数据库管理数据库管理SALESHRERPCRMCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted36数据库管理数据库管理跨数据库生命周期的全面管

32、理跨数据库生命周期的全面管理规规划划DatabaseConsolidation 测试测试优优化化迁移迁移整合规划/建议实时整合测试Oracle多租期Container DB & Pluggable DB 性能优化Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted37Exadata 技术创新技术创新 齐琨()资深解决方案咨询顾问Copyright 2013, Oracle and/or its affiliates. All righ

33、ts reserved.Oracle Confidential Highly Restricted38Exadata用于用于一台机器可适用于一台机器可适用于 数据仓库 OLTP 数据库云Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted39Exadata 架构架构可伸缩的数据库服务器可伸缩的数据库服务器 8x 2-socket, 或 2x 8-socket Xeon database servers Oracle Database, ASM

34、, RAC; Linux 或 Solaris 标准以太网接口可伸缩的智能存储服务器可伸缩的智能存储服务器 2-socket 存储服务器, Exadata Storage Software Up to 672 terabytes disk per rack 56 PCI Flash memory cards per rackInfiniBand网络网络 Unified internal connectivity ( 40 Gb/sec )Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confide

35、ntial Highly Restricted40预构建系统与传统系统的差别预构建系统与传统系统的差别性能目标性能目标性能目标性能目标时间 (以天计)时间 (以月计)100%度量、诊断调优和重新配置测试和调试出问题的部分组装一堆组件多供应商客户配置Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted41Exadata 工程化系工程化系统统在优化系统方面花费了几百人年帮助IT人员着重解决业务需要标准平台改善支持体验运行所有运行所有现现有的有的O

36、racle数据数据库库工作工作构建Oracle云更低风险, 更佳收益Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted42扩展性支持业务发展扩展性支持业务发展可升级统统一的架构使得性能更快，成本更低一的架构使得性能更快，成本更低配配满配满配配配1/8配配Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Re

37、stricted43扩展超过扩展超过18个机柜个机柜全带宽和冗余用内部线缆和交换机扩展到用内部线缆和交换机扩展到18个机柜个机柜用外部交换机和线缆扩展超过用外部交换机和线缆扩展超过18个机柜个机柜Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted44Exadata X3-2 1/8配配更低的成本更低的成本16 Database Cores, 54 TB Disk, 2.4 TB PCI Flash具备所有Exadata的高可用性配置让更多业

38、务可以使用让更多业务可以使用Exadata硬件上与硬件上与1/4配的区别配的区别 禁用一半 CPU Cores, Disks, 和 Flash Cards一半Database和Exadata Software Licenses只需要软件命令即可以升级成只需要软件命令即可以升级成1/4配配快于2010 配, 2008 配更低的更低的成本成本Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted45无缝升级和扩展无缝升级和扩展一个数据库服务器可以有

39、不同代的服务一个数据库服务器可以有不同代的服务器器数据库和集群可以分布到多带产品上数据库和集群可以分布到多带产品上新的软件可以运行在旧的硬件上新的软件可以运行在旧的硬件上X2-2 2011年部署1/4配X3-2 2013年1/4配到半配X4-2 2014年1/2配到满配升级样例Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted46硬件演进硬件演进V1V2X2X3 2008200920102012Storage (TB)4X336504504

40、168672Flash (TB)5.35.322.48X 044.83XCPU (Cores)649612864192Memory (GB)16X576115220482564096Connectivity (Gb/s)50X24241844004008 8800X4 2013Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted47Exadata硬件情况硬件情况X3-8 FullX4-2 FullX4-2 Half X4-2 QuarterX

41、4-2 Eighth2842216019296482440962048 (max 4096)1024 (max 2048)512 (max 1024)512 (max 1024)2222211111141473316816884361844.8 TB44.8 TB22.4 TB9.6 TB4.8 TB200 TB200 TB100 TB43.2 TB21.6 TB672 TB672 TB336 TB144 TB72 TB90 TB90 TB45 TB19 TB9 TB300 TB300 TB150 TB63 TB30 TB60 TB60 TB30 TB13 TB6.3 TB200 TB200

42、TB100 TB43 TB21.5 TBCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted48X4-2 SQL IO性能性能X4-2Full RackX4-2 Half RackX4-2Quarter X4-2 EighthFlash CacheSQL Bandwidth1,3High Cap Disk100 GB/s50 GB/s21.5 GB/s10.7 GB/sHigh Perf Disk100 GB/s 50 GB/s21.5 GB

43、/s10.7 GB/sFlash SQL IOPS2,38K Reads2,660,0001,330,000570,000285,0008K Writes1,680,000840,000360,000180,000Disk SQL Bandwidth1,3High Cap Disk20 GB/s10 GB/s4.5 G/s2.25 GB/sHigh Perf Disk24 GB/s12 GB/s5.2 GB/s2.6 GB/sDisk SQL IOPSHigh Cap Disk32,00016,0007,0003,500High Perf Disk50,00025,00010,8005,400

44、Data Load Rate420 TB/hr10 TB/hr5 TB/hr2.5 TB/hr1 - Bandwidth is peak physical scan bandwidth achieved running SQL, assuming no compression. Effective data bandwidth will be much higher when compression is factored in. 2 - IOPS Based on read IO requests of size 8K running SQL, typically with sub-mill

45、isecond latencies. Note that the IO size greatly effects flash IOPS. Others quote IOPS based on 2K, 4K or smaller IOs that are not relevant for databases and measure IOs using low level tools instead of SQL.3- Actual Performance varies by application.4 Load rates are typically limited by database se

46、rver CPU, not IO. Rates vary based on load method, indexes, data types, compression, and partitioningCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted49Exadata关键创新关键创新极限性能极限性能+ 混合列压缩混合列压缩 数据仓库10 x 压缩 存档系统15x 压缩压缩数据放在压缩数据放在Flash中中节省空间节省空间压缩压缩prima

47、ry DBstandbytestdevbackup未压缩未压缩 智能线性存储扩展智能线性存储扩展 InfiniBand 连接存储服务器 Smart Scan 智能扫描进行查询卸载 智能智能PCI Flash缓存缓存 在disk前段提供透明缓存 30 x加速随机I/O 提高4x数据扫描效率Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted50Exadata 存储索引存储索引示例表示例表 SALES 对常用列自动收集的摘要存储在Exadata

48、Storage Server的内存Order_dateShip_dateCust_IDProd_IDAmount03-SEP-200919-SEP-2009100753293210,000.0003-SEP-200905-SEP-2009200982009820,000.0003-SEP-200907-OCT-2009100892001015,000.0003-SEP-200901-OCT-2009201001000035,000.0003-SEP-200919-OCT-2009803003000010,000.0003-SEP-200903-NOV-200910000 203040,000.

49、00MINMAXData Chunk #1Order_date03-SEP-200903-SEP-2009Ship_date05-SEP-200907-OCT-2009Cust_ID1007520098Prod_ID2001032932Amount10,00020,000Data Chunk #2Order_date03-SEP-200903-SEP-2009Ship_date01-OCT-200903-NOV-2009Cust_ID1000080300Prod_ID 203030000Amount10,00040,000Copyright 2013, Oracle and/or its af

50、filiates. All rights reserved.Oracle Confidential Highly Restricted51Exadata 存储索引存储索引示例表示例表 SALES 存储索引将无关data chunk忽略掉提供类似分区修剪的功能WHERE ship_date between 01-SEP-2009 and 31-SEP-2009排除排除 data chunk #2 MINMAXData Chunk #1Order_date03-SEP-200903-SEP-2009Ship_date05-SEP-200907-OCT-2009Cust_ID1007520098Pr

51、od_ID2001032932Amount10,00020,000Data Chunk #2Order_date03-SEP-200903-SEP-2009Ship_date01-OCT-200903-NOV-2009Cust_ID1000080300Prod_ID 203030000Amount10,00040,000Order_dateShip_dateCust_IDProd_IDAmount03-SEP-200919-SEP-2009100753293210,000.0003-SEP-200905-SEP-2009200982009820,000.0003-SEP-200907-OCT-

52、2009100892001015,000.0003-SEP-200901-OCT-2009201001000035,000.0003-SEP-200919-OCT-2009803003000010,000.0003-SEP-200903-NOV-200910000 203040,000.00 xCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted52Exadata 智能扫描智能扫描: 比较比较 传统扫描处理技术传统扫描处理技术基于传统存储技术

53、，全部的数据库智能存在于数据库主机来源于存储的数据大部分被数据库主机所丢弃大量的废弃数据占用宝贵的数据库主机资源（IO、内存和CPU），严重影响其它任务执行， 导致处理缓慢I/Os 执行:返回 1 TB 数据DB主机筛选1 TB数据，得到1000行客户要求的数据，计算并返回给客户端返回数据行SELECT customer_id FROM calls WHERE amount 200;DB主机确定表的存储分区发起I/Os请求Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential H

54、ighly Restricted53Exadata 智能扫描智能扫描: 比较比较 Exadata的智能扫描技术的智能扫描技术仅查询相关的字段customer_id和符合条件的行 where amount200被返回给数据库服务器通过把扫描处理从数据库中剥离，减少了数据库服务器的CPU负担，同时极大降低了无效的信息传输仅仅传输需要的、有价值的信息返回2MB数据到数据库服务器返回数据行构造Smart Scan 并发送到存储单元Smart Scan在TB的表中识别出符合查询需求的行和字段汇聚各存储单元的返回结果到结果集SELECT customer_id FROM calls where amoun

55、t 200;Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted54Exadata 智能扫描智能扫描:卸载卸载 data mining scoring 处理处理Data mining scoring 在 Exadata 执行:所有的data mining scoring 功能卸载到 Exadata主要性能益处: CPU密集的操作从数据库服务期转移到exadata storage servers高达2x 性能收益(因为更多 CPU 在Exada

56、ta storage grid)更多性能收益, 因为 I/O 优化减少数据库服务器的CPU使用select cust_idfrom customerswhere region = USand prediction_probability(churnmod, Y using *) 0.8;Scoring function executed in ExadataNewCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted55Sun Oracle D

57、atabase Machine:对大型扫描的优化对大型扫描的优化1 TB（压缩）10 TB 的用户数据需要10 TB 的IO100 GB（分区修剪）20 GB（存储索引）5 GB （智能扫描）在Database Machine 上实现亚秒级数据减少10 倍，扫描加快2000 倍Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted56Exadata Smart Flash Cache在PCI flash中缓存读写IO透明加速读写敏感负载高达2.

58、66百万次 SQL 8K读高达1.68百万次 SQL 8K写持久化写缓存提高数据库恢复速度Exadata的Flash Cache比其他传统的Flash层更高效缓存当前的热数据，而不是昨天的数据缓存数据力度比其他缓存技术小816倍极大的改善Flash的效率I/Os2.66 百万次百万次 8K Read 1.68 百万次百万次 8K Write Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted57序号行行业业及及项项目目配置配置测试结测试结果

59、果测试测试日期日期1Telco: 经营分析V2, Rack168倍 2010.11.26 - 282Telco: 财务系统V2, Rack20倍7天, 20103Telco:经营分析V2, Rack235倍2010.9.8 - 154保险: 数据仓库V2, Rack25倍21天, 2010.55MRD: ETC (DW)V2, Rack300倍14天, 2010.56MRD: ODS/DW V2, Rack62倍14天, 2010.57DATES & DWV2, Rack10 - 450倍2010.7.5 -168MRD: 集运运输(OLTP)V2, Rack10倍2010.8.9 -

60、 189电力: 低压集超(DW)V110 倍7天, 2010.1Exadata 中国区用户POC测试结果* 测试结果为Exadata相当于用户原有环境或第三方对比测试方案的性能提升倍数Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted58一流品牌选择一流品牌选择ExadataCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly