0 Replies Latest reply on Nov 27, 2012 5:31 PM by _Joao_

    ASH Rows Detail report bug

      This is just an excerpt from ASH Rows Detail report:

      to_char(s.begin_interval_time,'mm/dd')  day,
      +'Executions' serial,+
      SUM(sql.executions_delta)     value
      dba_hist_sqlstat        sql,
      dba_hist_snapshot         s
      s.snap_id = sql.snap_id
      AND SQL.sql_id=:SQL_ID
      GROUP BY to_char(s.begin_interval_time,'mm/dd'),sql_id;

      It's missing a predicate chunk:

      and s.instance_number = sql.instance_number

      Otherwise the number of executions will double

      SQLDeveloper version:
      Sorry my english