Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what is the solution that oracle 11g awr is not automatically generated". In daily operation, I believe many people have doubts about what is the solution that oracle 11g awr does not generate automatically. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "what is the solution that oracle 11g awr does not generate automatically?" Next, please follow the editor to study!

There is a problem with oracle that it cannot purge awr on a regular basis, resulting in the rapid growth of sysaux tablespaces. After manual cleaning, awr is not automatically generated.

Awr needs to be rebuilt, but it needs to be restarted. The temporary solution is to write a crontab and automatically create one at regular intervals.

[oracle @ oracleserver2 ~] $more / homebank oracleash snapshotexports create.shwon ORACLE_BASE=/u01/app/oracleexport ORACLE_SID=oragps2export ORACLE_HOME=$ORACLE_BASE/11.2.0/db_1;/u01/app/oracle/11.2.0/db_1/bin/sqlplus / nolog.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.