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
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