Ash report 생성
DB CAFE
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
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.