"Ash report 생성"의 두 판 사이의 차이
DB CAFE
1번째 줄: | 1번째 줄: | ||
− | + | == ASH 보고서 생성 == | |
− | + | ashrpt.sql SQL 스크립트는 지정된 기간 동안 ASH 정보를 표시하는 HTML 또는 텍스트 보고서를 생성합니다. | |
To generate an ASH report: | To generate an ASH report: | ||
− | At the SQL prompt, enter: | + | * At the SQL prompt, enter: |
@$ORACLE_HOME/rdbms/admin/ashrpt.sql | @$ORACLE_HOME/rdbms/admin/ashrpt.sql | ||
+ | |||
Specify whether you want an HTML or a text report: | Specify whether you want an HTML or a text report: | ||
− | Enter value for report_type: text | + | * Enter value for report_type: text |
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: |
− | Enter value for begin_time: -10 | + | * Enter value for begin_time: -10 |
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. | ||
− | Enter value for duration: | + | * Enter value for duration: |
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: | + | * Enter a report name, or accept the default report name: |
− | Enter value for report_name: | + | * Enter value for report_name: |
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:25 판
- 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.