ASH報(bào)告生成詳解.doc

1. 參看AWR報(bào)告生成詳解.doc。2. 切換用戶: rootxlserver10 # su oracle /注意-后面有空格,oracle為用戶名3. oraclexlserver10 pwd4. oraclexlserver10 cd /opt/oracle/product/11.2.0/db_1/rdbms/admin5. oraclexlserver10 admin$ ls ash*6. oraclexlserver10 admin$ sqlplus /nolog /在目錄oracle_home/./admin7. sqlplus下刪除輸入的非法字符用delete鍵，不要用backspace退格8. SQL conn /as sysdba /這一句必須執(zhí)行9. 3 SQL ashrpt.sqlCurrent InstanceDB IdDB NameInst Num Instance- - - -715014091 ANQING1 anqing1Specify the Report TypeEnter html for an HTML report, or text for plain textDefaults to htmlEnter value for report_type: text-選擇生成的ASH報(bào)告類型，是text還是htmlType Specified:textInstances in this Workload Repository schemaDB IdInst Num DB NameInstanceHost- - - - -7150140911 ANQINGanqingsingledb* 7150140911 ANQINGanqing1raANQINGanqing2rac2Defaults to current databaseUsing database id: 715014091Defaults to current instanceUsing instance number: 1ASH Samples in this Workload Repository schemaOldest ASH sample available:19-May-11 14:49:5910585 mins in the pastLatest ASH sample available:26-May-11 23:14:341 mins in the pastSpecify the timeframe to generate the ASH reportEnter begin time for report:-Valid input formats:-To specify absolute begin time:-MM/DD/YY HH24:MI:SS-Examples: 02/23/03 14:30:15-02/23 14:30:15-14:30:15-14:30-To specify relative begin time: (start with - sign)-HH24:MI-Examples: -1:15(SYSDATE - 1 Hr 15 Mins)-25(SYSDATE - 25 Mins)Defaults to -15 minsEnter value for begin_time: 8:00-輸入ASH開始的時(shí)間，時(shí)間格式上面的示例有說明Report begin time specified: 8:00Enter duration in minutes starting from begin time:Defaults to SYSDATE - begin_timePress Enter to analyze till current timeEnter value for duration:-輸入ASH結(jié)束時(shí)間，默認(rèn)是SYSDATE - begin_timeReport duration specified:Using 26-May-11 08:00:00 as report begin timeUsing 26-May-11 23:15:12 as report end timeSpecify Slot Width (using ashrpti.sql) for Activity Over Time section- Explanation:-In the Activity Over Time section of the ASH report,-the analysis period is divided into smaller slots-and top wait events are reported in each of those slots.- Default:-The analysis period will be automatically split upto 10 slots-complying to a minimum slot width of-1 minute,if the source is V$ACTIVE_SESSION_HISTORY or-5 minutes, if the source is DBA_HIST_ACTIVE_SESS_HISTORY.Specify Slot Width in seconds to use in the Activity Over Time section:Defaults to a value as explained above:Slot Width specified:Specify Report Targets (using ashrpti.sql) to generate the ASH report- Explanation:-ASH Report can accept Report Targets,-like a particular SQL statement, or a particular SESSION,-to generate the report on. If one or more report targets are-specified, then the data used to generate the report will only be-the ASH samples that pertain to ALL the specified report targets.- Default:-If none of the report targets are specified,-then the target defaults to all activity in the database instance.Specify SESSION_ID (eg: from V$SESSION.SID) report target:Defaults to NULL:SESSION report target specified:Specify SQL_ID (eg: from V$SQL.SQL_ID) report target:Defaults to NULL: (% and _ wildcards allowed)SQL report target specified:Specify WATI_CLASS name (eg: from V$EVENT_NAME.WAIT_CLASS) report target:Enter CPU to investigate CPU usageDefaults to NULL: (% and _ wildcards allowed)WAIT_CLASS report target specified:Specify SERVICE_HASH (eg: from V$ACTIVE_SERVICES.NAME_HASH) report target:Defaults to NULL:SERVICE report target specified:Specify MODULE name (eg: from V$SESSION.MODULE) report target:Defaults to NULL: (% and _ wildcards allowed)MODULE report target specified:Specify ACTION name (eg: from V$SESSION.ACTION) report target:Defaults to NULL: (% and _ wildcards allowed)ACTION report target specified:Specify CLIENT_ID (eg: from V$SESSION.CLIENT_IDENTIFIER) report target:Defaults to NULL: (% and _ wildcards allowed)CLIENT_ID report target specified:Specify PLSQL_ENTRY name (eg: SYS.DBMS_LOB.*) report target:Defaults to NULL: (% and _ wildcards allowed)PLSQL_ENTRY report target specified:Specify the Report NameThe default report file name is