7 Replies Latest reply: Nov 30, 2011 11:18 PM by Aman.... RSS

    AWR

    user9037553
      Hi,

      Just want to find that does awr comes with default oracle enterprise 10g binaries?

      Or do we need to purchase diagoniastic and performance packs to use awr reports.
        • 1. Re: AWR
          Charles Hooper
          You need to purchase a Diagnostic Pack license to legally use AWR. AWR collection is enabled by default in 10g R2 - if you have no Diagnostic Pack license, you should disable AWR collection.

          Charles Hooper
          Co-author of "Expert Oracle Practices: Oracle Database Administration from the Oak Table"
          http://hoopercharles.wordpress.com/
          IT Manager/Oracle DBA
          K&M Machine-Fabricating, Inc.
          • 2. Re: AWR
            636520
            Hi,

            As awr is enabled when oracle is installed with database creation.And id I don't purchase daigonistic pack and if I use it like for awr reports,how does oracle corp. will come to know that i am using awr reports.
            • 3. Re: AWR
              636520
              I thought awr report is inbuilt with oracle binaries and it is free.
              • 4. Re: AWR
                Charles Hooper
                user633517 wrote:
                Hi,

                As awr is enabled when oracle is installed with database creation.And id I don't purchase daigonistic pack and if I use it like for awr reports,how does oracle corp. will come to know that i am using awr reports.
                I thought awr report is inbuilt with oracle binaries and it is free.
                You will find that a lot of extra cost features are built-in and are NOT free - partitioning is one such extra cost option. As the DBA (or owner) of that database, it is your responsibility to turn off what was not purchased and not use what was not purchased.

                How will Oracle Corp. find out if you are using AWR reports or other extra cost options? A simple query will answer the question, if your database is audited by Oracle Corp.:
                SELECT
                  NAME,
                  VERSION,
                  DETECTED_USAGES,
                  TOTAL_SAMPLES,
                  CURRENTLY_USED,
                  FIRST_USAGE_DATE,
                  LAST_USAGE_DATE,
                  LAST_SAMPLE_DATE
                FROM
                  DBA_FEATURE_USAGE_STATISTICS;
                The first time you log into Enterprise Manager Database Control as the SYSMAN user, you will be prompted to disable unlicensed items. Disabling the Diagnostic Pack license does not disable AWR logging - the data is still captured to the various tables. But you cannot legally query these tables without a Diagnostic Pack license - just querying the tables or views based on those tables could/will update the corresponding row in the DBA_FEATURE_USAGE_STATISTICS view.

                The above is one of the things that various books and the Oracle documentation simply gloss over when describing how AWR reports are the replacement for Statspack reports.

                Charles Hooper
                Co-author of "Expert Oracle Practices: Oracle Database Administration from the Oak Table"
                http://hoopercharles.wordpress.com/
                IT Manager/Oracle DBA
                K&M Machine-Fabricating, Inc.
                • 5. Re: AWR
                  User648012-Oracle
                  What shall customers do when they want to disable Diagnostic Pack and Tuning Pack because when they do not purchase licensees?
                  • 6. Re: AWR
                    Srini Chavali-Oracle
                    Pl post your database version.

                    For 11gR2 - see http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams037.htm
                    For 11gR1 - see http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams036.htm
                    For 10gR2 - see http://docs.oracle.com/cd/B19306_01/license.102/b40010/database_management.htm

                    HTH
                    Srini
                    • 7. Re: AWR
                      Aman....
                      He should be looking for Statspack . See the links that Srini has given.

                      Aman....