"Ash report 생성"의 두 판 사이의 차이

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.