ash报告生成详解

《ash报告生成详解》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、1.参看AWR报告生成详解.doc。2.切换用户:[root@xlserver10~]#su–oracle//注意-后面有空格,oracle为用户名3.[oracle@xlserver10~]pwd4.[oracle@xlserver10~]cd/opt/oracle/product/11.2.0/db_1/rdbms/admin5.[oracle@xlserver10admin]$lsash*6.[oracle@xlserver10admin]$sqlplus/nolog//在目录oracle_home/../admin7.sqlplus下删除输入的非法字符用delete键，不要

2、用backspace退格8.SQL>conn/assysdba//这一句必须执行9.3SQL>@ashrpt.sqlCurrentInstance~~~~~~~~~~~~~~~~    DBId    DBName      InstNumInstance-------------------------------------------  715014091ANQING              1anqing1  SpecifytheReportType~~~~~~~~~~~~~~~~~~~~~~~Enter'html'foranHTMLreport,or'text'forp

3、laintextDefaultsto'html'Entervalueforreport_type:text-- 选择生成的ASH 报告类型，是text 还是htmlTypeSpecified:  text  InstancesinthisWorkloadRepositoryschema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~    DBId     InstNumDBName      Instance     Host--------------------------------------------------------  

4、715014091         1ANQING       anqing       singledb*715014091         1ANQING       anqing1      rac1  715014091         2ANQING       anqing2      rac2 Defaultstocurrentdatabase Usingdatabaseid:715014091 Defaultstocurrentinstance Usinginstancenumber:1  ASHSamplesinthisWorkloadRepositorysche

5、ma~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ OldestASHsampleavailable:  19-May-1114:49:59   [  10585minsinthepast]LatestASHsampleavailable:  26-May-1123:14:34   [      1minsinthepast]  SpecifythetimeframetogeneratetheASHreport~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Enterbegintimefo

6、rreport: --    Validinputformats:--      Tospecifyabsolutebegintime:--        [MM/DD[/YY]]HH24:MI[:SS]--        Examples:02/23/0314:30:15--                  02/2314:30:15--                  14:30:15--                  14:30--      Tospecifyrelativebegintime:(startwith'-'sign)--        -[HH24:]

7、MI--        Examples:-1:15  (SYSDATE-1Hr15Mins)--                  -25    (SYSDATE-25Mins) Defaultsto-15minsEntervalueforbegin_time:8:00-- 输入ASH 开始的时间，时间格式上面的示例有说明Reportbegintimespecified:8:00 Enterdurationinminutesstartingfrombegintime