Monday , September 25 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

How to switch on primary database to physical standby database

After configuration data guard then data is switching  into primary database  to standby database : …

Leave a Reply

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