Oracle9i 数据仓库执行性能增强
简介 .................................................................................................................... 4
资源需求和相关性 ............................................................................................ 4
硬件..............................................................................................................................4
数据库..........................................................................................................................4
基本执行性能增强 ............................................................................................ 5
合并/更新插入.............................................................................................................5
合并/更新插入增强.............................................................................................5
合并/更新插入结果.............................................................................................5
外部表..........................................................................................................................6
外部表增强..........................................................................................................6
外部表结果..........................................................................................................7
Group By ......................................................................................................................7
可变长度聚合......................................................................................................7
聚合测试结果......................................................................................................8
动态内存管理..............................................................................................................8
专用服务器的 PGA 内存 ...................................................................................8
动态内存管理结果..............................................................................................9
实体化视图，快速刷新 ..............................................................................................9
快速刷新的优化执行方案..................................................................................9
快速刷新结果......................................................................................................9
PL/SQL........................................................................................................................10
PL/SQL 增强.......................................................................................................10
PL/SQL 结果.......................................................................................................10
索引跳扫....................................................................................................................11
索引跳扫增强....................................................................................................11
索引跳扫结果....................................................................................................11
位图联接索引............................................................................................................12
位图联接索引增强............................................................................................12
位图联接索引结果............................................................................................12
结论 .................................................................................................................. 14
附录...................................................................................................................15
初始化....................................................................................................................15
init8iopt.ora ........................................................................................................15
init9iopt.ora ........................................................................................................16
生成 语句.. .............................................................................................................18
Oracle9i 数据仓库执行性能增强 第 2 页
