Monday, October 15, 2012

ORACLE: ADDM, AWR and ASH Utilities

a) An ADDM Report (addmrpt.sql)
-------------------------------
The ADDM reporting utility creates a report of its database performance findings. The addmrpt.sql script is found in the $ORACLE_HOME/rdbms/admin directory. The output is written to the current working directory as a text file.

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

b) AWR Report (awrrpt.sql)
-------------------------------
The AWR reporting utility provides an overview of database performance within a specified period of time. It essentially computes the net change in database activity within the period. The awrrpt.sql script is found in the $ORACLE_HOME/rdbms/admin directory. The output is written to the current working directory, please select HTML format.

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

c) ASH Report (ashrpt.sql)
----------------------------
The ASH report utility is useful for determining the amount of active sessions, what they were doing, and which SQL statements were most active during a period of time. It is especially useful for analyzing transient performance issues. The ashrpt.sql script is found in the $ORACLE_HOME/rdbms/admin directory. The output is written to the current working directory, please select HTML format.

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



For further information on each utility, use the menu options on the right side of the website.

No comments:

Post a Comment