一. Oracle 分析报告

参考文档：http://blog.csdn.net/cuker919/article/details/8767328

1、登录数据库
sqlplus ‘/as sysdba’

2、输入分析命令
@?/rdbms/admin/awrrpt

3、输入要生成报告的文件格式
Type Specified:  html

4、输入要生成报告相隔的天数
Enter value for num_days: 1

5、输入相隔的快照之间的 Snap Id 开始号和结束号
Specify the Begin and End Snapshot Ids
Enter value for begin_snap: 2809
Enter value for end_snap: 2821
End Snapshot Id specified: 2821

6、输入生成报告的名字：
Enter value for report_name: 20130407awr.html

二. 重置 Oracle 表统计信息

BEGIN                                                                                                                    
  SYS.DBMS_STATS.GATHER_TABLE_STATS (                                                            
     OwnName           => ‘UNIMAX4_TEST’                                                                  
    ,TabName           => ‘UMPP_WORK_ORDER’                                                           
    ,Estimate_Percent  => 10                                                                                      
    ,Method_Opt        => ‘FOR ALL COLUMNS SIZE 1’                                                   
    ,Degree            => 4                                                                                            
    ,Cascade           => FALSE                                                                                     
    ,No_Invalidate  => FALSE);                                                                                   
END;