generate AWR report
1. see if AWR is enabled
show parameter statistics_level
2. modify interval and retention
exec DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(retention=>43200, interval=>30);
3. manually generate report
run the awrrpt.sql script. found under the $ORACLE_HOME/
rdbms/admin directory.
rdbms/admin directory.
sqlplus / as sysdba @awrrpt
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7636787/viewspace-752697/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- rebuild index online for SQL server
- make an index unusable
- Running Commands on a Remote Linux Server over SSH
- what shell I am in
- How to find which process is holding certain port #
- 改变从今天开始,立贴为证
- how to create a table from select query in sql server
- svn revert to a previous revision
- JTA example
- XML CDATA
