Friday , July 21 2017
Home / Oracle DBA / AUTOMATIC WORKLOAD REPOSITORY (AWR) REPORT

AUTOMATIC WORKLOAD REPOSITORY (AWR) REPORT

 

Automatic Workload Repository(AWR) report

Automatic Workload Repository(AWR) report

1.     It is an extension to statspack report and introduced in 10g
2.    In 10g, oracle will automatically runs collection of statistics job every one hour

# To generate AWR report

SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql

Active Session History(ASH) report

1.     It is a report to know the performance of database in last 15 minutes which helps in
providing quick solutions
2.      It also provides session info which are causing performance problem 

# To generate ASH report

SQL> @$ORACLE_HOME/rdbms/admin/ashrpt.sql

Automatic Database Diagnostic Monitor (ADDM) report

1.     It is a tool which can be used to get recommendations from oracle on the performance
issues
2.     It will take the snapshots generated by AWR and based on that will generate
recommendations

# To generate ADDM report

SQL> @$ORACLE_HOME/rdbms/admin/addmrpt.sql
View More:
ORACLE INCREMENTAL BACKUP WITH EXAMPLE
ORACLE RECOVERY CATALOG CONFIGURING
ORACLE RMAN RECOVERY SCENARIOS WITH EXAMPLES

Comments

comments

Check Also

DATA BASE LINKS

DATABASE LINKS: What are the db links? create a link from one database to another …

Leave a Reply

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