다른 명령
ASH 보고서 생성
ashrpt.sql SQL 스크립트는 지정된 기간 동안 ASH 정보를 표시하는 HTML 또는 텍스트 보고서를 생성합니다.
To generate an ASH report:
- At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/ashrpt.sql
- Specify whether you want an HTML or a text report:
Enter value for report_type: text
In this example, a text report is chosen.
- Specify the begin time in minutes before the system date:
Enter value for begin_time: -10
In this example, 10 minutes before the current time is selected.
Enter the duration in minutes that the report for which you want to capture ASH information from the begin time.
Enter value for duration:
In this example, the default duration of system date minus begin time is accepted.
Enter a report name, or accept the default report name:
Enter value for report_name:
Using the report name ashrpt_1_0310_0131.txt In this example, the default name is accepted and an ASH report named ashrpt_1_0310_0131 is generated. The report will gather ASH information beginning from 10 minutes before the current time and ending at the current time.