Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Enabling AWR in the database

893400Jun 4 2012 — edited Jun 4 2012

Hello everyone,
I have Oracle enterprise 10.2.0.4 on Linux and I have disabled AWR because of license issue. Now that we have bought the licenses, i wanted to enable it back.

I have disabled AWR using the below steps

SQL>@dbmsnowar.plb
--this will install the required package to disable AWR

SQL>begin dbms_awr.disable_awr(); end;

Please tell me how to enable AWR. In some website, they have asked to enable GATHER_STATS_JOB, but I am not sure if that is the only step.

-Jek

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 2 2012

Added on Jun 4 2012

#general-database-discussions

8 comments

10,167 views