Thursday 2 May 2013

TO GENERATE AWR AND ADDM REPORTS IN ORACLE:

 TO GENERATE AWR AND ADDM REPORTS IN ORACLE:
To issue AWR scripts:

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

OR

@?/rdbms/admin/awrrpt.sql

save it in Enter value for report_name: awr_report.txt

you can check the given file name in cd /$ORACLE_HOME/rdbms/admin
ls -lrt

to move from 1 place to another

mv awr_report.txt /home/oracle

to read
 more awr_report.txt

Same for addm:

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


No comments:

Post a Comment