AWR Report on the Oracle Database

Hello, to get awr report :

connect to oracle db as sysdba 
percula40: / home / oracle # sqlplus / as sysdba

SQL * Plus: Release 11.2.0.3.0 Production on Tue Mar 27 13:44:46 2018

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
run this scripts:
SQL>@$ORACLE_HOME/rdbms/admin/awrrpt.sql

He will ask the following questions with the order;

1. Enter value for report_type: -> I enter the report form, "HTML".
2. Enter value for num_days: -> How many days do you want to get snapshots, I enter "30".
3. Enter value for begin_snap: -> Look at the list and enter the initial snapshot. >>>> Snap Id
4. Enter value for end_snap: -> Look at the list and enter end snapshot. >>>>>> Snap Id
5. Enter value for report_name: -> I give the report a name.

Instance DB Name Snap Id Snap Started Level
———— ———— ——— —————— —–
ProdTTdev  85583 21 Mar 2018 04:00 1
85584 21 Mar 2018 04:30 1 >> SnapID=85584
85585 21 Mar 2018 05:00 1
85586 21 Mar 2018 05:30 1
85587 21 Mar 2018 06:00 1
85588 21 Mar 2018 06:30 1
85589 21 Mar 2018 07:00 1
85590 21 Mar 2018 07:30 1
85591 21 Mar 2018 08:00 1
85592 21 Mar 2018 08:30 1
85593 21 Mar 2018 09:00 1
85594 21 Mar 2018 09:30 1
85595 21 Mar 2018 10:00 1
85596 21 Mar 2018 10:30 1
85597 21 Mar 2018 11:00 1
85598 21 Mar 2018 11:30 1
85599 21 Mar 2018 12:00 1
85600 21 Mar 2018 12:30 1
85601 21 Mar 2018 13:00 1
85602 21 Mar 2018 13:30 1
85603 21 Mar 2018 14:00 1
85604 21 Mar 2018 14:30 1
85605 21 Mar 2018 15:00 1
85606 21 Mar 2018 15:30 1
85607 21 Mar 2018 16:00 1
85608 21 Mar 2018 16:30 1
85609 21 Mar 2018 17:00 1
85610 21 Mar 2018 17:30 1
85611 21 Mar 2018 18:00 1
85612 21 Mar 2018 18:30 1
85613 21 Mar 2018 19:00 1
85614 21 Mar 2018 19:30 1
85615 21 Mar 2018 20:00 1
85616 21 Mar 2018 20:30 1
85617 21 Mar 2018 21:00 1
85618 21 Mar 2018 21:30 1
85619 21 Mar 2018 22:00 1
85620 21 Mar 2018 22:30 1
85621 21 Mar 2018 23:00 1
85622 21 Mar 2018 23:30 1
85623 22 Mar 2018 00:00 1

Show Oracle AWR reports locations:

awr report under the /home/oracle directory. have a good day.

Hits: 9

Leave a Reply

Your email address will not be published. Required fields are marked *