日期:2014-05-16  浏览次数:20347 次

oracle awr 生成报告
cd  $ORACLE_HOME/rdbms/admin/

SQL> conn /as sysdba;
Connected.
SQL> show user;
USER is "SYS"
SQL> @awrrpt.sql
Enter value for report_type: html  //输出为html


Enter value for num_days: 1 //1天

Listing the last day's Completed Snapshots

                                                        Snap
Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
jrtdbtest    JRTDBTES          2494 08 Sep 2011 00:00      1
                               2495 08 Sep 2011 01:00      1
                               2496 08 Sep 2011 02:00      1
                               2497 08 Sep 2011 03:00      1
                               2498 08 Sep 2011 04:00      1
                               2499 08 Sep 2011 05:00      1
                               2500 08 Sep 2011 06:00      1
                               2501 08 Sep 2011 07:00      1
                               2502 08 Sep 2011 08:00      1
                               2503 08 Sep 2011 09:00      1
                               2504 08 Sep 2011 10:00      1
                               2505 08 Sep 2011 11:00      1
                               2506 08 Sep 2011 12:00      1