This discussion is archived
1 2 Previous Next 20 Replies Latest reply: May 21, 2013 1:51 AM by user522961 RSS

license for AWR

user522961 Newbie
Currently Being Moderated
Hi,
in 11g R2 on Win 2008,
AWR is installed by default. But it is not free to use it.
How to uninstall it ?
How to verify if it is uninstalled ?

Thank you.
  • 1. Re: license for AWR
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    You do not have to uninstall it. Just do not use it if you do not want to pay for it.

    Nicolas.
  • 2. Re: license for AWR
    Aman.... Oracle ACE
    Currently Being Moderated
    The AWR data is the snapshots that's collected automatically every 60 minutes by default. As long as you won't change the parameter Statistics_level, this behavior would remain but that's not what is licensed IMO. It's the scripts that make use of this data like awrrpt.sql etc. So if you don't want to pay for the cost of the license of using these scripts, simply don't fire them and use Statspack.

    Aman....
  • 3. Re: license for AWR
    user522961 Newbie
    Currently Being Moderated
    Ok, Thank you.

    Would you please explain me how can we have this :
    SQL> select count (*) from DBA_HIST_SNAPSHOT;
     
      COUNT(*)
    ----------
             0
     
    SQL> show parameter statistics_level
     
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ----------
    statistics_level                     string      TYPICAL
     
    Regards.
  • 4. Re: license for AWR
    sb92075 Guru
    Currently Being Moderated
    SQL> show parameter timed
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    timed_os_statistics                  integer     0
    timed_statistics                     boolean     TRUE
    SQL> 
  • 5. Re: license for AWR
    user522961 Newbie
    Currently Being Moderated
    thank you.
    Yes , We have also :
    SQL> show parameter timed
     
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    
    
    timed_statistics                     boolean     TRUE
    Regards.
  • 6. Re: license for AWR
    Aman.... Oracle ACE
    Currently Being Moderated
    user522961 wrote:
    Ok, Thank you.

    Would you please explain me how can we have this :
    SQL> select count (*) from DBA_HIST_SNAPSHOT;
    
    COUNT(*)
    ----------
    0
    
    SQL> show parameter statistics_level
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ----------
    statistics_level                     string      TYPICAL
    Regards.
    How can you have what, zero snapshots you mean? Quite possible that you may have disabled the snapshot collection?

    Aman....
  • 7. Re: license for AWR
    user522961 Newbie
    Currently Being Moderated
    thank.
    you may have disabled the snapshot collection
    How is it possible ?
    How to verify ?

    regards.
  • 8. Re: license for AWR
    TSharma-Oracle Guru
    Currently Being Moderated
    How is it possible ?
    How to verify ? >

    Post the result please of teh following queries:

    select systimestamp, most_recent_snap_time, snap_interval from wrm$_wr_control where dbid = (select dbid from v$database);
    select open_mode from v$database;

    select * from
    (select snap_id,
    instance_number,
    begin_interval_time,
    flush_elapsed,
    status,
    error_count,
    snap_flag
    from wrm$_snapshot
    where dbid = (select dbid from v$database)
    order by snap_id desc)
    where rownum <= 10
    order by snap_id;

    Edited by: TSharma on Mar 18, 2013 11:37 AM
  • 9. Re: license for AWR
    Dom Brooks Guru
    Currently Being Moderated
    See [url http://docs.oracle.com/cd/E14072_01/server.112/e10820/initparams036.htm]control_management_pack_access
    http://docs.oracle.com/cd/E11882_01/license.112/e10594/options.htm#DBLIC165
  • 10. Re: license for AWR
    jgarry Guru
    Currently Being Moderated
    In case it isn't clear, Oracle uses some of AWR for its internal use. So you don't really uninstall it, you just remove access to it, and possibly stop some optional data collection.
  • 11. Re: license for AWR
    user522961 Newbie
    Currently Being Moderated
    Thanks to all.

    Jgarry,
    just remove access to it, and possibly stop some optional data collection
    How to do ?

    My problem is that since one week I have no more snapshot and then no AWR report.I do not know why ? I had it before.
    SQL> show parameter control_management
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    control_management_pack_access       string      DIAGNOSTIC+TUNING
    SQL> select count(*) from dba_hist_snapshot;
    
      COUNT(*)
    ----------
             0
    
    
    
    Specify the number of days of snapshots to choose from
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Entering the number of days (n) will result in the most recent
    (n) days of snapshots being listed.  Pressing <return> without
    specifying a number lists all completed snapshots.
    
    
    Entrez une valeur pour num_days : 1
    
    Listing the last day's Completed Snapshots
    
    
    Specify the Begin and End Snapshot Ids
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  • 12. Re: license for AWR
    Aman.... Oracle ACE
    Currently Being Moderated
    Well, I would try to create a manual snapshot, just to confirm that things are working. So did you try to do so?

    Aman....
  • 13. Re: license for AWR
    TSharma-Oracle Guru
    Currently Being Moderated
    Post the results of following:
    select systimestamp, most_recent_snap_time, snap_interval from wrm$_wr_control where dbid = (select dbid from v$database);
    select open_mode from v$database;

    select * from
    (select snap_id,
    instance_number,
    begin_interval_time,
    flush_elapsed,
    status,
    error_count,
    snap_flag
    from wrm$_snapshot
    where dbid = (select dbid from v$database)
    order by snap_id desc)
    where rownum <= 10
    order by snap_id;
  • 14. Re: license for AWR
    user522961 Newbie
    Currently Being Moderated
    Thanks to all.

    Here are what Tsharma and Aman asked.
    SQL> select systimestamp, most_recent_snap_time, snap_interval from wrm$_wr_control where dbid = (select dbid from v$database);
    
    SYSTIMESTAMP                   MOST_RECENT_SNAP_TIM SNAP_INTERVAL
    ------------------------------ -------------------- ---------------------------------------------------------------------------
    20/03/13 09:18:59,234000 +01:0 19/03/13 15:31:38,62 +00000 01:00:00.0
    0                              9
    select open_mode from v$database;
    
    OPEN_MODE
    --------------------
    READ WRITE
    
    select * from 
    (select snap_id, 
    instance_number, 
    begin_interval_time, 
    flush_elapsed, 
    status, 
    error_count, 
    snap_flag 
    from wrm$_snapshot 
    where dbid = (select dbid from v$database) 
    order by snap_id desc) 
    where rownum <= 10 
    order by snap_id; 
    FLUSH_ELAPSED                                                                   STATUS ERROR_COUNT  SNAP_FLAG
    --------------------------------------------------------------------------- ---------- ----------- ----------
            65               1 11/03/13 15:33:04,579
                                                                                         1           0          0
    
            66               1 12/03/13 15:30:56,780
                                                                                         1           0          1
    
            67               1 12/03/13 16:17:17,771
                                                                                         1           0          0
    
            68               1 13/03/13 15:27:39,490
                                                                                         1           0          0
    
            69               1 14/03/13 15:35:16,113
                                                                                         1           0          0
    
            70               1 15/03/13 15:32:18,998
                                                                                         1           0          0
    
            71               1 16/03/13 15:30:22,465
                                                                                         1           0          0
    
            72               1 17/03/13 15:30:52,550
                                                                                         1           0          0
    
            73               1 18/03/13 15:33:03,305
                                                                                         1           0          0
    When I run the following it hangs :
     
    
    DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();
    it took 8 hours with event : " control file sequential read" but finally succeded.
    Regards.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points