oracle awr 生成报告

@?/rdbms/admin/awrrpt.sql //awr报告

@?/rdbms/admin/awrsqrpt.sql //执行计划

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
2507 08 Sep 2011 13:00 1
2508 08 Sep 2011 14:00 1
2509 08 Sep 2011 15:00 1
2510 08 Sep 2011 16:00 1


Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 2494 //开始
Begin Snapshot Id specified: 2494

Enter value for end_snap: 2510 //结束
End Snapshot Id specified: 2510


Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_1796_1813.html. To use this name,
press <return> to continue, otherwise enter an alternative.


Enter value for report_name: feng //文件的名字
SQL>quit

ls |grep feng 找到你文件

参考：[url]http://space.itpub.net/17203031/viewspace-700471[/url]