First we will start with ORA-20200 error. We tried to run awrrpt.sql found under $ORACLE_HOME/rdbms/admin and we encountered with that error since we had no AWR reports although it had been months since se installed our Oracle Applications Database(EBS).
Then we come up with the suggested solution below however our conditions were not that critical(Ref-1). We also didnt have those snapshots but we were able to create these snapshots. In that solution, it was suggested that we recreate the awr.
How to drop and recreate AWR?
Note:782974.1 How to Recreate The AWR ( AUTOMATIC WORKLOAD ) Repository
Our solution was however is to just recreate our snapshot to solve our ORA-20200.
References:
1- AWR Error - ORA 20200
http://fayoubi.blogspot.com.tr/2013/09/ora-13516-awr-operation-failed-or-ora.html
How to Generate an AWR Report and Create Baselines (Doc ID 748642.1) |
4-How to Use AWR Reports to Diagnose Database Performance Issues (Doc ID 1359094.1)
5-Awr reports Reading
http://oracle-base.com/articles/10g/automatic-workload-repository-10g.php
Hiç yorum yok:
Yorum Gönder