Oracle 10g用ASH生成性能报告
1、运行输入CMD进入命名窗口。
2、输入:
sqlplus /nolog;
conn /as sysdba;
3、运行ash导出文件，具体实现方式: （也可以到oracle安装目录下搜索ashrpt.sql，然后在命令窗口输入@，然后拉入文件即可）
SQL> @$Oracle_HOME/rdbms/admin/ashrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
631770879 ORA10 1 ora10
Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type: --输入产生的报告文件类型直接回车就是默认的html
Type Specified: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 631770879 1 ORA10 ora10 linux
Defaults to current database
Using database id: 631770879
Defaults to current instance
Using instance number: 1
ASH Samples in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Oldest ASH sample available: 12-Mar-08 12:22:57 [ 10246 mins in the past]
Latest ASH sample available: 19-Mar-08 15:05:08 [ 4 mins in the past]
Specify the timeframe to generate the ASH report
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter begin time for report:
-- Valid input formats:
-- To specify absolute begin time:
-- [MM/DD[/YY]] HH24:MI[:SS]
