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