文档详情

Oracle数据库g-数据库技术的革命.ppt

发布:2023-04-04约3万字共43页下载文档
文本预览下载声明
行级安全 + 列相关 50-100 GB in size. 高性能 HA. Used for shipment tracking, cost calculation, best transfers No central site, but 10 regional sites Why 62 systems: Biggest railway stations (62 most important cities) 62 RAC sites using either IBM HACMP or HP TRU64. RAC is their standard. Most sites are 3 nodes. One site is 4 nodes. Some of them were migrated from 8i OPS to 9iRAC. Some of them were running single instance and run out of the capacity, so they added the additional nodes. System used for both HA and 可伸缩性. Jiangsu Mobile Communications ZheJiang Mobile Communications are the two who have implemented, these are 2 of the 3 biggest provinces in China. JiangSu Mobile – HP UX – 10 RAC Clusters Reporting (16* TB initial, 3 – 24 way nodes) - 13 million users 3 x Prepay Mobile Call Authorization (0.6 TB, 2 nodes, 4000 SQL/sec) – 13 million users ZheJiang Mobile – HP-UX – 3 RAC Clusters Prepay Mobile Call Authorization (1.5 TB, 4 nodes, 4000 SQL/sec) – 13 million users Batch Billing (21 TB in just data, 4 – 16 way nodes, 4000 SQL/sec). 300 GB loaded per day. Hubei Mobile – AIX P690 – 2 RAC Clusters Prepay Mobile Call Authorization (1.5 TB, 2 nodes, 9000 SQL/sec) – 7 million users Batch Billing (10 TB , 2 – 16 way nodes, 48 GB RAM, 600 SQL/sec) Financials (15 TB), DW (10 TB) HP 8-32 way Superdome, 9 clusters, 2-4 nodes Add first-failure diagnostics Oracle has created a 网格计算 infrastructure 软件 that balances all types of workloads across servers, and enables all those servers to be managed as one complete system. 网格计算 can achieve the same very high level of 可靠性 as a mainframe because all 组件 are clustered. But unlike mainframes and large UNIX SMP servers, a grid can be built with open systems technologies such as Intel processors and the Linux operating system so it’s very 低成本. 网格控制 provides Entire stack User Provisioning Cloning Patch Management Oracle 数据库 10g 自我管理的数据库 内置的智能基础架构 代码工具 工作负载信息库 日常任务自动化 自动的基于磁盘的备份和恢复 自动的优化器统计信息收集 自动的 PGA 和 SGA 内
显示全部
相似文档