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
-------------------------------
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
No comments:
Post a Comment