oracle10g/11g 新特性七(性能维护)

Performance Monitoring

Enterprise Manager Performance Page

Driling Down to a Particular Wait Category

 Managing Memory Components

Dynamic Performance Statistics

Performance Planing

1.Investment options

2.System architecture

3.Scalability

4.Application design principles

5.Workload testing , modeling , and implementation

6.Deploying new applications

Optimizer Statistics Collection

select job_name from dba_scheduler_jobs;

select table_name,num_rows from user_tables;

execute dbms_scheduler.run_job('GATHER_STATS_JOB');  //数目和原数据相差不大的 就忽略了 达到一定比例才会收集

analyze table emp1 compute statistics; //这一句  和下一句是有区别的  粒度更细

删除统计信息： exec dbms_stats.delete_table_stats('SCOTT','EMP1') ;//删除当前用户下的emp1信息

如果没有统计信息：有个参数：optimizer_dynamic_sampling  2  动态采样，比如上边的表emp1被删了，执行关于这个表的SQL时候，就会动态取样 ，然后根据结果 确定执行计划

Statistic Preferences:Overview

Statistic Preferences:11g才有的功能

Using  Statistic Preferences