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
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

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

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe