Ash report 생성
DB CAFE
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
Generating an ASH Report The ashrpt.sql SQL script generates an HTML or text report that displays ASH information for a specified duration.
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.