"Ash report 생성"의 두 판 사이의 차이
DB CAFE
(→ASH 보고서 생성) |
|||
| (같은 사용자의 중간 판 하나는 보이지 않습니다) | |||
| 5번째 줄: | 5번째 줄: | ||
* At the SQL prompt, enter: | * At the SQL prompt, enter: | ||
| − | + | <source lang=sql> | |
@$ORACLE_HOME/rdbms/admin/ashrpt.sql | @$ORACLE_HOME/rdbms/admin/ashrpt.sql | ||
| − | + | </source> | |
| − | Specify whether you want an HTML or a text report: | + | * Specify whether you want an HTML or a text report: |
| − | + | <source lang=sql> | |
| − | + | Enter value for report_type: text | |
| + | </source> | ||
In this example, a text report is chosen. | In this example, a text report is chosen. | ||
* Specify the begin time in minutes before the system date: | * Specify the begin time in minutes before the system date: | ||
| − | + | <source lang=sql> | |
| − | + | Enter value for begin_time: -10 | |
| + | </source> | ||
In this example, 10 minutes before the current time is selected. | 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 the duration in minutes that the report for which you want to capture ASH information from the begin time. | ||
| − | + | <source lang=sql> | |
| − | + | Enter value for duration: | |
| + | </source> | ||
In this example, the default duration of system date minus begin time is accepted. | In this example, the default duration of system date minus begin time is accepted. | ||
| − | + | Enter a report name, or accept the default report name: | |
| − | + | <source lang=sql> | |
| − | + | Enter value for report_name: | |
| + | </source> | ||
Using the report name ashrpt_1_0310_0131.txt | 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. | 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. | ||
2023년 4월 4일 (화) 08:31 기준 최신판
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.