awr report

http://wiki.gurubee.net/display/DBSTUDY/AWR

AWR 사용법

1. 아래 경로로 이동

cd /oracle/app/ora/product/11g/db_1/rdbms/admin

=

cd $ORACLE_HOME/rdbms/admin

 

2. sqlplus 접속

sqlplus / as sysdba

 

3. awrrpt.sql 실행

@awrrpt.sql

 

Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type: text

 

htme/test 모드 중 한가지 선택하면 된다.

 

Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   DB Id     Inst Num DB Name    Instance Host
------------ -------- ------------ ------------ ------------
* 1981839973     1 DBWORKS    DBWORKS db3

Using 1981839973 for database Id
Using        1 for instance number

Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed.  Pressing <return> without
specifying a number lists all completed snapshots.

Enter value for num_days: 1

 

최근 하루 나는 숫자 1을 입력했다.

 

Listing the last day's Completed Snapshots

       Snap
Instance     DB Name     Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
DBWORKS      DBWORKS  144 25 May 2015 00:00    1
    145 25 May 2015 01:00    1
    146 25 May 2015 02:00    1
    147 25 May 2015 03:00    1
    148 25 May 2015 04:00    1
    149 25 May 2015 05:00    1
    150 25 May 2015 06:00    1
    151 25 May 2015 07:00    1
    152 25 May 2015 08:00    1
    153 25 May 2015 09:00    1
    154 25 May 2015 10:00    1
    155 25 May 2015 11:00    1

 

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 145

 

레포트 분석 시작 구간을 앞 숫자를 보고 입력한다.

문제가 있어서 분석을 원할 경우 당연히, 저 구간이 좁을수록 더 상황분석이 용이하다.

 

Enter value for end_snap: 146
End   Snapshot Id specified: 146

 

분석 끝나는 구간의 숫자 입력

 

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_145_146.txt.  To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name: 0525_145_146_awrreport.txt

 

파일명을 직접 입력하지 않으면 위의 디폴트 명으로 파일이 생성된다.

 

중간내용생략

 

init.ora Multi-Valued Parameters     DB/Inst: DBWORKS/DBWORKS Snaps: 145-146
-> This section only displays parameters that have more one value
->'(NULL)' indicates a missing parameter value
-> A blank in the End Snapshot indicates the same value as the BeginSnapshot

        End value
Parameter Name        Begin value   (if different)
----------------------------- --------------------------------- --------------
control_files        /oradata/DBWORKS/control01.ctl
         /oradata/DBWORKS/control02.ctl
   -------------------------------------------------------------

Dynamic Remastering Stats       DB/Inst: DBWORKS/DBWORKS Snaps: 145-146

    No data exists for this section of the report.
   -------------------------------------------------------------

End of Report
Report written to 0525_145_146_awrreport.txt

 

이 경로에 내가 지정해준 파일명으로 vi나 메모장으로 열어서 분석을 하면 된다.