1 2 Previous Next 20 Replies Latest reply: May 21, 2013 3:51 AM by user522961 Go to original post RSS
      • 15. Re: license for AWR
        TSharma-Oracle
        It seems your snapshot interval is 1 day not 1 hour. It could also be possible that your retention period is also 1 day. In that case, you will not see any counts in dba_hist _snapshot.

        Please post the output of the following to check the retention of your awr reports:

        select * from dba_hist_wr_control;

        Also I was not expecting flush_elapsed output in this format.
        • 16. Re: license for AWR
          user522961
          Thank you TSharma.

          Here is the query :
          SQL> select * from dba_hist_wr_control;
          
                DBID SNAP_INTERVAL             RETENTION                 TOPNSQL
          ---------- ------------------------- ------------------------- ---------
           786803536 +00000 01:00:00.0         +00008 00:00:00.0         DEFAULT
           683557503 +00000 01:00:00.0         +00008 00:00:00.0         DEFAULT
          regards.
          • 17. Re: license for AWR
            TSharma-Oracle
            SQL> select * from dba_hist_wr_control;

            DBID SNAP_INTERVAL RETENTION TOPNSQL
            ---------- ------------------------- ------------------------- ---------
            786803536 +00000 01:00:00.0 +00008 00:00:00.0 DEFAULT
            683557503 +00000 01:00:00.0 +00008 00:00:00.0 DEFAULT
            >

            This is your problem. You are maintaining 2 DBID's in AWR tables. According to Oracle if you are maintaining 2 DBID's, report generation could be the problem. You can try recreating AWR repository y using following metalink note:
            How to Recreate The AWR ( AUTOMATIC WORKLOAD ) Repository ? [ID 782974.1]
            OR
            http://vivekbhutani.wordpress.com/2011/12/07/steps-to-recreate-awr-automatic-workload-repository/

            Alos, please make sure you mark this thread answered when your issue got resolved.
            • 18. Re: license for AWR
              user522961
              Thank you Tsharma.
              With the same rows on another database (twwo DBids) I can run AWR.

              On DB1 : I can run AWR :
              SQL> select * from dba_hist_wr_control;
              
                    DBID SNAP_INTERVAL             RETENTION                 TOPNSQL
              ---------- ------------------------- ------------------------- ---------
               786803536 +00000 01:00:00.0         +00008 00:00:00.0         DEFAULT
               683557503 +00000 01:00:00.0         +00008 00:00:00.0         DEFAULT
              On DB2 I can not run AWR (no snapshot in repository.
              SQL> select * from dba_hist_wr_control;
              
                    DBID SNAP_INTERVAL             RETENTION                 TOPNSQL
              ---------- ------------------------- ------------------------- ----------
               828353143 +00000 01:00:00.0         +00008 00:00:00.0         DEFAULT
              4138791354 +00000 01:00:00.0         +00008 00:00:00.0         DEFAULT
              Thanks and regards.
              • 19. Re: license for AWR
                TSharma-Oracle
                Did you try recreating your awr repository?
                • 20. Re: license for AWR
                  user522961
                  Thanks.
                  1 2 Previous Next