目 录
1. 报告概述............................................................................................................................................3
2. 学习测试............................................................................................................................................3
2.1. 案例一、监控厂商代码查询 dba_free_space 慢.......................................................................3
2.1.1. 慢 SQL............................................................................................................................3
2.1.2. 问题处理........................................................................................................................3
2.2. 案例二、Oracle DBA 手记 2-OEM 查询 dba_free_space 慢.....................................................6
2.2.1. TOP SQL OEM..............................................................................................................6
2.2.2. 慢 SQL-执行计划..........................................................................................................6
2.2.3. 清空回收站可以提升 SQL 查询性能...........................................................................8
2.2.4. Oracle 10g dba_free_space.............................................................................................8
2.2.5. Oracle 11.2.0.4 dba_free_space......................................................................................9
2.3. 测试验证....................................................................................................................................10
2.3.1. 制造 SQL......................................................................................................................11
2.3.2. 制造 5 万条回收站的记录进行测试...........................................................................11
2.3.3. 制造 16 万条回收站的记录进行测试........................................................................14
结论及建议.....................................................................................................................................15
评论