Overview of oracle AWR report
Awr report is automatic workload repository It’s introduced in oracle database 10G This report stores data in sysaux tablespace AWR report background process is MMON(Manageability monitor) and MMNL. AWR report collects, process and maintenance performance statists. It can’t give any recommendations. It’s retain the stats for 8-days by default. How to generate AER report cd $ORACLE_HOME/rdbms/admin Report Name SQL Scripts AWR Report awrrpt.sql Automatic DB Diagnostics Monitor report addmrpt.sql ASH Report ashrpt.sql AWR Diff periods Report awrddrpt.sql AWR Single SQL Statement Report awrsqrpt.sql AWR Global Report awrgrpt.sql AWR Global Diff Report awrgdrpt.sql AWR report Analysis We can’t analysis the all details in AWR report because It’s contains much data I will be