Ash report 생성
DB CAFE
thumb_up 추천메뉴 바로가기
- 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: textIn this example, a text report is chosen.
- Specify the begin time in minutes before the system date:
Enter value for begin_time: -10In 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.